[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/schema/Column.java
[INFO] Scan 164 files header done in 223.542ms.
[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.054 sec
Running net.sf.jsqlparser.test.create.CreateTableTest
Tests run: 27, Failures: 2, Errors: 0, Skipped: 0, Time elapsed: 0.143 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: 4, Errors: 0, Skipped: 0, Time elapsed: 0.008 sec <<< FAILURE!
Running net.sf.jsqlparser.test.delete.DeleteTest
Tests run: 2, Failures: 2, Errors: 0, Skipped: 0, Time elapsed: 0.004 sec <<< FAILURE!
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.001 sec
Running net.sf.jsqlparser.test.insert.InsertTest
Tests run: 15, Failures: 14, Errors: 0, Skipped: 0, Time elapsed: 0.044 sec <<< FAILURE!
Running net.sf.jsqlparser.test.TestUtils
Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.001 sec
Running net.sf.jsqlparser.test.update.UpdateTest
Tests run: 7, Failures: 5, Errors: 0, Skipped: 0, Time elapsed: 0.005 sec <<< FAILURE!
Running net.sf.jsqlparser.test.replace.ReplaceTest
Tests run: 4, Failures: 3, Errors: 0, Skipped: 0, Time elapsed: 0.004 sec <<< FAILURE!
Running net.sf.jsqlparser.test.select.SelectASTTest
*Statement
* Column
* Column
* Table
* Column
* Column
Tests run: 2, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.003 sec
Running net.sf.jsqlparser.test.select.SpecialOracleTest
Oct 06, 2015 7:04:54 AM net.sf.jsqlparser.test.select.SpecialOracleTest testAllSqlsParseDeparse
INFO: testing string01.sql
Oct 06, 2015 7:04:54 AM net.sf.jsqlparser.test.select.SpecialOracleTest testAllSqlsParseDeparse
INFO:    -> PROBLEM net.sf.jsqlparser.JSQLParserException
Oct 06, 2015 7:04:54 AM net.sf.jsqlparser.test.select.SpecialOracleTest testAllSqlsParseDeparse
INFO: testing returning01.sql
Oct 06, 2015 7:04:54 AM net.sf.jsqlparser.test.select.SpecialOracleTest testAllSqlsParseDeparse
INFO:    -> PROBLEM net.sf.jsqlparser.JSQLParserException
Oct 06, 2015 7:04:54 AM net.sf.jsqlparser.test.select.SpecialOracleTest testAllSqlsParseDeparse
INFO: testing keywordasidentifier05.sql
Oct 06, 2015 7:04:54 AM net.sf.jsqlparser.test.select.SpecialOracleTest testAllSqlsOnlyParse
INFO: testing comment02.sql
Oct 06, 2015 7:04:54 AM net.sf.jsqlparser.test.select.SpecialOracleTest testAllSqlsOnlyParse
INFO:    -> SUCCESS
Oct 06, 2015 7:04:54 AM net.sf.jsqlparser.test.select.SpecialOracleTest testAllSqlsOnlyParse
INFO: testing numbers02.sql
Oct 06, 2015 7:04:54 AM net.sf.jsqlparser.test.select.SpecialOracleTest testAllSqlsOnlyParse
INFO:    -> SUCCESS
Oct 06, 2015 7:04:54 AM net.sf.jsqlparser.test.select.SpecialOracleTest testAllSqlsOnlyParse
INFO: testing comment01.sql
Oct 06, 2015 7:04:54 AM net.sf.jsqlparser.test.select.SpecialOracleTest testAllSqlsOnlyParse
INFO:    -> SUCCESS
Tests run: 2, Failures: 1, Errors: 0, Skipped: 0, Time elapsed: 0.087 sec <<< FAILURE!
Running net.sf.jsqlparser.test.select.SelectTest
Tests run: 228, Failures: 179, Errors: 0, Skipped: 0, Time elapsed: 0.549 sec <<< FAILURE!
Running net.sf.jsqlparser.test.select.SpeedTest
42500 statements parsed in 7737 milliseconds
 (5493 statements per second,  0.000182 seconds per statement )
38500 select scans for table name executed in 132 milliseconds
 (291666 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: 7.857 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.011 sec
Running net.sf.jsqlparser.util.ConnectExpressionsVisitorTest
Tests run: 2, Failures: 2, Errors: 0, Skipped: 0, Time elapsed: 0.005 sec <<< FAILURE!
Running net.sf.jsqlparser.util.AddAliasesVisitorTest
Tests run: 4, Failures: 2, Errors: 0, Skipped: 0, Time elapsed: 0.002 sec <<< FAILURE!
Running net.sf.jsqlparser.util.SelectUtilsTest
Tests run: 6, Failures: 5, Errors: 0, Skipped: 0, Time elapsed: 0.002 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.001 sec
Running net.sf.jsqlparser.schema.ServerTest
Tests run: 2, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0 sec
Running net.sf.jsqlparser.parser.CCJSqlParserUtilTest
Tests run: 3, Failures: 3, Errors: 0, Skipped: 0, Time elapsed: 0.003 sec <<< FAILURE!
Running net.sf.jsqlparser.statement.SetStatementTest
Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.002 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.001 sec

Results :

Failed tests:   testCreateTableAsSelect(net.sf.jsqlparser.test.create.CreateTableTest): expected:<...E TABLE a AS SELECT [col1, ]col2 FROM b> but was:<...E TABLE a AS SELECT [.col1, .]col2 FROM b>
  testCreateTableAsSelect2(net.sf.jsqlparser.test.create.CreateTableTest): expected:<...S WITH a AS (SELECT [col1, col3 FROM testtable) SELECT col1, col2, col3 FROM b INNER JOIN a ON b.col1 = a.]col1> but was:<...S WITH a AS (SELECT [.col1, .col3 FROM testtable) SELECT .col1, .col2, .col3 FROM b INNER JOIN a ON bcol1 = a]col1>
  testCreateView4(net.sf.jsqlparser.test.create.CreateViewTest): expected:<...IEW view2 AS SELECT [a, b, c FROM testtab INNER JOIN testtab2 ON testtab.col1 = testtab2.]col2> but was:<...IEW view2 AS SELECT [.a, .b, .c FROM testtab INNER JOIN testtab2 ON testtabcol1 = testtab2]col2>
  testCreateViewUnion(net.sf.jsqlparser.test.create.CreateViewTest): expected:<...EW view1 AS (SELECT [a, b FROM testtab) UNION (SELECT b, ]c FROM testtab2)> but was:<...EW view1 AS (SELECT [.a, .b FROM testtab) UNION (SELECT .b, .]c FROM testtab2)>
  testCreateMaterializedView(net.sf.jsqlparser.test.create.CreateViewTest): expected:<...IEW view1 AS SELECT [a, ]b FROM testtab> but was:<...IEW view1 AS SELECT [.a, .]b FROM testtab>
  testCreateViewWithColumnNames1(net.sf.jsqlparser.test.create.CreateViewTest): expected:<...l1, col2) AS SELECT [a, ]b FROM testtab> but was:<...l1, col2) AS SELECT [.a, .]b FROM testtab>
  testDelete(net.sf.jsqlparser.test.delete.DeleteTest): expected:<...ytable WHERE mytable[.]col = 9> but was:<...ytable WHERE mytable[]col = 9>
  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:<...NSERT INTO mytable ([col1, col2) VALUES (a, b), (d, ]e)> but was:<...NSERT INTO mytable ([.col1, .col2) VALUES (.a, .b), (.d, .]e)>
  testInsertWithReturning2(net.sf.jsqlparser.test.insert.InsertTest): expected:<...NSERT INTO mytable ([]mycolumn) VALUES ('1...> but was:<...NSERT INTO mytable ([.]mycolumn) VALUES ('1...>
  testInsertWithReturning3(net.sf.jsqlparser.test.insert.InsertTest): expected:<...NSERT INTO mytable ([mycolumn) VALUES ('1') RETURNING id AS a1, ]id2 AS a2> but was:<...NSERT INTO mytable ([.mycolumn) VALUES ('1') RETURNING .id AS a1, .]id2 AS a2>
  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...>
  testSimpleInsert(net.sf.jsqlparser.test.insert.InsertTest): expected:<...NSERT INTO example ([num, name, address, ]tel) VALUES (1, 'nam...> but was:<...NSERT INTO example ([.num, .name, .address, .]tel) VALUES (1, 'nam...>
  testInsertWithKeywords(net.sf.jsqlparser.test.insert.InsertTest): expected:<INSERT INTO kvPair ([value, ]key) VALUES (?, ?)> but was:<INSERT INTO kvPair ([.value, .]key) VALUES (?, ?)>
  testInsertWithReturning(net.sf.jsqlparser.test.insert.InsertTest): expected:<...NSERT INTO mytable ([mycolumn) VALUES ('1') RETURNING ]id> but was:<...NSERT INTO mytable ([.mycolumn) VALUES ('1') RETURNING .]id>
  testRegularInsert(net.sf.jsqlparser.test.insert.InsertTest): expected:<...NSERT INTO mytable ([col1, col2, ]col3) VALUES (?, 'sa...> but was:<...NSERT INTO mytable ([.col1, .col2, .]col3) VALUES (?, 'sa...>
  testInsertWithKeywordValue(net.sf.jsqlparser.test.insert.InsertTest): expected:<...NSERT INTO mytable ([]col1) VALUES ('val1'...> but was:<...NSERT INTO mytable ([.]col1) VALUES ('val1'...>
  testInsertFromSelect(net.sf.jsqlparser.test.insert.InsertTest): expected:<...NSERT INTO mytable ([col1, col2, ]col3) SELECT * FROM ...> but was:<...NSERT INTO mytable ([.col1, .col2, .]col3) SELECT * FROM ...>
  testInsertWithSelect(net.sf.jsqlparser.test.insert.InsertTest): expected:<...NSERT INTO mytable ([mycolumn) WITH a AS (SELECT mycolumn FROM mytable) SELECT ]mycolumn FROM a> but was:<...NSERT INTO mytable ([.mycolumn) WITH a AS (SELECT .mycolumn FROM mytable) SELECT .]mycolumn FROM a>
  testInsertSelect(net.sf.jsqlparser.test.insert.InsertTest): expected:<...NSERT INTO mytable ([mycolumn) SELECT ]mycolumn FROM mytabl...> but was:<...NSERT INTO mytable ([.mycolumn) SELECT .]mycolumn FROM mytabl...>
  testUpdateWithFrom(net.sf.jsqlparser.test.update.UpdateTest): expected:<UPDATE table1 SET [columna = 5 FROM table1 LEFT JOIN table2 ON col1 = ]col2> but was:<UPDATE table1 SET [.columna = 5 FROM table1 LEFT JOIN table2 ON .col1 = .]col2>
  testUpdateMultiTable(net.sf.jsqlparser.test.update.UpdateTest): expected:<UPDATE T1, T2 SET T1[.C2 = T2.C2, T2.C3 = 'UPDATED' WHERE T1.C1 = T2.C1 AND T1.]C2 < 10> but was:<UPDATE T1, T2 SET T1[C2 = T2C2, T2C3 = 'UPDATED' WHERE T1C1 = T2C1 AND T1]C2 < 10>
  testUpdateWithSelect2(net.sf.jsqlparser.test.update.UpdateTest): expected:<UPDATE mytable SET ([col1, col2, col3) = (SELECT a, b, ]c FROM mytable2)> but was:<UPDATE mytable SET ([.col1, .col2, .col3) = (SELECT .a, .b, .]c FROM mytable2)>
  testUpdateWithSelect(net.sf.jsqlparser.test.update.UpdateTest): expected:<UPDATE NATION SET ([]N_NATIONKEY) = (SELE...> but was:<UPDATE NATION SET ([.]N_NATIONKEY) = (SELE...>
  testUpdateWithDeparser(net.sf.jsqlparser.test.update.UpdateTest): expected:<...TE table1 AS A SET A[.columna = 'XXX' WHERE A.]cod_table = 'YYY'> but was:<...TE table1 AS A SET A[columna = 'XXX' WHERE A]cod_table = 'YYY'>
  testProblemReplaceParseDeparse(net.sf.jsqlparser.test.replace.ReplaceTest): expected:<REPLACE a_table ([ID, A, B) SELECT A_ID, A, ]B FROM b_table> but was:<REPLACE a_table ([.ID, .A, .B) SELECT .A_ID, .A, .]B FROM b_table>
  testReplaceSyntax1(net.sf.jsqlparser.test.replace.ReplaceTest): expected:<REPLACE mytable SET [col1='as', col2=?, ]col3=565> but was:<REPLACE mytable SET [.col1='as', .col2=?, .]col3=565>
  testReplaceSyntax2(net.sf.jsqlparser.test.replace.ReplaceTest): expected:<REPLACE mytable ([col1, col2, ]col3) VALUES ('as', ...> but was:<REPLACE mytable ([.col1, .col2, .]col3) VALUES ('as', ...>
  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 e1[.empno, e1.sal FROM emp e1 WHERE e1.sal > ALL (SELECT e2.sal FROM emp e2 WHERE e2.]deptno = 10)> but was:<SELECT e1[empno, e1sal FROM emp e1 WHERE e1sal > ALL (SELECT e2sal FROM emp e2 WHERE e2]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:<...M foo, bar WHERE foo[.id = bar.]foo_id FOR UPDATE OF...> but was:<...M foo, bar WHERE foo[id = bar]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:<...elle2 WHERE tabelle1[.a(+) = tabelle2.]b> but was:<...elle2 WHERE tabelle1[a(+) = tabelle2]b>
  testOracleJoin3(net.sf.jsqlparser.test.select.SelectTest): expected:<...elle2 WHERE tabelle1[.a(+) > tabelle2.]b> but was:<...elle2 WHERE tabelle1[a(+) > tabelle2]b>
  testOracleJoin4(net.sf.jsqlparser.test.select.SelectTest): expected:<...elle2 WHERE tabelle1[.a(+) = tabelle2.b AND tabelle1.]b(+) IN ('A', 'B')> but was:<...elle2 WHERE tabelle1[a(+) = tabelle2b AND tabelle1]b(+) IN ('A', 'B')>
  testMultiPartTableNameWithSchemaName(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT []columnName FROM sche...> but was:<SELECT [.]columnName FROM sche...>
  testSelectBrackets2(net.sf.jsqlparser.test.select.SelectTest): expected:<...RACT(epoch FROM age([d1, ]d2)) / 2)::numeric> but was:<...RACT(epoch FROM age([.d1, .]d2)) / 2)::numeric>
  testSelectBrackets3(net.sf.jsqlparser.test.select.SelectTest): expected:<...RACT(epoch FROM age([d1, ]d2)) / 2)::numeric)> but was:<...RACT(epoch FROM age([.d1, .]d2)) / 2)::numeric)>
  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:<tab1[.]a> but was:<tab1[]a>
  testCastTypeProblem2(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT []col1::varchar FROM t...> but was:<SELECT [.]col1::varchar FROM t...>
  testCastTypeProblem3(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT []col1::varchar (256) ...> but was:<SELECT [.]col1::varchar (256) ...>
  testCastInCast(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT CAST(CAST([]a AS numeric) AS var...> but was:<SELECT CAST(CAST([.]a AS numeric) AS var...>
  testSkipFirst(net.sf.jsqlparser.test.select.SelectTest): expected:<[]c1> but was:<[.]c1>
  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 cb[Genus, cbSpecies FROM Coleccion_de_Briofitas AS cb, unigeoestados AS es WHERE esnombre = ."Tamaulipas" AND cbthe_geom = es]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:<...ytable WHERE mytable[.]col = 9> but was:<...ytable WHERE mytable[]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 bBUYERID = aOWNERID AND b]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:<alias[.]columnName1> but was:<alias[]columnName1>
  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:<...ytable WHERE mytable[.]col = 9 LIMIT ? OFFS...> but was:<...ytable WHERE mytable[]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:<...ytable WHERE mytable[.col = 9) UNION (SELECT * FROM mytable3 WHERE mytable3.]col = ?) UNION (SELE...> but was:<...ytable WHERE mytable[col = 9) UNION (SELECT * FROM mytable3 WHERE mytable3]col = ?) UNION (SELE...>
  testWhere(net.sf.jsqlparser.test.select.SelectTest): expected:<... * FROM tab1 WHERE ([a + b + c / d + e * f) * (a / b * (a + ]b)) > ?> but was:<... * FROM tab1 WHERE ([.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 ...>
  testCast(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT CAST([]a AS varchar) FROM t...> but was:<SELECT CAST([.]a AS varchar) FROM t...>
  testFrom(net.sf.jsqlparser.test.select.SelectTest): expected:<...table4 WHERE mytable[.]col = 9> but was:<...table4 WHERE mytable[]col = 9>
  testJoin(net.sf.jsqlparser.test.select.SelectTest): expected:<tab1[.]id> but was:<tab1[]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:<alias[.]columnName1> but was:<alias[]columnName1>
  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:<WITH DINFO ([DEPTNO, AVGSALARY, EMPCOUNT) AS (SELECT OTHERS.WORKDEPT, AVG(OTHERS.SALARY), COUNT(*) FROM EMPLOYEE AS OTHERS GROUP BY OTHERS.WORKDEPT), DINFOMAX AS (SELECT MAX(AVGSALARY) AS AVGMAX FROM DINFO) SELECT THIS_EMP.EMPNO, THIS_EMP.SALARY, DINFO.AVGSALARY, DINFO.EMPCOUNT, DINFOMAX.AVGMAX FROM EMPLOYEE AS THIS_EMP INNER JOIN DINFO INNER JOIN DINFOMAX WHERE THIS_EMP.JOB = 'SALESREP' AND THIS_EMP.WORKDEPT = DINFO.]DEPTNO> but was:<WITH DINFO ([.DEPTNO, .AVGSALARY, .EMPCOUNT) AS (SELECT OTHERSWORKDEPT, AVG(OTHERSSALARY), COUNT(*) FROM EMPLOYEE AS OTHERS GROUP BY OTHERSWORKDEPT), DINFOMAX AS (SELECT MAX(.AVGSALARY) AS AVGMAX FROM DINFO) SELECT THIS_EMPEMPNO, THIS_EMPSALARY, DINFOAVGSALARY, DINFOEMPCOUNT, DINFOMAXAVGMAX FROM EMPLOYEE AS THIS_EMP INNER JOIN DINFO INNER JOIN DINFOMAX WHERE THIS_EMPJOB = 'SALESREP' AND THIS_EMPWORKDEPT = DINFO]DEPTNO>
  testJsonExpression(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT []data->'images'->'thu...> but was:<SELECT [.]data->'images'->'thu...>
  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:<...elle2 where tabelle1[.a(+)=tabelle2.]b> but was:<...elle2 where tabelle1[a(+)=tabelle2]b>
  testOracleJoin2_2(net.sf.jsqlparser.test.select.SelectTest): expected:<...elle2 where tabelle1[.a=tabelle2.]b(+)> but was:<...elle2 where tabelle1[a=tabelle2]b(+)>
  testOracleJoin3_1(net.sf.jsqlparser.test.select.SelectTest): expected:<...elle2 WHERE tabelle1[.a > tabelle2.]b(+)> but was:<...elle2 WHERE tabelle1[a > tabelle2]b(+)>
  testAnyConditionSubSelect(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT e1[.empno, e1.sal FROM emp e1 WHERE e1.sal > ANY (SELECT e2.sal FROM emp e2 WHERE e2.]deptno = 10)> but was:<SELECT e1[empno, e1sal FROM emp e1 WHERE e1sal > ANY (SELECT e2sal FROM emp e2 WHERE e2]deptno = 10)>
  testPivotXml1(net.sf.jsqlparser.test.select.SelectTest): expected:<...le PIVOT XML (count([a) FOR ]b IN ('val1'))> but was:<...le PIVOT XML (count([.a) FOR .]b IN ('val1'))>
  testPivotXml2(net.sf.jsqlparser.test.select.SelectTest): expected:<...le PIVOT XML (count([a) FOR b IN (SELECT ]vals FROM myothertab...> but was:<...le PIVOT XML (count([.a) FOR .b IN (SELECT .]vals FROM myothertab...>
  testPivotXml3(net.sf.jsqlparser.test.select.SelectTest): expected:<...le PIVOT XML (count([a) FOR ]b IN (ANY))> but was:<...le PIVOT XML (count([.a) FOR .]b IN (ANY))>
  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:<...ER JOIN tabb ON taba[.a = tabb.a, tabc LEFT JOIN tabd ON tabc.c = tabd.]c> but was:<...ER JOIN tabb ON taba[a = tabba, tabc LEFT JOIN tabd ON tabcc = tabd]c>
  testProblemSqlAnalytic(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [a, row_number() OVER (ORDER BY ]a) AS n FROM table1> but was:<SELECT [.a, row_number() OVER (ORDER BY .]a) AS n FROM table1>
  testLateral1(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT O[.ORDERID, O.CUSTNAME, OL.LINETOTAL FROM ORDERS AS O, LATERAL(SELECT SUM(NETAMT) AS LINETOTAL FROM ORDERLINES AS LINES WHERE LINES.ORDERID = O.]ORDERID) AS OL> but was:<SELECT O[ORDERID, OCUSTNAME, OLLINETOTAL FROM ORDERS AS O, LATERAL(SELECT SUM(.NETAMT) AS LINETOTAL FROM ORDERLINES AS LINES WHERE LINESORDERID = O]ORDERID) AS OL>
  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...>
  testLateralComplex1(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT O[.ORDERID, O.CUSTNAME, OL.LINETOTAL, OC.ORDCHGTOTAL, OT.TAXTOTAL FROM ORDERS O, LATERAL(SELECT SUM(NETAMT) AS LINETOTAL FROM ORDERLINES LINES WHERE LINES.ORDERID = O.ORDERID) AS OL, LATERAL(SELECT SUM(CHGAMT) AS ORDCHGTOTAL FROM ORDERCHARGES CHARGES WHERE LINES.ORDERID = O.ORDERID) AS OC, LATERAL(SELECT SUM(TAXAMT) AS TAXTOTAL FROM ORDERTAXES TAXES WHERE TAXES.ORDERID = O.]ORDERID) AS OT> but was:<SELECT O[ORDERID, OCUSTNAME, OLLINETOTAL, OCORDCHGTOTAL, OTTAXTOTAL FROM ORDERS O, LATERAL(SELECT SUM(.NETAMT) AS LINETOTAL FROM ORDERLINES LINES WHERE LINESORDERID = OORDERID) AS OL, LATERAL(SELECT SUM(.CHGAMT) AS ORDCHGTOTAL FROM ORDERCHARGES CHARGES WHERE LINESORDERID = OORDERID) AS OC, LATERAL(SELECT SUM(.TAXAMT) AS TAXTOTAL FROM ORDERTAXES TAXES WHERE TAXESORDERID = O]ORDERID) AS OT>
  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:<SELECT MAX((((((SPA[.SOORTAANLEVERPERIODE)::VARCHAR (2) || (VARCHAR(SPA.AANLEVERPERIODEJAAR))::VARCHAR (4)) || TO_CHAR(SPA.AANLEVERPERIODEVOLGNR, 'FM09'::VARCHAR)) || TO_CHAR((10000 - SPA.VERSCHIJNINGSVOLGNR), 'FM0999'::VARCHAR)) || (SPA.]GESLACHT)::VARCHAR (...> but was:<SELECT MAX((((((SPA[SOORTAANLEVERPERIODE)::VARCHAR (2) || (VARCHAR(SPAAANLEVERPERIODEJAAR))::VARCHAR (4)) || TO_CHAR(SPAAANLEVERPERIODEVOLGNR, 'FM09'::VARCHAR)) || TO_CHAR((10000 - SPAVERSCHIJNINGSVOLGNR), 'FM0999'::VARCHAR)) || (SPA]GESLACHT)::VARCHAR (...>
  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:<mytab[.]mycol2> but was:<mytab[]mycol2>
  testSelectJoin2(net.sf.jsqlparser.test.select.SelectTest): expected:<...t WHERE pg_attribute[.attnum = ANY(pg_constraint.]conkey)> but was:<...t WHERE pg_attribute[attnum = ANY(pg_constraint]conkey)>
  testBrackets2(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [][a] FROM t> but was:<SELECT [.][a] FROM t>
  testFirstWithKeywordLimit(net.sf.jsqlparser.test.select.SelectTest): expected:<alias[.]columnName1> but was:<alias[]columnName1>
  testGroupConcat(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [student_name, GROUP_CONCAT(DISTINCT test_score ORDER BY test_score DESC SEPARATOR ' ') FROM student GROUP BY ]student_name> but was:<SELECT [.student_name, GROUP_CONCAT(DISTINCT .test_score ORDER BY .test_score DESC SEPARATOR ' ') FROM student GROUP BY .]student_name>
  testWithRecursive(net.sf.jsqlparser.test.select.SelectTest): expected:<WITH RECURSIVE t ([n) AS ((SELECT 1) UNION ALL (SELECT n + 1 FROM t WHERE n < 100)) SELECT sum(]n) FROM t> but was:<WITH RECURSIVE t ([.n) AS ((SELECT 1) UNION ALL (SELECT .n + 1 FROM t WHERE .n < 100)) SELECT sum(.]n) FROM t>
  testSelectKeepOver(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT MIN([salary) KEEP (DENSE_RANK FIRST ORDER BY commission_pct) OVER (PARTITION BY department_id ) "Worst" FROM employees ORDER BY department_id, ]salary> but was:<SELECT MIN([.salary) KEEP (DENSE_RANK FIRST ORDER BY .commission_pct) OVER (PARTITION BY .department_id ) "Worst" FROM 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(table1[]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(tableafname AS varchar) FROM tablea INNER JOIN tableb ON tableamslink = tablebmslink AND tablebdeleted = 0 WHERE tableafname 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:<... 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:<... hist AS ((SELECT gl[mslink, bagl_name AS txt, bagl_nummer AS nr, 0 AS level, CAST(glmslink AS VARCHAR) AS path, aefeature FROM tablea AS gl INNER JOIN tableb AS ba ON glmslink = bagl_mslink INNER JOIN tablec AS ae ON glmslink = aemslink AND aedeleted = 0 WHERE glparent IS NULL AND glmslink <> 0) UNION ALL (SELECT glmslink, bagl_name AS txt, bagl_nummer AS nr, histlevel + 1 AS level, CAST(histpath + '.' + CAST(glmslink AS VARCHAR) AS VARCHAR) AS path, aefeature FROM tablea AS gl INNER JOIN tableb AS ba ON glmslink = bagl_mslink INNER JOIN tablec AS ae ON glmslink = aemslink AND aedeleted = 0 INNER JOIN hist ON glparent = histmslink WHERE glmslink <> 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 histfeature = 3) OR (.feature IN (4) AND hist]feature = 2)))>
  testWithUnionProblem5(net.sf.jsqlparser.test.select.SelectTest): expected:<... 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:<... hist AS ((SELECT gl[mslink, bagl_name AS txt, bagl_nummer AS nr, 0 AS level, CAST(glmslink AS VARCHAR) AS path, aefeature FROM tablea AS gl INNER JOIN tableb AS ba ON glmslink = bagl_mslink INNER JOIN tablec AS ae ON glmslink = aemslink AND aedeleted = 0 WHERE glparent IS NULL AND glmslink <> 0) UNION ALL (SELECT glmslink, bagl_name AS txt, bagl_nummer AS nr, histlevel + 1 AS level, CAST(histpath + '.' + CAST(glmslink AS VARCHAR) AS VARCHAR) AS path, 5 AS feature FROM tablea AS gl INNER JOIN tableb AS ba ON glmslink = bagl_mslink INNER JOIN tablec AS ae ON glmslink = aemslink AND aedeleted = 0 INNER JOIN hist ON glparent = histmslink WHERE gl]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:<tab1[.]b> but was:<tab1[]b>
  testMultiPartColumnNameWithTableName(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT tableName[.]columnName FROM tabl...> but was:<SELECT tableName[]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:<...ytable WHERE mytable[.col = 9 ORDER BY mytable.]id OFFSET 3 ROWS FET...> but was:<...ytable WHERE mytable[col = 9 ORDER BY mytable]id OFFSET 3 ROWS FET...>
  testLimitSqlServer2(net.sf.jsqlparser.test.select.SelectTest): expected:<...ytable WHERE mytable[.col = 9 ORDER BY mytable.]id OFFSET 3 ROW FETC...> but was:<...ytable WHERE mytable[col = 9 ORDER BY mytable]id OFFSET 3 ROW FETC...>
  testLimitSqlServer3(net.sf.jsqlparser.test.select.SelectTest): expected:<...ytable WHERE mytable[.col = 9 ORDER BY mytable.]id OFFSET 3 ROWS> but was:<...ytable WHERE mytable[col = 9 ORDER BY mytable]id OFFSET 3 ROWS>
  testLimitSqlServer4(net.sf.jsqlparser.test.select.SelectTest): expected:<...ytable WHERE mytable[.col = 9 ORDER BY mytable.]id FETCH NEXT 5 ROWS...> but was:<...ytable WHERE mytable[col = 9 ORDER BY mytable]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(SPA[]AANLEVERPERIODEVOLGN...>
  testConcatProblem2_2(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT MAX((SPA[.SOORTAANLEVERPERIODE)::VARCHAR (2) || (VARCHAR(SPA.]AANLEVERPERIODEJAAR)...> but was:<SELECT MAX((SPA[SOORTAANLEVERPERIODE)::VARCHAR (2) || (VARCHAR(SPA]AANLEVERPERIODEJAAR)...>
  testConcatProblem2_3(net.sf.jsqlparser.test.select.SelectTest): expected:<...TO_CHAR((10000 - SPA[.]VERSCHIJNINGSVOLGNR)...> but was:<...TO_CHAR((10000 - SPA[]VERSCHIJNINGSVOLGNR)...>
  testConcatProblem2_4(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT (SPA[.]GESLACHT)::VARCHAR (...> but was:<SELECT (SPA[]GESLACHT)::VARCHAR (...>
  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:<...schemaName.tableName[.]columnName FROM tabl...> but was:<...schemaName.tableName[]columnName FROM tabl...>
  testMultiPartColumnNameWithDatabaseNameAndTableName(net.sf.jsqlparser.test.select.SelectTest): expected:<...abaseName..tableName[.]columnName FROM tabl...> but was:<...abaseName..tableName[]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)>
  testSelectWithinGroup(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT LISTAGG([col1, '##') WITHIN GROUP (ORDER BY ]col1) FROM table1> but was:<SELECT LISTAGG([.col1, '##') WITHIN GROUP (ORDER BY .]col1) FROM table1>
  testNotEqualsTo(net.sf.jsqlparser.test.select.SelectTest): expected:<...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 (PARTITION BY c ORDER BY a, ]b) AS n FROM table1> but was:<SELECT [.a, lag(.a, 1) OVER (PARTITION BY .c ORDER BY .a, .]b) AS n FROM table1>
  testProblemSqlAnalytic11Lag(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [a, lag(a, 1, 0) OVER (PARTITION BY c ORDER BY a, ]b) AS n FROM table1> but was:<SELECT [.a, lag(.a, 1, 0) OVER (PARTITION BY .c ORDER BY .a, .]b) AS n FROM table1>
  testMatches(net.sf.jsqlparser.test.select.SelectTest): expected:<...FROM team WHERE team[.]search_column @@ to_...> but was:<...FROM team WHERE team[]search_column @@ to_...>
  testAnalyticFunctionProblem1(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT last_value(s[.revenue_hold) OVER (PARTITION BY s.id_d_insertion_order, s.id_d_product_ad_attr, trunc(s.date_id, 'mm') ORDER BY s.]date_id) AS col FROM...> but was:<SELECT last_value(s[revenue_hold) OVER (PARTITION BY sid_d_insertion_order, sid_d_product_ad_attr, trunc(sdate_id, 'mm') ORDER BY s]date_id) AS col FROM...>
  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 mytable]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>
  testAnalyticFunction12(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT SUM([a) OVER (PARTITION BY b ORDER BY ]c) FROM tab1> but was:<SELECT SUM([.a) OVER (PARTITION BY .b ORDER BY .]c) FROM tab1>
  testAnalyticFunction13(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT SUM([]a) OVER () FROM tab1> but was:<SELECT SUM([.]a) OVER () FROM tab1>
  testAnalyticFunction14(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT SUM([a) OVER (PARTITION BY ]b ) FROM tab1> but was:<SELECT SUM([.a) OVER (PARTITION BY .]b ) FROM tab1>
  testAnalyticFunction15(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT SUM([a) OVER (ORDER BY ]c) FROM tab1> but was:<SELECT SUM([.a) OVER (ORDER BY .]c) FROM tab1>
  testAnalyticFunction16(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT SUM([a) OVER (ORDER BY ]c NULLS FIRST) FROM ...> but was:<SELECT SUM([.a) OVER (ORDER BY .]c NULLS FIRST) FROM ...>
  testAnalyticFunction17(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT AVG([sal) OVER (PARTITION BY deptno ORDER BY ]sal ROWS BETWEEN 0 P...> but was:<SELECT AVG([.sal) OVER (PARTITION BY .deptno ORDER BY .]sal ROWS BETWEEN 0 P...>
  testAnalyticFunction18(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT AVG([sal) OVER (PARTITION BY deptno ORDER BY ]sal RANGE CURRENT RO...> but was:<SELECT AVG([.sal) OVER (PARTITION BY .deptno ORDER BY .]sal RANGE CURRENT RO...>
  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 table_a[]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 r[id, ruuid, rname, rsystem_role FROM role r WHERE rmerchant_id = ? AND rdeleted_time IS NULL ORDER BY r]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 n FROM...> but was:<SELECT [.a, sum(.]b) OVER () AS n FROM...>
  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(table1[]col1, 4) FROM table1>
  testCharacterSetClause(net.sf.jsqlparser.test.select.SelectTest): expected:<...ISTINCT CAST(`view0`[.`nick2` AS CHAR (8000) CHARACTER SET utf8) AS `v0` FROM people `view0` WHERE `view0`.]`nick2` IS NOT NULL> but was:<...ISTINCT CAST(`view0`[`nick2` AS CHAR (8000) CHARACTER SET utf8) AS `v0` FROM people `view0` WHERE `view0`]`nick2` IS NOT NULL>
  testComplexUnion1(net.sf.jsqlparser.test.select.SelectTest): expected:<...-' || coalesce(mytab[.a::varchar, '') AS a, mytab.b, mytab.c AS st, mytab.d, mytab.e FROM mytab WHERE mytab.del = 0) UNION (SELECT 'cde-' || coalesce(mytab2.a::varchar, '') AS a, mytab2.b, mytab2.bezeichnung AS c, 0 AS d, 0 AS e FROM mytab2 WHERE mytab2.]del = 0)> but was:<...-' || coalesce(mytab[a::varchar, '') AS a, mytabb, mytabc AS st, mytabd, mytabe FROM mytab WHERE mytabdel = 0) UNION (SELECT 'cde-' || coalesce(mytab2a::varchar, '') AS a, mytab2b, mytab2bezeichnung AS c, 0 AS d, 0 AS e FROM mytab2 WHERE mytab2]del = 0)>
  testProblemSqlAnalytic6AggregateColumnValue(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [a, sum(b + 5) OVER (ORDER BY ]a) AS n FROM table1> but was:<SELECT [.a, sum(.b + 5) OVER (ORDER BY .]a) AS n FROM table1>
  testDistinct(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT DISTINCT ON ([myid) myid, mycol FROM mytable WHERE mytable.]col = 9> but was:<SELECT DISTINCT ON ([.myid) .myid, .mycol FROM mytable WHERE mytable]col = 9>
  testMultiPartColumnNameWithSchemaNameAndTableName(net.sf.jsqlparser.test.select.SelectTest): expected:<...schemaName.tableName[.]columnName FROM tabl...> but was:<...schemaName.tableName[]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:<...ytable WHERE mytable[.]col = 9> but was:<...ytable WHERE mytable[]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(tab1[b) FROM tab1 WHERE .a > 34 GROUP BY tab1b HAVING MAX(tab1]b) > 56>
  testIssue154(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT d[.id, d.uuid, d.name, d.amount, d.percentage, d.modified_time FROM discount d LEFT OUTER JOIN discount_category dc ON d.id = dc.discount_id WHERE merchant_id = ? AND deleted = ? AND dc.discount_id IS NULL AND modified_time < ? AND modified_time >= ? ORDER BY ]modified_time> but was:<SELECT d[id, duuid, dname, damount, dpercentage, dmodified_time FROM discount d LEFT OUTER JOIN discount_category dc ON did = dcdiscount_id WHERE .merchant_id = ? AND .deleted = ? AND dcdiscount_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 mytable]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:<alias[.]columnName1> but was:<alias[]columnName1>
  testSelectOracleColl(net.sf.jsqlparser.test.select.SelectTest): expected:<...he_table tt WHERE TT[.COL1 = lines(]idx).COL1> but was:<...he_table tt WHERE TT[COL1 = lines(.]idx).COL1>
  testOracleJoin(net.sf.jsqlparser.test.select.SelectTest): expected:<...elle2 WHERE tabelle1[.a = tabelle2.]b(+)> but was:<...elle2 WHERE tabelle1[a = tabelle2]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:<...ytable WHERE mytable[.]col = 9 LIMIT ? OFFS...> but was:<...ytable WHERE mytable[]col = 9 LIMIT ? OFFS...>
  testProblemSqlAnalytic2(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [a, row_number() OVER (ORDER BY a, ]b) AS n FROM table1> but was:<SELECT [.a, row_number() OVER (ORDER BY .a, .]b) AS n FROM table1>
  testProblemSqlAnalytic3(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [a, row_number() OVER (PARTITION BY c ORDER BY a, ]b) AS n FROM table1> but was:<SELECT [.a, row_number() OVER (PARTITION BY .c ORDER BY .a, .]b) AS n FROM table1>
  testProblemSqlAnalytic9CommaListPartition(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [a, row_number() OVER (PARTITION BY c, d ORDER BY a, ]b) AS n FROM table1> but was:<SELECT [.a, row_number() OVER (PARTITION BY .c, .d ORDER BY .a, .]b) AS n FROM table1>
  testSelectWithoutFrom(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT footable[.]foocolumn> but was:<SELECT footable[]foocolumn>
  testOracleHierarchicalQuery(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [last_name, employee_id, manager_id FROM employees CONNECT BY employee_id = manager_id ORDER BY ]last_name> but was:<SELECT [.last_name, .employee_id, .manager_id FROM employees CONNECT BY .employee_id = .manager_id ORDER BY .]last_name>
  testPivot1(net.sf.jsqlparser.test.select.SelectTest): expected:<...ytable PIVOT (count([a) FOR ]b IN ('val1'))> but was:<...ytable PIVOT (count([.a) FOR .]b IN ('val1'))>
  testPivot2(net.sf.jsqlparser.test.select.SelectTest): expected:<...ytable PIVOT (count([a) FOR ]b IN (10, 20, 30))> but was:<...ytable PIVOT (count([.a) FOR .]b IN (10, 20, 30))>
  testPivot3(net.sf.jsqlparser.test.select.SelectTest): expected:<...ytable PIVOT (count([a) AS vals FOR ]b IN (10 AS d1, 20, ...> but was:<...ytable PIVOT (count([.a) AS vals FOR .]b IN (10 AS d1, 20, ...>
  testPivot4(net.sf.jsqlparser.test.select.SelectTest): expected:<...ytable PIVOT (count([a), sum(b) FOR ]b IN (10, 20, 30))> but was:<...ytable PIVOT (count([.a), sum(.b) FOR .]b IN (10, 20, 30))>
  testPivot5(net.sf.jsqlparser.test.select.SelectTest): expected:<...ytable PIVOT (count([a) FOR (b, ]c) IN ((10, 'a'), (2...> but was:<...ytable PIVOT (count([.a) FOR (.b, .]c) IN ((10, 'a'), (2...>
  testAnalyticFunctionProblem1b(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT last_value(s[.revenue_hold) OVER (PARTITION BY s.id_d_insertion_order, s.id_d_product_ad_attr, trunc(s.date_id, 'mm') ORDER BY s.]date_id ROWS BETWEEN...> but was:<SELECT last_value(s[revenue_hold) OVER (PARTITION BY sid_d_insertion_order, sid_d_product_ad_attr, trunc(sdate_id, 'mm') ORDER BY s]date_id ROWS BETWEEN...>
  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 a[OWNERLASTNAME, aOWNERFIRSTNAME FROM ANTIQUEOWNERS AS a, ANTIQUES AS b WHERE bBUYERID = aOWNERID AND b]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 employees CONNECT BY PRIOR employee_id = ]manager_id> but was:<SELECT [.employee_id, .last_name, .manager_id FROM employees CONNECT BY PRIOR .employee_id = .]manager_id>
  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...>
  testCastTypeProblem(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT CAST([]col1 AS varchar (256...> but was:<SELECT CAST([.]col1 AS varchar (256...>
  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:<...ytable WHERE mytable[.col = 9 ORDER BY mytable.]id OFFSET ? ROWS FET...> but was:<...ytable WHERE mytable[col = 9 ORDER BY mytable]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 pg_class[relname, pg_attributeattname, pg_constraintconname FROM pg_constraint JOIN pg_class ON pg_classoid = pg_constraintconrelid JOIN pg_attribute ON pg_attributeattrelid = pg_constraintconrelid WHERE pg_constraintcontype = 'u' AND (pg_attributeattnum = ANY(pg_constraintconkey)) ORDER BY pg_constraint]conname>
  testSelectKeep(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [col1, min(col2) KEEP (DENSE_RANK FIRST ORDER BY col3), col4 FROM table1 GROUP BY col5 ORDER BY ]col3> but was:<SELECT [.col1, min(.col2) KEEP (DENSE_RANK FIRST ORDER BY .col3), .col4 FROM table1 GROUP BY .col5 ORDER BY .]col3>
  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)>
  testCastInCast2(net.sf.jsqlparser.test.select.SelectTest): expected:<... CAST('test' + CAST([]assertEqual AS numer...> but was:<... CAST('test' + CAST([.]assertEqual AS numer...>
  testNamedParameter(net.sf.jsqlparser.test.select.SelectTest): expected:<... FROM mytable WHERE []b = :param> but was:<... FROM mytable WHERE [.]b = :param>
  testVisit_PlainSelect_concat(net.sf.jsqlparser.util.ConnectExpressionsVisitorTest): expected:<SELECT [a || b || ]c AS expr FROM test> but was:<SELECT [.a || .b || .]c AS expr FROM test>
  testVisit_PlainSelect_addition(net.sf.jsqlparser.util.ConnectExpressionsVisitorTest): expected:<SELECT [a + b + ]c AS testexpr FROM t...> but was:<SELECT [.a + .b + .]c AS testexpr FROM t...>
  testVisit_PlainSelect(net.sf.jsqlparser.util.AddAliasesVisitorTest): expected:<SELECT [a AS A1, b AS A2, ]c AS A3 FROM test> but was:<SELECT [.a AS A1, .b AS A2, .]c AS A3 FROM test>
  testVisit_PlainSelect_duplicates(net.sf.jsqlparser.util.AddAliasesVisitorTest): expected:<SELECT [a AS A2, b AS a1, ]c AS A3 FROM test> but was:<SELECT [.a AS A2, .b AS a1, .]c AS A3 FROM test>
  testBuildSelectFromTableAndExpressions(net.sf.jsqlparser.util.SelectUtilsTest): expected:<SELECT [a, ]b FROM mytable> but was:<SELECT [.a, .]b FROM mytable>
  testAddExpr(net.sf.jsqlparser.util.SelectUtilsTest): expected:<SELECT [a, ]b FROM mytable> but was:<SELECT [.a, .]b FROM mytable>
  testAddJoin(net.sf.jsqlparser.util.SelectUtilsTest): expected:<SELECT [a FROM mytable LEFT JOIN mytable2 ON a = ]b> but was:<SELECT [.a FROM mytable LEFT JOIN mytable2 ON .a = .]b>
  testBuildSelectFromTableWithGroupBy(net.sf.jsqlparser.util.SelectUtilsTest): expected:<...OM mytable GROUP BY []b> but was:<...OM mytable GROUP BY [.]b>
  testBuildSelectFromTableAndParsedExpression(net.sf.jsqlparser.util.SelectUtilsTest): expected:<SELECT [a + b, ]test FROM mytable> but was:<SELECT [.a + .b, .]test FROM mytable>
  testParseExpression2(net.sf.jsqlparser.parser.CCJSqlParserUtilTest): expected:<2 * ([]a + 6.0)> but was:<2 * ([.]a + 6.0)>
  testParseCondExpression(net.sf.jsqlparser.parser.CCJSqlParserUtilTest): expected:<[a + b > 5 AND ]c < 3> but was:<[.a + .b > 5 AND .]c < 3>
  testParseExpression(net.sf.jsqlparser.parser.CCJSqlParserUtilTest): expected:<[a + ]b> but was:<[.a + .]b>

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

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