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

Reply via email to