[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.986ms.
[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.056 sec
Running net.sf.jsqlparser.test.create.CreateTableTest
Tests run: 27, Failures: 2, Errors: 0, Skipped: 0, Time elapsed: 0.13 sec <<< FAILURE!
Running net.sf.jsqlparser.test.create.CreateIndexTest
Tests run: 6, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0 sec
Running net.sf.jsqlparser.test.create.CreateViewTest
Tests run: 8, Failures: 8, Errors: 0, Skipped: 0, Time elapsed: 0.007 sec <<< FAILURE!
Running net.sf.jsqlparser.test.delete.DeleteTest
Tests run: 2, Failures: 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.173 sec
Running net.sf.jsqlparser.test.drop.DropTest
Tests run: 2, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.002 sec
Running net.sf.jsqlparser.test.insert.InsertTest
Tests run: 15, Failures: 3, Errors: 0, Skipped: 0, Time elapsed: 0.039 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.007 sec <<< FAILURE!
Running net.sf.jsqlparser.test.replace.ReplaceTest
Tests run: 4, Failures: 1, Errors: 0, Skipped: 0, Time elapsed: 0.003 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:51:28 AM net.sf.jsqlparser.test.select.SpecialOracleTest testAllSqlsParseDeparse
INFO: testing string01.sql
Oct 06, 2015 7:51:28 AM net.sf.jsqlparser.test.select.SpecialOracleTest testAllSqlsParseDeparse
INFO:    -> PROBLEM net.sf.jsqlparser.JSQLParserException
Oct 06, 2015 7:51:28 AM net.sf.jsqlparser.test.select.SpecialOracleTest testAllSqlsParseDeparse
INFO: testing returning01.sql
Oct 06, 2015 7:51:28 AM net.sf.jsqlparser.test.select.SpecialOracleTest testAllSqlsParseDeparse
INFO:    -> PROBLEM net.sf.jsqlparser.JSQLParserException
Oct 06, 2015 7:51:28 AM net.sf.jsqlparser.test.select.SpecialOracleTest testAllSqlsParseDeparse
INFO: testing keywordasidentifier05.sql
Oct 06, 2015 7:51:28 AM net.sf.jsqlparser.test.select.SpecialOracleTest testAllSqlsOnlyParse
INFO: testing comment02.sql
Oct 06, 2015 7:51:28 AM net.sf.jsqlparser.test.select.SpecialOracleTest testAllSqlsOnlyParse
INFO:    -> SUCCESS
Oct 06, 2015 7:51:28 AM net.sf.jsqlparser.test.select.SpecialOracleTest testAllSqlsOnlyParse
INFO: testing numbers02.sql
Oct 06, 2015 7:51:28 AM net.sf.jsqlparser.test.select.SpecialOracleTest testAllSqlsOnlyParse
INFO:    -> SUCCESS
Oct 06, 2015 7:51:28 AM net.sf.jsqlparser.test.select.SpecialOracleTest testAllSqlsOnlyParse
INFO: testing comment01.sql
Oct 06, 2015 7:51:28 AM net.sf.jsqlparser.test.select.SpecialOracleTest testAllSqlsOnlyParse
INFO:    -> SUCCESS
Tests run: 2, Failures: 1, Errors: 0, Skipped: 0, Time elapsed: 0.083 sec <<< FAILURE!
Running net.sf.jsqlparser.test.select.SelectTest
Tests run: 228, Failures: 219, Errors: 0, Skipped: 0, Time elapsed: 0.574 sec <<< FAILURE!
Running net.sf.jsqlparser.test.select.SpeedTest
42500 statements parsed in 8066 milliseconds
 (5269 statements per second,  0.0001898 seconds per statement )
38500 select scans for table name executed in 138 milliseconds
 (278985 select scans for table name per second,  0.0000036 seconds per select scans for table name)
Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 8.19 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.015 sec
Running net.sf.jsqlparser.util.ConnectExpressionsVisitorTest
Tests run: 2, Failures: 2, Errors: 0, Skipped: 0, Time elapsed: 0.002 sec <<< FAILURE!
Running net.sf.jsqlparser.util.AddAliasesVisitorTest
Tests run: 4, Failures: 4, Errors: 0, Skipped: 0, Time elapsed: 0.004 sec <<< FAILURE!
Running net.sf.jsqlparser.util.SelectUtilsTest
Tests run: 6, Failures: 6, Errors: 0, Skipped: 0, Time elapsed: 0.001 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.001 sec
Running net.sf.jsqlparser.parser.CCJSqlParserUtilTest
Tests run: 3, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.001 sec
Running net.sf.jsqlparser.statement.SetStatementTest
Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.004 sec
Running net.sf.jsqlparser.statement.AdaptersTest
Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.002 sec
Running net.sf.jsqlparser.statement.StatementsTest
Tests run: 1, Failures: 1, Errors: 0, Skipped: 0, Time elapsed: 0.001 sec <<< FAILURE!
Running net.sf.jsqlparser.statement.execute.ExecuteTest
Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.001 sec

Results :

Failed tests:   testCreateTableAsSelect(net.sf.jsqlparser.test.create.CreateTableTest): expected:<...AS SELECT col1, col2[ FROM b]> but was:<...AS SELECT col1, col2[]>
  testCreateTableAsSelect2(net.sf.jsqlparser.test.create.CreateTableTest): expected:<...S (SELECT col1, col3[ FROM testtable) SELECT col1, col2, col3 FROM b INNER JOIN a ON b.col1 = a.col1]> but was:<...S (SELECT col1, col3[) SELECT col1, col2, col3]>
  testCreateView2(net.sf.jsqlparser.test.create.CreateViewTest): expected:<...W myview AS SELECT *[ FROM mytab]> but was:<...W myview AS SELECT *[]>
  testCreateView3(net.sf.jsqlparser.test.create.CreateViewTest): expected:<...W myview AS SELECT *[ FROM mytab]> but was:<...W myview AS SELECT *[]>
  testCreateView4(net.sf.jsqlparser.test.create.CreateViewTest): expected:<...w2 AS SELECT a, b, c[ FROM testtab INNER JOIN testtab2 ON testtab.col1 = testtab2.col2]> but was:<...w2 AS SELECT a, b, c[]>
  testCreateView5(net.sf.jsqlparser.test.create.CreateViewTest): expected:<... myview AS (SELECT *[ FROM mytab])> but was:<... myview AS (SELECT *[])>
  testCreateView(net.sf.jsqlparser.test.create.CreateViewTest): expected:<...W myview AS SELECT *[ FROM mytab]> but was:<...W myview AS SELECT *[]>
  testCreateViewUnion(net.sf.jsqlparser.test.create.CreateViewTest): expected:<...iew1 AS (SELECT a, b[ FROM testtab) UNION (SELECT b, c FROM testtab2])> but was:<...iew1 AS (SELECT a, b[) UNION (SELECT b, c])>
  testCreateMaterializedView(net.sf.jsqlparser.test.create.CreateViewTest): expected:<...view1 AS SELECT a, b[ FROM testtab]> but was:<...view1 AS SELECT a, b[]>
  testCreateViewWithColumnNames1(net.sf.jsqlparser.test.create.CreateViewTest): expected:<...col2) AS SELECT a, b[ FROM testtab]> but was:<...col2) AS SELECT a, b[]>
  testInsertFromSelect(net.sf.jsqlparser.test.insert.InsertTest): expected:<...col2, col3) SELECT *[ FROM mytable2]> but was:<...col2, col3) SELECT *[]>
  testInsertWithSelect(net.sf.jsqlparser.test.insert.InsertTest): expected:<... AS (SELECT mycolumn[ FROM mytable) SELECT mycolumn FROM a]> but was:<... AS (SELECT mycolumn[) SELECT mycolumn]>
  testInsertSelect(net.sf.jsqlparser.test.insert.InsertTest): expected:<...umn) SELECT mycolumn[ FROM mytable]> but was:<...umn) SELECT mycolumn[]>
  testUpdateWithSelect2(net.sf.jsqlparser.test.update.UpdateTest): expected:<...3) = (SELECT a, b, c[ FROM mytable2])> but was:<...3) = (SELECT a, b, c[])>
  testUpdateWithSelect(net.sf.jsqlparser.test.update.UpdateTest): expected:<...TIONKEY) = (SELECT ?[ FROM SYSIBM.SYSDUMMY1])> but was:<...TIONKEY) = (SELECT ?[])>
  testProblemReplaceParseDeparse(net.sf.jsqlparser.test.replace.ReplaceTest): expected:<...B) SELECT A_ID, A, B[ FROM b_table]> but was:<...B) SELECT A_ID, A, B[]>
  testAllSqlsParseDeparse(net.sf.jsqlparser.test.select.SpecialOracleTest): expected:<select exception[ from exception]> but was:<select exception[]>
  testSelectAliasWithoutAs(net.sf.jsqlparser.test.select.SelectTest): expected:<...umn "My Column Name"[ FROM mytable]> but was:<...umn "My Column Name"[]>
  testAllConditionSubSelect(net.sf.jsqlparser.test.select.SelectTest): expected:<...CT e1.empno, e1.sal [FROM emp e1 WHERE e1.sal > ALL (SELECT e2.sal FROM emp e2] WHERE e2.deptno = 1...> but was:<...CT e1.empno, e1.sal [WHERE e1.sal > ALL (SELECT e2.sal] WHERE e2.deptno = 1...>
  testSimpleSigns(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT +1, -1[ FROM tableName]> but was:<SELECT +1, -1[]>
  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 * [WHERE (trim(a), trim(b)) IN (SELECT a, b])>
  testSelectForUpdateOfTable(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT foo.*, bar.* [FROM foo, bar WHERE foo.id = bar.foo_id FOR UPDATE OF foo]> but was:<SELECT foo.*, bar.* [WHERE foo.id = bar.foo_id]>
  testPostgreSQLRegExpCaseSensitiveMatch(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT a, b [FROM foo ]WHERE a ~ '[help].*'> but was:<SELECT a, b []WHERE a ~ '[help].*'>
  testOracleJoin2(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT * [FROM tabelle1, tabelle2 ]WHERE tabelle1.a(+) ...> but was:<SELECT * []WHERE tabelle1.a(+) ...>
  testOracleJoin3(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT * [FROM tabelle1, tabelle2 ]WHERE tabelle1.a(+) ...> but was:<SELECT * []WHERE tabelle1.a(+) ...>
  testOracleJoin4(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT * [FROM tabelle1, tabelle2 ]WHERE tabelle1.a(+) ...> but was:<SELECT * []WHERE tabelle1.a(+) ...>
  testMultiPartTableNameWithSchemaName(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT columnName[ FROM schemaName.tableName]> but was:<SELECT columnName[]>
  testSelectBrackets2(net.sf.jsqlparser.test.select.SelectTest): expected:<..., d2)) / 2)::numeric[]> but was:<..., d2)) / 2)::numeric[ FROM null]>
  testSelectBrackets3(net.sf.jsqlparser.test.select.SelectTest): expected:<... d2)) / 2)::numeric)[]> but was:<... d2)) / 2)::numeric)[ FROM null]>
  testSelectBrackets4(net.sf.jsqlparser.test.select.SelectTest): expected:<...ECT (1 / 2)::numeric[]> but was:<...ECT (1 / 2)::numeric[ FROM null]>
  testSimpleAdditionsAndSubtractionsWithSigns(net.sf.jsqlparser.test.select.SelectTest): expected:<... + 1, +1 + 1, +1 - 1[ FROM tableName]> but was:<... + 1, +1 + 1, +1 - 1[]>
  testSelectAliasInQuotes(net.sf.jsqlparser.test.select.SelectTest): expected:<... AS "My Column Name"[ FROM mytable]> but was:<... AS "My Column Name"[]>
  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 * [WHERE a > 34]>
  testCastTypeProblem2(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT col1::varchar[ FROM tabelle1]> but was:<SELECT col1::varchar[]>
  testCastTypeProblem3(net.sf.jsqlparser.test.select.SelectTest): expected:<... col1::varchar (256)[ FROM tabelle1]> but was:<... col1::varchar (256)[]>
  testCastTypeProblem4(net.sf.jsqlparser.test.select.SelectTest): expected:<...ECT 5::varchar (256)[ FROM tabelle1]> but was:<...ECT 5::varchar (256)[]>
  testCastTypeProblem5(net.sf.jsqlparser.test.select.SelectTest): expected:<... 5.67::varchar (256)[ FROM tabelle1]> but was:<... 5.67::varchar (256)[]>
  testCastTypeProblem6(net.sf.jsqlparser.test.select.SelectTest): expected:<...'::character varying[ FROM tabelle1]> but was:<...'::character varying[]>
  testCastTypeProblem7(net.sf.jsqlparser.test.select.SelectTest): expected:<...S character varying)[ FROM tabelle1]> but was:<...S character varying)[]>
  testCastInCast(net.sf.jsqlparser.test.select.SelectTest): expected:<...numeric) AS varchar)[ FROM tabelle1]> but was:<...numeric) AS varchar)[]>
  testSkipFirst(net.sf.jsqlparser.test.select.SelectTest): expected:<...P ?1 FIRST f1 c1, c2[ FROM t1]> but was:<...P ?1 FIRST f1 c1, c2[]>
  testMultiPartTableNameWithDatabaseNameAndSchemaName(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT columnName[ FROM databaseName.schemaName.tableName]> but was:<SELECT columnName[]>
  testSelectJoinWithComma(net.sf.jsqlparser.test.select.SelectTest): expected:<...b.Genus, cb.Species [FROM Coleccion_de_Briofitas AS cb, unigeoestados AS es ]WHERE es.nombre = "T...> but was:<...b.Genus, cb.Species []WHERE es.nombre = "T...>
  testAdditionalLettersGerman(net.sf.jsqlparser.test.select.SelectTest): expected:<...ECT colä, colö, colü[ FROM testtableäöü]> but was:<...ECT colä, colö, colü[]>
  testTop(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT TOP 3 * [FROM mytable ]WHERE mytable.col = ...> but was:<SELECT TOP 3 * []WHERE mytable.col = ...>
  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[) UNION (SELECT mslink)) SELECT * WHERE mslink IN (SELECT mslink])>
  testMysqlQuote(net.sf.jsqlparser.test.select.SelectTest): expected:<...`, `OWNERFIRSTNAME` [FROM `ANTIQUEOWNERS` AS a, ANTIQUES AS b ]WHERE b.BUYERID = a....> but was:<...`, `OWNERFIRSTNAME` []WHERE b.BUYERID = a....>
  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 *[]>
  testReservedKeyword2(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT open[ FROM tableName]> but was:<SELECT open[]>
  testFirst(net.sf.jsqlparser.test.select.SelectTest): expected:<...1, alias.columnName2[ FROM schemaName.tableName alias ORDER BY alias.columnName2 DESC]> but was:<...1, alias.columnName2[]>
  testIlike(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT col1 [FROM table1 ]WHERE col1 ILIKE '%h...> but was:<SELECT col1 []WHERE col1 ILIKE '%h...>
  testIsNot(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT * [FROM test ]WHERE a IS NOT NULL> but was:<SELECT * []WHERE a IS NOT NULL>
  testLimit(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT * [FROM mytable WHERE mytable.col = 9 LIMIT ? OFFSET 3]> but was:<SELECT * [WHERE mytable.col = 9]>
  testSigns(net.sf.jsqlparser.test.select.SelectTest): expected:<...mnName), -columnName[ FROM tableName]> but was:<...mnName), -columnName[]>
  testUnion(net.sf.jsqlparser.test.select.SelectTest): expected:<(SELECT * [FROM mytable WHERE mytable.col = 9) UNION (SELECT * FROM mytable3 WHERE mytable3.col = ?) UNION (SELECT * FROM mytable2 LIMIT 4 OFFSET 3])> but was:<(SELECT * [WHERE mytable.col = 9) UNION (SELECT * WHERE mytable3.col = ?) UNION (SELECT *])>
  testWhere(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT * [FROM tab1 ]WHERE (a + b + c / d...> but was:<SELECT * []WHERE (a + b + c / d...>
  testRegexpLike1(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT * [FROM mytable ]WHERE REGEXP_LIKE(fi...> but was:<SELECT * []WHERE REGEXP_LIKE(fi...>
  testRegexpLike2(net.sf.jsqlparser.test.select.SelectTest): expected:<...') THEN 1 ELSE 2 END[ FROM mytable]> but was:<...') THEN 1 ELSE 2 END[]>
  testRegexpMySQL(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT * [FROM mytable ]WHERE first_name REG...> but was:<SELECT * []WHERE first_name REG...>
  testCase(net.sf.jsqlparser.test.select.SelectTest): expected:<... b WHEN 1 THEN 2 END[ FROM tab1]> but was:<... b WHEN 1 THEN 2 END[]>
  testCast(net.sf.jsqlparser.test.select.SelectTest): expected:<...T CAST(a AS varchar)[ FROM tabelle1]> but was:<...T CAST(a AS varchar)[]>
  testFrom(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT * [FROM mytable AS mytable0, mytable1 alias_tab1, mytable2 AS alias_tab2, (SELECT * FROM mytable3) AS mytable4 ]WHERE mytable.col = ...> but was:<SELECT * []WHERE mytable.col = ...>
  testJoin(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT *[ FROM tab1 LEFT OUTER JOIN tab2 ON tab1.id = tab2.id]> but was:<SELECT *[]>
  testLike(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT * [FROM tab1 ]WHERE a LIKE 'test'> but was:<SELECT * []WHERE a LIKE 'test'>
  testSkip(net.sf.jsqlparser.test.select.SelectTest): expected:<...1, alias.columnName2[ FROM schemaName.tableName alias ORDER BY alias.columnName2 DESC]> but was:<...1, alias.columnName2[]>
  testTime(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT * [FROM tab1 ]WHERE a > {t '04:05:...> but was:<SELECT * []WHERE a > {t '04:05:...>
  testWith(net.sf.jsqlparser.test.select.SelectTest): expected:<...RS.SALARY), COUNT(*)[ FROM EMPLOYEE AS OTHERS GROUP BY OTHERS.WORKDEPT), DINFOMAX AS (SELECT MAX(AVGSALARY) AS AVGMAX FROM DINFO) SELECT THIS_EMP.EMPNO, THIS_EMP.SALARY, DINFO.AVGSALARY, DINFO.EMPCOUNT, DINFOMAX.AVGMAX FROM EMPLOYEE AS THIS_EMP INNER JOIN DINFO INNER JOIN DINFO]MAX WHERE THIS_EMP.J...> but was:<...RS.SALARY), COUNT(*)[), DINFOMAX AS (SELECT MAX(AVGSALARY) AS AVGMAX) SELECT THIS_EMP.EMPNO, THIS_EMP.SALARY, DINFO.AVGSALARY, DINFO.EMPCOUNT, DINFOMAX.AVG]MAX WHERE THIS_EMP.J...>
  testJsonExpression(net.sf.jsqlparser.test.select.SelectTest): expected:<...ail'->'url' AS thumb[ FROM instagram]> but was:<...ail'->'url' AS thumb[]>
  testConcatProblem2_5_1(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT (a || b) || c[ FROM testtable]> but was:<SELECT (a || b) || c[]>
  testConcatProblem2_5_2(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT (a + b) + c[ FROM testtable]> but was:<SELECT (a + b) + c[]>
  testProblemSqlAnalytic8Complex(net.sf.jsqlparser.test.select.SelectTest): expected:<...*) OVER () AS ROWS2 [FROM STAFF WHERE ID < 60 ORDER BY ID]> but was:<...*) OVER () AS ROWS2 [WHERE ID < 60]>
  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[) UNION ALL (SELECT mslink)) SELECT * WHERE mslink IN (SELECT mslink])>
  testOracleJoin2_1(net.sf.jsqlparser.test.select.SelectTest): expected:<select*[from tabelle1,tabelle2 ]where tabelle1.a(+)=...> but was:<select*[]where tabelle1.a(+)=...>
  testOracleJoin2_2(net.sf.jsqlparser.test.select.SelectTest): expected:<select*[from tabelle1,tabelle2 ]where tabelle1.a=tab...> but was:<select*[]where tabelle1.a=tab...>
  testOracleJoin3_1(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT * [FROM tabelle1, tabelle2 ]WHERE tabelle1.a > t...> but was:<SELECT * []WHERE tabelle1.a > t...>
  testAnyConditionSubSelect(net.sf.jsqlparser.test.select.SelectTest): expected:<...CT e1.empno, e1.sal [FROM emp e1 WHERE e1.sal > ANY (SELECT e2.sal FROM emp e2] WHERE e2.deptno = 1...> but was:<...CT e1.empno, e1.sal [WHERE e1.sal > ANY (SELECT e2.sal] WHERE e2.deptno = 1...>
  testPivotXml1(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT *[ FROM mytable PIVOT XML (count(a) FOR b IN ('val1'))]> but was:<SELECT *[]>
  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 *[]>
  testPivotXml3(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT *[ FROM mytable PIVOT XML (count(a) FOR b IN (ANY))]> but was:<SELECT *[]>
  testIssue162_doubleUserVar(net.sf.jsqlparser.test.select.SelectTest): expected:<... USER AS "User Name"[]> but was:<... USER AS "User Name"[ FROM null]>
  testSelectWithBrackets2(net.sf.jsqlparser.test.select.SelectTest): expected:<(SELECT 1[])> but was:<(SELECT 1[ FROM null])>
  testOrderByNullsFirst(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT a[ FROM tab1 ORDER BY a NULLS FIRST]> but was:<SELECT a[]>
  testMultiTableJoin(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT *[ FROM taba INNER JOIN tabb ON taba.a = tabb.a, tabc LEFT JOIN tabd ON tabc.c = tabd.c]> but was:<SELECT *[]>
  testProblemSqlServer_Modulo_mod(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT mod(5, 2)[ FROM A]> but was:<SELECT mod(5, 2)[]>
  testProblemSqlAnalytic(net.sf.jsqlparser.test.select.SelectTest): expected:<...ER (ORDER BY a) AS n[ FROM table1]> but was:<...ER (ORDER BY a) AS n[]>
  testIssue160_signedParameter2(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT * [FROM mytable ]WHERE -? = 5> but was:<SELECT * []WHERE -? = 5>
  testAdditionalLettersSpanish(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT *[ FROM años]> but was:<SELECT *[]>
  testLateral1(net.sf.jsqlparser.test.select.SelectTest): expected:<...STNAME, OL.LINETOTAL[ FROM ORDERS AS O, LATERAL(SELECT SUM(NETAMT) AS LINETOTAL FROM ORDERLINES AS LINES WHERE LINES.ORDERID = O.ORDERID) AS OL]> but was:<...STNAME, OL.LINETOTAL[]>
  testSelectNumericBind(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT a [FROM b ]WHERE c = :1> but was:<SELECT a []WHERE c = :1>
  testRegexpBinaryMySQL(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT * [FROM mytable ]WHERE first_name REG...> but was:<SELECT * []WHERE first_name REG...>
  testLateralComplex1(net.sf.jsqlparser.test.select.SelectTest): expected:<...HGTOTAL, OT.TAXTOTAL[ FROM ORDERS O, LATERAL(SELECT SUM(NETAMT) AS LINETOTAL FROM ORDERLINES LINES WHERE LINES.ORDERID = O.ORDERID) AS OL, LATERAL(SELECT SUM(CHGAMT) AS ORDCHGTOTAL FROM ORDERCHARGES CHARGES WHERE LINES.ORDERID = O.ORDERID) AS OC, LATERAL(SELECT SUM(TAXAMT) AS TAXTOTAL FROM ORDERTAXES TAXES WHERE TAXES.ORDERID = O.ORDERID) AS OT]> but was:<...HGTOTAL, OT.TAXTOTAL[]>
  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 * [WHERE (a, b, c) IN (SELECT a, b, c])>
  testProblemSqlIntersect(net.sf.jsqlparser.test.select.SelectTest): expected:<(SELECT *[ FROM a) INTERSECT (SELECT * FROM b])> but was:<(SELECT *[) INTERSECT (SELECT *])>
  testProblemFunction(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT test()[ FROM testtable]> but was:<SELECT test()[]>
  testConcatProblem2(net.sf.jsqlparser.test.select.SelectTest): expected:<...1))) AS GESLACHT_TMP[ FROM testtable]> but was:<...1))) AS GESLACHT_TMP[]>
  testBitwise(net.sf.jsqlparser.test.select.SelectTest): expected:<... ^ col1, col1 | col2[ FROM table1]> but was:<... ^ col1, col1 | col2[]>
  testSelectInto1(net.sf.jsqlparser.test.select.SelectTest): expected:<...ECT * INTO user_copy[ FROM user]> but was:<...ECT * INTO user_copy[]>
  testSelectItems(net.sf.jsqlparser.test.select.SelectTest): expected:<...l, myschema.mytab.* [FROM mytable ]WHERE mytable.col = ...> but was:<...l, myschema.mytab.* []WHERE mytable.col = ...>
  testSelectJoin2(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT * [FROM pg_constraint ]WHERE pg_attribute.a...> but was:<SELECT * []WHERE pg_attribute.a...>
  testBrackets2(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [a][ FROM t]> but was:<SELECT [a][]>
  testProblemSqlServer_Modulo_Proz(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT 5 % 2[ FROM A]> but was:<SELECT 5 % 2[]>
  testFirstWithKeywordLimit(net.sf.jsqlparser.test.select.SelectTest): expected:<...1, alias.columnName2[ FROM schemaName.tableName alias ORDER BY alias.columnName2 DESC]> but was:<...1, alias.columnName2[]>
  testGroupConcat(net.sf.jsqlparser.test.select.SelectTest): expected:<... DESC SEPARATOR ' ')[ FROM student GROUP BY student_name]> but was:<... DESC SEPARATOR ' ')[]>
  testWithRecursive(net.sf.jsqlparser.test.select.SelectTest): expected:<... t (n) AS ((SELECT 1[) UNION ALL (SELECT n + 1 FROM t WHERE n < 100)) SELECT sum(n) FROM t]> but was:<... t (n) AS ((SELECT 1[ FROM null) UNION ALL (SELECT n + 1 WHERE n < 100)) SELECT sum(n)]>
  testSelectKeepOver(net.sf.jsqlparser.test.select.SelectTest): expected:<...artment_id ) "Worst"[ FROM employees ORDER BY department_id, salary]> but was:<...artment_id ) "Worst"[]>
  testFunctionRight(net.sf.jsqlparser.test.select.SelectTest): expected:<...ight(table1.col1, 4)[ FROM table1]> but was:<...ight(table1.col1, 4)[]>
  testSelectBrackets(net.sf.jsqlparser.test.select.SelectTest): expected:<...((123.250)::numeric)[]> but was:<...((123.250)::numeric)[ FROM null]>
  testMultiPartColumnName(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT columnName[ FROM tableName]> but was:<SELECT columnName[]>
  testWithUnionProblem3(net.sf.jsqlparser.test.select.SelectTest): expected:<...a.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:<...a.fname AS varchar) [WHERE tablea.fname IS NULL AND 1 = 0) UNION ALL (SELECT mslink)) SELECT * WHERE mslink IN (SELECT mslink])>
  testWithUnionProblem4(net.sf.jsqlparser.test.select.SelectTest): expected:<...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 AN...> but was:<...AS path, ae.feature [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 WHERE gl.mslink <> 0)) SELECT mslink, space(level * 4) + txt AS txt, nr, feature, path WHERE EXISTS (SELECT feature] WHERE mslink = 0 AN...>
  testWithUnionProblem5(net.sf.jsqlparser.test.select.SelectTest): expected:<...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:<...AS path, ae.feature [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 WHERE gl.mslink <> 0)) SELECT *]>
  testValues2(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT *[ FROM (VALUES 1, 2, 3, 4) AS test]> but was:<SELECT *[]>
  testValues3(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT *[ FROM (VALUES 1, 2, 3, 4) AS test(a)]> but was:<SELECT *[]>
  testValues4(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT *[ FROM (VALUES (1, 2), (3, 4)) AS test(a, b)]> but was:<SELECT *[]>
  testValues5(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT X, Y[ FROM (VALUES (0, 'a'), (1, 'b')) AS MY_TEMP_TABLE(X, Y)]> but was:<SELECT X, Y[]>
  testGroupBy(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT * [FROM tab1 WHERE a > 34 GROUP BY tab1.b]> but was:<SELECT * [WHERE a > 34]>
  testMultiPartColumnNameWithTableName(net.sf.jsqlparser.test.select.SelectTest): expected:<...tableName.columnName[ FROM tableName]> but was:<...tableName.columnName[]>
  testMultiPartTableNameWithDatabaseName(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT columnName[ FROM databaseName..tableName]> but was:<SELECT columnName[]>
  testLimitSqlServer1(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT * [FROM mytable WHERE mytable.col = 9 ORDER BY mytable.id OFFSET 3 ROWS FETCH NEXT 5 ROWS ONLY]> but was:<SELECT * [WHERE mytable.col = 9]>
  testLimitSqlServer2(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT * [FROM mytable WHERE mytable.col = 9 ORDER BY mytable.id OFFSET 3 ROW FETCH FIRST 5 ROW ONLY]> but was:<SELECT * [WHERE mytable.col = 9]>
  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 * [WHERE mytable.col = 9]>
  testLimitSqlServer4(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT * [FROM mytable WHERE mytable.col = 9 ORDER BY mytable.id FETCH NEXT 5 ROWS ONLY]> but was:<SELECT * [WHERE mytable.col = 9]>
  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[))]>
  testMultiPartTableNameWithServerNameAndDatabaseName(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT columnName[ FROM [server-name\server-instance].databaseName..tableName]> but was:<SELECT columnName[]>
  testConcatProblem2_1(net.sf.jsqlparser.test.select.SelectTest): expected:<...NR, 'FM09'::VARCHAR)[ FROM testtable]> but was:<...NR, 'FM09'::VARCHAR)[]>
  testConcatProblem2_2(net.sf.jsqlparser.test.select.SelectTest): expected:<...(4)) AS GESLACHT_TMP[ FROM testtable]> but was:<...(4)) AS GESLACHT_TMP[]>
  testConcatProblem2_3(net.sf.jsqlparser.test.select.SelectTest): expected:<..., 'FM0999'::VARCHAR)[ FROM testtable]> but was:<..., 'FM0999'::VARCHAR)[]>
  testConcatProblem2_4(net.sf.jsqlparser.test.select.SelectTest): expected:<...SLACHT)::VARCHAR (1)[ FROM testtable]> but was:<...SLACHT)::VARCHAR (1)[]>
  testConcatProblem2_5(net.sf.jsqlparser.test.select.SelectTest): expected:<...T max((a || b) || c)[ FROM testtable]> but was:<...T max((a || b) || c)[]>
  testConcatProblem2_6(net.sf.jsqlparser.test.select.SelectTest): expected:<...ECT max(a || b || c)[ FROM testtable]> but was:<...ECT max(a || b || c)[]>
  testMultiPartColumnNameWithDatabaseNameAndSchemaNameAndTableName(net.sf.jsqlparser.test.select.SelectTest): expected:<...tableName.columnName[ FROM tableName]> but was:<...tableName.columnName[]>
  testMultiPartColumnNameWithDatabaseNameAndTableName(net.sf.jsqlparser.test.select.SelectTest): expected:<...tableName.columnName[ FROM tableName]> but was:<...tableName.columnName[]>
  testReplaceAsFunction(net.sf.jsqlparser.test.select.SelectTest): expected:<...T REPLACE(a, 'b', c)[ FROM tab1]> but was:<...T REPLACE(a, 'b', c)[]>
  testSelectJPQLPositionalParameter(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT email [FROM users ]WHERE (type LIKE 'B'...> but was:<SELECT email []WHERE (type LIKE 'B'...>
  testSelectWithinGroup(net.sf.jsqlparser.test.select.SelectTest): expected:<...ROUP (ORDER BY col1)[ FROM table1]> but was:<...ROUP (ORDER BY col1)[]>
  testNotEqualsTo(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT * [FROM foo ]WHERE a != b> but was:<SELECT * []WHERE a != b>
  testSelectForUpdate(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT *[ FROM user_table FOR UPDATE]> but was:<SELECT *[]>
  testProblemSqlAnalytic10Lag(net.sf.jsqlparser.test.select.SelectTest): expected:<... ORDER BY a, b) AS n[ FROM table1]> but was:<... ORDER BY a, b) AS n[]>
  testProblemSqlAnalytic11Lag(net.sf.jsqlparser.test.select.SelectTest): expected:<... ORDER BY a, b) AS n[ FROM table1]> but was:<... ORDER BY a, b) AS n[]>
  testMatches(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT * [FROM team ]WHERE team.search_co...> but was:<SELECT * []WHERE team.search_co...>
  testAnalyticFunctionProblem1(net.sf.jsqlparser.test.select.SelectTest): expected:<...BY s.date_id) AS col[ FROM s]> but was:<...BY s.date_id) AS col[]>
  testFunctions(net.sf.jsqlparser.test.select.SelectTest): expected:<...LECT MAX(id) AS max [FROM mytable ]WHERE mytable.col = ...> but was:<...LECT MAX(id) AS max []WHERE mytable.col = ...>
  testProblemFunction2(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT sysdate[ FROM testtable]> but was:<SELECT sysdate[]>
  testProblemFunction3(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT TRUNCATE(col)[ FROM testtable]> but was:<SELECT TRUNCATE(col)[]>
  testSelectOrderHaving(net.sf.jsqlparser.test.select.SelectTest): expected:<... count(units) AS num[ FROM currency GROUP BY units HAVING count(units) > 1 ORDER BY num]> but was:<... count(units) AS num[]>
  testAnalyticFunction12(net.sf.jsqlparser.test.select.SelectTest): expected:<...ION BY b ORDER BY c)[ FROM tab1]> but was:<...ION BY b ORDER BY c)[]>
  testAnalyticFunction13(net.sf.jsqlparser.test.select.SelectTest): expected:<...ELECT SUM(a) OVER ()[ FROM tab1]> but was:<...ELECT SUM(a) OVER ()[]>
  testAnalyticFunction14(net.sf.jsqlparser.test.select.SelectTest): expected:<...ER (PARTITION BY b )[ FROM tab1]> but was:<...ER (PARTITION BY b )[]>
  testAnalyticFunction15(net.sf.jsqlparser.test.select.SelectTest): expected:<...a) OVER (ORDER BY c)[ FROM tab1]> but was:<...a) OVER (ORDER BY c)[]>
  testAnalyticFunction16(net.sf.jsqlparser.test.select.SelectTest): expected:<...ER BY c NULLS FIRST)[ FROM tab1]> but was:<...ER BY c NULLS FIRST)[]>
  testAnalyticFunction17(net.sf.jsqlparser.test.select.SelectTest): expected:<...S avg_of_current_sal[ FROM emp]> but was:<...S avg_of_current_sal[]>
  testAnalyticFunction18(net.sf.jsqlparser.test.select.SelectTest): expected:<...S avg_of_current_sal[ FROM emp]> but was:<...S avg_of_current_sal[]>
  testMultiPartTableNameWithServerNameAndDatabaseNameAndSchemaName(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT columnName[ FROM [server-name\server-instance].databaseName.schemaName.tableName]> but was:<SELECT columnName[]>
  testBrackets(net.sf.jsqlparser.test.select.SelectTest): expected:<...ble_a.name AS [Test][ FROM table_a]> but was:<...ble_a.name AS [Test][]>
  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[) SELECT * WHERE mslink IN (SELECT mslink])>
  testIssue154_2(net.sf.jsqlparser.test.select.SelectTest): expected:<...name, r.system_role [FROM role r WHERE r.merchant_id = ? AND r.deleted_time IS NULL ORDER BY r.id DESC]> but was:<...name, r.system_role [WHERE r.merchant_id = ? AND r.deleted_time IS NULL]>
  testTimestamp(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT * [FROM tab1 ]WHERE a > {ts '2004-...> but was:<SELECT * []WHERE a > {ts '2004-...>
  testProblemSqlAnalytic5AggregateColumnValue(net.sf.jsqlparser.test.select.SelectTest): expected:<... sum(b) OVER () AS n[ FROM table1]> but was:<... sum(b) OVER () AS n[]>
  testMultiPartTableNameWithColumnName(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT columnName[ FROM tableName]> but was:<SELECT columnName[]>
  testFunctionLeft(net.sf.jsqlparser.test.select.SelectTest): expected:<...left(table1.col1, 4)[ FROM table1]> but was:<...left(table1.col1, 4)[]>
  testCharacterSetClause(net.sf.jsqlparser.test.select.SelectTest): expected:<...R SET utf8) AS `v0` [FROM people `view0` ]WHERE `view0`.`nick2...> but was:<...R SET utf8) AS `v0` []WHERE `view0`.`nick2...>
  testComplexUnion1(net.sf.jsqlparser.test.select.SelectTest): expected:<...t, mytab.d, mytab.e [FROM mytab WHERE mytab.del = 0) UNION (SELECT 'cde-' || coalesce(mytab2.a::varchar, '') AS a, mytab2.b, mytab2.bezeichnung AS c, 0 AS d, 0 AS e FROM mytab2] WHERE mytab2.del = ...> but was:<...t, mytab.d, mytab.e [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] WHERE mytab2.del = ...>
  testProblemSqlAnalytic6AggregateColumnValue(net.sf.jsqlparser.test.select.SelectTest): expected:<...ER (ORDER BY a) AS n[ FROM table1]> but was:<...ER (ORDER BY a) AS n[]>
  testDistinct(net.sf.jsqlparser.test.select.SelectTest): expected:<... (myid) myid, mycol [FROM mytable ]WHERE mytable.col = ...> but was:<... (myid) myid, mycol []WHERE mytable.col = ...>
  testMultiPartColumnNameWithSchemaNameAndTableName(net.sf.jsqlparser.test.select.SelectTest): expected:<...tableName.columnName[ FROM tableName]> but was:<...tableName.columnName[]>
  testMultiPartTableNameWithServerName(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT columnName[ FROM [server-name\server-instance]...tableName]> but was:<SELECT columnName[]>
  testProblemSqlAnalytic7Count(net.sf.jsqlparser.test.select.SelectTest): expected:<...ount(*) OVER () AS n[ FROM table1]> but was:<...ount(*) OVER () AS n[]>
  testSelectFunction(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT 1 + 2 AS sum[]> but was:<SELECT 1 + 2 AS sum[ FROM null]>
  testIssue160_signedParameter(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT start_date []WHERE start_date > D...> but was:<SELECT start_date [FROM null ]WHERE start_date > D...>
  testAllColumnsFromTable(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT tableName.*[ FROM tableName]> but was:<SELECT tableName.*[]>
  testProblemSqlCombinedSets(net.sf.jsqlparser.test.select.SelectTest): expected:<(SELECT *[ FROM a) INTERSECT (SELECT * FROM b) UNION (SELECT * FROM c])> but was:<(SELECT *[) INTERSECT (SELECT *) UNION (SELECT *])>
  testInterval1(net.sf.jsqlparser.test.select.SelectTest): expected:<... + INTERVAL '3 days'[]> but was:<... + INTERVAL '3 days'[ FROM null]>
  testInterval2(net.sf.jsqlparser.test.select.SelectTest): expected:<...24:')) AS START_TIME[ FROM tab1]> but was:<...24:')) AS START_TIME[]>
  testInterval3(net.sf.jsqlparser.test.select.SelectTest): expected:<...5 + INTERVAL '3' day[]> but was:<...5 + INTERVAL '3' day[ FROM null]>
  testInterval4(net.sf.jsqlparser.test.select.SelectTest): expected:<... + INTERVAL 1 SECOND[]> but was:<... + INTERVAL 1 SECOND[ FROM null]>
  testConcat(net.sf.jsqlparser.test.select.SelectTest): expected:<...LECT a || b || c + 4[ FROM t]> but was:<...LECT a || b || c + 4[]>
  testCount2(net.sf.jsqlparser.test.select.SelectTest): expected:<...unt(ALL col1 + col2)[ FROM mytable]> but was:<...unt(ALL col1 + col2)[]>
  testSignedColumns(net.sf.jsqlparser.test.select.SelectTest): expected:<...Name), -(columnName)[ FROM tableName]> but was:<...Name), -(columnName)[]>
  testDouble(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT 1e2, * [FROM mytable ]WHERE mytable.col = ...> but was:<SELECT 1e2, * []WHERE mytable.col = ...>
  testProblemSqlMinus(net.sf.jsqlparser.test.select.SelectTest): expected:<(SELECT *[ FROM a) MINUS (SELECT * FROM b])> but was:<(SELECT *[) MINUS (SELECT *])>
  testExists(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT * [FROM tab1 WHERE EXISTS (SELECT * FROM tab2])> but was:<SELECT * [WHERE EXISTS (SELECT *])>
  testMultiPartTableNameWithServerProblem(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT *[ FROM LINK_100.htsac.dbo.t_transfer_num a]> but was:<SELECT *[]>
  testGroupByExpression(net.sf.jsqlparser.test.select.SelectTest): expected:<...l1 + col2, sum(col8)[ FROM table1 GROUP BY col1, col2, col1 + col2]> but was:<...l1 + col2, sum(col8)[]>
  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) [WHERE a > 34]>
  testIssue154(net.sf.jsqlparser.test.select.SelectTest): expected:<...ge, 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:<...ge, d.modified_time [WHERE merchant_id = ? AND deleted = ? AND dc.discount_id IS NULL AND modified_time < ? AND modified_time >= ?]>
  testDistinctTop(net.sf.jsqlparser.test.select.SelectTest): expected:<...T TOP 5 myid, mycol [FROM mytable ]WHERE mytable.col = ...> but was:<...T TOP 5 myid, mycol []WHERE mytable.col = ...>
  testSelectUserVariable(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT @col[ FROM t1]> but was:<SELECT @col[]>
  testIsNot2(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT * [FROM test ]WHERE a IS NOT NULL> but was:<SELECT * []WHERE a IS NOT NULL>
  testTopWithParenthesis(net.sf.jsqlparser.test.select.SelectTest): expected:<...1, alias.columnName2[ FROM schemaName.tableName alias ORDER BY alias.columnName2 DESC]> but was:<...1, alias.columnName2[]>
  testSelectOracleColl(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT * [FROM the_table tt ]WHERE TT.COL1 = line...> but was:<SELECT * []WHERE TT.COL1 = line...>
  testOracleJoin(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT * [FROM tabelle1, tabelle2 ]WHERE tabelle1.a = t...> but was:<SELECT * []WHERE tabelle1.a = t...>
  testPostgreSQLRegExpCaseSensitiveMatch2(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT a, b [FROM foo ]WHERE a ~* '[help].*...> but was:<SELECT a, b []WHERE a ~* '[help].*...>
  testPostgreSQLRegExpCaseSensitiveMatch3(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT a, b [FROM foo ]WHERE a !~ '[help].*...> but was:<SELECT a, b []WHERE a !~ '[help].*...>
  testPostgreSQLRegExpCaseSensitiveMatch4(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT a, b [FROM foo ]WHERE a !~* '[help]....> but was:<SELECT a, b []WHERE a !~* '[help]....>
  testRowConstructor1(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT * [FROM t1 WHERE (col1, col2) = (SELECT col3, col4 FROM t2] WHERE id = 10)> but was:<SELECT * [WHERE (col1, col2) = (SELECT col3, col4] WHERE id = 10)>
  testRowConstructor2(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT * [FROM t1 WHERE ROW(col1, col2) = (SELECT col3, col4 FROM t2] WHERE id = 10)> but was:<SELECT * [WHERE ROW(col1, col2) = (SELECT col3, col4] WHERE id = 10)>
  testLimit2(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT * [FROM mytable WHERE mytable.col = 9 LIMIT ? OFFSET 3]> but was:<SELECT * [WHERE mytable.col = 9]>
  testTableCrossJoin(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT *[ FROM taba CROSS JOIN tabb]> but was:<SELECT *[]>
  testProblemSqlAnalytic2(net.sf.jsqlparser.test.select.SelectTest): expected:<...(ORDER BY a, b) AS n[ FROM table1]> but was:<...(ORDER BY a, b) AS n[]>
  testProblemSqlAnalytic3(net.sf.jsqlparser.test.select.SelectTest): expected:<... ORDER BY a, b) AS n[ FROM table1]> but was:<... ORDER BY a, b) AS n[]>
  testProblemSqlAnalytic9CommaListPartition(net.sf.jsqlparser.test.select.SelectTest): expected:<... ORDER BY a, b) AS n[ FROM table1]> but was:<... ORDER BY a, b) AS n[]>
  testSelectWithoutFrom(net.sf.jsqlparser.test.select.SelectTest): expected:<...T footable.foocolumn[]> but was:<...T footable.foocolumn[ FROM null]>
  testOracleHierarchicalQuery(net.sf.jsqlparser.test.select.SelectTest): expected:<...loyee_id, manager_id[ FROM employees CONNECT BY employee_id = manager_id ORDER BY last_name]> but was:<...loyee_id, manager_id[]>
  testPivot1(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT *[ FROM mytable PIVOT (count(a) FOR b IN ('val1'))]> but was:<SELECT *[]>
  testPivot2(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT *[ FROM mytable PIVOT (count(a) FOR b IN (10, 20, 30))]> but was:<SELECT *[]>
  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 *[]>
  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 *[]>
  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 *[]>
  testSelectWithBrackets(net.sf.jsqlparser.test.select.SelectTest): expected:<(SELECT 1[ FROM mytable])> but was:<(SELECT 1[])>
  testAnalyticFunctionProblem1b(net.sf.jsqlparser.test.select.SelectTest): expected:<...ED FOLLOWING) AS col[ FROM s]> but was:<...ED FOLLOWING) AS col[]>
  testDeparser(net.sf.jsqlparser.test.select.SelectTest): expected:<...E, a.OWNERFIRSTNAME [FROM ANTIQUEOWNERS AS a, ANTIQUES AS b ]WHERE b.BUYERID = a....> but was:<...E, a.OWNERFIRSTNAME []WHERE b.BUYERID = a....>
  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 *[]>
  testOracleHierarchicalQuery2(net.sf.jsqlparser.test.select.SelectTest): expected:<...ast_name, manager_id[ FROM employees CONNECT BY PRIOR employee_id = manager_id]> but was:<...ast_name, manager_id[]>
  testOracleHierarchicalQuery3(net.sf.jsqlparser.test.select.SelectTest): expected:<...d, manager_id, LEVEL[ FROM employees START WITH employee_id = 100 CONNECT BY PRIOR employee_id = manager_id ORDER SIBLINGS BY last_name]> but was:<...d, manager_id, LEVEL[]>
  testOracleHierarchicalQuery4(net.sf.jsqlparser.test.select.SelectTest): expected:<...d, manager_id, LEVEL[ FROM employees CONNECT BY PRIOR employee_id = manager_id START WITH employee_id = 100 ORDER SIBLINGS BY last_name]> but was:<...d, manager_id, LEVEL[]>
  testExtractFrom1(net.sf.jsqlparser.test.select.SelectTest): expected:<...nth FROM datecolumn)[ FROM testtable]> but was:<...nth FROM datecolumn)[]>
  testExtractFrom2(net.sf.jsqlparser.test.select.SelectTest): expected:<...ACT(year FROM now())[ FROM testtable]> but was:<...ACT(year FROM now())[]>
  testExtractFrom3(net.sf.jsqlparser.test.select.SelectTest): expected:<...ar FROM (now() - 2))[ FROM testtable]> but was:<...ar FROM (now() - 2))[]>
  testExtractFrom4(net.sf.jsqlparser.test.select.SelectTest): expected:<... now() - '01:22:00')[ FROM testtable]> but was:<... now() - '01:22:00')[]>
  testProblemSqlAnalytic4EmptyOver(net.sf.jsqlparser.test.select.SelectTest): expected:<...umber() OVER () AS n[ FROM table1]> but was:<...umber() OVER () AS n[]>
  testCastTypeProblem(net.sf.jsqlparser.test.select.SelectTest): expected:<...l1 AS varchar (256))[ FROM tabelle1]> but was:<...l1 AS varchar (256))[]>
  testSelectKeywordPercent(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT percent[ FROM MY_TABLE]> but was:<SELECT percent[]>
  testValues(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT *[ FROM (VALUES (1, 2), (3, 4)) AS test]> but was:<SELECT *[]>
  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 [WHERE I IN (SELECT *])>
  testProblemSqlExcept(net.sf.jsqlparser.test.select.SelectTest): expected:<(SELECT *[ FROM a) EXCEPT (SELECT * FROM b])> but was:<(SELECT *[) EXCEPT (SELECT *])>
  testMultiPartTableNameWithServerNameAndSchemaName(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT columnName[ FROM [server-name\server-instance]..schemaName.tableName]> but was:<SELECT columnName[]>
  testProblemSqlServer_Modulo(net.sf.jsqlparser.test.select.SelectTest): expected:<...um) % 12) + ' month'[ FROM test_table]> but was:<...um) % 12) + ' month'[]>
  testReservedKeyword(net.sf.jsqlparser.test.select.SelectTest): expected:<...siblings, value, xml[ FROM tableName]> but was:<...siblings, value, xml[]>
  testLimitSqlServerJdbcParameters(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT * [FROM mytable WHERE mytable.col = 9 ORDER BY mytable.id OFFSET ? ROWS FETCH NEXT ? ROWS ONLY]> but was:<SELECT * [WHERE mytable.col = 9]>
  testSelectJoin(net.sf.jsqlparser.test.select.SelectTest): expected:<..._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:<..._constraint.conname [WHERE pg_constraint.contype = 'u' AND (pg_attribute.attnum = ANY(pg_constraint.conkey))]>
  testSelectKeep(net.sf.jsqlparser.test.select.SelectTest): expected:<...ORDER BY col3), col4[ FROM table1 GROUP BY col5 ORDER BY col3]> but was:<...ORDER BY col3), col4[]>
  testCaseElseAddition(net.sf.jsqlparser.test.select.SelectTest): expected:<...SE 1000 + 1 END AS d[ FROM dual]> but was:<...SE 1000 + 1 END AS d[]>
  testNamedParameter2(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT * [FROM mytable ]WHERE a = :param OR ...> but was:<SELECT * []WHERE a = :param OR ...>
  testBooleanFunction1(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT * [FROM mytable ]WHERE test_func(col1...> but was:<SELECT * []WHERE test_func(col1...>
  testCastInCast2(net.sf.jsqlparser.test.select.SelectTest): expected:<...numeric) AS varchar)[ FROM tabelle1]> but was:<...numeric) AS varchar)[]>
  testNamedParameter(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT * [FROM mytable ]WHERE b = :param> but was:<SELECT * []WHERE b = :param>
  testVisit_PlainSelect_concat(net.sf.jsqlparser.util.ConnectExpressionsVisitorTest): expected:<... a || b || c AS expr[ FROM test]> but was:<... a || b || c AS expr[]>
  testVisit_PlainSelect_addition(net.sf.jsqlparser.util.ConnectExpressionsVisitorTest): expected:<... + b + c AS testexpr[ FROM test]> but was:<... + b + c AS testexpr[]>
  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[) UNION (SELECT 7 + 8 AS A1])>
  testVisit_PlainSelect(net.sf.jsqlparser.util.AddAliasesVisitorTest): expected:<...A1, b AS A2, c AS A3[ FROM test]> but was:<...A1, b AS A2, c AS A3[]>
  testVisit_PlainSelect_expression(net.sf.jsqlparser.util.AddAliasesVisitorTest): expected:<SELECT 3 + 4 AS A1[ FROM test]> but was:<SELECT 3 + 4 AS A1[]>
  testVisit_PlainSelect_duplicates(net.sf.jsqlparser.util.AddAliasesVisitorTest): expected:<...A2, b AS a1, c AS A3[ FROM test]> but was:<...A2, b AS a1, c AS A3[]>
  testBuildSelectFromTableAndExpressions(net.sf.jsqlparser.util.SelectUtilsTest): expected:<SELECT a, b[ FROM mytable]> but was:<SELECT a, b[]>
  testAddExpr(net.sf.jsqlparser.util.SelectUtilsTest): expected:<SELECT a, b[ FROM mytable]> but was:<SELECT a, b[]>
  testAddJoin(net.sf.jsqlparser.util.SelectUtilsTest): expected:<SELECT a[ FROM mytable LEFT JOIN mytable2 ON a = b]> but was:<SELECT a[]>
  testBuildSelectFromTable(net.sf.jsqlparser.util.SelectUtilsTest): expected:<SELECT *[ FROM mytable]> but was:<SELECT *[]>
  testBuildSelectFromTableWithGroupBy(net.sf.jsqlparser.util.SelectUtilsTest): expected:<SELECT *[ FROM mytable GROUP BY b]> but was:<SELECT *[]>
  testBuildSelectFromTableAndParsedExpression(net.sf.jsqlparser.util.SelectUtilsTest): expected:<SELECT a + b, test[ FROM mytable]> but was:<SELECT a + b, test[]>
  testStatements(net.sf.jsqlparser.statement.StatementsTest): expected:<SELECT *[ FROM mytable;

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

[INFO] ------------------------------------------------------------------------
[INFO] BUILD FAILURE
[INFO] ------------------------------------------------------------------------
[INFO] Total time: 15.975s
[INFO] Finished at: Tue Oct 06 07:51:37 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
