Query filter for string value must be enclosed in double quotes
Article ID: KB0080506
Updated On:
| Products | Versions |
|---|---|
| TIBCO ActiveSpaces | - |
Description
For example, field salary is string type, we have queries as below:
1. salary=1000
2. salary=‘1000’
3. salary=“1000”
Both of above might return same result, but only #3 is the correct usage and this is restrict requirement, the reason being:
+++++
For #1, we will consider salary as long type and this query won’t take any index, so always a table scan.
For #2, it works in most case, but when value has only one character, e.g. salary=‘4’, we consider it is a char type and trigger a table scan, also query will return empty result.
Hence, for query filter which has a string field, value must be enclosed in double quotes.
1. salary=1000
2. salary=‘1000’
3. salary=“1000”
Both of above might return same result, but only #3 is the correct usage and this is restrict requirement, the reason being:
+++++
For #1, we will consider salary as long type and this query won’t take any index, so always a table scan.
For #2, it works in most case, but when value has only one character, e.g. salary=‘4’, we consider it is a char type and trigger a table scan, also query will return empty result.
Hence, for query filter which has a string field, value must be enclosed in double quotes.
Issue/Introduction
Query filter for string value must be enclosed in double quotes
Environment
ALL
Additional Information
query filter single quote double string
Feedback
Yes
No
Powered by
