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

Minor regression in SphinxQL documentId alias #22

Open
GoogleCodeExporter opened this issue Mar 16, 2015 · 0 comments
Open

Minor regression in SphinxQL documentId alias #22

GoogleCodeExporter opened this issue Mar 16, 2015 · 0 comments

Comments

@GoogleCodeExporter
Copy link

What steps will reproduce the problem?

  SELECT id AS id FROM my_index

Other variants w/o AS, with backquoted alias, alias in different case result in 
the same error. However if alias is different from case-insensitive "id" the 
query works.

What is the expected output? What do you see instead?

  ERROR 1064 (42000): sphinxql: syntax error, unexpected ID, expecting IDENT near 'id from my_index'

What version of the product are you using? On what operating system?

"2.0.4-1.1ubuntu1 (raring)" worked correctly. Current stable 
"2.1.3-release-1~wheezy" has the regression. The bug can be related to 
http://sphinxsearch.com/bugs/view.php?id=1264.

Also note that such alias can make no sense for hand-written queries it can be 
produces by a SQL generation utility.



Original issue reported on code.google.com by i...@saaj.me on 15 Nov 2013 at 3:23

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

1 participant