StrictComparison
Adjusts how precisely to translate filters on SQL input queries into Couchbase queries. This can be set to a comma-separated list of values, where each value can be one of: date, number, boolean, or string.
Data Type
string
Default Value
""
Remarks
This option is empty by default, which means that WHERE clauses sent to Couchbase will include extra functions that convert values so that more comparisons work.
For example, leaving the "string" setting out of the list causes arrays to be
converted, so that they can be compared with strings:
SELECT * FROM Bucket WHERE MyArrayColumn = '[1,2,3]'
If set to a value, queries including the relevant types of comparisons will be translated literally. This makes better use of Couchbase's indexes, but means that the types of comparisons must be in a format Couchbase can compare directly.
For example, if "date" is provided as one of the options, then dates must match
the format they are stored as in Couchbase since they will not be converted
automatically:
SELECT * FROM Bucket WHERE MyDateColumn = '2018-10-31T10:00:00';