[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/util/deparser/ExpressionDeParser.java
[INFO] Scan 164 files header done in 223.725ms.
[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.062 sec
Running net.sf.jsqlparser.test.create.CreateTableTest
Tests run: 27, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.14 sec
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: 0, Errors: 0, Skipped: 0, Time elapsed: 0.015 sec
Running net.sf.jsqlparser.test.delete.DeleteTest
Tests run: 2, Failures: 1, Errors: 0, Skipped: 0, Time elapsed: 0.012 sec <<< FAILURE!
Running net.sf.jsqlparser.test.simpleparsing.CCJSqlParserManagerTest
Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.178 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: 6, Errors: 0, Skipped: 0, Time elapsed: 0.053 sec <<< FAILURE!
Running net.sf.jsqlparser.test.TestUtils
Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.005 sec
Running net.sf.jsqlparser.test.update.UpdateTest
Tests run: 7, Failures: 3, Errors: 0, Skipped: 0, Time elapsed: 0.003 sec <<< FAILURE!
Running net.sf.jsqlparser.test.replace.ReplaceTest
Tests run: 4, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.001 sec
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.009 sec
Running net.sf.jsqlparser.test.select.SpecialOracleTest
Oct 06, 2015 8:37:42 AM net.sf.jsqlparser.test.select.SpecialOracleTest testAllSqlsParseDeparse
INFO: testing string01.sql
Oct 06, 2015 8:37:42 AM net.sf.jsqlparser.test.select.SpecialOracleTest testAllSqlsParseDeparse
INFO:    -> PROBLEM net.sf.jsqlparser.JSQLParserException
Oct 06, 2015 8:37:42 AM net.sf.jsqlparser.test.select.SpecialOracleTest testAllSqlsParseDeparse
INFO: testing returning01.sql
Oct 06, 2015 8:37:42 AM net.sf.jsqlparser.test.select.SpecialOracleTest testAllSqlsParseDeparse
INFO:    -> PROBLEM net.sf.jsqlparser.JSQLParserException
Oct 06, 2015 8:37:42 AM net.sf.jsqlparser.test.select.SpecialOracleTest testAllSqlsParseDeparse
INFO: testing keywordasidentifier05.sql
Oct 06, 2015 8:37:42 AM net.sf.jsqlparser.test.select.SpecialOracleTest testAllSqlsOnlyParse
INFO: testing comment02.sql
Oct 06, 2015 8:37:42 AM net.sf.jsqlparser.test.select.SpecialOracleTest testAllSqlsOnlyParse
INFO:    -> SUCCESS
Oct 06, 2015 8:37:42 AM net.sf.jsqlparser.test.select.SpecialOracleTest testAllSqlsOnlyParse
INFO: testing numbers02.sql
Oct 06, 2015 8:37:42 AM net.sf.jsqlparser.test.select.SpecialOracleTest testAllSqlsOnlyParse
INFO:    -> SUCCESS
Oct 06, 2015 8:37:42 AM net.sf.jsqlparser.test.select.SpecialOracleTest testAllSqlsOnlyParse
INFO: testing comment01.sql
Oct 06, 2015 8:37:42 AM net.sf.jsqlparser.test.select.SpecialOracleTest testAllSqlsOnlyParse
INFO:    -> SUCCESS
Tests run: 2, Failures: 1, Errors: 0, Skipped: 0, Time elapsed: 0.104 sec <<< FAILURE!
Running net.sf.jsqlparser.test.select.SelectTest
Tests run: 228, Failures: 149, Errors: 0, Skipped: 0, Time elapsed: 0.722 sec <<< FAILURE!
Running net.sf.jsqlparser.test.select.SpeedTest
42500 statements parsed in 8316 milliseconds
 (5110 statements per second,  0.0001957 seconds per statement )
38500 select scans for table name executed in 131 milliseconds
 (293893 select scans for table name per second,  0.0000034 seconds per select scans for table name)
Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 8.435 sec
Running net.sf.jsqlparser.test.truncate.TruncateTest
Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.001 sec
Running net.sf.jsqlparser.util.TablesNamesFinderTest
Tests run: 19, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.014 sec
Running net.sf.jsqlparser.util.ConnectExpressionsVisitorTest
Tests run: 2, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.001 sec
Running net.sf.jsqlparser.util.AddAliasesVisitorTest
Tests run: 4, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.001 sec
Running net.sf.jsqlparser.util.SelectUtilsTest
Tests run: 6, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0 sec
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.002 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.002 sec
Running net.sf.jsqlparser.statement.execute.ExecuteTest
Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0 sec

Results :

Failed tests:   testDeleteWhereProblem1(net.sf.jsqlparser.test.delete.DeleteTest): expected:<...ROM tablename WHERE [a = 1 AND ]b = 1> but was:<...ROM tablename WHERE [.a = 1 AND .]b = 1>
  testInsertMultiRowValue(net.sf.jsqlparser.test.insert.InsertTest): expected:<...col1, col2) VALUES ([a, b), (d, ]e)> but was:<...col1, col2) VALUES ([.a, .b), (.d, .]e)>
  testHexValues2(net.sf.jsqlparser.test.insert.InsertTest): expected:<...TABLE2 VALUES ('1', []"DSDD", 0xEFBFBDC7AB...> but was:<...TABLE2 VALUES ('1', [.]"DSDD", 0xEFBFBDC7AB...>
  testHexValues3(net.sf.jsqlparser.test.insert.InsertTest): expected:<...TABLE2 VALUES ('1', []"DSDD", 0xabcde)> but was:<...TABLE2 VALUES ('1', [.]"DSDD", 0xabcde)>
  testHexValues(net.sf.jsqlparser.test.insert.InsertTest): expected:<...TABLE2 VALUES ('1', []"DSDD", x'EFBFBDC7AB...> but was:<...TABLE2 VALUES ('1', [.]"DSDD", x'EFBFBDC7AB...>
  testInsertWithSelect(net.sf.jsqlparser.test.insert.InsertTest): expected:<...) WITH a AS (SELECT [mycolumn FROM mytable) SELECT ]mycolumn FROM a> but was:<...) WITH a AS (SELECT [.mycolumn FROM mytable) SELECT .]mycolumn FROM a>
  testInsertSelect(net.sf.jsqlparser.test.insert.InsertTest): expected:<...e (mycolumn) SELECT []mycolumn FROM mytabl...> but was:<...e (mycolumn) SELECT [.]mycolumn FROM mytabl...>
  testUpdateMultiTable(net.sf.jsqlparser.test.update.UpdateTest): expected:<... T1, T2 SET T1.C2 = [T2.C2, T2.C3 = 'UPDATED' WHERE T1.C1 = T2.C1 AND T1.]C2 < 10> but was:<... T1, T2 SET T1.C2 = [C2, T2.C3 = 'UPDATED' WHERE C1 = C1 AND ]C2 < 10>
  testUpdateWithSelect2(net.sf.jsqlparser.test.update.UpdateTest): expected:<...l2, col3) = (SELECT [a, b, ]c FROM mytable2)> but was:<...l2, col3) = (SELECT [.a, .b, .]c FROM mytable2)>
  testUpdateWithDeparser(net.sf.jsqlparser.test.update.UpdateTest): expected:<...lumna = 'XXX' WHERE [A.]cod_table = 'YYY'> but was:<...lumna = 'XXX' WHERE []cod_table = 'YYY'>
  testAllSqlsParseDeparse(net.sf.jsqlparser.test.select.SpecialOracleTest): expected:<select []exception from excep...> but was:<select [.]exception from excep...>
  testSelectAliasWithoutAs(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT []mycolumn "My Column ...> but was:<SELECT [.]mycolumn "My Column ...>
  testAllConditionSubSelect(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT e[1.empno, e1.sal FROM emp e1 WHERE e1.sal > ALL (SELECT e2.sal FROM emp e2 WHERE e2.]deptno = 10)> but was:<SELECT e[mpno, sal FROM emp e1 WHERE sal > ALL (SELECT sal FROM emp e2 WHERE ]deptno = 10)>
  testMultiValueIn2(net.sf.jsqlparser.test.select.SelectTest): expected:<...mytable WHERE (trim([a), trim(b)) IN (SELECT a, ]b FROM mytable2)> but was:<...mytable WHERE (trim([.a), trim(.b)) IN (SELECT .a, .]b FROM mytable2)>
  testSelectForUpdateOfTable(net.sf.jsqlparser.test.select.SelectTest): expected:<...FROM foo, bar WHERE [foo.id = bar.]foo_id FOR UPDATE OF...> but was:<...FROM foo, bar WHERE [id = ]foo_id FOR UPDATE OF...>
  testPostgreSQLRegExpCaseSensitiveMatch(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [a, b FROM foo WHERE ]a ~ '[help].*'> but was:<SELECT [.a, .b FROM foo WHERE .]a ~ '[help].*'>
  testOracleJoin2(net.sf.jsqlparser.test.select.SelectTest): expected:<...le1, tabelle2 WHERE [tabelle1.a(+) = tabelle2.]b> but was:<...le1, tabelle2 WHERE [a(+) = ]b>
  testOracleJoin3(net.sf.jsqlparser.test.select.SelectTest): expected:<...le1, tabelle2 WHERE [tabelle1.a(+) > tabelle2.]b> but was:<...le1, tabelle2 WHERE [a(+) > ]b>
  testOracleJoin4(net.sf.jsqlparser.test.select.SelectTest): expected:<...le1, tabelle2 WHERE [tabelle1.a(+) = tabelle2.b AND tabelle1.]b(+) IN ('A', 'B')> but was:<...le1, tabelle2 WHERE [a(+) = b AND ]b(+) IN ('A', 'B')>
  testMultiPartTableNameWithSchemaName(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT []columnName FROM sche...> but was:<SELECT [.]columnName FROM sche...>
  testSelectAliasInQuotes(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT []mycolumn AS "My Colu...> but was:<SELECT [.]mycolumn AS "My Colu...>
  testOrderBy(net.sf.jsqlparser.test.select.SelectTest): expected:<...T * FROM tab1 WHERE [a > 34 GROUP BY tab1.b ORDER BY tab1.a DESC, tab1.]b ASC> but was:<...T * FROM tab1 WHERE [.a > 34 GROUP BY b ORDER BY a DESC, ]b ASC>
  testSkipFirst(net.sf.jsqlparser.test.select.SelectTest): expected:<...CT SKIP ?1 FIRST f1 [c1, ]c2 FROM t1> but was:<...CT SKIP ?1 FIRST f1 [.c1, .]c2 FROM t1>
  testMultiPartTableNameWithDatabaseNameAndSchemaName(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT []columnName FROM data...> but was:<SELECT [.]columnName FROM data...>
  testSelectJoinWithComma(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [cb.Genus, cb.Species FROM Coleccion_de_Briofitas AS cb, unigeoestados AS es WHERE es.nombre = "Tamaulipas" AND cb.the_geom = es.]geom> but was:<SELECT [Genus, Species FROM Coleccion_de_Briofitas AS cb, unigeoestados AS es WHERE nombre = ."Tamaulipas" AND the_geom = ]geom>
  testAdditionalLettersGerman(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [colä, colö, ]colü FROM testtableä...> but was:<SELECT [.colä, .colö, .]colü FROM testtableä...>
  testTop(net.sf.jsqlparser.test.select.SelectTest): expected:<... FROM mytable WHERE [mytable.]col = 9> but was:<... FROM mytable WHERE []col = 9>
  testWithUnionProblem(net.sf.jsqlparser.test.select.SelectTest): expected:<...TH test AS ((SELECT [mslink FROM tablea) UNION (SELECT mslink FROM tableb)) SELECT * FROM tablea WHERE mslink IN (SELECT ]mslink FROM test)> but was:<...TH test AS ((SELECT [.mslink FROM tablea) UNION (SELECT .mslink FROM tableb)) SELECT * FROM tablea WHERE .mslink IN (SELECT .]mslink FROM test)>
  testMysqlQuote(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [`a.OWNERLASTNAME`, `OWNERFIRSTNAME` FROM `ANTIQUEOWNERS` AS a, ANTIQUES AS b WHERE b.BUYERID = a.OWNERID AND b.]ITEM = 'Chair'> but was:<SELECT [.`a.OWNERLASTNAME`, .`OWNERFIRSTNAME` FROM `ANTIQUEOWNERS` AS a, ANTIQUES AS b WHERE BUYERID = OWNERID AND ]ITEM = 'Chair'>
  testSelectInnerWith(net.sf.jsqlparser.test.select.SelectTest): expected:<...d FROM DUAL) SELECT []aid FROM actor)> but was:<...d FROM DUAL) SELECT [.]aid FROM actor)>
  testReservedKeyword2(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT []open FROM tableName> but was:<SELECT [.]open FROM tableName>
  testFirst(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT FIRST 5 [alias.columnName1, alias.columnName2 FROM schemaName.tableName alias ORDER BY alias.]columnName2 DESC> but was:<SELECT FIRST 5 [columnName1, columnName2 FROM schemaName.tableName alias ORDER BY ]columnName2 DESC>
  testIlike(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [col1 FROM table1 WHERE ]col1 ILIKE '%hello%'> but was:<SELECT [.col1 FROM table1 WHERE .]col1 ILIKE '%hello%'>
  testIsNot(net.sf.jsqlparser.test.select.SelectTest): expected:<...T * FROM test WHERE []a IS NOT NULL> but was:<...T * FROM test WHERE [.]a IS NOT NULL>
  testLimit(net.sf.jsqlparser.test.select.SelectTest): expected:<... FROM mytable WHERE [mytable.]col = 9 LIMIT ? OFFS...> but was:<... FROM mytable WHERE []col = 9 LIMIT ? OFFS...>
  testSigns(net.sf.jsqlparser.test.select.SelectTest): expected:<...CT (-(1)), -(1), (-([columnName)), -(columnName), (-1), -1, (-columnName), -]columnName FROM tabl...> but was:<...CT (-(1)), -(1), (-([.columnName)), -(.columnName), (-1), -1, (-.columnName), -.]columnName FROM tabl...>
  testUnion(net.sf.jsqlparser.test.select.SelectTest): expected:<... FROM mytable WHERE [mytable.col = 9) UNION (SELECT * FROM mytable3 WHERE mytable3.]col = ?) UNION (SELE...> but was:<... FROM mytable WHERE [col = 9) UNION (SELECT * FROM mytable3 WHERE ]col = ?) UNION (SELE...>
  testWhere(net.sf.jsqlparser.test.select.SelectTest): expected:<([a + b + c / d + e * f) * (a / b * (a + ]b)) > ?> but was:<([.a + .b + .c / .d + .e * .f) * (.a / .b * (.a + .]b)) > ?>
  testRegexpLike1(net.sf.jsqlparser.test.select.SelectTest): expected:<...e WHERE REGEXP_LIKE([]first_name, '^Ste(v|...> but was:<...e WHERE REGEXP_LIKE([.]first_name, '^Ste(v|...>
  testRegexpLike2(net.sf.jsqlparser.test.select.SelectTest): expected:<...SE WHEN REGEXP_LIKE([]first_name, '^Ste(v|...> but was:<...SE WHEN REGEXP_LIKE([.]first_name, '^Ste(v|...>
  testRegexpMySQL(net.sf.jsqlparser.test.select.SelectTest): expected:<... FROM mytable WHERE []first_name REGEXP '^...> but was:<... FROM mytable WHERE [.]first_name REGEXP '^...>
  testCase(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [a, CASE ]b WHEN 1 THEN 2 END ...> but was:<SELECT [.a, CASE .]b WHEN 1 THEN 2 END ...>
  testFrom(net.sf.jsqlparser.test.select.SelectTest): expected:<...) AS mytable4 WHERE [mytable.]col = 9> but was:<...) AS mytable4 WHERE []col = 9>
  testJoin(net.sf.jsqlparser.test.select.SelectTest): expected:<... OUTER JOIN tab2 ON [tab1.id = tab2.]id> but was:<... OUTER JOIN tab2 ON [id = ]id>
  testLike(net.sf.jsqlparser.test.select.SelectTest): expected:<...T * FROM tab1 WHERE []a LIKE 'test'> but was:<...T * FROM tab1 WHERE [.]a LIKE 'test'>
  testSkip(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT SKIP 5 [alias.columnName1, alias.columnName2 FROM schemaName.tableName alias ORDER BY alias.]columnName2 DESC> but was:<SELECT SKIP 5 [columnName1, columnName2 FROM schemaName.tableName alias ORDER BY ]columnName2 DESC>
  testTime(net.sf.jsqlparser.test.select.SelectTest): expected:<...T * FROM tab1 WHERE []a > {t '04:05:34'}> but was:<...T * FROM tab1 WHERE [.]a > {t '04:05:34'}>
  testWith(net.sf.jsqlparser.test.select.SelectTest): expected:<...MPCOUNT) AS (SELECT [OTHERS.WORKDEPT, AVG(OTHERS.SALARY), COUNT(*) FROM EMPLOYEE AS OTHERS GROUP BY OTHERS.WORKDEPT), DINFOMAX AS (SELECT MAX(AVGSALARY) AS AVGMAX FROM DINFO) SELECT THIS_EMP.EMPNO, THIS_EMP.SALARY, DINFO.AVGSALARY, DINFO.EMPCOUNT, DINFOMAX.AVGMAX FROM EMPLOYEE AS THIS_EMP INNER JOIN DINFO INNER JOIN DINFOMAX WHERE THIS_EMP.JOB = 'SALESREP' AND THIS_EMP.WORKDEPT = DINFO.]DEPTNO> but was:<...MPCOUNT) AS (SELECT [WORKDEPT, AVG(SALARY), COUNT(*) FROM EMPLOYEE AS OTHERS GROUP BY WORKDEPT), DINFOMAX AS (SELECT MAX(.AVGSALARY) AS AVGMAX FROM DINFO) SELECT EMPNO, SALARY, AVGSALARY, EMPCOUNT, AVGMAX FROM EMPLOYEE AS THIS_EMP INNER JOIN DINFO INNER JOIN DINFOMAX WHERE JOB = 'SALESREP' AND WORKDEPT = ]DEPTNO>
  testConcatProblem2_5_1(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT ([a || b) || ]c FROM testtable> but was:<SELECT ([.a || .b) || .]c FROM testtable>
  testConcatProblem2_5_2(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT ([a + b) + ]c FROM testtable> but was:<SELECT ([.a + .b) + .]c FROM testtable>
  testProblemSqlAnalytic8Complex(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [ID, NAME, SALARY, SUM(SALARY) OVER () AS SUM_SAL, AVG(SALARY) OVER () AS AVG_SAL, MIN(SALARY) OVER () AS MIN_SAL, MAX(SALARY) OVER () AS MAX_SAL, COUNT(*) OVER () AS ROWS2 FROM STAFF WHERE ID < 60 ORDER BY ]ID> but was:<SELECT [.ID, .NAME, .SALARY, SUM(SALARY) OVER () AS SUM_SAL, AVG(SALARY) OVER () AS AVG_SAL, MIN(SALARY) OVER () AS MIN_SAL, MAX(SALARY) OVER () AS MAX_SAL, COUNT(*) OVER () AS ROWS2 FROM STAFF WHERE .ID < 60 ORDER BY .]ID>
  testWithUnionAllProblem(net.sf.jsqlparser.test.select.SelectTest): expected:<...TH test AS ((SELECT [mslink FROM tablea) UNION ALL (SELECT mslink FROM tableb)) SELECT * FROM tablea WHERE mslink IN (SELECT ]mslink FROM test)> but was:<...TH test AS ((SELECT [.mslink FROM tablea) UNION ALL (SELECT .mslink FROM tableb)) SELECT * FROM tablea WHERE .mslink IN (SELECT .]mslink FROM test)>
  testOracleJoin2_1(net.sf.jsqlparser.test.select.SelectTest): expected:<...lle1,tabelle2 where [tabelle1.a(+)=tabelle2.]b> but was:<...lle1,tabelle2 where [a(+)=]b>
  testOracleJoin2_2(net.sf.jsqlparser.test.select.SelectTest): expected:<...lle1,tabelle2 where [tabelle1.a=tabelle2.]b(+)> but was:<...lle1,tabelle2 where [a=]b(+)>
  testOracleJoin3_1(net.sf.jsqlparser.test.select.SelectTest): expected:<...le1, tabelle2 WHERE [tabelle1.a > tabelle2.]b(+)> but was:<...le1, tabelle2 WHERE [a > ]b(+)>
  testAnyConditionSubSelect(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT e[1.empno, e1.sal FROM emp e1 WHERE e1.sal > ANY (SELECT e2.sal FROM emp e2 WHERE e2.]deptno = 10)> but was:<SELECT e[mpno, sal FROM emp e1 WHERE sal > ANY (SELECT sal FROM emp e2 WHERE ]deptno = 10)>
  testIssue162_doubleUserVar(net.sf.jsqlparser.test.select.SelectTest): expected:<...ELECT @@SPID AS ID, [SYSTEM_USER AS "Login Name", ]USER AS "User Name"> but was:<...ELECT @@SPID AS ID, [.SYSTEM_USER AS "Login Name", .]USER AS "User Name">
  testOrderByNullsFirst(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [a FROM tab1 ORDER BY ]a NULLS FIRST> but was:<SELECT [.a FROM tab1 ORDER BY .]a NULLS FIRST>
  testMultiTableJoin(net.sf.jsqlparser.test.select.SelectTest): expected:<... INNER JOIN tabb ON [taba.a = tabb.a, tabc LEFT JOIN tabd ON tabc.c = tabd.]c> but was:<... INNER JOIN tabb ON [a = a, tabc LEFT JOIN tabd ON c = ]c>
  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 ORDER...> but was:<SELECT O[RDERID, CUSTNAME, ]LINETOTAL FROM ORDER...>
  testSelectNumericBind(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [a FROM b WHERE ]c = :1> but was:<SELECT [.a FROM b WHERE .]c = :1>
  testRegexpBinaryMySQL(net.sf.jsqlparser.test.select.SelectTest): expected:<... FROM mytable WHERE []first_name REGEXP BI...> but was:<... FROM mytable WHERE [.]first_name REGEXP BI...>
  testMultiValueIn(net.sf.jsqlparser.test.select.SelectTest): expected:<...FROM mytable WHERE ([a, b, c) IN (SELECT a, b, ]c FROM mytable2)> but was:<...FROM mytable WHERE ([.a, .b, .c) IN (SELECT .a, .b, .]c FROM mytable2)>
  testConcatProblem2(net.sf.jsqlparser.test.select.SelectTest): expected:<...HAR (4)) || TO_CHAR([SPA.AANLEVERPERIODEVOLGNR, 'FM09'::VARCHAR)) || TO_CHAR((10000 - SPA.]VERSCHIJNINGSVOLGNR)...> but was:<...HAR (4)) || TO_CHAR([AANLEVERPERIODEVOLGNR, 'FM09'::VARCHAR)) || TO_CHAR((10000 - ]VERSCHIJNINGSVOLGNR)...>
  testBitwise(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [col1 & 32, col2 ^ col1, col1 | ]col2 FROM table1> but was:<SELECT [.col1 & 32, .col2 ^ .col1, .col1 | .]col2 FROM table1>
  testSelectItems(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [myid AS MYID, mycol, tab.*, schema.tab.*, mytab.mycol2, myschema.mytab.mycol, myschema.mytab.* FROM mytable WHERE mytable.]col = 9> but was:<SELECT [.myid AS MYID, .mycol, tab.*, schema.tab.*, mycol2, mycol, myschema.mytab.* FROM mytable WHERE ]col = 9>
  testSelectJoin2(net.sf.jsqlparser.test.select.SelectTest): expected:<...pg_constraint WHERE [pg_attribute.attnum = ANY(pg_constraint.]conkey)> but was:<...pg_constraint WHERE [attnum = ANY(]conkey)>
  testBrackets2(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [][a] FROM t> but was:<SELECT [.][a] FROM t>
  testFirstWithKeywordLimit(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT LIMIT ? [alias.columnName1, alias.columnName2 FROM schemaName.tableName alias ORDER BY alias.]columnName2 DESC> but was:<SELECT LIMIT ? [columnName1, columnName2 FROM schemaName.tableName alias ORDER BY ]columnName2 DESC>
  testGroupConcat(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [student_name, GROUP_CONCAT(DISTINCT test_score ORDER BY test_score DESC SEPARATOR ' ') FROM student GROUP BY ]student_name> but was:<SELECT [.student_name, GROUP_CONCAT(DISTINCT test_score ORDER BY test_score DESC SEPARATOR ' ') FROM student GROUP BY .]student_name>
  testWithRecursive(net.sf.jsqlparser.test.select.SelectTest): expected:<...) UNION ALL (SELECT [n + 1 FROM t WHERE n < 100)) SELECT sum(]n) FROM t> but was:<...) UNION ALL (SELECT [.n + 1 FROM t WHERE .n < 100)) SELECT sum(.]n) FROM t>
  testSelectKeepOver(net.sf.jsqlparser.test.select.SelectTest): expected:<... employees ORDER BY [department_id, ]salary> but was:<... employees ORDER BY [.department_id, .]salary>
  testFunctionRight(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT right([table1.]col1, 4) FROM table1> but was:<SELECT right([]col1, 4) FROM table1>
  testMultiPartColumnName(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT []columnName FROM tabl...> but was:<SELECT [.]columnName FROM tabl...>
  testWithUnionProblem3(net.sf.jsqlparser.test.select.SelectTest): expected:<...TH test AS ((SELECT [mslink, CAST(tablea.fname AS varchar) FROM tablea INNER JOIN tableb ON tablea.mslink = tableb.mslink AND tableb.deleted = 0 WHERE tablea.fname IS NULL AND 1 = 0) UNION ALL (SELECT mslink FROM tableb)) SELECT * FROM tablea WHERE mslink IN (SELECT ]mslink FROM test)> but was:<...TH test AS ((SELECT [.mslink, CAST(tablea.fname AS varchar) FROM tablea INNER JOIN tableb ON mslink = mslink AND deleted = 0 WHERE fname IS NULL AND 1 = 0) UNION ALL (SELECT .mslink FROM tableb)) SELECT * FROM tablea WHERE .mslink IN (SELECT .]mslink FROM test)>
  testWithUnionProblem4(net.sf.jsqlparser.test.select.SelectTest): expected:<...TH hist AS ((SELECT [gl.mslink, ba.gl_name AS txt, ba.gl_nummer AS nr, 0 AS level, CAST(gl.mslink AS VARCHAR) AS path, ae.feature FROM tablea AS gl INNER JOIN tableb AS ba ON gl.mslink = ba.gl_mslink INNER JOIN tablec AS ae ON gl.mslink = ae.mslink AND ae.deleted = 0 WHERE gl.parent IS NULL AND gl.mslink <> 0) UNION ALL (SELECT gl.mslink, ba.gl_name AS txt, ba.gl_nummer AS nr, hist.level + 1 AS level, CAST(hist.path + '.' + CAST(gl.mslink AS VARCHAR) AS VARCHAR) AS path, ae.feature FROM tablea AS gl INNER JOIN tableb AS ba ON gl.mslink = ba.gl_mslink INNER JOIN tablec AS ae ON gl.mslink = ae.mslink AND ae.deleted = 0 INNER JOIN hist ON gl.parent = hist.mslink WHERE gl.mslink <> 0)) SELECT mslink, space(level * 4) + txt AS txt, nr, feature, path FROM hist WHERE EXISTS (SELECT feature FROM tablec WHERE mslink = 0 AND ((feature IN (1, 2) AND hist.feature = 3) OR (feature IN (4) AND hist.]feature = 2)))> but was:<...TH hist AS ((SELECT [mslink, gl_name AS txt, gl_nummer AS nr, 0 AS level, CAST(gl.mslink AS VARCHAR) AS path, feature FROM tablea AS gl INNER JOIN tableb AS ba ON mslink = gl_mslink INNER JOIN tablec AS ae ON mslink = mslink AND deleted = 0 WHERE parent IS NULL AND mslink <> 0) UNION ALL (SELECT mslink, gl_name AS txt, gl_nummer AS nr, level + 1 AS level, CAST(hist.path + '.' + CAST(gl.mslink AS VARCHAR) AS VARCHAR) AS path, feature FROM tablea AS gl INNER JOIN tableb AS ba ON mslink = gl_mslink INNER JOIN tablec AS ae ON mslink = mslink AND deleted = 0 INNER JOIN hist ON parent = mslink WHERE 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 feature = 3) OR (.feature IN (4) AND ]feature = 2)))>
  testWithUnionProblem5(net.sf.jsqlparser.test.select.SelectTest): expected:<...TH hist AS ((SELECT [gl.mslink, ba.gl_name AS txt, ba.gl_nummer AS nr, 0 AS level, CAST(gl.mslink AS VARCHAR) AS path, ae.feature FROM tablea AS gl INNER JOIN tableb AS ba ON gl.mslink = ba.gl_mslink INNER JOIN tablec AS ae ON gl.mslink = ae.mslink AND ae.deleted = 0 WHERE gl.parent IS NULL AND gl.mslink <> 0) UNION ALL (SELECT gl.mslink, ba.gl_name AS txt, ba.gl_nummer AS nr, hist.level + 1 AS level, CAST(hist.path + '.' + CAST(gl.mslink AS VARCHAR) AS VARCHAR) AS path, 5 AS feature FROM tablea AS gl INNER JOIN tableb AS ba ON gl.mslink = ba.gl_mslink INNER JOIN tablec AS ae ON gl.mslink = ae.mslink AND ae.deleted = 0 INNER JOIN hist ON gl.parent = hist.mslink WHERE gl.]mslink <> 0)) SELECT...> but was:<...TH hist AS ((SELECT [mslink, gl_name AS txt, gl_nummer AS nr, 0 AS level, CAST(gl.mslink AS VARCHAR) AS path, feature FROM tablea AS gl INNER JOIN tableb AS ba ON mslink = gl_mslink INNER JOIN tablec AS ae ON mslink = mslink AND deleted = 0 WHERE parent IS NULL AND mslink <> 0) UNION ALL (SELECT mslink, gl_name AS txt, gl_nummer AS nr, 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 mslink = gl_mslink INNER JOIN tablec AS ae ON mslink = mslink AND deleted = 0 INNER JOIN hist ON parent = mslink WHERE ]mslink <> 0)) SELECT...>
  testValues5(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [X, ]Y FROM (VALUES (0, '...> but was:<SELECT [.X, .]Y FROM (VALUES (0, '...>
  testGroupBy(net.sf.jsqlparser.test.select.SelectTest): expected:<...T * FROM tab1 WHERE [a > 34 GROUP BY tab1.]b> but was:<...T * FROM tab1 WHERE [.a > 34 GROUP BY ]b>
  testMultiPartColumnNameWithTableName(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [tableName.]columnName FROM tabl...> but was:<SELECT []columnName FROM tabl...>
  testMultiPartTableNameWithDatabaseName(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT []columnName FROM data...> but was:<SELECT [.]columnName FROM data...>
  testLimitSqlServer1(net.sf.jsqlparser.test.select.SelectTest): expected:<... FROM mytable WHERE [mytable.col = 9 ORDER BY mytable.]id OFFSET 3 ROWS FET...> but was:<... FROM mytable WHERE [col = 9 ORDER BY ]id OFFSET 3 ROWS FET...>
  testLimitSqlServer2(net.sf.jsqlparser.test.select.SelectTest): expected:<... FROM mytable WHERE [mytable.col = 9 ORDER BY mytable.]id OFFSET 3 ROW FETC...> but was:<... FROM mytable WHERE [col = 9 ORDER BY ]id OFFSET 3 ROW FETC...>
  testLimitSqlServer3(net.sf.jsqlparser.test.select.SelectTest): expected:<... FROM mytable WHERE [mytable.col = 9 ORDER BY mytable.]id OFFSET 3 ROWS> but was:<... FROM mytable WHERE [col = 9 ORDER BY ]id OFFSET 3 ROWS>
  testLimitSqlServer4(net.sf.jsqlparser.test.select.SelectTest): expected:<... FROM mytable WHERE [mytable.col = 9 ORDER BY mytable.]id FETCH NEXT 5 ROWS...> but was:<... FROM mytable WHERE [col = 9 ORDER BY ]id FETCH NEXT 5 ROWS...>
  testPivotFunction(net.sf.jsqlparser.test.select.SelectTest): expected:<...ECT to_char((SELECT [col1 FROM (SELECT times_purchased, state_code FROM customers t) PIVOT (count(state_code) FOR state_code IN ('NY', 'CT', 'NJ', 'FL', 'MO')) ORDER BY ]times_purchased)) FR...> but was:<...ECT to_char((SELECT [.col1 FROM (SELECT .times_purchased, .state_code FROM customers t) PIVOT (count(state_code) FOR state_code IN ('NY', 'CT', 'NJ', 'FL', 'MO')) ORDER BY .]times_purchased)) FR...>
  testMultiPartTableNameWithServerNameAndDatabaseName(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT []columnName FROM [ser...> but was:<SELECT [.]columnName FROM [ser...>
  testConcatProblem2_1(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT TO_CHAR([SPA.]AANLEVERPERIODEVOLGN...> but was:<SELECT TO_CHAR([]AANLEVERPERIODEVOLGN...>
  testConcatProblem2_3(net.sf.jsqlparser.test.select.SelectTest): expected:<...CT TO_CHAR((10000 - [SPA.]VERSCHIJNINGSVOLGNR)...> but was:<...CT TO_CHAR((10000 - []VERSCHIJNINGSVOLGNR)...>
  testConcatProblem2_5(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT max(([a || b) || ]c) FROM testtable> but was:<SELECT max(([.a || .b) || .]c) FROM testtable>
  testConcatProblem2_6(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT max([a || b || ]c) FROM testtable> but was:<SELECT max([.a || .b || .]c) FROM testtable>
  testMultiPartColumnNameWithDatabaseNameAndSchemaNameAndTableName(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [databaseName.schemaName.tableName.]columnName FROM tabl...> but was:<SELECT []columnName FROM tabl...>
  testMultiPartColumnNameWithDatabaseNameAndTableName(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [databaseName..tableName.]columnName FROM tabl...> but was:<SELECT []columnName FROM tabl...>
  testReplaceAsFunction(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT REPLACE([a, 'b', ]c) FROM tab1> but was:<SELECT REPLACE([.a, 'b', .]c) FROM tab1>
  testSelectJPQLPositionalParameter(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [email FROM users WHERE (type LIKE 'B') AND (]username LIKE ?1)> but was:<SELECT [.email FROM users WHERE (.type LIKE 'B') AND (.]username LIKE ?1)>
  testNotEqualsTo(net.sf.jsqlparser.test.select.SelectTest): expected:<...CT * FROM foo WHERE [a != ]b> but was:<...CT * FROM foo WHERE [.a != .]b>
  testProblemSqlAnalytic10Lag(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT []a, lag(a, 1) OVER (P...> but was:<SELECT [.]a, lag(a, 1) OVER (P...>
  testProblemSqlAnalytic11Lag(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT []a, lag(a, 1, 0) OVER...> but was:<SELECT [.]a, lag(a, 1, 0) OVER...>
  testMatches(net.sf.jsqlparser.test.select.SelectTest): expected:<...T * FROM team WHERE [team.]search_column @@ to_...> but was:<...T * FROM team WHERE []search_column @@ to_...>
  testFunctions(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT MAX([id) AS max FROM mytable WHERE mytable.]col = 9> but was:<SELECT MAX([.id) AS max FROM mytable WHERE ]col = 9>
  testProblemFunction2(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT []sysdate FROM testtab...> but was:<SELECT [.]sysdate FROM testtab...>
  testProblemFunction3(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT TRUNCATE([]col) FROM testtable> but was:<SELECT TRUNCATE([.]col) FROM testtable>
  testSelectOrderHaving(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [units, count(units) AS num FROM currency GROUP BY units HAVING count(units) > 1 ORDER BY ]num> but was:<SELECT [.units, count(.units) AS num FROM currency GROUP BY .units HAVING count(.units) > 1 ORDER BY .]num>
  testMultiPartTableNameWithServerNameAndDatabaseNameAndSchemaName(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT []columnName FROM [ser...> but was:<SELECT [.]columnName FROM [ser...>
  testBrackets(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [table_a.]name AS [Test] FROM ...> but was:<SELECT []name AS [Test] FROM ...>
  testWithStatement(net.sf.jsqlparser.test.select.SelectTest): expected:<...ITH test AS (SELECT [mslink FROM feature) SELECT * FROM feature WHERE mslink IN (SELECT ]mslink FROM test)> but was:<...ITH test AS (SELECT [.mslink FROM feature) SELECT * FROM feature WHERE .mslink IN (SELECT .]mslink FROM test)>
  testIssue154_2(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [r.id, r.uuid, r.name, r.system_role FROM role r WHERE r.merchant_id = ? AND r.deleted_time IS NULL ORDER BY r.]id DESC> but was:<SELECT [id, uuid, name, system_role FROM role r WHERE merchant_id = ? AND deleted_time IS NULL ORDER BY ]id DESC>
  testTimestamp(net.sf.jsqlparser.test.select.SelectTest): expected:<...T * FROM tab1 WHERE []a > {ts '2004-04-30 ...> but was:<...T * FROM tab1 WHERE [.]a > {ts '2004-04-30 ...>
  testProblemSqlAnalytic5AggregateColumnValue(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT []a, sum(b) OVER () AS...> but was:<SELECT [.]a, sum(b) OVER () AS...>
  testMultiPartTableNameWithColumnName(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT []columnName FROM tabl...> but was:<SELECT [.]columnName FROM tabl...>
  testFunctionLeft(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT left([table1.]col1, 4) FROM table1> but was:<SELECT left([]col1, 4) FROM table1>
  testCharacterSetClause(net.sf.jsqlparser.test.select.SelectTest): expected:<...ople `view0` WHERE `[view0`.`]nick2` IS NOT NULL> but was:<...ople `view0` WHERE `[]nick2` IS NOT NULL>
  testComplexUnion1(net.sf.jsqlparser.test.select.SelectTest): expected:<...:varchar, '') AS a, [mytab.b, mytab.c AS st, mytab.d, mytab.e FROM mytab WHERE mytab.del = 0) UNION (SELECT 'cde-' || coalesce(mytab2.a::varchar, '') AS a, mytab2.b, mytab2.bezeichnung AS c, 0 AS d, 0 AS e FROM mytab2 WHERE mytab2.]del = 0)> but was:<...:varchar, '') AS a, [b, c AS st, d, e FROM mytab WHERE del = 0) UNION (SELECT 'cde-' || coalesce(mytab2.a::varchar, '') AS a, b, bezeichnung AS c, 0 AS d, 0 AS e FROM mytab2 WHERE ]del = 0)>
  testProblemSqlAnalytic6AggregateColumnValue(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT []a, sum(b + 5) OVER (...> but was:<SELECT [.]a, sum(b + 5) OVER (...>
  testDistinct(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT DISTINCT ON ([myid) myid, mycol FROM mytable WHERE mytable.]col = 9> but was:<SELECT DISTINCT ON ([.myid) .myid, .mycol FROM mytable WHERE ]col = 9>
  testMultiPartColumnNameWithSchemaNameAndTableName(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [schemaName.tableName.]columnName FROM tabl...> but was:<SELECT []columnName FROM tabl...>
  testMultiPartTableNameWithServerName(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT []columnName FROM [ser...> but was:<SELECT [.]columnName FROM [ser...>
  testIssue160_signedParameter(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [start_date WHERE start_date > DATEADD(]HH, -?, GETDATE())> but was:<SELECT [.start_date WHERE .start_date > DATEADD(.]HH, -?, GETDATE())>
  testConcat(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [a || b || ]c + 4 FROM t> but was:<SELECT [.a || .b || .]c + 4 FROM t>
  testCount2(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT count(ALL [col1 + ]col2) FROM mytable> but was:<SELECT count(ALL [.col1 + .]col2) FROM mytable>
  testSignedColumns(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT -[columnName, +columnName, +(columnName), -(]columnName) FROM tab...> but was:<SELECT -[.columnName, +.columnName, +(.columnName), -(.]columnName) FROM tab...>
  testDouble(net.sf.jsqlparser.test.select.SelectTest): expected:<... FROM mytable WHERE [mytable.]col = 9> but was:<... FROM mytable WHERE []col = 9>
  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:<SELECT MAX([tab1.b) FROM tab1 WHERE a > 34 GROUP BY tab1.b HAVING MAX(tab1.]b) > 56> but was:<SELECT MAX([b) FROM tab1 WHERE .a > 34 GROUP BY b HAVING MAX(]b) > 56>
  testIssue154(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [d.id, d.uuid, d.name, d.amount, d.percentage, d.modified_time FROM discount d LEFT OUTER JOIN discount_category dc ON d.id = dc.discount_id WHERE merchant_id = ? AND deleted = ? AND dc.discount_id IS NULL AND modified_time < ? AND modified_time >= ? ORDER BY ]modified_time> but was:<SELECT [id, uuid, name, amount, percentage, modified_time FROM discount d LEFT OUTER JOIN discount_category dc ON id = discount_id WHERE .merchant_id = ? AND .deleted = ? AND discount_id IS NULL AND .modified_time < ? AND .modified_time >= ? ORDER BY .]modified_time>
  testDistinctTop(net.sf.jsqlparser.test.select.SelectTest): expected:<...LECT DISTINCT TOP 5 [myid, mycol FROM mytable WHERE mytable.]col = 9> but was:<...LECT DISTINCT TOP 5 [.myid, .mycol FROM mytable WHERE ]col = 9>
  testIsNot2(net.sf.jsqlparser.test.select.SelectTest): expected:<...T * FROM test WHERE []a IS NOT NULL> but was:<...T * FROM test WHERE [.]a IS NOT NULL>
  testTopWithParenthesis(net.sf.jsqlparser.test.select.SelectTest): expected:<...ECT TOP (5) PERCENT [alias.columnName1, alias.columnName2 FROM schemaName.tableName alias ORDER BY alias.]columnName2 DESC> but was:<...ECT TOP (5) PERCENT [columnName1, columnName2 FROM schemaName.tableName alias ORDER BY ]columnName2 DESC>
  testSelectOracleColl(net.sf.jsqlparser.test.select.SelectTest): expected:<... the_table tt WHERE [TT.COL1 = lines(]idx).COL1> but was:<... the_table tt WHERE [COL1 = lines(.]idx).COL1>
  testOracleJoin(net.sf.jsqlparser.test.select.SelectTest): expected:<...le1, tabelle2 WHERE [tabelle1.a = tabelle2.]b(+)> but was:<...le1, tabelle2 WHERE [a = ]b(+)>
  testPostgreSQLRegExpCaseSensitiveMatch2(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [a, b FROM foo WHERE ]a ~* '[help].*'> but was:<SELECT [.a, .b FROM foo WHERE .]a ~* '[help].*'>
  testPostgreSQLRegExpCaseSensitiveMatch3(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [a, b FROM foo WHERE ]a !~ '[help].*'> but was:<SELECT [.a, .b FROM foo WHERE .]a !~ '[help].*'>
  testPostgreSQLRegExpCaseSensitiveMatch4(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [a, b FROM foo WHERE ]a !~* '[help].*'> but was:<SELECT [.a, .b FROM foo WHERE .]a !~* '[help].*'>
  testRowConstructor1(net.sf.jsqlparser.test.select.SelectTest): expected:<...CT * FROM t1 WHERE ([col1, col2) = (SELECT col3, col4 FROM t2 WHERE ]id = 10)> but was:<...CT * FROM t1 WHERE ([.col1, .col2) = (SELECT .col3, .col4 FROM t2 WHERE .]id = 10)>
  testRowConstructor2(net.sf.jsqlparser.test.select.SelectTest): expected:<...* FROM t1 WHERE ROW([col1, col2) = (SELECT col3, col4 FROM t2 WHERE ]id = 10)> but was:<...* FROM t1 WHERE ROW([.col1, .col2) = (SELECT .col3, .col4 FROM t2 WHERE .]id = 10)>
  testLimit2(net.sf.jsqlparser.test.select.SelectTest): expected:<... FROM mytable WHERE [mytable.]col = 9 LIMIT ? OFFS...> but was:<... FROM mytable WHERE []col = 9 LIMIT ? OFFS...>
  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...> but was:<SELECT [.]a, row_number() OVER...>
  testSelectWithoutFrom(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT foo[table.foo]column> but was:<SELECT foo[]column>
  testOracleHierarchicalQuery(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [last_name, employee_id, manager_id FROM employees CONNECT BY employee_id = manager_id ORDER BY ]last_name> but was:<SELECT [.last_name, .employee_id, .manager_id FROM employees CONNECT BY employee_id = manager_id ORDER BY .]last_name>
  testDeparser(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [a.OWNERLASTNAME, a.OWNERFIRSTNAME FROM ANTIQUEOWNERS AS a, ANTIQUES AS b WHERE b.BUYERID = a.OWNERID AND b.]ITEM = 'Chair'> but was:<SELECT [OWNERLASTNAME, OWNERFIRSTNAME FROM ANTIQUEOWNERS AS a, ANTIQUES AS b WHERE BUYERID = OWNERID AND ]ITEM = 'Chair'>
  testPivotXmlSubquery1(net.sf.jsqlparser.test.select.SelectTest): expected:<...LECT * FROM (SELECT [times_purchased, state_code FROM customers t) PIVOT (count(state_code) FOR state_code IN ('NY', 'CT', 'NJ', 'FL', 'MO')) ORDER BY ]times_purchased> but was:<...LECT * FROM (SELECT [.times_purchased, .state_code FROM customers t) PIVOT (count(state_code) FOR state_code IN ('NY', 'CT', 'NJ', 'FL', 'MO')) ORDER BY .]times_purchased>
  testOracleHierarchicalQuery2(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [employee_id, last_name, ]manager_id FROM empl...> but was:<SELECT [.employee_id, .last_name, .]manager_id FROM empl...>
  testOracleHierarchicalQuery3(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [last_name, employee_id, manager_id, LEVEL FROM employees START WITH employee_id = 100 CONNECT BY PRIOR employee_id = manager_id ORDER SIBLINGS BY ]last_name> but was:<SELECT [.last_name, .employee_id, .manager_id, .LEVEL FROM employees START WITH employee_id = 100 CONNECT BY PRIOR employee_id = manager_id ORDER SIBLINGS BY .]last_name>
  testOracleHierarchicalQuery4(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [last_name, employee_id, manager_id, LEVEL FROM employees CONNECT BY PRIOR employee_id = manager_id START WITH employee_id = 100 ORDER SIBLINGS BY ]last_name> but was:<SELECT [.last_name, .employee_id, .manager_id, .LEVEL FROM employees CONNECT BY PRIOR employee_id = manager_id START WITH employee_id = 100 ORDER SIBLINGS BY .]last_name>
  testExtractFrom1(net.sf.jsqlparser.test.select.SelectTest): expected:<... EXTRACT(month FROM []datecolumn) FROM tes...> but was:<... EXTRACT(month FROM [.]datecolumn) FROM tes...>
  testProblemSqlAnalytic4EmptyOver(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT []a, row_number() OVER...> but was:<SELECT [.]a, row_number() OVER...>
  testSelectKeywordPercent(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT []percent FROM MY_TABL...> but was:<SELECT [.]percent FROM MY_TABL...>
  testValues6BothVariants(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [I FROM (VALUES 1, 2, 3) AS MY_TEMP_TABLE(I) WHERE ]I IN (SELECT * FROM ...> but was:<SELECT [.I FROM (VALUES 1, 2, 3) AS MY_TEMP_TABLE(I) WHERE .]I IN (SELECT * FROM ...>
  testMultiPartTableNameWithServerNameAndSchemaName(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT []columnName FROM [ser...> but was:<SELECT [.]columnName FROM [ser...>
  testProblemSqlServer_Modulo(net.sf.jsqlparser.test.select.SelectTest): expected:<...char(255), DATEDIFF([month, year1, abc_datum) / 12) + ' year, ' + convert(varchar(255), DATEDIFF(month, year2, ]abc_datum) % 12) + '...> but was:<...char(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>
  testLimitSqlServerJdbcParameters(net.sf.jsqlparser.test.select.SelectTest): expected:<... FROM mytable WHERE [mytable.col = 9 ORDER BY mytable.]id OFFSET ? ROWS FET...> but was:<... FROM mytable WHERE [col = 9 ORDER BY ]id OFFSET ? ROWS FET...>
  testSelectJoin(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [pg_class.relname, pg_attribute.attname, pg_constraint.conname FROM pg_constraint JOIN pg_class ON pg_class.oid = pg_constraint.conrelid JOIN pg_attribute ON pg_attribute.attrelid = pg_constraint.conrelid WHERE pg_constraint.contype = 'u' AND (pg_attribute.attnum = ANY(pg_constraint.conkey)) ORDER BY pg_constraint.]conname> but was:<SELECT [relname, attname, conname FROM pg_constraint JOIN pg_class ON oid = conrelid JOIN pg_attribute ON attrelid = conrelid WHERE contype = 'u' AND (attnum = ANY(conkey)) ORDER BY ]conname>
  testSelectKeep(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [col1, min(col2) KEEP (DENSE_RANK FIRST ORDER BY col3), col4 FROM table1 GROUP BY col5 ORDER BY ]col3> but was:<SELECT [.col1, min(.col2) KEEP (DENSE_RANK FIRST ORDER BY col3), .col4 FROM table1 GROUP BY .col5 ORDER BY .]col3>
  testNamedParameter2(net.sf.jsqlparser.test.select.SelectTest): expected:<... FROM mytable WHERE [a = :param OR a = :param2 AND ]b = :param3> but was:<... FROM mytable WHERE [.a = :param OR .a = :param2 AND .]b = :param3>
  testBooleanFunction1(net.sf.jsqlparser.test.select.SelectTest): expected:<...ble WHERE test_func([]col1)> but was:<...ble WHERE test_func([.]col1)>
  testNamedParameter(net.sf.jsqlparser.test.select.SelectTest): expected:<... FROM mytable WHERE []b = :param> but was:<... FROM mytable WHERE [.]b = :param>

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

[INFO] ------------------------------------------------------------------------
[INFO] BUILD FAILURE
[INFO] ------------------------------------------------------------------------
[INFO] Total time: 16.524s
[INFO] Finished at: Tue Oct 06 08:37:52 CEST 2015
[INFO] Final Memory: 24M/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
