Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-12409

[Draft] Wrong result

    XMLWordPrintable

Details

    Description

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

      SELECT DISTINCT alias1.`col_time` AS field1, alias1.`col_char` AS cfield1 FROM ( ( SELECT DISTINCT SQ1_alias1.* FROM `view_t8` AS SQ1_alias1 ) AS alias1, `t8` AS alias2, `t5` AS alias3 ) WHERE alias1.`col_date` IS NULL;
      field1	cfield1
      00:00:00.000000	f
      12:08:13.007171	km
      SELECT * FROM (  SELECT DISTINCT alias1.`col_time` AS field1, alias1.`col_char` AS cfield1 FROM (( SELECT * FROM (  SELECT DISTINCT SQ1_alias1.* FROM `view_t8` AS SQ1_alias1  ) cte3 ) AS alias1, `t8` AS alias2, `t5` AS alias3 ) WHERE alias1.`col_date` IS NULL  /* QNO 17789 CON_ID 19 */  ) cte1;
      field1	cfield1
      

      --source include/have_innodb.inc
      --enable_connect_log
      --disable_abort_on_error
      SET GLOBAL event_scheduler = OFF;
      CREATE USER rqg@localhost;
      GRANT ALL ON *.* TO rqg@localhost;
      --connect (con9,localhost,rqg,,test)
      --let $con9_id = `SELECT CONNECTION_ID() AS con9`
      	SELECT VERSION();
      	SET optimizer_switch=(SELECT variable_value FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES WHERE VARIABLE_NAME='optimizer_switch');
      	SELECT DATABASE();
      	SELECT CONNECTION_ID();
      	SELECT CURRENT_USER();
      	DROP TABLE /*! IF EXISTS */ t1 /* QNO 1 CON_ID 9 */;
      	SHOW WARNINGS;
      	CREATE TABLE t5 (
       col_enum ENUM('','a','b','c','d','e','f','foo','bar') NOT NULL DEFAULT '',
       col_date DATE NOT NULL DEFAULT '1900-01-01',
       col_char CHAR(74) NOT NULL DEFAULT '',
       col_varchar VARCHAR(893) NOT NULL DEFAULT '',
       col_timestamp TIMESTAMP(1) NOT NULL DEFAULT '1971-01-01 00:00:00',
       col_datetime DATETIME(3) NOT NULL DEFAULT '1900-01-01 00:00:00',
       col_year YEAR NULL,
       pk INTEGER AUTO_INCREMENT,
       col_int SMALLINT(10) NOT NULL DEFAULT 0,
       col_dec DECIMAL(25,0) ZEROFILL NULL,
       col_blob MEDIUMTEXT NULL,
       col_bit BIT(32) NULL,
       col_time TIME(2) NOT NULL DEFAULT '00:00:00',
       PRIMARY KEY(pk)
       ) ENGINE=InnoDB /* QNO 51 CON_ID 9 */;
      	CREATE ALGORITHM=TEMPTABLE VIEW view_t5 AS SELECT * FROM t5 /* QNO 52 CON_ID 9 */;
      	ALTER TABLE t5 ADD INDEX(pk,col_time) /* QNO 53 CON_ID 9 */;
      	ALTER TABLE t5 ADD INDEX(col_date,col_timestamp,col_dec,col_datetime) /* QNO 54 CON_ID 9 */;
      	ALTER TABLE t5 ADD INDEX(col_timestamp,pk,col_year) /* QNO 55 CON_ID 9 */;
      	ALTER TABLE t5 ADD INDEX(col_datetime,col_varchar(64),col_int,col_year) /* QNO 56 CON_ID 9 */;
      	ALTER TABLE t5 ADD INDEX(col_char(64),col_timestamp) /* QNO 57 CON_ID 9 */;
      	ALTER TABLE t5 ADD INDEX(col_char(64)) /* QNO 58 CON_ID 9 */;
      	ALTER TABLE t5 ADD INDEX(col_blob(64),col_varchar(64),pk,col_date) /* QNO 59 CON_ID 9 */;
      	START TRANSACTION /* QNO 60 CON_ID 9 */;
      	INSERT IGNORE INTO t5 (col_enum,col_date,col_char,col_varchar,col_timestamp,col_datetime,col_year,col_int,col_dec,col_blob,col_bit,col_time) VALUES
       ('','2003-04-25','u','u','1972-04-20 03:40:34.013239','1973-01-27 07:36:25.034892',2014,8,0.7105712890625,'',b'00001010100101','02:34:42.049654'),
       ('','2021-01-20','trql','rq','2032-01-14 03:00:54.007011','2010-09-07 03:21:02.002206',2019,44,0.628067016601562,'b',b'0000111011011','12:37:39.000554'),
       ('','1977-08-18','qluy','luyx','2020-02-21 00:00:00','2003-07-24 12:41:51.056169',1980,4,0.369583129882812,'uy',b'010101101100011100','04:45:53.016719'),
       ('','1983-04-15','p','yxhr','1975-06-20 00:00:00','1987-07-06 00:00:00',2030,8,0.062042236328125,'xhrdo',b'0011100001100011010000111111','17:38:23.031821'),
       ('','1981-06-11','h','rdo','1982-12-17 21:50:51.040861','1996-04-20 23:16:54.049805',1988,4,0.581253051757812,'dodx',b'000000110','09:56:18.028618'),
       ('','1973-04-28','odxqqjwasfkvetfobocgpftrhvxugmmszwpoglvarsf','dxqqjw','1900-01-01 00:00:00','1900-01-01 00:00:00',1974,7,NULL,'d',b'01','08:39:11.018444'),
       ('','2025-09-06','','xqqj','2020-09-27 21:55:43.017671','1997-03-04 03:05:42.020233',2020,9,0.610305786132812,'',b'101011001010110110','07:15:24.012536'),
       ('','2034-11-23','q','qjwas','1978-02-07 13:38:08.043401','2028-04-01 00:00:00',1971,2,0.56903076171875,'jw',b'00110100100111000011111','14:00:23.037365'),
       ('','1993-09-19','[true,0,NULL,false,0,false,0]','','1971-01-17 16:58:15.061419','2024-08-04 08:42:30.032191',2025,8,0.952224731445312,'wa',b'100010001000100001101001011','11:03:51.037078'),
       ('','1900-01-01','asfkvet','sfkve','2011-03-11 00:00:00','2032-08-02 00:00:00',2032,1,0.354217529296875,'[false]',b'111110010110111100100100','09:07:09.017161'),
       ('','1975-07-05','fkv','kve','2024-02-09 15:17:38.009329','2032-03-21 00:00:00',1978,7,0.755447387695312,'v',b'0000001110100100100101','19:05:22.043700'),
       ('','2032-08-18','{}','etfoboc','2032-06-24 08:03:06.036247','2018-05-18 04:57:35.003385',1988,225,NULL,'tf',b'00011','17:22:59.009669'),
       ('','2000-12-03','f','ob','1983-06-06 00:00:00','1999-08-24 00:00:00',2012,2,0.02020263671875,'b',b'00011101',NULL),
       ('','2020-01-24','w','ocgp','2000-02-21 03:48:13.019071','1976-03-21 00:00:00',NULL,0,0.689483642578125,'["cgpftrhvxugmmszwpoglvarsfil","gpftrhvxugmmszw",true]',b'111111100111110',NULL),
       ('','2020-11-18','m','{"now": "pftrhvxugmmszwpoglvarsfiljrzimqeplev","right": NULL,"right": 0}','2011-02-01 19:50:27.014927','2033-11-09 10:27:57.044671',2017,0,0.82269287109375,'',b'10010111011101111100','15:12:48.029595'),
       ('','2027-02-24','ftr','[false]','1900-01-01 00:00:00','2003-05-09 21:48:54.032489',2034,9,0.0247802734375,NULL,b'10100000010110110010010101111',NULL),
       ('','1984-11-13','{"on": true,"didnt": false}','trhvxugmmszwpoglvarsfiljrzimqeplevleqdhepkhcfrahcpjjvhkkwblfenfpetwejamgeefplsksusqvazujabvkfekxhnemklzergshgvtqekglkhirmzlqye','2025-01-01 19:48:31.047304','2000-11-10 18:45:10.028047',1987,3,0.858062744140625,'[0,0,0,"rhvxugmmszwpoglvarsfiljrzimqeplevleqdh","hvxugmmszwpoglvarsfil","vxugmmszwpoglvar"]',b'110101101100100010011001101011','06:35:05.012218'),
       ('','2019-01-05','x','ugmmszwpoglvarsfiljrzimqeplevleqdhepkhcfrahcpjjvhkk','2013-05-28 00:00:00','2034-03-16 00:00:00',1989,8,NULL,'gmmsz',b'0000001100','10:36:23.016350'),
       ('','2035-04-25','mmszwpog','mszwp','2010-11-09 09:42:50.047894','1900-01-01 00:00:00',2010,6,0.17926025390625,'s',NULL,NULL),
       ('','1990-05-11','d','z','2015-09-06 02:08:56.055172','1985-02-19 09:57:42.019025',NULL,2,0.35491943359375,'',b'101001110001111000000001111','00:44:40.044744'),
       ('','1900-01-01','wp','poglvarsfiljrzimqeplevle','2024-04-22 04:08:13.000182','1996-04-03 00:00:00',NULL,3,0.289382934570312,'',b'1001','16:22:06.019452'),
       ('','1981-09-02','ogl','g','1999-02-18 00:00:00','2022-08-05 21:08:38.026023',NULL,8,0.0214691162109375,'l',b'010010010110110010110010','18:39:54.003157'),
       ('','2006-03-27','var','ars','2000-08-04 04:30:01.034653','2001-06-12 01:57:21.028690',1998,0,0.232376098632812,NULL,b'0001110011110110111','00:03:16.057308'),
       ('','2009-04-21','w','rsfiljrzimqeplevleqdhepkhcfrahcpjjvhkkwblfenfpetwejamgeefplsksusqvazujabvkfekxhnemklzergshgvtqekglkhirmzlqyeqtfopugfcdfubqoeujfhnpgthomsfusbhugmvurbryqqcbkhankkwoalodixeuhwkzwfdbrwmpkhdfocdcjrxxihtvzdfvdanvsodxuroztqcmuxmpjisqdkfykpraagyrwswotqllacxfargqphiaxjbjptzyomlqmecqikprnstjejxktdnhiudznoasbvoavryrpktcczmhdl','1987-08-13 19:22:20.058473','2004-05-27 07:43:38.042269',NULL,5,0.785690307617188,'{"like": "sfiljrzimqep"}',b'01011001111001100000111010011101','18:30:57.024160'),
       ('',NULL,'fi','il','2008-09-13 00:00:00','2021-04-01 10:45:25.041683',1981,4,0.211288452148438,'r',b'0000','14:14:57.065311'),
       ('','2027-09-12','{"really": 0,"up": "ljrzimqeplevleqdhepkhcfr","go": NULL,"come": "jrzimqep","been": false,"I": 0,"here": true}','','2013-01-05 15:29:51.010589','2035-06-20 00:00:00',2003,1,0.224700927734375,NULL,b'10111101001011',NULL),
       ('','2012-03-07','zimqe','imqe','1992-06-10 09:23:18.051063','2026-10-15 00:36:25.015877',NULL,2,0.873046875,'mqe',b'101011011011011001111','19:45:57.038585'),
       ('','1975-06-27','v','qe','1992-12-19 05:45:04.003839','1980-11-10 00:00:00',NULL,8,0.553298950195312,'',NULL,'12:19:19.003354'),
       ('','1900-01-01','epl','[false,NULL,true,0,"p","levleqdhepkhc",NULL]','2014-06-01 07:28:28.026282','1982-10-24 00:00:00',NULL,6,0.284530639648438,'e',b'11101011110101000000','03:55:17.012730'),
       ('','1985-06-13','vleqdhepkhcfrahcpjjvhkkwblfenfpetweja','l','1981-01-22 17:11:27.050395','2019-02-23 05:42:51.033210',2020,0,0.839584350585938,'e',b'011111010000','00:00:00'),
       ('','2006-04-27','qd','d','1993-08-08 15:06:16.035467','1990-03-17 23:47:07.054110',NULL,2,0.161529541015625,'he',b'01100001','11:14:48.003396'),
       ('','1900-01-01','epkhcf','pk','1996-11-24 22:01:02.047096','2014-02-17 23:05:34.059924',2003,9,0.850265502929688,'kh',b'1110011011111001100001000011','22:38:42.025460'),
       ('','2005-04-10','hcfrahcpjjvhkk','[false,0,false]','2008-03-11 09:41:29.035349','2009-02-18 20:10:42.036864',2009,7,0.65069580078125,'{"dont": "cfrahcpjjvhkkwblf","good": 0,"come": false,"see": "frahcpjjvhkkwblfe"}',b'0111100001110010100110111111001','23:07:13.015259'),
       ('','2026-11-06','rahcpj','ahcpjjvhkkwblfenfpetwejamgeefplsksusqvazujabvkfekxhnemklzergshgvtqekglkhirmzlqyeqtfopugfcdfubqoeujfhnpgthomsfusbhugmvurbryqqcbkhankkwoalodixeuhwkzwfdbrwmpkhdfocdcjrxxihtvzd','1984-03-28 20:29:41.047232','2034-02-13 00:00:00',NULL,6,0.480789184570312,'hc',b'111001001011110110100','02:51:53.059372'),
       ('','1900-01-01','cp','','1989-02-24 00:00:00','2024-06-19 20:35:03.033888',2035,2,0.0534515380859375,NULL,b'0100','21:36:17.059129'),
       ('','1900-01-01','{}','b','2010-06-11 19:17:13.064248','2003-01-16 00:00:00',1979,2,0.676620483398438,'{"hes": true,"what": NULL}',b'10110101101011010011001010','04:29:17.065224'),
       ('','2026-06-13','jj','jvhkk','2002-01-14 22:20:59.011813','1989-11-10 18:09:08.004168',2028,8,0.606674194335938,'vhkk',NULL,'05:09:11.064553'),
       ('','2028-05-14','hkkw','{"okay": NULL,"dont": "kkwblfenf","it": 0}','1985-04-04 07:24:07.038850','1990-06-28 16:17:13.050513',NULL,3,0.718887329101562,'kw',b'11101100000001010101001','00:00:00'),
       ('','2008-05-06','[false,true,NULL,true,0]','["wb",true,"blfenfpetwejamgeefplsksusqvazujabvkfekxhne","l","fenfpetwejamgeefplsksusq",false,0]','1978-08-04 21:51:47.027462','1986-10-12 00:00:00',NULL,1,0.357345581054688,NULL,b'001011001000011100010','17:25:40.062290'),
       ('','2001-09-06','enfp','nfp','2005-05-27 17:49:29.005791','2023-04-07 19:20:52.024408',2014,0,0.639175415039062,'',b'0100011','04:17:55.034634'),
       ('','1985-05-06','fpet','{"when": "pe","at": "etwejam","it": NULL,"want": NULL,"can": [0,false,""]}','2005-03-27 19:38:10.028347','1973-05-05 21:55:41.052391',2027,3,0.806976318359375,NULL,b'01001111001000','15:00:19.012367'),
       ('','1983-11-08','{"been": false,"it": 0,"hes": NULL,"about": 0,"didnt": "wejam","there": false,"oh": "ejamgeefplsksusqvazujabvkfekxh"}','e','1974-02-28 11:25:55.026587','1973-03-01 20:44:44.020424',2022,6,0.3375244140625,'[]',b'0101111110000100000111100101','06:02:45.043389'),
       ('','2014-02-28','jamgeef','f','2003-03-19 00:00:00','1998-07-25 00:00:00',1994,108,0.935882568359375,'am',b'10010110','12:26:50.002134'),
       ('','2008-04-12','mge','geefp','2010-03-05 13:35:56.008894','1973-04-14 00:00:00',1972,4,0.669387817382812,'eef',NULL,'07:35:18.064063'),
       ('','2026-06-20','efp','fp','1993-05-16 05:13:47.005449','2008-12-27 07:22:36.018568',1997,4,0.28515625,'{"okay": "plsksusq","up": "l","good": false,"not": false,"had": 0,"so": true}',b'1101111111101100011101010100','00:49:01.040403'),
       ('','2007-07-20','','s','1999-02-15 20:49:53.056890','1996-10-28 00:00:00',1988,0,0.909088134765625,'',b'0101110100','00:00:00'),
       ('',NULL,'ksu','susqva','2000-07-28 02:54:46.030415','1997-09-27 17:24:49.009516',2025,0,0.118576049804688,'us',b'11','20:09:18.029823'),
       ('','2025-12-28','sqvazujabvkfekxhn','f','1989-07-21 19:03:30.018626','1900-01-01 00:00:00',1990,5,0.819717407226562,'qv',b'01','11:19:35.062342'),
       ('',NULL,'v','["azu","zujabvkfekxhnemklzer","uj",NULL,NULL]','2030-10-02 08:09:18.040880','1979-06-18 08:52:59.031081',1987,1,0.54052734375,'p',b'1111010001','19:55:51.050495'),
       ('',NULL,'j','p','1900-01-01 00:00:00','1975-04-16 10:10:59.026735',2025,2,0.039398193359375,'',b'01010','07:41:03.027768'),
       ('','2006-10-22','[true,0]','ja','2013-05-04 10:03:52.015881','2027-06-25 00:00:00',1999,9,0.175155639648438,'ab',b'101','22:33:52.062768'),
       ('',NULL,'','bvkf','2025-01-19 05:46:11.001397','1991-08-28 21:16:50.040935',1980,5,0.539077758789062,'vk',b'011011',NULL),
       ('','2032-12-11','','[true,true,false]','1992-01-02 22:24:09.009511','2003-09-18 20:09:31.030164',2016,9,0.0834503173828125,'kfe',b'1011011101100010010010011',NULL),
       ('','1995-08-15','fekxhnemklzergshgvt','p','2010-04-05 07:24:29.024647','2020-11-02 00:00:00',1988,7,NULL,'e',NULL,NULL),
       ('','2017-11-05','k','','2005-06-09 02:04:12.024173','2014-02-02 09:19:01.007748',2029,9,NULL,'xh',b'10001111101000111','00:00:00'),
       ('','1900-01-01','hnemk','n','2022-03-06 12:17:16.001206','1900-01-01 00:00:00',2020,4,0.921096801757812,'',b'111110000101000000101101110',NULL),
       ('','1900-01-01','em','m','2008-06-12 19:53:09.057868','1972-07-09 16:42:48.052789',NULL,8,0.370712280273438,'h',b'0000111000001001010001001','14:59:09.061846'),
       ('','1900-01-01','','[0,false,0,{"are": 0,"are": NULL,"think": 0,"back": "klzergshgvtqekglkhirmzlqyeqtfop"},NULL]','1994-07-27 21:30:47.016047','2034-08-02 01:47:55.020300',2023,8,0.807861328125,'a',b'110000011011010111101','04:17:24.007520'),
       ('','2023-02-17','lzergs','{"hey": false,"know": NULL,"Im": 0,"be": 0,"hes": {"then": true,"well": false},"tell": 0,"did": {}}','1997-03-23 19:23:03.001579','1995-12-07 00:00:00',2010,4,0.313674926757812,'ze',b'1000000100100','17:32:31.017642'),
       ('','1989-10-18','ergshgvtqekglkhirmzlqyeq','','2001-02-09 03:37:48.023009','2002-01-16 17:11:04.064835',2010,4,0.818130493164062,'rgs',b'001101101011100111101000','10:00:31.013701'),
       ('','1972-08-03','[NULL,true,"gshgvtqek",true,"shgvtqekglkhirmzlqyeqtfopugfcdfubqoe",true,0]','h','2016-02-11 10:13:49.041158','2016-03-15 12:26:26.011209',1992,7,0.164520263671875,NULL,b'111001000111000000111010100','21:36:42.057547'),
       ('','2032-10-28','gv','','2007-08-22 22:36:11.019144','2030-11-01 02:43:45.035135',1995,5,0.508956909179688,'v',NULL,'17:28:33.024858'),
       ('','1997-11-10','[false]','vtq','2020-11-08 01:19:37.039141','1900-01-01 00:00:00',2010,7,NULL,'tqekg',NULL,'00:04:13.054254'),
       ('','1976-11-16','qekglkh','e','2030-09-27 03:54:21.038086','2019-08-05 17:26:04.038819',1980,5,0.733367919921875,'',NULL,'07:24:58.015614'),
       ('','2023-10-20','k','glkh','1988-12-22 00:00:00','2033-02-20 18:26:13.056860',2023,0,0.409683227539062,'',b'10','11:59:15.033473'),
       ('','1973-12-10','lkhir','khirmz','1983-02-01 06:39:57.011305','2021-07-11 00:00:00',2009,2,NULL,'{"about": NULL,"is": 0}',b'00011110',NULL),
       ('','1998-08-22','hi','i','2031-07-16 05:02:50.006382','2004-03-03 00:00:00',1994,2,NULL,'rmzlq',NULL,'02:28:27.055432'),
       ('','2018-03-09','','mzlqyeqtfopugfcdfubqoeujfhnpgthomsfusbhugmvurbryqqcbkhankkwoalodixeuhwkzwfdbrwmpkhdfocdcjrxxihtvzdfvdanvsodxuroztqcmuxmpjisqdkfykpraagyrwswotqllacxfargqphiaxjbjptzyomlqmecqikprnstjejxktdnhiudznoasbvoavryrpktcczmhdlcserqvakahjtesmgifltnefitzufcefqqmfokivsitbedsjzuvsjghsldzxndyqrnlbdgwcjxyuoyxkuhxeszommzdtwlfrvfcrogfdttnnkvhgrlhibykvacxgqpfomtdxswhuhnrhjauvubionbzrimkgktr','1900-01-01 00:00:00','2016-12-09 06:07:55.003683',1989,2,0.88201904296875,NULL,b'0010010101101011101','10:58:27.053811'),
       ('','1900-01-01','l','r','2002-03-07 00:00:00','1900-01-01 00:00:00',NULL,8,0.190704345703125,'q',b'010001010110','07:00:45.008818'),
       ('','1972-11-14','l','y','2000-03-14 23:28:46.059822','2011-04-14 05:02:15.025452',2019,0,0.305526733398438,'y',b'1000001010101000111010010','01:38:32.045710'),
       ('','2011-09-22','eq','{"youre": false,"all": "qtfopug"}','2025-05-20 00:27:07.052302','2000-04-07 06:26:21.000341',NULL,3,0.55609130859375,'tfopu',b'11001000101010010011110011','00:00:00'),
       ('','1980-06-07','fop','{"know": 0,"will": {"for": 0,"can": 0,"do": 0,"the": true}}','1979-05-07 06:50:31.046826','1900-01-01 00:00:00',2026,7,NULL,'[]',NULL,'05:22:45.014634'),
       ('','2033-12-21','','opugfc','1974-06-22 08:58:56.004154','1990-04-25 00:00:00',1978,139,0.866592407226562,NULL,b'0110010010000101101111111','22:25:26.052529'),
       ('','1988-04-23','ugfcdfubqoeujfhnpgthomsfusbhugmvu','gfc','1900-01-01 00:00:00','2010-09-10 08:28:39.009780',2016,5,0.0544281005859375,'',b'010101100100001100010110','00:00:00'),
       ('','2030-09-07','fc','[NULL,0,0,true,0]','1991-05-08 14:31:44.026283','1972-04-04 22:00:57.061747',NULL,6,0.55181884765625,'',b'1','02:12:43.043656'),
       ('','2027-05-13','o','cdfubq','1900-01-01 00:00:00','2017-06-15 20:52:14.044362',2000,9,0.537506103515625,NULL,b'110101','16:47:52.011968'),
       ('','1973-10-07','fubqo','u','1993-10-24 04:31:45.043253','1998-06-09 09:45:10.021413',2026,2,0.192901611328125,'bq',b'0101','18:39:16.030279'),
       ('','1987-04-14','qoeujfhnpgthomsfus','{"now": "oeujfhnpgthomsfusbhugmvurbryqqcbkhankkwoal","dont": 0,"were": 0,"it": false,"not": 0}','1996-10-03 00:00:00','2031-08-23 01:48:59.001260',2018,8,0.607589721679688,'e',NULL,'10:30:21.043974'),
       ('','2002-04-07','u','jfhnpg','1900-01-01 00:00:00','2026-10-03 02:16:41.001813',2004,0,0.832611083984375,'fh',b'1111010010101101001100001','18:49:44.055947'),
       ('','1979-07-19','hnpgt','npgthomsfusbhugmvurbryqqcbkhankkwoalodixeuhwkzwfdbrwmpkhdfocdcjrxxihtvzdfvdanvsodxuroztqcmuxmpjisqdkfykpraagyrwswotqllacxfargqphiaxjbjptzyomlqmecqikprnstjejxktdnhiudznoasbvoavryrpktcczmhdlc','1973-04-14 20:58:48.007644','2025-02-05 04:14:14.054631',1976,7,0.0850982666015625,NULL,b'100','19:09:56.028309'),
       ('','2029-04-04','gt','[true]','1900-01-01 00:00:00','1987-05-08 00:00:00',2012,76,0.927398681640625,'t',b'01110010000001010011000011110101','18:19:40.019925'),
       ('',NULL,'f','h','1981-12-10 15:49:50.063247','2005-11-25 00:00:00',2024,0,0.19134521484375,'{}',NULL,'09:44:18.032640'),
       ('','1900-01-01','omsf','z','2007-03-13 13:53:00.025566','2027-08-22 00:00:00',2021,7,0.8145751953125,NULL,b'0011100000','00:01:54.000256'),
       ('','2025-03-27','sf','fusbhugmvurbryqqcbkhankkwoalodixeuhwkzwfdbrwmpkhdfocdcjrxxihtvzdfvdanvsodxuroztqcmuxmpjisqdkfykpraagyrwswotqllacxfargqphiaxjbjptzyomlqmecqikprnstjejxktdnhiudznoasbvoavryrpktcczmhdlcserqvakahjtesmgifltnefitzufcefqqmfokivsitbedsjzuvsjghsldzxndyqrnlbdgwcjxyuoyxkuhxeszommzdtwlfrvfcrogfdttnnkvhgrlhibykvacxgqpfomtdxswhuhnrhjauvubionbzrimkgktrrxxdmguucqulwflxtnbvgqazmatrlfcpqdjzbyottttfezenwvxcdxpwdpolkniqzzdwoqnghixsjyoixuyqrdnahimtkdvjbeirucdkuykhtflxkzoiwimuljxdmazuguiuyyemoefwkptnpdnxobwuxplmihguaulybsxuogtmpmzdxsxgnpekolinzppighwyorqbeeikqlffesqekhmnbyflpwhihyfqexbzqllzydyptbwcmevpcmachjajxlcevjcezyvfndoulcceseebtfwteegsrysegyqzgaovjslcgxpzqoxlqejnumjojibwhbnqrmuahrrhkjrrizzulqclpzkfalbrtjcglxrhszefsxjeipujlawnhfnfesxlfcjsbwbwdxuuerdsygghanloqtmyexed','2034-03-15 03:18:19.040555','2001-07-02 22:34:26.016947',2006,2,0.74444580078125,'us',b'01000001101100','19:28:04.028200'),
       ('','1900-01-01','sbh','bhugmvurbryqqcbkhankkwoalodixeuhwkzwfdbrwmpkhdfocdcjrxxihtvzdfvdanvsodxuroztqcmuxmpjisqdkfykpraagyrwswotqllacxfargqphiaxjbjptzyomlqmecqikprnstjejxktdnhiudznoasbvoavryrpktcczmhdlcserqvakahjtesmgifltnefitzufcefqqmfokivsitbedsjzuvsjghsldzxndyqrnlbdgwcjxyuoyxkuhxeszommzdtwlfrvfcrogfdttnnkvhgrlhibykvacxgqpfomtdxswhuhnrhjauvubionbzrimkgktrrxxdmguucqulwflxtnbvgqazmatrlfcpqdjzbyottttfezenwvxcdxpwdpolkniqzzdwoqnghixsjyoixuyqrdnahimtkdvjbeirucdkuykhtflxkzoiwimuljxdmazuguiuyyemoefwkptnpdnxobwuxplmihguaulybsxuogtmpmzdxsxgnpekolinzppighwyorqbeeikqlffesqekhmnbyflpwhihyfqexbzqllzydyptbwcmevpcmachjajxlcevjcezyvfndoulcceseebtf','1900-01-01 00:00:00','1997-10-14 19:23:10.057256',1990,9,0.414871215820312,'[]',b'00001001001111','21:12:09.041048'),
       ('','2034-11-28','hugmv','','1985-08-15 06:54:19.021531','1998-03-23 18:55:13.045887',2000,1,0.727890014648438,'r',b'0100110000111010111','21:49:20.060337'),
       ('','1980-08-27','ug','{"about": "gmvurbryqqcbkhankkwoalodix","good": false}','1900-01-01 00:00:00','1992-08-10 23:50:42.016350',2006,4,0.226974487304688,'',b'010110100010101','00:00:00'),
       ('','1900-01-01','mvu','vurb','2020-01-11 20:03:56.016472','2003-02-24 12:13:52.045702',1995,4,0.67095947265625,'urbr',b'11010011111110100','20:44:10.058536'),
       ('',NULL,'[NULL,false]','r','1979-11-08 19:19:23.032762','2021-05-16 04:27:28.060487',2024,3,0.131240844726562,'',b'011011110010111001001111','10:25:38.012828'),
       ('','2020-09-21','bryqqcb','ry','1973-08-25 16:43:37.062700','1998-02-15 09:10:43.024086',NULL,3,0.135269165039062,'',b'0110100010000110','20:58:28.028531'),
       ('','1998-06-17','yqqc','{"some": NULL,"know": "qqcbkh","me": NULL}','1975-09-26 08:04:12.043821','1988-01-02 00:00:00',1973,168,0.69268798828125,'u',b'00000001001110111','03:49:49.060416'),
       ('','2035-01-02','q','cbk','2010-07-08 05:26:21.062351','2002-04-11 00:00:46.032988',1994,6,0.361404418945312,'[NULL,false,true]',b'00110101010','06:16:17.054581'),
       ('','2031-04-04','','["bk",true,false,"khankkwoalodixeuhwkzwfdb",false,NULL]','2014-03-24 00:00:00','1988-07-16 09:32:15.054143',2027,3,0.790542602539062,'',b'01111','15:38:25.031925'),
       ('','2018-04-06','t','hankkwoa','2023-11-13 21:46:38.014742','2015-10-19 00:00:00',1986,7,0.667831420898438,NULL,b'0001001','19:20:54.020359'),
       ('','1983-07-05','n','k','2030-07-24 04:30:34.010953','2002-12-24 07:33:50.058779',1974,7,0.17578125,'',b'11111101100001001110101','01:31:33.034968'),
       ('','2009-10-04','[0,"kwoalodixeuhwkzwfdbrwmpkhd"]','[NULL,true,NULL,true]','2020-08-04 00:00:00','1991-06-18 05:54:30.033496',2016,3,0.600662231445312,'woal',b'11',NULL),
       ('',NULL,'x','{"this": true,"because": NULL,"at": NULL,"didnt": 0}','2031-10-02 05:30:43.023194','2021-05-09 00:00:00',2026,3,0.147964477539062,'oalo',b'00010011011011011','13:39:15.026594'),
       ('','1981-06-18','al','lod','1973-07-27 07:56:36.047082','1900-01-01 00:00:00',1995,1,0.0956573486328125,'od',b'010101100011110011010010001100','04:04:25.044087'),
       ('','1900-01-01','{"ok": "dixeuhwkzwfdbrwmpkhdfocdcjrxxihtvzdfvdanvsodxur","have": "ixeuhwkzw","I": 0}','["x","euhwkzwfdbrwmpkhdfocdcjrxxihtvzdfvdanvsodxuroztqcmuxmpjisqdkfyk"]','1984-07-01 00:00:00','2009-01-10 07:21:40.058222',NULL,2,0.931106567382812,'',b'10101110010010111000000','00:00:00'),
       ('','1989-07-10','uhwkzwf','hw','1900-01-01 00:00:00','1900-01-01 00:00:00',1974,5,0.0133209228515625,'w',NULL,'15:40:49.018937'),
       ('','1900-01-01','kz','zw','2008-03-20 13:32:57.003636','1900-01-01 00:00:00',NULL,7,0.955184936523438,'wfdbr',NULL,'15:18:38.043412'),
       ('','1991-04-15','fdb','','2013-12-14 14:43:36.019025','2023-02-20 14:31:15.007807',1989,5,0.95782470703125,'db',b'0111','19:49:51.021668'),
       ('','1985-12-21','brwmpkhd','rw','2013-04-18 05:05:28.051540','2005-11-18 00:00:00',2009,151,0.674270629882812,'wmpk',b'010000001101','17:03:35.030274'),
       ('','2029-05-11','mp','{"youre": false,"on": 0}','1976-05-21 10:56:53.059618','2027-10-21 15:39:01.021206',2000,5,0.743667602539062,'pk',b'1100','05:20:04.050280'),
       ('','2018-06-22','khdfocdcjrxxihtvzdfvdanvsodxuroztqcmuxmpjisqdkfykpraagyrwswo','hdf','2004-10-24 00:00:00','2001-02-17 00:00:00',2000,8,0.115341186523438,'d',NULL,'01:37:26.022055'),
       ('','2016-06-21','d','f','1973-06-02 22:47:29.039241','2008-11-03 10:56:58.053949',2024,3,0.267166137695312,NULL,b'0000101011010111111','10:10:42.021874'),
       ('','2017-10-24','k','c','2028-10-25 00:00:00','2018-03-02 12:59:56.021378',1977,5,0.426193237304688,'dcjrxx',b'1000010011','00:00:00'),
       ('',NULL,'c','jrxxi','2013-08-21 17:07:34.023211','1996-04-25 00:00:00',2016,8,0.35906982421875,'{"in": ""}',b'10110001010','14:47:07.062397'),
       ('','2020-07-16','[0,"rxxi",0,false]','x','2005-12-05 00:00:00','2018-08-12 23:22:57.011536',1988,7,0.451583862304688,'',b'1010001011000011001100100011001','13:15:19.014654'),
       ('','2022-05-08','xi','ihtv','1986-05-08 00:00:00','1900-01-01 00:00:00',2025,2,0.185577392578125,'',b'0001111','00:00:00'),
       ('','2022-07-28','htvzd','tv','1988-11-25 14:59:11.053571','1996-06-12 14:07:17.051457',2030,6,0.994140625,'vzdf',b'0000001011101','00:50:33.053889'),
       ('','1987-11-11','zdfv','dfvda','2007-09-26 05:37:51.048674','2030-12-09 00:00:00',1997,2,0.375946044921875,'r',b'0101110101011',NULL),
       ('','2007-12-02','fvdanvsodxurozt','{"a": 0,"were": false,"good": 0}','2028-08-06 02:40:34.041753','1984-07-10 00:06:14.037330',1976,2,0.720474243164062,'{"will": 0,"know": false,"for": "vdanvsodxuroz","from": "h","who": "dan"}',b'010100','15:17:49.035745'),
       ('','1982-12-13','z','{"it": "anvs","yeah": false,"if": 0,"see": false}','1987-05-05 15:35:37.039721','1900-01-01 00:00:00',1979,4,0.267715454101562,'c',b'00000010',NULL),
       ('','2028-01-06','n','vsod','1996-11-28 10:11:36.033706','2008-10-04 05:31:37.013655',NULL,5,0.695022583007812,'["sodxuroztqcmuxmpj",NULL,0,NULL]',b'100','22:56:32.036730'),
       ('','2026-08-07','odx','d','1996-02-26 06:50:42.053364','1900-01-01 00:00:00',1993,6,0.064239501953125,'[]',b'000110','13:25:08.030694'),
       ('','1900-01-01','xu','uro','1999-12-16 03:12:05.009490','2005-10-27 02:07:53.016764',1978,7,0.505416870117188,'rozt',b'0000100000011011011101010','10:19:53.032669'),
       ('','1973-01-13','oztq','ztqcm','2011-02-26 15:34:56.019203','2003-11-07 00:00:00',1977,1,0.8104248046875,NULL,NULL,'17:08:37.008961'),
       ('','2007-11-26','[false,true]','tqcm','2022-08-03 22:50:32.009621','2007-08-22 05:21:06.030050',NULL,4,0.305068969726562,'{"with": [0,"qc","c"],"what": "muxmpj","up": 0}',b'0001111110001','11:52:26.045644'),
       ('','2020-08-27','w','uxm','1992-11-24 00:00:00','2001-01-08 00:00:00',1995,9,0.221221923828125,'{"I": "xmpjisqdkfykpraagyrwswotqllacxfa","tell": true,"my": false,"something": NULL,"your": {"at": true,"oh": 0,"really": true,"about": 0}}',b'011110100000101101111011101','10:52:59.026597'),
       ('','2002-08-16','mpjisq','','1977-08-11 10:29:31.001090','2032-04-02 09:18:06.016064',2034,3,0.845016479492188,'pjis',b'110000001011110010','09:44:38.021834'),
       ('','2034-12-21','[true,true]','jisq','1900-01-01 00:00:00','1977-07-25 14:48:10.000587',2026,6,0.24530029296875,'i',b'1101100100111010011100','13:12:24.002171'),
       ('','2035-11-26','sqdk','l','1996-09-10 00:00:00','1985-10-05 06:50:38.053539',1990,5,0.0859222412109375,'',b'0100000011','21:44:02.004517'),
       ('','1981-03-05','qd','dkf','2034-08-03 00:00:00','2031-11-02 21:25:54.035772',1981,134,0.679367065429688,'',NULL,'09:06:44.031732'),
       ('',NULL,'{"no": "kfykpr","are": NULL,"didnt": 0}','f','1995-07-15 11:26:37.032674','1986-08-18 12:53:04.040992',NULL,7,0.104751586914062,'yk',b'0010','00:01:33.029637'),
       ('','2030-01-11','kp','p','2012-10-22 21:32:42.040689','1991-08-22 10:59:00.024071',1998,4,0.857925415039062,'{"cant": NULL,"they": 0,"they": true}',b'11101010111','20:39:06.031551'),
       ('','2033-05-25','','raag','1991-09-07 00:00:00','2013-03-27 00:00:00',NULL,2,0.836700439453125,'a',b'00001010','09:58:12.055447'),
       ('','1972-02-15','agyrwswotqlla','gy','1986-04-07 14:28:54.052468','1972-09-15 10:36:21.037234',2002,1,0.740921020507812,'[NULL,NULL,0,true,false,"yrwswotqllacxfargqphia",NULL]',b'1001101111110101000001011','18:11:17.003253'),
       ('',NULL,'rws','{"him": "wswotqllac","Ill": "swotqllacxfargqphi","they": NULL,"ok": "wotqllacxfargqphiaxjbjp","me": 0}','1981-08-12 00:00:00','1995-02-09 00:00:00',2026,1,NULL,'otq',NULL,'03:52:20.053722'),
       ('','2008-09-21','["tql",0,true,0]','q','2015-02-07 11:30:15.040187','1900-01-01 00:00:00',2031,7,0.917678833007812,'',b'011101101101','18:18:43.044601'),
       ('','1978-05-19','l','lacxf','2031-01-19 22:49:34.063859','2033-01-05 17:55:29.037878',2009,1,0.695022583007812,'acxfa',b'0010100001111','18:12:59.031030'),
       ('','2015-04-18','cxf','','2032-01-28 11:58:31.025351','1993-01-03 00:00:00',NULL,9,0.541397094726562,'',b'0010001100011000000000110011',NULL),
       ('','1978-05-01','{"its": 0,"why": true,"get": false,"who": false}','xfa','1980-05-07 18:21:30.062951','1983-10-04 14:42:21.044663',1992,5,0.46502685546875,'fargqph',b'0','20:21:32.036280'),
       ('','2031-01-12','a','[false,false,true,false,true]','1900-01-01 00:00:00','1996-10-07 17:54:05.044980',2007,1,0.485870361328125,'rgq',b'000100001000101010000101','00:00:00'),
       ('','2022-12-18','gqphiaxjbjptzyomlqmecq','qp','2025-02-28 00:13:47.060810','2018-05-24 07:04:56.024703',1996,0,0.0454864501953125,'phiaxj',b'10010010110100001011110','12:15:24.027593'),
       ('','1994-10-15','hiaxjbjptzyomlqmecqikprnst','i','2004-09-06 23:29:43.000255','1993-12-21 11:30:11.016486',1991,3,0.758987426757812,'axj',b'01000110010001100','06:50:10.064893'),
       ('','2014-05-26','xjb','','2011-01-15 07:14:04.053248','2035-04-12 18:51:59.001208',1993,4,0.248428344726562,'n',b'0001110','04:03:21.053586'),
       ('','1984-06-11','jb','bjp','1984-01-09 00:00:00','1992-03-03 01:22:47.054396',2009,62,0.392166137695312,NULL,b'11110001011100001001101011','20:37:21.026177'),
       ('','1997-02-28','pt','tzyoml','1982-03-12 13:18:55.029827','2012-09-01 05:13:42.013441',2030,45,0.535995483398438,'z',b'0111001000001011011',NULL),
       ('','1982-03-23','{"did": true,"her": false,"okay": "yomlqmecqikprnstjejxktd","something": "omlqmecqikprnstjejxktdnhiudz","its": NULL}','d','2005-10-06 09:20:13.052901','2009-06-24 00:00:00',1973,0,0.996780395507812,'a',b'11011',NULL),
       ('','2017-08-27','m','[]','1980-07-28 22:17:34.007546','1972-05-17 02:43:06.062596',2009,1,NULL,'',b'01111010100101000','02:50:22.065485'),
       ('','1993-08-18','lqme','v','2004-04-13 04:38:55.006747','1992-09-05 00:00:00',2006,4,NULL,'qmec',b'0110101110001111011000010010011','21:00:46.037138'),
       ('','1998-02-10','mecq','ecqikp','1998-07-07 03:49:37.060856','1991-11-12 14:04:54.032020',1982,156,0.811203002929688,'cqi',b'1001101011110001000101100001010','03:50:53.039745'),
       ('','1978-05-24','z','','2005-09-22 03:27:54.060938','1994-04-10 10:49:10.030038',1980,3,0.93817138671875,'q',b'010111001000',NULL),
       ('',NULL,'[0,false,{"we": true,"thats": false},true,false]','ik','2003-10-03 00:23:04.020983','1987-01-04 00:00:00',2000,5,0.232711791992188,'t',b'000000111','09:59:29.040146'),
       ('','1973-07-06','kpr','p','1988-03-03 00:00:00','1998-11-17 00:00:00',2032,8,0.911224365234375,'rn',NULL,'01:42:00.037597'),
       ('','2025-12-05','nstjejxktdnhiudz','stje','2016-10-04 07:17:26.009024','1975-11-09 00:00:00',1984,9,0.193588256835938,'',b'000011011011000111101000101111','22:38:50.052494'),
       ('','2020-03-28','c','tjejxk','2023-11-06 00:00:00','1900-01-01 00:00:00',2002,6,0.791854858398438,'',b'11011100100000','15:40:50.063203'),
       ('','2007-08-17','jej','','2031-06-06 00:00:00','1900-01-01 00:00:00',1997,3,0.566207885742188,'',b'0001000001101',NULL),
       ('','1983-01-25','','f','2009-12-11 18:27:16.002314','2000-06-21 00:00:00',1990,9,0.6693115234375,'["ejxktdnhiudznoasbvoavryrpktcczmhdlcserqvakahjtesmgiflt",0,NULL,false,"jxktdnhiudznoasbvoavryrpktcczmhdlcserqvakahjtesm"]',b'1111011000010010111001010','05:17:44.025267'),
       ('','2011-12-06','xktdnhiudznoasbvoavryr','ktdnhiud','1994-09-23 21:27:49.026109','2012-04-04 02:26:09.009509',2011,38,0.439773559570312,'td',b'011111000111011101000','11:50:18.017839'),
       ('','2009-12-15','dnhiu','','1978-04-28 23:14:19.031438','1985-10-25 03:11:53.014042',2002,3,0.951934814453125,'nhiu',b'01','06:38:20.007447'),
       ('','1994-04-20','hiudznoasbvoavryrp','{"my": "iudznoasbvoavryrp","could": 0,"out": false,"about": "udznoasb","how": true}','1900-01-01 00:00:00','1900-01-01 00:00:00',2007,8,0.602523803710938,'[0,"dznoasbvoavryrpktc",false,true,false,"z","noasbvoavryrpktcczmhdlcserqvakahjtesm"]',b'111','10:25:34.020530'),
       ('','1976-08-09','oa','asbvoavr','2032-07-09 10:05:10.015384','1987-07-26 00:00:00',2029,8,0.713348388671875,'z',b'11111','08:31:12.053120'),
       ('','2028-09-20','f','sbvoa','1900-01-01 00:00:00','1999-06-02 10:07:16.019553',2005,180,0.43023681640625,'["bvoavryrpktcczmhdlcse"]',NULL,'00:00:00'),
       ('','1982-10-16','voavryrp','oavry','2010-05-26 12:29:45.037997','1983-07-03 15:46:10.001335',1991,6,0.308502197265625,NULL,NULL,'15:32:37.049776'),
       ('','2034-09-19','vryrp','ryrpk','2021-03-16 04:41:42.005519','1900-01-01 00:00:00',1996,8,0.862411499023438,'[0,"y",0]',b'111100','03:58:37.012076'),
       ('',NULL,'r','pktcc','1995-10-03 04:49:46.064065','1976-05-14 15:19:39.053712',2011,2,0.770050048828125,NULL,b'10101000111000111010101110010011','02:38:36.008175'),
       ('','1991-03-14','ktcc','tc','1984-08-07 09:49:49.023716','2015-02-28 01:24:31.023100',2006,9,0.113189697265625,NULL,b'001001010','14:34:56.024192'),
       ('','2029-01-13','c','zm','2006-08-18 14:03:06.059968','2025-02-11 09:48:17.023312',1974,14,0.8817138671875,'',b'010101110110110101000010','00:00:00'),
       ('','1992-02-02','[NULL,"mhdlcserqvakahjtesmgifltnefitzufcefqqmfo",false,true,0]','h','2015-09-09 05:47:31.032381','1978-04-20 15:05:33.059228',1974,6,0.405075073242188,'',b'010011000101100000001110001110','13:37:05.041188'),
       ('','2014-09-28','dlcser','lcserqvakahjtesmgifltnefitzufcefqqmfokivsitbedsjzuvsjghsldzx','1900-01-01 00:00:00','2025-01-09 05:12:28.047790',NULL,1,0.519012451171875,'d',b'010','02:10:26.036158'),
       ('','1983-04-08','cs','serqv','2015-10-18 00:00:00','2014-02-24 08:00:38.006765',1985,8,0.148086547851562,'erqvak',b'1001011001001100010110011000','20:25:57.050205'),
       ('','1900-01-01','rq','qvakahj','1973-08-07 18:56:00.023313','1972-04-21 00:00:00',1976,1,NULL,'vaka',b'111101011110','00:00:00'),
       ('',NULL,'{"really": NULL,"at": 0,"my": false,"your": 0}','aka','1986-11-17 12:52:23.032478','2021-09-28 06:41:11.058828',1985,7,0.282424926757812,'',b'1111101101101100','00:00:00'),
       ('','2001-06-03','ka','a','2028-09-04 00:00:00','2031-06-20 00:33:26.047713',2031,8,0.892120361328125,'{}',b'1011010001010010110100101','11:04:22.050132'),
       ('','2014-11-15','hjtesmgi','[false,0]','1900-01-01 00:00:00','1900-01-01 00:00:00',2004,7,0.377166748046875,NULL,b'001011100001101','20:10:55.046643'),
       ('','1974-07-01','tes','esmg','2033-04-21 11:59:01.013627','1979-07-22 20:10:53.063887',1990,2,0.730316162109375,'',b'10101001111001101100001011110000',NULL),
       ('','1971-09-26','s','mgi','1985-06-12 00:00:00','2030-06-11 01:59:27.005747',NULL,5,NULL,'gifltn',b'100100001100111101101011','05:32:17.019802'),
       ('','2021-08-26','{"were": NULL,"of": {"one": "ifltnefitzufcefqqmfokivsitbedsjzu","this": false,"then": 0},"like": false,"on": 0}','fltn','2023-02-01 13:31:11.022797','1978-04-25 12:28:22.026728',2022,3,0.459854125976562,'{}',b'01001001101111001110','19:00:22.058749'),
       ('','1900-01-01','ltn','[0,"tnefit",["nefitzufcefqqmfo","efitzufcefqqmfokivsitbe"],0]','1998-11-03 08:36:23.059724','1981-03-10 10:48:56.016062',1989,2,0.0744171142578125,'',b'0011111001000111011100001','20:09:05.022165'),
       ('','2015-09-28','f','it','2021-06-21 20:05:12.060281','2006-07-10 12:37:24.049230',2029,45,0.2393798828125,'[{"cant": 0,"she": NULL,"for": false,"been": 0},0,0,"tzufcefqqmfo",true,{"some": "zufcefqqmfokivsitbedsjzuvsjghsldzxn","why": NULL,"didnt": NULL,"were": "ufcefqqmfoki","that": NULL,"well": true,"if": true,"got": false}]',b'010101111','21:23:40.058247'),
       ('','1979-07-01','fce','k','2006-03-04 00:00:00','2004-11-06 05:05:41.031778',2034,3,0.0672454833984375,'cef',b'0110011','00:00:00'),
       ('','2030-10-10','efqqmf','f','2017-12-11 00:00:00','1900-01-01 00:00:00',1977,8,0.885498046875,'qqmfo',b'00011111111','18:34:02.017187'),
       ('','1983-03-04','qmfokivsitb','mfo','2005-03-15 05:34:58.061507','1978-11-18 06:16:12.005866',1992,3,NULL,'',b'010101100011000001110','15:39:17.057678'),
       ('','1900-01-01','foki','ok','1983-05-25 00:00:00','1971-12-15 14:57:24.042789',1978,4,0.793807983398438,'',b'000100110010100010110110011101','11:14:32.012614'),
       ('','1988-01-15','kivsit','{"dont": 0,"mean": true,"from": false,"then": NULL,"think": 0,"like": 0}','2019-01-05 23:44:52.056388','2015-11-01 13:36:32.052497',1984,7,0.407989501953125,NULL,b'0111101010100000110011000','11:06:12.058910'),
       ('','2001-03-02','{"why": false,"when": "vsitbedsjzuvsj","cant": 0,"like": 0}','sitbe','1990-01-08 11:16:56.023296','2012-02-25 22:56:59.021593',2009,3,0.531982421875,'i',b'1000101','14:39:36.009256'),
       ('','1985-07-23','w','w','2005-10-15 00:00:00','2021-05-11 06:38:32.014703',1983,5,0.5765380859375,NULL,b'01100010110110001110100011',NULL),
       ('','2035-10-19','bedsjz','ed','2028-12-17 07:20:57.060582','2020-07-14 22:12:24.059442',2018,6,0.766189575195312,'d',b'010100010010101','20:51:31.025452'),
       ('','2027-07-13','[0,NULL]','sj','2030-12-07 08:21:45.001421','2024-12-19 06:50:51.000945',2018,160,0.756393432617188,'',b'011100','23:15:11.036615'),
       ('','2013-05-12','jz','','2023-12-05 00:00:00','2033-03-11 09:05:31.053161',1973,4,0.427780151367188,'q',b'01000','00:00:00'),
       ('','2021-02-02','zuvs','{"something": "uvsjghsldzxndyqrnl","do": 0,"did": true,"mean": 0}','2008-07-12 08:23:57.061012','1900-01-01 00:00:00',NULL,3,0.071533203125,'',b'0000001011100100','19:13:30.018263'),
       ('','2020-03-02','','vsjgh','2023-05-24 17:07:15.058172','2000-12-27 00:00:00',2013,1,NULL,'s',b'010001010110','22:49:55.013563'),
       ('','1980-07-05','[false,"jghsldzxndyqrnlbdgwcjxyuoyxkuhxeszom",0,"gh","hsldzxndyqrnlbdgwcjxyu"]','','1900-01-01 00:00:00','1973-07-15 07:00:44.044084',1979,2,0.32855224609375,'["sldzxndy","ldzxndyqr"]',b'00011001101100101110100','01:31:13.039742'),
       ('','2000-08-16','d','zxndy','2018-12-19 00:08:10.046309','2017-12-28 20:21:18.049322',2011,3,0.745132446289062,'x',b'0000100111','23:13:12.010840'),
       ('',NULL,'nd','dyqrnlbdgwcjxyuoyxkuhxeszommzdtwlfrvfcrogfdttnnkvhgrlhibykvacxgqpfomtdxswhuhnrhjauvubionbzrimkgktrrxxdmguucqulwflxtnbvgqazmatrlfcpqdjzbyottttfezenwvxcdxpwdpolkniqzzdwoqnghixsjyoixuyqrdnahimtkdvjbeirucdkuykh','2035-03-08 00:00:00','2019-01-21 00:00:00',1979,0,0.696823120117188,'y',b'1','00:00:00'),
       ('','1900-01-01','z','qrnlb','2011-05-18 16:36:57.037686','1982-11-03 00:00:00',2008,1,0.338485717773438,'rn',b'00111011001110001','08:48:05.032866'),
       ('','1988-11-26','x','{"been": 0}','1900-01-01 00:00:00','2025-01-04 00:00:00',2007,6,0.39752197265625,'q',NULL,'00:00:00'),
       ('','2020-10-19','nlb','lbdgwcjxyuoyxkuhxeszommzdtwlfrvfcrogfdttnnkvhgrlhibykvacxgqpfomtdxswhuhnrhjauvubionbzrimkgktrrxxdmguucqulwflxtnbvgqazmatrlfcpqdjzbyottttfezenwvxcdxpwdpolkniqzzdwo','2006-04-25 03:54:09.065133','1992-04-21 03:59:35.059877',NULL,8,0.740341186523438,'b',b'01110100100','22:43:30.023047'),
       ('',NULL,'dgwcjxyuoyxkuhxeszo','z','1900-01-01 00:00:00','1983-07-05 09:36:50.020080',2011,6,0.565933227539062,'',b'10001','00:43:21.011246'),
       ('','2019-01-19','q','gwcjxyuoyxkuhxeszommzdtwlfrvfcrog','1972-10-03 00:00:00','1997-08-14 03:05:06.018790',2030,3,0.92413330078125,NULL,b'110001','20:46:55.014664'),
       ('','1978-09-04','','cjxyuoyxkuhxeszommzdtwlfrvfcr','2023-02-10 21:25:53.005955','1992-09-18 17:56:40.006118',2033,7,0.573760986328125,'',b'111100','15:35:11.010682'),
       ('','1990-07-28','{"be": "j"}','','1972-05-23 04:54:54.017194','2022-09-22 12:06:13.057498',2025,0,0.0131988525390625,'x',b'001','00:40:21.062880'),
       ('','2023-12-04','yu','u','1900-01-01 00:00:00','1974-05-14 14:03:20.049712',2018,9,0.461685180664062,'',b'011110001010110101100101110','17:15:10.030755'),
       ('','1984-01-21','oyxkuhxeszommzdtwlfrvfcrogfdttnnkvhgrlhiby','[0,"yxkuhxeszommzdtwlfrvfcrogf","xkuhxeszommzdtwlfrv",0]','1991-11-07 09:26:28.026075','2013-11-23 08:05:44.028617',2012,6,0.458740234375,'kuhxe',b'1101000110110101001','22:02:58.037435'),
       ('','2032-01-02','[]','uhxes','1978-12-23 00:39:10.043883','2013-05-18 14:05:46.000643',2001,7,0.763565063476562,'hxeszo',b'0011000','00:00:00'),
       ('','2002-01-22','xeszo','e','2014-07-11 05:13:29.024133','1900-01-01 00:00:00',2024,6,0.661529541015625,'',b'11100111111011','00:00:00'),
       ('','2014-06-04','','szomm','2013-11-15 00:00:00','1900-01-01 00:00:00',2013,75,0.58099365234375,NULL,b'111101000111010101110001011111','11:48:43.006485'),
       ('',NULL,'[NULL,true,false]','o','2015-11-24 00:00:00','2033-04-08 13:28:25.011667',1990,7,0.73907470703125,'m',NULL,'03:46:17.020761'),
       ('','2027-01-28','mzdtw','zdtwlf','2014-08-03 14:29:35.014022','1981-09-14 10:59:26.019689',1996,0,0.624740600585938,NULL,b'0001','08:52:13.009756'),
       ('','1996-08-14','dtw','t','2005-07-17 16:14:35.004997','1980-08-23 00:00:00',2021,5,0.49041748046875,'{"one": 0,"I": true,"be": NULL,"Ill": false,"dont": 0,"him": NULL}',b'1110','00:00:00'),
       ('','1976-08-28','w','lfrvf','2021-12-15 22:56:37.000631','1990-02-28 23:48:23.034289',NULL,3,0.0160980224609375,NULL,b'0011010010100001111010010010011','01:58:21.048016'),
       ('','2016-10-08','frvfcrogfdttnnkvhgrlhibykvacxgqpfomtdxsw','rv','2016-07-12 00:00:00','1986-01-12 14:35:28.065250',1983,8,0.456924438476562,'t',b'1111111100010100000000010011','00:00:00'),
       ('','2012-05-18','{"my": [[0,0,"vfcrogfdttnnkvhgrlh"],false,[0,false,0,false,"fcrogfdttnnkvh",true,NULL,NULL,"crogfdttnnkvhgr",0,"rogfdttnnkvhgrlh",0,false],false,NULL,0,0,"ogfdttnnk","gfdttn",0,NULL],"there": true,"one": 0,"that": 0,"know": 0,"it": NULL,"there": NULL}','f','2006-02-11 10:47:18.040536','1991-03-11 02:23:13.049416',2000,5,0.232009887695312,'m',b'01110010011001101100','23:08:07.019350'),
       ('','2022-06-15','d','ttnnkv','1900-01-01 00:00:00','1998-11-15 11:38:03.053049',1999,5,0.888824462890625,'{"okay": true}',b'1001','13:40:18.023230'),
       ('','1981-09-11','{"is": NULL,"all": false,"yeah": NULL,"think": false,"been": "tnn","about": "nnkvhgrl","did": true}','n','2016-05-01 03:54:40.022158','2023-01-26 01:24:55.054552',2009,1,0.894424438476562,'',b'100011110100111','01:57:12.029428'),
       ('',NULL,'k','vhgrlhib','2034-03-14 00:00:00','2004-03-26 00:00:00',2007,3,0.825164794921875,'[false,0,true,true,"h",0,false]',b'10100101001101101011001101101011','11:09:07.022183'),
       ('','2030-12-11','gr','y','2018-08-01 08:49:19.017287','2035-11-28 20:27:42.057296',2013,5,NULL,'rlhiby',NULL,'15:43:14.029831'),
       ('','1991-11-09','l','hibykvacxgqpfomtdxswhuhnrhja','2013-02-17 21:50:20.050085','2022-07-17 00:00:00',1972,169,0.300140380859375,'iby',b'011','16:11:16.011234'),
       ('','2007-01-28','bykva','yk','1979-12-24 00:00:00','1984-06-14 22:29:16.045891',2007,7,0.347412109375,'kva',b'00000000010','17:03:40.003496'),
       ('','1975-05-23','y','va','1974-11-03 05:17:29.042021','1977-11-24 08:44:03.000289',1974,7,0.4232177734375,'',b'101111101110010','06:56:55.030574'),
       ('','1971-05-26','a','cxg','2032-08-28 01:43:01.034654','1977-03-13 08:10:45.035136',1992,9,0.107040405273438,'{}',b'1110010001111111','19:56:16.065310'),
       ('','1900-01-01','x','gqpfomtdxswhuhnrhjauvubionbzrimkgktrr','2003-01-12 00:00:00','2021-03-05 20:45:33.005927',NULL,3,0.4794921875,'qpfomt',b'01111000001','14:15:11.064880'),
       ('','1987-09-10','pfomtdxswhuhnrhjauvubionbzrim','[false]','2027-06-14 22:55:05.035433','2001-11-01 18:27:56.009195',NULL,8,0.80938720703125,'',NULL,'17:01:51.000806'),
       ('','2020-12-24','f','o','2010-02-17 00:00:00','2006-05-03 19:16:46.063338',1984,1,0.716522216796875,'',b'11011100011','18:58:17.015585'),
       ('','2018-05-26','mt','tdx','2011-04-25 11:27:10.058314','2023-12-16 00:00:00',1996,2,0.733261108398438,'dx',b'1011111110010001101001010011100','06:34:00.060374'),
       ('','1998-11-09','c','','2000-12-02 14:09:09.043090','2015-10-07 16:27:48.036090',1972,3,0.507034301757812,'{"me": "xsw","there": "sw","could": "whuhn","cant": NULL,"what": "hu","go": "uhnrhjauvubionbzrimkgktrrxxdmguucqulwflxtnbvgqaz"}',b'11000001010001100101','10:01:27.008837'),
       ('','1997-07-18','h','[NULL,"nrhjauvubionbzrimkgktrrxxdmguucqulwfl",true,"rhjauvubion","hja"]','2019-02-02 08:46:12.057837','1985-11-03 02:12:31.013915',2027,5,0.878128051757812,'',b'011001110001101001',NULL),
       ('','1972-04-12','jau','au','1980-06-06 04:22:12.000192','1979-09-21 14:07:06.039195',1977,5,0.1920166015625,'',b'0011000101101111101100001110010','15:32:29.022378'),
       ('',NULL,'k','[]','2021-12-10 17:32:17.049856','1995-07-25 00:52:13.036934',2004,1,NULL,'',b'00010111010011110','09:58:15.026772'),
       ('','1900-01-01','uvu','v','1990-09-15 09:30:02.042486','2004-11-19 00:00:00',1980,1,0.674591064453125,'u',b'01101010010010101011',NULL),
       ('','1900-01-01','bio','u','1900-01-01 00:00:00','2031-05-16 08:41:21.015399',2028,7,0.9111328125,'ion',b'101111000111111001111010010',NULL),
       ('','1994-09-04','o','n','1982-08-28 04:18:55.007451','1974-08-05 11:30:42.029957',1989,104,0.933303833007812,'bzr',b'11101101100101110101010','07:10:22.054884'),
       ('','2015-02-01','zrimkgktrrxxdmguucqulwflxtnbvgqazm','rimkgktrrxxdmguucqulwflxtnbvgqazmatrlfcpqdjzbyottttfezenwvxcdxpwdpolkniqzzdwoqnghixsjyoixuyqrdnahimtkdvjbeirucdkuykhtflxkzoiwimuljxdmazuguiuyyemoefwkptnpd','1987-10-14 00:00:00','2015-04-27 08:19:34.063887',2005,72,NULL,'',b'000011011101111011100','03:04:10.023816'),
       ('','1979-03-25','','','2027-02-14 01:25:48.037241','1995-12-07 05:46:51.040088',1971,8,0.58624267578125,'',b'00110110111011111111111010010110','15:19:12.028771'),
       ('',NULL,'i','n','1900-01-01 00:00:00','1977-02-23 14:40:40.015709',2034,0,0.218917846679688,'',b'11011','07:42:59.009439'),
       ('','2020-08-09','[[true,0,NULL,"mkgktrrxxdmguucqulwflxtnbvgq","kg"],true,0,"gktrrxxdmguucqulwflx"]','{}','1900-01-01 00:00:00','2006-10-21 05:47:48.009672',2026,29,0.171859741210938,'kt',b'000111100001111000111001','00:00:00'),
       ('','1980-06-18','trr','[false,0,"rrxxdmguucqulwflxtnbvgqazm",false,["rxxdmguucqulwf",0,false,true,NULL,true,"xxdmgu"],0]','2019-08-19 05:31:18.033757','2026-08-03 10:20:50.052931',2032,9,0.0011444091796875,'xd',b'100010010100101011000111','14:34:34.055879'),
       ('','2013-05-04','dm','mguucq','1974-04-10 15:31:45.059147','1997-05-04 02:07:53.027998',1975,5,0.977386474609375,'',b'0001111100100','16:38:19.041435'),
       ('','1900-01-01','guu','uu','2011-11-05 00:00:00','1979-01-04 16:03:30.051464',2022,9,0.475967407226562,'u',b'00','22:30:01.010472'),
       ('','1900-01-01','cqulwfl','','1900-01-01 00:00:00','2010-12-06 21:01:02.009343',2007,0,NULL,'',b'10','22:22:47.059122'),
       ('','1900-01-01','qulw','[true,"u","lwf","wf",NULL]','2018-10-17 00:19:43.055726','2021-05-25 00:00:00',2015,5,0.347305297851562,'flxtnb',b'011101001001010','00:13:25.038482'),
       ('','1987-06-17','lx','q','2011-06-09 22:42:45.048011','2026-08-17 00:00:00',1999,7,0.77490234375,NULL,b'00100001001011100111000101101000','20:47:06.051970'),
       ('',NULL,'t','n','1900-01-01 00:00:00','2033-07-01 10:13:39.005488',NULL,4,0.434005737304688,'b',b'0001100100011101011100010000','00:00:00'),
       ('','2013-10-02','v','[0,{"something": NULL,"out": NULL,"so": "gqazmatrlfcpqdj","ok": 0,"not": false},"qazmatrlfcpqdjzbyotttt","az"]','2003-12-12 13:00:53.051600','1989-08-19 14:04:14.036437',1994,196,0.468109130859375,'zmat',b'10','21:56:13.015067'),
       ('',NULL,'mat','atrl','1900-01-01 00:00:00','2025-06-20 07:13:17.006919',2005,8,0.979598999023438,'trl',b'00010011','22:04:14.025528'),
       ('','1900-01-01','rlf','l','2003-07-26 00:27:57.028952','2033-04-03 05:54:02.037045',1980,2,0.0291595458984375,'',b'0011110101100110001100','15:07:36.025729'),
       ('','1900-01-01','{"yeah": false,"can": "h","say": false,"youre": true,"her": 0}','','1986-08-05 02:17:31.023717','1988-07-01 09:55:03.009647',1977,0,0.962554931640625,'f',b'11110111101011101','11:29:24.058880'),
       ('','1900-01-01','fc','{"how": "cpqdjz"}','1991-04-24 00:00:00','2026-10-11 03:17:36.014848',NULL,8,0.797592163085938,'["pqdjzbyott",false,"qdjzbyottttfezenwvxcdxpwdpolkniqzzdwoqnghixsjyoixuy"]',b'000110010101000100000','16:04:54.034303'),
       ('','2020-07-14','djzb','jzb','2004-05-08 16:28:20.048829','2018-08-01 15:39:26.061578',2005,3,0.768295288085938,'zb',b'10001011111100101','21:15:09.024502'),
       ('',NULL,'by','{"thats": "yott","this": true,"hes": 0,"Ill": 0,"to": "ottttfezenwvxcdxpwdpolkniqz"}','1976-04-11 23:05:10.012267','1986-07-21 14:11:37.064124',2009,5,0.970657348632812,'',b'010100','00:26:05.024957'),
       ('','2008-11-03','','ttttf','2012-08-09 13:59:54.021219','1974-12-13 21:31:48.005747',2002,1,0.584304809570312,NULL,b'00011010','16:23:44.020244'),
       ('','2016-09-11','ttfez','tfez','2027-10-21 00:13:42.045342','1987-08-08 01:43:51.058084',1991,1,0.1412353515625,'{"no": NULL,"of": 0,"if": 0,"she": NULL,"good": NULL,"really": 0,"are": "fezenwvxcdxpwdpolkniqzzdwoqnghixsjyoixuyq"}',b'100100001110001110001111011','22:12:54.044311'),
       ('','1981-04-03','eze','ze','2013-12-21 16:13:30.019742','2034-09-25 22:51:04.037264',1984,2,0.175277709960938,'',b'1100111011100111110000111111000',NULL),
       ('','2023-11-26','e','nwvx','2004-11-27 16:58:32.021910','2029-07-03 21:53:03.009661',1981,4,0.581985473632812,'wvx',b'1110111111110100110101111','02:34:03.001954'),
       ('','2001-12-20','vx','xcd','2022-04-21 19:46:44.012322','2004-05-01 14:55:13.052074',1990,0,0.46612548828125,NULL,b'01000001010100001','06:25:44.014726'),
       ('','2002-04-09','h','dxpwdpo','2000-07-25 16:34:47.051820','2032-05-05 19:58:58.023899',2025,5,0.08453369140625,'xpw',b'10101010111000000000100000010011','12:55:44.038707'),
       ('','1999-08-24','pwdp','wdp','2024-12-22 00:05:13.027939','2015-12-26 10:35:05.013257',1988,7,0.291900634765625,'l',b'00001100000010','02:14:26.025015'),
       ('','1900-01-01','dpolkniqzzdwoqnghixsjyoixuyqrdnahimtkd','po','2010-05-08 00:28:55.016746','1983-07-19 16:17:12.031757',2027,5,0.278839111328125,'ol',NULL,'09:59:37.022959'),
       ('','1996-12-03','lkn','kniqzzdwoqnghixsjyoixuyqrdnahimtkdvjbeirucdkuykhtflxkzoiwimuljxdmazuguiuyyemoefwkptnpdnxobwuxplmihguaulybsxuogtmpmzdxsxgnpekolinzppighwyorqbeeikqlffesqekhmnbyflpwhihyfqexbzqllzydyptbwcmevpcmachjajxlcevjcezyvfndoulcceseebtfwteegsrysegyqzgaovjslcgxp','2007-05-23 02:35:33.023538','2002-09-14 19:13:47.053444',1988,4,0.0664520263671875,'{"right": false,"see": true,"because": 0,"okay": NULL,"from": "s","be": "niqzzd","cant": NULL}',b'010111001100101001111110010','00:00:00'),
       ('','2026-06-20','i','qzzdw','1997-05-02 14:03:05.027020','2033-08-11 15:19:38.006113',NULL,3,0.524063110351562,'',b'01010001011100011110010','21:06:51.030532'),
       ('','2033-06-07','j','g','2024-04-27 14:18:48.045835','2001-07-19 00:00:00',1993,5,0.107864379882812,'u',b'01001110010111011011111110011111','05:35:52.056701'),
       ('','2011-11-18','','zzd','2032-02-20 14:21:22.009946','1999-06-04 16:13:41.011044',2006,8,NULL,'zd',b'1001001110011001010101111100001','05:07:46.048677'),
       ('','2004-04-27','dw','b','2014-08-19 16:15:18.056348','2021-08-02 09:06:36.030921',1985,7,0.510452270507812,'',b'0011001011101110001011101000100','03:54:43.056869'),
       ('','1900-01-01','woqnghixsjyoixuyqrdnahimtkdvjbeirucdkuy','oqngh','2026-04-16 04:40:46.010819','2008-08-05 18:42:38.057597',2003,0,NULL,'q',b'101011','00:53:29.012567'),
       ('','1973-11-08','nghix','{"go": "gh"}','2015-08-15 23:07:59.022775','1977-03-26 21:53:24.065201',1987,5,0.165542602539062,'hix',b'0110111001101','07:44:41.044243'),
       ('','1981-04-11','','ix','1971-11-17 18:45:50.057314','2016-11-16 12:33:00.063976',1979,5,0.381454467773438,'',b'00011111101010001101011','21:25:05.055456'),
       ('','1989-01-04','xsjyoixuyqrdnahimtkdvjbeirucdkuykh','s','2004-10-26 13:28:40.039758','1987-06-06 04:47:21.013851',2033,8,0.293731689453125,'{"her": "jyoixuyqrdnahimtkdvjbeirucdkuykhtflxkz","be": 0}',b'1','02:57:18.036171'),
       ('','2015-09-09','yoixu','o','2027-02-25 00:00:00','2028-12-10 00:08:50.055223',1991,8,0.5479736328125,'i',b'0010111',NULL),
       ('','2004-10-05','xuy','u','1973-05-13 03:35:04.041155','1900-01-01 00:00:00',2005,187,NULL,'j',b'111100001000011011011','23:32:45.015272'),
       ('','1900-01-01','yqrdn','qrdnahi','1979-03-08 22:47:48.016423','2033-07-14 10:49:13.027118',1983,6,0.542770385742188,'rd',b'101110000','00:24:13.036484'),
       ('',NULL,'dnah','nahim','1985-07-10 01:55:22.033998','2022-03-24 08:21:10.010889',1985,6,0.975448608398438,'[0,"ahimtkdvjbeirucdkuykhtflxkzoi",NULL,"himtkdvjbeirucdkuykhtflxkzoiwimuljxdm","imtkdvjbeirucdkuykhtflxkzoiwimuljxdmazugui",false,"mtkdvjbeirucdkuykht"]',b'0111001000000','13:00:47.012154'),
       ('','1999-11-18','{"if": false,"in": NULL,"to": NULL,"had": "tkdvjbeirucdkuykhtflxkzoiwimuljxdmazuguiuyyemoefwkpt","time": true}','kdvjbeir','1974-01-16 17:23:11.051839','1999-01-11 23:22:44.045663',2031,7,NULL,'',b'11001001100101011011','14:21:25.041589'),
       ('','1900-01-01','dvj','[]','2010-12-14 14:27:43.024915','2028-07-03 20:49:02.035549',NULL,8,0.308914184570312,'v',b'1000000010','03:44:51.060325'),
       ('','2027-02-14','jbe','beiruc','1991-04-27 20:04:29.060757','1989-05-12 02:37:29.026267',1982,4,NULL,'w',b'011110110111011101100001110001','00:46:56.035398'),
       ('','2016-06-25','','eir','1981-03-03 03:51:23.029515','2033-08-02 22:40:21.004501',2019,7,0.796859741210938,'iru',b'11011001010101001000','11:37:40.017285'),
       ('','1998-07-24','rucd','[true,NULL,"ucdk",NULL,"cd","dkuykhtflxkzoiwimulj"]','1984-02-08 00:11:18.054830','1986-09-22 23:04:43.065402',1990,6,0.0033721923828125,'kuykht',b'100101101110111011000','19:38:23.047425'),
       ('','1981-11-23','u','yk','1986-12-16 04:39:31.040699','2035-09-01 00:00:00',2009,2,0.570770263671875,'kht',b'00001000100010000110011011111','17:32:24.039708'),
       ('','2009-03-28','htflxkz','','1900-01-01 00:00:00','1900-01-01 00:00:00',2026,3,0.320358276367188,'tf',b'101001010000','03:39:22.063767'),
       ('','1900-01-01','fl','k','2018-11-18 12:10:00.010029','2004-12-25 00:00:00',1987,2,NULL,'[]',b'1001110011001101011000','16:34:01.034283'),
       ('','1980-03-04','lx','[NULL,NULL,0,"xk",0,0]','2029-08-04 09:52:57.020975','2024-06-06 06:25:23.001999',1974,0,0.999786376953125,'k',b'10001011011100110011','00:00:00'),
       ('','1900-01-01','zoiwimuljxdmazuguiuyyemo','oiwimuljxdmazuguiuyyemoefwkptnpdnxobwuxplmihguaulybsxuogtmpmzdxsxgnpekolinzppighwyorqbeeikqlffesqekh','2018-09-14 13:10:57.023202','2029-05-01 04:24:41.048783',2011,7,0.486343383789062,'iwi',b'00101101110101011001111111111','04:46:56.049982'),
       ('','2006-04-27','{"of": {"his": "wimuljxdmaz","out": false},"good": "imuljxdmazuguiuyye","hes": "mulj","will": "uljxdmazuguiuyyemoefwkptnpdnx","do": true,"Ill": "ljxdmazuguiuyyemoefwkptnpdnxobwuxplmihguaulybsxuogtmpmz","had": NULL}','j','2014-07-07 09:52:19.000049','1974-11-23 00:50:49.042496',1983,2,0.139694213867188,'xdmazu',b'101111000111011000000001011','00:00:00'),
       ('',NULL,'dm','mazuguiu','1900-01-01 00:00:00','1975-08-05 20:16:06.019493',2032,2,NULL,'a',b'0101110','15:28:30.045265'),
       ('','1973-05-10','zu','u','2030-11-16 09:47:44.007518','2001-12-23 08:41:07.027164',1978,9,0.166290283203125,'guiu',b'0111000100101','21:56:44.028746'),
       ('',NULL,'ui','[true,"iuyyemoefwkptnpd",{"look": "u","at": false,"hes": false,"who": "yyemoefwkptnpdnxobwuxpl","can": false,"yeah": false},NULL,NULL]','2024-08-19 00:00:00','2017-04-06 03:48:27.011722',2008,8,0.704803466796875,'yemoef',b'00000','00:13:09.020516'),
       ('',NULL,'emoefwkptnpdnxobwux','m','1986-08-21 00:00:00','1977-09-08 13:23:30.016993',2014,8,0.89862060546875,NULL,NULL,'18:12:21.034786'),
       ('','1992-11-06','efw','fwkptnpdnxobwuxplmihguaulybsxuogtmpmzdxsxgnpekolinzppighwyorqbeeikqlffesqekhmnbyflpwhihyfqexbzqllzydyptbwcmevpcmachjajxlcevjcezyvfndoulcceseebtfwteegsrysegyqzgaovjslcgxpzqoxlqejnumjojibwhbnqrmuahrrhkjrrizzulqclpzkfalbrtjcglxrhszefsxjeipujlawnhfnfesxlfcjsbwbwdxuuerdsygghanloqtmyexedxqxmwnizodvmwodfxwykmsmjvxtcusfmrtkhwlbtyeiap','1987-01-13 00:00:00','1900-01-01 00:00:00',1986,228,0.366867065429688,'wk',b'10000100111001101101','00:00:00'),
       ('','2004-10-14','k','p','1992-11-12 00:00:00','2021-12-18 12:15:54.039745',1971,3,0.507492065429688,'tnpd',b'001010101011100000110111','03:19:11.027466'),
       ('','1971-03-21','[[NULL,"np",0,false,NULL,false,false,"pdnxobwuxplmih",0,"dnxobwuxplmihguaulybsxuogtmpmzdxs",[0,NULL,false,[],0,false,true,{"now": NULL,"if": true,"so": true,"of": false,"then": "nxobwuxplmihguaulybsxuogtmpmzdxsxgnp","get": 0,"say": "xobwuxplmihguaulyb"},0,false,false,"obwuxplmihguaulybsxuo",0,"bwuxplmi",0,0],0,NULL],"wuxplmihg","ux",0,false,"xpl"]','p','1985-02-14 01:05:09.053073','1994-06-25 15:04:47.060888',1994,3,0.691024780273438,'[NULL,0,0,NULL]',b'10011101101010100000010110',NULL),
       ('','2024-02-02','k','lmihguaulybsxuogtmpmzdxsxgnpekolinzppighwyorqbeeikqlffesqekhmnbyflpwhihyfqexbzqllzydyptbwcmevpcmachjajxlcevjcezyvfndoulcceseebtfwteegsrysegyqzgaovjslcgxpzqoxlqejnumjojibwhbnqrmuahrrhkjrrizzulqclpzkfalbrtjcglxrhszefsxjeipujlawnhfnfesxlfcjsbwbwdxuuerdsygghanloqtmyexedxq','2022-07-06 02:56:53.020899','1994-02-07 21:08:18.046602',NULL,4,0.449935913085938,'',b'0100001011000100000101','14:30:36.048574'),
       ('','1988-11-06','fp','pv','1987-02-25 04:55:11.032146','2001-06-13 22:20:12.057555',1986,27,0.620101928710938,'{"that": 0,"or": false}',b'1010101010101110000111','16:17:54.032555') /* QNO 62 CON_ID 9 */;
      	SHOW WARNINGS;
      	COMMIT /* QNO 63 CON_ID 9 */;
      	DROP TABLE /*! IF EXISTS */ t6 /* QNO 64 CON_ID 9 */;
      	SHOW WARNINGS;
      	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(5) NULL,
       col_datetime DATETIME NOT NULL DEFAULT '1900-01-01 00:00:00',
       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(6) NULL,
       PRIMARY KEY(pk)
       ) ENGINE=InnoDB /* 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_char(2),col_blob(64),col_varchar(64)) /* QNO 90 CON_ID 9 */;
      	ALTER TABLE t8 ADD INDEX(col_int,col_dec,col_date) /* QNO 91 CON_ID 9 */;
      	ALTER TABLE t8 ADD INDEX(col_date,col_bit,col_datetime) /* QNO 92 CON_ID 9 */;
      	ALTER TABLE t8 ADD UNIQUE(col_date,col_year,col_dec,col_varchar(64)) /* QNO 93 CON_ID 9 */;
      	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;
      	SET SQL_MODE= 'NO_ENGINE_SUBSTITUTION' /* QNO 109 CON_ID 9 */;
      --disconnect con9
       
      --connection default
       
      SELECT DISTINCT alias1.`col_time` AS field1, alias1.`col_char` AS cfield1 FROM ( ( SELECT DISTINCT SQ1_alias1.* FROM `view_t8` AS SQ1_alias1 ) AS alias1, `t8` AS alias2, `t5` AS alias3 ) WHERE alias1.`col_date` IS NULL;
       
      SELECT * FROM (  SELECT DISTINCT alias1.`col_time` AS field1, alias1.`col_char` AS cfield1 FROM (( SELECT * FROM (  SELECT DISTINCT SQ1_alias1.* FROM `view_t8` AS SQ1_alias1  ) cte3 ) AS alias1, `t8` AS alias2, `t5` AS alias3 ) WHERE alias1.`col_date` IS NULL  /* QNO 17789 CON_ID 19 */  ) cte1;
      

      Attachments

        Activity

          People

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

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

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