Menu
▾
▴
Re: [Hsqldb-user] clobs and defaults
|
From: Fred T. <fr...@us...> - 2011-02-11 11:51:11
|
Thanks, Previously, column DEFAULT other than NULL was not supported for LOB columns but was rejected only for BLOB columns. I have implemented support for BLOB and CLOB column DEFAULT and committed to SVN. Will be included in the next snapshot later today. Fred On Thu, 10 Feb 2011 11:27 -0800, "Tmo_hsqldb_q" <tm...@bg...> wrote: > > When I create the following table with clob column and then restart > hsqldb > server everything is fine. > > CREATE TABLE TESTCLOB2 > ( > resourcePayload clob > ) > > > But when I create the following table with clob column and default value > and > then restart hsqldb server: > > CREATE TABLE TESTCLOB3 > ( > resourcePayload clob DEFAULT 'UNKNOWN' NOT NULL > ) > > > > I get the following exception: > > [2011-02-10 13:44:35,263] INFO [HSQLDB Server @26dfcc] > [HSQLDB2A0FD220ED.org.hsqldb.persist.Logger] - open start > [2011-02-10 13:44:35,319] INFO [HSQLDB Server @26dfcc] > [HSQLDB2A0FD220ED.org.hsqldb.persist.Logger] - open end > [2011-02-10 13:44:35,547] INFO [HSQLDB Server @26dfcc] > [HSQLDB2A0FD220ED.org.hsqldb.persist.Logger] - DataFileCache.close(false) > : > start > [2011-02-10 13:44:35,549] INFO [HSQLDB Server @26dfcc] > [HSQLDB2A0FD220ED.org.hsqldb.persist.Logger] - DataFileCache.close() : > close > [2011-02-10 13:44:35,549] WARN [HSQLDB Server @26dfcc] > [HSQLDB2A0FD220ED.org.hsqldb.persist.Logger] - Script processing failure > java.lang.ArithmeticException: / by zero > at org.hsqldb.persist.LobManager.setBytesBA(LobManager.java:929) > at org.hsqldb.persist.LobManager.setChars(LobManager.java:1119) > at org.hsqldb.Session.performLOBOperation(Session.java:1837) > at org.hsqldb.Session.execute(Session.java:929) > at org.hsqldb.types.ClobDataID.setString(ClobDataID.java:130) > at > org.hsqldb.types.CharacterType.castOrConvertToType(CharacterType.java:527) > at org.hsqldb.types.CharacterType.convertToType(CharacterType.java:620) > at org.hsqldb.ParserRoutine.readDefaultClause(ParserRoutine.java:190) > at org.hsqldb.ParserDDL.readColumnDefinitionOrNull(ParserDDL.java:2301) > at org.hsqldb.ParserDDL.compileCreateTableBody(ParserDDL.java:969) > at org.hsqldb.ParserDDL.compileCreateTable(ParserDDL.java:884) > at org.hsqldb.ParserDDL.compileCreate(ParserDDL.java:151) > at org.hsqldb.ParserCommand.compilePart(ParserCommand.java:206) > at org.hsqldb.ParserCommand.compileStatement(ParserCommand.java:63) > at org.hsqldb.Session.compileStatement(Session.java:904) > at org.hsqldb.scriptio.ScriptReaderText.readDDL(ScriptReaderText.java:118) > at org.hsqldb.scriptio.ScriptReaderBase.readAll(ScriptReaderBase.java:65) > at org.hsqldb.persist.Log.processScript(Log.java:759) > at org.hsqldb.persist.Log.open(Log.java:159) > at org.hsqldb.persist.Logger.openPersistence(Logger.java:288) > at org.hsqldb.Database.reopen(Database.java:218) > at org.hsqldb.Database.open(Database.java:185) > at org.hsqldb.DatabaseManager.getDatabase(DatabaseManager.java:236) > at org.hsqldb.DatabaseManager.getDatabase(DatabaseManager.java:189) > at org.hsqldb.server.Server.openDatabases(Server.java:1833) > at org.hsqldb.server.Server.run(Server.java:2166) > at org.hsqldb.server.Server.access$000(Server.java:243) > at org.hsqldb.server.Server$ServerThread.run(Server.java:314) > > > > > Tony > -- > View this message in context: > http://old.nabble.com/clobs-and-defaults-tp30895520p30895520.html > Sent from the HSQLDB - User mailing list archive at Nabble.com. > > > ------------------------------------------------------------------------------ > The ultimate all-in-one performance toolkit: Intel(R) Parallel Studio XE: > Pinpoint memory and threading errors before they happen. > Find and fix more than 250 security defects in the development cycle. > Locate bottlenecks in serial and parallel code that limit performance. > http://p.sf.net/sfu/intel-dev2devfeb > _______________________________________________ > Hsqldb-user mailing list > Hsq...@li... > https://lists.sourceforge.net/lists/listinfo/hsqldb-user > |