Bug 159319 - Functions in Query-GUI: Delete functions, which won't work with internal databases
Summary: Functions in Query-GUI: Delete functions, which won't work with internal data...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Base (show other bugs)
Version:
(earliest affected)
unspecified
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2024-01-22 10:16 UTC by Robert Großkopf
Modified: 2024-02-02 18:03 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:

Attachments
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 Robert Großkopf 2024-01-22 10:16:18 UTC 
Open any Base file.
Go to queries and start to design a query.
There are functions available like

FUSION
INTERSECTION
COLLECT

This functions aren't available in Firebird and HSQLDB. Searching in www and could only find COLLECT for Oracle. Don't know any database, which uses the other functions. 
I would prefer not to show this functions in the selection list. 
Best would be to show only functions, which will work with the chosen database - as it is with creating a table in table GUI for table types.
Comment 1 jcsanz 2024-01-22 12:40:30 UTC 
Totally agree with Robert.

More over, functions FUSION and INTERSECTION need an argument (usually a SELECT) which is not possible to choose or define in the GUI
Comment 2 Longi 2024-01-29 12:00:22 UTC 
I agree too!
Comment 3 Robert Großkopf 2024-01-29 14:17:15 UTC 
Following comment 1 and comment 2 I will set this one to New.
Comment 4 Alex Thurgood 2024-02-02 17:39:46 UTC 
Hi Robert,

Isn't this a DUP of either bug 105112 or bug 105140 ?
Comment 5 Robert Großkopf 2024-02-02 18:03:32 UTC 
(In reply to Alex Thurgood from comment #4)
> Hi Robert,
> 
> Isn't this a DUP of either bug 105112 or bug 105140 ?

The bugs I reported there are about support for this functions. But support of such function couldn't work, because the HSQLDB and Firebird won't support it - also no other database I'm using here and could test.

I would prefer: Solve this bug and I will set the other 2 bugs as Worksforma.