(7.4.z) MariaDB 10.3 sequence issues in Hibernate ORM 5.3.20.Final

While running Hibernate 5.3.20.Final test suite on MariaDB/MariaDB Galera Cluster 10.3, the following exceptions can be observed:

FUNCTION dballo16.currval does not exist

Reason: Though MariaDB 10.3 has a sequences support, it has a little bit different syntax for sequence current value retrieving:

MariaDB

PREVIOUS VALUE FOR sequence_name / LASTVAL(sequence_name)

MariaDB in Oracle mode:

sequence_name.currval

but there is no

currval(sequence_name)

as it is stated in error description.

Caused by: java.sql.SQLException: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'Range (`value`, id) values (5, 7)' at line 1

Reason: Reserved RANGE word.

Caused by: java.sql.SQLException: Sequence 'dballo02.pos_two_seq' values are conflicting

Fixed in the latest H8 ORM TS version.

Note: All exceptions does not appear in the latest H8 ORM test suite version (5.5.0)