Details
-
Bug
-
Resolution: Fixed
-
Major
-
6.5.0
-
Untriaged
-
MacOSX 64-bit
-
Yes
Description
I can run this query successful
Q1:
select count (*), (distinct `Primary Type`)
|
from `crime`
|
group by `Primary Type`
|
ORDER BY count(*)
|
|
when I run any query with field Primary Type in where clause I get,
Q2:
select count (*)
|
from `crime`
|
where `Primary Type`="NARCOTICS" |
[
|
|
{ "code": 5000, "msg": "n1fty: refresh failed - cause: syntax error - at Primary", "query": "select count (*)\nfrom `crime` \nwhere `Primary Type`=\"NARCOTICS\"" } |
|
]
|
|
If I drop my FTS index the query works.
The crime bucket contains 1 million records, although the size of bucket shouldn't matter.
FTS screen shot attached.
Attachments
For Gerrit Dashboard: MB-38201 | ||||||
---|---|---|---|---|---|---|
# | Subject | Branch | Project | Status | CR | V |
123340,3 | MB-38201: Enclose typeField of FTS index with backticks | master | n1fty | Status: MERGED | +2 | +1 |
123398,2 | [BP] MB-38201: Enclose typeField of FTS index with backticks | mad-hatter | n1fty | Status: MERGED | +2 | +1 |
123400,1 | Merge remote-tracking branch 'origin/mad-hatter' into 'master' | master | n1fty | Status: MERGED | +2 | +1 |