Add support for "ALTER TABLE MODIFY COLUMN ..." requests
--------------------------------------------------------
Key: SEQUOIA-866
URL: https://forge.continuent.org/jira/browse/SEQUOIA-866
Project: Sequoia
Type: Improvement
Components: Core
Versions: Sequoia 3.0 beta1, Sequoia 2.10.2
Environment: MySQL 4.10
Reporter: Emmanuel Cecchet
Assigned to: Emmanuel Cecchet
Fix For: Sequoia 3.0 beta 2
Reported by Waseem Taj <[EMAIL PROTECTED]> on the Sequoia mailing list:
We are currently assessing the feasibilty of using Sequoia for load balancing
and failover. We are using Sequoia 2.10.2 and MySQL 4.10 database . Using
MySQL driver, I can run the sql statement "ALTER TABLE MODIFY COLUMN ......",
however same statement fails using Sequoia driver with the following error:
Caused by: org.continuent.sequoia.common.exceptions.driver.DriverSQLException:
Message of cause: Malformed Alter Request. No drop or add condition
at
org.continuent.sequoia.driver.Connection.statementExecute(Connection.java:3012)
at org.continuent.sequoia.driver.Statement.execute(Statement.java:424)
at
org.continuent.sequoia.driver.PreparedStatement.execute(PreparedStatement.java:901)
at
org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:168)
at
com.youdevise.ids.persist.FullAccessPersistenceManager.update(FullAccessPersistenceManager.java:829)
... 17 more
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
https://forge.continuent.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira
_______________________________________________
Sequoia mailing list
[email protected]
https://forge.continuent.org/mailman/listinfo/sequoia
