2         K                     d    V  V       - - - - d    d   d -  K Vac| !" #$ %  &' d()* K+,- -./ 012 3 4+456789:;<=>?@ABCDEF +GHIJKLMNOPQRSTUVWX Y Z [  \ ] ^ _ ` a b c ^ d ef g 4g Kgh  ij  dk l m n op dq Km r s Ks t u v dw x y 4z Kx {| } K~ K 4{ 4 d    V             V d                     d    V V     4   d K    V V V V V +     K   K 4      g  V  d  d   d     V   d   4 4  4 4    V V V V d d   K     Collector InnerClassesVALUEI ConstantValueCOLUMNQUERYTRUEFALSE VALUELISTASTERISKFUNCTIONLIMITROW PARAMNEGATE ADD SUBTRACT MULTIPLY DIVIDECONCATNOTEQUAL BIGGER_EQUALBIGGERSMALLER SMALLER_EQUAL NOT_EQUALLIKEANDORINEXISTSALL ANY!IS_NULL"COUNT(SUM)MIN*MAX+AVG,EVERY-SOME. STDDEV_POP/ STDDEV_SAMP0VAR_POP1VAR_SAMP2IFNULL<CONVERT=CASEWHEN>EXTRACT?POSITION@TRIMA SUBSTRINGBNULLIFCCASEDCOALESCEE ALTERNATIVEFSEQUENCEGPLUSdOPENeCLOSEfSELECTgCOMMAhBETWEENjCASTkENDlISmWHENnTHENoELSEpENDWHENqDISTINCTrVIEWsASzFOR{FROM|BOTH}LEADING~TRAILINGYEARMONTHDAYHOURMINUTESECOND TIMEZONE_HOURT_TIMEZONE_MINUTEDOWSQL_EXTRACT_FIELD_NAMESLorg/hsqldb/lib/HashSet;SQL_TRIM_SPECIFICATIONAGGREGATE_SELFAGGREGATE_NONEAGGREGATE_LEFTAGGREGATE_RIGHTAGGREGATE_BOTHAGGREGATE_FUNCTIONexprType aggregateSpeceArgLorg/hsqldb/Expression;eArg2 valueDataLjava/lang/Object;dataTypehList valueList[Lorg/hsqldb/Expression;isFixedConstantValueListZsubQueryLorg/hsqldb/SubQuery;isQueryCorrelatedfunctionLorg/hsqldb/Function; likeObjectLorg/hsqldb/Like;catalogLjava/lang/String;schema tableName columnName tableFilterLorg/hsqldb/TableFilter; outerFilter columnIndex columnQuoted precisionscale columnAlias aliasQuoted isDescendingjoinedTableColumnIndexisDistinctAggregateisParamisInJoin INTEGER_0Ljava/lang/Integer; INTEGER_1oldIType PARAM_UNKNOWNPARAM_IN PARAM_IN_OUT PARAM_OUTNO_NULLSNULLABLENULLABLE_UNKNOWN isIdentity nullability isWritable paramModevalueClassName(Z)VCode StackMapTable(Lorg/hsqldb/Function;)V(Lorg/hsqldb/NumberSequence;)V(Lorg/hsqldb/Expression;)V(Lorg/hsqldb/SubQuery;)V([Lorg/hsqldb/Expression;)V2(ILorg/hsqldb/Expression;Lorg/hsqldb/Expression;)V(Lorg/hsqldb/Expression;III)VG(Lorg/hsqldb/Expression;Lorg/hsqldb/Expression;Ljava/lang/Character;Z)V9(Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;)V((Ljava/lang/String;Ljava/lang/String;Z)V.(Lorg/hsqldb/TableFilter;Lorg/hsqldb/Column;)V(ILjava/lang/Object;)V(ILjava/lang/Object;Z)V isTypeEqual(Lorg/hsqldb/Expression;)ZcheckAggregate()Vdescribe((Lorg/hsqldb/Session;)Ljava/lang/String; getContextDDL+(Lorg/hsqldb/Expression;)Ljava/lang/String; Exceptions getColumnDDL()Ljava/lang/String;getDDL)(Lorg/hsqldb/Session;I)Ljava/lang/String; setDataType(I)VsetTruesetNull similarToequals'(Ljava/lang/Object;Ljava/lang/Object;)Z3([Lorg/hsqldb/Expression;[Lorg/hsqldb/Expression;)Z1(Lorg/hsqldb/Expression;Lorg/hsqldb/Expression;)ZcanBeInGroupBy()ZcanBeInOrderByisColumncollectColumnName(Lorg/hsqldb/lib/HashSet;)ZcollectAllColumnNames(Lorg/hsqldb/lib/HashSet;)V isConstantcanBeInAggregate isAggregateisSelfAggregate(I)Z isConditionalcollectInGroupByExpressions!(Lorg/hsqldb/lib/HsqlArrayList;)V setDescendingsetAlias(Ljava/lang/String;Z)V setColumnName setTableName(Ljava/lang/String;)VgetDefinedAliasgetAlias isAliasQuotedgetType()IgetArg()Lorg/hsqldb/Expression;getArg2 getFilter()Lorg/hsqldb/TableFilter; checkResolved(Z)Z checkTablesgetExpressionForAlias2([Lorg/hsqldb/Expression;I)Lorg/hsqldb/Expression;replaceAliases([Lorg/hsqldb/Expression;I)VsetLikeOptimisedgetEquiJoinColumns5(Lorg/hsqldb/TableFilter;[Z[Lorg/hsqldb/Expression;)VfindTableFilter3([Lorg/hsqldb/TableFilter;)Lorg/hsqldb/TableFilter; resolveTables(Lorg/hsqldb/TableFilter;)VgetCaseWhenType(Lorg/hsqldb/Session;)I resolveTypes(Lorg/hsqldb/Session;)VresolveTypeForLikeresolveTypeForIn isResolved isCompare getTableNamegetFilterTableNamegetTableHsqlNameHsqlName'()Lorg/hsqldb/HsqlNameManager$HsqlName;getTableSchemaName getColumnNamegetBaseColumnName getColumnNr getColumnSizegetColumnScalesetDistinctAggregate swapCondition getDataTypegetValue)(Lorg/hsqldb/Session;I)Ljava/lang/Object;getAggregatedValue:(Lorg/hsqldb/Session;Ljava/lang/Object;)Ljava/lang/Object;updateAggregatingValue((Lorg/hsqldb/Session;)Ljava/lang/Object; testCondition(Lorg/hsqldb/Session;)Ztest)(Lorg/hsqldb/Session;)Ljava/lang/Boolean; compareValuesM(Lorg/hsqldb/Session;Ljava/lang/Object;Ljava/lang/Object;)Ljava/lang/Boolean;testInCondition;(Lorg/hsqldb/Session;Ljava/lang/Object;)Ljava/lang/Boolean;testExistsConditiontestAnyAllConditiongetAnyAllValueP(Lorg/hsqldb/Session;Ljava/lang/Object;Lorg/hsqldb/SubQuery;)Ljava/lang/Boolean;   setForJoin(Lorg/hsqldb/TableFilter;Z)ZgetCheckSelectR(Lorg/hsqldb/Session;Lorg/hsqldb/Table;Lorg/hsqldb/Expression;)Lorg/hsqldb/Select;setLeftExpressionsetRightExpressiongetRightExpressionbind(Ljava/lang/Object;)VisFixedConstantisFixedConditionalsetTableColumnAttributes(Lorg/hsqldb/Table;I)VgetValueClassName F\org/hsqldb/Expression Z 2Z 9Z BZ DZ Z      Z   5 !"  [\  -Z .Z /$ 0org/hsqldb/Like F %$ &$ '$ ,   & % $ c '  FW 4 {} {r ]f ecjava/lang/StringBuffer   c G () SYSTEM_SUBQUERY m  $ +Z  Fi _` corg/hsqldb/Token?  org/hsqldb/HsqlException||NULL>=<= IS NOT != !"ESCAPE# $%org/hsqldb/Trace &'SET TRUE, WAS:  FUNCTION ]^PARAM VALUE = ( , TYPE = $)COLUMN QUERY *+TRUE FALSE  VALUELIST  TYPE = * NEGATE ADD  SUBTRACT  MULTIPLY DIVIDE CONCAT NOT EQUAL  BIGGER_EQUAL BIGGER SMALLER SMALLER_EQUAL  NOT_EQUAL LIKE AND OR ALL ANY IN IS_NULL EXISTS COUNT SUM MIN MAX AVG CONVERT  CASEWHEN  join arg1=[ arg2=[org/hsqldb/Types mn mo lp lZ tr , uv wx yr ~r |r  1 java/lang/StringBuilder -. &. /0  1 23org/hsqldb/TableFilter 45   \ 6  7c   8 java/lang/Boolean 9r : ; < &= r  >} ?@ r  k\ M  aA  B   C} DEjava/lang/String &F GH Ir Jr Kc Lr Mr N Or Pc FP FR   org/hsqldb/lib/HashSet Q RS T c 3Expression.swapCondition U 67org/hsqldb/SetFunction V[Ljava/lang/Object; java/lang/Object WE DX cA YZ [\  ]^ _` a b }   ,c dc ec fc gh Fi 87 ,j  kjava/lang/NullPointerException lorg/hsqldb/NumberSequence mVExpression.test  n o p qrs tu [v w xy z {| }~ r          *) org/hsqldb/Select  F   A C #$   Ar r Cr c E$ ) c  TIMEZONE_MINUTE DAYOFWEEK  org/hsqldb/Expression$Collectororg/hsqldb/Functionorg/hsqldb/Columnorg/hsqldb/Tableorg/hsqldb/Sessionorg/hsqldb/lib/HsqlArrayList#org/hsqldb/HsqlNameManager$HsqlNameorg/hsqldb/Resultorg/hsqldb/SubQueryorg/hsqldb/Indexorg/hsqldb/index/RowIteratororg/hsqldb/Row hasAggregate(Ljava/lang/Character;Z)V filterTableLorg/hsqldb/Table;%Lorg/hsqldb/HsqlNameManager$HsqlName;namegetName isNameQuotedappend(C)Ljava/lang/StringBuffer;,(Ljava/lang/String;)Ljava/lang/StringBuffer;toStringdoAssertgetTable()Lorg/hsqldb/Table;(Ljava/lang/Object;)Z statementName getColumn(I)Lorg/hsqldb/Column;getDLLcreateSQLString'(Ljava/lang/Object;I)Ljava/lang/String; escapeCharLjava/lang/Character;java/lang/Character getTypeString(III)Ljava/lang/String;error(I)Lorg/hsqldb/HsqlException;,(Ljava/lang/Object;)Ljava/lang/StringBuffer;(I)Ljava/lang/String;selectLorg/hsqldb/Select;add-(Ljava/lang/String;)Ljava/lang/StringBuilder;/(ILjava/lang/Object;)Lorg/hsqldb/HsqlException; usedColumns[Zsizeget(I)Ljava/lang/Object; findColumn(Ljava/lang/String;)I optimised getSchemaNameresolveTablesUnion booleanValue resolveType getReturnType exprColumns(II)Lorg/hsqldb/HsqlException;isCharacterTypegetCombinedNumberType(III)ILjava/lang/Boolean;(II)I isNumberType convertObject'(Ljava/lang/Object;I)Ljava/lang/Object;1(II[Ljava/lang/Object;)Lorg/hsqldb/HsqlException; setParams*(Lorg/hsqldb/Session;Ljava/lang/String;Z)VisEquivalentToFalsePredicateisEquivalentToEqualsPredicate getRangeLowisEquivalentToNotNullPredicateisEquivalentToBetweenPredicate hasCollation/isEquivalentToBetweenPredicateAugmentedWithLike getRangeHighorg/hsqldb/Libraryrtrim&(Ljava/lang/String;)Ljava/lang/String; isAssigned(ZLjava/lang/String;)V()Ljava/lang/Object;negate=(Lorg/hsqldb/Session;Ljava/lang/Object;III)Ljava/lang/Object; resetPattern)(Lorg/hsqldb/Session;Ljava/lang/String;)Vcompare;(Lorg/hsqldb/Session;Ljava/lang/String;)Ljava/lang/Boolean; getResult*(Lorg/hsqldb/Session;I)Lorg/hsqldb/Result;rRootLorg/hsqldb/Record;tableisEmpty9(Ljava/lang/Object;Ljava/lang/Object;I)Ljava/lang/Object;subtractmultiplydivideconcat8(Ljava/lang/Object;Ljava/lang/Object;)Ljava/lang/Object;(IIZ)V)(Lorg/hsqldb/Session;Ljava/lang/Object;)V currentData(C)Ljava/lang/StringBuilder;getValueObject isOuterJoinisCurrentOuter nonJoinIsNulldatabaseLorg/hsqldb/Database;org/hsqldb/Database collationLorg/hsqldb/Collation;>(Lorg/hsqldb/Collation;Ljava/lang/Object;Ljava/lang/Object;I)IcontainsgetColumnTypes()[I populateTablegetPrimaryIndex()Lorg/hsqldb/Index; findFirstRowG(Lorg/hsqldb/Session;Ljava/lang/Object;I)Lorg/hsqldb/index/RowIterator;hasNext clearAllRowsfindFirstRowNotNull4(Lorg/hsqldb/Session;)Lorg/hsqldb/index/RowIterator;next()Lorg/hsqldb/Row;compareToTypeRange(Ljava/lang/Object;I)IlastRow&(Lorg/hsqldb/Session;)Lorg/hsqldb/Row;getData()[Ljava/lang/Object; getRowCounttFilter[Lorg/hsqldb/TableFilter;G(Lorg/hsqldb/Table;Ljava/lang/String;Lorg/hsqldb/lib/HashMappedList;Z)VqueryCondition resolveAll(Lorg/hsqldb/Session;Z)ZgetSizegetScale isNullablegetCatalogNamegetColStClsNamegetReturnClassNameaddAll([Ljava/lang/Object;)Zorg/hsqldb/store/ValuePoolgetInt(I)Ljava/lang/Integer;org/hsqldb/HsqlNameManager!YZ[\]Z[^_Z[`aZ[bcZ[deZ[fgZ[hiZ[jkZ[lmZ[noZ[npZ[qrZ[stZ[uvZ[wxZ[yzZ[{|Z[}~Z[Z[Z[Z[Z[Z[Z[Z[Z[Z[Z[Z[Z[Z[Z[Z[Z[Z[Z[Z[Z[Z[Z[Z[Z[Z[Z[Z[Z[Z[Z[Z[Z[Z[Z[Z[Z[Z[Z[Z[Z[Z[Z[Z[Z[Z[Z[Z[Z[Z[Z[Z[Z[Z[Z[Z[Z[Z[Z[Z[Z[Z[Z[Z[Z[Z[Z[Z[ Z[  Z[\ Z[^ Z[`Z[bZZZ !"#$%$&$'$()*)+Z,-Z.Z/$012Z34567879Z:Z[ ;Z[\<Z[^=Z[b>Z[ ?Z[\@Z[^ABZCDZE$fFGH],*******I&FJHV5********+ + *I4KFLH=1*******G*+ *+ FMHnb*******+*+ *+*+*+*+*+*+ *FNH4(********+FOH4(********+FPH=1********,*-*FQHYM*******=*+* ***+*+*FRHL@********+*,*Y-*FSHg?*******+*,- * **-I4 FTHe?*******+, ***,*I/FUHg*******+ !"*+#, *&**,$"*,$%*,& ICV"FWH9-******** *, FXH8*,'*(*IYZH>'* + *+*+I%@[\HeN*) *>**** *Y`*** *Y`I]^H*++_`HpV*,L*J*B*9*F0*>'*=-Y.M,(/+0)/1L+ITaAbcH*2-Y.L*34M*56@,7"*6+"/*0"/./W+, 80./W+,*9:$80W+1I @J-daAecHd-Y@;LMN* */-0W+1+,0</-0W+1+,0I0-0W+1G-6+,0J0-0W+,0K0-0W+1+,0 /L0 /W+-0W*M4+ /N0 /'/W+*MO0'/W+ /W+1+,0 /P0 /-0W+1+,0 /Q0 /-0W+1+,0 /R0 /-0W+1+,0 /S0 /-0W+1+,0 /T0 /-0W+1+ /U0(/W+,0,/W+* **V0W+)/W+1+ /W0(/W+,0,/-0)/W+1+,0 /E0 /G0W+1+,0,/-0W+1^+ /X0 /WJ+ /Y0(/W6+ /Z0(/W+,0)/W+ /[0(/W+,0)/W+ /\0(/W+,0)/W+ /]0(/W+,0)/W+ /^0(/W+,0)/W+ /_0(/W+,0)/W|+ /`0(/W+,0)/W]+ /a0(/W+,0)/W>+ /b0(/W+,0)/W+ /c0(/W+,0)/WcetAI]9-? J@A#d+ =U;)aA]fH -Y@;: /W6 /W* f0W* **>>5k$/:EP[fq|$/:EP[k{g0W* +h0W1*( i0Wj0* kWl0* m0W1n0W**0W./W*0W1o0W*p+q0W1r0W(s0Wt0Wu0* m0W*6*%*2+`+0W /Wקv0Ww0Wx0Wy0Wz0W{0W|0W}}0Wr~0Wg0W\0WQ0WF0W;0W00W*+0W0W 0W0W0W0W0W0W0W0W0W0W0W^0 /W_0 /Ws`0 /Wca0 /WSb0 /WCc0 /W30W* **V0W /W 0W* 0W*$0W*+`+0W]/W*$0W*+`+0W]/W1IY7-Cg-&  #+  '''hiH* j\H+* ***Ik\H+*(** * **lZH++**+* + w* + i*+[*+M* + ?*+1*+#*+*+I @mnH.*+ *+I DmoHwL*+*+*=>6/*2:+2: >IFlpH.*+ *+I DqrH7****I @srH=%*** **I@trHr*lHlllllllJRRRRR** *I L@uvH8*= +*WI  @ wxH='*+!* *+* *+IyrHv*pLppppppppNVVVVV***I P@zrH,** *I@{rH$ *I @|rH%*I @{}HV@=(2;;;;;;;;;;;I<~rH*"***I @Hv]*X*Q* +*WA*5*>*+!* *+* *+I \H*1rH*H *+*H *+*H*+cH*cH2****I rH1****I H*H*H*H*3HP=**=**=*%*p*p=* * =*+>* *2=*`*3L*=GC* * Y**N-*3*9TI)@@&@@@@\ aAH 0+ ** *+* *+*9 !=+>6b+:#:**674:*6**=*I* B* +74*)*:62+IY < *-d aAHW:>4*+26**+26+2*I +H*'***+ *+*'***+ *+*25K H!Hc* \* +PM*B*N6---2--2+S -2+ҧI "!5!aA\HE.* ** ** *I aAH* *+,-* *+,-**3*3*3+1**,*9T-*9*S*3+0**,*9T-*9*SI   H`<=+5+2N*-*6-#*6-I!HM*(+ ** *+* *+*: !*3+#M**,6+4N-*6*+3*9*,*-[*T*p+F* ?* +§41*&*N6--2+I!= ,aAH* aAH o*(* *+* *+*DF&PiDDDSDD???DDDD@@@@@@,qccDDDDDDDDDDDDDDDDDDDDDD* * ** Ķř* +** ǵ *p+**p2 *( Ըʿ** *˙**+* ̵ **}* ͚* ͙^** *˙"**+* ̵ ***1*( * *(* *(*( ոʿ*˙;** * *ε **+* ̵ ****(** *(** ** * *ε \* *˙"**+* ̵ ***0*( * *(* *(*( ָʿ*ϙ6*+M, *ѧ,ř * ****(9**  * *N**ҧ@*(6**  * **** )*+* *=*>*+Ч:*+Ч:?; *ѧ*řř**Zՙ!՚***)*( * *( * * G*=*>*+Ч:*+Ч:?; *ѧ*Ś ř**Y՚ ՙ***)*( * *( * * t*ϙ#**+жՙ** * * 1*ϙ-*+M, *ѧ*,ř**( * * ** *+* * *( ׸ʿ* *( ׸ʿ*** ׵ z*˚ *ϙf**+ص **P*( * **+ٵ 1*M*N,(-( ٸʿ,( , ,- -( - -, , - * , ڙ!- ڙ*, - Fε , ͙- ͙ * , - s-"*-, Z -- * ۵ W,"*,- Z ,, * ۵ 0Y, mSY- mSݿ*, I^g)ag +1>+ \g\g @@Tgg@@PCggYg Kg  ! '1&! aAHU *(*( ۸ʿ*ϙ2*+M, *ѧ*,ř**,*(* *( * **=*+ ܧN* d* d6*+-*ߙ*****%**Y *'**** ͚666**666%**666 Y *':Y *': >9*: *Y *Y  **upY*: Y* : *Y***M****Y  **VQY*: *Y***M**** **InKg  @@!+ $@@ cvRgaAH*4*(** ***M,>*(,2( ݸʿ,2: 6)* * * * 64,2:(  +Ä̧^* 6*  * 64,2:(  +Ä** d6#,2˚** *j*Y6S*2+:* :*  ܸ:*W:AI#Qg'* *Sg=gAaArHz_*Y 8:QYYYYYY8*3*3*I <@}HB,)''''''I(cHJ3****3**347"I cH-*3*347"I H)*3*347I cH/*3*347!"I cHD.*$*3**34*9:$"*IcH;&**3*34*9:$"I$H*9H*H*GHn3***(* *  I)UW\Ha<*<9!3-'<<<< **M***,I (aAH* H5*+N- * --۰I aAH  **,N:*#"#*Z(2<LLLLLLLLLL,,,,*+, ,2N,* *+:s,2:h,* *+N ,2N*+, ,2:+,M*+,2N*+,2:* #fp d!d"=>F-* +-* **԰--Ķř ԰--ĶřĶř ԧ-ՙ԰ՙ ԧ- ԧ :*(* *+- :*+*+-*&*p+: ԰*+ ԰-N-Ķ6 2 2:* ۰-* N* ::  -S S * +,*+*!* *+-*+-- -* N* :*W $/:EP-*  -*  -*  -*  - *+IF *? ggggG G ggggBB B B   +BBF ' ! ' aAH?*(i,Y** *M*  *+N,+-,,N-N-*+-2S-*+-2S-,N-N-*+-2S*-*+S-,N-N*-*+S-*+-2S-* +,,I(,G    aAHm*n  !=>FK* *3*92M* * Y*.*N-* +*p+* *+* * *+а+*+* ***+M,ՙ*+* ̰*+* ̰Y*+* SY*+* SMN**+* M**+* N*s : D NXbGh,-*  ,-*  ,-*  ,-*  ,- * *+аI8L\""=  aAH *+жլaAH7*"dO԰* *+M,,ř ԰*+N-*+:-řř ԧ*+ж>԰*+жՙ ԧ*+ ԧ*+ N*(* *+-*+ :*+*+*+ط*+* +:İ* *4*&*  * ڙ*+M,İje*!* *+*+ط*+M*+N,-K*3?*32**3,԰*3-*+,-Iy&  BBBB"  2NgaAH8* 6* * B* ڙ'* ڙ* * *6,M-N+ !,-"6*'E6cTr ԧ ԧ ԧ ԧ ԧ ԧ(ʿI/K : B B B B B BaAHQ,*,* MN*(*  ,ܸM*,# ԧ*>62*2+* :+ !,* "԰β*h,*$.MN* *+%*&+,'( ԧN**+)-eAAI/SAB.[ABaAHd@**+ ԰*p+M, ԰IBBaAHiB,*N-6-+%*+,-*: -+)I@ aAHa-+6-&:++:,:*4 !,*-.6T*M'//>>+԰ ԧ ԧ,*-M*"+,':( ԧ+/: 02:  02: + !, *-"6 + !, *-"6 *qD5Sb!  ԰ ԧ ԧ ԧ ԧ԰,*-.6U*N(00??,԰ ԧ ԧ,*-M* *K+,':*#(-+1 ԧ( ԰+/: 02:  02: ,*-M+ !, *-"6 + !, *-"6 *tG8Ve$  ԰ ԧ ԧ ԧ ԧI#DDg? B B2BjgB B B B Bg@ B B /BB|g B B B B BgaAH**+2**+3**+3d*[*R*J*B*9*0*'*** *"I d@HbV4Y5N--YԷ'S-6-6Y+7SY,:-8-*9W-aAMH*+MH*+H*H*+ 4rH*(rH*{L{{{{{{{{Yaaaaa*(*ˬ*˙*˙IP @@rH*"*˙*˙*ˬ*Ϭ*ϙ*ϙI @@MHE9*+*+*+::*+*+;;*+<<*+HV+:N*-& *-=*->*-?:*-@*:*+A;*+B<*+I+9dVdVcHb:*C1* ** d * DC** EC*CI] \HYFYGF YHSYISYJSYKSYLSYMSYNSYOSYPSQWGYRSYSSYTSQWUUXVW