[INFO] Scanning for projects...
[INFO]                                                                         
[INFO] ------------------------------------------------------------------------
[INFO] Building JSQLParser library 0.9.4
[INFO] ------------------------------------------------------------------------
[INFO] 
[INFO] --- javacc-maven-plugin:2.6:jjtree-javacc (javacc) @ jsqlparser ---
[INFO] Skipping - all parsers are up to date
[INFO] 
[INFO] --- license-maven-plugin:1.6:update-file-header (first) @ jsqlparser ---
[INFO] Will search files to update from root /home/perham/Study/Experiments/2015-10-23-ICST/LittleDarwin/Cases/JSqlParser-jsqlparser-0.9.4/src/main/java
[INFO]  - adding license header on file /home/perham/Study/Experiments/2015-10-23-ICST/LittleDarwin/Cases/JSqlParser-jsqlparser-0.9.4/src/main/java/net/sf/jsqlparser/statement/select/PlainSelect.java
[INFO] Scan 164 files header done in 217.016ms.
[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.071 sec <<< FAILURE!
Running net.sf.jsqlparser.test.create.CreateTableTest
Tests run: 27, Failures: 26, Errors: 0, Skipped: 0, Time elapsed: 0.075 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.008 sec <<< FAILURE!
Running net.sf.jsqlparser.test.delete.DeleteTest
Tests run: 2, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.006 sec
Running net.sf.jsqlparser.test.simpleparsing.CCJSqlParserManagerTest
Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.177 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.045 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.006 sec <<< FAILURE!
Running net.sf.jsqlparser.test.replace.ReplaceTest
Tests run: 4, Failures: 2, 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.004 sec
Running net.sf.jsqlparser.test.select.SpecialOracleTest
Oct 06, 2015 7:47:12 AM net.sf.jsqlparser.test.select.SpecialOracleTest testAllSqlsParseDeparse
INFO: testing string01.sql
Oct 06, 2015 7:47:12 AM net.sf.jsqlparser.test.select.SpecialOracleTest testAllSqlsParseDeparse
INFO:    -> PROBLEM net.sf.jsqlparser.JSQLParserException
Oct 06, 2015 7:47:12 AM net.sf.jsqlparser.test.select.SpecialOracleTest testAllSqlsParseDeparse
INFO: testing returning01.sql
Oct 06, 2015 7:47:12 AM net.sf.jsqlparser.test.select.SpecialOracleTest testAllSqlsParseDeparse
INFO:    -> PROBLEM net.sf.jsqlparser.JSQLParserException
Oct 06, 2015 7:47:12 AM net.sf.jsqlparser.test.select.SpecialOracleTest testAllSqlsParseDeparse
INFO: testing keywordasidentifier05.sql
Oct 06, 2015 7:47:12 AM net.sf.jsqlparser.test.select.SpecialOracleTest testAllSqlsOnlyParse
INFO: testing comment02.sql
Oct 06, 2015 7:47:12 AM net.sf.jsqlparser.test.select.SpecialOracleTest testAllSqlsOnlyParse
INFO:    -> SUCCESS
Oct 06, 2015 7:47:12 AM net.sf.jsqlparser.test.select.SpecialOracleTest testAllSqlsOnlyParse
INFO: testing numbers02.sql
Oct 06, 2015 7:47:12 AM net.sf.jsqlparser.test.select.SpecialOracleTest testAllSqlsOnlyParse
INFO:    -> SUCCESS
Oct 06, 2015 7:47:12 AM net.sf.jsqlparser.test.select.SpecialOracleTest testAllSqlsOnlyParse
INFO: testing comment01.sql
Oct 06, 2015 7:47:12 AM net.sf.jsqlparser.test.select.SpecialOracleTest testAllSqlsOnlyParse
INFO:    -> SUCCESS
Tests run: 2, Failures: 1, Errors: 0, Skipped: 0, Time elapsed: 0.087 sec <<< FAILURE!
Running net.sf.jsqlparser.test.select.SelectTest
Tests run: 228, Failures: 219, Errors: 0, Skipped: 0, Time elapsed: 0.561 sec <<< FAILURE!
Running net.sf.jsqlparser.test.select.SpeedTest
42500 statements parsed in 7751 milliseconds
 (5483 statements per second,  0.0001824 seconds per statement )
38500 select scans for table name executed in 150 milliseconds
 (256666 select scans for table name per second,  0.0000039 seconds per select scans for table name)
Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 7.891 sec
Running net.sf.jsqlparser.test.truncate.TruncateTest
Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0 sec
Running net.sf.jsqlparser.util.TablesNamesFinderTest
Tests run: 19, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.016 sec
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: 6, Errors: 0, Skipped: 0, Time elapsed: 0.004 sec <<< FAILURE!
Running net.sf.jsqlparser.expression.ExpressionVisitorAdapterTest
Tests run: 2, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0 sec
Running net.sf.jsqlparser.expression.SignedExpressionTest
Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0 sec
Running net.sf.jsqlparser.schema.ServerTest
Tests run: 2, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.001 sec
Running net.sf.jsqlparser.parser.CCJSqlParserUtilTest
Tests run: 3, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.002 sec
Running net.sf.jsqlparser.statement.SetStatementTest
Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.005 sec
Running net.sf.jsqlparser.statement.AdaptersTest
Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.001 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: 1, Errors: 0, Skipped: 0, Time elapsed: 0.001 sec <<< FAILURE!

Results :

Failed tests:   testAlterTableUniqueKey(net.sf.jsqlparser.test.alter.AlterTest): expected:<...schema_migrations` ([`version`])> but was:<...schema_migrations` ([])>
  testAlterTableAddColumn(net.sf.jsqlparser.test.alter.AlterTest): expected:<varchar ([255])> but was:<varchar ([])>
  testAlterTablePrimaryKey(net.sf.jsqlparser.test.alter.AlterTest): expected:<...ls ADD PRIMARY KEY ([id])> but was:<...ls ADD PRIMARY KEY ([])>
  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 ([, ])>
  testCreateTableArrays(net.sf.jsqlparser.test.create.CreateTableTest): expected:<...EATE TABLE sal_emp ([name text, pay_by_quarter integer[], schedule text[][]])> but was:<...EATE TABLE sal_emp ([])>
  testCreateTable2(net.sf.jsqlparser.test.create.CreateTableTest): expected:<...EATE TABLE testtab (["test" varchar (255)])> but was:<...EATE TABLE testtab ([])>
  testCreateTable3(net.sf.jsqlparser.test.create.CreateTableTest): expected:<...EATE TABLE testtab (["test" varchar (255), "test2" varchar (255)])> but was:<...EATE TABLE testtab ([])>
  testCreateTableParams(net.sf.jsqlparser.test.create.CreateTableTest): expected:<CREATE T[EMPORARY TABLE T1 (PROCESSID VARCHAR (32)) ON COMMIT PRESERVE ROWS]> but was:<CREATE T[ABLE T1 ()]>
  testCreateTableDefault2(net.sf.jsqlparser.test.create.CreateTableTest): expected:<CREATE TABLE T1 ([id integer default 1])> but was:<CREATE TABLE T1 ([])>
  testCreateTableWithKey(net.sf.jsqlparser.test.create.CreateTableTest): expected:<CREATE TABLE bar ([key character varying (255) NOT NULL])> but was:<CREATE TABLE bar ([])>
  testCreateTable(net.sf.jsqlparser.test.create.CreateTableTest): expected:<CREATE TABLE mytab ([mycol a (10, 20) c nm g, mycol2 mypar1 mypar2 (23,323,3) asdf ('23','123') dasd, PRIMARY KEY (mycol2, mycol)) type = myisam]> but was:<CREATE TABLE mytab ([, )]>
  testCreateTablePrimaryKey(net.sf.jsqlparser.test.create.CreateTableTest): expected:<CREATE TABLE test ([id INT UNSIGNED NOT NULL AUTO_INCREMENT, string VARCHAR (20), user_id INT UNSIGNED, CONSTRAINT pk_name PRIMARY KEY (id)])> but was:<CREATE TABLE test ([, ])>
  testCreateTableColumnValues(net.sf.jsqlparser.test.create.CreateTableTest): expected:<...ATE TABLE mytable1 ([values INTEGER])> but was:<...ATE TABLE mytable1 ([])>
  testCreateTableDefault(net.sf.jsqlparser.test.create.CreateTableTest): expected:<CREATE TABLE T1 ([id integer default -1])> but was:<CREATE TABLE T1 ([])>
  testCreateTableWithRange(net.sf.jsqlparser.test.create.CreateTableTest): expected:<CREATE TABLE foo ([name character varying (255), range character varying (255), start_range integer, end_range integer])> but was:<CREATE TABLE foo ([])>
  testCreateTableUniqueConstraint(net.sf.jsqlparser.test.create.CreateTableTest): expected:<...te table activities([_id integer primary key autoincrement,uuid varchar(255),user_id integer,sound_id integer,sound_type integer,comment_id integer,type string,tags varchar(255),created_at integer,content_id integer,sharing_note_text varchar(255),sharing_note_created_at integer,unique(created_at,type,content_id,sound_id,user_id)])> but was:<...te table activities([,])>
  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 ([, ])>
  testCreateTableForeignKey3(net.sf.jsqlparser.test.create.CreateTableTest): expected:<create table test([id int unsigned not null auto_increment,string varchar(20),user_id int unsigned references ra_user(id),primary key(id)])> but was:<create table test([,])>
  testCreateTableForeignKey4(net.sf.jsqlparser.test.create.CreateTableTest): expected:<create table test([id int unsigned not null auto_increment,string varchar(20),user_id int unsigned foreign key references ra_user(id),primary key(id)])> but was:<create table test([,])>
  testCreateTableWithUniqueKey(net.sf.jsqlparser.test.create.CreateTableTest): expected:<...EATE TABLE animals ([id INT NOT NULL, name VARCHAR (100) UNIQUE KEY (id)])> but was:<...EATE TABLE animals ([])>
  testCreateTableVeryComplex(net.sf.jsqlparser.test.create.CreateTableTest): expected:<...le `wp_commentmeta`([`meta_id` bigint(20)unsigned not null auto_increment,`comment_id` bigint(20)unsigned not null default '0',`meta_key` varchar(255)default null,`meta_value` longtext,primary key(`meta_id`),key `comment_id`(`comment_id`),key `meta_key`(`meta_key`))engine=innodb default charset=utf8]> but was:<...le `wp_commentmeta`([,)]>
  testCreateTableUnlogged2(net.sf.jsqlparser.test.create.CreateTableTest): expected:<...LOGGED TABLE mytab ([mycol a (10, 20) c nm g, mycol2 mypar1 mypar2 (23,323,3) asdf ('23','123') dasd, PRIMARY KEY (mycol2, mycol)])> but was:<...LOGGED TABLE mytab ([, ])>
  testCreateTableColumnValue(net.sf.jsqlparser.test.create.CreateTableTest): expected:<...ATE TABLE mytable1 ([value INTEGER])> but was:<...ATE TABLE mytable1 ([])>
  testCreateTableInlinePrimaryKey(net.sf.jsqlparser.test.create.CreateTableTest): expected:<...EATE TABLE animals ([id INT PRIMARY KEY NOT NULL])> but was:<...EATE TABLE animals ([])>
  testCreateTableArrays2(net.sf.jsqlparser.test.create.CreateTableTest): expected:<...EATE TABLE sal_emp ([name text, pay_by_quarter integer[5], schedule text[3][2]])> but was:<...EATE TABLE sal_emp ([])>
  testCreateTableAsSelect(net.sf.jsqlparser.test.create.CreateTableTest): expected:<...E TABLE a AS SELECT [col1, col2] FROM b> but was:<...E TABLE a AS SELECT [] FROM b>
  testCreateTableAsSelect2(net.sf.jsqlparser.test.create.CreateTableTest): expected:<...S WITH a AS (SELECT [col1, col3 FROM testtable) SELECT col1, col2, col3] FROM b INNER JOIN a...> but was:<...S WITH a AS (SELECT [ FROM testtable) SELECT ] FROM b INNER JOIN a...>
  testCreateTableUnlogged(net.sf.jsqlparser.test.create.CreateTableTest): expected:<...LOGGED TABLE mytab ([mycol a (10, 20) c nm g, mycol2 mypar1 mypar2 (23,323,3) asdf ('23','123') dasd, PRIMARY KEY (mycol2, mycol)) type = myisam]> but was:<...LOGGED TABLE mytab ([, )]>
  testCreateTableIfNotExists(net.sf.jsqlparser.test.create.CreateTableTest): expected:<...NOT EXISTS animals ([id INT NOT NULL])> but was:<...NOT EXISTS animals ([])>
  testCreateView2(net.sf.jsqlparser.test.create.CreateViewTest): expected:<...EW myview AS SELECT [*] FROM mytab> but was:<...EW myview AS SELECT [] FROM mytab>
  testCreateView3(net.sf.jsqlparser.test.create.CreateViewTest): expected:<...EW myview AS SELECT [*] FROM mytab> but was:<...EW myview AS SELECT [] FROM mytab>
  testCreateView4(net.sf.jsqlparser.test.create.CreateViewTest): expected:<...IEW view2 AS SELECT [a, b, c] FROM testtab INNER ...> but was:<...IEW view2 AS SELECT [] FROM testtab INNER ...>
  testCreateView5(net.sf.jsqlparser.test.create.CreateViewTest): expected:<...W myview AS (SELECT [*] FROM mytab)> but was:<...W myview AS (SELECT [] FROM mytab)>
  testCreateView(net.sf.jsqlparser.test.create.CreateViewTest): expected:<...EW myview AS SELECT [*] FROM mytab> but was:<...EW myview AS SELECT [] FROM mytab>
  testCreateViewUnion(net.sf.jsqlparser.test.create.CreateViewTest): expected:<...EW view1 AS (SELECT [a, b FROM testtab) UNION (SELECT b, c] FROM testtab2)> but was:<...EW view1 AS (SELECT [ FROM testtab) UNION (SELECT ] FROM testtab2)>
  testCreateMaterializedView(net.sf.jsqlparser.test.create.CreateViewTest): expected:<...IEW view1 AS SELECT [a, b] FROM testtab> but was:<...IEW view1 AS SELECT [] FROM testtab>
  testCreateViewWithColumnNames1(net.sf.jsqlparser.test.create.CreateViewTest): expected:<... REPLACE VIEW view1([col1, col2) AS SELECT a, b] FROM testtab> but was:<... REPLACE VIEW view1([) AS SELECT ] FROM testtab>
  testDrop(net.sf.jsqlparser.test.drop.DropTest): expected:<DROP INDEX myindex [CASCADE]> but was:<DROP INDEX myindex []>
  testInsertMultiRowValue(net.sf.jsqlparser.test.insert.InsertTest): expected:<...NSERT INTO mytable ([col1, col2) VALUES (a, b), (d, e])> but was:<...NSERT INTO mytable ([) VALUES (), (])>
  testInsertWithReturning2(net.sf.jsqlparser.test.insert.InsertTest): expected:<...NSERT INTO mytable ([mycolumn) VALUES ('1']) RETURNING *> but was:<...NSERT INTO mytable ([) VALUES (]) RETURNING *>
  testInsertWithReturning3(net.sf.jsqlparser.test.insert.InsertTest): expected:<...NSERT INTO mytable ([mycolumn) VALUES ('1') RETURNING id AS a1, id2 AS a2]> but was:<...NSERT INTO mytable ([) VALUES () RETURNING ]>
  testHexValues2(net.sf.jsqlparser.test.insert.InsertTest): expected:<...INTO TABLE2 VALUES (['1', "DSDD", 0xEFBFBDC7AB])> but was:<...INTO TABLE2 VALUES ([])>
  testHexValues3(net.sf.jsqlparser.test.insert.InsertTest): expected:<...INTO TABLE2 VALUES (['1', "DSDD", 0xabcde])> but was:<...INTO TABLE2 VALUES ([])>
  testHexValues(net.sf.jsqlparser.test.insert.InsertTest): expected:<...INTO TABLE2 VALUES (['1', "DSDD", x'EFBFBDC7AB'])> but was:<...INTO TABLE2 VALUES ([])>
  testSimpleInsert(net.sf.jsqlparser.test.insert.InsertTest): expected:<...NSERT INTO example ([num, name, address, tel) VALUES (1, 'name', 'test ', '1234-1234'])> but was:<...NSERT INTO example ([) VALUES (])>
  testInsertWithKeywords(net.sf.jsqlparser.test.insert.InsertTest): expected:<INSERT INTO kvPair ([value, key) VALUES (?, ?])> but was:<INSERT INTO kvPair ([) VALUES (])>
  testInsertWithReturning(net.sf.jsqlparser.test.insert.InsertTest): expected:<...NSERT INTO mytable ([mycolumn) VALUES ('1') RETURNING id]> but was:<...NSERT INTO mytable ([) VALUES () RETURNING ]>
  testRegularInsert(net.sf.jsqlparser.test.insert.InsertTest): expected:<...NSERT INTO mytable ([col1, col2, col3) VALUES (?, 'sadfsd', 234])> but was:<...NSERT INTO mytable ([) VALUES (])>
  testInsertWithKeywordValue(net.sf.jsqlparser.test.insert.InsertTest): expected:<...NSERT INTO mytable ([col1) VALUES ('val1'])> but was:<...NSERT INTO mytable ([) VALUES (])>
  testInsertFromSelect(net.sf.jsqlparser.test.insert.InsertTest): expected:<...NSERT INTO mytable ([col1, col2, col3) SELECT *] FROM mytable2> but was:<...NSERT INTO mytable ([) SELECT ] FROM mytable2>
  testInsertWithSelect(net.sf.jsqlparser.test.insert.InsertTest): expected:<...NSERT INTO mytable ([mycolumn) WITH a AS (SELECT mycolumn FROM mytable) SELECT mycolumn] FROM a> but was:<...NSERT INTO mytable ([) WITH a AS (SELECT  FROM mytable) SELECT ] FROM a>
  testInsertSelect(net.sf.jsqlparser.test.insert.InsertTest): expected:<...NSERT INTO mytable ([mycolumn) SELECT mycolumn] FROM mytable> but was:<...NSERT INTO mytable ([) SELECT ] FROM mytable>
  testUpdateWithFrom(net.sf.jsqlparser.test.update.UpdateTest): expected:<UPDATE [table1] SET columna = 5 FRO...> but was:<UPDATE [] SET columna = 5 FRO...>
  testUpdateMultiTable(net.sf.jsqlparser.test.update.UpdateTest): expected:<UPDATE [T1, T2] SET T1.C2 = T2.C2, ...> but was:<UPDATE [] 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 [ SET (col1, col2, col3) = (SELECT ] FROM mytable2)>
  testUpdateWithSelect(net.sf.jsqlparser.test.update.UpdateTest): expected:<UPDATE [NATION SET (N_NATIONKEY) = (SELECT ?] FROM SYSIBM.SYSDUMM...> but was:<UPDATE [ SET (N_NATIONKEY) = (SELECT ] FROM SYSIBM.SYSDUMM...>
  testUpdateWithDeparser(net.sf.jsqlparser.test.update.UpdateTest): expected:<UPDATE [table1 AS A] SET A.columna = 'XX...> but was:<UPDATE [] SET A.columna = 'XX...>
  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 ([) SELECT ] FROM b_table>
  testReplaceSyntax2(net.sf.jsqlparser.test.replace.ReplaceTest): expected:<REPLACE mytable ([col1, col2, col3) VALUES ('as', ?, 565])> but was:<REPLACE mytable ([) VALUES (])>
  testAllSqlsParseDeparse(net.sf.jsqlparser.test.select.SpecialOracleTest): expected:<select [exception ]from exception> but was:<select []from exception>
  testSelectAliasWithoutAs(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [mycolumn "My Column Name"] FROM mytable> but was:<SELECT [] FROM 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 e...> but was:<SELECT [ FROM emp e1 WHERE e1.sal > ALL (SELECT ] FROM emp e2 WHERE e...>
  testSimpleSigns(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [+1, -1] FROM tableName> but was:<SELECT [] FROM 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 mytable WHERE () IN (SELECT ] FROM mytable2)>
  testSelectForUpdateOfTable(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [foo.*, bar.*] FROM foo, bar WHERE...> but was:<SELECT [] FROM foo, bar WHERE...>
  testPostgreSQLRegExpCaseSensitiveMatch(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [a, b] FROM foo WHERE a ~ ...> but was:<SELECT [] FROM foo WHERE a ~ ...>
  testOracleJoin2(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [*] FROM tabelle1, tabe...> but was:<SELECT [] FROM tabelle1, tabe...>
  testOracleJoin3(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [*] FROM tabelle1, tabe...> but was:<SELECT [] FROM tabelle1, tabe...>
  testOracleJoin4(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [* FROM tabelle1, tabelle2 WHERE tabelle1.a(+) = tabelle2.b AND tabelle1.b(+) IN ('A', 'B'])> but was:<SELECT [ FROM tabelle1, tabelle2 WHERE tabelle1.a(+) = tabelle2.b AND tabelle1.b(+) IN (])>
  testMultiPartTableNameWithSchemaName(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [columnName] FROM schemaName.tab...> but was:<SELECT [] FROM schemaName.tab...>
  testSelectBrackets2(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [(EXTRACT(epoch FROM age(d1, d2)) / 2)::numeric]> but was:<SELECT []>
  testSelectBrackets3(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [avg((EXTRACT(epoch FROM age(d1, d2)) / 2)::numeric)]> but was:<SELECT []>
  testSelectBrackets4(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [(1 / 2)::numeric]> but was:<SELECT []>
  testSimpleAdditionsAndSubtractionsWithSigns(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [1 - 1, 1 + 1, -1 - 1, -1 + 1, +1 + 1, +1 - 1] FROM tableName> but was:<SELECT [] FROM tableName>
  testSelectAliasInQuotes(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [mycolumn AS "My Column Name"] FROM mytable> but was:<SELECT [] FROM mytable>
  testOrderBy(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [* FROM tab1 WHERE a > 34 GROUP BY tab1.b ORDER BY tab1.a DESC, tab1.b ASC]> but was:<SELECT [ FROM tab1 WHERE a > 34]>
  testCastTypeProblem2(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [col1::varchar] FROM tabelle1> but was:<SELECT [] FROM tabelle1>
  testCastTypeProblem3(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [col1::varchar (256)] FROM tabelle1> but was:<SELECT [] FROM tabelle1>
  testCastTypeProblem4(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [5::varchar (256)] FROM tabelle1> but was:<SELECT [] FROM tabelle1>
  testCastTypeProblem5(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [5.67::varchar (256)] FROM tabelle1> but was:<SELECT [] FROM tabelle1>
  testCastTypeProblem6(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT ['test'::character varying] FROM tabelle1> but was:<SELECT [] FROM tabelle1>
  testCastTypeProblem7(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [CAST('test' AS character varying)] FROM tabelle1> but was:<SELECT [] FROM tabelle1>
  testCastInCast(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [CAST(CAST(a AS numeric) AS varchar)] FROM tabelle1> but was:<SELECT [] FROM tabelle1>
  testSkipFirst(net.sf.jsqlparser.test.select.SelectTest): expected:<...CT SKIP ?1 FIRST f1 [c1, c2] FROM t1> but was:<...CT SKIP ?1 FIRST f1 [] FROM t1>
  testMultiPartTableNameWithDatabaseNameAndSchemaName(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [columnName] FROM databaseName.s...> but was:<SELECT [] FROM databaseName.s...>
  testSelectJoinWithComma(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [cb.Genus, cb.Species] FROM Coleccion_de_B...> but was:<SELECT [] FROM Coleccion_de_B...>
  testAdditionalLettersGerman(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [colä, colö, colü] FROM testtableäöü> but was:<SELECT [] FROM testtableäöü>
  testTop(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT TOP 3 [*] FROM mytable WHERE ...> but was:<SELECT TOP 3 [] FROM mytable WHERE ...>
  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 [ FROM tablea) UNION (SELECT  FROM tableb)) SELECT  FROM tablea WHERE mslink IN (SELECT ] FROM test)>
  testMysqlQuote(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [`a.OWNERLASTNAME`, `OWNERFIRSTNAME`] FROM `ANTIQUEOWNERS...> but was:<SELECT [] FROM `ANTIQUEOWNERS...>
  testSelectInnerWith(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [* FROM (WITH actor AS (SELECT 'a' aid FROM DUAL) SELECT aid] FROM actor)> but was:<SELECT [ FROM (WITH actor AS (SELECT  FROM DUAL) SELECT ] FROM actor)>
  testReservedKeyword2(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [open] FROM tableName> but was:<SELECT [] FROM tableName>
  testFirst(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT FIRST 5 [alias.columnName1, alias.columnName2 FROM schemaName.tableName alias ORDER BY alias.columnName2 DESC]> but was:<SELECT FIRST 5 [ FROM schemaName.tableName alias]>
  testIlike(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [col1] FROM table1 WHERE c...> but was:<SELECT [] FROM table1 WHERE c...>
  testIsNot(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [*] FROM test WHERE a I...> but was:<SELECT [] FROM test WHERE a I...>
  testLimit(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [*] FROM mytable WHERE ...> but was:<SELECT [] FROM mytable WHERE ...>
  testSigns(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [(-(1)), -(1), (-(columnName)), -(columnName), (-1), -1, (-columnName), -columnName] FROM tableName> but was:<SELECT [] FROM 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...> but was:<(SELECT [ FROM mytable WHERE mytable.col = 9) UNION (SELECT  FROM mytable3 WHERE mytable3.col = ?) UNION (SELECT ] FROM mytable2 LIMIT...>
  testWhere(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [*] FROM tab1 WHERE (a ...> but was:<SELECT [] FROM tab1 WHERE (a ...>
  testRegexpLike1(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [* FROM mytable WHERE REGEXP_LIKE(first_name, '^Ste(v|ph)en$'])> but was:<SELECT [ FROM mytable WHERE REGEXP_LIKE(])>
  testRegexpLike2(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [CASE WHEN REGEXP_LIKE(first_name, '^Ste(v|ph)en$') THEN 1 ELSE 2 END] FROM mytable> but was:<SELECT [] FROM mytable>
  testRegexpMySQL(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [*] FROM mytable WHERE ...> but was:<SELECT [] FROM mytable WHERE ...>
  testCase(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [a, CASE b WHEN 1 THEN 2 END] FROM tab1> but was:<SELECT [] FROM tab1>
  testCast(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [CAST(a AS varchar)] FROM tabelle1> but was:<SELECT [] FROM 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 m...> but was:<SELECT [ FROM mytable AS mytable0, mytable1 alias_tab1, mytable2 AS alias_tab2, (SELECT ] FROM mytable3) AS m...>
  testJoin(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [*] FROM tab1 LEFT OUTE...> but was:<SELECT [] FROM tab1 LEFT OUTE...>
  testLike(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [*] FROM tab1 WHERE a L...> but was:<SELECT [] FROM tab1 WHERE a L...>
  testSkip(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT SKIP 5 [alias.columnName1, alias.columnName2 FROM schemaName.tableName alias ORDER BY alias.columnName2 DESC]> but was:<SELECT SKIP 5 [ FROM schemaName.tableName alias]>
  testTime(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [*] FROM tab1 WHERE a >...> but was:<SELECT [] FROM tab1 WHERE a >...>
  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 TH...> but was:<WITH DINFO ([) AS (SELECT  FROM EMPLOYEE AS OTHERS), DINFOMAX AS (SELECT  FROM DINFO) SELECT ] FROM EMPLOYEE AS TH...>
  testJsonExpression(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [data->'images'->'thumbnail'->'url' AS thumb] FROM instagram> but was:<SELECT [] FROM instagram>
  testConcatProblem2_5_1(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [(a || b) || c] FROM testtable> but was:<SELECT [] FROM testtable>
  testConcatProblem2_5_2(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [(a + b) + c] FROM testtable> but was:<SELECT [] FROM 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 [ FROM STAFF WHERE ID < 60]>
  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 [ FROM tablea) UNION ALL (SELECT  FROM tableb)) SELECT  FROM tablea WHERE mslink IN (SELECT ] FROM test)>
  testOracleJoin2_1(net.sf.jsqlparser.test.select.SelectTest): expected:<select[*]from tabelle1,tabell...> but was:<select[ ]from tabelle1,tabell...>
  testOracleJoin2_2(net.sf.jsqlparser.test.select.SelectTest): expected:<select[*]from tabelle1,tabell...> but was:<select[ ]from tabelle1,tabell...>
  testOracleJoin3_1(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [*] FROM tabelle1, tabe...> but was:<SELECT [] FROM tabelle1, tabe...>
  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 e...> but was:<SELECT [ FROM emp e1 WHERE e1.sal > ANY (SELECT ] FROM emp e2 WHERE e...>
  testPivotXml1(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [* FROM mytable PIVOT XML (count(a) FOR b IN ('val1']))> but was:<SELECT [ FROM mytable PIVOT XML ( FOR  IN (]))>
  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 mytable PIVOT XML ( FOR  IN (SELECT ] FROM myothertable))>
  testPivotXml3(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [* FROM mytable PIVOT XML (count(a) FOR b] IN (ANY))> but was:<SELECT [ FROM mytable PIVOT XML ( FOR ] IN (ANY))>
  testIssue162_doubleUserVar(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [@@SPID AS ID, SYSTEM_USER AS "Login Name", USER AS "User Name"]> but was:<SELECT []>
  testSelectWithBrackets2(net.sf.jsqlparser.test.select.SelectTest): expected:<(SELECT [1])> but was:<(SELECT [])>
  testOrderByNullsFirst(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [a FROM tab1 ORDER BY a NULLS FIRST]> but was:<SELECT [ FROM tab1]>
  testMultiTableJoin(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [*] FROM taba INNER JOI...> but was:<SELECT [] FROM taba INNER JOI...>
  testProblemSqlServer_Modulo_mod(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [mod(5, 2)] FROM A> but was:<SELECT [] FROM A>
  testProblemSqlAnalytic(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [a, row_number() OVER (ORDER BY a) AS n] FROM table1> but was:<SELECT [] FROM table1>
  testIssue160_signedParameter2(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [*] FROM mytable WHERE ...> but was:<SELECT [] FROM mytable WHERE ...>
  testAdditionalLettersSpanish(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [*] FROM años> but was:<SELECT [] FROM 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 ...> but was:<SELECT [ FROM ORDERS AS O, LATERAL(SELECT ] FROM ORDERLINES AS ...>
  testSelectNumericBind(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [a] FROM b WHERE c = :1> but was:<SELECT [] FROM b WHERE c = :1>
  testRegexpBinaryMySQL(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [*] FROM mytable WHERE ...> but was:<SELECT [] FROM mytable WHERE ...>
  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 TAX...> but was:<SELECT [ FROM ORDERS O, LATERAL(SELECT  FROM ORDERLINES LINES WHERE LINES.ORDERID = O.ORDERID) AS OL, LATERAL(SELECT  FROM ORDERCHARGES CHARGES WHERE LINES.ORDERID = O.ORDERID) AS OC, LATERAL(SELECT ] FROM ORDERTAXES TAX...>
  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 mytable WHERE () IN (SELECT ] FROM mytable2)>
  testProblemSqlIntersect(net.sf.jsqlparser.test.select.SelectTest): expected:<(SELECT [* FROM a) INTERSECT (SELECT *] FROM b)> but was:<(SELECT [ FROM a) INTERSECT (SELECT ] FROM b)>
  testProblemFunction(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [test()] FROM testtable> but was:<SELECT [] FROM 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 [] FROM testtable>
  testBitwise(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [col1 & 32, col2 ^ col1, col1 | col2] FROM table1> but was:<SELECT [] FROM table1>
  testSelectInto1(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [*] INTO user_copy FROM...> but was:<SELECT [] INTO user_copy FROM...>
  testSelectItems(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [myid AS MYID, mycol, tab.*, schema.tab.*, mytab.mycol2, myschema.mytab.mycol, myschema.mytab.*] FROM mytable WHERE ...> but was:<SELECT [] FROM mytable WHERE ...>
  testSelectJoin2(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [* FROM pg_constraint WHERE pg_attribute.attnum = ANY(pg_constraint.conkey])> but was:<SELECT [ FROM pg_constraint WHERE pg_attribute.attnum = ANY(])>
  testBrackets2(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [[a]] FROM t> but was:<SELECT [] FROM t>
  testProblemSqlServer_Modulo_Proz(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [5 % 2] FROM A> but was:<SELECT [] FROM A>
  testFirstWithKeywordLimit(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT LIMIT ? [alias.columnName1, alias.columnName2 FROM schemaName.tableName alias ORDER BY alias.columnName2 DESC]> but was:<SELECT LIMIT ? [ FROM schemaName.tableName alias]>
  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 [ FROM student]>
  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 ([) AS ((SELECT ) UNION ALL (SELECT  FROM t WHERE n < 100)) SELECT ] FROM 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 [ FROM employees]>
  testFunctionRight(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [right(table1.col1, 4)] FROM table1> but was:<SELECT [] FROM table1>
  testSelectBrackets(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [avg((123.250)::numeric)]> but was:<SELECT []>
  testMultiPartColumnName(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [columnName] FROM tableName> but was:<SELECT [] FROM 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 [ 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  FROM tableb)) SELECT  FROM tablea WHERE mslink IN (SELECT ] FROM test)>
  testWithUnionProblem4(net.sf.jsqlparser.test.select.SelectTest): expected:<...TH hist AS ((SELECT [gl.mslink, ba.gl_name AS txt, ba.gl_nummer AS nr, 0 AS level, CAST(gl.mslink AS VARCHAR) AS path, ae.feature FROM tablea AS gl INNER JOIN tableb AS ba ON gl.mslink = ba.gl_mslink INNER JOIN tablec AS ae ON gl.mslink = ae.mslink AND ae.deleted = 0 WHERE gl.parent IS NULL AND gl.mslink <> 0) UNION ALL (SELECT gl.mslink, ba.gl_name AS txt, ba.gl_nummer AS nr, hist.level + 1 AS level, CAST(hist.path + '.' + CAST(gl.mslink AS VARCHAR) AS VARCHAR) AS path, ae.feature FROM tablea AS gl INNER JOIN tableb AS ba ON gl.mslink = ba.gl_mslink INNER JOIN tablec AS ae ON gl.mslink = ae.mslink AND ae.deleted = 0 INNER JOIN hist ON gl.parent = hist.mslink WHERE gl.mslink <> 0)) SELECT mslink, space(level * 4) + txt AS txt, nr, feature, path FROM hist WHERE EXISTS (SELECT feature FROM tablec WHERE mslink = 0 AND ((feature IN (1, 2) AND hist.feature = 3) OR (feature IN (4]) AND hist.feature =...> but was:<...TH hist AS ((SELECT [ 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  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 WHERE EXISTS (SELECT  FROM tablec WHERE mslink = 0 AND ((feature IN () AND hist.feature = 3) OR (feature IN (]) AND hist.feature =...>
  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 [ 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  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>
  testValues2(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [* FROM (VALUES 1, 2, 3, 4]) AS test> but was:<SELECT [ FROM (VALUES , , , ]) AS test>
  testValues3(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [* FROM (VALUES 1, 2, 3, 4]) AS test(a)> but was:<SELECT [ FROM (VALUES , , , ]) AS test(a)>
  testValues4(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [* FROM (VALUES (1, 2), (3, 4])) AS test(a, b)> but was:<SELECT [ FROM (VALUES (), (])) AS test(a, b)>
  testValues5(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [X, Y FROM (VALUES (0, 'a'), (1, 'b'])) AS MY_TEMP_TABLE(...> but was:<SELECT [ FROM (VALUES (), (])) AS MY_TEMP_TABLE(...>
  testGroupBy(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [* FROM tab1 WHERE a > 34 GROUP BY tab1.b]> but was:<SELECT [ FROM tab1 WHERE a > 34]>
  testMultiPartColumnNameWithTableName(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [tableName.columnName] FROM tableName> but was:<SELECT [] FROM tableName>
  testMultiPartTableNameWithDatabaseName(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [columnName] FROM databaseName.....> but was:<SELECT [] FROM databaseName.....>
  testLimitSqlServer1(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [* FROM mytable WHERE mytable.col = 9 ORDER BY mytable.id] OFFSET 3 ROWS FETCH...> but was:<SELECT [ FROM mytable WHERE mytable.col = 9] OFFSET 3 ROWS FETCH...>
  testLimitSqlServer2(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [* FROM mytable WHERE mytable.col = 9 ORDER BY mytable.id] OFFSET 3 ROW FETCH ...> but was:<SELECT [ FROM mytable WHERE mytable.col = 9] OFFSET 3 ROW FETCH ...>
  testLimitSqlServer3(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [* FROM mytable WHERE mytable.col = 9 ORDER BY mytable.id] OFFSET 3 ROWS> but was:<SELECT [ FROM mytable WHERE mytable.col = 9] OFFSET 3 ROWS>
  testLimitSqlServer4(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [* FROM mytable WHERE mytable.col = 9 ORDER BY mytable.id] FETCH NEXT 5 ROWS O...> but was:<SELECT [ FROM mytable WHERE mytable.col = 9] FETCH NEXT 5 ROWS O...>
  testPivotFunction(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [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:<SELECT [] FROM DUAL>
  testMultiPartTableNameWithServerNameAndDatabaseName(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [columnName] FROM [server-name\s...> but was:<SELECT [] FROM [server-name\s...>
  testConcatProblem2_1(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [TO_CHAR(SPA.AANLEVERPERIODEVOLGNR, 'FM09'::VARCHAR)] FROM testtable> but was:<SELECT [] FROM 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 [] FROM testtable>
  testConcatProblem2_3(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [TO_CHAR((10000 - SPA.VERSCHIJNINGSVOLGNR), 'FM0999'::VARCHAR)] FROM testtable> but was:<SELECT [] FROM testtable>
  testConcatProblem2_4(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [(SPA.GESLACHT)::VARCHAR (1)] FROM testtable> but was:<SELECT [] FROM testtable>
  testConcatProblem2_5(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [max((a || b) || c)] FROM testtable> but was:<SELECT [] FROM testtable>
  testConcatProblem2_6(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [max(a || b || c)] FROM testtable> but was:<SELECT [] FROM testtable>
  testMultiPartColumnNameWithDatabaseNameAndSchemaNameAndTableName(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [databaseName.schemaName.tableName.columnName] FROM tableName> but was:<SELECT [] FROM tableName>
  testMultiPartColumnNameWithDatabaseNameAndTableName(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [databaseName..tableName.columnName] FROM tableName> but was:<SELECT [] FROM tableName>
  testReplaceAsFunction(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [REPLACE(a, 'b', c)] FROM tab1> but was:<SELECT [] FROM tab1>
  testSelectJPQLPositionalParameter(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [email] FROM users WHERE (t...> but was:<SELECT [] FROM users WHERE (t...>
  testSelectWithinGroup(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [LISTAGG(col1, '##') WITHIN GROUP (ORDER BY col1)] FROM table1> but was:<SELECT [] FROM table1>
  testNotEqualsTo(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [*] FROM foo WHERE a !=...> but was:<SELECT [] FROM foo WHERE a !=...>
  testSelectForUpdate(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [*] FROM user_table FOR...> but was:<SELECT [] FROM user_table FOR...>
  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 [] FROM 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 [] FROM table1>
  testMatches(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [* FROM team WHERE team.search_column @@ to_tsquery('new & york & yankees'])> but was:<SELECT [ FROM team WHERE team.search_column @@ to_tsquery(])>
  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 [] FROM s>
  testFunctions(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [MAX(id) AS max] FROM mytable WHERE ...> but was:<SELECT [] FROM mytable WHERE ...>
  testProblemFunction2(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [sysdate] FROM testtable> but was:<SELECT [] FROM testtable>
  testProblemFunction3(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [TRUNCATE(col)] FROM testtable> but was:<SELECT [] FROM 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 [ FROM currency HAVING count() > 1]>
  testAnalyticFunction12(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [SUM(a) OVER (PARTITION BY b ORDER BY c)] FROM tab1> but was:<SELECT [] FROM tab1>
  testAnalyticFunction13(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [SUM(a) OVER ()] FROM tab1> but was:<SELECT [] FROM tab1>
  testAnalyticFunction14(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [SUM(a) OVER (PARTITION BY b )] FROM tab1> but was:<SELECT [] FROM tab1>
  testAnalyticFunction15(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [SUM(a) OVER (ORDER BY c)] FROM tab1> but was:<SELECT [] FROM tab1>
  testAnalyticFunction16(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [SUM(a) OVER (ORDER BY c NULLS FIRST)] FROM tab1> but was:<SELECT [] FROM 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 [] FROM 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 [] FROM emp>
  testMultiPartTableNameWithServerNameAndDatabaseNameAndSchemaName(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [columnName] FROM [server-name\s...> but was:<SELECT [] FROM [server-name\s...>
  testBrackets(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [table_a.name AS [Test]] FROM table_a> but was:<SELECT [] FROM 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 [ FROM feature) SELECT  FROM feature WHERE mslink IN (SELECT ] FROM 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 [ FROM role r WHERE r.merchant_id = ? AND r.deleted_time IS NULL]>
  testTimestamp(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [*] FROM tab1 WHERE a >...> but was:<SELECT [] FROM tab1 WHERE a >...>
  testProblemSqlAnalytic5AggregateColumnValue(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [a, sum(b) OVER () AS n] FROM table1> but was:<SELECT [] FROM table1>
  testMultiPartTableNameWithColumnName(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [columnName] FROM tableName> but was:<SELECT [] FROM tableName>
  testFunctionLeft(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [left(table1.col1, 4)] FROM table1> but was:<SELECT [] FROM table1>
  testCharacterSetClause(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT DISTINCT [CAST(`view0`.`nick2` AS CHAR (8000) CHARACTER SET utf8) AS `v0`] FROM people `view0`...> but was:<SELECT DISTINCT [] FROM people `view0`...>
  testComplexUnion1(net.sf.jsqlparser.test.select.SelectTest): expected:<(SELECT ['abc-' || coalesce(mytab.a::varchar, '') AS a, mytab.b, mytab.c AS st, mytab.d, mytab.e FROM mytab WHERE mytab.del = 0) UNION (SELECT 'cde-' || coalesce(mytab2.a::varchar, '') AS a, mytab2.b, mytab2.bezeichnung AS c, 0 AS d, 0 AS e] FROM mytab2 WHERE m...> but was:<(SELECT [ FROM mytab WHERE mytab.del = 0) UNION (SELECT ] FROM mytab2 WHERE m...>
  testProblemSqlAnalytic6AggregateColumnValue(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [a, sum(b + 5) OVER (ORDER BY a) AS n] FROM table1> but was:<SELECT [] FROM table1>
  testDistinct(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT DISTINCT ON ([myid) myid, mycol] FROM mytable WHERE ...> but was:<SELECT DISTINCT ON ([) ] FROM mytable WHERE ...>
  testMultiPartColumnNameWithSchemaNameAndTableName(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [schemaName.tableName.columnName] FROM tableName> but was:<SELECT [] FROM tableName>
  testMultiPartTableNameWithServerName(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [columnName] FROM [server-name\s...> but was:<SELECT [] FROM [server-name\s...>
  testProblemSqlAnalytic7Count(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [count(*) OVER () AS n] FROM table1> but was:<SELECT [] FROM table1>
  testSelectFunction(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [1 + 2 AS sum]> but was:<SELECT []>
  testIssue160_signedParameter(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [start_date WHERE start_date > DATEADD(HH, -?, GETDATE()])> but was:<SELECT [ WHERE start_date > DATEADD(])>
  testAllColumnsFromTable(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [tableName.*] FROM tableName> but was:<SELECT [] FROM tableName>
  testProblemSqlCombinedSets(net.sf.jsqlparser.test.select.SelectTest): expected:<(SELECT [* FROM a) INTERSECT (SELECT * FROM b) UNION (SELECT *] FROM c)> but was:<(SELECT [ FROM a) INTERSECT (SELECT  FROM b) UNION (SELECT ] FROM c)>
  testInterval1(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [5 + INTERVAL '3 days']> but was:<SELECT []>
  testInterval2(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [to_timestamp(to_char(now() - INTERVAL '45 MINUTE', 'YYYY-MM-DD-HH24:')) AS START_TIME] FROM tab1> but was:<SELECT [] FROM tab1>
  testInterval3(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [5 + INTERVAL '3' day]> but was:<SELECT []>
  testInterval4(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT ['2008-12-31 23:59:59' + INTERVAL 1 SECOND]> but was:<SELECT []>
  testConcat(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [a || b || c + 4] FROM t> but was:<SELECT [] FROM t>
  testCount2(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [count(ALL col1 + col2)] FROM mytable> but was:<SELECT [] FROM mytable>
  testSignedColumns(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [-columnName, +columnName, +(columnName), -(columnName)] FROM tableName> but was:<SELECT [] FROM tableName>
  testDouble(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [1e2, *] FROM mytable WHERE ...> but was:<SELECT [] FROM mytable WHERE ...>
  testProblemSqlMinus(net.sf.jsqlparser.test.select.SelectTest): expected:<(SELECT [* FROM a) MINUS (SELECT *] FROM b)> but was:<(SELECT [ FROM a) MINUS (SELECT ] FROM b)>
  testExists(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [* FROM tab1 WHERE EXISTS (SELECT *] FROM tab2)> but was:<SELECT [ FROM tab1 WHERE EXISTS (SELECT ] FROM tab2)>
  testMultiPartTableNameWithServerProblem(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [*] FROM LINK_100.htsac...> but was:<SELECT [] FROM LINK_100.htsac...>
  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 [ FROM table1]>
  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 [ FROM tab1 WHERE a > 34 HAVING MAX(]) > 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 [ 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 >= ?]>
  testDistinctTop(net.sf.jsqlparser.test.select.SelectTest): expected:<...LECT DISTINCT TOP 5 [myid, mycol] FROM mytable WHERE ...> but was:<...LECT DISTINCT TOP 5 [] FROM mytable WHERE ...>
  testSelectUserVariable(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [@col] FROM t1> but was:<SELECT [] FROM t1>
  testIsNot2(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [*] FROM test WHERE a I...> but was:<SELECT [] FROM test WHERE a I...>
  testTopWithParenthesis(net.sf.jsqlparser.test.select.SelectTest): expected:<...ECT TOP (5) PERCENT [alias.columnName1, alias.columnName2 FROM schemaName.tableName alias ORDER BY alias.columnName2 DESC]> but was:<...ECT TOP (5) PERCENT [ FROM schemaName.tableName alias]>
  testSelectOracleColl(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [* FROM the_table tt WHERE TT.COL1 = lines(idx]).COL1> but was:<SELECT [ FROM the_table tt WHERE TT.COL1 = lines(]).COL1>
  testOracleJoin(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [*] FROM tabelle1, tabe...> but was:<SELECT [] FROM tabelle1, tabe...>
  testPostgreSQLRegExpCaseSensitiveMatch2(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [a, b] FROM foo WHERE a ~*...> but was:<SELECT [] FROM foo WHERE a ~*...>
  testPostgreSQLRegExpCaseSensitiveMatch3(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [a, b] FROM foo WHERE a !~...> but was:<SELECT [] FROM foo WHERE a !~...>
  testPostgreSQLRegExpCaseSensitiveMatch4(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [a, b] FROM foo WHERE a !~...> but was:<SELECT [] FROM foo WHERE a !~...>
  testRowConstructor1(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [* FROM t1 WHERE (col1, col2) = (SELECT col3, col4] FROM t2 WHERE id = ...> but was:<SELECT [ FROM t1 WHERE () = (SELECT ] FROM t2 WHERE id = ...>
  testRowConstructor2(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [* FROM t1 WHERE ROW(col1, col2) = (SELECT col3, col4] FROM t2 WHERE id = ...> but was:<SELECT [ FROM t1 WHERE ROW() = (SELECT ] FROM t2 WHERE id = ...>
  testLimit2(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [*] FROM mytable WHERE ...> but was:<SELECT [] FROM mytable WHERE ...>
  testTableCrossJoin(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [*] FROM taba CROSS JOI...> but was:<SELECT [] FROM taba CROSS JOI...>
  testProblemSqlAnalytic2(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [a, row_number() OVER (ORDER BY a, b) AS n] FROM table1> but was:<SELECT [] FROM 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 [] FROM 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 [] FROM table1>
  testSelectWithoutFrom(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [footable.foocolumn]> but was:<SELECT []>
  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 [ FROM employees CONNECT BY employee_id = manager_id]>
  testPivot1(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [* FROM mytable PIVOT (count(a) FOR b IN ('val1']))> but was:<SELECT [ FROM mytable PIVOT ( FOR  IN (]))>
  testPivot2(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [* FROM mytable PIVOT (count(a) FOR b IN (10, 20, 30]))> but was:<SELECT [ FROM mytable PIVOT ( FOR  IN (]))>
  testPivot3(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [* FROM mytable PIVOT (count(a) AS vals FOR b IN (10 AS d1, 20, 30 AS d3]))> but was:<SELECT [ FROM mytable PIVOT ( FOR  IN (]))>
  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 mytable PIVOT ( FOR  IN (]))>
  testPivot5(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [* FROM mytable PIVOT (count(a) FOR (b, c) IN ((10, 'a'), (20, 'b'), (30, 'c')]))> but was:<SELECT [ FROM mytable PIVOT ( FOR () IN (]))>
  testSelectWithBrackets(net.sf.jsqlparser.test.select.SelectTest): expected:<(SELECT [1] FROM mytable)> but was:<(SELECT [] FROM 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 [] FROM s>
  testDeparser(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [a.OWNERLASTNAME, a.OWNERFIRSTNAME] FROM ANTIQUEOWNERS ...> but was:<SELECT [] FROM ANTIQUEOWNERS ...>
  testPivotXmlSubquery1(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [* FROM (SELECT times_purchased, state_code FROM customers t) PIVOT (count(state_code) FOR state_code IN ('NY', 'CT', 'NJ', 'FL', 'MO')) ORDER BY times_purchased]> but was:<SELECT [ FROM (SELECT  FROM customers t) PIVOT ( FOR  IN ())]>
  testOracleHierarchicalQuery2(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [employee_id, last_name, manager_id] FROM employees CONN...> but was:<SELECT [] FROM employees CONN...>
  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 [ FROM employees START WITH employee_id = 100 CONNECT BY PRIOR employee_id = manager_id]>
  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 [ FROM employees CONNECT BY PRIOR employee_id = manager_id START WITH employee_id = 100]>
  testExtractFrom1(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [EXTRACT(month FROM datecolumn)] FROM testtable> but was:<SELECT [] FROM testtable>
  testExtractFrom2(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [EXTRACT(year FROM now())] FROM testtable> but was:<SELECT [] FROM testtable>
  testExtractFrom3(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [EXTRACT(year FROM (now() - 2))] FROM testtable> but was:<SELECT [] FROM testtable>
  testExtractFrom4(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [EXTRACT(minutes FROM now() - '01:22:00')] FROM testtable> but was:<SELECT [] FROM testtable>
  testProblemSqlAnalytic4EmptyOver(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [a, row_number() OVER () AS n] FROM table1> but was:<SELECT [] FROM table1>
  testCastTypeProblem(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [CAST(col1 AS varchar (256))] FROM tabelle1> but was:<SELECT [] FROM tabelle1>
  testSelectKeywordPercent(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [percent] FROM MY_TABLE> but was:<SELECT [] FROM MY_TABLE>
  testValues(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [* FROM (VALUES (1, 2), (3, 4])) AS test> but was:<SELECT [ FROM (VALUES (), (])) AS test>
  testValues6BothVariants(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [I FROM (VALUES 1, 2, 3) AS MY_TEMP_TABLE(I) WHERE I IN (SELECT * FROM (VALUES 1, 2]) AS TEST)> but was:<SELECT [ FROM (VALUES , , ) AS MY_TEMP_TABLE(I) WHERE I IN (SELECT  FROM (VALUES , ]) AS TEST)>
  testProblemSqlExcept(net.sf.jsqlparser.test.select.SelectTest): expected:<(SELECT [* FROM a) EXCEPT (SELECT *] FROM b)> but was:<(SELECT [ FROM a) EXCEPT (SELECT ] FROM b)>
  testMultiPartTableNameWithServerNameAndSchemaName(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [columnName] FROM [server-name\s...> but was:<SELECT [] FROM [server-name\s...>
  testProblemSqlServer_Modulo(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [convert(varchar(255), DATEDIFF(month, year1, abc_datum) / 12) + ' year, ' + convert(varchar(255), DATEDIFF(month, year2, abc_datum) % 12) + ' month'] FROM test_table> but was:<SELECT [] FROM 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 [] FROM tableName>
  testLimitSqlServerJdbcParameters(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [* FROM mytable WHERE mytable.col = 9 ORDER BY mytable.id] OFFSET ? ROWS FETCH...> but was:<SELECT [ FROM mytable WHERE mytable.col = 9] OFFSET ? ROWS FETCH...>
  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.conname]> but was:<SELECT [ 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())]>
  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 [ FROM table1]>
  testCaseElseAddition(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [CASE WHEN 1 + 3 > 20 THEN 0 ELSE 1000 + 1 END AS d] FROM dual> but was:<SELECT [] FROM dual>
  testNamedParameter2(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [*] FROM mytable WHERE ...> but was:<SELECT [] FROM mytable WHERE ...>
  testBooleanFunction1(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [* FROM mytable WHERE test_func(col1])> but was:<SELECT [ FROM mytable WHERE test_func(])>
  testCastInCast2(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [CAST('test' + CAST(assertEqual AS numeric) AS varchar)] FROM tabelle1> but was:<SELECT [] FROM tabelle1>
  testNamedParameter(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [*] FROM mytable WHERE ...> but was:<SELECT [] FROM mytable WHERE ...>
  testVisit_PlainSelect_concat(net.sf.jsqlparser.util.ConnectExpressionsVisitorTest): expected:<SELECT [a || b || c AS expr] FROM test> but was:<SELECT [] FROM test>
  testVisit_PlainSelect_addition(net.sf.jsqlparser.util.ConnectExpressionsVisitorTest): expected:<SELECT [a + b + c AS testexpr] FROM test> but was:<SELECT [] FROM test>
  testVisit_SetOperationList(net.sf.jsqlparser.util.AddAliasesVisitorTest): expected:<(SELECT [3 + 4 AS A1 FROM test) UNION (SELECT 7 + 8 AS A1] FROM test2)> but was:<(SELECT [ FROM test) UNION (SELECT ] FROM test2)>
  testVisit_PlainSelect(net.sf.jsqlparser.util.AddAliasesVisitorTest): expected:<SELECT [a AS A1, b AS A2, c AS A3] FROM test> but was:<SELECT [] FROM test>
  testVisit_PlainSelect_expression(net.sf.jsqlparser.util.AddAliasesVisitorTest): expected:<SELECT [3 + 4 AS A1] FROM test> but was:<SELECT [] FROM 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 [] FROM test>
  testBuildSelectFromTableAndExpressions(net.sf.jsqlparser.util.SelectUtilsTest): expected:<SELECT [a, b] FROM mytable> but was:<SELECT [] FROM mytable>
  testAddExpr(net.sf.jsqlparser.util.SelectUtilsTest): expected:<SELECT [a, b] FROM mytable> but was:<SELECT [] FROM mytable>
  testAddJoin(net.sf.jsqlparser.util.SelectUtilsTest): expected:<SELECT [a] FROM mytable LEFT J...> but was:<SELECT [] FROM mytable LEFT J...>
  testBuildSelectFromTable(net.sf.jsqlparser.util.SelectUtilsTest): expected:<SELECT [*] FROM mytable> but was:<SELECT [] FROM mytable>
  testBuildSelectFromTableWithGroupBy(net.sf.jsqlparser.util.SelectUtilsTest): expected:<SELECT [* FROM mytable GROUP BY b]> but was:<SELECT [ FROM mytable]>
  testBuildSelectFromTableAndParsedExpression(net.sf.jsqlparser.util.SelectUtilsTest): expected:<SELECT [a + b, test] FROM mytable> but was:<SELECT [] FROM mytable>
  testStatements(net.sf.jsqlparser.statement.StatementsTest): expected:<SELECT [* FROM mytable;
  testAccept(net.sf.jsqlparser.statement.execute.ExecuteTest): expected:<EXECUTE myproc ['a', 2, 'b']> but was:<EXECUTE myproc []>

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

[INFO] ------------------------------------------------------------------------
[INFO] BUILD FAILURE
[INFO] ------------------------------------------------------------------------
[INFO] Total time: 15.564s
[INFO] Finished at: Tue Oct 06 07:47:20 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
