sorry for not getting back sooner with a testcase.
While writing this, I tested some more, and found additional information.
IF String.class is passed as type, the CHAR data type without length is
IF SQLDataType.VARCHAR is passed as type, the CHAR data type without length
IF SQLDataType.VARCHAR(10) is passed as type, the VARCHAR(10) data type is
I don't think this is appropriate behavior, especially for Java String
class. For other dialects (postgres, sqlite, H2 and Derby) it does the
Setup of MYSQL;
docker run --name mysql -e MYSQL_ROOT_PASSWORD="" -e
MYSQL_ALLOW_EMPTY_PASSWORD=yes -e MYSQL_DATABASE=jdbc_test_db -p 3306:3306
And then run the code below. The First *insertInto()* will succeed and the
second *insertInto()* will fail, becase the createTable() will produce the
following SQL statement;
*create table `TESTTABLE`(`_identity` char null)*
I was digging quite a lot in the JOOQ code to find this, but I can't figure
out how it hangs together, and it seems that large sections are generated
and not handcoded. So I gave up.
You received this digest because you're subscribed to updates for this group. You can change your settings on the group membership page.
To unsubscribe from this group and stop receiving emails from it send an email to [hidden email].