Hi,
What is your use case exactly? Do you have an application that needs
to parse the SQL state?
Well, SQL states are not well defined unfortunately. The following statements:
drop table test;
create table test(id int, name varchar(255));
insert into test(id, name) values(1);
will result in different SQL states:
42564 (HSQLDB: row column count mismatch)
42601 (PostgreSQL: INSERT has more target columns than expressions)
42802 (Derby: The number of values assigned is not the same ...)
21S01 (MySQL: Column count doesn't match value count at row 1)
21S02 (H2: Column count does not match)
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.
