Details
-
Task
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Won't Fix
-
None
-
10.2.4-1, 10.2.4-1, 10.2.4-2, 10.2.6-2, 10.2.6-3
Description
Before normal OK packet sent result set with 3 fields:
Id - first ID sequence
Len - Sequence length (number of sequential Ids)
Inc - increment of the sequence (same for all records)
If statement return the same ID after each insert, will be reported only one.
Function work only if INSERT_ID_REQUEST set as flag for the execute statement.
Attachments
Issue Links
- relates to
-
-
- Closed
-
Activity
Thanks!
Alas, the one place I wanted to use it is apparently not allowed:
INSERT ... SELECT ...
RETURNING ...;
Or maybe it would be
INSERT ... RETURNING ...
SELECT ...;
It is, https://github.com/MariaDB/server/blob/10.5/mysql-test/main/insert_returning.test#L136
what exactly isn't working for you?
I was looking at the syntax – It seems to be disallowed. Perhaps it is just a documentation omission?
(I have not yet tried it.)
Would the RETURNING come before the SELECT? Or After?
Looking at the syntax in the KB? https://mariadb.com/kb/en/insertreturning/ shows that it's supported.
See the manual for the documented supported syntax and the test file (in my previous comment) for actual working examples.
Not needed anymore, INSERT ... RETURNING can be used instead.