For example: select s_sequence1.nextval, s_sequence2.nextval from dual. This sql is supported by all types of database(maybe a little difference in spell).
And for Oracle 9i and after version, it support the "insert all" and "insert first" sql which can insert into multiple tables in just one sql. And for Oracle 12c, I heard it support autoincrease columns. Another types of database support insert multiple tables in one sql is not certain.
But in HA-JDBC, only one sequence and one table can be detected with a sql, Can you fix it? Thank you.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
For example: select s_sequence1.nextval, s_sequence2.nextval from dual. This sql is supported by all types of database(maybe a little difference in spell).
And for Oracle 9i and after version, it support the "insert all" and "insert first" sql which can insert into multiple tables in just one sql. And for Oracle 12c, I heard it support autoincrease columns. Another types of database support insert multiple tables in one sql is not certain.
But in HA-JDBC, only one sequence and one table can be detected with a sql, Can you fix it? Thank you.
Good point.
https://github.com/ha-jdbc/ha-jdbc/issues/80
OK, do you have a plan to fix it?