[INFO] Scanning for projects...
[INFO]                                                                         
[INFO] ------------------------------------------------------------------------
[INFO] Building JSQLParser library 0.9.4
[INFO] ------------------------------------------------------------------------
[INFO] 
[INFO] --- javacc-maven-plugin:2.6:jjtree-javacc (javacc) @ jsqlparser ---
[INFO] Skipping - all parsers are up to date
[INFO] 
[INFO] --- license-maven-plugin:1.6:update-file-header (first) @ jsqlparser ---
[INFO] Will search files to update from root /home/perham/Study/Experiments/2015-10-23-ICST/LittleDarwin/Cases/JSqlParser-jsqlparser-0.9.4/src/main/java
[INFO]  - adding license header on file /home/perham/Study/Experiments/2015-10-23-ICST/LittleDarwin/Cases/JSqlParser-jsqlparser-0.9.4/src/main/java/net/sf/jsqlparser/util/deparser/SelectDeParser.java
[INFO] Scan 164 files header done in 217.02ms.
[INFO] 
 * uptodate header on 163 files.
 * add header on 1 file.
[INFO] 
[INFO] --- maven-resources-plugin:2.6:resources (default-resources) @ jsqlparser ---
[INFO] Using 'UTF-8' encoding to copy filtered resources.
[INFO] skip non existing resourceDirectory /home/perham/Study/Experiments/2015-10-23-ICST/LittleDarwin/Cases/JSqlParser-jsqlparser-0.9.4/src/main/resources
[INFO] 
[INFO] --- maven-compiler-plugin:3.3:compile (default-compile) @ jsqlparser ---
[INFO] Changes detected - recompiling the module!
[INFO] Compiling 177 source files to /home/perham/Study/Experiments/2015-10-23-ICST/LittleDarwin/Cases/JSqlParser-jsqlparser-0.9.4/target/classes
[WARNING] bootstrap class path not set in conjunction with -source 1.6
[INFO] /home/perham/Study/Experiments/2015-10-23-ICST/LittleDarwin/Cases/JSqlParser-jsqlparser-0.9.4/target/generated-sources/javacc/net/sf/jsqlparser/parser/CCJSqlParser.java: /home/perham/Study/Experiments/2015-10-23-ICST/LittleDarwin/Cases/JSqlParser-jsqlparser-0.9.4/target/generated-sources/javacc/net/sf/jsqlparser/parser/CCJSqlParser.java uses unchecked or unsafe operations.
[INFO] /home/perham/Study/Experiments/2015-10-23-ICST/LittleDarwin/Cases/JSqlParser-jsqlparser-0.9.4/target/generated-sources/javacc/net/sf/jsqlparser/parser/CCJSqlParser.java: Recompile with -Xlint:unchecked for details.
[INFO] 
[INFO] --- maven-resources-plugin:2.6:testResources (default-testResources) @ jsqlparser ---
[INFO] Using 'UTF-8' encoding to copy filtered resources.
[INFO] Copying 280 resources
[INFO] 
[INFO] --- maven-compiler-plugin:3.3:testCompile (default-testCompile) @ jsqlparser ---
[INFO] Nothing to compile - all classes are up to date
[INFO] 
[INFO] --- maven-surefire-plugin:2.10:test (default-test) @ jsqlparser ---
[INFO] Surefire report directory: /home/perham/Study/Experiments/2015-10-23-ICST/LittleDarwin/Cases/JSqlParser-jsqlparser-0.9.4/target/surefire-reports

-------------------------------------------------------
 T E S T S
-------------------------------------------------------
Running net.sf.jsqlparser.test.alter.AlterTest
Tests run: 3, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.056 sec
Running net.sf.jsqlparser.test.create.CreateTableTest
Tests run: 27, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.13 sec
Running net.sf.jsqlparser.test.create.CreateIndexTest
Tests run: 6, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.005 sec
Running net.sf.jsqlparser.test.create.CreateViewTest
Tests run: 8, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.011 sec
Running net.sf.jsqlparser.test.delete.DeleteTest
Tests run: 2, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.005 sec
Running net.sf.jsqlparser.test.simpleparsing.CCJSqlParserManagerTest
Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.181 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: 0, Errors: 2, Skipped: 0, Time elapsed: 0.055 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: 0, Errors: 2, Skipped: 0, Time elapsed: 0.001 sec <<< FAILURE!
Running net.sf.jsqlparser.test.replace.ReplaceTest
Tests run: 4, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.001 sec
Running net.sf.jsqlparser.test.select.SelectASTTest
*Statement
* Column
* Column
* Table
* Column
* Column
Tests run: 2, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.001 sec
Running net.sf.jsqlparser.test.select.SpecialOracleTest
Oct 06, 2015 8:58:52 AM net.sf.jsqlparser.test.select.SpecialOracleTest testAllSqlsParseDeparse
INFO: testing string01.sql
Oct 06, 2015 8:58:52 AM net.sf.jsqlparser.test.select.SpecialOracleTest testAllSqlsParseDeparse
INFO:    -> PROBLEM net.sf.jsqlparser.JSQLParserException
Oct 06, 2015 8:58:52 AM net.sf.jsqlparser.test.select.SpecialOracleTest testAllSqlsParseDeparse
INFO: testing returning01.sql
Oct 06, 2015 8:58:52 AM net.sf.jsqlparser.test.select.SpecialOracleTest testAllSqlsParseDeparse
INFO:    -> PROBLEM net.sf.jsqlparser.JSQLParserException
Oct 06, 2015 8:58:52 AM net.sf.jsqlparser.test.select.SpecialOracleTest testAllSqlsParseDeparse
INFO: testing keywordasidentifier05.sql
Oct 06, 2015 8:58:52 AM net.sf.jsqlparser.test.select.SpecialOracleTest testAllSqlsParseDeparse
INFO:    -> PROBLEM java.lang.NullPointerException
Oct 06, 2015 8:58:52 AM net.sf.jsqlparser.test.select.SpecialOracleTest testAllSqlsParseDeparse
INFO: testing function07.sql
Oct 06, 2015 8:58:52 AM net.sf.jsqlparser.test.select.SpecialOracleTest testAllSqlsParseDeparse
INFO:    -> PROBLEM net.sf.jsqlparser.JSQLParserException
Oct 06, 2015 8:58:52 AM net.sf.jsqlparser.test.select.SpecialOracleTest testAllSqlsParseDeparse
INFO: testing cast_multiset15.sql
Oct 06, 2015 8:58:52 AM net.sf.jsqlparser.test.select.SpecialOracleTest testAllSqlsParseDeparse
INFO:    -> PROBLEM net.sf.jsqlparser.JSQLParserException
Oct 06, 2015 8:58:52 AM net.sf.jsqlparser.test.select.SpecialOracleTest testAllSqlsParseDeparse
INFO: testing interval01.sql
Oct 06, 2015 8:58:52 AM net.sf.jsqlparser.test.select.SpecialOracleTest testAllSqlsParseDeparse
INFO:    -> PROBLEM net.sf.jsqlparser.JSQLParserException
Oct 06, 2015 8:58:52 AM net.sf.jsqlparser.test.select.SpecialOracleTest testAllSqlsParseDeparse
INFO: testing analytic_query04.sql
Oct 06, 2015 8:58:52 AM net.sf.jsqlparser.test.select.SpecialOracleTest testAllSqlsParseDeparse
INFO:    -> PROBLEM net.sf.jsqlparser.JSQLParserException
Oct 06, 2015 8:58:52 AM net.sf.jsqlparser.test.select.SpecialOracleTest testAllSqlsParseDeparse
INFO: testing join10.sql
Oct 06, 2015 8:58:52 AM net.sf.jsqlparser.test.select.SpecialOracleTest testAllSqlsParseDeparse
INFO:    -> PROBLEM java.lang.NullPointerException
Oct 06, 2015 8:58:52 AM net.sf.jsqlparser.test.select.SpecialOracleTest testAllSqlsParseDeparse
INFO: testing pivot04.sql
Oct 06, 2015 8:58:52 AM net.sf.jsqlparser.test.select.SpecialOracleTest testAllSqlsParseDeparse
INFO:    -> PROBLEM net.sf.jsqlparser.JSQLParserException
Oct 06, 2015 8:58:52 AM net.sf.jsqlparser.test.select.SpecialOracleTest testAllSqlsParseDeparse
INFO: testing condition08.sql
Oct 06, 2015 8:58:52 AM net.sf.jsqlparser.test.select.SpecialOracleTest testAllSqlsParseDeparse
INFO:    -> PROBLEM net.sf.jsqlparser.JSQLParserException
Oct 06, 2015 8:58:52 AM net.sf.jsqlparser.test.select.SpecialOracleTest testAllSqlsParseDeparse
INFO: testing function03.sql
Oct 06, 2015 8:58:52 AM net.sf.jsqlparser.test.select.SpecialOracleTest testAllSqlsParseDeparse
INFO:    -> PROBLEM net.sf.jsqlparser.JSQLParserException
Oct 06, 2015 8:58:52 AM net.sf.jsqlparser.test.select.SpecialOracleTest testAllSqlsParseDeparse
INFO: testing merge03.sql
Oct 06, 2015 8:58:52 AM net.sf.jsqlparser.test.select.SpecialOracleTest testAllSqlsParseDeparse
INFO:    -> PROBLEM net.sf.jsqlparser.JSQLParserException
Oct 06, 2015 8:58:52 AM net.sf.jsqlparser.test.select.SpecialOracleTest testAllSqlsParseDeparse
INFO: testing insert02.sql
Oct 06, 2015 8:58:52 AM net.sf.jsqlparser.test.select.SpecialOracleTest testAllSqlsParseDeparse
INFO:    -> PROBLEM net.sf.jsqlparser.JSQLParserException
Oct 06, 2015 8:58:52 AM net.sf.jsqlparser.test.select.SpecialOracleTest testAllSqlsParseDeparse
INFO: testing insert11.sql
Oct 06, 2015 8:58:52 AM net.sf.jsqlparser.test.select.SpecialOracleTest testAllSqlsParseDeparse
INFO:    -> PROBLEM net.sf.jsqlparser.JSQLParserException
Oct 06, 2015 8:58:52 AM net.sf.jsqlparser.test.select.SpecialOracleTest testAllSqlsParseDeparse
INFO: testing interval02.sql
Oct 06, 2015 8:58:52 AM net.sf.jsqlparser.test.select.SpecialOracleTest testAllSqlsParseDeparse
INFO:    -> PROBLEM java.lang.NullPointerException
Oct 06, 2015 8:58:52 AM net.sf.jsqlparser.test.select.SpecialOracleTest testAllSqlsParseDeparse
INFO: testing cast_multiset18.sql
Oct 06, 2015 8:58:52 AM net.sf.jsqlparser.test.select.SpecialOracleTest testAllSqlsParseDeparse
INFO:    -> PROBLEM net.sf.jsqlparser.JSQLParserException
Oct 06, 2015 8:58:52 AM net.sf.jsqlparser.test.select.SpecialOracleTest testAllSqlsParseDeparse
INFO: testing query_factoring08.sql
Oct 06, 2015 8:58:52 AM net.sf.jsqlparser.test.select.SpecialOracleTest testAllSqlsParseDeparse
INFO:    -> PROBLEM java.lang.NullPointerException
Oct 06, 2015 8:58:52 AM net.sf.jsqlparser.test.select.SpecialOracleTest testAllSqlsParseDeparse
INFO: testing condition04.sql
Oct 06, 2015 8:58:58 AM net.sf.jsqlparser.test.select.SpecialOracleTest testAllSqlsOnlyParse
INFO: testing comment02.sql
Oct 06, 2015 8:58:58 AM net.sf.jsqlparser.test.select.SpecialOracleTest testAllSqlsOnlyParse
INFO:    -> SUCCESS
Oct 06, 2015 8:58:58 AM net.sf.jsqlparser.test.select.SpecialOracleTest testAllSqlsOnlyParse
INFO: testing numbers02.sql
Oct 06, 2015 8:58:58 AM net.sf.jsqlparser.test.select.SpecialOracleTest testAllSqlsOnlyParse
INFO:    -> SUCCESS
Oct 06, 2015 8:58:58 AM net.sf.jsqlparser.test.select.SpecialOracleTest testAllSqlsOnlyParse
INFO: testing comment01.sql
Oct 06, 2015 8:58:58 AM net.sf.jsqlparser.test.select.SpecialOracleTest testAllSqlsOnlyParse
INFO:    -> SUCCESS
Tests run: 2, Failures: 1, Errors: 0, Skipped: 0, Time elapsed: 6.657 sec <<< FAILURE!
Running net.sf.jsqlparser.test.select.SelectTest
Tests run: 228, Failures: 65, Errors: 152, Skipped: 0, Time elapsed: 0.256 sec <<< FAILURE!
Running net.sf.jsqlparser.test.select.SpeedTest
42500 statements parsed in 7932 milliseconds
 (5358 statements per second,  0.0001866 seconds per statement )
38500 select scans for table name executed in 127 milliseconds
 (303149 select scans for table name per second,  0.0000033 seconds per select scans for table name)
Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 8.048 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.012 sec
Running net.sf.jsqlparser.util.ConnectExpressionsVisitorTest
Tests run: 2, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.001 sec
Running net.sf.jsqlparser.util.AddAliasesVisitorTest
Tests run: 4, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.002 sec
Running net.sf.jsqlparser.util.SelectUtilsTest
Tests run: 6, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.003 sec
Running net.sf.jsqlparser.expression.ExpressionVisitorAdapterTest
Tests run: 2, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.003 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.001 sec
Running net.sf.jsqlparser.parser.CCJSqlParserUtilTest
Tests run: 3, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.001 sec
Running net.sf.jsqlparser.statement.SetStatementTest
Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.004 sec
Running net.sf.jsqlparser.statement.AdaptersTest
Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.001 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:   testAllSqlsParseDeparse(net.sf.jsqlparser.test.select.SpecialOracleTest): expected:<select*from t[ where((((((((((((((((type='2')or(type='3'))and(t.cde<20))and(t.se='xxx'))and(t.id='000000000002'))and((t.attr_1 is null)or(t.attr_1='*')))and((t.attr_2 is null)or(t.attr_2='*')))and((t.attr_3 is null)or(t.attr_3='*')))and((t.attr_4 is null)or(t.attr_4='*')))and((t.attr_5 is null)or(t.attr_5='*')))and((t.itype is null)or(t.itype='*')))and((t.inbr is null)or(t.inbr='*')))and((t.stat='01')or(t.stat='*')))and((t.orgn is null)or(t.orgn='*')))and(t.mbr='0000000000001'))and(t.nbr is null))]> but was:<select*from t[]>
  testAllConditionSubSelect(net.sf.jsqlparser.test.select.SelectTest): expected:<..., e1.sal FROM emp e1[ WHERE e1.sal > ALL (SELECT e2.sal FROM emp e2 WHERE e2.deptno = 10)]> but was:<..., e1.sal FROM emp e1[]>
  testMultiValueIn2(net.sf.jsqlparser.test.select.SelectTest): expected:<...ELECT * FROM mytable[ WHERE (trim(a), trim(b)) IN (SELECT a, b FROM mytable2)]> but was:<...ELECT * FROM mytable[]>
  testSelectForUpdateOfTable(net.sf.jsqlparser.test.select.SelectTest): expected:<...bar.* FROM foo, bar [WHERE foo.id = bar.foo_id ]FOR UPDATE OF foo> but was:<...bar.* FROM 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 a, b FROM foo[]>
  testOracleJoin2(net.sf.jsqlparser.test.select.SelectTest): expected:<...M tabelle1, tabelle2[ WHERE tabelle1.a(+) = tabelle2.b]> but was:<...M tabelle1, tabelle2[]>
  testOracleJoin3(net.sf.jsqlparser.test.select.SelectTest): expected:<...M tabelle1, tabelle2[ WHERE tabelle1.a(+) > tabelle2.b]> but was:<...M tabelle1, tabelle2[]>
  testOracleJoin4(net.sf.jsqlparser.test.select.SelectTest): expected:<...M tabelle1, tabelle2[ WHERE tabelle1.a(+) = tabelle2.b AND tabelle1.b(+) IN ('A', 'B')]> but was:<...M tabelle1, tabelle2[]>
  testOrderBy(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT * FROM tab1 [WHERE a > 34 ]GROUP BY tab1.b ORDE...> but was:<SELECT * FROM tab1 []GROUP BY tab1.b ORDE...>
  testSelectJoinWithComma(net.sf.jsqlparser.test.select.SelectTest): expected:<... unigeoestados AS es[ WHERE es.nombre = "Tamaulipas" AND cb.the_geom = es.geom]> but was:<... unigeoestados AS es[]>
  testTop(net.sf.jsqlparser.test.select.SelectTest): expected:<...TOP 3 * FROM mytable[ WHERE mytable.col = 9]> but was:<...TOP 3 * FROM mytable[]>
  testMysqlQuote(net.sf.jsqlparser.test.select.SelectTest): expected:<... AS a, ANTIQUES AS b[ WHERE b.BUYERID = a.OWNERID AND b.ITEM = 'Chair']> but was:<... AS a, ANTIQUES AS b[]>
  testIlike(net.sf.jsqlparser.test.select.SelectTest): expected:<...ECT col1 FROM table1[ WHERE col1 ILIKE '%hello%']> but was:<...ECT col1 FROM table1[]>
  testIsNot(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT * FROM test[ WHERE a IS NOT NULL]> but was:<SELECT * FROM test[]>
  testLimit(net.sf.jsqlparser.test.select.SelectTest): expected:<...LECT * FROM mytable [WHERE mytable.col = 9 ]LIMIT ? OFFSET 3> but was:<...LECT * FROM mytable []LIMIT ? OFFSET 3>
  testRegexpLike1(net.sf.jsqlparser.test.select.SelectTest): expected:<...ELECT * FROM mytable[ WHERE REGEXP_LIKE(first_name, '^Ste(v|ph)en$')]> but was:<...ELECT * FROM mytable[]>
  testRegexpMySQL(net.sf.jsqlparser.test.select.SelectTest): expected:<...ELECT * FROM mytable[ WHERE first_name REGEXP '^Ste(v|ph)en$']> but was:<...ELECT * FROM mytable[]>
  testLike(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT * FROM tab1[ WHERE a LIKE 'test']> but was:<SELECT * FROM tab1[]>
  testTime(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT * FROM tab1[ WHERE a > {t '04:05:34'}]> but was:<SELECT * FROM tab1[]>
  testProblemSqlAnalytic8Complex(net.sf.jsqlparser.test.select.SelectTest): expected:<...AS ROWS2 FROM STAFF [WHERE ID < 60 ]ORDER BY ID> but was:<...AS ROWS2 FROM STAFF []ORDER BY ID>
  testOracleJoin2_1(net.sf.jsqlparser.test.select.SelectTest): expected:<...om tabelle1,tabelle2[ where tabelle1.a(+)=tabelle2.b]> but was:<...om tabelle1,tabelle2[]>
  testOracleJoin2_2(net.sf.jsqlparser.test.select.SelectTest): expected:<...om tabelle1,tabelle2[ where tabelle1.a=tabelle2.b(+)]> but was:<...om tabelle1,tabelle2[]>
  testOracleJoin3_1(net.sf.jsqlparser.test.select.SelectTest): expected:<...M tabelle1, tabelle2[ WHERE tabelle1.a > tabelle2.b(+)]> but was:<...M tabelle1, tabelle2[]>
  testAnyConditionSubSelect(net.sf.jsqlparser.test.select.SelectTest): expected:<..., e1.sal FROM emp e1[ WHERE e1.sal > ANY (SELECT e2.sal FROM emp e2 WHERE e2.deptno = 10)]> but was:<..., e1.sal FROM emp e1[]>
  testIssue160_signedParameter2(net.sf.jsqlparser.test.select.SelectTest): expected:<...ELECT * FROM mytable[ WHERE -? = 5]> but was:<...ELECT * FROM mytable[]>
  testSelectNumericBind(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT a FROM b[ WHERE c = :1]> but was:<SELECT a FROM b[]>
  testRegexpBinaryMySQL(net.sf.jsqlparser.test.select.SelectTest): expected:<...ELECT * FROM mytable[ WHERE first_name REGEXP BINARY '^Ste(v|ph)en$']> but was:<...ELECT * FROM mytable[]>
  testMultiValueIn(net.sf.jsqlparser.test.select.SelectTest): expected:<...ELECT * FROM mytable[ WHERE (a, b, c) IN (SELECT a, b, c FROM mytable2)]> but was:<...ELECT * FROM mytable[]>
  testSelectItems(net.sf.jsqlparser.test.select.SelectTest): expected:<...mytab.* FROM mytable[ WHERE mytable.col = 9]> but was:<...mytab.* FROM mytable[]>
  testSelectJoin2(net.sf.jsqlparser.test.select.SelectTest): expected:<...* FROM pg_constraint[ WHERE pg_attribute.attnum = ANY(pg_constraint.conkey)]> but was:<...* FROM pg_constraint[]>
  testWithUnionProblem4(net.sf.jsqlparser.test.select.SelectTest): expected:<...k 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:<...k AND ae.deleted = 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)) SELECT mslink, space(level * 4) + txt AS txt, nr, feature, path FROM hist]>
  testGroupBy(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT * FROM tab1 [WHERE a > 34 ]GROUP BY tab1.b> but was:<SELECT * FROM tab1 []GROUP BY tab1.b>
  testLimitSqlServer1(net.sf.jsqlparser.test.select.SelectTest): expected:<...LECT * FROM mytable [WHERE mytable.col = 9 ]ORDER BY mytable.id ...> but was:<...LECT * FROM mytable []ORDER BY mytable.id ...>
  testLimitSqlServer2(net.sf.jsqlparser.test.select.SelectTest): expected:<...LECT * FROM mytable [WHERE mytable.col = 9 ]ORDER BY mytable.id ...> but was:<...LECT * FROM mytable []ORDER BY mytable.id ...>
  testLimitSqlServer3(net.sf.jsqlparser.test.select.SelectTest): expected:<...LECT * FROM mytable [WHERE mytable.col = 9 ]ORDER BY mytable.id ...> but was:<...LECT * FROM mytable []ORDER BY mytable.id ...>
  testLimitSqlServer4(net.sf.jsqlparser.test.select.SelectTest): expected:<...LECT * FROM mytable [WHERE mytable.col = 9 ]ORDER BY mytable.id ...> but was:<...LECT * FROM mytable []ORDER BY mytable.id ...>
  testSelectJPQLPositionalParameter(net.sf.jsqlparser.test.select.SelectTest): expected:<...ECT email FROM users[ WHERE (type LIKE 'B') AND (username LIKE ?1)]> but was:<...ECT email FROM users[]>
  testNotEqualsTo(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT * FROM foo[ WHERE a != b]> but was:<SELECT * FROM foo[]>
  testMatches(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT * FROM team[ WHERE team.search_column @@ to_tsquery('new & york & yankees')]> but was:<SELECT * FROM team[]>
  testFunctions(net.sf.jsqlparser.test.select.SelectTest): expected:<... AS max FROM mytable[ WHERE mytable.col = 9]> but was:<... AS max FROM mytable[]>
  testIssue154_2(net.sf.jsqlparser.test.select.SelectTest): expected:<...em_role FROM role r [WHERE r.merchant_id = ? AND r.deleted_time IS NULL ]ORDER BY r.id DESC> but was:<...em_role FROM role r []ORDER BY r.id DESC>
  testTimestamp(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT * FROM tab1[ WHERE a > {ts '2004-04-30 04:05:34.56'}]> but was:<SELECT * FROM tab1[]>
  testCharacterSetClause(net.sf.jsqlparser.test.select.SelectTest): expected:<... FROM people `view0`[ WHERE `view0`.`nick2` IS NOT NULL]> but was:<... FROM people `view0`[]>
  testComplexUnion1(net.sf.jsqlparser.test.select.SelectTest): expected:<..., 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:<..., mytab.e FROM mytab[) UNION (SELECT 'cde-' || coalesce(mytab2.a::varchar, '') AS a, mytab2.b, mytab2.bezeichnung AS c, 0 AS d, 0 AS e FROM mytab2])>
  testDistinct(net.sf.jsqlparser.test.select.SelectTest): expected:<..., mycol FROM mytable[ WHERE mytable.col = 9]> but was:<..., mycol FROM mytable[]>
  testIssue160_signedParameter(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT start_date[ WHERE start_date > DATEADD(HH, -?, GETDATE())]> but was:<SELECT start_date[]>
  testDouble(net.sf.jsqlparser.test.select.SelectTest): expected:<... 1e2, * FROM mytable[ WHERE mytable.col = 9]> but was:<... 1e2, * FROM mytable[]>
  testHaving(net.sf.jsqlparser.test.select.SelectTest): expected:<...X(tab1.b) FROM tab1 [WHERE a > 34 ]GROUP BY tab1.b HAVI...> but was:<...X(tab1.b) FROM tab1 []GROUP BY tab1.b HAVI...>
  testIssue154(net.sf.jsqlparser.test.select.SelectTest): expected:<...id = dc.discount_id [WHERE merchant_id = ? AND deleted = ? AND dc.discount_id IS NULL AND modified_time < ? AND modified_time >= ? ]ORDER BY modified_ti...> but was:<...id = dc.discount_id []ORDER BY modified_ti...>
  testDistinctTop(net.sf.jsqlparser.test.select.SelectTest): expected:<..., mycol FROM mytable[ WHERE mytable.col = 9]> but was:<..., mycol FROM mytable[]>
  testIsNot2(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT * FROM test[ WHERE a IS NOT NULL]> but was:<SELECT * FROM test[]>
  testSelectOracleColl(net.sf.jsqlparser.test.select.SelectTest): expected:<... * FROM the_table tt[ WHERE TT.COL1 = lines(idx).COL1]> but was:<... * FROM the_table tt[]>
  testOracleJoin(net.sf.jsqlparser.test.select.SelectTest): expected:<...M tabelle1, tabelle2[ WHERE tabelle1.a = tabelle2.b(+)]> but was:<...M tabelle1, tabelle2[]>
  testPostgreSQLRegExpCaseSensitiveMatch2(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT a, b FROM foo[ WHERE a ~* '[help].*']> but was:<SELECT a, b FROM foo[]>
  testPostgreSQLRegExpCaseSensitiveMatch3(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT a, b FROM foo[ WHERE a !~ '[help].*']> but was:<SELECT a, b FROM foo[]>
  testPostgreSQLRegExpCaseSensitiveMatch4(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT a, b FROM foo[ WHERE a !~* '[help].*']> but was:<SELECT a, b FROM foo[]>
  testRowConstructor1(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT * FROM t1[ WHERE (col1, col2) = (SELECT col3, col4 FROM t2 WHERE id = 10)]> but was:<SELECT * FROM t1[]>
  testRowConstructor2(net.sf.jsqlparser.test.select.SelectTest): expected:<SELECT * FROM t1[ WHERE ROW(col1, col2) = (SELECT col3, col4 FROM t2 WHERE id = 10)]> but was:<SELECT * FROM t1[]>
  testLimit2(net.sf.jsqlparser.test.select.SelectTest): expected:<...LECT * FROM mytable [WHERE mytable.col = 9 ]LIMIT ? OFFSET 3> but was:<...LECT * FROM mytable []LIMIT ? OFFSET 3>
  testDeparser(net.sf.jsqlparser.test.select.SelectTest): expected:<... AS a, ANTIQUES AS b[ WHERE b.BUYERID = a.OWNERID AND b.ITEM = 'Chair']> but was:<... AS a, ANTIQUES AS b[]>
  testValues6BothVariants(net.sf.jsqlparser.test.select.SelectTest): expected:<... AS MY_TEMP_TABLE(I)[ WHERE I IN (SELECT * FROM (VALUES 1, 2) AS TEST)]> but was:<... AS MY_TEMP_TABLE(I)[]>
  testLimitSqlServerJdbcParameters(net.sf.jsqlparser.test.select.SelectTest): expected:<...LECT * FROM mytable [WHERE mytable.col = 9 ]ORDER BY mytable.id ...> but was:<...LECT * FROM mytable []ORDER BY mytable.id ...>
  testSelectJoin(net.sf.jsqlparser.test.select.SelectTest): expected:<...constraint.conrelid [WHERE pg_constraint.contype = 'u' AND (pg_attribute.attnum = ANY(pg_constraint.conkey)) ]ORDER BY pg_constrai...> but was:<...constraint.conrelid []ORDER BY pg_constrai...>
  testNamedParameter2(net.sf.jsqlparser.test.select.SelectTest): expected:<...ELECT * FROM mytable[ WHERE a = :param OR a = :param2 AND b = :param3]> but was:<...ELECT * FROM mytable[]>
  testBooleanFunction1(net.sf.jsqlparser.test.select.SelectTest): expected:<...ELECT * FROM mytable[ WHERE test_func(col1)]> but was:<...ELECT * FROM mytable[]>
  testNamedParameter(net.sf.jsqlparser.test.select.SelectTest): expected:<...ELECT * FROM mytable[ WHERE b = :param]> but was:<...ELECT * FROM mytable[]>

Tests in error: 
  testInsertWithSelect(net.sf.jsqlparser.test.insert.InsertTest)
  testInsertSelect(net.sf.jsqlparser.test.insert.InsertTest)
  testUpdateWithSelect2(net.sf.jsqlparser.test.update.UpdateTest)
  testUpdateWithSelect(net.sf.jsqlparser.test.update.UpdateTest)
  testSelectAliasWithoutAs(net.sf.jsqlparser.test.select.SelectTest)
  testSimpleSigns(net.sf.jsqlparser.test.select.SelectTest)
  testMultiPartTableNameWithSchemaName(net.sf.jsqlparser.test.select.SelectTest)
  testSelectBrackets2(net.sf.jsqlparser.test.select.SelectTest)
  testSelectBrackets3(net.sf.jsqlparser.test.select.SelectTest)
  testSelectBrackets4(net.sf.jsqlparser.test.select.SelectTest)
  testSimpleAdditionsAndSubtractionsWithSigns(net.sf.jsqlparser.test.select.SelectTest)
  testSelectAliasInQuotes(net.sf.jsqlparser.test.select.SelectTest)
  testCastTypeProblem2(net.sf.jsqlparser.test.select.SelectTest)
  testCastTypeProblem3(net.sf.jsqlparser.test.select.SelectTest)
  testCastTypeProblem4(net.sf.jsqlparser.test.select.SelectTest)
  testCastTypeProblem5(net.sf.jsqlparser.test.select.SelectTest)
  testCastTypeProblem6(net.sf.jsqlparser.test.select.SelectTest)
  testCastTypeProblem7(net.sf.jsqlparser.test.select.SelectTest)
  testCastInCast(net.sf.jsqlparser.test.select.SelectTest)
  testSkipFirst(net.sf.jsqlparser.test.select.SelectTest)
  testMultiPartTableNameWithDatabaseNameAndSchemaName(net.sf.jsqlparser.test.select.SelectTest)
  testAdditionalLettersGerman(net.sf.jsqlparser.test.select.SelectTest)
  testWithUnionProblem(net.sf.jsqlparser.test.select.SelectTest)
  testSelectInnerWith(net.sf.jsqlparser.test.select.SelectTest)
  testReservedKeyword2(net.sf.jsqlparser.test.select.SelectTest)
  testFirst(net.sf.jsqlparser.test.select.SelectTest)
  testSigns(net.sf.jsqlparser.test.select.SelectTest)
  testUnion(net.sf.jsqlparser.test.select.SelectTest)
  testRegexpLike2(net.sf.jsqlparser.test.select.SelectTest)
  testCase(net.sf.jsqlparser.test.select.SelectTest)
  testCast(net.sf.jsqlparser.test.select.SelectTest)
  testFrom(net.sf.jsqlparser.test.select.SelectTest)
  testJoin(net.sf.jsqlparser.test.select.SelectTest)
  testSkip(net.sf.jsqlparser.test.select.SelectTest)
  testWith(net.sf.jsqlparser.test.select.SelectTest)
  testJsonExpression(net.sf.jsqlparser.test.select.SelectTest)
  testConcatProblem2_5_1(net.sf.jsqlparser.test.select.SelectTest)
  testConcatProblem2_5_2(net.sf.jsqlparser.test.select.SelectTest)
  testWithUnionAllProblem(net.sf.jsqlparser.test.select.SelectTest)
  testPivotXml1(net.sf.jsqlparser.test.select.SelectTest)
  testPivotXml2(net.sf.jsqlparser.test.select.SelectTest)
  testPivotXml3(net.sf.jsqlparser.test.select.SelectTest)
  testIssue162_doubleUserVar(net.sf.jsqlparser.test.select.SelectTest)
  testSelectWithBrackets2(net.sf.jsqlparser.test.select.SelectTest)
  testOrderByNullsFirst(net.sf.jsqlparser.test.select.SelectTest)
  testMultiTableJoin(net.sf.jsqlparser.test.select.SelectTest)
  testProblemSqlServer_Modulo_mod(net.sf.jsqlparser.test.select.SelectTest)
  testProblemSqlAnalytic(net.sf.jsqlparser.test.select.SelectTest)
  testAdditionalLettersSpanish(net.sf.jsqlparser.test.select.SelectTest)
  testLateral1(net.sf.jsqlparser.test.select.SelectTest)
  testProblemSqlIntersect(net.sf.jsqlparser.test.select.SelectTest)
  testProblemFunction(net.sf.jsqlparser.test.select.SelectTest)
  testConcatProblem2(net.sf.jsqlparser.test.select.SelectTest)
  testBitwise(net.sf.jsqlparser.test.select.SelectTest)
  testSelectInto1(net.sf.jsqlparser.test.select.SelectTest)
  testBrackets2(net.sf.jsqlparser.test.select.SelectTest)
  testProblemSqlServer_Modulo_Proz(net.sf.jsqlparser.test.select.SelectTest)
  testFirstWithKeywordLimit(net.sf.jsqlparser.test.select.SelectTest)
  testGroupConcat(net.sf.jsqlparser.test.select.SelectTest)
  testWithRecursive(net.sf.jsqlparser.test.select.SelectTest)
  testSelectKeepOver(net.sf.jsqlparser.test.select.SelectTest)
  testFunctionRight(net.sf.jsqlparser.test.select.SelectTest)
  testSelectBrackets(net.sf.jsqlparser.test.select.SelectTest)
  testMultiPartColumnName(net.sf.jsqlparser.test.select.SelectTest)
  testWithUnionProblem3(net.sf.jsqlparser.test.select.SelectTest)
  testWithUnionProblem5(net.sf.jsqlparser.test.select.SelectTest)
  testValues2(net.sf.jsqlparser.test.select.SelectTest)
  testValues3(net.sf.jsqlparser.test.select.SelectTest)
  testValues4(net.sf.jsqlparser.test.select.SelectTest)
  testValues5(net.sf.jsqlparser.test.select.SelectTest)
  testMultiPartColumnNameWithTableName(net.sf.jsqlparser.test.select.SelectTest)
  testMultiPartTableNameWithDatabaseName(net.sf.jsqlparser.test.select.SelectTest)
  testPivotFunction(net.sf.jsqlparser.test.select.SelectTest)
  testMultiPartTableNameWithServerNameAndDatabaseName(net.sf.jsqlparser.test.select.SelectTest)
  testConcatProblem2_1(net.sf.jsqlparser.test.select.SelectTest)
  testConcatProblem2_2(net.sf.jsqlparser.test.select.SelectTest)
  testConcatProblem2_3(net.sf.jsqlparser.test.select.SelectTest)
  testConcatProblem2_4(net.sf.jsqlparser.test.select.SelectTest)
  testConcatProblem2_5(net.sf.jsqlparser.test.select.SelectTest)
  testConcatProblem2_6(net.sf.jsqlparser.test.select.SelectTest)
  testMultiPartColumnNameWithDatabaseNameAndSchemaNameAndTableName(net.sf.jsqlparser.test.select.SelectTest)
  testMultiPartColumnNameWithDatabaseNameAndTableName(net.sf.jsqlparser.test.select.SelectTest)
  testReplaceAsFunction(net.sf.jsqlparser.test.select.SelectTest)
  testSelectWithinGroup(net.sf.jsqlparser.test.select.SelectTest)
  testSelectForUpdate(net.sf.jsqlparser.test.select.SelectTest)
  testProblemSqlAnalytic10Lag(net.sf.jsqlparser.test.select.SelectTest)
  testProblemSqlAnalytic11Lag(net.sf.jsqlparser.test.select.SelectTest)
  testAnalyticFunctionProblem1(net.sf.jsqlparser.test.select.SelectTest)
  testProblemFunction2(net.sf.jsqlparser.test.select.SelectTest)
  testProblemFunction3(net.sf.jsqlparser.test.select.SelectTest)
  testSelectOrderHaving(net.sf.jsqlparser.test.select.SelectTest)
  testAnalyticFunction12(net.sf.jsqlparser.test.select.SelectTest)
  testAnalyticFunction13(net.sf.jsqlparser.test.select.SelectTest)
  testAnalyticFunction14(net.sf.jsqlparser.test.select.SelectTest)
  testAnalyticFunction15(net.sf.jsqlparser.test.select.SelectTest)
  testAnalyticFunction16(net.sf.jsqlparser.test.select.SelectTest)
  testAnalyticFunction17(net.sf.jsqlparser.test.select.SelectTest)
  testAnalyticFunction18(net.sf.jsqlparser.test.select.SelectTest)
  testMultiPartTableNameWithServerNameAndDatabaseNameAndSchemaName(net.sf.jsqlparser.test.select.SelectTest)
  testBrackets(net.sf.jsqlparser.test.select.SelectTest)
  testWithStatement(net.sf.jsqlparser.test.select.SelectTest)
  testProblemSqlAnalytic5AggregateColumnValue(net.sf.jsqlparser.test.select.SelectTest)
  testMultiPartTableNameWithColumnName(net.sf.jsqlparser.test.select.SelectTest)
  testFunctionLeft(net.sf.jsqlparser.test.select.SelectTest)
  testProblemSqlAnalytic6AggregateColumnValue(net.sf.jsqlparser.test.select.SelectTest)
  testMultiPartColumnNameWithSchemaNameAndTableName(net.sf.jsqlparser.test.select.SelectTest)
  testMultiPartTableNameWithServerName(net.sf.jsqlparser.test.select.SelectTest)
  testProblemSqlAnalytic7Count(net.sf.jsqlparser.test.select.SelectTest)
  testSelectFunction(net.sf.jsqlparser.test.select.SelectTest)
  testAllColumnsFromTable(net.sf.jsqlparser.test.select.SelectTest)
  testProblemSqlCombinedSets(net.sf.jsqlparser.test.select.SelectTest)
  testInterval1(net.sf.jsqlparser.test.select.SelectTest)
  testInterval2(net.sf.jsqlparser.test.select.SelectTest)
  testInterval3(net.sf.jsqlparser.test.select.SelectTest)
  testInterval4(net.sf.jsqlparser.test.select.SelectTest)
  testConcat(net.sf.jsqlparser.test.select.SelectTest)
  testCount2(net.sf.jsqlparser.test.select.SelectTest)
  testSignedColumns(net.sf.jsqlparser.test.select.SelectTest)
  testProblemSqlMinus(net.sf.jsqlparser.test.select.SelectTest)
  testExists(net.sf.jsqlparser.test.select.SelectTest)
  testMultiPartTableNameWithServerProblem(net.sf.jsqlparser.test.select.SelectTest)
  testGroupByExpression(net.sf.jsqlparser.test.select.SelectTest)
  testSelectUserVariable(net.sf.jsqlparser.test.select.SelectTest)
  testTopWithParenthesis(net.sf.jsqlparser.test.select.SelectTest)
  testTableCrossJoin(net.sf.jsqlparser.test.select.SelectTest)
  testProblemSqlAnalytic2(net.sf.jsqlparser.test.select.SelectTest)
  testProblemSqlAnalytic3(net.sf.jsqlparser.test.select.SelectTest)
  testProblemSqlAnalytic9CommaListPartition(net.sf.jsqlparser.test.select.SelectTest)
  testSelectWithoutFrom(net.sf.jsqlparser.test.select.SelectTest)
  testOracleHierarchicalQuery(net.sf.jsqlparser.test.select.SelectTest)
  testPivot1(net.sf.jsqlparser.test.select.SelectTest)
  testPivot2(net.sf.jsqlparser.test.select.SelectTest)
  testPivot3(net.sf.jsqlparser.test.select.SelectTest)
  testPivot4(net.sf.jsqlparser.test.select.SelectTest)
  testPivot5(net.sf.jsqlparser.test.select.SelectTest)
  testSelectWithBrackets(net.sf.jsqlparser.test.select.SelectTest)
  testAnalyticFunctionProblem1b(net.sf.jsqlparser.test.select.SelectTest)
  testPivotXmlSubquery1(net.sf.jsqlparser.test.select.SelectTest)
  testOracleHierarchicalQuery2(net.sf.jsqlparser.test.select.SelectTest)
  testOracleHierarchicalQuery3(net.sf.jsqlparser.test.select.SelectTest)
  testOracleHierarchicalQuery4(net.sf.jsqlparser.test.select.SelectTest)
  testExtractFrom1(net.sf.jsqlparser.test.select.SelectTest)
  testExtractFrom2(net.sf.jsqlparser.test.select.SelectTest)
  testExtractFrom3(net.sf.jsqlparser.test.select.SelectTest)
  testExtractFrom4(net.sf.jsqlparser.test.select.SelectTest)
  testProblemSqlAnalytic4EmptyOver(net.sf.jsqlparser.test.select.SelectTest)
  testCastTypeProblem(net.sf.jsqlparser.test.select.SelectTest)
  testSelectKeywordPercent(net.sf.jsqlparser.test.select.SelectTest)
  testValues(net.sf.jsqlparser.test.select.SelectTest)
  testProblemSqlExcept(net.sf.jsqlparser.test.select.SelectTest)
  testMultiPartTableNameWithServerNameAndSchemaName(net.sf.jsqlparser.test.select.SelectTest)
  testProblemSqlServer_Modulo(net.sf.jsqlparser.test.select.SelectTest)
  testReservedKeyword(net.sf.jsqlparser.test.select.SelectTest)
  testSelectKeep(net.sf.jsqlparser.test.select.SelectTest)
  testCaseElseAddition(net.sf.jsqlparser.test.select.SelectTest)
  testCastInCast2(net.sf.jsqlparser.test.select.SelectTest)

Tests run: 353, Failures: 66, Errors: 156, Skipped: 0

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