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)
Version:
(earliest affected)
3.3.4 release
Hardware: Other Linux (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Database-Queries
  Show dependency treegraph
 
Reported: 2013-06-12 16:53 UTC by Terrence Enger
Modified: 2025-07-13 03:11 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


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

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 4.1.0.0.beta2, 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 4.0.4.2 - 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.
Comment 20 QA Administrators 2025-07-13 03:11:10 UTC
Dear Terrence Enger,

To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched for over a year.

There have been thousands of bug fixes and commits since anyone checked on this bug report. During that time, it's possible that the bug has been fixed, or the details of the problem have changed. We'd really appreciate your help in getting confirmation that the bug is still present.

If you have time, please do the following:

Test to see if the bug is still present with the latest version of LibreOffice from https://www.libreoffice.org/download/

If the bug is present, please leave a comment that includes the information from Help - About LibreOffice.
 
If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a comment that includes the information from Help - About LibreOffice.

Please DO NOT

Update the version field
Reply via email (please reply directly on the bug tracker)
Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not 
appropriate in this case)


If you want to do more to help you can test to see if your issue is a REGRESSION. To do so:
1. Download and install oldest version of LibreOffice (usually 3.3 unless your bug pertains to a feature added after 3.3) from https://downloadarchive.documentfoundation.org/libreoffice/old/

2. Test your bug
3. Leave a comment with your results.
4a. If the bug was present with 3.3 - set version to 'inherited from OOo';
4b. If the bug was not present in 3.3 - add 'regression' to keyword


Feel free to come ask questions or to say hello in our QA chat: https://web.libera.chat/?settings=#libreoffice-qa

Thank you for helping us make LibreOffice even better for everyone!

Warm Regards,
QA Team

MassPing-UntouchedBug