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

After update to MariaDB 10.4.22, select column return empty value

Details

    • Bug
    • Status: Open (View Workflow)
    • Major
    • Resolution: Unresolved
    • 10.4.22
    • None
    • Storage Engine - Connect
    • None
    • CentOS Linux release 8.4.2105, unixODBC 2.3.7, oracle-instantclient12.1-odbc, oracle-instantclient12.1-basic, oracle-instantclient12.1-devel, oracle-instantclient112.1-sqlplus

    Description

      Hello,
      after update from MariaDB 10.4.21 to 10.4.22, when i try select some column from remote table on OracleDB over engine connect (odbc), the result of select are empty values. When i select all columns from table (over asterix), so the result of select is right. I don't see any error or warning in log. Before update was all right.

      I did try upgrade MariaDB to 10.5.13 and upgrade oracle instant client to 19.13, but result of select is empty values. Please can you help me, thank you.

      There is my declaration of remote table connected over ODBC:

      CREATE TABLE `XXXX` (
      		 
        `XXXX1` double NOT NULL,
      		 
        `XXXX2` decimal(12,0) DEFAULT NULL,
      		 
        `XXXX3` decimal(12,0) DEFAULT NULL,
      		 
        `XXXX4` decimal(12,0) DEFAULT NULL,
      		 
        `XXXX5` decimal(3,0) NOT NULL,
      		 
        `XXXX6` varchar(10) DEFAULT NULL,
      		 
        `XXXX7` varchar(6) NOT NULL,
      		 
        `XXXX8` varchar(16) NOT NULL,
      		 
        `XXXX9` varchar(6) DEFAULT NULL,
      		 
        `XXXX10` varchar(16) DEFAULT NULL,
      		 
        `XXXX11` varchar(12) DEFAULT NULL,
      		 
        `XXXX12` varchar(200) DEFAULT NULL,
      		 
        `XXXX13` varchar(200) DEFAULT NULL,
      		 
        `XXXX14` varchar(200) DEFAULT NULL,
      		 
        `XXXX15` varchar(200) DEFAULT NULL,
      		 
        `XXXX16` varchar(1) NOT NULL,
      		 
        `XXXX17` varchar(1) NOT NULL,
      		 
        `XXXX18` decimal(5,1) NOT NULL,
      		 
        `XXXX19` varchar(4000) DEFAULT NULL,
      		 
        `XXXX20` double DEFAULT NULL,
      		 
        `XXXX21` double DEFAULT NULL,
      		 
        `XXXX22` double DEFAULT NULL,
      		 
        `XXXX23` double DEFAULT NULL,
      		 
        `XXXX24` varchar(1) NOT NULL,
      		 
        `XXXX25` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
      		 
        `XXXX26` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
      		 
        `XXXX27` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
      		 
        `XXXX28` varchar(2) DEFAULT NULL,
      		 
        `XXXX29` varchar(4000) DEFAULT NULL,
      		 
        `XXXX30` varchar(4000) DEFAULT NULL
      		 
      ) ENGINE=CONNECT DEFAULT CHARSET=utf8 CONNECTION='DSN=XXXX;UID=XXXX;PWD=XXXX' `TABLE_TYPE`='ODBC' `TABNAME`='XXXX' `DATA_CHARSET`='latin2'

      There is select and result:

      MariaDB [yyyy]> select XXXX16 from XXXX LIMIT 10;
      		 
      +---------+
      		 
      | XXXX16    |
      		 
      +---------+
      		 
      |         |
      		 
      |         |
      		 
      |         |
      		 
      |         |
      		 
      |         |
      		 
      |         |
      		 
      |         |
      		 
      |         |
      		 
      |         |
      		 
      |         |
      		 
      +---------+
      		 
      10 rows in set (0.064 sec)

      Attachments

        Activity

          Ascending order - Click to sort in descending order
          stachura Martin Stachura created issue -
          serg Sergei Golubchik made changes -
          Field Original Value New Value
          Description Hello,
          after update from MariaDB 10.4.21 to 10.4.22, when i try select some column from remote table on OracleDB over engine connect (odbc), the result of select are empty values. When i select all columns from table (over asterix), so the result of select is right. I don't see any error or warning in log. Before update was all right.

          I did try upgrade MariaDB to 10.5.13 and upgrade oracle instant client to 19.13, but result of select is empty values. Please can you help me, thank you.

          There is my declaration of remote table connected over ODBC:
          CREATE TABLE `XXXX` (
            `XXXX1` double NOT NULL,
            `XXXX2` decimal(12,0) DEFAULT NULL,
            `XXXX3` decimal(12,0) DEFAULT NULL,
            `XXXX4` decimal(12,0) DEFAULT NULL,
            `XXXX5` decimal(3,0) NOT NULL,
            `XXXX6` varchar(10) DEFAULT NULL,
            `XXXX7` varchar(6) NOT NULL,
            `XXXX8` varchar(16) NOT NULL,
            `XXXX9` varchar(6) DEFAULT NULL,
            `XXXX10` varchar(16) DEFAULT NULL,
            `XXXX11` varchar(12) DEFAULT NULL,
            `XXXX12` varchar(200) DEFAULT NULL,
            `XXXX13` varchar(200) DEFAULT NULL,
            `XXXX14` varchar(200) DEFAULT NULL,
            `XXXX15` varchar(200) DEFAULT NULL,
            `XXXX16` varchar(1) NOT NULL,
            `XXXX17` varchar(1) NOT NULL,
            `XXXX18` decimal(5,1) NOT NULL,
            `XXXX19` varchar(4000) DEFAULT NULL,
            `XXXX20` double DEFAULT NULL,
            `XXXX21` double DEFAULT NULL,
            `XXXX22` double DEFAULT NULL,
            `XXXX23` double DEFAULT NULL,
            `XXXX24` varchar(1) NOT NULL,
            `XXXX25` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
            `XXXX26` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
            `XXXX27` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
            `XXXX28` varchar(2) DEFAULT NULL,
            `XXXX29` varchar(4000) DEFAULT NULL,
            `XXXX30` varchar(4000) DEFAULT NULL
          ) ENGINE=CONNECT DEFAULT CHARSET=utf8 CONNECTION='DSN=XXXX;UID=XXXX;PWD=XXXX' `TABLE_TYPE`='ODBC' `TABNAME`='XXXX' `DATA_CHARSET`='latin2'

          There is select and result:
          MariaDB [xxxx]> select XXXX from XXXX LIMIT 10;
          +---------+
          | xxxx |
          +---------+
          | |
          | |
          | |
          | |
          | |
          | |
          | |
          | |
          | |
          | |
          +---------+
          10 rows in set (0.064 sec)



          		Hello,
          after update from MariaDB 10.4.21 to 10.4.22, when i try select some column from remote table on OracleDB over engine connect (odbc), the result of select are empty values. When i select all columns from table (over asterix), so the result of select is right. I don't see any error or warning in log. Before update was all right.

          I did try upgrade MariaDB to 10.5.13 and upgrade oracle instant client to 19.13, but result of select is empty values. Please can you help me, thank you.

          There is my declaration of remote table connected over ODBC:
          {code:sql}
          CREATE TABLE `XXXX` (
            `XXXX1` double NOT NULL,
            `XXXX2` decimal(12,0) DEFAULT NULL,
            `XXXX3` decimal(12,0) DEFAULT NULL,
            `XXXX4` decimal(12,0) DEFAULT NULL,
            `XXXX5` decimal(3,0) NOT NULL,
            `XXXX6` varchar(10) DEFAULT NULL,
            `XXXX7` varchar(6) NOT NULL,
            `XXXX8` varchar(16) NOT NULL,
            `XXXX9` varchar(6) DEFAULT NULL,
            `XXXX10` varchar(16) DEFAULT NULL,
            `XXXX11` varchar(12) DEFAULT NULL,
            `XXXX12` varchar(200) DEFAULT NULL,
            `XXXX13` varchar(200) DEFAULT NULL,
            `XXXX14` varchar(200) DEFAULT NULL,
            `XXXX15` varchar(200) DEFAULT NULL,
            `XXXX16` varchar(1) NOT NULL,
            `XXXX17` varchar(1) NOT NULL,
            `XXXX18` decimal(5,1) NOT NULL,
            `XXXX19` varchar(4000) DEFAULT NULL,
            `XXXX20` double DEFAULT NULL,
            `XXXX21` double DEFAULT NULL,
            `XXXX22` double DEFAULT NULL,
            `XXXX23` double DEFAULT NULL,
            `XXXX24` varchar(1) NOT NULL,
            `XXXX25` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
            `XXXX26` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
            `XXXX27` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
            `XXXX28` varchar(2) DEFAULT NULL,
            `XXXX29` varchar(4000) DEFAULT NULL,
            `XXXX30` varchar(4000) DEFAULT NULL
          ) ENGINE=CONNECT DEFAULT CHARSET=utf8 CONNECTION='DSN=XXXX;UID=XXXX;PWD=XXXX' `TABLE_TYPE`='ODBC' `TABNAME`='XXXX' `DATA_CHARSET`='latin2'
          {code}
          There is select and result:
          {noformat}
          MariaDB [xxxx]> select XXXX from XXXX LIMIT 10;
          +---------+
          | xxxx |
          +---------+
          | |
          | |
          | |
          | |
          | |
          | |
          | |
          | |
          | |
          | |
          +---------+
          10 rows in set (0.064 sec)
          {noformat}
          serg Sergei Golubchik made changes -
          Description Hello,
          after update from MariaDB 10.4.21 to 10.4.22, when i try select some column from remote table on OracleDB over engine connect (odbc), the result of select are empty values. When i select all columns from table (over asterix), so the result of select is right. I don't see any error or warning in log. Before update was all right.

          I did try upgrade MariaDB to 10.5.13 and upgrade oracle instant client to 19.13, but result of select is empty values. Please can you help me, thank you.

          There is my declaration of remote table connected over ODBC:
          {code:sql}
          CREATE TABLE `XXXX` (
            `XXXX1` double NOT NULL,
            `XXXX2` decimal(12,0) DEFAULT NULL,
            `XXXX3` decimal(12,0) DEFAULT NULL,
            `XXXX4` decimal(12,0) DEFAULT NULL,
            `XXXX5` decimal(3,0) NOT NULL,
            `XXXX6` varchar(10) DEFAULT NULL,
            `XXXX7` varchar(6) NOT NULL,
            `XXXX8` varchar(16) NOT NULL,
            `XXXX9` varchar(6) DEFAULT NULL,
            `XXXX10` varchar(16) DEFAULT NULL,
            `XXXX11` varchar(12) DEFAULT NULL,
            `XXXX12` varchar(200) DEFAULT NULL,
            `XXXX13` varchar(200) DEFAULT NULL,
            `XXXX14` varchar(200) DEFAULT NULL,
            `XXXX15` varchar(200) DEFAULT NULL,
            `XXXX16` varchar(1) NOT NULL,
            `XXXX17` varchar(1) NOT NULL,
            `XXXX18` decimal(5,1) NOT NULL,
            `XXXX19` varchar(4000) DEFAULT NULL,
            `XXXX20` double DEFAULT NULL,
            `XXXX21` double DEFAULT NULL,
            `XXXX22` double DEFAULT NULL,
            `XXXX23` double DEFAULT NULL,
            `XXXX24` varchar(1) NOT NULL,
            `XXXX25` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
            `XXXX26` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
            `XXXX27` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
            `XXXX28` varchar(2) DEFAULT NULL,
            `XXXX29` varchar(4000) DEFAULT NULL,
            `XXXX30` varchar(4000) DEFAULT NULL
          ) ENGINE=CONNECT DEFAULT CHARSET=utf8 CONNECTION='DSN=XXXX;UID=XXXX;PWD=XXXX' `TABLE_TYPE`='ODBC' `TABNAME`='XXXX' `DATA_CHARSET`='latin2'
          {code}
          There is select and result:
          {noformat}
          MariaDB [xxxx]> select XXXX from XXXX LIMIT 10;
          +---------+
          | xxxx |
          +---------+
          | |
          | |
          | |
          | |
          | |
          | |
          | |
          | |
          | |
          | |
          +---------+
          10 rows in set (0.064 sec)
          {noformat}           		Hello,
          after update from MariaDB 10.4.21 to 10.4.22, when i try select some column from remote table on OracleDB over engine connect (odbc), the result of select are empty values. When i select all columns from table (over asterix), so the result of select is right. I don't see any error or warning in log. Before update was all right.

          I did try upgrade MariaDB to 10.5.13 and upgrade oracle instant client to 19.13, but result of select is empty values. Please can you help me, thank you.

          There is my declaration of remote table connected over ODBC:
          {code:sql}
          CREATE TABLE `XXXX` (
            `XXXX1` double NOT NULL,
            `XXXX2` decimal(12,0) DEFAULT NULL,
            `XXXX3` decimal(12,0) DEFAULT NULL,
            `XXXX4` decimal(12,0) DEFAULT NULL,
            `XXXX5` decimal(3,0) NOT NULL,
            `XXXX6` varchar(10) DEFAULT NULL,
            `XXXX7` varchar(6) NOT NULL,
            `XXXX8` varchar(16) NOT NULL,
            `XXXX9` varchar(6) DEFAULT NULL,
            `XXXX10` varchar(16) DEFAULT NULL,
            `XXXX11` varchar(12) DEFAULT NULL,
            `XXXX12` varchar(200) DEFAULT NULL,
            `XXXX13` varchar(200) DEFAULT NULL,
            `XXXX14` varchar(200) DEFAULT NULL,
            `XXXX15` varchar(200) DEFAULT NULL,
            `XXXX16` varchar(1) NOT NULL,
            `XXXX17` varchar(1) NOT NULL,
            `XXXX18` decimal(5,1) NOT NULL,
            `XXXX19` varchar(4000) DEFAULT NULL,
            `XXXX20` double DEFAULT NULL,
            `XXXX21` double DEFAULT NULL,
            `XXXX22` double DEFAULT NULL,
            `XXXX23` double DEFAULT NULL,
            `XXXX24` varchar(1) NOT NULL,
            `XXXX25` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
            `XXXX26` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
            `XXXX27` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
            `XXXX28` varchar(2) DEFAULT NULL,
            `XXXX29` varchar(4000) DEFAULT NULL,
            `XXXX30` varchar(4000) DEFAULT NULL
          ) ENGINE=CONNECT DEFAULT CHARSET=utf8 CONNECTION='DSN=XXXX;UID=XXXX;PWD=XXXX' `TABLE_TYPE`='ODBC' `TABNAME`='XXXX' `DATA_CHARSET`='latin2'
          {code}
          There is select and result:
          {noformat}
          MariaDB [xxxx]> select XXXX from XXXX LIMIT 10;
          +---------+
          | xxxx |
          +---------+
          | |
          | |
          | |
          | |
          | |
          | |
          | |
          | |
          | |
          | |
          +---------+
          10 rows in set (0.064 sec)
          {noformat}
          stachura Martin Stachura made changes -
          Description Hello,
          after update from MariaDB 10.4.21 to 10.4.22, when i try select some column from remote table on OracleDB over engine connect (odbc), the result of select are empty values. When i select all columns from table (over asterix), so the result of select is right. I don't see any error or warning in log. Before update was all right.

          I did try upgrade MariaDB to 10.5.13 and upgrade oracle instant client to 19.13, but result of select is empty values. Please can you help me, thank you.

          There is my declaration of remote table connected over ODBC:
          {code:sql}
          CREATE TABLE `XXXX` (
            `XXXX1` double NOT NULL,
            `XXXX2` decimal(12,0) DEFAULT NULL,
            `XXXX3` decimal(12,0) DEFAULT NULL,
            `XXXX4` decimal(12,0) DEFAULT NULL,
            `XXXX5` decimal(3,0) NOT NULL,
            `XXXX6` varchar(10) DEFAULT NULL,
            `XXXX7` varchar(6) NOT NULL,
            `XXXX8` varchar(16) NOT NULL,
            `XXXX9` varchar(6) DEFAULT NULL,
            `XXXX10` varchar(16) DEFAULT NULL,
            `XXXX11` varchar(12) DEFAULT NULL,
            `XXXX12` varchar(200) DEFAULT NULL,
            `XXXX13` varchar(200) DEFAULT NULL,
            `XXXX14` varchar(200) DEFAULT NULL,
            `XXXX15` varchar(200) DEFAULT NULL,
            `XXXX16` varchar(1) NOT NULL,
            `XXXX17` varchar(1) NOT NULL,
            `XXXX18` decimal(5,1) NOT NULL,
            `XXXX19` varchar(4000) DEFAULT NULL,
            `XXXX20` double DEFAULT NULL,
            `XXXX21` double DEFAULT NULL,
            `XXXX22` double DEFAULT NULL,
            `XXXX23` double DEFAULT NULL,
            `XXXX24` varchar(1) NOT NULL,
            `XXXX25` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
            `XXXX26` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
            `XXXX27` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
            `XXXX28` varchar(2) DEFAULT NULL,
            `XXXX29` varchar(4000) DEFAULT NULL,
            `XXXX30` varchar(4000) DEFAULT NULL
          ) ENGINE=CONNECT DEFAULT CHARSET=utf8 CONNECTION='DSN=XXXX;UID=XXXX;PWD=XXXX' `TABLE_TYPE`='ODBC' `TABNAME`='XXXX' `DATA_CHARSET`='latin2'
          {code}
          There is select and result:
          {noformat}
          MariaDB [xxxx]> select XXXX from XXXX LIMIT 10;
          +---------+
          | xxxx |
          +---------+
          | |
          | |
          | |
          | |
          | |
          | |
          | |
          | |
          | |
          | |
          +---------+
          10 rows in set (0.064 sec)
          {noformat}           		Hello,
          after update from MariaDB 10.4.21 to 10.4.22, when i try select some column from remote table on OracleDB over engine connect (odbc), the result of select are empty values. When i select all columns from table (over asterix), so the result of select is right. I don't see any error or warning in log. Before update was all right.

          I did try upgrade MariaDB to 10.5.13 and upgrade oracle instant client to 19.13, but result of select is empty values. Please can you help me, thank you.

          There is my declaration of remote table connected over ODBC:
          {code:sql}
          CREATE TABLE `XXXX` (
            `XXXX1` double NOT NULL,
            `XXXX2` decimal(12,0) DEFAULT NULL,
            `XXXX3` decimal(12,0) DEFAULT NULL,
            `XXXX4` decimal(12,0) DEFAULT NULL,
            `XXXX5` decimal(3,0) NOT NULL,
            `XXXX6` varchar(10) DEFAULT NULL,
            `XXXX7` varchar(6) NOT NULL,
            `XXXX8` varchar(16) NOT NULL,
            `XXXX9` varchar(6) DEFAULT NULL,
            `XXXX10` varchar(16) DEFAULT NULL,
            `XXXX11` varchar(12) DEFAULT NULL,
            `XXXX12` varchar(200) DEFAULT NULL,
            `XXXX13` varchar(200) DEFAULT NULL,
            `XXXX14` varchar(200) DEFAULT NULL,
            `XXXX15` varchar(200) DEFAULT NULL,
            `XXXX16` varchar(1) NOT NULL,
            `XXXX17` varchar(1) NOT NULL,
            `XXXX18` decimal(5,1) NOT NULL,
            `XXXX19` varchar(4000) DEFAULT NULL,
            `XXXX20` double DEFAULT NULL,
            `XXXX21` double DEFAULT NULL,
            `XXXX22` double DEFAULT NULL,
            `XXXX23` double DEFAULT NULL,
            `XXXX24` varchar(1) NOT NULL,
            `XXXX25` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
            `XXXX26` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
            `XXXX27` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
            `XXXX28` varchar(2) DEFAULT NULL,
            `XXXX29` varchar(4000) DEFAULT NULL,
            `XXXX30` varchar(4000) DEFAULT NULL
          ) ENGINE=CONNECT DEFAULT CHARSET=utf8 CONNECTION='DSN=XXXX;UID=XXXX;PWD=XXXX' `TABLE_TYPE`='ODBC' `TABNAME`='XXXX' `DATA_CHARSET`='latin2'
          {code}

          There is select and result:
          {noformat}
          MariaDB [xxxx]> select XXXX16 from XXXX LIMIT 10;
          +---------+
          | xxxx16 |
          +---------+
          | |
          | |
          | |
          | |
          | |
          | |
          | |
          | |
          | |
          | |
          +---------+
          10 rows in set (0.064 sec)
          {noformat}
          stachura Martin Stachura made changes -
          Description Hello,
          after update from MariaDB 10.4.21 to 10.4.22, when i try select some column from remote table on OracleDB over engine connect (odbc), the result of select are empty values. When i select all columns from table (over asterix), so the result of select is right. I don't see any error or warning in log. Before update was all right.

          I did try upgrade MariaDB to 10.5.13 and upgrade oracle instant client to 19.13, but result of select is empty values. Please can you help me, thank you.

          There is my declaration of remote table connected over ODBC:
          {code:sql}
          CREATE TABLE `XXXX` (
            `XXXX1` double NOT NULL,
            `XXXX2` decimal(12,0) DEFAULT NULL,
            `XXXX3` decimal(12,0) DEFAULT NULL,
            `XXXX4` decimal(12,0) DEFAULT NULL,
            `XXXX5` decimal(3,0) NOT NULL,
            `XXXX6` varchar(10) DEFAULT NULL,
            `XXXX7` varchar(6) NOT NULL,
            `XXXX8` varchar(16) NOT NULL,
            `XXXX9` varchar(6) DEFAULT NULL,
            `XXXX10` varchar(16) DEFAULT NULL,
            `XXXX11` varchar(12) DEFAULT NULL,
            `XXXX12` varchar(200) DEFAULT NULL,
            `XXXX13` varchar(200) DEFAULT NULL,
            `XXXX14` varchar(200) DEFAULT NULL,
            `XXXX15` varchar(200) DEFAULT NULL,
            `XXXX16` varchar(1) NOT NULL,
            `XXXX17` varchar(1) NOT NULL,
            `XXXX18` decimal(5,1) NOT NULL,
            `XXXX19` varchar(4000) DEFAULT NULL,
            `XXXX20` double DEFAULT NULL,
            `XXXX21` double DEFAULT NULL,
            `XXXX22` double DEFAULT NULL,
            `XXXX23` double DEFAULT NULL,
            `XXXX24` varchar(1) NOT NULL,
            `XXXX25` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
            `XXXX26` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
            `XXXX27` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
            `XXXX28` varchar(2) DEFAULT NULL,
            `XXXX29` varchar(4000) DEFAULT NULL,
            `XXXX30` varchar(4000) DEFAULT NULL
          ) ENGINE=CONNECT DEFAULT CHARSET=utf8 CONNECTION='DSN=XXXX;UID=XXXX;PWD=XXXX' `TABLE_TYPE`='ODBC' `TABNAME`='XXXX' `DATA_CHARSET`='latin2'
          {code}

          There is select and result:
          {noformat}
          MariaDB [xxxx]> select XXXX16 from XXXX LIMIT 10;
          +---------+
          | xxxx16 |
          +---------+
          | |
          | |
          | |
          | |
          | |
          | |
          | |
          | |
          | |
          | |
          +---------+
          10 rows in set (0.064 sec)
          {noformat}           		Hello,
          after update from MariaDB 10.4.21 to 10.4.22, when i try select some column from remote table on OracleDB over engine connect (odbc), the result of select are empty values. When i select all columns from table (over asterix), so the result of select is right. I don't see any error or warning in log. Before update was all right.

          I did try upgrade MariaDB to 10.5.13 and upgrade oracle instant client to 19.13, but result of select is empty values. Please can you help me, thank you.

          There is my declaration of remote table connected over ODBC:
          {code:sql}
          CREATE TABLE `XXXX` (
            `XXXX1` double NOT NULL,
            `XXXX2` decimal(12,0) DEFAULT NULL,
            `XXXX3` decimal(12,0) DEFAULT NULL,
            `XXXX4` decimal(12,0) DEFAULT NULL,
            `XXXX5` decimal(3,0) NOT NULL,
            `XXXX6` varchar(10) DEFAULT NULL,
            `XXXX7` varchar(6) NOT NULL,
            `XXXX8` varchar(16) NOT NULL,
            `XXXX9` varchar(6) DEFAULT NULL,
            `XXXX10` varchar(16) DEFAULT NULL,
            `XXXX11` varchar(12) DEFAULT NULL,
            `XXXX12` varchar(200) DEFAULT NULL,
            `XXXX13` varchar(200) DEFAULT NULL,
            `XXXX14` varchar(200) DEFAULT NULL,
            `XXXX15` varchar(200) DEFAULT NULL,
            `XXXX16` varchar(1) NOT NULL,
            `XXXX17` varchar(1) NOT NULL,
            `XXXX18` decimal(5,1) NOT NULL,
            `XXXX19` varchar(4000) DEFAULT NULL,
            `XXXX20` double DEFAULT NULL,
            `XXXX21` double DEFAULT NULL,
            `XXXX22` double DEFAULT NULL,
            `XXXX23` double DEFAULT NULL,
            `XXXX24` varchar(1) NOT NULL,
            `XXXX25` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
            `XXXX26` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
            `XXXX27` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
            `XXXX28` varchar(2) DEFAULT NULL,
            `XXXX29` varchar(4000) DEFAULT NULL,
            `XXXX30` varchar(4000) DEFAULT NULL
          ) ENGINE=CONNECT DEFAULT CHARSET=utf8 CONNECTION='DSN=XXXX;UID=XXXX;PWD=XXXX' `TABLE_TYPE`='ODBC' `TABNAME`='XXXX' `DATA_CHARSET`='latin2'
          {code}

          There is select and result:
          {noformat}
          MariaDB [yyyy]> select XXXX16 from XXXX LIMIT 10;
          +---------+
          | xxxx16 |
          +---------+
          | |
          | |
          | |
          | |
          | |
          | |
          | |
          | |
          | |
          | |
          +---------+
          10 rows in set (0.064 sec)
          {noformat}
          stachura Martin Stachura made changes -
          Description Hello,
          after update from MariaDB 10.4.21 to 10.4.22, when i try select some column from remote table on OracleDB over engine connect (odbc), the result of select are empty values. When i select all columns from table (over asterix), so the result of select is right. I don't see any error or warning in log. Before update was all right.

          I did try upgrade MariaDB to 10.5.13 and upgrade oracle instant client to 19.13, but result of select is empty values. Please can you help me, thank you.

          There is my declaration of remote table connected over ODBC:
          {code:sql}
          CREATE TABLE `XXXX` (
            `XXXX1` double NOT NULL,
            `XXXX2` decimal(12,0) DEFAULT NULL,
            `XXXX3` decimal(12,0) DEFAULT NULL,
            `XXXX4` decimal(12,0) DEFAULT NULL,
            `XXXX5` decimal(3,0) NOT NULL,
            `XXXX6` varchar(10) DEFAULT NULL,
            `XXXX7` varchar(6) NOT NULL,
            `XXXX8` varchar(16) NOT NULL,
            `XXXX9` varchar(6) DEFAULT NULL,
            `XXXX10` varchar(16) DEFAULT NULL,
            `XXXX11` varchar(12) DEFAULT NULL,
            `XXXX12` varchar(200) DEFAULT NULL,
            `XXXX13` varchar(200) DEFAULT NULL,
            `XXXX14` varchar(200) DEFAULT NULL,
            `XXXX15` varchar(200) DEFAULT NULL,
            `XXXX16` varchar(1) NOT NULL,
            `XXXX17` varchar(1) NOT NULL,
            `XXXX18` decimal(5,1) NOT NULL,
            `XXXX19` varchar(4000) DEFAULT NULL,
            `XXXX20` double DEFAULT NULL,
            `XXXX21` double DEFAULT NULL,
            `XXXX22` double DEFAULT NULL,
            `XXXX23` double DEFAULT NULL,
            `XXXX24` varchar(1) NOT NULL,
            `XXXX25` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
            `XXXX26` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
            `XXXX27` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
            `XXXX28` varchar(2) DEFAULT NULL,
            `XXXX29` varchar(4000) DEFAULT NULL,
            `XXXX30` varchar(4000) DEFAULT NULL
          ) ENGINE=CONNECT DEFAULT CHARSET=utf8 CONNECTION='DSN=XXXX;UID=XXXX;PWD=XXXX' `TABLE_TYPE`='ODBC' `TABNAME`='XXXX' `DATA_CHARSET`='latin2'
          {code}

          There is select and result:
          {noformat}
          MariaDB [yyyy]> select XXXX16 from XXXX LIMIT 10;
          +---------+
          | xxxx16 |
          +---------+
          | |
          | |
          | |
          | |
          | |
          | |
          | |
          | |
          | |
          | |
          +---------+
          10 rows in set (0.064 sec)
          {noformat}           		Hello,
          after update from MariaDB 10.4.21 to 10.4.22, when i try select some column from remote table on OracleDB over engine connect (odbc), the result of select are empty values. When i select all columns from table (over asterix), so the result of select is right. I don't see any error or warning in log. Before update was all right.

          I did try upgrade MariaDB to 10.5.13 and upgrade oracle instant client to 19.13, but result of select is empty values. Please can you help me, thank you.

          There is my declaration of remote table connected over ODBC:
          {code:sql}
          CREATE TABLE `XXXX` (
            `XXXX1` double NOT NULL,
            `XXXX2` decimal(12,0) DEFAULT NULL,
            `XXXX3` decimal(12,0) DEFAULT NULL,
            `XXXX4` decimal(12,0) DEFAULT NULL,
            `XXXX5` decimal(3,0) NOT NULL,
            `XXXX6` varchar(10) DEFAULT NULL,
            `XXXX7` varchar(6) NOT NULL,
            `XXXX8` varchar(16) NOT NULL,
            `XXXX9` varchar(6) DEFAULT NULL,
            `XXXX10` varchar(16) DEFAULT NULL,
            `XXXX11` varchar(12) DEFAULT NULL,
            `XXXX12` varchar(200) DEFAULT NULL,
            `XXXX13` varchar(200) DEFAULT NULL,
            `XXXX14` varchar(200) DEFAULT NULL,
            `XXXX15` varchar(200) DEFAULT NULL,
            `XXXX16` varchar(1) NOT NULL,
            `XXXX17` varchar(1) NOT NULL,
            `XXXX18` decimal(5,1) NOT NULL,
            `XXXX19` varchar(4000) DEFAULT NULL,
            `XXXX20` double DEFAULT NULL,
            `XXXX21` double DEFAULT NULL,
            `XXXX22` double DEFAULT NULL,
            `XXXX23` double DEFAULT NULL,
            `XXXX24` varchar(1) NOT NULL,
            `XXXX25` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
            `XXXX26` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
            `XXXX27` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
            `XXXX28` varchar(2) DEFAULT NULL,
            `XXXX29` varchar(4000) DEFAULT NULL,
            `XXXX30` varchar(4000) DEFAULT NULL
          ) ENGINE=CONNECT DEFAULT CHARSET=utf8 CONNECTION='DSN=XXXX;UID=XXXX;PWD=XXXX' `TABLE_TYPE`='ODBC' `TABNAME`='XXXX' `DATA_CHARSET`='latin2'
          {code}

          There is select and result:
          {noformat}
          MariaDB [yyyy]> select XXXX16 from XXXX LIMIT 10;
          +---------+
          | XXXX16 |
          +---------+
          | |
          | |
          | |
          | |
          | |
          | |
          | |
          | |
          | |
          | |
          +---------+
          10 rows in set (0.064 sec)
          {noformat}
          stachura Martin Stachura made changes -
          Priority Minor [ 4 ] Major [ 3 ]
          serg Sergei Golubchik made changes -
          Workflow MariaDB v3 [ 127398 ] MariaDB v4 [ 143341 ]

          People

            Unassigned Unassigned
            stachura Martin Stachura
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:

              Git Integration

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