https://bugs.documentfoundation.org/show_bug.cgi?id=105220
Bug ID: 105220
Summary: Firebird: Insert with direct SQL - RETURNING without
values
Product: LibreOffice
Version: 5.4.0.0.alpha0+ Master
Hardware: x86-64 (AMD64)
OS: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Base
Assignee: [email protected]
Reporter: [email protected]
Created attachment 130288
--> https://bugs.documentfoundation.org/attachment.cgi?id=130288&action=edit
Open the database and try the code as described for get the last inserted
AutoValue
Open the attached Firebird 3 database.
Open Tools > SQL...
Mark "Show output of "select" statements.
Copy the following code:
INSERT INTO "Table" ("Name", "Town") VALUES ('Mike', 'Alexandria')
RETURNING "ID", "Name", "Town";
There is no value shown as output. The status shows only "1."
Expected is in "output":
4;Mike;Alexandria
There is a function in HSQLDB named "CALL IDENTITY()" This gives you the last
inserted AutoValue. I hope to find this in Firebird. There it should run with
RETURNING, but doesn't run in Tools > SQL... Will test this later with macros
to see, if it's a problem of internal Firebird or a problem of the SQL-dialog.
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
