[Libreoffice-bugs] [Bug 113884] Report editor Add Fields bug when Report is based on select all query from an Alias field

[bugzilla-daemon at bugs.documentfoundation.org]

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

--- Comment #2 from Howard Johnson <BridgeportContractor at gmail.com> ---
:-) I love bugs. So I tested again and could NOT make it fail this time (LO
v5.3.3.2/Debian linux 9.2 x64/Cinnamon 3.2.7), ... but not giving up I also
installed v5.4 and re-tested, same result: could not make it fail, (and same on
v5.2).

......Then I tinkered w/ it some more:  Edited Query_Table1 and re-named the
Alias to Txt-Alias2, then Edit 'A Report', and now it fails.

After tinker a bit more the bug is still there.  Here is a full procedure of
steps to re-produce it from scratch on 5.4.  If you can confirm this, I'll
submit this as a brand new, clean verifiable bug report and we can close this
one.  The following procedure shows this in Editing Forms, so it is in both
Forms and Reports.  It does seem to involve the order in which things are done.

--- In short ------------------------------------

0) Open LO 5.4
1) Create a new database
2) Create a table
3) Create 2 queries, the 2nd  one based on the first one
4) Create a new form
5) Edit 2nd query to add an Alias name
6) Edit Form 1 again; change Content to Query2; Add Field -> bug

--- In detail -----------------------------------
0) Open LO Base 5.4

1) Create a new database: HSQLDB; Finish; Name it 'Query bug'

2) Create table in design view
  Field name ID, Int, Primary key, Autovalue Yes
  Field name Txt, Text [Varchar]
Close and save as 'Table1'

3a) Create a query in design view
Tables: Table1; Add; Close
Double click ID
Double click Txt
Close; Save as Query1; Ok

3b) Create query in design view
Queries, Query1; Add; Close
Double click: *
Close; Save as Query2; Ok

4) Create form in design view
Form navigator
Right click on Forms; New: Form
Right click on Form; Properties
Content type: Query
Content: Query 1
Add field
Shows ID, Txt
Close form and save as Form1

5) Edit Query1
Enter 'Txt-Alias' for Txt Alias
Close; Save the changes

6) Edit Form1
Right click on Form; Properties
Change Content to Query2
Click Add Field
Shows: ID, Txt

BUG: Expected it to show: ID, Txt-Alias.

-----------------------


Thanks Robert.

-- 
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/20171117/d2baf1cb/attachment.html>