[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/Database.java
[INFO] Scan 164 files header done in 216.895ms.
[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: 3, Errors: 0, Skipped: 0, Time elapsed: 0.069 sec <<< FAILURE!
Running net.sf.jsqlparser.test.create.CreateTableTest
Tests run: 27, Failures: 26, Errors: 0, Skipped: 0, Time elapsed: 0.078 sec <<< FAILURE!
Running net.sf.jsqlparser.test.create.CreateIndexTest
Tests run: 6, Failures: 6, Errors: 0, Skipped: 0, Time elapsed: 0.001 sec <<< FAILURE!
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.004 sec <<< FAILURE!
Running net.sf.jsqlparser.test.simpleparsing.CCJSqlParserManagerTest
Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.171 sec
Running net.sf.jsqlparser.test.drop.DropTest
Tests run: 2, Failures: 2, Errors: 0, Skipped: 0, Time elapsed: 0.002 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.005 sec
Running net.sf.jsqlparser.test.select.SpecialOracleTest
Oct 06, 2015 7:05:29 AM net.sf.jsqlparser.test.select.SpecialOracleTest testAllSqlsParseDeparse
INFO: testing string01.sql
Oct 06, 2015 7:05:29 AM net.sf.jsqlparser.test.select.SpecialOracleTest testAllSqlsParseDeparse
INFO:    -> PROBLEM net.sf.jsqlparser.JSQLParserException
Oct 06, 2015 7:05:29 AM net.sf.jsqlparser.test.select.SpecialOracleTest testAllSqlsParseDeparse
INFO: testing returning01.sql
Oct 06, 2015 7:05:29 AM net.sf.jsqlparser.test.select.SpecialOracleTest testAllSqlsParseDeparse
INFO:    -> PROBLEM net.sf.jsqlparser.JSQLParserException
Oct 06, 2015 7:05:29 AM net.sf.jsqlparser.test.select.SpecialOracleTest testAllSqlsParseDeparse
INFO: testing keywordasidentifier05.sql
Oct 06, 2015 7:05:29 AM net.sf.jsqlparser.test.select.SpecialOracleTest testAllSqlsOnlyParse
INFO: testing comment02.sql
Oct 06, 2015 7:05:29 AM net.sf.jsqlparser.test.select.SpecialOracleTest testAllSqlsOnlyParse
INFO:    -> SUCCESS
Oct 06, 2015 7:05:29 AM net.sf.jsqlparser.test.select.SpecialOracleTest testAllSqlsOnlyParse
INFO: testing numbers02.sql
Oct 06, 2015 7:05:29 AM net.sf.jsqlparser.test.select.SpecialOracleTest testAllSqlsOnlyParse
INFO:    -> SUCCESS
Oct 06, 2015 7:05:29 AM net.sf.jsqlparser.test.select.SpecialOracleTest testAllSqlsOnlyParse
INFO: testing comment01.sql
Oct 06, 2015 7:05:29 AM net.sf.jsqlparser.test.select.SpecialOracleTest testAllSqlsOnlyParse
INFO:    -> SUCCESS
Tests run: 2, Failures: 1, Errors: 0, Skipped: 0, Time elapsed: 0.097 sec <<< FAILURE!
Running net.sf.jsqlparser.test.select.SelectTest
Tests run: 228, Failures: 208, Errors: 0, Skipped: 0, Time elapsed: 0.511 sec <<< FAILURE!
Running net.sf.jsqlparser.test.select.SpeedTest
42500 statements parsed in 8095 milliseconds
 (5250 statements per second,  0.0001905 seconds per statement )
38500 select scans for table name executed in 158 milliseconds
 (243670 select scans for table name per second,  0.0000041 seconds per select scans for table name)
Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 8.238 sec
Running net.sf.jsqlparser.test.truncate.TruncateTest
Tests run: 1, Failures: 1, Errors: 0, Skipped: 0, Time elapsed: 0 sec <<< FAILURE!
Running net.sf.jsqlparser.util.TablesNamesFinderTest
Tests run: 19, Failures: 17, Errors: 0, Skipped: 0, Time elapsed: 0.011 sec <<< FAILURE!
Running net.sf.jsqlparser.util.ConnectExpressionsVisitorTest
Tests run: 2, Failures: 2, Errors: 0, Skipped: 0, Time elapsed: 0.003 sec <<< FAILURE!
Running net.sf.jsqlparser.util.AddAliasesVisitorTest
Tests run: 4, Failures: 4, Errors: 0, Skipped: 0, Time elapsed: 0.004 sec <<< FAILURE!
Running net.sf.jsqlparser.util.SelectUtilsTest
Tests run: 6, Failures: 3, Errors: 0, Skipped: 0, Time elapsed: 0.003 sec <<< FAILURE!
Running net.sf.jsqlparser.expression.ExpressionVisitorAdapterTest
Tests run: 2, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.001 sec
Running net.sf.jsqlparser.expression.SignedExpressionTest
Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0 sec
Running net.sf.jsqlparser.schema.ServerTest
Tests run: 2, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0 sec
Running net.sf.jsqlparser.parser.CCJSqlParserUtilTest
Tests run: 3, Failures: 3, Errors: 0, Skipped: 0, Time elapsed: 0.003 sec <<< FAILURE!
Running net.sf.jsqlparser.statement.SetStatementTest
Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.004 sec
Running net.sf.jsqlparser.statement.AdaptersTest
Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.003 sec
Running net.sf.jsqlparser.statement.StatementsTest
Tests run: 1, Failures: 1, Errors: 0, Skipped: 0, Time elapsed: 0.002 sec <<< FAILURE!
Running net.sf.jsqlparser.statement.execute.ExecuteTest
Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.001 sec

Results :

Failed tests:   testAlterTableUniqueKey(net.sf.jsqlparser.test.alter.AlterTest): expected:<ALTER TABLE []`schema_migrations` ...> but was:<ALTER TABLE [null..]`schema_migrations` ...>
  testAlterTableAddColumn(net.sf.jsqlparser.test.alter.AlterTest): expected:<[]mytable> but was:<[null..]mytable>
  testAlterTablePrimaryKey(net.sf.jsqlparser.test.alter.AlterTest): expected:<ALTER TABLE []animals ADD PRIMARY ...> but was:<ALTER TABLE [null..]animals ADD PRIMARY ...>
  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 [null..test (id INT UNSIGNED NOT NULL AUTO_INCREMENT, string VARCHAR (20), user_id INT UNSIGNED, PRIMARY KEY (id), FOREIGN KEY (user_id) REFERENCES null..]ra_user(id))>
  testCreateTableArrays(net.sf.jsqlparser.test.create.CreateTableTest): expected:<CREATE TABLE []sal_emp (name text, ...> but was:<CREATE TABLE [null..]sal_emp (name text, ...>
  testCreateTable2(net.sf.jsqlparser.test.create.CreateTableTest): expected:<CREATE TABLE []testtab ("test" varc...> but was:<CREATE TABLE [null..]testtab ("test" varc...>
  testCreateTable3(net.sf.jsqlparser.test.create.CreateTableTest): expected:<CREATE TABLE []testtab ("test" varc...> but was:<CREATE TABLE [null..]testtab ("test" varc...>
  testCreateTableParams(net.sf.jsqlparser.test.create.CreateTableTest): expected:<...ATE TEMPORARY TABLE []T1 (PROCESSID VARCHA...> but was:<...ATE TEMPORARY TABLE [null..]T1 (PROCESSID VARCHA...>
  testCreateTableDefault2(net.sf.jsqlparser.test.create.CreateTableTest): expected:<CREATE TABLE []T1 (id integer defau...> but was:<CREATE TABLE [null..]T1 (id integer defau...>
  testCreateTableWithKey(net.sf.jsqlparser.test.create.CreateTableTest): expected:<CREATE TABLE []bar (key character v...> but was:<CREATE TABLE [null..]bar (key character v...>
  testCreateTable(net.sf.jsqlparser.test.create.CreateTableTest): expected:<CREATE TABLE []mytab (mycol a (10, ...> but was:<CREATE TABLE [null..]mytab (mycol a (10, ...>
  testCreateTablePrimaryKey(net.sf.jsqlparser.test.create.CreateTableTest): expected:<CREATE TABLE []test (id INT UNSIGNE...> but was:<CREATE TABLE [null..]test (id INT UNSIGNE...>
  testCreateTableColumnValues(net.sf.jsqlparser.test.create.CreateTableTest): expected:<CREATE TABLE []mytable1 (values INT...> but was:<CREATE TABLE [null..]mytable1 (values INT...>
  testCreateTableDefault(net.sf.jsqlparser.test.create.CreateTableTest): expected:<CREATE TABLE []T1 (id integer defau...> but was:<CREATE TABLE [null..]T1 (id integer defau...>
  testCreateTableWithRange(net.sf.jsqlparser.test.create.CreateTableTest): expected:<CREATE TABLE []foo (name character ...> but was:<CREATE TABLE [null..]foo (name character ...>
  testCreateTableUniqueConstraint(net.sf.jsqlparser.test.create.CreateTableTest): expected:<create table []activities(_id integ...> but was:<create table [null..]activities(_id integ...>
  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 [null..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 null..]ra_user(id))>
  testCreateTableForeignKey3(net.sf.jsqlparser.test.create.CreateTableTest): expected:<create table []test(id int unsigned...> but was:<create table [null..]test(id int unsigned...>
  testCreateTableForeignKey4(net.sf.jsqlparser.test.create.CreateTableTest): expected:<create table []test(id int unsigned...> but was:<create table [null..]test(id int unsigned...>
  testCreateTableWithUniqueKey(net.sf.jsqlparser.test.create.CreateTableTest): expected:<CREATE TABLE []animals (id INT NOT ...> but was:<CREATE TABLE [null..]animals (id INT NOT ...>
  testCreateTableVeryComplex(net.sf.jsqlparser.test.create.CreateTableTest): expected:<create table []`wp_commentmeta`(`me...> but was:<create table [null..]`wp_commentmeta`(`me...>
  testCreateTableUnlogged2(net.sf.jsqlparser.test.create.CreateTableTest): expected:<...EATE UNLOGGED TABLE []mytab (mycol a (10, ...> but was:<...EATE UNLOGGED TABLE [null..]mytab (mycol a (10, ...>
  testCreateTableColumnValue(net.sf.jsqlparser.test.create.CreateTableTest): expected:<CREATE TABLE []mytable1 (value INTE...> but was:<CREATE TABLE [null..]mytable1 (value INTE...>
  testCreateTableInlinePrimaryKey(net.sf.jsqlparser.test.create.CreateTableTest): expected:<CREATE TABLE []animals (id INT PRIM...> but was:<CREATE TABLE [null..]animals (id INT PRIM...>
  testCreateTableArrays2(net.sf.jsqlparser.test.create.CreateTableTest): expected:<CREATE TABLE []sal_emp (name text, ...> but was:<CREATE TABLE [null..]sal_emp (name text, ...>
  testCreateTableAsSelect(net.sf.jsqlparser.test.create.CreateTableTest): expected:<CREATE TABLE [a AS SELECT col1, col2 FROM ]b> but was:<CREATE TABLE [null..a AS SELECT null...col1, null...col2 FROM null..]b>
  testCreateTableAsSelect2(net.sf.jsqlparser.test.create.CreateTableTest): expected:<CREATE TABLE n[ewtable 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:<CREATE TABLE n[ull..newtable AS WITH a AS (SELECT null...col1, null...col3 FROM null..testtable) SELECT null...col1, null...col2, null...col3 FROM null..b INNER JOIN null..a ON null..b.col1 = null..]a.col1>
  testCreateTableUnlogged(net.sf.jsqlparser.test.create.CreateTableTest): expected:<...EATE UNLOGGED TABLE []mytab (mycol a (10, ...> but was:<...EATE UNLOGGED TABLE [null..]mytab (mycol a (10, ...>
  testCreateTableIfNotExists(net.sf.jsqlparser.test.create.CreateTableTest): expected:<...TABLE IF NOT EXISTS []animals (id INT NOT ...> but was:<...TABLE IF NOT EXISTS [null..]animals (id INT NOT ...>
  testCreateIndex2(net.sf.jsqlparser.test.create.CreateIndexTest): expected:<[]mytab> but was:<[null..]mytab>
  testCreateIndex3(net.sf.jsqlparser.test.create.CreateIndexTest): expected:<[]mytab> but was:<[null..]mytab>
  testCreateIndex4(net.sf.jsqlparser.test.create.CreateIndexTest): expected:<[]mytab> but was:<[null..]mytab>
  testCreateIndex5(net.sf.jsqlparser.test.create.CreateIndexTest): expected:<[]mytab> but was:<[null..]mytab>
  testCreateIndex6(net.sf.jsqlparser.test.create.CreateIndexTest): expected:<...TE INDEX myindex ON []mytab (mycol, mycol2...> but was:<...TE INDEX myindex ON [null..]mytab (mycol, mycol2...>
  testCreateIndex(net.sf.jsqlparser.test.create.CreateIndexTest): expected:<[]mytab> but was:<[null..]mytab>
  testCreateView2(net.sf.jsqlparser.test.create.CreateViewTest): expected:<CREATE VIEW [myview AS SELECT * FROM ]mytab> but was:<CREATE VIEW [null..myview AS SELECT * FROM null..]mytab>
  testCreateView3(net.sf.jsqlparser.test.create.CreateViewTest): expected:<...ATE OR REPLACE VIEW [myview AS SELECT * FROM ]mytab> but was:<...ATE OR REPLACE VIEW [null..myview AS SELECT * FROM null..]mytab>
  testCreateView4(net.sf.jsqlparser.test.create.CreateViewTest): expected:<...ATE OR REPLACE VIEW [view2 AS SELECT a, b, c FROM testtab INNER JOIN testtab2 ON testtab.col1 = ]testtab2.col2> but was:<...ATE OR REPLACE VIEW [null..view2 AS SELECT null...a, null...b, null...c FROM null..testtab INNER JOIN null..testtab2 ON null..testtab.col1 = null..]testtab2.col2>
  testCreateView5(net.sf.jsqlparser.test.create.CreateViewTest): expected:<CREATE VIEW [myview AS (SELECT * FROM ]mytab)> but was:<CREATE VIEW [null..myview AS (SELECT * FROM null..]mytab)>
  testCreateView(net.sf.jsqlparser.test.create.CreateViewTest): expected:<CREATE VIEW [myview AS SELECT * FROM ]mytab> but was:<CREATE VIEW [null..myview AS SELECT * FROM null..]mytab>
  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 [null..view1 AS (SELECT null...a, null...b FROM null..testtab) UNION (SELECT null...b, null...c FROM null..]testtab2)>
  testCreateMaterializedView(net.sf.jsqlparser.test.create.CreateViewTest): expected:<...E MATERIALIZED VIEW [view1 AS SELECT a, b FROM ]testtab> but was:<...E MATERIALIZED VIEW [null..view1 AS SELECT null...a, null...b FROM null..]testtab>
  testCreateViewWithColumnNames1(net.sf.jsqlparser.test.create.CreateViewTest): expected:<...ATE OR REPLACE VIEW [view1(col1, col2) AS SELECT a, b FROM ]testtab> but was:<...ATE OR REPLACE VIEW [null..view1(col1, col2) AS SELECT null...a, null...b FROM null..]testtab>
  testDelete(net.sf.jsqlparser.test.delete.DeleteTest): expected:<DELETE FROM [mytable WHERE ]mytable.col = 9> but was:<DELETE FROM [null..mytable WHERE null..]mytable.col = 9>
  testDeleteWhereProblem1(net.sf.jsqlparser.test.delete.DeleteTest): expected:<DELETE FROM [tablename WHERE a = 1 AND ]b = 1> but was:<DELETE FROM [null..tablename WHERE null...a = 1 AND null...]b = 1>
  testDrop2(net.sf.jsqlparser.test.drop.DropTest): expected:<[]"testtable"> but was:<[null..]"testtable">
  testDrop(net.sf.jsqlparser.test.drop.DropTest): expected:<[]mytab> but was:<[null..]mytab>
  testInsertMultiRowValue(net.sf.jsqlparser.test.insert.InsertTest): expected:<INSERT INTO [mytable (col1, col2) VALUES (a, b), (d, ]e)> but was:<INSERT INTO [null..mytable (null...col1, null...col2) VALUES (null...a, null...b), (null...d, null...]e)>
  testInsertWithReturning2(net.sf.jsqlparser.test.insert.InsertTest): expected:<INSERT INTO [mytable (]mycolumn) VALUES ('1...> but was:<INSERT INTO [null..mytable (null...]mycolumn) VALUES ('1...>
  testInsertWithReturning3(net.sf.jsqlparser.test.insert.InsertTest): expected:<INSERT INTO [mytable (mycolumn) VALUES ('1') RETURNING id AS a1, ]id2 AS a2> but was:<INSERT INTO [null..mytable (null...mycolumn) VALUES ('1') RETURNING null...id AS a1, null...]id2 AS a2>
  testHexValues2(net.sf.jsqlparser.test.insert.InsertTest): expected:<INSERT INTO [TABLE2 VALUES ('1', ]"DSDD", 0xEFBFBDC7AB...> but was:<INSERT INTO [null..TABLE2 VALUES ('1', null...]"DSDD", 0xEFBFBDC7AB...>
  testHexValues3(net.sf.jsqlparser.test.insert.InsertTest): expected:<INSERT INTO [TABLE2 VALUES ('1', ]"DSDD", 0xabcde)> but was:<INSERT INTO [null..TABLE2 VALUES ('1', null...]"DSDD", 0xabcde)>
  testHexValues(net.sf.jsqlparser.test.insert.InsertTest): expected:<INSERT INTO [TABLE2 VALUES ('1', ]"DSDD", x'EFBFBDC7AB...> but was:<INSERT INTO [null..TABLE2 VALUES ('1', null...]"DSDD", x'EFBFBDC7AB...>
  testSimpleInsert(net.sf.jsqlparser.test.insert.InsertTest): expected:<INSERT INTO [example (num, name, address, ]tel) VALUES (1, 'nam...> but was:<INSERT INTO [null..example (null...num, null...name, null...address, null...]tel) VALUES (1, 'nam...>
  testInsertWithKeywords(net.sf.jsqlparser.test.insert.InsertTest): expected:<INSERT INTO [kvPair (value, ]key) VALUES (?, ?)> but was:<INSERT INTO [null..kvPair (null...value, null...]key) VALUES (?, ?)>
  testInsertWithReturning(net.sf.jsqlparser.test.insert.InsertTest): expected:<INSERT INTO [mytable (mycolumn) VALUES ('1') RETURNING ]id> but was:<INSERT INTO [null..mytable (null...mycolumn) VALUES ('1') RETURNING null...]id>
  testRegularInsert(net.sf.jsqlparser.test.insert.InsertTest): expected:<INSERT INTO [mytable (col1, col2, ]col3) VALUES (?, 'sa...> but was:<INSERT INTO [null..mytable (null...col1, null...col2, null...]col3) VALUES (?, 'sa...>
  testInsertWithKeywordValue(net.sf.jsqlparser.test.insert.InsertTest): expected:<INSERT INTO [mytable (]col1) VALUES ('val1'...> but was:<INSERT INTO [null..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 [null..mytable (null...col1, null...col2, null...col3) SELECT * FROM null..]mytable2>
  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 [null..mytable (null...mycolumn) WITH a AS (SELECT null...mycolumn FROM null..mytable) SELECT null...mycolumn FROM null..]a>
  testInsertSelect(net.sf.jsqlparser.test.insert.InsertTest): expected:<INSERT INTO [mytable (mycolumn) SELECT mycolumn FROM ]mytable> but was:<INSERT INTO [null..mytable (null...mycolumn) SELECT null...mycolumn FROM null..]mytable>
  testUpdateWithFrom(net.sf.jsqlparser.test.update.UpdateTest): expected:<UPDATE [table1 SET columna = 5 FROM table1 LEFT JOIN table2 ON col1 = ]col2> but was:<UPDATE [null..table1 SET null...columna = 5 FROM null..table1 LEFT JOIN null..table2 ON null...col1 = null...]col2>
  testUpdateMultiTable(net.sf.jsqlparser.test.update.UpdateTest): expected:<UPDATE [T1, T2 SET T1.C2 = T2.C2, T2.C3 = 'UPDATED' WHERE T1.C1 = T2.C1 AND ]T1.C2 < 10> but was:<UPDATE [null..T1, null..T2 SET null..T1.C2 = null..T2.C2, null..T2.C3 = 'UPDATED' WHERE null..T1.C1 = null..T2.C1 AND null..]T1.C2 < 10>
  testUpdateWithSelect2(net.sf.jsqlparser.test.update.UpdateTest): expected:<UPDATE [mytable SET (col1, col2, col3) = (SELECT a, b, c FROM ]mytable2)> but was:<UPDATE [null..mytable SET (null...col1, null...col2, null...col3) = (SELECT null...a, null...b, null...c FROM null..]mytable2)>
  testUpdateWithSelect(net.sf.jsqlparser.test.update.UpdateTest): expected:<UPDATE [NATION SET (N_NATIONKEY) = (SELECT ? FROM ]SYSIBM.SYSDUMMY1)> but was:<UPDATE [null..NATION SET (null...N_NATIONKEY) = (SELECT ? FROM null.]SYSIBM.SYSDUMMY1)>
  testUpdateWithDeparser(net.sf.jsqlparser.test.update.UpdateTest): expected:<UPDATE [table1 AS A SET A.columna = 'XXX' WHERE ]A.cod_table = 'YYY'> but was:<UPDATE [null..table1 AS A SET null..A.columna = 'XXX' WHERE null..]A.cod_table = 'YYY'>
  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 [null..a_table (null...ID, null...A, null...B) SELECT null...A_ID, null...A, null...B FROM null..]b_table>
  testReplaceSyntax1(net.sf.jsqlparser.test.replace.ReplaceTest): expected:<REPLACE [mytable SET col1='as', col2=?, ]col3=565> but was:<REPLACE [null..mytable SET null...col1='as', null...col2=?, null...]col3=565>
  testReplaceSyntax2(net.sf.jsqlparser.test.replace.ReplaceTest): expected:<REPLACE [mytable (col1, col2, ]col3) VALUES ('as', ...> but was:<REPLACE [null..mytable (null...col1, null...col2, null...]col3) VALUES ('as', ...>
  testAllSqlsParseDeparse(net.sf.jsqlparser.test.select.SpecialOracleTest): expected:<select [exception from ]exception> but was:<select [null...exception from null..]exception>
  testSelectAliasWithoutAs(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [mycolumn "My Column Name" FROM ]mytable> but was:<SELECT [null...mycolumn "My Column Name" FROM null..]mytable>
  testAllConditionSubSelect(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [e1.empno, e1.sal FROM emp e1 WHERE e1.sal > ALL (SELECT e2.sal FROM emp e2 WHERE ]e2.deptno = 10)> but was:<SELECT [null..e1.empno, null..e1.sal FROM null..emp e1 WHERE null..e1.sal > ALL (SELECT null..e2.sal FROM null..emp e2 WHERE null..]e2.deptno = 10)>
  testSimpleSigns(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT +1, -1 FROM []tableName> but was:<SELECT +1, -1 FROM [null..]tableName>
  testMultiValueIn2(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT * FROM [mytable WHERE (trim(a), trim(b)) IN (SELECT a, b FROM ]mytable2)> but was:<SELECT * FROM [null..mytable WHERE (trim(null...a), trim(null...b)) IN (SELECT null...a, null...b FROM null..]mytable2)>
  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 [null..foo.*, null..bar.* FROM null..foo, null..bar WHERE null..foo.id = null..bar.foo_id FOR UPDATE OF null..]foo>
  testPostgreSQLRegExpCaseSensitiveMatch(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [a, b FROM foo WHERE ]a ~ '[help].*'> but was:<SELECT [null...a, null...b FROM null..foo WHERE null...]a ~ '[help].*'>
  testOracleJoin2(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT * FROM [tabelle1, tabelle2 WHERE tabelle1.a(+) = ]tabelle2.b> but was:<SELECT * FROM [null..tabelle1, null..tabelle2 WHERE null..tabelle1.a(+) = null..]tabelle2.b>
  testOracleJoin3(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT * FROM [tabelle1, tabelle2 WHERE tabelle1.a(+) > ]tabelle2.b> but was:<SELECT * FROM [null..tabelle1, null..tabelle2 WHERE null..tabelle1.a(+) > null..]tabelle2.b>
  testOracleJoin4(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT * FROM [tabelle1, tabelle2 WHERE tabelle1.a(+) = tabelle2.b AND ]tabelle1.b(+) IN ('A...> but was:<SELECT * FROM [null..tabelle1, null..tabelle2 WHERE null..tabelle1.a(+) = null..tabelle2.b AND null..]tabelle1.b(+) IN ('A...>
  testMultiPartTableNameWithSchemaName(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [columnName FROM ]schemaName.tableName> but was:<SELECT [null...columnName FROM null.]schemaName.tableName>
  testSelectBrackets2(net.sf.jsqlparser.test.select.SelectTest): expected:<...RACT(epoch FROM age([d1, ]d2)) / 2)::numeric> but was:<...RACT(epoch FROM age([null...d1, null...]d2)) / 2)::numeric>
  testSelectBrackets3(net.sf.jsqlparser.test.select.SelectTest): expected:<...RACT(epoch FROM age([d1, ]d2)) / 2)::numeric)> but was:<...RACT(epoch FROM age([null...d1, null...]d2)) / 2)::numeric)>
  testSimpleAdditionsAndSubtractionsWithSigns(net.sf.jsqlparser.test.select.SelectTest): expected:<...+1 + 1, +1 - 1 FROM []tableName> but was:<...+1 + 1, +1 - 1 FROM [null..]tableName>
  testSelectAliasInQuotes(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [mycolumn AS "My Column Name" FROM ]mytable> but was:<SELECT [null...mycolumn AS "My Column Name" FROM null..]mytable>
  testOrderBy(net.sf.jsqlparser.test.select.SelectTest): expected:<[]tab1.a> but was:<[null..]tab1.a>
  testCastTypeProblem2(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [col1::varchar FROM ]tabelle1> but was:<SELECT [null...col1::varchar FROM null..]tabelle1>
  testCastTypeProblem3(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [col1::varchar (256) FROM ]tabelle1> but was:<SELECT [null...col1::varchar (256) FROM null..]tabelle1>
  testCastTypeProblem4(net.sf.jsqlparser.test.select.SelectTest): expected:<...:varchar (256) FROM []tabelle1> but was:<...:varchar (256) FROM [null..]tabelle1>
  testCastTypeProblem5(net.sf.jsqlparser.test.select.SelectTest): expected:<...:varchar (256) FROM []tabelle1> but was:<...:varchar (256) FROM [null..]tabelle1>
  testCastTypeProblem6(net.sf.jsqlparser.test.select.SelectTest): expected:<...racter varying FROM []tabelle1> but was:<...racter varying FROM [null..]tabelle1>
  testCastTypeProblem7(net.sf.jsqlparser.test.select.SelectTest): expected:<...acter varying) FROM []tabelle1> but was:<...acter varying) FROM [null..]tabelle1>
  testCastInCast(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT CAST(CAST([a AS numeric) AS varchar) FROM ]tabelle1> but was:<SELECT CAST(CAST([null...a AS numeric) AS varchar) FROM null..]tabelle1>
  testSkipFirst(net.sf.jsqlparser.test.select.SelectTest): expected:<[]c1> but was:<[null...]c1>
  testMultiPartTableNameWithDatabaseNameAndSchemaName(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [columnName FROM databaseName.]schemaName.tableName> but was:<SELECT [null...columnName FROM ]schemaName.tableName>
  testSelectJoinWithComma(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [cb.Genus, cb.Species FROM Coleccion_de_Briofitas AS cb, unigeoestados AS es WHERE es.nombre = "Tamaulipas" AND cb.the_geom = ]es.geom> but was:<SELECT [null..cb.Genus, null..cb.Species FROM null..Coleccion_de_Briofitas AS cb, null..unigeoestados AS es WHERE null..es.nombre = null..."Tamaulipas" AND null..cb.the_geom = null..]es.geom>
  testAdditionalLettersGerman(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [colä, colö, colü FROM ]testtableäöü> but was:<SELECT [null...colä, null...colö, null...colü FROM null..]testtableäöü>
  testTop(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT TOP 3 * FROM [mytable WHERE ]mytable.col = 9> but was:<SELECT TOP 3 * FROM [null..mytable WHERE null..]mytable.col = 9>
  testWithUnionProblem(net.sf.jsqlparser.test.select.SelectTest): expected:<...TH test AS ((SELECT [mslink FROM tablea) UNION (SELECT mslink FROM tableb)) SELECT * FROM tablea WHERE mslink IN (SELECT mslink FROM ]test)> but was:<...TH test AS ((SELECT [null...mslink FROM null..tablea) UNION (SELECT null...mslink FROM null..tableb)) SELECT * FROM null..tablea WHERE null...mslink IN (SELECT null...mslink FROM null..]test)>
  testMysqlQuote(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [`a.OWNERLASTNAME`, `OWNERFIRSTNAME` FROM `ANTIQUEOWNERS` AS a, ANTIQUES AS b WHERE b.BUYERID = a.OWNERID AND ]b.ITEM = 'Chair'> but was:<SELECT [null...`a.OWNERLASTNAME`, null...`OWNERFIRSTNAME` FROM null..`ANTIQUEOWNERS` AS a, null..ANTIQUES AS b WHERE null..b.BUYERID = null..a.OWNERID AND null..]b.ITEM = 'Chair'>
  testSelectInnerWith(net.sf.jsqlparser.test.select.SelectTest): expected:<...SELECT 'a' aid FROM [DUAL) SELECT aid FROM ]actor)> but was:<...SELECT 'a' aid FROM [null..DUAL) SELECT null...aid FROM null..]actor)>
  testReservedKeyword2(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [open FROM ]tableName> but was:<SELECT [null...open FROM null..]tableName>
  testFirst(net.sf.jsqlparser.test.select.SelectTest): expected:<[]alias.columnName1> but was:<[null..]alias.columnName1>
  testIlike(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [col1 FROM table1 WHERE ]col1 ILIKE '%hello%'> but was:<SELECT [null...col1 FROM null..table1 WHERE null...]col1 ILIKE '%hello%'>
  testIsNot(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT * FROM [test WHERE ]a IS NOT NULL> but was:<SELECT * FROM [null..test WHERE null...]a IS NOT NULL>
  testLimit(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT * FROM [mytable WHERE ]mytable.col = 9 LIMI...> but was:<SELECT * FROM [null..mytable WHERE null..]mytable.col = 9 LIMI...>
  testSigns(net.sf.jsqlparser.test.select.SelectTest): expected:<...CT (-(1)), -(1), (-([columnName)), -(columnName), (-1), -1, (-columnName), -columnName FROM ]tableName> but was:<...CT (-(1)), -(1), (-([null...columnName)), -(null...columnName), (-1), -1, (-null...columnName), -null...columnName FROM null..]tableName>
  testUnion(net.sf.jsqlparser.test.select.SelectTest): expected:<(SELECT * FROM [mytable WHERE mytable.col = 9) UNION (SELECT * FROM mytable3 WHERE mytable3.col = ?) UNION (SELECT * FROM ]mytable2 LIMIT 4 OFF...> but was:<(SELECT * FROM [null..mytable WHERE null..mytable.col = 9) UNION (SELECT * FROM null..mytable3 WHERE null..mytable3.col = ?) UNION (SELECT * FROM null..]mytable2 LIMIT 4 OFF...>
  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 [null..tab1 WHERE (null...a + null...b + null...c / null...d + null...e * null...f) * (null...a / null...b * (null...a + null...]b)) > ?>
  testRegexpLike1(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT * FROM [mytable WHERE REGEXP_LIKE(]first_name, '^Ste(v|...> but was:<SELECT * FROM [null..mytable WHERE REGEXP_LIKE(null...]first_name, '^Ste(v|...>
  testRegexpLike2(net.sf.jsqlparser.test.select.SelectTest): expected:<...SE WHEN REGEXP_LIKE([first_name, '^Ste(v|ph)en$') THEN 1 ELSE 2 END FROM ]mytable> but was:<...SE WHEN REGEXP_LIKE([null...first_name, '^Ste(v|ph)en$') THEN 1 ELSE 2 END FROM null..]mytable>
  testRegexpMySQL(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT * FROM [mytable WHERE ]first_name REGEXP '^...> but was:<SELECT * FROM [null..mytable WHERE null...]first_name REGEXP '^...>
  testCase(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [a, CASE b WHEN 1 THEN 2 END FROM ]tab1> but was:<SELECT [null...a, CASE null...b WHEN 1 THEN 2 END FROM null..]tab1>
  testCast(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT CAST([a AS varchar) FROM ]tabelle1> but was:<SELECT CAST([null...a AS varchar) FROM null..]tabelle1>
  testFrom(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT * FROM [mytable AS mytable0, mytable1 alias_tab1, mytable2 AS alias_tab2, (SELECT * FROM mytable3) AS mytable4 WHERE ]mytable.col = 9> but was:<SELECT * FROM [null..mytable AS mytable0, null..mytable1 alias_tab1, null..mytable2 AS alias_tab2, (SELECT * FROM null..mytable3) AS mytable4 WHERE null..]mytable.col = 9>
  testJoin(net.sf.jsqlparser.test.select.SelectTest): expected:<[]tab2> but was:<[null..]tab2>
  testLike(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT * FROM [tab1 WHERE ]a LIKE 'test'> but was:<SELECT * FROM [null..tab1 WHERE null...]a LIKE 'test'>
  testSkip(net.sf.jsqlparser.test.select.SelectTest): expected:<[]alias.columnName1> but was:<[null..]alias.columnName1>
  testTime(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT * FROM [tab1 WHERE ]a > {t '04:05:34'}> but was:<SELECT * FROM [null..tab1 WHERE null...]a > {t '04:05:34'}>
  testWith(net.sf.jsqlparser.test.select.SelectTest): expected:<WITH DINFO ([DEPTNO, AVGSALARY, EMPCOUNT) AS (SELECT OTHERS.WORKDEPT, AVG(OTHERS.SALARY), COUNT(*) FROM EMPLOYEE AS OTHERS GROUP BY OTHERS.WORKDEPT), DINFOMAX AS (SELECT MAX(AVGSALARY) AS AVGMAX FROM DINFO) SELECT THIS_EMP.EMPNO, THIS_EMP.SALARY, DINFO.AVGSALARY, DINFO.EMPCOUNT, DINFOMAX.AVGMAX FROM EMPLOYEE AS THIS_EMP INNER JOIN DINFO INNER JOIN DINFOMAX WHERE THIS_EMP.JOB = 'SALESREP' AND THIS_EMP.WORKDEPT = ]DINFO.DEPTNO> but was:<WITH DINFO ([null...DEPTNO, null...AVGSALARY, null...EMPCOUNT) AS (SELECT null..OTHERS.WORKDEPT, AVG(null..OTHERS.SALARY), COUNT(*) FROM null..EMPLOYEE AS OTHERS GROUP BY null..OTHERS.WORKDEPT), DINFOMAX AS (SELECT MAX(null...AVGSALARY) AS AVGMAX FROM null..DINFO) SELECT null..THIS_EMP.EMPNO, null..THIS_EMP.SALARY, null..DINFO.AVGSALARY, null..DINFO.EMPCOUNT, null..DINFOMAX.AVGMAX FROM null..EMPLOYEE AS THIS_EMP INNER JOIN null..DINFO INNER JOIN null..DINFOMAX WHERE null..THIS_EMP.JOB = 'SALESREP' AND null..THIS_EMP.WORKDEPT = null..]DINFO.DEPTNO>
  testJsonExpression(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [data->'images'->'thumbnail'->'url' AS thumb FROM ]instagram> but was:<SELECT [null...data->'images'->'thumbnail'->'url' AS thumb FROM null..]instagram>
  testConcatProblem2_5_1(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT ([a || b) || c FROM ]testtable> but was:<SELECT ([null...a || null...b) || null...c FROM null..]testtable>
  testConcatProblem2_5_2(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT ([a + b) + c FROM ]testtable> but was:<SELECT ([null...a + null...b) + null...c FROM null..]testtable>
  testProblemSqlAnalytic8Complex(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [ID, NAME, SALARY, SUM(SALARY) OVER () AS SUM_SAL, AVG(SALARY) OVER () AS AVG_SAL, MIN(SALARY) OVER () AS MIN_SAL, MAX(SALARY) OVER () AS MAX_SAL, COUNT(*) OVER () AS ROWS2 FROM STAFF WHERE ID < 60 ORDER BY ]ID> but was:<SELECT [null...ID, null...NAME, null...SALARY, SUM(null...SALARY) OVER () AS SUM_SAL, AVG(null...SALARY) OVER () AS AVG_SAL, MIN(null...SALARY) OVER () AS MIN_SAL, MAX(null...SALARY) OVER () AS MAX_SAL, COUNT(*) OVER () AS ROWS2 FROM null..STAFF WHERE null...ID < 60 ORDER BY null...]ID>
  testWithUnionAllProblem(net.sf.jsqlparser.test.select.SelectTest): expected:<...TH test AS ((SELECT [mslink FROM tablea) UNION ALL (SELECT mslink FROM tableb)) SELECT * FROM tablea WHERE mslink IN (SELECT mslink FROM ]test)> but was:<...TH test AS ((SELECT [null...mslink FROM null..tablea) UNION ALL (SELECT null...mslink FROM null..tableb)) SELECT * FROM null..tablea WHERE null...mslink IN (SELECT null...mslink FROM null..]test)>
  testOracleJoin2_1(net.sf.jsqlparser.test.select.SelectTest): expected:<select*from [tabelle1,tabelle2 where tabelle1.a(+)=]tabelle2.b> but was:<select*from [null..tabelle1,null..tabelle2 where null..tabelle1.a(+)=null..]tabelle2.b>
  testOracleJoin2_2(net.sf.jsqlparser.test.select.SelectTest): expected:<select*from [tabelle1,tabelle2 where tabelle1.a=]tabelle2.b(+)> but was:<select*from [null..tabelle1,null..tabelle2 where null..tabelle1.a=null..]tabelle2.b(+)>
  testOracleJoin3_1(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT * FROM [tabelle1, tabelle2 WHERE tabelle1.a > ]tabelle2.b(+)> but was:<SELECT * FROM [null..tabelle1, null..tabelle2 WHERE null..tabelle1.a > null..]tabelle2.b(+)>
  testAnyConditionSubSelect(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [e1.empno, e1.sal FROM emp e1 WHERE e1.sal > ANY (SELECT e2.sal FROM emp e2 WHERE ]e2.deptno = 10)> but was:<SELECT [null..e1.empno, null..e1.sal FROM null..emp e1 WHERE null..e1.sal > ANY (SELECT null..e2.sal FROM null..emp e2 WHERE null..]e2.deptno = 10)>
  testPivotXml1(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT * FROM [mytable PIVOT XML (count(a) FOR ]b IN ('val1'))> but was:<SELECT * FROM [null..mytable PIVOT XML (count(null...a) FOR null...]b IN ('val1'))>
  testPivotXml2(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT * FROM [mytable PIVOT XML (count(a) FOR b IN (SELECT vals FROM ]myothertable))> but was:<SELECT * FROM [null..mytable PIVOT XML (count(null...a) FOR null...b IN (SELECT null...vals FROM null..]myothertable))>
  testPivotXml3(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT * FROM [mytable PIVOT XML (count(a) FOR ]b IN (ANY))> but was:<SELECT * FROM [null..mytable PIVOT XML (count(null...a) FOR null...]b IN (ANY))>
  testIssue162_doubleUserVar(net.sf.jsqlparser.test.select.SelectTest): expected:<...ELECT @@SPID AS ID, [SYSTEM_USER AS "Login Name", ]USER AS "User Name"> but was:<...ELECT @@SPID AS ID, [null...SYSTEM_USER AS "Login Name", null...]USER AS "User Name">
  testOrderByNullsFirst(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [a FROM tab1 ORDER BY ]a NULLS FIRST> but was:<SELECT [null...a FROM null..tab1 ORDER BY null...]a NULLS FIRST>
  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 [null..taba INNER JOIN null..tabb ON null..taba.a = null..tabb.a, null..tabc LEFT JOIN null..tabd ON null..tabc.c = null..]tabd.c>
  testProblemSqlServer_Modulo_mod(net.sf.jsqlparser.test.select.SelectTest): expected:<...LECT mod(5, 2) FROM []A> but was:<...LECT mod(5, 2) FROM [null..]A>
  testProblemSqlAnalytic(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [a, row_number() OVER (ORDER BY a) AS n FROM ]table1> but was:<SELECT [null...a, row_number() OVER (ORDER BY null...a) AS n FROM null..]table1>
  testIssue160_signedParameter2(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT * FROM []mytable WHERE -? = 5> but was:<SELECT * FROM [null..]mytable WHERE -? = 5>
  testAdditionalLettersSpanish(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT * FROM []años> but was:<SELECT * FROM [null..]años>
  testLateral1(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [O.ORDERID, O.CUSTNAME, OL.LINETOTAL FROM ORDERS AS O, LATERAL(SELECT SUM(NETAMT) AS LINETOTAL FROM ORDERLINES AS LINES WHERE LINES.ORDERID = ]O.ORDERID) AS OL> but was:<SELECT [null..O.ORDERID, null..O.CUSTNAME, null..OL.LINETOTAL FROM null..ORDERS AS O, LATERAL(SELECT SUM(null...NETAMT) AS LINETOTAL FROM null..ORDERLINES AS LINES WHERE null..LINES.ORDERID = null..]O.ORDERID) AS OL>
  testSelectNumericBind(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [a FROM b WHERE ]c = :1> but was:<SELECT [null...a FROM null..b WHERE null...]c = :1>
  testRegexpBinaryMySQL(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT * FROM [mytable WHERE ]first_name REGEXP BI...> but was:<SELECT * FROM [null..mytable WHERE null...]first_name REGEXP BI...>
  testLateralComplex1(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [O.ORDERID, O.CUSTNAME, OL.LINETOTAL, OC.ORDCHGTOTAL, OT.TAXTOTAL FROM ORDERS O, LATERAL(SELECT SUM(NETAMT) AS LINETOTAL FROM ORDERLINES LINES WHERE LINES.ORDERID = O.ORDERID) AS OL, LATERAL(SELECT SUM(CHGAMT) AS ORDCHGTOTAL FROM ORDERCHARGES CHARGES WHERE LINES.ORDERID = O.ORDERID) AS OC, LATERAL(SELECT SUM(TAXAMT) AS TAXTOTAL FROM ORDERTAXES TAXES WHERE TAXES.ORDERID = ]O.ORDERID) AS OT> but was:<SELECT [null..O.ORDERID, null..O.CUSTNAME, null..OL.LINETOTAL, null..OC.ORDCHGTOTAL, null..OT.TAXTOTAL FROM null..ORDERS O, LATERAL(SELECT SUM(null...NETAMT) AS LINETOTAL FROM null..ORDERLINES LINES WHERE null..LINES.ORDERID = null..O.ORDERID) AS OL, LATERAL(SELECT SUM(null...CHGAMT) AS ORDCHGTOTAL FROM null..ORDERCHARGES CHARGES WHERE null..LINES.ORDERID = null..O.ORDERID) AS OC, LATERAL(SELECT SUM(null...TAXAMT) AS TAXTOTAL FROM null..ORDERTAXES TAXES WHERE null..TAXES.ORDERID = null..]O.ORDERID) AS OT>
  testMultiValueIn(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT * FROM [mytable WHERE (a, b, c) IN (SELECT a, b, c FROM ]mytable2)> but was:<SELECT * FROM [null..mytable WHERE (null...a, null...b, null...c) IN (SELECT null...a, null...b, null...c FROM null..]mytable2)>
  testProblemSqlIntersect(net.sf.jsqlparser.test.select.SelectTest): expected:<(SELECT * FROM [a) INTERSECT (SELECT * FROM ]b)> but was:<(SELECT * FROM [null..a) INTERSECT (SELECT * FROM null..]b)>
  testProblemFunction(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT test() FROM []testtable> but was:<SELECT test() FROM [null..]testtable>
  testConcatProblem2(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT MAX(((((([SPA.SOORTAANLEVERPERIODE)::VARCHAR (2) || (VARCHAR(SPA.AANLEVERPERIODEJAAR))::VARCHAR (4)) || TO_CHAR(SPA.AANLEVERPERIODEVOLGNR, 'FM09'::VARCHAR)) || TO_CHAR((10000 - SPA.VERSCHIJNINGSVOLGNR), 'FM0999'::VARCHAR)) || (SPA.GESLACHT)::VARCHAR (1))) AS GESLACHT_TMP FROM ]testtable> but was:<SELECT MAX(((((([null..SPA.SOORTAANLEVERPERIODE)::VARCHAR (2) || (VARCHAR(null..SPA.AANLEVERPERIODEJAAR))::VARCHAR (4)) || TO_CHAR(null..SPA.AANLEVERPERIODEVOLGNR, 'FM09'::VARCHAR)) || TO_CHAR((10000 - null..SPA.VERSCHIJNINGSVOLGNR), 'FM0999'::VARCHAR)) || (null..SPA.GESLACHT)::VARCHAR (1))) AS GESLACHT_TMP FROM null..]testtable>
  testBitwise(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [col1 & 32, col2 ^ col1, col1 | col2 FROM ]table1> but was:<SELECT [null...col1 & 32, null...col2 ^ null...col1, null...col1 | null...col2 FROM null..]table1>
  testSelectInto1(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT * INTO [user_copy FROM ]user> but was:<SELECT * INTO [null..user_copy FROM null..]user>
  testSelectItems(net.sf.jsqlparser.test.select.SelectTest): expected:<[]schema.tab> but was:<[null.]schema.tab>
  testSelectJoin2(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT * FROM [pg_constraint WHERE pg_attribute.attnum = ANY(]pg_constraint.conkey...> but was:<SELECT * FROM [null..pg_constraint WHERE null..pg_attribute.attnum = ANY(null..]pg_constraint.conkey...>
  testBrackets2(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [[a] FROM ]t> but was:<SELECT [null...[a] FROM null..]t>
  testProblemSqlServer_Modulo_Proz(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT 5 % 2 FROM []A> but was:<SELECT 5 % 2 FROM [null..]A>
  testFirstWithKeywordLimit(net.sf.jsqlparser.test.select.SelectTest): expected:<[]alias.columnName1> but was:<[null..]alias.columnName1>
  testGroupConcat(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [student_name, GROUP_CONCAT(DISTINCT test_score ORDER BY test_score DESC SEPARATOR ' ') FROM student GROUP BY ]student_name> but was:<SELECT [null...student_name, GROUP_CONCAT(DISTINCT null...test_score ORDER BY null...test_score DESC SEPARATOR ' ') FROM null..student GROUP BY null...]student_name>
  testWithRecursive(net.sf.jsqlparser.test.select.SelectTest): expected:<WITH RECURSIVE t (n[) AS ((SELECT 1) UNION ALL (SELECT n + 1 FROM t WHERE n < 100)) SELECT sum(n) FROM ]t> but was:<WITH RECURSIVE t (n[ull...n) AS ((SELECT 1) UNION ALL (SELECT null...n + 1 FROM null..t WHERE null...n < 100)) SELECT sum(null...n) FROM null..]t>
  testSelectKeepOver(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT MIN([salary) KEEP (DENSE_RANK FIRST ORDER BY commission_pct) OVER (PARTITION BY department_id ) "Worst" FROM employees ORDER BY department_id, ]salary> but was:<SELECT MIN([null...salary) KEEP (DENSE_RANK FIRST ORDER BY null...commission_pct) OVER (PARTITION BY null...department_id ) "Worst" FROM null..employees ORDER BY null...department_id, null...]salary>
  testFunctionRight(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT right([table1.col1, 4) FROM ]table1> but was:<SELECT right([null..table1.col1, 4) FROM null..]table1>
  testMultiPartColumnName(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [columnName FROM ]tableName> but was:<SELECT [null...columnName FROM null..]tableName>
  testWithUnionProblem3(net.sf.jsqlparser.test.select.SelectTest): expected:<...TH test AS ((SELECT [mslink, CAST(tablea.fname AS varchar) FROM tablea INNER JOIN tableb ON tablea.mslink = tableb.mslink AND tableb.deleted = 0 WHERE tablea.fname IS NULL AND 1 = 0) UNION ALL (SELECT mslink FROM tableb)) SELECT * FROM tablea WHERE mslink IN (SELECT mslink FROM ]test)> but was:<...TH test AS ((SELECT [null...mslink, CAST(null..tablea.fname AS varchar) FROM null..tablea INNER JOIN null..tableb ON null..tablea.mslink = null..tableb.mslink AND null..tableb.deleted = 0 WHERE null..tablea.fname IS NULL AND 1 = 0) UNION ALL (SELECT null...mslink FROM null..tableb)) SELECT * FROM null..tablea WHERE null...mslink IN (SELECT null...mslink FROM null..]test)>
  testWithUnionProblem4(net.sf.jsqlparser.test.select.SelectTest): expected:<...TH hist AS ((SELECT [gl.mslink, ba.gl_name AS txt, ba.gl_nummer AS nr, 0 AS level, CAST(gl.mslink AS VARCHAR) AS path, ae.feature FROM tablea AS gl INNER JOIN tableb AS ba ON gl.mslink = ba.gl_mslink INNER JOIN tablec AS ae ON gl.mslink = ae.mslink AND ae.deleted = 0 WHERE gl.parent IS NULL AND gl.mslink <> 0) UNION ALL (SELECT gl.mslink, ba.gl_name AS txt, ba.gl_nummer AS nr, hist.level + 1 AS level, CAST(hist.path + '.' + CAST(gl.mslink AS VARCHAR) AS VARCHAR) AS path, ae.feature FROM tablea AS gl INNER JOIN tableb AS ba ON gl.mslink = ba.gl_mslink INNER JOIN tablec AS ae ON gl.mslink = ae.mslink AND ae.deleted = 0 INNER JOIN hist ON gl.parent = hist.mslink WHERE gl.mslink <> 0)) SELECT mslink, space(level * 4) + txt AS txt, nr, feature, path FROM hist WHERE EXISTS (SELECT feature FROM tablec WHERE mslink = 0 AND ((feature IN (1, 2) AND hist.feature = 3) OR (feature IN (4) AND ]hist.feature = 2)))> but was:<...TH hist AS ((SELECT [null..gl.mslink, null..ba.gl_name AS txt, null..ba.gl_nummer AS nr, 0 AS level, CAST(null..gl.mslink AS VARCHAR) AS path, null..ae.feature FROM null..tablea AS gl INNER JOIN null..tableb AS ba ON null..gl.mslink = null..ba.gl_mslink INNER JOIN null..tablec AS ae ON null..gl.mslink = null..ae.mslink AND null..ae.deleted = 0 WHERE null..gl.parent IS NULL AND null..gl.mslink <> 0) UNION ALL (SELECT null..gl.mslink, null..ba.gl_name AS txt, null..ba.gl_nummer AS nr, null..hist.level + 1 AS level, CAST(null..hist.path + '.' + CAST(null..gl.mslink AS VARCHAR) AS VARCHAR) AS path, null..ae.feature FROM null..tablea AS gl INNER JOIN null..tableb AS ba ON null..gl.mslink = null..ba.gl_mslink INNER JOIN null..tablec AS ae ON null..gl.mslink = null..ae.mslink AND null..ae.deleted = 0 INNER JOIN null..hist ON null..gl.parent = null..hist.mslink WHERE null..gl.mslink <> 0)) SELECT null...mslink, space(null...level * 4) + null...txt AS txt, null...nr, null...feature, null...path FROM null..hist WHERE EXISTS (SELECT null...feature FROM null..tablec WHERE null...mslink = 0 AND ((null...feature IN (1, 2) AND null..hist.feature = 3) OR (null...feature IN (4) AND null..]hist.feature = 2)))>
  testWithUnionProblem5(net.sf.jsqlparser.test.select.SelectTest): expected:<...TH hist AS ((SELECT [gl.mslink, ba.gl_name AS txt, ba.gl_nummer AS nr, 0 AS level, CAST(gl.mslink AS VARCHAR) AS path, ae.feature FROM tablea AS gl INNER JOIN tableb AS ba ON gl.mslink = ba.gl_mslink INNER JOIN tablec AS ae ON gl.mslink = ae.mslink AND ae.deleted = 0 WHERE gl.parent IS NULL AND gl.mslink <> 0) UNION ALL (SELECT gl.mslink, ba.gl_name AS txt, ba.gl_nummer AS nr, hist.level + 1 AS level, CAST(hist.path + '.' + CAST(gl.mslink AS VARCHAR) AS VARCHAR) AS path, 5 AS feature FROM tablea AS gl INNER JOIN tableb AS ba ON gl.mslink = ba.gl_mslink INNER JOIN tablec AS ae ON gl.mslink = ae.mslink AND ae.deleted = 0 INNER JOIN hist ON gl.parent = hist.mslink WHERE gl.mslink <> 0)) SELECT * FROM ]hist> but was:<...TH hist AS ((SELECT [null..gl.mslink, null..ba.gl_name AS txt, null..ba.gl_nummer AS nr, 0 AS level, CAST(null..gl.mslink AS VARCHAR) AS path, null..ae.feature FROM null..tablea AS gl INNER JOIN null..tableb AS ba ON null..gl.mslink = null..ba.gl_mslink INNER JOIN null..tablec AS ae ON null..gl.mslink = null..ae.mslink AND null..ae.deleted = 0 WHERE null..gl.parent IS NULL AND null..gl.mslink <> 0) UNION ALL (SELECT null..gl.mslink, null..ba.gl_name AS txt, null..ba.gl_nummer AS nr, null..hist.level + 1 AS level, CAST(null..hist.path + '.' + CAST(null..gl.mslink AS VARCHAR) AS VARCHAR) AS path, 5 AS feature FROM null..tablea AS gl INNER JOIN null..tableb AS ba ON null..gl.mslink = null..ba.gl_mslink INNER JOIN null..tablec AS ae ON null..gl.mslink = null..ae.mslink AND null..ae.deleted = 0 INNER JOIN null..hist ON null..gl.parent = null..hist.mslink WHERE null..gl.mslink <> 0)) SELECT * FROM null..]hist>
  testValues5(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [X, ]Y FROM (VALUES (0, '...> but was:<SELECT [null...X, null...]Y FROM (VALUES (0, '...>
  testGroupBy(net.sf.jsqlparser.test.select.SelectTest): expected:<[]tab1.b> but was:<[null..]tab1.b>
  testMultiPartColumnNameWithTableName(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [tableName.columnName FROM ]tableName> but was:<SELECT [null..tableName.columnName FROM null..]tableName>
  testMultiPartTableNameWithDatabaseName(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [columnName FROM databaseName..]tableName> but was:<SELECT [null...columnName FROM ]tableName>
  testLimitSqlServer1(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT * FROM [mytable WHERE mytable.col = 9 ORDER BY ]mytable.id OFFSET 3 ...> but was:<SELECT * FROM [null..mytable WHERE null..mytable.col = 9 ORDER BY null..]mytable.id OFFSET 3 ...>
  testLimitSqlServer2(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT * FROM [mytable WHERE mytable.col = 9 ORDER BY ]mytable.id OFFSET 3 ...> but was:<SELECT * FROM [null..mytable WHERE null..mytable.col = 9 ORDER BY null..]mytable.id OFFSET 3 ...>
  testLimitSqlServer3(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT * FROM [mytable WHERE mytable.col = 9 ORDER BY ]mytable.id OFFSET 3 ...> but was:<SELECT * FROM [null..mytable WHERE null..mytable.col = 9 ORDER BY null..]mytable.id OFFSET 3 ...>
  testLimitSqlServer4(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT * FROM [mytable WHERE mytable.col = 9 ORDER BY ]mytable.id FETCH NEX...> but was:<SELECT * FROM [null..mytable WHERE null..mytable.col = 9 ORDER BY null..]mytable.id FETCH NEX...>
  testPivotFunction(net.sf.jsqlparser.test.select.SelectTest): expected:<...ECT to_char((SELECT [col1 FROM (SELECT times_purchased, state_code FROM customers t) PIVOT (count(state_code) FOR state_code IN ('NY', 'CT', 'NJ', 'FL', 'MO')) ORDER BY times_purchased)) FROM ]DUAL> but was:<...ECT to_char((SELECT [null...col1 FROM (SELECT null...times_purchased, null...state_code FROM null..customers t) PIVOT (count(null...state_code) FOR null...state_code IN ('NY', 'CT', 'NJ', 'FL', 'MO')) ORDER BY null...times_purchased)) FROM null..]DUAL>
  testMultiPartTableNameWithServerNameAndDatabaseName(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [columnName FROM [server-name\server-instance].databaseName]..tableName> but was:<SELECT [null...columnName FROM [server-name\server-instance].]..tableName>
  testConcatProblem2_1(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT TO_CHAR([SPA.AANLEVERPERIODEVOLGNR, 'FM09'::VARCHAR) FROM ]testtable> but was:<SELECT TO_CHAR([null..SPA.AANLEVERPERIODEVOLGNR, 'FM09'::VARCHAR) FROM null..]testtable>
  testConcatProblem2_2(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT MAX(([SPA.SOORTAANLEVERPERIODE)::VARCHAR (2) || (VARCHAR(SPA.AANLEVERPERIODEJAAR))::VARCHAR (4)) AS GESLACHT_TMP FROM ]testtable> but was:<SELECT MAX(([null..SPA.SOORTAANLEVERPERIODE)::VARCHAR (2) || (VARCHAR(null..SPA.AANLEVERPERIODEJAAR))::VARCHAR (4)) AS GESLACHT_TMP FROM null..]testtable>
  testConcatProblem2_3(net.sf.jsqlparser.test.select.SelectTest): expected:<...CT TO_CHAR((10000 - [SPA.VERSCHIJNINGSVOLGNR), 'FM0999'::VARCHAR) FROM ]testtable> but was:<...CT TO_CHAR((10000 - [null..SPA.VERSCHIJNINGSVOLGNR), 'FM0999'::VARCHAR) FROM null..]testtable>
  testConcatProblem2_4(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT ([SPA.GESLACHT)::VARCHAR (1) FROM ]testtable> but was:<SELECT ([null..SPA.GESLACHT)::VARCHAR (1) FROM null..]testtable>
  testConcatProblem2_5(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT max(([a || b) || c) FROM ]testtable> but was:<SELECT max(([null...a || null...b) || null...c) FROM null..]testtable>
  testConcatProblem2_6(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT max([a || b || c) FROM ]testtable> but was:<SELECT max([null...a || null...b || null...c) FROM null..]testtable>
  testMultiPartColumnNameWithDatabaseNameAndSchemaNameAndTableName(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [databaseName.schemaName.tableName.columnName FROM ]tableName> but was:<SELECT [schemaName.tableName.columnName FROM null..]tableName>
  testMultiPartColumnNameWithDatabaseNameAndTableName(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [databaseName..tableName.columnName FROM ]tableName> but was:<SELECT [tableName.columnName FROM null..]tableName>
  testReplaceAsFunction(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT REPLACE([a, 'b', c) FROM ]tab1> but was:<SELECT REPLACE([null...a, 'b', null...c) FROM null..]tab1>
  testSelectJPQLPositionalParameter(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [email FROM users WHERE (type LIKE 'B') AND (]username LIKE ?1)> but was:<SELECT [null...email FROM null..users WHERE (null...type LIKE 'B') AND (null...]username LIKE ?1)>
  testSelectWithinGroup(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT LISTAGG([col1, '##') WITHIN GROUP (ORDER BY col1) FROM ]table1> but was:<SELECT LISTAGG([null...col1, '##') WITHIN GROUP (ORDER BY null...col1) FROM null..]table1>
  testNotEqualsTo(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT * FROM [foo WHERE a != ]b> but was:<SELECT * FROM [null..foo WHERE null...a != null...]b>
  testSelectForUpdate(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT * FROM []user_table FOR UPDAT...> but was:<SELECT * FROM [null..]user_table FOR UPDAT...>
  testProblemSqlAnalytic10Lag(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [a, lag(a, 1) OVER (PARTITION BY c ORDER BY a, b) AS n FROM ]table1> but was:<SELECT [null...a, lag(null...a, 1) OVER (PARTITION BY null...c ORDER BY null...a, null...b) AS n FROM null..]table1>
  testProblemSqlAnalytic11Lag(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [a, lag(a, 1, 0) OVER (PARTITION BY c ORDER BY a, b) AS n FROM ]table1> but was:<SELECT [null...a, lag(null...a, 1, 0) OVER (PARTITION BY null...c ORDER BY null...a, null...b) AS n FROM null..]table1>
  testMatches(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT * FROM [team WHERE ]team.search_column @...> but was:<SELECT * FROM [null..team WHERE null..]team.search_column @...>
  testAnalyticFunctionProblem1(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT last_value([s.revenue_hold) OVER (PARTITION BY s.id_d_insertion_order, s.id_d_product_ad_attr, trunc(s.date_id, 'mm') ORDER BY s.date_id) AS col FROM ]s> but was:<SELECT last_value([null..s.revenue_hold) OVER (PARTITION BY null..s.id_d_insertion_order, null..s.id_d_product_ad_attr, trunc(null..s.date_id, 'mm') ORDER BY null..s.date_id) AS col FROM null..]s>
  testFunctions(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT MAX([id) AS max FROM mytable WHERE ]mytable.col = 9> but was:<SELECT MAX([null...id) AS max FROM null..mytable WHERE null..]mytable.col = 9>
  testProblemFunction2(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [sysdate FROM ]testtable> but was:<SELECT [null...sysdate FROM null..]testtable>
  testProblemFunction3(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT TRUNCATE([col) FROM ]testtable> but was:<SELECT TRUNCATE([null...col) FROM null..]testtable>
  testSelectOrderHaving(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [units, count(units) AS num FROM currency GROUP BY units HAVING count(units) > 1 ORDER BY ]num> but was:<SELECT [null...units, count(null...units) AS num FROM null..currency GROUP BY null...units HAVING count(null...units) > 1 ORDER BY null...]num>
  testAnalyticFunction12(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT SUM([a) OVER (PARTITION BY b ORDER BY c) FROM ]tab1> but was:<SELECT SUM([null...a) OVER (PARTITION BY null...b ORDER BY null...c) FROM null..]tab1>
  testAnalyticFunction13(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT SUM([a) OVER () FROM ]tab1> but was:<SELECT SUM([null...a) OVER () FROM null..]tab1>
  testAnalyticFunction14(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT SUM([a) OVER (PARTITION BY b ) FROM ]tab1> but was:<SELECT SUM([null...a) OVER (PARTITION BY null...b ) FROM null..]tab1>
  testAnalyticFunction15(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT SUM([a) OVER (ORDER BY c) FROM ]tab1> but was:<SELECT SUM([null...a) OVER (ORDER BY null...c) FROM null..]tab1>
  testAnalyticFunction16(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT SUM([a) OVER (ORDER BY c NULLS FIRST) FROM ]tab1> but was:<SELECT SUM([null...a) OVER (ORDER BY null...c NULLS FIRST) FROM null..]tab1>
  testAnalyticFunction17(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT AVG([sal) OVER (PARTITION BY deptno ORDER BY sal ROWS BETWEEN 0 PRECEDING AND 0 PRECEDING) AS avg_of_current_sal FROM ]emp> but was:<SELECT AVG([null...sal) OVER (PARTITION BY null...deptno ORDER BY null...sal ROWS BETWEEN 0 PRECEDING AND 0 PRECEDING) AS avg_of_current_sal FROM null..]emp>
  testAnalyticFunction18(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT AVG([sal) OVER (PARTITION BY deptno ORDER BY sal RANGE CURRENT ROW) AS avg_of_current_sal FROM ]emp> but was:<SELECT AVG([null...sal) OVER (PARTITION BY null...deptno ORDER BY null...sal RANGE CURRENT ROW) AS avg_of_current_sal FROM null..]emp>
  testMultiPartTableNameWithServerNameAndDatabaseNameAndSchemaName(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [columnName FROM [server-name\server-instance].databaseName].schemaName.tableNam...> but was:<SELECT [null...columnName FROM [server-name\server-instance].].schemaName.tableNam...>
  testBrackets(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [table_a.name AS [Test] FROM ]table_a> but was:<SELECT [null..table_a.name AS [Test] FROM null..]table_a>
  testWithStatement(net.sf.jsqlparser.test.select.SelectTest): expected:<...ITH test AS (SELECT [mslink FROM feature) SELECT * FROM feature WHERE mslink IN (SELECT mslink FROM ]test)> but was:<...ITH test AS (SELECT [null...mslink FROM null..feature) SELECT * FROM null..feature WHERE null...mslink IN (SELECT null...mslink FROM null..]test)>
  testIssue154_2(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [r.id, r.uuid, r.name, r.system_role FROM role r WHERE r.merchant_id = ? AND r.deleted_time IS NULL ORDER BY ]r.id DESC> but was:<SELECT [null..r.id, null..r.uuid, null..r.name, null..r.system_role FROM null..role r WHERE null..r.merchant_id = ? AND null..r.deleted_time IS NULL ORDER BY null..]r.id DESC>
  testTimestamp(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT * FROM [tab1 WHERE ]a > {ts '2004-04-30 ...> but was:<SELECT * FROM [null..tab1 WHERE null...]a > {ts '2004-04-30 ...>
  testProblemSqlAnalytic5AggregateColumnValue(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [a, sum(b) OVER () AS n FROM ]table1> but was:<SELECT [null...a, sum(null...b) OVER () AS n FROM null..]table1>
  testMultiPartTableNameWithColumnName(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [columnName FROM ]tableName> but was:<SELECT [null...columnName FROM null..]tableName>
  testFunctionLeft(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT left([table1.col1, 4) FROM ]table1> but was:<SELECT left([null..table1.col1, 4) FROM null..]table1>
  testCharacterSetClause(net.sf.jsqlparser.test.select.SelectTest): expected:<...ELECT DISTINCT CAST([`view0`.`nick2` AS CHAR (8000) CHARACTER SET utf8) AS `v0` FROM people `view0` WHERE ]`view0`.`nick2` IS N...> but was:<...ELECT DISTINCT CAST([null..`view0`.`nick2` AS CHAR (8000) CHARACTER SET utf8) AS `v0` FROM null..people `view0` WHERE null..]`view0`.`nick2` IS N...>
  testComplexUnion1(net.sf.jsqlparser.test.select.SelectTest): expected:<... 'abc-' || coalesce([mytab.a::varchar, '') AS a, mytab.b, mytab.c AS st, mytab.d, mytab.e FROM mytab WHERE mytab.del = 0) UNION (SELECT 'cde-' || coalesce(mytab2.a::varchar, '') AS a, mytab2.b, mytab2.bezeichnung AS c, 0 AS d, 0 AS e FROM mytab2 WHERE ]mytab2.del = 0)> but was:<... 'abc-' || coalesce([null..mytab.a::varchar, '') AS a, null..mytab.b, null..mytab.c AS st, null..mytab.d, null..mytab.e FROM null..mytab WHERE null..mytab.del = 0) UNION (SELECT 'cde-' || coalesce(null..mytab2.a::varchar, '') AS a, null..mytab2.b, null..mytab2.bezeichnung AS c, 0 AS d, 0 AS e FROM null..mytab2 WHERE null..]mytab2.del = 0)>
  testProblemSqlAnalytic6AggregateColumnValue(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [a, sum(b + 5) OVER (ORDER BY a) AS n FROM ]table1> but was:<SELECT [null...a, sum(null...b + 5) OVER (ORDER BY null...a) AS n FROM null..]table1>
  testDistinct(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT DISTINCT ON ([myid) myid, mycol FROM mytable WHERE ]mytable.col = 9> but was:<SELECT DISTINCT ON ([null...myid) null...myid, null...mycol FROM null..mytable WHERE null..]mytable.col = 9>
  testMultiPartColumnNameWithSchemaNameAndTableName(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [schemaName.tableName.columnName FROM ]tableName> but was:<SELECT [null.schemaName.tableName.columnName FROM null..]tableName>
  testMultiPartTableNameWithServerName(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [columnName FROM [server-name\server-instance].]..tableName> but was:<SELECT [null...columnName FROM [server-name\server-instance].null]..tableName>
  testProblemSqlAnalytic7Count(net.sf.jsqlparser.test.select.SelectTest): expected:<...) OVER () AS n FROM []table1> but was:<...) OVER () AS n FROM [null..]table1>
  testIssue160_signedParameter(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [start_date WHERE start_date > DATEADD(]HH, -?, GETDATE())> but was:<SELECT [null...start_date WHERE null...start_date > DATEADD(null...]HH, -?, GETDATE())>
  testAllColumnsFromTable(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [tableName.* FROM ]tableName> but was:<SELECT [null..tableName.* FROM null..]tableName>
  testProblemSqlCombinedSets(net.sf.jsqlparser.test.select.SelectTest): expected:<(SELECT * FROM [a) INTERSECT (SELECT * FROM b) UNION (SELECT * FROM ]c)> but was:<(SELECT * FROM [null..a) INTERSECT (SELECT * FROM null..b) UNION (SELECT * FROM null..]c)>
  testInterval2(net.sf.jsqlparser.test.select.SelectTest): expected:<... AS START_TIME FROM []tab1> but was:<... AS START_TIME FROM [null..]tab1>
  testConcat(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [a || b || c + 4 FROM ]t> but was:<SELECT [null...a || null...b || null...c + 4 FROM null..]t>
  testCount2(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT count(ALL [col1 + col2) FROM ]mytable> but was:<SELECT count(ALL [null...col1 + null...col2) FROM null..]mytable>
  testSignedColumns(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT -[columnName, +columnName, +(columnName), -(columnName) FROM ]tableName> but was:<SELECT -[null...columnName, +null...columnName, +(null...columnName), -(null...columnName) FROM null..]tableName>
  testDouble(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT 1e2, * FROM [mytable WHERE ]mytable.col = 9> but was:<SELECT 1e2, * FROM [null..mytable WHERE null..]mytable.col = 9>
  testProblemSqlMinus(net.sf.jsqlparser.test.select.SelectTest): expected:<(SELECT * FROM [a) MINUS (SELECT * FROM ]b)> but was:<(SELECT * FROM [null..a) MINUS (SELECT * FROM null..]b)>
  testExists(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT * FROM [tab1 WHERE EXISTS (SELECT * FROM ]tab2)> but was:<SELECT * FROM [null..tab1 WHERE EXISTS (SELECT * FROM null..]tab2)>
  testMultiPartTableNameWithServerProblem(net.sf.jsqlparser.test.select.SelectTest): expected:<...ECT * FROM LINK_100.[htsac].dbo.t_transfer_num ...> but was:<...ECT * FROM LINK_100.[].dbo.t_transfer_num ...>
  testGroupByExpression(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [col1, col2, col1 + col2, sum(col8) FROM table1 GROUP BY col1, col2, col1 + ]col2> but was:<SELECT [null...col1, null...col2, null...col1 + null...col2, sum(null...col8) FROM null..table1 GROUP BY null...col1, null...col2, null...col1 + null...]col2>
  testHaving(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT MAX([tab1.b) FROM tab1 WHERE a > 34 GROUP BY tab1.b HAVING MAX(]tab1.b) > 56> but was:<SELECT MAX([null..tab1.b) FROM null..tab1 WHERE null...a > 34 GROUP BY null..tab1.b HAVING MAX(null..]tab1.b) > 56>
  testIssue154(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [d.id, d.uuid, d.name, d.amount, d.percentage, d.modified_time FROM discount d LEFT OUTER JOIN discount_category dc ON d.id = dc.discount_id WHERE merchant_id = ? AND deleted = ? AND dc.discount_id IS NULL AND modified_time < ? AND modified_time >= ? ORDER BY ]modified_time> but was:<SELECT [null..d.id, null..d.uuid, null..d.name, null..d.amount, null..d.percentage, null..d.modified_time FROM null..discount d LEFT OUTER JOIN null..discount_category dc ON null..d.id = null..dc.discount_id WHERE null...merchant_id = ? AND null...deleted = ? AND null..dc.discount_id IS NULL AND null...modified_time < ? AND null...modified_time >= ? ORDER BY null...]modified_time>
  testDistinctTop(net.sf.jsqlparser.test.select.SelectTest): expected:<...LECT DISTINCT TOP 5 [myid, mycol FROM mytable WHERE ]mytable.col = 9> but was:<...LECT DISTINCT TOP 5 [null...myid, null...mycol FROM null..mytable WHERE null..]mytable.col = 9>
  testSelectUserVariable(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT @col FROM []t1> but was:<SELECT @col FROM [null..]t1>
  testIsNot2(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT * FROM [test WHERE ]a IS NOT NULL> but was:<SELECT * FROM [null..test WHERE null...]a IS NOT NULL>
  testTopWithParenthesis(net.sf.jsqlparser.test.select.SelectTest): expected:<[]alias.columnName1> but was:<[null..]alias.columnName1>
  testSelectOracleColl(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT * FROM [the_table tt WHERE TT.COL1 = lines(]idx).COL1> but was:<SELECT * FROM [null..the_table tt WHERE null..TT.COL1 = lines(null...]idx).COL1>
  testOracleJoin(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT * FROM [tabelle1, tabelle2 WHERE tabelle1.a = ]tabelle2.b(+)> but was:<SELECT * FROM [null..tabelle1, null..tabelle2 WHERE null..tabelle1.a = null..]tabelle2.b(+)>
  testPostgreSQLRegExpCaseSensitiveMatch2(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [a, b FROM foo WHERE ]a ~* '[help].*'> but was:<SELECT [null...a, null...b FROM null..foo WHERE null...]a ~* '[help].*'>
  testPostgreSQLRegExpCaseSensitiveMatch3(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [a, b FROM foo WHERE ]a !~ '[help].*'> but was:<SELECT [null...a, null...b FROM null..foo WHERE null...]a !~ '[help].*'>
  testPostgreSQLRegExpCaseSensitiveMatch4(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [a, b FROM foo WHERE ]a !~* '[help].*'> but was:<SELECT [null...a, null...b FROM null..foo WHERE null...]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 [null..t1 WHERE (null...col1, null...col2) = (SELECT null...col3, null...col4 FROM null..t2 WHERE null...]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 [null..t1 WHERE ROW(null...col1, null...col2) = (SELECT null...col3, null...col4 FROM null..t2 WHERE null...]id = 10)>
  testLimit2(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT * FROM [mytable WHERE ]mytable.col = 9 LIMI...> but was:<SELECT * FROM [null..mytable WHERE null..]mytable.col = 9 LIMI...>
  testTableCrossJoin(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT * FROM [taba CROSS JOIN ]tabb> but was:<SELECT * FROM [null..taba CROSS JOIN null..]tabb>
  testProblemSqlAnalytic2(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [a, row_number() OVER (ORDER BY a, b) AS n FROM ]table1> but was:<SELECT [null...a, row_number() OVER (ORDER BY null...a, null...b) AS n FROM null..]table1>
  testProblemSqlAnalytic3(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [a, row_number() OVER (PARTITION BY c ORDER BY a, b) AS n FROM ]table1> but was:<SELECT [null...a, row_number() OVER (PARTITION BY null...c ORDER BY null...a, null...b) AS n FROM null..]table1>
  testProblemSqlAnalytic9CommaListPartition(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [a, row_number() OVER (PARTITION BY c, d ORDER BY a, b) AS n FROM ]table1> but was:<SELECT [null...a, row_number() OVER (PARTITION BY null...c, null...d ORDER BY null...a, null...b) AS n FROM null..]table1>
  testSelectWithoutFrom(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT []footable.foocolumn> but was:<SELECT [null..]footable.foocolumn>
  testOracleHierarchicalQuery(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [last_name, employee_id, manager_id FROM employees CONNECT BY employee_id = manager_id ORDER BY ]last_name> but was:<SELECT [null...last_name, null...employee_id, null...manager_id FROM null..employees CONNECT BY null...employee_id = null...manager_id ORDER BY null...]last_name>
  testPivot1(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT * FROM [mytable PIVOT (count(a) FOR ]b IN ('val1'))> but was:<SELECT * FROM [null..mytable PIVOT (count(null...a) FOR null...]b IN ('val1'))>
  testPivot2(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT * FROM [mytable PIVOT (count(a) FOR ]b IN (10, 20, 30))> but was:<SELECT * FROM [null..mytable PIVOT (count(null...a) FOR null...]b IN (10, 20, 30))>
  testPivot3(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT * FROM [mytable PIVOT (count(a) AS vals FOR ]b IN (10 AS d1, 20, ...> but was:<SELECT * FROM [null..mytable PIVOT (count(null...a) AS vals FOR null...]b IN (10 AS d1, 20, ...>
  testPivot4(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT * FROM [mytable PIVOT (count(a), sum(b) FOR ]b IN (10, 20, 30))> but was:<SELECT * FROM [null..mytable PIVOT (count(null...a), sum(null...b) FOR null...]b IN (10, 20, 30))>
  testPivot5(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT * FROM [mytable PIVOT (count(a) FOR (b, ]c) IN ((10, 'a'), (2...> but was:<SELECT * FROM [null..mytable PIVOT (count(null...a) FOR (null...b, null...]c) IN ((10, 'a'), (2...>
  testSelectWithBrackets(net.sf.jsqlparser.test.select.SelectTest): expected:<(SELECT 1 FROM []mytable)> but was:<(SELECT 1 FROM [null..]mytable)>
  testAnalyticFunctionProblem1b(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT last_value([s.revenue_hold) OVER (PARTITION BY s.id_d_insertion_order, s.id_d_product_ad_attr, trunc(s.date_id, 'mm') ORDER BY s.date_id ROWS BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING) AS col FROM ]s> but was:<SELECT last_value([null..s.revenue_hold) OVER (PARTITION BY null..s.id_d_insertion_order, null..s.id_d_product_ad_attr, trunc(null..s.date_id, 'mm') ORDER BY null..s.date_id ROWS BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING) AS col FROM null..]s>
  testDeparser(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [a.OWNERLASTNAME, a.OWNERFIRSTNAME FROM ANTIQUEOWNERS AS a, ANTIQUES AS b WHERE b.BUYERID = a.OWNERID AND ]b.ITEM = 'Chair'> but was:<SELECT [null..a.OWNERLASTNAME, null..a.OWNERFIRSTNAME FROM null..ANTIQUEOWNERS AS a, null..ANTIQUES AS b WHERE null..b.BUYERID = null..a.OWNERID AND null..]b.ITEM = 'Chair'>
  testPivotXmlSubquery1(net.sf.jsqlparser.test.select.SelectTest): expected:<...LECT * FROM (SELECT [times_purchased, state_code FROM customers t) PIVOT (count(state_code) FOR state_code IN ('NY', 'CT', 'NJ', 'FL', 'MO')) ORDER BY ]times_purchased> but was:<...LECT * FROM (SELECT [null...times_purchased, null...state_code FROM null..customers t) PIVOT (count(null...state_code) FOR null...state_code IN ('NY', 'CT', 'NJ', 'FL', 'MO')) ORDER BY null...]times_purchased>
  testOracleHierarchicalQuery2(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [employee_id, last_name, manager_id FROM employees CONNECT BY PRIOR employee_id = ]manager_id> but was:<SELECT [null...employee_id, null...last_name, null...manager_id FROM null..employees CONNECT BY PRIOR null...employee_id = null...]manager_id>
  testOracleHierarchicalQuery3(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [last_name, employee_id, manager_id, LEVEL FROM employees START WITH employee_id = 100 CONNECT BY PRIOR employee_id = manager_id ORDER SIBLINGS BY ]last_name> but was:<SELECT [null...last_name, null...employee_id, null...manager_id, null...LEVEL FROM null..employees START WITH null...employee_id = 100 CONNECT BY PRIOR null...employee_id = null...manager_id ORDER SIBLINGS BY null...]last_name>
  testOracleHierarchicalQuery4(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [last_name, employee_id, manager_id, LEVEL FROM employees CONNECT BY PRIOR employee_id = manager_id START WITH employee_id = 100 ORDER SIBLINGS BY ]last_name> but was:<SELECT [null...last_name, null...employee_id, null...manager_id, null...LEVEL FROM null..employees CONNECT BY PRIOR null...employee_id = null...manager_id START WITH null...employee_id = 100 ORDER SIBLINGS BY null...]last_name>
  testExtractFrom1(net.sf.jsqlparser.test.select.SelectTest): expected:<... EXTRACT(month FROM [datecolumn) FROM ]testtable> but was:<... EXTRACT(month FROM [null...datecolumn) FROM null..]testtable>
  testExtractFrom2(net.sf.jsqlparser.test.select.SelectTest): expected:<...ar FROM now()) FROM []testtable> but was:<...ar FROM now()) FROM [null..]testtable>
  testExtractFrom3(net.sf.jsqlparser.test.select.SelectTest): expected:<...M (now() - 2)) FROM []testtable> but was:<...M (now() - 2)) FROM [null..]testtable>
  testExtractFrom4(net.sf.jsqlparser.test.select.SelectTest): expected:<... - '01:22:00') FROM []testtable> but was:<... - '01:22:00') FROM [null..]testtable>
  testProblemSqlAnalytic4EmptyOver(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [a, row_number() OVER () AS n FROM ]table1> but was:<SELECT [null...a, row_number() OVER () AS n FROM null..]table1>
  testCastTypeProblem(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT CAST([col1 AS varchar (256)) FROM ]tabelle1> but was:<SELECT CAST([null...col1 AS varchar (256)) FROM null..]tabelle1>
  testSelectKeywordPercent(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [percent FROM ]MY_TABLE> but was:<SELECT [null...percent FROM null..]MY_TABLE>
  testValues6BothVariants(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [I FROM (VALUES 1, 2, 3) AS MY_TEMP_TABLE(I) WHERE ]I IN (SELECT * FROM ...> but was:<SELECT [null...I FROM (VALUES 1, 2, 3) AS MY_TEMP_TABLE(I) WHERE null...]I IN (SELECT * FROM ...>
  testProblemSqlExcept(net.sf.jsqlparser.test.select.SelectTest): expected:<(SELECT * FROM [a) EXCEPT (SELECT * FROM ]b)> but was:<(SELECT * FROM [null..a) EXCEPT (SELECT * FROM null..]b)>
  testMultiPartTableNameWithServerNameAndSchemaName(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [columnName FROM [server-name\server-instance].].schemaName.tableNam...> but was:<SELECT [null...columnName FROM [server-name\server-instance].null].schemaName.tableNam...>
  testProblemSqlServer_Modulo(net.sf.jsqlparser.test.select.SelectTest): expected:<...char(255), DATEDIFF([month, year1, abc_datum) / 12) + ' year, ' + convert(varchar(255), DATEDIFF(month, year2, abc_datum) % 12) + ' month' FROM ]test_table> but was:<...char(255), DATEDIFF([null...month, null...year1, null...abc_datum) / 12) + ' year, ' + convert(varchar(255), DATEDIFF(null...month, null...year2, null...abc_datum) % 12) + ' month' FROM null..]test_table>
  testReservedKeyword(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [cast, do, extract, first, following, last, materialized, nulls, partition, range, row, rows, siblings, value, xml FROM ]tableName> but was:<SELECT [null...cast, null...do, null...extract, null...first, null...following, null...last, null...materialized, null...nulls, null...partition, null...range, null...row, null...rows, null...siblings, null...value, null...xml FROM null..]tableName>
  testLimitSqlServerJdbcParameters(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT * FROM [mytable WHERE mytable.col = 9 ORDER BY ]mytable.id OFFSET ? ...> but was:<SELECT * FROM [null..mytable WHERE null..mytable.col = 9 ORDER BY null..]mytable.id OFFSET ? ...>
  testSelectJoin(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [pg_class.relname, pg_attribute.attname, pg_constraint.conname FROM pg_constraint JOIN pg_class ON pg_class.oid = pg_constraint.conrelid JOIN pg_attribute ON pg_attribute.attrelid = pg_constraint.conrelid WHERE pg_constraint.contype = 'u' AND (pg_attribute.attnum = ANY(pg_constraint.conkey)) ORDER BY ]pg_constraint.connam...> but was:<SELECT [null..pg_class.relname, null..pg_attribute.attname, null..pg_constraint.conname FROM null..pg_constraint JOIN null..pg_class ON null..pg_class.oid = null..pg_constraint.conrelid JOIN null..pg_attribute ON null..pg_attribute.attrelid = null..pg_constraint.conrelid WHERE null..pg_constraint.contype = 'u' AND (null..pg_attribute.attnum = ANY(null..pg_constraint.conkey)) ORDER BY null..]pg_constraint.connam...>
  testSelectKeep(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [col1, min(col2) KEEP (DENSE_RANK FIRST ORDER BY col3), col4 FROM table1 GROUP BY col5 ORDER BY ]col3> but was:<SELECT [null...col1, min(null...col2) KEEP (DENSE_RANK FIRST ORDER BY null...col3), null...col4 FROM null..table1 GROUP BY null...col5 ORDER BY null...]col3>
  testCaseElseAddition(net.sf.jsqlparser.test.select.SelectTest): expected:<...0 + 1 END AS d FROM []dual> but was:<...0 + 1 END AS d FROM [null..]dual>
  testNamedParameter2(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT * FROM [mytable WHERE a = :param OR a = :param2 AND ]b = :param3> but was:<SELECT * FROM [null..mytable WHERE null...a = :param OR null...a = :param2 AND null...]b = :param3>
  testBooleanFunction1(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT * FROM [mytable WHERE test_func(]col1)> but was:<SELECT * FROM [null..mytable WHERE test_func(null...]col1)>
  testCastInCast2(net.sf.jsqlparser.test.select.SelectTest): expected:<... CAST('test' + CAST([assertEqual AS numeric) AS varchar) FROM ]tabelle1> but was:<... CAST('test' + CAST([null...assertEqual AS numeric) AS varchar) FROM null..]tabelle1>
  testNamedParameter(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT * FROM [mytable WHERE ]b = :param> but was:<SELECT * FROM [null..mytable WHERE null...]b = :param>
  testTruncate(net.sf.jsqlparser.test.truncate.TruncateTest): expected:<[]myschema.mytab> but was:<[null.]myschema.mytab>
  testCreateSelect(net.sf.jsqlparser.util.TablesNamesFinderTest)
  testCmplxSelectProblem(net.sf.jsqlparser.util.TablesNamesFinderTest)
  testExpr(net.sf.jsqlparser.util.TablesNamesFinderTest)
  testRUBiSTableList(net.sf.jsqlparser.util.TablesNamesFinderTest): stm num:1 expected:<[]items> but was:<[null..]items>
  testGetTableList(net.sf.jsqlparser.util.TablesNamesFinderTest): expected:<[]MY_TABLE1> but was:<[null..]MY_TABLE1>
  testMoreComplexExamples(net.sf.jsqlparser.util.TablesNamesFinderTest): stm num:1 expected:<5> but was:<7>
  testGetTableListWithStmt(net.sf.jsqlparser.util.TablesNamesFinderTest): expected:<1> but was:<2>
  testGetTableListFromUpdate2(net.sf.jsqlparser.util.TablesNamesFinderTest)
  testGetTableListFromUpdate3(net.sf.jsqlparser.util.TablesNamesFinderTest): expected:<3> but was:<4>
  testGetTableListFromDelete(net.sf.jsqlparser.util.TablesNamesFinderTest)
  testGetTableListFromInsert(net.sf.jsqlparser.util.TablesNamesFinderTest)
  testGetTableListFromUpdate(net.sf.jsqlparser.util.TablesNamesFinderTest)
  testGetTableListWithAlias(net.sf.jsqlparser.util.TablesNamesFinderTest): expected:<[]MY_TABLE1> but was:<[null..]MY_TABLE1>
  testGetTableListWithLateral(net.sf.jsqlparser.util.TablesNamesFinderTest)
  testInsertSelect(net.sf.jsqlparser.util.TablesNamesFinderTest)
  testInsertSubSelect(net.sf.jsqlparser.util.TablesNamesFinderTest)
  testGetTableListFromReplace(net.sf.jsqlparser.util.TablesNamesFinderTest)
  testVisit_PlainSelect_concat(net.sf.jsqlparser.util.ConnectExpressionsVisitorTest): expected:<SELECT [a || b || c AS expr FROM ]test> but was:<SELECT [null...a || null...b || null...c AS expr FROM null..]test>
  testVisit_PlainSelect_addition(net.sf.jsqlparser.util.ConnectExpressionsVisitorTest): expected:<SELECT [a + b + c AS testexpr FROM ]test> but was:<SELECT [null...a + null...b + null...c AS testexpr FROM null..]test>
  testVisit_SetOperationList(net.sf.jsqlparser.util.AddAliasesVisitorTest): expected:<...CT 3 + 4 AS A1 FROM [test) UNION (SELECT 7 + 8 AS A1 FROM ]test2)> but was:<...CT 3 + 4 AS A1 FROM [null..test) UNION (SELECT 7 + 8 AS A1 FROM null..]test2)>
  testVisit_PlainSelect(net.sf.jsqlparser.util.AddAliasesVisitorTest): expected:<SELECT [a AS A1, b AS A2, c AS A3 FROM ]test> but was:<SELECT [null...a AS A1, null...b AS A2, null...c AS A3 FROM null..]test>
  testVisit_PlainSelect_expression(net.sf.jsqlparser.util.AddAliasesVisitorTest): expected:<...CT 3 + 4 AS A1 FROM []test> but was:<...CT 3 + 4 AS A1 FROM [null..]test>
  testVisit_PlainSelect_duplicates(net.sf.jsqlparser.util.AddAliasesVisitorTest): expected:<SELECT [a AS A2, b AS a1, c AS A3 FROM ]test> but was:<SELECT [null...a AS A2, null...b AS a1, null...c AS A3 FROM null..]test>
  testAddExpr(net.sf.jsqlparser.util.SelectUtilsTest): expected:<SELECT [a, b FROM ]mytable> but was:<SELECT [null...a, b FROM null..]mytable>
  testAddJoin(net.sf.jsqlparser.util.SelectUtilsTest): expected:<SELECT [a FROM ]mytable LEFT JOIN my...> but was:<SELECT [null...a FROM null..]mytable LEFT JOIN my...>
  testBuildSelectFromTableAndParsedExpression(net.sf.jsqlparser.util.SelectUtilsTest): expected:<SELECT [a + b, ]test FROM mytable> but was:<SELECT [null...a + null...b, null...]test FROM mytable>
  testParseExpression2(net.sf.jsqlparser.parser.CCJSqlParserUtilTest): expected:<2 * ([]a + 6.0)> but was:<2 * ([null...]a + 6.0)>
  testParseCondExpression(net.sf.jsqlparser.parser.CCJSqlParserUtilTest): expected:<[a + b > 5 AND ]c < 3> but was:<[null...a + null...b > 5 AND null...]c < 3>
  testParseExpression(net.sf.jsqlparser.parser.CCJSqlParserUtilTest): expected:<[a + ]b> but was:<[null...a + null...]b>
  testStatements(net.sf.jsqlparser.statement.StatementsTest): expected:<SELECT * FROM [mytable;

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

[INFO] ------------------------------------------------------------------------
[INFO] BUILD FAILURE
[INFO] ------------------------------------------------------------------------
[INFO] Total time: 15.906s
[INFO] Finished at: Tue Oct 06 07:05:38 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
