Hi,
The below test case throws exception:
Unique index or primary key violation: CONSTRAINT_INDEX_9 ON
FT.INDEXES(SCHEMA, TABLE) [23001-102]
I guess, it's a bug?
The code:
conn = DriverManager.getConnection("jdbc:h2:mem:a");
FullText.init(conn);
Statement stmt = conn.createStatement();
// Create table with a record
stmt.executeUpdate("create table test (id identity)");
FullText.createIndex(conn, "PUBLIC", "TEST", null);
stmt.executeUpdate("insert into test values (0)");
// Drop the table
FullText.dropIndex(conn, "PUBLIC", "test");
stmt.executeUpdate("drop table test");
// Recreate table with the same record
stmt.executeUpdate("create table test (id identity)");
FullText.createIndex(conn, "PUBLIC", "TEST", null);
stmt.executeUpdate("insert into test values (0)");
stmt.close();
conn.close();
Best regards,
Jacek
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
