Bug 56234 - RFE: please allow to link tables from different sources into one database file
Summary: RFE: please allow to link tables from different sources into one database file
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Base (show other bugs)
Version:
(earliest affected)
3.6.0.4 release
Hardware: All All
: medium enhancement
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Database-Connectivity Base-Enhancements
  Show dependency treegraph
 
Reported: 2012-10-20 19:17 UTC by Rolf Leggewie
Modified: 2018-10-02 07:09 UTC (History)
4 users (show)

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
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 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)