Hi, Thanks for your help! I see the problem now. It is a bug in the FullText class, I will fix it.
Regards, Thomas On Wed, Feb 18, 2009 at 9:15 PM, Jacek <[email protected]> wrote: > > here is the snippet: > conn = DriverManager.getConnection("jdbc:h2:mem:test"); > stmt = conn.createStatement(); > stmt.executeUpdate("create table \"t\\\" (x int)"); > FullText.createIndex(conn, "PUBLIC", "t\\", null); > stmt.close(); > conn.close(); > > end stack trace: > > Exception in thread "main" org.h2.jdbc.JdbcSQLException: Error > creating or initializing trigger FT_t\ object, class > org.h2.fulltext.FullText$FullTextTrigger, cause: > org.h2.jdbc.JdbcSQLException: Blad w LIKE ESCAPE: t[*]\ > Error in LIKE ESCAPE: t[*]\; SQL statement: > SELECT TABLE_CATALOG TABLE_CAT, TABLE_SCHEMA TABLE_SCHEM, TABLE_NAME, > COLUMN_NAME, DATA_TYPE, TYPE_NAME, CHARACTER_MAXIMUM_LENGTH > COLUMN_SIZE, CHARACTER_MAXIMUM_LENGTH BUFFER_LENGTH, NUMERIC_SCALE > DECIMAL_DIGITS, NUMERIC_PRECISION_RADIX NUM_PREC_RADIX, NULLABLE, > REMARKS, COLUMN_DEFAULT COLUMN_DEF, DATA_TYPE SQL_DATA_TYPE, ZERO() > SQL_DATETIME_SUB, CHARACTER_OCTET_LENGTH CHAR_OCTET_LENGTH, > ORDINAL_POSITION, IS_NULLABLE IS_NULLABLE FROM > INFORMATION_SCHEMA.COLUMNS WHERE TABLE_CATALOG LIKE ? AND TABLE_SCHEMA > LIKE ? AND TABLE_NAME LIKE ? AND COLUMN_NAME LIKE ? ORDER BY > TABLE_SCHEM, TABLE_NAME, ORDINAL_POSITION [22025-107]; see root cause > for details [90043-107] > at org.h2.message.Message.getSQLException(Message.java:103) > at org.h2.schema.TriggerObject.load(TriggerObject.java:67) > at org.h2.schema.TriggerObject.setTriggerClassName(TriggerObject.java: > 83) > at org.h2.command.ddl.CreateTrigger.update(CreateTrigger.java:96) > at org.h2.command.CommandContainer.update(CommandContainer.java:71) > at org.h2.command.Command.executeUpdate(Command.java:207) > at org.h2.jdbc.JdbcStatement.execute(JdbcStatement.java:165) > at org.h2.fulltext.FullText.createOrDropTrigger(FullText.java:627) > at org.h2.fulltext.FullText.createTrigger(FullText.java:611) > at org.h2.fulltext.FullText.createIndex(FullText.java:156) > at DatabaseBug.tableWithSlash(DatabaseBug.java:53) > at DatabaseBug.main(DatabaseBug.java:46) > Caused by: org.h2.jdbc.JdbcSQLException: Blad w LIKE ESCAPE: t[*]\ > Error in LIKE ESCAPE: t[*]\; SQL statement: > SELECT TABLE_CATALOG TABLE_CAT, TABLE_SCHEMA TABLE_SCHEM, TABLE_NAME, > COLUMN_NAME, DATA_TYPE, TYPE_NAME, CHARACTER_MAXIMUM_LENGTH > COLUMN_SIZE, CHARACTER_MAXIMUM_LENGTH BUFFER_LENGTH, NUMERIC_SCALE > DECIMAL_DIGITS, NUMERIC_PRECISION_RADIX NUM_PREC_RADIX, NULLABLE, > REMARKS, COLUMN_DEFAULT COLUMN_DEF, DATA_TYPE SQL_DATA_TYPE, ZERO() > SQL_DATETIME_SUB, CHARACTER_OCTET_LENGTH CHAR_OCTET_LENGTH, > ORDINAL_POSITION, IS_NULLABLE IS_NULLABLE FROM > INFORMATION_SCHEMA.COLUMNS WHERE TABLE_CATALOG LIKE ? AND TABLE_SCHEMA > LIKE ? AND TABLE_NAME LIKE ? AND COLUMN_NAME LIKE ? ORDER BY > TABLE_SCHEM, TABLE_NAME, ORDINAL_POSITION [22025-107] > at org.h2.message.Message.getSQLException(Message.java:103) > at org.h2.message.Message.getSQLException(Message.java:114) > at org.h2.message.Message.getSQLException(Message.java:77) > at org.h2.expression.CompareLike.initPattern(CompareLike.java:306) > at org.h2.expression.CompareLike.optimize(CompareLike.java:99) > at org.h2.expression.ConditionAndOr.optimize(ConditionAndOr.java:132) > at org.h2.expression.ConditionAndOr.optimize(ConditionAndOr.java:131) > at org.h2.command.dml.Select.prepare(Select.java:729) > at org.h2.command.CommandContainer.recompileIfRequired > (CommandContainer.java:61) > at org.h2.command.CommandContainer.query(CommandContainer.java:77) > at org.h2.command.Command.executeQueryLocal(Command.java:141) > at org.h2.command.Command.executeQuery(Command.java:122) > at org.h2.jdbc.JdbcPreparedStatement.executeQuery > (JdbcPreparedStatement.java:96) > at org.h2.jdbc.JdbcDatabaseMetaData.getColumns > (JdbcDatabaseMetaData.java:243) > at org.h2.fulltext.FullText$FullTextTrigger.init(FullText.java:696) > at org.h2.schema.TriggerObject.load(TriggerObject.java:65) > ... 10 more > > > > --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
