In needing to upgrade to Jooq 3.8.x to make use of the newly added range functions <http://www.jooq.org/javadoc/3.8.x/org/jooq/WindowSpecificationRowsStep.html#rangeBetweenUnboundedPreceding-->, the additional feature of allowing "DEFAULT" keywords in the code-generated create table statements has caused a side-effect in our HSQLdb embedded database implementation.
Since HSQLdb is a bit unorthodox with having the DEFAULT... statement preceding the NOT NULL statement, an "unexpected token: DEFAULT" error is thrown. For example, Jooq>=3.8.0 code-generates create table statements similar to the following for HSQLdb: create table schema_name.table_name(col_name varchar(255) not null default NULL, ...) But for HSQLdb, the order in the column definition needs to be <http://stackoverflow.com/questions/18449242/boolean-column-in-hsqldb-with-default-value> : create table schema_name.table_name(col_name varchar(255) default NULL not null, ...) Or simply, the default statement just shouldn't be included. I've tried to narrow-down where this statement gets injected, and I'm presuming it is here: https://github.com/jOOQ/jOOQ/blob/master/jOOQ/src/main/java/org/jooq/impl/CreateTableImpl.java#L298 *How could I disable/prevent/suppress default statements in column definitions of the code-generated create table SQL commands? * *If disabling them isn't possible without patching Jooq, how else could the ordering be corrected such that minimal code changes are necessary?* -- You received this message because you are subscribed to the Google Groups "jOOQ User Group" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
