[MDEV-27055] ENGINE = CONNECT - Jira

Details

Type: Bug
Status: Closed (View Workflow)
Priority: Critical
Resolution: Fixed
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
Component/s: Storage Engine - Connect
Labels:
- Connect-Engine
Environment:
ODBC table type

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?

Attachments

- Sort By Name
- Sort By Date
- Ascending
- Descending
- Thumbnails
- List
- Download All

my.ini
1 kB
2021-11-17 07:02

Issue Links

is duplicated by

MDEV-27285 CONNECT ODBC : not reliable anymore

Closed

Activity

Ascending order - Click to sort in descending order

Sergii Volikov created issue - 2021-11-15 18:57

Sergii Volikov added a comment - 2021-11-15 19:22 - edited

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!

Sergii Volikov added a comment - 2021-11-15 19:22 - edited 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!

Sergii Volikov added a comment - 2021-11-15 19:34 - edited

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

Sergii Volikov added a comment - 2021-11-15 19:34 - edited 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

Anel Husakovic made changes - 2021-11-16 08:08

Field	Original Value	New Value
Assignee		Olivier Bertrand [ bertrandop ]

Anel Husakovic made changes - 2021-11-16 08:21

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

run SELECT region_ID FROM pult_boxmdu;
OUT:
region_ID
0
0
0
0
0

Why "0? How to solve?

UPDATE 10.5.12 to 10.5.13.
{code:sql}
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
{code}

Why "0? How to solve?

Sergii Volikov added a comment - 2021-11-16 08:40 - edited

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")

);

Sergii Volikov added a comment - 2021-11-16 08:40 - edited 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" ) );

Alice Sherepa added a comment - 2021-11-16 17:14

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)

Alice Sherepa added a comment - 2021-11-16 17:14 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)

Sergii Volikov added a comment - 2021-11-17 07:01

region_ID
0
0
0
0
0

Sergii Volikov added a comment - 2021-11-17 07:01 region_ID 0 0 0 0 0

Sergii Volikov made changes - 2021-11-17 07:02

Attachment

my.ini [ 60628 ]

Sergii Volikov made changes - 2021-11-25 19:06

Component/s		Storage Engine - Connect [ 10128 ]
Component/s	Server [ 13907 ]

Sergii Volikov made changes - 2021-11-25 19:07

Labels

Connect-Engine

Olivier Bertrand made changes - 2021-11-26 11:28

Environment

OS MS Server 2019
ODBC PostgreSql Unicode(x64) 11.01.00.00

ODBC table type

Olivier Bertrand made changes - 2021-11-26 11:29

Affects Version/s		10.4.22 [ 26031 ]
Affects Version/s		10.3.32 [ 26029 ]
Affects Version/s		10.2.41 [ 26032 ]

Olivier Bertrand added a comment - 2021-11-26 11:34

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

Olivier Bertrand added a comment - 2021-11-26 11:34 Was a regression from MDEV-24493 last fix only applying to last versions.

Olivier Bertrand made changes - 2021-11-26 11:34

issue.field.resolutiondate

2021-11-26 11:34:28.0

2021-11-26 11:34:28.229

Olivier Bertrand made changes - 2021-11-26 11:34

Fix Version/s		10.2.42 [ 26803 ]
Fix Version/s		10.3.33 [ 26805 ]
Fix Version/s		10.4.23 [ 26807 ]
Fix Version/s		10.5.14 [ 26809 ]
Fix Version/s		10.6.6 [ 26811 ]
Fix Version/s		10.7.2 [ 26813 ]
Fix Version/s		10.8.1 [ 26815 ]
Resolution		Fixed [ 1 ]
Status	Open [ 1 ]	Closed [ 6 ]

Sergei Golubchik made changes - 2021-12-06 21:54

Workflow

MariaDB v3 [ 127522 ]

MariaDB v4 [ 159847 ]

Sergei Golubchik made changes - 2021-12-11 09:25

Fix Version/s

10.8.1 [ 26815 ]

Alice Sherepa made changes - 2021-12-17 14:32

Link

This issue is duplicated by ~~MDEV-27285~~ [ ~~MDEV-27285~~ ]

People

Assignee:: Olivier Bertrand

Reporter:: Sergii Volikov

Votes:: 0 Vote for this issue

Watchers:: 6 Start watching this issue

Dates

Created:: 2021-11-15 18:57

Updated:: 2022-01-25 09:17

Resolved:: 2021-11-26 11:34

Git Integration

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

MariaDB Server

Details

Description

Attachments

Attachments

Issue Links

Activity

People

Dates

Git Integration