[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 221.632ms.
[INFO] 
 * uptodate header on 163 files.
 * add header on 1 file.
[INFO] 
[INFO] --- maven-resources-plugin:2.6:resources (default-resources) @ jsqlparser ---
[INFO] Using 'UTF-8' encoding to copy filtered resources.
[INFO] skip non existing resourceDirectory /home/perham/Study/Experiments/2015-10-23-ICST/LittleDarwin/Cases/JSqlParser-jsqlparser-0.9.4/src/main/resources
[INFO] 
[INFO] --- maven-compiler-plugin:3.3:compile (default-compile) @ jsqlparser ---
[INFO] Changes detected - recompiling the module!
[INFO] Compiling 177 source files to /home/perham/Study/Experiments/2015-10-23-ICST/LittleDarwin/Cases/JSqlParser-jsqlparser-0.9.4/target/classes
[WARNING] bootstrap class path not set in conjunction with -source 1.6
[INFO] /home/perham/Study/Experiments/2015-10-23-ICST/LittleDarwin/Cases/JSqlParser-jsqlparser-0.9.4/target/generated-sources/javacc/net/sf/jsqlparser/parser/CCJSqlParser.java: /home/perham/Study/Experiments/2015-10-23-ICST/LittleDarwin/Cases/JSqlParser-jsqlparser-0.9.4/target/generated-sources/javacc/net/sf/jsqlparser/parser/CCJSqlParser.java uses unchecked or unsafe operations.
[INFO] /home/perham/Study/Experiments/2015-10-23-ICST/LittleDarwin/Cases/JSqlParser-jsqlparser-0.9.4/target/generated-sources/javacc/net/sf/jsqlparser/parser/CCJSqlParser.java: Recompile with -Xlint:unchecked for details.
[INFO] 
[INFO] --- maven-resources-plugin:2.6:testResources (default-testResources) @ jsqlparser ---
[INFO] Using 'UTF-8' encoding to copy filtered resources.
[INFO] Copying 280 resources
[INFO] 
[INFO] --- maven-compiler-plugin:3.3:testCompile (default-testCompile) @ jsqlparser ---
[INFO] Nothing to compile - all classes are up to date
[INFO] 
[INFO] --- maven-surefire-plugin:2.10:test (default-test) @ jsqlparser ---
[INFO] Surefire report directory: /home/perham/Study/Experiments/2015-10-23-ICST/LittleDarwin/Cases/JSqlParser-jsqlparser-0.9.4/target/surefire-reports

-------------------------------------------------------
 T E S T S
-------------------------------------------------------
Running net.sf.jsqlparser.test.alter.AlterTest
Tests run: 3, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.06 sec
Running net.sf.jsqlparser.test.create.CreateTableTest
Tests run: 27, Failures: 23, Errors: 0, Skipped: 0, Time elapsed: 0.092 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: 4, Errors: 0, Skipped: 0, Time elapsed: 0.003 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.176 sec
Running net.sf.jsqlparser.test.drop.DropTest
Tests run: 2, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0 sec
Running net.sf.jsqlparser.test.insert.InsertTest
Tests run: 15, Failures: 9, 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: 2, Errors: 0, Skipped: 0, Time elapsed: 0.005 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.003 sec
Running net.sf.jsqlparser.test.select.SpecialOracleTest
Oct 06, 2015 7:54:10 AM net.sf.jsqlparser.test.select.SpecialOracleTest testAllSqlsParseDeparse
INFO: testing string01.sql
Oct 06, 2015 7:54:10 AM net.sf.jsqlparser.test.select.SpecialOracleTest testAllSqlsParseDeparse
INFO:    -> PROBLEM net.sf.jsqlparser.JSQLParserException
Oct 06, 2015 7:54:10 AM net.sf.jsqlparser.test.select.SpecialOracleTest testAllSqlsParseDeparse
INFO: testing returning01.sql
Oct 06, 2015 7:54:10 AM net.sf.jsqlparser.test.select.SpecialOracleTest testAllSqlsParseDeparse
INFO:    -> PROBLEM net.sf.jsqlparser.JSQLParserException
Oct 06, 2015 7:54:10 AM net.sf.jsqlparser.test.select.SpecialOracleTest testAllSqlsParseDeparse
INFO: testing keywordasidentifier05.sql
Oct 06, 2015 7:54:10 AM net.sf.jsqlparser.test.select.SpecialOracleTest testAllSqlsParseDeparse
INFO:    -> SUCCESS
Oct 06, 2015 7:54:10 AM net.sf.jsqlparser.test.select.SpecialOracleTest testAllSqlsParseDeparse
INFO: testing function07.sql
Oct 06, 2015 7:54:10 AM net.sf.jsqlparser.test.select.SpecialOracleTest testAllSqlsParseDeparse
INFO:    -> PROBLEM net.sf.jsqlparser.JSQLParserException
Oct 06, 2015 7:54:10 AM net.sf.jsqlparser.test.select.SpecialOracleTest testAllSqlsParseDeparse
INFO: testing cast_multiset15.sql
Oct 06, 2015 7:54:10 AM net.sf.jsqlparser.test.select.SpecialOracleTest testAllSqlsParseDeparse
INFO:    -> PROBLEM net.sf.jsqlparser.JSQLParserException
Oct 06, 2015 7:54:10 AM net.sf.jsqlparser.test.select.SpecialOracleTest testAllSqlsParseDeparse
INFO: testing interval01.sql
Oct 06, 2015 7:54:10 AM net.sf.jsqlparser.test.select.SpecialOracleTest testAllSqlsParseDeparse
INFO:    -> PROBLEM net.sf.jsqlparser.JSQLParserException
Oct 06, 2015 7:54:10 AM net.sf.jsqlparser.test.select.SpecialOracleTest testAllSqlsParseDeparse
INFO: testing analytic_query04.sql
Oct 06, 2015 7:54:10 AM net.sf.jsqlparser.test.select.SpecialOracleTest testAllSqlsParseDeparse
INFO:    -> PROBLEM net.sf.jsqlparser.JSQLParserException
Oct 06, 2015 7:54:10 AM net.sf.jsqlparser.test.select.SpecialOracleTest testAllSqlsParseDeparse
INFO: testing join10.sql
Oct 06, 2015 7:54:10 AM net.sf.jsqlparser.test.select.SpecialOracleTest testAllSqlsParseDeparse
INFO:    -> SUCCESS
Oct 06, 2015 7:54:10 AM net.sf.jsqlparser.test.select.SpecialOracleTest testAllSqlsParseDeparse
INFO: testing pivot04.sql
Oct 06, 2015 7:54:10 AM net.sf.jsqlparser.test.select.SpecialOracleTest testAllSqlsParseDeparse
INFO:    -> PROBLEM net.sf.jsqlparser.JSQLParserException
Oct 06, 2015 7:54:10 AM net.sf.jsqlparser.test.select.SpecialOracleTest testAllSqlsParseDeparse
INFO: testing condition08.sql
Oct 06, 2015 7:54:10 AM net.sf.jsqlparser.test.select.SpecialOracleTest testAllSqlsParseDeparse
INFO:    -> PROBLEM net.sf.jsqlparser.JSQLParserException
Oct 06, 2015 7:54:10 AM net.sf.jsqlparser.test.select.SpecialOracleTest testAllSqlsParseDeparse
INFO: testing function03.sql
Oct 06, 2015 7:54:10 AM net.sf.jsqlparser.test.select.SpecialOracleTest testAllSqlsParseDeparse
INFO:    -> PROBLEM net.sf.jsqlparser.JSQLParserException
Oct 06, 2015 7:54:10 AM net.sf.jsqlparser.test.select.SpecialOracleTest testAllSqlsParseDeparse
INFO: testing merge03.sql
Oct 06, 2015 7:54:10 AM net.sf.jsqlparser.test.select.SpecialOracleTest testAllSqlsParseDeparse
INFO:    -> PROBLEM net.sf.jsqlparser.JSQLParserException
Oct 06, 2015 7:54:10 AM net.sf.jsqlparser.test.select.SpecialOracleTest testAllSqlsParseDeparse
INFO: testing insert02.sql
Oct 06, 2015 7:54:10 AM net.sf.jsqlparser.test.select.SpecialOracleTest testAllSqlsParseDeparse
INFO:    -> PROBLEM net.sf.jsqlparser.JSQLParserException
Oct 06, 2015 7:54:10 AM net.sf.jsqlparser.test.select.SpecialOracleTest testAllSqlsParseDeparse
INFO: testing insert11.sql
Oct 06, 2015 7:54:10 AM net.sf.jsqlparser.test.select.SpecialOracleTest testAllSqlsParseDeparse
INFO:    -> PROBLEM net.sf.jsqlparser.JSQLParserException
Oct 06, 2015 7:54:10 AM net.sf.jsqlparser.test.select.SpecialOracleTest testAllSqlsParseDeparse
INFO: testing interval02.sql
Oct 06, 2015 7:54:10 AM net.sf.jsqlparser.test.select.SpecialOracleTest testAllSqlsParseDeparse
INFO:    -> SUCCESS
Oct 06, 2015 7:54:10 AM net.sf.jsqlparser.test.select.SpecialOracleTest testAllSqlsParseDeparse
INFO: testing cast_multiset18.sql
Oct 06, 2015 7:54:10 AM net.sf.jsqlparser.test.select.SpecialOracleTest testAllSqlsParseDeparse
INFO:    -> PROBLEM net.sf.jsqlparser.JSQLParserException
Oct 06, 2015 7:54:10 AM net.sf.jsqlparser.test.select.SpecialOracleTest testAllSqlsParseDeparse
INFO: testing query_factoring08.sql
Oct 06, 2015 7:54:10 AM net.sf.jsqlparser.test.select.SpecialOracleTest testAllSqlsParseDeparse
INFO:    -> SUCCESS
Oct 06, 2015 7:54:10 AM net.sf.jsqlparser.test.select.SpecialOracleTest testAllSqlsParseDeparse
INFO: testing condition04.sql
Oct 06, 2015 7:54:17 AM net.sf.jsqlparser.test.select.SpecialOracleTest testAllSqlsParseDeparse
INFO:    -> SUCCESS
Oct 06, 2015 7:54:17 AM net.sf.jsqlparser.test.select.SpecialOracleTest testAllSqlsParseDeparse
INFO: testing xmltable02.sql
Oct 06, 2015 7:54:17 AM net.sf.jsqlparser.test.select.SpecialOracleTest testAllSqlsParseDeparse
INFO:    -> PROBLEM net.sf.jsqlparser.JSQLParserException
Oct 06, 2015 7:54:17 AM net.sf.jsqlparser.test.select.SpecialOracleTest testAllSqlsParseDeparse
INFO: testing for_update08.sql
Oct 06, 2015 7:54:17 AM net.sf.jsqlparser.test.select.SpecialOracleTest testAllSqlsParseDeparse
INFO:    -> PROBLEM net.sf.jsqlparser.JSQLParserException
Oct 06, 2015 7:54:17 AM net.sf.jsqlparser.test.select.SpecialOracleTest testAllSqlsParseDeparse
INFO: testing for_update03.sql
Oct 06, 2015 7:54:17 AM net.sf.jsqlparser.test.select.SpecialOracleTest testAllSqlsParseDeparse
INFO:    -> SUCCESS
Oct 06, 2015 7:54:17 AM net.sf.jsqlparser.test.select.SpecialOracleTest testAllSqlsParseDeparse
INFO: testing condition06.sql
Oct 06, 2015 7:54:17 AM net.sf.jsqlparser.test.select.SpecialOracleTest testAllSqlsParseDeparse
INFO:    -> PROBLEM net.sf.jsqlparser.JSQLParserException
Oct 06, 2015 7:54:17 AM net.sf.jsqlparser.test.select.SpecialOracleTest testAllSqlsParseDeparse
INFO: testing cast_multiset29.sql
Oct 06, 2015 7:54:17 AM net.sf.jsqlparser.test.select.SpecialOracleTest testAllSqlsOnlyParse
INFO: testing comment02.sql
Oct 06, 2015 7:54:17 AM net.sf.jsqlparser.test.select.SpecialOracleTest testAllSqlsOnlyParse
INFO:    -> SUCCESS
Oct 06, 2015 7:54:17 AM net.sf.jsqlparser.test.select.SpecialOracleTest testAllSqlsOnlyParse
INFO: testing numbers02.sql
Oct 06, 2015 7:54:17 AM net.sf.jsqlparser.test.select.SpecialOracleTest testAllSqlsOnlyParse
INFO:    -> SUCCESS
Oct 06, 2015 7:54:17 AM net.sf.jsqlparser.test.select.SpecialOracleTest testAllSqlsOnlyParse
INFO: testing comment01.sql
Oct 06, 2015 7:54:17 AM net.sf.jsqlparser.test.select.SpecialOracleTest testAllSqlsOnlyParse
INFO:    -> SUCCESS
Tests run: 2, Failures: 1, Errors: 0, Skipped: 0, Time elapsed: 7.419 sec <<< FAILURE!
Running net.sf.jsqlparser.test.select.SelectTest
Tests run: 228, Failures: 94, Errors: 0, Skipped: 0, Time elapsed: 0.253 sec <<< FAILURE!
Running net.sf.jsqlparser.test.select.SpeedTest
42500 statements parsed in 8550 milliseconds
 (4970 statements per second,  0.0002012 seconds per statement )
38500 select scans for table name executed in 140 milliseconds
 (275000 select scans for table name per second,  0.0000036 seconds per select scans for table name)
Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 8.685 sec
Running net.sf.jsqlparser.test.truncate.TruncateTest
Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.002 sec
Running net.sf.jsqlparser.util.TablesNamesFinderTest
Tests run: 19, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.017 sec
Running net.sf.jsqlparser.util.ConnectExpressionsVisitorTest
Tests run: 2, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.004 sec
Running net.sf.jsqlparser.util.AddAliasesVisitorTest
Tests run: 4, Failures: 2, Errors: 0, Skipped: 0, Time elapsed: 0.003 sec <<< FAILURE!
Running net.sf.jsqlparser.util.SelectUtilsTest
Tests run: 6, Failures: 3, 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.002 sec
Running net.sf.jsqlparser.expression.SignedExpressionTest
Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0 sec
Running net.sf.jsqlparser.schema.ServerTest
Tests run: 2, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0 sec
Running net.sf.jsqlparser.parser.CCJSqlParserUtilTest
Tests run: 3, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.001 sec
Running net.sf.jsqlparser.statement.SetStatementTest
Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.003 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: 0, Errors: 0, Skipped: 0, Time elapsed: 0.001 sec
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:   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_i...> but was:<...est (id INT UNSIGNED[, NOT, NULL, AUTO_INCREMENT string VARCHAR (20) user_id INT UNSIGNED, PRIMARY KEY (id)] FOREIGN KEY (user_i...>
  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[][])>
  testCreateTable3(net.sf.jsqlparser.test.create.CreateTableTest): expected:<..."test" varchar (255)[,] "test2" varchar (25...> but was:<..."test" varchar (255)[] "test2" varchar (25...>
  testCreateTableParams(net.sf.jsqlparser.test.create.CreateTableTest): expected:<...SID VARCHAR (32)) ON[ COMMIT PRESERVE] ROWS> but was:<...SID VARCHAR (32)) ON[, COMMIT, PRESERVE,] ROWS>
  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:<...er varying (255) NOT[] NULL)> but was:<...er varying (255) NOT[,] NULL)>
  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) c, nm, g mycol2 mypar1 mypar2, (23,323,3), asdf, ('23','123'), dasd, PRIMARY KEY (mycol2 mycol)) type, =,] myisam>
  testCreateTablePrimaryKey(net.sf.jsqlparser.test.create.CreateTableTest): expected:<...est (id INT UNSIGNED[ NOT NULL AUTO_INCREMENT, string VARCHAR (20),] user_id INT UNSIGNE...> but was:<...est (id INT UNSIGNED[, NOT, NULL, AUTO_INCREMENT string VARCHAR (20)] user_id INT UNSIGNE...>
  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:<...racter varying (255)[, range character varying (255), start_range integer,] end_range integer)> but was:<...racter varying (255)[ range character varying (255) start_range integer] end_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[,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))>
  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 FO...> but was:<...est (id INT UNSIGNED[, NOT, NULL, AUTO_INCREMENT string VARCHAR (20) user_id INT UNSIGNED, PRIMARY KEY (id)] CONSTRAINT fkIdx FO...>
  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[,not,null,auto_increment string varchar(20)user_id int unsigned,references,ra_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[,not,null,auto_increment string varchar(20)user_id int unsigned,foreign,key,references,ra_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) UNIQUE, KEY,] (id))>
  testCreateTableVeryComplex(net.sf.jsqlparser.test.create.CreateTableTest): expected:<...` 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:<...` 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>
  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) c, nm, g mycol2 mypar1 mypar2, (23,323,3), asdf, ('23','123'), dasd, PRIMARY KEY (mycol2] mycol))>
  testCreateTableInlinePrimaryKey(net.sf.jsqlparser.test.create.CreateTableTest): expected:<...mals (id INT PRIMARY[ KEY NOT] NULL)> but was:<...mals (id INT PRIMARY[, KEY, NOT,] NULL)>
  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 J...> but was:<...TH a AS (SELECT col1[ col3 FROM testtable) SELECT col1 col2] col3 FROM b INNER J...>
  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) c, nm, g mycol2 mypar1 mypar2, (23,323,3), asdf, ('23','123'), dasd, PRIMARY KEY (mycol2 mycol)) type, =,] myisam>
  testCreateTableIfNotExists(net.sf.jsqlparser.test.create.CreateTableTest): expected:<... animals (id INT NOT[] NULL)> but was:<... animals (id INT NOT[,] NULL)>
  testCreateView4(net.sf.jsqlparser.test.create.CreateViewTest): expected:<...EW view2 AS SELECT a[, b,] c FROM testtab INNE...> but was:<...EW view2 AS SELECT a[ b] c FROM testtab INNE...>
  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 b] c 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 a] b FROM testtab>
  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 (a b), (d] e)>
  testInsertWithReturning3(net.sf.jsqlparser.test.insert.InsertTest): expected:<...) RETURNING id AS a1[,] id2 AS a2> but was:<...) RETURNING id AS a1[] id2 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[ name address tel) 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 (?] ?)>
  testRegularInsert(net.sf.jsqlparser.test.insert.InsertTest): expected:<...T INTO mytable (col1[, col2, col3) VALUES (?, 'sadfsd',] 234)> but was:<...T INTO mytable (col1[ col2 col3) VALUES (? 'sadfsd'] 234)>
  testInsertFromSelect(net.sf.jsqlparser.test.insert.InsertTest): expected:<...T INTO mytable (col1[, col2,] col3) SELECT * FROM...> but was:<...T INTO mytable (col1[ col2] col3) SELECT * FROM...>
  testUpdateMultiTable(net.sf.jsqlparser.test.update.UpdateTest): expected:<UPDATE T1[,] T2 SET T1.C2 = T2.C...> but was:<UPDATE T1[] T2 SET T1.C2 = T2.C...>
  testUpdateWithSelect2(net.sf.jsqlparser.test.update.UpdateTest): expected:<...2, col3) = (SELECT a[, b,] c FROM mytable2)> but was:<...2, col3) = (SELECT a[ b] c FROM mytable2)>
  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[ A B) SELECT A_ID A] B FROM b_table>
  testReplaceSyntax2(net.sf.jsqlparser.test.replace.ReplaceTest): expected:<...EPLACE mytable (col1[, col2, col3) VALUES ('as', ?,] 565)> but was:<...EPLACE mytable (col1[ col2 col3) VALUES ('as' ?] 565)>
  testAllSqlsParseDeparse(net.sf.jsqlparser.test.select.SpecialOracleTest): expected:<...inct empsal_ot(ename[,]sal))as empsal_ntt)a...> but was:<...inct empsal_ot(ename[ ]sal))as empsal_ntt)a...>
  testAllConditionSubSelect(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT e1.empno[,] e1.sal FROM emp e1 ...> but was:<SELECT e1.empno[] e1.sal FROM emp e1 ...>
  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:<...table WHERE (trim(a)[, trim(b)) IN (SELECT a,] b FROM mytable2)> but was:<...table WHERE (trim(a)[ trim(b)) IN (SELECT a] b FROM mytable2)>
  testSelectForUpdateOfTable(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT foo.*[,] bar.* FROM foo, bar...> but was:<SELECT foo.*[] bar.* FROM foo, bar...>
  testPostgreSQLRegExpCaseSensitiveMatch(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT a[,] b FROM foo WHERE a ...> but was:<SELECT a[] b FROM foo WHERE a ...>
  testOracleJoin4(net.sf.jsqlparser.test.select.SelectTest): expected:<...abelle1.b(+) IN ('A'[,] 'B')> but was:<...abelle1.b(+) IN ('A'[] 'B')>
  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)>
  testSimpleAdditionsAndSubtractionsWithSigns(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT 1 - 1[, 1 + 1, -1 - 1, -1 + 1, +1 + 1,] +1 - 1 FROM tableNa...> but was:<SELECT 1 - 1[ 1 + 1 -1 - 1 -1 + 1 +1 + 1] +1 - 1 FROM tableNa...>
  testOrderBy(net.sf.jsqlparser.test.select.SelectTest): expected:<...ORDER BY tab1.a DESC[,] tab1.b ASC> but was:<...ORDER BY tab1.a DESC[] tab1.b ASC>
  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>
  testSelectJoinWithComma(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT cb.Genus[,] cb.Species FROM Col...> but was:<SELECT cb.Genus[] cb.Species FROM Col...>
  testAdditionalLettersGerman(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT colä[, colö,] colü FROM testtable...> but was:<SELECT colä[ colö] colü FROM testtable...>
  testMysqlQuote(net.sf.jsqlparser.test.select.SelectTest): expected:<...CT `a.OWNERLASTNAME`[,] `OWNERFIRSTNAME` FR...> but was:<...CT `a.OWNERLASTNAME`[] `OWNERFIRSTNAME` FR...>
  testFirst(net.sf.jsqlparser.test.select.SelectTest): expected:<... 5 alias.columnName1[,] alias.columnName2 F...> but was:<... 5 alias.columnName1[] alias.columnName2 F...>
  testSigns(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT (-(1))[, -(1), (-(columnName)), -(columnName), (-1), -1, (-columnName),] -columnName FROM ta...> but was:<SELECT (-(1))[ -(1) (-(columnName)) -(columnName) (-1) -1 (-columnName)] -columnName FROM ta...>
  testWhere(net.sf.jsqlparser.test.select.SelectTest): expected:<...HERE a / b NOT IN (?[, 's''adf',] 234.2)> but was:<...HERE a / b NOT IN (?[ 's''adf'] 234.2)>
  testRegexpLike1(net.sf.jsqlparser.test.select.SelectTest): expected:<...GEXP_LIKE(first_name[,] '^Ste(v|ph)en$')> but was:<...GEXP_LIKE(first_name[] '^Ste(v|ph)en$')>
  testRegexpLike2(net.sf.jsqlparser.test.select.SelectTest): expected:<...GEXP_LIKE(first_name[,] '^Ste(v|ph)en$') TH...> but was:<...GEXP_LIKE(first_name[] '^Ste(v|ph)en$') TH...>
  testCase(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT a[,] CASE b WHEN 1 THEN ...> but was:<SELECT a[] CASE b WHEN 1 THEN ...>
  testJoin(net.sf.jsqlparser.test.select.SelectTest): expected:<...R JOIN O USING (col1[,] col2) WHERE D.OasSD...> but was:<...R JOIN O USING (col1[] col2) WHERE D.OasSD...>
  testSkip(net.sf.jsqlparser.test.select.SelectTest): expected:<... 5 alias.columnName1[,] alias.columnName2 F...> but was:<... 5 alias.columnName1[] alias.columnName2 F...>
  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 FRO...> but was:<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 FRO...>
  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...> but was:<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...>
  testAnyConditionSubSelect(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT e1.empno[,] e1.sal FROM emp e1 ...> but was:<SELECT e1.empno[] e1.sal FROM emp e1 ...>
  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">
  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 (...> but was:<SELECT a[] row_number() OVER (...>
  testLateral1(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT O.ORDERID[, O.CUSTNAME,] OL.LINETOTAL FROM O...> but was:<SELECT O.ORDERID[ O.CUSTNAME] OL.LINETOTAL FROM O...>
  testLateralComplex1(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT O.ORDERID[, O.CUSTNAME, OL.LINETOTAL, OC.ORDCHGTOTAL,] OT.TAXTOTAL FROM OR...> but was:<SELECT O.ORDERID[ O.CUSTNAME OL.LINETOTAL OC.ORDCHGTOTAL] OT.TAXTOTAL FROM OR...>
  testMultiValueIn(net.sf.jsqlparser.test.select.SelectTest): expected:<...ROM mytable WHERE (a[, b, c) IN (SELECT a, b,] c FROM mytable2)> but was:<...ROM mytable WHERE (a[ b c) IN (SELECT a b] c FROM mytable2)>
  testConcatProblem2(net.sf.jsqlparser.test.select.SelectTest): expected:<...ANLEVERPERIODEVOLGNR[, 'FM09'::VARCHAR)) || TO_CHAR((10000 - SPA.VERSCHIJNINGSVOLGNR),] 'FM0999'::VARCHAR))...> but was:<...ANLEVERPERIODEVOLGNR[ 'FM09'::VARCHAR)) || TO_CHAR((10000 - SPA.VERSCHIJNINGSVOLGNR)] 'FM0999'::VARCHAR))...>
  testBitwise(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT col1 & 32[, col2 ^ col1,] col1 | col2 FROM ta...> but was:<SELECT col1 & 32[ col2 ^ col1] col1 | col2 FROM ta...>
  testSelectItems(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT myid AS MYID[, mycol, tab.*, schema.tab.*, mytab.mycol2, myschema.mytab.mycol,] myschema.mytab.* FR...> but was:<SELECT myid AS MYID[ mycol tab.* schema.tab.* mytab.mycol2 myschema.mytab.mycol] myschema.mytab.* FR...>
  testFirstWithKeywordLimit(net.sf.jsqlparser.test.select.SelectTest): expected:<... ? alias.columnName1[,] alias.columnName2 F...> but was:<... ? alias.columnName1[] alias.columnName2 F...>
  testGroupConcat(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT student_name[,] GROUP_CONCAT(DISTIN...> but was:<SELECT student_name[] GROUP_CONCAT(DISTIN...>
  testSelectKeepOver(net.sf.jsqlparser.test.select.SelectTest): expected:<...DER BY department_id[,] salary> but was:<...DER BY department_id[] salary>
  testFunctionRight(net.sf.jsqlparser.test.select.SelectTest): expected:<...CT right(table1.col1[,] 4) FROM table1> but was:<...CT right(table1.col1[] 4) FROM table1>
  testWithUnionProblem3(net.sf.jsqlparser.test.select.SelectTest): expected:<...t AS ((SELECT mslink[,] CAST(tablea.fname A...> but was:<...t AS ((SELECT mslink[] CAST(tablea.fname A...>
  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...> but was:<...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...>
  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 t...> but was:<...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 t...>
  testValues4(net.sf.jsqlparser.test.select.SelectTest): expected:<...CT * FROM (VALUES (1[, 2), (3,] 4)) AS test(a, b)> but was:<...CT * FROM (VALUES (1[ 2), (3] 4)) AS test(a, b)>
  testValues5(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT X[, Y FROM (VALUES (0, 'a'), (1,] 'b')) AS MY_TEMP_TA...> but was:<SELECT X[ Y FROM (VALUES (0 'a'), (1] 'b')) AS MY_TEMP_TA...>
  testGroupBy(net.sf.jsqlparser.test.select.SelectTest): expected:<...RE a > 34 GROUP BY 2[,] 3> but was:<...RE a > 34 GROUP BY 2[] 3>
  testPivotFunction(net.sf.jsqlparser.test.select.SelectTest): expected:<...LECT times_purchased[, state_code FROM customers t) PIVOT (count(state_code) FOR state_code IN ('NY', 'CT', 'NJ', 'FL',] 'MO')) ORDER BY tim...> but was:<...LECT times_purchased[ state_code FROM customers t) PIVOT (count(state_code) FOR state_code IN ('NY' 'CT' 'NJ' 'FL'] 'MO')) ORDER BY tim...>
  testConcatProblem2_1(net.sf.jsqlparser.test.select.SelectTest): expected:<...ANLEVERPERIODEVOLGNR[,] 'FM09'::VARCHAR) FR...> but was:<...ANLEVERPERIODEVOLGNR[] 'FM09'::VARCHAR) FR...>
  testConcatProblem2_3(net.sf.jsqlparser.test.select.SelectTest): expected:<...VERSCHIJNINGSVOLGNR)[,] 'FM0999'::VARCHAR) ...> but was:<...VERSCHIJNINGSVOLGNR)[] 'FM0999'::VARCHAR) ...>
  testReplaceAsFunction(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT REPLACE(a[, 'b',] c) FROM tab1> but was:<SELECT REPLACE(a[ 'b'] c) FROM tab1>
  testSelectWithinGroup(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT LISTAGG(col1[,] '##') WITHIN GROUP ...> but was:<SELECT LISTAGG(col1[] '##') WITHIN GROUP ...>
  testProblemSqlAnalytic10Lag(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT a[,] lag(a, 1) OVER (PAR...> but was:<SELECT a[] lag(a, 1) OVER (PAR...>
  testProblemSqlAnalytic11Lag(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT a[,] lag(a, 1, 0) OVER (...> but was:<SELECT a[] lag(a, 1, 0) OVER (...>
  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.da...> but was:<...id_d_insertion_order[ s.id_d_product_ad_attr trunc(s.date_id] 'mm') ORDER BY s.da...>
  testFunctions(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT MAX(id)[,] AVG(pro) AS myavg F...> but was:<SELECT MAX(id)[] AVG(pro) AS myavg F...>
  testSelectOrderHaving(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT units[,] count(units) AS num...> but was:<SELECT units[] count(units) AS num...>
  testIssue154_2(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT r.id[, r.uuid, r.name,] r.system_role FROM ...> but was:<SELECT r.id[ r.uuid r.name] r.system_role FROM ...>
  testProblemSqlAnalytic5AggregateColumnValue(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT a[,] sum(b) OVER () AS n...> but was:<SELECT a[] sum(b) OVER () AS n...>
  testFunctionLeft(net.sf.jsqlparser.test.select.SelectTest): expected:<...ECT left(table1.col1[,] 4) FROM table1> but was:<...ECT left(table1.col1[] 4) FROM table1>
  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 ...> but was:<...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 ...>
  testProblemSqlAnalytic6AggregateColumnValue(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT a[,] sum(b + 5) OVER (OR...> but was:<SELECT a[] sum(b + 5) OVER (OR...>
  testDistinct(net.sf.jsqlparser.test.select.SelectTest): expected:<...TINCT ON (myid) myid[,] mycol FROM mytable ...> but was:<...TINCT ON (myid) myid[] mycol FROM mytable ...>
  testIssue160_signedParameter(net.sf.jsqlparser.test.select.SelectTest): expected:<...rt_date > DATEADD(HH[, -?,] GETDATE())> but was:<...rt_date > DATEADD(HH[ -?] GETDATE())>
  testInterval2(net.sf.jsqlparser.test.select.SelectTest): expected:<...INTERVAL '45 MINUTE'[,] 'YYYY-MM-DD-HH24:')...> but was:<...INTERVAL '45 MINUTE'[] 'YYYY-MM-DD-HH24:')...>
  testSignedColumns(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT -columnName[, +columnName, +(columnName),] -(columnName) FROM ...> but was:<SELECT -columnName[ +columnName +(columnName)] -(columnName) FROM ...>
  testDouble(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT 1e2[,] * FROM mytable WHER...> but was:<SELECT 1e2[] * FROM mytable WHER...>
  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[ col2 col1 + col2 sum(col8) FROM table1 GROUP BY col1 col2] col1 + col2>
  testHaving(net.sf.jsqlparser.test.select.SelectTest): expected:<...G MAX(tab1.b) IN (56[, 32, 3,] ?)> but was:<...G MAX(tab1.b) IN (56[ 32 3] ?)>
  testIssue154(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT d.id[, d.uuid, d.name, d.amount, d.percentage,] d.modified_time FRO...> but was:<SELECT d.id[ d.uuid d.name d.amount d.percentage] d.modified_time FRO...>
  testDistinctTop(net.sf.jsqlparser.test.select.SelectTest): expected:<... DISTINCT TOP 5 myid[,] mycol FROM mytable ...> but was:<... DISTINCT TOP 5 myid[] mycol FROM mytable ...>
  testTopWithParenthesis(net.sf.jsqlparser.test.select.SelectTest): expected:<...NT alias.columnName1[,] alias.columnName2 F...> but was:<...NT alias.columnName1[] alias.columnName2 F...>
  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:<... FROM t1 WHERE (col1[, col2) = (SELECT col3,] col4 FROM t2 WHERE ...> but was:<... FROM t1 WHERE (col1[ col2) = (SELECT col3] col4 FROM t2 WHERE ...>
  testRowConstructor2(net.sf.jsqlparser.test.select.SelectTest): expected:<...OM t1 WHERE ROW(col1[, col2) = (SELECT col3,] col4 FROM t2 WHERE ...> but was:<...OM t1 WHERE ROW(col1[ col2) = (SELECT col3] col4 FROM t2 WHERE ...>
  testProblemSqlAnalytic2(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT a[,] row_number() OVER (...> but was:<SELECT a[] row_number() OVER (...>
  testProblemSqlAnalytic3(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT a[,] row_number() OVER (...> but was:<SELECT a[] row_number() OVER (...>
  testProblemSqlAnalytic9CommaListPartition(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT a[, row_number() OVER (PARTITION BY c,] d ORDER BY a, b) AS...> but was:<SELECT a[ row_number() OVER (PARTITION BY c] d ORDER BY a, b) AS...>
  testOracleHierarchicalQuery(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT last_name[, employee_id,] manager_id FROM emp...> but was:<SELECT last_name[ employee_id] manager_id FROM emp...>
  testPivot2(net.sf.jsqlparser.test.select.SelectTest): expected:<...ount(a) FOR b IN (10[, 20,] 30))> but was:<...ount(a) FOR b IN (10[ 20] 30))>
  testPivot3(net.sf.jsqlparser.test.select.SelectTest): expected:<...s FOR b IN (10 AS d1[, 20,] 30 AS d3))> but was:<...s FOR b IN (10 AS d1[ 20] 30 AS d3))>
  testPivot4(net.sf.jsqlparser.test.select.SelectTest): expected:<...able PIVOT (count(a)[, sum(b) FOR b IN (10, 20,] 30))> but was:<...able PIVOT (count(a)[ sum(b) FOR b IN (10 20] 30))>
  testPivot5(net.sf.jsqlparser.test.select.SelectTest): expected:<...VOT (count(a) FOR (b[, c) IN ((10, 'a'), (20, 'b'), (30,] 'c')))> but was:<...VOT (count(a) FOR (b[ c) IN ((10 'a') (20 'b') (30] 'c')))>
  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.da...> but was:<...id_d_insertion_order[ s.id_d_product_ad_attr trunc(s.date_id] 'mm') ORDER BY s.da...>
  testDeparser(net.sf.jsqlparser.test.select.SelectTest): expected:<...LECT a.OWNERLASTNAME[,] a.OWNERFIRSTNAME FR...> but was:<...LECT a.OWNERLASTNAME[] a.OWNERFIRSTNAME FR...>
  testPivotXmlSubquery1(net.sf.jsqlparser.test.select.SelectTest): expected:<...LECT times_purchased[, state_code FROM customers t) PIVOT (count(state_code) FOR state_code IN ('NY', 'CT', 'NJ', 'FL',] 'MO')) ORDER BY tim...> but was:<...LECT times_purchased[ state_code FROM customers t) PIVOT (count(state_code) FOR state_code IN ('NY' 'CT' 'NJ' 'FL'] 'MO')) ORDER BY tim...>
  testOracleHierarchicalQuery2(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT employee_id[, last_name,] manager_id FROM emp...> but was:<SELECT employee_id[ last_name] manager_id FROM emp...>
  testOracleHierarchicalQuery3(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT last_name[, employee_id, manager_id,] LEVEL FROM employee...> but was:<SELECT last_name[ employee_id manager_id] LEVEL FROM employee...>
  testOracleHierarchicalQuery4(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT last_name[, employee_id, manager_id,] LEVEL FROM employee...> but was:<SELECT last_name[ employee_id manager_id] LEVEL FROM employee...>
  testProblemSqlAnalytic4EmptyOver(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT a[,] row_number() OVER (...> but was:<SELECT a[] row_number() OVER (...>
  testValues(net.sf.jsqlparser.test.select.SelectTest): expected:<...CT * FROM (VALUES (1[, 2), (3,] 4)) AS test> but was:<...CT * FROM (VALUES (1[ 2), (3] 4)) AS test>
  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) + ...> but was:<...convert(varchar(255)[ DATEDIFF(month year1 abc_datum) / 12) + ' year, ' + convert(varchar(255) DATEDIFF(month year2] abc_datum) % 12) + ...>
  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[ do extract first following last materialized nulls partition range row rows siblings value] xml FROM tableName>
  testSelectJoin(net.sf.jsqlparser.test.select.SelectTest): expected:<...ECT pg_class.relname[, pg_attribute.attname,] pg_constraint.conna...> but was:<...ECT pg_class.relname[ pg_attribute.attname] pg_constraint.conna...>
  testSelectKeep(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT col1[, min(col2) KEEP (DENSE_RANK FIRST ORDER BY col3),] col4 FROM table1 GR...> but was:<SELECT col1[ min(col2) KEEP (DENSE_RANK FIRST ORDER BY col3)] col4 FROM table1 GR...>
  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 A2] c AS A3 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 a1] c 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>
  testBuildSelectFromTableAndParsedExpression(net.sf.jsqlparser.util.SelectUtilsTest): expected:<SELECT a + b[,] test FROM mytable> but was:<SELECT a + b[] test 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: 141, Errors: 0, Skipped: 0

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