Details
Description
Queries in this section don't match data in the `travel-sample` bucket. Example - SELECT meta().id
FROM `travel-sample` USE INDEX (USING FTS)
WHERE type = "hotel" AND country = "UNITED STATES" OR country = "CANADA";
This returns no result. Data in bucket have pattern "United States" and "Canada"
Should be SELECT meta().id
FROM `travel-sample` USE INDEX (USING FTS)
WHERE type = "hotel" AND UPPER(country) = "UNITED STATES" OR upper(country) = "CANADA";
or
SELECT meta().id
FROM `travel-sample` USE INDEX (USING FTS)
WHERE type = "hotel" AND country = "United States" OR country = "Canada";
The second example is more performant
Reporter: Tim Wong
E-mail: tim.wong@couchbase.com