https://bugs.documentfoundation.org/show_bug.cgi?id=132693
Bug ID: 132693
Summary: Execute SQL command with Firebird
Product: LibreOffice
Version: unspecified
Hardware: x86-64 (AMD64)
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Base
Assignee: [email protected]
Reporter: [email protected]
Executing two SQL commands fails with Firebird embedded.
CREATE TABLE "Members" ( "ID" INT GENERATED BY DEFAULT AS IDENTITY PRIMARY KEY,
"FirstName" VARCHAR(20) NOT NULL , "LastName" VARCHAR(20) NOT NULL, "EmailName"
VARCHAR(20), "EmailDomain" VARCHAR(20), "DateJoined" DATE );
INSERT INTO "Members" ("FirstName", "LastName", "EmailName", "EmailDomain")
VALUES ('test','user2','testuser2','soroban.co.uk');
Error report
1: firebird_sdbc error: *Dynamic SQL Error *SQL error code = -104 *Token
unknown - line 9, column 1 *INSERT caused by 'isc_dsql_prepare'
This works as expected with HSQLDB embedded
--
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