Details
-
Bug
-
Resolution: Fixed
-
Major
-
5.5.0
-
5.5.0-1708
-
Untriaged
-
No
-
CX Sprint 88, CX Sprint 89
Description
Query Executed:
SELECT SUM(DISTINCT decimal_field1 ) FROM multiple_table_db_1433277_simple_table_1_shadow WHERE NOT ((char_field1 != "N" AND decimal_field1 IS NOT NULL)) ORDER BY AVG( DISTINCT int_field1 );
|
Error Received:
[
|
{
|
"code": 1,
|
"msg": "Could not infer type for variable '$$55'.",
|
"query_from_user": "SELECT SUM(DISTINCT decimal_field1 ) FROM multiple_table_db_1433277_simple_table_1_shadow WHERE NOT ((char_field1 != \"N\" AND decimal_field1 IS NOT NULL)) ORDER BY AVG( DISTINCT int_field1 );"
|
}
|
]
|
Doc in the shadow dataset:
[
|
{
|
"multiple_table_db_1433277_simple_table_1_shadow": {
|
"bool_field1": true,
|
"char_field1": "N",
|
"datetime_field1": "2009-06-28 00:00:00",
|
"decimal_field1": 6595,
|
"int_field1": 8403265,
|
"primary_key_id": "1",
|
"varchar_field1": "lBQbhsBKIl"
|
}
|
}
|
]
|