[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 222.746ms.
[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.067 sec <<< FAILURE!
Running net.sf.jsqlparser.test.create.CreateTableTest
Tests run: 27, Failures: 26, Errors: 0, Skipped: 0, Time elapsed: 0.082 sec <<< FAILURE!
Running net.sf.jsqlparser.test.create.CreateIndexTest
Tests run: 6, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.001 sec
Running net.sf.jsqlparser.test.create.CreateViewTest
Tests run: 8, Failures: 8, Errors: 0, Skipped: 0, Time elapsed: 0.008 sec <<< FAILURE!
Running net.sf.jsqlparser.test.delete.DeleteTest
Tests run: 2, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.005 sec
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: 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.043 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: 2, Errors: 0, Skipped: 0, Time elapsed: 0.004 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.002 sec
Running net.sf.jsqlparser.test.select.SpecialOracleTest
Oct 06, 2015 7:46:54 AM net.sf.jsqlparser.test.select.SpecialOracleTest testAllSqlsParseDeparse
INFO: testing string01.sql
Oct 06, 2015 7:46:54 AM net.sf.jsqlparser.test.select.SpecialOracleTest testAllSqlsParseDeparse
INFO:    -> PROBLEM net.sf.jsqlparser.JSQLParserException
Oct 06, 2015 7:46:54 AM net.sf.jsqlparser.test.select.SpecialOracleTest testAllSqlsParseDeparse
INFO: testing returning01.sql
Oct 06, 2015 7:46:54 AM net.sf.jsqlparser.test.select.SpecialOracleTest testAllSqlsParseDeparse
INFO:    -> PROBLEM net.sf.jsqlparser.JSQLParserException
Oct 06, 2015 7:46:54 AM net.sf.jsqlparser.test.select.SpecialOracleTest testAllSqlsParseDeparse
INFO: testing keywordasidentifier05.sql
Oct 06, 2015 7:46:54 AM net.sf.jsqlparser.test.select.SpecialOracleTest testAllSqlsOnlyParse
INFO: testing comment02.sql
Oct 06, 2015 7:46:54 AM net.sf.jsqlparser.test.select.SpecialOracleTest testAllSqlsOnlyParse
INFO:    -> SUCCESS
Oct 06, 2015 7:46:54 AM net.sf.jsqlparser.test.select.SpecialOracleTest testAllSqlsOnlyParse
INFO: testing numbers02.sql
Oct 06, 2015 7:46:54 AM net.sf.jsqlparser.test.select.SpecialOracleTest testAllSqlsOnlyParse
INFO:    -> SUCCESS
Oct 06, 2015 7:46:54 AM net.sf.jsqlparser.test.select.SpecialOracleTest testAllSqlsOnlyParse
INFO: testing comment01.sql
Oct 06, 2015 7:46:54 AM net.sf.jsqlparser.test.select.SpecialOracleTest testAllSqlsOnlyParse
INFO:    -> SUCCESS
Tests run: 2, Failures: 1, Errors: 0, Skipped: 0, Time elapsed: 0.099 sec <<< FAILURE!
Running net.sf.jsqlparser.test.select.SelectTest
Tests run: 228, Failures: 219, Errors: 0, Skipped: 0, Time elapsed: 0.538 sec <<< FAILURE!
Running net.sf.jsqlparser.test.select.SpeedTest
42500 statements parsed in 8346 milliseconds
 (5092 statements per second,  0.0001964 seconds per statement )
38500 select scans for table name executed in 144 milliseconds
 (267361 select scans for table name per second,  0.0000037 seconds per select scans for table name)
Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 8.48 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.014 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.005 sec <<< FAILURE!
Running net.sf.jsqlparser.expression.ExpressionVisitorAdapterTest
Tests run: 2, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.001 sec
Running net.sf.jsqlparser.expression.SignedExpressionTest
Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.001 sec
Running net.sf.jsqlparser.schema.ServerTest
Tests run: 2, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0 sec
Running net.sf.jsqlparser.parser.CCJSqlParserUtilTest
Tests run: 3, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0 sec
Running net.sf.jsqlparser.statement.SetStatementTest
Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.004 sec
Running net.sf.jsqlparser.statement.AdaptersTest
Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.002 sec
Running net.sf.jsqlparser.statement.StatementsTest
Tests run: 1, Failures: 1, Errors: 0, Skipped: 0, Time elapsed: 0.001 sec <<< FAILURE!
Running net.sf.jsqlparser.statement.execute.ExecuteTest
Tests run: 1, Failures: 1, Errors: 0, Skipped: 0, Time elapsed: 0.001 sec <<< FAILURE!

Results :

Failed tests:   testAlterTableUniqueKey(net.sf.jsqlparser.test.alter.AlterTest): expected:<...grations` (`version`[])> but was:<...grations` (`version`[, ])>
  testAlterTableAddColumn(net.sf.jsqlparser.test.alter.AlterTest): expected:<varchar (255[])> but was:<varchar (255[, ])>
  testAlterTablePrimaryKey(net.sf.jsqlparser.test.alter.AlterTest): expected:<... ADD PRIMARY KEY (id[])> but was:<... ADD PRIMARY KEY (id[, ])>
  testCreateTableForeignKey(net.sf.jsqlparser.test.create.CreateTableTest): expected:<...est (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:<...est (id INT UNSIGNED[NOTNULLAUTO_INCREMENT string VARCHAR (20, )user_id INT UNSIGNED , , PRIMARY KEY (id, )FOREIGN KEY (user_id, ) REFERENCES ra_user(id, ), ])>
  testCreateTableArrays(net.sf.jsqlparser.test.create.CreateTableTest): expected:<...E sal_emp (name text[, pay_by_quarter integer[], schedule text[][]])> but was:<...E sal_emp (name text[pay_by_quarter integer[]schedule text[][], ])>
  testCreateTable2(net.sf.jsqlparser.test.create.CreateTableTest): expected:<...("test" varchar (255[)])> but was:<...("test" varchar (255[, ), ])>
  testCreateTable3(net.sf.jsqlparser.test.create.CreateTableTest): expected:<...("test" varchar (255[), "test2" varchar (255)])> but was:<...("test" varchar (255[, )"test2" varchar (255, ), ])>
  testCreateTableParams(net.sf.jsqlparser.test.create.CreateTableTest): expected:<CREATE TEMPORARY [TABLE T1 (PROCESSID VARCHAR (32)) ON COMMIT PRESERVE ROWS]> but was:<CREATE TEMPORARY [ TABLE T1 (PROCESSID VARCHAR (32, ), ) ONCOMMITPRESERVEROWS ]>
  testCreateTableDefault2(net.sf.jsqlparser.test.create.CreateTableTest): expected:<... (id integer default[ 1])> but was:<... (id integer default[1 , ])>
  testCreateTableWithKey(net.sf.jsqlparser.test.create.CreateTableTest): expected:<...aracter varying (255[) NOT NULL])> but was:<...aracter varying (255[, ) NOTNULL , ])>
  testCreateTable(net.sf.jsqlparser.test.create.CreateTableTest): expected:<...E 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:<...E mytab (mycol a (10[20, ) cnmg mycol2 mypar1 mypar2(23,323,3)asdf('23','123')dasd , , PRIMARY KEY (mycol2mycol, ), ) type=myisam ]>
  testCreateTablePrimaryKey(net.sf.jsqlparser.test.create.CreateTableTest): expected:<...est (id INT UNSIGNED[ NOT NULL AUTO_INCREMENT, string VARCHAR (20), user_id INT UNSIGNED, CONSTRAINT pk_name PRIMARY KEY (id)])> but was:<...est (id INT UNSIGNED[NOTNULLAUTO_INCREMENT string VARCHAR (20, )user_id INT UNSIGNED , , CONSTRAINT pk_name PRIMARY KEY (id, ), ])>
  testCreateTableColumnValues(net.sf.jsqlparser.test.create.CreateTableTest): expected:<...ble1 (values INTEGER[])> but was:<...ble1 (values INTEGER[, ])>
  testCreateTableDefault(net.sf.jsqlparser.test.create.CreateTableTest): expected:<... (id integer default[ -1])> but was:<... (id integer default[-1 , ])>
  testCreateTableWithRange(net.sf.jsqlparser.test.create.CreateTableTest): expected:<...aracter varying (255[), range character varying (255), start_range integer, end_range integer])> but was:<...aracter varying (255[, )range character varying (255, )start_range integerend_range integer, ])>
  testCreateTableUniqueConstraint(net.sf.jsqlparser.test.create.CreateTableTest): expected:<...(_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:<...(_id integer primary[keyautoincrement uuid varchar(255,)user_id integersound_id integersound_type integercomment_id integertype stringtags varchar(255,)created_at integercontent_id integersharing_note_text varchar(255,)sharing_note_created_at integer,,unique(created_attypecontent_idsound_iduser_id,),])>
  testCreateTableForeignKey2(net.sf.jsqlparser.test.create.CreateTableTest): expected:<...est (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:<...est (id INT UNSIGNED[NOTNULLAUTO_INCREMENT string VARCHAR (20, )user_id INT UNSIGNED , , PRIMARY KEY (id, )CONSTRAINT fkIdx FOREIGN KEY (user_id, ) REFERENCES ra_user(id, ), ])>
  testCreateTableForeignKey3(net.sf.jsqlparser.test.create.CreateTableTest): expected:<...test(id int unsigned[ not null auto_increment,string varchar(20),user_id int unsigned references ra_user(id),primary key(id)])> but was:<...test(id int unsigned[notnullauto_increment string varchar(20,)user_id int unsignedreferencesra_user(id),,primary key(id,),])>
  testCreateTableForeignKey4(net.sf.jsqlparser.test.create.CreateTableTest): expected:<...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:<...test(id int unsigned[notnullauto_increment string varchar(20,)user_id int unsignedforeignkeyreferencesra_user(id),,primary key(id,),])>
  testCreateTableWithUniqueKey(net.sf.jsqlparser.test.create.CreateTableTest): expected:<... animals (id INT NOT[ NULL, name VARCHAR (100) UNIQUE KEY (id)])> but was:<... animals (id INT NOT[NULL name VARCHAR (100, ) UNIQUEKEY(id) , ])>
  testCreateTableVeryComplex(net.sf.jsqlparser.test.create.CreateTableTest): expected:<...(`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:<...(`meta_id` bigint(20[,)unsignednotnullauto_increment `comment_id` bigint(20,)unsignednotnulldefault'0' `meta_key` varchar(255,)defaultnull `meta_value` longtext,,primary key(`meta_id`,)key `comment_id`(`comment_id`,)key `meta_key`(`meta_key`,),)engine=innodbdefault]charset=utf8>
  testCreateTableUnlogged2(net.sf.jsqlparser.test.create.CreateTableTest): expected:<...E mytab (mycol a (10[, 20) c nm g, mycol2 mypar1 mypar2 (23,323,3) asdf ('23','123') dasd, PRIMARY KEY (mycol2, mycol)])> but was:<...E mytab (mycol a (10[20, ) cnmg mycol2 mypar1 mypar2(23,323,3)asdf('23','123')dasd , , PRIMARY KEY (mycol2mycol, ), ])>
  testCreateTableColumnValue(net.sf.jsqlparser.test.create.CreateTableTest): expected:<...able1 (value INTEGER[])> but was:<...able1 (value INTEGER[, ])>
  testCreateTableInlinePrimaryKey(net.sf.jsqlparser.test.create.CreateTableTest): expected:<...mals (id INT PRIMARY[ KEY NOT NULL])> but was:<...mals (id INT PRIMARY[KEYNOTNULL , ])>
  testCreateTableArrays2(net.sf.jsqlparser.test.create.CreateTableTest): expected:<...E sal_emp (name text[, pay_by_quarter integer[5], schedule text[3][2]])> but was:<...E sal_emp (name text[pay_by_quarter integer[5]schedule text[3][2], ])>
  testCreateTableAsSelect(net.sf.jsqlparser.test.create.CreateTableTest): expected:<...BLE a AS SELECT col1[, col2] FROM b> but was:<...BLE a AS SELECT col1[col2, ] FROM b>
  testCreateTableAsSelect2(net.sf.jsqlparser.test.create.CreateTableTest): expected:<...TH a AS (SELECT col1[, col3 FROM testtable) SELECT col1, col2, col3] FROM b INNER JOIN a...> but was:<...TH a AS (SELECT col1[col3,  FROM testtable) SELECT col1col2col3, ] FROM b INNER JOIN a...>
  testCreateTableUnlogged(net.sf.jsqlparser.test.create.CreateTableTest): expected:<...E 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:<...E mytab (mycol a (10[20, ) cnmg mycol2 mypar1 mypar2(23,323,3)asdf('23','123')dasd , , PRIMARY KEY (mycol2mycol, ), ) type=myisam ]>
  testCreateTableIfNotExists(net.sf.jsqlparser.test.create.CreateTableTest): expected:<... animals (id INT NOT[ NULL])> but was:<... animals (id INT NOT[NULL , ])>
  testCreateView2(net.sf.jsqlparser.test.create.CreateViewTest): expected:<...W myview AS SELECT *[] FROM mytab> but was:<...W myview AS SELECT *[, ] FROM mytab>
  testCreateView3(net.sf.jsqlparser.test.create.CreateViewTest): expected:<...W myview AS SELECT *[] FROM mytab> but was:<...W myview AS SELECT *[, ] FROM mytab>
  testCreateView4(net.sf.jsqlparser.test.create.CreateViewTest): expected:<...EW view2 AS SELECT a[, b, c] FROM testtab INNER ...> but was:<...EW view2 AS SELECT a[bc, ] FROM testtab INNER ...>
  testCreateView5(net.sf.jsqlparser.test.create.CreateViewTest): expected:<... myview AS (SELECT *[] FROM mytab)> but was:<... myview AS (SELECT *[, ] FROM mytab)>
  testCreateView(net.sf.jsqlparser.test.create.CreateViewTest): expected:<...W myview AS SELECT *[] FROM mytab> but was:<...W myview AS SELECT *[, ] FROM mytab>
  testCreateViewUnion(net.sf.jsqlparser.test.create.CreateViewTest): expected:<...W view1 AS (SELECT a[, b FROM testtab) UNION (SELECT b, c] FROM testtab2)> but was:<...W view1 AS (SELECT a[b,  FROM testtab) UNION (SELECT bc, ] FROM testtab2)>
  testCreateMaterializedView(net.sf.jsqlparser.test.create.CreateViewTest): expected:<...EW view1 AS SELECT a[, b] FROM testtab> but was:<...EW view1 AS SELECT a[b, ] FROM testtab>
  testCreateViewWithColumnNames1(net.sf.jsqlparser.test.create.CreateViewTest): expected:<...LACE VIEW view1(col1[, col2) AS SELECT a, b] FROM testtab> but was:<...LACE VIEW view1(col1[col2, ) AS SELECT ab, ] FROM testtab>
  testDrop(net.sf.jsqlparser.test.drop.DropTest): expected:<...NDEX myindex CASCADE[]> but was:<...NDEX myindex CASCADE[, ]>
  testInsertMultiRowValue(net.sf.jsqlparser.test.insert.InsertTest): expected:<...T INTO mytable (col1[, col2) VALUES (a, b), (d, e])> but was:<...T INTO mytable (col1[col2, ) VALUES (ab, ), (de, ])>
  testInsertWithReturning2(net.sf.jsqlparser.test.insert.InsertTest): expected:<...TO mytable (mycolumn[) VALUES ('1']) RETURNING *> but was:<...TO mytable (mycolumn[, ) VALUES ('1', ]) RETURNING *>
  testInsertWithReturning3(net.sf.jsqlparser.test.insert.InsertTest): expected:<...TO mytable (mycolumn[) VALUES ('1') RETURNING id AS a1, id2 AS a2]> but was:<...TO mytable (mycolumn[, ) VALUES ('1', ) RETURNING id AS a1id2 AS a2, ]>
  testHexValues2(net.sf.jsqlparser.test.insert.InsertTest): expected:<...O TABLE2 VALUES ('1'[, "DSDD", 0xEFBFBDC7AB])> but was:<...O TABLE2 VALUES ('1'["DSDD"0xEFBFBDC7AB, ])>
  testHexValues3(net.sf.jsqlparser.test.insert.InsertTest): expected:<...O TABLE2 VALUES ('1'[, "DSDD", 0xabcde])> but was:<...O TABLE2 VALUES ('1'["DSDD"0xabcde, ])>
  testHexValues(net.sf.jsqlparser.test.insert.InsertTest): expected:<...O TABLE2 VALUES ('1'[, "DSDD", x'EFBFBDC7AB'])> but was:<...O TABLE2 VALUES ('1'["DSDD"x'EFBFBDC7AB', ])>
  testSimpleInsert(net.sf.jsqlparser.test.insert.InsertTest): expected:<...RT INTO example (num[, name, address, tel) VALUES (1, 'name', 'test ', '1234-1234'])> but was:<...RT INTO example (num[nameaddresstel, ) VALUES (1'name''test ''1234-1234', ])>
  testInsertWithKeywords(net.sf.jsqlparser.test.insert.InsertTest): expected:<...T INTO kvPair (value[, key) VALUES (?, ?])> but was:<...T INTO kvPair (value[key, ) VALUES (??, ])>
  testInsertWithReturning(net.sf.jsqlparser.test.insert.InsertTest): expected:<...TO mytable (mycolumn[) VALUES ('1') RETURNING id]> but was:<...TO mytable (mycolumn[, ) VALUES ('1', ) RETURNING id, ]>
  testRegularInsert(net.sf.jsqlparser.test.insert.InsertTest): expected:<...T INTO mytable (col1[, col2, col3) VALUES (?, 'sadfsd', 234])> but was:<...T INTO mytable (col1[col2col3, ) VALUES (?'sadfsd'234, ])>
  testInsertWithKeywordValue(net.sf.jsqlparser.test.insert.InsertTest): expected:<...T INTO mytable (col1[) VALUES ('val1'])> but was:<...T INTO mytable (col1[, ) VALUES ('val1', ])>
  testInsertFromSelect(net.sf.jsqlparser.test.insert.InsertTest): expected:<...T INTO mytable (col1[, col2, col3) SELECT *] FROM mytable2> but was:<...T INTO mytable (col1[col2col3, ) SELECT *, ] FROM mytable2>
  testInsertWithSelect(net.sf.jsqlparser.test.insert.InsertTest): expected:<...TO mytable (mycolumn[) WITH a AS (SELECT mycolumn FROM mytable) SELECT mycolumn] FROM a> but was:<...TO mytable (mycolumn[, ) WITH a AS (SELECT mycolumn,  FROM mytable) SELECT mycolumn, ] FROM a>
  testInsertSelect(net.sf.jsqlparser.test.insert.InsertTest): expected:<...TO mytable (mycolumn[) SELECT mycolumn] FROM mytable> but was:<...TO mytable (mycolumn[, ) SELECT mycolumn, ] FROM mytable>
  testUpdateWithFrom(net.sf.jsqlparser.test.update.UpdateTest): expected:<UPDATE table1[] SET columna = 5 FRO...> but was:<UPDATE table1[, ] SET columna = 5 FRO...>
  testUpdateMultiTable(net.sf.jsqlparser.test.update.UpdateTest): expected:<UPDATE T1[, T2] SET T1.C2 = T2.C2, ...> but was:<UPDATE T1[T2, ] SET T1.C2 = T2.C2, ...>
  testUpdateWithSelect2(net.sf.jsqlparser.test.update.UpdateTest): expected:<UPDATE mytable[ SET (col1, col2, col3) = (SELECT a, b, c] FROM mytable2)> but was:<UPDATE mytable[,  SET (col1, col2, col3) = (SELECT abc, ] FROM mytable2)>
  testUpdateWithSelect(net.sf.jsqlparser.test.update.UpdateTest): expected:<UPDATE NATION[ SET (N_NATIONKEY) = (SELECT ?] FROM SYSIBM.SYSDUMM...> but was:<UPDATE NATION[,  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 table1 AS A[, ] 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 (ID[AB, ) SELECT A_IDAB, ] FROM b_table>
  testReplaceSyntax2(net.sf.jsqlparser.test.replace.ReplaceTest): expected:<...EPLACE mytable (col1[, col2, col3) VALUES ('as', ?, 565])> but was:<...EPLACE mytable (col1[col2col3, ) VALUES ('as'?565, ])>
  testAllSqlsParseDeparse(net.sf.jsqlparser.test.select.SpecialOracleTest): expected:<select exception[ ]from exception> but was:<select exception[,]from exception>
  testSelectAliasWithoutAs(net.sf.jsqlparser.test.select.SelectTest): expected:<...umn "My Column Name"[] FROM mytable> but was:<...umn "My Column Name"[, ] 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 e1.empno[e1.sal,  FROM emp e1 WHERE e1.sal > ALL (SELECT e2.sal, ] FROM emp e2 WHERE e...>
  testSimpleSigns(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT +1[, -1] FROM tableName> but was:<SELECT +1[-1, ] 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 (trim(a, )trim(b, ), ) IN (SELECT ab, ] FROM mytable2)>
  testSelectForUpdateOfTable(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT foo.*[, bar.*] FROM foo, bar WHERE...> but was:<SELECT foo.*[bar.*, ] FROM foo, bar WHERE...>
  testPostgreSQLRegExpCaseSensitiveMatch(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT a[, b] FROM foo WHERE a ~ ...> but was:<SELECT a[b, ] 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 ('A''B', ])>
  testMultiPartTableNameWithSchemaName(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT columnName[] FROM schemaName.tab...> but was:<SELECT columnName[, ] FROM schemaName.tab...>
  testSelectBrackets2(net.sf.jsqlparser.test.select.SelectTest): expected:<...CT(epoch FROM age(d1[, d2)) / 2)::numeric]> but was:<...CT(epoch FROM age(d1[d2, )) / 2)::numeric, ]>
  testSelectBrackets3(net.sf.jsqlparser.test.select.SelectTest): expected:<...CT(epoch FROM age(d1[, d2)) / 2)::numeric)]> but was:<...CT(epoch FROM age(d1[d2, )) / 2)::numeric, ), ]>
  testSelectBrackets4(net.sf.jsqlparser.test.select.SelectTest): expected:<...ECT (1 / 2)::numeric[]> but was:<...ECT (1 / 2)::numeric[, ]>
  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 1 - 1[1 + 1-1 - 1-1 + 1+1 + 1+1 - 1, ] FROM tableName>
  testSelectAliasInQuotes(net.sf.jsqlparser.test.select.SelectTest): expected:<... AS "My Column Name"[] FROM mytable> but was:<... AS "My Column Name"[, ] 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 GROUP BY tab1.b,  ORDER BY tab1.a DESCtab1.b ASC, ]>
  testCastTypeProblem2(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT col1::varchar[] FROM tabelle1> but was:<SELECT col1::varchar[, ] FROM tabelle1>
  testCastTypeProblem3(net.sf.jsqlparser.test.select.SelectTest): expected:<...T col1::varchar (256[)] FROM tabelle1> but was:<...T col1::varchar (256[, ), ] FROM tabelle1>
  testCastTypeProblem4(net.sf.jsqlparser.test.select.SelectTest): expected:<...LECT 5::varchar (256[)] FROM tabelle1> but was:<...LECT 5::varchar (256[, ), ] FROM tabelle1>
  testCastTypeProblem5(net.sf.jsqlparser.test.select.SelectTest): expected:<...T 5.67::varchar (256[)] FROM tabelle1> but was:<...T 5.67::varchar (256[, ), ] FROM tabelle1>
  testCastTypeProblem6(net.sf.jsqlparser.test.select.SelectTest): expected:<...'::character varying[] FROM tabelle1> but was:<...'::character varying[, ] FROM tabelle1>
  testCastTypeProblem7(net.sf.jsqlparser.test.select.SelectTest): expected:<...S character varying)[] FROM tabelle1> but was:<...S character varying)[, ] FROM tabelle1>
  testCastInCast(net.sf.jsqlparser.test.select.SelectTest): expected:<...numeric) AS varchar)[] FROM tabelle1> but was:<...numeric) AS varchar)[, ] FROM tabelle1>
  testSkipFirst(net.sf.jsqlparser.test.select.SelectTest): expected:<... SKIP ?1 FIRST f1 c1[, c2] FROM t1> but was:<... SKIP ?1 FIRST f1 c1[c2, ] FROM t1>
  testMultiPartTableNameWithDatabaseNameAndSchemaName(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT columnName[] FROM databaseName.s...> but was:<SELECT columnName[, ] FROM databaseName.s...>
  testSelectJoinWithComma(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT cb.Genus[, cb.Species] FROM Coleccion_de_B...> but was:<SELECT cb.Genus[cb.Species, ] FROM Coleccion_de_B...>
  testAdditionalLettersGerman(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT colä[, colö, colü] FROM testtableäöü> but was:<SELECT colä[colöcolü, ] 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:<...t AS ((SELECT mslink[ FROM tablea) UNION (SELECT mslink FROM tableb)) SELECT * FROM tablea WHERE mslink IN (SELECT mslink] FROM test)> but was:<...t AS ((SELECT mslink[,  FROM tablea) UNION (SELECT mslink,  FROM tableb)) SELECT *,  FROM tablea WHERE mslink IN (SELECT mslink, ] FROM test)>
  testMysqlQuote(net.sf.jsqlparser.test.select.SelectTest): expected:<...CT `a.OWNERLASTNAME`[, `OWNERFIRSTNAME`] FROM `ANTIQUEOWNERS...> but was:<...CT `a.OWNERLASTNAME`[`OWNERFIRSTNAME`, ] 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 'a' aid,  FROM DUAL) SELECT aid, ] FROM actor)>
  testReservedKeyword2(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT open[] FROM tableName> but was:<SELECT open[, ] FROM tableName>
  testFirst(net.sf.jsqlparser.test.select.SelectTest): expected:<... 5 alias.columnName1[, alias.columnName2 FROM schemaName.tableName alias ORDER BY alias.columnName2 DESC]> but was:<... 5 alias.columnName1[alias.columnName2,  FROM schemaName.tableName alias ORDER BY alias.columnName2 DESC, ]>
  testIlike(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT col1[] FROM table1 WHERE c...> but was:<SELECT col1[, ] 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 (-(1))[-(1)(-(columnName))-(columnName)(-1)-1(-columnName)-columnName, ] 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(first_name'^Ste(v|ph)en$', ])>
  testRegexpLike2(net.sf.jsqlparser.test.select.SelectTest): expected:<...GEXP_LIKE(first_name[, '^Ste(v|ph)en$') THEN 1 ELSE 2 END] FROM mytable> but was:<...GEXP_LIKE(first_name['^Ste(v|ph)en$', ) THEN 1  ELSE 2 END, ] 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 a[CASE b WHEN 1 THEN 2  END, ] FROM tab1>
  testCast(net.sf.jsqlparser.test.select.SelectTest): expected:<...T CAST(a AS varchar)[] FROM tabelle1> but was:<...T CAST(a AS varchar)[, ] 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:<... 5 alias.columnName1[, alias.columnName2 FROM schemaName.tableName alias ORDER BY alias.columnName2 DESC]> but was:<... 5 alias.columnName1[alias.columnName2,  FROM schemaName.tableName alias ORDER BY alias.columnName2 DESC, ]>
  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 (DEPTNO[AVGSALARYEMPCOUNT, ) AS (SELECT OTHERS.WORKDEPTAVG(OTHERS.SALARY, )COUNT(*),  FROM EMPLOYEE AS OTHERS GROUP BY OTHERS.WORKDEPT, ), DINFOMAX AS (SELECT MAX(AVGSALARY, ) AS AVGMAX,  FROM DINFO) SELECT THIS_EMP.EMPNOTHIS_EMP.SALARYDINFO.AVGSALARYDINFO.EMPCOUNTDINFOMAX.AVGMAX, ] FROM EMPLOYEE AS TH...>
  testJsonExpression(net.sf.jsqlparser.test.select.SelectTest): expected:<...ail'->'url' AS thumb[] FROM instagram> but was:<...ail'->'url' AS thumb[, ] FROM instagram>
  testConcatProblem2_5_1(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT (a || b) || c[] FROM testtable> but was:<SELECT (a || b) || c[, ] FROM testtable>
  testConcatProblem2_5_2(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT (a + b) + c[] FROM testtable> but was:<SELECT (a + b) + c[, ] 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 ID[NAMESALARYSUM(SALARY) OVER () AS SUM_SALAVG(SALARY) OVER () AS AVG_SALMIN(SALARY) OVER () AS MIN_SALMAX(SALARY) OVER () AS MAX_SALCOUNT(*) OVER () AS ROWS2,  FROM STAFF WHERE ID < 60 ORDER BY ID, ]>
  testWithUnionAllProblem(net.sf.jsqlparser.test.select.SelectTest): expected:<...t AS ((SELECT mslink[ FROM tablea) UNION ALL (SELECT mslink FROM tableb)) SELECT * FROM tablea WHERE mslink IN (SELECT mslink] FROM test)> but was:<...t AS ((SELECT mslink[,  FROM tablea) UNION ALL (SELECT mslink,  FROM tableb)) SELECT *,  FROM tablea WHERE mslink IN (SELECT mslink, ] 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 e1.empno[e1.sal,  FROM emp e1 WHERE e1.sal > ANY (SELECT e2.sal, ] 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 (count(a, ),  FOR 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 mytable PIVOT XML (count(a, ),  FOR b,  IN (SELECT vals, ] 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 (count(a, ),  FOR b, ] 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 @@SPID AS ID[SYSTEM_USER AS "Login Name"USER AS "User Name", ]>
  testSelectWithBrackets2(net.sf.jsqlparser.test.select.SelectTest): expected:<(SELECT 1[])> but was:<(SELECT 1[, ])>
  testOrderByNullsFirst(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT a[ FROM tab1 ORDER BY a NULLS FIRST]> but was:<SELECT a[,  FROM tab1 ORDER BY a NULLS FIRST, ]>
  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 mod(5[2, ), ] 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 a[row_number() OVER (ORDER BY a) AS n, ] 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 O.ORDERID[O.CUSTNAMEOL.LINETOTAL,  FROM ORDERS AS O, LATERAL(SELECT SUM(NETAMT, ) AS LINETOTAL, ] FROM ORDERLINES AS ...>
  testSelectNumericBind(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT a[] FROM b WHERE c = :1> but was:<SELECT a[, ] 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 O.ORDERID[O.CUSTNAMEOL.LINETOTALOC.ORDCHGTOTALOT.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...>
  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 (abc, ) IN (SELECT abc, ] 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 test()[, ] FROM testtable>
  testConcatProblem2(net.sf.jsqlparser.test.select.SelectTest): expected:<...PERIODE)::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:<...PERIODE)::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>
  testBitwise(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT col1 & 32[, col2 ^ col1, col1 | col2] FROM table1> but was:<SELECT col1 & 32[col2 ^ col1col1 | col2, ] 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 myid AS MYID[mycoltab.*schema.tab.*mytab.mycol2myschema.mytab.mycolmyschema.mytab.*, ] 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(pg_constraint.conkey, ])>
  testBrackets2(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [a][] FROM t> but was:<SELECT [a][, ] FROM t>
  testProblemSqlServer_Modulo_Proz(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT 5 % 2[] FROM A> but was:<SELECT 5 % 2[, ] FROM A>
  testFirstWithKeywordLimit(net.sf.jsqlparser.test.select.SelectTest): expected:<... ? alias.columnName1[, alias.columnName2 FROM schemaName.tableName alias ORDER BY alias.columnName2 DESC]> but was:<... ? alias.columnName1[alias.columnName2,  FROM schemaName.tableName alias ORDER BY alias.columnName2 DESC, ]>
  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 student_name[GROUP_CONCAT(DISTINCT test_score,  ORDER BY test_score DESC SEPARATOR ' '),  FROM student GROUP BY 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[, ) AS ((SELECT 1, ) UNION ALL (SELECT n + 1,  FROM t WHERE n < 100)) SELECT sum(n, ), ] FROM t>
  testSelectKeepOver(net.sf.jsqlparser.test.select.SelectTest): expected:<...ION BY department_id[ ) "Worst" FROM employees ORDER BY department_id, salary]> but was:<...ION BY department_id[,  ) "Worst",  FROM employees ORDER BY department_idsalary, ]>
  testFunctionRight(net.sf.jsqlparser.test.select.SelectTest): expected:<...CT right(table1.col1[, 4)] FROM table1> but was:<...CT right(table1.col1[4, ), ] FROM table1>
  testSelectBrackets(net.sf.jsqlparser.test.select.SelectTest): expected:<...g((123.250)::numeric[)]> but was:<...g((123.250)::numeric[, ), ]>
  testMultiPartColumnName(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT columnName[] FROM tableName> but was:<SELECT columnName[, ] FROM tableName>
  testWithUnionProblem3(net.sf.jsqlparser.test.select.SelectTest): expected:<...t 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:<...t 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)>
  testWithUnionProblem4(net.sf.jsqlparser.test.select.SelectTest): expected:<...S ((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:<...S ((SELECT gl.mslink[ba.gl_name AS txtba.gl_nummer AS nr0 AS levelCAST(gl.mslink AS VARCHAR) AS pathae.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.mslinkba.gl_name AS txtba.gl_nummer AS nrhist.level + 1 AS levelCAST(hist.path + '.' + CAST(gl.mslink AS VARCHAR) AS VARCHAR) AS pathae.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 mslinkspace(level * 4, ) + txt AS txtnrfeaturepath,  FROM hist WHERE EXISTS (SELECT feature,  FROM tablec WHERE mslink = 0 AND ((feature IN (12, ) AND hist.feature = 3) OR (feature IN (4, ]) AND hist.feature =...>
  testWithUnionProblem5(net.sf.jsqlparser.test.select.SelectTest): expected:<...S ((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:<...S ((SELECT gl.mslink[ba.gl_name AS txtba.gl_nummer AS nr0 AS levelCAST(gl.mslink AS VARCHAR) AS pathae.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.mslinkba.gl_name AS txtba.gl_nummer AS nrhist.level + 1 AS levelCAST(hist.path + '.' + CAST(gl.mslink AS VARCHAR) AS VARCHAR) AS path5 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>
  testValues2(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT *[ FROM (VALUES 1, 2, 3, 4]) AS test> but was:<SELECT *[,  FROM (VALUES 1, , 2, , 3, , 4, ]) 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 1, , 2, , 3, , 4, ]) 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 (12, ), (34, ])) 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 X[Y,  FROM (VALUES (0'a', ), (1'b', ])) 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 GROUP BY tab1.b, ]>
  testMultiPartColumnNameWithTableName(net.sf.jsqlparser.test.select.SelectTest): expected:<...tableName.columnName[] FROM tableName> but was:<...tableName.columnName[, ] FROM tableName>
  testMultiPartTableNameWithDatabaseName(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT columnName[] FROM databaseName.....> but was:<SELECT columnName[, ] 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 ORDER BY mytable.id, ] 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 ORDER BY mytable.id, ] 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 ORDER BY mytable.id, ] 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 ORDER BY mytable.id, ] FETCH NEXT 5 ROWS O...>
  testPivotFunction(net.sf.jsqlparser.test.select.SelectTest): expected:<...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:<...to_char((SELECT col1[,  FROM (SELECT times_purchasedstate_code,  FROM customers t) PIVOT (count(state_code, ),  FOR state_code,  IN ('NY''CT''NJ''FL''MO', )) ORDER BY times_purchased, ), ), ] FROM DUAL>
  testMultiPartTableNameWithServerNameAndDatabaseName(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT columnName[] FROM [server-name\s...> but was:<SELECT columnName[, ] FROM [server-name\s...>
  testConcatProblem2_1(net.sf.jsqlparser.test.select.SelectTest): expected:<...ANLEVERPERIODEVOLGNR[, 'FM09'::VARCHAR)] FROM testtable> but was:<...ANLEVERPERIODEVOLGNR['FM09'::VARCHAR, ), ] FROM testtable>
  testConcatProblem2_2(net.sf.jsqlparser.test.select.SelectTest): expected:<...PERIODE)::VARCHAR (2[) || (VARCHAR(SPA.AANLEVERPERIODEJAAR))::VARCHAR (4)) AS GESLACHT_TMP] FROM testtable> but was:<...PERIODE)::VARCHAR (2[, ) || (VARCHAR(SPA.AANLEVERPERIODEJAAR, ))::VARCHAR (4, ), ) AS GESLACHT_TMP, ] FROM testtable>
  testConcatProblem2_3(net.sf.jsqlparser.test.select.SelectTest): expected:<...VERSCHIJNINGSVOLGNR)[, 'FM0999'::VARCHAR)] FROM testtable> but was:<...VERSCHIJNINGSVOLGNR)['FM0999'::VARCHAR, ), ] FROM testtable>
  testConcatProblem2_4(net.sf.jsqlparser.test.select.SelectTest): expected:<...ESLACHT)::VARCHAR (1[)] FROM testtable> but was:<...ESLACHT)::VARCHAR (1[, ), ] FROM testtable>
  testConcatProblem2_5(net.sf.jsqlparser.test.select.SelectTest): expected:<...CT max((a || b) || c[)] FROM testtable> but was:<...CT max((a || b) || c[, ), ] FROM testtable>
  testConcatProblem2_6(net.sf.jsqlparser.test.select.SelectTest): expected:<...LECT max(a || b || c[)] FROM testtable> but was:<...LECT max(a || b || c[, ), ] FROM testtable>
  testMultiPartColumnNameWithDatabaseNameAndSchemaNameAndTableName(net.sf.jsqlparser.test.select.SelectTest): expected:<...tableName.columnName[] FROM tableName> but was:<...tableName.columnName[, ] FROM tableName>
  testMultiPartColumnNameWithDatabaseNameAndTableName(net.sf.jsqlparser.test.select.SelectTest): expected:<...tableName.columnName[] FROM tableName> but was:<...tableName.columnName[, ] FROM tableName>
  testReplaceAsFunction(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT REPLACE(a[, 'b', c)] FROM tab1> but was:<SELECT REPLACE(a['b'c, ), ] FROM tab1>
  testSelectJPQLPositionalParameter(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT email[] FROM users WHERE (t...> but was:<SELECT email[, ] 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 LISTAGG(col1['##', ) WITHIN GROUP (ORDER BY col1), ] 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 a[lag(a, 1) OVER (PARTITION BY c,  ORDER BY a, b) AS n, ] 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 a[lag(a, 1, 0) OVER (PARTITION BY c,  ORDER BY a, b) AS n, ] 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('new & york & yankees', ])>
  testAnalyticFunctionProblem1(net.sf.jsqlparser.test.select.SelectTest): expected:<...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:<...id_d_insertion_order[s.id_d_product_ad_attrtrunc(s.date_id'mm', ),  ORDER BY s.date_id) AS col, ] FROM s>
  testFunctions(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT MAX(id[) AS max] FROM mytable WHERE ...> but was:<SELECT MAX(id[, ) AS max, ] FROM mytable WHERE ...>
  testProblemFunction2(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT sysdate[] FROM testtable> but was:<SELECT sysdate[, ] FROM testtable>
  testProblemFunction3(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT TRUNCATE(col[)] FROM testtable> but was:<SELECT TRUNCATE(col[, ), ] 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 units[count(units, ) AS num,  FROM currency GROUP BY units,  HAVING count(units, ) > 1 ORDER BY num, ]>
  testAnalyticFunction12(net.sf.jsqlparser.test.select.SelectTest): expected:<...OVER (PARTITION BY b[ ORDER BY c)] FROM tab1> but was:<...OVER (PARTITION BY b[,  ORDER BY c), ] FROM tab1>
  testAnalyticFunction13(net.sf.jsqlparser.test.select.SelectTest): expected:<...ELECT SUM(a) OVER ()[] FROM tab1> but was:<...ELECT SUM(a) OVER ()[, ] FROM tab1>
  testAnalyticFunction14(net.sf.jsqlparser.test.select.SelectTest): expected:<...OVER (PARTITION BY b[ )] FROM tab1> but was:<...OVER (PARTITION BY b[,  ), ] FROM tab1>
  testAnalyticFunction15(net.sf.jsqlparser.test.select.SelectTest): expected:<...a) OVER (ORDER BY c)[] FROM tab1> but was:<...a) OVER (ORDER BY c)[, ] FROM tab1>
  testAnalyticFunction16(net.sf.jsqlparser.test.select.SelectTest): expected:<...ER BY c NULLS FIRST)[] FROM tab1> but was:<...ER BY c NULLS FIRST)[, ] FROM tab1>
  testAnalyticFunction17(net.sf.jsqlparser.test.select.SelectTest): expected:<...(PARTITION BY deptno[ ORDER BY sal ROWS BETWEEN 0 PRECEDING AND 0 PRECEDING) AS avg_of_current_sal] FROM emp> but was:<...(PARTITION BY deptno[,  ORDER BY sal ROWS BETWEEN 0 PRECEDING AND 0 PRECEDING) AS avg_of_current_sal, ] FROM emp>
  testAnalyticFunction18(net.sf.jsqlparser.test.select.SelectTest): expected:<...(PARTITION BY deptno[ ORDER BY sal RANGE CURRENT ROW) AS avg_of_current_sal] FROM emp> but was:<...(PARTITION BY deptno[,  ORDER BY sal RANGE CURRENT ROW) AS avg_of_current_sal, ] FROM emp>
  testMultiPartTableNameWithServerNameAndDatabaseNameAndSchemaName(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT columnName[] FROM [server-name\s...> but was:<SELECT columnName[, ] FROM [server-name\s...>
  testBrackets(net.sf.jsqlparser.test.select.SelectTest): expected:<...ble_a.name AS [Test][] FROM table_a> but was:<...ble_a.name AS [Test][, ] FROM table_a>
  testWithStatement(net.sf.jsqlparser.test.select.SelectTest): expected:<...st AS (SELECT mslink[ FROM feature) SELECT * FROM feature WHERE mslink IN (SELECT mslink] FROM test)> but was:<...st AS (SELECT mslink[,  FROM feature) SELECT *,  FROM feature WHERE mslink IN (SELECT mslink, ] 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 r.id[r.uuidr.namer.system_role,  FROM role r WHERE r.merchant_id = ? AND r.deleted_time IS NULL ORDER BY r.id DESC, ]>
  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 a[sum(b) OVER () AS n, ] FROM table1>
  testMultiPartTableNameWithColumnName(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT columnName[] FROM tableName> but was:<SELECT columnName[, ] FROM tableName>
  testFunctionLeft(net.sf.jsqlparser.test.select.SelectTest): expected:<...ECT left(table1.col1[, 4)] FROM table1> but was:<...ECT left(table1.col1[4, ), ] FROM table1>
  testCharacterSetClause(net.sf.jsqlparser.test.select.SelectTest): expected:<...nick2` AS CHAR (8000[) CHARACTER SET utf8) AS `v0`] FROM people `view0`...> but was:<...nick2` AS CHAR (8000[, ) CHARACTER SET utf8) AS `v0`, ] FROM people `view0`...>
  testComplexUnion1(net.sf.jsqlparser.test.select.SelectTest): expected:<...sce(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:<...sce(mytab.a::varchar['', ) AS amytab.bmytab.c AS stmytab.dmytab.e,  FROM mytab WHERE mytab.del = 0) UNION (SELECT 'cde-' || coalesce(mytab2.a::varchar'', ) AS amytab2.bmytab2.bezeichnung AS c0 AS d0 AS e, ] 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 a[sum(b + 5) OVER (ORDER BY a) AS n, ] FROM table1>
  testDistinct(net.sf.jsqlparser.test.select.SelectTest): expected:<...CT DISTINCT ON (myid[) myid, mycol] FROM mytable WHERE ...> but was:<...CT DISTINCT ON (myid[, ) myidmycol, ] FROM mytable WHERE ...>
  testMultiPartColumnNameWithSchemaNameAndTableName(net.sf.jsqlparser.test.select.SelectTest): expected:<...tableName.columnName[] FROM tableName> but was:<...tableName.columnName[, ] FROM tableName>
  testMultiPartTableNameWithServerName(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT columnName[] FROM [server-name\s...> but was:<SELECT columnName[, ] FROM [server-name\s...>
  testProblemSqlAnalytic7Count(net.sf.jsqlparser.test.select.SelectTest): expected:<...ount(*) OVER () AS n[] FROM table1> but was:<...ount(*) OVER () AS n[, ] FROM table1>
  testSelectFunction(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT 1 + 2 AS sum[]> but was:<SELECT 1 + 2 AS sum[, ]>
  testIssue160_signedParameter(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT start_date[ WHERE start_date > DATEADD(HH, -?, GETDATE()])> but was:<SELECT start_date[,  WHERE start_date > DATEADD(HH-?GETDATE(), ])>
  testAllColumnsFromTable(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT tableName.*[] FROM tableName> but was:<SELECT tableName.*[, ] 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:<... + INTERVAL '3 days'[]> but was:<... + INTERVAL '3 days'[, ]>
  testInterval2(net.sf.jsqlparser.test.select.SelectTest): expected:<...INTERVAL '45 MINUTE'[, 'YYYY-MM-DD-HH24:')) AS START_TIME] FROM tab1> but was:<...INTERVAL '45 MINUTE'['YYYY-MM-DD-HH24:', ), ) AS START_TIME, ] FROM tab1>
  testInterval3(net.sf.jsqlparser.test.select.SelectTest): expected:<...5 + INTERVAL '3' day[]> but was:<...5 + INTERVAL '3' day[, ]>
  testInterval4(net.sf.jsqlparser.test.select.SelectTest): expected:<... + INTERVAL 1 SECOND[]> but was:<... + INTERVAL 1 SECOND[, ]>
  testConcat(net.sf.jsqlparser.test.select.SelectTest): expected:<...LECT a || b || c + 4[] FROM t> but was:<...LECT a || b || c + 4[, ] FROM t>
  testCount2(net.sf.jsqlparser.test.select.SelectTest): expected:<...ount(ALL col1 + col2[)] FROM mytable> but was:<...ount(ALL col1 + col2[, ), ] FROM mytable>
  testSignedColumns(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT -columnName[, +columnName, +(columnName), -(columnName)] FROM tableName> but was:<SELECT -columnName[+columnName+(columnName)-(columnName), ] FROM tableName>
  testDouble(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT 1e2[, *] FROM mytable WHERE ...> but was:<SELECT 1e2[*, ] 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 col1[col2col1 + col2sum(col8, ),  FROM table1 GROUP BY col1col2col1 + 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(tab1.b[, ),  FROM tab1 WHERE a > 34 GROUP BY tab1.b,  HAVING MAX(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 d.id[d.uuidd.named.amountd.percentaged.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, ]>
  testDistinctTop(net.sf.jsqlparser.test.select.SelectTest): expected:<... DISTINCT TOP 5 myid[, mycol] FROM mytable WHERE ...> but was:<... DISTINCT TOP 5 myid[mycol, ] FROM mytable WHERE ...>
  testSelectUserVariable(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT @col[] FROM t1> but was:<SELECT @col[, ] 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:<...NT alias.columnName1[, alias.columnName2 FROM schemaName.tableName alias ORDER BY alias.columnName2 DESC]> but was:<...NT alias.columnName1[alias.columnName2,  FROM schemaName.tableName alias ORDER BY alias.columnName2 DESC, ]>
  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(idx, ]).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 a[b, ] FROM foo WHERE a ~*...>
  testPostgreSQLRegExpCaseSensitiveMatch3(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT a[, b] FROM foo WHERE a !~...> but was:<SELECT a[b, ] FROM foo WHERE a !~...>
  testPostgreSQLRegExpCaseSensitiveMatch4(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT a[, b] FROM foo WHERE a !~...> but was:<SELECT a[b, ] 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 (col1col2, ) = (SELECT col3col4, ] 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(col1col2, ) = (SELECT col3col4, ] 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 a[row_number() OVER (ORDER BY a, b) AS n, ] 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 a[row_number() OVER (PARTITION BY c,  ORDER BY a, b) AS n, ] 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 a[row_number() OVER (PARTITION BY cd,  ORDER BY a, b) AS n, ] FROM table1>
  testSelectWithoutFrom(net.sf.jsqlparser.test.select.SelectTest): expected:<...T footable.foocolumn[]> but was:<...T 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 last_name[employee_idmanager_id,  FROM employees CONNECT BY employee_id = manager_id ORDER BY last_name, ]>
  testPivot1(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT *[ FROM mytable PIVOT (count(a) FOR b IN ('val1']))> but was:<SELECT *[,  FROM mytable PIVOT (count(a, ),  FOR 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 mytable PIVOT (count(a, ),  FOR b,  IN (102030, ]))>
  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 (count(a, ) AS vals,  FOR b,  IN (10 AS d12030 AS d3, ]))>
  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 (count(a, )sum(b, ),  FOR b,  IN (102030, ]))>
  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 (count(a, ),  FOR (bc, ) IN ((10'a', )(20'b', )(30'c', ), ]))>
  testSelectWithBrackets(net.sf.jsqlparser.test.select.SelectTest): expected:<(SELECT 1[] FROM mytable)> but was:<(SELECT 1[, ] FROM mytable)>
  testAnalyticFunctionProblem1b(net.sf.jsqlparser.test.select.SelectTest): expected:<...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:<...id_d_insertion_order[s.id_d_product_ad_attrtrunc(s.date_id'mm', ),  ORDER BY s.date_id ROWS BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING) AS col, ] FROM s>
  testDeparser(net.sf.jsqlparser.test.select.SelectTest): expected:<...LECT a.OWNERLASTNAME[, a.OWNERFIRSTNAME] FROM ANTIQUEOWNERS ...> but was:<...LECT a.OWNERLASTNAME[a.OWNERFIRSTNAME, ] 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 times_purchasedstate_code,  FROM customers t) PIVOT (count(state_code, ),  FOR state_code,  IN ('NY''CT''NJ''FL''MO', )) ORDER BY times_purchased, ]>
  testOracleHierarchicalQuery2(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT employee_id[, last_name, manager_id] FROM employees CONN...> but was:<SELECT employee_id[last_namemanager_id, ] 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 last_name[employee_idmanager_idLEVEL,  FROM employees START WITH employee_id = 100 CONNECT BY PRIOR employee_id = manager_id ORDER SIBLINGS BY 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 last_name[employee_idmanager_idLEVEL,  FROM employees CONNECT BY PRIOR employee_id = manager_id START WITH employee_id = 100 ORDER SIBLINGS BY last_name, ]>
  testExtractFrom1(net.sf.jsqlparser.test.select.SelectTest): expected:<...nth FROM datecolumn)[] FROM testtable> but was:<...nth FROM datecolumn)[, ] FROM testtable>
  testExtractFrom2(net.sf.jsqlparser.test.select.SelectTest): expected:<...ACT(year FROM now())[] FROM testtable> but was:<...ACT(year FROM now())[, ] FROM testtable>
  testExtractFrom3(net.sf.jsqlparser.test.select.SelectTest): expected:<...ar FROM (now() - 2))[] FROM testtable> but was:<...ar FROM (now() - 2))[, ] FROM testtable>
  testExtractFrom4(net.sf.jsqlparser.test.select.SelectTest): expected:<... now() - '01:22:00')[] FROM testtable> but was:<... now() - '01:22:00')[, ] FROM testtable>
  testProblemSqlAnalytic4EmptyOver(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT a[, row_number() OVER () AS n] FROM table1> but was:<SELECT a[row_number() OVER () AS n, ] FROM table1>
  testCastTypeProblem(net.sf.jsqlparser.test.select.SelectTest): expected:<...col1 AS varchar (256[))] FROM tabelle1> but was:<...col1 AS varchar (256[, )), ] FROM tabelle1>
  testSelectKeywordPercent(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT percent[] FROM MY_TABLE> but was:<SELECT percent[, ] 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 (12, ), (34, ])) 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 I[,  FROM (VALUES 1, , 2, , 3, ) AS MY_TEMP_TABLE(I) WHERE I IN (SELECT *,  FROM (VALUES 1, , 2, ]) 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 columnName[, ] FROM [server-name\s...>
  testProblemSqlServer_Modulo(net.sf.jsqlparser.test.select.SelectTest): expected:<... 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:<... convert(varchar(255[, )DATEDIFF(monthyear1abc_datum, ) / 12, ) + ' year, ' + convert(varchar(255, )DATEDIFF(monthyear2abc_datum, ) % 12, ) + ' month', ] 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 cast[doextractfirstfollowinglastmaterializednullspartitionrangerowrowssiblingsvaluexml, ] 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 ORDER BY mytable.id, ] OFFSET ? ROWS FETCH...>
  testSelectJoin(net.sf.jsqlparser.test.select.SelectTest): expected:<...ECT 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:<...ECT pg_class.relname[pg_attribute.attnamepg_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, ]>
  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 col1[min(col2, ) KEEP (DENSE_RANK FIRST ORDER BY col3)col4,  FROM table1 GROUP BY col5,  ORDER BY col3, ]>
  testCaseElseAddition(net.sf.jsqlparser.test.select.SelectTest): expected:<...N 1 + 3 > 20 THEN 0 [ELSE 1000 + 1 END AS d] FROM dual> but was:<...N 1 + 3 > 20 THEN 0 [ ELSE 1000 + 1 END AS d, ] 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(col1, ])>
  testCastInCast2(net.sf.jsqlparser.test.select.SelectTest): expected:<...numeric) AS varchar)[] FROM tabelle1> but was:<...numeric) AS varchar)[, ] 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:<... a || b || c AS expr[] FROM test> but was:<... a || b || c AS expr[, ] FROM test>
  testVisit_PlainSelect_addition(net.sf.jsqlparser.util.ConnectExpressionsVisitorTest): expected:<... + b + c AS testexpr[] FROM test> but was:<... + b + c AS testexpr[, ] 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 3 + 4 AS A1[,  FROM test) UNION (SELECT 7 + 8 AS A1, ] 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 a AS A1[b AS A2c AS A3, ] FROM test>
  testVisit_PlainSelect_expression(net.sf.jsqlparser.util.AddAliasesVisitorTest): expected:<SELECT 3 + 4 AS A1[] FROM test> but was:<SELECT 3 + 4 AS A1[, ] 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 a AS A2[b AS a1c AS A3, ] FROM test>
  testBuildSelectFromTableAndExpressions(net.sf.jsqlparser.util.SelectUtilsTest): expected:<SELECT a[, b] FROM mytable> but was:<SELECT a[b, ] FROM mytable>
  testAddExpr(net.sf.jsqlparser.util.SelectUtilsTest): expected:<SELECT a[, b] FROM mytable> but was:<SELECT a[b, ] FROM mytable>
  testAddJoin(net.sf.jsqlparser.util.SelectUtilsTest): expected:<SELECT a[] FROM mytable LEFT J...> but was:<SELECT a[, ] 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 GROUP BY b, ]>
  testBuildSelectFromTableAndParsedExpression(net.sf.jsqlparser.util.SelectUtilsTest): expected:<SELECT a + b[, test] FROM mytable> but was:<SELECT a + b[test, ] 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 'a'[2'b', ]>

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

[INFO] ------------------------------------------------------------------------
[INFO] BUILD FAILURE
[INFO] ------------------------------------------------------------------------
[INFO] Total time: 16.234s
[INFO] Finished at: Tue Oct 06 07:47:03 CEST 2015
[INFO] Final Memory: 23M/346M
[INFO] ------------------------------------------------------------------------
[ERROR] Failed to execute goal org.apache.maven.plugins:maven-surefire-plugin:2.10:test (default-test) on project jsqlparser: There are test failures.
[ERROR] 
[ERROR] Please refer to /home/perham/Study/Experiments/2015-10-23-ICST/LittleDarwin/Cases/JSqlParser-jsqlparser-0.9.4/target/surefire-reports for the individual test results.
[ERROR] -> [Help 1]
[ERROR] 
[ERROR] To see the full stack trace of the errors, re-run Maven with the -e switch.
[ERROR] Re-run Maven using the -X switch to enable full debug logging.
[ERROR] 
[ERROR] For more information about the errors and possible solutions, please read the following articles:
[ERROR] [Help 1] http://cwiki.apache.org/confluence/display/MAVEN/MojoFailureException
