[INFO] Scanning for projects...
[INFO]                                                                         
[INFO] ------------------------------------------------------------------------
[INFO] Building JSQLParser library 0.9.4
[INFO] ------------------------------------------------------------------------
[INFO] 
[INFO] --- javacc-maven-plugin:2.6:jjtree-javacc (javacc) @ jsqlparser ---
[INFO] Skipping - all parsers are up to date
[INFO] 
[INFO] --- license-maven-plugin:1.6:update-file-header (first) @ jsqlparser ---
[INFO] Will search files to update from root /home/perham/Study/Experiments/2015-10-23-ICST/LittleDarwin/Cases/JSqlParser-jsqlparser-0.9.4/src/main/java
[INFO]  - adding license header on file /home/perham/Study/Experiments/2015-10-23-ICST/LittleDarwin/Cases/JSqlParser-jsqlparser-0.9.4/src/main/java/net/sf/jsqlparser/schema/Table.java
[INFO] Scan 164 files header done in 219.085ms.
[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.057 sec
Running net.sf.jsqlparser.test.create.CreateTableTest
Tests run: 27, Failures: 26, Errors: 0, Skipped: 0, Time elapsed: 0.083 sec <<< FAILURE!
Running net.sf.jsqlparser.test.create.CreateIndexTest
Tests run: 6, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0 sec
Running net.sf.jsqlparser.test.create.CreateViewTest
Tests run: 8, Failures: 8, Errors: 0, Skipped: 0, Time elapsed: 0.007 sec <<< FAILURE!
Running net.sf.jsqlparser.test.delete.DeleteTest
Tests run: 2, Failures: 2, Errors: 0, Skipped: 0, Time elapsed: 0.002 sec <<< FAILURE!
Running net.sf.jsqlparser.test.simpleparsing.CCJSqlParserManagerTest
Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.174 sec
Running net.sf.jsqlparser.test.drop.DropTest
Tests run: 2, Failures: 1, Errors: 0, Skipped: 0, Time elapsed: 0.001 sec <<< FAILURE!
Running net.sf.jsqlparser.test.insert.InsertTest
Tests run: 15, Failures: 14, Errors: 0, Skipped: 0, Time elapsed: 0.04 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: 5, Errors: 0, Skipped: 0, Time elapsed: 0.004 sec <<< FAILURE!
Running net.sf.jsqlparser.test.replace.ReplaceTest
Tests run: 4, Failures: 3, Errors: 0, Skipped: 0, Time elapsed: 0.005 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:13:21 AM net.sf.jsqlparser.test.select.SpecialOracleTest testAllSqlsParseDeparse
INFO: testing string01.sql
Oct 06, 2015 7:13:22 AM net.sf.jsqlparser.test.select.SpecialOracleTest testAllSqlsParseDeparse
INFO:    -> PROBLEM net.sf.jsqlparser.JSQLParserException
Oct 06, 2015 7:13:22 AM net.sf.jsqlparser.test.select.SpecialOracleTest testAllSqlsParseDeparse
INFO: testing returning01.sql
Oct 06, 2015 7:13:22 AM net.sf.jsqlparser.test.select.SpecialOracleTest testAllSqlsParseDeparse
INFO:    -> PROBLEM net.sf.jsqlparser.JSQLParserException
Oct 06, 2015 7:13:22 AM net.sf.jsqlparser.test.select.SpecialOracleTest testAllSqlsParseDeparse
INFO: testing keywordasidentifier05.sql
Oct 06, 2015 7:13:22 AM net.sf.jsqlparser.test.select.SpecialOracleTest testAllSqlsOnlyParse
INFO: testing comment02.sql
Oct 06, 2015 7:13:22 AM net.sf.jsqlparser.test.select.SpecialOracleTest testAllSqlsOnlyParse
INFO:    -> SUCCESS
Oct 06, 2015 7:13:22 AM net.sf.jsqlparser.test.select.SpecialOracleTest testAllSqlsOnlyParse
INFO: testing numbers02.sql
Oct 06, 2015 7:13:22 AM net.sf.jsqlparser.test.select.SpecialOracleTest testAllSqlsOnlyParse
INFO:    -> SUCCESS
Oct 06, 2015 7:13:22 AM net.sf.jsqlparser.test.select.SpecialOracleTest testAllSqlsOnlyParse
INFO: testing comment01.sql
Oct 06, 2015 7:13:22 AM net.sf.jsqlparser.test.select.SpecialOracleTest testAllSqlsOnlyParse
INFO:    -> SUCCESS
Tests run: 2, Failures: 1, Errors: 0, Skipped: 0, Time elapsed: 0.084 sec <<< FAILURE!
Running net.sf.jsqlparser.test.select.SelectTest
Tests run: 228, Failures: 201, Errors: 0, Skipped: 0, Time elapsed: 0.52 sec <<< FAILURE!
Running net.sf.jsqlparser.test.select.SpeedTest
42500 statements parsed in 7913 milliseconds
 (5370 statements per second,  0.0001862 seconds per statement )
38500 select scans for table name executed in 138 milliseconds
 (278985 select scans for table name per second,  0.0000036 seconds per select scans for table name)
Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 8.04 sec
Running net.sf.jsqlparser.test.truncate.TruncateTest
Tests run: 1, Failures: 1, Errors: 0, Skipped: 0, Time elapsed: 0.001 sec <<< FAILURE!
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.002 sec <<< FAILURE!
Running net.sf.jsqlparser.util.AddAliasesVisitorTest
Tests run: 4, Failures: 4, Errors: 0, Skipped: 0, Time elapsed: 0.003 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.001 sec
Running net.sf.jsqlparser.schema.ServerTest
Tests run: 2, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0 sec
Running net.sf.jsqlparser.parser.CCJSqlParserUtilTest
Tests run: 3, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.001 sec
Running net.sf.jsqlparser.statement.SetStatementTest
Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.004 sec
Running net.sf.jsqlparser.statement.AdaptersTest
Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.002 sec
Running net.sf.jsqlparser.statement.StatementsTest
Tests run: 1, Failures: 1, Errors: 0, Skipped: 0, Time elapsed: 0.001 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:   testCreateTableForeignKey(net.sf.jsqlparser.test.create.CreateTableTest): expected:<CREATE TABLE test [(id INT UNSIGNED NOT NULL AUTO_INCREMENT, string VARCHAR (20), user_id INT UNSIGNED, PRIMARY KEY (id), FOREIGN KEY (user_id) REFERENCES ra_user](id))> but was:<CREATE TABLE test [null (id INT UNSIGNED NOT NULL AUTO_INCREMENT, string VARCHAR (20), user_id INT UNSIGNED, PRIMARY KEY (id), FOREIGN KEY (user_id) REFERENCES ra_user null](id))>
  testCreateTableArrays(net.sf.jsqlparser.test.create.CreateTableTest): expected:<...REATE TABLE sal_emp [](name text, pay_by_q...> but was:<...REATE TABLE sal_emp [null ](name text, pay_by_q...>
  testCreateTable2(net.sf.jsqlparser.test.create.CreateTableTest): expected:<...REATE TABLE testtab []("test" varchar (255...> but was:<...REATE TABLE testtab [null ]("test" varchar (255...>
  testCreateTable3(net.sf.jsqlparser.test.create.CreateTableTest): expected:<...REATE TABLE testtab []("test" varchar (255...> but was:<...REATE TABLE testtab [null ]("test" varchar (255...>
  testCreateTableParams(net.sf.jsqlparser.test.create.CreateTableTest): expected:<... TEMPORARY TABLE T1 [](PROCESSID VARCHAR (...> but was:<... TEMPORARY TABLE T1 [null ](PROCESSID VARCHAR (...>
  testCreateTableDefault2(net.sf.jsqlparser.test.create.CreateTableTest): expected:<CREATE TABLE T1 [](id integer default ...> but was:<CREATE TABLE T1 [null ](id integer default ...>
  testCreateTableWithKey(net.sf.jsqlparser.test.create.CreateTableTest): expected:<CREATE TABLE bar [](key character varyi...> but was:<CREATE TABLE bar [null ](key character varyi...>
  testCreateTable(net.sf.jsqlparser.test.create.CreateTableTest): expected:<CREATE TABLE mytab [](mycol a (10, 20) c ...> but was:<CREATE TABLE mytab [null ](mycol a (10, 20) c ...>
  testCreateTablePrimaryKey(net.sf.jsqlparser.test.create.CreateTableTest): expected:<CREATE TABLE test [](id INT UNSIGNED NOT...> but was:<CREATE TABLE test [null ](id INT UNSIGNED NOT...>
  testCreateTableColumnValues(net.sf.jsqlparser.test.create.CreateTableTest): expected:<...EATE TABLE mytable1 [](values INTEGER)> but was:<...EATE TABLE mytable1 [null ](values INTEGER)>
  testCreateTableDefault(net.sf.jsqlparser.test.create.CreateTableTest): expected:<CREATE TABLE T1 [](id integer default ...> but was:<CREATE TABLE T1 [null ](id integer default ...>
  testCreateTableWithRange(net.sf.jsqlparser.test.create.CreateTableTest): expected:<CREATE TABLE foo [](name character vary...> but was:<CREATE TABLE foo [null ](name character vary...>
  testCreateTableUniqueConstraint(net.sf.jsqlparser.test.create.CreateTableTest): expected:<...ate table activities[](_id integer primary...> but was:<...ate table activities[ null](_id integer primary...>
  testCreateTableForeignKey2(net.sf.jsqlparser.test.create.CreateTableTest): expected:<CREATE TABLE test [(id INT UNSIGNED NOT NULL AUTO_INCREMENT, string VARCHAR (20), user_id INT UNSIGNED, PRIMARY KEY (id), CONSTRAINT fkIdx FOREIGN KEY (user_id) REFERENCES ra_user](id))> but was:<CREATE TABLE test [null (id INT UNSIGNED NOT NULL AUTO_INCREMENT, string VARCHAR (20), user_id INT UNSIGNED, PRIMARY KEY (id), CONSTRAINT fkIdx FOREIGN KEY (user_id) REFERENCES ra_user null](id))>
  testCreateTableForeignKey3(net.sf.jsqlparser.test.create.CreateTableTest): expected:<create table test[](id int unsigned not...> but was:<create table test[ null](id int unsigned not...>
  testCreateTableForeignKey4(net.sf.jsqlparser.test.create.CreateTableTest): expected:<create table test[](id int unsigned not...> but was:<create table test[ null](id int unsigned not...>
  testCreateTableWithUniqueKey(net.sf.jsqlparser.test.create.CreateTableTest): expected:<...REATE TABLE animals [](id INT NOT NULL, na...> but was:<...REATE TABLE animals [null ](id INT NOT NULL, na...>
  testCreateTableVeryComplex(net.sf.jsqlparser.test.create.CreateTableTest): expected:<...ble `wp_commentmeta`[](`meta_id` bigint(20...> but was:<...ble `wp_commentmeta`[ null](`meta_id` bigint(20...>
  testCreateTableUnlogged2(net.sf.jsqlparser.test.create.CreateTableTest): expected:<...NLOGGED TABLE mytab [](mycol a (10, 20) c ...> but was:<...NLOGGED TABLE mytab [null ](mycol a (10, 20) c ...>
  testCreateTableColumnValue(net.sf.jsqlparser.test.create.CreateTableTest): expected:<...EATE TABLE mytable1 [](value INTEGER)> but was:<...EATE TABLE mytable1 [null ](value INTEGER)>
  testCreateTableInlinePrimaryKey(net.sf.jsqlparser.test.create.CreateTableTest): expected:<...REATE TABLE animals [](id INT PRIMARY KEY ...> but was:<...REATE TABLE animals [null ](id INT PRIMARY KEY ...>
  testCreateTableArrays2(net.sf.jsqlparser.test.create.CreateTableTest): expected:<...REATE TABLE sal_emp [](name text, pay_by_q...> but was:<...REATE TABLE sal_emp [null ](name text, pay_by_q...>
  testCreateTableAsSelect(net.sf.jsqlparser.test.create.CreateTableTest): expected:<CREATE TABLE a [AS SELECT col1, col2 FROM b]> but was:<CREATE TABLE a [null AS SELECT col1, col2 FROM b null]>
  testCreateTableAsSelect2(net.sf.jsqlparser.test.create.CreateTableTest): expected:<...EATE TABLE newtable [AS WITH a AS (SELECT col1, col3 FROM testtable) SELECT col1, col2, col3 FROM b INNER JOIN a] ON b.col1 = a.col1> but was:<...EATE TABLE newtable [null AS WITH a AS (SELECT col1, col3 FROM testtable null) SELECT col1, col2, col3 FROM b null INNER JOIN a null] ON b.col1 = a.col1>
  testCreateTableUnlogged(net.sf.jsqlparser.test.create.CreateTableTest): expected:<...NLOGGED TABLE mytab [](mycol a (10, 20) c ...> but was:<...NLOGGED TABLE mytab [null ](mycol a (10, 20) c ...>
  testCreateTableIfNotExists(net.sf.jsqlparser.test.create.CreateTableTest): expected:<... NOT EXISTS animals [](id INT NOT NULL)> but was:<... NOT EXISTS animals [null ](id INT NOT NULL)>
  testCreateView2(net.sf.jsqlparser.test.create.CreateViewTest): expected:<CREATE VIEW myview [AS SELECT * FROM mytab]> but was:<CREATE VIEW myview [null AS SELECT * FROM mytab null]>
  testCreateView3(net.sf.jsqlparser.test.create.CreateViewTest): expected:<...REPLACE VIEW myview [AS SELECT * FROM mytab]> but was:<...REPLACE VIEW myview [null AS SELECT * FROM mytab null]>
  testCreateView4(net.sf.jsqlparser.test.create.CreateViewTest): expected:<... REPLACE VIEW view2 [AS SELECT a, b, c FROM testtab INNER JOIN testtab2] ON testtab.col1 = t...> but was:<... REPLACE VIEW view2 [null AS SELECT a, b, c FROM testtab null INNER JOIN testtab2 null] ON testtab.col1 = t...>
  testCreateView5(net.sf.jsqlparser.test.create.CreateViewTest): expected:<CREATE VIEW myview [AS (SELECT * FROM mytab])> but was:<CREATE VIEW myview [null AS (SELECT * FROM mytab null])>
  testCreateView(net.sf.jsqlparser.test.create.CreateViewTest): expected:<CREATE VIEW myview [AS SELECT * FROM mytab]> but was:<CREATE VIEW myview [null AS SELECT * FROM mytab null]>
  testCreateViewUnion(net.sf.jsqlparser.test.create.CreateViewTest): expected:<CREATE VIEW view1 [AS (SELECT a, b FROM testtab) UNION (SELECT b, c FROM testtab2])> but was:<CREATE VIEW view1 [null AS (SELECT a, b FROM testtab null) UNION (SELECT b, c FROM testtab2 null])>
  testCreateMaterializedView(net.sf.jsqlparser.test.create.CreateViewTest): expected:<...RIALIZED VIEW view1 [AS SELECT a, b FROM testtab]> but was:<...RIALIZED VIEW view1 [null AS SELECT a, b FROM testtab null]>
  testCreateViewWithColumnNames1(net.sf.jsqlparser.test.create.CreateViewTest): expected:<...R REPLACE VIEW view1[(col1, col2) AS SELECT a, b FROM testtab]> but was:<...R REPLACE VIEW view1[ null(col1, col2) AS SELECT a, b FROM testtab null]>
  testDelete(net.sf.jsqlparser.test.delete.DeleteTest): expected:<DELETE FROM mytable []WHERE mytable.col = ...> but was:<DELETE FROM mytable [null ]WHERE mytable.col = ...>
  testDeleteWhereProblem1(net.sf.jsqlparser.test.delete.DeleteTest): expected:<...LETE FROM tablename []WHERE a = 1 AND b = ...> but was:<...LETE FROM tablename [null ]WHERE a = 1 AND b = ...>
  testDrop(net.sf.jsqlparser.test.drop.DropTest): expected:<DROP TABLE mytab[]> but was:<DROP TABLE mytab[ null]>
  testInsertMultiRowValue(net.sf.jsqlparser.test.insert.InsertTest): expected:<INSERT INTO mytable [](col1, col2) VALUES ...> but was:<INSERT INTO mytable [null ](col1, col2) VALUES ...>
  testInsertWithReturning2(net.sf.jsqlparser.test.insert.InsertTest): expected:<INSERT INTO mytable [](mycolumn) VALUES ('...> but was:<INSERT INTO mytable [null ](mycolumn) VALUES ('...>
  testInsertWithReturning3(net.sf.jsqlparser.test.insert.InsertTest): expected:<INSERT INTO mytable [](mycolumn) VALUES ('...> but was:<INSERT INTO mytable [null ](mycolumn) VALUES ('...>
  testHexValues2(net.sf.jsqlparser.test.insert.InsertTest): expected:<INSERT INTO TABLE2 []VALUES ('1', "DSDD",...> but was:<INSERT INTO TABLE2 [null ]VALUES ('1', "DSDD",...>
  testHexValues3(net.sf.jsqlparser.test.insert.InsertTest): expected:<INSERT INTO TABLE2 []VALUES ('1', "DSDD",...> but was:<INSERT INTO TABLE2 [null ]VALUES ('1', "DSDD",...>
  testHexValues(net.sf.jsqlparser.test.insert.InsertTest): expected:<INSERT INTO TABLE2 []VALUES ('1', "DSDD",...> but was:<INSERT INTO TABLE2 [null ]VALUES ('1', "DSDD",...>
  testSimpleInsert(net.sf.jsqlparser.test.insert.InsertTest): expected:<INSERT INTO example [](num, name, address,...> but was:<INSERT INTO example [null ](num, name, address,...>
  testInsertWithKeywords(net.sf.jsqlparser.test.insert.InsertTest): expected:<INSERT INTO kvPair [](value, key) VALUES ...> but was:<INSERT INTO kvPair [null ](value, key) VALUES ...>
  testInsertWithReturning(net.sf.jsqlparser.test.insert.InsertTest): expected:<INSERT INTO mytable [](mycolumn) VALUES ('...> but was:<INSERT INTO mytable [null ](mycolumn) VALUES ('...>
  testRegularInsert(net.sf.jsqlparser.test.insert.InsertTest): expected:<INSERT INTO mytable [](col1, col2, col3) V...> but was:<INSERT INTO mytable [null ](col1, col2, col3) V...>
  testInsertWithKeywordValue(net.sf.jsqlparser.test.insert.InsertTest): expected:<INSERT INTO mytable [](col1) VALUES ('val1...> but was:<INSERT INTO mytable [null ](col1) VALUES ('val1...>
  testInsertFromSelect(net.sf.jsqlparser.test.insert.InsertTest): expected:<INSERT INTO mytable [(col1, col2, col3) SELECT * FROM mytable2]> but was:<INSERT INTO mytable [null (col1, col2, col3) SELECT * FROM mytable2 null]>
  testInsertWithSelect(net.sf.jsqlparser.test.insert.InsertTest): expected:<INSERT INTO mytable [(mycolumn) WITH a AS (SELECT mycolumn FROM mytable) SELECT mycolumn FROM a]> but was:<INSERT INTO mytable [null (mycolumn) WITH a AS (SELECT mycolumn FROM mytable null) SELECT mycolumn FROM a null]>
  testInsertSelect(net.sf.jsqlparser.test.insert.InsertTest): expected:<INSERT INTO mytable [(mycolumn) SELECT mycolumn FROM mytable]> but was:<INSERT INTO mytable [null (mycolumn) SELECT mycolumn FROM mytable null]>
  testUpdateWithFrom(net.sf.jsqlparser.test.update.UpdateTest): expected:<UPDATE table1 [SET columna = 5 FROM table1 LEFT JOIN table2] ON col1 = col2> but was:<UPDATE table1 [null SET columna = 5 FROM table1 null LEFT JOIN table2 null] ON col1 = col2>
  testUpdateMultiTable(net.sf.jsqlparser.test.update.UpdateTest): expected:<UPDATE T1[, T2] SET T1.C2 = T2.C2, ...> but was:<UPDATE T1[ null, T2 null] SET T1.C2 = T2.C2, ...>
  testUpdateWithSelect2(net.sf.jsqlparser.test.update.UpdateTest): expected:<UPDATE mytable [SET (col1, col2, col3) = (SELECT a, b, c FROM mytable2])> but was:<UPDATE mytable [null SET (col1, col2, col3) = (SELECT a, b, c FROM mytable2 null])>
  testUpdateWithSelect(net.sf.jsqlparser.test.update.UpdateTest): expected:<UPDATE NATION [SET (N_NATIONKEY) = (SELECT ? FROM SYSIBM.SYSDUMMY1])> but was:<UPDATE NATION [null SET (N_NATIONKEY) = (SELECT ? FROM SYSIBM.SYSDUMMY1 null])>
  testUpdateWithDeparser(net.sf.jsqlparser.test.update.UpdateTest): expected:<UPDATE table1 []AS A SET A.columna =...> but was:<UPDATE table1 [null ]AS A SET A.columna =...>
  testProblemReplaceParseDeparse(net.sf.jsqlparser.test.replace.ReplaceTest): expected:<REPLACE a_table [(ID, A, B) SELECT A_ID, A, B FROM b_table]> but was:<REPLACE a_table [null (ID, A, B) SELECT A_ID, A, B FROM b_table null]>
  testReplaceSyntax1(net.sf.jsqlparser.test.replace.ReplaceTest): expected:<REPLACE mytable []SET col1='as', col2=...> but was:<REPLACE mytable [null ]SET col1='as', col2=...>
  testReplaceSyntax2(net.sf.jsqlparser.test.replace.ReplaceTest): expected:<REPLACE mytable [](col1, col2, col3) V...> but was:<REPLACE mytable [null ](col1, col2, col3) V...>
  testAllSqlsParseDeparse(net.sf.jsqlparser.test.select.SpecialOracleTest): expected:<...ption from exception[]> but was:<...ption from exception[ null]>
  testSelectAliasWithoutAs(net.sf.jsqlparser.test.select.SelectTest): expected:<...n Name" FROM mytable[]> but was:<...n Name" FROM mytable[ null]>
  testAllConditionSubSelect(net.sf.jsqlparser.test.select.SelectTest): expected:<...no, e1.sal FROM emp [e1 WHERE e1.sal > ALL (SELECT e2.sal FROM emp] e2 WHERE e2.deptno ...> but was:<...no, e1.sal FROM emp [null e1 WHERE e1.sal > ALL (SELECT e2.sal FROM emp null] e2 WHERE e2.deptno ...>
  testSimpleSigns(net.sf.jsqlparser.test.select.SelectTest): expected:<...1, -1 FROM tableName[]> but was:<...1, -1 FROM tableName[ null]>
  testMultiValueIn2(net.sf.jsqlparser.test.select.SelectTest): expected:<...LECT * FROM mytable [WHERE (trim(a), trim(b)) IN (SELECT a, b FROM mytable2])> but was:<...LECT * FROM mytable [null WHERE (trim(a), trim(b)) IN (SELECT a, b FROM mytable2 null])>
  testSelectForUpdateOfTable(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT foo[.*, bar.* FROM foo, bar WHERE foo.id = bar.foo_id FOR UPDATE OF foo]> but was:<SELECT foo[ null.*, bar null.* FROM foo null, bar null WHERE foo.id = bar.foo_id FOR UPDATE OF foo null]>
  testPostgreSQLRegExpCaseSensitiveMatch(net.sf.jsqlparser.test.select.SelectTest): expected:<...ELECT a, b FROM foo []WHERE a ~ '[help].*'> but was:<...ELECT a, b FROM foo [null ]WHERE a ~ '[help].*'>
  testOracleJoin2(net.sf.jsqlparser.test.select.SelectTest): expected:<...LECT * FROM tabelle1[, tabelle2] WHERE tabelle1.a(+)...> but was:<...LECT * FROM tabelle1[ null, tabelle2 null] WHERE tabelle1.a(+)...>
  testOracleJoin3(net.sf.jsqlparser.test.select.SelectTest): expected:<...LECT * FROM tabelle1[, tabelle2] WHERE tabelle1.a(+)...> but was:<...LECT * FROM tabelle1[ null, tabelle2 null] WHERE tabelle1.a(+)...>
  testOracleJoin4(net.sf.jsqlparser.test.select.SelectTest): expected:<...LECT * FROM tabelle1[, tabelle2] WHERE tabelle1.a(+)...> but was:<...LECT * FROM tabelle1[ null, tabelle2 null] WHERE tabelle1.a(+)...>
  testMultiPartTableNameWithSchemaName(net.sf.jsqlparser.test.select.SelectTest): expected:<...schemaName.tableName[]> but was:<...schemaName.tableName[ null]>
  testSimpleAdditionsAndSubtractionsWithSigns(net.sf.jsqlparser.test.select.SelectTest): expected:<...1 - 1 FROM tableName[]> but was:<...1 - 1 FROM tableName[ null]>
  testSelectAliasInQuotes(net.sf.jsqlparser.test.select.SelectTest): expected:<...n Name" FROM mytable[]> but was:<...n Name" FROM mytable[ null]>
  testOrderBy(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT * FROM tab1 []WHERE a > 34 GROUP B...> but was:<SELECT * FROM tab1 [null ]WHERE a > 34 GROUP B...>
  testCastTypeProblem2(net.sf.jsqlparser.test.select.SelectTest): expected:<...archar FROM tabelle1[]> but was:<...archar FROM tabelle1[ null]>
  testCastTypeProblem3(net.sf.jsqlparser.test.select.SelectTest): expected:<... (256) FROM tabelle1[]> but was:<... (256) FROM tabelle1[ null]>
  testCastTypeProblem4(net.sf.jsqlparser.test.select.SelectTest): expected:<... (256) FROM tabelle1[]> but was:<... (256) FROM tabelle1[ null]>
  testCastTypeProblem5(net.sf.jsqlparser.test.select.SelectTest): expected:<... (256) FROM tabelle1[]> but was:<... (256) FROM tabelle1[ null]>
  testCastTypeProblem6(net.sf.jsqlparser.test.select.SelectTest): expected:<...arying FROM tabelle1[]> but was:<...arying FROM tabelle1[ null]>
  testCastTypeProblem7(net.sf.jsqlparser.test.select.SelectTest): expected:<...rying) FROM tabelle1[]> but was:<...rying) FROM tabelle1[ null]>
  testCastInCast(net.sf.jsqlparser.test.select.SelectTest): expected:<...rchar) FROM tabelle1[]> but was:<...rchar) FROM tabelle1[ null]>
  testSkipFirst(net.sf.jsqlparser.test.select.SelectTest): expected:<...ST f1 c1, c2 FROM t1[]> but was:<...ST f1 c1, c2 FROM t1[ null]>
  testMultiPartTableNameWithDatabaseNameAndSchemaName(net.sf.jsqlparser.test.select.SelectTest): expected:<...schemaName.tableName[]> but was:<...schemaName.tableName[ null]>
  testSelectJoinWithComma(net.sf.jsqlparser.test.select.SelectTest): expected:<...eccion_de_Briofitas [AS cb, unigeoestados] AS es WHERE es.nomb...> but was:<...eccion_de_Briofitas [null AS cb, unigeoestados null] AS es WHERE es.nomb...>
  testAdditionalLettersGerman(net.sf.jsqlparser.test.select.SelectTest): expected:<...lü FROM testtableäöü[]> but was:<...lü FROM testtableäöü[ null]>
  testTop(net.sf.jsqlparser.test.select.SelectTest): expected:<...OP 3 * FROM mytable []WHERE mytable.col = ...> but was:<...OP 3 * FROM mytable [null ]WHERE mytable.col = ...>
  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[ null) UNION (SELECT mslink FROM tableb null)) SELECT * FROM tablea null WHERE mslink IN (SELECT mslink FROM test null])>
  testMysqlQuote(net.sf.jsqlparser.test.select.SelectTest): expected:<...ROM `ANTIQUEOWNERS` [AS a, ANTIQUES] AS b WHERE b.BUYERI...> but was:<...ROM `ANTIQUEOWNERS` [null AS a, ANTIQUES null] AS b WHERE b.BUYERI...>
  testSelectInnerWith(net.sf.jsqlparser.test.select.SelectTest): expected:<...CT 'a' aid FROM DUAL[) SELECT aid FROM actor])> but was:<...CT 'a' aid FROM DUAL[ null) SELECT aid FROM actor null])>
  testReservedKeyword2(net.sf.jsqlparser.test.select.SelectTest): expected:<... open FROM tableName[]> but was:<... open FROM tableName[ null]>
  testFirst(net.sf.jsqlparser.test.select.SelectTest): expected:<...chemaName.tableName []alias ORDER BY alias...> but was:<...chemaName.tableName [null ]alias ORDER BY alias...>
  testIlike(net.sf.jsqlparser.test.select.SelectTest): expected:<...CT col1 FROM table1 []WHERE col1 ILIKE '%h...> but was:<...CT col1 FROM table1 [null ]WHERE col1 ILIKE '%h...>
  testIsNot(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT * FROM test []WHERE a IS NOT NULL> but was:<SELECT * FROM test [null ]WHERE a IS NOT NULL>
  testLimit(net.sf.jsqlparser.test.select.SelectTest): expected:<...LECT * FROM mytable []WHERE mytable.col = ...> but was:<...LECT * FROM mytable [null ]WHERE mytable.col = ...>
  testSigns(net.sf.jsqlparser.test.select.SelectTest): expected:<...nName FROM tableName[]> but was:<...nName FROM tableName[ null]>
  testUnion(net.sf.jsqlparser.test.select.SelectTest): expected:<...LECT * FROM mytable [WHERE mytable.col = 9) UNION (SELECT * FROM mytable3 WHERE mytable3.col = ?) UNION (SELECT * FROM mytable2] LIMIT 4 OFFSET 3)> but was:<...LECT * FROM mytable [null WHERE mytable.col = 9) UNION (SELECT * FROM mytable3 null WHERE mytable3.col = ?) UNION (SELECT * FROM mytable2 null] LIMIT 4 OFFSET 3)>
  testWhere(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT * FROM tab1 []WHERE (a + b + c / d...> but was:<SELECT * FROM tab1 [null ]WHERE (a + b + c / d...>
  testRegexpLike1(net.sf.jsqlparser.test.select.SelectTest): expected:<...LECT * FROM mytable []WHERE REGEXP_LIKE(fi...> but was:<...LECT * FROM mytable [null ]WHERE REGEXP_LIKE(fi...>
  testRegexpLike2(net.sf.jsqlparser.test.select.SelectTest): expected:<...E 2 END FROM mytable[]> but was:<...E 2 END FROM mytable[ null]>
  testRegexpMySQL(net.sf.jsqlparser.test.select.SelectTest): expected:<...LECT * FROM mytable []WHERE first_name REG...> but was:<...LECT * FROM mytable [null ]WHERE first_name REG...>
  testCase(net.sf.jsqlparser.test.select.SelectTest): expected:<...THEN 2 END FROM tab1[]> but was:<...THEN 2 END FROM tab1[ null]>
  testCast(net.sf.jsqlparser.test.select.SelectTest): expected:<...rchar) FROM tabelle1[]> but was:<...rchar) FROM tabelle1[ null]>
  testFrom(net.sf.jsqlparser.test.select.SelectTest): expected:<...LECT * FROM mytable [AS mytable0, mytable1 alias_tab1, mytable2 AS alias_tab2, (SELECT * FROM mytable3]) AS mytable4 WHERE ...> but was:<...LECT * FROM mytable [null AS mytable0, mytable1 null alias_tab1, mytable2 null AS alias_tab2, (SELECT * FROM mytable3 null]) AS mytable4 WHERE ...>
  testJoin(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT * FROM tab1 [LEFT OUTER JOIN tab2] ON tab1.id = tab2.i...> but was:<SELECT * FROM tab1 [null LEFT OUTER JOIN tab2 null] ON tab1.id = tab2.i...>
  testLike(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT * FROM tab1 []WHERE a LIKE 'test'> but was:<SELECT * FROM tab1 [null ]WHERE a LIKE 'test'>
  testSkip(net.sf.jsqlparser.test.select.SelectTest): expected:<...chemaName.tableName []alias ORDER BY alias...> but was:<...chemaName.tableName [null ]alias ORDER BY alias...>
  testTime(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT * FROM tab1 []WHERE a > {t '04:05:...> but was:<SELECT * FROM tab1 [null ]WHERE a > {t '04:05:...>
  testWith(net.sf.jsqlparser.test.select.SelectTest): expected:<...NT(*) FROM EMPLOYEE [AS OTHERS GROUP BY OTHERS.WORKDEPT), DINFOMAX AS (SELECT MAX(AVGSALARY) AS AVGMAX FROM DINFO) SELECT THIS_EMP.EMPNO, THIS_EMP.SALARY, DINFO.AVGSALARY, DINFO.EMPCOUNT, DINFOMAX.AVGMAX FROM EMPLOYEE AS THIS_EMP INNER JOIN DINFO INNER JOIN DINFOMAX] WHERE THIS_EMP.JOB ...> but was:<...NT(*) FROM EMPLOYEE [null AS OTHERS GROUP BY OTHERS.WORKDEPT), DINFOMAX AS (SELECT MAX(AVGSALARY) AS AVGMAX FROM DINFO null) SELECT THIS_EMP.EMPNO, THIS_EMP.SALARY, DINFO.AVGSALARY, DINFO.EMPCOUNT, DINFOMAX.AVGMAX FROM EMPLOYEE null AS THIS_EMP INNER JOIN DINFO null INNER JOIN DINFOMAX null] WHERE THIS_EMP.JOB ...>
  testJsonExpression(net.sf.jsqlparser.test.select.SelectTest): expected:<...thumb FROM instagram[]> but was:<...thumb FROM instagram[ null]>
  testConcatProblem2_5_1(net.sf.jsqlparser.test.select.SelectTest): expected:<... || c FROM testtable[]> but was:<... || c FROM testtable[ null]>
  testConcatProblem2_5_2(net.sf.jsqlparser.test.select.SelectTest): expected:<...) + c FROM testtable[]> but was:<...) + c FROM testtable[ null]>
  testProblemSqlAnalytic8Complex(net.sf.jsqlparser.test.select.SelectTest): expected:<...AS ROWS2 FROM STAFF []WHERE ID < 60 ORDER ...> but was:<...AS ROWS2 FROM STAFF [null ]WHERE ID < 60 ORDER ...>
  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[ null) UNION ALL (SELECT mslink FROM tableb null)) SELECT * FROM tablea null WHERE mslink IN (SELECT mslink FROM test null])>
  testOracleJoin2_1(net.sf.jsqlparser.test.select.SelectTest): expected:<select*from tabelle1[,tabelle2] where tabelle1.a(+)...> but was:<select*from tabelle1[ null,tabelle2 null] where tabelle1.a(+)...>
  testOracleJoin2_2(net.sf.jsqlparser.test.select.SelectTest): expected:<select*from tabelle1[,tabelle2] where tabelle1.a=ta...> but was:<select*from tabelle1[ null,tabelle2 null] where tabelle1.a=ta...>
  testOracleJoin3_1(net.sf.jsqlparser.test.select.SelectTest): expected:<...LECT * FROM tabelle1[, tabelle2] WHERE tabelle1.a > ...> but was:<...LECT * FROM tabelle1[ null, tabelle2 null] WHERE tabelle1.a > ...>
  testAnyConditionSubSelect(net.sf.jsqlparser.test.select.SelectTest): expected:<...no, e1.sal FROM emp [e1 WHERE e1.sal > ANY (SELECT e2.sal FROM emp] e2 WHERE e2.deptno ...> but was:<...no, e1.sal FROM emp [null e1 WHERE e1.sal > ANY (SELECT e2.sal FROM emp null] e2 WHERE e2.deptno ...>
  testPivotXml1(net.sf.jsqlparser.test.select.SelectTest): expected:<...ELECT * FROM mytable[ PIVOT XML (count(a) FOR b IN ('val1'))]> but was:<...ELECT * FROM mytable[]>
  testPivotXml2(net.sf.jsqlparser.test.select.SelectTest): expected:<...ELECT * FROM mytable[ PIVOT XML (count(a) FOR b IN (SELECT vals FROM myothertable))]> but was:<...ELECT * FROM mytable[]>
  testPivotXml3(net.sf.jsqlparser.test.select.SelectTest): expected:<...ELECT * FROM mytable[ PIVOT XML (count(a) FOR b IN (ANY))]> but was:<...ELECT * FROM mytable[]>
  testOrderByNullsFirst(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT a FROM tab1 []ORDER BY a NULLS FIR...> but was:<SELECT a FROM tab1 [null ]ORDER BY a NULLS FIR...>
  testMultiTableJoin(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT * FROM taba [INNER JOIN tabb ON taba.a = tabb.a, tabc LEFT JOIN tabd] ON tabc.c = tabd.c> but was:<SELECT * FROM taba [null INNER JOIN tabb null ON taba.a = tabb.a, tabc null LEFT JOIN tabd null] ON tabc.c = tabd.c>
  testProblemSqlServer_Modulo_mod(net.sf.jsqlparser.test.select.SelectTest): expected:<...ECT mod(5, 2) FROM A[]> but was:<...ECT mod(5, 2) FROM A[ null]>
  testProblemSqlAnalytic(net.sf.jsqlparser.test.select.SelectTest): expected:<... a) AS n FROM table1[]> but was:<... a) AS n FROM table1[ null]>
  testIssue160_signedParameter2(net.sf.jsqlparser.test.select.SelectTest): expected:<...LECT * FROM mytable []WHERE -? = 5> but was:<...LECT * FROM mytable [null ]WHERE -? = 5>
  testAdditionalLettersSpanish(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT * FROM años[]> but was:<SELECT * FROM años[ null]>
  testLateral1(net.sf.jsqlparser.test.select.SelectTest): expected:<...NETOTAL FROM ORDERS [AS O, LATERAL(SELECT SUM(NETAMT) AS LINETOTAL FROM ORDERLINES] AS LINES WHERE LINE...> but was:<...NETOTAL FROM ORDERS [null AS O, LATERAL(SELECT SUM(NETAMT) AS LINETOTAL FROM ORDERLINES null] AS LINES WHERE LINE...>
  testSelectNumericBind(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT a FROM b []WHERE c = :1> but was:<SELECT a FROM b [null ]WHERE c = :1>
  testRegexpBinaryMySQL(net.sf.jsqlparser.test.select.SelectTest): expected:<...LECT * FROM mytable []WHERE first_name REG...> but was:<...LECT * FROM mytable [null ]WHERE first_name REG...>
  testLateralComplex1(net.sf.jsqlparser.test.select.SelectTest): expected:<...AXTOTAL FROM ORDERS [O, LATERAL(SELECT SUM(NETAMT) AS LINETOTAL FROM ORDERLINES LINES WHERE LINES.ORDERID = O.ORDERID) AS OL, LATERAL(SELECT SUM(CHGAMT) AS ORDCHGTOTAL FROM ORDERCHARGES CHARGES WHERE LINES.ORDERID = O.ORDERID) AS OC, LATERAL(SELECT SUM(TAXAMT) AS TAXTOTAL FROM ORDERTAXES] TAXES WHERE TAXES.O...> but was:<...AXTOTAL FROM ORDERS [null O, LATERAL(SELECT SUM(NETAMT) AS LINETOTAL FROM ORDERLINES null LINES WHERE LINES.ORDERID = O.ORDERID) AS OL, LATERAL(SELECT SUM(CHGAMT) AS ORDCHGTOTAL FROM ORDERCHARGES null CHARGES WHERE LINES.ORDERID = O.ORDERID) AS OC, LATERAL(SELECT SUM(TAXAMT) AS TAXTOTAL FROM ORDERTAXES null] TAXES WHERE TAXES.O...>
  testMultiValueIn(net.sf.jsqlparser.test.select.SelectTest): expected:<...LECT * FROM mytable [WHERE (a, b, c) IN (SELECT a, b, c FROM mytable2])> but was:<...LECT * FROM mytable [null WHERE (a, b, c) IN (SELECT a, b, c FROM mytable2 null])>
  testProblemSqlIntersect(net.sf.jsqlparser.test.select.SelectTest): expected:<(SELECT * FROM a[) INTERSECT (SELECT * FROM b])> but was:<(SELECT * FROM a[ null) INTERSECT (SELECT * FROM b null])>
  testProblemFunction(net.sf.jsqlparser.test.select.SelectTest): expected:<...est() FROM testtable[]> but was:<...est() FROM testtable[ null]>
  testConcatProblem2(net.sf.jsqlparser.test.select.SelectTest): expected:<...T_TMP FROM testtable[]> but was:<...T_TMP FROM testtable[ null]>
  testBitwise(net.sf.jsqlparser.test.select.SelectTest): expected:<...1 | col2 FROM table1[]> but was:<...1 | col2 FROM table1[ null]>
  testSelectInto1(net.sf.jsqlparser.test.select.SelectTest): expected:<...CT * INTO user_copy [FROM user]> but was:<...CT * INTO user_copy [null FROM user null]>
  testSelectItems(net.sf.jsqlparser.test.select.SelectTest): expected:<... AS MYID, mycol, tab[.*, schema.tab.*, mytab.mycol2, myschema.mytab.mycol, myschema.mytab.* FROM mytable] WHERE mytable.col =...> but was:<... AS MYID, mycol, tab[ null.*, schema.tab null.*, mytab.mycol2, myschema.mytab.mycol, myschema.mytab null.* FROM mytable null] WHERE mytable.col =...>
  testSelectJoin2(net.sf.jsqlparser.test.select.SelectTest): expected:<... FROM pg_constraint []WHERE pg_attribute.a...> but was:<... FROM pg_constraint [null ]WHERE pg_attribute.a...>
  testBrackets2(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [a] FROM t[]> but was:<SELECT [a] FROM t[ null]>
  testProblemSqlServer_Modulo_Proz(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT 5 % 2 FROM A[]> but was:<SELECT 5 % 2 FROM A[ null]>
  testFirstWithKeywordLimit(net.sf.jsqlparser.test.select.SelectTest): expected:<...chemaName.tableName []alias ORDER BY alias...> but was:<...chemaName.tableName [null ]alias ORDER BY alias...>
  testGroupConcat(net.sf.jsqlparser.test.select.SelectTest): expected:<...R ' ') FROM student []GROUP BY student_nam...> but was:<...R ' ') FROM student [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 [null WHERE n < 100)) SELECT sum(n) FROM t null]>
  testSelectKeepOver(net.sf.jsqlparser.test.select.SelectTest): expected:<...rst" FROM employees []ORDER BY department_...> but was:<...rst" FROM employees [null ]ORDER BY department_...>
  testFunctionRight(net.sf.jsqlparser.test.select.SelectTest): expected:<...col1, 4) FROM table1[]> but was:<...col1, 4) FROM table1[ null]>
  testMultiPartColumnName(net.sf.jsqlparser.test.select.SelectTest): expected:<...nName FROM tableName[]> but was:<...nName FROM tableName[ null]>
  testWithUnionProblem3(net.sf.jsqlparser.test.select.SelectTest): expected:<...archar) 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:<...archar) FROM tablea [null INNER JOIN tableb null ON tablea.mslink = tableb.mslink AND tableb.deleted = 0 WHERE tablea.fname IS NULL AND 1 = 0) UNION ALL (SELECT mslink FROM tableb null)) SELECT * FROM tablea null WHERE mslink IN (SELECT mslink FROM test null])>
  testWithUnionProblem4(net.sf.jsqlparser.test.select.SelectTest): expected:<...feature FROM tablea [AS gl INNER JOIN tableb AS ba ON gl.mslink = ba.gl_mslink INNER JOIN tablec AS ae ON gl.mslink = ae.mslink AND ae.deleted = 0 WHERE gl.parent IS NULL AND gl.mslink <> 0) UNION ALL (SELECT gl.mslink, ba.gl_name AS txt, ba.gl_nummer AS nr, hist.level + 1 AS level, CAST(hist.path + '.' + CAST(gl.mslink AS VARCHAR) AS VARCHAR) AS path, ae.feature FROM tablea AS gl INNER JOIN tableb AS ba ON gl.mslink = ba.gl_mslink INNER JOIN tablec AS ae ON gl.mslink = ae.mslink AND ae.deleted = 0 INNER JOIN hist ON gl.parent = hist.mslink WHERE gl.mslink <> 0)) SELECT mslink, space(level * 4) + txt AS txt, nr, feature, path FROM hist WHERE EXISTS (SELECT feature FROM tablec] WHERE mslink = 0 AN...> but was:<...feature FROM tablea [null AS gl INNER JOIN tableb null AS ba ON gl.mslink = ba.gl_mslink INNER JOIN tablec null 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 null AS gl INNER JOIN tableb null AS ba ON gl.mslink = ba.gl_mslink INNER JOIN tablec null AS ae ON gl.mslink = ae.mslink AND ae.deleted = 0 INNER JOIN hist null ON gl.parent = hist.mslink WHERE gl.mslink <> 0)) SELECT mslink, space(level * 4) + txt AS txt, nr, feature, path FROM hist null WHERE EXISTS (SELECT feature FROM tablec null] WHERE mslink = 0 AN...>
  testWithUnionProblem5(net.sf.jsqlparser.test.select.SelectTest): expected:<...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:<...feature FROM tablea [null AS gl INNER JOIN tableb null AS ba ON gl.mslink = ba.gl_mslink INNER JOIN tablec null 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 null AS gl INNER JOIN tableb null AS ba ON gl.mslink = ba.gl_mslink INNER JOIN tablec null AS ae ON gl.mslink = ae.mslink AND ae.deleted = 0 INNER JOIN hist null ON gl.parent = hist.mslink WHERE gl.mslink <> 0)) SELECT * FROM hist null]>
  testGroupBy(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT * FROM tab1 []WHERE a > 34 GROUP B...> but was:<SELECT * FROM tab1 [null ]WHERE a > 34 GROUP B...>
  testMultiPartColumnNameWithTableName(net.sf.jsqlparser.test.select.SelectTest): expected:<...nName FROM tableName[]> but was:<...nName FROM tableName[ null]>
  testMultiPartTableNameWithDatabaseName(net.sf.jsqlparser.test.select.SelectTest): expected:<...abaseName..tableName[]> but was:<...abaseName..tableName[ null]>
  testLimitSqlServer1(net.sf.jsqlparser.test.select.SelectTest): expected:<...LECT * FROM mytable []WHERE mytable.col = ...> but was:<...LECT * FROM mytable [null ]WHERE mytable.col = ...>
  testLimitSqlServer2(net.sf.jsqlparser.test.select.SelectTest): expected:<...LECT * FROM mytable []WHERE mytable.col = ...> but was:<...LECT * FROM mytable [null ]WHERE mytable.col = ...>
  testLimitSqlServer3(net.sf.jsqlparser.test.select.SelectTest): expected:<...LECT * FROM mytable []WHERE mytable.col = ...> but was:<...LECT * FROM mytable [null ]WHERE mytable.col = ...>
  testLimitSqlServer4(net.sf.jsqlparser.test.select.SelectTest): expected:<...LECT * FROM mytable []WHERE mytable.col = ...> but was:<...LECT * FROM mytable [null ]WHERE mytable.col = ...>
  testPivotFunction(net.sf.jsqlparser.test.select.SelectTest): expected:<...code FROM customers [t) PIVOT (count(state_code) FOR state_code IN ('NY', 'CT', 'NJ', 'FL', 'MO')) ORDER BY times_purchased)) FROM DUAL]> but was:<...code FROM customers [null t) PIVOT (count(state_code) FOR state_code IN ('NY', 'CT', 'NJ', 'FL', 'MO')) ORDER BY times_purchased)) FROM DUAL null]>
  testMultiPartTableNameWithServerNameAndDatabaseName(net.sf.jsqlparser.test.select.SelectTest): expected:<...abaseName..tableName[]> but was:<...abaseName..tableName[ null]>
  testConcatProblem2_1(net.sf.jsqlparser.test.select.SelectTest): expected:<...CHAR) FROM testtable[]> but was:<...CHAR) FROM testtable[ null]>
  testConcatProblem2_2(net.sf.jsqlparser.test.select.SelectTest): expected:<...T_TMP FROM testtable[]> but was:<...T_TMP FROM testtable[ null]>
  testConcatProblem2_3(net.sf.jsqlparser.test.select.SelectTest): expected:<...CHAR) FROM testtable[]> but was:<...CHAR) FROM testtable[ null]>
  testConcatProblem2_4(net.sf.jsqlparser.test.select.SelectTest): expected:<...R (1) FROM testtable[]> but was:<...R (1) FROM testtable[ null]>
  testConcatProblem2_5(net.sf.jsqlparser.test.select.SelectTest): expected:<...|| c) FROM testtable[]> but was:<...|| c) FROM testtable[ null]>
  testConcatProblem2_6(net.sf.jsqlparser.test.select.SelectTest): expected:<...|| c) FROM testtable[]> but was:<...|| c) FROM testtable[ null]>
  testMultiPartColumnNameWithDatabaseNameAndSchemaNameAndTableName(net.sf.jsqlparser.test.select.SelectTest): expected:<...nName FROM tableName[]> but was:<...nName FROM tableName[ null]>
  testMultiPartColumnNameWithDatabaseNameAndTableName(net.sf.jsqlparser.test.select.SelectTest): expected:<...nName FROM tableName[]> but was:<...nName FROM tableName[ null]>
  testReplaceAsFunction(net.sf.jsqlparser.test.select.SelectTest): expected:<...a, 'b', c) FROM tab1[]> but was:<...a, 'b', c) FROM tab1[ null]>
  testSelectJPQLPositionalParameter(net.sf.jsqlparser.test.select.SelectTest): expected:<...CT email FROM users []WHERE (type LIKE 'B'...> but was:<...CT email FROM users [null ]WHERE (type LIKE 'B'...>
  testSelectWithinGroup(net.sf.jsqlparser.test.select.SelectTest): expected:<...BY col1) FROM table1[]> but was:<...BY col1) FROM table1[ null]>
  testNotEqualsTo(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT * FROM foo []WHERE a != b> but was:<SELECT * FROM foo [null ]WHERE a != b>
  testSelectForUpdate(net.sf.jsqlparser.test.select.SelectTest): expected:<...T * FROM user_table []FOR UPDATE> but was:<...T * FROM user_table [null ]FOR UPDATE>
  testProblemSqlAnalytic10Lag(net.sf.jsqlparser.test.select.SelectTest): expected:<... b) AS n FROM table1[]> but was:<... b) AS n FROM table1[ null]>
  testProblemSqlAnalytic11Lag(net.sf.jsqlparser.test.select.SelectTest): expected:<... b) AS n FROM table1[]> but was:<... b) AS n FROM table1[ null]>
  testMatches(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT * FROM team []WHERE team.search_co...> but was:<SELECT * FROM team [null ]WHERE team.search_co...>
  testAnalyticFunctionProblem1(net.sf.jsqlparser.test.select.SelectTest): expected:<...te_id) AS col FROM s[]> but was:<...te_id) AS col FROM s[ null]>
  testFunctions(net.sf.jsqlparser.test.select.SelectTest): expected:<...AS max FROM mytable []WHERE mytable.col = ...> but was:<...AS max FROM mytable [null ]WHERE mytable.col = ...>
  testProblemFunction2(net.sf.jsqlparser.test.select.SelectTest): expected:<...sdate FROM testtable[]> but was:<...sdate FROM testtable[ null]>
  testProblemFunction3(net.sf.jsqlparser.test.select.SelectTest): expected:<...(col) FROM testtable[]> but was:<...(col) FROM testtable[ null]>
  testSelectOrderHaving(net.sf.jsqlparser.test.select.SelectTest): expected:<...S num FROM currency []GROUP BY units HAVIN...> but was:<...S num FROM currency [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[ null]>
  testAnalyticFunction13(net.sf.jsqlparser.test.select.SelectTest): expected:<...a) OVER () FROM tab1[]> but was:<...a) OVER () FROM tab1[ null]>
  testAnalyticFunction14(net.sf.jsqlparser.test.select.SelectTest): expected:<...ION BY b ) FROM tab1[]> but was:<...ION BY b ) FROM tab1[ null]>
  testAnalyticFunction15(net.sf.jsqlparser.test.select.SelectTest): expected:<...RDER BY c) FROM tab1[]> but was:<...RDER BY c) FROM tab1[ null]>
  testAnalyticFunction16(net.sf.jsqlparser.test.select.SelectTest): expected:<...LLS FIRST) FROM tab1[]> but was:<...LLS FIRST) FROM tab1[ null]>
  testAnalyticFunction17(net.sf.jsqlparser.test.select.SelectTest): expected:<...current_sal FROM emp[]> but was:<...current_sal FROM emp[ null]>
  testAnalyticFunction18(net.sf.jsqlparser.test.select.SelectTest): expected:<...current_sal FROM emp[]> but was:<...current_sal FROM emp[ null]>
  testMultiPartTableNameWithServerNameAndDatabaseNameAndSchemaName(net.sf.jsqlparser.test.select.SelectTest): expected:<...schemaName.tableName[]> but was:<...schemaName.tableName[ null]>
  testBrackets(net.sf.jsqlparser.test.select.SelectTest): expected:<... [Test] FROM table_a[]> but was:<... [Test] FROM table_a[ 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[ null) SELECT * FROM feature null WHERE mslink IN (SELECT mslink FROM test null])>
  testIssue154_2(net.sf.jsqlparser.test.select.SelectTest): expected:<...stem_role FROM role []r WHERE r.merchant_i...> but was:<...stem_role FROM role [null ]r WHERE r.merchant_i...>
  testTimestamp(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT * FROM tab1 []WHERE a > {ts '2004-...> but was:<SELECT * FROM tab1 [null ]WHERE a > {ts '2004-...>
  testProblemSqlAnalytic5AggregateColumnValue(net.sf.jsqlparser.test.select.SelectTest): expected:<... () AS n FROM table1[]> but was:<... () AS n FROM table1[ null]>
  testMultiPartTableNameWithColumnName(net.sf.jsqlparser.test.select.SelectTest): expected:<...nName FROM tableName[]> but was:<...nName FROM tableName[ null]>
  testFunctionLeft(net.sf.jsqlparser.test.select.SelectTest): expected:<...col1, 4) FROM table1[]> but was:<...col1, 4) FROM table1[ null]>
  testCharacterSetClause(net.sf.jsqlparser.test.select.SelectTest): expected:<...AS `v0` FROM people []`view0` WHERE `view0...> but was:<...AS `v0` FROM people [null ]`view0` WHERE `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 = ...> but was:<... mytab.e FROM mytab [null 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 null] WHERE mytab2.del = ...>
  testProblemSqlAnalytic6AggregateColumnValue(net.sf.jsqlparser.test.select.SelectTest): expected:<... a) AS n FROM table1[]> but was:<... a) AS n FROM table1[ null]>
  testDistinct(net.sf.jsqlparser.test.select.SelectTest): expected:<... mycol FROM mytable []WHERE mytable.col = ...> but was:<... mycol FROM mytable [null ]WHERE mytable.col = ...>
  testMultiPartColumnNameWithSchemaNameAndTableName(net.sf.jsqlparser.test.select.SelectTest): expected:<...nName FROM tableName[]> but was:<...nName FROM tableName[ null]>
  testMultiPartTableNameWithServerName(net.sf.jsqlparser.test.select.SelectTest): expected:<...nstance]...tableName[]> but was:<...nstance]...tableName[ null]>
  testProblemSqlAnalytic7Count(net.sf.jsqlparser.test.select.SelectTest): expected:<... () AS n FROM table1[]> but was:<... () AS n FROM table1[ null]>
  testAllColumnsFromTable(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT tableName[.* FROM tableName]> but was:<SELECT tableName[ null.* FROM tableName 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[ null) INTERSECT (SELECT * FROM b null) UNION (SELECT * FROM c null])>
  testInterval2(net.sf.jsqlparser.test.select.SelectTest): expected:<...START_TIME FROM tab1[]> but was:<...START_TIME FROM tab1[ null]>
  testConcat(net.sf.jsqlparser.test.select.SelectTest): expected:<...|| b || c + 4 FROM t[]> but was:<...|| b || c + 4 FROM t[ null]>
  testCount2(net.sf.jsqlparser.test.select.SelectTest): expected:<...+ col2) FROM mytable[]> but was:<...+ col2) FROM mytable[ null]>
  testSignedColumns(net.sf.jsqlparser.test.select.SelectTest): expected:<...Name) FROM tableName[]> but was:<...Name) FROM tableName[ null]>
  testDouble(net.sf.jsqlparser.test.select.SelectTest): expected:<...1e2, * FROM mytable []WHERE mytable.col = ...> but was:<...1e2, * FROM mytable [null ]WHERE mytable.col = ...>
  testProblemSqlMinus(net.sf.jsqlparser.test.select.SelectTest): expected:<(SELECT * FROM a[) MINUS (SELECT * FROM b])> but was:<(SELECT * FROM a[ null) MINUS (SELECT * FROM b null])>
  testExists(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT * FROM tab1 [WHERE EXISTS (SELECT * FROM tab2])> but was:<SELECT * FROM tab1 [null WHERE EXISTS (SELECT * FROM tab2 null])>
  testMultiPartTableNameWithServerProblem(net.sf.jsqlparser.test.select.SelectTest): expected:<....dbo.t_transfer_num []a> but was:<....dbo.t_transfer_num [null ]a>
  testGroupByExpression(net.sf.jsqlparser.test.select.SelectTest): expected:<...m(col8) FROM table1 []GROUP BY col1, col2,...> but was:<...m(col8) FROM table1 [null ]GROUP BY col1, col2,...>
  testHaving(net.sf.jsqlparser.test.select.SelectTest): expected:<...X(tab1.b) FROM tab1 []WHERE a > 34 GROUP B...> but was:<...X(tab1.b) FROM tab1 [null ]WHERE a > 34 GROUP B...>
  testIssue154(net.sf.jsqlparser.test.select.SelectTest): expected:<..._time FROM discount [d LEFT OUTER JOIN discount_category] dc ON d.id = dc.dis...> but was:<..._time FROM discount [null d LEFT OUTER JOIN discount_category null] dc ON d.id = dc.dis...>
  testDistinctTop(net.sf.jsqlparser.test.select.SelectTest): expected:<... mycol FROM mytable []WHERE mytable.col = ...> but was:<... mycol FROM mytable [null ]WHERE mytable.col = ...>
  testSelectUserVariable(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT @col FROM t1[]> but was:<SELECT @col FROM t1[ null]>
  testIsNot2(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT * FROM test []WHERE a IS NOT NULL> but was:<SELECT * FROM test [null ]WHERE a IS NOT NULL>
  testTopWithParenthesis(net.sf.jsqlparser.test.select.SelectTest): expected:<...chemaName.tableName []alias ORDER BY alias...> but was:<...chemaName.tableName [null ]alias ORDER BY alias...>
  testSelectOracleColl(net.sf.jsqlparser.test.select.SelectTest): expected:<...CT * FROM the_table []tt WHERE TT.COL1 = l...> but was:<...CT * FROM the_table [null ]tt WHERE TT.COL1 = l...>
  testOracleJoin(net.sf.jsqlparser.test.select.SelectTest): expected:<...LECT * FROM tabelle1[, tabelle2] WHERE tabelle1.a = ...> but was:<...LECT * FROM tabelle1[ null, tabelle2 null] WHERE tabelle1.a = ...>
  testPostgreSQLRegExpCaseSensitiveMatch2(net.sf.jsqlparser.test.select.SelectTest): expected:<...ELECT a, b FROM foo []WHERE a ~* '[help].*...> but was:<...ELECT a, b FROM foo [null ]WHERE a ~* '[help].*...>
  testPostgreSQLRegExpCaseSensitiveMatch3(net.sf.jsqlparser.test.select.SelectTest): expected:<...ELECT a, b FROM foo []WHERE a !~ '[help].*...> but was:<...ELECT a, b FROM foo [null ]WHERE a !~ '[help].*...>
  testPostgreSQLRegExpCaseSensitiveMatch4(net.sf.jsqlparser.test.select.SelectTest): expected:<...ELECT a, b FROM foo []WHERE a !~* '[help]....> but was:<...ELECT a, b FROM foo [null ]WHERE a !~* '[help]....>
  testRowConstructor1(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT * FROM t1 [WHERE (col1, col2) = (SELECT col3, col4 FROM t2] WHERE id = 10)> but was:<SELECT * FROM t1 [null WHERE (col1, col2) = (SELECT col3, col4 FROM t2 null] WHERE id = 10)>
  testRowConstructor2(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT * FROM t1 [WHERE ROW(col1, col2) = (SELECT col3, col4 FROM t2] WHERE id = 10)> but was:<SELECT * FROM t1 [null WHERE ROW(col1, col2) = (SELECT col3, col4 FROM t2 null] WHERE id = 10)>
  testLimit2(net.sf.jsqlparser.test.select.SelectTest): expected:<...LECT * FROM mytable []WHERE mytable.col = ...> but was:<...LECT * FROM mytable [null ]WHERE mytable.col = ...>
  testTableCrossJoin(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT * FROM taba [CROSS JOIN tabb]> but was:<SELECT * FROM taba [null CROSS JOIN tabb null]>
  testProblemSqlAnalytic2(net.sf.jsqlparser.test.select.SelectTest): expected:<... b) AS n FROM table1[]> but was:<... b) AS n FROM table1[ null]>
  testProblemSqlAnalytic3(net.sf.jsqlparser.test.select.SelectTest): expected:<... b) AS n FROM table1[]> but was:<... b) AS n FROM table1[ null]>
  testProblemSqlAnalytic9CommaListPartition(net.sf.jsqlparser.test.select.SelectTest): expected:<... b) AS n FROM table1[]> but was:<... b) AS n FROM table1[ null]>
  testOracleHierarchicalQuery(net.sf.jsqlparser.test.select.SelectTest): expected:<...r_id FROM employees []CONNECT BY employee_...> but was:<...r_id FROM employees [null ]CONNECT BY employee_...>
  testPivot1(net.sf.jsqlparser.test.select.SelectTest): expected:<...ELECT * FROM mytable[ PIVOT (count(a) FOR b IN ('val1'))]> but was:<...ELECT * FROM mytable[]>
  testPivot2(net.sf.jsqlparser.test.select.SelectTest): expected:<...ELECT * FROM mytable[ PIVOT (count(a) FOR b IN (10, 20, 30))]> but was:<...ELECT * FROM mytable[]>
  testPivot3(net.sf.jsqlparser.test.select.SelectTest): expected:<...ELECT * FROM mytable[ PIVOT (count(a) AS vals FOR b IN (10 AS d1, 20, 30 AS d3))]> but was:<...ELECT * FROM mytable[]>
  testPivot4(net.sf.jsqlparser.test.select.SelectTest): expected:<...ELECT * FROM mytable[ PIVOT (count(a), sum(b) FOR b IN (10, 20, 30))]> but was:<...ELECT * FROM mytable[]>
  testPivot5(net.sf.jsqlparser.test.select.SelectTest): expected:<...ELECT * FROM mytable[ PIVOT (count(a) FOR (b, c) IN ((10, 'a'), (20, 'b'), (30, 'c')))]> but was:<...ELECT * FROM mytable[]>
  testSelectWithBrackets(net.sf.jsqlparser.test.select.SelectTest): expected:<...ELECT 1 FROM mytable[])> but was:<...ELECT 1 FROM mytable[ null])>
  testAnalyticFunctionProblem1b(net.sf.jsqlparser.test.select.SelectTest): expected:<...OWING) AS col FROM s[]> but was:<...OWING) AS col FROM s[ null]>
  testDeparser(net.sf.jsqlparser.test.select.SelectTest): expected:<... FROM ANTIQUEOWNERS [AS a, ANTIQUES] AS b WHERE b.BUYERI...> but was:<... FROM ANTIQUEOWNERS [null AS a, ANTIQUES null] AS b WHERE b.BUYERI...>
  testPivotXmlSubquery1(net.sf.jsqlparser.test.select.SelectTest): expected:<...code FROM customers []t) PIVOT (count(stat...> but was:<...code FROM customers [null ]t) PIVOT (count(stat...>
  testOracleHierarchicalQuery2(net.sf.jsqlparser.test.select.SelectTest): expected:<...r_id FROM employees []CONNECT BY PRIOR emp...> but was:<...r_id FROM employees [null ]CONNECT BY PRIOR emp...>
  testOracleHierarchicalQuery3(net.sf.jsqlparser.test.select.SelectTest): expected:<...EVEL FROM employees []START WITH employee_...> but was:<...EVEL FROM employees [null ]START WITH employee_...>
  testOracleHierarchicalQuery4(net.sf.jsqlparser.test.select.SelectTest): expected:<...EVEL FROM employees []CONNECT BY PRIOR emp...> but was:<...EVEL FROM employees [null ]CONNECT BY PRIOR emp...>
  testExtractFrom1(net.sf.jsqlparser.test.select.SelectTest): expected:<...lumn) FROM testtable[]> but was:<...lumn) FROM testtable[ null]>
  testExtractFrom2(net.sf.jsqlparser.test.select.SelectTest): expected:<...ow()) FROM testtable[]> but was:<...ow()) FROM testtable[ null]>
  testExtractFrom3(net.sf.jsqlparser.test.select.SelectTest): expected:<...- 2)) FROM testtable[]> but was:<...- 2)) FROM testtable[ null]>
  testExtractFrom4(net.sf.jsqlparser.test.select.SelectTest): expected:<...:00') FROM testtable[]> but was:<...:00') FROM testtable[ null]>
  testProblemSqlAnalytic4EmptyOver(net.sf.jsqlparser.test.select.SelectTest): expected:<... () AS n FROM table1[]> but was:<... () AS n FROM table1[ null]>
  testCastTypeProblem(net.sf.jsqlparser.test.select.SelectTest): expected:<...(256)) FROM tabelle1[]> but was:<...(256)) FROM tabelle1[ null]>
  testSelectKeywordPercent(net.sf.jsqlparser.test.select.SelectTest): expected:<...ercent FROM MY_TABLE[]> but was:<...ercent FROM MY_TABLE[ null]>
  testProblemSqlExcept(net.sf.jsqlparser.test.select.SelectTest): expected:<(SELECT * FROM a[) EXCEPT (SELECT * FROM b])> but was:<(SELECT * FROM a[ null) EXCEPT (SELECT * FROM b null])>
  testMultiPartTableNameWithServerNameAndSchemaName(net.sf.jsqlparser.test.select.SelectTest): expected:<...schemaName.tableName[]> but was:<...schemaName.tableName[ null]>
  testProblemSqlServer_Modulo(net.sf.jsqlparser.test.select.SelectTest): expected:<...nth' FROM test_table[]> but was:<...nth' FROM test_table[ null]>
  testReservedKeyword(net.sf.jsqlparser.test.select.SelectTest): expected:<..., xml FROM tableName[]> but was:<..., xml FROM tableName[ null]>
  testLimitSqlServerJdbcParameters(net.sf.jsqlparser.test.select.SelectTest): expected:<...LECT * FROM mytable []WHERE mytable.col = ...> but was:<...LECT * FROM mytable [null ]WHERE mytable.col = ...>
  testSelectJoin(net.sf.jsqlparser.test.select.SelectTest): expected:<... FROM pg_constraint [JOIN pg_class ON pg_class.oid = pg_constraint.conrelid JOIN pg_attribute] ON pg_attribute.att...> but was:<... FROM pg_constraint [null JOIN pg_class null ON pg_class.oid = pg_constraint.conrelid JOIN pg_attribute null] ON pg_attribute.att...>
  testSelectKeep(net.sf.jsqlparser.test.select.SelectTest): expected:<...), col4 FROM table1 []GROUP BY col5 ORDER ...> but was:<...), col4 FROM table1 [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[ null]>
  testNamedParameter2(net.sf.jsqlparser.test.select.SelectTest): expected:<...LECT * FROM mytable []WHERE a = :param OR ...> but was:<...LECT * FROM mytable [null ]WHERE a = :param OR ...>
  testBooleanFunction1(net.sf.jsqlparser.test.select.SelectTest): expected:<...LECT * FROM mytable []WHERE test_func(col1...> but was:<...LECT * FROM mytable [null ]WHERE test_func(col1...>
  testCastInCast2(net.sf.jsqlparser.test.select.SelectTest): expected:<...rchar) FROM tabelle1[]> but was:<...rchar) FROM tabelle1[ null]>
  testNamedParameter(net.sf.jsqlparser.test.select.SelectTest): expected:<...LECT * FROM mytable []WHERE b = :param> but was:<...LECT * FROM mytable [null ]WHERE b = :param>
  testTruncate(net.sf.jsqlparser.test.truncate.TruncateTest): expected:<...TABLE MYSCHEMA.MYTAB[]> but was:<...TABLE MYSCHEMA.MYTAB[ NULL]>
  testVisit_PlainSelect_concat(net.sf.jsqlparser.util.ConnectExpressionsVisitorTest): expected:<... c AS expr FROM test[]> but was:<... c AS expr FROM test[ null]>
  testVisit_PlainSelect_addition(net.sf.jsqlparser.util.ConnectExpressionsVisitorTest): expected:<...S testexpr FROM test[]> but was:<...S testexpr FROM test[ 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[ null) UNION (SELECT 7 + 8 AS A1 FROM test2 null])>
  testVisit_PlainSelect(net.sf.jsqlparser.util.AddAliasesVisitorTest): expected:<...2, c AS A3 FROM test[]> but was:<...2, c AS A3 FROM test[ null]>
  testVisit_PlainSelect_expression(net.sf.jsqlparser.util.AddAliasesVisitorTest): expected:<... + 4 AS A1 FROM test[]> but was:<... + 4 AS A1 FROM test[ null]>
  testVisit_PlainSelect_duplicates(net.sf.jsqlparser.util.AddAliasesVisitorTest): expected:<...1, c AS A3 FROM test[]> but was:<...1, c AS A3 FROM test[ null]>
  testBuildSelectFromTableAndExpressions(net.sf.jsqlparser.util.SelectUtilsTest): expected:<...CT a, b FROM mytable[]> but was:<...CT a, b FROM mytable[ null]>
  testAddExpr(net.sf.jsqlparser.util.SelectUtilsTest): expected:<...CT a, b FROM mytable[]> but was:<...CT a, b FROM mytable[ null]>
  testAddJoin(net.sf.jsqlparser.util.SelectUtilsTest): expected:<...LECT a FROM mytable [LEFT JOIN mytable2] ON a = b> but was:<...LECT a FROM mytable [null LEFT JOIN mytable2 null] ON a = b>
  testBuildSelectFromTable(net.sf.jsqlparser.util.SelectUtilsTest): expected:<...ELECT * FROM mytable[]> but was:<...ELECT * FROM mytable[ null]>
  testBuildSelectFromTableWithGroupBy(net.sf.jsqlparser.util.SelectUtilsTest): expected:<...LECT * FROM mytable []GROUP BY b> but was:<...LECT * FROM mytable [null ]GROUP BY b>
  testBuildSelectFromTableAndParsedExpression(net.sf.jsqlparser.util.SelectUtilsTest): expected:<...b, test FROM mytable[]> but was:<...b, test FROM mytable[ null]>
  testStatements(net.sf.jsqlparser.statement.StatementsTest): expected:<...ELECT * FROM mytable[;

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

[INFO] ------------------------------------------------------------------------
[INFO] BUILD FAILURE
[INFO] ------------------------------------------------------------------------
[INFO] Total time: 15.756s
[INFO] Finished at: Tue Oct 06 07:13:30 CEST 2015
[INFO] Final Memory: 21M/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
