This is normal. An uppercase copy of the CLOB is created. To avoid it, cast the CLOB to VARCHAR before converting to uppercase.
Fred Toussi On Thu, Jul 13, 2017, at 10:52, Alexander Gerbig wrote: > Hallo hsqldb developers, > > we use a hsqldb in our application an experience a strange behavior. We > have some clob columns in different tables and when we execute an select > with an upper on the clob column in a where clause the lobs file > increases in size. Is it a very practice to make an upper on an clob > column? Is this normal? > > Thanks for any help. > > Bye > Alex > ------------------------------------------------------------------------------ > Check out the vibrant tech community on one of the world's most > engaging tech sites, Slashdot.org! http://sdm.link/slashdot > _______________________________________________ > hsqldb-developers mailing list > hsqldb-developers@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/hsqldb-developers ------------------------------------------------------------------------------ Check out the vibrant tech community on one of the world's most engaging tech sites, Slashdot.org! http://sdm.link/slashdot _______________________________________________ hsqldb-developers mailing list hsqldb-developers@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/hsqldb-developers
