Hi All!
I'm having an error when i try to execute a query using my sql client.
I'll try to explain what i did:
LD_PRELOAD=/usr/local/lib/libmysequoia.so mysql -h "DB1 DB2" -u root
-pPASS VirtualDatabase
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 0 to server version: 5.0.22
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> select * from table;
ERROR 2014 (HY000): Commands out of sync; you can't run this command now
Although if you press tab in mysql client to list the tables in database
it works, but you can't do any kind of query.
Why is this happening? Why error "commands out of sync" only when we use
libmysequoia. I undertand the error in Mysql (although it doesn't
produced if i try directly without preloading libmysequoia, so I suppose
is not a MySQL bug), but what happen internally in Carob to receive such
error?. I ask this because if i try to execute the same query in the
execute of mysql, there is no problem.
LD_PRELOAD=/usr/local/lib/libmysequoia.so mysql -h "DB1 DB2" -u root
-pPASS -e "select * from table;" VirtualDatabase
Also I have a php web application using mysqli function with php
compiled with mysqli support. First i make a mysql_connect and then a
select_db... but when i tried to execute this statement i recieve
exactly the same error.
I think that both cases must have some kind of relation.
$this->Link_ID=($GLOBALS["___mysqli_ston"] = mysqli_connect($Host,
$User, $Password));
if (!$this->Link_ID) {
$this->halt("pconnect($Host, $User, \$Password) failed.");
return 0;
}
if (!@((bool)mysqli_query($this->Link_ID, "USE $Database"))) {
$this->halt("cannot use database ".$this->Database);
return 0;
}
}
I think both cases have some kind of relationship.
_______________________________________________
Carob mailing list
[email protected]
https://forge.continuent.org/mailman/listinfo/carob
