korlov42 commented on code in PR #7249:
URL: https://github.com/apache/ignite-3/pull/7249#discussion_r2631201392
##########
modules/sql-engine/src/test/resources/tpcds/plan/q8.plan:
##########
@@ -67,16 +67,16 @@ Limit
est: (rows=832)
TableScan
table: PUBLIC.CUSTOMER_ADDRESS
- predicate: OR(=(SUBSTR(CA_ZIP, 1, 5), _UTF-8'47602'),
=(SUBSTR(CA_ZIP, 1, 5), _UTF-8'16704'), =(SUBSTR(CA_ZIP, 1, 5), _UTF-8'35863'),
=(SUBSTR(CA_ZIP, 1, 5), _UTF-8'28577'), =(SUBSTR(CA_ZIP, 1, 5), _UTF-8'83910'),
=(SUBSTR(CA_ZIP, 1, 5), _UTF-8'36201'), =(SUBSTR(CA_ZIP, 1, 5), _UTF-8'58412'),
=(SUBSTR(CA_ZIP, 1, 5), _UTF-8'48162'), =(SUBSTR(CA_ZIP, 1, 5), _UTF-8'28055'),
=(SUBSTR(CA_ZIP, 1, 5), _UTF-8'41419'), =(SUBSTR(CA_ZIP, 1, 5), _UTF-8'80332'),
=(SUBSTR(CA_ZIP, 1, 5), _UTF-8'38607'), =(SUBSTR(CA_ZIP, 1, 5), _UTF-8'77817'),
=(SUBSTR(CA_ZIP, 1, 5), _UTF-8'24891'), =(SUBSTR(CA_ZIP, 1, 5), _UTF-8'16226'),
=(SUBSTR(CA_ZIP, 1, 5), _UTF-8'18410'), =(SUBSTR(CA_ZIP, 1, 5), _UTF-8'21231'),
=(SUBSTR(CA_ZIP, 1, 5), _UTF-8'59345'), =(SUBSTR(CA_ZIP, 1, 5), _UTF-8'13918'),
=(SUBSTR(CA_ZIP, 1, 5), _UTF-8'51089'), =(SUBSTR(CA_ZIP, 1, 5), _UTF-8'20317'),
=(SUBSTR(CA_ZIP, 1, 5), _UTF-8'17167'), =(SUBSTR(CA_ZIP, 1, 5), _UTF-8'54585'),
=(SUBSTR(CA_ZIP, 1, 5), _UTF-8'67881'), =(S
UBSTR(CA_ZIP, 1, 5), _UTF-8'78366'), =(SUBSTR(CA_ZIP, 1, 5), _UTF-8'47770'),
=(SUBSTR(CA_ZIP, 1, 5), _UTF-8'18360'), =(SUBSTR(CA_ZIP, 1, 5), _UTF-8'51717'),
=(SUBSTR(CA_ZIP, 1, 5), _UTF-8'73108'), =(SUBSTR(CA_ZIP, 1, 5), _UTF-8'14440'),
=(SUBSTR(CA_ZIP, 1, 5), _UTF-8'21800'), =(SUBSTR(CA_ZIP, 1, 5), _UTF-8'89338'),
=(SUBSTR(CA_ZIP, 1, 5), _UTF-8'45859'), =(SUBSTR(CA_ZIP, 1, 5), _UTF-8'65501'),
=(SUBSTR(CA_ZIP, 1, 5), _UTF-8'34948'), =(SUBSTR(CA_ZIP, 1, 5), _UTF-8'25973'),
=(SUBSTR(CA_ZIP, 1, 5), _UTF-8'73219'), =(SUBSTR(CA_ZIP, 1, 5), _UTF-8'25333'),
=(SUBSTR(CA_ZIP, 1, 5), _UTF-8'17291'), =(SUBSTR(CA_ZIP, 1, 5), _UTF-8'10374'),
=(SUBSTR(CA_ZIP, 1, 5), _UTF-8'18829'), =(SUBSTR(CA_ZIP, 1, 5), _UTF-8'60736'),
=(SUBSTR(CA_ZIP, 1, 5), _UTF-8'82620'), =(SUBSTR(CA_ZIP, 1, 5), _UTF-8'41351'),
=(SUBSTR(CA_ZIP, 1, 5), _UTF-8'52094'), =(SUBSTR(CA_ZIP, 1, 5), _UTF-8'19326'),
=(SUBSTR(CA_ZIP, 1, 5), _UTF-8'25214'), =(SUBSTR(CA_ZIP, 1, 5), _UTF-8'54207'),
=(SUBSTR(CA_ZIP, 1, 5), _UTF-8'40936'),
=(SUBSTR(CA_ZIP, 1, 5), _UTF-8'21814'), =(SUBSTR(CA_ZIP, 1, 5),
_UTF-8'79077'), =(SUBSTR(CA_ZIP, 1, 5), _UTF-8'25178'), =(SUBSTR(CA_ZIP, 1, 5),
_UTF-8'75742'), =(SUBSTR(CA_ZIP, 1, 5), _UTF-8'77454'), =(SUBSTR(CA_ZIP, 1, 5),
_UTF-8'30621'), =(SUBSTR(CA_ZIP, 1, 5), _UTF-8'89193'), =(SUBSTR(CA_ZIP, 1, 5),
_UTF-8'27369'), =(SUBSTR(CA_ZIP, 1, 5), _UTF-8'41232'), =(SUBSTR(CA_ZIP, 1, 5),
_UTF-8'48567'), =(SUBSTR(CA_ZIP, 1, 5), _UTF-8'83041'), =(SUBSTR(CA_ZIP, 1, 5),
_UTF-8'71948'), =(SUBSTR(CA_ZIP, 1, 5), _UTF-8'37119'), =(SUBSTR(CA_ZIP, 1, 5),
_UTF-8'68341'), =(SUBSTR(CA_ZIP, 1, 5), _UTF-8'14073'), =(SUBSTR(CA_ZIP, 1, 5),
_UTF-8'16891'), =(SUBSTR(CA_ZIP, 1, 5), _UTF-8'62878'), =(SUBSTR(CA_ZIP, 1, 5),
_UTF-8'49130'), =(SUBSTR(CA_ZIP, 1, 5), _UTF-8'19833'), =(SUBSTR(CA_ZIP, 1, 5),
_UTF-8'24286'), =(SUBSTR(CA_ZIP, 1, 5), _UTF-8'27700'), =(SUBSTR(CA_ZIP, 1, 5),
_UTF-8'40979'), =(SUBSTR(CA_ZIP, 1, 5), _UTF-8'50412'), =(SUBSTR(CA_ZIP, 1, 5),
_UTF-8'81504'), =(SUBSTR(CA_ZIP, 1, 5), _UTF-8'94835'
), =(SUBSTR(CA_ZIP, 1, 5), _UTF-8'84844'), =(SUBSTR(CA_ZIP, 1, 5),
_UTF-8'71954'), =(SUBSTR(CA_ZIP, 1, 5), _UTF-8'39503'), =(SUBSTR(CA_ZIP, 1, 5),
_UTF-8'57649'), =(SUBSTR(CA_ZIP, 1, 5), _UTF-8'18434'), =(SUBSTR(CA_ZIP, 1, 5),
_UTF-8'24987'), =(SUBSTR(CA_ZIP, 1, 5), _UTF-8'12350'), =(SUBSTR(CA_ZIP, 1, 5),
_UTF-8'86379'), =(SUBSTR(CA_ZIP, 1, 5), _UTF-8'27413'), =(SUBSTR(CA_ZIP, 1, 5),
_UTF-8'44529'), =(SUBSTR(CA_ZIP, 1, 5), _UTF-8'98569'), =(SUBSTR(CA_ZIP, 1, 5),
_UTF-8'16515'), =(SUBSTR(CA_ZIP, 1, 5), _UTF-8'27287'), =(SUBSTR(CA_ZIP, 1, 5),
_UTF-8'24255'), =(SUBSTR(CA_ZIP, 1, 5), _UTF-8'21094'), =(SUBSTR(CA_ZIP, 1, 5),
_UTF-8'16005'), =(SUBSTR(CA_ZIP, 1, 5), _UTF-8'56436'), =(SUBSTR(CA_ZIP, 1, 5),
_UTF-8'91110'), =(SUBSTR(CA_ZIP, 1, 5), _UTF-8'68293'), =(SUBSTR(CA_ZIP, 1, 5),
_UTF-8'56455'), =(SUBSTR(CA_ZIP, 1, 5), _UTF-8'54558'), =(SUBSTR(CA_ZIP, 1, 5),
_UTF-8'10298'), =(SUBSTR(CA_ZIP, 1, 5), _UTF-8'83647'), =(SUBSTR(CA_ZIP, 1, 5),
_UTF-8'32754'), =(SUBSTR(CA_ZIP, 1, 5), _UTF-8'270
52'), =(SUBSTR(CA_ZIP, 1, 5), _UTF-8'51766'), =(SUBSTR(CA_ZIP, 1, 5),
_UTF-8'19444'), =(SUBSTR(CA_ZIP, 1, 5), _UTF-8'13869'), =(SUBSTR(CA_ZIP, 1, 5),
_UTF-8'45645'), =(SUBSTR(CA_ZIP, 1, 5), _UTF-8'94791'), =(SUBSTR(CA_ZIP, 1, 5),
_UTF-8'57631'), =(SUBSTR(CA_ZIP, 1, 5), _UTF-8'20712'), =(SUBSTR(CA_ZIP, 1, 5),
_UTF-8'37788'), =(SUBSTR(CA_ZIP, 1, 5), _UTF-8'41807'), =(SUBSTR(CA_ZIP, 1, 5),
_UTF-8'46507'), =(SUBSTR(CA_ZIP, 1, 5), _UTF-8'21727'), =(SUBSTR(CA_ZIP, 1, 5),
_UTF-8'71836'), =(SUBSTR(CA_ZIP, 1, 5), _UTF-8'81070'), =(SUBSTR(CA_ZIP, 1, 5),
_UTF-8'50632'), =(SUBSTR(CA_ZIP, 1, 5), _UTF-8'88086'), =(SUBSTR(CA_ZIP, 1, 5),
_UTF-8'63991'), =(SUBSTR(CA_ZIP, 1, 5), _UTF-8'20244'), =(SUBSTR(CA_ZIP, 1, 5),
_UTF-8'31655'), =(SUBSTR(CA_ZIP, 1, 5), _UTF-8'51782'), =(SUBSTR(CA_ZIP, 1, 5),
_UTF-8'29818'), =(SUBSTR(CA_ZIP, 1, 5), _UTF-8'63792'), =(SUBSTR(CA_ZIP, 1, 5),
_UTF-8'68605'), =(SUBSTR(CA_ZIP, 1, 5), _UTF-8'94898'), =(SUBSTR(CA_ZIP, 1, 5),
_UTF-8'36430'), =(SUBSTR(CA_ZIP, 1, 5), _UTF-8'
57025'), =(SUBSTR(CA_ZIP, 1, 5), _UTF-8'20601'), =(SUBSTR(CA_ZIP, 1, 5),
_UTF-8'82080'), =(SUBSTR(CA_ZIP, 1, 5), _UTF-8'33869'), =(SUBSTR(CA_ZIP, 1, 5),
_UTF-8'22728'), =(SUBSTR(CA_ZIP, 1, 5), _UTF-8'35834'), =(SUBSTR(CA_ZIP, 1, 5),
_UTF-8'29086'), =(SUBSTR(CA_ZIP, 1, 5), _UTF-8'92645'), =(SUBSTR(CA_ZIP, 1, 5),
_UTF-8'98584'), =(SUBSTR(CA_ZIP, 1, 5), _UTF-8'98072'), =(SUBSTR(CA_ZIP, 1, 5),
_UTF-8'11652'), =(SUBSTR(CA_ZIP, 1, 5), _UTF-8'78093'), =(SUBSTR(CA_ZIP, 1, 5),
_UTF-8'57553'), =(SUBSTR(CA_ZIP, 1, 5), _UTF-8'43830'), =(SUBSTR(CA_ZIP, 1, 5),
_UTF-8'71144'), =(SUBSTR(CA_ZIP, 1, 5), _UTF-8'53565'), =(SUBSTR(CA_ZIP, 1, 5),
_UTF-8'18700'), =(SUBSTR(CA_ZIP, 1, 5), _UTF-8'90209'), =(SUBSTR(CA_ZIP, 1, 5),
_UTF-8'71256'), =(SUBSTR(CA_ZIP, 1, 5), _UTF-8'38353'), =(SUBSTR(CA_ZIP, 1, 5),
_UTF-8'54364'), =(SUBSTR(CA_ZIP, 1, 5), _UTF-8'28571'), =(SUBSTR(CA_ZIP, 1, 5),
_UTF-8'96560'), =(SUBSTR(CA_ZIP, 1, 5), _UTF-8'57839'), =(SUBSTR(CA_ZIP, 1, 5),
_UTF-8'56355'), =(SUBSTR(CA_ZIP, 1, 5), _UTF
-8'50679'), =(SUBSTR(CA_ZIP, 1, 5), _UTF-8'45266'), =(SUBSTR(CA_ZIP, 1, 5),
_UTF-8'84680'), =(SUBSTR(CA_ZIP, 1, 5), _UTF-8'34306'), =(SUBSTR(CA_ZIP, 1, 5),
_UTF-8'34972'), =(SUBSTR(CA_ZIP, 1, 5), _UTF-8'48530'), =(SUBSTR(CA_ZIP, 1, 5),
_UTF-8'30106'), =(SUBSTR(CA_ZIP, 1, 5), _UTF-8'15371'), =(SUBSTR(CA_ZIP, 1, 5),
_UTF-8'92380'), =(SUBSTR(CA_ZIP, 1, 5), _UTF-8'84247'), =(SUBSTR(CA_ZIP, 1, 5),
_UTF-8'92292'), =(SUBSTR(CA_ZIP, 1, 5), _UTF-8'68852'), =(SUBSTR(CA_ZIP, 1, 5),
_UTF-8'13338'), =(SUBSTR(CA_ZIP, 1, 5), _UTF-8'34594'), =(SUBSTR(CA_ZIP, 1, 5),
_UTF-8'82602'), =(SUBSTR(CA_ZIP, 1, 5), _UTF-8'70073'), =(SUBSTR(CA_ZIP, 1, 5),
_UTF-8'98069'), =(SUBSTR(CA_ZIP, 1, 5), _UTF-8'85066'), =(SUBSTR(CA_ZIP, 1, 5),
_UTF-8'47289'), =(SUBSTR(CA_ZIP, 1, 5), _UTF-8'11686'), =(SUBSTR(CA_ZIP, 1, 5),
_UTF-8'98862'), =(SUBSTR(CA_ZIP, 1, 5), _UTF-8'26217'), =(SUBSTR(CA_ZIP, 1, 5),
_UTF-8'47529'), =(SUBSTR(CA_ZIP, 1, 5), _UTF-8'63294'), =(SUBSTR(CA_ZIP, 1, 5),
_UTF-8'51793'), =(SUBSTR(CA_ZIP, 1, 5), _
UTF-8'35926'), =(SUBSTR(CA_ZIP, 1, 5), _UTF-8'24227'), =(SUBSTR(CA_ZIP, 1, 5),
_UTF-8'14196'), =(SUBSTR(CA_ZIP, 1, 5), _UTF-8'24594'), =(SUBSTR(CA_ZIP, 1, 5),
_UTF-8'32489'), =(SUBSTR(CA_ZIP, 1, 5), _UTF-8'99060'), =(SUBSTR(CA_ZIP, 1, 5),
_UTF-8'49472'), =(SUBSTR(CA_ZIP, 1, 5), _UTF-8'43432'), =(SUBSTR(CA_ZIP, 1, 5),
_UTF-8'49211'), =(SUBSTR(CA_ZIP, 1, 5), _UTF-8'14312'), =(SUBSTR(CA_ZIP, 1, 5),
_UTF-8'88137'), =(SUBSTR(CA_ZIP, 1, 5), _UTF-8'47369'), =(SUBSTR(CA_ZIP, 1, 5),
_UTF-8'56877'), =(SUBSTR(CA_ZIP, 1, 5), _UTF-8'20534'), =(SUBSTR(CA_ZIP, 1, 5),
_UTF-8'81755'), =(SUBSTR(CA_ZIP, 1, 5), _UTF-8'15794'), =(SUBSTR(CA_ZIP, 1, 5),
_UTF-8'12318'), =(SUBSTR(CA_ZIP, 1, 5), _UTF-8'21060'), =(SUBSTR(CA_ZIP, 1, 5),
_UTF-8'73134'), =(SUBSTR(CA_ZIP, 1, 5), _UTF-8'41255'), =(SUBSTR(CA_ZIP, 1, 5),
_UTF-8'63073'), =(SUBSTR(CA_ZIP, 1, 5), _UTF-8'81003'), =(SUBSTR(CA_ZIP, 1, 5),
_UTF-8'73873'), =(SUBSTR(CA_ZIP, 1, 5), _UTF-8'66057'), =(SUBSTR(CA_ZIP, 1, 5),
_UTF-8'51184'), =(SUBSTR(CA_ZIP, 1, 5)
, _UTF-8'51195'), =(SUBSTR(CA_ZIP, 1, 5), _UTF-8'45676'), =(SUBSTR(CA_ZIP, 1,
5), _UTF-8'92696'), =(SUBSTR(CA_ZIP, 1, 5), _UTF-8'70450'), =(SUBSTR(CA_ZIP, 1,
5), _UTF-8'90669'), =(SUBSTR(CA_ZIP, 1, 5), _UTF-8'98338'), =(SUBSTR(CA_ZIP, 1,
5), _UTF-8'25264'), =(SUBSTR(CA_ZIP, 1, 5), _UTF-8'38919'), =(SUBSTR(CA_ZIP, 1,
5), _UTF-8'59226'), =(SUBSTR(CA_ZIP, 1, 5), _UTF-8'58581'), =(SUBSTR(CA_ZIP, 1,
5), _UTF-8'60298'), =(SUBSTR(CA_ZIP, 1, 5), _UTF-8'17895'), =(SUBSTR(CA_ZIP, 1,
5), _UTF-8'19489'), =(SUBSTR(CA_ZIP, 1, 5), _UTF-8'52301'), =(SUBSTR(CA_ZIP, 1,
5), _UTF-8'80846'), =(SUBSTR(CA_ZIP, 1, 5), _UTF-8'95464'), =(SUBSTR(CA_ZIP, 1,
5), _UTF-8'68770'), =(SUBSTR(CA_ZIP, 1, 5), _UTF-8'51634'), =(SUBSTR(CA_ZIP, 1,
5), _UTF-8'19988'), =(SUBSTR(CA_ZIP, 1, 5), _UTF-8'18367'), =(SUBSTR(CA_ZIP, 1,
5), _UTF-8'18421'), =(SUBSTR(CA_ZIP, 1, 5), _UTF-8'11618'), =(SUBSTR(CA_ZIP, 1,
5), _UTF-8'67975'), =(SUBSTR(CA_ZIP, 1, 5), _UTF-8'25494'), =(SUBSTR(CA_ZIP, 1,
5), _UTF-8'41352'), =(SUBSTR(CA_ZIP, 1,
5), _UTF-8'95430'), =(SUBSTR(CA_ZIP, 1, 5), _UTF-8'15734'), =(SUBSTR(CA_ZIP,
1, 5), _UTF-8'62585'), =(SUBSTR(CA_ZIP, 1, 5), _UTF-8'97173'), =(SUBSTR(CA_ZIP,
1, 5), _UTF-8'33773'), =(SUBSTR(CA_ZIP, 1, 5), _UTF-8'10425'), =(SUBSTR(CA_ZIP,
1, 5), _UTF-8'75675'), =(SUBSTR(CA_ZIP, 1, 5), _UTF-8'53535'), =(SUBSTR(CA_ZIP,
1, 5), _UTF-8'17879'), =(SUBSTR(CA_ZIP, 1, 5), _UTF-8'41967'), =(SUBSTR(CA_ZIP,
1, 5), _UTF-8'12197'), =(SUBSTR(CA_ZIP, 1, 5), _UTF-8'67998'), =(SUBSTR(CA_ZIP,
1, 5), _UTF-8'79658'), =(SUBSTR(CA_ZIP, 1, 5), _UTF-8'59130'), =(SUBSTR(CA_ZIP,
1, 5), _UTF-8'72592'), =(SUBSTR(CA_ZIP, 1, 5), _UTF-8'14851'), =(SUBSTR(CA_ZIP,
1, 5), _UTF-8'43933'), =(SUBSTR(CA_ZIP, 1, 5), _UTF-8'68101'), =(SUBSTR(CA_ZIP,
1, 5), _UTF-8'50636'), =(SUBSTR(CA_ZIP, 1, 5), _UTF-8'25717'), =(SUBSTR(CA_ZIP,
1, 5), _UTF-8'71286'), =(SUBSTR(CA_ZIP, 1, 5), _UTF-8'24660'), =(SUBSTR(CA_ZIP,
1, 5), _UTF-8'58058'), =(SUBSTR(CA_ZIP, 1, 5), _UTF-8'72991'), =(SUBSTR(CA_ZIP,
1, 5), _UTF-8'95042'), =(SUBSTR(CA_ZIP,
1, 5), _UTF-8'15543'), =(SUBSTR(CA_ZIP, 1, 5), _UTF-8'33122'),
=(SUBSTR(CA_ZIP, 1, 5), _UTF-8'69280'), =(SUBSTR(CA_ZIP, 1, 5), _UTF-8'11912'),
=(SUBSTR(CA_ZIP, 1, 5), _UTF-8'59386'), =(SUBSTR(CA_ZIP, 1, 5), _UTF-8'27642'),
=(SUBSTR(CA_ZIP, 1, 5), _UTF-8'65177'), =(SUBSTR(CA_ZIP, 1, 5), _UTF-8'17672'),
=(SUBSTR(CA_ZIP, 1, 5), _UTF-8'33467'), =(SUBSTR(CA_ZIP, 1, 5), _UTF-8'64592'),
=(SUBSTR(CA_ZIP, 1, 5), _UTF-8'36335'), =(SUBSTR(CA_ZIP, 1, 5), _UTF-8'54010'),
=(SUBSTR(CA_ZIP, 1, 5), _UTF-8'18767'), =(SUBSTR(CA_ZIP, 1, 5), _UTF-8'63193'),
=(SUBSTR(CA_ZIP, 1, 5), _UTF-8'42361'), =(SUBSTR(CA_ZIP, 1, 5), _UTF-8'49254'),
=(SUBSTR(CA_ZIP, 1, 5), _UTF-8'33113'), =(SUBSTR(CA_ZIP, 1, 5), _UTF-8'33159'),
=(SUBSTR(CA_ZIP, 1, 5), _UTF-8'36479'), =(SUBSTR(CA_ZIP, 1, 5), _UTF-8'59080'),
=(SUBSTR(CA_ZIP, 1, 5), _UTF-8'11855'), =(SUBSTR(CA_ZIP, 1, 5), _UTF-8'81963'),
=(SUBSTR(CA_ZIP, 1, 5), _UTF-8'31016'), =(SUBSTR(CA_ZIP, 1, 5), _UTF-8'49140'),
=(SUBSTR(CA_ZIP, 1, 5), _UTF-8'29392'), =(SUBSTR(CA_Z
IP, 1, 5), _UTF-8'41836'), =(SUBSTR(CA_ZIP, 1, 5), _UTF-8'32958'),
=(SUBSTR(CA_ZIP, 1, 5), _UTF-8'53163'), =(SUBSTR(CA_ZIP, 1, 5), _UTF-8'13844'),
=(SUBSTR(CA_ZIP, 1, 5), _UTF-8'73146'), =(SUBSTR(CA_ZIP, 1, 5), _UTF-8'23952'),
=(SUBSTR(CA_ZIP, 1, 5), _UTF-8'65148'), =(SUBSTR(CA_ZIP, 1, 5), _UTF-8'93498'),
=(SUBSTR(CA_ZIP, 1, 5), _UTF-8'14530'), =(SUBSTR(CA_ZIP, 1, 5), _UTF-8'46131'),
=(SUBSTR(CA_ZIP, 1, 5), _UTF-8'58454'), =(SUBSTR(CA_ZIP, 1, 5), _UTF-8'13376'),
=(SUBSTR(CA_ZIP, 1, 5), _UTF-8'13378'), =(SUBSTR(CA_ZIP, 1, 5), _UTF-8'83986'),
=(SUBSTR(CA_ZIP, 1, 5), _UTF-8'12320'), =(SUBSTR(CA_ZIP, 1, 5), _UTF-8'17193'),
=(SUBSTR(CA_ZIP, 1, 5), _UTF-8'59852'), =(SUBSTR(CA_ZIP, 1, 5), _UTF-8'46081'),
=(SUBSTR(CA_ZIP, 1, 5), _UTF-8'98533'), =(SUBSTR(CA_ZIP, 1, 5), _UTF-8'52389'),
=(SUBSTR(CA_ZIP, 1, 5), _UTF-8'13086'), =(SUBSTR(CA_ZIP, 1, 5), _UTF-8'68843'),
=(SUBSTR(CA_ZIP, 1, 5), _UTF-8'31013'), =(SUBSTR(CA_ZIP, 1, 5), _UTF-8'13261'),
=(SUBSTR(CA_ZIP, 1, 5), _UTF-8'60560'), =(SUBSTR(C
A_ZIP, 1, 5), _UTF-8'13443'), =(SUBSTR(CA_ZIP, 1, 5), _UTF-8'45533'),
=(SUBSTR(CA_ZIP, 1, 5), _UTF-8'83583'), =(SUBSTR(CA_ZIP, 1, 5), _UTF-8'11489'),
=(SUBSTR(CA_ZIP, 1, 5), _UTF-8'58218'), =(SUBSTR(CA_ZIP, 1, 5), _UTF-8'19753'),
=(SUBSTR(CA_ZIP, 1, 5), _UTF-8'22911'), =(SUBSTR(CA_ZIP, 1, 5), _UTF-8'25115'),
=(SUBSTR(CA_ZIP, 1, 5), _UTF-8'86709'), =(SUBSTR(CA_ZIP, 1, 5), _UTF-8'27156'),
=(SUBSTR(CA_ZIP, 1, 5), _UTF-8'32669'), =(SUBSTR(CA_ZIP, 1, 5), _UTF-8'13123'),
=(SUBSTR(CA_ZIP, 1, 5), _UTF-8'51933'), =(SUBSTR(CA_ZIP, 1, 5), _UTF-8'39214'),
=(SUBSTR(CA_ZIP, 1, 5), _UTF-8'41331'), =(SUBSTR(CA_ZIP, 1, 5), _UTF-8'66943'),
=(SUBSTR(CA_ZIP, 1, 5), _UTF-8'14155'), =(SUBSTR(CA_ZIP, 1, 5), _UTF-8'69998'),
=(SUBSTR(CA_ZIP, 1, 5), _UTF-8'49101'), =(SUBSTR(CA_ZIP, 1, 5), _UTF-8'70070'),
=(SUBSTR(CA_ZIP, 1, 5), _UTF-8'35076'), =(SUBSTR(CA_ZIP, 1, 5), _UTF-8'14242'),
=(SUBSTR(CA_ZIP, 1, 5), _UTF-8'73021'), =(SUBSTR(CA_ZIP, 1, 5), _UTF-8'59494'),
=(SUBSTR(CA_ZIP, 1, 5), _UTF-8'15782'), =(SUBST
R(CA_ZIP, 1, 5), _UTF-8'29752'), =(SUBSTR(CA_ZIP, 1, 5), _UTF-8'37914'),
=(SUBSTR(CA_ZIP, 1, 5), _UTF-8'74686'), =(SUBSTR(CA_ZIP, 1, 5), _UTF-8'83086'),
=(SUBSTR(CA_ZIP, 1, 5), _UTF-8'34473'), =(SUBSTR(CA_ZIP, 1, 5), _UTF-8'15751'),
=(SUBSTR(CA_ZIP, 1, 5), _UTF-8'81084'), =(SUBSTR(CA_ZIP, 1, 5), _UTF-8'49230'),
=(SUBSTR(CA_ZIP, 1, 5), _UTF-8'91894'), =(SUBSTR(CA_ZIP, 1, 5), _UTF-8'60624'),
=(SUBSTR(CA_ZIP, 1, 5), _UTF-8'17819'), =(SUBSTR(CA_ZIP, 1, 5), _UTF-8'28810'),
=(SUBSTR(CA_ZIP, 1, 5), _UTF-8'63180'), =(SUBSTR(CA_ZIP, 1, 5), _UTF-8'56224'),
=(SUBSTR(CA_ZIP, 1, 5), _UTF-8'39459'), =(SUBSTR(CA_ZIP, 1, 5), _UTF-8'55233'),
=(SUBSTR(CA_ZIP, 1, 5), _UTF-8'75752'), =(SUBSTR(CA_ZIP, 1, 5), _UTF-8'43639'),
=(SUBSTR(CA_ZIP, 1, 5), _UTF-8'55349'), =(SUBSTR(CA_ZIP, 1, 5), _UTF-8'86057'),
=(SUBSTR(CA_ZIP, 1, 5), _UTF-8'62361'), =(SUBSTR(CA_ZIP, 1, 5), _UTF-8'50788'),
=(SUBSTR(CA_ZIP, 1, 5), _UTF-8'31830'), =(SUBSTR(CA_ZIP, 1, 5), _UTF-8'58062'),
=(SUBSTR(CA_ZIP, 1, 5), _UTF-8'18218'), =(SU
BSTR(CA_ZIP, 1, 5), _UTF-8'85761'), =(SUBSTR(CA_ZIP, 1, 5), _UTF-8'60083'),
=(SUBSTR(CA_ZIP, 1, 5), _UTF-8'45484'), =(SUBSTR(CA_ZIP, 1, 5), _UTF-8'21204'),
=(SUBSTR(CA_ZIP, 1, 5), _UTF-8'90229'), =(SUBSTR(CA_ZIP, 1, 5), _UTF-8'70041'),
=(SUBSTR(CA_ZIP, 1, 5), _UTF-8'41162'), =(SUBSTR(CA_ZIP, 1, 5), _UTF-8'35390'),
=(SUBSTR(CA_ZIP, 1, 5), _UTF-8'16364'), =(SUBSTR(CA_ZIP, 1, 5), _UTF-8'39500'),
=(SUBSTR(CA_ZIP, 1, 5), _UTF-8'68908'), =(SUBSTR(CA_ZIP, 1, 5), _UTF-8'26689'),
=(SUBSTR(CA_ZIP, 1, 5), _UTF-8'52868'), =(SUBSTR(CA_ZIP, 1, 5), _UTF-8'81335'),
=(SUBSTR(CA_ZIP, 1, 5), _UTF-8'40146'), =(SUBSTR(CA_ZIP, 1, 5), _UTF-8'11340'),
=(SUBSTR(CA_ZIP, 1, 5), _UTF-8'61527'), =(SUBSTR(CA_ZIP, 1, 5), _UTF-8'61794'),
=(SUBSTR(CA_ZIP, 1, 5), _UTF-8'71997'), =(SUBSTR(CA_ZIP, 1, 5), _UTF-8'30415'),
=(SUBSTR(CA_ZIP, 1, 5), _UTF-8'59004'), =(SUBSTR(CA_ZIP, 1, 5), _UTF-8'29450'),
=(SUBSTR(CA_ZIP, 1, 5), _UTF-8'58117'), =(SUBSTR(CA_ZIP, 1, 5), _UTF-8'69952'),
=(SUBSTR(CA_ZIP, 1, 5), _UTF-8'33562'), =
(SUBSTR(CA_ZIP, 1, 5), _UTF-8'83833'), =(SUBSTR(CA_ZIP, 1, 5), _UTF-8'27385'),
=(SUBSTR(CA_ZIP, 1, 5), _UTF-8'61860'), =(SUBSTR(CA_ZIP, 1, 5), _UTF-8'96435'),
=(SUBSTR(CA_ZIP, 1, 5), _UTF-8'48333'), =(SUBSTR(CA_ZIP, 1, 5), _UTF-8'23065'),
=(SUBSTR(CA_ZIP, 1, 5), _UTF-8'32961'), =(SUBSTR(CA_ZIP, 1, 5), _UTF-8'84919'),
=(SUBSTR(CA_ZIP, 1, 5), _UTF-8'61997'), =(SUBSTR(CA_ZIP, 1, 5), _UTF-8'99132'),
=(SUBSTR(CA_ZIP, 1, 5), _UTF-8'22815'), =(SUBSTR(CA_ZIP, 1, 5), _UTF-8'56600'),
=(SUBSTR(CA_ZIP, 1, 5), _UTF-8'68730'), =(SUBSTR(CA_ZIP, 1, 5), _UTF-8'48017'),
=(SUBSTR(CA_ZIP, 1, 5), _UTF-8'95694'), =(SUBSTR(CA_ZIP, 1, 5), _UTF-8'32919'),
=(SUBSTR(CA_ZIP, 1, 5), _UTF-8'88217'), =(SUBSTR(CA_ZIP, 1, 5), _UTF-8'27116'),
=(SUBSTR(CA_ZIP, 1, 5), _UTF-8'28239'), =(SUBSTR(CA_ZIP, 1, 5), _UTF-8'58032'),
=(SUBSTR(CA_ZIP, 1, 5), _UTF-8'18884'), =(SUBSTR(CA_ZIP, 1, 5), _UTF-8'16791'),
=(SUBSTR(CA_ZIP, 1, 5), _UTF-8'21343'), =(SUBSTR(CA_ZIP, 1, 5), _UTF-8'97462'),
=(SUBSTR(CA_ZIP, 1, 5), _UTF-8'18569')
, =(SUBSTR(CA_ZIP, 1, 5), _UTF-8'75660'), =(SUBSTR(CA_ZIP, 1, 5),
_UTF-8'15475'))
+ predicate: SEARCH(SUBSTR(CA_ZIP, 1, 5),
Sarg[_UTF-8'10298':VARCHAR(10) CHARACTER SET "UTF-8", _UTF-8'10374':VARCHAR(10)
CHARACTER SET "UTF-8", _UTF-8'10425':VARCHAR(10) CHARACTER SET "UTF-8",
_UTF-8'11340':VARCHAR(10) CHARACTER SET "UTF-8", _UTF-8'11489':VARCHAR(10)
CHARACTER SET "UTF-8", _UTF-8'11618':VARCHAR(10) CHARACTER SET "UTF-8",
_UTF-8'11652':VARCHAR(10) CHARACTER SET "UTF-8", _UTF-8'11686':VARCHAR(10)
CHARACTER SET "UTF-8", _UTF-8'11855':VARCHAR(10) CHARACTER SET "UTF-8",
_UTF-8'11912':VARCHAR(10) CHARACTER SET "UTF-8", _UTF-8'12197':VARCHAR(10)
CHARACTER SET "UTF-8", _UTF-8'12318':VARCHAR(10) CHARACTER SET "UTF-8",
_UTF-8'12320':VARCHAR(10) CHARACTER SET "UTF-8", _UTF-8'12350':VARCHAR(10)
CHARACTER SET "UTF-8", _UTF-8'13086':VARCHAR(10) CHARACTER SET "UTF-8",
_UTF-8'13123':VARCHAR(10) CHARACTER SET "UTF-8", _UTF-8'13261':VARCHAR(10)
CHARACTER SET "UTF-8", _UTF-8'13338':VARCHAR(10) CHARACTER SET "UTF-8",
_UTF-8'13376':VARCHAR(10) CHARACTER SET "UTF-8", _
UTF-8'13378':VARCHAR(10) CHARACTER SET "UTF-8", _UTF-8'13443':VARCHAR(10)
CHARACTER SET "UTF-8", _UTF-8'13844':VARCHAR(10) CHARACTER SET "UTF-8",
_UTF-8'13869':VARCHAR(10) CHARACTER SET "UTF-8", _UTF-8'13918':VARCHAR(10)
CHARACTER SET "UTF-8", _UTF-8'14073':VARCHAR(10) CHARACTER SET "UTF-8",
_UTF-8'14155':VARCHAR(10) CHARACTER SET "UTF-8", _UTF-8'14196':VARCHAR(10)
CHARACTER SET "UTF-8", _UTF-8'14242':VARCHAR(10) CHARACTER SET "UTF-8",
_UTF-8'14312':VARCHAR(10) CHARACTER SET "UTF-8", _UTF-8'14440':VARCHAR(10)
CHARACTER SET "UTF-8", _UTF-8'14530':VARCHAR(10) CHARACTER SET "UTF-8",
_UTF-8'14851':VARCHAR(10) CHARACTER SET "UTF-8", _UTF-8'15371':VARCHAR(10)
CHARACTER SET "UTF-8", _UTF-8'15475':VARCHAR(10) CHARACTER SET "UTF-8",
_UTF-8'15543':VARCHAR(10) CHARACTER SET "UTF-8", _UTF-8'15734':VARCHAR(10)
CHARACTER SET "UTF-8", _UTF-8'15751':VARCHAR(10) CHARACTER SET "UTF-8",
_UTF-8'15782':VARCHAR(10) CHARACTER SET "UTF-8", _UTF-8'15794':VARCHAR(10)
CHARACTER SET "UTF-8", _UTF-8'16005':VARC
HAR(10) CHARACTER SET "UTF-8", _UTF-8'16226':VARCHAR(10) CHARACTER SET
"UTF-8", _UTF-8'16364':VARCHAR(10) CHARACTER SET "UTF-8",
_UTF-8'16515':VARCHAR(10) CHARACTER SET "UTF-8", _UTF-8'16704':VARCHAR(10)
CHARACTER SET "UTF-8", _UTF-8'16791':VARCHAR(10) CHARACTER SET "UTF-8",
_UTF-8'16891':VARCHAR(10) CHARACTER SET "UTF-8", _UTF-8'17167':VARCHAR(10)
CHARACTER SET "UTF-8", _UTF-8'17193':VARCHAR(10) CHARACTER SET "UTF-8",
_UTF-8'17291':VARCHAR(10) CHARACTER SET "UTF-8", _UTF-8'17672':VARCHAR(10)
CHARACTER SET "UTF-8", _UTF-8'17819':VARCHAR(10) CHARACTER SET "UTF-8",
_UTF-8'17879':VARCHAR(10) CHARACTER SET "UTF-8", _UTF-8'17895':VARCHAR(10)
CHARACTER SET "UTF-8", _UTF-8'18218':VARCHAR(10) CHARACTER SET "UTF-8",
_UTF-8'18360':VARCHAR(10) CHARACTER SET "UTF-8", _UTF-8'18367':VARCHAR(10)
CHARACTER SET "UTF-8", _UTF-8'18410':VARCHAR(10) CHARACTER SET "UTF-8",
_UTF-8'18421':VARCHAR(10) CHARACTER SET "UTF-8", _UTF-8'18434':VARCHAR(10)
CHARACTER SET "UTF-8", _UTF-8'18569':VARCHAR(10) CHARACTER
SET "UTF-8", _UTF-8'18700':VARCHAR(10) CHARACTER SET "UTF-8",
_UTF-8'18767':VARCHAR(10) CHARACTER SET "UTF-8", _UTF-8'18829':VARCHAR(10)
CHARACTER SET "UTF-8", _UTF-8'18884':VARCHAR(10) CHARACTER SET "UTF-8",
_UTF-8'19326':VARCHAR(10) CHARACTER SET "UTF-8", _UTF-8'19444':VARCHAR(10)
CHARACTER SET "UTF-8", _UTF-8'19489':VARCHAR(10) CHARACTER SET "UTF-8",
_UTF-8'19753':VARCHAR(10) CHARACTER SET "UTF-8", _UTF-8'19833':VARCHAR(10)
CHARACTER SET "UTF-8", _UTF-8'19988':VARCHAR(10) CHARACTER SET "UTF-8",
_UTF-8'20244':VARCHAR(10) CHARACTER SET "UTF-8", _UTF-8'20317':VARCHAR(10)
CHARACTER SET "UTF-8", _UTF-8'20534':VARCHAR(10) CHARACTER SET "UTF-8",
_UTF-8'20601':VARCHAR(10) CHARACTER SET "UTF-8", _UTF-8'20712':VARCHAR(10)
CHARACTER SET "UTF-8", _UTF-8'21060':VARCHAR(10) CHARACTER SET "UTF-8",
_UTF-8'21094':VARCHAR(10) CHARACTER SET "UTF-8", _UTF-8'21204':VARCHAR(10)
CHARACTER SET "UTF-8", _UTF-8'21231':VARCHAR(10) CHARACTER SET "UTF-8",
_UTF-8'21343':VARCHAR(10) CHARACTER SET "UTF-8", _UT
F-8'21727':VARCHAR(10) CHARACTER SET "UTF-8", _UTF-8'21800':VARCHAR(10)
CHARACTER SET "UTF-8", _UTF-8'21814':VARCHAR(10) CHARACTER SET "UTF-8",
_UTF-8'22728':VARCHAR(10) CHARACTER SET "UTF-8", _UTF-8'22815':VARCHAR(10)
CHARACTER SET "UTF-8", _UTF-8'22911':VARCHAR(10) CHARACTER SET "UTF-8",
_UTF-8'23065':VARCHAR(10) CHARACTER SET "UTF-8", _UTF-8'23952':VARCHAR(10)
CHARACTER SET "UTF-8", _UTF-8'24227':VARCHAR(10) CHARACTER SET "UTF-8",
_UTF-8'24255':VARCHAR(10) CHARACTER SET "UTF-8", _UTF-8'24286':VARCHAR(10)
CHARACTER SET "UTF-8", _UTF-8'24594':VARCHAR(10) CHARACTER SET "UTF-8",
_UTF-8'24660':VARCHAR(10) CHARACTER SET "UTF-8", _UTF-8'24891':VARCHAR(10)
CHARACTER SET "UTF-8", _UTF-8'24987':VARCHAR(10) CHARACTER SET "UTF-8",
_UTF-8'25115':VARCHAR(10) CHARACTER SET "UTF-8", _UTF-8'25178':VARCHAR(10)
CHARACTER SET "UTF-8", _UTF-8'25214':VARCHAR(10) CHARACTER SET "UTF-8",
_UTF-8'25264':VARCHAR(10) CHARACTER SET "UTF-8", _UTF-8'25333':VARCHAR(10)
CHARACTER SET "UTF-8", _UTF-8'25494':VARCHA
R(10) CHARACTER SET "UTF-8", _UTF-8'25717':VARCHAR(10) CHARACTER SET "UTF-8",
_UTF-8'25973':VARCHAR(10) CHARACTER SET "UTF-8", _UTF-8'26217':VARCHAR(10)
CHARACTER SET "UTF-8", _UTF-8'26689':VARCHAR(10) CHARACTER SET "UTF-8",
_UTF-8'27052':VARCHAR(10) CHARACTER SET "UTF-8", _UTF-8'27116':VARCHAR(10)
CHARACTER SET "UTF-8", _UTF-8'27156':VARCHAR(10) CHARACTER SET "UTF-8",
_UTF-8'27287':VARCHAR(10) CHARACTER SET "UTF-8", _UTF-8'27369':VARCHAR(10)
CHARACTER SET "UTF-8", _UTF-8'27385':VARCHAR(10) CHARACTER SET "UTF-8",
_UTF-8'27413':VARCHAR(10) CHARACTER SET "UTF-8", _UTF-8'27642':VARCHAR(10)
CHARACTER SET "UTF-8", _UTF-8'27700':VARCHAR(10) CHARACTER SET "UTF-8",
_UTF-8'28055':VARCHAR(10) CHARACTER SET "UTF-8", _UTF-8'28239':VARCHAR(10)
CHARACTER SET "UTF-8", _UTF-8'28571':VARCHAR(10) CHARACTER SET "UTF-8",
_UTF-8'28577':VARCHAR(10) CHARACTER SET "UTF-8", _UTF-8'28810':VARCHAR(10)
CHARACTER SET "UTF-8", _UTF-8'29086':VARCHAR(10) CHARACTER SET "UTF-8",
_UTF-8'29392':VARCHAR(10) CHARACTER S
ET "UTF-8", _UTF-8'29450':VARCHAR(10) CHARACTER SET "UTF-8",
_UTF-8'29752':VARCHAR(10) CHARACTER SET "UTF-8", _UTF-8'29818':VARCHAR(10)
CHARACTER SET "UTF-8", _UTF-8'30106':VARCHAR(10) CHARACTER SET "UTF-8",
_UTF-8'30415':VARCHAR(10) CHARACTER SET "UTF-8", _UTF-8'30621':VARCHAR(10)
CHARACTER SET "UTF-8", _UTF-8'31013':VARCHAR(10) CHARACTER SET "UTF-8",
_UTF-8'31016':VARCHAR(10) CHARACTER SET "UTF-8", _UTF-8'31655':VARCHAR(10)
CHARACTER SET "UTF-8", _UTF-8'31830':VARCHAR(10) CHARACTER SET "UTF-8",
_UTF-8'32489':VARCHAR(10) CHARACTER SET "UTF-8", _UTF-8'32669':VARCHAR(10)
CHARACTER SET "UTF-8", _UTF-8'32754':VARCHAR(10) CHARACTER SET "UTF-8",
_UTF-8'32919':VARCHAR(10) CHARACTER SET "UTF-8", _UTF-8'32958':VARCHAR(10)
CHARACTER SET "UTF-8", _UTF-8'32961':VARCHAR(10) CHARACTER SET "UTF-8",
_UTF-8'33113':VARCHAR(10) CHARACTER SET "UTF-8", _UTF-8'33122':VARCHAR(10)
CHARACTER SET "UTF-8", _UTF-8'33159':VARCHAR(10) CHARACTER SET "UTF-8",
_UTF-8'33467':VARCHAR(10) CHARACTER SET "UTF-8", _UTF-
8'33562':VARCHAR(10) CHARACTER SET "UTF-8", _UTF-8'33773':VARCHAR(10)
CHARACTER SET "UTF-8", _UTF-8'33869':VARCHAR(10) CHARACTER SET "UTF-8",
_UTF-8'34306':VARCHAR(10) CHARACTER SET "UTF-8", _UTF-8'34473':VARCHAR(10)
CHARACTER SET "UTF-8", _UTF-8'34594':VARCHAR(10) CHARACTER SET "UTF-8",
_UTF-8'34948':VARCHAR(10) CHARACTER SET "UTF-8", _UTF-8'34972':VARCHAR(10)
CHARACTER SET "UTF-8", _UTF-8'35076':VARCHAR(10) CHARACTER SET "UTF-8",
_UTF-8'35390':VARCHAR(10) CHARACTER SET "UTF-8", _UTF-8'35834':VARCHAR(10)
CHARACTER SET "UTF-8", _UTF-8'35863':VARCHAR(10) CHARACTER SET "UTF-8",
_UTF-8'35926':VARCHAR(10) CHARACTER SET "UTF-8", _UTF-8'36201':VARCHAR(10)
CHARACTER SET "UTF-8", _UTF-8'36335':VARCHAR(10) CHARACTER SET "UTF-8",
_UTF-8'36430':VARCHAR(10) CHARACTER SET "UTF-8", _UTF-8'36479':VARCHAR(10)
CHARACTER SET "UTF-8", _UTF-8'37119':VARCHAR(10) CHARACTER SET "UTF-8",
_UTF-8'37788':VARCHAR(10) CHARACTER SET "UTF-8", _UTF-8'37914':VARCHAR(10)
CHARACTER SET "UTF-8", _UTF-8'38353':VARCHAR(
10) CHARACTER SET "UTF-8", _UTF-8'38607':VARCHAR(10) CHARACTER SET "UTF-8",
_UTF-8'38919':VARCHAR(10) CHARACTER SET "UTF-8", _UTF-8'39214':VARCHAR(10)
CHARACTER SET "UTF-8", _UTF-8'39459':VARCHAR(10) CHARACTER SET "UTF-8",
_UTF-8'39500':VARCHAR(10) CHARACTER SET "UTF-8", _UTF-8'39503':VARCHAR(10)
CHARACTER SET "UTF-8", _UTF-8'40146':VARCHAR(10) CHARACTER SET "UTF-8",
_UTF-8'40936':VARCHAR(10) CHARACTER SET "UTF-8", _UTF-8'40979':VARCHAR(10)
CHARACTER SET "UTF-8", _UTF-8'41162':VARCHAR(10) CHARACTER SET "UTF-8",
_UTF-8'41232':VARCHAR(10) CHARACTER SET "UTF-8", _UTF-8'41255':VARCHAR(10)
CHARACTER SET "UTF-8", _UTF-8'41331':VARCHAR(10) CHARACTER SET "UTF-8",
_UTF-8'41351':VARCHAR(10) CHARACTER SET "UTF-8", _UTF-8'41352':VARCHAR(10)
CHARACTER SET "UTF-8", _UTF-8'41419':VARCHAR(10) CHARACTER SET "UTF-8",
_UTF-8'41807':VARCHAR(10) CHARACTER SET "UTF-8", _UTF-8'41836':VARCHAR(10)
CHARACTER SET "UTF-8", _UTF-8'41967':VARCHAR(10) CHARACTER SET "UTF-8",
_UTF-8'42361':VARCHAR(10) CHARACTER SET
"UTF-8", _UTF-8'43432':VARCHAR(10) CHARACTER SET "UTF-8",
_UTF-8'43639':VARCHAR(10) CHARACTER SET "UTF-8", _UTF-8'43830':VARCHAR(10)
CHARACTER SET "UTF-8", _UTF-8'43933':VARCHAR(10) CHARACTER SET "UTF-8",
_UTF-8'44529':VARCHAR(10) CHARACTER SET "UTF-8", _UTF-8'45266':VARCHAR(10)
CHARACTER SET "UTF-8", _UTF-8'45484':VARCHAR(10) CHARACTER SET "UTF-8",
_UTF-8'45533':VARCHAR(10) CHARACTER SET "UTF-8", _UTF-8'45645':VARCHAR(10)
CHARACTER SET "UTF-8", _UTF-8'45676':VARCHAR(10) CHARACTER SET "UTF-8",
_UTF-8'45859':VARCHAR(10) CHARACTER SET "UTF-8", _UTF-8'46081':VARCHAR(10)
CHARACTER SET "UTF-8", _UTF-8'46131':VARCHAR(10) CHARACTER SET "UTF-8",
_UTF-8'46507':VARCHAR(10) CHARACTER SET "UTF-8", _UTF-8'47289':VARCHAR(10)
CHARACTER SET "UTF-8", _UTF-8'47369':VARCHAR(10) CHARACTER SET "UTF-8",
_UTF-8'47529':VARCHAR(10) CHARACTER SET "UTF-8", _UTF-8'47602':VARCHAR(10)
CHARACTER SET "UTF-8", _UTF-8'47770':VARCHAR(10) CHARACTER SET "UTF-8",
_UTF-8'48017':VARCHAR(10) CHARACTER SET "UTF-8", _UTF-8'
48162':VARCHAR(10) CHARACTER SET "UTF-8", _UTF-8'48333':VARCHAR(10) CHARACTER
SET "UTF-8", _UTF-8'48530':VARCHAR(10) CHARACTER SET "UTF-8",
_UTF-8'48567':VARCHAR(10) CHARACTER SET "UTF-8", _UTF-8'49101':VARCHAR(10)
CHARACTER SET "UTF-8", _UTF-8'49130':VARCHAR(10) CHARACTER SET "UTF-8",
_UTF-8'49140':VARCHAR(10) CHARACTER SET "UTF-8", _UTF-8'49211':VARCHAR(10)
CHARACTER SET "UTF-8", _UTF-8'49230':VARCHAR(10) CHARACTER SET "UTF-8",
_UTF-8'49254':VARCHAR(10) CHARACTER SET "UTF-8", _UTF-8'49472':VARCHAR(10)
CHARACTER SET "UTF-8", _UTF-8'50412':VARCHAR(10) CHARACTER SET "UTF-8",
_UTF-8'50632':VARCHAR(10) CHARACTER SET "UTF-8", _UTF-8'50636':VARCHAR(10)
CHARACTER SET "UTF-8", _UTF-8'50679':VARCHAR(10) CHARACTER SET "UTF-8",
_UTF-8'50788':VARCHAR(10) CHARACTER SET "UTF-8", _UTF-8'51089':VARCHAR(10)
CHARACTER SET "UTF-8", _UTF-8'51184':VARCHAR(10) CHARACTER SET "UTF-8",
_UTF-8'51195':VARCHAR(10) CHARACTER SET "UTF-8", _UTF-8'51634':VARCHAR(10)
CHARACTER SET "UTF-8", _UTF-8'51717':VARCHAR(10
) CHARACTER SET "UTF-8", _UTF-8'51766':VARCHAR(10) CHARACTER SET "UTF-8",
_UTF-8'51782':VARCHAR(10) CHARACTER SET "UTF-8", _UTF-8'51793':VARCHAR(10)
CHARACTER SET "UTF-8", _UTF-8'51933':VARCHAR(10) CHARACTER SET "UTF-8",
_UTF-8'52094':VARCHAR(10) CHARACTER SET "UTF-8", _UTF-8'52301':VARCHAR(10)
CHARACTER SET "UTF-8", _UTF-8'52389':VARCHAR(10) CHARACTER SET "UTF-8",
_UTF-8'52868':VARCHAR(10) CHARACTER SET "UTF-8", _UTF-8'53163':VARCHAR(10)
CHARACTER SET "UTF-8", _UTF-8'53535':VARCHAR(10) CHARACTER SET "UTF-8",
_UTF-8'53565':VARCHAR(10) CHARACTER SET "UTF-8", _UTF-8'54010':VARCHAR(10)
CHARACTER SET "UTF-8", _UTF-8'54207':VARCHAR(10) CHARACTER SET "UTF-8",
_UTF-8'54364':VARCHAR(10) CHARACTER SET "UTF-8", _UTF-8'54558':VARCHAR(10)
CHARACTER SET "UTF-8", _UTF-8'54585':VARCHAR(10) CHARACTER SET "UTF-8",
_UTF-8'55233':VARCHAR(10) CHARACTER SET "UTF-8", _UTF-8'55349':VARCHAR(10)
CHARACTER SET "UTF-8", _UTF-8'56224':VARCHAR(10) CHARACTER SET "UTF-8",
_UTF-8'56355':VARCHAR(10) CHARACTER SET "
UTF-8", _UTF-8'56436':VARCHAR(10) CHARACTER SET "UTF-8",
_UTF-8'56455':VARCHAR(10) CHARACTER SET "UTF-8", _UTF-8'56600':VARCHAR(10)
CHARACTER SET "UTF-8", _UTF-8'56877':VARCHAR(10) CHARACTER SET "UTF-8",
_UTF-8'57025':VARCHAR(10) CHARACTER SET "UTF-8", _UTF-8'57553':VARCHAR(10)
CHARACTER SET "UTF-8", _UTF-8'57631':VARCHAR(10) CHARACTER SET "UTF-8",
_UTF-8'57649':VARCHAR(10) CHARACTER SET "UTF-8", _UTF-8'57839':VARCHAR(10)
CHARACTER SET "UTF-8", _UTF-8'58032':VARCHAR(10) CHARACTER SET "UTF-8",
_UTF-8'58058':VARCHAR(10) CHARACTER SET "UTF-8", _UTF-8'58062':VARCHAR(10)
CHARACTER SET "UTF-8", _UTF-8'58117':VARCHAR(10) CHARACTER SET "UTF-8",
_UTF-8'58218':VARCHAR(10) CHARACTER SET "UTF-8", _UTF-8'58412':VARCHAR(10)
CHARACTER SET "UTF-8", _UTF-8'58454':VARCHAR(10) CHARACTER SET "UTF-8",
_UTF-8'58581':VARCHAR(10) CHARACTER SET "UTF-8", _UTF-8'59004':VARCHAR(10)
CHARACTER SET "UTF-8", _UTF-8'59080':VARCHAR(10) CHARACTER SET "UTF-8",
_UTF-8'59130':VARCHAR(10) CHARACTER SET "UTF-8", _UTF-8'59
226':VARCHAR(10) CHARACTER SET "UTF-8", _UTF-8'59345':VARCHAR(10) CHARACTER
SET "UTF-8", _UTF-8'59386':VARCHAR(10) CHARACTER SET "UTF-8",
_UTF-8'59494':VARCHAR(10) CHARACTER SET "UTF-8", _UTF-8'59852':VARCHAR(10)
CHARACTER SET "UTF-8", _UTF-8'60083':VARCHAR(10) CHARACTER SET "UTF-8",
_UTF-8'60298':VARCHAR(10) CHARACTER SET "UTF-8", _UTF-8'60560':VARCHAR(10)
CHARACTER SET "UTF-8", _UTF-8'60624':VARCHAR(10) CHARACTER SET "UTF-8",
_UTF-8'60736':VARCHAR(10) CHARACTER SET "UTF-8", _UTF-8'61527':VARCHAR(10)
CHARACTER SET "UTF-8", _UTF-8'61794':VARCHAR(10) CHARACTER SET "UTF-8",
_UTF-8'61860':VARCHAR(10) CHARACTER SET "UTF-8", _UTF-8'61997':VARCHAR(10)
CHARACTER SET "UTF-8", _UTF-8'62361':VARCHAR(10) CHARACTER SET "UTF-8",
_UTF-8'62585':VARCHAR(10) CHARACTER SET "UTF-8", _UTF-8'62878':VARCHAR(10)
CHARACTER SET "UTF-8", _UTF-8'63073':VARCHAR(10) CHARACTER SET "UTF-8",
_UTF-8'63180':VARCHAR(10) CHARACTER SET "UTF-8", _UTF-8'63193':VARCHAR(10)
CHARACTER SET "UTF-8", _UTF-8'63294':VARCHAR(10)
CHARACTER SET "UTF-8", _UTF-8'63792':VARCHAR(10) CHARACTER SET "UTF-8",
_UTF-8'63991':VARCHAR(10) CHARACTER SET "UTF-8", _UTF-8'64592':VARCHAR(10)
CHARACTER SET "UTF-8", _UTF-8'65148':VARCHAR(10) CHARACTER SET "UTF-8",
_UTF-8'65177':VARCHAR(10) CHARACTER SET "UTF-8", _UTF-8'65501':VARCHAR(10)
CHARACTER SET "UTF-8", _UTF-8'66057':VARCHAR(10) CHARACTER SET "UTF-8",
_UTF-8'66943':VARCHAR(10) CHARACTER SET "UTF-8", _UTF-8'67881':VARCHAR(10)
CHARACTER SET "UTF-8", _UTF-8'67975':VARCHAR(10) CHARACTER SET "UTF-8",
_UTF-8'67998':VARCHAR(10) CHARACTER SET "UTF-8", _UTF-8'68101':VARCHAR(10)
CHARACTER SET "UTF-8", _UTF-8'68293':VARCHAR(10) CHARACTER SET "UTF-8",
_UTF-8'68341':VARCHAR(10) CHARACTER SET "UTF-8", _UTF-8'68605':VARCHAR(10)
CHARACTER SET "UTF-8", _UTF-8'68730':VARCHAR(10) CHARACTER SET "UTF-8",
_UTF-8'68770':VARCHAR(10) CHARACTER SET "UTF-8", _UTF-8'68843':VARCHAR(10)
CHARACTER SET "UTF-8", _UTF-8'68852':VARCHAR(10) CHARACTER SET "UTF-8",
_UTF-8'68908':VARCHAR(10) CHARACTER SET "UT
F-8", _UTF-8'69280':VARCHAR(10) CHARACTER SET "UTF-8",
_UTF-8'69952':VARCHAR(10) CHARACTER SET "UTF-8", _UTF-8'69998':VARCHAR(10)
CHARACTER SET "UTF-8", _UTF-8'70041':VARCHAR(10) CHARACTER SET "UTF-8",
_UTF-8'70070':VARCHAR(10) CHARACTER SET "UTF-8", _UTF-8'70073':VARCHAR(10)
CHARACTER SET "UTF-8", _UTF-8'70450':VARCHAR(10) CHARACTER SET "UTF-8",
_UTF-8'71144':VARCHAR(10) CHARACTER SET "UTF-8", _UTF-8'71256':VARCHAR(10)
CHARACTER SET "UTF-8", _UTF-8'71286':VARCHAR(10) CHARACTER SET "UTF-8",
_UTF-8'71836':VARCHAR(10) CHARACTER SET "UTF-8", _UTF-8'71948':VARCHAR(10)
CHARACTER SET "UTF-8", _UTF-8'71954':VARCHAR(10) CHARACTER SET "UTF-8",
_UTF-8'71997':VARCHAR(10) CHARACTER SET "UTF-8", _UTF-8'72592':VARCHAR(10)
CHARACTER SET "UTF-8", _UTF-8'72991':VARCHAR(10) CHARACTER SET "UTF-8",
_UTF-8'73021':VARCHAR(10) CHARACTER SET "UTF-8", _UTF-8'73108':VARCHAR(10)
CHARACTER SET "UTF-8", _UTF-8'73134':VARCHAR(10) CHARACTER SET "UTF-8",
_UTF-8'73146':VARCHAR(10) CHARACTER SET "UTF-8", _UTF-8'7321
9':VARCHAR(10) CHARACTER SET "UTF-8", _UTF-8'73873':VARCHAR(10) CHARACTER SET
"UTF-8", _UTF-8'74686':VARCHAR(10) CHARACTER SET "UTF-8",
_UTF-8'75660':VARCHAR(10) CHARACTER SET "UTF-8", _UTF-8'75675':VARCHAR(10)
CHARACTER SET "UTF-8", _UTF-8'75742':VARCHAR(10) CHARACTER SET "UTF-8",
_UTF-8'75752':VARCHAR(10) CHARACTER SET "UTF-8", _UTF-8'77454':VARCHAR(10)
CHARACTER SET "UTF-8", _UTF-8'77817':VARCHAR(10) CHARACTER SET "UTF-8",
_UTF-8'78093':VARCHAR(10) CHARACTER SET "UTF-8", _UTF-8'78366':VARCHAR(10)
CHARACTER SET "UTF-8", _UTF-8'79077':VARCHAR(10) CHARACTER SET "UTF-8",
_UTF-8'79658':VARCHAR(10) CHARACTER SET "UTF-8", _UTF-8'80332':VARCHAR(10)
CHARACTER SET "UTF-8", _UTF-8'80846':VARCHAR(10) CHARACTER SET "UTF-8",
_UTF-8'81003':VARCHAR(10) CHARACTER SET "UTF-8", _UTF-8'81070':VARCHAR(10)
CHARACTER SET "UTF-8", _UTF-8'81084':VARCHAR(10) CHARACTER SET "UTF-8",
_UTF-8'81335':VARCHAR(10) CHARACTER SET "UTF-8", _UTF-8'81504':VARCHAR(10)
CHARACTER SET "UTF-8", _UTF-8'81755':VARCHAR(10) CH
ARACTER SET "UTF-8", _UTF-8'81963':VARCHAR(10) CHARACTER SET "UTF-8",
_UTF-8'82080':VARCHAR(10) CHARACTER SET "UTF-8", _UTF-8'82602':VARCHAR(10)
CHARACTER SET "UTF-8", _UTF-8'82620':VARCHAR(10) CHARACTER SET "UTF-8",
_UTF-8'83041':VARCHAR(10) CHARACTER SET "UTF-8", _UTF-8'83086':VARCHAR(10)
CHARACTER SET "UTF-8", _UTF-8'83583':VARCHAR(10) CHARACTER SET "UTF-8",
_UTF-8'83647':VARCHAR(10) CHARACTER SET "UTF-8", _UTF-8'83833':VARCHAR(10)
CHARACTER SET "UTF-8", _UTF-8'83910':VARCHAR(10) CHARACTER SET "UTF-8",
_UTF-8'83986':VARCHAR(10) CHARACTER SET "UTF-8", _UTF-8'84247':VARCHAR(10)
CHARACTER SET "UTF-8", _UTF-8'84680':VARCHAR(10) CHARACTER SET "UTF-8",
_UTF-8'84844':VARCHAR(10) CHARACTER SET "UTF-8", _UTF-8'84919':VARCHAR(10)
CHARACTER SET "UTF-8", _UTF-8'85066':VARCHAR(10) CHARACTER SET "UTF-8",
_UTF-8'85761':VARCHAR(10) CHARACTER SET "UTF-8", _UTF-8'86057':VARCHAR(10)
CHARACTER SET "UTF-8", _UTF-8'86379':VARCHAR(10) CHARACTER SET "UTF-8",
_UTF-8'86709':VARCHAR(10) CHARACTER SET "UTF-
8", _UTF-8'88086':VARCHAR(10) CHARACTER SET "UTF-8", _UTF-8'88137':VARCHAR(10)
CHARACTER SET "UTF-8", _UTF-8'88217':VARCHAR(10) CHARACTER SET "UTF-8",
_UTF-8'89193':VARCHAR(10) CHARACTER SET "UTF-8", _UTF-8'89338':VARCHAR(10)
CHARACTER SET "UTF-8", _UTF-8'90209':VARCHAR(10) CHARACTER SET "UTF-8",
_UTF-8'90229':VARCHAR(10) CHARACTER SET "UTF-8", _UTF-8'90669':VARCHAR(10)
CHARACTER SET "UTF-8", _UTF-8'91110':VARCHAR(10) CHARACTER SET "UTF-8",
_UTF-8'91894':VARCHAR(10) CHARACTER SET "UTF-8", _UTF-8'92292':VARCHAR(10)
CHARACTER SET "UTF-8", _UTF-8'92380':VARCHAR(10) CHARACTER SET "UTF-8",
_UTF-8'92645':VARCHAR(10) CHARACTER SET "UTF-8", _UTF-8'92696':VARCHAR(10)
CHARACTER SET "UTF-8", _UTF-8'93498':VARCHAR(10) CHARACTER SET "UTF-8",
_UTF-8'94791':VARCHAR(10) CHARACTER SET "UTF-8", _UTF-8'94835':VARCHAR(10)
CHARACTER SET "UTF-8", _UTF-8'94898':VARCHAR(10) CHARACTER SET "UTF-8",
_UTF-8'95042':VARCHAR(10) CHARACTER SET "UTF-8", _UTF-8'95430':VARCHAR(10)
CHARACTER SET "UTF-8", _UTF-8'95464'
:VARCHAR(10) CHARACTER SET "UTF-8", _UTF-8'95694':VARCHAR(10) CHARACTER SET
"UTF-8", _UTF-8'96435':VARCHAR(10) CHARACTER SET "UTF-8",
_UTF-8'96560':VARCHAR(10) CHARACTER SET "UTF-8", _UTF-8'97173':VARCHAR(10)
CHARACTER SET "UTF-8", _UTF-8'97462':VARCHAR(10) CHARACTER SET "UTF-8",
_UTF-8'98069':VARCHAR(10) CHARACTER SET "UTF-8", _UTF-8'98072':VARCHAR(10)
CHARACTER SET "UTF-8", _UTF-8'98338':VARCHAR(10) CHARACTER SET "UTF-8",
_UTF-8'98533':VARCHAR(10) CHARACTER SET "UTF-8", _UTF-8'98569':VARCHAR(10)
CHARACTER SET "UTF-8", _UTF-8'98584':VARCHAR(10) CHARACTER SET "UTF-8",
_UTF-8'98862':VARCHAR(10) CHARACTER SET "UTF-8", _UTF-8'99060':VARCHAR(10)
CHARACTER SET "UTF-8", _UTF-8'99132':VARCHAR(10) CHARACTER SET
"UTF-8"]:VARCHAR(10) CHARACTER SET "UTF-8")
fieldNames: [CA_ZIP]
projection: [SUBSTR(CA_ZIP, 1, 5)]
est: (rows=50000)
Exchange
- distribution: hash by [CA_ZIP]
+ distribution: random
est: (rows=1665)
Project
fieldNames: [CA_ZIP]
- projection: [CA_ZIP]
+ projection: [SUBSTR(CA_ZIP, 1, 5)]
Review Comment:
> Before the upgrade we could only group by column names, isn't it?
no, this is not quite correct. We supported `GROUP BY ALIAS` a year ago (see
[IGNITE-18212](https://issues.apache.org/jira/browse/IGNITE-18212)).
> Now, we can group by index/aliases
this change represents exactly the opposite. Take a look at fragment of the
old plan:
```
MapHashAggregate
fieldNames: [CA_ZIP, _ACC0, _GROUP_ID]
group: [CA_ZIP]
aggregation: [COUNT()]
est: (rows=3330)
Project
fieldNames: [CA_ZIP]
projection: [SUBSTR(CA_ZIP, 1, 5)]
est: (rows=33300)
```
We first compute projection and then group by the result of the projection.
And now we group by raw `CA_ZIP ` column and only then compute projection.
I'm afraid, these two plans (old one and new one) are not equivalent. It's
better to check TCPDS spec to understand actual semantic of the subquery
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
