[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/util/deparser/SelectDeParser.java
[INFO] Scan 164 files header done in 212.545ms.
[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.052 sec
Running net.sf.jsqlparser.test.create.CreateTableTest
Tests run: 27, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.127 sec
Running net.sf.jsqlparser.test.create.CreateIndexTest
Tests run: 6, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0 sec
Running net.sf.jsqlparser.test.create.CreateViewTest
Tests run: 8, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.011 sec
Running net.sf.jsqlparser.test.delete.DeleteTest
Tests run: 2, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.005 sec
Running net.sf.jsqlparser.test.simpleparsing.CCJSqlParserManagerTest
Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.171 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: 2, Errors: 0, Skipped: 0, Time elapsed: 0.048 sec <<< FAILURE!
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.004 sec <<< FAILURE!
Running net.sf.jsqlparser.test.replace.ReplaceTest
Tests run: 4, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.001 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.001 sec
Running net.sf.jsqlparser.test.select.SpecialOracleTest
Oct 06, 2015 8:59:33 AM net.sf.jsqlparser.test.select.SpecialOracleTest testAllSqlsParseDeparse
INFO: testing string01.sql
Oct 06, 2015 8:59:33 AM net.sf.jsqlparser.test.select.SpecialOracleTest testAllSqlsParseDeparse
INFO:    -> PROBLEM net.sf.jsqlparser.JSQLParserException
Oct 06, 2015 8:59:33 AM net.sf.jsqlparser.test.select.SpecialOracleTest testAllSqlsParseDeparse
INFO: testing returning01.sql
Oct 06, 2015 8:59:33 AM net.sf.jsqlparser.test.select.SpecialOracleTest testAllSqlsParseDeparse
INFO:    -> PROBLEM net.sf.jsqlparser.JSQLParserException
Oct 06, 2015 8:59:33 AM net.sf.jsqlparser.test.select.SpecialOracleTest testAllSqlsParseDeparse
INFO: testing keywordasidentifier05.sql
Oct 06, 2015 8:59:33 AM net.sf.jsqlparser.test.select.SpecialOracleTest testAllSqlsOnlyParse
INFO: testing comment02.sql
Oct 06, 2015 8:59:33 AM net.sf.jsqlparser.test.select.SpecialOracleTest testAllSqlsOnlyParse
INFO:    -> SUCCESS
Oct 06, 2015 8:59:33 AM net.sf.jsqlparser.test.select.SpecialOracleTest testAllSqlsOnlyParse
INFO: testing numbers02.sql
Oct 06, 2015 8:59:33 AM net.sf.jsqlparser.test.select.SpecialOracleTest testAllSqlsOnlyParse
INFO:    -> SUCCESS
Oct 06, 2015 8:59:33 AM net.sf.jsqlparser.test.select.SpecialOracleTest testAllSqlsOnlyParse
INFO: testing comment01.sql
Oct 06, 2015 8:59:33 AM net.sf.jsqlparser.test.select.SpecialOracleTest testAllSqlsOnlyParse
INFO:    -> SUCCESS
Tests run: 2, Failures: 1, Errors: 0, Skipped: 0, Time elapsed: 0.078 sec <<< FAILURE!
Running net.sf.jsqlparser.test.select.SelectTest
Tests run: 228, Failures: 204, Errors: 13, Skipped: 0, Time elapsed: 0.564 sec <<< FAILURE!
Running net.sf.jsqlparser.test.select.SpeedTest
42500 statements parsed in 7690 milliseconds
 (5526 statements per second,  0.000181 seconds per statement )
38500 select scans for table name executed in 128 milliseconds
 (300781 select scans for table name per second,  0.0000033 seconds per select scans for table name)
Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 7.806 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.011 sec
Running net.sf.jsqlparser.util.ConnectExpressionsVisitorTest
Tests run: 2, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.001 sec
Running net.sf.jsqlparser.util.AddAliasesVisitorTest
Tests run: 4, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.001 sec
Running net.sf.jsqlparser.util.SelectUtilsTest
Tests run: 6, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.001 sec
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.001 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.003 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:   testInsertWithSelect(net.sf.jsqlparser.test.insert.InsertTest): expected:<... AS (SELECT mycolumn[ FROM mytable) SELECT mycolumn FROM a]> but was:<... AS (SELECT mycolumn[) SELECT mycolumn]>
  testInsertSelect(net.sf.jsqlparser.test.insert.InsertTest): expected:<...umn) SELECT mycolumn[ FROM mytable]> but was:<...umn) SELECT mycolumn[]>
  testUpdateWithSelect2(net.sf.jsqlparser.test.update.UpdateTest): expected:<...3) = (SELECT a, b, c[ FROM mytable2])> but was:<...3) = (SELECT a, b, c[])>
  testUpdateWithSelect(net.sf.jsqlparser.test.update.UpdateTest): expected:<...TIONKEY) = (SELECT ?[ FROM SYSIBM.SYSDUMMY1])> but was:<...TIONKEY) = (SELECT ?[])>
  testAllSqlsParseDeparse(net.sf.jsqlparser.test.select.SpecialOracleTest): expected:<select exception[ from exception]> but was:<select exception[]>
  testSelectAliasWithoutAs(net.sf.jsqlparser.test.select.SelectTest): expected:<...umn "My Column Name"[ FROM mytable]> but was:<...umn "My Column Name"[]>
  testAllConditionSubSelect(net.sf.jsqlparser.test.select.SelectTest): expected:<...CT e1.empno, e1.sal [FROM emp e1 WHERE e1.sal > ALL (SELECT e2.sal FROM emp e2] WHERE e2.deptno = 1...> but was:<...CT e1.empno, e1.sal [WHERE e1.sal > ALL (SELECT e2.sal] WHERE e2.deptno = 1...>
  testSimpleSigns(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT +1, -1[ FROM tableName]> but was:<SELECT +1, -1[]>
  testMultiValueIn2(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT * [FROM mytable WHERE (trim(a), trim(b)) IN (SELECT a, b FROM mytable2])> but was:<SELECT * [WHERE (trim(a), trim(b)) IN (SELECT a, b])>
  testSelectForUpdateOfTable(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT foo.*, bar.*[ FROM foo], bar WHERE foo.id =...> but was:<SELECT foo.*, bar.*[], bar WHERE foo.id =...>
  testPostgreSQLRegExpCaseSensitiveMatch(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT a, b [FROM foo ]WHERE a ~ '[help].*'> but was:<SELECT a, b []WHERE a ~ '[help].*'>
  testOracleJoin2(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT *[ FROM tabelle1], tabelle2 WHERE tab...> but was:<SELECT *[], tabelle2 WHERE tab...>
  testOracleJoin3(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT *[ FROM tabelle1], tabelle2 WHERE tab...> but was:<SELECT *[], tabelle2 WHERE tab...>
  testOracleJoin4(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT *[ FROM tabelle1], tabelle2 WHERE tab...> but was:<SELECT *[], tabelle2 WHERE tab...>
  testMultiPartTableNameWithSchemaName(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT columnName[ FROM schemaName.tableName]> but was:<SELECT columnName[]>
  testSimpleAdditionsAndSubtractionsWithSigns(net.sf.jsqlparser.test.select.SelectTest): expected:<... + 1, +1 + 1, +1 - 1[ FROM tableName]> but was:<... + 1, +1 + 1, +1 - 1[]>
  testSelectAliasInQuotes(net.sf.jsqlparser.test.select.SelectTest): expected:<... AS "My Column Name"[ FROM mytable]> but was:<... AS "My Column Name"[]>
  testOrderBy(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT * [FROM tab1 ]WHERE a > 34 GROUP B...> but was:<SELECT * []WHERE a > 34 GROUP B...>
  testCastTypeProblem2(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT col1::varchar[ FROM tabelle1]> but was:<SELECT col1::varchar[]>
  testCastTypeProblem3(net.sf.jsqlparser.test.select.SelectTest): expected:<... col1::varchar (256)[ FROM tabelle1]> but was:<... col1::varchar (256)[]>
  testCastTypeProblem4(net.sf.jsqlparser.test.select.SelectTest): expected:<...ECT 5::varchar (256)[ FROM tabelle1]> but was:<...ECT 5::varchar (256)[]>
  testCastTypeProblem5(net.sf.jsqlparser.test.select.SelectTest): expected:<... 5.67::varchar (256)[ FROM tabelle1]> but was:<... 5.67::varchar (256)[]>
  testCastTypeProblem6(net.sf.jsqlparser.test.select.SelectTest): expected:<...'::character varying[ FROM tabelle1]> but was:<...'::character varying[]>
  testCastTypeProblem7(net.sf.jsqlparser.test.select.SelectTest): expected:<...S character varying)[ FROM tabelle1]> but was:<...S character varying)[]>
  testCastInCast(net.sf.jsqlparser.test.select.SelectTest): expected:<...numeric) AS varchar)[ FROM tabelle1]> but was:<...numeric) AS varchar)[]>
  testSkipFirst(net.sf.jsqlparser.test.select.SelectTest): expected:<...P ?1 FIRST f1 c1, c2[ FROM t1]> but was:<...P ?1 FIRST f1 c1, c2[]>
  testMultiPartTableNameWithDatabaseNameAndSchemaName(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT columnName[ FROM databaseName.schemaName.tableName]> but was:<SELECT columnName[]>
  testSelectJoinWithComma(net.sf.jsqlparser.test.select.SelectTest): expected:<...cb.Genus, cb.Species[ FROM Coleccion_de_Briofitas AS cb], unigeoestados AS e...> but was:<...cb.Genus, cb.Species[], unigeoestados AS e...>
  testAdditionalLettersGerman(net.sf.jsqlparser.test.select.SelectTest): expected:<...ECT colä, colö, colü[ FROM testtableäöü]> but was:<...ECT colä, colö, colü[]>
  testTop(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT TOP 3 * [FROM mytable ]WHERE mytable.col = ...> but was:<SELECT TOP 3 * []WHERE mytable.col = ...>
  testWithUnionProblem(net.sf.jsqlparser.test.select.SelectTest): expected:<...t AS ((SELECT mslink[ FROM tablea) UNION (SELECT mslink FROM tableb)) SELECT * FROM tablea WHERE mslink IN (SELECT mslink FROM test])> but was:<...t AS ((SELECT mslink[) UNION (SELECT mslink)) SELECT * WHERE mslink IN (SELECT mslink])>
  testMysqlQuote(net.sf.jsqlparser.test.select.SelectTest): expected:<...E`, `OWNERFIRSTNAME`[ FROM `ANTIQUEOWNERS` AS a], ANTIQUES AS b WHER...> but was:<...E`, `OWNERFIRSTNAME`[], ANTIQUES AS b WHER...>
  testSelectInnerWith(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT *[ FROM (WITH actor AS (SELECT 'a' aid FROM DUAL) SELECT aid FROM actor)]> but was:<SELECT *[]>
  testReservedKeyword2(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT open[ FROM tableName]> but was:<SELECT open[]>
  testFirst(net.sf.jsqlparser.test.select.SelectTest): expected:<..., alias.columnName2 [FROM schemaName.tableName alias ]ORDER BY alias.colum...> but was:<..., alias.columnName2 []ORDER BY alias.colum...>
  testIlike(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT col1 [FROM table1 ]WHERE col1 ILIKE '%h...> but was:<SELECT col1 []WHERE col1 ILIKE '%h...>
  testIsNot(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT * [FROM test ]WHERE a IS NOT NULL> but was:<SELECT * []WHERE a IS NOT NULL>
  testLimit(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT * [FROM mytable ]WHERE mytable.col = ...> but was:<SELECT * []WHERE mytable.col = ...>
  testSigns(net.sf.jsqlparser.test.select.SelectTest): expected:<...mnName), -columnName[ FROM tableName]> but was:<...mnName), -columnName[]>
  testUnion(net.sf.jsqlparser.test.select.SelectTest): expected:<(SELECT * [FROM mytable WHERE mytable.col = 9) UNION (SELECT * FROM mytable3 WHERE mytable3.col = ?) UNION (SELECT * FROM mytable2] LIMIT 4 OFFSET 3)> but was:<(SELECT * [WHERE mytable.col = 9) UNION (SELECT * WHERE mytable3.col = ?) UNION (SELECT *] LIMIT 4 OFFSET 3)>
  testRegexpLike1(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT * [FROM mytable ]WHERE REGEXP_LIKE(fi...> but was:<SELECT * []WHERE REGEXP_LIKE(fi...>
  testRegexpLike2(net.sf.jsqlparser.test.select.SelectTest): expected:<...') THEN 1 ELSE 2 END[ FROM mytable]> but was:<...') THEN 1 ELSE 2 END[]>
  testRegexpMySQL(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT * [FROM mytable ]WHERE first_name REG...> but was:<SELECT * []WHERE first_name REG...>
  testCase(net.sf.jsqlparser.test.select.SelectTest): expected:<... b WHEN 1 THEN 2 END[ FROM tab1]> but was:<... b WHEN 1 THEN 2 END[]>
  testCast(net.sf.jsqlparser.test.select.SelectTest): expected:<...T CAST(a AS varchar)[ FROM tabelle1]> but was:<...T CAST(a AS varchar)[]>
  testFrom(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT *[ FROM mytable AS mytable0, mytable1 alias_tab1, mytable2 AS alias_tab2, (SELECT * FROM mytable3]) AS mytable4 WHERE ...> but was:<SELECT *[, mytable1 alias_tab1, mytable2 AS alias_tab2, (SELECT *]) AS mytable4 WHERE ...>
  testJoin(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT * [FROM tab1 ]LEFT OUTER JOIN tab2...> but was:<SELECT * []LEFT OUTER JOIN tab2...>
  testLike(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT * [FROM tab1 ]WHERE a LIKE 'test'> but was:<SELECT * []WHERE a LIKE 'test'>
  testSkip(net.sf.jsqlparser.test.select.SelectTest): expected:<..., alias.columnName2 [FROM schemaName.tableName alias ]ORDER BY alias.colum...> but was:<..., alias.columnName2 []ORDER BY alias.colum...>
  testTime(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT * [FROM tab1 ]WHERE a > {t '04:05:...> but was:<SELECT * []WHERE a > {t '04:05:...>
  testWith(net.sf.jsqlparser.test.select.SelectTest): expected:<...S.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 IN...> but was:<...S.SALARY), COUNT(*) [GROUP BY OTHERS.WORKDEPT), DINFOMAX AS (SELECT MAX(AVGSALARY) AS AVGMAX) SELECT THIS_EMP.EMPNO, THIS_EMP.SALARY, DINFO.AVGSALARY, DINFO.EMPCOUNT, DINFOMAX.AVGMAX] INNER JOIN DINFO IN...>
  testJsonExpression(net.sf.jsqlparser.test.select.SelectTest): expected:<...ail'->'url' AS thumb[ FROM instagram]> but was:<...ail'->'url' AS thumb[]>
  testConcatProblem2_5_1(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT (a || b) || c[ FROM testtable]> but was:<SELECT (a || b) || c[]>
  testConcatProblem2_5_2(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT (a + b) + c[ FROM testtable]> but was:<SELECT (a + b) + c[]>
  testProblemSqlAnalytic8Complex(net.sf.jsqlparser.test.select.SelectTest): expected:<...*) OVER () AS ROWS2 [FROM STAFF ]WHERE ID < 60 ORDER ...> but was:<...*) OVER () AS ROWS2 []WHERE ID < 60 ORDER ...>
  testWithUnionAllProblem(net.sf.jsqlparser.test.select.SelectTest): expected:<...t AS ((SELECT mslink[ FROM tablea) UNION ALL (SELECT mslink FROM tableb)) SELECT * FROM tablea WHERE mslink IN (SELECT mslink FROM test])> but was:<...t AS ((SELECT mslink[) UNION ALL (SELECT mslink)) SELECT * WHERE mslink IN (SELECT mslink])>
  testOracleJoin2_1(net.sf.jsqlparser.test.select.SelectTest): expected:<select*[from tabelle1],tabelle2 where tabe...> but was:<select*[],tabelle2 where tabe...>
  testOracleJoin2_2(net.sf.jsqlparser.test.select.SelectTest): expected:<select*[from tabelle1],tabelle2 where tabe...> but was:<select*[],tabelle2 where tabe...>
  testOracleJoin3_1(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT *[ FROM tabelle1], tabelle2 WHERE tab...> but was:<SELECT *[], tabelle2 WHERE tab...>
  testAnyConditionSubSelect(net.sf.jsqlparser.test.select.SelectTest): expected:<...CT e1.empno, e1.sal [FROM emp e1 WHERE e1.sal > ANY (SELECT e2.sal FROM emp e2] WHERE e2.deptno = 1...> but was:<...CT e1.empno, e1.sal [WHERE e1.sal > ANY (SELECT e2.sal] WHERE e2.deptno = 1...>
  testPivotXml1(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT *[ FROM mytable PIVOT XML (count(a) FOR b IN ('val1'))]> but was:<SELECT *[]>
  testPivotXml2(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT *[ FROM mytable PIVOT XML (count(a) FOR b IN (SELECT vals FROM myothertable))]> but was:<SELECT *[]>
  testPivotXml3(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT *[ FROM mytable PIVOT XML (count(a) FOR b IN (ANY))]> but was:<SELECT *[]>
  testOrderByNullsFirst(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT a [FROM tab1 ]ORDER BY a NULLS FIR...> but was:<SELECT a []ORDER BY a NULLS FIR...>
  testMultiTableJoin(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT * [FROM taba ]INNER JOIN tabb ON t...> but was:<SELECT * []INNER JOIN tabb ON t...>
  testProblemSqlServer_Modulo_mod(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT mod(5, 2)[ FROM A]> but was:<SELECT mod(5, 2)[]>
  testProblemSqlAnalytic(net.sf.jsqlparser.test.select.SelectTest): expected:<...ER (ORDER BY a) AS n[ FROM table1]> but was:<...ER (ORDER BY a) AS n[]>
  testIssue160_signedParameter2(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT * [FROM mytable ]WHERE -? = 5> but was:<SELECT * []WHERE -? = 5>
  testAdditionalLettersSpanish(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT *[ FROM años]> but was:<SELECT *[]>
  testLateral1(net.sf.jsqlparser.test.select.SelectTest): expected:<...STNAME, OL.LINETOTAL[ FROM ORDERS AS O], LATERAL(SELECT SUM...> but was:<...STNAME, OL.LINETOTAL[], LATERAL(SELECT SUM...>
  testSelectNumericBind(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT a [FROM b ]WHERE c = :1> but was:<SELECT a []WHERE c = :1>
  testRegexpBinaryMySQL(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT * [FROM mytable ]WHERE first_name REG...> but was:<SELECT * []WHERE first_name REG...>
  testMultiValueIn(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT * [FROM mytable WHERE (a, b, c) IN (SELECT a, b, c FROM mytable2])> but was:<SELECT * [WHERE (a, b, c) IN (SELECT a, b, c])>
  testProblemSqlIntersect(net.sf.jsqlparser.test.select.SelectTest): expected:<(SELECT *[ FROM a) INTERSECT (SELECT * FROM b])> but was:<(SELECT *[) INTERSECT (SELECT *])>
  testProblemFunction(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT test()[ FROM testtable]> but was:<SELECT test()[]>
  testConcatProblem2(net.sf.jsqlparser.test.select.SelectTest): expected:<...1))) AS GESLACHT_TMP[ FROM testtable]> but was:<...1))) AS GESLACHT_TMP[]>
  testBitwise(net.sf.jsqlparser.test.select.SelectTest): expected:<... ^ col1, col1 | col2[ FROM table1]> but was:<... ^ col1, col1 | col2[]>
  testSelectInto1(net.sf.jsqlparser.test.select.SelectTest): expected:<...ECT * INTO user_copy[ FROM user]> but was:<...ECT * INTO user_copy[]>
  testSelectItems(net.sf.jsqlparser.test.select.SelectTest): expected:<...l, myschema.mytab.* [FROM mytable ]WHERE mytable.col = ...> but was:<...l, myschema.mytab.* []WHERE mytable.col = ...>
  testSelectJoin2(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT * [FROM pg_constraint ]WHERE pg_attribute.a...> but was:<SELECT * []WHERE pg_attribute.a...>
  testBrackets2(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [a][ FROM t]> but was:<SELECT [a][]>
  testProblemSqlServer_Modulo_Proz(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT 5 % 2[ FROM A]> but was:<SELECT 5 % 2[]>
  testFirstWithKeywordLimit(net.sf.jsqlparser.test.select.SelectTest): expected:<..., alias.columnName2 [FROM schemaName.tableName alias ]ORDER BY alias.colum...> but was:<..., alias.columnName2 []ORDER BY alias.colum...>
  testGroupConcat(net.sf.jsqlparser.test.select.SelectTest): expected:<...DESC SEPARATOR ' ') [FROM student ]GROUP BY student_nam...> but was:<...DESC SEPARATOR ' ') []GROUP BY student_nam...>
  testSelectKeepOver(net.sf.jsqlparser.test.select.SelectTest): expected:<...rtment_id ) "Worst" [FROM employees ]ORDER BY department_...> but was:<...rtment_id ) "Worst" []ORDER BY department_...>
  testFunctionRight(net.sf.jsqlparser.test.select.SelectTest): expected:<...ight(table1.col1, 4)[ FROM table1]> but was:<...ight(table1.col1, 4)[]>
  testMultiPartColumnName(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT columnName[ FROM tableName]> but was:<SELECT columnName[]>
  testWithUnionProblem3(net.sf.jsqlparser.test.select.SelectTest): expected:<...a.fname AS varchar) [FROM tablea INNER JOIN tableb ON tablea.mslink = tableb.mslink AND tableb.deleted = 0 WHERE tablea.fname IS NULL AND 1 = 0) UNION ALL (SELECT mslink FROM tableb)) SELECT * FROM tablea WHERE mslink IN (SELECT mslink FROM test])> but was:<...a.fname AS varchar) [INNER JOIN tableb ON tablea.mslink = tableb.mslink AND tableb.deleted = 0 WHERE tablea.fname IS NULL AND 1 = 0) UNION ALL (SELECT mslink)) SELECT * WHERE mslink IN (SELECT mslink])>
  testWithUnionProblem4(net.sf.jsqlparser.test.select.SelectTest): expected:<...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 AN...> but was:<...AS path, ae.feature [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 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 WHERE EXISTS (SELECT feature] WHERE mslink = 0 AN...>
  testWithUnionProblem5(net.sf.jsqlparser.test.select.SelectTest): expected:<...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 * FROM hist]> but was:<...AS path, ae.feature [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 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 *]>
  testValues2(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT *[ FROM (VALUES 1, 2, 3, 4) AS test]> but was:<SELECT *[]>
  testValues3(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT *[ FROM (VALUES 1, 2, 3, 4) AS test(a)]> but was:<SELECT *[]>
  testValues4(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT *[ FROM (VALUES (1, 2), (3, 4)) AS test(a, b)]> but was:<SELECT *[]>
  testValues5(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT X, Y[ FROM (VALUES (0, 'a'), (1, 'b')) AS MY_TEMP_TABLE(X, Y)]> but was:<SELECT X, Y[]>
  testGroupBy(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT * [FROM tab1 ]WHERE a > 34 GROUP B...> but was:<SELECT * []WHERE a > 34 GROUP B...>
  testMultiPartColumnNameWithTableName(net.sf.jsqlparser.test.select.SelectTest): expected:<...tableName.columnName[ FROM tableName]> but was:<...tableName.columnName[]>
  testMultiPartTableNameWithDatabaseName(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT columnName[ FROM databaseName..tableName]> but was:<SELECT columnName[]>
  testLimitSqlServer1(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT * [FROM mytable ]WHERE mytable.col = ...> but was:<SELECT * []WHERE mytable.col = ...>
  testLimitSqlServer2(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT * [FROM mytable ]WHERE mytable.col = ...> but was:<SELECT * []WHERE mytable.col = ...>
  testLimitSqlServer3(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT * [FROM mytable ]WHERE mytable.col = ...> but was:<SELECT * []WHERE mytable.col = ...>
  testLimitSqlServer4(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT * [FROM mytable ]WHERE mytable.col = ...> but was:<SELECT * []WHERE mytable.col = ...>
  testPivotFunction(net.sf.jsqlparser.test.select.SelectTest): expected:<...o_char((SELECT col1 [FROM (SELECT times_purchased, state_code FROM customers t) PIVOT (count(state_code) FOR state_code IN ('NY', 'CT', 'NJ', 'FL', 'MO')) ORDER BY times_purchased)) FROM DUAL]> but was:<...o_char((SELECT col1 [ORDER BY times_purchased))]>
  testMultiPartTableNameWithServerNameAndDatabaseName(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT columnName[ FROM [server-name\server-instance].databaseName..tableName]> but was:<SELECT columnName[]>
  testConcatProblem2_1(net.sf.jsqlparser.test.select.SelectTest): expected:<...NR, 'FM09'::VARCHAR)[ FROM testtable]> but was:<...NR, 'FM09'::VARCHAR)[]>
  testConcatProblem2_2(net.sf.jsqlparser.test.select.SelectTest): expected:<...(4)) AS GESLACHT_TMP[ FROM testtable]> but was:<...(4)) AS GESLACHT_TMP[]>
  testConcatProblem2_3(net.sf.jsqlparser.test.select.SelectTest): expected:<..., 'FM0999'::VARCHAR)[ FROM testtable]> but was:<..., 'FM0999'::VARCHAR)[]>
  testConcatProblem2_4(net.sf.jsqlparser.test.select.SelectTest): expected:<...SLACHT)::VARCHAR (1)[ FROM testtable]> but was:<...SLACHT)::VARCHAR (1)[]>
  testConcatProblem2_5(net.sf.jsqlparser.test.select.SelectTest): expected:<...T max((a || b) || c)[ FROM testtable]> but was:<...T max((a || b) || c)[]>
  testConcatProblem2_6(net.sf.jsqlparser.test.select.SelectTest): expected:<...ECT max(a || b || c)[ FROM testtable]> but was:<...ECT max(a || b || c)[]>
  testMultiPartColumnNameWithDatabaseNameAndSchemaNameAndTableName(net.sf.jsqlparser.test.select.SelectTest): expected:<...tableName.columnName[ FROM tableName]> but was:<...tableName.columnName[]>
  testMultiPartColumnNameWithDatabaseNameAndTableName(net.sf.jsqlparser.test.select.SelectTest): expected:<...tableName.columnName[ FROM tableName]> but was:<...tableName.columnName[]>
  testReplaceAsFunction(net.sf.jsqlparser.test.select.SelectTest): expected:<...T REPLACE(a, 'b', c)[ FROM tab1]> but was:<...T REPLACE(a, 'b', c)[]>
  testSelectJPQLPositionalParameter(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT email [FROM users ]WHERE (type LIKE 'B'...> but was:<SELECT email []WHERE (type LIKE 'B'...>
  testSelectWithinGroup(net.sf.jsqlparser.test.select.SelectTest): expected:<...ROUP (ORDER BY col1)[ FROM table1]> but was:<...ROUP (ORDER BY col1)[]>
  testNotEqualsTo(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT * [FROM foo ]WHERE a != b> but was:<SELECT * []WHERE a != b>
  testSelectForUpdate(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT * F[ROM user_table F]OR UPDATE> but was:<SELECT * F[]OR UPDATE>
  testProblemSqlAnalytic10Lag(net.sf.jsqlparser.test.select.SelectTest): expected:<... ORDER BY a, b) AS n[ FROM table1]> but was:<... ORDER BY a, b) AS n[]>
  testProblemSqlAnalytic11Lag(net.sf.jsqlparser.test.select.SelectTest): expected:<... ORDER BY a, b) AS n[ FROM table1]> but was:<... ORDER BY a, b) AS n[]>
  testMatches(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT * [FROM team ]WHERE team.search_co...> but was:<SELECT * []WHERE team.search_co...>
  testAnalyticFunctionProblem1(net.sf.jsqlparser.test.select.SelectTest): expected:<...BY s.date_id) AS col[ FROM s]> but was:<...BY s.date_id) AS col[]>
  testFunctions(net.sf.jsqlparser.test.select.SelectTest): expected:<...LECT MAX(id) AS max [FROM mytable ]WHERE mytable.col = ...> but was:<...LECT MAX(id) AS max []WHERE mytable.col = ...>
  testProblemFunction2(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT sysdate[ FROM testtable]> but was:<SELECT sysdate[]>
  testProblemFunction3(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT TRUNCATE(col)[ FROM testtable]> but was:<SELECT TRUNCATE(col)[]>
  testSelectOrderHaving(net.sf.jsqlparser.test.select.SelectTest): expected:<...count(units) AS num [FROM currency ]GROUP BY units HAVIN...> but was:<...count(units) AS num []GROUP BY units HAVIN...>
  testAnalyticFunction12(net.sf.jsqlparser.test.select.SelectTest): expected:<...ION BY b ORDER BY c)[ FROM tab1]> but was:<...ION BY b ORDER BY c)[]>
  testAnalyticFunction13(net.sf.jsqlparser.test.select.SelectTest): expected:<...ELECT SUM(a) OVER ()[ FROM tab1]> but was:<...ELECT SUM(a) OVER ()[]>
  testAnalyticFunction14(net.sf.jsqlparser.test.select.SelectTest): expected:<...ER (PARTITION BY b )[ FROM tab1]> but was:<...ER (PARTITION BY b )[]>
  testAnalyticFunction15(net.sf.jsqlparser.test.select.SelectTest): expected:<...a) OVER (ORDER BY c)[ FROM tab1]> but was:<...a) OVER (ORDER BY c)[]>
  testAnalyticFunction16(net.sf.jsqlparser.test.select.SelectTest): expected:<...ER BY c NULLS FIRST)[ FROM tab1]> but was:<...ER BY c NULLS FIRST)[]>
  testAnalyticFunction17(net.sf.jsqlparser.test.select.SelectTest): expected:<...S avg_of_current_sal[ FROM emp]> but was:<...S avg_of_current_sal[]>
  testAnalyticFunction18(net.sf.jsqlparser.test.select.SelectTest): expected:<...S avg_of_current_sal[ FROM emp]> but was:<...S avg_of_current_sal[]>
  testMultiPartTableNameWithServerNameAndDatabaseNameAndSchemaName(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT columnName[ FROM [server-name\server-instance].databaseName.schemaName.tableName]> but was:<SELECT columnName[]>
  testBrackets(net.sf.jsqlparser.test.select.SelectTest): expected:<...ble_a.name AS [Test][ FROM table_a]> but was:<...ble_a.name AS [Test][]>
  testWithStatement(net.sf.jsqlparser.test.select.SelectTest): expected:<...st AS (SELECT mslink[ FROM feature) SELECT * FROM feature WHERE mslink IN (SELECT mslink FROM test])> but was:<...st AS (SELECT mslink[) SELECT * WHERE mslink IN (SELECT mslink])>
  testIssue154_2(net.sf.jsqlparser.test.select.SelectTest): expected:<...name, r.system_role [FROM role r ]WHERE r.merchant_id ...> but was:<...name, r.system_role []WHERE r.merchant_id ...>
  testTimestamp(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT * [FROM tab1 ]WHERE a > {ts '2004-...> but was:<SELECT * []WHERE a > {ts '2004-...>
  testProblemSqlAnalytic5AggregateColumnValue(net.sf.jsqlparser.test.select.SelectTest): expected:<... sum(b) OVER () AS n[ FROM table1]> but was:<... sum(b) OVER () AS n[]>
  testMultiPartTableNameWithColumnName(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT columnName[ FROM tableName]> but was:<SELECT columnName[]>
  testFunctionLeft(net.sf.jsqlparser.test.select.SelectTest): expected:<...left(table1.col1, 4)[ FROM table1]> but was:<...left(table1.col1, 4)[]>
  testCharacterSetClause(net.sf.jsqlparser.test.select.SelectTest): expected:<...R SET utf8) AS `v0` [FROM people `view0` ]WHERE `view0`.`nick2...> but was:<...R SET utf8) AS `v0` []WHERE `view0`.`nick2...>
  testComplexUnion1(net.sf.jsqlparser.test.select.SelectTest): expected:<...t, 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 = ...> but was:<...t, mytab.d, mytab.e [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] WHERE mytab2.del = ...>
  testProblemSqlAnalytic6AggregateColumnValue(net.sf.jsqlparser.test.select.SelectTest): expected:<...ER (ORDER BY a) AS n[ FROM table1]> but was:<...ER (ORDER BY a) AS n[]>
  testDistinct(net.sf.jsqlparser.test.select.SelectTest): expected:<... (myid) myid, mycol [FROM mytable ]WHERE mytable.col = ...> but was:<... (myid) myid, mycol []WHERE mytable.col = ...>
  testMultiPartColumnNameWithSchemaNameAndTableName(net.sf.jsqlparser.test.select.SelectTest): expected:<...tableName.columnName[ FROM tableName]> but was:<...tableName.columnName[]>
  testMultiPartTableNameWithServerName(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT columnName[ FROM [server-name\server-instance]...tableName]> but was:<SELECT columnName[]>
  testProblemSqlAnalytic7Count(net.sf.jsqlparser.test.select.SelectTest): expected:<...ount(*) OVER () AS n[ FROM table1]> but was:<...ount(*) OVER () AS n[]>
  testAllColumnsFromTable(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT tableName.*[ FROM tableName]> but was:<SELECT tableName.*[]>
  testProblemSqlCombinedSets(net.sf.jsqlparser.test.select.SelectTest): expected:<(SELECT *[ FROM a) INTERSECT (SELECT * FROM b) UNION (SELECT * FROM c])> but was:<(SELECT *[) INTERSECT (SELECT *) UNION (SELECT *])>
  testInterval2(net.sf.jsqlparser.test.select.SelectTest): expected:<...24:')) AS START_TIME[ FROM tab1]> but was:<...24:')) AS START_TIME[]>
  testConcat(net.sf.jsqlparser.test.select.SelectTest): expected:<...LECT a || b || c + 4[ FROM t]> but was:<...LECT a || b || c + 4[]>
  testCount2(net.sf.jsqlparser.test.select.SelectTest): expected:<...unt(ALL col1 + col2)[ FROM mytable]> but was:<...unt(ALL col1 + col2)[]>
  testSignedColumns(net.sf.jsqlparser.test.select.SelectTest): expected:<...Name), -(columnName)[ FROM tableName]> but was:<...Name), -(columnName)[]>
  testDouble(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT 1e2, * [FROM mytable ]WHERE mytable.col = ...> but was:<SELECT 1e2, * []WHERE mytable.col = ...>
  testProblemSqlMinus(net.sf.jsqlparser.test.select.SelectTest): expected:<(SELECT *[ FROM a) MINUS (SELECT * FROM b])> but was:<(SELECT *[) MINUS (SELECT *])>
  testExists(net.sf.jsqlparser.test.select.SelectTest): expected:<EXISTS (SELECT *[ FROM tab2])> but was:<EXISTS (SELECT *[])>
  testMultiPartTableNameWithServerProblem(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT *[ FROM LINK_100.htsac.dbo.t_transfer_num a]> but was:<SELECT *[]>
  testGroupByExpression(net.sf.jsqlparser.test.select.SelectTest): expected:<...1 + col2, sum(col8) [FROM table1 ]GROUP BY col1, col2,...> but was:<...1 + col2, sum(col8) []GROUP BY col1, col2,...>
  testHaving(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT MAX(tab1.b) [FROM tab1 ]WHERE a > 34 GROUP B...> but was:<SELECT MAX(tab1.b) []WHERE a > 34 GROUP B...>
  testIssue154(net.sf.jsqlparser.test.select.SelectTest): expected:<...ge, d.modified_time [FROM discount d ]LEFT OUTER JOIN disc...> but was:<...ge, d.modified_time []LEFT OUTER JOIN disc...>
  testDistinctTop(net.sf.jsqlparser.test.select.SelectTest): expected:<...T TOP 5 myid, mycol [FROM mytable ]WHERE mytable.col = ...> but was:<...T TOP 5 myid, mycol []WHERE mytable.col = ...>
  testSelectUserVariable(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT @col[ FROM t1]> but was:<SELECT @col[]>
  testIsNot2(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT * [FROM test ]WHERE a IS NOT NULL> but was:<SELECT * []WHERE a IS NOT NULL>
  testTopWithParenthesis(net.sf.jsqlparser.test.select.SelectTest): expected:<..., alias.columnName2 [FROM schemaName.tableName alias ]ORDER BY alias.colum...> but was:<..., alias.columnName2 []ORDER BY alias.colum...>
  testSelectOracleColl(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT * [FROM the_table tt ]WHERE TT.COL1 = line...> but was:<SELECT * []WHERE TT.COL1 = line...>
  testOracleJoin(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT *[ FROM tabelle1], tabelle2 WHERE tab...> but was:<SELECT *[], tabelle2 WHERE tab...>
  testPostgreSQLRegExpCaseSensitiveMatch2(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT a, b [FROM foo ]WHERE a ~* '[help].*...> but was:<SELECT a, b []WHERE a ~* '[help].*...>
  testPostgreSQLRegExpCaseSensitiveMatch3(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT a, b [FROM foo ]WHERE a !~ '[help].*...> but was:<SELECT a, b []WHERE a !~ '[help].*...>
  testPostgreSQLRegExpCaseSensitiveMatch4(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT a, b [FROM foo ]WHERE a !~* '[help]....> but was:<SELECT a, b []WHERE a !~* '[help]....>
  testRowConstructor1(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT * [FROM t1 WHERE (col1, col2) = (SELECT col3, col4 FROM t2] WHERE id = 10)> but was:<SELECT * [WHERE (col1, col2) = (SELECT col3, col4] WHERE id = 10)>
  testRowConstructor2(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT * [FROM t1 WHERE ROW(col1, col2) = (SELECT col3, col4 FROM t2] WHERE id = 10)> but was:<SELECT * [WHERE ROW(col1, col2) = (SELECT col3, col4] WHERE id = 10)>
  testLimit2(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT * [FROM mytable ]WHERE mytable.col = ...> but was:<SELECT * []WHERE mytable.col = ...>
  testTableCrossJoin(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT * [FROM taba ]CROSS JOIN tabb> but was:<SELECT * []CROSS JOIN tabb>
  testProblemSqlAnalytic2(net.sf.jsqlparser.test.select.SelectTest): expected:<...(ORDER BY a, b) AS n[ FROM table1]> but was:<...(ORDER BY a, b) AS n[]>
  testProblemSqlAnalytic3(net.sf.jsqlparser.test.select.SelectTest): expected:<... ORDER BY a, b) AS n[ FROM table1]> but was:<... ORDER BY a, b) AS n[]>
  testProblemSqlAnalytic9CommaListPartition(net.sf.jsqlparser.test.select.SelectTest): expected:<... ORDER BY a, b) AS n[ FROM table1]> but was:<... ORDER BY a, b) AS n[]>
  testOracleHierarchicalQuery(net.sf.jsqlparser.test.select.SelectTest): expected:<...oyee_id, manager_id [FROM employees ]CONNECT BY employee_...> but was:<...oyee_id, manager_id []CONNECT BY employee_...>
  testPivot1(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT *[ FROM mytable PIVOT (count(a) FOR b IN ('val1'))]> but was:<SELECT *[]>
  testPivot2(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT *[ FROM mytable PIVOT (count(a) FOR b IN (10, 20, 30))]> but was:<SELECT *[]>
  testPivot3(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT *[ FROM mytable PIVOT (count(a) AS vals FOR b IN (10 AS d1, 20, 30 AS d3))]> but was:<SELECT *[]>
  testPivot4(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT *[ FROM mytable PIVOT (count(a), sum(b) FOR b IN (10, 20, 30))]> but was:<SELECT *[]>
  testPivot5(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT *[ FROM mytable PIVOT (count(a) FOR (b, c) IN ((10, 'a'), (20, 'b'), (30, 'c')))]> but was:<SELECT *[]>
  testSelectWithBrackets(net.sf.jsqlparser.test.select.SelectTest): expected:<(SELECT 1[ FROM mytable])> but was:<(SELECT 1[])>
  testAnalyticFunctionProblem1b(net.sf.jsqlparser.test.select.SelectTest): expected:<...ED FOLLOWING) AS col[ FROM s]> but was:<...ED FOLLOWING) AS col[]>
  testDeparser(net.sf.jsqlparser.test.select.SelectTest): expected:<...ME, a.OWNERFIRSTNAME[ FROM ANTIQUEOWNERS AS a], ANTIQUES AS b WHER...> but was:<...ME, a.OWNERFIRSTNAME[], ANTIQUES AS b WHER...>
  testPivotXmlSubquery1(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT * [FROM (SELECT times_purchased, state_code FROM customers t) PIVOT (count(state_code) FOR state_code IN ('NY', 'CT', 'NJ', 'FL', 'MO')) ]ORDER BY times_purch...> but was:<SELECT * []ORDER BY times_purch...>
  testOracleHierarchicalQuery2(net.sf.jsqlparser.test.select.SelectTest): expected:<...st_name, manager_id [FROM employees ]CONNECT BY PRIOR emp...> but was:<...st_name, manager_id []CONNECT BY PRIOR emp...>
  testOracleHierarchicalQuery3(net.sf.jsqlparser.test.select.SelectTest): expected:<..., manager_id, LEVEL [FROM employees ]START WITH employee_...> but was:<..., manager_id, LEVEL []START WITH employee_...>
  testOracleHierarchicalQuery4(net.sf.jsqlparser.test.select.SelectTest): expected:<..., manager_id, LEVEL [FROM employees ]CONNECT BY PRIOR emp...> but was:<..., manager_id, LEVEL []CONNECT BY PRIOR emp...>
  testExtractFrom1(net.sf.jsqlparser.test.select.SelectTest): expected:<...nth FROM datecolumn)[ FROM testtable]> but was:<...nth FROM datecolumn)[]>
  testExtractFrom2(net.sf.jsqlparser.test.select.SelectTest): expected:<...ACT(year FROM now())[ FROM testtable]> but was:<...ACT(year FROM now())[]>
  testExtractFrom3(net.sf.jsqlparser.test.select.SelectTest): expected:<...ar FROM (now() - 2))[ FROM testtable]> but was:<...ar FROM (now() - 2))[]>
  testExtractFrom4(net.sf.jsqlparser.test.select.SelectTest): expected:<... now() - '01:22:00')[ FROM testtable]> but was:<... now() - '01:22:00')[]>
  testProblemSqlAnalytic4EmptyOver(net.sf.jsqlparser.test.select.SelectTest): expected:<...umber() OVER () AS n[ FROM table1]> but was:<...umber() OVER () AS n[]>
  testCastTypeProblem(net.sf.jsqlparser.test.select.SelectTest): expected:<...l1 AS varchar (256))[ FROM tabelle1]> but was:<...l1 AS varchar (256))[]>
  testSelectKeywordPercent(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT percent[ FROM MY_TABLE]> but was:<SELECT percent[]>
  testValues(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT *[ FROM (VALUES (1, 2), (3, 4)) AS test]> but was:<SELECT *[]>
  testValues6BothVariants(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT I [FROM (VALUES 1, 2, 3) AS MY_TEMP_TABLE(I) WHERE I IN (SELECT * FROM (VALUES 1, 2) AS TEST])> but was:<SELECT I [WHERE I IN (SELECT *])>
  testProblemSqlExcept(net.sf.jsqlparser.test.select.SelectTest): expected:<(SELECT *[ FROM a) EXCEPT (SELECT * FROM b])> but was:<(SELECT *[) EXCEPT (SELECT *])>
  testMultiPartTableNameWithServerNameAndSchemaName(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT columnName[ FROM [server-name\server-instance]..schemaName.tableName]> but was:<SELECT columnName[]>
  testProblemSqlServer_Modulo(net.sf.jsqlparser.test.select.SelectTest): expected:<...um) % 12) + ' month'[ FROM test_table]> but was:<...um) % 12) + ' month'[]>
  testReservedKeyword(net.sf.jsqlparser.test.select.SelectTest): expected:<...siblings, value, xml[ FROM tableName]> but was:<...siblings, value, xml[]>
  testLimitSqlServerJdbcParameters(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT * [FROM mytable ]WHERE mytable.col = ...> but was:<SELECT * []WHERE mytable.col = ...>
  testSelectJoin(net.sf.jsqlparser.test.select.SelectTest): expected:<..._constraint.conname [FROM pg_constraint ]JOIN pg_class ON pg_...> but was:<..._constraint.conname []JOIN pg_class ON pg_...>
  testSelectKeep(net.sf.jsqlparser.test.select.SelectTest): expected:<...RDER BY col3), col4 [FROM table1 ]GROUP BY col5 ORDER ...> but was:<...RDER BY col3), col4 []GROUP BY col5 ORDER ...>
  testCaseElseAddition(net.sf.jsqlparser.test.select.SelectTest): expected:<...SE 1000 + 1 END AS d[ FROM dual]> but was:<...SE 1000 + 1 END AS d[]>
  testNamedParameter2(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT * [FROM mytable ]WHERE a = :param OR ...> but was:<SELECT * []WHERE a = :param OR ...>
  testBooleanFunction1(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT * [FROM mytable ]WHERE test_func(col1...> but was:<SELECT * []WHERE test_func(col1...>
  testCastInCast2(net.sf.jsqlparser.test.select.SelectTest): expected:<...numeric) AS varchar)[ FROM tabelle1]> but was:<...numeric) AS varchar)[]>
  testNamedParameter(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT * [FROM mytable ]WHERE b = :param> but was:<SELECT * []WHERE b = :param>

Tests in error: 
  testSelectBrackets2(net.sf.jsqlparser.test.select.SelectTest)
  testSelectBrackets3(net.sf.jsqlparser.test.select.SelectTest)
  testSelectBrackets4(net.sf.jsqlparser.test.select.SelectTest)
  testIssue162_doubleUserVar(net.sf.jsqlparser.test.select.SelectTest)
  testSelectWithBrackets2(net.sf.jsqlparser.test.select.SelectTest)
  testWithRecursive(net.sf.jsqlparser.test.select.SelectTest)
  testSelectBrackets(net.sf.jsqlparser.test.select.SelectTest)
  testSelectFunction(net.sf.jsqlparser.test.select.SelectTest)
  testIssue160_signedParameter(net.sf.jsqlparser.test.select.SelectTest)
  testInterval1(net.sf.jsqlparser.test.select.SelectTest)
  testInterval3(net.sf.jsqlparser.test.select.SelectTest)
  testInterval4(net.sf.jsqlparser.test.select.SelectTest)
  testSelectWithoutFrom(net.sf.jsqlparser.test.select.SelectTest)

Tests run: 353, Failures: 209, Errors: 13, Skipped: 0

[INFO] ------------------------------------------------------------------------
[INFO] BUILD FAILURE
[INFO] ------------------------------------------------------------------------
[INFO] Total time: 15.411s
[INFO] Finished at: Tue Oct 06 08:59:41 CEST 2015
[INFO] Final Memory: 23M/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
