Issues when using the Connect storage engine as a condition

CREATE TABLE `dbatest3` (

  `bank_name` varchar(60) NOT NULL,

  `bank_number` varchar(30) DEFAULT NULL,

  `bank_account_name` varchar(80) NOT NULL

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci

;

insert into dbatest3 values ('abc','01','test1'),('def','02','test2'),('ghj','03','test3');

CREATE TABLE CBOEACCT.DBA_BANK_V

(

    BANK_NAME               VARCHAR2(60) NOT NULL,

    BANK_NUMBER             VARCHAR2(30),

    BANK_ACCOUNT_NAME       VARCHAR2(80) NOT NULL

);

insert into DBA_BANK_V values ('abc','01','test1');

insert into DBA_BANK_V values ('def','02','test2');

insert into DBA_BANK_V values ('ghj','03','test3');

commit;

CREATE TABLE `dbatest_Conncet` (

  `BANK_NAME` varchar(60) NOT NULL,

  `BANK_NUMBER` varchar(30) DEFAULT NULL,

  `BANK_ACCOUNT_NAME` varchar(80) NOT NULL

) ENGINE=CONNECT DEFAULT CHARSET=euckr COLLATE=euckr_korean_ci CONNECTION='DSN=TDIA_DIAT;UID=cboeacct;PWD=cboeacct'

`TABLE_TYPE`='ODBC' `TABNAME`='DBA_BANK_V' `DBNAME`='CBOEACCT' `OPTION_LIST`='memory=2';

select * 

from dbatest3                     -- innodb Table

where bank_name not in (

                        select convert(bank_name using UTF8) 

                          from dbatest_Conncet       -- Connect Table

);

 < 0 row result

bank_name|bank_number|bank_account_name|

---------+-----------+-----------------+

update dbatest3                     -- innodb Table

set BANK_ACCOUNT_NAME = 'A'

where bank_name not in (

                        select convert(bank_name using UTF8)      -- Connect Table

                          from dbatest_Conncet 

);

<<<<< 2 Row Updated

Updated Rows	2

Query	update dbatest3          

	set BANK_ACCOUNT_NAME = 'A'

	where bank_name not in (

	                        select convert(bank_name using UTF8) 

	                          from dbatest_Conncet            

	)

Finish time	Wed Mar 13 13:12:21 KST 2024

delete from dbatest3                    -- innodb Table

where bank_name not in (

                        select convert(bank_name using UTF8) 

                          from dbatest_Conncet       -- Connect Table

);

<<<<< 2 Row DELETED

Updated Rows	2

Query	delete from dbatest3

	where bank_name not in (

	                        select convert(bank_name using UTF8) 

	                          from dbatest_Conncet                

	)

Finish time	Wed Mar 13 13:14:06 KST 2024