hi all,
with the update to version 1.3.154, i've this error when alter column
with data on my db:
org.h2.jdbc.JdbcSQLException: Unique index or primary key violation:
"PRIMARY KEY ON """".PAGE_INDEX"; SQL statement:
ALTER TABLE TbBase ALTER COLUMN BasPerc62 DOUBLE [23505-154];
State=23505; ErrorCode=23505
at org.h2.message.DbException.getJdbcSQLException(DbException.java:
327)
at org.h2.message.DbException.get(DbException.java:167)
at org.h2.message.DbException.get(DbException.java:144)
at
org.h2.index.PageDataIndex.getNewDuplicateKeyException(PageDataIndex.java:
157)
at org.h2.index.PageDataIndex.add(PageDataIndex.java:135)
at org.h2.store.PageStore.addMeta(PageStore.java:1678)
at org.h2.index.PageDataIndex.<init>(PageDataIndex.java:75)
at org.h2.table.RegularTable.<init>(RegularTable.java:92)
at org.h2.schema.Schema.createTable(Schema.java:542)
at
org.h2.command.ddl.AlterTableAlterColumn.cloneTableStructure(AlterTableAlterColumn.java:
267)
at
org.h2.command.ddl.AlterTableAlterColumn.copyData(AlterTableAlterColumn.java:
180)
at
org.h2.command.ddl.AlterTableAlterColumn.update(AlterTableAlterColumn.java:
117)
at org.h2.command.CommandContainer.update(CommandContainer.java:69)
at org.h2.command.Command.executeUpdate(Command.java:212)
at org.h2.jdbc.JdbcStatement.executeUpdateInternal(JdbcStatement.java:
125)
at org.h2.jdbc.JdbcStatement.executeUpdate(JdbcStatement.java:110)
at
it.unosistemi.gestord.aggiornamenti.AggiornaTbBase.processAggiornaPreEis(AggiornaTbBase.java:
42)
at
it.unosistemi.gestord.aggiornamenti.AggiornaTbBase.doWork(AggiornaTbBase.java:
24)
at
it.unosistemi.gestord.aggiornamenti.AggiornaTbBase.<init>(AggiornaTbBase.java:
18)
at
it.unosistemi.gestord.jfc.GestioneOrdiniJFrame.processAggiornamento(GestioneOrdiniJFrame.java:
1649)
at
it.unosistemi.gestord.jfc.GestioneOrdiniJFrame.connEtoM4(GestioneOrdiniJFrame.java:
1010)
at
it.unosistemi.gestord.jfc.GestioneOrdiniJFrame.<init>(GestioneOrdiniJFrame.java:
264)
at
it.unosistemi.gestord.jfc.GestioneOrdiniJFrame.main(GestioneOrdiniJFrame.java:
522)
is it a bug?
other detail:
when i execute query on console, first time doesn't work but second
time it works.
thanks all.
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/h2-database?hl=en.
