Details
-
Type:
Bug
-
Status: Closed (View Workflow)
-
Priority:
Major
-
Resolution: Fixed
-
Affects Version/s: 10.0.19
-
Component/s: Storage Engine - Connect
-
Labels:None
-
Environment:Centos 7
Description
We're trying to merge two sqlite databases that are similar to those outlined below, and see the following when we try to query the resulting table in MariaDB:
/usr/local/data/SQLiteDB_1.dat < create table users ( id varchar(10), name varchar(24) );
|
-----------------
|
| id | name
|
| f3 | Alice
|
| 6g | Bob
|
/usr/local/data/SQLiteDB_2.dat < create table users( id varchar(10), name varchar(24) );
|
------------------
|
| id | name
|
| s1 | Alison
|
| 9y | Robert
|
MariaDB > create table people ( id varchar(10), name varchar(24) ) ENGINE=CONNECT TABLE_TYPE=ODBC multiple=1 tabname='users' CONNECTION='DSN=SQLite3 Datasource;DBQ=/usr/local/data/SQLiteDB_*.dat;'; |
|
|
MariaDB > select * from people: |
|
|
----------------
|
| id | name |
| f3 | Alice
|
| 6g | Bob
|
| f3 | Alice
|
| 6g | Bob
|