Bug 65685 - constant in select list querying a spreadsheet yields blanks
Summary: constant in select list querying a spreadsheet yields blanks
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Base (show other bugs)
(earliest affected)
3.3.4 release
Hardware: Other Linux (All)
: medium normal
Assignee: Not Assigned
Depends on:
Blocks: Database-Queries
  Show dependency treegraph
Reported: 2013-06-12 16:53 UTC by Terrence Enger
Modified: 2023-07-13 19:03 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:

image of query result (39.13 KB, image/png)
2013-06-12 16:56 UTC, Terrence Enger
a very small spreadsheet (7.79 KB, application/vnd.oasis.opendocument.spreadsheet)
2013-06-12 16:57 UTC, Terrence Enger
database connecting to that spreadsheet (2.28 KB, application/vnd.oasis.opendocument.database)
2013-06-12 16:57 UTC, Terrence Enger

Note You need to log in before you can comment on or make changes to this bug.
Description Terrence Enger 2013-06-12 16:53:26 UTC
Steps to reproduce

(*) Download the soon-to-be-attached files smallspreadsheet.odt and
    constant_in_select_list.odb to the same directory on your system.

(*) Open constant_in_select_list.odb in LibreOffice.  Program presents
    windown constant_in_select_list.odb.

(*) In Database pane click Queries, and in Queries pane right-click
    query_with_constants.  Program presents pop-up menu.

(*) In pop-up menu, select "Edit in SQL View...".  Program presents
    SQL window showing statement

        SELECT "number", 'x', 12345, "word" FROM "Sheet1"

(*) If the program does not already show a data grid, press <F5>.

    Program action actual: As shown in attached file query_window.png,
    the data grid shows the middle two columns blank.

        number  'x'  12345  word
        ------  ---  -----  ----
        1                   one
        2                   two
        3                   three

    Program action expected: The middle two columns should have
    non-blank (albeit very boring) values.

        number  'x'  12345  word
        ------  ---  -----  ----
        1       x    12345  one
        2       x    12345  two
        3       x    12345  three

I see this behaviour in LibreOffice version 3.3.4 (as delivered with
ubuntu-natty), version, and in a couple of other fairly
recent versions.

I am leaving bug status UNCONFIRMED to encourage testing on other platforms.
Comment 1 Terrence Enger 2013-06-12 16:55:03 UTC
Hey, where did status UNCONFIRMED go?
Comment 2 Terrence Enger 2013-06-12 16:56:16 UTC
Created attachment 80736 [details]
image of query result
Comment 3 Terrence Enger 2013-06-12 16:57:26 UTC
Created attachment 80737 [details]
a very small spreadsheet
Comment 4 Terrence Enger 2013-06-12 16:57:59 UTC
Created attachment 80738 [details]
database connecting to that spreadsheet
Comment 5 Robert Großkopf 2013-06-14 18:09:53 UTC
I an confirm it. My System: Linux 64bit rpm. LO 3.3.4 and LO - both leave the two columns blank. 
If you set up such a query to the internal HSQLDB, it only works right, when you choose "direct SQL". In GUI-Mode the numbers weren't shown.
Comment 6 Terrence Enger 2014-08-14 13:28:24 UTC
I still see the problem with my debug build of master commit 692878e,
fetched 2014-08-13, built and running on debian-wheezy 64-bit.
Comment 7 Alex Thurgood 2015-01-03 17:38:14 UTC Comment hidden (no-value)
Comment 8 QA Administrators 2016-01-17 20:02:14 UTC Comment hidden (obsolete)
Comment 9 Terrence Enger 2016-01-18 14:00:47 UTC
The problem is still present daily dbgutil bibisect version 2016-01-18
running on debian-wheezy chroot'd to debian-sid.
Comment 10 QA Administrators 2017-03-06 13:51:12 UTC Comment hidden (obsolete)
Comment 11 Terrence Enger 2017-03-22 01:51:20 UTC
I still see the problem in daily Linux dbgutil bibisect repository
version 2017-03-21 running on debian-stretch.

Contrary to Robert's experience reported in comment 5, all the columns
have data when I run my query by a double-click in the Queries pane.
Comment 12 QA Administrators 2018-03-23 03:35:04 UTC Comment hidden (obsolete)
Comment 13 Terrence Enger 2018-03-26 17:25:24 UTC
I still see the bug in daily Linux dbgutil bibisect repository version 2018-03-26 running on debian-sid.
Comment 14 QA Administrators 2019-03-27 03:43:00 UTC Comment hidden (obsolete)
Comment 15 Terrence Enger 2019-03-27 13:57:59 UTC
I still see the bug in bibisect-linux-64.6.3 bibisect repository s-h
82463bdd from 2019-03-25.
Comment 16 QA Administrators 2021-06-02 03:47:49 UTC Comment hidden (obsolete)
Comment 17 Terrence Enger 2021-06-20 15:55:38 UTC
I still see the problem in a local build of commit d95e400b
(2021-06-18) built and running on debian-buster.
Comment 18 QA Administrators 2023-06-21 03:13:50 UTC Comment hidden (obsolete)
Comment 19 Terrence Enger 2023-07-13 19:03:22 UTC
In a dbgutil local build of commit f1306e1d (2023-03-08) built and
running on debian-sid, I cannot execute the the query in the SQL
window.  I have no idea why this is so.

Still, I see the two blank "constant" columns in direct the data
window from direct execution of the query.  So, I deem the bug to
still be present.