Details
-
Bug
-
Resolution: Fixed
-
Major
-
4.5.1, 4.6.2, 5.0.0
-
Untriaged
-
Unknown
Description
Index created:
create index ix on default where y like "abc%\";
Query issued:
select x,y from default where x > 20 and y like "abc%\";
Result:
{
"requestID": "fae254e1-b9c3-4517-b294-65af6cf1725c",
"clientContextID": "a62e41b8-eff0-4343-825f-dd0d3a50fba7",
"signature":
,
"results": [
],
"status": "success",
"metrics":
}
Document contents:
{ "x": 21, "y": "abctest" }select * from system:indexes shows index created as:
{
"indexes":
},
*Note that the index created is showing condition as empty "condition": "(`y` like \"\")" *
For same document, the below query gives correct results:
select x,y from default where x > 20 and y like \"abc%"
;
create index ix100 on default where y like "abc%";
Are the backward slashes ignored in query?
|