Hi, > Statement like > CREATE LOCAL TEMPORARY TABLE FOO AS (SOME_QUERY) TRANSACTIONAL NOT > PERSISTENT; > throws a syntax error and the error is identified next to NOT word.
This is a bug in the documentation, I will fix it. It should be: [ NOT PERSISTENT ] [ TRANSACTIONAL ] > Is TEMP table a GLOBAL or LOCAL TEMPORARY? global. > Would it make sense also to have a table that is local to the transaction? Yes. I'm not sure if it's useful, and it's not fully tested, that why it is not documented, but you can use: CREATE LOCAL TEMPORARY TABLE FOO AS (select 1) ON COMMIT DROP TRANSACTIONAL; also implemented is ON COMMIT DELETE. > CREATE CACHED TEMP TABLE ... NOT PERSISTENT -> ?!? The 'cached' is ignored in this case. But it might as well throw an exception. 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.
