I have a DB created with older version 1.4.96 and we've upgraded to 1.4.99. When altering a table to drop a column, it cause table to be renamed, to something like <table>_COPY_##_## where ## is a number. Once this happens, it get DB to a corrupted state and it is no longer usable. Is this a known issue? Is there a workaround?
org.h2.jdbc.JdbcSQLSyntaxErrorException: Table "DEPLOYMENT_SPEC" not found; SQL statement: ALTER TABLE deployment_spec DROP COLUMN vlan_pool_fk [42102-199] at org.h2.message.DbException.getJdbcSQLException(DbException.java:451) ~[factory.jar:sxrel2.0] at org.h2.message.DbException.getJdbcSQLException(DbException.java:427) ~[factory.jar:sxrel2.0] at org.h2.message.DbException.get(DbException.java:205) ~[factory.jar:sxrel2.0] at org.h2.message.DbException.get(DbException.java:181) ~[factory.jar:sxrel2.0] at org.h2.command.Parser.tableIfTableExists(Parser.java:7497) ~[factory.jar:sxrel2.0] at org.h2.command.Parser.parseAlterTable(Parser.java:7307) ~[factory.jar:sxrel2.0] at org.h2.command.Parser.parseAlter(Parser.java:6546) ~[factory.jar:sxrel2.0] at org.h2.command.Parser.parsePrepared(Parser.java:828) ~[factory.jar:sxrel2.0] at org.h2.command.Parser.parse(Parser.java:788) ~[factory.jar:sxrel2.0] at org.h2.command.Parser.parse(Parser.java:760) ~[factory.jar:sxrel2.0] at org.h2.command.CommandContainer.recompileIfRequired(CommandContainer.java:108) ~[factory.jar:sxrel2.0] at org.h2.command.CommandContainer.update(CommandContainer.java:128) ~[factory.jar:sxrel2.0] at org.h2.command.Command.executeUpdate(Command.java:267) ~[factory.jar:sxrel2.0] at org.h2.jdbc.JdbcStatement.executeInternal(JdbcStatement.java:233) ~[factory.jar:sxrel2.0] at org.h2.jdbc.JdbcStatement.execute(JdbcStatement.java:205) ~[factory.jar:sxrel2.0] -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to h2-database+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/h2-database/f4a9a286-5773-4034-a3d3-3cbd8feb6e92%40googlegroups.com.
