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

          Transition Time In Source Status Execution Times
          Olivier Bertrand made transition -
          Open Closed
          		19d 2h 8m 1

          People

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

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.