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
View All Add an attachment (proposed patch, testcase, etc.)

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