Bug 56234

Summary: RFE: please allow to link tables from different sources into one database file
Product: LibreOffice Reporter: Rolf Leggewie <bugs.freedesktop.org>
Component: BaseAssignee: Not Assigned <libreoffice-bugs>
Status: NEW ---    
Severity: enhancement CC: iplaw67, lionel, lo_bugs, robert
Priority: medium    
Version: 3.6.0.4 release   
Hardware: All   
OS: All   
See Also: https://issues.apache.org/ooo/show_bug.cgi?id=42464
Whiteboard:
Crash report or crash signature: Regression By:
Bug Depends on:    
Bug Blocks: 104790, 120255    

Description Rolf Leggewie 2012-10-20 19:17:38 UTC 
This is a copy of the request in IZ: https://issues.apache.org/ooo/show_bug.cgi?id=42464

One feature that is lacking in DB support is to access data in more than one external database.  A user might want to access both an Sqlite and MySQL database at the same time and consolidate their data for evaluation in Base.

Please kindly consider this RFE to make Base even more of a professional product.
Comment 1 Robert Großkopf 2012-10-24 20:08:46 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.
Comment 2 Rolf Leggewie 2012-10-25 00:09:15 UTC 
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)
Comment 3 Alex Thurgood 2015-01-03 17:38:50 UTC Comment hidden (no-value)