The DSLContext.alterTableIfExists() does not support MySQL as per the documentation: https://www.jooq.org/javadoc/latest/org.jooq/org/jooq/DSLContext.html#alterTableIfExists(java.lang.String)
On Thu, Jun 16, 2022 at 2:28 PM Bert-Jan de Gier <[email protected]> wrote: > Hello, > > Maybe I'm doing something wrong, but I've tried to rename my table in > MySQL using jOOQ using DSLContext.alterTableIfExists(). The resulting > query is: > > alter table if exists `oldname` rename to `newname` > > But my MySQL instance refuses this claiming it's invalid SQL. When I use > DSLContext.alterTable() it does work correctly. Is this a bug in jOOQ or > am I doing something wrong? Thanks for any insights you can give. > > Best regards, > Bert-Jan de Gier > > -- > 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]. > To view this discussion on the web visit > https://groups.google.com/d/msgid/jooq-user/f5e8f6d7-ee89-44a1-9e32-57af422e7e56n%40googlegroups.com > <https://groups.google.com/d/msgid/jooq-user/f5e8f6d7-ee89-44a1-9e32-57af422e7e56n%40googlegroups.com?utm_medium=email&utm_source=footer> > . > -- 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]. To view this discussion on the web visit https://groups.google.com/d/msgid/jooq-user/CAB4ELO4AL4n5UVNtHm9gnQoa8bRGzU%2BdUEH_%2BsJ2rCqZKy1KLw%40mail.gmail.com.
