[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/statement/select/PlainSelect.java
[INFO] Scan 164 files header done in 223.242ms.
[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.056 sec
Running net.sf.jsqlparser.test.create.CreateTableTest
Tests run: 27, Failures: 2, Errors: 0, Skipped: 0, Time elapsed: 0.135 sec <<< FAILURE!
Running net.sf.jsqlparser.test.create.CreateIndexTest
Tests run: 6, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.001 sec
Running net.sf.jsqlparser.test.create.CreateViewTest
Tests run: 8, Failures: 8, Errors: 0, Skipped: 0, Time elapsed: 0.009 sec <<< FAILURE!
Running net.sf.jsqlparser.test.delete.DeleteTest
Tests run: 2, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.002 sec
Running net.sf.jsqlparser.test.simpleparsing.CCJSqlParserManagerTest
Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.173 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: 3, Errors: 0, Skipped: 0, Time elapsed: 0.036 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.006 sec <<< FAILURE!
Running net.sf.jsqlparser.test.replace.ReplaceTest
Tests run: 4, Failures: 1, Errors: 0, Skipped: 0, Time elapsed: 0.003 sec <<< FAILURE!
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.003 sec
Running net.sf.jsqlparser.test.select.SpecialOracleTest
Oct 06, 2015 7:50:53 AM net.sf.jsqlparser.test.select.SpecialOracleTest testAllSqlsParseDeparse
INFO: testing string01.sql
Oct 06, 2015 7:50:53 AM net.sf.jsqlparser.test.select.SpecialOracleTest testAllSqlsParseDeparse
INFO:    -> PROBLEM net.sf.jsqlparser.JSQLParserException
Oct 06, 2015 7:50:53 AM net.sf.jsqlparser.test.select.SpecialOracleTest testAllSqlsParseDeparse
INFO: testing returning01.sql
Oct 06, 2015 7:50:53 AM net.sf.jsqlparser.test.select.SpecialOracleTest testAllSqlsParseDeparse
INFO:    -> PROBLEM net.sf.jsqlparser.JSQLParserException
Oct 06, 2015 7:50:53 AM net.sf.jsqlparser.test.select.SpecialOracleTest testAllSqlsParseDeparse
INFO: testing keywordasidentifier05.sql
Oct 06, 2015 7:50:53 AM net.sf.jsqlparser.test.select.SpecialOracleTest testAllSqlsOnlyParse
INFO: testing comment02.sql
Oct 06, 2015 7:50:53 AM net.sf.jsqlparser.test.select.SpecialOracleTest testAllSqlsOnlyParse
INFO:    -> SUCCESS
Oct 06, 2015 7:50:53 AM net.sf.jsqlparser.test.select.SpecialOracleTest testAllSqlsOnlyParse
INFO: testing numbers02.sql
Oct 06, 2015 7:50:53 AM net.sf.jsqlparser.test.select.SpecialOracleTest testAllSqlsOnlyParse
INFO:    -> SUCCESS
Oct 06, 2015 7:50:53 AM net.sf.jsqlparser.test.select.SpecialOracleTest testAllSqlsOnlyParse
INFO: testing comment01.sql
Oct 06, 2015 7:50:53 AM net.sf.jsqlparser.test.select.SpecialOracleTest testAllSqlsOnlyParse
INFO:    -> SUCCESS
Tests run: 2, Failures: 1, Errors: 0, Skipped: 0, Time elapsed: 0.083 sec <<< FAILURE!
Running net.sf.jsqlparser.test.select.SelectTest
Tests run: 228, Failures: 207, Errors: 0, Skipped: 0, Time elapsed: 0.587 sec <<< FAILURE!
Running net.sf.jsqlparser.test.select.SpeedTest
42500 statements parsed in 7766 milliseconds
 (5472 statements per second,  0.0001827 seconds per statement )
38500 select scans for table name executed in 134 milliseconds
 (287313 select scans for table name per second,  0.0000035 seconds per select scans for table name)
Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 7.887 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.01 sec
Running net.sf.jsqlparser.util.ConnectExpressionsVisitorTest
Tests run: 2, Failures: 2, Errors: 0, Skipped: 0, Time elapsed: 0.004 sec <<< FAILURE!
Running net.sf.jsqlparser.util.AddAliasesVisitorTest
Tests run: 4, Failures: 4, Errors: 0, Skipped: 0, Time elapsed: 0.002 sec <<< FAILURE!
Running net.sf.jsqlparser.util.SelectUtilsTest
Tests run: 6, Failures: 6, Errors: 0, Skipped: 0, Time elapsed: 0.005 sec <<< FAILURE!
Running net.sf.jsqlparser.expression.ExpressionVisitorAdapterTest
Tests run: 2, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.001 sec
Running net.sf.jsqlparser.expression.SignedExpressionTest
Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0 sec
Running net.sf.jsqlparser.schema.ServerTest
Tests run: 2, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.001 sec
Running net.sf.jsqlparser.parser.CCJSqlParserUtilTest
Tests run: 3, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.002 sec
Running net.sf.jsqlparser.statement.SetStatementTest
Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.005 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: 1, Errors: 0, Skipped: 0, Time elapsed: 0 sec <<< FAILURE!
Running net.sf.jsqlparser.statement.execute.ExecuteTest
Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0 sec

Results :

Failed tests:   testCreateTableAsSelect(net.sf.jsqlparser.test.create.CreateTableTest): expected:<...CT col1, col2 FROM b[]> but was:<...CT col1, col2 FROM b[ WHERE null]>
  testCreateTableAsSelect2(net.sf.jsqlparser.test.create.CreateTableTest): expected:<... col3 FROM testtable[) SELECT col1, col2, col3 FROM b INNER JOIN a ON b.col1 = a.col1]> but was:<... col3 FROM testtable[ WHERE null) SELECT col1, col2, col3 FROM b INNER JOIN a ON b.col1 = a.col1 WHERE null]>
  testCreateView2(net.sf.jsqlparser.test.create.CreateViewTest): expected:<... SELECT * FROM mytab[]> but was:<... SELECT * FROM mytab[ WHERE null]>
  testCreateView3(net.sf.jsqlparser.test.create.CreateViewTest): expected:<... SELECT * FROM mytab[]> but was:<... SELECT * FROM mytab[ WHERE null]>
  testCreateView4(net.sf.jsqlparser.test.create.CreateViewTest): expected:<...col1 = testtab2.col2[]> but was:<...col1 = testtab2.col2[ WHERE null]>
  testCreateView5(net.sf.jsqlparser.test.create.CreateViewTest): expected:<...(SELECT * FROM mytab[])> but was:<...(SELECT * FROM mytab[ WHERE null])>
  testCreateView(net.sf.jsqlparser.test.create.CreateViewTest): expected:<... SELECT * FROM mytab[]> but was:<... SELECT * FROM mytab[ WHERE null]>
  testCreateViewUnion(net.sf.jsqlparser.test.create.CreateViewTest): expected:<...CT a, b FROM testtab[) UNION (SELECT b, c FROM testtab2])> but was:<...CT a, b FROM testtab[ WHERE null) UNION (SELECT b, c FROM testtab2 WHERE null])>
  testCreateMaterializedView(net.sf.jsqlparser.test.create.CreateViewTest): expected:<...CT a, b FROM testtab[]> but was:<...CT a, b FROM testtab[ WHERE null]>
  testCreateViewWithColumnNames1(net.sf.jsqlparser.test.create.CreateViewTest): expected:<...CT a, b FROM testtab[]> but was:<...CT a, b FROM testtab[ WHERE null]>
  testInsertFromSelect(net.sf.jsqlparser.test.insert.InsertTest): expected:<...LECT * FROM mytable2[]> but was:<...LECT * FROM mytable2[ WHERE null]>
  testInsertWithSelect(net.sf.jsqlparser.test.insert.InsertTest): expected:<...ycolumn FROM mytable[) SELECT mycolumn FROM a]> but was:<...ycolumn FROM mytable[ WHERE null) SELECT mycolumn FROM a WHERE null]>
  testInsertSelect(net.sf.jsqlparser.test.insert.InsertTest): expected:<...ycolumn FROM mytable[]> but was:<...ycolumn FROM mytable[ WHERE null]>
  testUpdateWithSelect2(net.sf.jsqlparser.test.update.UpdateTest): expected:<..., b, c FROM mytable2[])> but was:<..., b, c FROM mytable2[ WHERE null])>
  testUpdateWithSelect(net.sf.jsqlparser.test.update.UpdateTest): expected:<...ROM SYSIBM.SYSDUMMY1[])> but was:<...ROM SYSIBM.SYSDUMMY1[ WHERE null])>
  testProblemReplaceParseDeparse(net.sf.jsqlparser.test.replace.ReplaceTest): expected:<...D, A, B FROM b_table[]> but was:<...D, A, B FROM b_table[ WHERE null]>
  testAllSqlsParseDeparse(net.sf.jsqlparser.test.select.SpecialOracleTest): expected:<...ption from exception[]> but was:<...ption from exception[ where null]>
  testSelectAliasWithoutAs(net.sf.jsqlparser.test.select.SelectTest): expected:<...n Name" FROM mytable[]> but was:<...n Name" FROM mytable[ WHERE null]>
  testAllConditionSubSelect(net.sf.jsqlparser.test.select.SelectTest): expected:<..., e1.sal FROM emp e1[ WHERE e1.sal > ALL (SELECT e2.sal FROM emp e2 WHERE e2.deptno = 10)]> but was:<..., e1.sal FROM emp e1[]>
  testSimpleSigns(net.sf.jsqlparser.test.select.SelectTest): expected:<...1, -1 FROM tableName[]> but was:<...1, -1 FROM tableName[ WHERE null]>
  testMultiValueIn2(net.sf.jsqlparser.test.select.SelectTest): expected:<...ELECT * FROM mytable[ WHERE (trim(a), trim(b)) IN (SELECT a, b FROM mytable2)]> but was:<...ELECT * FROM mytable[]>
  testSelectForUpdateOfTable(net.sf.jsqlparser.test.select.SelectTest): expected:<...bar.* FROM foo, bar [WHERE foo.id = bar.foo_id ]FOR UPDATE OF foo> but was:<...bar.* FROM foo, bar []FOR UPDATE OF foo>
  testPostgreSQLRegExpCaseSensitiveMatch(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT a, b FROM foo[ WHERE a ~ '[help].*']> but was:<SELECT a, b FROM foo[]>
  testOracleJoin2(net.sf.jsqlparser.test.select.SelectTest): expected:<...M tabelle1, tabelle2[ WHERE tabelle1.a(+) = tabelle2.b]> but was:<...M tabelle1, tabelle2[]>
  testOracleJoin3(net.sf.jsqlparser.test.select.SelectTest): expected:<...M tabelle1, tabelle2[ WHERE tabelle1.a(+) > tabelle2.b]> but was:<...M tabelle1, tabelle2[]>
  testOracleJoin4(net.sf.jsqlparser.test.select.SelectTest): expected:<...M tabelle1, tabelle2[ WHERE tabelle1.a(+) = tabelle2.b AND tabelle1.b(+) IN ('A', 'B')]> but was:<...M tabelle1, tabelle2[]>
  testMultiPartTableNameWithSchemaName(net.sf.jsqlparser.test.select.SelectTest): expected:<...schemaName.tableName[]> but was:<...schemaName.tableName[ WHERE null]>
  testSimpleAdditionsAndSubtractionsWithSigns(net.sf.jsqlparser.test.select.SelectTest): expected:<...1 - 1 FROM tableName[]> but was:<...1 - 1 FROM tableName[ WHERE null]>
  testSelectAliasInQuotes(net.sf.jsqlparser.test.select.SelectTest): expected:<...n Name" FROM mytable[]> but was:<...n Name" FROM mytable[ WHERE null]>
  testOrderBy(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT * FROM tab1 [WHERE a > 34 ]GROUP BY tab1.b ORDE...> but was:<SELECT * FROM tab1 []GROUP BY tab1.b ORDE...>
  testCastTypeProblem2(net.sf.jsqlparser.test.select.SelectTest): expected:<...archar FROM tabelle1[]> but was:<...archar FROM tabelle1[ WHERE null]>
  testCastTypeProblem3(net.sf.jsqlparser.test.select.SelectTest): expected:<... (256) FROM tabelle1[]> but was:<... (256) FROM tabelle1[ WHERE null]>
  testCastTypeProblem4(net.sf.jsqlparser.test.select.SelectTest): expected:<... (256) FROM tabelle1[]> but was:<... (256) FROM tabelle1[ WHERE null]>
  testCastTypeProblem5(net.sf.jsqlparser.test.select.SelectTest): expected:<... (256) FROM tabelle1[]> but was:<... (256) FROM tabelle1[ WHERE null]>
  testCastTypeProblem6(net.sf.jsqlparser.test.select.SelectTest): expected:<...arying FROM tabelle1[]> but was:<...arying FROM tabelle1[ WHERE null]>
  testCastTypeProblem7(net.sf.jsqlparser.test.select.SelectTest): expected:<...rying) FROM tabelle1[]> but was:<...rying) FROM tabelle1[ WHERE null]>
  testCastInCast(net.sf.jsqlparser.test.select.SelectTest): expected:<...rchar) FROM tabelle1[]> but was:<...rchar) FROM tabelle1[ WHERE null]>
  testSkipFirst(net.sf.jsqlparser.test.select.SelectTest): expected:<...ST f1 c1, c2 FROM t1[]> but was:<...ST f1 c1, c2 FROM t1[ WHERE null]>
  testMultiPartTableNameWithDatabaseNameAndSchemaName(net.sf.jsqlparser.test.select.SelectTest): expected:<...schemaName.tableName[]> but was:<...schemaName.tableName[ WHERE null]>
  testSelectJoinWithComma(net.sf.jsqlparser.test.select.SelectTest): expected:<... unigeoestados AS es[ WHERE es.nombre = "Tamaulipas" AND cb.the_geom = es.geom]> but was:<... unigeoestados AS es[]>
  testAdditionalLettersGerman(net.sf.jsqlparser.test.select.SelectTest): expected:<...lü FROM testtableäöü[]> but was:<...lü FROM testtableäöü[ WHERE null]>
  testTop(net.sf.jsqlparser.test.select.SelectTest): expected:<...TOP 3 * FROM mytable[ WHERE mytable.col = 9]> but was:<...TOP 3 * FROM mytable[]>
  testWithUnionProblem(net.sf.jsqlparser.test.select.SelectTest): expected:<...T mslink FROM tablea[) UNION (SELECT mslink FROM tableb)) SELECT * FROM tablea WHERE mslink IN (SELECT mslink FROM test)]> but was:<...T mslink FROM tablea[ WHERE null) UNION (SELECT mslink FROM tableb WHERE null)) SELECT * FROM tablea]>
  testMysqlQuote(net.sf.jsqlparser.test.select.SelectTest): expected:<... AS a, ANTIQUES AS b[ WHERE b.BUYERID = a.OWNERID AND b.ITEM = 'Chair']> but was:<... AS a, ANTIQUES AS b[]>
  testSelectInnerWith(net.sf.jsqlparser.test.select.SelectTest): expected:<...CT 'a' aid FROM DUAL[) SELECT aid FROM actor)]> but was:<...CT 'a' aid FROM DUAL[ WHERE null) SELECT aid FROM actor WHERE null) WHERE null]>
  testReservedKeyword2(net.sf.jsqlparser.test.select.SelectTest): expected:<... open FROM tableName[]> but was:<... open FROM tableName[ WHERE null]>
  testFirst(net.sf.jsqlparser.test.select.SelectTest): expected:<...ame.tableName alias []ORDER BY alias.colum...> but was:<...ame.tableName alias [WHERE null ]ORDER BY alias.colum...>
  testIlike(net.sf.jsqlparser.test.select.SelectTest): expected:<...ECT col1 FROM table1[ WHERE col1 ILIKE '%hello%']> but was:<...ECT col1 FROM table1[]>
  testIsNot(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT * FROM test[ WHERE a IS NOT NULL]> but was:<SELECT * FROM test[]>
  testLimit(net.sf.jsqlparser.test.select.SelectTest): expected:<...LECT * FROM mytable [WHERE mytable.col = 9 ]LIMIT ? OFFSET 3> but was:<...LECT * FROM mytable []LIMIT ? OFFSET 3>
  testSigns(net.sf.jsqlparser.test.select.SelectTest): expected:<...nName FROM tableName[]> but was:<...nName FROM tableName[ WHERE null]>
  testUnion(net.sf.jsqlparser.test.select.SelectTest): expected:<...ELECT * FROM mytable[ WHERE mytable.col = 9) UNION (SELECT * FROM mytable3 WHERE mytable3.col = ?) UNION (SELECT * FROM mytable2] LIMIT 4 OFFSET 3)> but was:<...ELECT * FROM mytable[) UNION (SELECT * FROM mytable3) UNION (SELECT * FROM mytable2 WHERE null] LIMIT 4 OFFSET 3)>
  testWhere(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT * FROM tab1[ WHERE (a + b + c / d + e * f) * (a / b * (a + b)) > ?]> but was:<SELECT * FROM tab1[]>
  testRegexpLike1(net.sf.jsqlparser.test.select.SelectTest): expected:<...ELECT * FROM mytable[ WHERE REGEXP_LIKE(first_name, '^Ste(v|ph)en$')]> but was:<...ELECT * FROM mytable[]>
  testRegexpLike2(net.sf.jsqlparser.test.select.SelectTest): expected:<...E 2 END FROM mytable[]> but was:<...E 2 END FROM mytable[ WHERE null]>
  testRegexpMySQL(net.sf.jsqlparser.test.select.SelectTest): expected:<...ELECT * FROM mytable[ WHERE first_name REGEXP '^Ste(v|ph)en$']> but was:<...ELECT * FROM mytable[]>
  testCase(net.sf.jsqlparser.test.select.SelectTest): expected:<...THEN 2 END FROM tab1[]> but was:<...THEN 2 END FROM tab1[ WHERE null]>
  testCast(net.sf.jsqlparser.test.select.SelectTest): expected:<...rchar) FROM tabelle1[]> but was:<...rchar) FROM tabelle1[ WHERE null]>
  testFrom(net.sf.jsqlparser.test.select.SelectTest): expected:<...LECT * FROM mytable3[) AS mytable4 WHERE mytable.col = 9]> but was:<...LECT * FROM mytable3[ WHERE null) AS mytable4]>
  testJoin(net.sf.jsqlparser.test.select.SelectTest): expected:<...ON tab1.id = tab2.id[]> but was:<...ON tab1.id = tab2.id[ WHERE null]>
  testLike(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT * FROM tab1[ WHERE a LIKE 'test']> but was:<SELECT * FROM tab1[]>
  testSkip(net.sf.jsqlparser.test.select.SelectTest): expected:<...ame.tableName alias []ORDER BY alias.colum...> but was:<...ame.tableName alias [WHERE null ]ORDER BY alias.colum...>
  testTime(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT * FROM tab1[ WHERE a > {t '04:05:34'}]> but was:<SELECT * FROM tab1[]>
  testWith(net.sf.jsqlparser.test.select.SelectTest): expected:<... EMPLOYEE AS OTHERS [GROUP BY OTHERS.WORKDEPT), DINFOMAX AS (SELECT MAX(AVGSALARY) AS AVGMAX FROM DINFO) SELECT THIS_EMP.EMPNO, THIS_EMP.SALARY, DINFO.AVGSALARY, DINFO.EMPCOUNT, DINFOMAX.AVGMAX FROM EMPLOYEE AS THIS_EMP INNER JOIN DINFO INNER JOIN DINFOMAX WHERE THIS_EMP.JOB = 'SALESREP' AND THIS_EMP.WORKDEPT = DINFO.DEPTNO]> but was:<... EMPLOYEE AS OTHERS [WHERE null GROUP BY OTHERS.WORKDEPT), DINFOMAX AS (SELECT MAX(AVGSALARY) AS AVGMAX FROM DINFO WHERE null) SELECT THIS_EMP.EMPNO, THIS_EMP.SALARY, DINFO.AVGSALARY, DINFO.EMPCOUNT, DINFOMAX.AVGMAX FROM EMPLOYEE AS THIS_EMP INNER JOIN DINFO INNER JOIN DINFOMAX]>
  testJsonExpression(net.sf.jsqlparser.test.select.SelectTest): expected:<...thumb FROM instagram[]> but was:<...thumb FROM instagram[ WHERE null]>
  testConcatProblem2_5_1(net.sf.jsqlparser.test.select.SelectTest): expected:<... || c FROM testtable[]> but was:<... || c FROM testtable[ WHERE null]>
  testConcatProblem2_5_2(net.sf.jsqlparser.test.select.SelectTest): expected:<...) + c FROM testtable[]> but was:<...) + c FROM testtable[ WHERE null]>
  testProblemSqlAnalytic8Complex(net.sf.jsqlparser.test.select.SelectTest): expected:<...AS ROWS2 FROM STAFF [WHERE ID < 60 ]ORDER BY ID> but was:<...AS ROWS2 FROM STAFF []ORDER BY ID>
  testWithUnionAllProblem(net.sf.jsqlparser.test.select.SelectTest): expected:<...T mslink FROM tablea[) UNION ALL (SELECT mslink FROM tableb)) SELECT * FROM tablea WHERE mslink IN (SELECT mslink FROM test)]> but was:<...T mslink FROM tablea[ WHERE null) UNION ALL (SELECT mslink FROM tableb WHERE null)) SELECT * FROM tablea]>
  testOracleJoin2_1(net.sf.jsqlparser.test.select.SelectTest): expected:<...om tabelle1,tabelle2[ where tabelle1.a(+)=tabelle2.b]> but was:<...om tabelle1,tabelle2[]>
  testOracleJoin2_2(net.sf.jsqlparser.test.select.SelectTest): expected:<...om tabelle1,tabelle2[ where tabelle1.a=tabelle2.b(+)]> but was:<...om tabelle1,tabelle2[]>
  testOracleJoin3_1(net.sf.jsqlparser.test.select.SelectTest): expected:<...M tabelle1, tabelle2[ WHERE tabelle1.a > tabelle2.b(+)]> but was:<...M tabelle1, tabelle2[]>
  testAnyConditionSubSelect(net.sf.jsqlparser.test.select.SelectTest): expected:<..., e1.sal FROM emp e1[ WHERE e1.sal > ANY (SELECT e2.sal FROM emp e2 WHERE e2.deptno = 10)]> but was:<..., e1.sal FROM emp e1[]>
  testPivotXml1(net.sf.jsqlparser.test.select.SelectTest): expected:<...) FOR b IN ('val1'))[]> but was:<...) FOR b IN ('val1'))[ WHERE null]>
  testPivotXml2(net.sf.jsqlparser.test.select.SelectTest): expected:<...ls FROM myothertable[))]> but was:<...ls FROM myothertable[ WHERE null)) WHERE null]>
  testPivotXml3(net.sf.jsqlparser.test.select.SelectTest): expected:<...t(a) FOR b IN (ANY))[]> but was:<...t(a) FOR b IN (ANY))[ WHERE null]>
  testOrderByNullsFirst(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT a FROM tab1 []ORDER BY a NULLS FIR...> but was:<SELECT a FROM tab1 [WHERE null ]ORDER BY a NULLS FIR...>
  testMultiTableJoin(net.sf.jsqlparser.test.select.SelectTest): expected:<...d ON tabc.c = tabd.c[]> but was:<...d ON tabc.c = tabd.c[ WHERE null]>
  testProblemSqlServer_Modulo_mod(net.sf.jsqlparser.test.select.SelectTest): expected:<...ECT mod(5, 2) FROM A[]> but was:<...ECT mod(5, 2) FROM A[ WHERE null]>
  testProblemSqlAnalytic(net.sf.jsqlparser.test.select.SelectTest): expected:<... a) AS n FROM table1[]> but was:<... a) AS n FROM table1[ WHERE null]>
  testIssue160_signedParameter2(net.sf.jsqlparser.test.select.SelectTest): expected:<...ELECT * FROM mytable[ WHERE -? = 5]> but was:<...ELECT * FROM mytable[]>
  testAdditionalLettersSpanish(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT * FROM años[]> but was:<SELECT * FROM años[ WHERE null]>
  testLateral1(net.sf.jsqlparser.test.select.SelectTest): expected:<... ORDERLINES AS LINES[ WHERE LINES.ORDERID = O.ORDERID) AS OL]> but was:<... ORDERLINES AS LINES[) AS OL WHERE null]>
  testSelectNumericBind(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT a FROM b[ WHERE c = :1]> but was:<SELECT a FROM b[]>
  testRegexpBinaryMySQL(net.sf.jsqlparser.test.select.SelectTest): expected:<...ELECT * FROM mytable[ WHERE first_name REGEXP BINARY '^Ste(v|ph)en$']> but was:<...ELECT * FROM mytable[]>
  testLateralComplex1(net.sf.jsqlparser.test.select.SelectTest): expected:<...ROM ORDERLINES LINES[ WHERE LINES.ORDERID = O.ORDERID) AS OL, LATERAL(SELECT SUM(CHGAMT) AS ORDCHGTOTAL FROM ORDERCHARGES CHARGES WHERE LINES.ORDERID = O.ORDERID) AS OC, LATERAL(SELECT SUM(TAXAMT) AS TAXTOTAL FROM ORDERTAXES TAXES WHERE TAXES.ORDERID = O.ORDERID) AS OT]> but was:<...ROM ORDERLINES LINES[) AS OL, LATERAL(SELECT SUM(CHGAMT) AS ORDCHGTOTAL FROM ORDERCHARGES CHARGES) AS OC, LATERAL(SELECT SUM(TAXAMT) AS TAXTOTAL FROM ORDERTAXES TAXES) AS OT WHERE null]>
  testMultiValueIn(net.sf.jsqlparser.test.select.SelectTest): expected:<...ELECT * FROM mytable[ WHERE (a, b, c) IN (SELECT a, b, c FROM mytable2)]> but was:<...ELECT * FROM mytable[]>
  testProblemSqlIntersect(net.sf.jsqlparser.test.select.SelectTest): expected:<(SELECT * FROM a[) INTERSECT (SELECT * FROM b])> but was:<(SELECT * FROM a[ WHERE null) INTERSECT (SELECT * FROM b WHERE null])>
  testProblemFunction(net.sf.jsqlparser.test.select.SelectTest): expected:<...est() FROM testtable[]> but was:<...est() FROM testtable[ WHERE null]>
  testConcatProblem2(net.sf.jsqlparser.test.select.SelectTest): expected:<...T_TMP FROM testtable[]> but was:<...T_TMP FROM testtable[ WHERE null]>
  testBitwise(net.sf.jsqlparser.test.select.SelectTest): expected:<...1 | col2 FROM table1[]> but was:<...1 | col2 FROM table1[ WHERE null]>
  testSelectInto1(net.sf.jsqlparser.test.select.SelectTest): expected:<... user_copy FROM user[]> but was:<... user_copy FROM user[ WHERE null]>
  testSelectItems(net.sf.jsqlparser.test.select.SelectTest): expected:<...mytab.* FROM mytable[ WHERE mytable.col = 9]> but was:<...mytab.* FROM mytable[]>
  testSelectJoin2(net.sf.jsqlparser.test.select.SelectTest): expected:<...* FROM pg_constraint[ WHERE pg_attribute.attnum = ANY(pg_constraint.conkey)]> but was:<...* FROM pg_constraint[]>
  testBrackets2(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [a] FROM t[]> but was:<SELECT [a] FROM t[ WHERE null]>
  testProblemSqlServer_Modulo_Proz(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT 5 % 2 FROM A[]> but was:<SELECT 5 % 2 FROM A[ WHERE null]>
  testFirstWithKeywordLimit(net.sf.jsqlparser.test.select.SelectTest): expected:<...ame.tableName alias []ORDER BY alias.colum...> but was:<...ame.tableName alias [WHERE null ]ORDER BY alias.colum...>
  testGroupConcat(net.sf.jsqlparser.test.select.SelectTest): expected:<...R ' ') FROM student []GROUP BY student_nam...> but was:<...R ' ') FROM student [WHERE null ]GROUP BY student_nam...>
  testWithRecursive(net.sf.jsqlparser.test.select.SelectTest): expected:<...(SELECT n + 1 FROM t[ WHERE n < 100)) SELECT sum(n) FROM t]> but was:<...(SELECT n + 1 FROM t[)) SELECT sum(n) FROM t WHERE null]>
  testSelectKeepOver(net.sf.jsqlparser.test.select.SelectTest): expected:<...rst" FROM employees []ORDER BY department_...> but was:<...rst" FROM employees [WHERE null ]ORDER BY department_...>
  testFunctionRight(net.sf.jsqlparser.test.select.SelectTest): expected:<...col1, 4) FROM table1[]> but was:<...col1, 4) FROM table1[ WHERE null]>
  testMultiPartColumnName(net.sf.jsqlparser.test.select.SelectTest): expected:<...nName FROM tableName[]> but was:<...nName FROM tableName[ WHERE null]>
  testWithUnionProblem3(net.sf.jsqlparser.test.select.SelectTest): expected:<...D 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:<...D tableb.deleted = 0[) UNION ALL (SELECT mslink FROM tableb WHERE null)) SELECT * FROM tablea]>
  testWithUnionProblem4(net.sf.jsqlparser.test.select.SelectTest): expected:<...k AND ae.deleted = 0[ WHERE gl.parent IS NULL AND gl.mslink <> 0) UNION ALL (SELECT gl.mslink, ba.gl_name AS txt, ba.gl_nummer AS nr, hist.level + 1 AS level, CAST(hist.path + '.' + CAST(gl.mslink AS VARCHAR) AS VARCHAR) AS path, ae.feature FROM tablea AS gl INNER JOIN tableb AS ba ON gl.mslink = ba.gl_mslink INNER JOIN tablec AS ae ON gl.mslink = ae.mslink AND ae.deleted = 0 INNER JOIN hist ON gl.parent = hist.mslink WHERE gl.mslink <> 0)) SELECT mslink, space(level * 4) + txt AS txt, nr, feature, path FROM hist WHERE EXISTS (SELECT feature FROM tablec WHERE mslink = 0 AND ((feature IN (1, 2) AND hist.feature = 3) OR (feature IN (4) AND hist.feature = 2)))]> but was:<...k AND ae.deleted = 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)) SELECT mslink, space(level * 4) + txt AS txt, nr, feature, path FROM hist]>
  testWithUnionProblem5(net.sf.jsqlparser.test.select.SelectTest): expected:<...k 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:<...k AND ae.deleted = 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)) SELECT * FROM hist WHERE null]>
  testValues2(net.sf.jsqlparser.test.select.SelectTest): expected:<... 1, 2, 3, 4) AS test[]> but was:<... 1, 2, 3, 4) AS test[ WHERE null]>
  testValues3(net.sf.jsqlparser.test.select.SelectTest): expected:<... 2, 3, 4) AS test(a)[]> but was:<... 2, 3, 4) AS test(a)[ WHERE null]>
  testValues4(net.sf.jsqlparser.test.select.SelectTest): expected:<...3, 4)) AS test(a, b)[]> but was:<...3, 4)) AS test(a, b)[ WHERE null]>
  testValues5(net.sf.jsqlparser.test.select.SelectTest): expected:<... MY_TEMP_TABLE(X, Y)[]> but was:<... MY_TEMP_TABLE(X, Y)[ WHERE null]>
  testGroupBy(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT * FROM tab1 [WHERE a > 34 ]GROUP BY tab1.b> but was:<SELECT * FROM tab1 []GROUP BY tab1.b>
  testMultiPartColumnNameWithTableName(net.sf.jsqlparser.test.select.SelectTest): expected:<...nName FROM tableName[]> but was:<...nName FROM tableName[ WHERE null]>
  testMultiPartTableNameWithDatabaseName(net.sf.jsqlparser.test.select.SelectTest): expected:<...abaseName..tableName[]> but was:<...abaseName..tableName[ WHERE null]>
  testLimitSqlServer1(net.sf.jsqlparser.test.select.SelectTest): expected:<...LECT * FROM mytable [WHERE mytable.col = 9 ]ORDER BY mytable.id ...> but was:<...LECT * FROM mytable []ORDER BY mytable.id ...>
  testLimitSqlServer2(net.sf.jsqlparser.test.select.SelectTest): expected:<...LECT * FROM mytable [WHERE mytable.col = 9 ]ORDER BY mytable.id ...> but was:<...LECT * FROM mytable []ORDER BY mytable.id ...>
  testLimitSqlServer3(net.sf.jsqlparser.test.select.SelectTest): expected:<...LECT * FROM mytable [WHERE mytable.col = 9 ]ORDER BY mytable.id ...> but was:<...LECT * FROM mytable []ORDER BY mytable.id ...>
  testLimitSqlServer4(net.sf.jsqlparser.test.select.SelectTest): expected:<...LECT * FROM mytable [WHERE mytable.col = 9 ]ORDER BY mytable.id ...> but was:<...LECT * FROM mytable []ORDER BY mytable.id ...>
  testPivotFunction(net.sf.jsqlparser.test.select.SelectTest): expected:<...ode FROM customers t[) PIVOT (count(state_code) FOR state_code IN ('NY', 'CT', 'NJ', 'FL', 'MO')) ORDER BY times_purchased)) FROM DUAL]> but was:<...ode FROM customers t[ WHERE null) PIVOT (count(state_code) FOR state_code IN ('NY', 'CT', 'NJ', 'FL', 'MO')) WHERE null ORDER BY times_purchased)) FROM DUAL WHERE null]>
  testMultiPartTableNameWithServerNameAndDatabaseName(net.sf.jsqlparser.test.select.SelectTest): expected:<...abaseName..tableName[]> but was:<...abaseName..tableName[ WHERE null]>
  testConcatProblem2_1(net.sf.jsqlparser.test.select.SelectTest): expected:<...CHAR) FROM testtable[]> but was:<...CHAR) FROM testtable[ WHERE null]>
  testConcatProblem2_2(net.sf.jsqlparser.test.select.SelectTest): expected:<...T_TMP FROM testtable[]> but was:<...T_TMP FROM testtable[ WHERE null]>
  testConcatProblem2_3(net.sf.jsqlparser.test.select.SelectTest): expected:<...CHAR) FROM testtable[]> but was:<...CHAR) FROM testtable[ WHERE null]>
  testConcatProblem2_4(net.sf.jsqlparser.test.select.SelectTest): expected:<...R (1) FROM testtable[]> but was:<...R (1) FROM testtable[ WHERE null]>
  testConcatProblem2_5(net.sf.jsqlparser.test.select.SelectTest): expected:<...|| c) FROM testtable[]> but was:<...|| c) FROM testtable[ WHERE null]>
  testConcatProblem2_6(net.sf.jsqlparser.test.select.SelectTest): expected:<...|| c) FROM testtable[]> but was:<...|| c) FROM testtable[ WHERE null]>
  testMultiPartColumnNameWithDatabaseNameAndSchemaNameAndTableName(net.sf.jsqlparser.test.select.SelectTest): expected:<...nName FROM tableName[]> but was:<...nName FROM tableName[ WHERE null]>
  testMultiPartColumnNameWithDatabaseNameAndTableName(net.sf.jsqlparser.test.select.SelectTest): expected:<...nName FROM tableName[]> but was:<...nName FROM tableName[ WHERE null]>
  testReplaceAsFunction(net.sf.jsqlparser.test.select.SelectTest): expected:<...a, 'b', c) FROM tab1[]> but was:<...a, 'b', c) FROM tab1[ WHERE null]>
  testSelectJPQLPositionalParameter(net.sf.jsqlparser.test.select.SelectTest): expected:<...ECT email FROM users[ WHERE (type LIKE 'B') AND (username LIKE ?1)]> but was:<...ECT email FROM users[]>
  testSelectWithinGroup(net.sf.jsqlparser.test.select.SelectTest): expected:<...BY col1) FROM table1[]> but was:<...BY col1) FROM table1[ WHERE null]>
  testNotEqualsTo(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT * FROM foo[ WHERE a != b]> but was:<SELECT * FROM foo[]>
  testSelectForUpdate(net.sf.jsqlparser.test.select.SelectTest): expected:<...T * FROM user_table []FOR UPDATE> but was:<...T * FROM user_table [WHERE null ]FOR UPDATE>
  testProblemSqlAnalytic10Lag(net.sf.jsqlparser.test.select.SelectTest): expected:<... b) AS n FROM table1[]> but was:<... b) AS n FROM table1[ WHERE null]>
  testProblemSqlAnalytic11Lag(net.sf.jsqlparser.test.select.SelectTest): expected:<... b) AS n FROM table1[]> but was:<... b) AS n FROM table1[ WHERE null]>
  testMatches(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT * FROM team[ WHERE team.search_column @@ to_tsquery('new & york & yankees')]> but was:<SELECT * FROM team[]>
  testAnalyticFunctionProblem1(net.sf.jsqlparser.test.select.SelectTest): expected:<...te_id) AS col FROM s[]> but was:<...te_id) AS col FROM s[ WHERE null]>
  testFunctions(net.sf.jsqlparser.test.select.SelectTest): expected:<... AS max FROM mytable[ WHERE mytable.col = 9]> but was:<... AS max FROM mytable[]>
  testProblemFunction2(net.sf.jsqlparser.test.select.SelectTest): expected:<...sdate FROM testtable[]> but was:<...sdate FROM testtable[ WHERE null]>
  testProblemFunction3(net.sf.jsqlparser.test.select.SelectTest): expected:<...(col) FROM testtable[]> but was:<...(col) FROM testtable[ WHERE null]>
  testSelectOrderHaving(net.sf.jsqlparser.test.select.SelectTest): expected:<...S num FROM currency []GROUP BY units HAVIN...> but was:<...S num FROM currency [WHERE null ]GROUP BY units HAVIN...>
  testAnalyticFunction12(net.sf.jsqlparser.test.select.SelectTest): expected:<...RDER BY c) FROM tab1[]> but was:<...RDER BY c) FROM tab1[ WHERE null]>
  testAnalyticFunction13(net.sf.jsqlparser.test.select.SelectTest): expected:<...a) OVER () FROM tab1[]> but was:<...a) OVER () FROM tab1[ WHERE null]>
  testAnalyticFunction14(net.sf.jsqlparser.test.select.SelectTest): expected:<...ION BY b ) FROM tab1[]> but was:<...ION BY b ) FROM tab1[ WHERE null]>
  testAnalyticFunction15(net.sf.jsqlparser.test.select.SelectTest): expected:<...RDER BY c) FROM tab1[]> but was:<...RDER BY c) FROM tab1[ WHERE null]>
  testAnalyticFunction16(net.sf.jsqlparser.test.select.SelectTest): expected:<...LLS FIRST) FROM tab1[]> but was:<...LLS FIRST) FROM tab1[ WHERE null]>
  testAnalyticFunction17(net.sf.jsqlparser.test.select.SelectTest): expected:<...current_sal FROM emp[]> but was:<...current_sal FROM emp[ WHERE null]>
  testAnalyticFunction18(net.sf.jsqlparser.test.select.SelectTest): expected:<...current_sal FROM emp[]> but was:<...current_sal FROM emp[ WHERE null]>
  testMultiPartTableNameWithServerNameAndDatabaseNameAndSchemaName(net.sf.jsqlparser.test.select.SelectTest): expected:<...schemaName.tableName[]> but was:<...schemaName.tableName[ WHERE null]>
  testBrackets(net.sf.jsqlparser.test.select.SelectTest): expected:<... [Test] FROM table_a[]> but was:<... [Test] FROM table_a[ WHERE null]>
  testWithStatement(net.sf.jsqlparser.test.select.SelectTest): expected:<... mslink FROM feature[) SELECT * FROM feature WHERE mslink IN (SELECT mslink FROM test)]> but was:<... mslink FROM feature[ WHERE null) SELECT * FROM feature]>
  testIssue154_2(net.sf.jsqlparser.test.select.SelectTest): expected:<...em_role FROM role r [WHERE r.merchant_id = ? AND r.deleted_time IS NULL ]ORDER BY r.id DESC> but was:<...em_role FROM role r []ORDER BY r.id DESC>
  testTimestamp(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT * FROM tab1[ WHERE a > {ts '2004-04-30 04:05:34.56'}]> but was:<SELECT * FROM tab1[]>
  testProblemSqlAnalytic5AggregateColumnValue(net.sf.jsqlparser.test.select.SelectTest): expected:<... () AS n FROM table1[]> but was:<... () AS n FROM table1[ WHERE null]>
  testMultiPartTableNameWithColumnName(net.sf.jsqlparser.test.select.SelectTest): expected:<...nName FROM tableName[]> but was:<...nName FROM tableName[ WHERE null]>
  testFunctionLeft(net.sf.jsqlparser.test.select.SelectTest): expected:<...col1, 4) FROM table1[]> but was:<...col1, 4) FROM table1[ WHERE null]>
  testCharacterSetClause(net.sf.jsqlparser.test.select.SelectTest): expected:<... FROM people `view0`[ WHERE `view0`.`nick2` IS NOT NULL]> but was:<... FROM people `view0`[]>
  testComplexUnion1(net.sf.jsqlparser.test.select.SelectTest): expected:<..., mytab.e FROM mytab[ WHERE mytab.del = 0) UNION (SELECT 'cde-' || coalesce(mytab2.a::varchar, '') AS a, mytab2.b, mytab2.bezeichnung AS c, 0 AS d, 0 AS e FROM mytab2 WHERE mytab2.del = 0])> but was:<..., mytab.e FROM mytab[) UNION (SELECT 'cde-' || coalesce(mytab2.a::varchar, '') AS a, mytab2.b, mytab2.bezeichnung AS c, 0 AS d, 0 AS e FROM mytab2])>
  testProblemSqlAnalytic6AggregateColumnValue(net.sf.jsqlparser.test.select.SelectTest): expected:<... a) AS n FROM table1[]> but was:<... a) AS n FROM table1[ WHERE null]>
  testDistinct(net.sf.jsqlparser.test.select.SelectTest): expected:<..., mycol FROM mytable[ WHERE mytable.col = 9]> but was:<..., mycol FROM mytable[]>
  testMultiPartColumnNameWithSchemaNameAndTableName(net.sf.jsqlparser.test.select.SelectTest): expected:<...nName FROM tableName[]> but was:<...nName FROM tableName[ WHERE null]>
  testMultiPartTableNameWithServerName(net.sf.jsqlparser.test.select.SelectTest): expected:<...nstance]...tableName[]> but was:<...nstance]...tableName[ WHERE null]>
  testProblemSqlAnalytic7Count(net.sf.jsqlparser.test.select.SelectTest): expected:<... () AS n FROM table1[]> but was:<... () AS n FROM table1[ WHERE null]>
  testAllColumnsFromTable(net.sf.jsqlparser.test.select.SelectTest): expected:<...ame.* FROM tableName[]> but was:<...ame.* FROM tableName[ WHERE null]>
  testProblemSqlCombinedSets(net.sf.jsqlparser.test.select.SelectTest): expected:<(SELECT * FROM a[) INTERSECT (SELECT * FROM b) UNION (SELECT * FROM c])> but was:<(SELECT * FROM a[ WHERE null) INTERSECT (SELECT * FROM b WHERE null) UNION (SELECT * FROM c WHERE null])>
  testInterval2(net.sf.jsqlparser.test.select.SelectTest): expected:<...START_TIME FROM tab1[]> but was:<...START_TIME FROM tab1[ WHERE null]>
  testConcat(net.sf.jsqlparser.test.select.SelectTest): expected:<...|| b || c + 4 FROM t[]> but was:<...|| b || c + 4 FROM t[ WHERE null]>
  testCount2(net.sf.jsqlparser.test.select.SelectTest): expected:<...+ col2) FROM mytable[]> but was:<...+ col2) FROM mytable[ WHERE null]>
  testSignedColumns(net.sf.jsqlparser.test.select.SelectTest): expected:<...Name) FROM tableName[]> but was:<...Name) FROM tableName[ WHERE null]>
  testDouble(net.sf.jsqlparser.test.select.SelectTest): expected:<... 1e2, * FROM mytable[ WHERE mytable.col = 9]> but was:<... 1e2, * FROM mytable[]>
  testProblemSqlMinus(net.sf.jsqlparser.test.select.SelectTest): expected:<(SELECT * FROM a[) MINUS (SELECT * FROM b])> but was:<(SELECT * FROM a[ WHERE null) MINUS (SELECT * FROM b WHERE null])>
  testExists(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT * FROM tab1[ WHERE EXISTS (SELECT * FROM tab2)]> but was:<SELECT * FROM tab1[]>
  testMultiPartTableNameWithServerProblem(net.sf.jsqlparser.test.select.SelectTest): expected:<...dbo.t_transfer_num a[]> but was:<...dbo.t_transfer_num a[ WHERE null]>
  testGroupByExpression(net.sf.jsqlparser.test.select.SelectTest): expected:<...m(col8) FROM table1 []GROUP BY col1, col2,...> but was:<...m(col8) FROM table1 [WHERE null ]GROUP BY col1, col2,...>
  testHaving(net.sf.jsqlparser.test.select.SelectTest): expected:<...X(tab1.b) FROM tab1 [WHERE a > 34 ]GROUP BY tab1.b HAVI...> but was:<...X(tab1.b) FROM tab1 []GROUP BY tab1.b HAVI...>
  testIssue154(net.sf.jsqlparser.test.select.SelectTest): expected:<...id = dc.discount_id [WHERE merchant_id = ? AND deleted = ? AND dc.discount_id IS NULL AND modified_time < ? AND modified_time >= ? ]ORDER BY modified_ti...> but was:<...id = dc.discount_id []ORDER BY modified_ti...>
  testDistinctTop(net.sf.jsqlparser.test.select.SelectTest): expected:<..., mycol FROM mytable[ WHERE mytable.col = 9]> but was:<..., mycol FROM mytable[]>
  testSelectUserVariable(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT @col FROM t1[]> but was:<SELECT @col FROM t1[ WHERE null]>
  testIsNot2(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT * FROM test[ WHERE a IS NOT NULL]> but was:<SELECT * FROM test[]>
  testTopWithParenthesis(net.sf.jsqlparser.test.select.SelectTest): expected:<...ame.tableName alias []ORDER BY alias.colum...> but was:<...ame.tableName alias [WHERE null ]ORDER BY alias.colum...>
  testSelectOracleColl(net.sf.jsqlparser.test.select.SelectTest): expected:<... * FROM the_table tt[ WHERE TT.COL1 = lines(idx).COL1]> but was:<... * FROM the_table tt[]>
  testOracleJoin(net.sf.jsqlparser.test.select.SelectTest): expected:<...M tabelle1, tabelle2[ WHERE tabelle1.a = tabelle2.b(+)]> but was:<...M tabelle1, tabelle2[]>
  testPostgreSQLRegExpCaseSensitiveMatch2(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT a, b FROM foo[ WHERE a ~* '[help].*']> but was:<SELECT a, b FROM foo[]>
  testPostgreSQLRegExpCaseSensitiveMatch3(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT a, b FROM foo[ WHERE a !~ '[help].*']> but was:<SELECT a, b FROM foo[]>
  testPostgreSQLRegExpCaseSensitiveMatch4(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT a, b FROM foo[ WHERE a !~* '[help].*']> but was:<SELECT a, b FROM foo[]>
  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 * FROM t1[]>
  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 * FROM t1[]>
  testLimit2(net.sf.jsqlparser.test.select.SelectTest): expected:<...LECT * FROM mytable [WHERE mytable.col = 9 ]LIMIT ? OFFSET 3> but was:<...LECT * FROM mytable []LIMIT ? OFFSET 3>
  testTableCrossJoin(net.sf.jsqlparser.test.select.SelectTest): expected:<...taba CROSS JOIN tabb[]> but was:<...taba CROSS JOIN tabb[ WHERE null]>
  testProblemSqlAnalytic2(net.sf.jsqlparser.test.select.SelectTest): expected:<... b) AS n FROM table1[]> but was:<... b) AS n FROM table1[ WHERE null]>
  testProblemSqlAnalytic3(net.sf.jsqlparser.test.select.SelectTest): expected:<... b) AS n FROM table1[]> but was:<... b) AS n FROM table1[ WHERE null]>
  testProblemSqlAnalytic9CommaListPartition(net.sf.jsqlparser.test.select.SelectTest): expected:<... b) AS n FROM table1[]> but was:<... b) AS n FROM table1[ WHERE null]>
  testOracleHierarchicalQuery(net.sf.jsqlparser.test.select.SelectTest): expected:<...r_id FROM employees []CONNECT BY employee_...> but was:<...r_id FROM employees [WHERE null ]CONNECT BY employee_...>
  testPivot1(net.sf.jsqlparser.test.select.SelectTest): expected:<...) FOR b IN ('val1'))[]> but was:<...) FOR b IN ('val1'))[ WHERE null]>
  testPivot2(net.sf.jsqlparser.test.select.SelectTest): expected:<...R b IN (10, 20, 30))[]> but was:<...R b IN (10, 20, 30))[ WHERE null]>
  testPivot3(net.sf.jsqlparser.test.select.SelectTest): expected:<...S d1, 20, 30 AS d3))[]> but was:<...S d1, 20, 30 AS d3))[ WHERE null]>
  testPivot4(net.sf.jsqlparser.test.select.SelectTest): expected:<...R b IN (10, 20, 30))[]> but was:<...R b IN (10, 20, 30))[ WHERE null]>
  testPivot5(net.sf.jsqlparser.test.select.SelectTest): expected:<...0, 'b'), (30, 'c')))[]> but was:<...0, 'b'), (30, 'c')))[ WHERE null]>
  testSelectWithBrackets(net.sf.jsqlparser.test.select.SelectTest): expected:<...ELECT 1 FROM mytable[])> but was:<...ELECT 1 FROM mytable[ WHERE null])>
  testAnalyticFunctionProblem1b(net.sf.jsqlparser.test.select.SelectTest): expected:<...OWING) AS col FROM s[]> but was:<...OWING) AS col FROM s[ WHERE null]>
  testDeparser(net.sf.jsqlparser.test.select.SelectTest): expected:<... AS a, ANTIQUES AS b[ WHERE b.BUYERID = a.OWNERID AND b.ITEM = 'Chair']> but was:<... AS a, ANTIQUES AS b[]>
  testPivotXmlSubquery1(net.sf.jsqlparser.test.select.SelectTest): expected:<...ode FROM customers t[) PIVOT (count(state_code) FOR state_code IN ('NY', 'CT', 'NJ', 'FL', 'MO'))] ORDER BY times_purc...> but was:<...ode FROM customers t[ WHERE null) PIVOT (count(state_code) FOR state_code IN ('NY', 'CT', 'NJ', 'FL', 'MO')) WHERE null] ORDER BY times_purc...>
  testOracleHierarchicalQuery2(net.sf.jsqlparser.test.select.SelectTest): expected:<...r_id FROM employees []CONNECT BY PRIOR emp...> but was:<...r_id FROM employees [WHERE null ]CONNECT BY PRIOR emp...>
  testOracleHierarchicalQuery3(net.sf.jsqlparser.test.select.SelectTest): expected:<...EVEL FROM employees []START WITH employee_...> but was:<...EVEL FROM employees [WHERE null ]START WITH employee_...>
  testOracleHierarchicalQuery4(net.sf.jsqlparser.test.select.SelectTest): expected:<...EVEL FROM employees []CONNECT BY PRIOR emp...> but was:<...EVEL FROM employees [WHERE null ]CONNECT BY PRIOR emp...>
  testExtractFrom1(net.sf.jsqlparser.test.select.SelectTest): expected:<...lumn) FROM testtable[]> but was:<...lumn) FROM testtable[ WHERE null]>
  testExtractFrom2(net.sf.jsqlparser.test.select.SelectTest): expected:<...ow()) FROM testtable[]> but was:<...ow()) FROM testtable[ WHERE null]>
  testExtractFrom3(net.sf.jsqlparser.test.select.SelectTest): expected:<...- 2)) FROM testtable[]> but was:<...- 2)) FROM testtable[ WHERE null]>
  testExtractFrom4(net.sf.jsqlparser.test.select.SelectTest): expected:<...:00') FROM testtable[]> but was:<...:00') FROM testtable[ WHERE null]>
  testProblemSqlAnalytic4EmptyOver(net.sf.jsqlparser.test.select.SelectTest): expected:<... () AS n FROM table1[]> but was:<... () AS n FROM table1[ WHERE null]>
  testCastTypeProblem(net.sf.jsqlparser.test.select.SelectTest): expected:<...(256)) FROM tabelle1[]> but was:<...(256)) FROM tabelle1[ WHERE null]>
  testSelectKeywordPercent(net.sf.jsqlparser.test.select.SelectTest): expected:<...ercent FROM MY_TABLE[]> but was:<...ercent FROM MY_TABLE[ WHERE null]>
  testValues(net.sf.jsqlparser.test.select.SelectTest): expected:<... 2), (3, 4)) AS test[]> but was:<... 2), (3, 4)) AS test[ WHERE null]>
  testValues6BothVariants(net.sf.jsqlparser.test.select.SelectTest): expected:<... AS MY_TEMP_TABLE(I)[ WHERE I IN (SELECT * FROM (VALUES 1, 2) AS TEST)]> but was:<... AS MY_TEMP_TABLE(I)[]>
  testProblemSqlExcept(net.sf.jsqlparser.test.select.SelectTest): expected:<(SELECT * FROM a[) EXCEPT (SELECT * FROM b])> but was:<(SELECT * FROM a[ WHERE null) EXCEPT (SELECT * FROM b WHERE null])>
  testMultiPartTableNameWithServerNameAndSchemaName(net.sf.jsqlparser.test.select.SelectTest): expected:<...schemaName.tableName[]> but was:<...schemaName.tableName[ WHERE null]>
  testProblemSqlServer_Modulo(net.sf.jsqlparser.test.select.SelectTest): expected:<...nth' FROM test_table[]> but was:<...nth' FROM test_table[ WHERE null]>
  testReservedKeyword(net.sf.jsqlparser.test.select.SelectTest): expected:<..., xml FROM tableName[]> but was:<..., xml FROM tableName[ WHERE null]>
  testLimitSqlServerJdbcParameters(net.sf.jsqlparser.test.select.SelectTest): expected:<...LECT * FROM mytable [WHERE mytable.col = 9 ]ORDER BY mytable.id ...> but was:<...LECT * FROM mytable []ORDER BY mytable.id ...>
  testSelectJoin(net.sf.jsqlparser.test.select.SelectTest): expected:<...constraint.conrelid [WHERE pg_constraint.contype = 'u' AND (pg_attribute.attnum = ANY(pg_constraint.conkey)) ]ORDER BY pg_constrai...> but was:<...constraint.conrelid []ORDER BY pg_constrai...>
  testSelectKeep(net.sf.jsqlparser.test.select.SelectTest): expected:<...), col4 FROM table1 []GROUP BY col5 ORDER ...> but was:<...), col4 FROM table1 [WHERE null ]GROUP BY col5 ORDER ...>
  testCaseElseAddition(net.sf.jsqlparser.test.select.SelectTest): expected:<...1 END AS d FROM dual[]> but was:<...1 END AS d FROM dual[ WHERE null]>
  testNamedParameter2(net.sf.jsqlparser.test.select.SelectTest): expected:<...ELECT * FROM mytable[ WHERE a = :param OR a = :param2 AND b = :param3]> but was:<...ELECT * FROM mytable[]>
  testBooleanFunction1(net.sf.jsqlparser.test.select.SelectTest): expected:<...ELECT * FROM mytable[ WHERE test_func(col1)]> but was:<...ELECT * FROM mytable[]>
  testCastInCast2(net.sf.jsqlparser.test.select.SelectTest): expected:<...rchar) FROM tabelle1[]> but was:<...rchar) FROM tabelle1[ WHERE null]>
  testNamedParameter(net.sf.jsqlparser.test.select.SelectTest): expected:<...ELECT * FROM mytable[ WHERE b = :param]> but was:<...ELECT * FROM mytable[]>
  testVisit_PlainSelect_concat(net.sf.jsqlparser.util.ConnectExpressionsVisitorTest): expected:<... c AS expr FROM test[]> but was:<... c AS expr FROM test[ WHERE null]>
  testVisit_PlainSelect_addition(net.sf.jsqlparser.util.ConnectExpressionsVisitorTest): expected:<...S testexpr FROM test[]> but was:<...S testexpr FROM test[ WHERE null]>
  testVisit_SetOperationList(net.sf.jsqlparser.util.AddAliasesVisitorTest): expected:<... + 4 AS A1 FROM test[) UNION (SELECT 7 + 8 AS A1 FROM test2])> but was:<... + 4 AS A1 FROM test[ WHERE null) UNION (SELECT 7 + 8 AS A1 FROM test2 WHERE null])>
  testVisit_PlainSelect(net.sf.jsqlparser.util.AddAliasesVisitorTest): expected:<...2, c AS A3 FROM test[]> but was:<...2, c AS A3 FROM test[ WHERE null]>
  testVisit_PlainSelect_expression(net.sf.jsqlparser.util.AddAliasesVisitorTest): expected:<... + 4 AS A1 FROM test[]> but was:<... + 4 AS A1 FROM test[ WHERE null]>
  testVisit_PlainSelect_duplicates(net.sf.jsqlparser.util.AddAliasesVisitorTest): expected:<...1, c AS A3 FROM test[]> but was:<...1, c AS A3 FROM test[ WHERE null]>
  testBuildSelectFromTableAndExpressions(net.sf.jsqlparser.util.SelectUtilsTest): expected:<...CT a, b FROM mytable[]> but was:<...CT a, b FROM mytable[ WHERE null]>
  testAddExpr(net.sf.jsqlparser.util.SelectUtilsTest): expected:<...CT a, b FROM mytable[]> but was:<...CT a, b FROM mytable[ WHERE null]>
  testAddJoin(net.sf.jsqlparser.util.SelectUtilsTest): expected:<...IN mytable2 ON a = b[]> but was:<...IN mytable2 ON a = b[ WHERE null]>
  testBuildSelectFromTable(net.sf.jsqlparser.util.SelectUtilsTest): expected:<...ELECT * FROM mytable[]> but was:<...ELECT * FROM mytable[ WHERE null]>
  testBuildSelectFromTableWithGroupBy(net.sf.jsqlparser.util.SelectUtilsTest): expected:<...LECT * FROM mytable []GROUP BY b> but was:<...LECT * FROM mytable [WHERE null ]GROUP BY b>
  testBuildSelectFromTableAndParsedExpression(net.sf.jsqlparser.util.SelectUtilsTest): expected:<...b, test FROM mytable[]> but was:<...b, test FROM mytable[ WHERE null]>
  testStatements(net.sf.jsqlparser.statement.StatementsTest): expected:<...ELECT * FROM mytable[;

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

[INFO] ------------------------------------------------------------------------
[INFO] BUILD FAILURE
[INFO] ------------------------------------------------------------------------
[INFO] Total time: 15.765s
[INFO] Finished at: Tue Oct 06 07:51:02 CEST 2015
[INFO] Final Memory: 22M/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
