cassandra-migration icon indicating copy to clipboard operation
cassandra-migration copied to clipboard

SQL error with cassandra 3.7

Open martinscheffler opened this issue 7 years ago • 2 comments

In SchemaVersionDAO.java, line 205, " SET count = count + 1" + "WHERE name = 'installed_rank';");

there is a missing whitespace between "1" and "WHERE". This starts to cause exceptions from cassandra 3.7 on, no idea why it was accepted before

martinscheffler avatar Apr 27 '17 06:04 martinscheffler

I have exactly the same issue with cassandra 3.10 : Caused by: com.datastax.driver.core.exceptions.SyntaxError: line 1:86 no viable alternative at input 'HERE' (... count = count + 1W[HERE]...) at com.datastax.driver.core.exceptions.SyntaxError.copy(SyntaxError.java:58) at com.datastax.driver.core.exceptions.SyntaxError.copy(SyntaxError.java:24) at com.datastax.driver.core.DriverThrowables.propagateCause(DriverThrowables.java:37) at com.datastax.driver.core.DefaultResultSetFuture.getUninterruptibly(DefaultResultSetFuture.java:245) at com.datastax.driver.core.AbstractSession.execute(AbstractSession.java:68) at com.contrastsecurity.cassandra.migration.dao.SchemaVersionDAO.calculateInstalledRank(SchemaVersionDAO.java:207) at com.contrastsecurity.cassandra.migration.dao.SchemaVersionDAO.addAppliedMigration(SchemaVersionDAO.java:135) at com.contrastsecurity.cassandra.migration.action.Migrate.applyMigration(Migrate.java:126) at com.contrastsecurity.cassandra.migration.action.Migrate.run(Migrate.java:83) at com.contrastsecurity.cassandra.migration.CassandraMigration$1.execute(CassandraMigration.java:77) at com.contrastsecurity.cassandra.migration.CassandraMigration$1.execute(CassandraMigration.java:68) at com.contrastsecurity.cassandra.migration.CassandraMigration.execute(CassandraMigration.java:174) at com.contrastsecurity.cassandra.migration.CassandraMigration.migrate(CassandraMigration.java:68)

alexis-morillo avatar May 17 '17 09:05 alexis-morillo

+1

luiseduardomiranda avatar Jun 07 '17 22:06 luiseduardomiranda