mysql virtual columns

[Leander Kurscheidt]

Hello,

i have virtual columns in my database and generated the representation from it. Inserting something where the value is set for the column will throw an error i guess, but will they work when i set them to null?

Leander

[Lukas Eder]

Hi Leander,

jOOQ will only generate INSERT or UPDATE SQL code for columns that you explicitly set to a value. If you don't set any value for your generated columns, then jOOQ will not produce them in your INSERT statement (resulting in DEFAULT behaviour). If you explicitly set NULL, then jOOQ will also set NULL explicitly.

I'm not sure what the behaviour of virtual columns in MySQL is in that respect, but I think you shouldn't insert into them.

I hope this helps.

Lukas

--
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 jooq-user+...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.