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)
Version:
(earliest affected)
4.3.7.2 release
Hardware: All All
: high major
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: bibisectRequest, regression
Depends on:
Blocks:
 
Reported: 2017-12-20 18:47 UTC by jorojmaqui
Modified: 2018-11-06 11:03 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Attachments
Query in libreoffice base + sqlite3 odbc have no functions (280.71 KB, application/pdf)
2017-12-20 18:47 UTC, jorojmaqui
Details

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 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