Posted on Jan 16, 2011 by
Massive Elephant
The BQL SELECT COUNT(*), word FROM [Table] WHERE word CONTAINS 'th' GROUP_BY word LIMIT 5;
is parsed into AST:
(N_SELECT_STATEMENT (N_FROM (N_TABLE_NAME [Table])) (N_SELECT (N_CREATE_COLUMN (N_EXPRESSION (N_CALL_PARAMS (N_EXPRESSION (N_COLUMN (N_COLUMN_NAME *))) (N_COLUMN (N_COLUMN_NAME COUNT))))) (N_CREATE_COLUMN (N_EXPRESSION (N_COLUMN (N_COLUMN_NAME word))))) (N_WHERE (N_EXPRESSION (N_CONTAINS (N_COLUMN (N_COLUMN_NAME word)) (N_STRING 'th')))))
And LIMIT is never mentioned
Status: Accepted
Labels:
Type-Defect
Priority-Medium