[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 228.795ms.
[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.055 sec
Running net.sf.jsqlparser.test.create.CreateTableTest
Tests run: 27, Failures: 2, Errors: 0, Skipped: 0, Time elapsed: 0.134 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.009 sec <<< FAILURE!
Running net.sf.jsqlparser.test.delete.DeleteTest
Tests run: 2, Failures: 2, Errors: 0, Skipped: 0, Time elapsed: 0.003 sec <<< FAILURE!
Running net.sf.jsqlparser.test.simpleparsing.CCJSqlParserManagerTest
Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.172 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.04 sec <<< FAILURE!
Running net.sf.jsqlparser.test.TestUtils
Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0 sec
Running net.sf.jsqlparser.test.update.UpdateTest
Tests run: 7, Failures: 5, Errors: 0, Skipped: 0, Time elapsed: 0.003 sec <<< FAILURE!
Running net.sf.jsqlparser.test.replace.ReplaceTest
Tests run: 4, Failures: 3, Errors: 0, Skipped: 0, Time elapsed: 0.005 sec <<< FAILURE!
Running net.sf.jsqlparser.test.select.SelectASTTest
*Statement
* Column
* Column
* Table
* Column
* Column
Tests run: 2, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.002 sec
Running net.sf.jsqlparser.test.select.SpecialOracleTest
Oct 06, 2015 7:04:37 AM net.sf.jsqlparser.test.select.SpecialOracleTest testAllSqlsParseDeparse
INFO: testing string01.sql
Oct 06, 2015 7:04:37 AM net.sf.jsqlparser.test.select.SpecialOracleTest testAllSqlsParseDeparse
INFO:    -> PROBLEM net.sf.jsqlparser.JSQLParserException
Oct 06, 2015 7:04:37 AM net.sf.jsqlparser.test.select.SpecialOracleTest testAllSqlsParseDeparse
INFO: testing returning01.sql
Oct 06, 2015 7:04:37 AM net.sf.jsqlparser.test.select.SpecialOracleTest testAllSqlsParseDeparse
INFO:    -> PROBLEM net.sf.jsqlparser.JSQLParserException
Oct 06, 2015 7:04:37 AM net.sf.jsqlparser.test.select.SpecialOracleTest testAllSqlsParseDeparse
INFO: testing keywordasidentifier05.sql
Oct 06, 2015 7:04:37 AM net.sf.jsqlparser.test.select.SpecialOracleTest testAllSqlsOnlyParse
INFO: testing comment02.sql
Oct 06, 2015 7:04:37 AM net.sf.jsqlparser.test.select.SpecialOracleTest testAllSqlsOnlyParse
INFO:    -> SUCCESS
Oct 06, 2015 7:04:37 AM net.sf.jsqlparser.test.select.SpecialOracleTest testAllSqlsOnlyParse
INFO: testing numbers02.sql
Oct 06, 2015 7:04:37 AM net.sf.jsqlparser.test.select.SpecialOracleTest testAllSqlsOnlyParse
INFO:    -> SUCCESS
Oct 06, 2015 7:04:37 AM net.sf.jsqlparser.test.select.SpecialOracleTest testAllSqlsOnlyParse
INFO: testing comment01.sql
Oct 06, 2015 7:04:37 AM net.sf.jsqlparser.test.select.SpecialOracleTest testAllSqlsOnlyParse
INFO:    -> SUCCESS
Tests run: 2, Failures: 1, Errors: 0, Skipped: 0, Time elapsed: 0.086 sec <<< FAILURE!
Running net.sf.jsqlparser.test.select.SelectTest
Tests run: 228, Failures: 179, Errors: 0, Skipped: 0, Time elapsed: 0.559 sec <<< FAILURE!
Running net.sf.jsqlparser.test.select.SpeedTest
42500 statements parsed in 7686 milliseconds
 (5529 statements per second,  0.0001809 seconds per statement )
38500 select scans for table name executed in 137 milliseconds
 (281021 select scans for table name per second,  0.0000036 seconds per select scans for table name)
Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 7.814 sec
Running net.sf.jsqlparser.test.truncate.TruncateTest
Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0 sec
Running net.sf.jsqlparser.util.TablesNamesFinderTest
Tests run: 19, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.013 sec
Running net.sf.jsqlparser.util.ConnectExpressionsVisitorTest
Tests run: 2, Failures: 2, Errors: 0, Skipped: 0, Time elapsed: 0.004 sec <<< FAILURE!
Running net.sf.jsqlparser.util.AddAliasesVisitorTest
Tests run: 4, Failures: 2, Errors: 0, Skipped: 0, Time elapsed: 0.001 sec <<< FAILURE!
Running net.sf.jsqlparser.util.SelectUtilsTest
Tests run: 6, Failures: 5, Errors: 0, Skipped: 0, Time elapsed: 0.003 sec <<< FAILURE!
Running net.sf.jsqlparser.expression.ExpressionVisitorAdapterTest
Tests run: 2, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.001 sec
Running net.sf.jsqlparser.expression.SignedExpressionTest
Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.001 sec
Running net.sf.jsqlparser.schema.ServerTest
Tests run: 2, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0 sec
Running net.sf.jsqlparser.parser.CCJSqlParserUtilTest
Tests run: 3, Failures: 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.004 sec
Running net.sf.jsqlparser.statement.AdaptersTest
Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.002 sec
Running net.sf.jsqlparser.statement.StatementsTest
Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0 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 [, ] 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 [,  FROM testtable) SELECT , ,  FROM b INNER JOIN a ON b. = a.]>
  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 [, ,  FROM testtab INNER JOIN testtab2 ON testtab. = testtab2.]>
  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 [,  FROM testtab) UNION (SELECT , ] FROM testtab2)>
  testCreateMaterializedView(net.sf.jsqlparser.test.create.CreateViewTest): expected:<...IEW view1 AS SELECT [a, b] FROM testtab> but was:<...IEW view1 AS SELECT [, ] FROM testtab>
  testCreateViewWithColumnNames1(net.sf.jsqlparser.test.create.CreateViewTest): expected:<...l1, col2) AS SELECT [a, b] FROM testtab> but was:<...l1, col2) AS SELECT [, ] FROM testtab>
  testDelete(net.sf.jsqlparser.test.delete.DeleteTest): expected:<...table WHERE mytable.[col] = 9> but was:<...table WHERE mytable.[] = 9>
  testDeleteWhereProblem1(net.sf.jsqlparser.test.delete.DeleteTest): expected:<...ROM tablename WHERE [a = 1 AND b] = 1> but was:<...ROM tablename WHERE [ = 1 AND ] = 1>
  testInsertMultiRowValue(net.sf.jsqlparser.test.insert.InsertTest): expected:<...NSERT INTO mytable ([col1, col2) VALUES (a, b), (d, e])> but was:<...NSERT INTO mytable ([, ) VALUES (, ), (, ])>
  testInsertWithReturning2(net.sf.jsqlparser.test.insert.InsertTest): expected:<...NSERT INTO mytable ([mycolumn]) VALUES ('1') RETUR...> but was:<...NSERT INTO mytable ([]) VALUES ('1') RETUR...>
  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 ([) VALUES ('1') RETURNING  AS a1, ] AS a2>
  testHexValues2(net.sf.jsqlparser.test.insert.InsertTest): expected:<...TABLE2 VALUES ('1', ["DSDD"], 0xEFBFBDC7AB)> but was:<...TABLE2 VALUES ('1', [], 0xEFBFBDC7AB)>
  testHexValues3(net.sf.jsqlparser.test.insert.InsertTest): expected:<...TABLE2 VALUES ('1', ["DSDD"], 0xabcde)> but was:<...TABLE2 VALUES ('1', [], 0xabcde)>
  testHexValues(net.sf.jsqlparser.test.insert.InsertTest): expected:<...TABLE2 VALUES ('1', ["DSDD"], x'EFBFBDC7AB')> but was:<...TABLE2 VALUES ('1', [], x'EFBFBDC7AB')>
  testSimpleInsert(net.sf.jsqlparser.test.insert.InsertTest): expected:<...NSERT INTO example ([num, name, address, tel]) VALUES (1, 'name',...> but was:<...NSERT INTO example ([, , , ]) VALUES (1, 'name',...>
  testInsertWithKeywords(net.sf.jsqlparser.test.insert.InsertTest): expected:<INSERT INTO kvPair ([value, key]) VALUES (?, ?)> but was:<INSERT INTO kvPair ([, ]) VALUES (?, ?)>
  testInsertWithReturning(net.sf.jsqlparser.test.insert.InsertTest): expected:<...NSERT INTO mytable ([mycolumn) VALUES ('1') RETURNING id]> but was:<...NSERT INTO mytable ([) VALUES ('1') RETURNING ]>
  testRegularInsert(net.sf.jsqlparser.test.insert.InsertTest): expected:<...NSERT INTO mytable ([col1, col2, col3]) VALUES (?, 'sadfsd...> but was:<...NSERT INTO mytable ([, , ]) VALUES (?, 'sadfsd...>
  testInsertWithKeywordValue(net.sf.jsqlparser.test.insert.InsertTest): expected:<...NSERT INTO mytable ([col1]) VALUES ('val1')> but was:<...NSERT INTO mytable ([]) VALUES ('val1')>
  testInsertFromSelect(net.sf.jsqlparser.test.insert.InsertTest): expected:<...NSERT INTO mytable ([col1, col2, col3]) SELECT * FROM myta...> but was:<...NSERT INTO mytable ([, , ]) SELECT * FROM myta...>
  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 ([) WITH a AS (SELECT  FROM mytable) SELECT ] FROM a>
  testInsertSelect(net.sf.jsqlparser.test.insert.InsertTest): expected:<...NSERT INTO mytable ([mycolumn) SELECT mycolumn] FROM mytable> but was:<...NSERT INTO mytable ([) SELECT ] FROM mytable>
  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 [ = 5 FROM table1 LEFT JOIN table2 ON  = ]>
  testUpdateMultiTable(net.sf.jsqlparser.test.update.UpdateTest): expected:<...PDATE T1, T2 SET T1.[C2 = T2.C2, T2.C3 = 'UPDATED' WHERE T1.C1 = T2.C1 AND T1.C2] < 10> but was:<...PDATE T1, T2 SET T1.[ = T2., T2. = 'UPDATED' WHERE T1. = T2. AND T1.] < 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 ([, , ) = (SELECT , , ] FROM mytable2)>
  testUpdateWithSelect(net.sf.jsqlparser.test.update.UpdateTest): expected:<UPDATE NATION SET ([N_NATIONKEY]) = (SELECT ? FROM S...> but was:<UPDATE NATION SET ([]) = (SELECT ? FROM S...>
  testUpdateWithDeparser(net.sf.jsqlparser.test.update.UpdateTest): expected:<...E table1 AS A SET A.[columna = 'XXX' WHERE A.cod_table] = 'YYY'> but was:<...E table1 AS A SET A.[ = 'XXX' WHERE A.] = '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 ([, , ) SELECT , , ] FROM b_table>
  testReplaceSyntax1(net.sf.jsqlparser.test.replace.ReplaceTest): expected:<REPLACE mytable SET [col1='as', col2=?, col3]=565> but was:<REPLACE mytable SET [='as', =?, ]=565>
  testReplaceSyntax2(net.sf.jsqlparser.test.replace.ReplaceTest): expected:<REPLACE mytable ([col1, col2, col3]) VALUES ('as', ?, 5...> but was:<REPLACE mytable ([, , ]) VALUES ('as', ?, 5...>
  testAllSqlsParseDeparse(net.sf.jsqlparser.test.select.SpecialOracleTest): expected:<select [exception ]from exception> but was:<select []from exception>
  testSelectAliasWithoutAs(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [mycolumn] "My Column Name" FR...> but was:<SELECT [] "My Column Name" FR...>
  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.[, e1. FROM emp e1 WHERE e1. > ALL (SELECT e2. FROM emp e2 WHERE e2.] = 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([), trim()) IN (SELECT , ] FROM mytable2)>
  testSelectForUpdateOfTable(net.sf.jsqlparser.test.select.SelectTest): expected:<... foo, bar WHERE foo.[id = bar.foo_id] FOR UPDATE OF foo> but was:<... foo, bar WHERE foo.[ = bar.] FOR UPDATE OF foo>
  testPostgreSQLRegExpCaseSensitiveMatch(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [a, b FROM foo WHERE a] ~ '[help].*'> but was:<SELECT [,  FROM foo WHERE ] ~ '[help].*'>
  testOracleJoin2(net.sf.jsqlparser.test.select.SelectTest): expected:<...lle2 WHERE tabelle1.[a(+) = tabelle2.b]> but was:<...lle2 WHERE tabelle1.[(+) = tabelle2.]>
  testOracleJoin3(net.sf.jsqlparser.test.select.SelectTest): expected:<...lle2 WHERE tabelle1.[a(+) > tabelle2.b]> but was:<...lle2 WHERE tabelle1.[(+) > tabelle2.]>
  testOracleJoin4(net.sf.jsqlparser.test.select.SelectTest): expected:<...lle2 WHERE tabelle1.[a(+) = tabelle2.b AND tabelle1.b](+) IN ('A', 'B')> but was:<...lle2 WHERE tabelle1.[(+) = tabelle2. AND tabelle1.](+) IN ('A', 'B')>
  testMultiPartTableNameWithSchemaName(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [columnName] FROM schemaName.tab...> but was:<SELECT [] FROM schemaName.tab...>
  testSelectBrackets2(net.sf.jsqlparser.test.select.SelectTest): expected:<...RACT(epoch FROM age([d1, d2])) / 2)::numeric> but was:<...RACT(epoch FROM age([, ])) / 2)::numeric>
  testSelectBrackets3(net.sf.jsqlparser.test.select.SelectTest): expected:<...RACT(epoch FROM age([d1, d2])) / 2)::numeric)> but was:<...RACT(epoch FROM age([, ])) / 2)::numeric)>
  testSelectAliasInQuotes(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [mycolumn] AS "My Column Name"...> but was:<SELECT [] AS "My Column Name"...>
  testOrderBy(net.sf.jsqlparser.test.select.SelectTest): expected:<tab1.[a]> but was:<tab1.[]>
  testCastTypeProblem2(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [col1]::varchar FROM tabel...> but was:<SELECT []::varchar FROM tabel...>
  testCastTypeProblem3(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [col1]::varchar (256) FROM...> but was:<SELECT []::varchar (256) FROM...>
  testCastInCast(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT CAST(CAST([a] AS numeric) AS varc...> but was:<SELECT CAST(CAST([] AS numeric) AS varc...>
  testSkipFirst(net.sf.jsqlparser.test.select.SelectTest): expected:<[c1]> but was:<[]>
  testMultiPartTableNameWithDatabaseNameAndSchemaName(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [columnName] FROM databaseName.s...> but was:<SELECT [] FROM databaseName.s...>
  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.[, cb. FROM Coleccion_de_Briofitas AS cb, unigeoestados AS es WHERE es. =  AND cb. = es.]>
  testAdditionalLettersGerman(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [colä, colö, colü] FROM testtableäöü> but was:<SELECT [, , ] FROM testtableäöü>
  testTop(net.sf.jsqlparser.test.select.SelectTest): expected:<...table WHERE mytable.[col] = 9> but was:<...table WHERE mytable.[] = 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 [ FROM tablea) UNION (SELECT  FROM tableb)) SELECT * FROM tablea WHERE  IN (SELECT ] 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 [,  FROM `ANTIQUEOWNERS` AS a, ANTIQUES AS b WHERE b. = a. AND b.] = 'Chair'>
  testSelectInnerWith(net.sf.jsqlparser.test.select.SelectTest): expected:<...d FROM DUAL) SELECT [aid] FROM actor)> but was:<...d FROM DUAL) SELECT [] FROM actor)>
  testReservedKeyword2(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [open] FROM tableName> but was:<SELECT [] FROM tableName>
  testFirst(net.sf.jsqlparser.test.select.SelectTest): expected:<alias.[columnName1]> but was:<alias.[]>
  testIlike(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [col1 FROM table1 WHERE col1] ILIKE '%hello%'> but was:<SELECT [ FROM table1 WHERE ] ILIKE '%hello%'>
  testIsNot(net.sf.jsqlparser.test.select.SelectTest): expected:<...T * FROM test WHERE [a] IS NOT NULL> but was:<...T * FROM test WHERE [] IS NOT NULL>
  testLimit(net.sf.jsqlparser.test.select.SelectTest): expected:<...table WHERE mytable.[col] = 9 LIMIT ? OFFSET ...> but was:<...table WHERE mytable.[] = 9 LIMIT ? OFFSET ...>
  testSigns(net.sf.jsqlparser.test.select.SelectTest): expected:<...CT (-(1)), -(1), (-([columnName)), -(columnName), (-1), -1, (-columnName), -columnName] FROM tableName> but was:<...CT (-(1)), -(1), (-([)), -(), (-1), -1, (-), -] FROM tableName>
  testUnion(net.sf.jsqlparser.test.select.SelectTest): expected:<...table WHERE mytable.[col = 9) UNION (SELECT * FROM mytable3 WHERE mytable3.col] = ?) UNION (SELECT ...> but was:<...table WHERE mytable.[ = 9) UNION (SELECT * FROM mytable3 WHERE mytable3.] = ?) UNION (SELECT ...>
  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 ([ +  +  /  +  * ) * ( /  * ( + ])) > ?>
  testRegexpLike1(net.sf.jsqlparser.test.select.SelectTest): expected:<...e WHERE REGEXP_LIKE([first_name], '^Ste(v|ph)en$')> but was:<...e WHERE REGEXP_LIKE([], '^Ste(v|ph)en$')>
  testRegexpLike2(net.sf.jsqlparser.test.select.SelectTest): expected:<...SE WHEN REGEXP_LIKE([first_name], '^Ste(v|ph)en$') T...> but was:<...SE WHEN REGEXP_LIKE([], '^Ste(v|ph)en$') T...>
  testRegexpMySQL(net.sf.jsqlparser.test.select.SelectTest): expected:<... FROM mytable WHERE [first_name] REGEXP '^Ste(v|ph)e...> but was:<... FROM mytable WHERE [] REGEXP '^Ste(v|ph)e...>
  testCase(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [a, CASE b] WHEN 1 THEN 2 END F...> but was:<SELECT [, CASE ] WHEN 1 THEN 2 END F...>
  testCast(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT CAST([a] AS varchar) FROM ta...> but was:<SELECT CAST([] AS varchar) FROM ta...>
  testFrom(net.sf.jsqlparser.test.select.SelectTest): expected:<...able4 WHERE mytable.[col] = 9> but was:<...able4 WHERE mytable.[] = 9>
  testJoin(net.sf.jsqlparser.test.select.SelectTest): expected:<tab1.[id]> but was:<tab1.[]>
  testLike(net.sf.jsqlparser.test.select.SelectTest): expected:<...T * FROM tab1 WHERE [a] LIKE 'test'> but was:<...T * FROM tab1 WHERE [] LIKE 'test'>
  testSkip(net.sf.jsqlparser.test.select.SelectTest): expected:<alias.[columnName1]> but was:<alias.[]>
  testTime(net.sf.jsqlparser.test.select.SelectTest): expected:<...T * FROM tab1 WHERE [a] > {t '04:05:34'}> but was:<...T * FROM tab1 WHERE [] > {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 ([, , ) AS (SELECT OTHERS., AVG(OTHERS.), COUNT(*) FROM EMPLOYEE AS OTHERS GROUP BY OTHERS.), DINFOMAX AS (SELECT MAX() AS AVGMAX FROM DINFO) SELECT THIS_EMP., THIS_EMP., DINFO., DINFO., DINFOMAX. FROM EMPLOYEE AS THIS_EMP INNER JOIN DINFO INNER JOIN DINFOMAX WHERE THIS_EMP. = 'SALESREP' AND THIS_EMP. = DINFO.]>
  testJsonExpression(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [data]->'images'->'thumbna...> but was:<SELECT []->'images'->'thumbna...>
  testConcatProblem2_5_1(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT ([a || b) || c] FROM testtable> but was:<SELECT ([ || ) || ] FROM testtable>
  testConcatProblem2_5_2(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT ([a + b) + c] FROM testtable> but was:<SELECT ([ + ) + ] 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 [, , , SUM() OVER () AS SUM_SAL, AVG() OVER () AS AVG_SAL, MIN() OVER () AS MIN_SAL, MAX() OVER () AS MAX_SAL, COUNT(*) OVER () AS ROWS2 FROM STAFF WHERE  < 60]>
  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 [ FROM tablea) UNION ALL (SELECT  FROM tableb)) SELECT * FROM tablea WHERE  IN (SELECT ] FROM test)>
  testOracleJoin2_1(net.sf.jsqlparser.test.select.SelectTest): expected:<...lle2 where tabelle1.[a(+)=tabelle2.b]> but was:<...lle2 where tabelle1.[(+)=tabelle2.]>
  testOracleJoin2_2(net.sf.jsqlparser.test.select.SelectTest): expected:<...lle2 where tabelle1.[a=tabelle2.b](+)> but was:<...lle2 where tabelle1.[=tabelle2.](+)>
  testOracleJoin3_1(net.sf.jsqlparser.test.select.SelectTest): expected:<...lle2 WHERE tabelle1.[a > tabelle2.b](+)> but was:<...lle2 WHERE tabelle1.[ > tabelle2.](+)>
  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.[, e1. FROM emp e1 WHERE e1. > ANY (SELECT e2. FROM emp e2 WHERE e2.] = 10)>
  testPivotXml1(net.sf.jsqlparser.test.select.SelectTest): expected:<...le PIVOT XML (count([a) FOR b] IN ('val1'))> but was:<...le PIVOT XML (count([) FOR ] IN ('val1'))>
  testPivotXml2(net.sf.jsqlparser.test.select.SelectTest): expected:<...le PIVOT XML (count([a) FOR b IN (SELECT vals] FROM myothertable))> but was:<...le PIVOT XML (count([) FOR  IN (SELECT ] FROM myothertable))>
  testPivotXml3(net.sf.jsqlparser.test.select.SelectTest): expected:<...le PIVOT XML (count([a) FOR b] IN (ANY))> but was:<...le PIVOT XML (count([) FOR ] 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, [ AS "Login Name", ] AS "User Name">
  testOrderByNullsFirst(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [a FROM tab1 ORDER BY a] NULLS FIRST> but was:<SELECT [ FROM tab1 ORDER BY ] NULLS FIRST>
  testMultiTableJoin(net.sf.jsqlparser.test.select.SelectTest): expected:<...R JOIN tabb ON taba.[a = tabb.a, tabc LEFT JOIN tabd ON tabc.c = tabd.c]> but was:<...R JOIN tabb ON taba.[ = tabb., tabc LEFT JOIN tabd ON tabc. = tabd.]>
  testProblemSqlAnalytic(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [a, row_number() OVER (ORDER BY a]) AS n FROM table1> but was:<SELECT [, row_number() OVER (ORDER BY ]) 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.[, O., OL. FROM ORDERS AS O, LATERAL(SELECT SUM() AS LINETOTAL FROM ORDERLINES AS LINES WHERE LINES. = O.]) AS OL>
  testSelectNumericBind(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [a FROM b WHERE c] = :1> but was:<SELECT [ FROM b WHERE ] = :1>
  testRegexpBinaryMySQL(net.sf.jsqlparser.test.select.SelectTest): expected:<... FROM mytable WHERE [first_name] REGEXP BINARY '^Ste...> but was:<... FROM mytable WHERE [] REGEXP BINARY '^Ste...>
  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.[, O., OL., OC., OT. FROM ORDERS O, LATERAL(SELECT SUM() AS LINETOTAL FROM ORDERLINES LINES WHERE LINES. = O.) AS OL, LATERAL(SELECT SUM() AS ORDCHGTOTAL FROM ORDERCHARGES CHARGES WHERE LINES. = O.) AS OC, LATERAL(SELECT SUM() AS TAXTOTAL FROM ORDERTAXES TAXES WHERE TAXES. = O.]) 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 ([, , ) IN (SELECT , , ] 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 (1))) AS ...> but was:<SELECT MAX((((((SPA.[)::VARCHAR (2) || (VARCHAR(SPA.))::VARCHAR (4)) || TO_CHAR(SPA., 'FM09'::VARCHAR)) || TO_CHAR((10000 - SPA.), 'FM0999'::VARCHAR)) || (SPA.])::VARCHAR (1))) AS ...>
  testBitwise(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [col1 & 32, col2 ^ col1, col1 | col2] FROM table1> but was:<SELECT [ & 32,  ^ ,  | ] FROM table1>
  testSelectItems(net.sf.jsqlparser.test.select.SelectTest): expected:<mytab.[mycol2]> but was:<mytab.[]>
  testSelectJoin2(net.sf.jsqlparser.test.select.SelectTest): expected:<... WHERE pg_attribute.[attnum = ANY(pg_constraint.conkey])> but was:<... WHERE pg_attribute.[ = ANY(pg_constraint.])>
  testBrackets2(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [[a]] FROM t> but was:<SELECT [] FROM t>
  testFirstWithKeywordLimit(net.sf.jsqlparser.test.select.SelectTest): expected:<alias.[columnName1]> but was:<alias.[]>
  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 [, GROUP_CONCAT(DISTINCT  ORDER BY  DESC SEPARATOR ' ') FROM student]>
  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 ([) AS ((SELECT 1) UNION ALL (SELECT  + 1 FROM t WHERE  < 100)) SELECT sum(]) 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([) KEEP (DENSE_RANK FIRST ORDER BY ) OVER (PARTITION BY  ) "Worst" FROM employees ORDER BY , ]>
  testFunctionRight(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT right(table1.[col1], 4) FROM table1> but was:<SELECT right(table1.[], 4) FROM table1>
  testMultiPartColumnName(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [columnName] FROM tableName> but was:<SELECT [] FROM tableName>
  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 [, CAST(tablea. AS varchar) FROM tablea INNER JOIN tableb ON tablea. = tableb. AND tableb. = 0 WHERE tablea. IS NULL AND 1 = 0) UNION ALL (SELECT  FROM tableb)) SELECT * FROM tablea WHERE  IN (SELECT ] 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.[, ba. AS txt, ba. AS nr, 0 AS level, CAST(gl. AS VARCHAR) AS path, ae. FROM tablea AS gl INNER JOIN tableb AS ba ON gl. = ba. INNER JOIN tablec AS ae ON gl. = ae. AND ae. = 0 WHERE gl. IS NULL AND gl. <> 0) UNION ALL (SELECT gl., ba. AS txt, ba. AS nr, hist. + 1 AS level, CAST(hist. + '.' + CAST(gl. AS VARCHAR) AS VARCHAR) AS path, ae. FROM tablea AS gl INNER JOIN tableb AS ba ON gl. = ba. INNER JOIN tablec AS ae ON gl. = ae. AND ae. = 0 INNER JOIN hist ON gl. = hist. WHERE gl. <> 0)) SELECT , space( * 4) +  AS txt, , ,  FROM hist WHERE EXISTS (SELECT  FROM tablec WHERE  = 0 AND (( IN (1, 2) AND hist. = 3) OR ( IN (4) AND hist.] = 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 * FRO...> but was:<...hist AS ((SELECT gl.[, ba. AS txt, ba. AS nr, 0 AS level, CAST(gl. AS VARCHAR) AS path, ae. FROM tablea AS gl INNER JOIN tableb AS ba ON gl. = ba. INNER JOIN tablec AS ae ON gl. = ae. AND ae. = 0 WHERE gl. IS NULL AND gl. <> 0) UNION ALL (SELECT gl., ba. AS txt, ba. AS nr, hist. + 1 AS level, CAST(hist. + '.' + CAST(gl. AS VARCHAR) AS VARCHAR) AS path, 5 AS feature FROM tablea AS gl INNER JOIN tableb AS ba ON gl. = ba. INNER JOIN tablec AS ae ON gl. = ae. AND ae. = 0 INNER JOIN hist ON gl. = hist. WHERE gl.] <> 0)) SELECT * FRO...>
  testValues5(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [X, Y] FROM (VALUES (0, 'a...> but was:<SELECT [, ] FROM (VALUES (0, 'a...>
  testGroupBy(net.sf.jsqlparser.test.select.SelectTest): expected:<tab1.[b]> but was:<tab1.[]>
  testMultiPartColumnNameWithTableName(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT tableName.[columnName] FROM tableName> but was:<SELECT tableName.[] FROM tableName>
  testMultiPartTableNameWithDatabaseName(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [columnName] FROM databaseName.....> but was:<SELECT [] FROM databaseName.....>
  testLimitSqlServer1(net.sf.jsqlparser.test.select.SelectTest): expected:<...table WHERE mytable.[col = 9 ORDER BY mytable.id] OFFSET 3 ROWS FETCH...> but was:<...table WHERE mytable.[ = 9 ORDER BY mytable.] OFFSET 3 ROWS FETCH...>
  testLimitSqlServer2(net.sf.jsqlparser.test.select.SelectTest): expected:<...table WHERE mytable.[col = 9 ORDER BY mytable.id] OFFSET 3 ROW FETCH ...> but was:<...table WHERE mytable.[ = 9 ORDER BY mytable.] OFFSET 3 ROW FETCH ...>
  testLimitSqlServer3(net.sf.jsqlparser.test.select.SelectTest): expected:<...table WHERE mytable.[col = 9 ORDER BY mytable.id] OFFSET 3 ROWS> but was:<...table WHERE mytable.[ = 9 ORDER BY mytable.] OFFSET 3 ROWS>
  testLimitSqlServer4(net.sf.jsqlparser.test.select.SelectTest): expected:<...table WHERE mytable.[col = 9 ORDER BY mytable.id] FETCH NEXT 5 ROWS O...> but was:<...table WHERE mytable.[ = 9 ORDER BY mytable.] FETCH NEXT 5 ROWS O...>
  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])) FROM DUAL> but was:<...ECT to_char((SELECT [ FROM (SELECT ,  FROM customers t) PIVOT (count() FOR  IN ('NY', 'CT', 'NJ', 'FL', 'MO'))])) FROM DUAL>
  testMultiPartTableNameWithServerNameAndDatabaseName(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [columnName] FROM [server-name\s...> but was:<SELECT [] FROM [server-name\s...>
  testConcatProblem2_1(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT TO_CHAR(SPA.[AANLEVERPERIODEVOLGNR], 'FM09'::VARCHAR) F...> but was:<SELECT TO_CHAR(SPA.[], 'FM09'::VARCHAR) F...>
  testConcatProblem2_2(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT MAX((SPA.[SOORTAANLEVERPERIODE)::VARCHAR (2) || (VARCHAR(SPA.AANLEVERPERIODEJAAR]))::VARCHAR (4)) AS ...> but was:<SELECT MAX((SPA.[)::VARCHAR (2) || (VARCHAR(SPA.]))::VARCHAR (4)) AS ...>
  testConcatProblem2_3(net.sf.jsqlparser.test.select.SelectTest): expected:<...O_CHAR((10000 - SPA.[VERSCHIJNINGSVOLGNR]), 'FM0999'::VARCHAR...> but was:<...O_CHAR((10000 - SPA.[]), 'FM0999'::VARCHAR...>
  testConcatProblem2_4(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT (SPA.[GESLACHT])::VARCHAR (1) FROM ...> but was:<SELECT (SPA.[])::VARCHAR (1) FROM ...>
  testConcatProblem2_5(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT max(([a || b) || c]) FROM testtable> but was:<SELECT max(([ || ) || ]) FROM testtable>
  testConcatProblem2_6(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT max([a || b || c]) FROM testtable> but was:<SELECT max([ ||  || ]) FROM testtable>
  testMultiPartColumnNameWithDatabaseNameAndSchemaNameAndTableName(net.sf.jsqlparser.test.select.SelectTest): expected:<...chemaName.tableName.[columnName] FROM tableName> but was:<...chemaName.tableName.[] FROM tableName>
  testMultiPartColumnNameWithDatabaseNameAndTableName(net.sf.jsqlparser.test.select.SelectTest): expected:<...baseName..tableName.[columnName] FROM tableName> but was:<...baseName..tableName.[] FROM tableName>
  testReplaceAsFunction(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT REPLACE([a, 'b', c]) FROM tab1> but was:<SELECT REPLACE([, 'b', ]) 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 [ FROM users WHERE ( LIKE 'B') AND (] LIKE ?1)>
  testSelectWithinGroup(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT LISTAGG([col1, '##') WITHIN GROUP (ORDER BY col1]) FROM table1> but was:<SELECT LISTAGG([, '##') WITHIN GROUP (ORDER BY ]) FROM table1>
  testNotEqualsTo(net.sf.jsqlparser.test.select.SelectTest): expected:<...CT * FROM foo WHERE [a != b]> but was:<...CT * FROM foo WHERE [ != ]>
  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 [, lag(, 1) OVER (PARTITION BY  ORDER BY , ]) 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 [, lag(, 1, 0) OVER (PARTITION BY  ORDER BY , ]) AS n FROM table1>
  testMatches(net.sf.jsqlparser.test.select.SelectTest): expected:<...ROM team WHERE team.[search_column] @@ to_tsquery('new ...> but was:<...ROM team WHERE team.[] @@ to_tsquery('new ...>
  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 s> but was:<SELECT last_value(s.[) OVER (PARTITION BY s., s., trunc(s., 'mm') ORDER BY s.]) AS col FROM s>
  testFunctions(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT MAX([id) AS max FROM mytable WHERE mytable.col] = 9> but was:<SELECT MAX([) AS max FROM mytable WHERE mytable.] = 9>
  testProblemFunction2(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [sysdate] FROM testtable> but was:<SELECT [] FROM testtable>
  testProblemFunction3(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT TRUNCATE([col]) FROM testtable> but was:<SELECT TRUNCATE([]) 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 [, count() AS num FROM currency HAVING count() > 1]>
  testAnalyticFunction12(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT SUM([a) OVER (PARTITION BY b ORDER BY c]) FROM tab1> but was:<SELECT SUM([) OVER (PARTITION BY  ORDER BY ]) FROM tab1>
  testAnalyticFunction13(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT SUM([a]) OVER () FROM tab1> but was:<SELECT SUM([]) OVER () FROM tab1>
  testAnalyticFunction14(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT SUM([a) OVER (PARTITION BY b] ) FROM tab1> but was:<SELECT SUM([) OVER (PARTITION BY ] ) FROM tab1>
  testAnalyticFunction15(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT SUM([a) OVER (ORDER BY c]) FROM tab1> but was:<SELECT SUM([) OVER (ORDER BY ]) FROM tab1>
  testAnalyticFunction16(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT SUM([a) OVER (ORDER BY c] NULLS FIRST) FROM t...> but was:<SELECT SUM([) OVER (ORDER BY ] NULLS FIRST) FROM t...>
  testAnalyticFunction17(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT AVG([sal) OVER (PARTITION BY deptno ORDER BY sal] ROWS BETWEEN 0 PREC...> but was:<SELECT AVG([) OVER (PARTITION BY  ORDER BY ] ROWS BETWEEN 0 PREC...>
  testAnalyticFunction18(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT AVG([sal) OVER (PARTITION BY deptno ORDER BY sal] RANGE CURRENT ROW) ...> but was:<SELECT AVG([) OVER (PARTITION BY  ORDER BY ] RANGE CURRENT ROW) ...>
  testMultiPartTableNameWithServerNameAndDatabaseNameAndSchemaName(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [columnName] FROM [server-name\s...> but was:<SELECT [] FROM [server-name\s...>
  testBrackets(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT table_a.[name] AS [Test] FROM tabl...> but was:<SELECT table_a.[] AS [Test] FROM tabl...>
  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 [ FROM feature) SELECT * FROM feature WHERE  IN (SELECT ] 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.[, r., r., r. FROM role r WHERE r. = ? AND r. IS NULL ORDER BY r.] DESC>
  testTimestamp(net.sf.jsqlparser.test.select.SelectTest): expected:<...T * FROM tab1 WHERE [a] > {ts '2004-04-30 0...> but was:<...T * FROM tab1 WHERE [] > {ts '2004-04-30 0...>
  testProblemSqlAnalytic5AggregateColumnValue(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [a, sum(b]) OVER () AS n FROM ...> but was:<SELECT [, sum(]) OVER () AS n FROM ...>
  testMultiPartTableNameWithColumnName(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [columnName] FROM tableName> but was:<SELECT [] FROM tableName>
  testFunctionLeft(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT left(table1.[col1], 4) FROM table1> but was:<SELECT left(table1.[], 4) FROM table1>
  testCharacterSetClause(net.sf.jsqlparser.test.select.SelectTest): expected:<...STINCT CAST(`view0`.[`nick2` AS CHAR (8000) CHARACTER SET utf8) AS `v0` FROM people `view0` WHERE `view0`.`nick2`] IS NOT NULL> but was:<...STINCT CAST(`view0`.[ AS CHAR (8000) CHARACTER SET utf8) AS `v0` FROM people `view0` WHERE `view0`.] 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.[::varchar, '') AS a, mytab., mytab. AS st, mytab., mytab. FROM mytab WHERE mytab. = 0) UNION (SELECT 'cde-' || coalesce(mytab2.::varchar, '') AS a, mytab2., mytab2. AS c, 0 AS d, 0 AS e FROM mytab2 WHERE mytab2.] = 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 [, sum( + 5) OVER (ORDER BY ]) 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 ([) ,  FROM mytable WHERE mytable.] = 9>
  testMultiPartColumnNameWithSchemaNameAndTableName(net.sf.jsqlparser.test.select.SelectTest): expected:<...chemaName.tableName.[columnName] FROM tableName> but was:<...chemaName.tableName.[] FROM tableName>
  testMultiPartTableNameWithServerName(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [columnName] FROM [server-name\s...> but was:<SELECT [] FROM [server-name\s...>
  testIssue160_signedParameter(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [start_date WHERE start_date > DATEADD(HH], -?, GETDATE())> but was:<SELECT [ WHERE  > DATEADD(], -?, GETDATE())>
  testConcat(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [a || b || c] + 4 FROM t> but was:<SELECT [ ||  || ] + 4 FROM t>
  testCount2(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT count(ALL [col1 + col2]) FROM mytable> but was:<SELECT count(ALL [ + ]) FROM mytable>
  testSignedColumns(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT -[columnName, +columnName, +(columnName), -(columnName]) FROM tableName> but was:<SELECT -[, +, +(), -(]) FROM tableName>
  testDouble(net.sf.jsqlparser.test.select.SelectTest): expected:<...table WHERE mytable.[col] = 9> but was:<...table WHERE mytable.[] = 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 [, ,  + , sum() FROM table1 GROUP BY , ,  + ]>
  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.[) FROM tab1 WHERE  > 34 GROUP BY tab1. HAVING MAX(tab1.]) > 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.[, d., d., d., d., d. FROM discount d LEFT OUTER JOIN discount_category dc ON d. = dc. WHERE  = ? AND  = ? AND dc. IS NULL AND  < ? AND  >= ?]>
  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 [,  FROM mytable WHERE mytable.] = 9>
  testIsNot2(net.sf.jsqlparser.test.select.SelectTest): expected:<...T * FROM test WHERE [a] IS NOT NULL> but was:<...T * FROM test WHERE [] IS NOT NULL>
  testTopWithParenthesis(net.sf.jsqlparser.test.select.SelectTest): expected:<alias.[columnName1]> but was:<alias.[]>
  testSelectOracleColl(net.sf.jsqlparser.test.select.SelectTest): expected:<...e_table tt WHERE TT.[COL1 = lines(idx]).COL1> but was:<...e_table tt WHERE TT.[ = lines(]).COL1>
  testOracleJoin(net.sf.jsqlparser.test.select.SelectTest): expected:<...lle2 WHERE tabelle1.[a = tabelle2.b](+)> but was:<...lle2 WHERE tabelle1.[ = tabelle2.](+)>
  testPostgreSQLRegExpCaseSensitiveMatch2(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [a, b FROM foo WHERE a] ~* '[help].*'> but was:<SELECT [,  FROM foo WHERE ] ~* '[help].*'>
  testPostgreSQLRegExpCaseSensitiveMatch3(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [a, b FROM foo WHERE a] !~ '[help].*'> but was:<SELECT [,  FROM foo WHERE ] !~ '[help].*'>
  testPostgreSQLRegExpCaseSensitiveMatch4(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [a, b FROM foo WHERE a] !~* '[help].*'> but was:<SELECT [,  FROM foo WHERE ] !~* '[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 ([, ) = (SELECT ,  FROM t2 WHERE ] = 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([, ) = (SELECT ,  FROM t2 WHERE ] = 10)>
  testLimit2(net.sf.jsqlparser.test.select.SelectTest): expected:<...table WHERE mytable.[col] = 9 LIMIT ? OFFSET ...> but was:<...table WHERE mytable.[] = 9 LIMIT ? OFFSET ...>
  testProblemSqlAnalytic2(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [a, row_number() OVER (ORDER BY a, b]) AS n FROM table1> but was:<SELECT [, row_number() OVER (ORDER BY , ]) 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 [, row_number() OVER (PARTITION BY  ORDER BY , ]) 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 [, row_number() OVER (PARTITION BY ,  ORDER BY , ]) AS n FROM table1>
  testSelectWithoutFrom(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT footable.[foocolumn]> but was:<SELECT footable.[]>
  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 [, ,  FROM employees CONNECT BY  = ]>
  testPivot1(net.sf.jsqlparser.test.select.SelectTest): expected:<...ytable PIVOT (count([a) FOR b] IN ('val1'))> but was:<...ytable PIVOT (count([) FOR ] 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([) FOR ] 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, 3...> but was:<...ytable PIVOT (count([) AS vals FOR ] IN (10 AS d1, 20, 3...>
  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([), sum() FOR ] IN (10, 20, 30))>
  testPivot5(net.sf.jsqlparser.test.select.SelectTest): expected:<...ytable PIVOT (count([a) FOR (b, c]) IN ((10, 'a'), (20...> but was:<...ytable PIVOT (count([) FOR (, ]) IN ((10, 'a'), (20...>
  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 UNBOUN...> but was:<SELECT last_value(s.[) OVER (PARTITION BY s., s., trunc(s., 'mm') ORDER BY s.] ROWS BETWEEN UNBOUN...>
  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.[, a. FROM ANTIQUEOWNERS AS a, ANTIQUES AS b WHERE b. = a. AND b.] = '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 [,  FROM customers t) PIVOT (count() FOR  IN ('NY', 'CT', 'NJ', 'FL', 'MO'))]>
  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 [, ,  FROM employees CONNECT BY PRIOR  = ]>
  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 [, , ,  FROM employees START WITH  = 100 CONNECT BY PRIOR  = ]>
  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 [, , ,  FROM employees CONNECT BY PRIOR  =  START WITH  = 100]>
  testExtractFrom1(net.sf.jsqlparser.test.select.SelectTest): expected:<... EXTRACT(month FROM [datecolumn]) FROM testtable> but was:<... EXTRACT(month FROM []) FROM testtable>
  testProblemSqlAnalytic4EmptyOver(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [a], row_number() OVER ...> but was:<SELECT [], row_number() OVER ...>
  testCastTypeProblem(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT CAST([col1] AS varchar (256)) F...> but was:<SELECT CAST([] AS varchar (256)) F...>
  testSelectKeywordPercent(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [percent] FROM MY_TABLE> but was:<SELECT [] FROM MY_TABLE>
  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 [ FROM (VALUES 1, 2, 3) AS MY_TEMP_TABLE(I) WHERE ] IN (SELECT * FROM (...>
  testMultiPartTableNameWithServerNameAndSchemaName(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT [columnName] FROM [server-name\s...> but was:<SELECT [] FROM [server-name\s...>
  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) + ' month' F...> but was:<...char(255), DATEDIFF([, , ) / 12) + ' year, ' + convert(varchar(255), DATEDIFF(, , ]) % 12) + ' month' F...>
  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 [, , , , , , , , , , , , , , ] FROM tableName>
  testLimitSqlServerJdbcParameters(net.sf.jsqlparser.test.select.SelectTest): expected:<...table WHERE mytable.[col = 9 ORDER BY mytable.id] OFFSET ? ROWS FETCH...> but was:<...table WHERE mytable.[ = 9 ORDER BY mytable.] OFFSET ? ROWS FETCH...>
  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.[, pg_attribute., pg_constraint. FROM pg_constraint JOIN pg_class ON pg_class. = pg_constraint. JOIN pg_attribute ON pg_attribute. = pg_constraint. WHERE pg_constraint. = 'u' AND (pg_attribute. = ANY(pg_constraint.)) ORDER BY pg_constraint.]>
  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 [, min() KEEP (DENSE_RANK FIRST ORDER BY ),  FROM table1]>
  testNamedParameter2(net.sf.jsqlparser.test.select.SelectTest): expected:<... FROM mytable WHERE [a = :param OR a = :param2 AND b] = :param3> but was:<... FROM mytable WHERE [ = :param OR  = :param2 AND ] = :param3>
  testBooleanFunction1(net.sf.jsqlparser.test.select.SelectTest): expected:<...ble WHERE test_func([col1])> but was:<...ble WHERE test_func([])>
  testCastInCast2(net.sf.jsqlparser.test.select.SelectTest): expected:<... CAST('test' + CAST([assertEqual] AS numeric) AS varc...> but was:<... CAST('test' + CAST([] AS numeric) AS varc...>
  testNamedParameter(net.sf.jsqlparser.test.select.SelectTest): expected:<... FROM mytable WHERE [b] = :param> but was:<... FROM mytable WHERE [] = :param>
  testVisit_PlainSelect_concat(net.sf.jsqlparser.util.ConnectExpressionsVisitorTest): expected:<SELECT [a || b || c] AS expr FROM test> but was:<SELECT [ ||  || ] AS expr FROM test>
  testVisit_PlainSelect_addition(net.sf.jsqlparser.util.ConnectExpressionsVisitorTest): expected:<SELECT [a + b + c] AS testexpr FROM te...> but was:<SELECT [ +  + ] AS testexpr FROM te...>
  testVisit_PlainSelect(net.sf.jsqlparser.util.AddAliasesVisitorTest): expected:<SELECT [a AS A1, b AS A2, c] AS A3 FROM test> but was:<SELECT [ AS A1,  AS A2, ] 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 [ AS A2,  AS a1, ] AS A3 FROM test>
  testBuildSelectFromTableAndExpressions(net.sf.jsqlparser.util.SelectUtilsTest): expected:<SELECT [a, b] FROM mytable> but was:<SELECT [, ] FROM mytable>
  testAddExpr(net.sf.jsqlparser.util.SelectUtilsTest): expected:<SELECT [a, b] FROM mytable> but was:<SELECT [, ] FROM mytable>
  testAddJoin(net.sf.jsqlparser.util.SelectUtilsTest): expected:<SELECT [a FROM mytable LEFT JOIN mytable2 ON a = b]> but was:<SELECT [ FROM mytable LEFT JOIN mytable2 ON  = ]>
  testBuildSelectFromTableWithGroupBy(net.sf.jsqlparser.util.SelectUtilsTest): expected:<...ELECT * FROM mytable[ GROUP BY b]> but was:<...ELECT * FROM mytable[]>
  testBuildSelectFromTableAndParsedExpression(net.sf.jsqlparser.util.SelectUtilsTest): expected:<SELECT [a + b, test] FROM mytable> but was:<SELECT [ + , ] FROM mytable>
  testParseExpression2(net.sf.jsqlparser.parser.CCJSqlParserUtilTest): expected:<2 * ([a] + 6.0)> but was:<2 * ([] + 6.0)>
  testParseCondExpression(net.sf.jsqlparser.parser.CCJSqlParserUtilTest): expected:<[a + b > 5 AND c] < 3> but was:<[ +  > 5 AND ] < 3>
  testParseExpression(net.sf.jsqlparser.parser.CCJSqlParserUtilTest): expected:<[a + b]> but was:<[ + ]>

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

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