Hi With MySQL we sometimes use temp tables to break up a complex query, especially when large subquery results are involved. For performance reasons, these temp tables need to have indices, but we don't want the running transaction to be committed. I'd also appreciate transaction save index creation to be implented on temp tables in H2. MYSQL compatibility mode is not really an option since we don't like other features included therein.
Regards Remo On 9 Aug., 19:04, Thomas Mueller <[email protected]> wrote: > Hi, > > In the MySQL mode (append ;MODE=MYSQL to the database URL), you can > create indexes as follows: > > create table test(id int, name varchar, index idx_name(name)); > > Otherwise I'm afraid this feature is not supported. > > 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.
