=j*org/idempiere/test/base/AcessSQLParserTest#org/idempiere/test/AbstractTestCase()VCode  LineNumberTableLocalVariableTablethis,Lorg/idempiere/test/base/AcessSQLParserTest; testOneTableRuntimeVisibleAnnotationsLorg/junit/jupiter/api/Test;>SELECT AD_Table_ID, TableName FROM AD_Table WHERE IsActive='Y'"org/compiere/model/AccessSqlParser  (Ljava/lang/String;)VAccessSqlParser[AD_Table|0]  toString()Ljava/lang/String; !  org/junit/jupiter/api/Assertions "# assertEquals'(Ljava/lang/Object;Ljava/lang/Object;)VsqlLjava/lang/String;fixture$Lorg/compiere/model/AccessSqlParser;testOneTableSyn*FSELECT t.AD_Table_ID, t.TableName FROM AD_Table t WHERE t.IsActive='Y',AccessSqlParser[AD_Table=t|0]testOneTableSynAS/ISELECT t.AD_Table_ID, t.TableName FROM AD_Table AS t WHERE t.IsActive='Y' testTwoTable2SELECT t.AD_Table_ID, t.TableName, c.AD_Column_ID, c.ColumnName FROM AD_Table t, AD_Column c WHERE t.AD_Table_ID=c.AD_Table_ID AND t.IsActive='Y'4)AccessSqlParser[AD_Table=t,AD_Column=c|0]testTwoTableSyn7SELECT t.AD_Table_ID, t.TableName, c.AD_Column_ID, c.ColumnName FROM AD_Table as t, AD_Column AS c WHERE t.AD_Table_ID=c.AD_Table_ID AND t.IsActive='Y' testJoinInner:SELECT t.AD_Table_ID, t.TableName, c.AD_Column_ID, c.ColumnName FROM AD_Table t INNER JOIN AD_Column c ON (t.AD_Table_ID=c.AD_Table_ID) WHERE t.IsActive='Y' testJoinOuter=SELECT t.AD_Table_ID, t.TableName, c.AD_Column_ID, c.ColumnName FROM AD_Table t LEFT OUTER JOIN AD_Column c ON (t.AD_Table_ID=c.AD_Table_ID) WHERE t.IsActive='Y' testExists@SELECT AD_Table.AD_Table_ID, AD_Table.TableName FROM AD_Table WHERE EXISTS (SELECT * FROM AD_Column c WHERE AD_Table.AD_Table_ID=c.AD_Table_ID)B'AccessSqlParser[AD_Column=c|AD_Table|1] testExistsSynE|SELECT t.AD_Table_ID, t.TableName FROM AD_Table t WHERE EXISTS (SELECT * FROM AD_Column c WHERE t.AD_Table_ID=c.AD_Table_ID)G)AccessSqlParser[AD_Column=c|AD_Table=t|1]testEmbeddedSelectJSELECT t.AD_Table_ID, t.TableName,(SELECT COUNT(c.ColumnName) FROM AD_Column c WHERE t.AD_Table_ID=c.AD_Table_ID) FROM AD_Table t WHERE t.IsActive='Y'testEmbeddedFromMSELECT t.AD_Table_ID, t.TableName, cc.CCount FROM AD_Table t,(SELECT COUNT(ColumnName) AS CCount FROM AD_Column) cc WHERE t.IsActive='Y'O/AccessSqlParser[AD_Column|AD_Table=t,(##)=cc|1]!testProductInstanceAttributeQueryRSELECT p.M_Product_ID, p.Discontinued, p.Value, p.Name, BOM_Qty_Available(p.M_Product_ID,?) AS QtyAvailable, bomQtyList(p.M_Product_ID, pr.M_PriceList_Version_ID) AS PriceList, bomQtyStd(p.M_Product_ID, pr.M_PriceList_Version_ID) AS PriceStd, BOM_Qty_OnHand(p.M_Product_ID,?) AS QtyOnHand, BOM_Qty_Reserved(p.M_Product_ID,?) AS QtyReserved, BOM_Qty_Ordered(p.M_Product_ID,?) AS QtyOrdered, bomQtyStd(p.M_Product_ID, pr.M_PriceList_Version_ID)-bomQtyLimit(p.M_Product_ID, pr.M_PriceList_Version_ID) AS Margin, bomQtyLimit(p.M_Product_ID, pr.M_PriceList_Version_ID) AS PriceLimit, pa.IsInstanceAttribute FROM M_Product p INNER JOIN M_ProductPrice pr ON (p.M_Product_ID=pr.M_Product_ID) LEFT OUTER JOIN M_AttributeSet pa ON (p.M_AttributeSet_ID=pa.M_AttributeSet_ID) WHERE p.IsSummary='N' AND p.IsActive='Y' AND pr.IsActive='Y' AND pr.M_PriceList_Version_ID=? AND EXISTS (SELECT * FROM M_StorageOnHand s INNER JOIN M_AttributeSetInstance asi ON (s.M_AttributeSetInstance_ID=asi.M_AttributeSetInstance_ID) WHERE s.M_Product_ID=p.M_Product_ID AND asi.SerNo LIKE '33' AND asi.Lot LIKE '33' AND asi.M_Lot_ID=101 AND TRUNC(asi.GuaranteeDate) ?@  $% &'0`1LY+M3, HI JK  $% &'5`6LY+M3, ST UV  $% &'8`9LY+M3, ^` ab  $% &';``?LY+MA, vy z{  $% &'C`DLY+MF,    $% &'H`ILY+MF,    $% &'K`LLY+MN,    $% &'P`QLY+MS,    $% &'U`VLY+MX,    $% &'Z+[LY+M],_LY+Ma, &  !* + ($% &'cPYdLf+    &'hi