View Issue Details

IDProjectCategoryView StatusLast Update
0000148SymmetricDSBugpublic2010-01-08 11:51
ReporterAssigned Tochenson  
Status closedResolutionfixed 
Product Version1.7.4 
Summary0000148: Unable to drop an index when updating scheme on H2
DescriptionWe use DdlUtils to upgrade our schema in runtime. Database is H2. DdlUtils builds invalid SQL to alter schema using Symmetric's H2Builder class when some indecies are removed. org.h2.jdbc.JdbcSQLException: Syntax error in SQL statement DROP INDEX PK_BLOB_BINARY ON[*] BLOB_BINARY; SQL statement: DROP INDEX PK_BLOB_BINARY ON BLOB_BINARY [42000-115] Index names in H2 are unique to a schema and hence H2 does not use the ON <tablename> clause. It is NOT issue for SymmetricDS at the moment but can be in the future.
TagsNo tags attached.


There are no notes attached to this issue.

Issue History

Date Modified Username Field Change