[Libreoffice-bugs] [Bug 122461] New: SQL error with Query Wizard

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 122461
           Summary: SQL error with Query Wizard
           Product: LibreOffice
           Version: 6.1.3.2 release
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Base
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: realitix at gmail.com

Created attachment 147992
  --> https://bugs.documentfoundation.org/attachment.cgi?id=147992&action=edit
test file

Hello,

When using the Query Wizard, there is a SQL exception.
Here the steps to reproduce:

1 - Download the attached spreedsheet "data-test.ods"
2 - Open Base > Connect to an existing database > Spreadsheet
3 - Select the data-test.ods and create the database
4 - Select Queries > Use Wizard to Create Query
5 - Double Click on "Contrat" in "Available fields", "Contrat" moves to "Fields
in the Query"
6 - Click on Finish
-> You get the SQL error

The error appears only with the fields "Contrat" and "Service d'affectation".
For the others fields, there are no SQL exception.

Sincerely,
Jean-Sébastien

-- 
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/20190104/98eb11b0/attachment.html>