hash-threshold 8

statement ok
CREATE TABLE tab0(pk INTEGER PRIMARY KEY, col0 INTEGER, col1 FLOAT, col2 TEXT, col3 INTEGER, col4 FLOAT, col5 TEXT)

statement ok
INSERT INTO tab0 VALUES(0,92529,298553.6,'roeqz',536254,404235.56,'ihmvy')

statement ok
INSERT INTO tab0 VALUES(1,174621,202941.78,'opxlf',414550,446655.53,'rlmak')

statement ok
INSERT INTO tab0 VALUES(2,298278,606201.63,'rrayy',569854,672119.42,'mnxat')

statement ok
INSERT INTO tab0 VALUES(3,366577,80261.5,'fobli',535217,762847.32,'widjo')

statement ok
INSERT INTO tab0 VALUES(4,573638,324005.11,'opria',197113,340637.53,'ngqef')

statement ok
INSERT INTO tab0 VALUES(5,529663,788269.60,'tvplw',920562,591674.64,'dnqoq')

statement ok
INSERT INTO tab0 VALUES(6,385742,300811.20,'jcyun',674133,891571.69,'germw')

statement ok
INSERT INTO tab0 VALUES(7,959075,691436.58,'ygbcb',154815,430419.27,'ojias')

statement ok
INSERT INTO tab0 VALUES(8,857849,416778.52,'pfbrp',913238,837799.63,'vgqnf')

statement ok
INSERT INTO tab0 VALUES(9,606231,185516.6,'vzmoy',478454,807678.86,'iiypp')

statement ok
INSERT INTO tab0 VALUES(10,769470,583282.59,'ybwud',483093,723510.95,'plmim')

statement ok
INSERT INTO tab0 VALUES(11,78796,697570.0,'uflhg',788208,283233.98,'aaxkw')

statement ok
INSERT INTO tab0 VALUES(12,556427,742919.81,'jxthu',608489,124176.18,'ibyhp')

statement ok
INSERT INTO tab0 VALUES(13,640655,685760.28,'lhceo',637054,448181.12,'khbez')

statement ok
INSERT INTO tab0 VALUES(14,310760,869567.53,'dhnub',170562,646484.76,'wkcgk')

statement ok
INSERT INTO tab0 VALUES(15,212036,639678.68,'qtcnf',234191,924804.65,'qbuwb')

statement ok
INSERT INTO tab0 VALUES(16,780761,968383.97,'utric',706634,928344.1,'oapml')

statement ok
INSERT INTO tab0 VALUES(17,369293,80017.89,'qioaj',445129,366699.86,'bkcyb')

statement ok
INSERT INTO tab0 VALUES(18,370971,75744.28,'ebcga',410369,638977.18,'vqsoa')

statement ok
INSERT INTO tab0 VALUES(19,345123,558776.50,'wwgux',791595,458679.96,'jqjfr')

statement ok
INSERT INTO tab0 VALUES(20,142150,259246.51,'jehlo',131561,478790.41,'oadnh')

statement ok
INSERT INTO tab0 VALUES(21,28442,659240.1,'chkjo',451568,916778.4,'mdrym')

statement ok
INSERT INTO tab0 VALUES(22,811370,617797.60,'uehci',376373,179504.77,'vfdwd')

statement ok
INSERT INTO tab0 VALUES(23,964416,995910.83,'ivurt',259246,488342.10,'qmnut')

statement ok
INSERT INTO tab0 VALUES(24,751922,281494.41,'dhpvr',307098,504058.21,'yinlg')

statement ok
INSERT INTO tab0 VALUES(25,354431,214508.28,'xusas',705169,951904.7,'ikzvn')

statement ok
INSERT INTO tab0 VALUES(26,993347,411743.73,'hxhrt',742340,246612.60,'pspmc')

statement ok
INSERT INTO tab0 VALUES(27,56182,992034.56,'kqaeo',936004,117309.77,'juqmr')

statement ok
INSERT INTO tab0 VALUES(28,221435,201141.20,'noycm',157012,232604.72,'tuhrx')

statement ok
INSERT INTO tab0 VALUES(29,583587,36804.81,'szbhb',754760,825592.92,'vrprw')

statement ok
INSERT INTO tab0 VALUES(30,778198,873596.42,'jzuyp',682159,318786.24,'nfxcs')

statement ok
INSERT INTO tab0 VALUES(31,106811,88226.6,'yqtwv',620666,949096.15,'agoql')

statement ok
INSERT INTO tab0 VALUES(32,661987,684234.87,'oajln',105194,393005.76,'mtlfj')

statement ok
INSERT INTO tab0 VALUES(33,452270,917144.24,'pnnxf',649200,391387.0,'qxrbs')

statement ok
INSERT INTO tab0 VALUES(34,527282,919403.94,'gszhp',869659,374542.75,'jihxk')

statement ok
INSERT INTO tab0 VALUES(35,102630,325500.21,'ishtj',612060,87249.93,'ndsao')

statement ok
INSERT INTO tab0 VALUES(36,684906,896759.92,'tfhnu',75439,213745.63,'gamme')

statement ok
INSERT INTO tab0 VALUES(37,196777,146545.70,'fnqeh',937255,2746.27,'xowcu')

statement ok
INSERT INTO tab0 VALUES(38,101898,965148.2,'tvpqa',478607,892395.70,'lcmqx')

statement ok
INSERT INTO tab0 VALUES(39,529907,244812.38,'lhnjq',709045,135253.30,'gbycx')

statement ok
INSERT INTO tab0 VALUES(40,401519,504730.35,'ccqmw',491577,423370.16,'pykmm')

statement ok
INSERT INTO tab0 VALUES(41,553436,516052.80,'rqnwz',667816,513244.17,'jphjh')

statement ok
INSERT INTO tab0 VALUES(42,863342,926849.93,'bqujr',182891,850860.14,'pduoq')

statement ok
INSERT INTO tab0 VALUES(43,375030,887237.45,'rgsto',210388,196624.95,'fhrpa')

statement ok
INSERT INTO tab0 VALUES(44,423187,674163.67,'bfwzs',277435,250366.66,'pjtsv')

statement ok
INSERT INTO tab0 VALUES(45,758575,316650.68,'ozsil',389709,276397.62,'eloyy')

statement ok
INSERT INTO tab0 VALUES(46,673034,220550.41,'xvhkw',156311,728485.64,'bnyij')

statement ok
INSERT INTO tab0 VALUES(47,124298,793762.79,'vyskm',914978,874877.7,'unvyu')

statement ok
INSERT INTO tab0 VALUES(48,861175,71105.88,'qpyew',856872,423217.94,'tpoci')

statement ok
INSERT INTO tab0 VALUES(49,548553,339355.97,'bhigh',151702,145660.8,'zcwmz')

statement ok
INSERT INTO tab0 VALUES(50,892211,762237.72,'pthdh',72723,503753.28,'sugfm')

statement ok
INSERT INTO tab0 VALUES(51,764038,5401.30,'hivkh',121612,273559.35,'yyryt')

statement ok
INSERT INTO tab0 VALUES(52,326904,861541.48,'jthsj',153686,170532.31,'elgen')

statement ok
INSERT INTO tab0 VALUES(53,159667,875183.78,'tpxys',502685,474609.48,'byubc')

statement ok
INSERT INTO tab0 VALUES(54,382263,967926.61,'vemng',105895,655181.60,'ubkxv')

statement ok
INSERT INTO tab0 VALUES(55,780578,63201.33,'ztwhl',629150,996124.98,'bgfzv')

statement ok
INSERT INTO tab0 VALUES(56,931610,711486.47,'eswtt',591705,220733.60,'kgyvo')

statement ok
INSERT INTO tab0 VALUES(57,328247,715179.76,'tpngi',491455,116729.26,'zamgn')

statement ok
INSERT INTO tab0 VALUES(58,504486,753631.32,'whbyo',929718,161315.68,'ewrqs')

statement ok
INSERT INTO tab0 VALUES(59,160278,8148.78,'fcfbv',736358,146179.64,'drtwm')

statement ok
INSERT INTO tab0 VALUES(60,286651,786956.35,'pyczb',94787,802398.11,'nwaoa')

statement ok
INSERT INTO tab0 VALUES(61,290618,150329.2,'rktjh',666839,425537.36,'atpex')

statement ok
INSERT INTO tab0 VALUES(62,120208,535369.62,'lxshl',717987,500640.8,'djwdz')

statement ok
INSERT INTO tab0 VALUES(63,389434,381256.1,'wvpgv',242126,327148.54,'oxfys')

statement ok
INSERT INTO tab0 VALUES(64,503387,753997.13,'qozot',86700,643981.67,'aqpjy')

statement ok
INSERT INTO tab0 VALUES(65,783142,971649.19,'rsreh',77697,254547.22,'vbgkn')

statement ok
INSERT INTO tab0 VALUES(66,590759,229187.76,'uiqzs',144531,651672.87,'lcfpz')

statement ok
INSERT INTO tab0 VALUES(67,454376,223541.90,'itlyi',445251,642578.35,'gezcx')

statement ok
INSERT INTO tab0 VALUES(68,193115,778594.31,'uzxcx',491333,974090.58,'zjery')

statement ok
INSERT INTO tab0 VALUES(69,42114,470153.40,'iqwwl',272827,957305.78,'olcac')

statement ok
INSERT INTO tab0 VALUES(70,777496,251068.48,'shoxq',383209,92926.60,'mdmun')

statement ok
INSERT INTO tab0 VALUES(71,841461,76049.83,'mimpu',144592,696014.26,'rexqc')

statement ok
INSERT INTO tab0 VALUES(72,467193,526763.88,'zgwub',732513,521148.66,'ajrnd')

statement ok
INSERT INTO tab0 VALUES(73,803863,436889.27,'uvjgj',301055,387298.47,'xvgru')

statement ok
INSERT INTO tab0 VALUES(74,41717,517028.3,'jarnz',107818,802947.35,'zbxwz')

statement ok
INSERT INTO tab0 VALUES(75,536987,979736.68,'qkcha',638916,590942.98,'tblkt')

statement ok
INSERT INTO tab0 VALUES(76,936889,164520.36,'uyhhe',734008,513732.22,'cmshb')

statement ok
INSERT INTO tab0 VALUES(77,304718,162841.94,'rkuqh',711212,898040.25,'brilj')

statement ok
INSERT INTO tab0 VALUES(78,244750,443115.18,'ojqsa',492187,260192.68,'iygqe')

statement ok
INSERT INTO tab0 VALUES(79,27282,475677.83,'tjcon',727111,930908.68,'xpkuu')

statement ok
INSERT INTO tab0 VALUES(80,713592,357910.74,'ezdtv',919708,680297.8,'wbgbv')

statement ok
INSERT INTO tab0 VALUES(81,281036,439025.3,'baetu',552124,343078.54,'synwz')

statement ok
INSERT INTO tab0 VALUES(82,747924,945312.17,'morwo',210144,443237.65,'gkvfl')

statement ok
INSERT INTO tab0 VALUES(83,298675,604888.14,'ceukc',707977,819366.5,'czfor')

statement ok
INSERT INTO tab0 VALUES(84,408599,272918.53,'qzvwa',213409,249450.55,'hxueb')

statement ok
INSERT INTO tab0 VALUES(85,969116,556488.66,'pvczc',372650,75866.29,'adkdk')

statement ok
INSERT INTO tab0 VALUES(86,412597,439605.75,'yinxv',435546,830596.83,'cmikp')

statement ok
INSERT INTO tab0 VALUES(87,837493,908325.0,'pdzkf',380371,859893.28,'sxsek')

statement ok
INSERT INTO tab0 VALUES(88,133239,575561.72,'dwhsh',38940,949615.45,'zjisu')

statement ok
INSERT INTO tab0 VALUES(89,105285,306182.47,'klrau',221588,949981.94,'rcetu')

statement ok
INSERT INTO tab0 VALUES(90,600067,842102.18,'eahgq',842193,400726.28,'rubkb')

statement ok
INSERT INTO tab0 VALUES(91,630096,427062.29,'qfaot',43060,155975.8,'spijk')

statement ok
INSERT INTO tab0 VALUES(92,498870,431854.82,'ggbar',320129,9368.9,'agkcq')

statement ok
INSERT INTO tab0 VALUES(93,925872,979187.58,'dbkda',647766,318939.42,'wkkwx')

statement ok
INSERT INTO tab0 VALUES(94,171661,568725.21,'witvf',603912,632202.57,'gktxo')

statement ok
INSERT INTO tab0 VALUES(95,162780,702087.37,'bttkd',494934,311126.61,'nsznr')

statement ok
INSERT INTO tab0 VALUES(96,616790,507843.84,'wbzxr',480834,157196.29,'xybhr')

statement ok
INSERT INTO tab0 VALUES(97,167236,366485.61,'vglfm',700042,36193.18,'hxgby')

statement ok
INSERT INTO tab0 VALUES(98,488739,535552.9,'iobzj',394531,503509.76,'swsen')

statement ok
INSERT INTO tab0 VALUES(99,421875,774414.14,'frlzf',34790,428894.57,'bmznq')

statement ok
INSERT INTO tab0 VALUES(100,98327,969512.26,'oxpbi',444854,621612.36,'sfsum')

statement ok
INSERT INTO tab0 VALUES(101,65673,759124.70,'efhlh',927215,455322.15,'bdjlp')

statement ok
INSERT INTO tab0 VALUES(102,412567,158569.57,'glxrk',387908,493164.41,'hgqxs')

statement ok
INSERT INTO tab0 VALUES(103,893737,185089.96,'zizvl',461486,112762.16,'uqfri')

statement ok
INSERT INTO tab0 VALUES(104,54809,482879.11,'hsuqe',636016,131134.11,'akloe')

statement ok
INSERT INTO tab0 VALUES(105,357513,948059.47,'gpbqd',378112,429809.78,'yawpc')

statement ok
INSERT INTO tab0 VALUES(106,304534,353790.90,'xhnhb',257812,579711.59,'vfuho')

statement ok
INSERT INTO tab0 VALUES(107,564636,975097.71,'urpyr',73791,466247.6,'qjdvc')

statement ok
INSERT INTO tab0 VALUES(108,97564,213958.87,'obahf',978179,914306.87,'wjtbi')

statement ok
INSERT INTO tab0 VALUES(109,279083,224365.5,'rmhcd',601562,313171.0,'czkpe')

statement ok
INSERT INTO tab0 VALUES(110,25939,537261.84,'awpsp',178161,241607.87,'puzdu')

statement ok
INSERT INTO tab0 VALUES(111,920959,685455.77,'kbfxi',670593,92864.46,'zjoja')

statement ok
INSERT INTO tab0 VALUES(112,337951,828796.54,'jxfdz',895111,699615.43,'ulrga')

statement ok
INSERT INTO tab0 VALUES(113,566741,379058.7,'qocpy',646392,958923.25,'eacba')

statement ok
INSERT INTO tab0 VALUES(114,938140,624938.63,'wlikv',822692,457427.30,'lnlov')

statement ok
INSERT INTO tab0 VALUES(115,949035,357177.2,'hjcti',550689,96160.5,'vvxbm')

statement ok
INSERT INTO tab0 VALUES(116,387268,493377.64,'evwxm',310699,715576.13,'wkqqw')

statement ok
INSERT INTO tab0 VALUES(117,456787,703094.64,'qzakr',61462,720611.47,'jpocj')

statement ok
INSERT INTO tab0 VALUES(118,902435,32897.4,'etkga',365264,705688.46,'royjm')

statement ok
INSERT INTO tab0 VALUES(119,135131,531311.83,'gacza',512939,79620.2,'ombim')

statement ok
INSERT INTO tab0 VALUES(120,356872,873718.17,'avxrh',648742,690704.77,'rqsdx')

statement ok
INSERT INTO tab0 VALUES(121,685546,987548.41,'xjdib',895568,451721.11,'jqzhj')

statement ok
INSERT INTO tab0 VALUES(122,280120,677154.30,'ebary',479736,964843.41,'blttc')

statement ok
INSERT INTO tab0 VALUES(123,465637,248809.9,'rxmqj',856140,146759.6,'cnkzl')

statement ok
INSERT INTO tab0 VALUES(124,858032,135833.62,'jluek',833099,853546.66,'gykhu')

statement ok
INSERT INTO tab0 VALUES(125,489349,523406.49,'zvapf',697570,505767.10,'jpytv')

statement ok
INSERT INTO tab0 VALUES(126,932617,973663.18,'qewow',339904,713470.71,'ygpkm')

statement ok
INSERT INTO tab0 VALUES(127,426849,50750.15,'mkdgs',379089,901092.36,'yqujk')

statement ok
INSERT INTO tab0 VALUES(128,2136,945770.99,'gqkoi',287567,932586.63,'drsao')

statement ok
INSERT INTO tab0 VALUES(129,604553,101684.52,'bctbu',516235,736297.88,'amqbw')

statement ok
INSERT INTO tab0 VALUES(130,221160,838500.93,'uieio',619628,930053.42,'dptoa')

statement ok
INSERT INTO tab0 VALUES(131,5096,978149.92,'yliwa',380706,446166.61,'ycrit')

statement ok
INSERT INTO tab0 VALUES(132,400482,469482.79,'dyhlc',935974,156341.98,'kqdvu')

statement ok
INSERT INTO tab0 VALUES(133,267425,13397.61,'rfxzx',900451,496765.39,'nrqhh')

statement ok
INSERT INTO tab0 VALUES(134,7141,687652.29,'jipwh',492675,93109.12,'xnyzn')

statement ok
INSERT INTO tab0 VALUES(135,686737,571960.75,'ajyaq',659729,385437.99,'pnwgm')

statement ok
INSERT INTO tab0 VALUES(136,164398,373077.3,'zlizg',202148,253326.54,'qdsqq')

statement ok
INSERT INTO tab0 VALUES(137,214385,49591.40,'axncf',899017,640747.7,'nddbg')

statement ok
INSERT INTO tab0 VALUES(138,651855,437133.52,'qkjpw',632934,181182.86,'bpnvi')

statement ok
INSERT INTO tab0 VALUES(139,458038,873260.53,'abgsm',515045,822509.20,'veuxc')

statement ok
INSERT INTO tab0 VALUES(140,905242,822479.20,'jozxv',9918,452087.60,'vcyyp')

statement ok
INSERT INTO tab0 VALUES(141,681671,501251.2,'rggty',60760,521728.86,'hjsll')

statement ok
INSERT INTO tab0 VALUES(142,16632,502960.38,'iidlo',214202,672729.21,'yydwg')

statement ok
INSERT INTO tab0 VALUES(143,805389,423034.64,'vzcny',745422,360809.43,'asism')

statement ok
INSERT INTO tab0 VALUES(144,734313,483764.30,'ejfhi',783142,481109.0,'ptvtv')

statement ok
INSERT INTO tab0 VALUES(145,405670,159393.8,'tybsq',434539,993255.20,'kincd')

statement ok
INSERT INTO tab0 VALUES(146,462799,801177.10,'skeud',910339,546325.23,'iddhr')

statement ok
INSERT INTO tab0 VALUES(147,715118,262298.95,'vyuly',649780,103881.36,'dkvld')

statement ok
INSERT INTO tab0 VALUES(148,262939,522888.84,'ajmvu',445617,568908.4,'yzwmx')

statement ok
INSERT INTO tab0 VALUES(149,622650,315032.73,'wbpgn',569122,408813.3,'ckfba')

statement ok
INSERT INTO tab0 VALUES(150,851715,747772.45,'mjdow',895112,280487.50,'oggvl')

statement ok
INSERT INTO tab0 VALUES(151,673492,932098.83,'xlebw',26855,655273.19,'pxgna')

statement ok
INSERT INTO tab0 VALUES(152,602447,605957.81,'uprrs',421173,444000.55,'mccdy')

statement ok
INSERT INTO tab0 VALUES(153,69030,759216.58,'fixef',513397,621917.78,'bqyyh')

statement ok
INSERT INTO tab0 VALUES(154,544677,258758.68,'xmfen',842407,853668.6,'kvsrw')

statement ok
INSERT INTO tab0 VALUES(155,666900,473419.18,'jgoiq',175537,118469.61,'ilxtq')

statement ok
INSERT INTO tab0 VALUES(156,364196,898895.73,'bnhme',633666,334930.82,'gxael')

statement ok
INSERT INTO tab0 VALUES(157,981048,782928.76,'hvosx',816192,986083.40,'mkhvr')

statement ok
INSERT INTO tab0 VALUES(158,403015,750183.54,'tncnj',926025,744445.50,'ezipt')

statement ok
INSERT INTO tab0 VALUES(159,181640,427276.35,'dvtwp',894622,97015.80,'vssmw')

statement ok
INSERT INTO tab0 VALUES(160,659454,67749.59,'ufglq',506866,970184.68,'tupno')

statement ok
INSERT INTO tab0 VALUES(161,95092,177185.90,'ifqse',526275,354827.33,'zskik')

statement ok
INSERT INTO tab0 VALUES(162,788055,138031.28,'gtzzf',819793,931304.86,'shivm')

statement ok
INSERT INTO tab0 VALUES(163,204040,834686.24,'occqs',482940,694366.45,'yybnf')

statement ok
INSERT INTO tab0 VALUES(164,99609,278564.90,'meaee',964660,578277.44,'coltw')

statement ok
INSERT INTO tab0 VALUES(165,647430,233032.12,'wrskf',192535,81695.50,'vayod')

statement ok
INSERT INTO tab0 VALUES(166,561157,838317.65,'dyqni',697571,892761.72,'hwmax')

statement ok
INSERT INTO tab0 VALUES(167,220458,236694.21,'njlfj',739318,514099.75,'duvhr')

statement ok
INSERT INTO tab0 VALUES(168,795989,197326.65,'clowh',430847,887725.92,'womtl')

statement ok
INSERT INTO tab0 VALUES(169,374450,741424.6,'cuvpr',863769,20172.36,'qfabe')

statement ok
INSERT INTO tab0 VALUES(170,83618,767059.91,'qjenl',233154,607360.15,'sfalh')

statement ok
INSERT INTO tab0 VALUES(171,217163,674255.14,'kpapl',962615,659698.40,'imkpr')

statement ok
INSERT INTO tab0 VALUES(172,359863,990081.35,'emhda',829284,127075.43,'bpfax')

statement ok
INSERT INTO tab0 VALUES(173,512481,993438.84,'osqps',88806,523773.85,'pvhzd')

statement ok
INSERT INTO tab0 VALUES(174,216766,340270.80,'nuhwx',600372,553588.70,'imtuo')

statement ok
INSERT INTO tab0 VALUES(175,680541,688446.42,'adtjj',951629,734680.58,'ztque')

statement ok
INSERT INTO tab0 VALUES(176,902618,322784.0,'rjdew',583770,24810.78,'gzsni')

statement ok
INSERT INTO tab0 VALUES(177,797790,780059.8,'lccdz',916503,446014.40,'kuwxh')

statement ok
INSERT INTO tab0 VALUES(178,321960,473999.58,'amgal',473052,709960.44,'xfwia')

statement ok
INSERT INTO tab0 VALUES(179,596893,320281.91,'uyxnz',5187,842590.98,'atzsr')

statement ok
INSERT INTO tab0 VALUES(180,35552,361511.10,'dopqx',618133,809448.30,'noltg')

statement ok
INSERT INTO tab0 VALUES(181,466766,392333.92,'hcwop',895660,140441.95,'gokxi')

statement ok
INSERT INTO tab0 VALUES(182,260467,584228.1,'xesvi',25054,554992.93,'tnfsm')

statement ok
INSERT INTO tab0 VALUES(183,452575,110717.0,'nihpt',922119,586914.80,'vggsc')

statement ok
INSERT INTO tab0 VALUES(184,869995,772247.66,'mcprp',356201,209503.79,'kslqv')

statement ok
INSERT INTO tab0 VALUES(185,255706,621215.98,'hjzof',75103,460540.94,'ubapm')

statement ok
INSERT INTO tab0 VALUES(186,393676,586975.32,'jfwti',930175,67199.24,'ryafi')

statement ok
INSERT INTO tab0 VALUES(187,233886,100830.56,'rfhro',1281,71166.71,'kkwqx')

statement ok
INSERT INTO tab0 VALUES(188,17303,721038.17,'hnpya',721801,453521.56,'yefrq')

statement ok
INSERT INTO tab0 VALUES(189,400970,757781.38,'baana',3662,759826.32,'gujcl')

statement ok
INSERT INTO tab0 VALUES(190,582885,898284.28,'fhkru',362243,725128.94,'zozoi')

statement ok
INSERT INTO tab0 VALUES(191,427154,831604.97,'barfu',41473,898864.91,'dysub')

statement ok
INSERT INTO tab0 VALUES(192,588775,873840.64,'mwnpr',138793,269989.44,'sjtvt')

statement ok
INSERT INTO tab0 VALUES(193,638824,593017.76,'rrcer',730163,891845.52,'groyl')

statement ok
INSERT INTO tab0 VALUES(194,189453,434112.14,'rsozk',995086,507263.8,'malxx')

statement ok
INSERT INTO tab0 VALUES(195,18707,344055.10,'bptgj',341522,173553.10,'zbecb')

statement ok
INSERT INTO tab0 VALUES(196,195739,396728.57,'pouio',530975,887420.74,'ucppt')

statement ok
INSERT INTO tab0 VALUES(197,205657,417968.24,'tnsug',803466,210052.49,'aeghe')

statement ok
INSERT INTO tab0 VALUES(198,74645,610534.65,'lgaqm',2563,892120.23,'midbw')

statement ok
INSERT INTO tab0 VALUES(199,494873,179229.33,'okkkq',700256,498718.45,'jldww')

statement ok
INSERT INTO tab0 VALUES(200,949523,955688.97,'qslgg',322174,34332.27,'sqsxs')

statement ok
INSERT INTO tab0 VALUES(201,837768,23620.45,'mfzem',272369,568023.65,'fgprx')

statement ok
INSERT INTO tab0 VALUES(202,599853,343566.5,'vdyzu',58441,858245.47,'vcien')

statement ok
INSERT INTO tab0 VALUES(203,842010,378112.55,'wgypp',416534,977874.66,'eiyxx')

statement ok
INSERT INTO tab0 VALUES(204,461486,716766.32,'avvbt',436248,939270.34,'nwqgg')

statement ok
INSERT INTO tab0 VALUES(205,771514,700958.51,'kwlpm',685699,319274.95,'bjdgg')

statement ok
INSERT INTO tab0 VALUES(206,626403,49163.11,'nebzq',336608,884124.34,'tjtzs')

statement ok
INSERT INTO tab0 VALUES(207,546417,481719.12,'yodlo',289154,214538.92,'xkoqd')

statement ok
INSERT INTO tab0 VALUES(208,842895,345916.65,'vwzwp',296966,330718.78,'udjpl')

statement ok
INSERT INTO tab0 VALUES(209,743164,241088.6,'rcfwx',92315,317260.84,'emdon')

statement ok
INSERT INTO tab0 VALUES(210,515563,643402.7,'uqobt',510894,948272.92,'dursu')

statement ok
INSERT INTO tab0 VALUES(211,594421,531066.92,'cgjzl',616943,312255.91,'mwhvb')

statement ok
INSERT INTO tab0 VALUES(212,705139,9216.44,'nkhjv',828216,437194.89,'ofkkx')

statement ok
INSERT INTO tab0 VALUES(213,989105,934936.21,'xcvgw',41015,915557.24,'uadti')

statement ok
INSERT INTO tab0 VALUES(214,128723,542266.69,'kgdbk',755065,529205.76,'fkwcp')

statement ok
INSERT INTO tab0 VALUES(215,472381,67199.33,'eskrr',198730,874481.83,'hmcxq')

statement ok
INSERT INTO tab0 VALUES(216,159545,372650.70,'ckrsx',453796,987213.49,'kmvrr')

statement ok
INSERT INTO tab0 VALUES(217,245635,573577.60,'flknc',580627,967651.60,'nyhjz')

statement ok
INSERT INTO tab0 VALUES(218,827178,661773.22,'ohzkl',743011,605438.95,'vupjm')

statement ok
INSERT INTO tab0 VALUES(219,166595,131072.23,'puqpd',333374,4821.37,'hjhqh')

statement ok
INSERT INTO tab0 VALUES(220,817382,602264.93,'alrox',97564,209320.90,'ktbwj')

statement ok
INSERT INTO tab0 VALUES(221,749114,447998.36,'gjlzr',259979,827056.86,'qtgoe')

statement ok
INSERT INTO tab0 VALUES(222,472259,417969.41,'aovab',648529,655517.3,'hapfh')

statement ok
INSERT INTO tab0 VALUES(223,163391,263763.0,'gyvhg',819671,306701.71,'yhuka')

statement ok
INSERT INTO tab0 VALUES(224,790039,364013.14,'inebj',183319,832000.92,'bjdxb')

statement ok
INSERT INTO tab0 VALUES(225,235809,349212.10,'blckg',127899,347290.46,'uidwb')

statement ok
INSERT INTO tab0 VALUES(226,425292,726806.51,'bhwic',145477,657928.7,'ksdwh')

statement ok
INSERT INTO tab0 VALUES(227,449096,506286.50,'lahtx',956451,883666.55,'ckzbh')

statement ok
INSERT INTO tab0 VALUES(228,688812,823974.82,'ncqwh',634857,83770.88,'ldpij')

statement ok
INSERT INTO tab0 VALUES(229,942108,568237.96,'iwxcb',733245,881896.34,'deplk')

statement ok
INSERT INTO tab0 VALUES(230,547637,4364.28,'jhtfu',407623,91217.64,'mwaak')

statement ok
INSERT INTO tab0 VALUES(231,510040,399597.13,'bkxom',542541,339263.7,'hmtxa')

statement ok
INSERT INTO tab0 VALUES(232,625030,648132.98,'ohzee',876098,693145.58,'djlcj')

statement ok
INSERT INTO tab0 VALUES(233,604309,896118.56,'efxuq',124816,284362.93,'jguvk')

statement ok
INSERT INTO tab0 VALUES(234,200592,166656.96,'furbx',108856,933837.81,'ielzx')

statement ok
INSERT INTO tab0 VALUES(235,332580,984771.74,'nazsw',876800,776977.97,'jrmws')

statement ok
INSERT INTO tab0 VALUES(236,210052,2532.12,'xospc',830780,888671.35,'fzdqp')

statement ok
INSERT INTO tab0 VALUES(237,458770,623840.4,'ersuf',851470,908203.18,'qaheu')

statement ok
INSERT INTO tab0 VALUES(238,245483,629638.31,'jokvt',422973,664367.13,'gqejr')

statement ok
INSERT INTO tab0 VALUES(239,403016,802795.73,'pghun',758026,800354.43,'usbfi')

statement ok
INSERT INTO tab0 VALUES(240,555175,553131.24,'qxsho',922790,398834.99,'eftyf')

statement ok
INSERT INTO tab0 VALUES(241,241760,542419.1,'mxjxk',961975,606964.52,'sjgat')

statement ok
INSERT INTO tab0 VALUES(242,43640,309387.58,'bwbxb',23803,261291.67,'avnlb')

statement ok
INSERT INTO tab0 VALUES(243,707672,894683.97,'tzfti',485046,512847.14,'ntwwi')

statement ok
INSERT INTO tab0 VALUES(244,271728,466003.85,'fwmzo',75927,452148.82,'cxtmu')

statement ok
INSERT INTO tab0 VALUES(245,189666,942871.61,'szmjk',5218,734100.90,'rvima')

statement ok
INSERT INTO tab0 VALUES(246,456420,621887.52,'znkfe',85205,203125.0,'zxeyv')

statement ok
INSERT INTO tab0 VALUES(247,732910,801483.83,'vpnfq',856689,518035.30,'yptcr')

statement ok
INSERT INTO tab0 VALUES(248,471038,407135.94,'pmytr',714019,777160.66,'olegj')

statement ok
INSERT INTO tab0 VALUES(249,38787,616241.46,'ypdau',29998,143188.75,'hhreu')

statement ok
INSERT INTO tab0 VALUES(250,845123,483154.38,'lspdu',280975,468414.18,'yjmck')

statement ok
INSERT INTO tab0 VALUES(251,464996,564178.20,'eapdk',171813,919403.59,'ajetu')

statement ok
INSERT INTO tab0 VALUES(252,764465,542541.2,'ignhx',760894,602325.82,'oqmrp')

statement ok
INSERT INTO tab0 VALUES(253,25482,853515.68,'wxvdu',585144,187744.2,'shweu')

statement ok
INSERT INTO tab0 VALUES(254,71075,309204.92,'ehjpg',784942,535614.77,'eidpo')

statement ok
INSERT INTO tab0 VALUES(255,390319,723785.45,'rpfca',229217,320465.19,'euzgs')

statement ok
INSERT INTO tab0 VALUES(256,263275,538269.8,'jegtu',640411,656219.11,'tttun')

statement ok
INSERT INTO tab0 VALUES(257,886016,445709.92,'nnrlz',719512,721221.14,'osccg')

statement ok
INSERT INTO tab0 VALUES(258,495635,16082.39,'kmwzh',270935,383300.84,'njkqq')

statement ok
INSERT INTO tab0 VALUES(259,495208,321319.45,'rhsci',327728,824768.81,'ibnjw')

statement ok
INSERT INTO tab0 VALUES(260,578887,560302.64,'fumui',276367,167327.85,'csmzt')

statement ok
INSERT INTO tab0 VALUES(261,856781,683868.28,'pphho',981872,97198.6,'cazav')

statement ok
INSERT INTO tab0 VALUES(262,980072,19775.54,'xavff',912811,489990.95,'hoban')

statement ok
INSERT INTO tab0 VALUES(263,265930,897827.58,'ckxsv',266174,35797.63,'xxsme')

statement ok
INSERT INTO tab0 VALUES(264,822540,274658.70,'wdepb',92590,864196.86,'fuqhk')

statement ok
INSERT INTO tab0 VALUES(265,674072,358947.41,'eurle',421112,169158.20,'zfpot')

statement ok
INSERT INTO tab0 VALUES(266,885772,236297.62,'wgkst',384368,834136.18,'gmiwn')

statement ok
INSERT INTO tab0 VALUES(267,688873,494262.73,'gxdyi',343414,57067.34,'wnzle')

statement ok
INSERT INTO tab0 VALUES(268,605590,847351.74,'vrvuz',12939,975280.44,'dvtez')

statement ok
INSERT INTO tab0 VALUES(269,574218,762023.42,'xfkdy',586059,290618.52,'ksruu')

statement ok
INSERT INTO tab0 VALUES(270,74035,81695.39,'bxijf',859436,894317.7,'tgbzm')

statement ok
INSERT INTO tab0 VALUES(271,250335,651702.26,'aefih',358245,492095.13,'qqdou')

statement ok
INSERT INTO tab0 VALUES(272,39398,944427.79,'cmjnr',461181,229156.41,'kewoq')

statement ok
INSERT INTO tab0 VALUES(273,293579,684082.94,'wmqfo',525482,315093.45,'alhhc')

statement ok
INSERT INTO tab0 VALUES(274,906219,471954.9,'tfvpk',11840,649017.70,'pjkot')

statement ok
INSERT INTO tab0 VALUES(275,936645,411163.6,'vblxp',609497,444427.68,'dkptm')

statement ok
INSERT INTO tab0 VALUES(276,735260,731872.33,'eafmd',361206,854309.9,'cqlzy')

statement ok
INSERT INTO tab0 VALUES(277,68450,416168.11,'rvwyd',788269,596130.93,'aycek')

statement ok
INSERT INTO tab0 VALUES(278,243591,823089.47,'rzoin',15441,576751.64,'bzehd')

statement ok
INSERT INTO tab0 VALUES(279,234161,313598.50,'mzrfq',896026,517547.20,'uphhf')

statement ok
INSERT INTO tab0 VALUES(280,804504,875701.38,'ajivx',136840,579284.29,'uomjz')

statement ok
INSERT INTO tab0 VALUES(281,635162,749237.54,'mvecj',423217,987214.40,'bcfby')

statement ok
INSERT INTO tab0 VALUES(282,447540,51116.80,'bmryk',544006,656066.93,'yrrlz')

statement ok
INSERT INTO tab0 VALUES(283,129150,400085.46,'jvfhi',516601,814971.36,'oinal')

statement ok
INSERT INTO tab0 VALUES(284,858489,541931.42,'dzfez',711853,632537.33,'muoej')

statement ok
INSERT INTO tab0 VALUES(285,230041,974365.37,'xqdyj',979156,841857.80,'jjhaj')

statement ok
INSERT INTO tab0 VALUES(286,379394,572052.82,'rmzjh',771453,365417.16,'pmore')

statement ok
INSERT INTO tab0 VALUES(287,108001,211608.31,'iawqb',270111,940216.36,'wkfid')

statement ok
INSERT INTO tab0 VALUES(288,8514,396606.48,'nxssw',510131,742645.2,'upqke')

statement ok
INSERT INTO tab0 VALUES(289,589447,882568.22,'bxvhu',504943,13610.57,'qtlrz')

statement ok
INSERT INTO tab0 VALUES(290,400421,301940.78,'tfpzz',371520,683380.38,'vaehz')

statement ok
INSERT INTO tab0 VALUES(291,157043,789184.93,'ukzis',455352,996826.88,'pztbu')

statement ok
INSERT INTO tab0 VALUES(292,865905,605712.4,'rqidr',455474,138092.67,'twfoy')

statement ok
INSERT INTO tab0 VALUES(293,949676,764801.21,'ouvlu',549346,855926.65,'zrjbk')

statement ok
INSERT INTO tab0 VALUES(294,372009,656768.44,'zngst',518066,88470.17,'wigyg')

statement ok
INSERT INTO tab0 VALUES(295,762542,673858.71,'plkws',871185,588256.12,'gtaoi')

statement ok
INSERT INTO tab0 VALUES(296,541992,835266.11,'pgbnw',971710,547424.10,'wxiov')

statement ok
INSERT INTO tab0 VALUES(297,47058,412139.98,'nxgda',161285,222381.47,'dccvx')

statement ok
INSERT INTO tab0 VALUES(298,655456,552551.5,'socyj',884948,559143.57,'qbbwj')

statement ok
INSERT INTO tab0 VALUES(299,910888,906616.51,'dykhz',816375,818115.77,'sxkqg')

statement ok
INSERT INTO tab0 VALUES(300,648132,251281.19,'ufgpl',982666,199096.62,'hnnwk')

statement ok
INSERT INTO tab0 VALUES(301,117919,115570.66,'okorq',889495,466461.98,'hmicf')

statement ok
INSERT INTO tab0 VALUES(302,112091,405334.35,'pexqc',645965,573974.16,'ifivd')

statement ok
INSERT INTO tab0 VALUES(303,88378,28472.71,'fiwdw',89813,289825.1,'lfurl')

statement ok
INSERT INTO tab0 VALUES(304,295623,519805.28,'foxna',912200,821685.5,'ncsms')

statement ok
INSERT INTO tab0 VALUES(305,898620,666107.86,'uxyvh',782836,441711.62,'btfjm')

statement ok
INSERT INTO tab0 VALUES(306,103240,131073.61,'yquds',474975,111450.1,'vkjzx')

statement ok
INSERT INTO tab0 VALUES(307,281341,80444.19,'gnalh',990295,106933.53,'ivonm')

statement ok
INSERT INTO tab0 VALUES(308,95794,806823.89,'kvmwn',684112,643676.70,'plmwk')

statement ok
INSERT INTO tab0 VALUES(309,625457,354766.72,'wpxxc',390167,501617.33,'sjjvl')

statement ok
INSERT INTO tab0 VALUES(310,490264,145843.57,'mrnkn',545745,650085.67,'kswcn')

statement ok
INSERT INTO tab0 VALUES(311,976104,603576.33,'dwusr',316680,872985.53,'wmpmf')

statement ok
INSERT INTO tab0 VALUES(312,159973,778350.1,'izxxo',722229,393615.39,'dwvzn')

statement ok
INSERT INTO tab0 VALUES(313,34759,972595.86,'wcnst',760284,499694.54,'wixaj')

statement ok
INSERT INTO tab0 VALUES(314,634460,365661.48,'kpgvg',532165,168426.22,'xsdjh')

statement ok
INSERT INTO tab0 VALUES(315,159027,638824.1,'ehlbx',367736,691467.69,'yjhke')

statement ok
INSERT INTO tab0 VALUES(316,99487,600402.15,'mpqfc',950408,299957.43,'dffir')

statement ok
INSERT INTO tab0 VALUES(317,362854,810577.41,'kojlk',442016,789459.20,'sbmbw')

statement ok
INSERT INTO tab0 VALUES(318,397155,206481.10,'ndsig',608032,144958.20,'pnync')

statement ok
INSERT INTO tab0 VALUES(319,316406,727294.59,'geuyj',942352,165924.20,'aensi')

statement ok
INSERT INTO tab0 VALUES(320,25695,939025.32,'vqpzr',792419,91278.63,'fvswy')

statement ok
INSERT INTO tab0 VALUES(321,346099,659729.99,'rqoyr',484222,224426.74,'ynfng')

statement ok
INSERT INTO tab0 VALUES(322,139678,584381.69,'apbhf',447174,558197.70,'hqntg')

statement ok
INSERT INTO tab0 VALUES(323,434570,909912.96,'ulekz',339324,399810.76,'zdsdc')

statement ok
INSERT INTO tab0 VALUES(324,549896,960205.0,'yrgwj',172149,996063.32,'jnvax')

statement ok
INSERT INTO tab0 VALUES(325,220794,811065.74,'fkpnt',435699,158142.11,'tetoe')

statement ok
INSERT INTO tab0 VALUES(326,723388,915344.98,'sraql',223449,886657.28,'hgqvo')

statement ok
INSERT INTO tab0 VALUES(327,999877,727722.50,'qlkzd',357513,996704.54,'hyrdm')

statement ok
INSERT INTO tab0 VALUES(328,783447,329956.22,'trozp',513427,742858.30,'eqnvr')

statement ok
INSERT INTO tab0 VALUES(329,723266,55633.29,'dpqxg',345275,444091.74,'vyfsw')

statement ok
INSERT INTO tab0 VALUES(330,509582,115386.23,'usttt',610656,108856.99,'kvozk')

statement ok
INSERT INTO tab0 VALUES(331,998626,221771.8,'dbvst',295684,60089.25,'wuvmx')

statement ok
INSERT INTO tab0 VALUES(332,337615,214294.45,'ueycm',740020,560119.89,'rzjsv')

statement ok
INSERT INTO tab0 VALUES(333,89843,684417.75,'dhejh',761779,435791.57,'hihba')

statement ok
INSERT INTO tab0 VALUES(334,359588,600555.20,'zmapj',782623,703338.41,'ynbwq')

statement ok
INSERT INTO tab0 VALUES(335,917144,933044.7,'dtgef',952728,193481.7,'ekbnj')

statement ok
INSERT INTO tab0 VALUES(336,323791,279266.72,'afkgn',275817,176422.90,'myhrl')

statement ok
INSERT INTO tab0 VALUES(337,56884,488433.75,'hditp',734039,986785.4,'xgbhx')

statement ok
INSERT INTO tab0 VALUES(338,634765,286804.14,'peznb',413177,648590.59,'txito')

statement ok
INSERT INTO tab0 VALUES(339,741760,902557.37,'biaik',627441,500427.69,'datdi')

statement ok
INSERT INTO tab0 VALUES(340,353271,690856.52,'yhhet',44616,820251.65,'pgxec')

statement ok
INSERT INTO tab0 VALUES(341,860687,758697.42,'fiqih',810913,450531.10,'uedke')

statement ok
INSERT INTO tab0 VALUES(342,196380,590209.80,'ipild',676177,423126.11,'cafja')

statement ok
INSERT INTO tab0 VALUES(343,958801,671356.33,'tgxst',118682,584411.29,'dgurt')

statement ok
INSERT INTO tab0 VALUES(344,537384,115081.84,'okqzr',470245,220153.95,'pidex')

statement ok
INSERT INTO tab0 VALUES(345,237579,286254.40,'alewa',41198,680603.18,'rasab')

statement ok
INSERT INTO tab0 VALUES(346,405822,426788.42,'lbhvk',245422,5493.2,'tmywi')

statement ok
INSERT INTO tab0 VALUES(347,554626,280426.85,'pjhle',725219,548950.58,'djoyb')

statement ok
INSERT INTO tab0 VALUES(348,487487,717956.21,'icwjh',476531,604583.11,'nzndm')

statement ok
INSERT INTO tab0 VALUES(349,423889,362091.80,'jropy',973724,30487.22,'rikgh')

statement ok
INSERT INTO tab0 VALUES(350,124389,212493.77,'shnnb',294738,874176.90,'cjgbj')

statement ok
INSERT INTO tab0 VALUES(351,15533,270782.29,'lcyyz',245941,997558.73,'pcyhg')

statement ok
INSERT INTO tab0 VALUES(352,314880,165527.61,'ikxme',487335,702117.96,'znbbv')

statement ok
INSERT INTO tab0 VALUES(353,155975,777221.25,'iqvks',657348,353729.66,'ozjsc')

statement ok
INSERT INTO tab0 VALUES(354,713439,863403.10,'hnfyy',497955,7690.80,'xgkcm')

statement ok
INSERT INTO tab0 VALUES(355,327850,683441.53,'rifie',979644,33782.44,'koipu')

statement ok
INSERT INTO tab0 VALUES(356,630889,623748.54,'zvfyi',426452,741241.81,'ythkq')

statement ok
INSERT INTO tab0 VALUES(357,670135,822692.88,'nmonl',640869,3814.44,'lmemc')

statement ok
INSERT INTO tab0 VALUES(358,34240,795501.15,'apdag',28930,884552.29,'mffsl')

statement ok
INSERT INTO tab0 VALUES(359,977935,59448.96,'dlxcd',725189,261108.90,'aoqfq')

statement ok
INSERT INTO tab0 VALUES(360,546844,758728.2,'hjtzi',717712,450500.46,'bbfdx')

statement ok
INSERT INTO tab0 VALUES(361,702697,289459.32,'cvvru',973114,834228.99,'atadq')

statement ok
INSERT INTO tab0 VALUES(362,448181,924804.18,'bskdw',561462,483276.44,'pwwer')

statement ok
INSERT INTO tab0 VALUES(363,952087,439758.44,'gikhs',781372,783050.79,'jfeyf')

statement ok
INSERT INTO tab0 VALUES(364,674073,736389.54,'unyfc',284973,58380.24,'ihitg')

statement ok
INSERT INTO tab0 VALUES(365,489990,468597.69,'rwfgy',202911,198577.27,'mgmth')

statement ok
INSERT INTO tab0 VALUES(366,816558,667327.94,'fstgz',269378,282409.80,'qfedy')

statement ok
INSERT INTO tab0 VALUES(367,736633,365478.35,'vkllj',946990,203126.31,'whwdo')

statement ok
INSERT INTO tab0 VALUES(368,123931,222808.11,'ljttg',552001,293365.96,'hrqeu')

statement ok
INSERT INTO tab0 VALUES(369,768371,151092.62,'jetzo',379119,950286.71,'nytzk')

statement ok
INSERT INTO tab0 VALUES(370,500732,939117.68,'tuksk',826507,260437.45,'iwkwq')

statement ok
INSERT INTO tab0 VALUES(371,317901,877532.58,'gojoy',520965,624877.15,'mydrb')

statement ok
INSERT INTO tab0 VALUES(372,507720,383941.22,'skqju',442687,384063.93,'bdrwc')

statement ok
INSERT INTO tab0 VALUES(373,774139,627990.24,'tzbes',50506,442932.24,'hglxp')

statement ok
INSERT INTO tab0 VALUES(374,361999,156158.16,'italk',406707,895874.95,'bygco')

statement ok
INSERT INTO tab0 VALUES(375,182220,516967.50,'kdbfw',302032,651794.49,'pyuwt')

statement ok
INSERT INTO tab0 VALUES(376,936798,885864.87,'rpncf',380859,58898.97,'ezkwg')

statement ok
INSERT INTO tab0 VALUES(377,243621,690246.17,'aweod',265960,529998.31,'mescc')

statement ok
INSERT INTO tab0 VALUES(378,761688,234466.62,'gwuwu',683746,167266.36,'oaazb')

statement ok
INSERT INTO tab0 VALUES(379,315948,324829.98,'rcukb',589080,387390.2,'ekhpb')

statement ok
INSERT INTO tab0 VALUES(380,22430,894592.58,'towro',290283,546447.39,'qakpv')

statement ok
INSERT INTO tab0 VALUES(381,413146,628936.54,'sysly',574310,565002.86,'hedrr')

statement ok
INSERT INTO tab0 VALUES(382,561126,590087.83,'fwlxt',831512,553100.24,'edmiz')

statement ok
INSERT INTO tab0 VALUES(383,205383,842103.40,'wtjsx',180877,435180.94,'rdlex')

statement ok
INSERT INTO tab0 VALUES(384,876007,76080.34,'yfpgj',594848,575164.1,'cpqbx')

statement ok
INSERT INTO tab0 VALUES(385,19073,235076.98,'ayrqu',24322,401458.32,'kexfm')

statement ok
INSERT INTO tab0 VALUES(386,121643,139007.2,'nbdxe',523834,31890.67,'swwgr')

statement ok
INSERT INTO tab0 VALUES(387,836853,109832.64,'kcddh',376342,898681.93,'ygslv')

statement ok
INSERT INTO tab0 VALUES(388,108825,596405.66,'udfmr',218353,373657.14,'nnqsd')

statement ok
INSERT INTO tab0 VALUES(389,297698,799621.62,'oyskv',164886,392913.64,'zppvg')

statement ok
INSERT INTO tab0 VALUES(390,304595,297241.96,'xfpwf',934478,82153.21,'liyoy')

statement ok
INSERT INTO tab0 VALUES(391,696716,668975.8,'elyfq',974212,381439.19,'mnxut')

statement ok
INSERT INTO tab0 VALUES(392,832214,121551.53,'gipmy',584625,670349.59,'oejmo')

statement ok
INSERT INTO tab0 VALUES(393,985351,113647.8,'jqwos',44799,392852.25,'smlce')

statement ok
INSERT INTO tab0 VALUES(394,471282,980804.89,'poadt',737335,682434.91,'fczmd')

statement ok
INSERT INTO tab0 VALUES(395,771240,560607.59,'msbyv',273376,986938.39,'fdmad')

statement ok
INSERT INTO tab0 VALUES(396,657531,817565.45,'vhgyh',617492,693817.69,'eikxt')

statement ok
INSERT INTO tab0 VALUES(397,318359,468139.49,'dcrip',212890,754791.9,'ugzda')

statement ok
INSERT INTO tab0 VALUES(398,483032,605713.56,'hxcpa',106201,311187.35,'igtqc')

statement ok
INSERT INTO tab0 VALUES(399,546813,325714.55,'gijyh',72631,318725.74,'nthmy')

statement ok
INSERT INTO tab0 VALUES(400,696075,350402.44,'nbbbe',740814,172546.24,'zjsxv')

statement ok
INSERT INTO tab0 VALUES(401,33081,654113.47,'zagnc',718017,332275.61,'wvjny')

statement ok
INSERT INTO tab0 VALUES(402,701171,88012.24,'imbsu',714935,946990.59,'pjmje')

statement ok
INSERT INTO tab0 VALUES(403,9765,5310.84,'vddex',670806,480255.92,'kqsbr')

statement ok
INSERT INTO tab0 VALUES(404,559173,886138.99,'vdnlq',878387,335052.55,'abuzj')

statement ok
INSERT INTO tab0 VALUES(405,365783,962585.16,'moekj',108947,478759.75,'drhjr')

statement ok
INSERT INTO tab0 VALUES(406,987060,843688.66,'kcnki',737304,68359.19,'hmyhf')

statement ok
INSERT INTO tab0 VALUES(407,646362,140441.83,'bnfeb',866729,75103.12,'hmqbg')

statement ok
INSERT INTO tab0 VALUES(408,358154,90759.10,'sppgf',454040,909851.45,'vuscl')

statement ok
INSERT INTO tab0 VALUES(409,52886,184600.17,'uimud',434570,47821.93,'iuvgl')

statement ok
INSERT INTO tab0 VALUES(410,701995,788757.9,'sztak',847198,653747.22,'ggksn')

statement ok
INSERT INTO tab0 VALUES(411,442993,772094.40,'ikxaq',959259,206756.2,'bmljd')

statement ok
INSERT INTO tab0 VALUES(412,704376,130310.28,'rwrdx',391632,125488.25,'njxtr')

statement ok
INSERT INTO tab0 VALUES(413,330627,611145.64,'oluzl',243713,392974.11,'opqgy')

statement ok
INSERT INTO tab0 VALUES(414,707305,339263.27,'cylmj',218414,181732.24,'usqhy')

statement ok
INSERT INTO tab0 VALUES(415,885955,441284.93,'oeafc',747192,478760.83,'eiagi')

statement ok
INSERT INTO tab0 VALUES(416,709106,670745.53,'tbthg',114929,710449.77,'pclvd')

statement ok
INSERT INTO tab0 VALUES(417,935394,33233.20,'vpcsa',585145,367675.72,'navak')

statement ok
INSERT INTO tab0 VALUES(418,364318,411164.45,'tftgx',524780,630798.32,'rlwhv')

statement ok
INSERT INTO tab0 VALUES(419,961578,189025.29,'btyui',529357,994567.23,'oftqg')

statement ok
INSERT INTO tab0 VALUES(420,983734,878143.34,'kpfjh',547821,893249.30,'cwvxk')

statement ok
INSERT INTO tab0 VALUES(421,103454,741882.97,'gxbgz',7751,325500.70,'kpbqo')

statement ok
INSERT INTO tab0 VALUES(422,534393,420532.40,'kokei',940155,479461.2,'gowka')

statement ok
INSERT INTO tab0 VALUES(423,156219,556335.87,'rllhs',104583,357757.40,'qxoww')

statement ok
INSERT INTO tab0 VALUES(424,639587,418487.73,'qocmo',114105,402404.68,'ryawo')

statement ok
INSERT INTO tab0 VALUES(425,571228,528137.57,'yzslz',560333,119934.50,'yemqo')

statement ok
INSERT INTO tab0 VALUES(426,578826,283386.35,'hgprk',138336,706268.41,'hpxwv')

statement ok
INSERT INTO tab0 VALUES(427,456146,584259.53,'wgwtd',771728,671813.5,'jotsr')

statement ok
INSERT INTO tab0 VALUES(428,287933,457824.19,'xluja',737640,466462.22,'hfpgg')

statement ok
INSERT INTO tab0 VALUES(429,574951,682983.14,'obpoe',791717,104492.4,'fisfd')

statement ok
INSERT INTO tab0 VALUES(430,358947,415679.7,'fcbrk',293151,789672.5,'cqtjc')

statement ok
INSERT INTO tab0 VALUES(431,347747,813781.66,'kmara',329589,540252.35,'dxhpp')

statement ok
INSERT INTO tab0 VALUES(432,40161,662109.72,'hhgch',842224,813903.72,'nynzm')

statement ok
INSERT INTO tab0 VALUES(433,851013,997436.30,'esvif',750762,132690.77,'zxwwn')

statement ok
INSERT INTO tab0 VALUES(434,236114,733489.80,'khxpd',78430,708251.0,'nhqef')

statement ok
INSERT INTO tab0 VALUES(435,817352,285949.14,'tbgdg',76995,66619.99,'ydmid')

statement ok
INSERT INTO tab0 VALUES(436,507568,197418.84,'eoykh',351684,673248.51,'lainx')

statement ok
INSERT INTO tab0 VALUES(437,635681,762542.18,'kczcg',986267,558074.63,'klqtl')

statement ok
INSERT INTO tab0 VALUES(438,71594,652801.29,'orxhw',668029,940521.83,'wqizy')

statement ok
INSERT INTO tab0 VALUES(439,351226,541717.33,'skiqg',812774,854400.18,'eyhhg')

statement ok
INSERT INTO tab0 VALUES(440,801483,729736.53,'qiukq',689849,773010.40,'qtzxo')

statement ok
INSERT INTO tab0 VALUES(441,665344,769256.40,'kvcpy',547058,234130.5,'evclc')

statement ok
INSERT INTO tab0 VALUES(442,226776,89630.81,'ymffi',735748,464935.60,'xfcar')

statement ok
INSERT INTO tab0 VALUES(443,935760,622161.11,'rjqfx',835784,7110.58,'tnbgj')

statement ok
INSERT INTO tab0 VALUES(444,533264,425109.30,'ecgti',780548,341735.71,'czbnb')

statement ok
INSERT INTO tab0 VALUES(445,176330,308654.10,'ucuek',981964,514373.99,'lowbe')

statement ok
INSERT INTO tab0 VALUES(446,562957,460021.9,'imohv',455413,760070.89,'yeszg')

statement ok
INSERT INTO tab0 VALUES(447,57250,68267.88,'mizlp',944824,128265.41,'dqrqm')

statement ok
INSERT INTO tab0 VALUES(448,814208,949493.16,'sxgpv',47637,107910.24,'lankm')

statement ok
INSERT INTO tab0 VALUES(449,904907,171722.89,'rncni',339813,252349.87,'xpeex')

statement ok
INSERT INTO tab0 VALUES(450,441497,679931.40,'xxcwd',500854,804412.74,'vakdy')

statement ok
INSERT INTO tab0 VALUES(451,702026,921051.49,'ogqhg',438720,321411.33,'flnga')

statement ok
INSERT INTO tab0 VALUES(452,255645,468963.60,'ufhrg',414916,300048.31,'rsxal')

statement ok
INSERT INTO tab0 VALUES(453,87463,649505.91,'qgpaw',169464,801513.64,'tjowa')

statement ok
INSERT INTO tab0 VALUES(454,723693,165435.47,'mppxo',45928,76477.74,'vwzer')

statement ok
INSERT INTO tab0 VALUES(455,356414,721557.33,'slmjh',116302,190032.56,'mrnlz')

statement ok
INSERT INTO tab0 VALUES(456,968902,649506.63,'kcgac',306213,646667.74,'jjeha')

statement ok
INSERT INTO tab0 VALUES(457,460296,532958.79,'vyjkp',519714,15441.74,'rvfts')

statement ok
INSERT INTO tab0 VALUES(458,770843,832550.58,'gueuu',764404,554809.93,'thqis')

statement ok
INSERT INTO tab0 VALUES(459,6774,510772.27,'jwvqo',276428,837646.76,'vnzbv')

statement ok
INSERT INTO tab0 VALUES(460,565338,657135.75,'aaqkj',645385,376312.84,'pwxst')

statement ok
INSERT INTO tab0 VALUES(461,259765,113159.64,'xrzyt',939392,247619.10,'vmtys')

statement ok
INSERT INTO tab0 VALUES(462,444366,97229.46,'zfolf',830200,717864.89,'xkeiy')

statement ok
INSERT INTO tab0 VALUES(463,139404,829711.69,'jxlqn',717895,867767.14,'srwmn')

statement ok
INSERT INTO tab0 VALUES(464,156220,157897.96,'rajyp',856201,217468.43,'xmbhu')

statement ok
INSERT INTO tab0 VALUES(465,222137,181091.11,'xemlz',477355,351593.16,'xfhaf')

statement ok
INSERT INTO tab0 VALUES(466,105499,875549.37,'xfzgn',917053,544250.68,'dsvir')

statement ok
INSERT INTO tab0 VALUES(467,740631,719390.48,'bktla',739532,383911.38,'ajmmm')

statement ok
INSERT INTO tab0 VALUES(468,352935,317779.76,'vqxgu',862548,398651.81,'jbems')

statement ok
INSERT INTO tab0 VALUES(469,583801,27801.30,'nnmej',682403,680847.88,'bnmcx')

statement ok
INSERT INTO tab0 VALUES(470,615631,583496.6,'umcda',198822,512390.87,'sjkdu')

statement ok
INSERT INTO tab0 VALUES(471,296813,720825.99,'jumpm',140167,989624.67,'ggums')

statement ok
INSERT INTO tab0 VALUES(472,266815,802796.15,'mweon',88226,648376.82,'nxgfo')

statement ok
INSERT INTO tab0 VALUES(473,81054,444274.86,'vkbyp',603363,88897.67,'bimsb')

statement ok
INSERT INTO tab0 VALUES(474,336059,137084.79,'whdnm',349365,600830.52,'lycxo')

statement ok
INSERT INTO tab0 VALUES(475,794250,875061.12,'pyabu',218658,788391.70,'gqdhs')

statement ok
INSERT INTO tab0 VALUES(476,509124,778961.65,'egqmu',457092,195190.75,'lxuzz')

statement ok
INSERT INTO tab0 VALUES(477,950256,721496.90,'mytaw',789062,929260.49,'zdxai')

statement ok
INSERT INTO tab0 VALUES(478,128112,952331.30,'wmthe',542480,288116.19,'rmslw')

statement ok
INSERT INTO tab0 VALUES(479,719268,723083.24,'rgdkj',773803,383758.66,'nckgj')

statement ok
INSERT INTO tab0 VALUES(480,191253,912322.24,'vufed',392944,767578.42,'qjuta')

statement ok
INSERT INTO tab0 VALUES(481,927673,650573.6,'ouqet',288360,55450.77,'owwpz')

statement ok
INSERT INTO tab0 VALUES(482,353118,945281.85,'bgewx',452026,552734.94,'donwa')

statement ok
INSERT INTO tab0 VALUES(483,58197,305938.22,'xqfrd',104431,879180.25,'zyafe')

statement ok
INSERT INTO tab0 VALUES(484,924499,368865.43,'yzkio',819610,594055.15,'fdvah')

statement ok
INSERT INTO tab0 VALUES(485,249694,522430.47,'sbisl',650024,821014.45,'zzbos')

statement ok
INSERT INTO tab0 VALUES(486,872436,531921.19,'djcdx',251770,873199.35,'ehgyx')

statement ok
INSERT INTO tab0 VALUES(487,297363,164581.45,'gmakl',9368,878234.64,'bvunc')

statement ok
INSERT INTO tab0 VALUES(488,820190,814605.23,'owcco',160919,403137.76,'smvtv')

statement ok
INSERT INTO tab0 VALUES(489,652618,128143.74,'bkvkp',922943,79437.97,'xlols')

statement ok
INSERT INTO tab0 VALUES(490,47363,628265.57,'kdsnz',615600,228057.48,'qgdxv')

statement ok
INSERT INTO tab0 VALUES(491,423126,340087.80,'zqwqe',787475,484405.53,'qzeap')

statement ok
INSERT INTO tab0 VALUES(492,489685,415557.13,'ezucg',340698,423371.55,'ehiji')

statement ok
INSERT INTO tab0 VALUES(493,372802,758698.0,'eatni',655944,184234.28,'osaks')

statement ok
INSERT INTO tab0 VALUES(494,739227,650360.74,'pisyj',717315,95794.89,'unamp')

statement ok
INSERT INTO tab0 VALUES(495,921783,373443.64,'aoqwv',237548,301239.11,'fcacq')

statement ok
INSERT INTO tab0 VALUES(496,44281,837768.13,'tiknc',782806,383239.34,'exjxt')

statement ok
INSERT INTO tab0 VALUES(497,146514,205108.89,'flfwi',897796,988952.81,'ospax')

statement ok
INSERT INTO tab0 VALUES(498,309356,514190.95,'yehux',230743,454925.65,'kqcvq')

statement ok
INSERT INTO tab0 VALUES(499,779663,305664.86,'tcqdf',658416,432189.7,'sjsns')

statement ok
INSERT INTO tab0 VALUES(500,95306,247222.75,'tjkad',411041,511260.45,'uckvu')

statement ok
INSERT INTO tab0 VALUES(501,210144,758392.53,'vyrss',197387,847045.49,'dxwja')

statement ok
INSERT INTO tab0 VALUES(502,619110,635772.97,'dmezv',329742,783966.31,'wtdtr')

statement ok
INSERT INTO tab0 VALUES(503,483123,677795.82,'zqqat',848907,480834.59,'nmdrs')

statement ok
INSERT INTO tab0 VALUES(504,754089,309936.97,'gfstw',649230,535949.69,'ngnbm')

statement ok
INSERT INTO tab0 VALUES(505,299987,209594.55,'bbiwd',603515,612091.78,'yhbbh')

statement ok
INSERT INTO tab0 VALUES(506,29785,931121.3,'nmnxx',688110,61431.95,'yjkld')

statement ok
INSERT INTO tab0 VALUES(507,18463,530822.42,'edamj',107879,550659.37,'psrle')

statement ok
INSERT INTO tab0 VALUES(508,631988,191925.31,'riujj',421234,685852.38,'mddck')

statement ok
INSERT INTO tab0 VALUES(509,652404,849700.7,'pzqou',665008,637573.60,'dhsek')

statement ok
INSERT INTO tab0 VALUES(510,402709,816253.90,'uybmk',479675,765869.13,'xqqov')

statement ok
INSERT INTO tab0 VALUES(511,872009,405761.2,'cxpdl',234130,245178.60,'ksgcz')

statement ok
INSERT INTO tab0 VALUES(512,840301,559234.77,'bsobc',150817,689453.32,'fdixr')

statement ok
INSERT INTO tab0 VALUES(513,3662,469726.72,'nitqg',430725,777038.41,'mvajp')

statement ok
INSERT INTO tab0 VALUES(514,99243,207214.81,'edzee',378265,875762.92,'qcekb')

statement ok
INSERT INTO tab0 VALUES(515,30090,343627.50,'exqyx',526489,667938.97,'vsfor')

statement ok
INSERT INTO tab0 VALUES(516,990356,577850.83,'xynkd',761871,775268.84,'tcpyw')

statement ok
INSERT INTO tab0 VALUES(517,590148,360687.62,'mhfit',449432,383972.13,'clpro')

statement ok
INSERT INTO tab0 VALUES(518,980651,519989.53,'lwyuk',557739,869628.87,'jvrrs')

statement ok
INSERT INTO tab0 VALUES(519,979034,885437.24,'gmamc',783813,422424.65,'hjlcf')

statement ok
INSERT INTO tab0 VALUES(520,193481,913787.52,'ezpra',678192,671814.74,'qhyfb')

statement ok
INSERT INTO tab0 VALUES(521,148162,313629.41,'omdlx',770019,311859.21,'raorm')

statement ok
INSERT INTO tab0 VALUES(522,408325,670593.31,'ujfvx',691894,726013.6,'ylmpd')

statement ok
INSERT INTO tab0 VALUES(523,705200,72235.11,'tnbtz',304870,612152.36,'uyiqz')

statement ok
INSERT INTO tab0 VALUES(524,61004,733062.33,'ijfls',823638,607635.35,'zowew')

statement ok
INSERT INTO tab0 VALUES(525,914062,619537.22,'kaahw',941314,914307.58,'kapnd')

statement ok
INSERT INTO tab0 VALUES(526,243560,75073.90,'bklcy',954559,923400.4,'rzhwc')

statement ok
INSERT INTO tab0 VALUES(527,694885,445007.50,'llpix',888549,840637.26,'rdtla')

statement ok
INSERT INTO tab0 VALUES(528,704284,701721.26,'ldiwu',622009,311218.47,'hgjvj')

statement ok
INSERT INTO tab0 VALUES(529,624114,69427.66,'cozpg',12084,44738.69,'zkuur')

statement ok
INSERT INTO tab0 VALUES(530,847717,649383.55,'kgvdh',19561,440307.89,'jbjsa')

statement ok
INSERT INTO tab0 VALUES(531,934417,44799.28,'vexfv',833648,211425.6,'ycdlu')

statement ok
INSERT INTO tab0 VALUES(532,734619,985748.81,'ztkrg',997100,11077.43,'rfaod')

statement ok
INSERT INTO tab0 VALUES(533,514709,954345.86,'igorg',531219,56732.48,'oquov')

statement ok
INSERT INTO tab0 VALUES(534,82061,809600.1,'psctg',60761,755249.16,'isnwr')

statement ok
INSERT INTO tab0 VALUES(535,910156,412567.82,'qauyb',939025,328002.95,'aphxe')

statement ok
INSERT INTO tab0 VALUES(536,263366,251159.99,'xhkyq',372833,435729.3,'qstkh')

statement ok
INSERT INTO tab0 VALUES(537,322143,65246.46,'dtxhn',547515,803771.38,'vstlw')

statement ok
INSERT INTO tab0 VALUES(538,307983,471740.53,'xzkjo',751953,846740.92,'ioznl')

statement ok
INSERT INTO tab0 VALUES(539,608367,589385.1,'iyrnp',503448,293884.60,'uvrss')

statement ok
INSERT INTO tab0 VALUES(540,901794,663970.30,'tgskz',672943,813720.59,'hrcvj')

statement ok
INSERT INTO tab0 VALUES(541,282745,693206.58,'efmue',609802,639373.34,'zahol')

statement ok
INSERT INTO tab0 VALUES(542,386810,51757.88,'awmxo',266967,193328.73,'srnld')

statement ok
INSERT INTO tab0 VALUES(543,515441,116241.21,'uihov',325805,712585.22,'sldfj')

statement ok
INSERT INTO tab0 VALUES(544,761291,890228.74,'mrieu',321319,873535.93,'dicum')

statement ok
INSERT INTO tab0 VALUES(545,132873,629211.85,'oflwx',766937,417053.79,'rnnlt')

statement ok
INSERT INTO tab0 VALUES(546,679809,465728.29,'gqmuy',279632,773498.67,'hpjvb')

statement ok
INSERT INTO tab0 VALUES(547,617706,34149.32,'hazbp',704895,687622.49,'tscgo')

statement ok
INSERT INTO tab0 VALUES(548,453155,95916.81,'qarxb',241760,843688.36,'gpgug')

statement ok
INSERT INTO tab0 VALUES(549,108826,164306.38,'yziwv',567718,490356.68,'csdfo')

statement ok
INSERT INTO tab0 VALUES(550,48370,129638.52,'hbexa',963806,65795.29,'imhkd')

statement ok
INSERT INTO tab0 VALUES(551,401428,884155.70,'umoni',439575,822540.60,'gikfh')

statement ok
INSERT INTO tab0 VALUES(552,88714,947052.52,'distj',858093,452697.69,'esots')

statement ok
INSERT INTO tab0 VALUES(553,946929,89447.82,'kbgop',60974,712768.43,'znfmb')

statement ok
INSERT INTO tab0 VALUES(554,853790,959503.82,'kksro',993255,48675.66,'rwpjr')

statement ok
INSERT INTO tab0 VALUES(555,852996,707244.22,'pnkzx',828613,220825.24,'glkvz')

statement ok
INSERT INTO tab0 VALUES(556,279327,609649.36,'odxkt',94146,929107.23,'apnem')

statement ok
INSERT INTO tab0 VALUES(557,883514,695709.28,'ossfj',795532,437805.0,'lkkjz')

statement ok
INSERT INTO tab0 VALUES(558,957397,371368.95,'iltaw',541870,200714.34,'qvzll')

statement ok
INSERT INTO tab0 VALUES(559,458709,44433.28,'qphau',670898,486022.60,'cvboq')

statement ok
INSERT INTO tab0 VALUES(560,136291,749755.33,'vlear',373779,1403.82,'hndzq')

statement ok
INSERT INTO tab0 VALUES(561,654937,774108.40,'omvpu',820220,519012.82,'eiwkm')

statement ok
INSERT INTO tab0 VALUES(562,720520,281188.15,'ilphs',283477,500396.40,'zytxw')

statement ok
INSERT INTO tab0 VALUES(563,204895,936737.74,'gpnpv',265228,721588.37,'uqtfs')

statement ok
INSERT INTO tab0 VALUES(564,270935,533325.95,'muzff',620788,898101.74,'bjzsu')

statement ok
INSERT INTO tab0 VALUES(565,497497,615600.30,'zndbb',683898,309844.84,'ksfsi')

statement ok
INSERT INTO tab0 VALUES(566,4516,105041.18,'ddvli',391845,426239.40,'bhqkt')

statement ok
INSERT INTO tab0 VALUES(567,577911,925170.99,'hxzil',410461,531097.74,'sphcd')

statement ok
INSERT INTO tab0 VALUES(568,794586,626464.21,'megew',259002,347747.83,'wkziz')

statement ok
INSERT INTO tab0 VALUES(569,147521,11260.61,'znuht',435363,663879.48,'topys')

statement ok
INSERT INTO tab0 VALUES(570,170684,758911.30,'zvtxn',540863,956787.41,'qmwfl')

statement ok
INSERT INTO tab0 VALUES(571,564025,50781.89,'ekyfn',405364,18035.39,'uyddk')

statement ok
INSERT INTO tab0 VALUES(572,318572,195098.61,'jdlor',212280,578796.40,'vmsgw')

statement ok
INSERT INTO tab0 VALUES(573,841339,252075.45,'ephrb',623443,934631.70,'lhpcj')

statement ok
INSERT INTO tab0 VALUES(574,80352,658843.24,'qhzno',904327,570495.98,'bohat')

statement ok
INSERT INTO tab0 VALUES(575,649627,854553.83,'smftl',48828,785949.52,'midpm')

statement ok
INSERT INTO tab0 VALUES(576,954254,905303.16,'bqnod',904388,319824.25,'kydnl')

statement ok
INSERT INTO tab0 VALUES(577,315307,129058.45,'rksxp',296997,975555.92,'dxlvm')

statement ok
INSERT INTO tab0 VALUES(578,94848,720826.27,'htttf',156097,245941.20,'dcdbb')

statement ok
INSERT INTO tab0 VALUES(579,821044,377532.68,'haeae',639648,938293.82,'szsjv')

statement ok
INSERT INTO tab0 VALUES(580,312927,923034.36,'dgxti',259216,799316.71,'tqunk')

statement ok
INSERT INTO tab0 VALUES(581,805725,933227.75,'cbqip',4821,140228.9,'aurfu')

statement ok
INSERT INTO tab0 VALUES(582,75531,360870.14,'tzsmu',469940,461639.61,'cgcbd')

statement ok
INSERT INTO tab0 VALUES(583,564544,160675.82,'ulpnb',976684,78643.48,'yqruj')

statement ok
INSERT INTO tab0 VALUES(584,505950,914398.21,'ozojs',700592,745819.60,'jvqht')

statement ok
INSERT INTO tab0 VALUES(585,48919,455627.96,'ngesq',795745,282135.65,'uzmwl')

statement ok
INSERT INTO tab0 VALUES(586,383697,494995.9,'gidda',519744,196044.29,'wnnfk')

statement ok
INSERT INTO tab0 VALUES(587,866516,245056.13,'prwia',358703,310485.18,'blmrq')

statement ok
INSERT INTO tab0 VALUES(588,144592,45318.20,'uixaj',152282,387786.21,'hlhhc')

statement ok
INSERT INTO tab0 VALUES(589,281219,987243.21,'qbvhw',218597,754792.54,'pwnwg')

statement ok
INSERT INTO tab0 VALUES(590,880676,539215.88,'mlspf',479309,927734.79,'qzchq')

statement ok
INSERT INTO tab0 VALUES(591,213256,171661.98,'oasyl',584594,237335.12,'mdzln')

statement ok
INSERT INTO tab0 VALUES(592,340240,981842.36,'wiyxu',38177,453796.37,'dsqmo')

statement ok
INSERT INTO tab0 VALUES(593,238983,319091.13,'oesxy',322204,411712.20,'dkwvj')

statement ok
INSERT INTO tab0 VALUES(594,927825,409576.77,'tsohc',22460,635192.19,'hhdlf')

statement ok
INSERT INTO tab0 VALUES(595,591094,981506.25,'bkojg',953155,962738.98,'fyown')

statement ok
INSERT INTO tab0 VALUES(596,704193,890014.16,'gmbqz',282073,172332.40,'xohhr')

statement ok
INSERT INTO tab0 VALUES(597,158508,742187.84,'wtkvb',655426,606445.56,'pcevn')

statement ok
INSERT INTO tab0 VALUES(598,386413,522064.50,'tulda',323059,796936.5,'cmjlx')

statement ok
INSERT INTO tab0 VALUES(599,486358,215637.32,'yhdfv',263244,90179.96,'pndip')

statement ok
INSERT INTO tab0 VALUES(600,347778,435821.63,'zvgkn',307800,271942.10,'fffup')

statement ok
INSERT INTO tab0 VALUES(601,776123,47576.98,'rjzwv',267059,192474.7,'rwolx')

statement ok
INSERT INTO tab0 VALUES(602,617828,792694.32,'uaons',54901,391510.42,'xccnd')

statement ok
INSERT INTO tab0 VALUES(603,885406,915039.6,'plvmc',813629,723175.74,'qcbrf')

statement ok
INSERT INTO tab0 VALUES(604,882354,785308.25,'mwywl',39184,981079.79,'cpxiw')

statement ok
INSERT INTO tab0 VALUES(605,328155,526245.67,'qfzfk',705963,523315.67,'nesvg')

statement ok
INSERT INTO tab0 VALUES(606,483367,637512.99,'odojl',391815,897369.89,'zhais')

statement ok
INSERT INTO tab0 VALUES(607,274536,620727.86,'wjkrk',403198,465240.51,'sjffj')

statement ok
INSERT INTO tab0 VALUES(608,419219,604431.3,'vqcff',900085,28320.29,'bzjzo')

statement ok
INSERT INTO tab0 VALUES(609,550964,969207.54,'vxntl',20904,452514.79,'vztnt')

statement ok
INSERT INTO tab0 VALUES(610,344390,972503.76,'ilsbz',7629,293090.50,'dpkez')

statement ok
INSERT INTO tab0 VALUES(611,640075,373718.58,'exgvr',330780,419921.96,'uoavl')

statement ok
INSERT INTO tab0 VALUES(612,569702,59265.48,'lqdaw',814300,642150.91,'ffdeh')

statement ok
INSERT INTO tab0 VALUES(613,680847,667480.72,'xqdsc',760772,333526.38,'usgre')

statement ok
INSERT INTO tab0 VALUES(614,62164,213684.39,'uqqnr',76202,57189.83,'rcbss')

statement ok
INSERT INTO tab0 VALUES(615,468383,715057.61,'ilenj',395141,190704.29,'ijhwl')

statement ok
INSERT INTO tab0 VALUES(616,445129,815795.60,'jxamz',205657,551116.47,'cqgwe')

statement ok
INSERT INTO tab0 VALUES(617,454132,412109.82,'zzxxz',974365,19927.87,'cjlur')

statement ok
INSERT INTO tab0 VALUES(618,998077,277069.12,'hboef',271331,168121.94,'lkgfi')

statement ok
INSERT INTO tab0 VALUES(619,745758,685699.82,'txluh',895172,881103.18,'ezmew')

statement ok
INSERT INTO tab0 VALUES(620,656860,40069.88,'bxehn',998016,983673.27,'ubeot')

statement ok
INSERT INTO tab0 VALUES(621,107147,494079.98,'rdkoi',210510,865203.20,'wkwbz')

statement ok
INSERT INTO tab0 VALUES(622,13458,578674.70,'mlfxx',766845,104461.39,'roqiq')

statement ok
INSERT INTO tab0 VALUES(623,958526,826721.59,'grycx',629638,94635.82,'vcmbq')

statement ok
INSERT INTO tab0 VALUES(624,316162,398040.32,'ospob',615142,668395.14,'vvxfc')

statement ok
INSERT INTO tab0 VALUES(625,376251,704406.83,'dssns',518067,722900.82,'wssbh')

statement ok
INSERT INTO tab0 VALUES(626,469573,34545.39,'qbtdn',236572,844696.26,'gdpjz')

statement ok
INSERT INTO tab0 VALUES(627,93017,179138.80,'gpync',897460,934814.90,'ezpkf')

statement ok
INSERT INTO tab0 VALUES(628,34423,55786.45,'ivszp',980926,833770.39,'guzhw')

statement ok
INSERT INTO tab0 VALUES(629,497741,334136.49,'xwkbh',445800,946502.66,'fvqwj')

statement ok
INSERT INTO tab0 VALUES(630,227813,60668.94,'mrxui',854370,867340.9,'lgvze')

statement ok
INSERT INTO tab0 VALUES(631,635559,283905.81,'pdhpg',497375,5187.61,'shuoo')

statement ok
INSERT INTO tab0 VALUES(632,922973,679290.24,'ihlrq',519195,208343.83,'rfktc')

statement ok
INSERT INTO tab0 VALUES(633,207946,174224.59,'dgnyt',42602,389526.16,'qqsbj')

statement ok
INSERT INTO tab0 VALUES(634,649475,573059.60,'iovfd',294006,150939.96,'bmpkp')

statement ok
INSERT INTO tab0 VALUES(635,572509,182098.52,'rdiji',728271,409240.64,'hglie')

statement ok
INSERT INTO tab0 VALUES(636,593078,434600.21,'dogig',153717,20568.77,'czscj')

statement ok
INSERT INTO tab0 VALUES(637,743194,515747.25,'mzrlg',857299,405487.27,'gqptb')

statement ok
INSERT INTO tab0 VALUES(638,595886,987762.13,'vmgkf',729370,173980.44,'kwqja')

statement ok
INSERT INTO tab0 VALUES(639,390167,414703.30,'iawiq',388946,750518.18,'knjcy')

statement ok
INSERT INTO tab0 VALUES(640,156127,987670.35,'srccy',308380,999023.4,'blwgv')

statement ok
INSERT INTO tab0 VALUES(641,839843,149688.11,'bsxkj',938659,847900.41,'vtlop')

statement ok
INSERT INTO tab0 VALUES(642,428375,220733.77,'hskrh',834289,914978.58,'hbhcw')

statement ok
INSERT INTO tab0 VALUES(643,74859,22735.2,'xrfnd',778228,132476.91,'yjasl')

statement ok
INSERT INTO tab0 VALUES(644,223419,504577.18,'nfkrt',906982,372192.95,'rjktz')

statement ok
INSERT INTO tab0 VALUES(645,734191,367095.29,'lpvai',835571,70312.53,'mmwns')

statement ok
INSERT INTO tab0 VALUES(646,8300,688049.28,'laxar',782531,852447.95,'bbfix')

statement ok
INSERT INTO tab0 VALUES(647,112945,547241.6,'jlfne',694946,158691.4,'klgmn')

statement ok
INSERT INTO tab0 VALUES(648,906280,651306.68,'ocdde',373352,868621.30,'mcinz')

statement ok
INSERT INTO tab0 VALUES(649,162567,958923.41,'thldt',596832,926208.8,'xtair')

statement ok
INSERT INTO tab0 VALUES(650,696960,305725.90,'nqzue',247985,964904.62,'lntgm')

statement ok
INSERT INTO tab0 VALUES(651,490722,29205.30,'zheit',437957,932647.24,'qzmhs')

statement ok
INSERT INTO tab0 VALUES(652,816070,593902.37,'jxteh',631317,716766.42,'omdak')

statement ok
INSERT INTO tab0 VALUES(653,361297,216247.61,'rwkat',771270,769104.98,'ianzc')

statement ok
INSERT INTO tab0 VALUES(654,355682,489715.40,'hjixz',404449,730895.15,'ulqpm')

statement ok
INSERT INTO tab0 VALUES(655,694488,9643.12,'rowme',806060,57891.70,'csolz')

statement ok
INSERT INTO tab0 VALUES(656,64086,998321.24,'xrezn',104736,645202.12,'kwwgi')

statement ok
INSERT INTO tab0 VALUES(657,66741,930084.51,'gbtlb',407745,452545.69,'jfmch')

statement ok
INSERT INTO tab0 VALUES(658,345794,156097.3,'zneuy',925781,128906.60,'xmcpf')

statement ok
INSERT INTO tab0 VALUES(659,710662,529571.38,'vesaj',98083,637878.13,'tuwvt')

statement ok
INSERT INTO tab0 VALUES(660,261657,30639.80,'qvwfa',717407,882415.72,'cbari')

statement ok
INSERT INTO tab0 VALUES(661,515197,391387.24,'dybst',55053,329986.13,'fwpvx')

statement ok
INSERT INTO tab0 VALUES(662,528656,720855.52,'itfji',985748,637451.54,'cqyyn')

statement ok
INSERT INTO tab0 VALUES(663,25483,130035.48,'gnmlt',112854,276184.69,'zyhuz')

statement ok
INSERT INTO tab0 VALUES(664,520111,356842.5,'qmtyf',893157,156951.2,'fkpgm')

statement ok
INSERT INTO tab0 VALUES(665,442994,391235.42,'lfjpo',762023,255004.74,'pvzsd')

statement ok
INSERT INTO tab0 VALUES(666,265563,100006.15,'olpaw',258239,235076.3,'epjws')

statement ok
INSERT INTO tab0 VALUES(667,625335,851989.28,'jmmwf',149230,76293.10,'ukgdf')

statement ok
INSERT INTO tab0 VALUES(668,450805,142974.49,'idiye',555847,697265.35,'vsdml')

statement ok
INSERT INTO tab0 VALUES(669,86456,220611.18,'vyhjn',77484,581085.48,'qrgwu')

statement ok
INSERT INTO tab0 VALUES(670,417846,709594.65,'mhbqw',917054,400268.64,'kifdr')

statement ok
INSERT INTO tab0 VALUES(671,996520,236511.16,'zlpsd',6011,641723.53,'nvpfh')

statement ok
INSERT INTO tab0 VALUES(672,165008,54992.12,'ttmhk',129241,231933.51,'lhphf')

statement ok
INSERT INTO tab0 VALUES(673,181945,670532.16,'ivwvk',50262,161773.77,'cgnwz')

statement ok
INSERT INTO tab0 VALUES(674,346862,465576.28,'gouqc',636017,111541.43,'rmrxs')

statement ok
INSERT INTO tab0 VALUES(675,125366,324615.1,'ohbcl',982025,76019.67,'eltyu')

statement ok
INSERT INTO tab0 VALUES(676,274108,258972.44,'jxssz',537231,989471.82,'danfm')

statement ok
INSERT INTO tab0 VALUES(677,965728,32012.46,'qargh',229218,350555.56,'bbmwm')

statement ok
INSERT INTO tab0 VALUES(678,913879,784027.80,'scmyv',588989,847412.97,'fdoxr')

statement ok
INSERT INTO tab0 VALUES(679,498229,657257.19,'wltno',876099,982666.71,'eyoop')

statement ok
INSERT INTO tab0 VALUES(680,889434,420898.47,'epyhj',203643,698333.10,'mfxdf')

statement ok
INSERT INTO tab0 VALUES(681,174224,96099.73,'vdvlv',663146,915.28,'gbgjm')

statement ok
INSERT INTO tab0 VALUES(682,480285,580932.45,'abjzw',449768,586395.32,'wwckw')

statement ok
INSERT INTO tab0 VALUES(683,101379,275512.58,'juzai',987091,465179.35,'kokaf')

statement ok
INSERT INTO tab0 VALUES(684,622253,706787.69,'siptp',52246,587097.66,'nsgqc')

statement ok
INSERT INTO tab0 VALUES(685,43670,153778.9,'oiwqe',900878,466463.88,'xskor')

statement ok
INSERT INTO tab0 VALUES(686,907379,272338.99,'zhbql',392181,807037.5,'ysace')

statement ok
INSERT INTO tab0 VALUES(687,421203,720367.56,'wspdf',113800,127076.77,'iyfoo')

statement ok
INSERT INTO tab0 VALUES(688,583953,782684.11,'xcref',506927,384216.32,'vvpoe')

statement ok
INSERT INTO tab0 VALUES(689,310455,996063.17,'yfwra',991271,600616.80,'qyezi')

statement ok
INSERT INTO tab0 VALUES(690,556518,774230.67,'ubvhj',90057,487823.22,'fhrey')

statement ok
INSERT INTO tab0 VALUES(691,444030,32836.1,'tdwwa',555053,71899.66,'xjhde')

statement ok
INSERT INTO tab0 VALUES(692,385833,814575.23,'hnohg',491485,318298.39,'kklmb')

statement ok
INSERT INTO tab0 VALUES(693,210845,913970.9,'oykum',483123,756958.96,'pfdtc')

statement ok
INSERT INTO tab0 VALUES(694,288970,502624.24,'fbjxx',717254,107269.39,'arsky')

statement ok
INSERT INTO tab0 VALUES(695,656127,753967.31,'xjrvg',109680,903137.21,'nnqzy')

statement ok
INSERT INTO tab0 VALUES(696,139221,468475.6,'vmggf',429748,117767.68,'xtuhu')

statement ok
INSERT INTO tab0 VALUES(697,481262,698547.48,'ofnue',425262,788970.82,'onklg')

statement ok
INSERT INTO tab0 VALUES(698,466125,373535.95,'nqvwv',947570,643920.62,'elmzo')

statement ok
INSERT INTO tab0 VALUES(699,43884,924743.33,'rkhyt',76538,724304.11,'conbj')

statement ok
INSERT INTO tab0 VALUES(700,455474,910400.9,'bperd',245544,11199.50,'hreoa')

statement ok
INSERT INTO tab0 VALUES(701,357940,640777.47,'ocvyi',366516,50170.31,'rgrel')

statement ok
INSERT INTO tab0 VALUES(702,949310,802978.56,'loybk',954833,576263.50,'yrspq')

statement ok
INSERT INTO tab0 VALUES(703,93597,86181.44,'yoovy',254425,138916.56,'dgypk')

statement ok
INSERT INTO tab0 VALUES(704,445892,806396.33,'ywito',362731,727050.69,'epodu')

statement ok
INSERT INTO tab0 VALUES(705,577270,531677.68,'rhjbn',355712,394073.88,'plany')

statement ok
INSERT INTO tab0 VALUES(706,99792,707000.31,'eayyk',412872,882812.7,'eyqnn')

statement ok
INSERT INTO tab0 VALUES(707,791595,279296.53,'buuns',942169,250488.23,'muenn')

statement ok
INSERT INTO tab0 VALUES(708,721801,322448.28,'atbdm',705108,493927.53,'ogmps')

statement ok
INSERT INTO tab0 VALUES(709,375518,662292.24,'nwtky',941711,174224.46,'nmdpk')

statement ok
INSERT INTO tab0 VALUES(710,778961,501586.96,'nwljd',495544,42083.90,'eibma')

statement ok
INSERT INTO tab0 VALUES(711,624237,45135.97,'xlvmm',938598,662567.32,'qveeq')

statement ok
INSERT INTO tab0 VALUES(712,394531,124572.95,'fijzl',696502,40252.87,'bayvw')

statement ok
INSERT INTO tab0 VALUES(713,489074,823577.79,'goaug',173309,244110.48,'dicac')

statement ok
INSERT INTO tab0 VALUES(714,348114,102752.76,'sisti',876617,32623.6,'slfrl')

statement ok
INSERT INTO tab0 VALUES(715,577789,424652.65,'wkzuc',542572,478637.52,'nphjh')

statement ok
INSERT INTO tab0 VALUES(716,75439,378784.83,'bdtym',260772,594604.99,'ttmjv')

statement ok
INSERT INTO tab0 VALUES(717,154266,306610.43,'kltlp',599365,957244.90,'pmpvr')

statement ok
INSERT INTO tab0 VALUES(718,668579,926544.47,'mejbi',730010,332885.10,'ciwus')

statement ok
INSERT INTO tab0 VALUES(719,138641,958924.92,'udbza',552886,302246.2,'nvllk')

statement ok
INSERT INTO tab0 VALUES(720,875823,751129.92,'ocbdc',821685,885467.73,'csber')

statement ok
INSERT INTO tab0 VALUES(721,107360,902374.81,'febeo',268646,167175.15,'qvsrk')

statement ok
INSERT INTO tab0 VALUES(722,101684,888946.33,'crsqv',729461,921447.11,'fogcc')

statement ok
INSERT INTO tab0 VALUES(723,293090,688964.69,'blkcd',268371,236846.50,'qszhl')

statement ok
INSERT INTO tab0 VALUES(724,407012,407592.73,'evuii',303131,141357.39,'ftfrb')

statement ok
INSERT INTO tab0 VALUES(725,584747,901916.5,'exlhj',730041,227355.17,'kxdpz')

statement ok
INSERT INTO tab0 VALUES(726,508789,405975.9,'gpjkd',48829,276824.63,'gheil')

statement ok
INSERT INTO tab0 VALUES(727,527496,155731.31,'otwqv',487854,886016.16,'fzufj')

statement ok
INSERT INTO tab0 VALUES(728,780334,14190.26,'ygxor',128906,90789.80,'rgzwz')

statement ok
INSERT INTO tab0 VALUES(729,322723,96191.77,'mhznr',32348,991363.39,'oqzfq')

statement ok
INSERT INTO tab0 VALUES(730,251190,393646.1,'ffoub',361968,377471.74,'czxqd')

statement ok
INSERT INTO tab0 VALUES(731,828155,400299.66,'pzsrz',510192,353240.69,'guhcq')

statement ok
INSERT INTO tab0 VALUES(732,607116,736938.2,'izvof',222869,962310.25,'mzvgd')

statement ok
INSERT INTO tab0 VALUES(733,557647,776275.11,'tlifp',724395,812713.77,'ilwra')

statement ok
INSERT INTO tab0 VALUES(734,190216,267974.85,'thysv',842681,701965.0,'bvduz')

statement ok
INSERT INTO tab0 VALUES(735,681396,963653.14,'cmtsb',134185,242065.27,'evigf')

statement ok
INSERT INTO tab0 VALUES(736,998718,241882.99,'iznmk',8819,484406.58,'ghttm')

statement ok
INSERT INTO tab0 VALUES(737,25787,733154.69,'camct',855041,544860.73,'jixmk')

statement ok
INSERT INTO tab0 VALUES(738,687194,945007.84,'ccuog',164825,228790.47,'widah')

statement ok
INSERT INTO tab0 VALUES(739,73547,886810.60,'lekux',658660,655944.60,'wjinp')

statement ok
INSERT INTO tab0 VALUES(740,566436,695007.70,'kulzi',410583,885589.9,'zaiws')

statement ok
INSERT INTO tab0 VALUES(741,963531,257873.63,'deanj',973052,541381.22,'wsuvn')

statement ok
INSERT INTO tab0 VALUES(742,603485,840728.75,'zjtfo',502166,436462.72,'xqtay')

statement ok
INSERT INTO tab0 VALUES(743,490936,710815.43,'lljlx',882446,198455.86,'vcdhs')

statement ok
INSERT INTO tab0 VALUES(744,421630,762329.13,'qkmen',851989,894378.59,'hnmow')

statement ok
INSERT INTO tab0 VALUES(745,107177,141418.57,'ynaeb',127319,655761.68,'noqfn')

statement ok
INSERT INTO tab0 VALUES(746,300384,871154.83,'qlado',528594,303527.81,'zgdag')

statement ok
INSERT INTO tab0 VALUES(747,919921,476654.51,'mebsa',104400,973083.75,'yedia')

statement ok
INSERT INTO tab0 VALUES(748,175567,609863.79,'liety',256866,739318.41,'eouho')

statement ok
INSERT INTO tab0 VALUES(749,693084,674774.62,'fgcky',866668,241516.4,'mibud')

statement ok
INSERT INTO tab0 VALUES(750,639221,452331.83,'waheo',417907,308441.31,'jhdtb')

statement ok
INSERT INTO tab0 VALUES(751,846801,725341.20,'mthcq',123321,583343.44,'rjgcm')

statement ok
INSERT INTO tab0 VALUES(752,939636,903656.68,'wqjxe',49072,148895.35,'gngbv')

statement ok
INSERT INTO tab0 VALUES(753,457519,649047.43,'ayhzs',239868,152160.75,'lyeeo')

statement ok
INSERT INTO tab0 VALUES(754,981353,500213.99,'vkuuh',843963,429779.28,'wjyks')

statement ok
INSERT INTO tab0 VALUES(755,257904,497894.40,'tdirq',238037,132781.65,'xvvip')

statement ok
INSERT INTO tab0 VALUES(756,325134,809692.31,'jupff',152404,351623.74,'nejhi')

statement ok
INSERT INTO tab0 VALUES(757,636871,355163.11,'zuefn',795806,741242.74,'oyrko')

statement ok
INSERT INTO tab0 VALUES(758,188049,430877.8,'iifwa',980529,146057.28,'umisb')

statement ok
INSERT INTO tab0 VALUES(759,639588,335357.47,'fpbzk',247406,224884.54,'dhulh')

statement ok
INSERT INTO tab0 VALUES(760,443389,993988.67,'yvtxo',990692,76020.38,'oydzc')

statement ok
INSERT INTO tab0 VALUES(761,967437,584197.29,'gkuva',583282,862243.46,'pfrci')

statement ok
INSERT INTO tab0 VALUES(762,620697,160339.34,'qdsvn',501495,435730.39,'yhpxk')

statement ok
INSERT INTO tab0 VALUES(763,978149,278686.29,'edtaw',450195,963165.82,'gzmga')

statement ok
INSERT INTO tab0 VALUES(764,905761,622558.27,'chhpi',487792,550628.59,'lobqt')

statement ok
INSERT INTO tab0 VALUES(765,685577,627136.10,'kytdi',151123,868682.84,'qfujo')

statement ok
INSERT INTO tab0 VALUES(766,140594,104553.53,'kmbod',580657,777374.16,'rwmsq')

statement ok
INSERT INTO tab0 VALUES(767,759918,868957.25,'odgil',645294,951141.67,'rovdu')

statement ok
INSERT INTO tab0 VALUES(768,823547,361450.10,'vdemy',67474,503936.18,'rlfej')

statement ok
INSERT INTO tab0 VALUES(769,527557,274993.17,'obdyc',548187,614105.33,'lxeum')

statement ok
INSERT INTO tab0 VALUES(770,109100,179595.89,'ytjmo',891845,149475.65,'ttfja')

statement ok
INSERT INTO tab0 VALUES(771,971221,147186.21,'rkwyz',131500,292358.77,'jgewb')

statement ok
INSERT INTO tab0 VALUES(772,808074,376647.68,'qywen',653625,164459.47,'kjabn')

statement ok
INSERT INTO tab0 VALUES(773,729766,818786.62,'kxmnn',323242,451965.86,'dtmlu')

statement ok
INSERT INTO tab0 VALUES(774,387481,801452.18,'zpknd',608917,30548.45,'mapnl')

statement ok
INSERT INTO tab0 VALUES(775,98388,654327.55,'mkljx',707672,590301.33,'stkwt')

statement ok
INSERT INTO tab0 VALUES(776,970672,334167.1,'msgxn',670043,260711.28,'cqnih')

statement ok
INSERT INTO tab0 VALUES(777,28503,49560.8,'zbwqe',525177,235839.87,'ksuzs')

statement ok
INSERT INTO tab0 VALUES(778,337127,886139.66,'ukhbo',405670,399139.59,'rhwlg')

statement ok
INSERT INTO tab0 VALUES(779,127777,431457.16,'gbhsd',672576,948486.3,'shyyi')

statement ok
INSERT INTO tab0 VALUES(780,922668,400024.57,'wywgz',40588,21240.91,'wegji')

statement ok
INSERT INTO tab0 VALUES(781,660125,258300.67,'yswoh',702819,319213.30,'mgtlz')

statement ok
INSERT INTO tab0 VALUES(782,819335,849701.7,'bvvae',455932,733734.67,'qquwg')

statement ok
INSERT INTO tab0 VALUES(783,545684,19561.40,'xrglb',825103,970428.6,'tnqmu')

statement ok
INSERT INTO tab0 VALUES(784,775421,240264.39,'vrpkl',189056,174530.19,'gfffq')

statement ok
INSERT INTO tab0 VALUES(785,360900,236022.3,'knpcm',904937,555633.59,'zgomu')

statement ok
INSERT INTO tab0 VALUES(786,195465,608093.67,'bfdut',433532,12847.72,'epqav')

statement ok
INSERT INTO tab0 VALUES(787,338439,459655.15,'veqqo',464050,759643.10,'usxgp')

statement ok
INSERT INTO tab0 VALUES(788,140228,20843.95,'vkxax',39276,949097.42,'hqwiw')

statement ok
INSERT INTO tab0 VALUES(789,367218,273742.28,'zppox',680419,298583.69,'dhtdv')

statement ok
INSERT INTO tab0 VALUES(790,326812,577392.20,'ohxhn',512329,714996.33,'pidot')

statement ok
INSERT INTO tab0 VALUES(791,992401,292785.80,'wzgub',388275,919677.35,'gnprs')

statement ok
INSERT INTO tab0 VALUES(792,128448,407867.27,'wesgx',15075,73455.42,'ouhqc')

statement ok
INSERT INTO tab0 VALUES(793,415374,162506.4,'upxrf',78063,401580.2,'qfoai')

statement ok
INSERT INTO tab0 VALUES(794,574676,673583.92,'tjjyh',366119,818695.56,'tipuk')

statement ok
INSERT INTO tab0 VALUES(795,493835,559936.22,'jykyl',896545,554016.51,'bfdoo')

statement ok
INSERT INTO tab0 VALUES(796,351348,567260.84,'kmnun',40283,776153.51,'clyrx')

statement ok
INSERT INTO tab0 VALUES(797,741729,193298.45,'lrdtn',646697,218139.54,'pnnfa')

statement ok
INSERT INTO tab0 VALUES(798,800476,312713.59,'kegqi',168731,802490.96,'wttjp')

statement ok
INSERT INTO tab0 VALUES(799,329132,802124.78,'fnzqc',787750,266204.74,'pkjgd')

statement ok
INSERT INTO tab0 VALUES(800,920318,165100.66,'nifte',538757,785675.50,'mzwjj')

statement ok
INSERT INTO tab0 VALUES(801,82550,157135.13,'clipn',435180,601776.67,'tewjc')

statement ok
INSERT INTO tab0 VALUES(802,365447,410766.45,'uzruk',593994,644866.61,'ucvns')

statement ok
INSERT INTO tab0 VALUES(803,484619,60363.36,'vnfyz',360687,159698.76,'xjsqw')

statement ok
INSERT INTO tab0 VALUES(804,446655,367340.24,'phhuz',434295,330535.70,'ufoeb')

statement ok
INSERT INTO tab0 VALUES(805,674224,345062.21,'jbclj',992309,906036.36,'gqeng')

statement ok
INSERT INTO tab0 VALUES(806,130981,383758.25,'pojhu',815765,824340.7,'vnqzo')

statement ok
INSERT INTO tab0 VALUES(807,446563,875702.34,'zkail',414215,838073.74,'iuazu')

statement ok
INSERT INTO tab0 VALUES(808,41687,840057.58,'sisdl',150726,139251.93,'nmbcd')

statement ok
INSERT INTO tab0 VALUES(809,253051,548034.31,'hencr',366912,984405.5,'vvpht')

statement ok
INSERT INTO tab0 VALUES(810,458374,147705.25,'deoph',507812,319458.40,'uokam')

statement ok
INSERT INTO tab0 VALUES(811,201354,289093.60,'darvk',247100,404815.37,'vwsfh')

statement ok
INSERT INTO tab0 VALUES(812,316772,749267.18,'izwjo',611907,440368.51,'uovpc')

statement ok
INSERT INTO tab0 VALUES(813,55389,57128.57,'pxcwq',107819,190399.68,'pftuh')

statement ok
INSERT INTO tab0 VALUES(814,208953,118621.20,'cpyoe',844024,608703.17,'zixgh')

statement ok
INSERT INTO tab0 VALUES(815,235290,841613.51,'cuzag',658233,463470.85,'viqpj')

statement ok
INSERT INTO tab0 VALUES(816,383209,760925.4,'mgsrw',241607,962371.24,'cwwrc')

statement ok
INSERT INTO tab0 VALUES(817,817504,663330.60,'ixznw',263854,377563.68,'iuupa')

statement ok
INSERT INTO tab0 VALUES(818,744049,212554.35,'tdrpf',498229,670593.45,'ejkzj')

statement ok
INSERT INTO tab0 VALUES(819,534698,574279.95,'hphyw',946411,117492.86,'gjebm')

statement ok
INSERT INTO tab0 VALUES(820,852325,41107.67,'prtsl',963714,933776.44,'netts')

statement ok
INSERT INTO tab0 VALUES(821,775787,657684.54,'djsin',383880,899353.0,'cyiut')

statement ok
INSERT INTO tab0 VALUES(822,925018,845489.46,'vmlrq',644195,983642.78,'ttqxn')

statement ok
INSERT INTO tab0 VALUES(823,585937,28045.30,'nvlcs',910491,970458.60,'oqhxp')

statement ok
INSERT INTO tab0 VALUES(824,835449,255798.7,'rhwqs',202026,83099.93,'rvlvz')

statement ok
INSERT INTO tab0 VALUES(825,666534,831146.2,'dwibg',516693,609344.8,'rrozq')

statement ok
INSERT INTO tab0 VALUES(826,113159,933441.77,'pyndh',955810,526367.26,'lcxgc')

statement ok
INSERT INTO tab0 VALUES(827,375274,243988.43,'eksnq',849243,125854.75,'rlgze')

statement ok
INSERT INTO tab0 VALUES(828,943939,571044.73,'honct',880401,638885.2,'nqljo')

statement ok
INSERT INTO tab0 VALUES(829,726074,474792.15,'zolbf',211120,861022.85,'elahk')

statement ok
INSERT INTO tab0 VALUES(830,169799,892456.4,'thnxk',606872,777313.42,'pmysy')

statement ok
INSERT INTO tab0 VALUES(831,389099,763092.72,'erysb',561553,187194.50,'akaqe')

statement ok
INSERT INTO tab0 VALUES(832,289062,652802.67,'iorhd',422637,329620.53,'ryuin')

statement ok
INSERT INTO tab0 VALUES(833,690765,379608.57,'scdab',516021,507934.75,'ieyhg')

statement ok
INSERT INTO tab0 VALUES(834,456268,638519.51,'puskt',271240,714965.35,'amzoj')

statement ok
INSERT INTO tab0 VALUES(835,613739,626373.5,'vnmux',346221,258026.55,'nuztb')

statement ok
INSERT INTO tab0 VALUES(836,482208,667144.37,'jtuvu',752563,383819.77,'eqzek')

statement ok
INSERT INTO tab0 VALUES(837,796905,836639.41,'zqyhz',980194,903564.73,'hjxbx')

statement ok
INSERT INTO tab0 VALUES(838,833923,587615.95,'vfsnq',122680,817840.60,'zdvlg')

statement ok
INSERT INTO tab0 VALUES(839,535461,374877.79,'akcfn',2105,941833.7,'qgzpu')

statement ok
INSERT INTO tab0 VALUES(840,634704,280059.85,'jfuwi',294007,529999.55,'oybyi')

statement ok
INSERT INTO tab0 VALUES(841,780822,636871.28,'yvzrn',652465,901397.23,'txbfp')

statement ok
INSERT INTO tab0 VALUES(842,664062,655853.60,'svvrv',835083,64483.24,'ictqx')

statement ok
INSERT INTO tab0 VALUES(843,140655,49592.83,'ddebv',827972,342132.77,'gzkbw')

statement ok
INSERT INTO tab0 VALUES(844,357818,657592.61,'vkddt',970794,996705.19,'yumax')

statement ok
INSERT INTO tab0 VALUES(845,878845,71319.32,'ftujy',81665,855041.17,'xhavz')

statement ok
INSERT INTO tab0 VALUES(846,808013,259155.22,'zjquo',582244,933380.83,'jjlwe')

statement ok
INSERT INTO tab0 VALUES(847,915618,191528.54,'afmwf',622711,62438.83,'vufne')

statement ok
INSERT INTO tab0 VALUES(848,762939,465698.65,'tjtso',206787,512420.50,'vkhkf')

statement ok
INSERT INTO tab0 VALUES(849,827331,930999.16,'vdlfv',316650,617919.1,'knynj')

statement ok
INSERT INTO tab0 VALUES(850,627136,313599.5,'xdkgr',37994,403045.44,'wpfhj')

statement ok
INSERT INTO tab0 VALUES(851,846679,841705.79,'ckjpq',685150,206298.93,'htrtg')

statement ok
INSERT INTO tab0 VALUES(852,461364,870452.46,'ppcht',925782,305664.80,'hszpu')

statement ok
INSERT INTO tab0 VALUES(853,862579,506927.92,'nbmni',906188,543609.68,'lylkj')

statement ok
INSERT INTO tab0 VALUES(854,982696,235168.85,'fwvzk',376190,951995.64,'evvsj')

statement ok
INSERT INTO tab0 VALUES(855,420196,541168.96,'efqwl',814056,377197.28,'crtda')

statement ok
INSERT INTO tab0 VALUES(856,564422,537841.6,'keday',551605,104949.91,'waonu')

statement ok
INSERT INTO tab0 VALUES(857,720916,590148.22,'iebad',899169,485595.63,'spsbg')

statement ok
INSERT INTO tab0 VALUES(858,236083,939880.87,'dxcjn',270629,558746.48,'bqnhn')

statement ok
INSERT INTO tab0 VALUES(859,622436,330871.93,'qlqrn',308319,678649.55,'drvoy')

statement ok
INSERT INTO tab0 VALUES(860,683471,633911.95,'roioc',8087,138824.13,'rcost')

statement ok
INSERT INTO tab0 VALUES(861,638671,471649.21,'xqszk',844421,797393.78,'kyhos')

statement ok
INSERT INTO tab0 VALUES(862,248596,843780.87,'lxxji',895141,701843.53,'wcbup')

statement ok
INSERT INTO tab0 VALUES(863,939788,751892.8,'joeoi',966705,714172.94,'wothz')

statement ok
INSERT INTO tab0 VALUES(864,929809,824615.12,'iuobt',719085,135772.28,'ejybv')

statement ok
INSERT INTO tab0 VALUES(865,352203,942443.49,'jcmgs',790710,332519.58,'ewkmz')

statement ok
INSERT INTO tab0 VALUES(866,381591,862823.9,'jflip',923553,359771.86,'kvskz')

statement ok
INSERT INTO tab0 VALUES(867,358551,845245.28,'skpns',88134,587310.14,'flygq')

statement ok
INSERT INTO tab0 VALUES(868,914764,276031.8,'xkify',608398,324310.67,'nohcn')

statement ok
INSERT INTO tab0 VALUES(869,97808,293548.21,'irzch',286926,444519.98,'fxqat')

statement ok
INSERT INTO tab0 VALUES(870,496368,413085.28,'qpkep',529724,11078.3,'xwfwn')

statement ok
INSERT INTO tab0 VALUES(871,365081,151885.92,'ojrdc',471343,901519.34,'qbgsv')

statement ok
INSERT INTO tab0 VALUES(872,749664,654144.82,'ljode',99853,432983.13,'fcouy')

statement ok
INSERT INTO tab0 VALUES(873,611816,316009.98,'xbggs',381866,986877.40,'fydrf')

statement ok
INSERT INTO tab0 VALUES(874,954223,410583.71,'nhajb',387451,634216.10,'hvwjn')

statement ok
INSERT INTO tab0 VALUES(875,945678,712890.86,'gkukk',415222,760375.22,'zqcob')

statement ok
INSERT INTO tab0 VALUES(876,45867,125000.86,'jfsnm',117309,690246.96,'itgot')

statement ok
INSERT INTO tab0 VALUES(877,130554,300812.93,'tiwbf',624359,313110.79,'ilnod')

statement ok
INSERT INTO tab0 VALUES(878,616577,271270.12,'tcyti',670562,707763.64,'uukrw')

statement ok
INSERT INTO tab0 VALUES(879,586669,69244.48,'svsxa',718566,767395.98,'uwidf')

statement ok
INSERT INTO tab0 VALUES(880,914642,354553.20,'rzsnk',84533,824676.98,'kxlly')

statement ok
INSERT INTO tab0 VALUES(881,390380,38970.69,'xdygk',63262,276763.59,'gkzhs')

statement ok
INSERT INTO tab0 VALUES(882,844665,911224.76,'ofkte',52886,210205.72,'fhczw')

statement ok
INSERT INTO tab0 VALUES(883,274383,261962.67,'hpuqu',680206,26031.31,'xxjiw')

statement ok
INSERT INTO tab0 VALUES(884,967376,508880.33,'yfaty',925415,64758.50,'niove')

statement ok
INSERT INTO tab0 VALUES(885,627593,821502.40,'brzdk',247344,231292.74,'ehbyr')

statement ok
INSERT INTO tab0 VALUES(886,499877,746429.38,'smcgu',708282,620056.89,'wmrzi')

statement ok
INSERT INTO tab0 VALUES(887,495147,832092.79,'vbvde',98968,139862.39,'vockx')

statement ok
INSERT INTO tab0 VALUES(888,315399,253967.26,'bwpkq',63781,139038.34,'fjrum')

statement ok
INSERT INTO tab0 VALUES(889,578521,439453.66,'iodmx',225494,30273.67,'uzzee')

statement ok
INSERT INTO tab0 VALUES(890,943511,692901.24,'leesb',310516,915863.23,'pwkzq')

statement ok
INSERT INTO tab0 VALUES(891,235321,820617.73,'rdflc',273712,212371.91,'lywgu')

statement ok
INSERT INTO tab0 VALUES(892,569976,755828.49,'omxdn',423400,275970.81,'nwgsm')

statement ok
INSERT INTO tab0 VALUES(893,479492,183807.62,'hxxqa',546539,27221.33,'hzizy')

statement ok
INSERT INTO tab0 VALUES(894,36895,166657.9,'mzkae',33508,576080.29,'socpp')

statement ok
INSERT INTO tab0 VALUES(895,981201,768554.86,'uercw',3234,847106.7,'evoen')

statement ok
INSERT INTO tab0 VALUES(896,842498,680511.2,'mbvdc',428161,204132.73,'bejpg')

statement ok
INSERT INTO tab0 VALUES(897,66864,845581.89,'ckkhl',259247,75592.16,'hggag')

statement ok
INSERT INTO tab0 VALUES(898,141357,83740.17,'cgxpz',550994,579285.14,'ydzdo')

statement ok
INSERT INTO tab0 VALUES(899,719116,716918.6,'ldpcm',586364,147521.55,'ajqco')

statement ok
INSERT INTO tab0 VALUES(900,744262,194000.35,'gewak',1861,152008.42,'wblyk')

statement ok
INSERT INTO tab0 VALUES(901,576934,715820.61,'jefui',912506,528961.9,'agkkt')

statement ok
INSERT INTO tab0 VALUES(902,118255,860137.26,'bslir',36834,403991.35,'rsugk')

statement ok
INSERT INTO tab0 VALUES(903,935424,206756.70,'pjtag',821929,717193.54,'ihwiv')

statement ok
INSERT INTO tab0 VALUES(904,386596,962310.49,'xuzyy',568328,848144.67,'myorz')

statement ok
INSERT INTO tab0 VALUES(905,746032,585479.40,'evixh',555114,240814.57,'exwrr')

statement ok
INSERT INTO tab0 VALUES(906,328887,411865.58,'npfqc',164887,28656.98,'rvufk')

statement ok
INSERT INTO tab0 VALUES(907,616424,279022.67,'ntnwe',8789,659606.74,'butrv')

statement ok
INSERT INTO tab0 VALUES(908,380859,151458.94,'xloou',51391,520996.82,'yoehp')

statement ok
INSERT INTO tab0 VALUES(909,810485,745635.39,'folwm',735900,564666.53,'xrizt')

statement ok
INSERT INTO tab0 VALUES(910,634582,154968.90,'itwkm',108948,931854.60,'gousk')

statement ok
INSERT INTO tab0 VALUES(911,248443,474822.34,'essfo',945739,578278.32,'sobon')

statement ok
INSERT INTO tab0 VALUES(912,838348,427490.70,'heocl',874908,899139.67,'vhitj')

statement ok
INSERT INTO tab0 VALUES(913,506652,987274.21,'oznoo',503723,354034.41,'woxwd')

statement ok
INSERT INTO tab0 VALUES(914,396667,5432.47,'qkqbq',542877,92071.26,'fmzzu')

statement ok
INSERT INTO tab0 VALUES(915,817810,835083.59,'wdpaj',931610,576752.99,'cwhtj')

statement ok
INSERT INTO tab0 VALUES(916,370391,956390.27,'nlmcx',962677,211059.54,'fznnv')

statement ok
INSERT INTO tab0 VALUES(917,70831,601440.98,'vgeer',407379,962463.16,'iyflq')

statement ok
INSERT INTO tab0 VALUES(918,476501,379272.4,'hiemv',640441,987823.54,'xsftj')

statement ok
INSERT INTO tab0 VALUES(919,810852,900848.79,'mkbxz',765228,258514.93,'tigqh')

statement ok
INSERT INTO tab0 VALUES(920,88317,404174.65,'pifvt',738525,185302.24,'qxuoc')

statement ok
INSERT INTO tab0 VALUES(921,239349,379089.33,'dznon',495697,243438.21,'xvlij')

statement ok
INSERT INTO tab0 VALUES(922,235382,192504.86,'lusdv',75531,597656.50,'cvqfl')

statement ok
INSERT INTO tab0 VALUES(923,213928,713165.82,'klkvh',745452,727081.83,'ofjbu')

statement ok
INSERT INTO tab0 VALUES(924,603486,936859.35,'ahgxz',126312,50323.9,'dypjs')

statement ok
INSERT INTO tab0 VALUES(925,248535,611297.38,'cjbye',317504,550476.50,'uqdqd')

statement ok
INSERT INTO tab0 VALUES(926,534637,861145.69,'wnzxx',21942,400024.70,'bwcdy')

statement ok
INSERT INTO tab0 VALUES(927,513336,813018.5,'mokjs',671081,585968.87,'yfmiv')

statement ok
INSERT INTO tab0 VALUES(928,27160,220489.37,'ujnmc',549804,534698.91,'ikzyw')

statement ok
INSERT INTO tab0 VALUES(929,834747,89080.77,'xaxdh',921630,737121.48,'rjnxb')

statement ok
INSERT INTO tab0 VALUES(930,735626,301239.77,'vwdfv',153533,373504.21,'rlurc')

statement ok
INSERT INTO tab0 VALUES(931,695404,241424.37,'ctlod',840942,938720.76,'woajw')

statement ok
INSERT INTO tab0 VALUES(932,970764,421051.20,'jdmfe',932891,866912.0,'fdlrb')

statement ok
INSERT INTO tab0 VALUES(933,234283,103393.62,'bbpkc',856933,156829.7,'slegy')

statement ok
INSERT INTO tab0 VALUES(934,699615,928771.86,'anwxx',644073,996612.58,'fqnpv')

statement ok
INSERT INTO tab0 VALUES(935,246490,539428.16,'cijxy',53863,388824.67,'swvlw')

statement ok
INSERT INTO tab0 VALUES(936,545532,204559.86,'unbgr',699401,775512.18,'ilapk')

statement ok
INSERT INTO tab0 VALUES(937,183471,445312.56,'uegpe',172210,663177.73,'qvggx')

statement ok
INSERT INTO tab0 VALUES(938,787994,659759.21,'tujlw',167449,247802.90,'maodl')

statement ok
INSERT INTO tab0 VALUES(939,152862,748016.28,'xgklc',608703,39794.31,'mlilg')

statement ok
INSERT INTO tab0 VALUES(940,362823,737030.84,'ncrgr',773101,488952.76,'udedm')

statement ok
INSERT INTO tab0 VALUES(941,918640,405822.71,'qmkxs',416290,609649.38,'pzkbt')

statement ok
INSERT INTO tab0 VALUES(942,862060,910247.57,'tkjta',897461,605651.71,'urpzu')

statement ok
INSERT INTO tab0 VALUES(943,900909,408203.12,'iwltx',304260,495147.85,'oyksb')

statement ok
INSERT INTO tab0 VALUES(944,533996,684509.15,'owikr',577880,735809.57,'dpyik')

statement ok
INSERT INTO tab0 VALUES(945,176147,775939.70,'tqeei',638031,849792.48,'gwtgq')

statement ok
INSERT INTO tab0 VALUES(946,283172,596191.20,'frbed',507934,48645.9,'xezie')

statement ok
INSERT INTO tab0 VALUES(947,476959,561004.55,'ubuuj',439361,858428.98,'wokbs')

statement ok
INSERT INTO tab0 VALUES(948,670349,212982.28,'kimjs',37536,744567.91,'krwot')

statement ok
INSERT INTO tab0 VALUES(949,192291,846679.66,'ttbqf',386230,737091.95,'wxxwh')

statement ok
INSERT INTO tab0 VALUES(950,912597,133666.84,'yjcrn',172729,55297.60,'fpkzm')

statement ok
INSERT INTO tab0 VALUES(951,367279,747467.95,'dhhdv',812835,733093.90,'xagwe')

statement ok
INSERT INTO tab0 VALUES(952,883239,988464.24,'boahi',575897,243774.60,'epwwo')

statement ok
INSERT INTO tab0 VALUES(953,703399,409088.22,'tmfdy',709716,125061.25,'acapx')

statement ok
INSERT INTO tab0 VALUES(954,111724,438690.75,'dttrw',565643,604156.30,'mndbz')

statement ok
INSERT INTO tab0 VALUES(955,558258,8544.19,'sjfve',723541,222717.30,'nnhzx')

statement ok
INSERT INTO tab0 VALUES(956,783935,176971.54,'zzkun',116790,461883.96,'nhosm')

statement ok
INSERT INTO tab0 VALUES(957,945800,754150.50,'jadxt',157318,367218.30,'ywslg')

statement ok
INSERT INTO tab0 VALUES(958,741882,927215.68,'pnran',860504,173706.76,'zbzjp')

statement ok
INSERT INTO tab0 VALUES(959,536193,885345.66,'kskkv',970275,930816.36,'eultw')

statement ok
INSERT INTO tab0 VALUES(960,483825,444549.16,'fsqbv',84075,127471.79,'xbwap')

statement ok
INSERT INTO tab0 VALUES(961,655853,672882.13,'tyytg',777893,317077.54,'ieebl')

statement ok
INSERT INTO tab0 VALUES(962,164337,515319.88,'mbadf',731140,742462.4,'ptecp')

statement ok
INSERT INTO tab0 VALUES(963,287414,418792.23,'pgfws',851867,960845.78,'uzczn')

statement ok
INSERT INTO tab0 VALUES(964,594207,957183.62,'gfcug',401550,469024.42,'nsiim')

statement ok
INSERT INTO tab0 VALUES(965,69824,456298.23,'mkfzp',120208,328186.93,'ilznh')

statement ok
INSERT INTO tab0 VALUES(966,240478,618988.10,'qbpyg',351409,788940.71,'oslyw')

statement ok
INSERT INTO tab0 VALUES(967,298279,149932.28,'dilte',167144,916381.74,'vwcbv')

statement ok
INSERT INTO tab0 VALUES(968,226409,380889.92,'bnubj',493041,215087.65,'vpzof')

statement ok
INSERT INTO tab0 VALUES(969,924133,895446.44,'rbzil',233155,254028.89,'qshkz')

statement ok
INSERT INTO tab0 VALUES(970,331604,154235.60,'fumwk',395111,291656.83,'smcds')

statement ok
INSERT INTO tab0 VALUES(971,555053,119812.68,'kwkde',214965,900909.93,'fpwvh')

statement ok
INSERT INTO tab0 VALUES(972,991790,881683.56,'ddcpd',282409,594116.80,'xniek')

statement ok
INSERT INTO tab0 VALUES(973,455017,281311.88,'zcwcy',665557,448120.36,'ljtwf')

statement ok
INSERT INTO tab0 VALUES(974,299041,537109.13,'aamvy',36071,729156.97,'idvlz')

statement ok
INSERT INTO tab0 VALUES(975,544128,869415.81,'hgymb',794128,517974.55,'jxhpv')

statement ok
INSERT INTO tab0 VALUES(976,1647,125610.54,'lcand',193420,334686.69,'hwiec')

statement ok
INSERT INTO tab0 VALUES(977,398864,404907.17,'nbwbs',466186,764007.79,'kjlle')

statement ok
INSERT INTO tab0 VALUES(978,504119,683563.94,'gbser',948120,79925.19,'hizba')

statement ok
INSERT INTO tab0 VALUES(979,251831,439788.55,'cjjxt',203460,871032.28,'gasgy')

statement ok
INSERT INTO tab0 VALUES(980,867309,278656.36,'oxznj',149963,665283.63,'ckoby')

statement ok
INSERT INTO tab0 VALUES(981,991943,557250.45,'weqny',183929,555145.12,'tfbgp')

statement ok
INSERT INTO tab0 VALUES(982,808197,9674.77,'sqxvu',305114,822479.5,'vbhrr')

statement ok
INSERT INTO tab0 VALUES(983,164428,371887.28,'uqmwr',241790,563659.31,'fobdn')

statement ok
INSERT INTO tab0 VALUES(984,700103,6835.3,'koytj',575866,314453.43,'vmzsz')

statement ok
INSERT INTO tab0 VALUES(985,970642,529388.34,'ebfhg',867584,675109.77,'dvtxt')

statement ok
INSERT INTO tab0 VALUES(986,572570,431458.90,'pagge',780822,935363.63,'uzyng')

statement ok
INSERT INTO tab0 VALUES(987,268310,706788.86,'qxqls',207977,699340.33,'hvsbc')

statement ok
INSERT INTO tab0 VALUES(988,111358,476165.4,'nqjvd',394897,510681.41,'pycru')

statement ok
INSERT INTO tab0 VALUES(989,571289,612304.97,'bveov',65979,477386.71,'sqblg')

statement ok
INSERT INTO tab0 VALUES(990,658569,364868.5,'ralhz',549133,897064.47,'lcvip')

statement ok
INSERT INTO tab0 VALUES(991,49774,985473.69,'ppreg',900817,881591.53,'vmnkq')

statement ok
INSERT INTO tab0 VALUES(992,212432,352691.41,'vcdyf',30944,982452.39,'xdzxn')

statement ok
INSERT INTO tab0 VALUES(993,530151,597015.96,'reofh',827973,815521.35,'frfnk')

statement ok
INSERT INTO tab0 VALUES(994,427520,725982.50,'dvrkc',283874,686096.66,'qacib')

statement ok
INSERT INTO tab0 VALUES(995,495148,248962.63,'zpwae',619140,213958.61,'vsxzo')

statement ok
INSERT INTO tab0 VALUES(996,614624,802368.62,'ymttr',407806,958374.67,'uwcwr')

statement ok
INSERT INTO tab0 VALUES(997,83619,774566.45,'oealv',702331,42999.65,'uhugw')

statement ok
INSERT INTO tab0 VALUES(998,740783,930786.98,'vhrlt',158813,780975.74,'rwngm')

statement ok
INSERT INTO tab0 VALUES(999,90759,38299.7,'rhbpy',161804,299926.74,'rgsev')

statement ok
CREATE TABLE tab1(pk INTEGER PRIMARY KEY, col0 INTEGER, col1 FLOAT, col2 TEXT, col3 INTEGER, col4 FLOAT, col5 TEXT)

statement ok
CREATE INDEX idx_tab1_0 on tab1 (col0)

statement ok
CREATE INDEX idx_tab1_1 on tab1 (col1)

statement ok
CREATE INDEX idx_tab1_3 on tab1 (col3)

statement ok
CREATE INDEX idx_tab1_4 on tab1 (col4)

statement ok
INSERT INTO tab1 SELECT * FROM tab0

statement ok
CREATE TABLE tab2(pk INTEGER PRIMARY KEY, col0 INTEGER, col1 FLOAT, col2 TEXT, col3 INTEGER, col4 FLOAT, col5 TEXT)

statement ok
CREATE INDEX idx_tab2_0 ON tab2 (col4 DESC)

statement ok
CREATE INDEX idx_tab2_3 ON tab2 (col3 DESC)

statement ok
CREATE UNIQUE INDEX idx_tab2_4 ON tab2 (col0)

statement ok
INSERT INTO tab2 SELECT * FROM tab0

statement ok
CREATE TABLE tab3(pk INTEGER PRIMARY KEY, col0 INTEGER, col1 FLOAT, col2 TEXT, col3 INTEGER, col4 FLOAT, col5 TEXT)

statement ok
CREATE UNIQUE INDEX idx_tab3_0 ON tab3 (col0 DESC,col1)

statement ok
CREATE INDEX idx_tab3_1 ON tab3 (col1 DESC)

statement ok
CREATE UNIQUE INDEX idx_tab3_2 ON tab3 (col4 DESC,col3)

statement ok
INSERT INTO tab3 SELECT * FROM tab0

statement ok
CREATE TABLE tab4(pk INTEGER PRIMARY KEY, col0 INTEGER, col1 FLOAT, col2 TEXT, col3 INTEGER, col4 FLOAT, col5 TEXT)

statement ok
CREATE INDEX idx_tab4_0 ON tab4 (col0,col4)

statement ok
CREATE UNIQUE INDEX idx_tab4_2 ON tab4 (col1 DESC,col3)

statement ok
CREATE INDEX idx_tab4_3 ON tab4 (col3)

statement ok
INSERT INTO tab4 SELECT * FROM tab0

query IIIIIII rowsort label-0
SELECT ALL * FROM tab0 AS cor0 WHERE + col1 * + col1 IS NULL
----

query IIIIIII rowsort label-0
SELECT ALL * FROM tab1 AS cor0 WHERE + col1 * + col1 IS NULL
----

query IIIIIII rowsort label-0
SELECT ALL * FROM tab2 AS cor0 WHERE + col1 * + col1 IS NULL
----

query IIIIIII rowsort label-0
SELECT ALL * FROM tab3 AS cor0 WHERE + col1 * + col1 IS NULL
----

query IIIIIII rowsort label-0
SELECT ALL * FROM tab4 AS cor0 WHERE + col1 * + col1 IS NULL
----

onlyif mysql # CAST syntax: SIGNED type: 
query IIIIIII rowsort label-5
SELECT ALL * FROM tab0 AS cor0 WHERE col0 NOT IN ( - - 53, + CAST( NULL AS SIGNED ) + col4 )
----

skipif mysql # not compatible
query IIIIIII rowsort label-5
SELECT ALL * FROM tab0 AS cor0 WHERE col0 NOT IN ( - - 53, + CAST ( NULL AS INTEGER ) + col4 )
----

onlyif mysql # CAST syntax: SIGNED type: 
query IIIIIII rowsort label-5
SELECT ALL * FROM tab1 AS cor0 WHERE col0 NOT IN ( - - 53, + CAST( NULL AS SIGNED ) + col4 )
----

skipif mysql # not compatible
query IIIIIII rowsort label-5
SELECT ALL * FROM tab1 AS cor0 WHERE col0 NOT IN ( - - 53, + CAST ( NULL AS INTEGER ) + col4 )
----

onlyif mysql # CAST syntax: SIGNED type: 
query IIIIIII rowsort label-5
SELECT ALL * FROM tab2 AS cor0 WHERE col0 NOT IN ( - - 53, + CAST( NULL AS SIGNED ) + col4 )
----

skipif mysql # not compatible
query IIIIIII rowsort label-5
SELECT ALL * FROM tab2 AS cor0 WHERE col0 NOT IN ( - - 53, + CAST ( NULL AS INTEGER ) + col4 )
----

onlyif mysql # CAST syntax: SIGNED type: 
query IIIIIII rowsort label-5
SELECT ALL * FROM tab3 AS cor0 WHERE col0 NOT IN ( - - 53, + CAST( NULL AS SIGNED ) + col4 )
----

skipif mysql # not compatible
query IIIIIII rowsort label-5
SELECT ALL * FROM tab3 AS cor0 WHERE col0 NOT IN ( - - 53, + CAST ( NULL AS INTEGER ) + col4 )
----

onlyif mysql # CAST syntax: SIGNED type: 
query IIIIIII rowsort label-5
SELECT ALL * FROM tab4 AS cor0 WHERE col0 NOT IN ( - - 53, + CAST( NULL AS SIGNED ) + col4 )
----

skipif mysql # not compatible
query IIIIIII rowsort label-5
SELECT ALL * FROM tab4 AS cor0 WHERE col0 NOT IN ( - - 53, + CAST ( NULL AS INTEGER ) + col4 )
----

query IIIIIII rowsort label-10
SELECT ALL * FROM tab0 WHERE col5 IS NULL
----

query IIIIIII rowsort label-10
SELECT ALL * FROM tab1 WHERE col5 IS NULL
----

query IIIIIII rowsort label-10
SELECT ALL * FROM tab2 WHERE col5 IS NULL
----

query IIIIIII rowsort label-10
SELECT ALL * FROM tab3 WHERE col5 IS NULL
----

query IIIIIII rowsort label-10
SELECT ALL * FROM tab4 WHERE col5 IS NULL
----

query II rowsort label-15
SELECT ALL col2, col4 FROM tab0 WHERE NULL IS NOT NULL
----

query II rowsort label-15
SELECT ALL col2, col4 FROM tab1 WHERE NULL IS NOT NULL
----

query II rowsort label-15
SELECT ALL col2, col4 FROM tab2 WHERE NULL IS NOT NULL
----

query II rowsort label-15
SELECT ALL col2, col4 FROM tab3 WHERE NULL IS NOT NULL
----

query II rowsort label-15
SELECT ALL col2, col4 FROM tab4 WHERE NULL IS NOT NULL
----

query IIIIIII rowsort label-20
SELECT * FROM tab0 WHERE col0 >= NULL
----

query IIIIIII rowsort label-20
SELECT * FROM tab1 WHERE col0 >= NULL
----

query IIIIIII rowsort label-20
SELECT * FROM tab2 WHERE col0 >= NULL
----

query IIIIIII rowsort label-20
SELECT * FROM tab3 WHERE col0 >= NULL
----

query IIIIIII rowsort label-20
SELECT * FROM tab4 WHERE col0 >= NULL
----

query IIIIIII rowsort label-25
SELECT * FROM tab0 AS cor0 WHERE NOT ( NULL ) IS NULL
----

query IIIIIII rowsort label-25
SELECT * FROM tab1 AS cor0 WHERE NOT ( NULL ) IS NULL
----

query IIIIIII rowsort label-25
SELECT * FROM tab2 AS cor0 WHERE NOT ( NULL ) IS NULL
----

query IIIIIII rowsort label-25
SELECT * FROM tab3 AS cor0 WHERE NOT ( NULL ) IS NULL
----

query IIIIIII rowsort label-25
SELECT * FROM tab4 AS cor0 WHERE NOT ( NULL ) IS NULL
----

query IIIIIII rowsort label-30
SELECT * FROM tab0 AS cor0 WHERE NOT + col0 IS NOT NULL
----

query IIIIIII rowsort label-30
SELECT * FROM tab1 AS cor0 WHERE NOT + col0 IS NOT NULL
----

query IIIIIII rowsort label-30
SELECT * FROM tab2 AS cor0 WHERE NOT + col0 IS NOT NULL
----

query IIIIIII rowsort label-30
SELECT * FROM tab3 AS cor0 WHERE NOT + col0 IS NOT NULL
----

query IIIIIII rowsort label-30
SELECT * FROM tab4 AS cor0 WHERE NOT + col0 IS NOT NULL
----

onlyif mysql # CAST syntax: SIGNED type: 
query II rowsort label-35
SELECT col2 AS col0, - 97 + + col1 * CAST( + + 52 AS SIGNED ) + - + 72 AS col1 FROM tab0 AS cor0 WHERE NOT NULL IS NULL
----

skipif mysql # not compatible
query II rowsort label-35
SELECT col2 AS col0, - 97 + + col1 * CAST ( + + 52 AS INTEGER ) + - + 72 AS col1 FROM tab0 AS cor0 WHERE NOT NULL IS NULL
----

onlyif mysql # CAST syntax: SIGNED type: 
query II rowsort label-35
SELECT col2 AS col0, - 97 + + col1 * CAST( + + 52 AS SIGNED ) + - + 72 AS col1 FROM tab1 AS cor0 WHERE NOT NULL IS NULL
----

skipif mysql # not compatible
query II rowsort label-35
SELECT col2 AS col0, - 97 + + col1 * CAST ( + + 52 AS INTEGER ) + - + 72 AS col1 FROM tab1 AS cor0 WHERE NOT NULL IS NULL
----

onlyif mysql # CAST syntax: SIGNED type: 
query II rowsort label-35
SELECT col2 AS col0, - 97 + + col1 * CAST( + + 52 AS SIGNED ) + - + 72 AS col1 FROM tab2 AS cor0 WHERE NOT NULL IS NULL
----

skipif mysql # not compatible
query II rowsort label-35
SELECT col2 AS col0, - 97 + + col1 * CAST ( + + 52 AS INTEGER ) + - + 72 AS col1 FROM tab2 AS cor0 WHERE NOT NULL IS NULL
----

onlyif mysql # CAST syntax: SIGNED type: 
query II rowsort label-35
SELECT col2 AS col0, - 97 + + col1 * CAST( + + 52 AS SIGNED ) + - + 72 AS col1 FROM tab3 AS cor0 WHERE NOT NULL IS NULL
----

skipif mysql # not compatible
query II rowsort label-35
SELECT col2 AS col0, - 97 + + col1 * CAST ( + + 52 AS INTEGER ) + - + 72 AS col1 FROM tab3 AS cor0 WHERE NOT NULL IS NULL
----

onlyif mysql # CAST syntax: SIGNED type: 
query II rowsort label-35
SELECT col2 AS col0, - 97 + + col1 * CAST( + + 52 AS SIGNED ) + - + 72 AS col1 FROM tab4 AS cor0 WHERE NOT NULL IS NULL
----

skipif mysql # not compatible
query II rowsort label-35
SELECT col2 AS col0, - 97 + + col1 * CAST ( + + 52 AS INTEGER ) + - + 72 AS col1 FROM tab4 AS cor0 WHERE NOT NULL IS NULL
----

query I rowsort label-40
SELECT col4 / + 55 AS col0 FROM tab0 AS cor0 WHERE NOT NULL IS NULL
----

query I rowsort label-40
SELECT col4 / + 55 AS col0 FROM tab1 AS cor0 WHERE NOT NULL IS NULL
----

query I rowsort label-40
SELECT col4 / + 55 AS col0 FROM tab2 AS cor0 WHERE NOT NULL IS NULL
----

query I rowsort label-40
SELECT col4 / + 55 AS col0 FROM tab3 AS cor0 WHERE NOT NULL IS NULL
----

query I rowsort label-40
SELECT col4 / + 55 AS col0 FROM tab4 AS cor0 WHERE NOT NULL IS NULL
----

query IIIIIII rowsort label-45
SELECT * FROM tab0 AS cor0 WHERE NOT NULL IS NULL
----

query IIIIIII rowsort label-45
SELECT * FROM tab1 AS cor0 WHERE NOT NULL IS NULL
----

query IIIIIII rowsort label-45
SELECT * FROM tab2 AS cor0 WHERE NOT NULL IS NULL
----

query IIIIIII rowsort label-45
SELECT * FROM tab3 AS cor0 WHERE NOT NULL IS NULL
----

query IIIIIII rowsort label-45
SELECT * FROM tab4 AS cor0 WHERE NOT NULL IS NULL
----

query IIIIIII rowsort label-50
SELECT ALL * FROM tab0 WHERE NOT + + 75 + - ( + ( 4 ) ) IS NOT NULL
----

query IIIIIII rowsort label-50
SELECT ALL * FROM tab1 WHERE NOT + + 75 + - ( + ( 4 ) ) IS NOT NULL
----

query IIIIIII rowsort label-50
SELECT ALL * FROM tab2 WHERE NOT + + 75 + - ( + ( 4 ) ) IS NOT NULL
----

query IIIIIII rowsort label-50
SELECT ALL * FROM tab3 WHERE NOT + + 75 + - ( + ( 4 ) ) IS NOT NULL
----

query IIIIIII rowsort label-50
SELECT ALL * FROM tab4 WHERE NOT + + 75 + - ( + ( 4 ) ) IS NOT NULL
----

query I rowsort label-55
SELECT ALL - col4 FROM tab0 WHERE NULL = NULL
----

query I rowsort label-55
SELECT ALL - col4 FROM tab1 WHERE NULL = NULL
----

query I rowsort label-55
SELECT ALL - col4 FROM tab2 WHERE NULL = NULL
----

query I rowsort label-55
SELECT ALL - col4 FROM tab3 WHERE NULL = NULL
----

query I rowsort label-55
SELECT ALL - col4 FROM tab4 WHERE NULL = NULL
----

query I rowsort label-60
SELECT + 92 * + + col3 FROM tab0 WHERE col3 * - 78 = + col1 + - + col1
----

query I rowsort label-60
SELECT + 92 * + + col3 FROM tab1 WHERE col3 * - 78 = + col1 + - + col1
----

query I rowsort label-60
SELECT + 92 * + + col3 FROM tab2 WHERE col3 * - 78 = + col1 + - + col1
----

query I rowsort label-60
SELECT + 92 * + + col3 FROM tab3 WHERE col3 * - 78 = + col1 + - + col1
----

query I rowsort label-60
SELECT + 92 * + + col3 FROM tab4 WHERE col3 * - 78 = + col1 + - + col1
----

query IIIIIII rowsort label-65
SELECT * FROM tab0 AS cor0 WHERE ( 40 ) = NULL
----

query IIIIIII rowsort label-65
SELECT * FROM tab1 AS cor0 WHERE ( 40 ) = NULL
----

query IIIIIII rowsort label-65
SELECT * FROM tab2 AS cor0 WHERE ( 40 ) = NULL
----

query IIIIIII rowsort label-65
SELECT * FROM tab3 AS cor0 WHERE ( 40 ) = NULL
----

query IIIIIII rowsort label-65
SELECT * FROM tab4 AS cor0 WHERE ( 40 ) = NULL
----

onlyif mysql # CAST syntax: SIGNED type: DECIMAL type: 
query IIIIIII rowsort label-70
SELECT * FROM tab0 AS cor0 WHERE col4 * + col1 + - col3 + - 64 + - col4 BETWEEN col1 + + - CAST( + - col4 AS DECIMAL ) AND - - CAST( NULL AS SIGNED )
----

skipif mysql # not compatible
query IIIIIII rowsort label-70
SELECT * FROM tab0 AS cor0 WHERE col4 * + col1 + - col3 + - 64 + - col4 BETWEEN col1 + + - CAST ( + - col4 AS REAL ) AND - - CAST ( NULL AS INTEGER )
----

onlyif mysql # CAST syntax: SIGNED type: DECIMAL type: 
query IIIIIII rowsort label-70
SELECT * FROM tab1 AS cor0 WHERE col4 * + col1 + - col3 + - 64 + - col4 BETWEEN col1 + + - CAST( + - col4 AS DECIMAL ) AND - - CAST( NULL AS SIGNED )
----

skipif mysql # not compatible
query IIIIIII rowsort label-70
SELECT * FROM tab1 AS cor0 WHERE col4 * + col1 + - col3 + - 64 + - col4 BETWEEN col1 + + - CAST ( + - col4 AS REAL ) AND - - CAST ( NULL AS INTEGER )
----

onlyif mysql # CAST syntax: SIGNED type: DECIMAL type: 
query IIIIIII rowsort label-70
SELECT * FROM tab2 AS cor0 WHERE col4 * + col1 + - col3 + - 64 + - col4 BETWEEN col1 + + - CAST( + - col4 AS DECIMAL ) AND - - CAST( NULL AS SIGNED )
----

skipif mysql # not compatible
query IIIIIII rowsort label-70
SELECT * FROM tab2 AS cor0 WHERE col4 * + col1 + - col3 + - 64 + - col4 BETWEEN col1 + + - CAST ( + - col4 AS REAL ) AND - - CAST ( NULL AS INTEGER )
----

onlyif mysql # CAST syntax: SIGNED type: DECIMAL type: 
query IIIIIII rowsort label-70
SELECT * FROM tab3 AS cor0 WHERE col4 * + col1 + - col3 + - 64 + - col4 BETWEEN col1 + + - CAST( + - col4 AS DECIMAL ) AND - - CAST( NULL AS SIGNED )
----

skipif mysql # not compatible
query IIIIIII rowsort label-70
SELECT * FROM tab3 AS cor0 WHERE col4 * + col1 + - col3 + - 64 + - col4 BETWEEN col1 + + - CAST ( + - col4 AS REAL ) AND - - CAST ( NULL AS INTEGER )
----

onlyif mysql # CAST syntax: SIGNED type: DECIMAL type: 
query IIIIIII rowsort label-70
SELECT * FROM tab4 AS cor0 WHERE col4 * + col1 + - col3 + - 64 + - col4 BETWEEN col1 + + - CAST( + - col4 AS DECIMAL ) AND - - CAST( NULL AS SIGNED )
----

skipif mysql # not compatible
query IIIIIII rowsort label-70
SELECT * FROM tab4 AS cor0 WHERE col4 * + col1 + - col3 + - 64 + - col4 BETWEEN col1 + + - CAST ( + - col4 AS REAL ) AND - - CAST ( NULL AS INTEGER )
----

query I rowsort label-75
SELECT ALL - col3 AS col4 FROM tab0 WHERE + col4 + + + col3 IS NULL
----

query I rowsort label-75
SELECT ALL - col3 AS col4 FROM tab1 WHERE + col4 + + + col3 IS NULL
----

query I rowsort label-75
SELECT ALL - col3 AS col4 FROM tab2 WHERE + col4 + + + col3 IS NULL
----

query I rowsort label-75
SELECT ALL - col3 AS col4 FROM tab3 WHERE + col4 + + + col3 IS NULL
----

query I rowsort label-75
SELECT ALL - col3 AS col4 FROM tab4 WHERE + col4 + + + col3 IS NULL
----

query IIIIIII rowsort label-80
SELECT ALL * FROM tab0 AS cor0 WHERE NULL IS NOT NULL
----

query IIIIIII rowsort label-80
SELECT ALL * FROM tab1 AS cor0 WHERE NULL IS NOT NULL
----

query IIIIIII rowsort label-80
SELECT ALL * FROM tab2 AS cor0 WHERE NULL IS NOT NULL
----

query IIIIIII rowsort label-80
SELECT ALL * FROM tab3 AS cor0 WHERE NULL IS NOT NULL
----

query IIIIIII rowsort label-80
SELECT ALL * FROM tab4 AS cor0 WHERE NULL IS NOT NULL
----

query IIIIIII rowsort label-85
SELECT ALL * FROM tab0 cor0 WHERE 61 IS NULL
----

query IIIIIII rowsort label-85
SELECT ALL * FROM tab1 cor0 WHERE 61 IS NULL
----

query IIIIIII rowsort label-85
SELECT ALL * FROM tab2 cor0 WHERE 61 IS NULL
----

query IIIIIII rowsort label-85
SELECT ALL * FROM tab3 cor0 WHERE 61 IS NULL
----

query IIIIIII rowsort label-85
SELECT ALL * FROM tab4 cor0 WHERE 61 IS NULL
----

query I rowsort label-90
SELECT DISTINCT 17 FROM tab0 AS cor0 WHERE NULL IS NOT NULL
----

query I rowsort label-90
SELECT DISTINCT 17 FROM tab1 AS cor0 WHERE NULL IS NOT NULL
----

query I rowsort label-90
SELECT DISTINCT 17 FROM tab2 AS cor0 WHERE NULL IS NOT NULL
----

query I rowsort label-90
SELECT DISTINCT 17 FROM tab3 AS cor0 WHERE NULL IS NOT NULL
----

query I rowsort label-90
SELECT DISTINCT 17 FROM tab4 AS cor0 WHERE NULL IS NOT NULL
----

onlyif mysql # CAST syntax: SIGNED type: 
query IIIIIII rowsort label-95
SELECT ALL * FROM tab0 WHERE NOT - col0 + + CAST( NULL AS SIGNED ) IS NULL
----

skipif mysql # not compatible
query IIIIIII rowsort label-95
SELECT ALL * FROM tab0 WHERE NOT - col0 + + CAST ( NULL AS INTEGER ) IS NULL
----

onlyif mysql # CAST syntax: SIGNED type: 
query IIIIIII rowsort label-95
SELECT ALL * FROM tab1 WHERE NOT - col0 + + CAST( NULL AS SIGNED ) IS NULL
----

skipif mysql # not compatible
query IIIIIII rowsort label-95
SELECT ALL * FROM tab1 WHERE NOT - col0 + + CAST ( NULL AS INTEGER ) IS NULL
----

onlyif mysql # CAST syntax: SIGNED type: 
query IIIIIII rowsort label-95
SELECT ALL * FROM tab2 WHERE NOT - col0 + + CAST( NULL AS SIGNED ) IS NULL
----

skipif mysql # not compatible
query IIIIIII rowsort label-95
SELECT ALL * FROM tab2 WHERE NOT - col0 + + CAST ( NULL AS INTEGER ) IS NULL
----

onlyif mysql # CAST syntax: SIGNED type: 
query IIIIIII rowsort label-95
SELECT ALL * FROM tab3 WHERE NOT - col0 + + CAST( NULL AS SIGNED ) IS NULL
----

skipif mysql # not compatible
query IIIIIII rowsort label-95
SELECT ALL * FROM tab3 WHERE NOT - col0 + + CAST ( NULL AS INTEGER ) IS NULL
----

onlyif mysql # CAST syntax: SIGNED type: 
query IIIIIII rowsort label-95
SELECT ALL * FROM tab4 WHERE NOT - col0 + + CAST( NULL AS SIGNED ) IS NULL
----

skipif mysql # not compatible
query IIIIIII rowsort label-95
SELECT ALL * FROM tab4 WHERE NOT - col0 + + CAST ( NULL AS INTEGER ) IS NULL
----

query IIIIIII rowsort label-100
SELECT ALL * FROM tab0 WHERE NOT + + col2 IS NOT NULL
----

query IIIIIII rowsort label-100
SELECT ALL * FROM tab1 WHERE NOT + + col2 IS NOT NULL
----

query IIIIIII rowsort label-100
SELECT ALL * FROM tab2 WHERE NOT + + col2 IS NOT NULL
----

query IIIIIII rowsort label-100
SELECT ALL * FROM tab3 WHERE NOT + + col2 IS NOT NULL
----

query IIIIIII rowsort label-100
SELECT ALL * FROM tab4 WHERE NOT + + col2 IS NOT NULL
----

query IIIIIII rowsort label-105
SELECT * FROM tab0 AS cor0 WHERE NOT 16 + - col0 IS NOT NULL
----

query IIIIIII rowsort label-105
SELECT * FROM tab1 AS cor0 WHERE NOT 16 + - col0 IS NOT NULL
----

query IIIIIII rowsort label-105
SELECT * FROM tab2 AS cor0 WHERE NOT 16 + - col0 IS NOT NULL
----

query IIIIIII rowsort label-105
SELECT * FROM tab3 AS cor0 WHERE NOT 16 + - col0 IS NOT NULL
----

query IIIIIII rowsort label-105
SELECT * FROM tab4 AS cor0 WHERE NOT 16 + - col0 IS NOT NULL
----

query IIIIIII rowsort label-110
SELECT * FROM tab0 WHERE NOT NULL IS NULL
----

query IIIIIII rowsort label-110
SELECT * FROM tab1 WHERE NOT NULL IS NULL
----

query IIIIIII rowsort label-110
SELECT * FROM tab2 WHERE NOT NULL IS NULL
----

query IIIIIII rowsort label-110
SELECT * FROM tab3 WHERE NOT NULL IS NULL
----

query IIIIIII rowsort label-110
SELECT * FROM tab4 WHERE NOT NULL IS NULL
----

query I rowsort label-115
SELECT ALL 42 AS col5 FROM tab0 AS cor0 WHERE NOT NULL IS NOT NULL
----
1000 values hashing to ddd8ee475564698dfe4e1e17f62fc7a8

query I rowsort label-115
SELECT ALL 42 AS col5 FROM tab1 AS cor0 WHERE NOT NULL IS NOT NULL
----
1000 values hashing to ddd8ee475564698dfe4e1e17f62fc7a8

query I rowsort label-115
SELECT ALL 42 AS col5 FROM tab2 AS cor0 WHERE NOT NULL IS NOT NULL
----
1000 values hashing to ddd8ee475564698dfe4e1e17f62fc7a8

query I rowsort label-115
SELECT ALL 42 AS col5 FROM tab3 AS cor0 WHERE NOT NULL IS NOT NULL
----
1000 values hashing to ddd8ee475564698dfe4e1e17f62fc7a8

query I rowsort label-115
SELECT ALL 42 AS col5 FROM tab4 AS cor0 WHERE NOT NULL IS NOT NULL
----
1000 values hashing to ddd8ee475564698dfe4e1e17f62fc7a8

query I rowsort label-120
SELECT + 62 FROM tab0 AS cor0 WHERE NULL <> NULL
----

query I rowsort label-120
SELECT + 62 FROM tab1 AS cor0 WHERE NULL <> NULL
----

query I rowsort label-120
SELECT + 62 FROM tab2 AS cor0 WHERE NULL <> NULL
----

query I rowsort label-120
SELECT + 62 FROM tab3 AS cor0 WHERE NULL <> NULL
----

query I rowsort label-120
SELECT + 62 FROM tab4 AS cor0 WHERE NULL <> NULL
----

query I rowsort label-125
SELECT DISTINCT + col3 FROM tab0 WHERE NULL IS NOT NULL
----

query I rowsort label-125
SELECT DISTINCT + col3 FROM tab1 WHERE NULL IS NOT NULL
----

query I rowsort label-125
SELECT DISTINCT + col3 FROM tab2 WHERE NULL IS NOT NULL
----

query I rowsort label-125
SELECT DISTINCT + col3 FROM tab3 WHERE NULL IS NOT NULL
----

query I rowsort label-125
SELECT DISTINCT + col3 FROM tab4 WHERE NULL IS NOT NULL
----

query IIIIIII rowsort label-130
SELECT * FROM tab0 WHERE NOT col2 IS NOT NULL
----

query IIIIIII rowsort label-130
SELECT * FROM tab1 WHERE NOT col2 IS NOT NULL
----

query IIIIIII rowsort label-130
SELECT * FROM tab2 WHERE NOT col2 IS NOT NULL
----

query IIIIIII rowsort label-130
SELECT * FROM tab3 WHERE NOT col2 IS NOT NULL
----

query IIIIIII rowsort label-130
SELECT * FROM tab4 WHERE NOT col2 IS NOT NULL
----

query IIIIIII rowsort label-135
SELECT * FROM tab0 cor0 WHERE NOT col5 IS NOT NULL
----

query IIIIIII rowsort label-135
SELECT * FROM tab1 cor0 WHERE NOT col5 IS NOT NULL
----

query IIIIIII rowsort label-135
SELECT * FROM tab2 cor0 WHERE NOT col5 IS NOT NULL
----

query IIIIIII rowsort label-135
SELECT * FROM tab3 cor0 WHERE NOT col5 IS NOT NULL
----

query IIIIIII rowsort label-135
SELECT * FROM tab4 cor0 WHERE NOT col5 IS NOT NULL
----

query IIIIIII rowsort label-140
SELECT * FROM tab0 AS cor0 WHERE NOT 75 * + col4 NOT BETWEEN - col0 * + - col4 AND NULL
----

query IIIIIII rowsort label-140
SELECT * FROM tab1 AS cor0 WHERE NOT 75 * + col4 NOT BETWEEN - col0 * + - col4 AND NULL
----

query IIIIIII rowsort label-140
SELECT * FROM tab2 AS cor0 WHERE NOT 75 * + col4 NOT BETWEEN - col0 * + - col4 AND NULL
----

query IIIIIII rowsort label-140
SELECT * FROM tab3 AS cor0 WHERE NOT 75 * + col4 NOT BETWEEN - col0 * + - col4 AND NULL
----

query IIIIIII rowsort label-140
SELECT * FROM tab4 AS cor0 WHERE NOT 75 * + col4 NOT BETWEEN - col0 * + - col4 AND NULL
----

onlyif mysql # CAST syntax: DECIMAL type: 
query I rowsort label-145
SELECT ALL - - CAST( + ( col1 ) AS DECIMAL ) * + + 79 col3 FROM tab0 AS cor0 WHERE - col4 = NULL
----

skipif mysql # not compatible
skipif postgresql # PostgreSQL requires AS when renaming output columns
query I rowsort label-145
SELECT ALL - - CAST ( + ( col1 ) AS REAL ) * + + 79 col3 FROM tab0 AS cor0 WHERE - col4 = NULL
----

onlyif mysql # CAST syntax: DECIMAL type: 
query I rowsort label-145
SELECT ALL - - CAST( + ( col1 ) AS DECIMAL ) * + + 79 col3 FROM tab1 AS cor0 WHERE - col4 = NULL
----

skipif mysql # not compatible
skipif postgresql # PostgreSQL requires AS when renaming output columns
query I rowsort label-145
SELECT ALL - - CAST ( + ( col1 ) AS REAL ) * + + 79 col3 FROM tab1 AS cor0 WHERE - col4 = NULL
----

onlyif mysql # CAST syntax: DECIMAL type: 
query I rowsort label-145
SELECT ALL - - CAST( + ( col1 ) AS DECIMAL ) * + + 79 col3 FROM tab2 AS cor0 WHERE - col4 = NULL
----

skipif mysql # not compatible
skipif postgresql # PostgreSQL requires AS when renaming output columns
query I rowsort label-145
SELECT ALL - - CAST ( + ( col1 ) AS REAL ) * + + 79 col3 FROM tab2 AS cor0 WHERE - col4 = NULL
----

onlyif mysql # CAST syntax: DECIMAL type: 
query I rowsort label-145
SELECT ALL - - CAST( + ( col1 ) AS DECIMAL ) * + + 79 col3 FROM tab3 AS cor0 WHERE - col4 = NULL
----

skipif mysql # not compatible
skipif postgresql # PostgreSQL requires AS when renaming output columns
query I rowsort label-145
SELECT ALL - - CAST ( + ( col1 ) AS REAL ) * + + 79 col3 FROM tab3 AS cor0 WHERE - col4 = NULL
----

onlyif mysql # CAST syntax: DECIMAL type: 
query I rowsort label-145
SELECT ALL - - CAST( + ( col1 ) AS DECIMAL ) * + + 79 col3 FROM tab4 AS cor0 WHERE - col4 = NULL
----

skipif mysql # not compatible
skipif postgresql # PostgreSQL requires AS when renaming output columns
query I rowsort label-145
SELECT ALL - - CAST ( + ( col1 ) AS REAL ) * + + 79 col3 FROM tab4 AS cor0 WHERE - col4 = NULL
----

skipif postgresql # PostgreSQL requires AS when renaming output columns
query I rowsort label-150
SELECT - 57 col4 FROM tab0 AS cor0 WHERE + col0 < NULL
----

skipif postgresql # PostgreSQL requires AS when renaming output columns
query I rowsort label-150
SELECT - 57 col4 FROM tab1 AS cor0 WHERE + col0 < NULL
----

skipif postgresql # PostgreSQL requires AS when renaming output columns
query I rowsort label-150
SELECT - 57 col4 FROM tab2 AS cor0 WHERE + col0 < NULL
----

skipif postgresql # PostgreSQL requires AS when renaming output columns
query I rowsort label-150
SELECT - 57 col4 FROM tab3 AS cor0 WHERE + col0 < NULL
----

skipif postgresql # PostgreSQL requires AS when renaming output columns
query I rowsort label-150
SELECT - 57 col4 FROM tab4 AS cor0 WHERE + col0 < NULL
----

query I rowsort label-155
SELECT col2 FROM tab0 cor0 WHERE col4 = - - 37 + - col3 + - + col3
----

query I rowsort label-155
SELECT col2 FROM tab1 cor0 WHERE col4 = - - 37 + - col3 + - + col3
----

query I rowsort label-155
SELECT col2 FROM tab2 cor0 WHERE col4 = - - 37 + - col3 + - + col3
----

query I rowsort label-155
SELECT col2 FROM tab3 cor0 WHERE col4 = - - 37 + - col3 + - + col3
----

query I rowsort label-155
SELECT col2 FROM tab4 cor0 WHERE col4 = - - 37 + - col3 + - + col3
----

query IIIIIII rowsort label-160
SELECT ALL * FROM tab0 AS cor0 WHERE NOT NULL = col3 * - - 87
----

query IIIIIII rowsort label-160
SELECT ALL * FROM tab1 AS cor0 WHERE NOT NULL = col3 * - - 87
----

query IIIIIII rowsort label-160
SELECT ALL * FROM tab2 AS cor0 WHERE NOT NULL = col3 * - - 87
----

query IIIIIII rowsort label-160
SELECT ALL * FROM tab3 AS cor0 WHERE NOT NULL = col3 * - - 87
----

query IIIIIII rowsort label-160
SELECT ALL * FROM tab4 AS cor0 WHERE NOT NULL = col3 * - - 87
----

query I rowsort label-165
SELECT DISTINCT - - col0 AS col0 FROM tab0 AS cor0 WHERE NOT + col4 = - - 82
----
1000 values hashing to 246e64dff83b87422885732f0ed3966f

query I rowsort label-165
SELECT DISTINCT - - col0 AS col0 FROM tab1 AS cor0 WHERE NOT + col4 = - - 82
----
1000 values hashing to 246e64dff83b87422885732f0ed3966f

query I rowsort label-165
SELECT DISTINCT - - col0 AS col0 FROM tab2 AS cor0 WHERE NOT + col4 = - - 82
----
1000 values hashing to 246e64dff83b87422885732f0ed3966f

query I rowsort label-165
SELECT DISTINCT - - col0 AS col0 FROM tab3 AS cor0 WHERE NOT + col4 = - - 82
----
1000 values hashing to 246e64dff83b87422885732f0ed3966f

query I rowsort label-165
SELECT DISTINCT - - col0 AS col0 FROM tab4 AS cor0 WHERE NOT + col4 = - - 82
----
1000 values hashing to 246e64dff83b87422885732f0ed3966f

query IIIIIII rowsort label-170
SELECT ALL * FROM tab0 AS cor0 WHERE NOT - col1 < NULL
----

query IIIIIII rowsort label-170
SELECT ALL * FROM tab1 AS cor0 WHERE NOT - col1 < NULL
----

query IIIIIII rowsort label-170
SELECT ALL * FROM tab2 AS cor0 WHERE NOT - col1 < NULL
----

query IIIIIII rowsort label-170
SELECT ALL * FROM tab3 AS cor0 WHERE NOT - col1 < NULL
----

query IIIIIII rowsort label-170
SELECT ALL * FROM tab4 AS cor0 WHERE NOT - col1 < NULL
----

query I rowsort label-175
SELECT + col3 FROM tab0 WHERE NULL IS NULL
----
1000 values hashing to bfdd2bba6492501de7f490ea210e31cc

query I rowsort label-175
SELECT + col3 FROM tab1 WHERE NULL IS NULL
----
1000 values hashing to bfdd2bba6492501de7f490ea210e31cc

query I rowsort label-175
SELECT + col3 FROM tab2 WHERE NULL IS NULL
----
1000 values hashing to bfdd2bba6492501de7f490ea210e31cc

query I rowsort label-175
SELECT + col3 FROM tab3 WHERE NULL IS NULL
----
1000 values hashing to bfdd2bba6492501de7f490ea210e31cc

query I rowsort label-175
SELECT + col3 FROM tab4 WHERE NULL IS NULL
----
1000 values hashing to bfdd2bba6492501de7f490ea210e31cc

query IIIIIII rowsort label-180
SELECT * FROM tab0 WHERE NOT - + col4 + + 63 + + col4 IS NOT NULL
----

query IIIIIII rowsort label-180
SELECT * FROM tab1 WHERE NOT - + col4 + + 63 + + col4 IS NOT NULL
----

query IIIIIII rowsort label-180
SELECT * FROM tab2 WHERE NOT - + col4 + + 63 + + col4 IS NOT NULL
----

query IIIIIII rowsort label-180
SELECT * FROM tab3 WHERE NOT - + col4 + + 63 + + col4 IS NOT NULL
----

query IIIIIII rowsort label-180
SELECT * FROM tab4 WHERE NOT - + col4 + + 63 + + col4 IS NOT NULL
----

onlyif mysql # aggregate syntax: 
query I rowsort label-185
SELECT COUNT( * ) FROM tab0 cor0 WHERE NOT NULL IS NULL
----
0

skipif mysql # not compatible
query I rowsort label-185
SELECT COUNT ( * ) FROM tab0 cor0 WHERE NOT NULL IS NULL
----
0

onlyif mysql # aggregate syntax: 
query I rowsort label-185
SELECT COUNT( * ) FROM tab1 cor0 WHERE NOT NULL IS NULL
----
0

skipif mysql # not compatible
query I rowsort label-185
SELECT COUNT ( * ) FROM tab1 cor0 WHERE NOT NULL IS NULL
----
0

onlyif mysql # aggregate syntax: 
query I rowsort label-185
SELECT COUNT( * ) FROM tab2 cor0 WHERE NOT NULL IS NULL
----
0

skipif mysql # not compatible
query I rowsort label-185
SELECT COUNT ( * ) FROM tab2 cor0 WHERE NOT NULL IS NULL
----
0

onlyif mysql # aggregate syntax: 
query I rowsort label-185
SELECT COUNT( * ) FROM tab3 cor0 WHERE NOT NULL IS NULL
----
0

skipif mysql # not compatible
query I rowsort label-185
SELECT COUNT ( * ) FROM tab3 cor0 WHERE NOT NULL IS NULL
----
0

onlyif mysql # aggregate syntax: 
query I rowsort label-185
SELECT COUNT( * ) FROM tab4 cor0 WHERE NOT NULL IS NULL
----
0

skipif mysql # not compatible
query I rowsort label-185
SELECT COUNT ( * ) FROM tab4 cor0 WHERE NOT NULL IS NULL
----
0

query I rowsort label-190
SELECT DISTINCT 49 FROM tab0, tab0 AS cor0 WHERE NOT + 35 IS NOT NULL
----

query I rowsort label-190
SELECT DISTINCT 49 FROM tab1, tab1 AS cor0 WHERE NOT + 35 IS NOT NULL
----

query I rowsort label-190
SELECT DISTINCT 49 FROM tab2, tab2 AS cor0 WHERE NOT + 35 IS NOT NULL
----

query I rowsort label-190
SELECT DISTINCT 49 FROM tab3, tab3 AS cor0 WHERE NOT + 35 IS NOT NULL
----

query I rowsort label-190
SELECT DISTINCT 49 FROM tab4, tab4 AS cor0 WHERE NOT + 35 IS NOT NULL
----

onlyif mysql # aggregate syntax: 
query I rowsort label-195
SELECT DISTINCT + - 53 + + COUNT( * ) FROM tab0 AS cor0 WHERE col2 IS NOT NULL
----
947

skipif mysql # not compatible
query I rowsort label-195
SELECT DISTINCT + - 53 + + COUNT ( * ) FROM tab0 AS cor0 WHERE col2 IS NOT NULL
----
947

onlyif mysql # aggregate syntax: 
query I rowsort label-195
SELECT DISTINCT + - 53 + + COUNT( * ) FROM tab1 AS cor0 WHERE col2 IS NOT NULL
----
947

skipif mysql # not compatible
query I rowsort label-195
SELECT DISTINCT + - 53 + + COUNT ( * ) FROM tab1 AS cor0 WHERE col2 IS NOT NULL
----
947

onlyif mysql # aggregate syntax: 
query I rowsort label-195
SELECT DISTINCT + - 53 + + COUNT( * ) FROM tab2 AS cor0 WHERE col2 IS NOT NULL
----
947

skipif mysql # not compatible
query I rowsort label-195
SELECT DISTINCT + - 53 + + COUNT ( * ) FROM tab2 AS cor0 WHERE col2 IS NOT NULL
----
947

onlyif mysql # aggregate syntax: 
query I rowsort label-195
SELECT DISTINCT + - 53 + + COUNT( * ) FROM tab3 AS cor0 WHERE col2 IS NOT NULL
----
947

skipif mysql # not compatible
query I rowsort label-195
SELECT DISTINCT + - 53 + + COUNT ( * ) FROM tab3 AS cor0 WHERE col2 IS NOT NULL
----
947

onlyif mysql # aggregate syntax: 
query I rowsort label-195
SELECT DISTINCT + - 53 + + COUNT( * ) FROM tab4 AS cor0 WHERE col2 IS NOT NULL
----
947

skipif mysql # not compatible
query I rowsort label-195
SELECT DISTINCT + - 53 + + COUNT ( * ) FROM tab4 AS cor0 WHERE col2 IS NOT NULL
----
947

onlyif mysql # aggregate syntax: 
query I rowsort label-200
SELECT - COUNT( + col1 ) AS col4 FROM tab0 AS cor0 WHERE NOT NULL BETWEEN ( NULL ) AND 39
----
0

skipif mysql # not compatible
query I rowsort label-200
SELECT - COUNT ( + col1 ) AS col4 FROM tab0 AS cor0 WHERE NOT NULL BETWEEN ( NULL ) AND 39
----
0

onlyif mysql # aggregate syntax: 
query I rowsort label-200
SELECT - COUNT( + col1 ) AS col4 FROM tab1 AS cor0 WHERE NOT NULL BETWEEN ( NULL ) AND 39
----
0

skipif mysql # not compatible
query I rowsort label-200
SELECT - COUNT ( + col1 ) AS col4 FROM tab1 AS cor0 WHERE NOT NULL BETWEEN ( NULL ) AND 39
----
0

onlyif mysql # aggregate syntax: 
query I rowsort label-200
SELECT - COUNT( + col1 ) AS col4 FROM tab2 AS cor0 WHERE NOT NULL BETWEEN ( NULL ) AND 39
----
0

skipif mysql # not compatible
query I rowsort label-200
SELECT - COUNT ( + col1 ) AS col4 FROM tab2 AS cor0 WHERE NOT NULL BETWEEN ( NULL ) AND 39
----
0

onlyif mysql # aggregate syntax: 
query I rowsort label-200
SELECT - COUNT( + col1 ) AS col4 FROM tab3 AS cor0 WHERE NOT NULL BETWEEN ( NULL ) AND 39
----
0

skipif mysql # not compatible
query I rowsort label-200
SELECT - COUNT ( + col1 ) AS col4 FROM tab3 AS cor0 WHERE NOT NULL BETWEEN ( NULL ) AND 39
----
0

onlyif mysql # aggregate syntax: 
query I rowsort label-200
SELECT - COUNT( + col1 ) AS col4 FROM tab4 AS cor0 WHERE NOT NULL BETWEEN ( NULL ) AND 39
----
0

skipif mysql # not compatible
query I rowsort label-200
SELECT - COUNT ( + col1 ) AS col4 FROM tab4 AS cor0 WHERE NOT NULL BETWEEN ( NULL ) AND 39
----
0

query IIIIIII rowsort label-205
SELECT * FROM tab0 WHERE NULL <> NULL
----

query IIIIIII rowsort label-205
SELECT * FROM tab1 WHERE NULL <> NULL
----

query IIIIIII rowsort label-205
SELECT * FROM tab2 WHERE NULL <> NULL
----

query IIIIIII rowsort label-205
SELECT * FROM tab3 WHERE NULL <> NULL
----

query IIIIIII rowsort label-205
SELECT * FROM tab4 WHERE NULL <> NULL
----

onlyif mysql # CAST syntax: SIGNED type: 
query I rowsort label-210
SELECT ALL - col0 * - CAST( NULL AS SIGNED ) AS col5 FROM tab0 WHERE - 72 NOT BETWEEN 37 AND NULL
----
1000 values hashing to 934e0694199f84c934e83e05849aa6f0

skipif mysql # not compatible
query I rowsort label-210
SELECT ALL - col0 * - CAST ( NULL AS INTEGER ) AS col5 FROM tab0 WHERE - 72 NOT BETWEEN 37 AND NULL
----
1000 values hashing to 934e0694199f84c934e83e05849aa6f0

onlyif mysql # CAST syntax: SIGNED type: 
query I rowsort label-210
SELECT ALL - col0 * - CAST( NULL AS SIGNED ) AS col5 FROM tab1 WHERE - 72 NOT BETWEEN 37 AND NULL
----
1000 values hashing to 934e0694199f84c934e83e05849aa6f0

skipif mysql # not compatible
query I rowsort label-210
SELECT ALL - col0 * - CAST ( NULL AS INTEGER ) AS col5 FROM tab1 WHERE - 72 NOT BETWEEN 37 AND NULL
----
1000 values hashing to 934e0694199f84c934e83e05849aa6f0

onlyif mysql # CAST syntax: SIGNED type: 
query I rowsort label-210
SELECT ALL - col0 * - CAST( NULL AS SIGNED ) AS col5 FROM tab2 WHERE - 72 NOT BETWEEN 37 AND NULL
----
1000 values hashing to 934e0694199f84c934e83e05849aa6f0

skipif mysql # not compatible
query I rowsort label-210
SELECT ALL - col0 * - CAST ( NULL AS INTEGER ) AS col5 FROM tab2 WHERE - 72 NOT BETWEEN 37 AND NULL
----
1000 values hashing to 934e0694199f84c934e83e05849aa6f0

onlyif mysql # CAST syntax: SIGNED type: 
query I rowsort label-210
SELECT ALL - col0 * - CAST( NULL AS SIGNED ) AS col5 FROM tab3 WHERE - 72 NOT BETWEEN 37 AND NULL
----
1000 values hashing to 934e0694199f84c934e83e05849aa6f0

skipif mysql # not compatible
query I rowsort label-210
SELECT ALL - col0 * - CAST ( NULL AS INTEGER ) AS col5 FROM tab3 WHERE - 72 NOT BETWEEN 37 AND NULL
----
1000 values hashing to 934e0694199f84c934e83e05849aa6f0

onlyif mysql # CAST syntax: SIGNED type: 
query I rowsort label-210
SELECT ALL - col0 * - CAST( NULL AS SIGNED ) AS col5 FROM tab4 WHERE - 72 NOT BETWEEN 37 AND NULL
----
1000 values hashing to 934e0694199f84c934e83e05849aa6f0

skipif mysql # not compatible
query I rowsort label-210
SELECT ALL - col0 * - CAST ( NULL AS INTEGER ) AS col5 FROM tab4 WHERE - 72 NOT BETWEEN 37 AND NULL
----
1000 values hashing to 934e0694199f84c934e83e05849aa6f0

onlyif mysql # CAST syntax: SIGNED type: 
query I rowsort label-215
SELECT + 91 * 61 FROM tab0 WHERE ( + - CAST( NULL AS SIGNED ) ) IS NOT NULL
----

skipif mysql # not compatible
query I rowsort label-215
SELECT + 91 * 61 FROM tab0 WHERE ( + - CAST ( NULL AS INTEGER ) ) IS NOT NULL
----

onlyif mysql # CAST syntax: SIGNED type: 
query I rowsort label-215
SELECT + 91 * 61 FROM tab1 WHERE ( + - CAST( NULL AS SIGNED ) ) IS NOT NULL
----

skipif mysql # not compatible
query I rowsort label-215
SELECT + 91 * 61 FROM tab1 WHERE ( + - CAST ( NULL AS INTEGER ) ) IS NOT NULL
----

onlyif mysql # CAST syntax: SIGNED type: 
query I rowsort label-215
SELECT + 91 * 61 FROM tab2 WHERE ( + - CAST( NULL AS SIGNED ) ) IS NOT NULL
----

skipif mysql # not compatible
query I rowsort label-215
SELECT + 91 * 61 FROM tab2 WHERE ( + - CAST ( NULL AS INTEGER ) ) IS NOT NULL
----

onlyif mysql # CAST syntax: SIGNED type: 
query I rowsort label-215
SELECT + 91 * 61 FROM tab3 WHERE ( + - CAST( NULL AS SIGNED ) ) IS NOT NULL
----

skipif mysql # not compatible
query I rowsort label-215
SELECT + 91 * 61 FROM tab3 WHERE ( + - CAST ( NULL AS INTEGER ) ) IS NOT NULL
----

onlyif mysql # CAST syntax: SIGNED type: 
query I rowsort label-215
SELECT + 91 * 61 FROM tab4 WHERE ( + - CAST( NULL AS SIGNED ) ) IS NOT NULL
----

skipif mysql # not compatible
query I rowsort label-215
SELECT + 91 * 61 FROM tab4 WHERE ( + - CAST ( NULL AS INTEGER ) ) IS NOT NULL
----

skipif postgresql # PostgreSQL requires AS when renaming output columns
query I rowsort label-220
SELECT ALL col5 col0 FROM tab0 WHERE + col3 IS NOT NULL
----
1000 values hashing to 2ed57cb9c408b954ec52c7a2da59153d

skipif postgresql # PostgreSQL requires AS when renaming output columns
query I rowsort label-220
SELECT ALL col5 col0 FROM tab1 WHERE + col3 IS NOT NULL
----
1000 values hashing to 2ed57cb9c408b954ec52c7a2da59153d

skipif postgresql # PostgreSQL requires AS when renaming output columns
query I rowsort label-220
SELECT ALL col5 col0 FROM tab2 WHERE + col3 IS NOT NULL
----
1000 values hashing to 2ed57cb9c408b954ec52c7a2da59153d

skipif postgresql # PostgreSQL requires AS when renaming output columns
query I rowsort label-220
SELECT ALL col5 col0 FROM tab3 WHERE + col3 IS NOT NULL
----
1000 values hashing to 2ed57cb9c408b954ec52c7a2da59153d

skipif postgresql # PostgreSQL requires AS when renaming output columns
query I rowsort label-220
SELECT ALL col5 col0 FROM tab4 WHERE + col3 IS NOT NULL
----
1000 values hashing to 2ed57cb9c408b954ec52c7a2da59153d

onlyif mysql # CAST syntax: SIGNED type: 
query IIIIIII rowsort label-225
SELECT ALL * FROM tab0 cor0 WHERE NULL > + CAST( + 32 AS SIGNED )
----

skipif mysql # not compatible
query IIIIIII rowsort label-225
SELECT ALL * FROM tab0 cor0 WHERE NULL > + CAST ( + 32 AS INTEGER )
----

onlyif mysql # CAST syntax: SIGNED type: 
query IIIIIII rowsort label-225
SELECT ALL * FROM tab1 cor0 WHERE NULL > + CAST( + 32 AS SIGNED )
----

skipif mysql # not compatible
query IIIIIII rowsort label-225
SELECT ALL * FROM tab1 cor0 WHERE NULL > + CAST ( + 32 AS INTEGER )
----

onlyif mysql # CAST syntax: SIGNED type: 
query IIIIIII rowsort label-225
SELECT ALL * FROM tab2 cor0 WHERE NULL > + CAST( + 32 AS SIGNED )
----

skipif mysql # not compatible
query IIIIIII rowsort label-225
SELECT ALL * FROM tab2 cor0 WHERE NULL > + CAST ( + 32 AS INTEGER )
----

onlyif mysql # CAST syntax: SIGNED type: 
query IIIIIII rowsort label-225
SELECT ALL * FROM tab3 cor0 WHERE NULL > + CAST( + 32 AS SIGNED )
----

skipif mysql # not compatible
query IIIIIII rowsort label-225
SELECT ALL * FROM tab3 cor0 WHERE NULL > + CAST ( + 32 AS INTEGER )
----

onlyif mysql # CAST syntax: SIGNED type: 
query IIIIIII rowsort label-225
SELECT ALL * FROM tab4 cor0 WHERE NULL > + CAST( + 32 AS SIGNED )
----

skipif mysql # not compatible
query IIIIIII rowsort label-225
SELECT ALL * FROM tab4 cor0 WHERE NULL > + CAST ( + 32 AS INTEGER )
----

skipif postgresql # PostgreSQL requires AS when renaming output columns
query I rowsort label-230
SELECT + - ( - ( - col0 ) ) / - - ( + col1 ) + - - 98 + - 83 col5 FROM tab0 AS cor0 WHERE NOT ( NULL >= + + 31 )
----

skipif postgresql # PostgreSQL requires AS when renaming output columns
query I rowsort label-230
SELECT + - ( - ( - col0 ) ) / - - ( + col1 ) + - - 98 + - 83 col5 FROM tab1 AS cor0 WHERE NOT ( NULL >= + + 31 )
----

skipif postgresql # PostgreSQL requires AS when renaming output columns
query I rowsort label-230
SELECT + - ( - ( - col0 ) ) / - - ( + col1 ) + - - 98 + - 83 col5 FROM tab2 AS cor0 WHERE NOT ( NULL >= + + 31 )
----

skipif postgresql # PostgreSQL requires AS when renaming output columns
query I rowsort label-230
SELECT + - ( - ( - col0 ) ) / - - ( + col1 ) + - - 98 + - 83 col5 FROM tab3 AS cor0 WHERE NOT ( NULL >= + + 31 )
----

skipif postgresql # PostgreSQL requires AS when renaming output columns
query I rowsort label-230
SELECT + - ( - ( - col0 ) ) / - - ( + col1 ) + - - 98 + - 83 col5 FROM tab4 AS cor0 WHERE NOT ( NULL >= + + 31 )
----

query IIIIIII rowsort label-235
SELECT * FROM tab0 AS cor0 WHERE NOT ( NOT col3 * 84 IS NULL )
----

query IIIIIII rowsort label-235
SELECT * FROM tab1 AS cor0 WHERE NOT ( NOT col3 * 84 IS NULL )
----

query IIIIIII rowsort label-235
SELECT * FROM tab2 AS cor0 WHERE NOT ( NOT col3 * 84 IS NULL )
----

query IIIIIII rowsort label-235
SELECT * FROM tab3 AS cor0 WHERE NOT ( NOT col3 * 84 IS NULL )
----

query IIIIIII rowsort label-235
SELECT * FROM tab4 AS cor0 WHERE NOT ( NOT col3 * 84 IS NULL )
----

onlyif mysql # aggregate syntax: 
query I rowsort label-240
SELECT + - COUNT( * ) AS col4 FROM tab0 cor0 WHERE 12 = + col0 / - + col0 * - col1 * + 75
----
0

skipif mysql # not compatible
query I rowsort label-240
SELECT + - COUNT ( * ) AS col4 FROM tab0 cor0 WHERE 12 = + col0 / - + col0 * - col1 * + 75
----
0

onlyif mysql # aggregate syntax: 
query I rowsort label-240
SELECT + - COUNT( * ) AS col4 FROM tab1 cor0 WHERE 12 = + col0 / - + col0 * - col1 * + 75
----
0

skipif mysql # not compatible
query I rowsort label-240
SELECT + - COUNT ( * ) AS col4 FROM tab1 cor0 WHERE 12 = + col0 / - + col0 * - col1 * + 75
----
0

onlyif mysql # aggregate syntax: 
query I rowsort label-240
SELECT + - COUNT( * ) AS col4 FROM tab2 cor0 WHERE 12 = + col0 / - + col0 * - col1 * + 75
----
0

skipif mysql # not compatible
query I rowsort label-240
SELECT + - COUNT ( * ) AS col4 FROM tab2 cor0 WHERE 12 = + col0 / - + col0 * - col1 * + 75
----
0

onlyif mysql # aggregate syntax: 
query I rowsort label-240
SELECT + - COUNT( * ) AS col4 FROM tab3 cor0 WHERE 12 = + col0 / - + col0 * - col1 * + 75
----
0

skipif mysql # not compatible
query I rowsort label-240
SELECT + - COUNT ( * ) AS col4 FROM tab3 cor0 WHERE 12 = + col0 / - + col0 * - col1 * + 75
----
0

onlyif mysql # aggregate syntax: 
query I rowsort label-240
SELECT + - COUNT( * ) AS col4 FROM tab4 cor0 WHERE 12 = + col0 / - + col0 * - col1 * + 75
----
0

skipif mysql # not compatible
query I rowsort label-240
SELECT + - COUNT ( * ) AS col4 FROM tab4 cor0 WHERE 12 = + col0 / - + col0 * - col1 * + 75
----
0

query IIIIIII rowsort label-245
SELECT * FROM tab0 cor0 WHERE NOT + col4 * 12 <> NULL
----

query IIIIIII rowsort label-245
SELECT * FROM tab1 cor0 WHERE NOT + col4 * 12 <> NULL
----

query IIIIIII rowsort label-245
SELECT * FROM tab2 cor0 WHERE NOT + col4 * 12 <> NULL
----

query IIIIIII rowsort label-245
SELECT * FROM tab3 cor0 WHERE NOT + col4 * 12 <> NULL
----

query IIIIIII rowsort label-245
SELECT * FROM tab4 cor0 WHERE NOT + col4 * 12 <> NULL
----

query IIIIIII rowsort label-250
SELECT * FROM tab0 AS cor0 WHERE NOT NULL <= + col3
----

query IIIIIII rowsort label-250
SELECT * FROM tab1 AS cor0 WHERE NOT NULL <= + col3
----

query IIIIIII rowsort label-250
SELECT * FROM tab2 AS cor0 WHERE NOT NULL <= + col3
----

query IIIIIII rowsort label-250
SELECT * FROM tab3 AS cor0 WHERE NOT NULL <= + col3
----

query IIIIIII rowsort label-250
SELECT * FROM tab4 AS cor0 WHERE NOT NULL <= + col3
----

query I rowsort label-255
SELECT - col0 AS col1 FROM tab0 AS cor0 WHERE NOT col4 * 77 IS NULL
----
1000 values hashing to 5978ace6e958246c27da54bdaea19532

query I rowsort label-255
SELECT - col0 AS col1 FROM tab1 AS cor0 WHERE NOT col4 * 77 IS NULL
----
1000 values hashing to 5978ace6e958246c27da54bdaea19532

query I rowsort label-255
SELECT - col0 AS col1 FROM tab2 AS cor0 WHERE NOT col4 * 77 IS NULL
----
1000 values hashing to 5978ace6e958246c27da54bdaea19532

query I rowsort label-255
SELECT - col0 AS col1 FROM tab3 AS cor0 WHERE NOT col4 * 77 IS NULL
----
1000 values hashing to 5978ace6e958246c27da54bdaea19532

query I rowsort label-255
SELECT - col0 AS col1 FROM tab4 AS cor0 WHERE NOT col4 * 77 IS NULL
----
1000 values hashing to 5978ace6e958246c27da54bdaea19532

query IIIIIII rowsort label-260
SELECT * FROM tab0 WHERE + 86 IS NULL
----

query IIIIIII rowsort label-260
SELECT * FROM tab1 WHERE + 86 IS NULL
----

query IIIIIII rowsort label-260
SELECT * FROM tab2 WHERE + 86 IS NULL
----

query IIIIIII rowsort label-260
SELECT * FROM tab3 WHERE + 86 IS NULL
----

query IIIIIII rowsort label-260
SELECT * FROM tab4 WHERE + 86 IS NULL
----

query IIIIIII rowsort label-265
SELECT * FROM tab0 AS cor0 WHERE NULL IS NOT NULL
----

query IIIIIII rowsort label-265
SELECT * FROM tab1 AS cor0 WHERE NULL IS NOT NULL
----

query IIIIIII rowsort label-265
SELECT * FROM tab2 AS cor0 WHERE NULL IS NOT NULL
----

query IIIIIII rowsort label-265
SELECT * FROM tab3 AS cor0 WHERE NULL IS NOT NULL
----

query IIIIIII rowsort label-265
SELECT * FROM tab4 AS cor0 WHERE NULL IS NOT NULL
----

query IIIIIII rowsort label-270
SELECT * FROM tab0 AS cor0 WHERE NOT NULL IN ( col0, col4 )
----

query IIIIIII rowsort label-270
SELECT * FROM tab1 AS cor0 WHERE NOT NULL IN ( col0, col4 )
----

query IIIIIII rowsort label-270
SELECT * FROM tab2 AS cor0 WHERE NOT NULL IN ( col0, col4 )
----

query IIIIIII rowsort label-270
SELECT * FROM tab3 AS cor0 WHERE NOT NULL IN ( col0, col4 )
----

query IIIIIII rowsort label-270
SELECT * FROM tab4 AS cor0 WHERE NOT NULL IN ( col0, col4 )
----

query IIIIIII rowsort label-275
SELECT * FROM tab0 AS cor0 WHERE ( NOT NULL IS NULL )
----

query IIIIIII rowsort label-275
SELECT * FROM tab1 AS cor0 WHERE ( NOT NULL IS NULL )
----

query IIIIIII rowsort label-275
SELECT * FROM tab2 AS cor0 WHERE ( NOT NULL IS NULL )
----

query IIIIIII rowsort label-275
SELECT * FROM tab3 AS cor0 WHERE ( NOT NULL IS NULL )
----

query IIIIIII rowsort label-275
SELECT * FROM tab4 AS cor0 WHERE ( NOT NULL IS NULL )
----

onlyif mysql # aggregate syntax: 
query I rowsort label-280
SELECT DISTINCT ( + - COUNT( * ) ) AS col3 FROM tab0 AS cor0 WHERE NULL IS NULL
----
-1000

skipif mysql # not compatible
query I rowsort label-280
SELECT DISTINCT ( + - COUNT ( * ) ) AS col3 FROM tab0 AS cor0 WHERE NULL IS NULL
----
-1000

onlyif mysql # aggregate syntax: 
query I rowsort label-280
SELECT DISTINCT ( + - COUNT( * ) ) AS col3 FROM tab1 AS cor0 WHERE NULL IS NULL
----
-1000

skipif mysql # not compatible
query I rowsort label-280
SELECT DISTINCT ( + - COUNT ( * ) ) AS col3 FROM tab1 AS cor0 WHERE NULL IS NULL
----
-1000

onlyif mysql # aggregate syntax: 
query I rowsort label-280
SELECT DISTINCT ( + - COUNT( * ) ) AS col3 FROM tab2 AS cor0 WHERE NULL IS NULL
----
-1000

skipif mysql # not compatible
query I rowsort label-280
SELECT DISTINCT ( + - COUNT ( * ) ) AS col3 FROM tab2 AS cor0 WHERE NULL IS NULL
----
-1000

onlyif mysql # aggregate syntax: 
query I rowsort label-280
SELECT DISTINCT ( + - COUNT( * ) ) AS col3 FROM tab3 AS cor0 WHERE NULL IS NULL
----
-1000

skipif mysql # not compatible
query I rowsort label-280
SELECT DISTINCT ( + - COUNT ( * ) ) AS col3 FROM tab3 AS cor0 WHERE NULL IS NULL
----
-1000

onlyif mysql # aggregate syntax: 
query I rowsort label-280
SELECT DISTINCT ( + - COUNT( * ) ) AS col3 FROM tab4 AS cor0 WHERE NULL IS NULL
----
-1000

skipif mysql # not compatible
query I rowsort label-280
SELECT DISTINCT ( + - COUNT ( * ) ) AS col3 FROM tab4 AS cor0 WHERE NULL IS NULL
----
-1000

query II rowsort label-285
SELECT ALL - + col4 * - 74 AS col2, - 10 FROM tab0 cor0 WHERE ( NULL ) < + - col4
----

query II rowsort label-285
SELECT ALL - + col4 * - 74 AS col2, - 10 FROM tab1 cor0 WHERE ( NULL ) < + - col4
----

query II rowsort label-285
SELECT ALL - + col4 * - 74 AS col2, - 10 FROM tab2 cor0 WHERE ( NULL ) < + - col4
----

query II rowsort label-285
SELECT ALL - + col4 * - 74 AS col2, - 10 FROM tab3 cor0 WHERE ( NULL ) < + - col4
----

query II rowsort label-285
SELECT ALL - + col4 * - 74 AS col2, - 10 FROM tab4 cor0 WHERE ( NULL ) < + - col4
----

query IIIIIII rowsort label-290
SELECT * FROM tab0 WHERE NOT ( ( NULL ) NOT BETWEEN 31 AND NULL )
----

query IIIIIII rowsort label-290
SELECT * FROM tab1 WHERE NOT ( ( NULL ) NOT BETWEEN 31 AND NULL )
----

query IIIIIII rowsort label-290
SELECT * FROM tab2 WHERE NOT ( ( NULL ) NOT BETWEEN 31 AND NULL )
----

query IIIIIII rowsort label-290
SELECT * FROM tab3 WHERE NOT ( ( NULL ) NOT BETWEEN 31 AND NULL )
----

query IIIIIII rowsort label-290
SELECT * FROM tab4 WHERE NOT ( ( NULL ) NOT BETWEEN 31 AND NULL )
----

query I rowsort label-295
SELECT DISTINCT - - 89 AS col4 FROM tab0 WHERE NOT ( + col4 IS NOT NULL )
----

query I rowsort label-295
SELECT DISTINCT - - 89 AS col4 FROM tab1 WHERE NOT ( + col4 IS NOT NULL )
----

query I rowsort label-295
SELECT DISTINCT - - 89 AS col4 FROM tab2 WHERE NOT ( + col4 IS NOT NULL )
----

query I rowsort label-295
SELECT DISTINCT - - 89 AS col4 FROM tab3 WHERE NOT ( + col4 IS NOT NULL )
----

query I rowsort label-295
SELECT DISTINCT - - 89 AS col4 FROM tab4 WHERE NOT ( + col4 IS NOT NULL )
----

query I rowsort label-300
SELECT + col0 AS col0 FROM tab0 AS cor0 WHERE ( NULL ) IS NOT NULL
----

query I rowsort label-300
SELECT + col0 AS col0 FROM tab1 AS cor0 WHERE ( NULL ) IS NOT NULL
----

query I rowsort label-300
SELECT + col0 AS col0 FROM tab2 AS cor0 WHERE ( NULL ) IS NOT NULL
----

query I rowsort label-300
SELECT + col0 AS col0 FROM tab3 AS cor0 WHERE ( NULL ) IS NOT NULL
----

query I rowsort label-300
SELECT + col0 AS col0 FROM tab4 AS cor0 WHERE ( NULL ) IS NOT NULL
----

query IIIIIII rowsort label-305
SELECT ALL * FROM tab0 AS cor0 WHERE NOT 49 IS NOT NULL
----

query IIIIIII rowsort label-305
SELECT ALL * FROM tab1 AS cor0 WHERE NOT 49 IS NOT NULL
----

query IIIIIII rowsort label-305
SELECT ALL * FROM tab2 AS cor0 WHERE NOT 49 IS NOT NULL
----

query IIIIIII rowsort label-305
SELECT ALL * FROM tab3 AS cor0 WHERE NOT 49 IS NOT NULL
----

query IIIIIII rowsort label-305
SELECT ALL * FROM tab4 AS cor0 WHERE NOT 49 IS NOT NULL
----

query I rowsort label-310
SELECT ALL 38 AS col3 FROM tab0 AS cor0 WHERE NOT NULL IS NULL
----

query I rowsort label-310
SELECT ALL 38 AS col3 FROM tab1 AS cor0 WHERE NOT NULL IS NULL
----

query I rowsort label-310
SELECT ALL 38 AS col3 FROM tab2 AS cor0 WHERE NOT NULL IS NULL
----

query I rowsort label-310
SELECT ALL 38 AS col3 FROM tab3 AS cor0 WHERE NOT NULL IS NULL
----

query I rowsort label-310
SELECT ALL 38 AS col3 FROM tab4 AS cor0 WHERE NOT NULL IS NULL
----

query IIIIIII rowsort label-315
SELECT ALL * FROM tab0 AS cor0 WHERE NOT + col0 IS NOT NULL
----

query IIIIIII rowsort label-315
SELECT ALL * FROM tab1 AS cor0 WHERE NOT + col0 IS NOT NULL
----

query IIIIIII rowsort label-315
SELECT ALL * FROM tab2 AS cor0 WHERE NOT + col0 IS NOT NULL
----

query IIIIIII rowsort label-315
SELECT ALL * FROM tab3 AS cor0 WHERE NOT + col0 IS NOT NULL
----

query IIIIIII rowsort label-315
SELECT ALL * FROM tab4 AS cor0 WHERE NOT + col0 IS NOT NULL
----

onlyif mysql # aggregate syntax: 
query I rowsort label-320
SELECT - COUNT( * ) AS col1 FROM tab0 WHERE NOT NULL > col4
----
0

skipif mysql # not compatible
query I rowsort label-320
SELECT - COUNT ( * ) AS col1 FROM tab0 WHERE NOT NULL > col4
----
0

onlyif mysql # aggregate syntax: 
query I rowsort label-320
SELECT - COUNT( * ) AS col1 FROM tab1 WHERE NOT NULL > col4
----
0

skipif mysql # not compatible
query I rowsort label-320
SELECT - COUNT ( * ) AS col1 FROM tab1 WHERE NOT NULL > col4
----
0

onlyif mysql # aggregate syntax: 
query I rowsort label-320
SELECT - COUNT( * ) AS col1 FROM tab2 WHERE NOT NULL > col4
----
0

skipif mysql # not compatible
query I rowsort label-320
SELECT - COUNT ( * ) AS col1 FROM tab2 WHERE NOT NULL > col4
----
0

onlyif mysql # aggregate syntax: 
query I rowsort label-320
SELECT - COUNT( * ) AS col1 FROM tab3 WHERE NOT NULL > col4
----
0

skipif mysql # not compatible
query I rowsort label-320
SELECT - COUNT ( * ) AS col1 FROM tab3 WHERE NOT NULL > col4
----
0

onlyif mysql # aggregate syntax: 
query I rowsort label-320
SELECT - COUNT( * ) AS col1 FROM tab4 WHERE NOT NULL > col4
----
0

skipif mysql # not compatible
query I rowsort label-320
SELECT - COUNT ( * ) AS col1 FROM tab4 WHERE NOT NULL > col4
----
0

query IIIIIII rowsort label-325
SELECT * FROM tab0 WHERE NOT + col3 IS NOT NULL
----

query IIIIIII rowsort label-325
SELECT * FROM tab1 WHERE NOT + col3 IS NOT NULL
----

query IIIIIII rowsort label-325
SELECT * FROM tab2 WHERE NOT + col3 IS NOT NULL
----

query IIIIIII rowsort label-325
SELECT * FROM tab3 WHERE NOT + col3 IS NOT NULL
----

query IIIIIII rowsort label-325
SELECT * FROM tab4 WHERE NOT + col3 IS NOT NULL
----

query IIIIIII rowsort label-330
SELECT ALL * FROM tab0 WHERE NOT ( NULL ) IS NULL
----

query IIIIIII rowsort label-330
SELECT ALL * FROM tab1 WHERE NOT ( NULL ) IS NULL
----

query IIIIIII rowsort label-330
SELECT ALL * FROM tab2 WHERE NOT ( NULL ) IS NULL
----

query IIIIIII rowsort label-330
SELECT ALL * FROM tab3 WHERE NOT ( NULL ) IS NULL
----

query IIIIIII rowsort label-330
SELECT ALL * FROM tab4 WHERE NOT ( NULL ) IS NULL
----

query I rowsort label-335
SELECT ALL + - col3 FROM tab0 WHERE NOT NULL < NULL
----

query I rowsort label-335
SELECT ALL + - col3 FROM tab1 WHERE NOT NULL < NULL
----

query I rowsort label-335
SELECT ALL + - col3 FROM tab2 WHERE NOT NULL < NULL
----

query I rowsort label-335
SELECT ALL + - col3 FROM tab3 WHERE NOT NULL < NULL
----

query I rowsort label-335
SELECT ALL + - col3 FROM tab4 WHERE NOT NULL < NULL
----

query I rowsort label-340
SELECT ALL + col0 AS col0 FROM tab0 WHERE NOT NULL = NULL
----

query I rowsort label-340
SELECT ALL + col0 AS col0 FROM tab1 WHERE NOT NULL = NULL
----

query I rowsort label-340
SELECT ALL + col0 AS col0 FROM tab2 WHERE NOT NULL = NULL
----

query I rowsort label-340
SELECT ALL + col0 AS col0 FROM tab3 WHERE NOT NULL = NULL
----

query I rowsort label-340
SELECT ALL + col0 AS col0 FROM tab4 WHERE NOT NULL = NULL
----

query I rowsort label-345
SELECT - - col1 FROM tab0 cor0 WHERE col0 >= NULL
----

query I rowsort label-345
SELECT - - col1 FROM tab1 cor0 WHERE col0 >= NULL
----

query I rowsort label-345
SELECT - - col1 FROM tab2 cor0 WHERE col0 >= NULL
----

query I rowsort label-345
SELECT - - col1 FROM tab3 cor0 WHERE col0 >= NULL
----

query I rowsort label-345
SELECT - - col1 FROM tab4 cor0 WHERE col0 >= NULL
----

query IIIIIII rowsort label-350
SELECT ALL * FROM tab0 AS cor0 WHERE NOT col0 IS NOT NULL
----

query IIIIIII rowsort label-350
SELECT ALL * FROM tab1 AS cor0 WHERE NOT col0 IS NOT NULL
----

query IIIIIII rowsort label-350
SELECT ALL * FROM tab2 AS cor0 WHERE NOT col0 IS NOT NULL
----

query IIIIIII rowsort label-350
SELECT ALL * FROM tab3 AS cor0 WHERE NOT col0 IS NOT NULL
----

query IIIIIII rowsort label-350
SELECT ALL * FROM tab4 AS cor0 WHERE NOT col0 IS NOT NULL
----

query IIIIIII rowsort label-355
SELECT * FROM tab0 AS cor0 WHERE col4 * - col4 = NULL
----

query IIIIIII rowsort label-355
SELECT * FROM tab1 AS cor0 WHERE col4 * - col4 = NULL
----

query IIIIIII rowsort label-355
SELECT * FROM tab2 AS cor0 WHERE col4 * - col4 = NULL
----

query IIIIIII rowsort label-355
SELECT * FROM tab3 AS cor0 WHERE col4 * - col4 = NULL
----

query IIIIIII rowsort label-355
SELECT * FROM tab4 AS cor0 WHERE col4 * - col4 = NULL
----

query IIIIIII rowsort label-360
SELECT ALL * FROM tab0 WHERE NULL >= - col3
----

query IIIIIII rowsort label-360
SELECT ALL * FROM tab1 WHERE NULL >= - col3
----

query IIIIIII rowsort label-360
SELECT ALL * FROM tab2 WHERE NULL >= - col3
----

query IIIIIII rowsort label-360
SELECT ALL * FROM tab3 WHERE NULL >= - col3
----

query IIIIIII rowsort label-360
SELECT ALL * FROM tab4 WHERE NULL >= - col3
----

query I rowsort label-365
SELECT col0 AS col5 FROM tab0 WHERE - col3 IS NULL
----

query I rowsort label-365
SELECT col0 AS col5 FROM tab1 WHERE - col3 IS NULL
----

query I rowsort label-365
SELECT col0 AS col5 FROM tab2 WHERE - col3 IS NULL
----

query I rowsort label-365
SELECT col0 AS col5 FROM tab3 WHERE - col3 IS NULL
----

query I rowsort label-365
SELECT col0 AS col5 FROM tab4 WHERE - col3 IS NULL
----

query IIIIIII rowsort label-370
SELECT * FROM tab0 WHERE NULL IS NOT NULL
----

query IIIIIII rowsort label-370
SELECT * FROM tab1 WHERE NULL IS NOT NULL
----

query IIIIIII rowsort label-370
SELECT * FROM tab2 WHERE NULL IS NOT NULL
----

query IIIIIII rowsort label-370
SELECT * FROM tab3 WHERE NULL IS NOT NULL
----

query IIIIIII rowsort label-370
SELECT * FROM tab4 WHERE NULL IS NOT NULL
----

onlyif mysql # CAST syntax: SIGNED type: 
query I rowsort label-375
SELECT DISTINCT - CAST( NULL AS SIGNED ) FROM tab0 WHERE ( NOT 39 IS NOT NULL )
----

skipif mysql # not compatible
query I rowsort label-375
SELECT DISTINCT - CAST ( NULL AS INTEGER ) FROM tab0 WHERE ( NOT 39 IS NOT NULL )
----

onlyif mysql # CAST syntax: SIGNED type: 
query I rowsort label-375
SELECT DISTINCT - CAST( NULL AS SIGNED ) FROM tab1 WHERE ( NOT 39 IS NOT NULL )
----

skipif mysql # not compatible
query I rowsort label-375
SELECT DISTINCT - CAST ( NULL AS INTEGER ) FROM tab1 WHERE ( NOT 39 IS NOT NULL )
----

onlyif mysql # CAST syntax: SIGNED type: 
query I rowsort label-375
SELECT DISTINCT - CAST( NULL AS SIGNED ) FROM tab2 WHERE ( NOT 39 IS NOT NULL )
----

skipif mysql # not compatible
query I rowsort label-375
SELECT DISTINCT - CAST ( NULL AS INTEGER ) FROM tab2 WHERE ( NOT 39 IS NOT NULL )
----

onlyif mysql # CAST syntax: SIGNED type: 
query I rowsort label-375
SELECT DISTINCT - CAST( NULL AS SIGNED ) FROM tab3 WHERE ( NOT 39 IS NOT NULL )
----

skipif mysql # not compatible
query I rowsort label-375
SELECT DISTINCT - CAST ( NULL AS INTEGER ) FROM tab3 WHERE ( NOT 39 IS NOT NULL )
----

onlyif mysql # CAST syntax: SIGNED type: 
query I rowsort label-375
SELECT DISTINCT - CAST( NULL AS SIGNED ) FROM tab4 WHERE ( NOT 39 IS NOT NULL )
----

skipif mysql # not compatible
query I rowsort label-375
SELECT DISTINCT - CAST ( NULL AS INTEGER ) FROM tab4 WHERE ( NOT 39 IS NOT NULL )
----

query IIIIIII rowsort label-380
SELECT ALL * FROM tab0 AS cor0 WHERE NOT 58 + + col1 IS NOT NULL
----

query IIIIIII rowsort label-380
SELECT ALL * FROM tab1 AS cor0 WHERE NOT 58 + + col1 IS NOT NULL
----

query IIIIIII rowsort label-380
SELECT ALL * FROM tab2 AS cor0 WHERE NOT 58 + + col1 IS NOT NULL
----

query IIIIIII rowsort label-380
SELECT ALL * FROM tab3 AS cor0 WHERE NOT 58 + + col1 IS NOT NULL
----

query IIIIIII rowsort label-380
SELECT ALL * FROM tab4 AS cor0 WHERE NOT 58 + + col1 IS NOT NULL
----

query I rowsort label-385
SELECT ALL + col2 FROM tab0 AS cor0 WHERE NOT ( NOT col3 * - col0 * col3 + + col0 = NULL )
----

query I rowsort label-385
SELECT ALL + col2 FROM tab1 AS cor0 WHERE NOT ( NOT col3 * - col0 * col3 + + col0 = NULL )
----

query I rowsort label-385
SELECT ALL + col2 FROM tab2 AS cor0 WHERE NOT ( NOT col3 * - col0 * col3 + + col0 = NULL )
----

query I rowsort label-385
SELECT ALL + col2 FROM tab3 AS cor0 WHERE NOT ( NOT col3 * - col0 * col3 + + col0 = NULL )
----

query I rowsort label-385
SELECT ALL + col2 FROM tab4 AS cor0 WHERE NOT ( NOT col3 * - col0 * col3 + + col0 = NULL )
----

query IIIIIII rowsort label-390
SELECT ALL * FROM tab0 AS cor0 WHERE NOT NULL >= 28
----

query IIIIIII rowsort label-390
SELECT ALL * FROM tab1 AS cor0 WHERE NOT NULL >= 28
----

query IIIIIII rowsort label-390
SELECT ALL * FROM tab2 AS cor0 WHERE NOT NULL >= 28
----

query IIIIIII rowsort label-390
SELECT ALL * FROM tab3 AS cor0 WHERE NOT NULL >= 28
----

query IIIIIII rowsort label-390
SELECT ALL * FROM tab4 AS cor0 WHERE NOT NULL >= 28
----

query I rowsort label-395
SELECT ALL + col4 FROM tab0 WHERE NOT col0 <= NULL
----

query I rowsort label-395
SELECT ALL + col4 FROM tab1 WHERE NOT col0 <= NULL
----

query I rowsort label-395
SELECT ALL + col4 FROM tab2 WHERE NOT col0 <= NULL
----

query I rowsort label-395
SELECT ALL + col4 FROM tab3 WHERE NOT col0 <= NULL
----

query I rowsort label-395
SELECT ALL + col4 FROM tab4 WHERE NOT col0 <= NULL
----

query IIIIIII rowsort label-400
SELECT * FROM tab0 AS cor0 WHERE NOT col0 IS NOT NULL
----

query IIIIIII rowsort label-400
SELECT * FROM tab1 AS cor0 WHERE NOT col0 IS NOT NULL
----

query IIIIIII rowsort label-400
SELECT * FROM tab2 AS cor0 WHERE NOT col0 IS NOT NULL
----

query IIIIIII rowsort label-400
SELECT * FROM tab3 AS cor0 WHERE NOT col0 IS NOT NULL
----

query IIIIIII rowsort label-400
SELECT * FROM tab4 AS cor0 WHERE NOT col0 IS NOT NULL
----

query IIIIIII rowsort label-405
SELECT ALL * FROM tab0 AS cor0 WHERE NOT - col1 * 62 * 49 IS NOT NULL
----

query IIIIIII rowsort label-405
SELECT ALL * FROM tab1 AS cor0 WHERE NOT - col1 * 62 * 49 IS NOT NULL
----

query IIIIIII rowsort label-405
SELECT ALL * FROM tab2 AS cor0 WHERE NOT - col1 * 62 * 49 IS NOT NULL
----

query IIIIIII rowsort label-405
SELECT ALL * FROM tab3 AS cor0 WHERE NOT - col1 * 62 * 49 IS NOT NULL
----

query IIIIIII rowsort label-405
SELECT ALL * FROM tab4 AS cor0 WHERE NOT - col1 * 62 * 49 IS NOT NULL
----

onlyif mysql # aggregate syntax: 
query I rowsort label-410
SELECT DISTINCT - + COUNT( * ) FROM tab0 AS cor0 WHERE col0 * 33 + - col3 IS NULL
----
0

skipif mysql # not compatible
query I rowsort label-410
SELECT DISTINCT - + COUNT ( * ) FROM tab0 AS cor0 WHERE col0 * 33 + - col3 IS NULL
----
0

onlyif mysql # aggregate syntax: 
query I rowsort label-410
SELECT DISTINCT - + COUNT( * ) FROM tab1 AS cor0 WHERE col0 * 33 + - col3 IS NULL
----
0

skipif mysql # not compatible
query I rowsort label-410
SELECT DISTINCT - + COUNT ( * ) FROM tab1 AS cor0 WHERE col0 * 33 + - col3 IS NULL
----
0

onlyif mysql # aggregate syntax: 
query I rowsort label-410
SELECT DISTINCT - + COUNT( * ) FROM tab2 AS cor0 WHERE col0 * 33 + - col3 IS NULL
----
0

skipif mysql # not compatible
query I rowsort label-410
SELECT DISTINCT - + COUNT ( * ) FROM tab2 AS cor0 WHERE col0 * 33 + - col3 IS NULL
----
0

onlyif mysql # aggregate syntax: 
query I rowsort label-410
SELECT DISTINCT - + COUNT( * ) FROM tab3 AS cor0 WHERE col0 * 33 + - col3 IS NULL
----
0

skipif mysql # not compatible
query I rowsort label-410
SELECT DISTINCT - + COUNT ( * ) FROM tab3 AS cor0 WHERE col0 * 33 + - col3 IS NULL
----
0

onlyif mysql # aggregate syntax: 
query I rowsort label-410
SELECT DISTINCT - + COUNT( * ) FROM tab4 AS cor0 WHERE col0 * 33 + - col3 IS NULL
----
0

skipif mysql # not compatible
query I rowsort label-410
SELECT DISTINCT - + COUNT ( * ) FROM tab4 AS cor0 WHERE col0 * 33 + - col3 IS NULL
----
0

query IIIIIIIIIIIIII rowsort label-415
SELECT ALL * FROM tab0, tab0 AS cor0 WHERE ( NULL ) >= - 45
----

query IIIIIIIIIIIIII rowsort label-415
SELECT ALL * FROM tab1, tab1 AS cor0 WHERE ( NULL ) >= - 45
----

query IIIIIIIIIIIIII rowsort label-415
SELECT ALL * FROM tab2, tab2 AS cor0 WHERE ( NULL ) >= - 45
----

query IIIIIIIIIIIIII rowsort label-415
SELECT ALL * FROM tab3, tab3 AS cor0 WHERE ( NULL ) >= - 45
----

query IIIIIIIIIIIIII rowsort label-415
SELECT ALL * FROM tab4, tab4 AS cor0 WHERE ( NULL ) >= - 45
----

query I rowsort label-420
SELECT 25 FROM tab0 AS cor0 WHERE + + col3 * - col1 IS NOT NULL OR 69 >= + col3
----
1000 values hashing to 7ab27497c121866e93dc81537b56ecc8

query I rowsort label-420
SELECT 25 FROM tab1 AS cor0 WHERE + + col3 * - col1 IS NOT NULL OR 69 >= + col3
----
1000 values hashing to 7ab27497c121866e93dc81537b56ecc8

query I rowsort label-420
SELECT 25 FROM tab2 AS cor0 WHERE + + col3 * - col1 IS NOT NULL OR 69 >= + col3
----
1000 values hashing to 7ab27497c121866e93dc81537b56ecc8

query I rowsort label-420
SELECT 25 FROM tab3 AS cor0 WHERE + + col3 * - col1 IS NOT NULL OR 69 >= + col3
----
1000 values hashing to 7ab27497c121866e93dc81537b56ecc8

query I rowsort label-420
SELECT 25 FROM tab4 AS cor0 WHERE + + col3 * - col1 IS NOT NULL OR 69 >= + col3
----
1000 values hashing to 7ab27497c121866e93dc81537b56ecc8

query I rowsort label-425
SELECT col0 + - 82 FROM tab0 AS cor0 WHERE NOT NULL NOT BETWEEN NULL AND - 64 * + 41 * 10
----

query I rowsort label-425
SELECT col0 + - 82 FROM tab1 AS cor0 WHERE NOT NULL NOT BETWEEN NULL AND - 64 * + 41 * 10
----

query I rowsort label-425
SELECT col0 + - 82 FROM tab2 AS cor0 WHERE NOT NULL NOT BETWEEN NULL AND - 64 * + 41 * 10
----

query I rowsort label-425
SELECT col0 + - 82 FROM tab3 AS cor0 WHERE NOT NULL NOT BETWEEN NULL AND - 64 * + 41 * 10
----

query I rowsort label-425
SELECT col0 + - 82 FROM tab4 AS cor0 WHERE NOT NULL NOT BETWEEN NULL AND - 64 * + 41 * 10
----

query IIIIIII rowsort label-430
SELECT ALL * FROM tab0 AS cor0 WHERE col5 IS NULL
----

query IIIIIII rowsort label-430
SELECT ALL * FROM tab1 AS cor0 WHERE col5 IS NULL
----

query IIIIIII rowsort label-430
SELECT ALL * FROM tab2 AS cor0 WHERE col5 IS NULL
----

query IIIIIII rowsort label-430
SELECT ALL * FROM tab3 AS cor0 WHERE col5 IS NULL
----

query IIIIIII rowsort label-430
SELECT ALL * FROM tab4 AS cor0 WHERE col5 IS NULL
----

query IIIIIII rowsort label-435
SELECT * FROM tab0 WHERE NOT NULL >= NULL
----

query IIIIIII rowsort label-435
SELECT * FROM tab1 WHERE NOT NULL >= NULL
----

query IIIIIII rowsort label-435
SELECT * FROM tab2 WHERE NOT NULL >= NULL
----

query IIIIIII rowsort label-435
SELECT * FROM tab3 WHERE NOT NULL >= NULL
----

query IIIIIII rowsort label-435
SELECT * FROM tab4 WHERE NOT NULL >= NULL
----

onlyif mysql # CAST syntax: DECIMAL type: 
query I rowsort label-440
SELECT CAST( NULL AS DECIMAL ) * - col0 FROM tab0 WHERE ( - col1 + + col4 ) IS NULL
----

skipif mysql # not compatible
query I rowsort label-440
SELECT CAST ( NULL AS REAL ) * - col0 FROM tab0 WHERE ( - col1 + + col4 ) IS NULL
----

onlyif mysql # CAST syntax: DECIMAL type: 
query I rowsort label-440
SELECT CAST( NULL AS DECIMAL ) * - col0 FROM tab1 WHERE ( - col1 + + col4 ) IS NULL
----

skipif mysql # not compatible
query I rowsort label-440
SELECT CAST ( NULL AS REAL ) * - col0 FROM tab1 WHERE ( - col1 + + col4 ) IS NULL
----

onlyif mysql # CAST syntax: DECIMAL type: 
query I rowsort label-440
SELECT CAST( NULL AS DECIMAL ) * - col0 FROM tab2 WHERE ( - col1 + + col4 ) IS NULL
----

skipif mysql # not compatible
query I rowsort label-440
SELECT CAST ( NULL AS REAL ) * - col0 FROM tab2 WHERE ( - col1 + + col4 ) IS NULL
----

onlyif mysql # CAST syntax: DECIMAL type: 
query I rowsort label-440
SELECT CAST( NULL AS DECIMAL ) * - col0 FROM tab3 WHERE ( - col1 + + col4 ) IS NULL
----

skipif mysql # not compatible
query I rowsort label-440
SELECT CAST ( NULL AS REAL ) * - col0 FROM tab3 WHERE ( - col1 + + col4 ) IS NULL
----

onlyif mysql # CAST syntax: DECIMAL type: 
query I rowsort label-440
SELECT CAST( NULL AS DECIMAL ) * - col0 FROM tab4 WHERE ( - col1 + + col4 ) IS NULL
----

skipif mysql # not compatible
query I rowsort label-440
SELECT CAST ( NULL AS REAL ) * - col0 FROM tab4 WHERE ( - col1 + + col4 ) IS NULL
----

onlyif mysql # aggregate syntax: 
query I rowsort label-445
SELECT - ( COUNT( * ) ) AS col3 FROM tab0 WHERE NULL IS NULL
----
-1000

skipif mysql # not compatible
query I rowsort label-445
SELECT - ( COUNT ( * ) ) AS col3 FROM tab0 WHERE NULL IS NULL
----
-1000

onlyif mysql # aggregate syntax: 
query I rowsort label-445
SELECT - ( COUNT( * ) ) AS col3 FROM tab1 WHERE NULL IS NULL
----
-1000

skipif mysql # not compatible
query I rowsort label-445
SELECT - ( COUNT ( * ) ) AS col3 FROM tab1 WHERE NULL IS NULL
----
-1000

onlyif mysql # aggregate syntax: 
query I rowsort label-445
SELECT - ( COUNT( * ) ) AS col3 FROM tab2 WHERE NULL IS NULL
----
-1000

skipif mysql # not compatible
query I rowsort label-445
SELECT - ( COUNT ( * ) ) AS col3 FROM tab2 WHERE NULL IS NULL
----
-1000

onlyif mysql # aggregate syntax: 
query I rowsort label-445
SELECT - ( COUNT( * ) ) AS col3 FROM tab3 WHERE NULL IS NULL
----
-1000

skipif mysql # not compatible
query I rowsort label-445
SELECT - ( COUNT ( * ) ) AS col3 FROM tab3 WHERE NULL IS NULL
----
-1000

onlyif mysql # aggregate syntax: 
query I rowsort label-445
SELECT - ( COUNT( * ) ) AS col3 FROM tab4 WHERE NULL IS NULL
----
-1000

skipif mysql # not compatible
query I rowsort label-445
SELECT - ( COUNT ( * ) ) AS col3 FROM tab4 WHERE NULL IS NULL
----
-1000

query IIIIIII rowsort label-450
SELECT ALL * FROM tab0 WHERE + col0 * 57 >= NULL
----

query IIIIIII rowsort label-450
SELECT ALL * FROM tab1 WHERE + col0 * 57 >= NULL
----

query IIIIIII rowsort label-450
SELECT ALL * FROM tab2 WHERE + col0 * 57 >= NULL
----

query IIIIIII rowsort label-450
SELECT ALL * FROM tab3 WHERE + col0 * 57 >= NULL
----

query IIIIIII rowsort label-450
SELECT ALL * FROM tab4 WHERE + col0 * 57 >= NULL
----

query IIIIIII rowsort label-455
SELECT * FROM tab0 AS cor0 WHERE NOT col3 IS NOT NULL
----

query IIIIIII rowsort label-455
SELECT * FROM tab1 AS cor0 WHERE NOT col3 IS NOT NULL
----

query IIIIIII rowsort label-455
SELECT * FROM tab2 AS cor0 WHERE NOT col3 IS NOT NULL
----

query IIIIIII rowsort label-455
SELECT * FROM tab3 AS cor0 WHERE NOT col3 IS NOT NULL
----

query IIIIIII rowsort label-455
SELECT * FROM tab4 AS cor0 WHERE NOT col3 IS NOT NULL
----

query I rowsort label-460
SELECT col2 AS col3 FROM tab0 AS cor0 WHERE NOT + 39 BETWEEN NULL AND NULL
----

query I rowsort label-460
SELECT col2 AS col3 FROM tab1 AS cor0 WHERE NOT + 39 BETWEEN NULL AND NULL
----

query I rowsort label-460
SELECT col2 AS col3 FROM tab2 AS cor0 WHERE NOT + 39 BETWEEN NULL AND NULL
----

query I rowsort label-460
SELECT col2 AS col3 FROM tab3 AS cor0 WHERE NOT + 39 BETWEEN NULL AND NULL
----

query I rowsort label-460
SELECT col2 AS col3 FROM tab4 AS cor0 WHERE NOT + 39 BETWEEN NULL AND NULL
----

onlyif mysql # CAST syntax: SIGNED type: 
query I rowsort label-465
SELECT CAST( NULL AS SIGNED ) AS col3 FROM tab0 AS cor0 WHERE NOT - col3 IN ( + - 29 * 82 )
----
1000 values hashing to 934e0694199f84c934e83e05849aa6f0

skipif mysql # not compatible
query I rowsort label-465
SELECT CAST ( NULL AS INTEGER ) AS col3 FROM tab0 AS cor0 WHERE NOT - col3 IN ( + - 29 * 82 )
----
1000 values hashing to 934e0694199f84c934e83e05849aa6f0

onlyif mysql # CAST syntax: SIGNED type: 
query I rowsort label-465
SELECT CAST( NULL AS SIGNED ) AS col3 FROM tab1 AS cor0 WHERE NOT - col3 IN ( + - 29 * 82 )
----
1000 values hashing to 934e0694199f84c934e83e05849aa6f0

skipif mysql # not compatible
query I rowsort label-465
SELECT CAST ( NULL AS INTEGER ) AS col3 FROM tab1 AS cor0 WHERE NOT - col3 IN ( + - 29 * 82 )
----
1000 values hashing to 934e0694199f84c934e83e05849aa6f0

onlyif mysql # CAST syntax: SIGNED type: 
query I rowsort label-465
SELECT CAST( NULL AS SIGNED ) AS col3 FROM tab2 AS cor0 WHERE NOT - col3 IN ( + - 29 * 82 )
----
1000 values hashing to 934e0694199f84c934e83e05849aa6f0

skipif mysql # not compatible
query I rowsort label-465
SELECT CAST ( NULL AS INTEGER ) AS col3 FROM tab2 AS cor0 WHERE NOT - col3 IN ( + - 29 * 82 )
----
1000 values hashing to 934e0694199f84c934e83e05849aa6f0

onlyif mysql # CAST syntax: SIGNED type: 
query I rowsort label-465
SELECT CAST( NULL AS SIGNED ) AS col3 FROM tab3 AS cor0 WHERE NOT - col3 IN ( + - 29 * 82 )
----
1000 values hashing to 934e0694199f84c934e83e05849aa6f0

skipif mysql # not compatible
query I rowsort label-465
SELECT CAST ( NULL AS INTEGER ) AS col3 FROM tab3 AS cor0 WHERE NOT - col3 IN ( + - 29 * 82 )
----
1000 values hashing to 934e0694199f84c934e83e05849aa6f0

onlyif mysql # CAST syntax: SIGNED type: 
query I rowsort label-465
SELECT CAST( NULL AS SIGNED ) AS col3 FROM tab4 AS cor0 WHERE NOT - col3 IN ( + - 29 * 82 )
----
1000 values hashing to 934e0694199f84c934e83e05849aa6f0

skipif mysql # not compatible
query I rowsort label-465
SELECT CAST ( NULL AS INTEGER ) AS col3 FROM tab4 AS cor0 WHERE NOT - col3 IN ( + - 29 * 82 )
----
1000 values hashing to 934e0694199f84c934e83e05849aa6f0

query IIIIIII rowsort label-470
SELECT * FROM tab0 WHERE NOT + - 90 IS NOT NULL
----

query IIIIIII rowsort label-470
SELECT * FROM tab1 WHERE NOT + - 90 IS NOT NULL
----

query IIIIIII rowsort label-470
SELECT * FROM tab2 WHERE NOT + - 90 IS NOT NULL
----

query IIIIIII rowsort label-470
SELECT * FROM tab3 WHERE NOT + - 90 IS NOT NULL
----

query IIIIIII rowsort label-470
SELECT * FROM tab4 WHERE NOT + - 90 IS NOT NULL
----

onlyif mysql # aggregate syntax: 
query I rowsort label-475
SELECT - AVG ( DISTINCT 27 ) + - MAX( DISTINCT col1 ) AS col4 FROM tab0 WHERE NOT NULL <> - + 90
----
NULL

skipif mysql # not compatible
query I rowsort label-475
SELECT - AVG ( DISTINCT 27 ) + - MAX ( DISTINCT col1 ) AS col4 FROM tab0 WHERE NOT NULL <> - + 90
----
NULL

onlyif mysql # aggregate syntax: 
query I rowsort label-475
SELECT - AVG ( DISTINCT 27 ) + - MAX( DISTINCT col1 ) AS col4 FROM tab1 WHERE NOT NULL <> - + 90
----
NULL

skipif mysql # not compatible
query I rowsort label-475
SELECT - AVG ( DISTINCT 27 ) + - MAX ( DISTINCT col1 ) AS col4 FROM tab1 WHERE NOT NULL <> - + 90
----
NULL

onlyif mysql # aggregate syntax: 
query I rowsort label-475
SELECT - AVG ( DISTINCT 27 ) + - MAX( DISTINCT col1 ) AS col4 FROM tab2 WHERE NOT NULL <> - + 90
----
NULL

skipif mysql # not compatible
query I rowsort label-475
SELECT - AVG ( DISTINCT 27 ) + - MAX ( DISTINCT col1 ) AS col4 FROM tab2 WHERE NOT NULL <> - + 90
----
NULL

onlyif mysql # aggregate syntax: 
query I rowsort label-475
SELECT - AVG ( DISTINCT 27 ) + - MAX( DISTINCT col1 ) AS col4 FROM tab3 WHERE NOT NULL <> - + 90
----
NULL

skipif mysql # not compatible
query I rowsort label-475
SELECT - AVG ( DISTINCT 27 ) + - MAX ( DISTINCT col1 ) AS col4 FROM tab3 WHERE NOT NULL <> - + 90
----
NULL

onlyif mysql # aggregate syntax: 
query I rowsort label-475
SELECT - AVG ( DISTINCT 27 ) + - MAX( DISTINCT col1 ) AS col4 FROM tab4 WHERE NOT NULL <> - + 90
----
NULL

skipif mysql # not compatible
query I rowsort label-475
SELECT - AVG ( DISTINCT 27 ) + - MAX ( DISTINCT col1 ) AS col4 FROM tab4 WHERE NOT NULL <> - + 90
----
NULL

query IIIIIII rowsort label-480
SELECT ALL * FROM tab0 WHERE NOT NULL IS NULL
----

query IIIIIII rowsort label-480
SELECT ALL * FROM tab1 WHERE NOT NULL IS NULL
----

query IIIIIII rowsort label-480
SELECT ALL * FROM tab2 WHERE NOT NULL IS NULL
----

query IIIIIII rowsort label-480
SELECT ALL * FROM tab3 WHERE NOT NULL IS NULL
----

query IIIIIII rowsort label-480
SELECT ALL * FROM tab4 WHERE NOT NULL IS NULL
----

query I rowsort label-485
SELECT - col0 FROM tab0 AS cor0 WHERE 96 IS NULL
----

query I rowsort label-485
SELECT - col0 FROM tab1 AS cor0 WHERE 96 IS NULL
----

query I rowsort label-485
SELECT - col0 FROM tab2 AS cor0 WHERE 96 IS NULL
----

query I rowsort label-485
SELECT - col0 FROM tab3 AS cor0 WHERE 96 IS NULL
----

query I rowsort label-485
SELECT - col0 FROM tab4 AS cor0 WHERE 96 IS NULL
----

onlyif mysql # aggregate syntax: 
query I rowsort label-490
SELECT DISTINCT + COUNT( + col4 ) AS col3 FROM tab0 AS cor0 WHERE NOT NULL IS NOT NULL
----
1000

skipif mysql # not compatible
query I rowsort label-490
SELECT DISTINCT + COUNT ( + col4 ) AS col3 FROM tab0 AS cor0 WHERE NOT NULL IS NOT NULL
----
1000

onlyif mysql # aggregate syntax: 
query I rowsort label-490
SELECT DISTINCT + COUNT( + col4 ) AS col3 FROM tab1 AS cor0 WHERE NOT NULL IS NOT NULL
----
1000

skipif mysql # not compatible
query I rowsort label-490
SELECT DISTINCT + COUNT ( + col4 ) AS col3 FROM tab1 AS cor0 WHERE NOT NULL IS NOT NULL
----
1000

onlyif mysql # aggregate syntax: 
query I rowsort label-490
SELECT DISTINCT + COUNT( + col4 ) AS col3 FROM tab2 AS cor0 WHERE NOT NULL IS NOT NULL
----
1000

skipif mysql # not compatible
query I rowsort label-490
SELECT DISTINCT + COUNT ( + col4 ) AS col3 FROM tab2 AS cor0 WHERE NOT NULL IS NOT NULL
----
1000

onlyif mysql # aggregate syntax: 
query I rowsort label-490
SELECT DISTINCT + COUNT( + col4 ) AS col3 FROM tab3 AS cor0 WHERE NOT NULL IS NOT NULL
----
1000

skipif mysql # not compatible
query I rowsort label-490
SELECT DISTINCT + COUNT ( + col4 ) AS col3 FROM tab3 AS cor0 WHERE NOT NULL IS NOT NULL
----
1000

onlyif mysql # aggregate syntax: 
query I rowsort label-490
SELECT DISTINCT + COUNT( + col4 ) AS col3 FROM tab4 AS cor0 WHERE NOT NULL IS NOT NULL
----
1000

skipif mysql # not compatible
query I rowsort label-490
SELECT DISTINCT + COUNT ( + col4 ) AS col3 FROM tab4 AS cor0 WHERE NOT NULL IS NOT NULL
----
1000

onlyif mysql # aggregate syntax: 
query I rowsort label-495
SELECT DISTINCT - COUNT( * ) FROM tab0 AS cor0 WHERE NOT NULL = - ( - col0 ) + - 89
----
0

skipif mysql # not compatible
query I rowsort label-495
SELECT DISTINCT - COUNT ( * ) FROM tab0 AS cor0 WHERE NOT NULL = - ( - col0 ) + - 89
----
0

onlyif mysql # aggregate syntax: 
query I rowsort label-495
SELECT DISTINCT - COUNT( * ) FROM tab1 AS cor0 WHERE NOT NULL = - ( - col0 ) + - 89
----
0

skipif mysql # not compatible
query I rowsort label-495
SELECT DISTINCT - COUNT ( * ) FROM tab1 AS cor0 WHERE NOT NULL = - ( - col0 ) + - 89
----
0

onlyif mysql # aggregate syntax: 
query I rowsort label-495
SELECT DISTINCT - COUNT( * ) FROM tab2 AS cor0 WHERE NOT NULL = - ( - col0 ) + - 89
----
0

skipif mysql # not compatible
query I rowsort label-495
SELECT DISTINCT - COUNT ( * ) FROM tab2 AS cor0 WHERE NOT NULL = - ( - col0 ) + - 89
----
0

onlyif mysql # aggregate syntax: 
query I rowsort label-495
SELECT DISTINCT - COUNT( * ) FROM tab3 AS cor0 WHERE NOT NULL = - ( - col0 ) + - 89
----
0

skipif mysql # not compatible
query I rowsort label-495
SELECT DISTINCT - COUNT ( * ) FROM tab3 AS cor0 WHERE NOT NULL = - ( - col0 ) + - 89
----
0

onlyif mysql # aggregate syntax: 
query I rowsort label-495
SELECT DISTINCT - COUNT( * ) FROM tab4 AS cor0 WHERE NOT NULL = - ( - col0 ) + - 89
----
0

skipif mysql # not compatible
query I rowsort label-495
SELECT DISTINCT - COUNT ( * ) FROM tab4 AS cor0 WHERE NOT NULL = - ( - col0 ) + - 89
----
0

query IIIIIII rowsort label-500
SELECT * FROM tab0 WHERE NOT + - col3 IS NOT NULL
----

query IIIIIII rowsort label-500
SELECT * FROM tab1 WHERE NOT + - col3 IS NOT NULL
----

query IIIIIII rowsort label-500
SELECT * FROM tab2 WHERE NOT + - col3 IS NOT NULL
----

query IIIIIII rowsort label-500
SELECT * FROM tab3 WHERE NOT + - col3 IS NOT NULL
----

query IIIIIII rowsort label-500
SELECT * FROM tab4 WHERE NOT + - col3 IS NOT NULL
----

query I rowsort label-505
SELECT DISTINCT + - col1 AS col0 FROM tab0 WHERE NOT col3 IS NOT NULL
----

query I rowsort label-505
SELECT DISTINCT + - col1 AS col0 FROM tab1 WHERE NOT col3 IS NOT NULL
----

query I rowsort label-505
SELECT DISTINCT + - col1 AS col0 FROM tab2 WHERE NOT col3 IS NOT NULL
----

query I rowsort label-505
SELECT DISTINCT + - col1 AS col0 FROM tab3 WHERE NOT col3 IS NOT NULL
----

query I rowsort label-505
SELECT DISTINCT + - col1 AS col0 FROM tab4 WHERE NOT col3 IS NOT NULL
----

onlyif mysql # aggregate syntax: 
query I rowsort label-510
SELECT DISTINCT + MIN( ALL col3 ) AS col4 FROM tab0 AS cor0 WHERE + 90 IS NOT NULL
----
1281

skipif mysql # not compatible
query I rowsort label-510
SELECT DISTINCT + MIN ( ALL col3 ) AS col4 FROM tab0 AS cor0 WHERE + 90 IS NOT NULL
----
1281

onlyif mysql # aggregate syntax: 
query I rowsort label-510
SELECT DISTINCT + MIN( ALL col3 ) AS col4 FROM tab1 AS cor0 WHERE + 90 IS NOT NULL
----
1281

skipif mysql # not compatible
query I rowsort label-510
SELECT DISTINCT + MIN ( ALL col3 ) AS col4 FROM tab1 AS cor0 WHERE + 90 IS NOT NULL
----
1281

onlyif mysql # aggregate syntax: 
query I rowsort label-510
SELECT DISTINCT + MIN( ALL col3 ) AS col4 FROM tab2 AS cor0 WHERE + 90 IS NOT NULL
----
1281

skipif mysql # not compatible
query I rowsort label-510
SELECT DISTINCT + MIN ( ALL col3 ) AS col4 FROM tab2 AS cor0 WHERE + 90 IS NOT NULL
----
1281

onlyif mysql # aggregate syntax: 
query I rowsort label-510
SELECT DISTINCT + MIN( ALL col3 ) AS col4 FROM tab3 AS cor0 WHERE + 90 IS NOT NULL
----
1281

skipif mysql # not compatible
query I rowsort label-510
SELECT DISTINCT + MIN ( ALL col3 ) AS col4 FROM tab3 AS cor0 WHERE + 90 IS NOT NULL
----
1281

onlyif mysql # aggregate syntax: 
query I rowsort label-510
SELECT DISTINCT + MIN( ALL col3 ) AS col4 FROM tab4 AS cor0 WHERE + 90 IS NOT NULL
----
1281

skipif mysql # not compatible
query I rowsort label-510
SELECT DISTINCT + MIN ( ALL col3 ) AS col4 FROM tab4 AS cor0 WHERE + 90 IS NOT NULL
----
1281

onlyif mysql # CAST syntax: SIGNED type: 
query I rowsort label-515
SELECT ALL + + col5 FROM tab0 AS cor0 WHERE CAST( + col3 AS SIGNED ) + 25 IS NULL
----

skipif mysql # not compatible
query I rowsort label-515
SELECT ALL + + col5 FROM tab0 AS cor0 WHERE CAST ( + col3 AS INTEGER ) + 25 IS NULL
----

onlyif mysql # CAST syntax: SIGNED type: 
query I rowsort label-515
SELECT ALL + + col5 FROM tab1 AS cor0 WHERE CAST( + col3 AS SIGNED ) + 25 IS NULL
----

skipif mysql # not compatible
query I rowsort label-515
SELECT ALL + + col5 FROM tab1 AS cor0 WHERE CAST ( + col3 AS INTEGER ) + 25 IS NULL
----

onlyif mysql # CAST syntax: SIGNED type: 
query I rowsort label-515
SELECT ALL + + col5 FROM tab2 AS cor0 WHERE CAST( + col3 AS SIGNED ) + 25 IS NULL
----

skipif mysql # not compatible
query I rowsort label-515
SELECT ALL + + col5 FROM tab2 AS cor0 WHERE CAST ( + col3 AS INTEGER ) + 25 IS NULL
----

onlyif mysql # CAST syntax: SIGNED type: 
query I rowsort label-515
SELECT ALL + + col5 FROM tab3 AS cor0 WHERE CAST( + col3 AS SIGNED ) + 25 IS NULL
----

skipif mysql # not compatible
query I rowsort label-515
SELECT ALL + + col5 FROM tab3 AS cor0 WHERE CAST ( + col3 AS INTEGER ) + 25 IS NULL
----

onlyif mysql # CAST syntax: SIGNED type: 
query I rowsort label-515
SELECT ALL + + col5 FROM tab4 AS cor0 WHERE CAST( + col3 AS SIGNED ) + 25 IS NULL
----

skipif mysql # not compatible
query I rowsort label-515
SELECT ALL + + col5 FROM tab4 AS cor0 WHERE CAST ( + col3 AS INTEGER ) + 25 IS NULL
----

query IIIIIII rowsort label-520
SELECT * FROM tab0 AS cor0 WHERE ( + - col4 - + col4 >= NULL )
----

query IIIIIII rowsort label-520
SELECT * FROM tab1 AS cor0 WHERE ( + - col4 - + col4 >= NULL )
----

query IIIIIII rowsort label-520
SELECT * FROM tab2 AS cor0 WHERE ( + - col4 - + col4 >= NULL )
----

query IIIIIII rowsort label-520
SELECT * FROM tab3 AS cor0 WHERE ( + - col4 - + col4 >= NULL )
----

query IIIIIII rowsort label-520
SELECT * FROM tab4 AS cor0 WHERE ( + - col4 - + col4 >= NULL )
----

onlyif mysql # CAST syntax: aggregate syntax: SIGNED type: 
query II rowsort label-525
SELECT ALL - + COUNT( * ) * + + 51 AS col2, - CAST( NULL AS SIGNED ) FROM tab0 AS cor0 WHERE NULL <> - col0
----
0
NULL

skipif mysql # not compatible
query II rowsort label-525
SELECT ALL - + COUNT ( * ) * + + 51 AS col2, - CAST ( NULL AS INTEGER ) FROM tab0 AS cor0 WHERE NULL <> - col0
----
0
NULL

onlyif mysql # CAST syntax: aggregate syntax: SIGNED type: 
query II rowsort label-525
SELECT ALL - + COUNT( * ) * + + 51 AS col2, - CAST( NULL AS SIGNED ) FROM tab1 AS cor0 WHERE NULL <> - col0
----
0
NULL

skipif mysql # not compatible
query II rowsort label-525
SELECT ALL - + COUNT ( * ) * + + 51 AS col2, - CAST ( NULL AS INTEGER ) FROM tab1 AS cor0 WHERE NULL <> - col0
----
0
NULL

onlyif mysql # CAST syntax: aggregate syntax: SIGNED type: 
query II rowsort label-525
SELECT ALL - + COUNT( * ) * + + 51 AS col2, - CAST( NULL AS SIGNED ) FROM tab2 AS cor0 WHERE NULL <> - col0
----
0
NULL

skipif mysql # not compatible
query II rowsort label-525
SELECT ALL - + COUNT ( * ) * + + 51 AS col2, - CAST ( NULL AS INTEGER ) FROM tab2 AS cor0 WHERE NULL <> - col0
----
0
NULL

onlyif mysql # CAST syntax: aggregate syntax: SIGNED type: 
query II rowsort label-525
SELECT ALL - + COUNT( * ) * + + 51 AS col2, - CAST( NULL AS SIGNED ) FROM tab3 AS cor0 WHERE NULL <> - col0
----
0
NULL

skipif mysql # not compatible
query II rowsort label-525
SELECT ALL - + COUNT ( * ) * + + 51 AS col2, - CAST ( NULL AS INTEGER ) FROM tab3 AS cor0 WHERE NULL <> - col0
----
0
NULL

onlyif mysql # CAST syntax: aggregate syntax: SIGNED type: 
query II rowsort label-525
SELECT ALL - + COUNT( * ) * + + 51 AS col2, - CAST( NULL AS SIGNED ) FROM tab4 AS cor0 WHERE NULL <> - col0
----
0
NULL

skipif mysql # not compatible
query II rowsort label-525
SELECT ALL - + COUNT ( * ) * + + 51 AS col2, - CAST ( NULL AS INTEGER ) FROM tab4 AS cor0 WHERE NULL <> - col0
----
0
NULL

query IIIIIII rowsort label-530
SELECT * FROM tab0 AS cor0 WHERE ( - 90 * col4 = NULL )
----

query IIIIIII rowsort label-530
SELECT * FROM tab1 AS cor0 WHERE ( - 90 * col4 = NULL )
----

query IIIIIII rowsort label-530
SELECT * FROM tab2 AS cor0 WHERE ( - 90 * col4 = NULL )
----

query IIIIIII rowsort label-530
SELECT * FROM tab3 AS cor0 WHERE ( - 90 * col4 = NULL )
----

query IIIIIII rowsort label-530
SELECT * FROM tab4 AS cor0 WHERE ( - 90 * col4 = NULL )
----

query I rowsort label-535
SELECT col3 FROM tab0 AS cor0 WHERE ( NOT + col3 = col0 - - col4 + col3 )
----
1000 values hashing to bfdd2bba6492501de7f490ea210e31cc

query I rowsort label-535
SELECT col3 FROM tab1 AS cor0 WHERE ( NOT + col3 = col0 - - col4 + col3 )
----
1000 values hashing to bfdd2bba6492501de7f490ea210e31cc

query I rowsort label-535
SELECT col3 FROM tab2 AS cor0 WHERE ( NOT + col3 = col0 - - col4 + col3 )
----
1000 values hashing to bfdd2bba6492501de7f490ea210e31cc

query I rowsort label-535
SELECT col3 FROM tab3 AS cor0 WHERE ( NOT + col3 = col0 - - col4 + col3 )
----
1000 values hashing to bfdd2bba6492501de7f490ea210e31cc

query I rowsort label-535
SELECT col3 FROM tab4 AS cor0 WHERE ( NOT + col3 = col0 - - col4 + col3 )
----
1000 values hashing to bfdd2bba6492501de7f490ea210e31cc

query IIIIIII rowsort label-540
SELECT * FROM tab0 WHERE NOT col0 IS NOT NULL
----

query IIIIIII rowsort label-540
SELECT * FROM tab1 WHERE NOT col0 IS NOT NULL
----

query IIIIIII rowsort label-540
SELECT * FROM tab2 WHERE NOT col0 IS NOT NULL
----

query IIIIIII rowsort label-540
SELECT * FROM tab3 WHERE NOT col0 IS NOT NULL
----

query IIIIIII rowsort label-540
SELECT * FROM tab4 WHERE NOT col0 IS NOT NULL
----

query IIIIIII rowsort label-545
SELECT * FROM tab0 AS cor0 WHERE + 64 IS NULL
----

query IIIIIII rowsort label-545
SELECT * FROM tab1 AS cor0 WHERE + 64 IS NULL
----

query IIIIIII rowsort label-545
SELECT * FROM tab2 AS cor0 WHERE + 64 IS NULL
----

query IIIIIII rowsort label-545
SELECT * FROM tab3 AS cor0 WHERE + 64 IS NULL
----

query IIIIIII rowsort label-545
SELECT * FROM tab4 AS cor0 WHERE + 64 IS NULL
----

query IIIIIII rowsort label-550
SELECT ALL * FROM tab0 AS cor0 WHERE NOT col1 <= NULL
----

query IIIIIII rowsort label-550
SELECT ALL * FROM tab1 AS cor0 WHERE NOT col1 <= NULL
----

query IIIIIII rowsort label-550
SELECT ALL * FROM tab2 AS cor0 WHERE NOT col1 <= NULL
----

query IIIIIII rowsort label-550
SELECT ALL * FROM tab3 AS cor0 WHERE NOT col1 <= NULL
----

query IIIIIII rowsort label-550
SELECT ALL * FROM tab4 AS cor0 WHERE NOT col1 <= NULL
----

onlyif mysql # CAST syntax: DECIMAL type: 
query I rowsort label-555
SELECT DISTINCT + CAST( NULL AS DECIMAL ) - + 80 AS col2 FROM tab0 WHERE NOT + 43 IS NULL
----
NULL

skipif mysql # not compatible
query I rowsort label-555
SELECT DISTINCT + CAST ( NULL AS REAL ) - + 80 AS col2 FROM tab0 WHERE NOT + 43 IS NULL
----
NULL

onlyif mysql # CAST syntax: DECIMAL type: 
query I rowsort label-555
SELECT DISTINCT + CAST( NULL AS DECIMAL ) - + 80 AS col2 FROM tab1 WHERE NOT + 43 IS NULL
----
NULL

skipif mysql # not compatible
query I rowsort label-555
SELECT DISTINCT + CAST ( NULL AS REAL ) - + 80 AS col2 FROM tab1 WHERE NOT + 43 IS NULL
----
NULL

onlyif mysql # CAST syntax: DECIMAL type: 
query I rowsort label-555
SELECT DISTINCT + CAST( NULL AS DECIMAL ) - + 80 AS col2 FROM tab2 WHERE NOT + 43 IS NULL
----
NULL

skipif mysql # not compatible
query I rowsort label-555
SELECT DISTINCT + CAST ( NULL AS REAL ) - + 80 AS col2 FROM tab2 WHERE NOT + 43 IS NULL
----
NULL

onlyif mysql # CAST syntax: DECIMAL type: 
query I rowsort label-555
SELECT DISTINCT + CAST( NULL AS DECIMAL ) - + 80 AS col2 FROM tab3 WHERE NOT + 43 IS NULL
----
NULL

skipif mysql # not compatible
query I rowsort label-555
SELECT DISTINCT + CAST ( NULL AS REAL ) - + 80 AS col2 FROM tab3 WHERE NOT + 43 IS NULL
----
NULL

onlyif mysql # CAST syntax: DECIMAL type: 
query I rowsort label-555
SELECT DISTINCT + CAST( NULL AS DECIMAL ) - + 80 AS col2 FROM tab4 WHERE NOT + 43 IS NULL
----
NULL

skipif mysql # not compatible
query I rowsort label-555
SELECT DISTINCT + CAST ( NULL AS REAL ) - + 80 AS col2 FROM tab4 WHERE NOT + 43 IS NULL
----
NULL

query IIIIIII rowsort label-560
SELECT ALL * FROM tab0 WHERE col3 BETWEEN NULL AND NULL
----

query IIIIIII rowsort label-560
SELECT ALL * FROM tab1 WHERE col3 BETWEEN NULL AND NULL
----

query IIIIIII rowsort label-560
SELECT ALL * FROM tab2 WHERE col3 BETWEEN NULL AND NULL
----

query IIIIIII rowsort label-560
SELECT ALL * FROM tab3 WHERE col3 BETWEEN NULL AND NULL
----

query IIIIIII rowsort label-560
SELECT ALL * FROM tab4 WHERE col3 BETWEEN NULL AND NULL
----

query IIIIIII rowsort label-565
SELECT ALL * FROM tab0 AS cor0 WHERE - ( - 90 ) IS NULL
----

query IIIIIII rowsort label-565
SELECT ALL * FROM tab1 AS cor0 WHERE - ( - 90 ) IS NULL
----

query IIIIIII rowsort label-565
SELECT ALL * FROM tab2 AS cor0 WHERE - ( - 90 ) IS NULL
----

query IIIIIII rowsort label-565
SELECT ALL * FROM tab3 AS cor0 WHERE - ( - 90 ) IS NULL
----

query IIIIIII rowsort label-565
SELECT ALL * FROM tab4 AS cor0 WHERE - ( - 90 ) IS NULL
----

query IIIIIII rowsort label-570
SELECT * FROM tab0 AS cor0 WHERE NOT - col4 IS NOT NULL
----

query IIIIIII rowsort label-570
SELECT * FROM tab1 AS cor0 WHERE NOT - col4 IS NOT NULL
----

query IIIIIII rowsort label-570
SELECT * FROM tab2 AS cor0 WHERE NOT - col4 IS NOT NULL
----

query IIIIIII rowsort label-570
SELECT * FROM tab3 AS cor0 WHERE NOT - col4 IS NOT NULL
----

query IIIIIII rowsort label-570
SELECT * FROM tab4 AS cor0 WHERE NOT - col4 IS NOT NULL
----

query I rowsort label-575
SELECT DISTINCT - 8 AS col2 FROM tab0 AS cor0 WHERE + 35 IN ( - 10 / + col4 )
----

query I rowsort label-575
SELECT DISTINCT - 8 AS col2 FROM tab1 AS cor0 WHERE + 35 IN ( - 10 / + col4 )
----

query I rowsort label-575
SELECT DISTINCT - 8 AS col2 FROM tab2 AS cor0 WHERE + 35 IN ( - 10 / + col4 )
----

query I rowsort label-575
SELECT DISTINCT - 8 AS col2 FROM tab3 AS cor0 WHERE + 35 IN ( - 10 / + col4 )
----

query I rowsort label-575
SELECT DISTINCT - 8 AS col2 FROM tab4 AS cor0 WHERE + 35 IN ( - 10 / + col4 )
----

query IIIIIII rowsort label-580
SELECT * FROM tab0 WHERE NULL < + col1
----

query IIIIIII rowsort label-580
SELECT * FROM tab1 WHERE NULL < + col1
----

query IIIIIII rowsort label-580
SELECT * FROM tab2 WHERE NULL < + col1
----

query IIIIIII rowsort label-580
SELECT * FROM tab3 WHERE NULL < + col1
----

query IIIIIII rowsort label-580
SELECT * FROM tab4 WHERE NULL < + col1
----

onlyif mysql # aggregate syntax: 
query I rowsort label-585
SELECT ALL + COUNT( * ) col5 FROM tab0 WHERE NOT 8 + 48 > 25 * - col1 / 79 - - 60
----
0

skipif mysql # not compatible
skipif postgresql # PostgreSQL requires AS when renaming output columns
query I rowsort label-585
SELECT ALL + COUNT ( * ) col5 FROM tab0 WHERE NOT 8 + 48 > 25 * - col1 / 79 - - 60
----
0

onlyif mysql # aggregate syntax: 
query I rowsort label-585
SELECT ALL + COUNT( * ) col5 FROM tab1 WHERE NOT 8 + 48 > 25 * - col1 / 79 - - 60
----
0

skipif mysql # not compatible
skipif postgresql # PostgreSQL requires AS when renaming output columns
query I rowsort label-585
SELECT ALL + COUNT ( * ) col5 FROM tab1 WHERE NOT 8 + 48 > 25 * - col1 / 79 - - 60
----
0

onlyif mysql # aggregate syntax: 
query I rowsort label-585
SELECT ALL + COUNT( * ) col5 FROM tab2 WHERE NOT 8 + 48 > 25 * - col1 / 79 - - 60
----
0

skipif mysql # not compatible
skipif postgresql # PostgreSQL requires AS when renaming output columns
query I rowsort label-585
SELECT ALL + COUNT ( * ) col5 FROM tab2 WHERE NOT 8 + 48 > 25 * - col1 / 79 - - 60
----
0

onlyif mysql # aggregate syntax: 
query I rowsort label-585
SELECT ALL + COUNT( * ) col5 FROM tab3 WHERE NOT 8 + 48 > 25 * - col1 / 79 - - 60
----
0

skipif mysql # not compatible
skipif postgresql # PostgreSQL requires AS when renaming output columns
query I rowsort label-585
SELECT ALL + COUNT ( * ) col5 FROM tab3 WHERE NOT 8 + 48 > 25 * - col1 / 79 - - 60
----
0

onlyif mysql # aggregate syntax: 
query I rowsort label-585
SELECT ALL + COUNT( * ) col5 FROM tab4 WHERE NOT 8 + 48 > 25 * - col1 / 79 - - 60
----
0

skipif mysql # not compatible
skipif postgresql # PostgreSQL requires AS when renaming output columns
query I rowsort label-585
SELECT ALL + COUNT ( * ) col5 FROM tab4 WHERE NOT 8 + 48 > 25 * - col1 / 79 - - 60
----
0

query IIIIIII rowsort label-590
SELECT * FROM tab0 AS cor0 WHERE NOT 79 + + col4 IS NOT NULL
----

query IIIIIII rowsort label-590
SELECT * FROM tab1 AS cor0 WHERE NOT 79 + + col4 IS NOT NULL
----

query IIIIIII rowsort label-590
SELECT * FROM tab2 AS cor0 WHERE NOT 79 + + col4 IS NOT NULL
----

query IIIIIII rowsort label-590
SELECT * FROM tab3 AS cor0 WHERE NOT 79 + + col4 IS NOT NULL
----

query IIIIIII rowsort label-590
SELECT * FROM tab4 AS cor0 WHERE NOT 79 + + col4 IS NOT NULL
----

query I rowsort label-595
SELECT col5 AS col5 FROM tab0 cor0 WHERE NOT NULL BETWEEN 30 AND ( col3 )
----

query I rowsort label-595
SELECT col5 AS col5 FROM tab1 cor0 WHERE NOT NULL BETWEEN 30 AND ( col3 )
----

query I rowsort label-595
SELECT col5 AS col5 FROM tab2 cor0 WHERE NOT NULL BETWEEN 30 AND ( col3 )
----

query I rowsort label-595
SELECT col5 AS col5 FROM tab3 cor0 WHERE NOT NULL BETWEEN 30 AND ( col3 )
----

query I rowsort label-595
SELECT col5 AS col5 FROM tab4 cor0 WHERE NOT NULL BETWEEN 30 AND ( col3 )
----

onlyif mysql # CAST syntax: SIGNED type: 
query IIIIIII rowsort label-600
SELECT * FROM tab0 WHERE NOT - CAST( NULL AS SIGNED ) - col3 NOT BETWEEN - col4 AND NULL
----

skipif mysql # not compatible
query IIIIIII rowsort label-600
SELECT * FROM tab0 WHERE NOT - CAST ( NULL AS INTEGER ) - col3 NOT BETWEEN - col4 AND NULL
----

onlyif mysql # CAST syntax: SIGNED type: 
query IIIIIII rowsort label-600
SELECT * FROM tab1 WHERE NOT - CAST( NULL AS SIGNED ) - col3 NOT BETWEEN - col4 AND NULL
----

skipif mysql # not compatible
query IIIIIII rowsort label-600
SELECT * FROM tab1 WHERE NOT - CAST ( NULL AS INTEGER ) - col3 NOT BETWEEN - col4 AND NULL
----

onlyif mysql # CAST syntax: SIGNED type: 
query IIIIIII rowsort label-600
SELECT * FROM tab2 WHERE NOT - CAST( NULL AS SIGNED ) - col3 NOT BETWEEN - col4 AND NULL
----

skipif mysql # not compatible
query IIIIIII rowsort label-600
SELECT * FROM tab2 WHERE NOT - CAST ( NULL AS INTEGER ) - col3 NOT BETWEEN - col4 AND NULL
----

onlyif mysql # CAST syntax: SIGNED type: 
query IIIIIII rowsort label-600
SELECT * FROM tab3 WHERE NOT - CAST( NULL AS SIGNED ) - col3 NOT BETWEEN - col4 AND NULL
----

skipif mysql # not compatible
query IIIIIII rowsort label-600
SELECT * FROM tab3 WHERE NOT - CAST ( NULL AS INTEGER ) - col3 NOT BETWEEN - col4 AND NULL
----

onlyif mysql # CAST syntax: SIGNED type: 
query IIIIIII rowsort label-600
SELECT * FROM tab4 WHERE NOT - CAST( NULL AS SIGNED ) - col3 NOT BETWEEN - col4 AND NULL
----

skipif mysql # not compatible
query IIIIIII rowsort label-600
SELECT * FROM tab4 WHERE NOT - CAST ( NULL AS INTEGER ) - col3 NOT BETWEEN - col4 AND NULL
----

onlyif mysql # CAST syntax: SIGNED type: 
query I rowsort label-605
SELECT ALL + CAST( NULL AS SIGNED ) AS col5 FROM tab0 WHERE + col3 = 71
----

skipif mysql # not compatible
query I rowsort label-605
SELECT ALL + CAST ( NULL AS INTEGER ) AS col5 FROM tab0 WHERE + col3 = 71
----

onlyif mysql # CAST syntax: SIGNED type: 
query I rowsort label-605
SELECT ALL + CAST( NULL AS SIGNED ) AS col5 FROM tab1 WHERE + col3 = 71
----

skipif mysql # not compatible
query I rowsort label-605
SELECT ALL + CAST ( NULL AS INTEGER ) AS col5 FROM tab1 WHERE + col3 = 71
----

onlyif mysql # CAST syntax: SIGNED type: 
query I rowsort label-605
SELECT ALL + CAST( NULL AS SIGNED ) AS col5 FROM tab2 WHERE + col3 = 71
----

skipif mysql # not compatible
query I rowsort label-605
SELECT ALL + CAST ( NULL AS INTEGER ) AS col5 FROM tab2 WHERE + col3 = 71
----

onlyif mysql # CAST syntax: SIGNED type: 
query I rowsort label-605
SELECT ALL + CAST( NULL AS SIGNED ) AS col5 FROM tab3 WHERE + col3 = 71
----

skipif mysql # not compatible
query I rowsort label-605
SELECT ALL + CAST ( NULL AS INTEGER ) AS col5 FROM tab3 WHERE + col3 = 71
----

onlyif mysql # CAST syntax: SIGNED type: 
query I rowsort label-605
SELECT ALL + CAST( NULL AS SIGNED ) AS col5 FROM tab4 WHERE + col3 = 71
----

skipif mysql # not compatible
query I rowsort label-605
SELECT ALL + CAST ( NULL AS INTEGER ) AS col5 FROM tab4 WHERE + col3 = 71
----

onlyif mysql # CAST syntax: SIGNED type: 
query IIIIIII rowsort label-610
SELECT * FROM tab0 WHERE NOT - CAST( col1 AS SIGNED ) * + col0 NOT BETWEEN NULL AND ( NULL )
----

skipif mysql # not compatible
query IIIIIII rowsort label-610
SELECT * FROM tab0 WHERE NOT - CAST ( col1 AS INTEGER ) * + col0 NOT BETWEEN NULL AND ( NULL )
----

onlyif mysql # CAST syntax: SIGNED type: 
query IIIIIII rowsort label-610
SELECT * FROM tab1 WHERE NOT - CAST( col1 AS SIGNED ) * + col0 NOT BETWEEN NULL AND ( NULL )
----

skipif mysql # not compatible
query IIIIIII rowsort label-610
SELECT * FROM tab1 WHERE NOT - CAST ( col1 AS INTEGER ) * + col0 NOT BETWEEN NULL AND ( NULL )
----

onlyif mysql # CAST syntax: SIGNED type: 
query IIIIIII rowsort label-610
SELECT * FROM tab2 WHERE NOT - CAST( col1 AS SIGNED ) * + col0 NOT BETWEEN NULL AND ( NULL )
----

skipif mysql # not compatible
query IIIIIII rowsort label-610
SELECT * FROM tab2 WHERE NOT - CAST ( col1 AS INTEGER ) * + col0 NOT BETWEEN NULL AND ( NULL )
----

onlyif mysql # CAST syntax: SIGNED type: 
query IIIIIII rowsort label-610
SELECT * FROM tab3 WHERE NOT - CAST( col1 AS SIGNED ) * + col0 NOT BETWEEN NULL AND ( NULL )
----

skipif mysql # not compatible
query IIIIIII rowsort label-610
SELECT * FROM tab3 WHERE NOT - CAST ( col1 AS INTEGER ) * + col0 NOT BETWEEN NULL AND ( NULL )
----

onlyif mysql # CAST syntax: SIGNED type: 
query IIIIIII rowsort label-610
SELECT * FROM tab4 WHERE NOT - CAST( col1 AS SIGNED ) * + col0 NOT BETWEEN NULL AND ( NULL )
----

skipif mysql # not compatible
query IIIIIII rowsort label-610
SELECT * FROM tab4 WHERE NOT - CAST ( col1 AS INTEGER ) * + col0 NOT BETWEEN NULL AND ( NULL )
----

query IIIIIII rowsort label-615
SELECT * FROM tab0 WHERE NOT - col3 + - 91 NOT BETWEEN col3 / col0 AND 35 + 43
----

query IIIIIII rowsort label-615
SELECT * FROM tab1 WHERE NOT - col3 + - 91 NOT BETWEEN col3 / col0 AND 35 + 43
----

query IIIIIII rowsort label-615
SELECT * FROM tab2 WHERE NOT - col3 + - 91 NOT BETWEEN col3 / col0 AND 35 + 43
----

query IIIIIII rowsort label-615
SELECT * FROM tab3 WHERE NOT - col3 + - 91 NOT BETWEEN col3 / col0 AND 35 + 43
----

query IIIIIII rowsort label-615
SELECT * FROM tab4 WHERE NOT - col3 + - 91 NOT BETWEEN col3 / col0 AND 35 + 43
----

query IIIIIII rowsort label-620
SELECT ALL * FROM tab0 WHERE NULL >= NULL
----

query IIIIIII rowsort label-620
SELECT ALL * FROM tab1 WHERE NULL >= NULL
----

query IIIIIII rowsort label-620
SELECT ALL * FROM tab2 WHERE NULL >= NULL
----

query IIIIIII rowsort label-620
SELECT ALL * FROM tab3 WHERE NULL >= NULL
----

query IIIIIII rowsort label-620
SELECT ALL * FROM tab4 WHERE NULL >= NULL
----

onlyif mysql # aggregate syntax: 
query I rowsort label-625
SELECT COUNT( DISTINCT - col3 ) FROM tab0 WHERE NOT col1 IN ( + ( col0 ) + 79 )
----
1000

skipif mysql # not compatible
query I rowsort label-625
SELECT COUNT ( DISTINCT - col3 ) FROM tab0 WHERE NOT col1 IN ( + ( col0 ) + 79 )
----
1000

onlyif mysql # aggregate syntax: 
query I rowsort label-625
SELECT COUNT( DISTINCT - col3 ) FROM tab1 WHERE NOT col1 IN ( + ( col0 ) + 79 )
----
1000

skipif mysql # not compatible
query I rowsort label-625
SELECT COUNT ( DISTINCT - col3 ) FROM tab1 WHERE NOT col1 IN ( + ( col0 ) + 79 )
----
1000

onlyif mysql # aggregate syntax: 
query I rowsort label-625
SELECT COUNT( DISTINCT - col3 ) FROM tab2 WHERE NOT col1 IN ( + ( col0 ) + 79 )
----
1000

skipif mysql # not compatible
query I rowsort label-625
SELECT COUNT ( DISTINCT - col3 ) FROM tab2 WHERE NOT col1 IN ( + ( col0 ) + 79 )
----
1000

onlyif mysql # aggregate syntax: 
query I rowsort label-625
SELECT COUNT( DISTINCT - col3 ) FROM tab3 WHERE NOT col1 IN ( + ( col0 ) + 79 )
----
1000

skipif mysql # not compatible
query I rowsort label-625
SELECT COUNT ( DISTINCT - col3 ) FROM tab3 WHERE NOT col1 IN ( + ( col0 ) + 79 )
----
1000

onlyif mysql # aggregate syntax: 
query I rowsort label-625
SELECT COUNT( DISTINCT - col3 ) FROM tab4 WHERE NOT col1 IN ( + ( col0 ) + 79 )
----
1000

skipif mysql # not compatible
query I rowsort label-625
SELECT COUNT ( DISTINCT - col3 ) FROM tab4 WHERE NOT col1 IN ( + ( col0 ) + 79 )
----
1000

query I rowsort label-630
SELECT DISTINCT 8 + 63 FROM tab0 WHERE NOT col4 + - col3 >= col3
----
71

query I rowsort label-630
SELECT DISTINCT 8 + 63 FROM tab1 WHERE NOT col4 + - col3 >= col3
----
71

query I rowsort label-630
SELECT DISTINCT 8 + 63 FROM tab2 WHERE NOT col4 + - col3 >= col3
----
71

query I rowsort label-630
SELECT DISTINCT 8 + 63 FROM tab3 WHERE NOT col4 + - col3 >= col3
----
71

query I rowsort label-630
SELECT DISTINCT 8 + 63 FROM tab4 WHERE NOT col4 + - col3 >= col3
----
71

onlyif mysql # aggregate syntax: 
query I rowsort label-635
SELECT ALL - SUM( + col1 ) FROM tab0 WHERE 85 IN ( col3 )
----
NULL

skipif mysql # not compatible
query I rowsort label-635
SELECT ALL - SUM ( + col1 ) FROM tab0 WHERE 85 IN ( col3 )
----
NULL

onlyif mysql # aggregate syntax: 
query I rowsort label-635
SELECT ALL - SUM( + col1 ) FROM tab1 WHERE 85 IN ( col3 )
----
NULL

skipif mysql # not compatible
query I rowsort label-635
SELECT ALL - SUM ( + col1 ) FROM tab1 WHERE 85 IN ( col3 )
----
NULL

onlyif mysql # aggregate syntax: 
query I rowsort label-635
SELECT ALL - SUM( + col1 ) FROM tab2 WHERE 85 IN ( col3 )
----
NULL

skipif mysql # not compatible
query I rowsort label-635
SELECT ALL - SUM ( + col1 ) FROM tab2 WHERE 85 IN ( col3 )
----
NULL

onlyif mysql # aggregate syntax: 
query I rowsort label-635
SELECT ALL - SUM( + col1 ) FROM tab3 WHERE 85 IN ( col3 )
----
NULL

skipif mysql # not compatible
query I rowsort label-635
SELECT ALL - SUM ( + col1 ) FROM tab3 WHERE 85 IN ( col3 )
----
NULL

onlyif mysql # aggregate syntax: 
query I rowsort label-635
SELECT ALL - SUM( + col1 ) FROM tab4 WHERE 85 IN ( col3 )
----
NULL

skipif mysql # not compatible
query I rowsort label-635
SELECT ALL - SUM ( + col1 ) FROM tab4 WHERE 85 IN ( col3 )
----
NULL

query I rowsort label-640
SELECT + col0 * col0 FROM tab0 WHERE NOT NULL IN ( + 25 / - col0 )
----

query I rowsort label-640
SELECT + col0 * col0 FROM tab1 WHERE NOT NULL IN ( + 25 / - col0 )
----

query I rowsort label-640
SELECT + col0 * col0 FROM tab2 WHERE NOT NULL IN ( + 25 / - col0 )
----

query I rowsort label-640
SELECT + col0 * col0 FROM tab3 WHERE NOT NULL IN ( + 25 / - col0 )
----

query I rowsort label-640
SELECT + col0 * col0 FROM tab4 WHERE NOT NULL IN ( + 25 / - col0 )
----

onlyif mysql # aggregate syntax: 
query I rowsort label-645
SELECT ALL COUNT( * ) FROM tab0 WHERE col2 IS NOT NULL
----
1000

skipif mysql # not compatible
query I rowsort label-645
SELECT ALL COUNT ( * ) FROM tab0 WHERE col2 IS NOT NULL
----
1000

onlyif mysql # aggregate syntax: 
query I rowsort label-645
SELECT ALL COUNT( * ) FROM tab1 WHERE col2 IS NOT NULL
----
1000

skipif mysql # not compatible
query I rowsort label-645
SELECT ALL COUNT ( * ) FROM tab1 WHERE col2 IS NOT NULL
----
1000

onlyif mysql # aggregate syntax: 
query I rowsort label-645
SELECT ALL COUNT( * ) FROM tab2 WHERE col2 IS NOT NULL
----
1000

skipif mysql # not compatible
query I rowsort label-645
SELECT ALL COUNT ( * ) FROM tab2 WHERE col2 IS NOT NULL
----
1000

onlyif mysql # aggregate syntax: 
query I rowsort label-645
SELECT ALL COUNT( * ) FROM tab3 WHERE col2 IS NOT NULL
----
1000

skipif mysql # not compatible
query I rowsort label-645
SELECT ALL COUNT ( * ) FROM tab3 WHERE col2 IS NOT NULL
----
1000

onlyif mysql # aggregate syntax: 
query I rowsort label-645
SELECT ALL COUNT( * ) FROM tab4 WHERE col2 IS NOT NULL
----
1000

skipif mysql # not compatible
query I rowsort label-645
SELECT ALL COUNT ( * ) FROM tab4 WHERE col2 IS NOT NULL
----
1000

onlyif mysql # CAST syntax: SIGNED type: 
query I rowsort label-650
SELECT CAST( + col0 AS SIGNED ) FROM tab0 WHERE - col0 NOT IN ( - col1 * col1 )
----
1000 values hashing to 246e64dff83b87422885732f0ed3966f

skipif mysql # not compatible
query I rowsort label-650
SELECT CAST ( + col0 AS INTEGER ) FROM tab0 WHERE - col0 NOT IN ( - col1 * col1 )
----
1000 values hashing to 246e64dff83b87422885732f0ed3966f

onlyif mysql # CAST syntax: SIGNED type: 
query I rowsort label-650
SELECT CAST( + col0 AS SIGNED ) FROM tab1 WHERE - col0 NOT IN ( - col1 * col1 )
----
1000 values hashing to 246e64dff83b87422885732f0ed3966f

skipif mysql # not compatible
query I rowsort label-650
SELECT CAST ( + col0 AS INTEGER ) FROM tab1 WHERE - col0 NOT IN ( - col1 * col1 )
----
1000 values hashing to 246e64dff83b87422885732f0ed3966f

onlyif mysql # CAST syntax: SIGNED type: 
query I rowsort label-650
SELECT CAST( + col0 AS SIGNED ) FROM tab2 WHERE - col0 NOT IN ( - col1 * col1 )
----
1000 values hashing to 246e64dff83b87422885732f0ed3966f

skipif mysql # not compatible
query I rowsort label-650
SELECT CAST ( + col0 AS INTEGER ) FROM tab2 WHERE - col0 NOT IN ( - col1 * col1 )
----
1000 values hashing to 246e64dff83b87422885732f0ed3966f

onlyif mysql # CAST syntax: SIGNED type: 
query I rowsort label-650
SELECT CAST( + col0 AS SIGNED ) FROM tab3 WHERE - col0 NOT IN ( - col1 * col1 )
----
1000 values hashing to 246e64dff83b87422885732f0ed3966f

skipif mysql # not compatible
query I rowsort label-650
SELECT CAST ( + col0 AS INTEGER ) FROM tab3 WHERE - col0 NOT IN ( - col1 * col1 )
----
1000 values hashing to 246e64dff83b87422885732f0ed3966f

onlyif mysql # CAST syntax: SIGNED type: 
query I rowsort label-650
SELECT CAST( + col0 AS SIGNED ) FROM tab4 WHERE - col0 NOT IN ( - col1 * col1 )
----
1000 values hashing to 246e64dff83b87422885732f0ed3966f

skipif mysql # not compatible
query I rowsort label-650
SELECT CAST ( + col0 AS INTEGER ) FROM tab4 WHERE - col0 NOT IN ( - col1 * col1 )
----
1000 values hashing to 246e64dff83b87422885732f0ed3966f

onlyif mysql # aggregate syntax: 
query I rowsort label-655
SELECT + COUNT( * ) AS col0 FROM tab0 WHERE NOT - col3 * - 94 IS NOT NULL
----
0

skipif mysql # not compatible
query I rowsort label-655
SELECT + COUNT ( * ) AS col0 FROM tab0 WHERE NOT - col3 * - 94 IS NOT NULL
----
0

onlyif mysql # aggregate syntax: 
query I rowsort label-655
SELECT + COUNT( * ) AS col0 FROM tab1 WHERE NOT - col3 * - 94 IS NOT NULL
----
0

skipif mysql # not compatible
query I rowsort label-655
SELECT + COUNT ( * ) AS col0 FROM tab1 WHERE NOT - col3 * - 94 IS NOT NULL
----
0

onlyif mysql # aggregate syntax: 
query I rowsort label-655
SELECT + COUNT( * ) AS col0 FROM tab2 WHERE NOT - col3 * - 94 IS NOT NULL
----
0

skipif mysql # not compatible
query I rowsort label-655
SELECT + COUNT ( * ) AS col0 FROM tab2 WHERE NOT - col3 * - 94 IS NOT NULL
----
0

onlyif mysql # aggregate syntax: 
query I rowsort label-655
SELECT + COUNT( * ) AS col0 FROM tab3 WHERE NOT - col3 * - 94 IS NOT NULL
----
0

skipif mysql # not compatible
query I rowsort label-655
SELECT + COUNT ( * ) AS col0 FROM tab3 WHERE NOT - col3 * - 94 IS NOT NULL
----
0

onlyif mysql # aggregate syntax: 
query I rowsort label-655
SELECT + COUNT( * ) AS col0 FROM tab4 WHERE NOT - col3 * - 94 IS NOT NULL
----
0

skipif mysql # not compatible
query I rowsort label-655
SELECT + COUNT ( * ) AS col0 FROM tab4 WHERE NOT - col3 * - 94 IS NOT NULL
----
0

query IIIIIII rowsort label-660
SELECT * FROM tab0 WHERE NOT 39 + + col0 IS NOT NULL
----

query IIIIIII rowsort label-660
SELECT * FROM tab1 WHERE NOT 39 + + col0 IS NOT NULL
----

query IIIIIII rowsort label-660
SELECT * FROM tab2 WHERE NOT 39 + + col0 IS NOT NULL
----

query IIIIIII rowsort label-660
SELECT * FROM tab3 WHERE NOT 39 + + col0 IS NOT NULL
----

query IIIIIII rowsort label-660
SELECT * FROM tab4 WHERE NOT 39 + + col0 IS NOT NULL
----

query I rowsort label-665
SELECT DISTINCT - 72 AS col4 FROM tab0 WHERE NULL IS NOT NULL
----

query I rowsort label-665
SELECT DISTINCT - 72 AS col4 FROM tab1 WHERE NULL IS NOT NULL
----

query I rowsort label-665
SELECT DISTINCT - 72 AS col4 FROM tab2 WHERE NULL IS NOT NULL
----

query I rowsort label-665
SELECT DISTINCT - 72 AS col4 FROM tab3 WHERE NULL IS NOT NULL
----

query I rowsort label-665
SELECT DISTINCT - 72 AS col4 FROM tab4 WHERE NULL IS NOT NULL
----

query IIIIIII rowsort label-670
SELECT ALL * FROM tab0 WHERE col0 = + 59 * col1
----

query IIIIIII rowsort label-670
SELECT ALL * FROM tab1 WHERE col0 = + 59 * col1
----

query IIIIIII rowsort label-670
SELECT ALL * FROM tab2 WHERE col0 = + 59 * col1
----

query IIIIIII rowsort label-670
SELECT ALL * FROM tab3 WHERE col0 = + 59 * col1
----

query IIIIIII rowsort label-670
SELECT ALL * FROM tab4 WHERE col0 = + 59 * col1
----

query IIIIIII rowsort label-675
SELECT * FROM tab0 WHERE NOT 30 * + 78 IS NOT NULL
----

query IIIIIII rowsort label-675
SELECT * FROM tab1 WHERE NOT 30 * + 78 IS NOT NULL
----

query IIIIIII rowsort label-675
SELECT * FROM tab2 WHERE NOT 30 * + 78 IS NOT NULL
----

query IIIIIII rowsort label-675
SELECT * FROM tab3 WHERE NOT 30 * + 78 IS NOT NULL
----

query IIIIIII rowsort label-675
SELECT * FROM tab4 WHERE NOT 30 * + 78 IS NOT NULL
----

query IIIIIII rowsort label-680
SELECT * FROM tab0 WHERE 15 + + 32 IS NULL
----

query IIIIIII rowsort label-680
SELECT * FROM tab1 WHERE 15 + + 32 IS NULL
----

query IIIIIII rowsort label-680
SELECT * FROM tab2 WHERE 15 + + 32 IS NULL
----

query IIIIIII rowsort label-680
SELECT * FROM tab3 WHERE 15 + + 32 IS NULL
----

query IIIIIII rowsort label-680
SELECT * FROM tab4 WHERE 15 + + 32 IS NULL
----

query I rowsort label-685
SELECT + 74 FROM tab0 WHERE NOT ( + col5 ) IS NULL
----
1000 values hashing to 085c7bd238cc783adfc37b6a15e693f8

query I rowsort label-685
SELECT + 74 FROM tab1 WHERE NOT ( + col5 ) IS NULL
----
1000 values hashing to 085c7bd238cc783adfc37b6a15e693f8

query I rowsort label-685
SELECT + 74 FROM tab2 WHERE NOT ( + col5 ) IS NULL
----
1000 values hashing to 085c7bd238cc783adfc37b6a15e693f8

query I rowsort label-685
SELECT + 74 FROM tab3 WHERE NOT ( + col5 ) IS NULL
----
1000 values hashing to 085c7bd238cc783adfc37b6a15e693f8

query I rowsort label-685
SELECT + 74 FROM tab4 WHERE NOT ( + col5 ) IS NULL
----
1000 values hashing to 085c7bd238cc783adfc37b6a15e693f8

query IIIIIII rowsort label-690
SELECT * FROM tab0 WHERE NOT + col1 IS NOT NULL
----

query IIIIIII rowsort label-690
SELECT * FROM tab1 WHERE NOT + col1 IS NOT NULL
----

query IIIIIII rowsort label-690
SELECT * FROM tab2 WHERE NOT + col1 IS NOT NULL
----

query IIIIIII rowsort label-690
SELECT * FROM tab3 WHERE NOT + col1 IS NOT NULL
----

query IIIIIII rowsort label-690
SELECT * FROM tab4 WHERE NOT + col1 IS NOT NULL
----

query IIIIIII rowsort label-695
SELECT ALL * FROM tab0 WHERE ( NULL ) <> NULL
----

query IIIIIII rowsort label-695
SELECT ALL * FROM tab1 WHERE ( NULL ) <> NULL
----

query IIIIIII rowsort label-695
SELECT ALL * FROM tab2 WHERE ( NULL ) <> NULL
----

query IIIIIII rowsort label-695
SELECT ALL * FROM tab3 WHERE ( NULL ) <> NULL
----

query IIIIIII rowsort label-695
SELECT ALL * FROM tab4 WHERE ( NULL ) <> NULL
----

query IIIIIII rowsort label-700
SELECT * FROM tab0 WHERE NOT 51 * - 84 IS NOT NULL
----

query IIIIIII rowsort label-700
SELECT * FROM tab1 WHERE NOT 51 * - 84 IS NOT NULL
----

query IIIIIII rowsort label-700
SELECT * FROM tab2 WHERE NOT 51 * - 84 IS NOT NULL
----

query IIIIIII rowsort label-700
SELECT * FROM tab3 WHERE NOT 51 * - 84 IS NOT NULL
----

query IIIIIII rowsort label-700
SELECT * FROM tab4 WHERE NOT 51 * - 84 IS NOT NULL
----

onlyif mysql # aggregate syntax: 
query I rowsort label-705
SELECT COUNT( * ) FROM tab0 WHERE - 28 IS NULL
----
0

skipif mysql # not compatible
query I rowsort label-705
SELECT COUNT ( * ) FROM tab0 WHERE - 28 IS NULL
----
0

onlyif mysql # aggregate syntax: 
query I rowsort label-705
SELECT COUNT( * ) FROM tab1 WHERE - 28 IS NULL
----
0

skipif mysql # not compatible
query I rowsort label-705
SELECT COUNT ( * ) FROM tab1 WHERE - 28 IS NULL
----
0

onlyif mysql # aggregate syntax: 
query I rowsort label-705
SELECT COUNT( * ) FROM tab2 WHERE - 28 IS NULL
----
0

skipif mysql # not compatible
query I rowsort label-705
SELECT COUNT ( * ) FROM tab2 WHERE - 28 IS NULL
----
0

onlyif mysql # aggregate syntax: 
query I rowsort label-705
SELECT COUNT( * ) FROM tab3 WHERE - 28 IS NULL
----
0

skipif mysql # not compatible
query I rowsort label-705
SELECT COUNT ( * ) FROM tab3 WHERE - 28 IS NULL
----
0

onlyif mysql # aggregate syntax: 
query I rowsort label-705
SELECT COUNT( * ) FROM tab4 WHERE - 28 IS NULL
----
0

skipif mysql # not compatible
query I rowsort label-705
SELECT COUNT ( * ) FROM tab4 WHERE - 28 IS NULL
----
0

query I rowsort label-710
SELECT col3 AS col2 FROM tab0 WHERE NOT NULL IS NOT NULL
----
1000 values hashing to bfdd2bba6492501de7f490ea210e31cc

query I rowsort label-710
SELECT col3 AS col2 FROM tab1 WHERE NOT NULL IS NOT NULL
----
1000 values hashing to bfdd2bba6492501de7f490ea210e31cc

query I rowsort label-710
SELECT col3 AS col2 FROM tab2 WHERE NOT NULL IS NOT NULL
----
1000 values hashing to bfdd2bba6492501de7f490ea210e31cc

query I rowsort label-710
SELECT col3 AS col2 FROM tab3 WHERE NOT NULL IS NOT NULL
----
1000 values hashing to bfdd2bba6492501de7f490ea210e31cc

query I rowsort label-710
SELECT col3 AS col2 FROM tab4 WHERE NOT NULL IS NOT NULL
----
1000 values hashing to bfdd2bba6492501de7f490ea210e31cc

query I rowsort label-715
SELECT ALL 44 AS col3 FROM tab0 WHERE NOT NULL = + col1
----

query I rowsort label-715
SELECT ALL 44 AS col3 FROM tab1 WHERE NOT NULL = + col1
----

query I rowsort label-715
SELECT ALL 44 AS col3 FROM tab2 WHERE NOT NULL = + col1
----

query I rowsort label-715
SELECT ALL 44 AS col3 FROM tab3 WHERE NOT NULL = + col1
----

query I rowsort label-715
SELECT ALL 44 AS col3 FROM tab4 WHERE NOT NULL = + col1
----

query I rowsort label-720
SELECT ALL col2 FROM tab0 AS cor0 WHERE ( NULL ) < ( + col0 )
----

query I rowsort label-720
SELECT ALL col2 FROM tab1 AS cor0 WHERE ( NULL ) < ( + col0 )
----

query I rowsort label-720
SELECT ALL col2 FROM tab2 AS cor0 WHERE ( NULL ) < ( + col0 )
----

query I rowsort label-720
SELECT ALL col2 FROM tab3 AS cor0 WHERE ( NULL ) < ( + col0 )
----

query I rowsort label-720
SELECT ALL col2 FROM tab4 AS cor0 WHERE ( NULL ) < ( + col0 )
----

query I rowsort label-725
SELECT col3 AS col3 FROM tab0 AS cor0 WHERE NOT + 11 * col3 IS NULL
----
1000 values hashing to bfdd2bba6492501de7f490ea210e31cc

query I rowsort label-725
SELECT col3 AS col3 FROM tab1 AS cor0 WHERE NOT + 11 * col3 IS NULL
----
1000 values hashing to bfdd2bba6492501de7f490ea210e31cc

query I rowsort label-725
SELECT col3 AS col3 FROM tab2 AS cor0 WHERE NOT + 11 * col3 IS NULL
----
1000 values hashing to bfdd2bba6492501de7f490ea210e31cc

query I rowsort label-725
SELECT col3 AS col3 FROM tab3 AS cor0 WHERE NOT + 11 * col3 IS NULL
----
1000 values hashing to bfdd2bba6492501de7f490ea210e31cc

query I rowsort label-725
SELECT col3 AS col3 FROM tab4 AS cor0 WHERE NOT + 11 * col3 IS NULL
----
1000 values hashing to bfdd2bba6492501de7f490ea210e31cc

query IIIIIII rowsort label-730
SELECT * FROM tab0 AS cor0 WHERE NOT NULL <= NULL
----

query IIIIIII rowsort label-730
SELECT * FROM tab1 AS cor0 WHERE NOT NULL <= NULL
----

query IIIIIII rowsort label-730
SELECT * FROM tab2 AS cor0 WHERE NOT NULL <= NULL
----

query IIIIIII rowsort label-730
SELECT * FROM tab3 AS cor0 WHERE NOT NULL <= NULL
----

query IIIIIII rowsort label-730
SELECT * FROM tab4 AS cor0 WHERE NOT NULL <= NULL
----

query IIIIIII rowsort label-735
SELECT * FROM tab0 WHERE - ( ( col4 ) ) IS NULL
----

query IIIIIII rowsort label-735
SELECT * FROM tab1 WHERE - ( ( col4 ) ) IS NULL
----

query IIIIIII rowsort label-735
SELECT * FROM tab2 WHERE - ( ( col4 ) ) IS NULL
----

query IIIIIII rowsort label-735
SELECT * FROM tab3 WHERE - ( ( col4 ) ) IS NULL
----

query IIIIIII rowsort label-735
SELECT * FROM tab4 WHERE - ( ( col4 ) ) IS NULL
----

query IIIIIII rowsort label-740
SELECT ALL * FROM tab0 WHERE col1 IS NULL
----

query IIIIIII rowsort label-740
SELECT ALL * FROM tab1 WHERE col1 IS NULL
----

query IIIIIII rowsort label-740
SELECT ALL * FROM tab2 WHERE col1 IS NULL
----

query IIIIIII rowsort label-740
SELECT ALL * FROM tab3 WHERE col1 IS NULL
----

query IIIIIII rowsort label-740
SELECT ALL * FROM tab4 WHERE col1 IS NULL
----

query I rowsort label-745
SELECT DISTINCT col3 FROM tab0 AS cor0 WHERE ( ( + col3 ) ) BETWEEN NULL AND + 2
----

query I rowsort label-745
SELECT DISTINCT col3 FROM tab1 AS cor0 WHERE ( ( + col3 ) ) BETWEEN NULL AND + 2
----

query I rowsort label-745
SELECT DISTINCT col3 FROM tab2 AS cor0 WHERE ( ( + col3 ) ) BETWEEN NULL AND + 2
----

query I rowsort label-745
SELECT DISTINCT col3 FROM tab3 AS cor0 WHERE ( ( + col3 ) ) BETWEEN NULL AND + 2
----

query I rowsort label-745
SELECT DISTINCT col3 FROM tab4 AS cor0 WHERE ( ( + col3 ) ) BETWEEN NULL AND + 2
----

query IIIIIII rowsort label-750
SELECT * FROM tab0 AS cor0 WHERE NOT ( NULL ) < NULL
----

query IIIIIII rowsort label-750
SELECT * FROM tab1 AS cor0 WHERE NOT ( NULL ) < NULL
----

query IIIIIII rowsort label-750
SELECT * FROM tab2 AS cor0 WHERE NOT ( NULL ) < NULL
----

query IIIIIII rowsort label-750
SELECT * FROM tab3 AS cor0 WHERE NOT ( NULL ) < NULL
----

query IIIIIII rowsort label-750
SELECT * FROM tab4 AS cor0 WHERE NOT ( NULL ) < NULL
----

query IIIIIII rowsort label-755
SELECT * FROM tab0 AS cor0 WHERE NOT - col4 + + col3 NOT BETWEEN ( NULL ) AND NULL
----

query IIIIIII rowsort label-755
SELECT * FROM tab1 AS cor0 WHERE NOT - col4 + + col3 NOT BETWEEN ( NULL ) AND NULL
----

query IIIIIII rowsort label-755
SELECT * FROM tab2 AS cor0 WHERE NOT - col4 + + col3 NOT BETWEEN ( NULL ) AND NULL
----

query IIIIIII rowsort label-755
SELECT * FROM tab3 AS cor0 WHERE NOT - col4 + + col3 NOT BETWEEN ( NULL ) AND NULL
----

query IIIIIII rowsort label-755
SELECT * FROM tab4 AS cor0 WHERE NOT - col4 + + col3 NOT BETWEEN ( NULL ) AND NULL
----

query I rowsort label-760
SELECT 1 + col4 AS col2 FROM tab0 AS cor0 WHERE NOT + col3 NOT BETWEEN ( - col0 ) AND NULL
----

query I rowsort label-760
SELECT 1 + col4 AS col2 FROM tab1 AS cor0 WHERE NOT + col3 NOT BETWEEN ( - col0 ) AND NULL
----

query I rowsort label-760
SELECT 1 + col4 AS col2 FROM tab2 AS cor0 WHERE NOT + col3 NOT BETWEEN ( - col0 ) AND NULL
----

query I rowsort label-760
SELECT 1 + col4 AS col2 FROM tab3 AS cor0 WHERE NOT + col3 NOT BETWEEN ( - col0 ) AND NULL
----

query I rowsort label-760
SELECT 1 + col4 AS col2 FROM tab4 AS cor0 WHERE NOT + col3 NOT BETWEEN ( - col0 ) AND NULL
----

query I rowsort label-765
SELECT ALL + 10 AS col5 FROM tab0 AS cor0 WHERE NOT ( + 27 ) IS NOT NULL
----

query I rowsort label-765
SELECT ALL + 10 AS col5 FROM tab1 AS cor0 WHERE NOT ( + 27 ) IS NOT NULL
----

query I rowsort label-765
SELECT ALL + 10 AS col5 FROM tab2 AS cor0 WHERE NOT ( + 27 ) IS NOT NULL
----

query I rowsort label-765
SELECT ALL + 10 AS col5 FROM tab3 AS cor0 WHERE NOT ( + 27 ) IS NOT NULL
----

query I rowsort label-765
SELECT ALL + 10 AS col5 FROM tab4 AS cor0 WHERE NOT ( + 27 ) IS NOT NULL
----

query IIIIIII rowsort label-770
SELECT ALL * FROM tab0 AS cor0 WHERE NOT NULL IS NULL
----

query IIIIIII rowsort label-770
SELECT ALL * FROM tab1 AS cor0 WHERE NOT NULL IS NULL
----

query IIIIIII rowsort label-770
SELECT ALL * FROM tab2 AS cor0 WHERE NOT NULL IS NULL
----

query IIIIIII rowsort label-770
SELECT ALL * FROM tab3 AS cor0 WHERE NOT NULL IS NULL
----

query IIIIIII rowsort label-770
SELECT ALL * FROM tab4 AS cor0 WHERE NOT NULL IS NULL
----

onlyif mysql # CAST syntax: aggregate syntax: SIGNED type: 
query I rowsort label-775
SELECT DISTINCT - SUM( CAST( col1 AS SIGNED ) ) + - AVG ( ALL col1 + col0 ) FROM tab0 AS cor0 WHERE NOT - col4 + col1 NOT IN ( 39 )
----
NULL

skipif mysql # not compatible
query I rowsort label-775
SELECT DISTINCT - SUM ( CAST ( col1 AS INTEGER ) ) + - AVG ( ALL col1 + col0 ) FROM tab0 AS cor0 WHERE NOT - col4 + col1 NOT IN ( 39 )
----
NULL

onlyif mysql # CAST syntax: aggregate syntax: SIGNED type: 
query I rowsort label-775
SELECT DISTINCT - SUM( CAST( col1 AS SIGNED ) ) + - AVG ( ALL col1 + col0 ) FROM tab1 AS cor0 WHERE NOT - col4 + col1 NOT IN ( 39 )
----
NULL

skipif mysql # not compatible
query I rowsort label-775
SELECT DISTINCT - SUM ( CAST ( col1 AS INTEGER ) ) + - AVG ( ALL col1 + col0 ) FROM tab1 AS cor0 WHERE NOT - col4 + col1 NOT IN ( 39 )
----
NULL

onlyif mysql # CAST syntax: aggregate syntax: SIGNED type: 
query I rowsort label-775
SELECT DISTINCT - SUM( CAST( col1 AS SIGNED ) ) + - AVG ( ALL col1 + col0 ) FROM tab2 AS cor0 WHERE NOT - col4 + col1 NOT IN ( 39 )
----
NULL

skipif mysql # not compatible
query I rowsort label-775
SELECT DISTINCT - SUM ( CAST ( col1 AS INTEGER ) ) + - AVG ( ALL col1 + col0 ) FROM tab2 AS cor0 WHERE NOT - col4 + col1 NOT IN ( 39 )
----
NULL

onlyif mysql # CAST syntax: aggregate syntax: SIGNED type: 
query I rowsort label-775
SELECT DISTINCT - SUM( CAST( col1 AS SIGNED ) ) + - AVG ( ALL col1 + col0 ) FROM tab3 AS cor0 WHERE NOT - col4 + col1 NOT IN ( 39 )
----
NULL

skipif mysql # not compatible
query I rowsort label-775
SELECT DISTINCT - SUM ( CAST ( col1 AS INTEGER ) ) + - AVG ( ALL col1 + col0 ) FROM tab3 AS cor0 WHERE NOT - col4 + col1 NOT IN ( 39 )
----
NULL

onlyif mysql # CAST syntax: aggregate syntax: SIGNED type: 
query I rowsort label-775
SELECT DISTINCT - SUM( CAST( col1 AS SIGNED ) ) + - AVG ( ALL col1 + col0 ) FROM tab4 AS cor0 WHERE NOT - col4 + col1 NOT IN ( 39 )
----
NULL

skipif mysql # not compatible
query I rowsort label-775
SELECT DISTINCT - SUM ( CAST ( col1 AS INTEGER ) ) + - AVG ( ALL col1 + col0 ) FROM tab4 AS cor0 WHERE NOT - col4 + col1 NOT IN ( 39 )
----
NULL

onlyif mysql # CAST syntax: SIGNED type: 
query I rowsort label-780
SELECT - 45 / - CAST( col1 AS SIGNED ) FROM tab0 WHERE NOT NULL IS NULL
----

skipif mysql # not compatible
query I rowsort label-780
SELECT - 45 / - CAST ( col1 AS INTEGER ) FROM tab0 WHERE NOT NULL IS NULL
----

onlyif mysql # CAST syntax: SIGNED type: 
query I rowsort label-780
SELECT - 45 / - CAST( col1 AS SIGNED ) FROM tab1 WHERE NOT NULL IS NULL
----

skipif mysql # not compatible
query I rowsort label-780
SELECT - 45 / - CAST ( col1 AS INTEGER ) FROM tab1 WHERE NOT NULL IS NULL
----

onlyif mysql # CAST syntax: SIGNED type: 
query I rowsort label-780
SELECT - 45 / - CAST( col1 AS SIGNED ) FROM tab2 WHERE NOT NULL IS NULL
----

skipif mysql # not compatible
query I rowsort label-780
SELECT - 45 / - CAST ( col1 AS INTEGER ) FROM tab2 WHERE NOT NULL IS NULL
----

onlyif mysql # CAST syntax: SIGNED type: 
query I rowsort label-780
SELECT - 45 / - CAST( col1 AS SIGNED ) FROM tab3 WHERE NOT NULL IS NULL
----

skipif mysql # not compatible
query I rowsort label-780
SELECT - 45 / - CAST ( col1 AS INTEGER ) FROM tab3 WHERE NOT NULL IS NULL
----

onlyif mysql # CAST syntax: SIGNED type: 
query I rowsort label-780
SELECT - 45 / - CAST( col1 AS SIGNED ) FROM tab4 WHERE NOT NULL IS NULL
----

skipif mysql # not compatible
query I rowsort label-780
SELECT - 45 / - CAST ( col1 AS INTEGER ) FROM tab4 WHERE NOT NULL IS NULL
----

query IIIIIII rowsort label-785
SELECT * FROM tab0 AS cor0 WHERE NOT ( - 85 * col3 ) IN ( + col4 ) AND NOT col4 <> NULL
----

query IIIIIII rowsort label-785
SELECT * FROM tab1 AS cor0 WHERE NOT ( - 85 * col3 ) IN ( + col4 ) AND NOT col4 <> NULL
----

query IIIIIII rowsort label-785
SELECT * FROM tab2 AS cor0 WHERE NOT ( - 85 * col3 ) IN ( + col4 ) AND NOT col4 <> NULL
----

query IIIIIII rowsort label-785
SELECT * FROM tab3 AS cor0 WHERE NOT ( - 85 * col3 ) IN ( + col4 ) AND NOT col4 <> NULL
----

query IIIIIII rowsort label-785
SELECT * FROM tab4 AS cor0 WHERE NOT ( - 85 * col3 ) IN ( + col4 ) AND NOT col4 <> NULL
----

query I rowsort label-790
SELECT ALL + col1 AS col2 FROM tab0 WHERE NOT ( ( col4 ) <= NULL )
----

query I rowsort label-790
SELECT ALL + col1 AS col2 FROM tab1 WHERE NOT ( ( col4 ) <= NULL )
----

query I rowsort label-790
SELECT ALL + col1 AS col2 FROM tab2 WHERE NOT ( ( col4 ) <= NULL )
----

query I rowsort label-790
SELECT ALL + col1 AS col2 FROM tab3 WHERE NOT ( ( col4 ) <= NULL )
----

query I rowsort label-790
SELECT ALL + col1 AS col2 FROM tab4 WHERE NOT ( ( col4 ) <= NULL )
----

query I rowsort label-795
SELECT ALL - 81 AS col2 FROM tab0 WHERE NOT + col3 * + col1 < - 38 * col3
----
1000 values hashing to 4a47b14abddd20654d2347c2aa94ceef

query I rowsort label-795
SELECT ALL - 81 AS col2 FROM tab1 WHERE NOT + col3 * + col1 < - 38 * col3
----
1000 values hashing to 4a47b14abddd20654d2347c2aa94ceef

query I rowsort label-795
SELECT ALL - 81 AS col2 FROM tab2 WHERE NOT + col3 * + col1 < - 38 * col3
----
1000 values hashing to 4a47b14abddd20654d2347c2aa94ceef

query I rowsort label-795
SELECT ALL - 81 AS col2 FROM tab3 WHERE NOT + col3 * + col1 < - 38 * col3
----
1000 values hashing to 4a47b14abddd20654d2347c2aa94ceef

query I rowsort label-795
SELECT ALL - 81 AS col2 FROM tab4 WHERE NOT + col3 * + col1 < - 38 * col3
----
1000 values hashing to 4a47b14abddd20654d2347c2aa94ceef

skipif postgresql # PostgreSQL requires AS when renaming output columns
query I rowsort label-800
SELECT DISTINCT + ( - col0 ) col0 FROM tab0 AS cor0 WHERE NULL IS NOT NULL
----

skipif postgresql # PostgreSQL requires AS when renaming output columns
query I rowsort label-800
SELECT DISTINCT + ( - col0 ) col0 FROM tab1 AS cor0 WHERE NULL IS NOT NULL
----

skipif postgresql # PostgreSQL requires AS when renaming output columns
query I rowsort label-800
SELECT DISTINCT + ( - col0 ) col0 FROM tab2 AS cor0 WHERE NULL IS NOT NULL
----

skipif postgresql # PostgreSQL requires AS when renaming output columns
query I rowsort label-800
SELECT DISTINCT + ( - col0 ) col0 FROM tab3 AS cor0 WHERE NULL IS NOT NULL
----

skipif postgresql # PostgreSQL requires AS when renaming output columns
query I rowsort label-800
SELECT DISTINCT + ( - col0 ) col0 FROM tab4 AS cor0 WHERE NULL IS NOT NULL
----

query IIIIIII rowsort label-805
SELECT * FROM tab0 AS cor0 WHERE - ( col3 ) IS NULL
----

query IIIIIII rowsort label-805
SELECT * FROM tab1 AS cor0 WHERE - ( col3 ) IS NULL
----

query IIIIIII rowsort label-805
SELECT * FROM tab2 AS cor0 WHERE - ( col3 ) IS NULL
----

query IIIIIII rowsort label-805
SELECT * FROM tab3 AS cor0 WHERE - ( col3 ) IS NULL
----

query IIIIIII rowsort label-805
SELECT * FROM tab4 AS cor0 WHERE - ( col3 ) IS NULL
----

query IIIIIII rowsort label-810
SELECT ALL * FROM tab0 cor0 WHERE NULL IN ( - col4 + - col4 - - col4 )
----

query IIIIIII rowsort label-810
SELECT ALL * FROM tab1 cor0 WHERE NULL IN ( - col4 + - col4 - - col4 )
----

query IIIIIII rowsort label-810
SELECT ALL * FROM tab2 cor0 WHERE NULL IN ( - col4 + - col4 - - col4 )
----

query IIIIIII rowsort label-810
SELECT ALL * FROM tab3 cor0 WHERE NULL IN ( - col4 + - col4 - - col4 )
----

query IIIIIII rowsort label-810
SELECT ALL * FROM tab4 cor0 WHERE NULL IN ( - col4 + - col4 - - col4 )
----

query IIIIIII rowsort label-815
SELECT ALL * FROM tab0 AS cor0 WHERE col4 - + + 67 / col0 IS NULL
----

query IIIIIII rowsort label-815
SELECT ALL * FROM tab1 AS cor0 WHERE col4 - + + 67 / col0 IS NULL
----

query IIIIIII rowsort label-815
SELECT ALL * FROM tab2 AS cor0 WHERE col4 - + + 67 / col0 IS NULL
----

query IIIIIII rowsort label-815
SELECT ALL * FROM tab3 AS cor0 WHERE col4 - + + 67 / col0 IS NULL
----

query IIIIIII rowsort label-815
SELECT ALL * FROM tab4 AS cor0 WHERE col4 - + + 67 / col0 IS NULL
----

query IIIIIII rowsort label-820
SELECT * FROM tab0 WHERE NOT ( NULL ) IS NULL
----

query IIIIIII rowsort label-820
SELECT * FROM tab1 WHERE NOT ( NULL ) IS NULL
----

query IIIIIII rowsort label-820
SELECT * FROM tab2 WHERE NOT ( NULL ) IS NULL
----

query IIIIIII rowsort label-820
SELECT * FROM tab3 WHERE NOT ( NULL ) IS NULL
----

query IIIIIII rowsort label-820
SELECT * FROM tab4 WHERE NOT ( NULL ) IS NULL
----

onlyif mysql # CAST syntax: SIGNED type: 
query I rowsort label-825
SELECT + col1 * CAST( NULL AS SIGNED ) AS col3 FROM tab0 WHERE NOT ( 84 ) NOT BETWEEN ( NULL ) AND col3
----

skipif mysql # not compatible
query I rowsort label-825
SELECT + col1 * CAST ( NULL AS INTEGER ) AS col3 FROM tab0 WHERE NOT ( 84 ) NOT BETWEEN ( NULL ) AND col3
----

onlyif mysql # CAST syntax: SIGNED type: 
query I rowsort label-825
SELECT + col1 * CAST( NULL AS SIGNED ) AS col3 FROM tab1 WHERE NOT ( 84 ) NOT BETWEEN ( NULL ) AND col3
----

skipif mysql # not compatible
query I rowsort label-825
SELECT + col1 * CAST ( NULL AS INTEGER ) AS col3 FROM tab1 WHERE NOT ( 84 ) NOT BETWEEN ( NULL ) AND col3
----

onlyif mysql # CAST syntax: SIGNED type: 
query I rowsort label-825
SELECT + col1 * CAST( NULL AS SIGNED ) AS col3 FROM tab2 WHERE NOT ( 84 ) NOT BETWEEN ( NULL ) AND col3
----

skipif mysql # not compatible
query I rowsort label-825
SELECT + col1 * CAST ( NULL AS INTEGER ) AS col3 FROM tab2 WHERE NOT ( 84 ) NOT BETWEEN ( NULL ) AND col3
----

onlyif mysql # CAST syntax: SIGNED type: 
query I rowsort label-825
SELECT + col1 * CAST( NULL AS SIGNED ) AS col3 FROM tab3 WHERE NOT ( 84 ) NOT BETWEEN ( NULL ) AND col3
----

skipif mysql # not compatible
query I rowsort label-825
SELECT + col1 * CAST ( NULL AS INTEGER ) AS col3 FROM tab3 WHERE NOT ( 84 ) NOT BETWEEN ( NULL ) AND col3
----

onlyif mysql # CAST syntax: SIGNED type: 
query I rowsort label-825
SELECT + col1 * CAST( NULL AS SIGNED ) AS col3 FROM tab4 WHERE NOT ( 84 ) NOT BETWEEN ( NULL ) AND col3
----

skipif mysql # not compatible
query I rowsort label-825
SELECT + col1 * CAST ( NULL AS INTEGER ) AS col3 FROM tab4 WHERE NOT ( 84 ) NOT BETWEEN ( NULL ) AND col3
----

query I rowsort label-830
SELECT col2 FROM tab0 WHERE ( NULL ) NOT IN ( - ( - - 85 ) )
----

query I rowsort label-830
SELECT col2 FROM tab1 WHERE ( NULL ) NOT IN ( - ( - - 85 ) )
----

query I rowsort label-830
SELECT col2 FROM tab2 WHERE ( NULL ) NOT IN ( - ( - - 85 ) )
----

query I rowsort label-830
SELECT col2 FROM tab3 WHERE ( NULL ) NOT IN ( - ( - - 85 ) )
----

query I rowsort label-830
SELECT col2 FROM tab4 WHERE ( NULL ) NOT IN ( - ( - - 85 ) )
----

query I rowsort label-835
SELECT DISTINCT + col0 FROM tab0 cor0 WHERE ( NULL ) IS NOT NULL
----

query I rowsort label-835
SELECT DISTINCT + col0 FROM tab1 cor0 WHERE ( NULL ) IS NOT NULL
----

query I rowsort label-835
SELECT DISTINCT + col0 FROM tab2 cor0 WHERE ( NULL ) IS NOT NULL
----

query I rowsort label-835
SELECT DISTINCT + col0 FROM tab3 cor0 WHERE ( NULL ) IS NOT NULL
----

query I rowsort label-835
SELECT DISTINCT + col0 FROM tab4 cor0 WHERE ( NULL ) IS NOT NULL
----

query IIIIIII rowsort label-840
SELECT ALL * FROM tab0 AS cor0 WHERE + ( + col0 ) IS NULL
----

query IIIIIII rowsort label-840
SELECT ALL * FROM tab1 AS cor0 WHERE + ( + col0 ) IS NULL
----

query IIIIIII rowsort label-840
SELECT ALL * FROM tab2 AS cor0 WHERE + ( + col0 ) IS NULL
----

query IIIIIII rowsort label-840
SELECT ALL * FROM tab3 AS cor0 WHERE + ( + col0 ) IS NULL
----

query IIIIIII rowsort label-840
SELECT ALL * FROM tab4 AS cor0 WHERE + ( + col0 ) IS NULL
----

onlyif mysql # CAST syntax: DECIMAL type: 
query IIIIIII rowsort label-845
SELECT * FROM tab0 AS cor0 WHERE ( NOT ( col0 * col4 ) <> ( - col0 * - 67 + - ( - CAST( col3 AS DECIMAL ) ) ) )
----

skipif mysql # not compatible
query IIIIIII rowsort label-845
SELECT * FROM tab0 AS cor0 WHERE ( NOT ( col0 * col4 ) <> ( - col0 * - 67 + - ( - CAST ( col3 AS REAL ) ) ) )
----

onlyif mysql # CAST syntax: DECIMAL type: 
query IIIIIII rowsort label-845
SELECT * FROM tab1 AS cor0 WHERE ( NOT ( col0 * col4 ) <> ( - col0 * - 67 + - ( - CAST( col3 AS DECIMAL ) ) ) )
----

skipif mysql # not compatible
query IIIIIII rowsort label-845
SELECT * FROM tab1 AS cor0 WHERE ( NOT ( col0 * col4 ) <> ( - col0 * - 67 + - ( - CAST ( col3 AS REAL ) ) ) )
----

onlyif mysql # CAST syntax: DECIMAL type: 
query IIIIIII rowsort label-845
SELECT * FROM tab2 AS cor0 WHERE ( NOT ( col0 * col4 ) <> ( - col0 * - 67 + - ( - CAST( col3 AS DECIMAL ) ) ) )
----

skipif mysql # not compatible
query IIIIIII rowsort label-845
SELECT * FROM tab2 AS cor0 WHERE ( NOT ( col0 * col4 ) <> ( - col0 * - 67 + - ( - CAST ( col3 AS REAL ) ) ) )
----

onlyif mysql # CAST syntax: DECIMAL type: 
query IIIIIII rowsort label-845
SELECT * FROM tab3 AS cor0 WHERE ( NOT ( col0 * col4 ) <> ( - col0 * - 67 + - ( - CAST( col3 AS DECIMAL ) ) ) )
----

skipif mysql # not compatible
query IIIIIII rowsort label-845
SELECT * FROM tab3 AS cor0 WHERE ( NOT ( col0 * col4 ) <> ( - col0 * - 67 + - ( - CAST ( col3 AS REAL ) ) ) )
----

onlyif mysql # CAST syntax: DECIMAL type: 
query IIIIIII rowsort label-845
SELECT * FROM tab4 AS cor0 WHERE ( NOT ( col0 * col4 ) <> ( - col0 * - 67 + - ( - CAST( col3 AS DECIMAL ) ) ) )
----

skipif mysql # not compatible
query IIIIIII rowsort label-845
SELECT * FROM tab4 AS cor0 WHERE ( NOT ( col0 * col4 ) <> ( - col0 * - 67 + - ( - CAST ( col3 AS REAL ) ) ) )
----

query IIIIIII rowsort label-850
SELECT * FROM tab0 WHERE NOT + col1 / col3 IS NOT NULL
----

query IIIIIII rowsort label-850
SELECT * FROM tab1 WHERE NOT + col1 / col3 IS NOT NULL
----

query IIIIIII rowsort label-850
SELECT * FROM tab2 WHERE NOT + col1 / col3 IS NOT NULL
----

query IIIIIII rowsort label-850
SELECT * FROM tab3 WHERE NOT + col1 / col3 IS NOT NULL
----

query IIIIIII rowsort label-850
SELECT * FROM tab4 WHERE NOT + col1 / col3 IS NOT NULL
----

onlyif mysql # aggregate syntax: 
query I rowsort label-855
SELECT - COUNT( * ) AS col4 FROM tab0 WHERE NOT - col3 IS NOT NULL
----
0

skipif mysql # not compatible
query I rowsort label-855
SELECT - COUNT ( * ) AS col4 FROM tab0 WHERE NOT - col3 IS NOT NULL
----
0

onlyif mysql # aggregate syntax: 
query I rowsort label-855
SELECT - COUNT( * ) AS col4 FROM tab1 WHERE NOT - col3 IS NOT NULL
----
0

skipif mysql # not compatible
query I rowsort label-855
SELECT - COUNT ( * ) AS col4 FROM tab1 WHERE NOT - col3 IS NOT NULL
----
0

onlyif mysql # aggregate syntax: 
query I rowsort label-855
SELECT - COUNT( * ) AS col4 FROM tab2 WHERE NOT - col3 IS NOT NULL
----
0

skipif mysql # not compatible
query I rowsort label-855
SELECT - COUNT ( * ) AS col4 FROM tab2 WHERE NOT - col3 IS NOT NULL
----
0

onlyif mysql # aggregate syntax: 
query I rowsort label-855
SELECT - COUNT( * ) AS col4 FROM tab3 WHERE NOT - col3 IS NOT NULL
----
0

skipif mysql # not compatible
query I rowsort label-855
SELECT - COUNT ( * ) AS col4 FROM tab3 WHERE NOT - col3 IS NOT NULL
----
0

onlyif mysql # aggregate syntax: 
query I rowsort label-855
SELECT - COUNT( * ) AS col4 FROM tab4 WHERE NOT - col3 IS NOT NULL
----
0

skipif mysql # not compatible
query I rowsort label-855
SELECT - COUNT ( * ) AS col4 FROM tab4 WHERE NOT - col3 IS NOT NULL
----
0

onlyif mysql # CAST syntax: SIGNED type: 
query I rowsort label-860
SELECT ALL + col4 * + CAST( NULL AS SIGNED ) AS col2 FROM tab0 WHERE + 43 * + - col4 < ( + + col0 )
----
1000 values hashing to 934e0694199f84c934e83e05849aa6f0

skipif mysql # not compatible
query I rowsort label-860
SELECT ALL + col4 * + CAST ( NULL AS INTEGER ) AS col2 FROM tab0 WHERE + 43 * + - col4 < ( + + col0 )
----
1000 values hashing to 934e0694199f84c934e83e05849aa6f0

onlyif mysql # CAST syntax: SIGNED type: 
query I rowsort label-860
SELECT ALL + col4 * + CAST( NULL AS SIGNED ) AS col2 FROM tab1 WHERE + 43 * + - col4 < ( + + col0 )
----
1000 values hashing to 934e0694199f84c934e83e05849aa6f0

skipif mysql # not compatible
query I rowsort label-860
SELECT ALL + col4 * + CAST ( NULL AS INTEGER ) AS col2 FROM tab1 WHERE + 43 * + - col4 < ( + + col0 )
----
1000 values hashing to 934e0694199f84c934e83e05849aa6f0

onlyif mysql # CAST syntax: SIGNED type: 
query I rowsort label-860
SELECT ALL + col4 * + CAST( NULL AS SIGNED ) AS col2 FROM tab2 WHERE + 43 * + - col4 < ( + + col0 )
----
1000 values hashing to 934e0694199f84c934e83e05849aa6f0

skipif mysql # not compatible
query I rowsort label-860
SELECT ALL + col4 * + CAST ( NULL AS INTEGER ) AS col2 FROM tab2 WHERE + 43 * + - col4 < ( + + col0 )
----
1000 values hashing to 934e0694199f84c934e83e05849aa6f0

onlyif mysql # CAST syntax: SIGNED type: 
query I rowsort label-860
SELECT ALL + col4 * + CAST( NULL AS SIGNED ) AS col2 FROM tab3 WHERE + 43 * + - col4 < ( + + col0 )
----
1000 values hashing to 934e0694199f84c934e83e05849aa6f0

skipif mysql # not compatible
query I rowsort label-860
SELECT ALL + col4 * + CAST ( NULL AS INTEGER ) AS col2 FROM tab3 WHERE + 43 * + - col4 < ( + + col0 )
----
1000 values hashing to 934e0694199f84c934e83e05849aa6f0

onlyif mysql # CAST syntax: SIGNED type: 
query I rowsort label-860
SELECT ALL + col4 * + CAST( NULL AS SIGNED ) AS col2 FROM tab4 WHERE + 43 * + - col4 < ( + + col0 )
----
1000 values hashing to 934e0694199f84c934e83e05849aa6f0

skipif mysql # not compatible
query I rowsort label-860
SELECT ALL + col4 * + CAST ( NULL AS INTEGER ) AS col2 FROM tab4 WHERE + 43 * + - col4 < ( + + col0 )
----
1000 values hashing to 934e0694199f84c934e83e05849aa6f0

onlyif mysql # aggregate syntax: 
query I rowsort label-865
SELECT ALL MAX( ALL - col1 ) FROM tab0 cor0 WHERE NOT NULL IS NULL
----
NULL

skipif mysql # not compatible
query I rowsort label-865
SELECT ALL MAX ( ALL - col1 ) FROM tab0 cor0 WHERE NOT NULL IS NULL
----
NULL

onlyif mysql # aggregate syntax: 
query I rowsort label-865
SELECT ALL MAX( ALL - col1 ) FROM tab1 cor0 WHERE NOT NULL IS NULL
----
NULL

skipif mysql # not compatible
query I rowsort label-865
SELECT ALL MAX ( ALL - col1 ) FROM tab1 cor0 WHERE NOT NULL IS NULL
----
NULL

onlyif mysql # aggregate syntax: 
query I rowsort label-865
SELECT ALL MAX( ALL - col1 ) FROM tab2 cor0 WHERE NOT NULL IS NULL
----
NULL

skipif mysql # not compatible
query I rowsort label-865
SELECT ALL MAX ( ALL - col1 ) FROM tab2 cor0 WHERE NOT NULL IS NULL
----
NULL

onlyif mysql # aggregate syntax: 
query I rowsort label-865
SELECT ALL MAX( ALL - col1 ) FROM tab3 cor0 WHERE NOT NULL IS NULL
----
NULL

skipif mysql # not compatible
query I rowsort label-865
SELECT ALL MAX ( ALL - col1 ) FROM tab3 cor0 WHERE NOT NULL IS NULL
----
NULL

onlyif mysql # aggregate syntax: 
query I rowsort label-865
SELECT ALL MAX( ALL - col1 ) FROM tab4 cor0 WHERE NOT NULL IS NULL
----
NULL

skipif mysql # not compatible
query I rowsort label-865
SELECT ALL MAX ( ALL - col1 ) FROM tab4 cor0 WHERE NOT NULL IS NULL
----
NULL

query I rowsort label-870
SELECT + 89 + 10 AS col1 FROM tab0 WHERE NOT 61 > + ( + 15 ) * 67 * + col4
----
1000 values hashing to 13a2d531f3cdd60bafb0269dfc58721b

query I rowsort label-870
SELECT + 89 + 10 AS col1 FROM tab1 WHERE NOT 61 > + ( + 15 ) * 67 * + col4
----
1000 values hashing to 13a2d531f3cdd60bafb0269dfc58721b

query I rowsort label-870
SELECT + 89 + 10 AS col1 FROM tab2 WHERE NOT 61 > + ( + 15 ) * 67 * + col4
----
1000 values hashing to 13a2d531f3cdd60bafb0269dfc58721b

query I rowsort label-870
SELECT + 89 + 10 AS col1 FROM tab3 WHERE NOT 61 > + ( + 15 ) * 67 * + col4
----
1000 values hashing to 13a2d531f3cdd60bafb0269dfc58721b

query I rowsort label-870
SELECT + 89 + 10 AS col1 FROM tab4 WHERE NOT 61 > + ( + 15 ) * 67 * + col4
----
1000 values hashing to 13a2d531f3cdd60bafb0269dfc58721b

query I rowsort label-875
SELECT 26 AS col4 FROM tab0 WHERE NOT ( NULL ) IS NULL
----

query I rowsort label-875
SELECT 26 AS col4 FROM tab1 WHERE NOT ( NULL ) IS NULL
----

query I rowsort label-875
SELECT 26 AS col4 FROM tab2 WHERE NOT ( NULL ) IS NULL
----

query I rowsort label-875
SELECT 26 AS col4 FROM tab3 WHERE NOT ( NULL ) IS NULL
----

query I rowsort label-875
SELECT 26 AS col4 FROM tab4 WHERE NOT ( NULL ) IS NULL
----

query I rowsort label-880
SELECT + - 18 FROM tab0 WHERE NOT + + col3 * + - 16 IS NOT NULL
----

query I rowsort label-880
SELECT + - 18 FROM tab1 WHERE NOT + + col3 * + - 16 IS NOT NULL
----

query I rowsort label-880
SELECT + - 18 FROM tab2 WHERE NOT + + col3 * + - 16 IS NOT NULL
----

query I rowsort label-880
SELECT + - 18 FROM tab3 WHERE NOT + + col3 * + - 16 IS NOT NULL
----

query I rowsort label-880
SELECT + - 18 FROM tab4 WHERE NOT + + col3 * + - 16 IS NOT NULL
----

query I rowsort label-885
SELECT ALL - + 34 - + - col4 / 60 AS col1 FROM tab0 WHERE NOT 42 <> - col0
----

query I rowsort label-885
SELECT ALL - + 34 - + - col4 / 60 AS col1 FROM tab1 WHERE NOT 42 <> - col0
----

query I rowsort label-885
SELECT ALL - + 34 - + - col4 / 60 AS col1 FROM tab2 WHERE NOT 42 <> - col0
----

query I rowsort label-885
SELECT ALL - + 34 - + - col4 / 60 AS col1 FROM tab3 WHERE NOT 42 <> - col0
----

query I rowsort label-885
SELECT ALL - + 34 - + - col4 / 60 AS col1 FROM tab4 WHERE NOT 42 <> - col0
----

query IIIIIII rowsort label-890
SELECT * FROM tab0 WHERE NOT + col3 * + - col1 - - col1 * col0 IS NOT NULL
----

query IIIIIII rowsort label-890
SELECT * FROM tab1 WHERE NOT + col3 * + - col1 - - col1 * col0 IS NOT NULL
----

query IIIIIII rowsort label-890
SELECT * FROM tab2 WHERE NOT + col3 * + - col1 - - col1 * col0 IS NOT NULL
----

query IIIIIII rowsort label-890
SELECT * FROM tab3 WHERE NOT + col3 * + - col1 - - col1 * col0 IS NOT NULL
----

query IIIIIII rowsort label-890
SELECT * FROM tab4 WHERE NOT + col3 * + - col1 - - col1 * col0 IS NOT NULL
----

query IIIIIII rowsort label-895
SELECT * FROM tab0 WHERE NOT ( - col4 ) BETWEEN ( NULL ) AND ( + 18 )
----

query IIIIIII rowsort label-895
SELECT * FROM tab1 WHERE NOT ( - col4 ) BETWEEN ( NULL ) AND ( + 18 )
----

query IIIIIII rowsort label-895
SELECT * FROM tab2 WHERE NOT ( - col4 ) BETWEEN ( NULL ) AND ( + 18 )
----

query IIIIIII rowsort label-895
SELECT * FROM tab3 WHERE NOT ( - col4 ) BETWEEN ( NULL ) AND ( + 18 )
----

query IIIIIII rowsort label-895
SELECT * FROM tab4 WHERE NOT ( - col4 ) BETWEEN ( NULL ) AND ( + 18 )
----

onlyif mysql # aggregate syntax: 
query I rowsort label-900
SELECT - COUNT( * ) FROM tab0 AS cor0 WHERE col4 IS NOT NULL
----
-1000

skipif mysql # not compatible
query I rowsort label-900
SELECT - COUNT ( * ) FROM tab0 AS cor0 WHERE col4 IS NOT NULL
----
-1000

onlyif mysql # aggregate syntax: 
query I rowsort label-900
SELECT - COUNT( * ) FROM tab1 AS cor0 WHERE col4 IS NOT NULL
----
-1000

skipif mysql # not compatible
query I rowsort label-900
SELECT - COUNT ( * ) FROM tab1 AS cor0 WHERE col4 IS NOT NULL
----
-1000

onlyif mysql # aggregate syntax: 
query I rowsort label-900
SELECT - COUNT( * ) FROM tab2 AS cor0 WHERE col4 IS NOT NULL
----
-1000

skipif mysql # not compatible
query I rowsort label-900
SELECT - COUNT ( * ) FROM tab2 AS cor0 WHERE col4 IS NOT NULL
----
-1000

onlyif mysql # aggregate syntax: 
query I rowsort label-900
SELECT - COUNT( * ) FROM tab3 AS cor0 WHERE col4 IS NOT NULL
----
-1000

skipif mysql # not compatible
query I rowsort label-900
SELECT - COUNT ( * ) FROM tab3 AS cor0 WHERE col4 IS NOT NULL
----
-1000

onlyif mysql # aggregate syntax: 
query I rowsort label-900
SELECT - COUNT( * ) FROM tab4 AS cor0 WHERE col4 IS NOT NULL
----
-1000

skipif mysql # not compatible
query I rowsort label-900
SELECT - COUNT ( * ) FROM tab4 AS cor0 WHERE col4 IS NOT NULL
----
-1000

query IIIIIII rowsort label-905
SELECT * FROM tab0 WHERE NULL >= ( + col3 )
----

query IIIIIII rowsort label-905
SELECT * FROM tab1 WHERE NULL >= ( + col3 )
----

query IIIIIII rowsort label-905
SELECT * FROM tab2 WHERE NULL >= ( + col3 )
----

query IIIIIII rowsort label-905
SELECT * FROM tab3 WHERE NULL >= ( + col3 )
----

query IIIIIII rowsort label-905
SELECT * FROM tab4 WHERE NULL >= ( + col3 )
----

query I rowsort label-910
SELECT DISTINCT col1 * - - ( - + col1 ) AS col3 FROM tab0 AS cor0 WHERE NULL NOT BETWEEN NULL AND ( NULL )
----

query I rowsort label-910
SELECT DISTINCT col1 * - - ( - + col1 ) AS col3 FROM tab1 AS cor0 WHERE NULL NOT BETWEEN NULL AND ( NULL )
----

query I rowsort label-910
SELECT DISTINCT col1 * - - ( - + col1 ) AS col3 FROM tab2 AS cor0 WHERE NULL NOT BETWEEN NULL AND ( NULL )
----

query I rowsort label-910
SELECT DISTINCT col1 * - - ( - + col1 ) AS col3 FROM tab3 AS cor0 WHERE NULL NOT BETWEEN NULL AND ( NULL )
----

query I rowsort label-910
SELECT DISTINCT col1 * - - ( - + col1 ) AS col3 FROM tab4 AS cor0 WHERE NULL NOT BETWEEN NULL AND ( NULL )
----

query IIIIIII rowsort label-915
SELECT ALL * FROM tab0 cor0 WHERE NULL IS NOT NULL
----

query IIIIIII rowsort label-915
SELECT ALL * FROM tab1 cor0 WHERE NULL IS NOT NULL
----

query IIIIIII rowsort label-915
SELECT ALL * FROM tab2 cor0 WHERE NULL IS NOT NULL
----

query IIIIIII rowsort label-915
SELECT ALL * FROM tab3 cor0 WHERE NULL IS NOT NULL
----

query IIIIIII rowsort label-915
SELECT ALL * FROM tab4 cor0 WHERE NULL IS NOT NULL
----

query IIIIIII rowsort label-920
SELECT * FROM tab0 WHERE - col1 * - col0 / col3 + - col4 IS NULL
----

query IIIIIII rowsort label-920
SELECT * FROM tab1 WHERE - col1 * - col0 / col3 + - col4 IS NULL
----

query IIIIIII rowsort label-920
SELECT * FROM tab2 WHERE - col1 * - col0 / col3 + - col4 IS NULL
----

query IIIIIII rowsort label-920
SELECT * FROM tab3 WHERE - col1 * - col0 / col3 + - col4 IS NULL
----

query IIIIIII rowsort label-920
SELECT * FROM tab4 WHERE - col1 * - col0 / col3 + - col4 IS NULL
----

query I rowsort label-925
SELECT DISTINCT - col4 AS col1 FROM tab0 WHERE NULL = - 84 / 23 + - + col0 + + col1
----

query I rowsort label-925
SELECT DISTINCT - col4 AS col1 FROM tab1 WHERE NULL = - 84 / 23 + - + col0 + + col1
----

query I rowsort label-925
SELECT DISTINCT - col4 AS col1 FROM tab2 WHERE NULL = - 84 / 23 + - + col0 + + col1
----

query I rowsort label-925
SELECT DISTINCT - col4 AS col1 FROM tab3 WHERE NULL = - 84 / 23 + - + col0 + + col1
----

query I rowsort label-925
SELECT DISTINCT - col4 AS col1 FROM tab4 WHERE NULL = - 84 / 23 + - + col0 + + col1
----

query IIIIIII rowsort label-930
SELECT * FROM tab0 AS cor0 WHERE NOT col4 IS NOT NULL
----

query IIIIIII rowsort label-930
SELECT * FROM tab1 AS cor0 WHERE NOT col4 IS NOT NULL
----

query IIIIIII rowsort label-930
SELECT * FROM tab2 AS cor0 WHERE NOT col4 IS NOT NULL
----

query IIIIIII rowsort label-930
SELECT * FROM tab3 AS cor0 WHERE NOT col4 IS NOT NULL
----

query IIIIIII rowsort label-930
SELECT * FROM tab4 AS cor0 WHERE NOT col4 IS NOT NULL
----

query I rowsort label-935
SELECT ALL + + col5 AS col2 FROM tab0 AS cor0 WHERE - col1 * - 78 * col1 + 21 IS NOT NULL
----
1000 values hashing to 2ed57cb9c408b954ec52c7a2da59153d

query I rowsort label-935
SELECT ALL + + col5 AS col2 FROM tab1 AS cor0 WHERE - col1 * - 78 * col1 + 21 IS NOT NULL
----
1000 values hashing to 2ed57cb9c408b954ec52c7a2da59153d

query I rowsort label-935
SELECT ALL + + col5 AS col2 FROM tab2 AS cor0 WHERE - col1 * - 78 * col1 + 21 IS NOT NULL
----
1000 values hashing to 2ed57cb9c408b954ec52c7a2da59153d

query I rowsort label-935
SELECT ALL + + col5 AS col2 FROM tab3 AS cor0 WHERE - col1 * - 78 * col1 + 21 IS NOT NULL
----
1000 values hashing to 2ed57cb9c408b954ec52c7a2da59153d

query I rowsort label-935
SELECT ALL + + col5 AS col2 FROM tab4 AS cor0 WHERE - col1 * - 78 * col1 + 21 IS NOT NULL
----
1000 values hashing to 2ed57cb9c408b954ec52c7a2da59153d

query I rowsort label-940
SELECT + + col0 / + col0 FROM tab0 WHERE ( NULL ) > ( NULL )
----

query I rowsort label-940
SELECT + + col0 / + col0 FROM tab1 WHERE ( NULL ) > ( NULL )
----

query I rowsort label-940
SELECT + + col0 / + col0 FROM tab2 WHERE ( NULL ) > ( NULL )
----

query I rowsort label-940
SELECT + + col0 / + col0 FROM tab3 WHERE ( NULL ) > ( NULL )
----

query I rowsort label-940
SELECT + + col0 / + col0 FROM tab4 WHERE ( NULL ) > ( NULL )
----

query I rowsort label-945
SELECT - 49 FROM tab0 AS cor0 WHERE NOT NULL IS NOT NULL
----
1000 values hashing to 0c423456490bd5d5f98d5147ab0e2ff9

query I rowsort label-945
SELECT - 49 FROM tab1 AS cor0 WHERE NOT NULL IS NOT NULL
----
1000 values hashing to 0c423456490bd5d5f98d5147ab0e2ff9

query I rowsort label-945
SELECT - 49 FROM tab2 AS cor0 WHERE NOT NULL IS NOT NULL
----
1000 values hashing to 0c423456490bd5d5f98d5147ab0e2ff9

query I rowsort label-945
SELECT - 49 FROM tab3 AS cor0 WHERE NOT NULL IS NOT NULL
----
1000 values hashing to 0c423456490bd5d5f98d5147ab0e2ff9

query I rowsort label-945
SELECT - 49 FROM tab4 AS cor0 WHERE NOT NULL IS NOT NULL
----
1000 values hashing to 0c423456490bd5d5f98d5147ab0e2ff9

query IIIIIII rowsort label-950
SELECT * FROM tab0 AS cor0 WHERE NOT col1 IS NOT NULL
----

query IIIIIII rowsort label-950
SELECT * FROM tab1 AS cor0 WHERE NOT col1 IS NOT NULL
----

query IIIIIII rowsort label-950
SELECT * FROM tab2 AS cor0 WHERE NOT col1 IS NOT NULL
----

query IIIIIII rowsort label-950
SELECT * FROM tab3 AS cor0 WHERE NOT col1 IS NOT NULL
----

query IIIIIII rowsort label-950
SELECT * FROM tab4 AS cor0 WHERE NOT col1 IS NOT NULL
----

query I rowsort label-955
SELECT 69 AS col0 FROM tab0 AS cor0 WHERE col4 IN ( - col0 )
----

query I rowsort label-955
SELECT 69 AS col0 FROM tab1 AS cor0 WHERE col4 IN ( - col0 )
----

query I rowsort label-955
SELECT 69 AS col0 FROM tab2 AS cor0 WHERE col4 IN ( - col0 )
----

query I rowsort label-955
SELECT 69 AS col0 FROM tab3 AS cor0 WHERE col4 IN ( - col0 )
----

query I rowsort label-955
SELECT 69 AS col0 FROM tab4 AS cor0 WHERE col4 IN ( - col0 )
----

onlyif mysql # CAST syntax: SIGNED type: 
query I rowsort label-960
SELECT DISTINCT + + col0 * - col4 AS col2 FROM tab0 WHERE NOT ( + CAST( NULL AS SIGNED ) ) NOT BETWEEN ( NULL ) AND + col4
----

skipif mysql # not compatible
query I rowsort label-960
SELECT DISTINCT + + col0 * - col4 AS col2 FROM tab0 WHERE NOT ( + CAST ( NULL AS INTEGER ) ) NOT BETWEEN ( NULL ) AND + col4
----

onlyif mysql # CAST syntax: SIGNED type: 
query I rowsort label-960
SELECT DISTINCT + + col0 * - col4 AS col2 FROM tab1 WHERE NOT ( + CAST( NULL AS SIGNED ) ) NOT BETWEEN ( NULL ) AND + col4
----

skipif mysql # not compatible
query I rowsort label-960
SELECT DISTINCT + + col0 * - col4 AS col2 FROM tab1 WHERE NOT ( + CAST ( NULL AS INTEGER ) ) NOT BETWEEN ( NULL ) AND + col4
----

onlyif mysql # CAST syntax: SIGNED type: 
query I rowsort label-960
SELECT DISTINCT + + col0 * - col4 AS col2 FROM tab2 WHERE NOT ( + CAST( NULL AS SIGNED ) ) NOT BETWEEN ( NULL ) AND + col4
----

skipif mysql # not compatible
query I rowsort label-960
SELECT DISTINCT + + col0 * - col4 AS col2 FROM tab2 WHERE NOT ( + CAST ( NULL AS INTEGER ) ) NOT BETWEEN ( NULL ) AND + col4
----

onlyif mysql # CAST syntax: SIGNED type: 
query I rowsort label-960
SELECT DISTINCT + + col0 * - col4 AS col2 FROM tab3 WHERE NOT ( + CAST( NULL AS SIGNED ) ) NOT BETWEEN ( NULL ) AND + col4
----

skipif mysql # not compatible
query I rowsort label-960
SELECT DISTINCT + + col0 * - col4 AS col2 FROM tab3 WHERE NOT ( + CAST ( NULL AS INTEGER ) ) NOT BETWEEN ( NULL ) AND + col4
----

onlyif mysql # CAST syntax: SIGNED type: 
query I rowsort label-960
SELECT DISTINCT + + col0 * - col4 AS col2 FROM tab4 WHERE NOT ( + CAST( NULL AS SIGNED ) ) NOT BETWEEN ( NULL ) AND + col4
----

skipif mysql # not compatible
query I rowsort label-960
SELECT DISTINCT + + col0 * - col4 AS col2 FROM tab4 WHERE NOT ( + CAST ( NULL AS INTEGER ) ) NOT BETWEEN ( NULL ) AND + col4
----

query IIIIIII rowsort label-965
SELECT * FROM tab0 WHERE - 91 >= + ( 92 )
----

query IIIIIII rowsort label-965
SELECT * FROM tab1 WHERE - 91 >= + ( 92 )
----

query IIIIIII rowsort label-965
SELECT * FROM tab2 WHERE - 91 >= + ( 92 )
----

query IIIIIII rowsort label-965
SELECT * FROM tab3 WHERE - 91 >= + ( 92 )
----

query IIIIIII rowsort label-965
SELECT * FROM tab4 WHERE - 91 >= + ( 92 )
----

query I rowsort label-970
SELECT ALL + col2 FROM tab0 WHERE NOT col2 IS NOT NULL
----

query I rowsort label-970
SELECT ALL + col2 FROM tab1 WHERE NOT col2 IS NOT NULL
----

query I rowsort label-970
SELECT ALL + col2 FROM tab2 WHERE NOT col2 IS NOT NULL
----

query I rowsort label-970
SELECT ALL + col2 FROM tab3 WHERE NOT col2 IS NOT NULL
----

query I rowsort label-970
SELECT ALL + col2 FROM tab4 WHERE NOT col2 IS NOT NULL
----

onlyif mysql # aggregate syntax: 
query II rowsort label-975
SELECT DISTINCT - - 55 AS col2, + COUNT( ALL + + 31 ) AS col5 FROM tab0 AS cor0 WHERE NOT ( NULL ) IS NOT NULL
----
55
1000

skipif mysql # not compatible
query II rowsort label-975
SELECT DISTINCT - - 55 AS col2, + COUNT ( ALL + + 31 ) AS col5 FROM tab0 AS cor0 WHERE NOT ( NULL ) IS NOT NULL
----
55
1000

onlyif mysql # aggregate syntax: 
query II rowsort label-975
SELECT DISTINCT - - 55 AS col2, + COUNT( ALL + + 31 ) AS col5 FROM tab1 AS cor0 WHERE NOT ( NULL ) IS NOT NULL
----
55
1000

skipif mysql # not compatible
query II rowsort label-975
SELECT DISTINCT - - 55 AS col2, + COUNT ( ALL + + 31 ) AS col5 FROM tab1 AS cor0 WHERE NOT ( NULL ) IS NOT NULL
----
55
1000

onlyif mysql # aggregate syntax: 
query II rowsort label-975
SELECT DISTINCT - - 55 AS col2, + COUNT( ALL + + 31 ) AS col5 FROM tab2 AS cor0 WHERE NOT ( NULL ) IS NOT NULL
----
55
1000

skipif mysql # not compatible
query II rowsort label-975
SELECT DISTINCT - - 55 AS col2, + COUNT ( ALL + + 31 ) AS col5 FROM tab2 AS cor0 WHERE NOT ( NULL ) IS NOT NULL
----
55
1000

onlyif mysql # aggregate syntax: 
query II rowsort label-975
SELECT DISTINCT - - 55 AS col2, + COUNT( ALL + + 31 ) AS col5 FROM tab3 AS cor0 WHERE NOT ( NULL ) IS NOT NULL
----
55
1000

skipif mysql # not compatible
query II rowsort label-975
SELECT DISTINCT - - 55 AS col2, + COUNT ( ALL + + 31 ) AS col5 FROM tab3 AS cor0 WHERE NOT ( NULL ) IS NOT NULL
----
55
1000

onlyif mysql # aggregate syntax: 
query II rowsort label-975
SELECT DISTINCT - - 55 AS col2, + COUNT( ALL + + 31 ) AS col5 FROM tab4 AS cor0 WHERE NOT ( NULL ) IS NOT NULL
----
55
1000

skipif mysql # not compatible
query II rowsort label-975
SELECT DISTINCT - - 55 AS col2, + COUNT ( ALL + + 31 ) AS col5 FROM tab4 AS cor0 WHERE NOT ( NULL ) IS NOT NULL
----
55
1000

query IIIIIII rowsort label-980
SELECT ALL * FROM tab0 AS cor0 WHERE NOT ( NULL ) IS NULL
----

query IIIIIII rowsort label-980
SELECT ALL * FROM tab1 AS cor0 WHERE NOT ( NULL ) IS NULL
----

query IIIIIII rowsort label-980
SELECT ALL * FROM tab2 AS cor0 WHERE NOT ( NULL ) IS NULL
----

query IIIIIII rowsort label-980
SELECT ALL * FROM tab3 AS cor0 WHERE NOT ( NULL ) IS NULL
----

query IIIIIII rowsort label-980
SELECT ALL * FROM tab4 AS cor0 WHERE NOT ( NULL ) IS NULL
----

query I rowsort label-985
SELECT + col0 AS col3 FROM tab0 cor0 WHERE NOT col4 * - 76 IS NULL
----
1000 values hashing to 246e64dff83b87422885732f0ed3966f

query I rowsort label-985
SELECT + col0 AS col3 FROM tab1 cor0 WHERE NOT col4 * - 76 IS NULL
----
1000 values hashing to 246e64dff83b87422885732f0ed3966f

query I rowsort label-985
SELECT + col0 AS col3 FROM tab2 cor0 WHERE NOT col4 * - 76 IS NULL
----
1000 values hashing to 246e64dff83b87422885732f0ed3966f

query I rowsort label-985
SELECT + col0 AS col3 FROM tab3 cor0 WHERE NOT col4 * - 76 IS NULL
----
1000 values hashing to 246e64dff83b87422885732f0ed3966f

query I rowsort label-985
SELECT + col0 AS col3 FROM tab4 cor0 WHERE NOT col4 * - 76 IS NULL
----
1000 values hashing to 246e64dff83b87422885732f0ed3966f

query IIIIIII rowsort label-990
SELECT ALL * FROM tab0 AS cor0 WHERE NOT ( NULL NOT BETWEEN - 79 AND + col3 )
----

query IIIIIII rowsort label-990
SELECT ALL * FROM tab1 AS cor0 WHERE NOT ( NULL NOT BETWEEN - 79 AND + col3 )
----

query IIIIIII rowsort label-990
SELECT ALL * FROM tab2 AS cor0 WHERE NOT ( NULL NOT BETWEEN - 79 AND + col3 )
----

query IIIIIII rowsort label-990
SELECT ALL * FROM tab3 AS cor0 WHERE NOT ( NULL NOT BETWEEN - 79 AND + col3 )
----

query IIIIIII rowsort label-990
SELECT ALL * FROM tab4 AS cor0 WHERE NOT ( NULL NOT BETWEEN - 79 AND + col3 )
----

query I rowsort label-995
SELECT ALL col0 AS col1 FROM tab0 AS cor0 WHERE ( ( NOT + col1 > + 17 / + - col3 ) )
----

query I rowsort label-995
SELECT ALL col0 AS col1 FROM tab1 AS cor0 WHERE ( ( NOT + col1 > + 17 / + - col3 ) )
----

query I rowsort label-995
SELECT ALL col0 AS col1 FROM tab2 AS cor0 WHERE ( ( NOT + col1 > + 17 / + - col3 ) )
----

query I rowsort label-995
SELECT ALL col0 AS col1 FROM tab3 AS cor0 WHERE ( ( NOT + col1 > + 17 / + - col3 ) )
----

query I rowsort label-995
SELECT ALL col0 AS col1 FROM tab4 AS cor0 WHERE ( ( NOT + col1 > + 17 / + - col3 ) )
----

query IIIIIII rowsort label-1000
SELECT ALL * FROM tab0 WHERE + col3 IS NULL
----

query IIIIIII rowsort label-1000
SELECT ALL * FROM tab1 WHERE + col3 IS NULL
----

query IIIIIII rowsort label-1000
SELECT ALL * FROM tab2 WHERE + col3 IS NULL
----

query IIIIIII rowsort label-1000
SELECT ALL * FROM tab3 WHERE + col3 IS NULL
----

query IIIIIII rowsort label-1000
SELECT ALL * FROM tab4 WHERE + col3 IS NULL
----

query IIIIIII rowsort label-1005
SELECT * FROM tab0 AS cor0 WHERE ( NULL ) IN ( 86, + 65 )
----

query IIIIIII rowsort label-1005
SELECT * FROM tab1 AS cor0 WHERE ( NULL ) IN ( 86, + 65 )
----

query IIIIIII rowsort label-1005
SELECT * FROM tab2 AS cor0 WHERE ( NULL ) IN ( 86, + 65 )
----

query IIIIIII rowsort label-1005
SELECT * FROM tab3 AS cor0 WHERE ( NULL ) IN ( 86, + 65 )
----

query IIIIIII rowsort label-1005
SELECT * FROM tab4 AS cor0 WHERE ( NULL ) IN ( 86, + 65 )
----

query I rowsort label-1010
SELECT ALL + ( - 1 ) FROM tab0 AS cor0 WHERE 58 IS NULL
----

query I rowsort label-1010
SELECT ALL + ( - 1 ) FROM tab1 AS cor0 WHERE 58 IS NULL
----

query I rowsort label-1010
SELECT ALL + ( - 1 ) FROM tab2 AS cor0 WHERE 58 IS NULL
----

query I rowsort label-1010
SELECT ALL + ( - 1 ) FROM tab3 AS cor0 WHERE 58 IS NULL
----

query I rowsort label-1010
SELECT ALL + ( - 1 ) FROM tab4 AS cor0 WHERE 58 IS NULL
----

query IIIIIII rowsort label-1015
SELECT ALL * FROM tab0 AS cor0 WHERE 11 IS NULL
----

query IIIIIII rowsort label-1015
SELECT ALL * FROM tab1 AS cor0 WHERE 11 IS NULL
----

query IIIIIII rowsort label-1015
SELECT ALL * FROM tab2 AS cor0 WHERE 11 IS NULL
----

query IIIIIII rowsort label-1015
SELECT ALL * FROM tab3 AS cor0 WHERE 11 IS NULL
----

query IIIIIII rowsort label-1015
SELECT ALL * FROM tab4 AS cor0 WHERE 11 IS NULL
----

onlyif mysql # aggregate syntax: 
query I rowsort label-1020
SELECT COUNT( * ) FROM tab0 AS cor0 WHERE NOT - 96 + - ( + 83 ) IS NULL
----
1000

skipif mysql # not compatible
query I rowsort label-1020
SELECT COUNT ( * ) FROM tab0 AS cor0 WHERE NOT - 96 + - ( + 83 ) IS NULL
----
1000

onlyif mysql # aggregate syntax: 
query I rowsort label-1020
SELECT COUNT( * ) FROM tab1 AS cor0 WHERE NOT - 96 + - ( + 83 ) IS NULL
----
1000

skipif mysql # not compatible
query I rowsort label-1020
SELECT COUNT ( * ) FROM tab1 AS cor0 WHERE NOT - 96 + - ( + 83 ) IS NULL
----
1000

onlyif mysql # aggregate syntax: 
query I rowsort label-1020
SELECT COUNT( * ) FROM tab2 AS cor0 WHERE NOT - 96 + - ( + 83 ) IS NULL
----
1000

skipif mysql # not compatible
query I rowsort label-1020
SELECT COUNT ( * ) FROM tab2 AS cor0 WHERE NOT - 96 + - ( + 83 ) IS NULL
----
1000

onlyif mysql # aggregate syntax: 
query I rowsort label-1020
SELECT COUNT( * ) FROM tab3 AS cor0 WHERE NOT - 96 + - ( + 83 ) IS NULL
----
1000

skipif mysql # not compatible
query I rowsort label-1020
SELECT COUNT ( * ) FROM tab3 AS cor0 WHERE NOT - 96 + - ( + 83 ) IS NULL
----
1000

onlyif mysql # aggregate syntax: 
query I rowsort label-1020
SELECT COUNT( * ) FROM tab4 AS cor0 WHERE NOT - 96 + - ( + 83 ) IS NULL
----
1000

skipif mysql # not compatible
query I rowsort label-1020
SELECT COUNT ( * ) FROM tab4 AS cor0 WHERE NOT - 96 + - ( + 83 ) IS NULL
----
1000

query IIIIIII rowsort label-1025
SELECT * FROM tab0 AS cor0 WHERE NOT + col1 <> NULL
----

query IIIIIII rowsort label-1025
SELECT * FROM tab1 AS cor0 WHERE NOT + col1 <> NULL
----

query IIIIIII rowsort label-1025
SELECT * FROM tab2 AS cor0 WHERE NOT + col1 <> NULL
----

query IIIIIII rowsort label-1025
SELECT * FROM tab3 AS cor0 WHERE NOT + col1 <> NULL
----

query IIIIIII rowsort label-1025
SELECT * FROM tab4 AS cor0 WHERE NOT + col1 <> NULL
----

query IIIIIII rowsort label-1030
SELECT * FROM tab0 cor0 WHERE NOT ( - col1 ) = NULL
----

query IIIIIII rowsort label-1030
SELECT * FROM tab1 cor0 WHERE NOT ( - col1 ) = NULL
----

query IIIIIII rowsort label-1030
SELECT * FROM tab2 cor0 WHERE NOT ( - col1 ) = NULL
----

query IIIIIII rowsort label-1030
SELECT * FROM tab3 cor0 WHERE NOT ( - col1 ) = NULL
----

query IIIIIII rowsort label-1030
SELECT * FROM tab4 cor0 WHERE NOT ( - col1 ) = NULL
----

skipif postgresql # PostgreSQL requires AS when renaming output columns
query I rowsort label-1035
SELECT + col1 col5 FROM tab0 AS cor0 WHERE NOT NULL < 73
----

skipif postgresql # PostgreSQL requires AS when renaming output columns
query I rowsort label-1035
SELECT + col1 col5 FROM tab1 AS cor0 WHERE NOT NULL < 73
----

skipif postgresql # PostgreSQL requires AS when renaming output columns
query I rowsort label-1035
SELECT + col1 col5 FROM tab2 AS cor0 WHERE NOT NULL < 73
----

skipif postgresql # PostgreSQL requires AS when renaming output columns
query I rowsort label-1035
SELECT + col1 col5 FROM tab3 AS cor0 WHERE NOT NULL < 73
----

skipif postgresql # PostgreSQL requires AS when renaming output columns
query I rowsort label-1035
SELECT + col1 col5 FROM tab4 AS cor0 WHERE NOT NULL < 73
----

query IIIIIII rowsort label-1040
SELECT ALL * FROM tab0 AS cor0 WHERE col1 >= NULL
----

query IIIIIII rowsort label-1040
SELECT ALL * FROM tab1 AS cor0 WHERE col1 >= NULL
----

query IIIIIII rowsort label-1040
SELECT ALL * FROM tab2 AS cor0 WHERE col1 >= NULL
----

query IIIIIII rowsort label-1040
SELECT ALL * FROM tab3 AS cor0 WHERE col1 >= NULL
----

query IIIIIII rowsort label-1040
SELECT ALL * FROM tab4 AS cor0 WHERE col1 >= NULL
----

