Hi,
Thanks for your mail! I will add this to the feature request list:
"MySQL compatibility: for auto_increment columns, convert 0 to next
value (as when inserting NULL)."
However, for me it doesn't have a high priority at the moment (this
may change if more people request the feature).
My test case is:
drop table test;
create table test(id int auto_increment primary key, name varchar(255));
insert into test(name) values('hello');
insert into test(id, name) values(null, 'world');
insert into test(id, name) values(10, 'test 10');
insert into test(id, name) values(0, 'test');
select * from test;
> id name
> 1 hello
> 2 world
> 10 test 10
> 11 test
> In MySQL inserting 0 in AUTO_INCREMENT column behaves like inserting
> NULL so that automatically a new incremental integer is assigned to
> identity column.
I didn't know about that. If you have a link to the MySQL
documentation about that, could you post it?
I think you know that MySQL will also convert NULL to the next value
(as H2 does). Of course you would need to change your application
then.
> Is it possible to preserve the column name case accepting both upper
> and lower case rather than turning all column names to lower case as
> it happens currently
There is already a feature request, I will increase the priority:
"MySQL, MS SQL Server compatibility: support case sensitive (mixed
case) identifiers without quotes."
> Many web developers willing to get rid of infectious nature of GPL
> license terms will quickly turn to H2
The MySQL license is quite restrictive, and probably will get more
restrictive over time. GPL + commercial (dual licensing) is more and
more used to force companies to buy the commercial version. So GPL is
used to make others _not_ use it. I don't think this was the intention
of those who wrote the GPL...
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
-~----------~----~----~----~------~----~------~--~---
