AMashenkov commented on code in PR #7249:
URL: https://github.com/apache/ignite-3/pull/7249#discussion_r2630472446
##########
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:
Why?
```
SELECT substr(ca_zip,1,5) ca_zip,count(*) cnt
FROM customer_address, customer
WHERE ca_address_sk = c_current_addr_sk and
c_preferred_cust_flag='Y'
group by ca_zip
having count(*) > 10)A1)A2) V1
```
Before the upgrade we could only group by column names, isn't it?
So, before, we grouped by the real `ca_zip` column and therefore couldn't
pushdown the `substr` function here and below.
Now, we can group by index/aliases. So, now we group by alias here.
The query works earlier just because of clashing names.
Am I missed smth?
##########
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:
Why?
```
SELECT substr(ca_zip,1,5) ca_zip,count(*) cnt
FROM customer_address, customer
WHERE ca_address_sk = c_current_addr_sk and
c_preferred_cust_flag='Y'
group by ca_zip
having count(*) > 10)A1)A2) V1
```
Before the upgrade we could only group by column names, isn't it?
So, before, we grouped by the real `ca_zip` column and therefore couldn't
pushdown the `substr` function here and below.
Now, we can group by index/aliases. So, now we group by alias here.
The query worked earlier just because of clashing names.
Am I missed smth?
--
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]
