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

CONNECT Engine - Unable to Merge Mutliple SQLite

        Details

        • Type: Bug
        • Status: Open
        • Priority: Major
        • Resolution: Unresolved
        • Affects Version/s: 10.0.19
        • Fix Version/s: None
        • 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

            Gliffy Diagrams

              Attachments

                Activity

                There are no comments yet on this issue.

                  People

                  • Assignee:
                    Unassigned
                    Reporter:
                    bdarbyso Brandon Darbyson
                  • Votes:
                    0 Vote for this issue
                    Watchers:
                    2 Start watching this issue

                    Dates

                    • Created:
                      Updated: