Howdy.
Using 1.3.171 and "jdbc:h2:mem:dictservice_test;MODE=PostgreSQL", we get
the following error when trying to create a lower-case index:
org.h2.jdbc.JdbcSQLException: Syntax error in SQL statement "CREATE INDEX
DICTIONARY_WORD_LCASE_IDX ON DICTIONARY (LOWER([*]""word"")) "; expected
"ASC, DESC, NULLS, ,, )"; SQL statement:
CREATE INDEX dictionary_word_lcase_idx ON dictionary (lower("word"))
[42001-171]
at org.h2.message.DbException.getJdbcSQLException(DbException.java:329)
at org.h2.message.DbException.get(DbException.java:169)
at org.h2.message.DbException.getSyntaxError(DbException.java:194)
at org.h2.command.Parser.getSyntaxError(Parser.java:490)
at org.h2.command.Parser.read(Parser.java:2805)
at org.h2.command.Parser.parseIndexColumnList(Parser.java:768)
at org.h2.command.Parser.parseCreate(Parser.java:3859)
at org.h2.command.Parser.parsePrepared(Parser.java:323)
at org.h2.command.Parser.parse(Parser.java:278)
at org.h2.command.Parser.parse(Parser.java:254)
Is this a bug, or are "function-based" indexes simply not supported?
- Pyppe
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/h2-database?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.
