If you send us a patch, we can probably include it into the normal H2 codebase :-)
On Tue, Feb 21, 2012 at 20:21, Steve McLeod <[email protected]> wrote: > More on this: > > MySQL also supports multi-column ADD, as per this example: > > ALTER TABLE customer ADD (foo INTEGER, foo2 INTEGER); > > I had a go at adding this feature to H2 as per Oracle's and MySQL's > syntax, and I've had success. Now adding four columns at once takes > about the same time of previously adding just one column. For my > specific use case this is a great win. > > The use case is updating existing user databases that may be Gigaytes > in size. A 30 minute update is far better than a 2 hour update. > > Regards, > > Steve > > > > On Feb 20, 8:25 pm, Steve McLeod <[email protected]> wrote: >> Hi Thomas & co, >> >> Currently if I want to add 2 or more columns to a table in H2, I need >> to execute multiple ALTER TABLE ADD commands: >> >> ALTER TABLE customer ADD foo INTEGER; >> ALTER TABLE customer ADD foo2 INTEGER; >> >> Oracle allows adding two columns at once: >> >> ALTER TABLE customer ADD (foo INTEGER, foo2 INTEGER); >> >> So does Microsft SQL Server's T-SQL: >> >> ALTER TABLE customer ADD foo INTEGER, foo2 INTEGER; >> >> I'd like to have a go at adding this to H2. If I do, is this something >> you'd be likely to add to the SVN trunk? If so, is the SQL Server >> syntax or the Oracle syntax preferable? As far as I can tell, the >> SQL-92 standard doesn't cover this scenario. >> >> Regards, >> >> Steve > > -- > 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. > -- 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.
