vasipallyn opened a new pull request, #9484:
URL: https://github.com/apache/hop/pull/9484
MariaDB has supported sequences natively since 10.3, but the MariaDB
database type inherited MySQL's lack of sequence support, so sequences could
not be listed, checked or used from Hop.
This change, in 'MariaDBDatabaseMeta':
reports sequence support,
lists the sequences of the current database from
`INFORMATION_SCHEMA.TABLES`, where MariaDB stores them with 'TABLE_TYPE =
'SEQUENCE',
- checks whether a sequence exists in the current database, or in the given
database for a schema-qualified (backtick-quoted) name such as "sales.order_seq"
- uses 'NEXTVAL()' for the next value and 'LASTVAL()' for the current value.
'MariaDBSequenceAndReleaseSavePointTest', which asserted that MariaDB had no
sequence support, now asserts the generated SQL, with extra cases for a
schema-qualified name and for quote escaping. Formatting was checked with
google-java-format 1.17. I could not run the full Maven build locally, so I am
relying on the automated checks for that.
fixes #8525
------------------------
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]