[INFO] Scanning for projects...
[INFO]                                                                         
[INFO] ------------------------------------------------------------------------
[INFO] Building JSQLParser library 0.9.4
[INFO] ------------------------------------------------------------------------
[INFO] 
[INFO] --- javacc-maven-plugin:2.6:jjtree-javacc (javacc) @ jsqlparser ---
[INFO] Skipping - all parsers are up to date
[INFO] 
[INFO] --- license-maven-plugin:1.6:update-file-header (first) @ jsqlparser ---
[INFO] Will search files to update from root /home/perham/Study/Experiments/2015-10-23-ICST/LittleDarwin/Cases/JSqlParser-jsqlparser-0.9.4/src/main/java
[INFO]  - adding license header on file /home/perham/Study/Experiments/2015-10-23-ICST/LittleDarwin/Cases/JSqlParser-jsqlparser-0.9.4/src/main/java/net/sf/jsqlparser/schema/Column.java
[INFO] Scan 164 files header done in 216.985ms.
[INFO] 
 * uptodate header on 163 files.
 * add header on 1 file.
[INFO] 
[INFO] --- maven-resources-plugin:2.6:resources (default-resources) @ jsqlparser ---
[INFO] Using 'UTF-8' encoding to copy filtered resources.
[INFO] skip non existing resourceDirectory /home/perham/Study/Experiments/2015-10-23-ICST/LittleDarwin/Cases/JSqlParser-jsqlparser-0.9.4/src/main/resources
[INFO] 
[INFO] --- maven-compiler-plugin:3.3:compile (default-compile) @ jsqlparser ---
[INFO] Changes detected - recompiling the module!
[INFO] Compiling 177 source files to /home/perham/Study/Experiments/2015-10-23-ICST/LittleDarwin/Cases/JSqlParser-jsqlparser-0.9.4/target/classes
[WARNING] bootstrap class path not set in conjunction with -source 1.6
[INFO] /home/perham/Study/Experiments/2015-10-23-ICST/LittleDarwin/Cases/JSqlParser-jsqlparser-0.9.4/target/generated-sources/javacc/net/sf/jsqlparser/parser/CCJSqlParser.java: /home/perham/Study/Experiments/2015-10-23-ICST/LittleDarwin/Cases/JSqlParser-jsqlparser-0.9.4/target/generated-sources/javacc/net/sf/jsqlparser/parser/CCJSqlParser.java uses unchecked or unsafe operations.
[INFO] /home/perham/Study/Experiments/2015-10-23-ICST/LittleDarwin/Cases/JSqlParser-jsqlparser-0.9.4/target/generated-sources/javacc/net/sf/jsqlparser/parser/CCJSqlParser.java: Recompile with -Xlint:unchecked for details.
[INFO] 
[INFO] --- maven-resources-plugin:2.6:testResources (default-testResources) @ jsqlparser ---
[INFO] Using 'UTF-8' encoding to copy filtered resources.
[INFO] Copying 280 resources
[INFO] 
[INFO] --- maven-compiler-plugin:3.3:testCompile (default-testCompile) @ jsqlparser ---
[INFO] Nothing to compile - all classes are up to date
[INFO] 
[INFO] --- maven-surefire-plugin:2.10:test (default-test) @ jsqlparser ---
[INFO] Surefire report directory: /home/perham/Study/Experiments/2015-10-23-ICST/LittleDarwin/Cases/JSqlParser-jsqlparser-0.9.4/target/surefire-reports

-------------------------------------------------------
 T E S T S
-------------------------------------------------------
Running net.sf.jsqlparser.test.alter.AlterTest
Tests run: 3, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.054 sec
Running net.sf.jsqlparser.test.create.CreateTableTest
Tests run: 27, Failures: 1, Errors: 0, Skipped: 0, Time elapsed: 0.149 sec <<< FAILURE!
Running net.sf.jsqlparser.test.create.CreateIndexTest
Tests run: 6, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.001 sec
Running net.sf.jsqlparser.test.create.CreateViewTest
Tests run: 8, Failures: 1, Errors: 0, Skipped: 0, Time elapsed: 0.001 sec <<< FAILURE!
Running net.sf.jsqlparser.test.delete.DeleteTest
Tests run: 2, Failures: 1, Errors: 0, Skipped: 0, Time elapsed: 0.003 sec <<< FAILURE!
Running net.sf.jsqlparser.test.simpleparsing.CCJSqlParserManagerTest
Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.183 sec
Running net.sf.jsqlparser.test.drop.DropTest
Tests run: 2, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.001 sec
Running net.sf.jsqlparser.test.insert.InsertTest
Tests run: 15, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.036 sec
Running net.sf.jsqlparser.test.TestUtils
Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0 sec
Running net.sf.jsqlparser.test.update.UpdateTest
Tests run: 7, Failures: 2, Errors: 0, Skipped: 0, Time elapsed: 0.008 sec <<< FAILURE!
Running net.sf.jsqlparser.test.replace.ReplaceTest
Tests run: 4, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.004 sec
Running net.sf.jsqlparser.test.select.SelectASTTest
*Statement
* Column
* Column
* Table
* Column
* Column
Tests run: 2, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.004 sec
Running net.sf.jsqlparser.test.select.SpecialOracleTest
Oct 06, 2015 7:05:11 AM net.sf.jsqlparser.test.select.SpecialOracleTest testAllSqlsParseDeparse
INFO: testing string01.sql
Oct 06, 2015 7:05:11 AM net.sf.jsqlparser.test.select.SpecialOracleTest testAllSqlsParseDeparse
INFO:    -> PROBLEM net.sf.jsqlparser.JSQLParserException
Oct 06, 2015 7:05:11 AM net.sf.jsqlparser.test.select.SpecialOracleTest testAllSqlsParseDeparse
INFO: testing returning01.sql
Oct 06, 2015 7:05:11 AM net.sf.jsqlparser.test.select.SpecialOracleTest testAllSqlsParseDeparse
INFO:    -> PROBLEM net.sf.jsqlparser.JSQLParserException
Oct 06, 2015 7:05:11 AM net.sf.jsqlparser.test.select.SpecialOracleTest testAllSqlsParseDeparse
INFO: testing keywordasidentifier05.sql
Oct 06, 2015 7:05:11 AM net.sf.jsqlparser.test.select.SpecialOracleTest testAllSqlsParseDeparse
INFO:    -> SUCCESS
Oct 06, 2015 7:05:11 AM net.sf.jsqlparser.test.select.SpecialOracleTest testAllSqlsParseDeparse
INFO: testing function07.sql
Oct 06, 2015 7:05:11 AM net.sf.jsqlparser.test.select.SpecialOracleTest testAllSqlsParseDeparse
INFO:    -> PROBLEM net.sf.jsqlparser.JSQLParserException
Oct 06, 2015 7:05:11 AM net.sf.jsqlparser.test.select.SpecialOracleTest testAllSqlsParseDeparse
INFO: testing cast_multiset15.sql
Oct 06, 2015 7:05:11 AM net.sf.jsqlparser.test.select.SpecialOracleTest testAllSqlsParseDeparse
INFO:    -> PROBLEM net.sf.jsqlparser.JSQLParserException
Oct 06, 2015 7:05:11 AM net.sf.jsqlparser.test.select.SpecialOracleTest testAllSqlsParseDeparse
INFO: testing interval01.sql
Oct 06, 2015 7:05:11 AM net.sf.jsqlparser.test.select.SpecialOracleTest testAllSqlsParseDeparse
INFO:    -> PROBLEM net.sf.jsqlparser.JSQLParserException
Oct 06, 2015 7:05:11 AM net.sf.jsqlparser.test.select.SpecialOracleTest testAllSqlsParseDeparse
INFO: testing analytic_query04.sql
Oct 06, 2015 7:05:11 AM net.sf.jsqlparser.test.select.SpecialOracleTest testAllSqlsParseDeparse
INFO:    -> PROBLEM net.sf.jsqlparser.JSQLParserException
Oct 06, 2015 7:05:11 AM net.sf.jsqlparser.test.select.SpecialOracleTest testAllSqlsParseDeparse
INFO: testing join10.sql
Oct 06, 2015 7:05:11 AM net.sf.jsqlparser.test.select.SpecialOracleTest testAllSqlsParseDeparse
INFO:    -> SUCCESS
Oct 06, 2015 7:05:11 AM net.sf.jsqlparser.test.select.SpecialOracleTest testAllSqlsParseDeparse
INFO: testing pivot04.sql
Oct 06, 2015 7:05:11 AM net.sf.jsqlparser.test.select.SpecialOracleTest testAllSqlsParseDeparse
INFO:    -> PROBLEM net.sf.jsqlparser.JSQLParserException
Oct 06, 2015 7:05:11 AM net.sf.jsqlparser.test.select.SpecialOracleTest testAllSqlsParseDeparse
INFO: testing condition08.sql
Oct 06, 2015 7:05:12 AM net.sf.jsqlparser.test.select.SpecialOracleTest testAllSqlsParseDeparse
INFO:    -> PROBLEM net.sf.jsqlparser.JSQLParserException
Oct 06, 2015 7:05:12 AM net.sf.jsqlparser.test.select.SpecialOracleTest testAllSqlsParseDeparse
INFO: testing function03.sql
Oct 06, 2015 7:05:12 AM net.sf.jsqlparser.test.select.SpecialOracleTest testAllSqlsParseDeparse
INFO:    -> PROBLEM net.sf.jsqlparser.JSQLParserException
Oct 06, 2015 7:05:12 AM net.sf.jsqlparser.test.select.SpecialOracleTest testAllSqlsParseDeparse
INFO: testing merge03.sql
Oct 06, 2015 7:05:12 AM net.sf.jsqlparser.test.select.SpecialOracleTest testAllSqlsParseDeparse
INFO:    -> PROBLEM net.sf.jsqlparser.JSQLParserException
Oct 06, 2015 7:05:12 AM net.sf.jsqlparser.test.select.SpecialOracleTest testAllSqlsParseDeparse
INFO: testing insert02.sql
Oct 06, 2015 7:05:12 AM net.sf.jsqlparser.test.select.SpecialOracleTest testAllSqlsParseDeparse
INFO:    -> PROBLEM net.sf.jsqlparser.JSQLParserException
Oct 06, 2015 7:05:12 AM net.sf.jsqlparser.test.select.SpecialOracleTest testAllSqlsParseDeparse
INFO: testing insert11.sql
Oct 06, 2015 7:05:12 AM net.sf.jsqlparser.test.select.SpecialOracleTest testAllSqlsParseDeparse
INFO:    -> PROBLEM net.sf.jsqlparser.JSQLParserException
Oct 06, 2015 7:05:12 AM net.sf.jsqlparser.test.select.SpecialOracleTest testAllSqlsParseDeparse
INFO: testing interval02.sql
Oct 06, 2015 7:05:12 AM net.sf.jsqlparser.test.select.SpecialOracleTest testAllSqlsParseDeparse
INFO:    -> SUCCESS
Oct 06, 2015 7:05:12 AM net.sf.jsqlparser.test.select.SpecialOracleTest testAllSqlsParseDeparse
INFO: testing cast_multiset18.sql
Oct 06, 2015 7:05:12 AM net.sf.jsqlparser.test.select.SpecialOracleTest testAllSqlsParseDeparse
INFO:    -> PROBLEM net.sf.jsqlparser.JSQLParserException
Oct 06, 2015 7:05:12 AM net.sf.jsqlparser.test.select.SpecialOracleTest testAllSqlsParseDeparse
INFO: testing query_factoring08.sql
Oct 06, 2015 7:05:12 AM net.sf.jsqlparser.test.select.SpecialOracleTest testAllSqlsOnlyParse
INFO: testing comment02.sql
Oct 06, 2015 7:05:12 AM net.sf.jsqlparser.test.select.SpecialOracleTest testAllSqlsOnlyParse
INFO:    -> SUCCESS
Oct 06, 2015 7:05:12 AM net.sf.jsqlparser.test.select.SpecialOracleTest testAllSqlsOnlyParse
INFO: testing numbers02.sql
Oct 06, 2015 7:05:12 AM net.sf.jsqlparser.test.select.SpecialOracleTest testAllSqlsOnlyParse
INFO:    -> SUCCESS
Oct 06, 2015 7:05:12 AM net.sf.jsqlparser.test.select.SpecialOracleTest testAllSqlsOnlyParse
INFO: testing comment01.sql
Oct 06, 2015 7:05:12 AM net.sf.jsqlparser.test.select.SpecialOracleTest testAllSqlsOnlyParse
INFO:    -> SUCCESS
Tests run: 2, Failures: 1, Errors: 0, Skipped: 0, Time elapsed: 0.376 sec <<< FAILURE!
Running net.sf.jsqlparser.test.select.SelectTest
Tests run: 228, Failures: 66, Errors: 0, Skipped: 0, Time elapsed: 0.28 sec <<< FAILURE!
Running net.sf.jsqlparser.test.select.SpeedTest
42500 statements parsed in 8324 milliseconds
 (5105 statements per second,  0.0001959 seconds per statement )
38500 select scans for table name executed in 136 milliseconds
 (283088 select scans for table name per second,  0.0000035 seconds per select scans for table name)
Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 8.454 sec
Running net.sf.jsqlparser.test.truncate.TruncateTest
Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0 sec
Running net.sf.jsqlparser.util.TablesNamesFinderTest
Tests run: 19, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.013 sec
Running net.sf.jsqlparser.util.ConnectExpressionsVisitorTest
Tests run: 2, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.002 sec
Running net.sf.jsqlparser.util.AddAliasesVisitorTest
Tests run: 4, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.002 sec
Running net.sf.jsqlparser.util.SelectUtilsTest
Tests run: 6, Failures: 0, Errors: 4, Skipped: 0, Time elapsed: 0.006 sec <<< FAILURE!
Running net.sf.jsqlparser.expression.ExpressionVisitorAdapterTest
Tests run: 2, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.001 sec
Running net.sf.jsqlparser.expression.SignedExpressionTest
Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0 sec
Running net.sf.jsqlparser.schema.ServerTest
Tests run: 2, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0 sec
Running net.sf.jsqlparser.parser.CCJSqlParserUtilTest
Tests run: 3, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.001 sec
Running net.sf.jsqlparser.statement.SetStatementTest
Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.004 sec
Running net.sf.jsqlparser.statement.AdaptersTest
Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.002 sec
Running net.sf.jsqlparser.statement.StatementsTest
Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.001 sec
Running net.sf.jsqlparser.statement.execute.ExecuteTest
Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.001 sec

Results :

Failed tests:   testCreateTableAsSelect2(net.sf.jsqlparser.test.create.CreateTableTest): expected:<...M b INNER JOIN a ON [b.col1 = a.]col1> but was:<...M b INNER JOIN a ON [col1 = ]col1>
  testCreateView4(net.sf.jsqlparser.test.create.CreateViewTest): expected:<...ER JOIN testtab2 ON [testtab.col1 = testtab2.]col2> but was:<...ER JOIN testtab2 ON [col1 = ]col2>
  testDelete(net.sf.jsqlparser.test.delete.DeleteTest): expected:<... FROM mytable WHERE [mytable.]col = 9> but was:<... FROM mytable WHERE []col = 9>
  testUpdateMultiTable(net.sf.jsqlparser.test.update.UpdateTest): expected:<UPDATE T1, T2 SET [T1.C2 = T2.C2, T2.C3 = 'UPDATED' WHERE T1.C1 = T2.C1 AND T1.]C2 < 10> but was:<UPDATE T1, T2 SET [C2 = C2, C3 = 'UPDATED' WHERE C1 = C1 AND ]C2 < 10>
  testUpdateWithDeparser(net.sf.jsqlparser.test.update.UpdateTest): expected:<...ATE table1 AS A SET [A.columna = 'XXX' WHERE A.]cod_table = 'YYY'> but was:<...ATE table1 AS A SET [columna = 'XXX' WHERE ]cod_table = 'YYY'>
  testAllSqlsParseDeparse(net.sf.jsqlparser.test.select.SpecialOracleTest): expected:<...*from t2 join t3 on([t2.a2=t3.a3))select*from x1 join x2 on(x1.a1=x2.a2)join t4 on(x1.a1=t4.]a4)> but was:<...*from t2 join t3 on([a2=a3))select*from x1 join x2 on(a1=a2)join t4 on(a1=]a4)>
  testAllConditionSubSelect(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT e[1.empno, e1.sal FROM emp e1 WHERE e1.sal > ALL (SELECT e2.sal FROM emp e2 WHERE e2.]deptno = 10)> but was:<SELECT e[mpno, sal FROM emp e1 WHERE sal > ALL (SELECT sal FROM emp e2 WHERE ]deptno = 10)>
  testSelectForUpdateOfTable(net.sf.jsqlparser.test.select.SelectTest): expected:<...FROM foo, bar WHERE [foo.id = bar.]foo_id FOR UPDATE OF...> but was:<...FROM foo, bar WHERE [id = ]foo_id FOR UPDATE OF...>
  testOracleJoin2(net.sf.jsqlparser.test.select.SelectTest): expected:<...le1, tabelle2 WHERE [tabelle1.a(+) = tabelle2.]b> but was:<...le1, tabelle2 WHERE [a(+) = ]b>
  testOracleJoin3(net.sf.jsqlparser.test.select.SelectTest): expected:<...le1, tabelle2 WHERE [tabelle1.a(+) > tabelle2.]b> but was:<...le1, tabelle2 WHERE [a(+) > ]b>
  testOracleJoin4(net.sf.jsqlparser.test.select.SelectTest): expected:<...le1, tabelle2 WHERE [tabelle1.a(+) = tabelle2.b AND tabelle1.]b(+) IN ('A', 'B')> but was:<...le1, tabelle2 WHERE [a(+) = b AND ]b(+) IN ('A', 'B')>
  testOrderBy(net.sf.jsqlparser.test.select.SelectTest): expected:<[tab1.]a> but was:<[]a>
  testSelectJoinWithComma(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [cb.Genus, cb.Species FROM Coleccion_de_Briofitas AS cb, unigeoestados AS es WHERE es.nombre = "Tamaulipas" AND cb.the_geom = es.]geom> but was:<SELECT [Genus, Species FROM Coleccion_de_Briofitas AS cb, unigeoestados AS es WHERE nombre = "Tamaulipas" AND the_geom = ]geom>
  testTop(net.sf.jsqlparser.test.select.SelectTest): expected:<... FROM mytable WHERE [mytable.]col = 9> but was:<... FROM mytable WHERE []col = 9>
  testMysqlQuote(net.sf.jsqlparser.test.select.SelectTest): expected:<...ANTIQUES AS b WHERE [b.BUYERID = a.OWNERID AND b.]ITEM = 'Chair'> but was:<...ANTIQUES AS b WHERE [BUYERID = OWNERID AND ]ITEM = 'Chair'>
  testFirst(net.sf.jsqlparser.test.select.SelectTest): expected:<[alias.]columnName1> but was:<[]columnName1>
  testLimit(net.sf.jsqlparser.test.select.SelectTest): expected:<... FROM mytable WHERE [mytable.]col = 9 LIMIT ? OFFS...> but was:<... FROM mytable WHERE []col = 9 LIMIT ? OFFS...>
  testUnion(net.sf.jsqlparser.test.select.SelectTest): expected:<... FROM mytable WHERE [mytable.col = 9) UNION (SELECT * FROM mytable3 WHERE mytable3.]col = ?) UNION (SELE...> but was:<... FROM mytable WHERE [col = 9) UNION (SELECT * FROM mytable3 WHERE ]col = ?) UNION (SELE...>
  testFrom(net.sf.jsqlparser.test.select.SelectTest): expected:<...) AS mytable4 WHERE [mytable.]col = 9> but was:<...) AS mytable4 WHERE []col = 9>
  testJoin(net.sf.jsqlparser.test.select.SelectTest): expected:<[tab1.]id> but was:<[]id>
  testSkip(net.sf.jsqlparser.test.select.SelectTest): expected:<[alias.]columnName1> but was:<[]columnName1>
  testWith(net.sf.jsqlparser.test.select.SelectTest): expected:<...MPCOUNT) AS (SELECT [OTHERS.WORKDEPT, AVG(OTHERS.SALARY), COUNT(*) FROM EMPLOYEE AS OTHERS GROUP BY OTHERS.WORKDEPT), DINFOMAX AS (SELECT MAX(AVGSALARY) AS AVGMAX FROM DINFO) SELECT THIS_EMP.EMPNO, THIS_EMP.SALARY, DINFO.AVGSALARY, DINFO.EMPCOUNT, DINFOMAX.AVGMAX FROM EMPLOYEE AS THIS_EMP INNER JOIN DINFO INNER JOIN DINFOMAX WHERE THIS_EMP.JOB = 'SALESREP' AND THIS_EMP.WORKDEPT = DINFO.]DEPTNO> but was:<...MPCOUNT) AS (SELECT [WORKDEPT, AVG(SALARY), COUNT(*) FROM EMPLOYEE AS OTHERS GROUP BY WORKDEPT), DINFOMAX AS (SELECT MAX(AVGSALARY) AS AVGMAX FROM DINFO) SELECT EMPNO, SALARY, AVGSALARY, EMPCOUNT, AVGMAX FROM EMPLOYEE AS THIS_EMP INNER JOIN DINFO INNER JOIN DINFOMAX WHERE JOB = 'SALESREP' AND WORKDEPT = ]DEPTNO>
  testOracleJoin2_1(net.sf.jsqlparser.test.select.SelectTest): expected:<...lle1,tabelle2 where [tabelle1.a(+)=tabelle2.]b> but was:<...lle1,tabelle2 where [a(+)=]b>
  testOracleJoin2_2(net.sf.jsqlparser.test.select.SelectTest): expected:<...lle1,tabelle2 where [tabelle1.a=tabelle2.]b(+)> but was:<...lle1,tabelle2 where [a=]b(+)>
  testOracleJoin3_1(net.sf.jsqlparser.test.select.SelectTest): expected:<...le1, tabelle2 WHERE [tabelle1.a > tabelle2.]b(+)> but was:<...le1, tabelle2 WHERE [a > ]b(+)>
  testAnyConditionSubSelect(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT e[1.empno, e1.sal FROM emp e1 WHERE e1.sal > ANY (SELECT e2.sal FROM emp e2 WHERE e2.]deptno = 10)> but was:<SELECT e[mpno, sal FROM emp e1 WHERE sal > ANY (SELECT sal FROM emp e2 WHERE ]deptno = 10)>
  testMultiTableJoin(net.sf.jsqlparser.test.select.SelectTest): expected:<... INNER JOIN tabb ON [taba.a = tabb.a, tabc LEFT JOIN tabd ON tabc.c = tabd.]c> but was:<... INNER JOIN tabb ON [a = a, tabc LEFT JOIN tabd ON c = ]c>
  testLateral1(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT O[.ORDERID, O.CUSTNAME, OL.LINETOTAL FROM ORDERS AS O, LATERAL(SELECT SUM(NETAMT) AS LINETOTAL FROM ORDERLINES AS LINES WHERE LINES.ORDERID = O.]ORDERID) AS OL> but was:<SELECT O[RDERID, CUSTNAME, LINETOTAL FROM ORDERS AS O, LATERAL(SELECT SUM(NETAMT) AS LINETOTAL FROM ORDERLINES AS LINES WHERE ORDERID = ]ORDERID) AS OL>
  testLateralComplex1(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT O[.ORDERID, O.CUSTNAME, OL.LINETOTAL, OC.ORDCHGTOTAL, OT.TAXTOTAL FROM ORDERS O, LATERAL(SELECT SUM(NETAMT) AS LINETOTAL FROM ORDERLINES LINES WHERE LINES.ORDERID = O.ORDERID) AS OL, LATERAL(SELECT SUM(CHGAMT) AS ORDCHGTOTAL FROM ORDERCHARGES CHARGES WHERE LINES.ORDERID = O.ORDERID) AS OC, LATERAL(SELECT SUM(TAXAMT) AS TAXTOTAL FROM ORDERTAXES TAXES WHERE TAXES.ORDERID = O.]ORDERID) AS OT> but was:<SELECT O[RDERID, CUSTNAME, LINETOTAL, ORDCHGTOTAL, TAXTOTAL FROM ORDERS O, LATERAL(SELECT SUM(NETAMT) AS LINETOTAL FROM ORDERLINES LINES WHERE ORDERID = ORDERID) AS OL, LATERAL(SELECT SUM(CHGAMT) AS ORDCHGTOTAL FROM ORDERCHARGES CHARGES WHERE ORDERID = ORDERID) AS OC, LATERAL(SELECT SUM(TAXAMT) AS TAXTOTAL FROM ORDERTAXES TAXES WHERE ORDERID = ]ORDERID) AS OT>
  testConcatProblem2(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT MAX((((((S[PA.SOORTAANLEVERPERIODE)::VARCHAR (2) || (VARCHAR(SPA.AANLEVERPERIODEJAAR))::VARCHAR (4)) || TO_CHAR(SPA.AANLEVERPERIODEVOLGNR, 'FM09'::VARCHAR)) || TO_CHAR((10000 - SPA.VERSCHIJNINGSVOLGNR), 'FM0999'::VARCHAR)) || (SPA.]GESLACHT)::VARCHAR (...> but was:<SELECT MAX((((((S[OORTAANLEVERPERIODE)::VARCHAR (2) || (VARCHAR(AANLEVERPERIODEJAAR))::VARCHAR (4)) || TO_CHAR(AANLEVERPERIODEVOLGNR, 'FM09'::VARCHAR)) || TO_CHAR((10000 - VERSCHIJNINGSVOLGNR), 'FM0999'::VARCHAR)) || (]GESLACHT)::VARCHAR (...>
  testSelectItems(net.sf.jsqlparser.test.select.SelectTest): expected:<my[tab.my]col2> but was:<my[]col2>
  testSelectJoin2(net.sf.jsqlparser.test.select.SelectTest): expected:<...pg_constraint WHERE [pg_attribute.attnum = ANY(pg_constraint.]conkey)> but was:<...pg_constraint WHERE [attnum = ANY(]conkey)>
  testFirstWithKeywordLimit(net.sf.jsqlparser.test.select.SelectTest): expected:<[alias.]columnName1> but was:<[]columnName1>
  testFunctionRight(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT right([table1.]col1, 4) FROM table1> but was:<SELECT right([]col1, 4) FROM table1>
  testWithUnionProblem3(net.sf.jsqlparser.test.select.SelectTest): expected:<...SELECT mslink, CAST([tablea.fname AS varchar) FROM tablea INNER JOIN tableb ON tablea.mslink = tableb.mslink AND tableb.deleted = 0 WHERE tablea.]fname IS NULL AND 1 ...> but was:<...SELECT mslink, CAST([fname AS varchar) FROM tablea INNER JOIN tableb ON mslink = mslink AND deleted = 0 WHERE ]fname IS NULL AND 1 ...>
  testWithUnionProblem4(net.sf.jsqlparser.test.select.SelectTest): expected:<...TH hist AS ((SELECT [gl.mslink, ba.gl_name AS txt, ba.gl_nummer AS nr, 0 AS level, CAST(gl.mslink AS VARCHAR) AS path, ae.feature FROM tablea AS gl INNER JOIN tableb AS ba ON gl.mslink = ba.gl_mslink INNER JOIN tablec AS ae ON gl.mslink = ae.mslink AND ae.deleted = 0 WHERE gl.parent IS NULL AND gl.mslink <> 0) UNION ALL (SELECT gl.mslink, ba.gl_name AS txt, ba.gl_nummer AS nr, hist.level + 1 AS level, CAST(hist.path + '.' + CAST(gl.mslink AS VARCHAR) AS VARCHAR) AS path, ae.feature FROM tablea AS gl INNER JOIN tableb AS ba ON gl.mslink = ba.gl_mslink INNER JOIN tablec AS ae ON gl.mslink = ae.mslink AND ae.deleted = 0 INNER JOIN hist ON gl.parent = hist.mslink WHERE gl.mslink <> 0)) SELECT mslink, space(level * 4) + txt AS txt, nr, feature, path FROM hist WHERE EXISTS (SELECT feature FROM tablec WHERE mslink = 0 AND ((feature IN (1, 2) AND hist.feature = 3) OR (feature IN (4) AND hist.]feature = 2)))> but was:<...TH hist AS ((SELECT [mslink, gl_name AS txt, gl_nummer AS nr, 0 AS level, CAST(mslink AS VARCHAR) AS path, feature FROM tablea AS gl INNER JOIN tableb AS ba ON mslink = gl_mslink INNER JOIN tablec AS ae ON mslink = mslink AND deleted = 0 WHERE parent IS NULL AND mslink <> 0) UNION ALL (SELECT mslink, gl_name AS txt, gl_nummer AS nr, level + 1 AS level, CAST(path + '.' + CAST(mslink AS VARCHAR) AS VARCHAR) AS path, feature FROM tablea AS gl INNER JOIN tableb AS ba ON mslink = gl_mslink INNER JOIN tablec AS ae ON mslink = mslink AND deleted = 0 INNER JOIN hist ON parent = mslink WHERE mslink <> 0)) SELECT mslink, space(level * 4) + txt AS txt, nr, feature, path FROM hist WHERE EXISTS (SELECT feature FROM tablec WHERE mslink = 0 AND ((feature IN (1, 2) AND feature = 3) OR (feature IN (4) AND ]feature = 2)))>
  testWithUnionProblem5(net.sf.jsqlparser.test.select.SelectTest): expected:<...TH hist AS ((SELECT [gl.mslink, ba.gl_name AS txt, ba.gl_nummer AS nr, 0 AS level, CAST(gl.mslink AS VARCHAR) AS path, ae.feature FROM tablea AS gl INNER JOIN tableb AS ba ON gl.mslink = ba.gl_mslink INNER JOIN tablec AS ae ON gl.mslink = ae.mslink AND ae.deleted = 0 WHERE gl.parent IS NULL AND gl.mslink <> 0) UNION ALL (SELECT gl.mslink, ba.gl_name AS txt, ba.gl_nummer AS nr, hist.level + 1 AS level, CAST(hist.path + '.' + CAST(gl.mslink AS VARCHAR) AS VARCHAR) AS path, 5 AS feature FROM tablea AS gl INNER JOIN tableb AS ba ON gl.mslink = ba.gl_mslink INNER JOIN tablec AS ae ON gl.mslink = ae.mslink AND ae.deleted = 0 INNER JOIN hist ON gl.parent = hist.mslink WHERE gl.]mslink <> 0)) SELECT...> but was:<...TH hist AS ((SELECT [mslink, gl_name AS txt, gl_nummer AS nr, 0 AS level, CAST(mslink AS VARCHAR) AS path, feature FROM tablea AS gl INNER JOIN tableb AS ba ON mslink = gl_mslink INNER JOIN tablec AS ae ON mslink = mslink AND deleted = 0 WHERE parent IS NULL AND mslink <> 0) UNION ALL (SELECT mslink, gl_name AS txt, gl_nummer AS nr, level + 1 AS level, CAST(path + '.' + CAST(mslink AS VARCHAR) AS VARCHAR) AS path, 5 AS feature FROM tablea AS gl INNER JOIN tableb AS ba ON mslink = gl_mslink INNER JOIN tablec AS ae ON mslink = mslink AND deleted = 0 INNER JOIN hist ON parent = mslink WHERE ]mslink <> 0)) SELECT...>
  testGroupBy(net.sf.jsqlparser.test.select.SelectTest): expected:<[tab1.]b> but was:<[]b>
  testMultiPartColumnNameWithTableName(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [tableName.]columnName FROM tabl...> but was:<SELECT []columnName FROM tabl...>
  testLimitSqlServer1(net.sf.jsqlparser.test.select.SelectTest): expected:<... FROM mytable WHERE [mytable.col = 9 ORDER BY mytable.]id OFFSET 3 ROWS FET...> but was:<... FROM mytable WHERE [col = 9 ORDER BY ]id OFFSET 3 ROWS FET...>
  testLimitSqlServer2(net.sf.jsqlparser.test.select.SelectTest): expected:<... FROM mytable WHERE [mytable.col = 9 ORDER BY mytable.]id OFFSET 3 ROW FETC...> but was:<... FROM mytable WHERE [col = 9 ORDER BY ]id OFFSET 3 ROW FETC...>
  testLimitSqlServer3(net.sf.jsqlparser.test.select.SelectTest): expected:<... FROM mytable WHERE [mytable.col = 9 ORDER BY mytable.]id OFFSET 3 ROWS> but was:<... FROM mytable WHERE [col = 9 ORDER BY ]id OFFSET 3 ROWS>
  testLimitSqlServer4(net.sf.jsqlparser.test.select.SelectTest): expected:<... FROM mytable WHERE [mytable.col = 9 ORDER BY mytable.]id FETCH NEXT 5 ROWS...> but was:<... FROM mytable WHERE [col = 9 ORDER BY ]id FETCH NEXT 5 ROWS...>
  testConcatProblem2_1(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT TO_CHAR([SPA.]AANLEVERPERIODEVOLGN...> but was:<SELECT TO_CHAR([]AANLEVERPERIODEVOLGN...>
  testConcatProblem2_2(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT MAX((S[PA.SOORTAANLEVERPERIODE)::VARCHAR (2) || (VARCHAR(SPA.]AANLEVERPERIODEJAAR)...> but was:<SELECT MAX((S[OORTAANLEVERPERIODE)::VARCHAR (2) || (VARCHAR(]AANLEVERPERIODEJAAR)...>
  testConcatProblem2_3(net.sf.jsqlparser.test.select.SelectTest): expected:<...CT TO_CHAR((10000 - [SPA.]VERSCHIJNINGSVOLGNR)...> but was:<...CT TO_CHAR((10000 - []VERSCHIJNINGSVOLGNR)...>
  testConcatProblem2_4(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT ([SPA.]GESLACHT)::VARCHAR (...> but was:<SELECT ([]GESLACHT)::VARCHAR (...>
  testMultiPartColumnNameWithDatabaseNameAndSchemaNameAndTableName(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [databaseName.schemaName.tableName.]columnName FROM tabl...> but was:<SELECT []columnName FROM tabl...>
  testMultiPartColumnNameWithDatabaseNameAndTableName(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [databaseName..tableName.]columnName FROM tabl...> but was:<SELECT []columnName FROM tabl...>
  testMatches(net.sf.jsqlparser.test.select.SelectTest): expected:<...T * FROM team WHERE [team.]search_column @@ to_...> but was:<...T * FROM team WHERE []search_column @@ to_...>
  testAnalyticFunctionProblem1(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT last_value([s.revenue_hold) OVER (PARTITION BY s.id_d_insertion_order, s.id_d_product_ad_attr, trunc(s.date_id, 'mm') ORDER BY s.]date_id) AS col FROM...> but was:<SELECT last_value([revenue_hold) OVER (PARTITION BY id_d_insertion_order, id_d_product_ad_attr, trunc(date_id, 'mm') ORDER BY ]date_id) AS col FROM...>
  testFunctions(net.sf.jsqlparser.test.select.SelectTest): expected:<... FROM mytable WHERE [mytable.]col = 9> but was:<... FROM mytable WHERE []col = 9>
  testBrackets(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [table_a.]name AS [Test] FROM ...> but was:<SELECT []name AS [Test] FROM ...>
  testIssue154_2(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [r.id, r.uuid, r.name, r.system_role FROM role r WHERE r.merchant_id = ? AND r.deleted_time IS NULL ORDER BY r.]id DESC> but was:<SELECT [id, uuid, name, system_role FROM role r WHERE merchant_id = ? AND deleted_time IS NULL ORDER BY ]id DESC>
  testFunctionLeft(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT left([table1.]col1, 4) FROM table1> but was:<SELECT left([]col1, 4) FROM table1>
  testCharacterSetClause(net.sf.jsqlparser.test.select.SelectTest): expected:<...LECT DISTINCT CAST(`[view0`.`nick2` AS CHAR (8000) CHARACTER SET utf8) AS `v0` FROM people `view0` WHERE `view0`.]`nick2` IS NOT NULL> but was:<...LECT DISTINCT CAST(`[nick2` AS CHAR (8000) CHARACTER SET utf8) AS `v0` FROM people `view0` WHERE ]`nick2` IS NOT NULL>
  testComplexUnion1(net.sf.jsqlparser.test.select.SelectTest): expected:<... 'abc-' || coalesce([mytab.a::varchar, '') AS a, mytab.b, mytab.c AS st, mytab.d, mytab.e FROM mytab WHERE mytab.del = 0) UNION (SELECT 'cde-' || coalesce(mytab2.a::varchar, '') AS a, mytab2.b, mytab2.bezeichnung AS c, 0 AS d, 0 AS e FROM mytab2 WHERE mytab2.]del = 0)> but was:<... 'abc-' || coalesce([a::varchar, '') AS a, b, c AS st, d, e FROM mytab WHERE del = 0) UNION (SELECT 'cde-' || coalesce(a::varchar, '') AS a, b, bezeichnung AS c, 0 AS d, 0 AS e FROM mytab2 WHERE ]del = 0)>
  testDistinct(net.sf.jsqlparser.test.select.SelectTest): expected:<... FROM mytable WHERE [mytable.]col = 9> but was:<... FROM mytable WHERE []col = 9>
  testMultiPartColumnNameWithSchemaNameAndTableName(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [schemaName.tableName.]columnName FROM tabl...> but was:<SELECT []columnName FROM tabl...>
  testDouble(net.sf.jsqlparser.test.select.SelectTest): expected:<... FROM mytable WHERE [mytable.]col = 9> but was:<... FROM mytable WHERE []col = 9>
  testHaving(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT MAX([tab1.b) FROM tab1 WHERE a > 34 GROUP BY tab1.b HAVING MAX(tab1.]b) > 56> but was:<SELECT MAX([b) FROM tab1 WHERE a > 34 GROUP BY b HAVING MAX(]b) > 56>
  testIssue154(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [d.id, d.uuid, d.name, d.amount, d.percentage, d.modified_time FROM discount d LEFT OUTER JOIN discount_category dc ON d.id = dc.discount_id WHERE merchant_id = ? AND deleted = ? AND dc.]discount_id IS NULL ...> but was:<SELECT [id, uuid, name, amount, percentage, modified_time FROM discount d LEFT OUTER JOIN discount_category dc ON id = discount_id WHERE merchant_id = ? AND deleted = ? AND ]discount_id IS NULL ...>
  testDistinctTop(net.sf.jsqlparser.test.select.SelectTest): expected:<... FROM mytable WHERE [mytable.]col = 9> but was:<... FROM mytable WHERE []col = 9>
  testTopWithParenthesis(net.sf.jsqlparser.test.select.SelectTest): expected:<[alias.]columnName1> but was:<[]columnName1>
  testSelectOracleColl(net.sf.jsqlparser.test.select.SelectTest): expected:<... the_table tt WHERE [TT.]COL1 = lines(idx).CO...> but was:<... the_table tt WHERE []COL1 = lines(idx).CO...>
  testOracleJoin(net.sf.jsqlparser.test.select.SelectTest): expected:<...le1, tabelle2 WHERE [tabelle1.a = tabelle2.]b(+)> but was:<...le1, tabelle2 WHERE [a = ]b(+)>
  testLimit2(net.sf.jsqlparser.test.select.SelectTest): expected:<... FROM mytable WHERE [mytable.]col = 9 LIMIT ? OFFS...> but was:<... FROM mytable WHERE []col = 9 LIMIT ? OFFS...>
  testSelectWithoutFrom(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT foo[table.foo]column> but was:<SELECT foo[]column>
  testAnalyticFunctionProblem1b(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT last_value([s.revenue_hold) OVER (PARTITION BY s.id_d_insertion_order, s.id_d_product_ad_attr, trunc(s.date_id, 'mm') ORDER BY s.]date_id ROWS BETWEEN...> but was:<SELECT last_value([revenue_hold) OVER (PARTITION BY id_d_insertion_order, id_d_product_ad_attr, trunc(date_id, 'mm') ORDER BY ]date_id ROWS BETWEEN...>
  testDeparser(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [a.OWNERLASTNAME, a.OWNERFIRSTNAME FROM ANTIQUEOWNERS AS a, ANTIQUES AS b WHERE b.BUYERID = a.OWNERID AND b.]ITEM = 'Chair'> but was:<SELECT [OWNERLASTNAME, OWNERFIRSTNAME FROM ANTIQUEOWNERS AS a, ANTIQUES AS b WHERE BUYERID = OWNERID AND ]ITEM = 'Chair'>
  testLimitSqlServerJdbcParameters(net.sf.jsqlparser.test.select.SelectTest): expected:<... FROM mytable WHERE [mytable.col = 9 ORDER BY mytable.]id OFFSET ? ROWS FET...> but was:<... FROM mytable WHERE [col = 9 ORDER BY ]id OFFSET ? ROWS FET...>
  testSelectJoin(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [pg_class.relname, pg_attribute.attname, pg_constraint.conname FROM pg_constraint JOIN pg_class ON pg_class.oid = pg_constraint.conrelid JOIN pg_attribute ON pg_attribute.attrelid = pg_constraint.conrelid WHERE pg_constraint.contype = 'u' AND (pg_attribute.attnum = ANY(pg_constraint.conkey)) ORDER BY pg_constraint.]conname> but was:<SELECT [relname, attname, conname FROM pg_constraint JOIN pg_class ON oid = conrelid JOIN pg_attribute ON attrelid = conrelid WHERE contype = 'u' AND (attnum = ANY(conkey)) ORDER BY ]conname>

Tests in error: 
  testBuildSelectFromTableAndExpressions(net.sf.jsqlparser.util.SelectUtilsTest)
  testAddExpr(net.sf.jsqlparser.util.SelectUtilsTest)
  testAddJoin(net.sf.jsqlparser.util.SelectUtilsTest)
  testBuildSelectFromTableWithGroupBy(net.sf.jsqlparser.util.SelectUtilsTest)

Tests run: 353, Failures: 72, Errors: 4, Skipped: 0

[INFO] ------------------------------------------------------------------------
[INFO] BUILD FAILURE
[INFO] ------------------------------------------------------------------------
[INFO] Total time: 16.113s
[INFO] Finished at: Tue Oct 06 07:05:21 CEST 2015
[INFO] Final Memory: 24M/346M
[INFO] ------------------------------------------------------------------------
[ERROR] Failed to execute goal org.apache.maven.plugins:maven-surefire-plugin:2.10:test (default-test) on project jsqlparser: There are test failures.
[ERROR] 
[ERROR] Please refer to /home/perham/Study/Experiments/2015-10-23-ICST/LittleDarwin/Cases/JSqlParser-jsqlparser-0.9.4/target/surefire-reports for the individual test results.
[ERROR] -> [Help 1]
[ERROR] 
[ERROR] To see the full stack trace of the errors, re-run Maven with the -e switch.
[ERROR] Re-run Maven using the -X switch to enable full debug logging.
[ERROR] 
[ERROR] For more information about the errors and possible solutions, please read the following articles:
[ERROR] [Help 1] http://cwiki.apache.org/confluence/display/MAVEN/MojoFailureException
