lukaseder/jOOQ — Issue #11: MySQL Dialect Doesn't Support NULLIF
Author: dacc
Created: 2012-02-23 01:28:34+00:00
State: open

Attempting to use nullif from a subtype of MySQLFactory causes an exception like the one below:

```
org.jooq.exception.SQLDialectNotSupportedException: Type class org.jooq.impl.CombinedCondition is not supported in dialect null
at org.jooq.impl.AbstractDataType.getDataType(AbstractDataType.java:428)
at org.jooq.impl.FieldTypeHelper.getDataType(FieldTypeHelper.java:781)
at org.jooq.impl.Factory.getDataType(Factory.java:4470)
at org.jooq.impl.Factory.val(Factory.java:4003)
at org.jooq.impl.Factory.nullif(Factory.java:1578)
```

MySQL supports NULLIF as documented here:

http://dev.mysql.com/doc/refman/5.0/en/control-flow-functions.html#function_nullif