Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Error message with select ... indexed by #2996

Closed
pgulutzan opened this issue Dec 13, 2017 · 0 comments
Closed

Error message with select ... indexed by #2996

pgulutzan opened this issue Dec 13, 2017 · 0 comments
Assignees
Labels
Milestone

Comments

@pgulutzan
Copy link
Contributor

I have Ubuntu 14.04 and Tarantool 1.8, pulled from source today.
I use an example which was shown when Issue#2134 was closed.
box.sql.execute("CREATE TABLE a (id PRIMARY KEY, a INTEGER);");
box.sql.execute("CREATE INDEX i on a(a);");
box.sql.execute("INSERT INTO a VALUES (1,2), (3,4), (5,6);");
box.sql.execute("EXPLAIN SELECT id FROM a INDEXED BY i");
Result: - error: keyword "BY" is reserved
There is no error with delete ... indexed by.

@pgulutzan pgulutzan added the sql label Dec 13, 2017
@kostja kostja added this to the 1.8.5 milestone Jan 9, 2018
TheAviat0r added a commit that referenced this issue Feb 12, 2018
Remove unnecessary OP_SCopy opcodes from listings being generated
for INSERT/UPDATE operations, add it to VDBE listing only in
case of presence of UNIQUE bytecode.

Closes #2996
TheAviat0r added a commit that referenced this issue Feb 22, 2018
Renerate parse.y after fixing bug with non-working 'INDEXED BY' clause
in SELECT statement.

For #2996
TheAviat0r added a commit that referenced this issue Feb 22, 2018
Fix non-working 'INDEXED BY' clause for SELECT statement,
which caused syntax-error during execution.

Closes #2996
TheAviat0r added a commit that referenced this issue Feb 22, 2018
Renerate parse.y after fixing bug with non-working 'INDEXED BY' clause
in SELECT statement.

For #2996
TheAviat0r added a commit that referenced this issue Feb 22, 2018
Fix non-working 'INDEXED BY' clause for SELECT statement,
which caused syntax-error during execution.

Closes #2996
TheAviat0r added a commit that referenced this issue Feb 22, 2018
Renerate parse.y after fixing bug with non-working 'INDEXED BY' clause
in SELECT statement.

For #2996
TheAviat0r added a commit that referenced this issue Mar 5, 2018
Fix non-working 'INDEXED BY' clause for SELECT statement,
which caused syntax-error during execution.

Closes #2996
TheAviat0r added a commit that referenced this issue Mar 5, 2018
Renerate parse.y after fixing bug with non-working 'INDEXED BY' clause
in SELECT statement.

For #2996
TheAviat0r added a commit that referenced this issue Mar 10, 2018
Fix non-working 'INDEXED BY' clause for SELECT statement,
which caused syntax-error during execution.

Closes #2996
TheAviat0r added a commit that referenced this issue Mar 10, 2018
Fix non-working 'INDEXED BY' clause for SELECT statement,
which caused syntax-error during execution.

Closes #2996
TheAviat0r added a commit that referenced this issue Mar 12, 2018
Fix non-working 'INDEXED BY' clause for SELECT statement,
which caused syntax-error during execution.

Closes #2996
TheAviat0r added a commit that referenced this issue Mar 12, 2018
Fix non-working 'INDEXED BY' clause for SELECT statement,
which caused syntax-error during execution.

Closes #2996
TheAviat0r added a commit that referenced this issue Mar 12, 2018
Fix non-working 'INDEXED BY' clause for SELECT statement,
which caused syntax-error during execution.

Closes #2996
TheAviat0r added a commit that referenced this issue Mar 13, 2018
Fix non-working 'INDEXED BY' clause for SELECT statement,
which caused syntax-error during execution.

Closes #2996
TheAviat0r added a commit that referenced this issue Mar 27, 2018
Fix non-working 'INDEXED BY' clause for SELECT statement,
which caused syntax-error during execution.

Closes #2996
TheAviat0r added a commit that referenced this issue Mar 29, 2018
Fix non-working 'INDEXED BY' clause for SELECT statement,
which caused syntax-error during execution.

Closes #2996
TheAviat0r added a commit that referenced this issue Mar 29, 2018
Fix non-working 'INDEXED BY' clause for SELECT statement,
which caused syntax-error during execution.

Closes #2996
@kyukhin kyukhin closed this as completed in e453770 Apr 5, 2018
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Projects
None yet
Development

No branches or pull requests

3 participants