Details

      Description

      Note: possibly related to MDEV-12406, MDEV-12407.

      SELECT alias1.* FROM `t8` AS alias1 INNER JOIN `view_t4` AS alias2 ON (alias2.`col_bit` = alias1.`pk` ) WHERE ( alias1.`col_char` ) IN ( SELECT col_varchar FROM t4 );
      col_enum	col_date	col_bit	col_year	col_char	col_timestamp	col_datetime	col_dec	col_int	col_varchar	col_blob	pk	col_time
      SELECT * FROM ( SELECT alias1.* FROM `t8` AS alias1 INNER JOIN `view_t4` AS alias2 ON (alias2.`col_bit` = alias1.`pk` ) WHERE ( alias1.`col_char` ) IN ( SELECT col_varchar FROM t4 ) ) cte;
      col_enum	col_date	col_bit	col_year	col_char	col_timestamp	col_datetime	col_dec	col_int	col_varchar	col_blob	pk	col_time
      	1900-01-01	)��5	2026	b	2009-08-05 02:19:02	2007-01-25 00:00:00	0	5	bib		1	00:00:00
      	1900-01-01	)��5	2026	b	2009-08-05 02:19:02	2007-01-25 00:00:00	0	5	bib		1	00:00:00
      

      --source include/have_innodb.inc
      --enable_connect_log
      --disable_abort_on_error
       
      CREATE TABLE t4 (
       pk INTEGER AUTO_INCREMENT,
       col_year YEAR NULL,
       col_timestamp TIMESTAMP NULL,
       col_dec DECIMAL(42,0) ZEROFILL NULL,
       col_varchar VARCHAR(3289) NOT NULL DEFAULT '',
       col_int SMALLINT(2) ZEROFILL NOT NULL DEFAULT 0,
       col_blob MEDIUMTEXT NULL,
       col_date DATE NULL,
       col_time TIME NULL,
       col_datetime DATETIME,
       col_bit BIT(61) NULL,
       col_char CHAR(82) NULL,
       col_enum SET('','a','b','c','d','e','f','foo','bar') NULL,
       PRIMARY KEY(pk)
       ) ENGINE=Aria /* QNO 41 CON_ID 9 */;
      	CREATE ALGORITHM=TEMPTABLE VIEW view_t4 AS SELECT * FROM t4 /* QNO 42 CON_ID 9 */;
      	ALTER TABLE t4 ADD UNIQUE(col_int,col_time,col_year) /* QNO 43 CON_ID 9 */;
      	ALTER TABLE t4 ADD INDEX(col_blob(64),col_enum) /* QNO 44 CON_ID 9 */;
      	ALTER TABLE t4 ADD UNIQUE(pk,col_time) /* QNO 45 CON_ID 9 */;
      	ALTER TABLE t4 ADD INDEX(col_blob(64)) /* QNO 46 CON_ID 9 */;
      	START TRANSACTION /* QNO 47 CON_ID 9 */;
      	INSERT IGNORE INTO t4 (col_year,col_timestamp,col_dec,col_varchar,col_int,col_blob,col_date,col_time,col_datetime,col_bit,col_char,col_enum) VALUES
       (2032,'2011-07-10 17:18:16.003920',0.520217895507812,'',7,'s','2006-10-20','10:58:05.029841','2024-12-16 21:29:19.017292',NULL,'unk',''),
       (2022,'1900-01-01 00:00:00',0.95855712890625,'nk',7,'','1987-05-20','00:00:00','2026-06-21 09:12:14.028767',b'100100011011110101010100110100001110110',NULL,''),
       (1997,'1981-09-03 23:20:32.017938',0.464584350585938,'{"see": true,"something": 0}',3,'[0,true,false,"rcpv"]','1900-01-01','05:56:23.040084','1977-07-02 00:43:41.028858',b'10','cp',NULL),
       (2016,'2031-04-03 09:34:49.028612',0.357742309570312,'pv',2,'vasd','1994-10-17','12:11:59.029084','2017-06-05 15:54:47.061688',b'1111110001001111','as',''),
       (2018,'1988-09-09 20:30:16.012173',0.481414794921875,'sdqkxb',252,'z','2034-09-14','21:13:47.063387','1979-03-17 13:58:17.060325',NULL,'{"about": false,"or": "dqk"}',NULL),
       (1985,'1997-08-25 22:51:12.028867',0.334518432617188,'q',8,'j','2035-03-23','22:25:42.056743','1977-05-20 03:41:52.020547',NULL,'u',''),
       (1995,'2013-04-25 20:35:24.030770',0.36126708984375,'["kxbwptigbpn",false,[true],NULL,"xbwptigbpnesqigwegcnfeuvrgnecpthmhffq"]',6,'bwp','1977-06-05','20:29:14.038823','2029-12-14 13:53:32.039479',b'01010111000011101','wp',''),
       (NULL,'2005-02-15 15:34:26.027540',0.135711669921875,'ptigbpn',3,'ti',NULL,'00:00:00','2012-01-01 00:00:00',b'1100010110110010010100000001001','{"so": NULL,"your": "igbpnesqigwegc","would": true,"some": NULL,"would": 0}',''),
       (2032,'2021-11-22 02:32:00.032433',0.794998168945312,'gb',6,'bpne','1900-01-01','11:35:08.055226','2001-01-13 00:00:00',b'101111101101100101111001111010111100000000','pnesq',NULL),
       (1985,'1997-04-19 18:21:41.013932',0.551010131835938,'nesqigw',4,NULL,'2035-09-04','04:01:56.009234','2030-07-26 10:10:09.034674',b'011110100101110101000011000011','a',''),
       (2030,NULL,NULL,'esqigwegcnfeuvrgnecpthmhffqbythjwpukqubzpomntrddrwhzjtqvbjiklcekxqyoxsolbxthdcprswpjxixmvfwmsyseblwcvumvyvbitxqjxdzdytunqvvrmpyxrencqhuyrfluezqekmqpwutxnzddrbjycyoyqbzsoxvillooqxuvoxcgohdbytybwcqxdwtqrebgjzbycekyjgbpmqadutrqluyxhrdodxqqjwasfkvetfobocgpftrhvxugmmszwpoglvarsfiljrzimqeplevleqdhepkhcfrahcpjjvhkkwblfenfpetwejamgeefplsksusqvazujabvkfekxhnemklzergshgvtqekglkhirmzlqyeqtfopugfcdfubqoeujfhnpgthomsfusbhug',1,'s','2017-11-07','03:22:55.011325','2013-05-11 00:00:00',b'0100110111010011010110010000','q',''),
       (2007,NULL,0.02972412109375,'igwegc',1,'[0,"gw","weg",false,0,0,true]','1999-12-27','11:59:05.013933','1900-01-01 00:00:00',b'111001011110111111110000111010011','egcnfe',''),
       (2001,NULL,0.8619384765625,'gcnfe',7,'l','2019-07-18','00:00:00','2031-07-03 23:36:04.043735',b'111000111100011010',NULL,''),
       (2013,NULL,0.01385498046875,'',1,'{"a": true,"know": false,"now": true,"all": true,"have": NULL,"have": "cnfe"}','2029-07-19','03:06:49.064082','1987-01-27 11:49:07.049214',b'101001001110111011111011','nf',''),
       (NULL,NULL,0.991500854492188,'a',2,'fe','1972-09-14','11:20:31.039440','1900-01-01 00:00:00',b'01010111000','euvr',''),
       (NULL,'1982-07-02 00:00:00',0.82049560546875,'[NULL,NULL,true,0]',2,'[]',NULL,'00:00:00','2013-08-19 15:54:16.040602',b'100101101','u',''),
       (2004,'2011-08-19 04:46:53.046799',0.905105590820312,'vrgnecpthmhffqbythjwpukqubzpomntrddrwhzjtqvbjiklcekxqyoxsolbxthdcprswpjxixmvfwmsyseblwcvumvyvbitxqjxdzdytunqvvrmpyxrencqhuyrfluezqekmqpwutxnzddrbjycyoyqbzsoxvillooqxuvoxcgohdbytybwcqxdwtqrebgjzbycekyjgbpmqadutrqluyxhrdodxqqjwasfkvetfobocgpftrhvxugmmszwpoglvarsfiljrzimqeplevleqdhepkhcfrahcpjjvhkkwblfenfpetwejamgeefplsksusqvazujabvkfekxhnemklzergshgvtqekglkhirmzlqyeqtfopugfcdfubqoeujfhnpgthomsfusbhugmvurbryqqcbkhankkwoalodixeuhwkzwfdbrwmpkhdfocdcjrxxihtvzdfvdanvsodxuroztqcmuxmpjisqdkfykpraagyrwswotqllacxfargqphiaxjbjptzyomlqmecqikprnstjejxktdnhiudznoasbvoavryrpktcczmhdlcserqvakahjtesmgifltnefitzufcefqqmfokivsitbedsjzuvsjghsldzxndyqrnlbdgwcjxyuoyxkuhxeszommzdtwlfrvfcrogfdttnnkvhgrlhibykvacxgqpfomtdxswhuhnrhjauvubionbzrimkgktrrxxdmguucqulwflxtnbvgqazmatrlfcpqdjzbyottttfezenwvxcdxpwdpolkniqzzdwoqnghixsjyoixuyqrdnahimtkdvjbei',2,'rgnecp','2003-05-14','19:04:01.047098','2026-02-15 04:18:34.004252',NULL,NULL,''),
       (1974,'2007-01-06 11:57:39.013197',0.719161987304688,'necpth',7,NULL,'1984-09-03','00:08:16.002954','1992-12-10 12:23:37.045926',b'1100111100','cpth',''),
       (1974,'1983-04-16 15:00:17.003592',0.103622436523438,'pthm',4,'f','1900-01-01','19:22:16.015548','2013-08-25 01:32:47.008806',b'00001011111100101100011','thmhffqbythjwpukqubzpomnt',''),
       (1987,'1988-07-23 00:00:00',NULL,'h',9,'{"thats": 0,"think": 0,"not": false,"see": 0}',NULL,'21:18:33.039919','1991-05-16 22:17:29.018990',b'10100010010110000111001010100111011101011110011','[true]',''),
       (2007,'1900-01-01 00:00:00',0.29425048828125,'[NULL,0,"mhffqbythjwpukqubzpomntrdd",0,true]',1,'hff','1974-09-13','23:06:59.054050','2012-12-14 00:00:00',b'11101',NULL,''),
       (2002,'2004-01-07 19:00:41.031706',0.959014892578125,'f',3,'qby','1989-03-02','19:11:23.034769','1997-05-08 09:54:07.007807',b'1110110010111010010100001010000110','bythj',''),
       (1976,'2002-01-18 00:00:00',0.149566650390625,'yt',9,'[NULL,true,0]','1975-03-10','00:00:00','2027-08-18 02:27:28.026114',b'01001011110001010001111001010001','th',''),
       (1983,'1979-03-04 06:14:13.038463',0.850997924804688,'hj',4,'jwpuk','2028-04-26','21:17:01.035731','1900-01-01 00:00:00',b'111011100111000110010110100111110111010110101110101010000111',NULL,''),
       (2020,'1900-01-01 00:00:00',0.981109619140625,'pu',3,NULL,'1900-01-01','19:05:53.029579','2020-02-20 07:32:21.059521',b'01000111010111001001','{"it": false,"to": NULL,"what": 0,"would": true}',''),
       (2015,'1999-02-16 23:39:51.036205',0.277114868164062,'k',3,'qu','1986-03-19',NULL,'2003-05-16 00:32:07.046881',b'1010111001101011100000101','ub',''),
       (1999,NULL,0.671600341796875,'[false,"bzpomn","zp",true,true]',0,'','1997-08-13','21:27:38.024505','1991-08-25 00:00:00',NULL,'pomn',''),
       (1993,'1977-03-03 03:43:53.061233',0.60693359375,'omntrd',0,NULL,'2008-10-16','06:59:48.026561','1900-01-01 00:00:00',b'11100110010111','rddr',NULL),
       (1989,NULL,0.30657958984375,'dd',6,'l','1994-02-01','18:10:10.061262','2007-09-08 00:00:00',b'00000000110001011111111001','dr',NULL),
       (2002,'2003-10-15 23:54:25.014715',0.094879150390625,'r',8,'','2021-06-19','07:09:28.035220','2035-03-16 10:48:59.031496',b'111101111100111100100100101100001100100010101101110100100','whzjtqvbjiklcek',''),
       (2008,'2007-04-05 17:59:08.063252',0.747146606445312,'hz',6,NULL,'1997-11-18','01:09:14.016732','1998-02-01 10:31:35.032702',b'10111111101100111011010111110011010110','d',''),
       (1974,'1987-09-26 06:43:14.015619',0.4412841796875,'j',8,'{"have": true,"hes": false,"its": 0,"his": NULL,"on": false}','2001-12-09','05:22:56.065526','2012-12-18 02:43:37.038767',b'010111000001011000101101101','tqvbjiklcekxqyoxsolbxthdcprswpjxixmv',''),
       (NULL,'2033-11-07 22:07:54.005182',0.0614776611328125,'qv',6,'vb','1980-01-20','06:25:36.035446','1973-10-01 03:37:05.053802',b'11001110010100011100100010100010000010011011001110','bjik',''),
       (2023,'2028-09-04 09:48:53.008432',0.447372436523438,'{"dont": 0}',7,NULL,'2020-01-28','00:00:00','2018-12-02 00:27:35.056455',b'010000100000100000010100101011101000110','jiklc',''),
       (1977,'2008-01-04 00:00:00',0.54010009765625,'i',5,'{"look": true,"go": 0,"did": true,"but": 0,"was": 0,"now": true,"he": "klce"}','1976-08-26','07:22:25.033657','2010-01-21 05:17:01.015777',b'10100001110010000010000110101110111110101','lcekxq',''),
       (1987,NULL,0.139068603515625,'cek',3,'','1998-10-01','03:51:54.021900','1985-08-19 22:17:31.011278',b'0101001100100110101001000001011100000110101000010','ekxqyoxsolbxthdcprswpjxixmvfwmsys',NULL),
       (1986,'2013-11-16 07:22:14.009509',NULL,'kxqyoxs',7,'xqyo','2022-01-08','08:10:47.011902','1900-01-01 00:00:00',b'1000101010001001111','qyox',''),
       (NULL,'1978-02-22 02:55:14.047104',0.456741333007812,'g',4,NULL,NULL,'06:50:23.045582','2035-07-04 00:00:00',b'0111011011100110011110111000101010110010111111011110000','[]',''),
       (2004,'1978-03-06 00:00:00',0.848785400390625,'{}',3,'x','2007-05-24','19:08:23.001348','1900-01-01 00:00:00',b'101011100011011011000011011000100111111111011010010','[false,0,"oxsolbxthdcprswpjxixmvfwmsyseblwcvum",false,0,NULL,NULL]',''),
       (2011,'2026-01-23 06:20:04.049880',0.940200805664062,'xso',6,'solbxth','1980-08-26','14:12:35.065342','1977-10-25 00:10:21.018440',b'00001011000000000010011101000101001100','ol',''),
       (2000,NULL,0.256866455078125,'lbxt',0,'b','1987-09-10','13:11:23.031776','1995-06-19 00:00:00',b'000000','{"who": "xthdcprswpjxixmvfwmsyseblwcvumv"}',''),
       (2006,'1975-05-18 19:25:03.064688',0.482818603515625,'thd',0,'hdcprsw','2030-12-06','17:40:29.000983','2006-01-27 00:00:00',b'10011110011100010110011111110011111100110','{"who": 0,"now": NULL,"get": false,"we": NULL,"who": true}',NULL),
       (2030,'1900-01-01 00:00:00',0.372634887695312,'[]',1,'',NULL,'11:01:43.021590','2020-10-08 02:19:48.049335',b'11000000100100011010010100001100111011100100000001','dcprs',''),
       (2014,'2030-01-03 12:22:04.026924',0.757888793945312,'cprswp',5,'','2014-03-12','00:00:00','1997-04-07 05:34:33.049778',NULL,'prswpjx',''),
       (1989,'1998-06-08 00:00:00',0.404312133789062,'rswpjxi',6,'swpjxix',NULL,'14:53:28.042107','1900-01-01 00:00:00',b'1','',''),
       (2008,'1987-05-07 09:10:12.053156',0.82220458984375,'w',1,'pj','1900-01-01','00:52:28.008578','2002-08-19 00:00:00',b'01111011000111111011111111100000000001000010100100100','jx',''),
       (2006,'2024-07-04 16:46:02.051606',0.525299072265625,'',9,'x','1986-07-28','06:52:27.056008','1986-10-17 07:45:40.026813',b'111110101110001101001000011010010111000000101010','ixmvfw',''),
       (1993,'2001-05-26 06:06:00.055109',0.333938598632812,'xmv',5,NULL,'1900-01-01',NULL,'1975-01-02 07:25:38.014308',b'0111100101101010010011110111','{"see": true,"that": NULL,"go": "mvfwmsyse"}',''),
       (NULL,'2009-02-03 09:42:22.048168',0.94818115234375,'vf',8,'fwmsys','1981-10-20','02:31:19.004480','2031-04-12 00:00:00',b'1000111100100110001111010000011010100','',NULL),
       (2008,'2035-10-09 22:34:38.001824',0.910797119140625,'wm',7,'msyseblw','1900-01-01','02:16:57.023929','1982-03-05 11:28:30.004617',b'11101',NULL,''),
       (2004,'1991-12-05 03:32:18.045713',0.545440673828125,'sysebl',1,'y','1900-01-01',NULL,'2016-06-18 09:49:52.001949',b'01010001000011111001011011111011111010001','seblwcv',NULL),
       (2010,'1987-07-23 00:00:00',0.400665283203125,'',1,NULL,'1997-10-03','13:25:52.039149','1989-07-05 03:37:07.052046',NULL,'blwcv',''),
       (1980,'1900-01-01 00:00:00',0.46295166015625,'{"dont": "lwcvumvyvbitxqjxdzdytu","him": 0,"but": "wc","or": 0}',9,'cvu','1993-10-11','19:10:58.018380','2024-08-10 00:00:00',b'01000101110100111111001010111101111011000010010000011','v',''),
       (NULL,'1900-01-01 00:00:00',0.6600341796875,'umv',1,'',NULL,'16:36:10.016860','1987-08-21 11:24:31.056635',b'00110000010001000100001000110','mvyv',''),
       (1999,'2006-05-28 05:01:41.049598',0.620712280273438,'vy',2,'yvb','2015-03-01','13:53:51.030512','1984-09-03 06:31:42.042677',b'001','vb',''),
       (NULL,'1980-09-05 15:38:46.065375',0.687820434570312,'bitxqjxdzdytunqvvrmpyxrencqhuyrfluezqekmqpwutxnzddrbjycyoyqbzsoxvillooqxuvoxcgohdbytybwcqxdwtqrebgjzbycekyjgbpmqadutrqluyxhrdodxqqjwasfkvetfobocgpftrhvxugmmszwpoglvarsfiljrzimqeplevleqdhepkhcfrahcpjjvhkkwblfenfpetwejamgeefplsksusqvazujabvkfekxhnemklzergshgvtqekglkhirmzlqyeqtfopugfcdfubqoeujfhnpgthomsfusbhugmvurbryqqcbkhankkwoalodixeuhwkzwfdbrwmpkhdfocdcjrxxihtvzdfvdanvsodxuroztqcmuxmpjisqdkfykpraagyrwswotqllacxfargqphiaxjbjptzyomlqmecqikprnstjejxktdnhiudznoasbvoavryrpktcczmhdlcserqvakahjtesmgifltnefitzufcefqqmfokivsitbedsjzuvsjghsldzxndyqrnlbdgwcjxyuoyxkuhxeszommzdtwlfrvfcrogfdttnnkvhgrlhibykvacxgqpfomtdxswhuhnrhjauvubionbzrimkgktrrxxdmguucqulwflxtnbvgqazmatrlfcpqdjzbyottttfezenwvxcdxpwdpolkniqzzdwoqnghixsjyoixuyqrdnahimtkdvjbeirucdkuykhtflxkzoiwimuljxdmazuguiuyyemoefwkptnpdnxobwuxplmihguaulybsxuogtmpmzdxsxgnpekolinzppighwyorqbeeikqlffesqekhmnbyflpwhihyfqexbzqllzydyptbwcmevpcmachjajxlcevjcezyvfndoulcceseebtfwteegsrysegyqzgaovjslcgxpzqoxlqejnumjojibwhbnqrmuahrrhkjrrizzulqclpzkfalbrtjcglxrhszefsxjeipujlawnhfnfewoalodixeuhwkzwfdbrwmpkhdfocdcjrxxihtvzdfvdanvsodxuroztqcmuxmpjisqdkfykpraagyrwswotqllacxfargqphiaxjbjptzyomlqmecqikprnstjejxktdnhiudznoasbvoavryrpktcczmhdlcserqvakahjtesmgifltnefitzufcefqqmfokivsitbedsjzuvsjghsldzxndyqrnlbdgwcjxyuoyxkuhxeszommzdtwlfrvfcrogfdttnnkvhgrlhibykvacxgqpfomtdxswhuhnrhjauvubionbzrimkgktrrxxdmguucqulwflxtnbvgqazmatrlfcpqdjzbyottttfezenwvxcdxpwdpolkniqzzdwoqnghixsjyoixuyqrdnahimtkdvjbeirucdkuykhtflxkzoiwimuljxdmazuguiuyyemoefwkptnpdnxobwuxplmihguaulybsxuogtmpmzdxsxgnpekolinzppighwyorqbeeikqlffesqekhmnbyflpwhihyfqexbzqllzydyptbwcmevpcmachjajxlcevjcezyvfndoulcceseebtfwteegsrysegyqzgaovjslcgxpzqoxlqejnumjojibwhbnqrmuahrrhkjrrizzulqclpzkfalbrtjcglxrhszefsxjeipujlawnhfnfe',5,'itxq','1988-02-20','18:16:35.008494','2016-04-20 01:54:33.054697',b'00111111101110111011','',''),
       (1987,'1983-05-27 00:00:00',0.748245239257812,'txqjxdzd',6,'',NULL,'02:51:21.010051','2024-09-23 01:41:02.038769',b'10101111110010010111110100110001100111111000111111111010111','',NULL),
       (1996,'2000-02-22 00:00:00',0.512130737304688,'xq',1,'{"that": 0,"all": "qjxdzdy","not": {"yes": "jxdzdytunqvvr","because": false,"will": 0,"had": 0,"my": 0}}','1990-12-08','17:09:50.038179','1987-12-12 02:59:12.032256',NULL,'',NULL),
       (1975,'2017-03-05 00:00:00',0.367294311523438,'xdzdytunqvvrmpyxrencqhuyrfluezqekmqpwutxnzddrbjycyoyqbzsoxvillooqxuvoxcgohdbytybwcqxdwtqrebgjzbycekyjgbpmqadutrql',3,'dzdy','1998-05-12','03:02:23.050031','2016-06-12 14:04:59.018344',b'0111110011011010010101101100001001001001110','',''),
       (2002,'1997-01-28 18:36:42.064922',0.618804931640625,'zdy',3,'dy','1999-05-03','10:39:47.004022','2006-08-21 14:28:30.049016',b'111101011','',''),
       (2029,'2028-12-19 00:00:00',0.905105590820312,'ytun',249,'tunqvv','1989-03-25','02:13:25.018124','2021-01-18 11:45:10.022536',b'10011001010','u',''),
       (NULL,'1997-08-16 20:08:07.030307',0.591079711914062,'nq',0,'r','2019-07-07','00:00:00','2014-05-25 02:10:51.013074',b'10110010110010010101011001','[false,NULL,0,"","q"]',NULL),
       (2026,'2010-04-10 00:00:00',0.987548828125,'{"know": {"good": true},"really": [false,0,"vvrmpyxrencqhuyrf",0,"vrmpyxrencqhuyrfluezqekmqpwutxnzddrb"],"I": NULL,"hey": "rmpyxr","know": NULL}',5,'','2001-02-25','05:21:02.035675','1999-07-16 00:00:00',b'101100111000001101101101111110011000101','mpyxre',''),
       (2022,'2000-04-19 05:08:15.014678',NULL,'w',9,'py',NULL,'20:25:12.042350','2022-11-17 00:00:00',b'1011010','[false,0,"yxrencqhuyrfluezqekmq",0]',''),
       (2003,'1978-05-19 15:23:16.021433',NULL,'{"that": 0}',2,NULL,'1975-04-08','14:44:17.060125','1971-10-28 13:43:19.008905',b'1111010010001001','',''),
       (2007,'1900-01-01 00:00:00',0.123703002929688,'re',0,'',NULL,'20:19:41.049941','2010-12-28 09:13:18.057850',b'100110001101010000000100','encqhu',''),
       (2002,'1990-04-24 09:02:40.063021',0.182601928710938,'ncqhuyr',224,'[0,NULL,"cq",false,"qhuyrfluezqekmqpwu",NULL,true]','1994-12-13','14:53:43.052878','1973-07-18 12:06:28.034002',b'11100110010100100011110100011111100100','',''),
       (2013,'2026-06-20 03:38:12.057780',NULL,'huy',9,'u','1900-01-01','12:08:39.021202','2024-05-08 08:32:05.026227',b'010100110110100001010001101111110101','y',NULL),
       (1995,NULL,0.111907958984375,'r',9,'{"are": true,"at": 0,"it": true}','2010-03-19','04:28:54.058532','1900-01-01 00:00:00',b'1001010100000100111001101000001111111011','fluez',''),
       (2028,'2025-11-15 14:15:24.041574',0.00872802734375,'lue',5,'uezq','2027-06-07','00:00:00','2024-03-19 02:15:24.063953',b'0110001000110110110111111001011011001100110011','ezq',''),
       (1973,'2012-08-06 00:00:00',0.146041870117188,'zqekmqpwutxnzddrbjycyoyqbzsoxvillooqxuvoxcgohdbytybwcqxdwtqrebgjzbycekyjgbpmqadutrqluyxhrdodxqqjwasfkvetfobocgpftrhvxugmmszwpoglvarsfiljrzimqeplevleqdhepkhcfrahcpjjvhkkwblfenfpetwejamgeefplsksusqvazujabvkfekxhnemklzergshgvtqekglkhirmzlqyeqtfopugfcdfubqoeujfhnpgthomsfusbhugmvurbryqqcbkhankkwoalodixeuhwkzwfdbrwmpkhdfocdcjrxxihtvzdfvdanvsodxuroztqcmuxmpjisqdkfykpraagyrwswotqllacxfargqphiaxjbjptzyomlqmecqikprnstjejxktdnhiudznoasbvoavryrpktcczmhdlcserqvakahjtesmgifltnefitzufcefqqmfokivsitbedsjzuvsjghsldzxndyqrnlbdgwcjxyuoyxkuhxeszommzdtwlfrvfcrogfdttnnkvhgrlhibykvacxgqpfomtdxswhuhnrhjauvubionbzrimkgktrrxxdmguucqulwflxtnbvgqazmatrlfcpqdjzbyottttfezenwvxcdxpwdpolkniqzzdwoqnghixsjyoixuyqrdnahimtkdvjbeirucdkuykhtflxkzoiwimuljxdmazuguiuyyemoefwkptnpdnxobwuxplmihguaulybsxuogtmpmzdxsxgnpekolinzppighwyorqbeeikqlffesqekhmnbyflpwhihyfqexbzqllzydyptbwcmevpcmachjajxlcevjcezyvfndoulcceseebtfwteegsrysegyqzgaovjslcgxpzqoxlqejnumjojibwhbnqrmuahrrhkjrrizzulqclpzkfalbrtjcglxrhszefsxjeipujlawnhfnfesxlfcjsbwbwdxuuerdsygghanloqtmyexedzqekmqpwutxnzddrbjycyoyqbzsoxvillooqxuvoxcgohdbytybwcqxdwtqrebgjzbycekyjgbpmqadutrqluyxhrdodxqqjwasfkvetfobocgpftrhvxugmmszwpoglvarsfiljrzimqeplevleqdhepkhcfrahcpjjvhkkwblfenfpetwejamgeefplsksusqvazujabvkfekxhnemklzergshgvtqekglkhirmzlqyeqtfopugfcdfubqoeujfhnpgthomsfusbhugmvurbryqqcbkhankkwoalodixeuhwkzwfdbrwmpkhdfocdcjrxxihtvzdfvdanvsodxuroztqcmuxmpjisqdkfykpraagyrwswotqllacxfargqphiaxjbjptzyomlqmecqikprnstjejxktdnhiudznoasbvoavryrpktcczmhdlcserqvakahjtesmgifltnefitzufcefqqmfokivsitbedsjzuvsjghsldzxndyqrnlbdgwcjxyuoyxkuhxeszommzdtwlfrvfcrogfdttnnkvhgrlhibykvacxgqpfomtdxswhuhnrhjauvubionbzrimkgktrrxxdmguucqulwflxtnbvgqazmatrlfcpqdjzbyottttfezenwvxcdxpwdpolkniqzzdwoqnghixsjyoixuyqrdnahimtkdvjbeirucdkuykhtflxkzoiwimuljxdmazuguiuyyemoefwkptnpdnxobwuxplmihguaulybsxuogtmpmzdxsxgnpekolinzppighwyorqbeeikqlffesqekhmnbyflpwhihyfqexbzqllzydyptbwcmevpcmachjajxlcevjcezyvfndoulcceseebtfwteegsrysegyqzgaovjslcgxpzqoxlqejnumjojibwhbnqrmuahrrhkjrrizzulqclpzkfalbrtjcglxrhszefsxjeipujlawnhfnfesxlfcjsbwbwdxuuerdsygghanloqtmyexedolkniqzzdwoqnghixsjyoixuyqrdnahimtkdvjbeirucdkuykhtflxkzoiwimuljxdmazuguiuyyemoefwkptnpdnxobwuxplmihguaulybsxuogtmpmzdxsxgnpekolinzppighwyorqbeeikqlffesqekhmnbyflpwhihyfqexbzqllzydyptbwcmevpcmachjajxlcevjcezyvfndoulcceseebtfwteegsrysegyqzgaovjslcgxpzqoxlqejnumjojibwhbnqrmuahrrhkjrrizzulqclpzkfalbrtjcglxrhszefsxjeipujlawnhfnfesxlfcjsbwbwdxuuerdsygghanloqtmyexed',6,'t','1972-08-28','14:14:11.050944','2003-07-27 23:39:18.026729',b'1110010010101011101110110001001110101000101000','q',''),
       (2018,'1976-04-06 06:43:01.058103',0.733718872070312,'[NULL,0,NULL,true,false]',206,'ekmq','2016-08-03','00:00:00','1983-02-19 04:19:19.056236',b'010011100111','k',''),
       (1993,'2010-09-10 23:15:45.036830',NULL,'{"yeah": false}',0,'','1989-02-12','09:37:05.017251','1986-04-02 13:00:46.035701',b'001111011101010001010','m',''),
       (1974,'2019-12-28 04:09:18.006257',0.4046630859375,'q',8,'pwu','2024-08-05','17:16:08.035152','1984-03-10 17:38:47.030555',b'010011110110010011001101','wutxnzd',''),
       (1999,'2031-10-22 20:02:55.003124',0.494674682617188,'["utxnzddrbjycyoyqbzsoxvillooqxuvoxcgohdbytybwcqx",NULL,false,"t","xnzddrbjycyoyqbzsoxvillooqxuvoxcgohdbytybwcq",false,0]',1,'{"about": true,"right": "nzddrbjycyoyqbzsoxvil","from": 0}','1900-01-01','03:58:04.059902','2024-12-26 08:30:47.063417',b'011','b',''),
       (NULL,'1992-11-20 07:42:22.041483',0.86065673828125,'zd',224,'d','1989-02-09','21:43:07.033293','1985-01-14 07:12:10.057102',b'00111001101010110101111100101101111',NULL,''),
       (2021,'1987-04-13 02:13:13.036388',0.340774536132812,'[NULL,true,0,0,0]',8,NULL,'1982-08-21','11:59:42.015139','2027-11-09 23:21:09.061398',b'001011110011001111101010','',''),
       (2027,'2003-08-15 08:48:23.038111',0.9490966796875,'drbj',8,NULL,'1987-07-23','15:14:39.055599','2033-06-25 12:58:11.003801',b'1101001110000010111110001110100000110110000110001010101011000','bjycy',''),
       (2030,'1972-08-19 00:00:00',NULL,'{"at": "jycyoyqbzsoxvillooqxuv","look": false,"or": {"why": NULL},"hes": [NULL,0,true,NULL,"ycyoyqbzsoxvillo",0,false,"c",[[false,"yoyqbz","oy",0,0,0,"yq",true,NULL],"qbz",NULL,0,0,0,0,false,0],"bzsoxvillooqxuvoxcgohdbytybwcqxdwtqrebgjzby"],"that": true,"you": "zsoxvillooqxuvoxcgohdbytybwcqx","in": 0}',8,'sox','2032-06-12','09:45:37.030684','1900-01-01 00:00:00',b'001110',NULL,''),
       (2023,'2023-09-09 04:57:34.041376',0.75238037109375,'p',5,'','2015-09-28','09:58:40.030603','2024-05-05 07:49:28.034636',NULL,'m',''),
       (2010,'1971-11-05 16:05:55.047094',0.517074584960938,'x',4,'v','1900-01-01','07:12:51.009776','1995-09-11 00:00:00',b'000011111111010000100001000111011001011110000101101','',''),
       (1996,'1988-10-05 00:00:00',0.484207153320312,'illooqx',9,'',NULL,'16:34:21.038660','2009-07-12 17:47:18.055293',b'0111001000010101101011101111101101001011010','llo',''),
       (2018,'1999-08-17 16:39:08.050944',0.094879150390625,'looq',7,'oo','2018-03-25','17:04:47.019282','2012-03-22 03:27:59.036192',b'100110100110111101001000011011100100101110111000','{"there": false,"your": true,"were": "oqxuvoxcgohdbytybwcqxdwtqrebgjzbycekyjgb"}',''),
       (1991,'1992-09-02 05:25:48.052345',0.85382080078125,'qx',0,'xu','1900-01-01','17:19:05.023072','2028-07-18 18:32:32.051330',b'1011001110010110110000011110110001011111','uvoxcgohdbytybwcq',''),
       (1990,'1985-12-25 04:00:24.047667',0.59228515625,'{"my": "voxcgo"}',3,'','1900-01-01','04:10:52.058110','1978-05-10 21:08:56.023999',b'1011111010011010','',''),
       (2026,'2033-11-26 10:34:39.044191',0.350387573242188,'oxcgohdbytybwcqxdwtqrebgjzbycekyjgbpmqadutrqluyxhrdodxqqjwasfkvetfobocgpftrhvxugmmszwpoglvarsfiljrzimqeplevleqdhepkhcfrahcpjjvhkkwblfenfpetwejamg',8,'x','2033-10-25','22:53:07.030543','1999-11-20 12:50:42.060905',NULL,'',''),
       (NULL,'2020-08-04 20:27:11.017419',3.0517578125e-05,'c',2,'s','2035-02-28','19:53:49.013721','2022-01-10 04:36:33.028797',b'100001011001','["gohdbytybwcqx",0,NULL,0,0,true,false]',NULL),
       (2030,'1996-10-28 22:03:21.034174',0.646469116210938,'ohd',6,'hdbyt','1991-10-06','19:55:30.061475','1990-02-24 23:14:36.044244',b'100001011101000111000000001100010','{"out": 0,"your": 0,"this": NULL,"he": "dby","not": 0}',''),
       (2029,'1992-09-11 04:29:31.045074',NULL,'b',3,'ytyb',NULL,'17:08:26.047358','1988-02-11 18:18:35.013736',b'100001001111000100101011110111100101001110','tybwcqx',''),
       (2012,NULL,0.818695068359375,'yb',8,'b','1975-12-08','00:00:01.048604','2004-09-18 11:18:26.056600',b'1111111100101100101011010110',NULL,''),
       (1989,'2018-10-22 06:20:41.025467',0.066314697265625,'',7,'','1986-04-08','11:03:59.053293','2025-06-08 00:05:54.016021',b'11111100100001111','[0,{},false,{"mean": false,"no": 0,"yes": {"or": false,"of": 0,"out": 0,"been": {"now": "cqxdwtqrebgjzbycekyj","hes": false,"with": NULL,"with": "qxdwtq","but": "xdwtqrebgjz"},"are": "dwtqrebgjzbycekyjgbpmqadutrqlu","but": 0,"my": "wtqrebgjzb"}}]',NULL),
       (1977,'2012-09-04 14:08:18.034457',0.12823486328125,'',4,'t','2023-08-20','04:34:45.035009','1997-08-25 16:16:35.020206',b'01100000110001101110111101000111000110001110000010101','qr',''),
       (2008,'1900-01-01 00:00:00',NULL,'rebgjz',9,'','1900-01-01','08:19:36.031309','2033-02-26 00:00:00',b'0100101100111011101001011000000','eb',''),
       (2033,'2011-12-24 11:05:52.016418',0.286865234375,'b',6,'gj','2013-11-23','15:20:43.057527','1989-09-07 04:55:12.011385',b'10101010000011011110111101000001110110100100101101','j',NULL),
       (NULL,'1972-06-08 02:30:26.002910',0.718887329101562,'zbyceky',5,'byce','2002-04-05','14:49:59.060633','2029-06-17 00:00:00',b'110111011000011010101010000110100110110101010100101','d',''),
       (2015,'1983-09-12 22:43:41.001478',0.117874145507812,'ycekyjg',0,'[0,"cekyjgbpmqadutrq","ekyjgbpmqadutrqluyxhrdod","kyjgbpmqadutrqlu"]','1900-01-01',NULL,'1996-01-13 02:11:57.008897',NULL,NULL,''),
       (2025,'2001-07-22 11:04:43.027061',0.0662841796875,'c',1,'y','1987-01-27',NULL,'2021-10-15 09:23:41.009733',b'011001110001000111100011000001110000110011010000000','jgbpm',''),
       (NULL,'1982-04-16 11:27:43.022091',0.775299072265625,'gbpmqadu',1,'','1986-08-27','20:08:12.051220','1900-01-01 00:00:00',NULL,'bpm',''),
       (NULL,'1986-11-07 15:10:31.057393',0.669097900390625,'p',183,'mqadutr','2006-11-15','06:40:25.006044','1999-09-06 00:00:00',b'101110100001101001100010100000100110110100','qad',''),
       (2007,'2019-10-26 07:50:37.014570',0.725341796875,'{"he": 0,"she": true,"there": 0,"see": "adutrqluyxhrdodxqqjwasfkvetfobocgpftrhvxugmm","really": false}',116,'{}','2013-02-24','00:00:00','2029-11-24 14:38:13.014834',b'01010110000001111001111010110101111001','dutrq','') /* QNO 48 CON_ID 9 */;
      	SHOW WARNINGS;
      	COMMIT /* QNO 49 CON_ID 9 */;
       
      CREATE TABLE t8 (
       col_enum ENUM('','a','b','c','d','e','f','foo','bar') NOT NULL DEFAULT '',
       col_date DATE NOT NULL DEFAULT '1900-01-01',
       col_bit BIT(46) NOT NULL DEFAULT 0,
       col_year YEAR NOT NULL DEFAULT '1970',
       col_char CHAR(2) NULL,
       col_timestamp TIMESTAMP NULL,
       col_datetime DATETIME,
       col_dec DECIMAL(42,0) UNSIGNED NULL,
       col_int BIGINT(1) ZEROFILL NULL,
       col_varchar VARBINARY(2204) NOT NULL DEFAULT '',
       col_blob MEDIUMTEXT NULL,
       pk SERIAL,
       col_time TIME NULL,
       PRIMARY KEY(pk)
       ) ENGINE=Aria /* QNO 88 CON_ID 9 */;
      	CREATE ALGORITHM=TEMPTABLE VIEW view_t8 AS SELECT * FROM t8 /* QNO 89 CON_ID 9 */;
      	ALTER TABLE t8 ADD INDEX(col_date,col_varchar(64),col_blob(64)) /* QNO 90 CON_ID 9 */;
      	ALTER TABLE t8 ADD INDEX(col_char(2),col_time,col_year) /* QNO 91 CON_ID 9 */;
      	ALTER TABLE t8 ADD INDEX(col_year,col_int,col_bit) /* QNO 92 CON_ID 9 */;
      	ALTER TABLE t8 ADD UNIQUE(col_year,col_timestamp,col_time,col_blob(64)) /* QNO 93 CON_ID 9 */;
      --sleep 1
      	START TRANSACTION /* QNO 94 CON_ID 9 */;
      	INSERT IGNORE INTO t8 (col_enum,col_date,col_bit,col_year,col_char,col_timestamp,col_datetime,col_dec,col_int,col_varchar,col_blob,col_time) VALUES
       ('','1900-01-01',b'0101001110101111110100000110101',2026,'b','2009-08-05 02:19:02.000354','2007-01-25 00:00:00',0.0307769775390625,5,'bib','','00:00:00'),
       ('','2000-01-13',b'10',2012,'ibf','2015-02-07 12:05:00.016865','1900-01-01 00:00:00',0.642532348632812,8,'bfo','fofny','17:31:22.065277'),
       ('','2031-11-02',b'1100011010111011001000010000001001000000',2000,'{"but": true}',NULL,'1900-01-01 00:00:00',NULL,25,'[true]',NULL,'08:22:25.043520'),
       ('',NULL,b'0100001000101',2026,'f','2035-09-07 00:45:24.036427','2025-02-27 00:00:00',0.59576416015625,7,'s','ny','00:00:00'),
       ('','2034-12-01',b'0111110011101000110110100011011010111111101',2026,'yxt','2017-10-03 10:43:12.048925','2033-08-06 00:00:00',0.765380859375,5,'xtl','tl','18:57:40.028989'),
       ('','2005-07-07',b'10111000101110110000111111011101110',2015,'leecm',NULL,'1991-01-16 19:56:46.017947',0.570144653320312,8,'e','ee','16:23:10.040320'),
       ('','1900-01-01',b'0100101001000111011010010000100100100001000',2022,NULL,'1979-09-22 03:47:15.011348','1998-06-05 08:34:25.009431',0.473602294921875,3,'cmubzh','[true,NULL]','19:05:51.028118'),
       ('','1975-04-27',b'1111000101101',2009,'','2011-04-21 03:12:36.028777','2027-04-15 06:18:45.032304',0.61297607421875,NULL,'','mu',NULL),
       ('','1900-01-01',b'01010000111011011010001111001111000010101',2004,'ubzh',NULL,'2025-05-10 12:51:36.062144',0.680221557617188,211,'','bz','10:54:00.051917'),
       ('','2016-02-20',b'1010001111010010101111101011010',2016,'zhuutkm','2032-05-02 22:10:34.008156','2008-04-06 23:35:53.000379',0.299667358398438,141,'{"this": "huutkmzovjqgdicbqtwetatl"}',NULL,'17:49:12.020995'),
       ('','2034-12-03',b'0001101101111101011',1992,'{"for": false,"his": true}','1900-01-01 00:00:00','1900-01-01 00:00:00',0.832168579101562,0,'utk','[false,{}]',NULL),
       ('','2026-12-02',b'00000000011',2003,'','1988-02-14 01:39:24.024631','2003-02-28 20:45:16.005527',0.798828125,4,'tkmzo','','23:27:34.035896'),
       ('',NULL,b'11100101',2009,'kmzo','1988-02-24 00:00:00','2016-02-11 23:05:44.010260',0.638931274414062,NULL,'','mzo','12:08:13.007171'),
       ('','2012-10-23',b'01011001000101111001110101110101',2013,'zov','2015-04-14 01:30:46.039875','2033-01-18 13:08:49.045082',0.790573120117188,8,'{"with": 0,"or": 0,"good": "ovjqgdicbqtwetatliakbfhxacpomvuwy","got": NULL}','{"Ill": false,"of": true,"out": true}','10:20:02.006268'),
       ('','2027-08-12',b'1000011111000110010101111111110001111',1991,'{"see": true,"tell": false,"were": [false,true,"vjqg",0,"",true,"jqgdicbqtwetatliakbfhxacpo",0,"qgdicbqtwetat",false,"gdicbqtwetatliakbfhxacpomvuwypisncanrknijzvhogrpg",false,0]}','1981-11-08 23:36:32.057743','2014-11-09 06:52:56.013669',0.899932861328125,9,'d','[NULL,false,false,true,NULL,{"well": false,"if": false,"will": false,"how": true,"time": 0,"mean": "icbqtwetatli"},true]','23:05:19.058296'),
       ('','2004-05-13',b'010110101',1993,'[NULL,0,NULL,0,"cbqt",0,true]','2009-06-10 08:09:36.041402','1993-08-14 02:48:10.059372',0.541549682617188,4,'b','qt','20:00:45.002257'),
       ('','2029-12-17',b'011100100100011111111011',2016,NULL,'1993-10-19 23:23:13.059545','2010-04-28 15:39:46.019132',0.0175933837890625,1,'','w','21:05:38.009035'),
       ('','2005-07-25',b'001001110',2012,'{"will": NULL,"okay": NULL,"got": false}','1900-01-01 00:00:00','2028-12-16 08:38:36.024678',0.505325317382812,6,'i',NULL,'18:00:59.056144'),
       ('','1900-01-01',b'1000001',1972,'t','2031-03-08 13:38:26.005564','2022-08-21 00:00:00',0.233108520507812,5,'{"him": 0,"could": false,"in": 0}','a','00:18:55.032812'),
       ('','2022-08-16',b'0001001101111010100001',2008,'t','1900-01-01 00:00:00','2012-04-10 09:14:39.021634',0.411148071289062,8,'lia','','08:54:02.017557') /* QNO 95 CON_ID 9 */;
      	SHOW WARNINGS;
      	COMMIT /* QNO 96 CON_ID 9 */;
      	DROP TABLE /*! IF EXISTS */ t9 /* QNO 97 CON_ID 9 */;
      	SHOW WARNINGS;
       
      --let $query = SELECT alias1.* FROM `t8` AS alias1 INNER JOIN `view_t4` AS alias2 ON (alias2.`col_bit` = alias1.`pk` ) WHERE ( alias1.`col_char` ) IN ( SELECT col_varchar FROM t4 )
       
      eval $query;
       
      eval SELECT * FROM ( $query ) cte;
      

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              elenst Elena Stepanova
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: