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]

Reply via email to