Details
-
Bug
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.4.22
-
None
-
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)
|