El Tuesday 03 April 2007 18:59:00 Emmanuel Cecchet escribió:
> Actually when you leave the trailing ; Sequoia considers the request as
> an inline batch (as if you were trying to execute SELECT ... ; SELECT
> ... ; INSERT ... ; SELECT ... ; UPDATE ... ; ... in a single statement).
> And there is a bug in the way the inline batch handling code.
> This was probably related to
> https://forge.continuent.org/jira/browse/SEQUOIA-812 which is fixed in
> CVS HEAD. If you use the latest build (from
> https://forge.continuent.org/builds/sequoia/), this should be fixed.
Anyway it seems this bug affects only CREATE statements, INSERT and SELECT
work with semicolons without a glitch
jdbc:sequoia://sequoia/MySQL5 (wwwagent) > create table test3(id integer)
engine=innodb;
11:08:44,962 WARN controller.RequestManager.MySQL5 Failed to execute request
create table test3(id integer) engine=in... because of (null)
java.lang.ClassCastException
at
org.continuent.sequoia.controller.loadbalancer.raidb1.RAIDb1.callStoredProcedure(RAIDb1.java:849)
at
org.continuent.sequoia.controller.loadbalancer.raidb1.RAIDb1.statementExecute(RAIDb1.java:280)
at
org.continuent.sequoia.controller.requestmanager.RequestManager.loadBalanceStatementExecute(RequestManager.java:971)
at
org.continuent.sequoia.controller.requestmanager.RequestManager.statementExecute(RequestManager.java:766)
at
org.continuent.sequoia.controller.virtualdatabase.VirtualDatabase.statementExecute(VirtualDatabase.java:738)
at
org.continuent.sequoia.controller.virtualdatabase.VirtualDatabaseWorkerThread.statementExecute(VirtualDatabaseWorkerThread.java:2397)
at
org.continuent.sequoia.controller.virtualdatabase.VirtualDatabaseWorkerThread.run(VirtualDatabaseWorkerThread.java:507)
11:08:44,964 WARN controller.virtualdatabase.MySQL5 Stored procedure 3 failed
(Failed to execute request create table test3(id integer) engine=in...
because of (null))
An error occured while executing SQL query
(org.continuent.sequoia.common.exceptions.driver.DriverSQLException: Message
of cause: Failed to execute request create table test3(id integer)
engine=in... because of (null))
jdbc:sequoia://sequoia/MySQL5 (wwwagent) > show tables;
+--------+
| tables |
+--------+
| test |
| test2 |
+--------+
jdbc:sequoia://sequoia/MySQL5 (wwwagent) > create table test3(id integer)
engine=innodb
Affected rows: 0
Query executed in 0 s 8 ms .
jdbc:sequoia://sequoia/MySQL5 (wwwagent) > show tables;
+--------+
| tables |
+--------+
| test |
| test2 |
| test3 |
+--------+
jdbc:sequoia://sequoia/MySQL5 (wwwagent) > select * from test;
+-------------+
| i |
+-------------+
| 1 |
| 2 |
| 3 |
| 32 |
| 35 |
| 356 |
+-------------+
--
Davide Ferrari
_______________________________________________
Sequoia mailing list
[email protected]
https://forge.continuent.org/mailman/listinfo/sequoia
