Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.0.19
-
None
-
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
|