[Libreoffice-bugs] [Bug 132693] New: Execute SQL command with Firebird

[bugzilla-daemon at bugs.documentfoundation.org]

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: libreoffice-bugs at lists.freedesktop.org
          Reporter: jcs.LibreOffice at soroban.co.uk

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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20200504/3626803e/attachment.htm>