lowka commented on code in PR #7249:
URL: https://github.com/apache/ignite-3/pull/7249#discussion_r2635117717
##########
modules/sql-engine/src/test/java/org/apache/ignite/internal/sql/engine/planner/datatypes/NumericInTypeCoercionTest.java:
##########
@@ -2710,16 +2714,81 @@ public void literals(
.build()
);
- // SHORT values can intersect with a DECIMAL with a 5 digits in
integer parts, so for SHORT (INT16) we need to generate values
- // take it into consideration.
- boolean closerToBound = numericPair.first().spec() == ColumnType.INT16;
-
- String value = "(" + generateLiteral(numericPair.second(),
closerToBound) + ")";
+ String value = "(" + generateLiteralForPair(numericPair, true) + ")";
Predicate<IgniteTableScan> matcher = checkPlan(first, second);
assertPlan("SELECT c1 FROM T1 WHERE c1 IN " + value, schema, matcher);
}
+ private static String generateLiteralForPair(NumericPair numericPair,
boolean literalIsInRange) {
Review Comment:
Fixed.
##########
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:
Filed an issue.
--
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]
