Using recovery tools doesn't take any effect.
Column GUID isn't PK. I have index on this column. After droping this
index, my select work correctly, but i cannot create index on field
GUID again, because h2 throws error:
General error: "java.lang.RuntimeException: rowcount remaining=79
CG_BARCODE"; SQL statement:
CREATE INDEX INDEX_BARCODE_GUID ON CG_BARCODE (GUID) [50000-141]
at org.h2.message.DbException.getJdbcSQLException(DbException.java:
327)
at org.h2.message.DbException.get(DbException.java:156)
at org.h2.message.DbException.convert(DbException.java:279)
at org.h2.command.Command.executeUpdate(Command.java:219)
at org.h2.jdbc.JdbcStatement.executeInternal(JdbcStatement.java:
176)
at org.h2.jdbc.JdbcStatement.execute(JdbcStatement.java:151)
at org.h2.server.web.WebApp.getResult(WebApp.java:1316)
at org.h2.server.web.WebApp.query(WebApp.java:1004)
at org.h2.server.web.WebApp$1.next(WebApp.java:967)
at org.h2.server.web.WebApp$1.next(WebApp.java:970)
at org.h2.server.web.WebThread.process(WebThread.java:161)
at org.h2.server.web.WebThread.run(WebThread.java:88)
at java.lang.Thread.run(Unknown Source)
Caused by: java.lang.RuntimeException: rowcount remaining=79
CG_BARCODE
at org.h2.message.DbException.throwInternalError(DbException.java:
226)
at org.h2.table.RegularTable.addIndex(RegularTable.java:243)
at org.h2.command.ddl.CreateIndex.update(CreateIndex.java:89)
at org.h2.command.CommandContainer.update(CommandContainer.java:
70)
at org.h2.command.Command.executeUpdate(Command.java:199)
... 9 more
On 25 авг, 18:11, stolyarchukav <[email protected]> wrote:
> Hi,
> I have a problem with select data.
>
> Select:
> SELECT ID, GUID FROM CG_BARCODE where guid = 941088;
>
> Result:
> ID GUID
> 21801 941068
>
> As you see, GUID in select different with GUID in result
>
> Type of GUID filed is BIGINT(19) NOT NULL
>
> Thanks
--
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.
