Hi, This is a bug. If there are a lot of rows in a result set, the result is stored externally. In most cases, this is a temporary file (in the temp directory for read-only databases). But for some queries (mainly distinct queries) this is a temporary table. Creating temporary tables fails for read-only databases. In the next release, no temporary table will be created in this case. This will limit the size of distinct queries, but I guess this is not that important for read-only databases.
Regards, Thomas -- 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.
