[Libreoffice-bugs] [Bug 137566] New: LO base: some errors during - create Table and insert records via menue "tools/SQL"

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=137566

            Bug ID: 137566
           Summary: LO base: some errors during - create Table and insert
                    records via menue "tools/SQL"
           Product: LibreOffice
           Version: 7.1.0.0.alpha0+ Master
          Hardware: x86-64 (AMD64)
                OS: Linux (All)
            Status: UNCONFIRMED
          Severity: minor
          Priority: medium
         Component: Base
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: rich.libre at demattio.co.at

Description:
creating tables and inserting records are leading to errors "token unknown"
and the operations are failing

Steps to Reproduce:
see the attached file

Actual Results:
creating a new table via Tools SQL works fine, when I klick "Execute"
inserting ONE record into this table afterwards works also fine
~~~~~~~~~~~~~~
create table AND insert record in one transaction brings:
   *SQL error code = -104
   *Token unknown - line 10, column 1
   *INSERT "Error
after "execute"
also "COMMIT" is unknown in such a sequence
~~~~~~~~~~~~~~~~
inserting two records in one transaction also brings:
   *SQL error code = -104
   *Token unknown - line 2, column 1
   *INSERT
~~~~~~~~~~~~~~
inserting two or more records via an EXECUTE BLOCK ...
works fine.

See the attached testcases




Expected Results:
should work as one sequence!
This way it would be possible and easy to create tables, load records and
update by definitions in a textfile.


Reproducible: Always


User Profile Reset: No



Additional Info:
BUILD:

https://gerrit.libreoffice.org/gitweb?p=core.git;a=log;h=17cbc559be6936777904e5cf8a517cac89045264

-- 
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/20201017/fda3a60e/attachment-0001.htm>