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
-~----------~----~----~----~------~----~------~--~---
