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.
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.
This happens with the libreoffice 5.4.4.2 connected to a database sqlite using odbc on Windows 8.1 and Windows XP The section of functions in the consultations does not appear
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?
WIN10 + LIBREOFFICE 6.2.2.1 in spanish you do not see the SQLITE functions in the Queries
Created attachment 149790 [details] screenshot with functions in Spanish Screenshot on Win10 + master sources updated today.
Created attachment 149792 [details] query+no functions
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) ?
Created attachment 149821 [details] SQLITE_FUNCIONES_NO_PRESENTE WINDOWS 10 LIBREOFFICE 6.2.2.1 iNTEFACE OF ENGLISH USERS (EEUU) 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
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.
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. https://wiki.documentfoundation.org/QA/Bibisect/Windows 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)
Dear jorojmaqui, 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
For future testers: https://wiki.documentfoundation.org/Documentation/HowTo/Base/Connect_to_SQLite
bibisected with win32-4.3 36122c27539ae22c3a67fab89ecf1a262074c3b4..754160755adb071f432898978c487aec9c87177d bibisected with linux-43max Version: 4.3.0.0.alpha1+ Build ID: 94a07be5d726de71315f47d24ef9003991d201ad author Lionel Elie Mamane commit 94a07be5d726de71315f47d24ef9003991d201ad odbc: clean up SQL conformance level tests Change-Id: I9c96ee389a086c76489f99750c2c86b7504cd393