[MDEV-27055] ENGINE = CONNECT Created: 2021-11-15  Updated: 2022-01-25  Resolved: 2021-11-26

Status: Closed
Project: MariaDB Server
Component/s: Storage Engine - Connect
Affects Version/s: 10.2.41, 10.3.32, 10.4.22, 10.5.13
Fix Version/s: 10.2.42, 10.3.33, 10.4.23, 10.5.14, 10.6.6, 10.7.2

Type: Bug Priority: Critical
Reporter: Sergii Volikov Assignee: Olivier Bertrand
Resolution: Fixed Votes: 0
Labels: Connect-Engine
Environment:

ODBC table type

Attachments: File my.ini    
Issue Links:
Duplicate
is duplicated by MDEV-27285 CONNECT ODBC : not reliable anymore Closed

 Description   

UPDATE 10.5.12 to 10.5.13.

CREATE TABLE pult_boxmdu (
 
  id int(11) NOT NULL,
 
  region_ID int(11) NOT NULL,
 
  PRIMARY KEY (id)
 
)
 
ENGINE = CONNECT,
 
TABLE_TYPE = ODBC,
 
TABNAME = 'pult_boxmdu',
 
READONLY = 1,
 
CHARACTER SET cp1251,
 
COLLATE cp1251_ukrainian_ci,
 
CONNECTION = 'DSN=Odyssey';
 
 
 
run SELECT id, region_ID FROM pult_boxmdu;
 
OUT:
 
id	region_ID
 
14	3
 
8	3
 
26	3
 
712	2
 
22	3
 
 
 
SELECT region_ID FROM pult_boxmdu;
 
region_ID
 
0
 
0
 
0
 
0
 
0

Why "0? How to solve?

 Comments   
Comment by Sergii Volikov [ 2021-11-15 ] 

SELECT * FROM pult_boxmdu WHERE region_id = 3;

id region_ID
14 3
8 3
26 3
22 3
....

SELECT region_id FROM pult_boxmdu WHERE region_id = 3;

Records not!

Comment by Sergii Volikov [ 2021-11-15 ] 

SELECT COUNT(id) cnt FROM pult_boxmdu WHERE region_id > 0;

cnt = 712

SELECT COUNT(region_id) cnt FROM pult_boxmdu WHERE region_id > 0;

cnt = 0

Comment by Sergii Volikov [ 2021-11-16 ]

Table pult_boxmdu in DB PostgreSql 

CREATE TABLE "pult_boxmdu" (
 
	"id" INTEGER NOT NULL DEFAULT 'nextval(''pult_boxmdu_id_seq''::regclass)',
 
	"external_id" INTEGER NOT NULL,
 
	"msan" VARCHAR(32) NOT NULL,
 
	"msan_name" VARCHAR(64) NOT NULL,
 
	"msan_ip" VARCHAR(15) NOT NULL,
 
	"msan_addr" VARCHAR(255) NOT NULL,
 
	"extend" VARCHAR(32) NOT NULL,
 
	"eq_id" VARCHAR(15) NULL DEFAULT NULL,
 
	"ring" VARCHAR(8) NOT NULL,
 
	"region_id" INTEGER NOT NULL,
 
	"blocked" BOOLEAN NOT NULL,
 
	"psswd" VARCHAR(64) NULL DEFAULT NULL,
 
	"uname" VARCHAR(64) NULL DEFAULT NULL,
 
	"broken" BOOLEAN NOT NULL,
 
	"protocol" VARCHAR(16) NOT NULL,
 
	PRIMARY KEY ("id"),
 
	INDEX "pult_boxmdu_region_id_dea02e3b" ("region_id")
 
);

Comment by Alice Sherepa [ 2021-11-16 ]

just a quick check - "SELECT SQL_NO_CACHE region_ID FROM pult_boxmdu; " is it returning wrong results also? Please add also your .cnf file(s)

Comment by Sergii Volikov [ 2021-11-17 ]

region_ID
0
0
0
0
0

Comment by Olivier Bertrand [ 2021-11-26 ]

Was a regression from MDEV-24493 last fix only applying to last versions.

Generated at Thu Feb 08 09:50:00 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.