2   ! " # $ % & ' ( ) *+ , - ./ 20 .1 223 4 5 26 *7 *8 9: ;< = *> *? *@ A *BCDE *FG &H I &J HK &L &MN 9O PQ RS 2T HU V HW X (Y (Z [\ ;] ;^ _ ;` 2a bc 2d &e &f g hi H *jk *lm no Hpq *r *s t u (v Hwx X Xyz *{| 9} H~ * " * H . *  * * (    u   H H H H   H H H  H  H H H      ( ( ( (  ( (   ( H  (  ( X    X  (  `  ( ( ( u 2 2 (   ( ( ( ( . P  u     O (    (    (     ( (   9 4 ( ( ( ( ( (       (   (           (   ( (   *  (! " (# 9$%  # .&  '  ( () * R+ (, (- ./ 0123456 P7 (8 (9:;< (=>?@ AB CD E F *G *H *v *IJ *K L `M N &O P Q RS .T U V 6W X 6Y 2Z [ 2\ 2] ^ 6_ 6` Pa 6b ucd 2e u>f bgh 6i jk O Olm Rno Rpqrstuvwxyz `{ `|}~databaseLorg/hsqldb/Database; tokenizerLorg/hsqldb/Tokenizer;sessionLorg/hsqldb/Session;sSchemaLjava/lang/String;sTablesToken wasQuotedZoDataLjava/lang/Object;iTypeIiToken compilingView subQueryLevel subQueryListLorg/hsqldb/lib/HsqlArrayList;simpleFunctionsLorg/hsqldb/lib/HashMap;tokenSet Lorg/hsqldb/lib/IntValueHashMap; parameters noParameters[Lorg/hsqldb/Expression; noSubqueries[Lorg/hsqldb/SubQuery;B(Lorg/hsqldb/Session;Lorg/hsqldb/Database;Lorg/hsqldb/Tokenizer;)VCodesetCompilingView()VisCompilingView()Zreset(Ljava/lang/String;)VcheckTableWriteAccess(Lorg/hsqldb/Table;I)V StackMapTable ExceptionsgetColumnNames^(Lorg/hsqldb/Database;Lorg/hsqldb/Table;Lorg/hsqldb/Tokenizer;Z)Lorg/hsqldb/lib/HsqlArrayList; parseSubqueryHsqlName InnerClasses@(I[Lorg/hsqldb/HsqlNameManager$HsqlName;ZI)Lorg/hsqldb/SubQuery;getViewSubquery((Lorg/hsqldb/View;)Lorg/hsqldb/SubQuery; parseSelect(IZZZZ)Lorg/hsqldb/Select; parseUnion(Ljava/lang/String;)I parseLimit)(Ljava/lang/String;Lorg/hsqldb/Select;Z)V parseOrderBy4(Lorg/hsqldb/Select;Lorg/hsqldb/lib/HsqlArrayList;)VresolveSelectTableFilterR(Lorg/hsqldb/Select;Lorg/hsqldb/lib/HsqlArrayList;Lorg/hsqldb/lib/HsqlArrayList;)VaddFilterColumns:(Lorg/hsqldb/TableFilter;Lorg/hsqldb/lib/HsqlArrayList;I)IresolveOrderByExpressiona(Lorg/hsqldb/Expression;Lorg/hsqldb/Select;Lorg/hsqldb/lib/HsqlArrayList;)Lorg/hsqldb/Expression;resolveOrderByColumnIndexO(Lorg/hsqldb/Expression;Lorg/hsqldb/lib/HsqlArrayList;I)Lorg/hsqldb/Expression;parseSimpleTableFilter(I)Lorg/hsqldb/TableFilter;parseTableFilter(Z)Lorg/hsqldb/TableFilter; addConditionG(Lorg/hsqldb/Expression;Lorg/hsqldb/Expression;)Lorg/hsqldb/Expression;addJoinCondition`(Lorg/hsqldb/Expression;Lorg/hsqldb/Expression;Lorg/hsqldb/TableFilter;Z)Lorg/hsqldb/Expression;parseExpression()Lorg/hsqldb/Expression; readAggregatereadOrreadAnd readConditionparseLikePredicate0(Lorg/hsqldb/Expression;)Lorg/hsqldb/Expression;parseBetweenPredicateparseInPredicateparseAllAnyPredicatereadThis(I)V readConcatreadSum readFactorreadTermreadCaseExpression parseCaseWhenreadCaseWhenExpressionreadCastExpressionreadColumnExpressionreadConcatExpressionreadNullIfExpressionreadCoalesceExpressionreadExtractExpressionreadPositionExpressionreadSubstringExpressionreadSequenceExpressionreadTrimExpressionreadDefaultClause(I)Lorg/hsqldb/Expression;read readToken getParameters()[Lorg/hsqldb/Expression;clearParameters setAsView(Lorg/hsqldb/View;)VgetSortedSubqueries()[Lorg/hsqldb/SubQuery;compileCallStatement ()Lorg/hsqldb/CompiledStatement;compileDeleteStatementgetInsertColumnValueExpressions.(Lorg/hsqldb/Table;[Lorg/hsqldb/Expression;I)VcompileInsertStatementcompileSelectStatement!(I)Lorg/hsqldb/CompiledStatement;compileUpdateStatementparseOpenBracketsSelect()IparseOpenBracketsparseCloseBrackets(I)IparseColumnList!()Lorg/hsqldb/lib/HashMappedList;processColumnList8(Lorg/hsqldb/Tokenizer;Z)Lorg/hsqldb/lib/HashMappedList; org/hsqldb/lib/HsqlArrayList                org/hsqldb/Trace             org/hsqldb/Token,) org/hsqldb/SubQueryorg/hsqldb/Expression     SYSTEM_SUBQUERY   org/hsqldb/Table        java/lang/StringBuilderCOL_          org/hsqldb/Select LIMIT TOP DISTINCT ALL      org/hsqldb/lib/IntKeyHashMap AS INTO       FROM   INNERJOIN   CROSSLEFTOUTER  ON   RIGHT  org/hsqldb/TableFilter  WHERE  GROUPBY HAVING  ORDER       ( SELECT      !  OFFSETorg/hsqldb/Types" #$ % & ' ()java/lang/Integer * + , - DESC .ASC / 0 1  23 456 78 9 :java/lang/StringBuffer ; < => ?@ AB CD EF G HI J %  K L M N O EP  Q org/hsqldb/UserManagerorg/hsqldb/View  R  ST    U>   V W     XYESCAPE (Zjava/lang/Stringjava/lang/Character [\ ] ^_` a b c d e f    g h  i   j           kY   lm n o pY # qY r  s t org/hsqldb/Function  u vw x  ! ym z{| } POSITIONorg.hsqldb.Library.position SUBSTRINGorg.hsqldb.Library.substringVALUEFOR ~  {BOTH LEADING >TRAILINGTRIMorg.hsqldb.Library.trim    Y   *        org/hsqldb/CompiledStatement               P  SET = [I  org/hsqldb/lib/HashMappedList org/hsqldb/lib/HashMap CURRENT_DATEorg.hsqldb.Library.curdate  CURRENT_TIMEorg.hsqldb.Library.curtimeCURRENT_TIMESTAMPorg.hsqldb.Library.now CURRENT_USERorg.hsqldb.Library.userSYSDATENOWTODAYorg/hsqldb/lib/IntValueHashMap  !=<><><=>=ANDNOTORANYINEXISTSBETWEEN+-/||LIKECOUNTSUMMINMAXAVGEVERYSOME STDDEV_POP STDDEV_SAMPVAR_POPVAR_SAMPIFNULLNVLNULLIFCONVERTCASTNEXTCASEWHENTHENELSEENDCASEWHENCOALESCEEXTRACTIS?org/hsqldb/Parserjava/lang/Objectorg/hsqldb/HsqlException#org/hsqldb/HsqlNameManager$HsqlName&[Lorg/hsqldb/HsqlNameManager$HsqlName;[Lorg/hsqldb/TableFilter;org/hsqldb/lib/Iterator[Zorg/hsqldb/Tokenizerclearorg/hsqldb/SessioncheckReadWritegetName'()Lorg/hsqldb/HsqlNameManager$HsqlName;check)(Lorg/hsqldb/HsqlNameManager$HsqlName;I)VisViewnameerror/(ILjava/lang/Object;)Lorg/hsqldb/HsqlException;checkDataReadOnly getSimpleName()Ljava/lang/String;wasQuotedIdentifierorg/hsqldb/Database nameManagerLorg/hsqldb/HsqlNameManager;org/hsqldb/HsqlNameManager newHsqlName:(Ljava/lang/String;Z)Lorg/hsqldb/HsqlNameManager$HsqlName;add(Ljava/lang/Object;)Z wasLongNamegetLongNameFirstequalsgetSimpleTokenthrowUnexpectedlevel resolveAll(Lorg/hsqldb/Session;Z)ZselectLorg/hsqldb/Select; isResolved schemaManagerLorg/hsqldb/SchemaManager;org/hsqldb/SchemaManagerSYSTEM_SCHEMA_HSQLNAME%Lorg/hsqldb/HsqlNameManager$HsqlName;schema>(Lorg/hsqldb/Database;Lorg/hsqldb/HsqlNameManager$HsqlName;I)V iResultLen(I)Lorg/hsqldb/HsqlException; exprColumns isNameQuotedsetAlias(Ljava/lang/String;Z)VgetAliaslengthappend-(Ljava/lang/String;)Ljava/lang/StringBuilder;valueOf(I)Ljava/lang/String;toString addColumns(Lorg/hsqldb/Select;)Vorg/hsqldb/lib/ArrayUtil fillSequence([I)VcreatePrimaryKeytableLorg/hsqldb/Table; uniqueRows viewSubQueryLorg/hsqldb/SubQuery;viewSubqueries getStringwasThis(Ljava/lang/String;)ZisDistinctSelectback getPositiongetTypeasteriskPositionsLorg/hsqldb/lib/IntKeyHashMap;put'(ILjava/lang/Object;)Ljava/lang/Object; wasSimpleNamegetDefaultTableTypeintoTypewasSimpleTokengetwasName sIntoTablegetSchemaHsqlName9(Ljava/lang/String;)Lorg/hsqldb/HsqlNameManager$HsqlName; matchThisgetThis&(Ljava/lang/String;)Ljava/lang/String; isGetThis checkTables!(Lorg/hsqldb/lib/HsqlArrayList;)VaddAll(Lorg/hsqldb/lib/Collection;)Z(I)Ljava/lang/Object; isOuterJoinqueryConditionLorg/hsqldb/Expression; iGroupLen iHavingLenhavingCondition unionDepth iOrderLenlimitCondition unionType unionSelect sortUnion prepareUnionssizetoArray&(Ljava/lang/Object;)Ljava/lang/Object;org/hsqldb/store/ValuePoolgetInt(I)Ljava/lang/Integer;(ILjava/lang/Object;)VisParam getDataTypegetValue((Lorg/hsqldb/Session;)Ljava/lang/Object;intValue setDataType2(ILorg/hsqldb/Expression;Lorg/hsqldb/Expression;)V(II)Lorg/hsqldb/HsqlException; setDescendingtFilterremove getTableNamefindTableFilter3([Lorg/hsqldb/TableFilter;)Lorg/hsqldb/TableFilter;keySet()Lorg/hsqldb/lib/Set;org/hsqldb/lib/Setiterator()Lorg/hsqldb/lib/Iterator;hasNextnextInt getColumnDDL,(Ljava/lang/String;)Ljava/lang/StringBuffer;doAssert(Z)V getFilter()Lorg/hsqldb/TableFilter; resolveTables(Lorg/hsqldb/TableFilter;)V resolveTypes(Lorg/hsqldb/Session;)VgetTable()Lorg/hsqldb/Table;getColumnCount getColumn(I)Lorg/hsqldb/Column;.(Lorg/hsqldb/TableFilter;Lorg/hsqldb/Column;)V getColumnNamegetDefinedAliasgetFilterTableNamejoinedTableColumnIndex getSchemaNameL(Lorg/hsqldb/Session;Ljava/lang/String;Ljava/lang/String;)Lorg/hsqldb/Table;G(Lorg/hsqldb/Table;Ljava/lang/String;Lorg/hsqldb/lib/HashMappedList;Z)V viewSelect setForJoin(Lorg/hsqldb/TableFilter;Z)ZsetDistinctAggregate(ZI)V(Lorg/hsqldb/SubQuery;)V isCompare(I)Z)(Lorg/hsqldb/Session;I)Ljava/lang/Object;charAt(I)C(C)V collationLorg/hsqldb/Collation;org/hsqldb/CollationG(Lorg/hsqldb/Expression;Lorg/hsqldb/Expression;Ljava/lang/Character;Z)VgetArggetArg2exprType valueData([Lorg/hsqldb/Expression;)V getMessage(ZILjava/lang/Object;)V(ILjava/lang/Object;Z)V9(Ljava/lang/String;Ljava/lang/String;Ljava/lang/String;)V isAggregatesetRightExpression(Lorg/hsqldb/Expression;)VgetRightExpression getTypeNracceptsPrecisionCreateParamacceptsScaleCreateParam(Lorg/hsqldb/Expression;III)V((Ljava/lang/String;Ljava/lang/String;Z)V getJavaName getArgCount setArgument(ILorg/hsqldb/Expression;)V(Lorg/hsqldb/Function;)VsetLeftExpressionSQL_EXTRACT_FIELD_NAMESLorg/hsqldb/lib/HashSet;org/hsqldb/lib/HashSetcontains getSequenceA(Ljava/lang/String;Ljava/lang/String;)Lorg/hsqldb/NumberSequence;(Lorg/hsqldb/NumberSequence;)VSQL_TRIM_SPECIFICATIONorg/hsqldb/Column convertObject'(Ljava/lang/Object;I)Ljava/lang/Object;java/util/LocaleENGLISHLjava/util/Locale; toUpperCase&(Ljava/util/Locale;)Ljava/lang/String;isDatetimeTypewasValue getAsValue()Ljava/lang/Object;getLongNamePre wasParameter(Ljava/lang/Object;I)IviewLorg/hsqldb/View;sort$(Lorg/hsqldb/lib/ObjectComparator;)V currentSchema(Lorg/hsqldb/Session;Lorg/hsqldb/Database;Lorg/hsqldb/HsqlNameManager$HsqlName;Lorg/hsqldb/Expression;[Lorg/hsqldb/SubQuery;[Lorg/hsqldb/Expression;)V(Lorg/hsqldb/Session;Lorg/hsqldb/Database;Lorg/hsqldb/HsqlNameManager$HsqlName;Lorg/hsqldb/TableFilter;Lorg/hsqldb/Expression;[Lorg/hsqldb/SubQuery;[Lorg/hsqldb/Expression;)V getColumnMap()[IgetNewColumnCheckList()[Z getColumnNr(Lorg/hsqldb/HsqlNameManager$HsqlName;Lorg/hsqldb/Table;[I[Lorg/hsqldb/Expression;[Z[Lorg/hsqldb/SubQuery;[Lorg/hsqldb/Expression;)V(Lorg/hsqldb/Session;Lorg/hsqldb/Database;Lorg/hsqldb/HsqlNameManager$HsqlName;Lorg/hsqldb/Table;[I[ZLorg/hsqldb/Select;[Lorg/hsqldb/SubQuery;[Lorg/hsqldb/Expression;)V findUserTable(Lorg/hsqldb/Session;Lorg/hsqldb/Database;Lorg/hsqldb/HsqlNameManager$HsqlName;Lorg/hsqldb/Select;[Lorg/hsqldb/SubQuery;[Lorg/hsqldb/Expression;)V filterTablegetNewColumnMap resizeArray(Lorg/hsqldb/Session;Lorg/hsqldb/Database;Lorg/hsqldb/HsqlNameManager$HsqlName;Lorg/hsqldb/TableFilter;[I[Lorg/hsqldb/Expression;Lorg/hsqldb/Expression;[Lorg/hsqldb/SubQuery;[Lorg/hsqldb/Expression;)V'(Ljava/lang/Object;Ljava/lang/Object;)Z8(Ljava/lang/Object;Ljava/lang/Object;)Ljava/lang/Object;(Ljava/lang/Object;I)Z  B6***Y*Y*,*-*+* * 7+* * * *+ ***A,**++7++'Y:',:,6*:W/,W,,+ ,,!:# $  ,% '+ 3Ż&Y':*Y`s g6gs 6 !6*): ***Yd *+6  , -*.:  */W012Y* 3: ,C, 456   4$, 2: 6 278 اY6   4L 6 29: :,;Y<=> `?>@: 6 28   A !6 :  4 :B C D E*W\!&@@@~ &H2*#("@LD&+FM>+G*+G2W, &"HYI:*J:-*KL*ML*N*J:*OL P*QL *RY:*S6 *T: *U. V$WXYYWW  ZW*J:*[L" **8*J:$*\ *8*J: W*#LY] 6 *J:*^_*`jaQ.,6HG5H>_"___6  *:*b *%**cc**d1*J:*ef: Y:  *gW*J:6 *hL*ijWi: *kL*ijWi:6 l V*L*mnW*ijW*g:   W*ojW*T:   p   q: r *u*mnW*ijW*g: Y:   W  sW :  tuv*ojW*T: p  tuq: h*iL8 *gW L*ojW*T:   p  q: '*#L *gW *Rr* w*J:*xL*T:   y: *J: z*{L=*|jW6 *T:  W*J: *#L }*~L&*T*J:WH*L*|jW**J:*KL*N*J:6 %$ 6 *d`d<*J:  66 6  . )5  F5  5*6G6*n6*``<*jW*)*J:_VN*L$*|jW**J:*KL*N*J:*R6(66W3H3( 3 p H  6((\@ 6,. &( @ @.! 4=*`+azNks\,7k*!L+Q =;+O =-=*R!*OnW=*OnW= < :,:6:+K 06**:*  **:*RH+K **:*:6*R!+M **:*R(Y:-VtkbS-VB90!,(Y 6E 5(( H(%H((11 Be6*T:+,:*JN- *JN- *JN,W-# *R+/H(%-u:-W+,66G,t(:V ,W,6:6 +6  * 2,6,6 *:  * ,6,6*U6 +W:  s 6 +W YY:  60,t(: Wd  #W+W  ZW6  )626,t(:*+4~; H(!u--H(  lG+:661(Y+:*U +,2$( E+4>+6*V *,*V F5**:*:66g,t(:  :  :  :  :   &     F*p @ (HA(H( (H  P;*0*>+dt(:dF55sM*N**:*/*-:**JN-[ *M*\-M *RuY,ðP2nMN::*n/*6*jW*N*$jW-DM_*:**:*/*M*,, *,ƶN-,ƴȵ,-DM:*J:* *%l r * *Rm[ 2*(*:*nD*R*:4*\#:*n*R*: *R,ʟ5uY,ð( B2&O[8) .*++*(Y*+ *+,˚ @5*+y**L*R+<=*>**J:O <Q = *R*e*:*f"/01 2 ȸ5(Y:%(G,*L**=+N*(Y-*зL+ ($G,*L**=+N*(Y-*ѷL+ ($*ͫ3*<*(Y**<**e=*e*``=**g *N(Y-:**fλ(Y*L*m^** =*=**  *(Y"+(YL(Y+L+=* =**ͫ>#5j,*+LF*+L=*+L4 *͸ؙ*>*(Y+*Է+(Y+L+. & @.#(@,&@%**MN* ٶ T**:V* : : YݷN*ߴ6(Y+,-L+.((@" @p*(Y+*ԷM*λ(Y+*ԷN,, -- (Y,- F(( *=**eN6*e*``6**g7*:,4һ(YN*o*RY:*T: O5W**h(:(YN*fλ(Y+-( ,($&@$(*<**eM>*e*``>**g J5*:,:,4һ(YM**fλ(Y,)( &H@.* * @E**L*=+N*(Y-*L+ ("[9*L*d  =*  =+N*(Y-*L+( Q5*L* **=+N*(Y-*L+ (5L*ͫ8 O  !<=>?@ABCDEGdegjk*L3*=*(Y*L+Ըҧ**L+Ը**L*f  * *(Y** L*(YL*+W**gM(Y,L*q*Li(Y** ۷L*N***********͸* * +)($@@ n><MN**n*N:*-:, M :*n*p*p*:*q,((((mR*n+ *M(Y+*̷M*o*N(YF-(Y:(Y>,: (UI*<M**e*M*h*N*hλ(YF-*̷N(Y,-M*f,*=<**e*M *hΧ *z* >666A*n5*66*#n *6*$jW5 A5]! 6 A5,,(Y,M**f,$ @(K(  * L(Y* +*M**ek*+N Y+- :*-  66**f$*̶ *h **fλ(YM(+N- Y+- :(YM,-W( ($<0*<**e*M*hλ(Y,*̷M*f,XL**e*L*hλ(YF(Y+M(Y+*̷L(Y>+,L*f+}L**eM*N,*f*f,-P(Y"-:(YF(Y-:(Y>:+ L ,M*hΧ+.(((:((( ((qW**e* L+  * **|λ Y+*+ M,*̶ *fλ(Y,#L@**eλ Y L+* *+*̶ *fλ(Y+<**eλ Y M,* *| *|Χ *h<,*̶ N*{*{*N*h*h*N,- *fλ(Y,6 %(YM*jW*jW*L*M*,M*JW*/+,N(Y-**e* L+ *L* :* M*M*|λ(Y,N+ (Y!:(Y!:1+" (Y!:(Y!:(Y!Y:: Y#$ :*̶ -   *fλ(Y  0( ((M**ͫ" O* N-: Y- :(Y*>**x** % (Y(Y* * &'N-:( Y- :(Y** % (Y* .* ,(,29**J ***)!**** **+*\** *7**,** * - * ͧM*ͧE*. * ͧ2* : *lͧ*/* 0* *l*ͪ * *lͱ >5'**J */* 0ͱG.* 1**(L*+S*H,=*!*t&N-2-+2ڱ "  R=*3**t&4*&L*+W*+  7+*5*TL6Y***7+*8*9:M,  | [M*5*ejW*;N*JL+x *TM *R6Y***7-,*8*9<:/(ui*jW6T*T:*,S*!:# $ d*%5 6(  *5*]jW*:**:*/*:*LM=N6*6*J:~*Lr6*R**>L+5+6?M N6  $+ t۶@6 -  O, T *!:*` *%a6  g#9U(: * A6Y*7- ,*8*9B:  *`6*jW*):  456Y***7-, *8*9C:   8 L2' +1H(f*5*)M,c2,cN,c1:*/*-D -6Y***7,*8*9EN-DH p *5*;:FM*GjW,HN-(:6L,*@6 *:  I 5*JjW*T:-5- OS*!L+# :+x *T: *R-KLNK:6Y***7-*8*9M:  h. 2Lu- 2L(u5 2L((u*<*jW/<*n 4=*$n  *NiOYPM*jW*N,-Q6 -*!N- - *!N-# -$   -,O =1RYSTUVWWXVWYZVW[\VW]UVW^ZVW_UVW`Y%a//#hbW/JbW/cbW/dbW/ebW/fbW/gbW/hbW/ibW/jbW/kbW/Q bW/l!bW/mbW/nbW/ojbW/pdbW/q bW/- bW/rbW/sbW/ebW/$fbW/gbW/tbW/u(bW/v)bW/w*bW/x+bW/y,bW/z-bW/{.bW/|/bW/}0bW/~1bW/2bW/<bW/<bW/CbW/=bW/kbW/GbW/DbW/nbW/obW/pbW/qbW/>bW/EbW/?bW/@bW/e|bW/#AbW/BbW/{bW/[zbW/mbW/ bW(1&3 ;