Here we go:
mysql> SELECT extra FROM information_schema.columns
-> WHERE lower(table_name) = 'campaigns'
-> AND lower(column_name) = 'id';
+----------------+
| extra |
+----------------+
| auto_increment |
+----------------+
1 row in set (0.05 sec)
Does this help?
Ian.
On Sun, Mar 25, 2012 at 11:07 AM, Lukas Eder <[email protected]> wrote:
> Hello Ian,
>
> > In case it's useful, here is the mysql dump of the campaigns table:
> >
> > https://gist.github.com/46e5fa5f5a768725eb7c
>
> I tried running the code generator on your table with my setup and it
> correctly generated an identity for campaigns.id. So the problem is
> not related to your JDBC driver. There's probably a bug in
> jooq-codegen's MySQL integration.
>
> >> - What version of MySQL are you using? jOOQ officially supports 5.1 and
> >> above
> >
> > I'm using 5.5.20
>
> Maybe there is some feature in the MySQL dictionary views, that I am
> not aware of. What does the following query return on your system?
>
> SELECT extra FROM information_schema.columns
> WHERE lower(table_name) = 'campaigns'
> AND lower(column_name) = 'id'
>
> Cheers
> Lukas
>
--
Ian Clarke
Blog: http://blog.locut.us/
