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

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

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