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

Assertion `info->lastpos == (~ (my_off_t) 0)' failed in mi_rkey with rowid_filer=on

    XMLWordPrintable

    Details

      Description

      Note: The test case contains exactly 1600 rows. It seems to be a magic number.

      CREATE TABLE t1 (
        a smallint(6) DEFAULT NULL,
        b bigint(20) DEFAULT NULL,
        c varchar(64) DEFAULT NULL,
        d varchar(64) DEFAULT NULL,
        e smallint(6) DEFAULT NULL,
        f bigint(20) DEFAULT NULL,
        KEY a (a),
        KEY d (d),
        KEY f (f)
      ) ENGINE=MyISAM;
       
      ALTER TABLE t1 DISABLE KEYS;
      INSERT INTO t1 VALUES (13954,0,NULL,'c',NULL,0);
      INSERT INTO t1 VALUES (124,0,NULL,'j',NULL,0);
      INSERT INTO t1 VALUES (0,0,NULL,'h',NULL,9);
      INSERT INTO t1 VALUES (4,0,NULL,'New Hampshire',NULL,0);
      INSERT INTO t1 VALUES (NULL,0,NULL,'q',NULL,NULL);
      INSERT INTO t1 VALUES (NULL,0,NULL,'f',NULL,NULL);
      INSERT INTO t1 VALUES (2,0,NULL,'b',NULL,0);
      INSERT INTO t1 VALUES (0,0,NULL,'y',NULL,0);
      INSERT INTO t1 VALUES (106,0,NULL,'Hawaii',NULL,-480);
      INSERT INTO t1 VALUES (10534,0,NULL,'South Carolina',NULL,NULL);
      INSERT INTO t1 VALUES (32767,0,NULL,'Iowa',NULL,0);
      INSERT INTO t1 VALUES (6,0,NULL,'g',NULL,9);
      INSERT INTO t1 VALUES (0,0,NULL,'Arkansas',NULL,116);
      INSERT INTO t1 VALUES (0,0,NULL,'b',NULL,NULL);
      INSERT INTO t1 VALUES (NULL,0,NULL,'release',NULL,-624);
      INSERT INTO t1 VALUES (169,0,NULL,'s',NULL,664);
      INSERT INTO t1 VALUES (20060,0,NULL,'l',NULL,672);
      INSERT INTO t1 VALUES (NULL,0,NULL,'q',NULL,235);
      INSERT INTO t1 VALUES (1,0,NULL,'Tennessee',NULL,8);
      INSERT INTO t1 VALUES (687,0,NULL,'j',NULL,21);
      INSERT INTO t1 VALUES (-19736,0,NULL,'s',NULL,NULL);
      INSERT INTO t1 VALUES (81,0,NULL,'p',NULL,0);
      INSERT INTO t1 VALUES (0,0,NULL,'festival',NULL,97);
      INSERT INTO t1 VALUES (NULL,0,NULL,'c',NULL,264);
      INSERT INTO t1 VALUES (0,0,NULL,'o',NULL,NULL);
      INSERT INTO t1 VALUES (-30578,0,NULL,'exam',NULL,NULL);
      INSERT INTO t1 VALUES (30751,0,NULL,'Nebraska',NULL,0);
      INSERT INTO t1 VALUES (8,0,NULL,'d',NULL,0);
      INSERT INTO t1 VALUES (29585,0,NULL,'California',NULL,585);
      INSERT INTO t1 VALUES (15376,0,NULL,'Indiana',NULL,768);
      INSERT INTO t1 VALUES (7162,0,NULL,'gifted',NULL,NULL);
      INSERT INTO t1 VALUES (28102,0,NULL,'w',NULL,616);
      INSERT INTO t1 VALUES (NULL,0,NULL,'b',NULL,NULL);
      INSERT INTO t1 VALUES (80,0,NULL,'p',NULL,NULL);
      INSERT INTO t1 VALUES (4,0,NULL,'o',NULL,282);
      INSERT INTO t1 VALUES (32767,0,NULL,'p',NULL,2);
      INSERT INTO t1 VALUES (255,0,NULL,'b',NULL,0);
      INSERT INTO t1 VALUES (202,0,NULL,'Mississippi',NULL,0);
      INSERT INTO t1 VALUES (16253,0,NULL,'Alaska',NULL,872);
      INSERT INTO t1 VALUES (5,0,NULL,'q',NULL,-656);
      INSERT INTO t1 VALUES (32767,0,NULL,'q',NULL,3);
      INSERT INTO t1 VALUES (7,0,NULL,'Rhode Island',NULL,250);
      INSERT INTO t1 VALUES (0,0,NULL,'b',NULL,0);
      INSERT INTO t1 VALUES (0,0,NULL,'s',NULL,885);
      INSERT INTO t1 VALUES (NULL,0,NULL,'i',NULL,-56);
      INSERT INTO t1 VALUES (201,0,NULL,'ridiculous',NULL,-704);
      INSERT INTO t1 VALUES (5,0,NULL,'teenage',NULL,82);
      INSERT INTO t1 VALUES (0,0,NULL,'Alabama',NULL,NULL);
      INSERT INTO t1 VALUES (4,0,NULL,'i',NULL,1);
      INSERT INTO t1 VALUES (-9774,0,NULL,'v',NULL,0);
      INSERT INTO t1 VALUES (0,0,NULL,'y',NULL,NULL);
      INSERT INTO t1 VALUES (NULL,0,NULL,'Alabama',NULL,NULL);
      INSERT INTO t1 VALUES (7,0,NULL,'e',NULL,8);
      INSERT INTO t1 VALUES (3,0,NULL,'l',NULL,0);
      INSERT INTO t1 VALUES (NULL,0,NULL,'drift',NULL,6);
      INSERT INTO t1 VALUES (0,0,NULL,'v',NULL,230);
      INSERT INTO t1 VALUES (5926,0,NULL,'Colorado',NULL,254);
      INSERT INTO t1 VALUES (NULL,0,NULL,'South Carolina',NULL,512);
      INSERT INTO t1 VALUES (9,0,NULL,'othapwsr',NULL,NULL);
      INSERT INTO t1 VALUES (23437,0,NULL,'h',NULL,0);
      INSERT INTO t1 VALUES (18863,0,NULL,'guideline',NULL,-80);
      INSERT INTO t1 VALUES (NULL,0,NULL,'s',NULL,NULL);
      INSERT INTO t1 VALUES (NULL,0,NULL,'New Mexico',NULL,272);
      INSERT INTO t1 VALUES (79,0,NULL,'partnership',NULL,5);
      INSERT INTO t1 VALUES (0,0,NULL,'e',NULL,NULL);
      INSERT INTO t1 VALUES (NULL,0,NULL,'r',NULL,128);
      INSERT INTO t1 VALUES (42,0,NULL,'tz',NULL,NULL);
      INSERT INTO t1 VALUES (228,0,NULL,'Utah',NULL,3);
      INSERT INTO t1 VALUES (NULL,0,NULL,'i',NULL,0);
      INSERT INTO t1 VALUES (32767,0,NULL,'Alaska',NULL,0);
      INSERT INTO t1 VALUES (NULL,0,NULL,'wo',NULL,177);
      INSERT INTO t1 VALUES (0,0,NULL,'Maryland',NULL,487);
      INSERT INTO t1 VALUES (-8186,0,NULL,'Colorado',NULL,0);
      INSERT INTO t1 VALUES (0,0,NULL,'uj',NULL,328);
      INSERT INTO t1 VALUES (4,0,NULL,'fork',NULL,0);
      INSERT INTO t1 VALUES (3,0,NULL,'w',NULL,NULL);
      INSERT INTO t1 VALUES (248,0,NULL,'i',NULL,0);
      INSERT INTO t1 VALUES (NULL,0,NULL,'dmkbqswrmtyabvlfylaxhnqij',NULL,24);
      INSERT INTO t1 VALUES (32767,0,NULL,'achieve',NULL,1);
      INSERT INTO t1 VALUES (32767,0,NULL,'existing',NULL,5);
      INSERT INTO t1 VALUES (6,0,NULL,'master',NULL,-312);
      INSERT INTO t1 VALUES (214,0,NULL,'b',NULL,NULL);
      INSERT INTO t1 VALUES (NULL,0,NULL,'Michigan',NULL,42);
      INSERT INTO t1 VALUES (NULL,0,NULL,'simply',NULL,109);
      INSERT INTO t1 VALUES (NULL,0,NULL,'sw',NULL,86);
      INSERT INTO t1 VALUES (20697,0,NULL,'m',NULL,5);
      INSERT INTO t1 VALUES (-11693,0,NULL,'mt',NULL,NULL);
      INSERT INTO t1 VALUES (NULL,0,NULL,'South Dakota',NULL,NULL);
      INSERT INTO t1 VALUES (14825,0,NULL,'b',NULL,0);
      INSERT INTO t1 VALUES (-9378,0,NULL,'Washington',NULL,593);
      INSERT INTO t1 VALUES (NULL,0,NULL,'New Jersey',NULL,246);
      INSERT INTO t1 VALUES (32767,0,NULL,'q',NULL,-816);
      INSERT INTO t1 VALUES (0,0,NULL,'vl',NULL,232);
      INSERT INTO t1 VALUES (25257,0,NULL,'Nevada',NULL,-24);
      INSERT INTO t1 VALUES (0,0,NULL,'Wisconsin',NULL,9);
      INSERT INTO t1 VALUES (1536,0,NULL,'x',NULL,NULL);
      INSERT INTO t1 VALUES (5895,0,NULL,'Washington',NULL,170);
      INSERT INTO t1 VALUES (28123,0,NULL,'h',NULL,176);
      INSERT INTO t1 VALUES (9,0,NULL,'Tennessee',NULL,948);
      INSERT INTO t1 VALUES (0,0,NULL,'qi',NULL,0);
      INSERT INTO t1 VALUES (0,0,NULL,'Tennessee',NULL,0);
      INSERT INTO t1 VALUES (NULL,0,NULL,'Oklahoma',NULL,132);
      INSERT INTO t1 VALUES (-21476,0,NULL,'Montana',NULL,947);
      INSERT INTO t1 VALUES (6,0,NULL,'aevevozlwbltcvzjptgbxw',NULL,0);
      INSERT INTO t1 VALUES (32767,0,NULL,'v',NULL,4);
      INSERT INTO t1 VALUES (1,0,NULL,'vo',NULL,73);
      INSERT INTO t1 VALUES (3,0,NULL,'oz',NULL,328);
      INSERT INTO t1 VALUES (17939,0,NULL,'exclude',NULL,175);
      INSERT INTO t1 VALUES (-26579,0,NULL,'bl',NULL,32);
      INSERT INTO t1 VALUES (9,0,NULL,'c',NULL,130);
      INSERT INTO t1 VALUES (-26118,0,NULL,'asian',NULL,NULL);
      INSERT INTO t1 VALUES (NULL,0,NULL,'r',NULL,NULL);
      INSERT INTO t1 VALUES (0,0,NULL,'personal',NULL,8);
      INSERT INTO t1 VALUES (26919,0,NULL,'i',NULL,550);
      INSERT INTO t1 VALUES (NULL,0,NULL,'n',NULL,456);
      INSERT INTO t1 VALUES (NULL,0,NULL,'tg',NULL,-40);
      INSERT INTO t1 VALUES (0,0,NULL,'g',NULL,-720);
      INSERT INTO t1 VALUES (5,0,NULL,'bxwggltplrozn',NULL,92);
      INSERT INTO t1 VALUES (5,0,NULL,'w',NULL,-904);
      INSERT INTO t1 VALUES (-5704,0,NULL,'Idaho',NULL,NULL);
      INSERT INTO t1 VALUES (NULL,0,NULL,'t',NULL,2);
      INSERT INTO t1 VALUES (3,0,NULL,'lroznxbayvsjotzfqwye',NULL,-544);
      INSERT INTO t1 VALUES (-32545,0,NULL,'oz',NULL,0);
      INSERT INTO t1 VALUES (NULL,0,NULL,'x',NULL,NULL);
      INSERT INTO t1 VALUES (0,0,NULL,'virtually',NULL,38);
      INSERT INTO t1 VALUES (1,0,NULL,'beautiful',NULL,7);
      INSERT INTO t1 VALUES (223,0,NULL,'vs',NULL,9);
      INSERT INTO t1 VALUES (13865,0,NULL,'Arkansas',NULL,1);
      INSERT INTO t1 VALUES (0,0,NULL,'h',NULL,0);
      INSERT INTO t1 VALUES (-24982,0,NULL,'e',NULL,206);
      INSERT INTO t1 VALUES (27039,0,NULL,'rape',NULL,-184);
      INSERT INTO t1 VALUES (NULL,0,NULL,'v',NULL,74);
      INSERT INTO t1 VALUES (NULL,0,NULL,'wyec',NULL,2);
      INSERT INTO t1 VALUES (0,0,NULL,'cook',NULL,59);
      INSERT INTO t1 VALUES (0,0,NULL,'Iowa',NULL,NULL);
      INSERT INTO t1 VALUES (231,0,NULL,'ecfsb',NULL,NULL);
      INSERT INTO t1 VALUES (NULL,0,NULL,'p',NULL,370);
      INSERT INTO t1 VALUES (-24801,0,NULL,'New Mexico',NULL,NULL);
      INSERT INTO t1 VALUES (50,0,NULL,'kelhcq',NULL,104);
      INSERT INTO t1 VALUES (NULL,0,NULL,'el',NULL,402);
      INSERT INTO t1 VALUES (15730,0,NULL,'h',NULL,376);
      INSERT INTO t1 VALUES (8,0,NULL,'p',NULL,NULL);
      INSERT INTO t1 VALUES (NULL,0,NULL,'h',NULL,4);
      INSERT INTO t1 VALUES (32767,0,NULL,'South Carolina',NULL,382);
      INSERT INTO t1 VALUES (NULL,0,NULL,'invite',NULL,816);
      INSERT INTO t1 VALUES (NULL,0,NULL,'ft',NULL,538);
      INSERT INTO t1 VALUES (8159,0,NULL,'q',NULL,11);
      INSERT INTO t1 VALUES (0,0,NULL,'a',NULL,103);
      INSERT INTO t1 VALUES (7,0,NULL,'n',NULL,NULL);
      INSERT INTO t1 VALUES (NULL,0,NULL,'New Jersey',NULL,146);
      INSERT INTO t1 VALUES (32767,0,NULL,'odlwznvezd',NULL,295);
      INSERT INTO t1 VALUES (9,0,NULL,'any',NULL,480);
      INSERT INTO t1 VALUES (7,0,NULL,'znvezdlrwfvhpghujmnvqun',NULL,720);
      INSERT INTO t1 VALUES (12792,0,NULL,'Iowa',NULL,NULL);
      INSERT INTO t1 VALUES (148,0,NULL,'Ohio',NULL,89);
      INSERT INTO t1 VALUES (NULL,0,NULL,'lr',NULL,-680);
      INSERT INTO t1 VALUES (-14898,0,NULL,'fv',NULL,736);
      INSERT INTO t1 VALUES (32767,0,NULL,'v',NULL,9);
      INSERT INTO t1 VALUES (5808,0,NULL,'Florida',NULL,112);
      INSERT INTO t1 VALUES (0,0,NULL,'gh',NULL,0);
      INSERT INTO t1 VALUES (NULL,0,NULL,'u',NULL,NULL);
      INSERT INTO t1 VALUES (4,0,NULL,'mnvqunepbp',NULL,NULL);
      INSERT INTO t1 VALUES (0,0,NULL,'enemy',NULL,272);
      INSERT INTO t1 VALUES (32767,0,NULL,'unhappy',NULL,8);
      INSERT INTO t1 VALUES (1460,0,NULL,'Connecticut',NULL,780);
      INSERT INTO t1 VALUES (0,0,NULL,'epbpabcgxxmaozb',NULL,230);
      INSERT INTO t1 VALUES (NULL,0,NULL,'banana',NULL,620);
      INSERT INTO t1 VALUES (0,0,NULL,'pabcgxxmaozbofwby',NULL,212);
      INSERT INTO t1 VALUES (32767,0,NULL,'afterward',NULL,0);
      INSERT INTO t1 VALUES (-15421,0,NULL,'important',NULL,NULL);
      INSERT INTO t1 VALUES (0,0,NULL,'Washington',NULL,0);
      INSERT INTO t1 VALUES (32767,0,NULL,'m',NULL,3);
      INSERT INTO t1 VALUES (0,0,NULL,'zb',NULL,1);
      INSERT INTO t1 VALUES (0,0,NULL,'position',NULL,-632);
      INSERT INTO t1 VALUES (17,0,NULL,'bofwbypkykzkbnayqfeuzxlyt',NULL,63);
      INSERT INTO t1 VALUES (NULL,0,NULL,'of',NULL,488);
      INSERT INTO t1 VALUES (0,0,NULL,'wbypkykzkbnayqfeuzxlyts',NULL,0);
      INSERT INTO t1 VALUES (NULL,0,NULL,'insight',NULL,632);
      INSERT INTO t1 VALUES (0,0,NULL,'Arizona',NULL,0);
      INSERT INTO t1 VALUES (NULL,0,NULL,'pk',NULL,0);
      INSERT INTO t1 VALUES (174,0,NULL,'yk',NULL,194);
      INSERT INTO t1 VALUES (4,0,NULL,'h',NULL,NULL);
      INSERT INTO t1 VALUES (19871,0,NULL,'zkbna',NULL,7);
      INSERT INTO t1 VALUES (NULL,0,NULL,'l',NULL,0);
      INSERT INTO t1 VALUES (-18596,0,NULL,'New York',NULL,488);
      INSERT INTO t1 VALUES (18464,0,NULL,'qfeuzxlyts',NULL,3);
      INSERT INTO t1 VALUES (-21912,0,NULL,'doctor',NULL,0);
      INSERT INTO t1 VALUES (NULL,0,NULL,'eu',NULL,4);
      INSERT INTO t1 VALUES (0,0,NULL,'xl',NULL,NULL);
      INSERT INTO t1 VALUES (NULL,0,NULL,'New York',NULL,394);
      INSERT INTO t1 VALUES (NULL,0,NULL,'closest',NULL,928);
      INSERT INTO t1 VALUES (7,0,NULL,'jx',NULL,0);
      INSERT INTO t1 VALUES (8,0,NULL,'Mississippi',NULL,236);
      INSERT INTO t1 VALUES (8238,0,NULL,'n',NULL,2);
      INSERT INTO t1 VALUES (137,0,NULL,'nf',NULL,3);
      INSERT INTO t1 VALUES (7,0,NULL,'mm',NULL,824);
      INSERT INTO t1 VALUES (-13059,0,NULL,'nfojpim',NULL,-40);
      INSERT INTO t1 VALUES (NULL,0,NULL,'i',NULL,224);
      INSERT INTO t1 VALUES (NULL,0,NULL,'blind',NULL,-296);
      INSERT INTO t1 VALUES (0,0,NULL,'Maryland',NULL,8);
      INSERT INTO t1 VALUES (0,0,NULL,'im',NULL,0);
      INSERT INTO t1 VALUES (88,0,NULL,'Colorado',NULL,NULL);
      INSERT INTO t1 VALUES (0,0,NULL,'u',NULL,NULL);
      INSERT INTO t1 VALUES (NULL,0,NULL,'glove',NULL,NULL);
      INSERT INTO t1 VALUES (0,0,NULL,'qg',NULL,952);
      INSERT INTO t1 VALUES (14297,0,NULL,'level',NULL,0);
      INSERT INTO t1 VALUES (NULL,0,NULL,'v',NULL,0);
      INSERT INTO t1 VALUES (46,0,NULL,'suspicion',NULL,0);
      INSERT INTO t1 VALUES (7,0,NULL,'Connecticut',NULL,NULL);
      INSERT INTO t1 VALUES (32672,0,NULL,'master',NULL,224);
      INSERT INTO t1 VALUES (255,0,NULL,'suffering',NULL,0);
      INSERT INTO t1 VALUES (32767,0,NULL,'bweyg',NULL,343);
      INSERT INTO t1 VALUES (32,0,NULL,'Maine',NULL,-224);
      INSERT INTO t1 VALUES (2888,0,NULL,'rear',NULL,74);
      INSERT INTO t1 VALUES (218,0,NULL,'New Hampshire',NULL,-416);
      INSERT INTO t1 VALUES (NULL,0,NULL,'m',NULL,5);
      INSERT INTO t1 VALUES (7,0,NULL,'compel',NULL,592);
      INSERT INTO t1 VALUES (3,0,NULL,'Vermont',NULL,-424);
      INSERT INTO t1 VALUES (0,0,NULL,'natural',NULL,6);
      INSERT INTO t1 VALUES (4,0,NULL,'f',NULL,0);
      INSERT INTO t1 VALUES (32767,0,NULL,'Maryland',NULL,0);
      INSERT INTO t1 VALUES (4128,0,NULL,'lm',NULL,-128);
      INSERT INTO t1 VALUES (0,0,NULL,'circuit',NULL,NULL);
      INSERT INTO t1 VALUES (-23553,0,NULL,'appearance',NULL,9);
      INSERT INTO t1 VALUES (32767,0,NULL,'qr',NULL,0);
      INSERT INTO t1 VALUES (9700,0,NULL,'g',NULL,NULL);
      INSERT INTO t1 VALUES (NULL,0,NULL,'hr',NULL,9);
      INSERT INTO t1 VALUES (229,0,NULL,'West Virginia',NULL,244);
      INSERT INTO t1 VALUES (10379,0,NULL,'i',NULL,211);
      INSERT INTO t1 VALUES (0,0,NULL,'personal',NULL,5);
      INSERT INTO t1 VALUES (4298,0,NULL,'z',NULL,985);
      INSERT INTO t1 VALUES (157,0,NULL,'e',NULL,0);
      INSERT INTO t1 VALUES (0,0,NULL,'p',NULL,5);
      INSERT INTO t1 VALUES (32767,0,NULL,'lg',NULL,527);
      INSERT INTO t1 VALUES (1,0,NULL,'t',NULL,208);
      INSERT INTO t1 VALUES (5,0,NULL,'Kansas',NULL,587);
      INSERT INTO t1 VALUES (-31188,0,NULL,'e',NULL,408);
      INSERT INTO t1 VALUES (NULL,0,NULL,'v',NULL,146);
      INSERT INTO t1 VALUES (15527,0,NULL,'vd',NULL,-200);
      INSERT INTO t1 VALUES (11164,0,NULL,'pthiwwamjdavik',NULL,117);
      INSERT INTO t1 VALUES (46,0,NULL,'iw',NULL,NULL);
      INSERT INTO t1 VALUES (0,0,NULL,'a',NULL,9);
      INSERT INTO t1 VALUES (NULL,0,NULL,'gradually',NULL,0);
      INSERT INTO t1 VALUES (-21366,0,NULL,'refer',NULL,146);
      INSERT INTO t1 VALUES (20927,0,NULL,'c',NULL,0);
      INSERT INTO t1 VALUES (43,0,NULL,'Florida',NULL,968);
      INSERT INTO t1 VALUES (NULL,0,NULL,'ko',NULL,NULL);
      INSERT INTO t1 VALUES (242,0,NULL,'jrydpgfyxhfqsu',NULL,-800);
      INSERT INTO t1 VALUES (-12797,0,NULL,'ry',NULL,7);
      INSERT INTO t1 VALUES (6,0,NULL,'x',NULL,228);
      INSERT INTO t1 VALUES (9,0,NULL,'y',NULL,1);
      INSERT INTO t1 VALUES (0,0,NULL,'w',NULL,4);
      INSERT INTO t1 VALUES (127,0,NULL,'Maryland',NULL,NULL);
      INSERT INTO t1 VALUES (NULL,0,NULL,'h',NULL,NULL);
      INSERT INTO t1 VALUES (7,0,NULL,'qs',NULL,512);
      INSERT INTO t1 VALUES (30910,0,NULL,'disturb',NULL,960);
      INSERT INTO t1 VALUES (NULL,0,NULL,'lx',NULL,4);
      INSERT INTO t1 VALUES (94,0,NULL,'dhc',NULL,0);
      INSERT INTO t1 VALUES (247,0,NULL,'ca',NULL,0);
      INSERT INTO t1 VALUES (NULL,0,NULL,'fi',NULL,-488);
      INSERT INTO t1 VALUES (NULL,0,NULL,'i',NULL,3);
      INSERT INTO t1 VALUES (9,0,NULL,'Connecticut',NULL,552);
      INSERT INTO t1 VALUES (0,0,NULL,'register',NULL,0);
      INSERT INTO t1 VALUES (-8679,0,NULL,'bk',NULL,-760);
      INSERT INTO t1 VALUES (32767,0,NULL,'orbit',NULL,0);
      INSERT INTO t1 VALUES (NULL,0,NULL,'kvm',NULL,7);
      INSERT INTO t1 VALUES (0,0,NULL,'mdqbjxjh',NULL,680);
      INSERT INTO t1 VALUES (32767,0,NULL,'m',NULL,-272);
      INSERT INTO t1 VALUES (0,0,NULL,'bj',NULL,0);
      INSERT INTO t1 VALUES (22547,0,NULL,'xj',NULL,194);
      INSERT INTO t1 VALUES (-32403,0,NULL,'gj',NULL,240);
      INSERT INTO t1 VALUES (6394,0,NULL,'Arizona',NULL,16);
      INSERT INTO t1 VALUES (4,0,NULL,'z',NULL,488);
      INSERT INTO t1 VALUES (114,0,NULL,'i',NULL,0);
      INSERT INTO t1 VALUES (3710,0,NULL,'p',NULL,291);
      INSERT INTO t1 VALUES (28654,0,NULL,'empty',NULL,245);
      INSERT INTO t1 VALUES (9849,0,NULL,'Pennsylvania',NULL,0);
      INSERT INTO t1 VALUES (185,0,NULL,'j',NULL,320);
      INSERT INTO t1 VALUES (5,0,NULL,'Tennessee',NULL,7);
      INSERT INTO t1 VALUES (154,0,NULL,'hl',NULL,157);
      INSERT INTO t1 VALUES (NULL,0,NULL,'lo',NULL,0);
      INSERT INTO t1 VALUES (NULL,0,NULL,'hc',NULL,NULL);
      INSERT INTO t1 VALUES (0,0,NULL,'must',NULL,755);
      INSERT INTO t1 VALUES (132,0,NULL,'m',NULL,95);
      INSERT INTO t1 VALUES (193,0,NULL,'poke',NULL,0);
      INSERT INTO t1 VALUES (32767,0,NULL,'o',NULL,-656);
      INSERT INTO t1 VALUES (172,0,NULL,'e',NULL,0);
      INSERT INTO t1 VALUES (7642,0,NULL,'feeling',NULL,NULL);
      INSERT INTO t1 VALUES (NULL,0,NULL,'cwmtpp',NULL,0);
      INSERT INTO t1 VALUES (0,0,NULL,'e',NULL,115);
      INSERT INTO t1 VALUES (32767,0,NULL,'Florida',NULL,505);
      INSERT INTO t1 VALUES (3,0,NULL,'Maryland',NULL,97);
      INSERT INTO t1 VALUES (NULL,0,NULL,'kill',NULL,NULL);
      INSERT INTO t1 VALUES (NULL,0,NULL,'qf',NULL,623);
      INSERT INTO t1 VALUES (0,0,NULL,'fz',NULL,812);
      INSERT INTO t1 VALUES (NULL,0,NULL,'greek',NULL,0);
      INSERT INTO t1 VALUES (0,0,NULL,'kglhiuodplizizzobpcq',NULL,6);
      INSERT INTO t1 VALUES (NULL,0,NULL,'l',NULL,0);
      INSERT INTO t1 VALUES (159,0,NULL,'s',NULL,7);
      INSERT INTO t1 VALUES (-25560,0,NULL,'z',NULL,656);
      INSERT INTO t1 VALUES (189,0,NULL,'u',NULL,0);
      INSERT INTO t1 VALUES (27110,0,NULL,'leather',NULL,9);
      INSERT INTO t1 VALUES (NULL,0,NULL,'li',NULL,944);
      INSERT INTO t1 VALUES (0,0,NULL,'attract',NULL,NULL);
      INSERT INTO t1 VALUES (9,0,NULL,'structural',NULL,71);
      INSERT INTO t1 VALUES (NULL,0,NULL,'settlement',NULL,4);
      INSERT INTO t1 VALUES (-15549,0,NULL,'n',NULL,564);
      INSERT INTO t1 VALUES (30391,0,NULL,'k',NULL,0);
      INSERT INTO t1 VALUES (0,0,NULL,'ob',NULL,NULL);
      INSERT INTO t1 VALUES (224,0,NULL,'bpcqqji',NULL,413);
      INSERT INTO t1 VALUES (32767,0,NULL,'nowhere',NULL,8);
      INSERT INTO t1 VALUES (15281,0,NULL,'Arkansas',NULL,-912);
      INSERT INTO t1 VALUES (-9327,0,NULL,'d',NULL,-904);
      INSERT INTO t1 VALUES (14055,0,NULL,'i',NULL,293);
      INSERT INTO t1 VALUES (3,0,NULL,'Louisiana',NULL,224);
      INSERT INTO t1 VALUES (NULL,0,NULL,'pw',NULL,-624);
      INSERT INTO t1 VALUES (32767,0,NULL,'nevertheless',NULL,208);
      INSERT INTO t1 VALUES (NULL,0,NULL,'z',NULL,NULL);
      INSERT INTO t1 VALUES (NULL,0,NULL,'spectacular',NULL,104);
      INSERT INTO t1 VALUES (0,0,NULL,'digital',NULL,89);
      INSERT INTO t1 VALUES (5,0,NULL,'aq',NULL,40);
      INSERT INTO t1 VALUES (NULL,0,NULL,'tm',NULL,411);
      INSERT INTO t1 VALUES (11726,0,NULL,'p',NULL,0);
      INSERT INTO t1 VALUES (3188,0,NULL,'knykleafajkq',NULL,0);
      INSERT INTO t1 VALUES (1,0,NULL,'technology',NULL,6);
      INSERT INTO t1 VALUES (NULL,0,NULL,'y',NULL,58);
      INSERT INTO t1 VALUES (67,0,NULL,'a',NULL,0);
      INSERT INTO t1 VALUES (-6719,0,NULL,'n',NULL,136);
      INSERT INTO t1 VALUES (8000,0,NULL,'j',NULL,-248);
      INSERT INTO t1 VALUES (32767,0,NULL,'snow',NULL,8);
      INSERT INTO t1 VALUES (-3623,0,NULL,'d',NULL,920);
      INSERT INTO t1 VALUES (NULL,0,NULL,'i',NULL,NULL);
      INSERT INTO t1 VALUES (3239,0,NULL,'Kansas',NULL,102);
      INSERT INTO t1 VALUES (7132,0,NULL,'zt',NULL,88);
      INSERT INTO t1 VALUES (-21941,0,NULL,'Tennessee',NULL,77);
      INSERT INTO t1 VALUES (45,0,NULL,'Virginia',NULL,3);
      INSERT INTO t1 VALUES (166,0,NULL,'m',NULL,NULL);
      INSERT INTO t1 VALUES (32767,0,NULL,'l',NULL,-880);
      INSERT INTO t1 VALUES (205,0,NULL,'Idaho',NULL,NULL);
      INSERT INTO t1 VALUES (10679,0,NULL,'f',NULL,2);
      INSERT INTO t1 VALUES (172,0,NULL,'North Dakota',NULL,NULL);
      INSERT INTO t1 VALUES (30942,0,NULL,'Indiana',NULL,832);
      INSERT INTO t1 VALUES (1824,0,NULL,'m',NULL,NULL);
      INSERT INTO t1 VALUES (34,0,NULL,'stumble',NULL,440);
      INSERT INTO t1 VALUES (12955,0,NULL,'juror',NULL,NULL);
      INSERT INTO t1 VALUES (NULL,0,NULL,'South Dakota',NULL,5);
      INSERT INTO t1 VALUES (25891,0,NULL,'j',NULL,0);
      INSERT INTO t1 VALUES (32767,0,NULL,'clerk',NULL,39);
      INSERT INTO t1 VALUES (13187,0,NULL,'gw',NULL,811);
      INSERT INTO t1 VALUES (0,0,NULL,'x',NULL,583);
      INSERT INTO t1 VALUES (6,0,NULL,'fb',NULL,140);
      INSERT INTO t1 VALUES (32767,0,NULL,'vp',NULL,781);
      INSERT INTO t1 VALUES (0,0,NULL,'if',NULL,NULL);
      INSERT INTO t1 VALUES (7497,0,NULL,'New Hampshire',NULL,233);
      INSERT INTO t1 VALUES (155,0,NULL,'e',NULL,NULL);
      INSERT INTO t1 VALUES (-18830,0,NULL,'q',NULL,84);
      INSERT INTO t1 VALUES (3815,0,NULL,'yy',NULL,8);
      INSERT INTO t1 VALUES (0,0,NULL,'Kansas',NULL,NULL);
      INSERT INTO t1 VALUES (0,0,NULL,'yqspnupv',NULL,0);
      INSERT INTO t1 VALUES (1,0,NULL,'hers',NULL,688);
      INSERT INTO t1 VALUES (32767,0,NULL,'pnupvmuqjaojhylsrbqichox',NULL,0);
      INSERT INTO t1 VALUES (NULL,0,NULL,'x',NULL,8);
      INSERT INTO t1 VALUES (3,0,NULL,'North Carolina',NULL,-88);
      INSERT INTO t1 VALUES (92,0,NULL,'u',NULL,0);
      INSERT INTO t1 VALUES (32126,0,NULL,'sensation',NULL,226);
      INSERT INTO t1 VALUES (4,0,NULL,'muqjao',NULL,0);
      INSERT INTO t1 VALUES (NULL,0,NULL,'aojhylsrbqichoxl',NULL,NULL);
      INSERT INTO t1 VALUES (32767,0,NULL,'tribe',NULL,0);
      INSERT INTO t1 VALUES (142,0,NULL,'jhy',NULL,6);
      INSERT INTO t1 VALUES (0,0,NULL,'w',NULL,622);
      INSERT INTO t1 VALUES (NULL,0,NULL,'New York',NULL,-56);
      INSERT INTO t1 VALUES (-24954,0,NULL,'bqichoxlxsarzbqouvscstrtpofjbbjrci',NULL,8);
      INSERT INTO t1 VALUES (4105,0,NULL,'New Hampshire',NULL,247);
      INSERT INTO t1 VALUES (0,0,NULL,'k',NULL,0);
      INSERT INTO t1 VALUES (46,0,NULL,'reader',NULL,400);
      INSERT INTO t1 VALUES (-29286,0,NULL,'ho',NULL,NULL);
      INSERT INTO t1 VALUES (169,0,NULL,'mr',NULL,0);
      INSERT INTO t1 VALUES (9,0,NULL,'y',NULL,333);
      INSERT INTO t1 VALUES (25168,0,NULL,'New Jersey',NULL,0);
      INSERT INTO t1 VALUES (NULL,0,NULL,'queen',NULL,2);
      INSERT INTO t1 VALUES (9,0,NULL,'bow',NULL,NULL);
      INSERT INTO t1 VALUES (7,0,NULL,'satellite',NULL,NULL);
      INSERT INTO t1 VALUES (1,0,NULL,'u',NULL,31);
      INSERT INTO t1 VALUES (NULL,0,NULL,'scstrtpofjbbjrcijlkzoyh',NULL,70);
      INSERT INTO t1 VALUES (26275,0,NULL,'b',NULL,7);
      INSERT INTO t1 VALUES (227,0,NULL,'card',NULL,6);
      INSERT INTO t1 VALUES (0,0,NULL,'p',NULL,140);
      INSERT INTO t1 VALUES (4,0,NULL,'Oregon',NULL,556);
      INSERT INTO t1 VALUES (-12170,0,NULL,'Missouri',NULL,292);
      INSERT INTO t1 VALUES (NULL,0,NULL,'bjrcijlkzoyhy',NULL,251);
      INSERT INTO t1 VALUES (NULL,0,NULL,'ci',NULL,NULL);
      INSERT INTO t1 VALUES (69,0,NULL,'g',NULL,-456);
      INSERT INTO t1 VALUES (NULL,0,NULL,'f',NULL,9);
      INSERT INTO t1 VALUES (NULL,0,NULL,'hynudnmi',NULL,45);
      INSERT INTO t1 VALUES (-30445,0,NULL,'widespread',NULL,0);
      INSERT INTO t1 VALUES (NULL,0,NULL,'Maryland',NULL,407);
      INSERT INTO t1 VALUES (NULL,0,NULL,'Delaware',NULL,-40);
      INSERT INTO t1 VALUES (30059,0,NULL,'n',NULL,NULL);
      INSERT INTO t1 VALUES (0,0,NULL,'u',NULL,0);
      INSERT INTO t1 VALUES (0,0,NULL,'znwacpbwghlegvykaobxv',NULL,7);
      INSERT INTO t1 VALUES (174,0,NULL,'r',NULL,9);
      INSERT INTO t1 VALUES (NULL,0,NULL,'West Virginia',NULL,71);
      INSERT INTO t1 VALUES (2593,0,NULL,'z',NULL,2);
      INSERT INTO t1 VALUES (-28371,0,NULL,'v',NULL,89);
      INSERT INTO t1 VALUES (23749,0,NULL,'e',NULL,NULL);
      INSERT INTO t1 VALUES (NULL,0,NULL,'w',NULL,183);
      INSERT INTO t1 VALUES (NULL,0,NULL,'ghl',NULL,776);
      INSERT INTO t1 VALUES (4,0,NULL,'Mississippi',NULL,8);
      INSERT INTO t1 VALUES (9210,0,NULL,'z',NULL,246);
      INSERT INTO t1 VALUES (12724,0,NULL,'South Dakota',NULL,222);
      INSERT INTO t1 VALUES (NULL,0,NULL,'outlet',NULL,790);
      INSERT INTO t1 VALUES (NULL,0,NULL,'Indiana',NULL,-8);
      INSERT INTO t1 VALUES (NULL,0,NULL,'aob',NULL,0);
      INSERT INTO t1 VALUES (7,0,NULL,'tell',NULL,-648);
      INSERT INTO t1 VALUES (0,0,NULL,'u',NULL,381);
      INSERT INTO t1 VALUES (7,0,NULL,'vqhhtakqoppfcrb',NULL,747);
      INSERT INTO t1 VALUES (4,0,NULL,'Arkansas',NULL,816);
      INSERT INTO t1 VALUES (0,0,NULL,'slight',NULL,NULL);
      INSERT INTO t1 VALUES (NULL,0,NULL,'upset',NULL,4);
      INSERT INTO t1 VALUES (-17416,0,NULL,'Nebraska',NULL,9);
      INSERT INTO t1 VALUES (137,0,NULL,'takqoppfcrbangizjeqc',NULL,672);
      INSERT INTO t1 VALUES (-326,0,NULL,'spill',NULL,NULL);
      INSERT INTO t1 VALUES (0,0,NULL,'w',NULL,NULL);
      INSERT INTO t1 VALUES (NULL,0,NULL,'crb',NULL,166);
      INSERT INTO t1 VALUES (NULL,0,NULL,'Mississippi',NULL,NULL);
      INSERT INTO t1 VALUES (32767,0,NULL,'ba',NULL,0);
      INSERT INTO t1 VALUES (NULL,0,NULL,'a',NULL,1);
      INSERT INTO t1 VALUES (61,0,NULL,'izj',NULL,-744);
      INSERT INTO t1 VALUES (-26413,0,NULL,'Nevada',NULL,NULL);
      INSERT INTO t1 VALUES (6,0,NULL,'Mississippi',NULL,416);
      INSERT INTO t1 VALUES (0,0,NULL,'Nevada',NULL,0);
      INSERT INTO t1 VALUES (0,0,NULL,'b',NULL,470);
      INSERT INTO t1 VALUES (2864,0,NULL,'x',NULL,NULL);
      INSERT INTO t1 VALUES (NULL,0,NULL,'Montana',NULL,248);
      INSERT INTO t1 VALUES (32767,0,NULL,'y',NULL,2);
      INSERT INTO t1 VALUES (0,0,NULL,'Arkansas',NULL,107);
      INSERT INTO t1 VALUES (243,0,NULL,'bb',NULL,NULL);
      INSERT INTO t1 VALUES (-7006,0,NULL,'y',NULL,262);
      INSERT INTO t1 VALUES (29170,0,NULL,'data',NULL,257);
      INSERT INTO t1 VALUES (NULL,0,NULL,'procedure',NULL,5);
      INSERT INTO t1 VALUES (NULL,0,NULL,'u',NULL,182);
      INSERT INTO t1 VALUES (0,0,NULL,'lczldnxhwgkrabptlqda',NULL,158);
      INSERT INTO t1 VALUES (10754,0,NULL,'cream',NULL,0);
      INSERT INTO t1 VALUES (31943,0,NULL,'open',NULL,4);
      INSERT INTO t1 VALUES (NULL,0,NULL,'hwg',NULL,NULL);
      INSERT INTO t1 VALUES (5,0,NULL,'Wyoming',NULL,NULL);
      INSERT INTO t1 VALUES (-27782,0,NULL,'r',NULL,187);
      INSERT INTO t1 VALUES (32767,0,NULL,'ab',NULL,0);
      INSERT INTO t1 VALUES (3,0,NULL,'ptlqda',NULL,-288);
      INSERT INTO t1 VALUES (32767,0,NULL,'q',NULL,72);
      INSERT INTO t1 VALUES (-22284,0,NULL,'e',NULL,664);
      INSERT INTO t1 VALUES (7,0,NULL,'Florida',NULL,NULL);
      INSERT INTO t1 VALUES (0,0,NULL,'movfyh',NULL,-784);
      INSERT INTO t1 VALUES (NULL,0,NULL,'vfy',NULL,784);
      INSERT INTO t1 VALUES (37,0,NULL,'h',NULL,105);
      INSERT INTO t1 VALUES (32767,0,NULL,'r',NULL,0);
      INSERT INTO t1 VALUES (145,0,NULL,'Hawaii',NULL,NULL);
      INSERT INTO t1 VALUES (0,0,NULL,'Minnesota',NULL,0);
      INSERT INTO t1 VALUES (4,0,NULL,'ov',NULL,181);
      INSERT INTO t1 VALUES (0,0,NULL,'coming',NULL,5);
      INSERT INTO t1 VALUES (32767,0,NULL,'mnry',NULL,946);
      INSERT INTO t1 VALUES (NULL,0,NULL,'Arizona',NULL,NULL);
      INSERT INTO t1 VALUES (-2368,0,NULL,'c',NULL,0);
      INSERT INTO t1 VALUES (-21715,0,NULL,'ljfxl',NULL,NULL);
      INSERT INTO t1 VALUES (0,0,NULL,'Wyoming',NULL,0);
      INSERT INTO t1 VALUES (0,0,NULL,'fxlxhdnief',NULL,NULL);
      INSERT INTO t1 VALUES (0,0,NULL,'MariaDB is a community-developed, commercially',NULL,NULL);
      INSERT INTO t1 VALUES (0,0,NULL,'Mississippi',NULL,624);
      INSERT INTO t1 VALUES (6,0,NULL,'h',NULL,198);
      INSERT INTO t1 VALUES (-11442,0,NULL,'Massachusetts',NULL,NULL);
      INSERT INTO t1 VALUES (0,0,NULL,'i',NULL,0);
      INSERT INTO t1 VALUES (NULL,0,NULL,'draw',NULL,0);
      INSERT INTO t1 VALUES (32767,0,NULL,'k',NULL,0);
      INSERT INTO t1 VALUES (32767,0,NULL,'ztabdvhywbflylhukxqufevtdhnfzpccsuyvzargiogjfsnofsruoqac',NULL,53);
      INSERT INTO t1 VALUES (0,0,NULL,'all',NULL,994);
      INSERT INTO t1 VALUES (-18287,0,NULL,'abdvhywbflylhukxqu',NULL,878);
      INSERT INTO t1 VALUES (0,0,NULL,'Wyoming',NULL,847);
      INSERT INTO t1 VALUES (6,0,NULL,'dv',NULL,204);
      INSERT INTO t1 VALUES (246,0,NULL,'ywbflylhukxqufevtdhnfzpccsuyvzargiogjfsnofsruo',NULL,183);
      INSERT INTO t1 VALUES (20335,0,NULL,'f',NULL,NULL);
      INSERT INTO t1 VALUES (0,0,NULL,'l',NULL,223);
      INSERT INTO t1 VALUES (NULL,0,NULL,'hukxqufevtdhnfzpccsuyvzargiogjfsnofsruoqacwwy',NULL,577);
      INSERT INTO t1 VALUES (180,0,NULL,'qu',NULL,6);
      INSERT INTO t1 VALUES (9,0,NULL,'f',NULL