Details
-
Bug
-
Resolution: Unresolved
-
Major
-
5.5.0
-
Untriaged
-
Centos 64-bit
-
Unknown
Description
When trying to pushdown a query, the indexer doesn't handle +inf values and maybe also -inf values.
Query:
SELECT SUM(EXP(decimal_field1) )
FROM simple_table_db_74549072_simple_table
WHERE decimal_field1 < 4987 and decimal_field1 > 4512
GROUP BY int_field1
Index:
CREATE INDEX simple_table_aggregate_pushdown_index_30464775
ON simple_table_db_74549072_simple_table( decimal_field1 , EXP( decimal_field1 ) + 2 , RADIANS( decimal_field1 ) - 2 , FLOOR( decimal_field1 ) - 2 , int_field1 ) USING GSI
Error:
[
{
"code": 5000,
"msg": " json: unsupported value: +Inf from [127.0.0.1:9101] - cause: json: unsupported value: +Inf from [127.0.0.1:9101]",
"query_from_user": "SELECT SUM(EXP(decimal_field1) )\nFROM simple_table_db_74549072_simple_table \nWHERE decimal_field1 < 4987 and decimal_field1 > 4512\nGROUP BY int_field1"
}
]
I have attached backups
./cbbackupmgr config --archive /opt/couchbase/bin/backup --repo temp
./cbbackupmgr backup --archive /opt/couchbase/bin/backup --repo temp --host couchbase://192.168.10.10 --username Administrator --password password