V 1.4.200 LAST_INSERT_ID() don't work

[Roland M.]

Hello, I want to change from V1.4.199 to V1.4.200.

But unfortunately the query "SELECT LAST_INSERT_ID()" don' work anymore.

Is this a bug , or have I to use another function, and when, which one?

Best regards

[Evgenij Ryazanov]

Hello.

This function is a part of MSSQLServer compatibility mode and is not available in other modes anymore.

For identity columns In Regular mode you need to ask an insert or merge operation about the inserted data.

With JDBC you can use Statement.getGeneratedKeys() if Statement.RETURN_GENERATED_KEYS, column names, or column indexes were specified earlier.

With SQL only you can use standard data change delta tables:

SELECT ID FROM FINAL TABLE (INSERT INTO TEST (A, B) VALUES (1, 2))

https://h2database.com/html/grammar.html#data_change_delta_table

If you have separate sequences, you can use non-standard and non-portable

VALUES CURRENT VALUE FOR sequenceName

but normally you should only use standard NEXT VALUE FOR sequenceName when new generated value is needed.

https://h2database.com/html/grammar.html#sequence_value_expression

[Roland M.]

Ah,

ok. Thank you very much for the detailed answer!