I get an error when trying to use *LOB data types in version 1.3.156. This appears to be due to a recent change in the LobStorage class where a column named OFFSET was introduced to the LOB_MAP table. OFFSET appears to be a reserved word ( http://publib.boulder.ibm.com/infocenter/db2luw/v9r7/topic/com.ibm.db2.luw.sql.ref.doc/doc/r0001095.html ), so the parser runs into problems.
Example command (in DB2 mode): CREATE TABLE FOO (FooID INT NOT NULL, FooClob CLOB NOT NULL); Observed output : CREATE TABLE FOO (FooID INT NOT NULL, FooClob CLOB NOT NULL); Syntax error in SQL statement "CREATE TABLE IF NOT EXISTS INFORMATION_SCHEMA.LOB_MAP(LOB BIGINT, SEQ INT, OFFSET[*] BIGINT, HASH INT, BLOCK BIGINT, PRIMARY KEY(LOB, SEQ)) HIDDEN"; expected "identifier"; SQL statement: CREATE TABLE IF NOT EXISTS INFORMATION_SCHEMA.LOB_MAP(LOB BIGINT, SEQ INT, OFFSET BIGINT, HASH INT, BLOCK BIGINT, PRIMARY KEY(LOB, SEQ)) HIDDEN [42001-156] 42001/42001 As expected this works perfectly in default mode (where OFFSET isn't a reserved word). I haven't tested any of the other compatibility modes. Obviously there may also be other errors in different parts of the system which you might want to test for too. -- 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.
