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.