Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-8882

CONNECT Engine - Unable to Merge Mutliple SQLite

    Details

      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

        Attachments

          Activity

            People

            • Assignee:
              bertrandop Olivier Bertrand
              Reporter:
              bdarbyso Brandon Darbyson
            • Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: