Details
-
Bug
-
Resolution: Fixed
-
Critical
-
spock-beta1
-
None
Description
Hi Guy,
The example queries Q1/Q2/Q3 should have additional predicate (type = "airport") to match those indexes. Pls fix asap.
{{Q1: SELECT * FROM `travel-sample` WHERE airportname LIKE "San Francisco%" AND type = "airport" ; }}
{{Q2: SELECT * FROM `travel-sample` WHERE city = "San Francisco" AND type = "airport" ; }}
Q3: SELECT * FROM `travel-sample` WHERE faa = "SFO" AND type = "airport" ;
thanks,
-Prasad