Wow, fast work! The patch seems fine, please can I get a license statement as per: http://h2database.com/html/build.html#providing_patches
On 2014-03-15 15:26, [email protected] wrote:
Hi Noel, I'm attaching a patch that extends the query parser to support "ALTER TABLE CHANGE [COLUMN] /|old_col_name|/ /|column_definition|/", "ALTER TABLE DROP INDEX index_name" and "ALTER TABLE DROP FOREIGN KEY fk_symbol" (as documented in http://dev.mysql.com/doc/refman/5.5/en/alter-table.html). ALTER TABLE CHANGE is limited insofar as MySQL supports complete column redefinitions whereas the patch only enabled column renames. I've extended the test script but didn't add any other testing code. I'd be happy about any feedback regarding the patch. Thanks, Peter Am Freitag, 14. März 2014 08:17:19 UTC+1 schrieb Noel Grandin: Other than reading the source code, unfortunately not. However, we are always open to patches to improve the situation :-) On 2014-03-13 12:51, Peter Jentsch wrote: > Hi, > > we're currently using H2 as embedded database for unit tests for as system that runs on MySQL in production. The DDL is > versioned using FlyWay. We haven't faced any compatibility issues as long as we only added to the schema. Recently we > started to modify the schema and found it hard to find compatible options for some statements (column rename, drop > constraint). Is there any comprehensive overview of which MySQL DDL statements are supported by H2 in MySQL > compatibility mode? -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected] <mailto:[email protected]>. To post to this group, send email to [email protected] <mailto:[email protected]>. Visit this group at http://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.
-- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.
