Hi Fred,
because of the following reasons we consider this as a bug:
- the upper copy of the clob is not removed afterwards and the already
occupied space is not reused
- it is not easily possible to reduce the size of the lobs-file
- this behavior is not documented
Therefore I will open a bug in the Bug Tracker.
Bye, Alex
2017-07-13 19:31 GMT+02:00 Alexander Gerbig <alexander.ger...@gmail.com>:
> Ok, thank you. Is it possible to reduce the size of the file again?
>
> > Am 13.07.2017 um 18:08 schrieb Fred Toussi via hsqldb-developers <
> hsqldb-developers@lists.sourceforge.net>:
> >
> > 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
>
------------------------------------------------------------------------------
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
