Temporary table but no database shrink after close (1.2.133)

40 views
Skip to first unread message

phillnet

unread,
Apr 17, 2010, 7:12:23 AM4/17/10
to H2 Database
Hi

I've been thinking about this for hours but I just don't see the
solution:

If i create global temporary tables, work with them and finally close
the database the filename.h2.db still maintains it's size. I have to
re-open the connection to finally "shrink" the database. So I guess
cached temporary tables are somehow kept until the database is opened
next time?

Is it the same problem as mentioned in release 1.2.130?
"When using temporary tables, the database didn't shrink sometimes
when closing. Also, sometimes a database could not recover normally. "

Thanks in advance

--
You received this message because you are subscribed to the Google Groups "H2 Database" group.
To post to this group, send email to h2-da...@googlegroups.com.
To unsubscribe from this group, send email to h2-database...@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/h2-database?hl=en.

Thomas Mueller

unread,
Apr 23, 2010, 1:45:17 PM4/23/10
to h2-da...@googlegroups.com
Hi,

Sorry for the delay. This looks like a bug, I will try to fix it for
the next release.

Regards,
Thomas
Reply all
Reply to author
Forward
0 new messages