I try to import table data from a linked table:
CREATE LINKED TABLE linked_brands('com.mysql.jdbc.Driver',
'jdbc:mysql:///MYDATABASE', '***', '***', 'brands');
INSERT INTO brands SELECT * FROM linked_brands;
DROP TABLE linked_brands;
This works fine for most tables. However some tables give the following
error:
Error: NULL not allowed for column "ISMANDATORY"; SQL statement:
INSERT INTO test SELECT * FROM linked_test [23502-190]
SQLState: 23502
ErrorCode: 23502
Error occured in:
INSERT INTO test SELECT * FROM linked_test
It turns out that this error always happens if the linked table contains a
boolean field defined as BIT in Mysql and the column name starts with "IS".
Note that the linked tables does *not* contains NULL values in the reported
column. All columns contain 1 or 0.
What goes wrong here?
--
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.
