Details
-
Bug
-
Resolution: Fixed
-
Major
-
feature-backlog
-
Untriaged
-
Unknown
Description
Left join asterix query:
SELECT VALUE t_3 FROM multiple_table_db_80_simple_table_1_shadow t_3 LEFT JOIN multiple_table_db_80_simple_table_2_shadow t_1 ON ( t_3.primary_key_id = t_1.primary_key_id ) WHERE (t_1.primary_key_id IS NULL) AND ((NOT (NOT (NOT ((t_3.int_field1 IN ( 2 , 22 , 30 , 70 , 79 )) AND (t_1.int_field1 < 5037)))) OR t_3.primary_key_id LIKE '%549%')) OR ((t_1.int_field1 >= 5037) AND (t_1.decimal_field1 != 5067)) AND (t_3.decimal_field1 BETWEEN 0 and 9991) ORDER BY t_3.int_field1 , t_3.primary_key_id , t_3.varchar_field1 , t_1.bool_field1 ;
Syntax error:
"msg": "Syntax error: In line 1 >>SELECT VALUE t_3 FROM multiple_table_db_80_simple_table_1_shadow t_3 LEFT JOIN multiple_table_db_80_simple_table_2_shadow t_1 ON ( t_3.primary_key_id = t_1.primary_key_id ) WHERE (t_1.primary_key_id IS NULL) AND ((NOT (NOT (NOT ((t_3.int_field1 IN ( 2 , 22 , 30 , 70 , 79 )) AND (t_1.int_field1 < 5037)))) OR t_3.primary_key_id LIKE '%549%')) OR ((t_1.int_field1 >= 5037) AND (t_1.decimal_field1 != 5067)) AND (t_3.decimal_field1 BETWEEN 0 and 9991) ORDER BY t_3.int_field1 , t_3.primary_key_id , t_3.varchar_field1 , t_1.bool_field1 ;<< Encountered ',' \",\" at column 262. "
}],
Same query works in sql.