[Libreoffice-bugs] [Bug 144949] New: firebird_sdbc error: when opening a form with Libre base 7.2.1

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 144949
           Summary: firebird_sdbc error: when opening a form with Libre
                    base 7.2.1
           Product: LibreOffice
           Version: 7.2.1.2 release
          Hardware: Other
                OS: Windows (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Base
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: zmds at gmx.de

Description:
Opening a form
getting error: 
Der Inhalt eines Kombinations- oder Listenfeldes konnte nicht ermittelt werden.
firebird_sdbc error:
*Unrecognized C++ exception
caused by
'SELECT DISTINCT "Lagerort" FROM "Lagerort"'


For one field a list should be shown out of an other table

Field Properties:   
Daten:   Lagerort
Art des Listeninhalts: Tabelle
Tabelle: Lagerort    (This table contains the items to be shown in the list


Now changing "Art des Listeninhalts" to:   SQL
and Listeninhalt to:   select Lagerort from Lagerort



Now the form works fine again.
I have the impression the the "DISTINCT" is causing the error above


database content as well as forms where done with former Libre Base versions
about three years ago.
Form works just fine with Libre Base 7.1.6

Steps to Reproduce:
1.start base
2.open form
3.

Actual Results:
see description

Expected Results:
List to be shown in form field respectively form should open without error


Reproducible: Always


User Profile Reset: No



Additional Info:
Version: 7.2.1.2 (x64) / LibreOffice Community
Build ID: 87b77fad49947c1441b67c559c339af8f3517e22
CPU threads: 4; OS: Windows 10.0 Build 19043; UI render: Skia/Vulkan; VCL: win
Locale: de-DE (de_DE); UI: de-DE
Calc: threaded

-- 
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/20211005/08b19320/attachment-0001.htm>