Hi Lukas,
I did some further investigation about what insert is generated for each db.
[ ] insert into "country" ("id", "code", "name", "population",
"percentage", "date", "continent_id") values ('netherlands', 'NL',
'Netherlands', 17947684, 0.2, date '2023-12-31', 'europe')
[CUBRID
Marcel,
Yes I know it’s a challenge to try to create “ANSI SQL” files.
>
I've just thought of a problem you will inevitably run into with your
approach: jOOQ does not give you any guarantee of "ANSI SQL." If you pick
any dialect (e.g. PostgreSQL), it will generate a "reasonable" SQL query or
expr
Thanks for detailed feedback Luka, I really appreciate it.
I think https://github.com/jOOQ/jOOQ/issues/16498 makes sense,
but also MariaDB supports the { d '*str*' } expression (as expected as it
is a fork), so even in my case that should be no problem.
Note I'm generating the .sql file dumps
On Fri, Mar 22, 2024 at 12:16 PM Marcel Overdijk
wrote:
> Thanks for detailed feedback Luka, I really appreciate it.
>
> I think https://github.com/jOOQ/jOOQ/issues/16498 makes sense,
> but also MariaDB supports the { d '*str*' } expression (as expected as
> it is a fork), so even in my case tha