Export to GitHub

dremel - issue #9

LIMIT is not supported by the parser


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