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

After update to MariaDB 10.4.22, select column return empty value

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Open (View Workflow)
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: 10.4.22
    • Fix Version/s: None
    • Labels:
      None
    • Environment:
      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

            People

            Assignee:
            Unassigned Unassigned
            Reporter:
            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.