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

Robert Großkopf <[email protected]> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |[email protected]
             Status|UNCONFIRMED                 |NEW
     Ever confirmed|0                           |1

--- Comment #1 from Robert Großkopf <[email protected]> ---
Would be good to provide an example here.
Have tested this:
Table with on field, which is INTEGER.
SQL in the form: SELECT "ID", "ID" * 3 AD "triple" FROM "Table"
If I choose a form control I will get "MULTIPLY" for this field with internal
Firebird. Will be "triple" with internal HSQLDB.
If I choose "Field add …" of the toolbar for creating forms there will be shown
"triple".

The alias will be also ignored for other fields, not only for fields, which
contain a function. You could write 
SELECT "Name" AS "Forename" From "Table"
and "Name" will be offered for selection in the controls.

This is a special bug of internal Firebird database.

Tested with OpenSUSE 15.3 64bit rpm Linux and LO 7.3.1.3.

-- 
You are receiving this mail because:
You are the assignee for the bug.

Reply via email to