korlov42 commented on code in PR #7249:
URL: https://github.com/apache/ignite-3/pull/7249#discussion_r2629844542
##########
modules/sql-engine/src/test/java/org/apache/ignite/internal/sql/engine/planner/CorrelatedSubqueryPlannerTest.java:
##########
@@ -196,15 +196,13 @@ public void testCorrelatesCollisionsMixed() throws
Exception {
List<LogicalCorrelate> correlates = findNodes(rel,
byClass(LogicalCorrelate.class));
- assertEquals(4, correlates.size());
+ assertEquals(2, correlates.size());
// There are collisions by correlation id.
assertEquals(correlates.get(0).getCorrelationId(),
correlates.get(1).getCorrelationId());
- assertEquals(correlates.get(0).getCorrelationId(),
correlates.get(2).getCorrelationId());
- assertEquals(correlates.get(0).getCorrelationId(),
correlates.get(3).getCorrelationId());
+ // Cannot decorrelate further
rel = planner.replaceCorrelatesCollisions(rel);
Review Comment:
looks like `planner.replaceCorrelatesCollisions(rel);` is not need anymore.
Please file a jira to take a look later
##########
modules/sql-engine/src/test/java/org/apache/ignite/internal/sql/engine/planner/PrimaryKeyLookupPlannerTest.java:
##########
@@ -204,15 +204,15 @@ void optimizedGetWithOutOfRangeKey() {
QueryPlan plan = node.prepare("SELECT * FROM test WHERE id = 128");
assertThat(plan, instanceOf(MultiStepPlan.class));
- assertEmptyValuesNode((MultiStepPlan) plan);
+ assertEmptyScan((MultiStepPlan) plan);
Review Comment:
please file a JIRA and add TODO here and below to investigate this change.
First changes in `DynamicParametersTest.java` most likely caused by the very
same issue
##########
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:
this method is not correct. It doesn't respect given type of literal
##########
modules/sql-engine/src/main/java/org/apache/ignite/internal/sql/engine/prepare/IgniteSqlToRelConvertor.java:
##########
@@ -193,9 +221,8 @@ private void convertValuesImplEx(Blackboard bb, SqlCall
values, RelDataType targ
}
/**
- * This method was copy-pasted from super-method except this changes:
- * - For updateCall we require all columns in the project and should not
skip anything.
- * - If there is no updateCall, LEFT JOIN converted to ANTI JOIN.
+ * This method was copy-pasted from super-method except this changes: -
For updateCall we require all columns in the project and should
Review Comment:
please restore formatting
##########
modules/sql-engine/src/test/resources/tpcds/plan/q15.plan:
##########
@@ -1,54 +1,40 @@
Sort
collation: [CA_ZIP ASC]
fetch: 100
- est: (rows=100)
Review Comment:
please restore back estimates
##########
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:
this change looks suspicious as well. Please file a JIRA to take a look at
it later
--
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]
