Details
Description
load travel-sample
run:
SELECT id, airlineid, airline FROM `travel-sample` t WHERE (ANY s IN t.schedule SATISFIES s.day like "3%" END) AND `type` = "route" ORDER BY id, airlineid, airline
|
This query is allowed to run even though the day field is of type int. It will return no results since day is an int field.
The same query on analytics returns this error:
SELECT id, airlineid, airline FROM `travel-sample` t WHERE (ANY s IN t.schedule SATISFIES s.day like '3%' END) AND `type` = "route" ORDER BY id, airlineid, airline
|
[
|
|
{ "code": 24011, "msg": "Type mismatch: function like expects its 1st input parameter to be of type string, but the actual input type is bigint (in line 1, at column 97)", "query_from_user": "SELECT id, airlineid, airline FROM `travel-sample` t WHERE (ANY s IN t.schedule SATISFIES s.day like '3%' END) AND `type` = \"route\" ORDER BY id, airlineid, airline" }
|
|
]
|
The documentation for like states:
Match string with a wildcard expression. Use % for zero or more wildcards and _ to match any character at this place in a string.
Attachments
Issue Links
- links to