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.
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
I agree too!
Following comment 1 and comment 2 I will set this one to New.
Hi Robert, Isn't this a DUP of either bug 105112 or bug 105140 ?
(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.
INTERSECTION is nowhere to be seen Remark: INTERSECT exists but it's a set operator (like UNION, MINUS/EXCEPT) Lionel: at minimum, we can at least remove completely INTERSECTION and FUSION from LO code. About COLLECT, I'd do the same but since it's used by Oracle, perhaps some people would use it in Base. What do you think?