[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 215.831ms.
[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: 0, Errors: 0, Skipped: 0, Time elapsed: 0.128 sec
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: 0, Errors: 0, Skipped: 0, Time elapsed: 0.009 sec
Running net.sf.jsqlparser.test.delete.DeleteTest
Tests run: 2, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.004 sec
Running net.sf.jsqlparser.test.simpleparsing.CCJSqlParserManagerTest
Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.181 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.047 sec <<< FAILURE!
Running net.sf.jsqlparser.test.TestUtils
Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.001 sec
Running net.sf.jsqlparser.test.update.UpdateTest
Tests run: 7, Failures: 2, Errors: 0, Skipped: 0, Time elapsed: 0.002 sec <<< FAILURE!
Running net.sf.jsqlparser.test.replace.ReplaceTest
Tests run: 4, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.003 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 9:01:36 AM net.sf.jsqlparser.test.select.SpecialOracleTest testAllSqlsParseDeparse
INFO: testing string01.sql
Oct 06, 2015 9:01:36 AM net.sf.jsqlparser.test.select.SpecialOracleTest testAllSqlsParseDeparse
INFO:    -> PROBLEM net.sf.jsqlparser.JSQLParserException
Oct 06, 2015 9:01:36 AM net.sf.jsqlparser.test.select.SpecialOracleTest testAllSqlsParseDeparse
INFO: testing returning01.sql
Oct 06, 2015 9:01:36 AM net.sf.jsqlparser.test.select.SpecialOracleTest testAllSqlsParseDeparse
INFO:    -> PROBLEM net.sf.jsqlparser.JSQLParserException
Oct 06, 2015 9:01:36 AM net.sf.jsqlparser.test.select.SpecialOracleTest testAllSqlsParseDeparse
INFO: testing keywordasidentifier05.sql
Oct 06, 2015 9:01:36 AM net.sf.jsqlparser.test.select.SpecialOracleTest testAllSqlsOnlyParse
INFO: testing comment02.sql
Oct 06, 2015 9:01:36 AM net.sf.jsqlparser.test.select.SpecialOracleTest testAllSqlsOnlyParse
INFO:    -> SUCCESS
Oct 06, 2015 9:01:36 AM net.sf.jsqlparser.test.select.SpecialOracleTest testAllSqlsOnlyParse
INFO: testing numbers02.sql
Oct 06, 2015 9:01:36 AM net.sf.jsqlparser.test.select.SpecialOracleTest testAllSqlsOnlyParse
INFO:    -> SUCCESS
Oct 06, 2015 9:01:36 AM net.sf.jsqlparser.test.select.SpecialOracleTest testAllSqlsOnlyParse
INFO: testing comment01.sql
Oct 06, 2015 9:01:36 AM net.sf.jsqlparser.test.select.SpecialOracleTest testAllSqlsOnlyParse
INFO:    -> SUCCESS
Tests run: 2, Failures: 1, Errors: 0, Skipped: 0, Time elapsed: 0.082 sec <<< FAILURE!
Running net.sf.jsqlparser.test.select.SelectTest
Tests run: 228, Failures: 217, Errors: 0, Skipped: 0, Time elapsed: 0.531 sec <<< FAILURE!
Running net.sf.jsqlparser.test.select.SpeedTest
42500 statements parsed in 7834 milliseconds
 (5425 statements per second,  0.0001843 seconds per statement )
38500 select scans for table name executed in 129 milliseconds
 (298449 select scans for table name per second,  0.0000034 seconds per select scans for table name)
Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 7.952 sec
Running net.sf.jsqlparser.test.truncate.TruncateTest
Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.001 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.003 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: 0, Skipped: 0, Time elapsed: 0.003 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 sec
Running net.sf.jsqlparser.parser.CCJSqlParserUtilTest
Tests run: 3, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0 sec
Running net.sf.jsqlparser.statement.SetStatementTest
Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.002 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.002 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:<...) WITH a AS (SELECT [mycolumn FROM mytable) SELECT] mycolumn FROM a> but was:<...) WITH a AS (SELECT [null mycolumn FROM mytable) SELECT null] mycolumn FROM a>
  testInsertSelect(net.sf.jsqlparser.test.insert.InsertTest): expected:<...e (mycolumn) SELECT []mycolumn FROM mytabl...> but was:<...e (mycolumn) SELECT [null ]mycolumn FROM mytabl...>
  testUpdateWithSelect2(net.sf.jsqlparser.test.update.UpdateTest): expected:<...l2, col3) = (SELECT []a, b, c FROM mytable...> but was:<...l2, col3) = (SELECT [null ]a, b, c FROM mytable...>
  testUpdateWithSelect(net.sf.jsqlparser.test.update.UpdateTest): expected:<...ATIONKEY) = (SELECT []? FROM SYSIBM.SYSDUM...> but was:<...ATIONKEY) = (SELECT [null ]? FROM SYSIBM.SYSDUM...>
  testAllSqlsParseDeparse(net.sf.jsqlparser.test.select.SpecialOracleTest): expected:<select []exception from excep...> but was:<select [null ]exception from excep...>
  testSelectAliasWithoutAs(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT []mycolumn "My Column ...> but was:<SELECT [null ]mycolumn "My Column ...>
  testAllConditionSubSelect(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [e1.empno, e1.sal FROM emp e1 WHERE e1.sal > ALL (SELECT] e2.sal FROM emp e2 ...> but was:<SELECT [null e1.empno, e1.sal FROM emp e1 WHERE e1.sal > ALL (SELECT null] e2.sal FROM emp e2 ...>
  testSimpleSigns(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT []+1, -1 FROM tableNam...> but was:<SELECT [null ]+1, -1 FROM tableNam...>
  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 [null * FROM mytable WHERE (trim(a), trim(b)) IN (SELECT null] a, b FROM mytable2)>
  testSelectForUpdateOfTable(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT []foo.*, bar.* FROM fo...> but was:<SELECT [null ]foo.*, bar.* FROM fo...>
  testPostgreSQLRegExpCaseSensitiveMatch(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT []a, b FROM foo WHERE ...> but was:<SELECT [null ]a, b FROM foo WHERE ...>
  testOracleJoin2(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT []* FROM tabelle1, tab...> but was:<SELECT [null ]* FROM tabelle1, tab...>
  testOracleJoin3(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT []* FROM tabelle1, tab...> but was:<SELECT [null ]* FROM tabelle1, tab...>
  testOracleJoin4(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT []* FROM tabelle1, tab...> but was:<SELECT [null ]* FROM tabelle1, tab...>
  testMultiPartTableNameWithSchemaName(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT []columnName FROM sche...> but was:<SELECT [null ]columnName FROM sche...>
  testSelectBrackets2(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [](EXTRACT(epoch FROM ...> but was:<SELECT [null ](EXTRACT(epoch FROM ...>
  testSelectBrackets3(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT []avg((EXTRACT(epoch F...> but was:<SELECT [null ]avg((EXTRACT(epoch F...>
  testSelectBrackets4(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [](1 / 2)::numeric> but was:<SELECT [null ](1 / 2)::numeric>
  testSimpleAdditionsAndSubtractionsWithSigns(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT []1 - 1, 1 + 1, -1 - 1...> but was:<SELECT [null ]1 - 1, 1 + 1, -1 - 1...>
  testSelectAliasInQuotes(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT []mycolumn AS "My Colu...> but was:<SELECT [null ]mycolumn AS "My Colu...>
  testOrderBy(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT []* FROM tab1 WHERE a ...> but was:<SELECT [null ]* FROM tab1 WHERE a ...>
  testCastTypeProblem2(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT []col1::varchar FROM t...> but was:<SELECT [null ]col1::varchar FROM t...>
  testCastTypeProblem3(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT []col1::varchar (256) ...> but was:<SELECT [null ]col1::varchar (256) ...>
  testCastTypeProblem4(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT []5::varchar (256) FRO...> but was:<SELECT [null ]5::varchar (256) FRO...>
  testCastTypeProblem5(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT []5.67::varchar (256) ...> but was:<SELECT [null ]5.67::varchar (256) ...>
  testCastTypeProblem6(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT []'test'::character va...> but was:<SELECT [null ]'test'::character va...>
  testCastTypeProblem7(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT []CAST('test' AS chara...> but was:<SELECT [null ]CAST('test' AS chara...>
  testCastInCast(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT []CAST(CAST(a AS numer...> but was:<SELECT [null ]CAST(CAST(a AS numer...>
  testSkipFirst(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [SKIP ?1 ]FIRST f1 c1, c2 FROM...> but was:<SELECT []FIRST f1 c1, c2 FROM...>
  testMultiPartTableNameWithDatabaseNameAndSchemaName(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT []columnName FROM data...> but was:<SELECT [null ]columnName FROM data...>
  testSelectJoinWithComma(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT []cb.Genus, cb.Species...> but was:<SELECT [null ]cb.Genus, cb.Species...>
  testAdditionalLettersGerman(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT []colä, colö, colü FRO...> but was:<SELECT [null ]colä, colö, colü FRO...>
  testTop(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT []TOP 3 * FROM mytable...> but was:<SELECT [null ]TOP 3 * FROM mytable...>
  testWithUnionProblem(net.sf.jsqlparser.test.select.SelectTest): expected:<...TH test AS ((SELECT [mslink FROM tablea) UNION (SELECT mslink FROM tableb)) SELECT * FROM tablea WHERE mslink IN (SELECT] mslink FROM test)> but was:<...TH test AS ((SELECT [null mslink FROM tablea) UNION (SELECT null mslink FROM tableb)) SELECT null * FROM tablea WHERE mslink IN (SELECT null] mslink FROM test)>
  testMysqlQuote(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT []`a.OWNERLASTNAME`, `...> but was:<SELECT [null ]`a.OWNERLASTNAME`, `...>
  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 [null * FROM (WITH actor AS (SELECT null 'a' aid FROM DUAL) SELECT null] aid FROM actor)>
  testReservedKeyword2(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT []open FROM tableName> but was:<SELECT [null ]open FROM tableName>
  testFirst(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT []FIRST 5 alias.column...> but was:<SELECT [null ]FIRST 5 alias.column...>
  testIlike(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT []col1 FROM table1 WHE...> but was:<SELECT [null ]col1 FROM table1 WHE...>
  testIsNot(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT []* FROM test WHERE a ...> but was:<SELECT [null ]* FROM test WHERE a ...>
  testLimit(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT []* FROM mytable WHERE...> but was:<SELECT [null ]* FROM mytable WHERE...>
  testSigns(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [](-(1)), -(1), (-(col...> but was:<SELECT [null ](-(1)), -(1), (-(col...>
  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 LIM...> but was:<(SELECT [null * FROM mytable WHERE mytable.col = 9) UNION (SELECT null * FROM mytable3 WHERE mytable3.col = ?) UNION (SELECT null] * FROM mytable2 LIM...>
  testRegexpLike1(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT []* FROM mytable WHERE...> but was:<SELECT [null ]* FROM mytable WHERE...>
  testRegexpLike2(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT []CASE WHEN REGEXP_LIK...> but was:<SELECT [null ]CASE WHEN REGEXP_LIK...>
  testRegexpMySQL(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT []* FROM mytable WHERE...> but was:<SELECT [null ]* FROM mytable WHERE...>
  testCase(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT []a, CASE b WHEN 1 THE...> but was:<SELECT [null ]a, CASE b WHEN 1 THE...>
  testCast(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT []CAST(a AS varchar) F...> but was:<SELECT [null ]CAST(a AS varchar) F...>
  testFrom(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [* FROM mytable AS mytable0, mytable1 alias_tab1, mytable2 AS alias_tab2, (SELECT] * FROM mytable3) AS...> but was:<SELECT [null * FROM mytable AS mytable0, mytable1 alias_tab1, mytable2 AS alias_tab2, (SELECT null] * FROM mytable3) AS...>
  testJoin(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT []* FROM tab1 LEFT OUT...> but was:<SELECT [null ]* FROM tab1 LEFT OUT...>
  testLike(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT []* FROM tab1 WHERE a ...> but was:<SELECT [null ]* FROM tab1 WHERE a ...>
  testSkip(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [SKIP 5 ]alias.columnName1, a...> but was:<SELECT []alias.columnName1, a...>
  testTime(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT []* FROM tab1 WHERE a ...> but was:<SELECT [null ]* FROM tab1 WHERE a ...>
  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, THI...> but was:<...MPCOUNT) AS (SELECT [null OTHERS.WORKDEPT, AVG(OTHERS.SALARY), COUNT(*) FROM EMPLOYEE AS OTHERS GROUP BY OTHERS.WORKDEPT), DINFOMAX AS (SELECT null MAX(AVGSALARY) AS AVGMAX FROM DINFO) SELECT null] THIS_EMP.EMPNO, THI...>
  testJsonExpression(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT []data->'images'->'thu...> but was:<SELECT [null ]data->'images'->'thu...>
  testConcatProblem2_5_1(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [](a || b) || c FROM t...> but was:<SELECT [null ](a || b) || c FROM t...>
  testConcatProblem2_5_2(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [](a + b) + c FROM tes...> but was:<SELECT [null ](a + b) + c FROM tes...>
  testProblemSqlAnalytic8Complex(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT []ID, NAME, SALARY, SU...> but was:<SELECT [null ]ID, NAME, SALARY, SU...>
  testWithUnionAllProblem(net.sf.jsqlparser.test.select.SelectTest): expected:<...TH test AS ((SELECT [mslink FROM tablea) UNION ALL (SELECT mslink FROM tableb)) SELECT * FROM tablea WHERE mslink IN (SELECT] mslink FROM test)> but was:<...TH test AS ((SELECT [null mslink FROM tablea) UNION ALL (SELECT null mslink FROM tableb)) SELECT null * FROM tablea WHERE mslink IN (SELECT null] mslink FROM test)>
  testOracleJoin2_1(net.sf.jsqlparser.test.select.SelectTest): expected:<select[]*from tabelle1,tabel...> but was:<select[ null]*from tabelle1,tabel...>
  testOracleJoin2_2(net.sf.jsqlparser.test.select.SelectTest): expected:<select[]*from tabelle1,tabel...> but was:<select[ null]*from tabelle1,tabel...>
  testOracleJoin3_1(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT []* FROM tabelle1, tab...> but was:<SELECT [null ]* FROM tabelle1, tab...>
  testAnyConditionSubSelect(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [e1.empno, e1.sal FROM emp e1 WHERE e1.sal > ANY (SELECT] e2.sal FROM emp e2 ...> but was:<SELECT [null e1.empno, e1.sal FROM emp e1 WHERE e1.sal > ANY (SELECT null] e2.sal FROM emp e2 ...>
  testPivotXml1(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT []* FROM mytable PIVOT...> but was:<SELECT [null ]* FROM mytable PIVOT...>
  testPivotXml2(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT []* FROM mytable PIVOT...> but was:<SELECT [null ]* FROM mytable PIVOT...>
  testPivotXml3(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT []* FROM mytable PIVOT...> but was:<SELECT [null ]* FROM mytable PIVOT...>
  testIssue162_doubleUserVar(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT []@@SPID AS ID, SYSTEM...> but was:<SELECT [null ]@@SPID AS ID, SYSTEM...>
  testSelectWithBrackets2(net.sf.jsqlparser.test.select.SelectTest): expected:<(SELECT []1)> but was:<(SELECT [null ]1)>
  testOrderByNullsFirst(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT []a FROM tab1 ORDER BY...> but was:<SELECT [null ]a FROM tab1 ORDER BY...>
  testMultiTableJoin(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT []* FROM taba INNER JO...> but was:<SELECT [null ]* FROM taba INNER JO...>
  testProblemSqlServer_Modulo_mod(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT []mod(5, 2) FROM A> but was:<SELECT [null ]mod(5, 2) FROM A>
  testProblemSqlAnalytic(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT []a, row_number() OVER...> but was:<SELECT [null ]a, row_number() OVER...>
  testIssue160_signedParameter2(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT []* FROM mytable WHERE...> but was:<SELECT [null ]* FROM mytable WHERE...>
  testAdditionalLettersSpanish(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT []* FROM años> but was:<SELECT [null ]* FROM años>
  testLateral1(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT []O.ORDERID, O.CUSTNAM...> but was:<SELECT [null ]O.ORDERID, O.CUSTNAM...>
  testSelectNumericBind(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT []a FROM b WHERE c = :...> but was:<SELECT [null ]a FROM b WHERE c = :...>
  testRegexpBinaryMySQL(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT []* FROM mytable WHERE...> but was:<SELECT [null ]* FROM mytable WHERE...>
  testMultiValueIn(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [* FROM mytable WHERE (a, b, c) IN (SELECT] a, b, c FROM mytabl...> but was:<SELECT [null * FROM mytable WHERE (a, b, c) IN (SELECT null] a, b, c FROM mytabl...>
  testProblemSqlIntersect(net.sf.jsqlparser.test.select.SelectTest): expected:<(SELECT [* FROM a) INTERSECT (SELECT] * FROM b)> but was:<(SELECT [null * FROM a) INTERSECT (SELECT null] * FROM b)>
  testProblemFunction(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT []test() FROM testtabl...> but was:<SELECT [null ]test() FROM testtabl...>
  testConcatProblem2(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT []MAX((((((SPA.SOORTAA...> but was:<SELECT [null ]MAX((((((SPA.SOORTAA...>
  testBitwise(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT []col1 & 32, col2 ^ co...> but was:<SELECT [null ]col1 & 32, col2 ^ co...>
  testSelectInto1(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT []* INTO user_copy FRO...> but was:<SELECT [null ]* INTO user_copy FRO...>
  testSelectItems(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT []myid AS MYID, mycol,...> but was:<SELECT [null ]myid AS MYID, mycol,...>
  testSelectJoin2(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT []* FROM pg_constraint...> but was:<SELECT [null ]* FROM pg_constraint...>
  testBrackets2(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [][a] FROM t> but was:<SELECT [null ][a] FROM t>
  testProblemSqlServer_Modulo_Proz(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT []5 % 2 FROM A> but was:<SELECT [null ]5 % 2 FROM A>
  testFirstWithKeywordLimit(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT []LIMIT ? alias.column...> but was:<SELECT [null ]LIMIT ? alias.column...>
  testGroupConcat(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT []student_name, GROUP_...> but was:<SELECT [null ]student_name, GROUP_...>
  testWithRecursive(net.sf.jsqlparser.test.select.SelectTest): expected:<...E t (n) AS ((SELECT [1) UNION ALL (SELECT n + 1 FROM t WHERE n < 100)) SELECT] sum(n) FROM t> but was:<...E t (n) AS ((SELECT [null 1) UNION ALL (SELECT null n + 1 FROM t WHERE n < 100)) SELECT null] sum(n) FROM t>
  testSelectKeepOver(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT []MIN(salary) KEEP (DE...> but was:<SELECT [null ]MIN(salary) KEEP (DE...>
  testFunctionRight(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT []right(table1.col1, 4...> but was:<SELECT [null ]right(table1.col1, 4...>
  testSelectBrackets(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT []avg((123.250)::numer...> but was:<SELECT [null ]avg((123.250)::numer...>
  testMultiPartColumnName(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT []columnName FROM tabl...> but was:<SELECT [null ]columnName FROM tabl...>
  testWithUnionProblem3(net.sf.jsqlparser.test.select.SelectTest): expected:<...TH test AS ((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 = 0) UNION ALL (SELECT mslink FROM tableb)) SELECT * FROM tablea WHERE mslink IN (SELECT] mslink FROM test)> but was:<...TH test AS ((SELECT [null 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 = 0) UNION ALL (SELECT null mslink FROM tableb)) SELECT null * FROM tablea WHERE mslink IN (SELECT null] mslink FROM test)>
  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...> but was:<...TH hist AS ((SELECT [null 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 null 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 null mslink, space(level * 4) + txt AS txt, nr, feature, path FROM hist WHERE EXISTS (SELECT null] feature FROM tablec...>
  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] * FROM hist> but was:<...TH hist AS ((SELECT [null 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 null 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 null] * FROM hist>
  testValues2(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT []* FROM (VALUES 1, 2,...> but was:<SELECT [null ]* FROM (VALUES 1, 2,...>
  testValues3(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT []* FROM (VALUES 1, 2,...> but was:<SELECT [null ]* FROM (VALUES 1, 2,...>
  testValues4(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT []* FROM (VALUES (1, 2...> but was:<SELECT [null ]* FROM (VALUES (1, 2...>
  testValues5(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT []X, Y FROM (VALUES (0...> but was:<SELECT [null ]X, Y FROM (VALUES (0...>
  testGroupBy(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT []* FROM tab1 WHERE a ...> but was:<SELECT [null ]* FROM tab1 WHERE a ...>
  testMultiPartColumnNameWithTableName(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT []tableName.columnName...> but was:<SELECT [null ]tableName.columnName...>
  testMultiPartTableNameWithDatabaseName(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT []columnName FROM data...> but was:<SELECT [null ]columnName FROM data...>
  testLimitSqlServer1(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT []* FROM mytable WHERE...> but was:<SELECT [null ]* FROM mytable WHERE...>
  testLimitSqlServer2(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT []* FROM mytable WHERE...> but was:<SELECT [null ]* FROM mytable WHERE...>
  testLimitSqlServer3(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT []* FROM mytable WHERE...> but was:<SELECT [null ]* FROM mytable WHERE...>
  testLimitSqlServer4(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT []* FROM mytable WHERE...> but was:<SELECT [null ]* FROM mytable WHERE...>
  testPivotFunction(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [to_char((SELECT col1 FROM (SELECT] times_purchased, st...> but was:<SELECT [null to_char((SELECT null col1 FROM (SELECT null] times_purchased, st...>
  testMultiPartTableNameWithServerNameAndDatabaseName(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT []columnName FROM [ser...> but was:<SELECT [null ]columnName FROM [ser...>
  testConcatProblem2_1(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT []TO_CHAR(SPA.AANLEVER...> but was:<SELECT [null ]TO_CHAR(SPA.AANLEVER...>
  testConcatProblem2_2(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT []MAX((SPA.SOORTAANLEV...> but was:<SELECT [null ]MAX((SPA.SOORTAANLEV...>
  testConcatProblem2_3(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT []TO_CHAR((10000 - SPA...> but was:<SELECT [null ]TO_CHAR((10000 - SPA...>
  testConcatProblem2_4(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [](SPA.GESLACHT)::VARC...> but was:<SELECT [null ](SPA.GESLACHT)::VARC...>
  testConcatProblem2_5(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT []max((a || b) || c) F...> but was:<SELECT [null ]max((a || b) || c) F...>
  testConcatProblem2_6(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT []max(a || b || c) FRO...> but was:<SELECT [null ]max(a || b || c) FRO...>
  testMultiPartColumnNameWithDatabaseNameAndSchemaNameAndTableName(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT []databaseName.schemaN...> but was:<SELECT [null ]databaseName.schemaN...>
  testMultiPartColumnNameWithDatabaseNameAndTableName(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT []databaseName..tableN...> but was:<SELECT [null ]databaseName..tableN...>
  testReplaceAsFunction(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT []REPLACE(a, 'b', c) F...> but was:<SELECT [null ]REPLACE(a, 'b', c) F...>
  testSelectJPQLPositionalParameter(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT []email FROM users WHE...> but was:<SELECT [null ]email FROM users WHE...>
  testSelectWithinGroup(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT []LISTAGG(col1, '##') ...> but was:<SELECT [null ]LISTAGG(col1, '##') ...>
  testNotEqualsTo(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT []* FROM foo WHERE a !...> but was:<SELECT [null ]* FROM foo WHERE a !...>
  testSelectForUpdate(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT []* FROM user_table FO...> but was:<SELECT [null ]* FROM user_table FO...>
  testProblemSqlAnalytic10Lag(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT []a, lag(a, 1) OVER (P...> but was:<SELECT [null ]a, lag(a, 1) OVER (P...>
  testProblemSqlAnalytic11Lag(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT []a, lag(a, 1, 0) OVER...> but was:<SELECT [null ]a, lag(a, 1, 0) OVER...>
  testMatches(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT []* FROM team WHERE te...> but was:<SELECT [null ]* FROM team WHERE te...>
  testAnalyticFunctionProblem1(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT []last_value(s.revenue...> but was:<SELECT [null ]last_value(s.revenue...>
  testFunctions(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT []MAX(id) AS max FROM ...> but was:<SELECT [null ]MAX(id) AS max FROM ...>
  testProblemFunction2(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT []sysdate FROM testtab...> but was:<SELECT [null ]sysdate FROM testtab...>
  testProblemFunction3(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT []TRUNCATE(col) FROM t...> but was:<SELECT [null ]TRUNCATE(col) FROM t...>
  testSelectOrderHaving(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT []units, count(units) ...> but was:<SELECT [null ]units, count(units) ...>
  testAnalyticFunction12(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT []SUM(a) OVER (PARTITI...> but was:<SELECT [null ]SUM(a) OVER (PARTITI...>
  testAnalyticFunction13(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT []SUM(a) OVER () FROM ...> but was:<SELECT [null ]SUM(a) OVER () FROM ...>
  testAnalyticFunction14(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT []SUM(a) OVER (PARTITI...> but was:<SELECT [null ]SUM(a) OVER (PARTITI...>
  testAnalyticFunction15(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT []SUM(a) OVER (ORDER B...> but was:<SELECT [null ]SUM(a) OVER (ORDER B...>
  testAnalyticFunction16(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT []SUM(a) OVER (ORDER B...> but was:<SELECT [null ]SUM(a) OVER (ORDER B...>
  testAnalyticFunction17(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT []AVG(sal) OVER (PARTI...> but was:<SELECT [null ]AVG(sal) OVER (PARTI...>
  testAnalyticFunction18(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT []AVG(sal) OVER (PARTI...> but was:<SELECT [null ]AVG(sal) OVER (PARTI...>
  testMultiPartTableNameWithServerNameAndDatabaseNameAndSchemaName(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT []columnName FROM [ser...> but was:<SELECT [null ]columnName FROM [ser...>
  testBrackets(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT []table_a.name AS [Tes...> but was:<SELECT [null ]table_a.name AS [Tes...>
  testWithStatement(net.sf.jsqlparser.test.select.SelectTest): expected:<...ITH test AS (SELECT [mslink FROM feature) SELECT * FROM feature WHERE mslink IN (SELECT] mslink FROM test)> but was:<...ITH test AS (SELECT [null mslink FROM feature) SELECT null * FROM feature WHERE mslink IN (SELECT null] mslink FROM test)>
  testIssue154_2(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT []r.id, r.uuid, r.name...> but was:<SELECT [null ]r.id, r.uuid, r.name...>
  testTimestamp(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT []* FROM tab1 WHERE a ...> but was:<SELECT [null ]* FROM tab1 WHERE a ...>
  testProblemSqlAnalytic5AggregateColumnValue(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT []a, sum(b) OVER () AS...> but was:<SELECT [null ]a, sum(b) OVER () AS...>
  testMultiPartTableNameWithColumnName(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT []columnName FROM tabl...> but was:<SELECT [null ]columnName FROM tabl...>
  testFunctionLeft(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT []left(table1.col1, 4)...> but was:<SELECT [null ]left(table1.col1, 4)...>
  testCharacterSetClause(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT []DISTINCT CAST(`view0...> but was:<SELECT [null ]DISTINCT CAST(`view0...>
  testComplexUnion1(net.sf.jsqlparser.test.select.SelectTest): expected:<(SELECT ['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(...> but was:<(SELECT [null '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 null] 'cde-' || coalesce(...>
  testProblemSqlAnalytic6AggregateColumnValue(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT []a, sum(b + 5) OVER (...> but was:<SELECT [null ]a, sum(b + 5) OVER (...>
  testDistinct(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT []DISTINCT ON (myid) m...> but was:<SELECT [null ]DISTINCT ON (myid) m...>
  testMultiPartColumnNameWithSchemaNameAndTableName(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT []schemaName.tableName...> but was:<SELECT [null ]schemaName.tableName...>
  testMultiPartTableNameWithServerName(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT []columnName FROM [ser...> but was:<SELECT [null ]columnName FROM [ser...>
  testProblemSqlAnalytic7Count(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT []count(*) OVER () AS ...> but was:<SELECT [null ]count(*) OVER () AS ...>
  testSelectFunction(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT []1 + 2 AS sum> but was:<SELECT [null ]1 + 2 AS sum>
  testIssue160_signedParameter(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT []start_date WHERE sta...> but was:<SELECT [null ]start_date WHERE sta...>
  testAllColumnsFromTable(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT []tableName.* FROM tab...> but was:<SELECT [null ]tableName.* FROM tab...>
  testProblemSqlCombinedSets(net.sf.jsqlparser.test.select.SelectTest): expected:<(SELECT [* FROM a) INTERSECT (SELECT * FROM b) UNION (SELECT] * FROM c)> but was:<(SELECT [null * FROM a) INTERSECT (SELECT null * FROM b) UNION (SELECT null] * FROM c)>
  testInterval1(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT []5 + INTERVAL '3 days...> but was:<SELECT [null ]5 + INTERVAL '3 days...>
  testInterval2(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT []to_timestamp(to_char...> but was:<SELECT [null ]to_timestamp(to_char...>
  testInterval3(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT []5 + INTERVAL '3' day> but was:<SELECT [null ]5 + INTERVAL '3' day>
  testInterval4(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT []'2008-12-31 23:59:59...> but was:<SELECT [null ]'2008-12-31 23:59:59...>
  testConcat(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT []a || b || c + 4 FROM...> but was:<SELECT [null ]a || b || c + 4 FROM...>
  testCount2(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT []count(ALL col1 + col...> but was:<SELECT [null ]count(ALL col1 + col...>
  testSignedColumns(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT []-columnName, +column...> but was:<SELECT [null ]-columnName, +column...>
  testDouble(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT []1e2, * FROM mytable ...> but was:<SELECT [null ]1e2, * FROM mytable ...>
  testProblemSqlMinus(net.sf.jsqlparser.test.select.SelectTest): expected:<(SELECT [* FROM a) MINUS (SELECT] * FROM b)> but was:<(SELECT [null * FROM a) MINUS (SELECT null] * FROM b)>
  testExists(net.sf.jsqlparser.test.select.SelectTest): expected:<EXISTS (SELECT []* FROM tab2)> but was:<EXISTS (SELECT [null ]* FROM tab2)>
  testMultiPartTableNameWithServerProblem(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT []* FROM LINK_100.htsa...> but was:<SELECT [null ]* FROM LINK_100.htsa...>
  testGroupByExpression(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT []col1, col2, col1 + c...> but was:<SELECT [null ]col1, col2, col1 + c...>
  testHaving(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT []MAX(tab1.b) FROM tab...> but was:<SELECT [null ]MAX(tab1.b) FROM tab...>
  testIssue154(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT []d.id, d.uuid, d.name...> but was:<SELECT [null ]d.id, d.uuid, d.name...>
  testDistinctTop(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT []DISTINCT TOP 5 myid,...> but was:<SELECT [null ]DISTINCT TOP 5 myid,...>
  testSelectUserVariable(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT []@col FROM t1> but was:<SELECT [null ]@col FROM t1>
  testIsNot2(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT []* FROM test WHERE a ...> but was:<SELECT [null ]* FROM test WHERE a ...>
  testTopWithParenthesis(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT []TOP (5) PERCENT alia...> but was:<SELECT [null ]TOP (5) PERCENT alia...>
  testSelectOracleColl(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT []* FROM the_table tt ...> but was:<SELECT [null ]* FROM the_table tt ...>
  testOracleJoin(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT []* FROM tabelle1, tab...> but was:<SELECT [null ]* FROM tabelle1, tab...>
  testPostgreSQLRegExpCaseSensitiveMatch2(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT []a, b FROM foo WHERE ...> but was:<SELECT [null ]a, b FROM foo WHERE ...>
  testPostgreSQLRegExpCaseSensitiveMatch3(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT []a, b FROM foo WHERE ...> but was:<SELECT [null ]a, b FROM foo WHERE ...>
  testPostgreSQLRegExpCaseSensitiveMatch4(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT []a, b FROM foo WHERE ...> but was:<SELECT [null ]a, b FROM foo WHERE ...>
  testRowConstructor1(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [* FROM t1 WHERE (col1, col2) = (SELECT] col3, col4 FROM t2 ...> but was:<SELECT [null * FROM t1 WHERE (col1, col2) = (SELECT null] col3, col4 FROM t2 ...>
  testRowConstructor2(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [* FROM t1 WHERE ROW(col1, col2) = (SELECT] col3, col4 FROM t2 ...> but was:<SELECT [null * FROM t1 WHERE ROW(col1, col2) = (SELECT null] col3, col4 FROM t2 ...>
  testLimit2(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT []* FROM mytable WHERE...> but was:<SELECT [null ]* FROM mytable WHERE...>
  testTableCrossJoin(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT []* FROM taba CROSS JO...> but was:<SELECT [null ]* FROM taba CROSS JO...>
  testProblemSqlAnalytic2(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT []a, row_number() OVER...> but was:<SELECT [null ]a, row_number() OVER...>
  testProblemSqlAnalytic3(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT []a, row_number() OVER...> but was:<SELECT [null ]a, row_number() OVER...>
  testProblemSqlAnalytic9CommaListPartition(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT []a, row_number() OVER...> but was:<SELECT [null ]a, row_number() OVER...>
  testSelectWithoutFrom(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT []footable.foocolumn> but was:<SELECT [null ]footable.foocolumn>
  testOracleHierarchicalQuery(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT []last_name, employee_...> but was:<SELECT [null ]last_name, employee_...>
  testPivot1(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT []* FROM mytable PIVOT...> but was:<SELECT [null ]* FROM mytable PIVOT...>
  testPivot2(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT []* FROM mytable PIVOT...> but was:<SELECT [null ]* FROM mytable PIVOT...>
  testPivot3(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT []* FROM mytable PIVOT...> but was:<SELECT [null ]* FROM mytable PIVOT...>
  testPivot4(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT []* FROM mytable PIVOT...> but was:<SELECT [null ]* FROM mytable PIVOT...>
  testPivot5(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT []* FROM mytable PIVOT...> but was:<SELECT [null ]* FROM mytable PIVOT...>
  testSelectWithBrackets(net.sf.jsqlparser.test.select.SelectTest): expected:<(SELECT []1 FROM mytable)> but was:<(SELECT [null ]1 FROM mytable)>
  testAnalyticFunctionProblem1b(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT []last_value(s.revenue...> but was:<SELECT [null ]last_value(s.revenue...>
  testDeparser(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT []a.OWNERLASTNAME, a.O...> but was:<SELECT [null ]a.OWNERLASTNAME, a.O...>
  testPivotXmlSubquery1(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [* FROM (SELECT] times_purchased, st...> but was:<SELECT [null * FROM (SELECT null] times_purchased, st...>
  testOracleHierarchicalQuery2(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT []employee_id, last_na...> but was:<SELECT [null ]employee_id, last_na...>
  testOracleHierarchicalQuery3(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT []last_name, employee_...> but was:<SELECT [null ]last_name, employee_...>
  testOracleHierarchicalQuery4(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT []last_name, employee_...> but was:<SELECT [null ]last_name, employee_...>
  testExtractFrom1(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT []EXTRACT(month FROM d...> but was:<SELECT [null ]EXTRACT(month FROM d...>
  testExtractFrom2(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT []EXTRACT(year FROM no...> but was:<SELECT [null ]EXTRACT(year FROM no...>
  testExtractFrom3(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT []EXTRACT(year FROM (n...> but was:<SELECT [null ]EXTRACT(year FROM (n...>
  testExtractFrom4(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT []EXTRACT(minutes FROM...> but was:<SELECT [null ]EXTRACT(minutes FROM...>
  testProblemSqlAnalytic4EmptyOver(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT []a, row_number() OVER...> but was:<SELECT [null ]a, row_number() OVER...>
  testCastTypeProblem(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT []CAST(col1 AS varchar...> but was:<SELECT [null ]CAST(col1 AS varchar...>
  testSelectKeywordPercent(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT []percent FROM MY_TABL...> but was:<SELECT [null ]percent FROM MY_TABL...>
  testValues(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT []* FROM (VALUES (1, 2...> but was:<SELECT [null ]* FROM (VALUES (1, 2...>
  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...> but was:<SELECT [null I FROM (VALUES 1, 2, 3) AS MY_TEMP_TABLE(I) WHERE I IN (SELECT null] * FROM (VALUES 1, 2...>
  testProblemSqlExcept(net.sf.jsqlparser.test.select.SelectTest): expected:<(SELECT [* FROM a) EXCEPT (SELECT] * FROM b)> but was:<(SELECT [null * FROM a) EXCEPT (SELECT null] * FROM b)>
  testMultiPartTableNameWithServerNameAndSchemaName(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT []columnName FROM [ser...> but was:<SELECT [null ]columnName FROM [ser...>
  testProblemSqlServer_Modulo(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT []convert(varchar(255)...> but was:<SELECT [null ]convert(varchar(255)...>
  testReservedKeyword(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT []cast, do, extract, f...> but was:<SELECT [null ]cast, do, extract, f...>
  testLimitSqlServerJdbcParameters(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT []* FROM mytable WHERE...> but was:<SELECT [null ]* FROM mytable WHERE...>
  testSelectJoin(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT []pg_class.relname, pg...> but was:<SELECT [null ]pg_class.relname, pg...>
  testSelectKeep(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT []col1, min(col2) KEEP...> but was:<SELECT [null ]col1, min(col2) KEEP...>
  testCaseElseAddition(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT []CASE WHEN 1 + 3 > 20...> but was:<SELECT [null ]CASE WHEN 1 + 3 > 20...>
  testNamedParameter2(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT []* FROM mytable WHERE...> but was:<SELECT [null ]* FROM mytable WHERE...>
  testBooleanFunction1(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT []* FROM mytable WHERE...> but was:<SELECT [null ]* FROM mytable WHERE...>
  testCastInCast2(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT []CAST('test' + CAST(a...> but was:<SELECT [null ]CAST('test' + CAST(a...>
  testNamedParameter(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT []* FROM mytable WHERE...> but was:<SELECT [null ]* FROM mytable WHERE...>

Tests run: 353, Failures: 222, Errors: 0, Skipped: 0

[INFO] ------------------------------------------------------------------------
[INFO] BUILD FAILURE
[INFO] ------------------------------------------------------------------------
[INFO] Total time: 15.425s
[INFO] Finished at: Tue Oct 06 09:01:44 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
