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

Missing Query and QueryRow for SphinxQL #3

Open
raichu opened this issue Jul 4, 2013 · 1 comment
Open

Missing Query and QueryRow for SphinxQL #3

raichu opened this issue Jul 4, 2013 · 1 comment

Comments

@raichu
Copy link

raichu commented Jul 4, 2013

Will there be a way of SELECTing rows via SphinxQL?

@yunge
Copy link
Owner

yunge commented Jul 5, 2013

Sphinx server only support a subset of MySql command
enum
{
MYSQL_COM_QUIT = 1,
MYSQL_COM_INIT_DB = 2,
MYSQL_COM_QUERY = 3,
MYSQL_COM_PING = 14,
MYSQL_COM_SET_OPTION = 27
};
(sphinx-2.1.1-beta/src/searchd.cpp)

So it doesn't support MYSQL_COM_STMT_PREPARE, but
database/sql.DB.Query() always
call Prepare() to get a Stmt object, that would cause "unknown command"
error from Sphinx server.

There is a lib should solve this problem:
https://github.com/go-sql-driver/sphinxql, but unfortunately it has some
problem, I can't use it in "sphinx" lib. So for now, you can only use
sphinx api to do SELECT operations, thanks.

On Thu, Jul 4, 2013 at 1:58 PM, raichu [email protected] wrote:

Will there be a way of SELECTing rows via SphinxQL?


Reply to this email directly or view it on GitHubhttps://github.com//issues/3
.

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

No branches or pull requests

2 participants