Bug 114602 - Query-Editor: No functions available for Sqlite 3 odbc
Summary: Query-Editor: No functions available for Sqlite 3 odbc
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Base (show other bugs)
(earliest affected) release
Hardware: All All
: high major
Assignee: Not Assigned
Keywords: bibisectRequest, regression
Depends on:
Reported: 2017-12-20 18:47 UTC by jorojmaqui
Modified: 2020-12-10 08:39 UTC (History)
5 users (show)

See Also:
Crash report or crash signature:

Query in libreoffice base + sqlite3 odbc have no functions (280.71 KB, application/pdf)
2017-12-20 18:47 UTC, jorojmaqui
screenshot with functions in Spanish (59.79 KB, image/png)
2019-03-07 13:21 UTC, Julien Nabet
query+no functions (100.54 KB, application/pdf)
2019-03-07 13:58 UTC, jorojmaqui
SQLITE_FUNCIONES_NO_PRESENTE (85.29 KB, application/pdf)
2019-03-08 12:17 UTC, jorojmaqui

Note You need to log in before you can comment on or make changes to this bug.
Description jorojmaqui 2017-12-20 18:47:44 UTC
Created attachment 138554 [details]
Query in libreoffice base + sqlite3 odbc have no functions

Libreoffice base, in queries when requesting the functions of queries such as sum, group, etc. they do not appear when I work with sqlite3 odbc version 3.15.2 and instead in openoffice if I can get the functions.
Comment 1 Robert Großkopf 2017-12-24 10:54:37 UTC
Could confirm the buggy behavior. Couldn't choose any function in queries through GUI. Have to use SQL-mode to use functions.

First version I have found here with this buggy behavior is LO 4.3.7
Last version I have tested here, which will show functions, is LO 4.1.6
So I set this bug to NEW and Keyword "regression".

Tested all with OpenSUSE 64bit rpm Linux.
Comment 2 jorojmaqui 2018-01-18 15:09:33 UTC
This happens with the libreoffice connected to a database sqlite using odbc on Windows 8.1 and Windows XP

The section of functions in the consultations does not appear
Comment 3 Julien Nabet 2019-03-06 15:03:53 UTC
On Win10 + LO 6.1.5, I don't reproduce this.
I can see functions in English UI or in French UI.

Could someone may give a try with a newer LO version?
Comment 4 jorojmaqui 2019-03-07 10:15:26 UTC
WIN10 + LIBREOFFICE in spanish
you do not see the SQLITE functions in the Queries
Comment 5 Julien Nabet 2019-03-07 13:21:49 UTC
Created attachment 149790 [details]
screenshot with functions in Spanish

Screenshot on Win10 + master sources updated today.
Comment 6 jorojmaqui 2019-03-07 13:58:46 UTC
Created attachment 149792 [details]
query+no functions
Comment 7 Julien Nabet 2019-03-07 20:47:59 UTC
jorojmaqui: could you test 2 other things and tell if you reproduce this in these cases:
1) If you use English USA language for UI
(goal is to know if it's related to language)

2) If you create a brand odb file which points on sqlite 3 file and just try to create a simple query
(goal is not undergoing an old buggy odb file due to an old bug on a previous LO  version)
Comment 8 jorojmaqui 2019-03-08 12:17:00 UTC
Created attachment 149821 [details]


Create new database in the interface in English (USA) and I still give the same of the functions within the consultations.
attached pdf file

I have already seen that in Libreoffice version 6.3 of proof it will already be fixed
Comment 9 Julien Nabet 2019-03-08 13:27:49 UTC
Thank you for your new feedback.
Since I don't have more questions and must recognize I'm stuck, I put it back to NEW.
Comment 10 Buovjaga 2019-04-15 06:52:58 UTC
As this is somewhat hard to test (I don't see any ready-made setup provided for us), it would be great if the affected people would try to bibisect this.

Robert could use the Linux repos: https://wiki.documentfoundation.org/QA/Bibisect/Linux

In case the problem appeared between 4.2 and 4.3, jorojmaqui could use the win32-4.3 repository.


Cloning the repo in cygwin shell:

git clone https://git.libreoffice.org/bibisect-win32-4.3

Please also fetch commit notes:

git fetch origin refs/notes/commits:refs/notes/commits

Do regular bibisect with tag oldest and latest, and if you end up on a commit that has a note attached, please do as it says (continue between the tags fixup_oldest and fixup_latest)