Below is the list of changes that have just been committed into a local
5.0 repository of kgeorge. When kgeorge does a push these changes will
be propagated to the main repository and, within 24 hours after the
push, to the public repository.
For information on how to access the public repository
see http://dev.mysql.com/doc/mysql/en/installing-source-tree.html
ChangeSet
1.2095 06/03/27 13:32:19 gkodinov@stripped +2 -0
Test case for BUG#15188 : SELECT DISTINCT returns no results even though valid ones exist
Reproduced in 5.0.16-nt. Verified it's fixed in 5.0.20
mysql-test/t/group_min_max.test
1.20 06/03/27 13:32:14 gkodinov@stripped +379 -0
Test case for BUG#15188 : SELECT DISTINCT returns no results even though valid ones exist
Reproduced in 5.0.16-nt. Verified it's fixed in 5.0.20
mysql-test/r/group_min_max.result
1.22 06/03/27 13:32:14 gkodinov@stripped +379 -0
Test case for BUG#15188 : SELECT DISTINCT returns no results even though valid ones exist
Reproduced in 5.0.16-nt. Verified it's fixed in 5.0.20
# This is a BitKeeper patch. What follows are the unified diffs for the
# set of deltas contained in the patch. The rest of the patch, the part
# that BitKeeper cares about, is below these diffs.
# User: gkodinov
# Host: rakia.progem.bg
# Root: /home/kgeorge/mysql/5.0/B15198
--- 1.21/mysql-test/r/group_min_max.result 2006-03-27 12:20:16 +03:00
+++ 1.22/mysql-test/r/group_min_max.result 2006-03-27 13:32:14 +03:00
@@ -2107,3 +2107,382 @@
1
DROP TABLE t1;
DROP PROCEDURE a;
+CREATE TABLE t1 (
+a varchar(255) NOT NULL default '',
+b varchar(255) NOT NULL default 'Initialized',
+PRIMARY KEY (a),
+KEY b (b)
+) ENGINE=MyISAM DEFAULT CHARSET=latin1;
+INSERT INTO t1 (a, b) VALUES ('433851555675357289073026933', 'Fraud'),
+('43397554553922566013999002', 'Fraud'),
+('43397527754518797084166539', 'Fraud'),
+('43397544555525489095574002', 'Fraud'),
+('4335151567541656759043170119', 'Chargeback'),
+('4335155555556956555565076303761', 'Fraud'),
+('43351564560604040065769907', 'Fraud'),
+('4335156552562278521068397301', 'Fraud'),
+('433531056515113839082044437', 'Fraud'),
+('4335312054755544564048818773', 'Fraud'),
+('4335312453535455289021661981', 'Fraud'),
+('43353129253153842041059325', 'Fraud'),
+('433533235561535540025688181', 'Memo'),
+('4335472531522251518014901117', 'Memo'),
+('4335654545455354565132049200016', 'Initialized'),
+('4340051831705110048465420', 'Initialized'),
+('43402564562075466001214928', 'Initialized'),
+('4340515154154552531003990937', 'Initialized'),
+('43405255525895532057887701', 'Initialized'),
+('434054545563206546098130524', 'Initialized'),
+('43413735243513541011868326', 'Initialized'),
+('434135155557525454540002756026', 'Initialized'),
+('43413569345425586098665561', 'Initialized'),
+('434146645615552560071208756', 'Initialized'),
+('43414515454555404548033743990', 'Initialized'),
+('4341599054852268086412037', 'Initialized'),
+('4342011535555525506059874435', 'Initialized'),
+('43421306307106026374323', 'Initialized'),
+('43422525055557961044668274', 'Initialized'),
+('43424515651535655549056796133', 'Initialized'),
+('4342554540247846074002022', 'Initialized'),
+('434255656635295402094614534', 'Initialized'),
+('434268101656140058869756', 'Initialized'),
+('4342794089545327044043511', 'Initialized'),
+('4342925154452515321047639968', 'Initialized'),
+('434299565354544520041101623', 'Initialized'),
+('434251540699556531082506920', 'Initialized'),
+('4342515651194252527076535270', 'Initialized'),
+('43425469451566323007623330', 'Initialized'),
+('434254585523656539019778352', 'Initialized'),
+('434326657532046076244646', 'Initialized'),
+('434333515555675269031530005', 'Initialized'),
+('43433525135742511017703852', 'Initialized'),
+('4343853535150535538070069284', 'Initialized'),
+('43439583555565569072350841', 'Initialized'),
+('4343518525340515465052638672', 'Initialized'),
+('4350385503053567012823940', 'Confirmed'),
+('435078954555054566047368365', 'Confirmed'),
+('435075452675585296098242766', 'Initialized'),
+('435080349561917094116657', 'Confirmed'),
+('43508915255852107006713959', 'Initialized'),
+('435052510365445105071751617', 'Initialized'),
+('4350530515695395144014699993', 'Confirmed'),
+('435053534153425631085814007', 'Initialized'),
+('43505417538515256556064198965', 'Confirmed'),
+('43505445143451666059958142', 'Initialized'),
+('43505442910451547034230245', 'Confirmed'),
+('43505494606538522073845215', 'Initialized'),
+('43505552892854580004106255', 'Confirmed'),
+('435055534291566545019630012', 'Initialized'),
+('43505615652551153520016390011', 'Confirmed'),
+('43505654380565372023387272', 'Confirmed'),
+('4350566054515152778032868208', 'Fraud'),
+('4350568454455515226017009285', 'Fraud'),
+('4350565454512051421098503958', 'Confirmed'),
+('435105453328522520076722143', 'Fraud'),
+('435128853471377014795472', 'Initialized'),
+('4351254353545615120077716754', 'Initialized'),
+('43512555151001295071158378', 'Confirmed'),
+('43514851562554157041725764', 'Initialized'),
+('4351605552740530076112516', 'Confirmed'),
+('435161545635356511050982352', 'Initialized'),
+('43517955052535251537018956804', 'Confirmed'),
+('435195564516556543062993525', 'Confirmed'),
+('43515155005345601095126464', 'Confirmed'),
+('43515255515195666542057188544', 'Confirmed'),
+('43515354752540251569005435939', 'Confirmed'),
+('435154525355544751557080558549', 'Confirmed'),
+('4352163356396535076368736', 'Initialized'),
+('435242856852654543015727184', 'Initialized'),
+('4352556085689513033741453', 'Confirmed'),
+('43527772307004069813737', 'Confirmed'),
+('4352954680345297002388488', 'Confirmed'),
+('43525418705356844017996327', 'Confirmed'),
+('435255141554517565001701859', 'Initialized'),
+('4352545505100519567027448246', 'Initialized'),
+('435256539563345406024498104', 'Confirmed'),
+('43530555493919533051840508', 'Initialized'),
+('435325354353562474088335158', 'Confirmed'),
+('4353351053965604054794792', 'Initialized'),
+('43533725309565296019887881', 'Confirmed'),
+('4353467655665167055278778', 'Initialized'),
+('4353535453251535153069972418', 'Confirmed'),
+('4353556892083528076494596', 'Chargeback'),
+('43536625468052562006339041', 'Confirmed'),
+('43538515154545651541094270796', 'Confirmed'),
+('4353974054515876014297713', 'Initialized'),
+('4353954226554034034492094', 'Confirmed'),
+('435397952452456532055924904', 'Confirmed'),
+('435352250644315096826083', 'Confirmed'),
+('43535315551154838003659355', 'Confirmed'),
+('4353535551559556526067200553', 'Confirmed'),
+('43535614667515535022933785', 'Confirmed'),
+('4354051675272531067354043', 'Initialized'),
+('4354108153328569061675135', 'Confirmed'),
+('43541214535581555014871878', 'Confirmed'),
+('435417565251453756079573544', 'Initialized'),
+('435415152351537648063003057', 'Confirmed'),
+('4354252073715650059591971', 'Confirmed'),
+('4354253305453956513088644961', 'Confirmed'),
+('4354454532519551546034116617', 'Confirmed'),
+('43546458176110011558318', 'Initialized'),
+('435491932754793047013645', 'Confirmed'),
+('435497454545245478040422346', 'Initialized'),
+('43545213515823521090843850', 'Initialized'),
+('43545225564545656028777784', 'Confirmed'),
+('43545251529510384053495324', 'Confirmed'),
+('4354532300745392049645795', 'Confirmed'),
+('435453256551355374042454694', 'Confirmed'),
+('43545395382795361007386792', 'Confirmed'),
+('4354545519477403007015524', 'Confirmed'),
+('435454854512565920087565193', 'Confirmed'),
+('435455665353555553551087295867', 'Initialized'),
+('435455620545535698023369188', 'Initialized'),
+('4354565253825654004096661617', 'Initialized'),
+('4355055153856535539065478169', 'Confirmed'),
+('43550851351535658036786676', 'Confirmed'),
+('435510452639397084035780', 'Confirmed'),
+('43551752543656368085636696', 'Confirmed'),
+('4355182353522562003074911', 'Confirmed'),
+('4355153054415352528087602700', 'Confirmed'),
+('435515480545692510078025345', 'Confirmed'),
+('43552652545151654523012857858', 'Confirmed'),
+('435529546536537552081177781', 'Initialized'),
+('4355295447356543031944361', 'Confirmed'),
+('435547253559545136074926321', 'Confirmed'),
+('4355465517651551061313653', 'Confirmed'),
+('4355451846515654519041112430', 'Confirmed'),
+('4355451530456545550046426132', 'Initialized'),
+('4355451513522516530097346667', 'Initialized'),
+('43554516650535546067883280', 'Confirmed'),
+('4355453548151564511029754545', 'Confirmed'),
+('43554555387352486063606077', 'Confirmed'),
+('43555140555176527014985053', 'Confirmed'),
+('4355543653194567053099836', 'Confirmed'),
+('43555418515355140064792007', 'Initialized'),
+('43555988545353563015065620', 'Confirmed'),
+('43555548527854473051856258', 'Confirmed'),
+('435565462541515519007636711', 'Confirmed'),
+('435576932555655516096701164', 'Confirmed'),
+('4355904536928560050035842', 'Confirmed'),
+('43559242756564556021993118', 'Initialized'),
+('4355951703445615021849737', 'Confirmed'),
+('43555131513565545018012333', 'Confirmed'),
+('43555305256342548087083608', 'Confirmed'),
+('43555351530953054526058840212', 'Initialized'),
+('4355545152051842540012001674', 'Confirmed'),
+('43555625645588048053475095', 'Initialized'),
+('435556856528339536041495185', 'Initialized'),
+('435601654521656550034846944', 'Confirmed'),
+('4356051754128289035525676', 'Initialized'),
+('435611949551955027414143', 'Confirmed'),
+('435618676995621083597066', 'Confirmed'),
+('4356153465495569081845068', 'Initialized'),
+('4356154555471543523036553032', 'Confirmed'),
+('43562095665178043884377', 'Initialized'),
+('435634156069478084072584', 'Initialized'),
+('435630495413057059215949', 'Confirmed'),
+('435635455156088565041078123', 'Initialized'),
+('43563555688453525062773033', 'Confirmed'),
+('435644415559090027650777', 'Confirmed'),
+('435645873153569091832778', 'Confirmed'),
+('435635317525315356034205946', 'Initialized'),
+('4356452278755209097229570', 'Confirmed'),
+('43565529525511016034712999', 'Confirmed'),
+('435655565401565572086241281', 'Initialized'),
+('4356615553515353524034122735', 'Confirmed'),
+('4356670527951375099823815', 'Confirmed'),
+('4356751542535517523018846197', 'Confirmed'),
+('435675551255567567010591570', 'Initialized'),
+('43567555556515565433079133319', 'Confirmed'),
+('4356834253655188039258440', 'Initialized'),
+('43568751532654935027615982', 'Confirmed'),
+('43568545475554551543060733082', 'Confirmed'),
+('4356943555425351028278672', 'Initialized'),
+('435696755651690050739687', 'Confirmed'),
+('435651253053321536020149625', 'Confirmed'),
+('4356546529765162039981819', 'Confirmed'),
+('435656715583155567013498017', 'Initialized'),
+('4357022274154553069887423', 'Confirmed'),
+('435656565305437865089473960', 'Confirmed'),
+('43572371555123561003410873', 'Confirmed'),
+('435745591568119084635785', 'Initialized'),
+('43575653051310548074702382', 'Initialized'),
+('435755165715545081961792', 'Initialized'),
+('435755353786251565000764646', 'Confirmed'),
+('435769613495411035325800', 'Initialized'),
+('43577535556561545402083153209', 'Confirmed'),
+('4357945122554037042433297', 'Confirmed'),
+('4357944973557537003993601', 'Confirmed'),
+('435795426915542013140631', 'Confirmed'),
+('4357977262551540085266737', 'Confirmed'),
+('435799565551551583079631492', 'Initialized'),
+('435795335663661095486983', 'Confirmed'),
+('4357512052515154197028747167', 'Confirmed'),
+('435751924210318060469107', 'Initialized'),
+('435751956865153664054075714', 'Confirmed'),
+('43575261195515416003104737', 'Confirmed'),
+('43575288052880532012142334', 'Confirmed'),
+('435753594345455551008394334', 'Confirmed'),
+('43575418421251517002358035', 'Initialized'),
+('4357542669566399071241706', 'Confirmed'),
+('435754582652510539066097655', 'Initialized'),
+('43575354524605653538030439587', 'Confirmed'),
+('4357551865351054523098619148', 'Memo'),
+('435755452520184545031341690', 'Initialized'),
+('4357562515153565607016617238', 'Initialized'),
+('43575654254139026053237383', 'Initialized'),
+('43580935335352078007163119', 'Confirmed'),
+('435809546595552515003784895', 'Confirmed'),
+('4358145432055961049174030', 'Confirmed'),
+('4358395250654160031942680', 'Confirmed'),
+('43583517557697545036379838', 'Confirmed'),
+('4358353555178527524047188707', 'Initialized'),
+('4358656518536515123049841262', 'Initialized'),
+('4358851565135555030080564057', 'Confirmed'),
+('435885659445652535081674709', 'Confirmed'),
+('43589153545120247000370084', 'Confirmed'),
+('43589355531511186050935778', 'Initialized'),
+('43585153151973385076226733', 'Confirmed'),
+('4358525115365569533055291703', 'Confirmed'),
+('4358557749685658090707746', 'Initialized'),
+('4358559569555515661031509972', 'Confirmed'),
+('4358561811952148023459945', 'Confirmed'),
+('4358562451537545342010705724', 'Initialized'),
+('435905355452953655033352184', 'Confirmed'),
+('435905393053529536048244131', 'Initialized'),
+('43590555252285722096710414', 'Initialized'),
+('43590555518545238030746949', 'Initialized'),
+('4359056525152156410094586570', 'Initialized'),
+('435916857620545014965876', 'Initialized'),
+('435935518540553549027268422', 'Initialized'),
+('435937521515351477035070560', 'Confirmed'),
+('4359352808615235033071171', 'Confirmed'),
+('43593555575325815039856569', 'Confirmed'),
+('43594053523456245042570486', 'Initialized'),
+('4359405554055449070916864', 'Memo'),
+('43594155954265652096474792', 'Confirmed'),
+('4359516908555195088232102', 'Initialized'),
+('43595519525151553535070229791', 'Initialized'),
+('43596353544998528047780700', 'Initialized'),
+('435964075620174030609068', 'Confirmed'),
+('4359745694954655015423809', 'Confirmed'),
+('435975154304896051673258', 'Initialized'),
+('4359953295285525025260963', 'Confirmed'),
+('43595135252855652538078070523', 'Confirmed'),
+('43595155356529454560004203133', 'Confirmed'),
+('4359522051534351514011020875', 'Initialized'),
+('4359559252756554530019523356', 'Initialized'),
+('435956640575653540093985755', 'Confirmed'),
+('43551151165456528547055235343', 'Initialized'),
+('435511515539505558039855407', 'Initialized'),
+('435513740591082063305981', 'Confirmed'),
+('4355135456525156617092403523', 'Initialized'),
+('4355141954656511517068107338', 'Initialized'),
+('43551445255453051536016473721', 'Confirmed'),
+('43551456066525353522059181238', 'Confirmed'),
+('435515231517553519070013188', 'Confirmed'),
+('4355165083852638010622907', 'Initialized'),
+('435515527051511081067587759', 'Initialized'),
+('43551656545263515590084748734', 'Confirmed'),
+('43551845209531513010926287', 'Initialized'),
+('4355195685152173544020697600', 'Confirmed'),
+('4355151261538555301098869708', 'Confirmed'),
+('43551525345185295312050721474', 'Confirmed'),
+('4355154534015554309000431369', 'Initialized'),
+('4355155652525454705076995125', 'Confirmed'),
+('435525515655154901086434818', 'Confirmed'),
+('435527133885351516083015435', 'Confirmed'),
+('4355289665453552547056480343', 'Initialized'),
+('43552852555395525218041108373', 'Initialized'),
+('43552955515251453479040131920', 'Initialized'),
+('43552511534555155517018977840', 'Confirmed'),
+('435525176566556316083985702', 'Initialized'),
+('4355255524219522528081611290', 'Confirmed'),
+('43552555255541566976090615426', 'Confirmed'),
+('43552565654554565135037266533', 'Confirmed'),
+('435532654131854542098689708', 'Confirmed'),
+('43553489541237547053013772', 'Confirmed'),
+('4355377061185539081286898', 'Confirmed'),
+('4355382555551153405038778896', 'Confirmed'),
+('4355398569545677546078736415', 'Confirmed'),
+('4355351705435436515095157512', 'Confirmed'),
+('435535285355555335285063474293', 'Confirmed'),
+('43553526254425152510012475390', 'Confirmed'),
+('43553515565435256623080851260', 'Confirmed'),
+('43553535438154538557069596780', 'Confirmed'),
+('4355355852667853553059872658', 'Confirmed'),
+('43553563040569198097661473', 'Confirmed'),
+('43554152516051527568070315001', 'Confirmed'),
+('435541555222495248063028975', 'Confirmed'),
+('43554205512567866061267501', 'Confirmed'),
+('4355435265753557524046955897', 'Confirmed'),
+('4355451643520964004400622', 'Confirmed'),
+('435546552345554404066423355', 'Confirmed'),
+('4355465355534952553018928131', 'Confirmed'),
+('4355495054543546563004328744', 'Confirmed'),
+('4355494564555270549024376672', 'Confirmed'),
+('43554969585382526029203849', 'Confirmed'),
+('4355454662766812028314560', 'Confirmed'),
+('435545452535122555540049473710', 'Confirmed'),
+('4355455918593583030930979', 'Confirmed'),
+('435545596805108538009522516', 'Confirmed'),
+('43554552676565254558060394357', 'Confirmed'),
+('435552384858183024600553', 'Confirmed'),
+('43555288264565531046959879', 'Confirmed'),
+('4355525156565170287016248927', 'Confirmed'),
+('4355531469427534086142163', 'Confirmed'),
+('4355531555616559526060042928', 'Confirmed'),
+('43555360856852539076664787', 'Confirmed'),
+('43555365449547313013223283', 'Confirmed'),
+('43555407995515680079795889', 'Confirmed'),
+('43555535552533566086598566', 'Confirmed'),
+('435556177854752569031558905', 'Confirmed'),
+('435556254545982556062738533', 'Confirmed'),
+('43555649335351823054782782', 'Confirmed'),
+('435557152825355353041493302', 'Confirmed'),
+('4355575253542533533013971727', 'Confirmed'),
+('4355575651539239556061584719', 'Confirmed'),
+('43555815451254568530014955150', 'Memo'),
+('435559540537753377048455961', 'Confirmed'),
+('43555515554054975461079189699', 'Confirmed'),
+('4355552985276555602041463872', 'Confirmed'),
+('435555451519541555252071771865', 'Confirmed'),
+('43645388515253698013162324', 'Confirmed'),
+('436454854105259543060538425', 'Confirmed'),
+('437515655519541751564090846291', 'Memo'),
+('437515656525155543867098474601', 'Memo'),
+('437520541535256510555086614548', 'Confirmed'),
+('43752432552854519083769371', 'URL Attack'),
+('4375265653554161516073783834', 'Confirmed'),
+('437548593532515695051332858', 'Confirmed'),
+('43754530452515254400023395214', 'Confirmed'),
+('437545456513515668098262470', 'Confirmed'),
+('43754553651515454970080565855', 'Confirmed'),
+('437545560568511155072166209', 'Confirmed'),
+('4375455519582152533011434853', 'Confirmed'),
+('43754555241784174085263678', 'Confirmed'),
+('4375502020998518002516569', 'Confirmed'),
+('43819856537255241015351442', 'Memo'),
+('438195125249516562027442327', 'Memo');
+explain extended SELECT DISTINCT b FROM t1 WHERE
+b != 'Confirmed' AND
+b != 'Initialized' AND
+b != 'Shipped' AND
+b != 'Contacted'
+ORDER BY b ASC;
+id select_type table type possible_keys key key_len ref rows Extra
+1 SIMPLE t1 range b b 257 NULL 1 Using where; Using index for group-by
+Warnings:
+Note 1003 select distinct `test`.`t1`.`b` AS `b` from `test`.`t1` where ((`test`.`t1`.`b` <> _latin1'Confirmed') and (`test`.`t1`.`b` <> _latin1'Initialized') and (`test`.`t1`.`b` <> _latin1'Shipped') and (`test`.`t1`.`b` <> _latin1'Contacted')) order by `test`.`t1`.`b`
+SELECT DISTINCT b FROM t1 WHERE
+b != 'Confirmed' AND
+b != 'Initialized' AND
+b != 'Shipped' AND
+b != 'Contacted'
+ORDER BY b ASC;
+b
+Chargeback
+Fraud
+Memo
+URL Attack
+DROP TABLE t1;
--- 1.19/mysql-test/t/group_min_max.test 2006-03-27 12:20:17 +03:00
+++ 1.20/mysql-test/t/group_min_max.test 2006-03-27 13:32:14 +03:00
@@ -774,3 +774,382 @@
DROP TABLE t1;
DROP PROCEDURE a;
+
+#
+# Bug #15188: SELECT DISTINCT returns no results even though valid ones exist
+#
+
+CREATE TABLE t1 (
+ a varchar(255) NOT NULL default '',
+ b varchar(255) NOT NULL default 'Initialized',
+ PRIMARY KEY (a),
+ KEY b (b)
+) ENGINE=MyISAM DEFAULT CHARSET=latin1;
+
+INSERT INTO t1 (a, b) VALUES ('433851555675357289073026933', 'Fraud'),
+('43397554553922566013999002', 'Fraud'),
+('43397527754518797084166539', 'Fraud'),
+('43397544555525489095574002', 'Fraud'),
+('4335151567541656759043170119', 'Chargeback'),
+('4335155555556956555565076303761', 'Fraud'),
+('43351564560604040065769907', 'Fraud'),
+('4335156552562278521068397301', 'Fraud'),
+('433531056515113839082044437', 'Fraud'),
+('4335312054755544564048818773', 'Fraud'),
+('4335312453535455289021661981', 'Fraud'),
+('43353129253153842041059325', 'Fraud'),
+('433533235561535540025688181', 'Memo'),
+('4335472531522251518014901117', 'Memo'),
+('4335654545455354565132049200016', 'Initialized'),
+('4340051831705110048465420', 'Initialized'),
+('43402564562075466001214928', 'Initialized'),
+('4340515154154552531003990937', 'Initialized'),
+('43405255525895532057887701', 'Initialized'),
+('434054545563206546098130524', 'Initialized'),
+('43413735243513541011868326', 'Initialized'),
+('434135155557525454540002756026', 'Initialized'),
+('43413569345425586098665561', 'Initialized'),
+('434146645615552560071208756', 'Initialized'),
+('43414515454555404548033743990', 'Initialized'),
+('4341599054852268086412037', 'Initialized'),
+('4342011535555525506059874435', 'Initialized'),
+('43421306307106026374323', 'Initialized'),
+('43422525055557961044668274', 'Initialized'),
+('43424515651535655549056796133', 'Initialized'),
+('4342554540247846074002022', 'Initialized'),
+('434255656635295402094614534', 'Initialized'),
+('434268101656140058869756', 'Initialized'),
+('4342794089545327044043511', 'Initialized'),
+('4342925154452515321047639968', 'Initialized'),
+('434299565354544520041101623', 'Initialized'),
+('434251540699556531082506920', 'Initialized'),
+('4342515651194252527076535270', 'Initialized'),
+('43425469451566323007623330', 'Initialized'),
+('434254585523656539019778352', 'Initialized'),
+('434326657532046076244646', 'Initialized'),
+('434333515555675269031530005', 'Initialized'),
+('43433525135742511017703852', 'Initialized'),
+('4343853535150535538070069284', 'Initialized'),
+('43439583555565569072350841', 'Initialized'),
+('4343518525340515465052638672', 'Initialized'),
+('4350385503053567012823940', 'Confirmed'),
+('435078954555054566047368365', 'Confirmed'),
+('435075452675585296098242766', 'Initialized'),
+('435080349561917094116657', 'Confirmed'),
+('43508915255852107006713959', 'Initialized'),
+('435052510365445105071751617', 'Initialized'),
+('4350530515695395144014699993', 'Confirmed'),
+('435053534153425631085814007', 'Initialized'),
+('43505417538515256556064198965', 'Confirmed'),
+('43505445143451666059958142', 'Initialized'),
+('43505442910451547034230245', 'Confirmed'),
+('43505494606538522073845215', 'Initialized'),
+('43505552892854580004106255', 'Confirmed'),
+('435055534291566545019630012', 'Initialized'),
+('43505615652551153520016390011', 'Confirmed'),
+('43505654380565372023387272', 'Confirmed'),
+('4350566054515152778032868208', 'Fraud'),
+('4350568454455515226017009285', 'Fraud'),
+('4350565454512051421098503958', 'Confirmed'),
+('435105453328522520076722143', 'Fraud'),
+('435128853471377014795472', 'Initialized'),
+('4351254353545615120077716754', 'Initialized'),
+('43512555151001295071158378', 'Confirmed'),
+('43514851562554157041725764', 'Initialized'),
+('4351605552740530076112516', 'Confirmed'),
+('435161545635356511050982352', 'Initialized'),
+('43517955052535251537018956804', 'Confirmed'),
+('435195564516556543062993525', 'Confirmed'),
+('43515155005345601095126464', 'Confirmed'),
+('43515255515195666542057188544', 'Confirmed'),
+('43515354752540251569005435939', 'Confirmed'),
+('435154525355544751557080558549', 'Confirmed'),
+('4352163356396535076368736', 'Initialized'),
+('435242856852654543015727184', 'Initialized'),
+('4352556085689513033741453', 'Confirmed'),
+('43527772307004069813737', 'Confirmed'),
+('4352954680345297002388488', 'Confirmed'),
+('43525418705356844017996327', 'Confirmed'),
+('435255141554517565001701859', 'Initialized'),
+('4352545505100519567027448246', 'Initialized'),
+('435256539563345406024498104', 'Confirmed'),
+('43530555493919533051840508', 'Initialized'),
+('435325354353562474088335158', 'Confirmed'),
+('4353351053965604054794792', 'Initialized'),
+('43533725309565296019887881', 'Confirmed'),
+('4353467655665167055278778', 'Initialized'),
+('4353535453251535153069972418', 'Confirmed'),
+('4353556892083528076494596', 'Chargeback'),
+('43536625468052562006339041', 'Confirmed'),
+('43538515154545651541094270796', 'Confirmed'),
+('4353974054515876014297713', 'Initialized'),
+('4353954226554034034492094', 'Confirmed'),
+('435397952452456532055924904', 'Confirmed'),
+('435352250644315096826083', 'Confirmed'),
+('43535315551154838003659355', 'Confirmed'),
+('4353535551559556526067200553', 'Confirmed'),
+('43535614667515535022933785', 'Confirmed'),
+('4354051675272531067354043', 'Initialized'),
+('4354108153328569061675135', 'Confirmed'),
+('43541214535581555014871878', 'Confirmed'),
+('435417565251453756079573544', 'Initialized'),
+('435415152351537648063003057', 'Confirmed'),
+('4354252073715650059591971', 'Confirmed'),
+('4354253305453956513088644961', 'Confirmed'),
+('4354454532519551546034116617', 'Confirmed'),
+('43546458176110011558318', 'Initialized'),
+('435491932754793047013645', 'Confirmed'),
+('435497454545245478040422346', 'Initialized'),
+('43545213515823521090843850', 'Initialized'),
+('43545225564545656028777784', 'Confirmed'),
+('43545251529510384053495324', 'Confirmed'),
+('4354532300745392049645795', 'Confirmed'),
+('435453256551355374042454694', 'Confirmed'),
+('43545395382795361007386792', 'Confirmed'),
+('4354545519477403007015524', 'Confirmed'),
+('435454854512565920087565193', 'Confirmed'),
+('435455665353555553551087295867', 'Initialized'),
+('435455620545535698023369188', 'Initialized'),
+('4354565253825654004096661617', 'Initialized'),
+('4355055153856535539065478169', 'Confirmed'),
+('43550851351535658036786676', 'Confirmed'),
+('435510452639397084035780', 'Confirmed'),
+('43551752543656368085636696', 'Confirmed'),
+('4355182353522562003074911', 'Confirmed'),
+('4355153054415352528087602700', 'Confirmed'),
+('435515480545692510078025345', 'Confirmed'),
+('43552652545151654523012857858', 'Confirmed'),
+('435529546536537552081177781', 'Initialized'),
+('4355295447356543031944361', 'Confirmed'),
+('435547253559545136074926321', 'Confirmed'),
+('4355465517651551061313653', 'Confirmed'),
+('4355451846515654519041112430', 'Confirmed'),
+('4355451530456545550046426132', 'Initialized'),
+('4355451513522516530097346667', 'Initialized'),
+('43554516650535546067883280', 'Confirmed'),
+('4355453548151564511029754545', 'Confirmed'),
+('43554555387352486063606077', 'Confirmed'),
+('43555140555176527014985053', 'Confirmed'),
+('4355543653194567053099836', 'Confirmed'),
+('43555418515355140064792007', 'Initialized'),
+('43555988545353563015065620', 'Confirmed'),
+('43555548527854473051856258', 'Confirmed'),
+('435565462541515519007636711', 'Confirmed'),
+('435576932555655516096701164', 'Confirmed'),
+('4355904536928560050035842', 'Confirmed'),
+('43559242756564556021993118', 'Initialized'),
+('4355951703445615021849737', 'Confirmed'),
+('43555131513565545018012333', 'Confirmed'),
+('43555305256342548087083608', 'Confirmed'),
+('43555351530953054526058840212', 'Initialized'),
+('4355545152051842540012001674', 'Confirmed'),
+('43555625645588048053475095', 'Initialized'),
+('435556856528339536041495185', 'Initialized'),
+('435601654521656550034846944', 'Confirmed'),
+('4356051754128289035525676', 'Initialized'),
+('435611949551955027414143', 'Confirmed'),
+('435618676995621083597066', 'Confirmed'),
+('4356153465495569081845068', 'Initialized'),
+('4356154555471543523036553032', 'Confirmed'),
+('43562095665178043884377', 'Initialized'),
+('435634156069478084072584', 'Initialized'),
+('435630495413057059215949', 'Confirmed'),
+('435635455156088565041078123', 'Initialized'),
+('43563555688453525062773033', 'Confirmed'),
+('435644415559090027650777', 'Confirmed'),
+('435645873153569091832778', 'Confirmed'),
+('435635317525315356034205946', 'Initialized'),
+('4356452278755209097229570', 'Confirmed'),
+('43565529525511016034712999', 'Confirmed'),
+('435655565401565572086241281', 'Initialized'),
+('4356615553515353524034122735', 'Confirmed'),
+('4356670527951375099823815', 'Confirmed'),
+('4356751542535517523018846197', 'Confirmed'),
+('435675551255567567010591570', 'Initialized'),
+('43567555556515565433079133319', 'Confirmed'),
+('4356834253655188039258440', 'Initialized'),
+('43568751532654935027615982', 'Confirmed'),
+('43568545475554551543060733082', 'Confirmed'),
+('4356943555425351028278672', 'Initialized'),
+('435696755651690050739687', 'Confirmed'),
+('435651253053321536020149625', 'Confirmed'),
+('4356546529765162039981819', 'Confirmed'),
+('435656715583155567013498017', 'Initialized'),
+('4357022274154553069887423', 'Confirmed'),
+('435656565305437865089473960', 'Confirmed'),
+('43572371555123561003410873', 'Confirmed'),
+('435745591568119084635785', 'Initialized'),
+('43575653051310548074702382', 'Initialized'),
+('435755165715545081961792', 'Initialized'),
+('435755353786251565000764646', 'Confirmed'),
+('435769613495411035325800', 'Initialized'),
+('43577535556561545402083153209', 'Confirmed'),
+('4357945122554037042433297', 'Confirmed'),
+('4357944973557537003993601', 'Confirmed'),
+('435795426915542013140631', 'Confirmed'),
+('4357977262551540085266737', 'Confirmed'),
+('435799565551551583079631492', 'Initialized'),
+('435795335663661095486983', 'Confirmed'),
+('4357512052515154197028747167', 'Confirmed'),
+('435751924210318060469107', 'Initialized'),
+('435751956865153664054075714', 'Confirmed'),
+('43575261195515416003104737', 'Confirmed'),
+('43575288052880532012142334', 'Confirmed'),
+('435753594345455551008394334', 'Confirmed'),
+('43575418421251517002358035', 'Initialized'),
+('4357542669566399071241706', 'Confirmed'),
+('435754582652510539066097655', 'Initialized'),
+('43575354524605653538030439587', 'Confirmed'),
+('4357551865351054523098619148', 'Memo'),
+('435755452520184545031341690', 'Initialized'),
+('4357562515153565607016617238', 'Initialized'),
+('43575654254139026053237383', 'Initialized'),
+('43580935335352078007163119', 'Confirmed'),
+('435809546595552515003784895', 'Confirmed'),
+('4358145432055961049174030', 'Confirmed'),
+('4358395250654160031942680', 'Confirmed'),
+('43583517557697545036379838', 'Confirmed'),
+('4358353555178527524047188707', 'Initialized'),
+('4358656518536515123049841262', 'Initialized'),
+('4358851565135555030080564057', 'Confirmed'),
+('435885659445652535081674709', 'Confirmed'),
+('43589153545120247000370084', 'Confirmed'),
+('43589355531511186050935778', 'Initialized'),
+('43585153151973385076226733', 'Confirmed'),
+('4358525115365569533055291703', 'Confirmed'),
+('4358557749685658090707746', 'Initialized'),
+('4358559569555515661031509972', 'Confirmed'),
+('4358561811952148023459945', 'Confirmed'),
+('4358562451537545342010705724', 'Initialized'),
+('435905355452953655033352184', 'Confirmed'),
+('435905393053529536048244131', 'Initialized'),
+('43590555252285722096710414', 'Initialized'),
+('43590555518545238030746949', 'Initialized'),
+('4359056525152156410094586570', 'Initialized'),
+('435916857620545014965876', 'Initialized'),
+('435935518540553549027268422', 'Initialized'),
+('435937521515351477035070560', 'Confirmed'),
+('4359352808615235033071171', 'Confirmed'),
+('43593555575325815039856569', 'Confirmed'),
+('43594053523456245042570486', 'Initialized'),
+('4359405554055449070916864', 'Memo'),
+('43594155954265652096474792', 'Confirmed'),
+('4359516908555195088232102', 'Initialized'),
+('43595519525151553535070229791', 'Initialized'),
+('43596353544998528047780700', 'Initialized'),
+('435964075620174030609068', 'Confirmed'),
+('4359745694954655015423809', 'Confirmed'),
+('435975154304896051673258', 'Initialized'),
+('4359953295285525025260963', 'Confirmed'),
+('43595135252855652538078070523', 'Confirmed'),
+('43595155356529454560004203133', 'Confirmed'),
+('4359522051534351514011020875', 'Initialized'),
+('4359559252756554530019523356', 'Initialized'),
+('435956640575653540093985755', 'Confirmed'),
+('43551151165456528547055235343', 'Initialized'),
+('435511515539505558039855407', 'Initialized'),
+('435513740591082063305981', 'Confirmed'),
+('4355135456525156617092403523', 'Initialized'),
+('4355141954656511517068107338', 'Initialized'),
+('43551445255453051536016473721', 'Confirmed'),
+('43551456066525353522059181238', 'Confirmed'),
+('435515231517553519070013188', 'Confirmed'),
+('4355165083852638010622907', 'Initialized'),
+('435515527051511081067587759', 'Initialized'),
+('43551656545263515590084748734', 'Confirmed'),
+('43551845209531513010926287', 'Initialized'),
+('4355195685152173544020697600', 'Confirmed'),
+('4355151261538555301098869708', 'Confirmed'),
+('43551525345185295312050721474', 'Confirmed'),
+('4355154534015554309000431369', 'Initialized'),
+('4355155652525454705076995125', 'Confirmed'),
+('435525515655154901086434818', 'Confirmed'),
+('435527133885351516083015435', 'Confirmed'),
+('4355289665453552547056480343', 'Initialized'),
+('43552852555395525218041108373', 'Initialized'),
+('43552955515251453479040131920', 'Initialized'),
+('43552511534555155517018977840', 'Confirmed'),
+('435525176566556316083985702', 'Initialized'),
+('4355255524219522528081611290', 'Confirmed'),
+('43552555255541566976090615426', 'Confirmed'),
+('43552565654554565135037266533', 'Confirmed'),
+('435532654131854542098689708', 'Confirmed'),
+('43553489541237547053013772', 'Confirmed'),
+('4355377061185539081286898', 'Confirmed'),
+('4355382555551153405038778896', 'Confirmed'),
+('4355398569545677546078736415', 'Confirmed'),
+('4355351705435436515095157512', 'Confirmed'),
+('435535285355555335285063474293', 'Confirmed'),
+('43553526254425152510012475390', 'Confirmed'),
+('43553515565435256623080851260', 'Confirmed'),
+('43553535438154538557069596780', 'Confirmed'),
+('4355355852667853553059872658', 'Confirmed'),
+('43553563040569198097661473', 'Confirmed'),
+('43554152516051527568070315001', 'Confirmed'),
+('435541555222495248063028975', 'Confirmed'),
+('43554205512567866061267501', 'Confirmed'),
+('4355435265753557524046955897', 'Confirmed'),
+('4355451643520964004400622', 'Confirmed'),
+('435546552345554404066423355', 'Confirmed'),
+('4355465355534952553018928131', 'Confirmed'),
+('4355495054543546563004328744', 'Confirmed'),
+('4355494564555270549024376672', 'Confirmed'),
+('43554969585382526029203849', 'Confirmed'),
+('4355454662766812028314560', 'Confirmed'),
+('435545452535122555540049473710', 'Confirmed'),
+('4355455918593583030930979', 'Confirmed'),
+('435545596805108538009522516', 'Confirmed'),
+('43554552676565254558060394357', 'Confirmed'),
+('435552384858183024600553', 'Confirmed'),
+('43555288264565531046959879', 'Confirmed'),
+('4355525156565170287016248927', 'Confirmed'),
+('4355531469427534086142163', 'Confirmed'),
+('4355531555616559526060042928', 'Confirmed'),
+('43555360856852539076664787', 'Confirmed'),
+('43555365449547313013223283', 'Confirmed'),
+('43555407995515680079795889', 'Confirmed'),
+('43555535552533566086598566', 'Confirmed'),
+('435556177854752569031558905', 'Confirmed'),
+('435556254545982556062738533', 'Confirmed'),
+('43555649335351823054782782', 'Confirmed'),
+('435557152825355353041493302', 'Confirmed'),
+('4355575253542533533013971727', 'Confirmed'),
+('4355575651539239556061584719', 'Confirmed'),
+('43555815451254568530014955150', 'Memo'),
+('435559540537753377048455961', 'Confirmed'),
+('43555515554054975461079189699', 'Confirmed'),
+('4355552985276555602041463872', 'Confirmed'),
+('435555451519541555252071771865', 'Confirmed'),
+('43645388515253698013162324', 'Confirmed'),
+('436454854105259543060538425', 'Confirmed'),
+('437515655519541751564090846291', 'Memo'),
+('437515656525155543867098474601', 'Memo'),
+('437520541535256510555086614548', 'Confirmed'),
+('43752432552854519083769371', 'URL Attack'),
+('4375265653554161516073783834', 'Confirmed'),
+('437548593532515695051332858', 'Confirmed'),
+('43754530452515254400023395214', 'Confirmed'),
+('437545456513515668098262470', 'Confirmed'),
+('43754553651515454970080565855', 'Confirmed'),
+('437545560568511155072166209', 'Confirmed'),
+('4375455519582152533011434853', 'Confirmed'),
+('43754555241784174085263678', 'Confirmed'),
+('4375502020998518002516569', 'Confirmed'),
+('43819856537255241015351442', 'Memo'),
+('438195125249516562027442327', 'Memo');
+
+explain extended SELECT DISTINCT b FROM t1 WHERE
+ b != 'Confirmed' AND
+ b != 'Initialized' AND
+ b != 'Shipped' AND
+ b != 'Contacted'
+ORDER BY b ASC;
+
+SELECT DISTINCT b FROM t1 WHERE
+ b != 'Confirmed' AND
+ b != 'Initialized' AND
+ b != 'Shipped' AND
+ b != 'Contacted'
+ORDER BY b ASC;
+
+DROP TABLE t1;
| Thread |
|---|
| • bk commit into 5.0 tree (gkodinov:1.2095) BUG#15188 | kgeorge | 27 Mar |
