Summary: | RFE: please allow to link tables from different sources into one database file | ||
---|---|---|---|
Product: | LibreOffice | Reporter: | Rolf Leggewie <bugs.freedesktop.org> |
Component: | Database | Assignee: | Not Assigned <libreoffice-bugs> |
Status: | NEW --- | QA Contact: | |
Severity: | enhancement | ||
Priority: | medium | CC: | iplaw67, lionel, robert |
Version: | 3.6.0.4 release | ||
Hardware: | All | ||
OS: | All | ||
See Also: | https://issues.apache.org/ooo/show_bug.cgi?id=42464 | ||
Whiteboard: | |||
i915 platform: | i915 features: |
Description
Rolf Leggewie
2012-10-20 19:17:38 UTC
How should this work: Two databases of different engines in one view? How do you think a query could be created? How should Base create queries with any function? Example: When you concatenate three fields you could get this with hsqld with the following code: 1)"field1"||"field2"||"field3" 2)"field1"+"field2"+"field3" 3)CONCAT(CONCAT("field1","field2"),"field3") ... and now try with MySQL. Concat in MySQL works with more than 2 fields. Another function, called CONCAT_WS, adds delimiter. ... You could open two databases. You could copy data from one to the other. Then queries could work right. If you wish an enhancement, please set the Importance to enhancement. I set this bug to new, because it isn't realised yet. Could be a long discussion, if it could be realised at all. Robert, thank you for your comments here and in my other tickets. Yes, it's an enhancement (see the word RFE in the title). I have no real idea how this plays along with current LO internals. Conceptually, there should be no problem, Access already does this apparently (see OOo ticket 42464) Adding self to CC if not already on |
Use of freedesktop.org services, including Bugzilla, is subject to our Code of Conduct. How we collect and use information is described in our Privacy Policy.