polygene-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Paul Merlin (JIRA)" <j...@apache.org>
Subject [jira] [Created] (POLYGENE-222) Indexing-SQL is broken
Date Mon, 09 Jan 2017 10:26:58 GMT
Paul Merlin created POLYGENE-222:
------------------------------------

             Summary: Indexing-SQL is broken
                 Key: POLYGENE-222
                 URL: https://issues.apache.org/jira/browse/POLYGENE-222
             Project: Polygene
          Issue Type: Bug
            Reporter: Paul Merlin
             Fix For: 3.0


In POLYGENE-180 we noticed that some Indexing SQL tests were failing. But the situation is
not that simple.

I bisected to find the offending commits, here are my findings:

The last good commit is [4dabe5781cd73463526951b70b097c2f0b45b320|https://github.com/apache/polygene-java/commit/4dabe5781cd73463526951b70b097c2f0b45b320].

[d845ea705b05b3d8182086ba82979fa8332bde78|https://github.com/apache/polygene-java/commit/d845ea705b05b3d8182086ba82979fa8332bde78]
is the first bad commit with these 7 tests failing:

{code}
PostgreSQLEntityFinderTest. script03
PostgreSQLEntityFinderTest. script18
PostgreSQLEntityFinderTest. script19
PostgreSQLQueryTest. script03
PostgreSQLQueryTest. script17
PostgreSQLQueryTest. script18
PostgreSQLQueryTest. script19
{code}

then [5d2a62bef95828222c17c1c2b413ac43d8d2b71b|https://github.com/apache/polygene-java/commit/5d2a62bef95828222c17c1c2b413ac43d8d2b71b]
made ALL tests fail

then [a5be013f39cba9642114e01486cdff0c355569f2|https://github.com/apache/polygene-java/commit/a5be013f39cba9642114e01486cdff0c355569f2]
fixed some tests but the following 19 still fail:

{code}
PostgreSQLComplexQueryTest. script01
PostgreSQLComplexQueryTest. script02
PostgreSQLComplexQueryTest. script03
PostgreSQLComplexQueryTest. script05
PostgreSQLComplexQueryTest. script06
PostgreSQLComplexQueryTest. script07
PostgreSQLComplexQueryTest. script08
PostgreSQLComplexQueryTest. script09
PostgreSQLComplexQueryTest. script10
PostgreSQLComplexQueryTest. script11
PostgreSQLEntityFinderTest. script03
PostgreSQLEntityFinderTest. script18
PostgreSQLEntityFinderTest. script19
PostgreSQLQueryTest. script03
PostgreSQLQueryTest. script17
PostgreSQLQueryTest. script18
PostgreSQLQueryTest. script19
PostgreSQLQueryTest. script29
PostgreSQLQueryTest. script32
{code}

then [dedb068e4b56fce8d6c21f5938396eb84da63f7c|https://github.com/apache/polygene-java/commit/]
made ALL tests fail again

then [e5c57f95e199f8a79763debb2e101028f8e8f896|https://github.com/apache/polygene-java/commit/e5c57f95e199f8a79763debb2e101028f8e8f896]
fixed some tests but the following 19 still fail, same as above:

{code}
PostgreSQLComplexQueryTest. script01
PostgreSQLComplexQueryTest. script02
PostgreSQLComplexQueryTest. script03
PostgreSQLComplexQueryTest. script05
PostgreSQLComplexQueryTest. script06
PostgreSQLComplexQueryTest. script07
PostgreSQLComplexQueryTest. script08
PostgreSQLComplexQueryTest. script09
PostgreSQLComplexQueryTest. script10
PostgreSQLComplexQueryTest. script11
PostgreSQLEntityFinderTest. script03
PostgreSQLEntityFinderTest. script18
PostgreSQLEntityFinderTest. script19
PostgreSQLQueryTest. script03
PostgreSQLQueryTest. script17
PostgreSQLQueryTest. script18
PostgreSQLQueryTest. script19
PostgreSQLQueryTest. script29
PostgreSQLQueryTest. script32
{code}

then with [962badcea188f48da722cba396fb2478375065e7|https://github.com/apache/polygene-java/commit/962badcea188f48da722cba396fb2478375065e7]
only 16 tests still fail (see POLYGENE-137):

{code}
PostgreSQLComplexQueryTest. script03
PostgreSQLComplexQueryTest. script05
PostgreSQLComplexQueryTest. script06
PostgreSQLComplexQueryTest. script07
PostgreSQLComplexQueryTest. script08
PostgreSQLComplexQueryTest. script09
PostgreSQLComplexQueryTest. script10
PostgreSQLComplexQueryTest. script11
PostgreSQLEntityFinderTest. script03
PostgreSQLEntityFinderTest. script18
PostgreSQLEntityFinderTest. script19
PostgreSQLQueryTest. script03
PostgreSQLQueryTest. script17
PostgreSQLQueryTest. script18
PostgreSQLQueryTest. script19
PostgreSQLQueryTest. script29
{code}

then with [612f952a338ef93e305b90321de04b5ccc9c7930|https://github.com/apache/polygene-java/commit/612f952a338ef93e305b90321de04b5ccc9c7930]
only 9 tests still fail:

{code}
PostgreSQLComplexQueryTest. script03
PostgreSQLComplexQueryTest. script05
PostgreSQLComplexQueryTest. script06
PostgreSQLComplexQueryTest. script07
PostgreSQLComplexQueryTest. script08
PostgreSQLComplexQueryTest. script09
PostgreSQLComplexQueryTest. script10
PostgreSQLComplexQueryTest. script11
PostgreSQLQueryTest. script29
{code}

then [def7765f4a21a8ead434a7599c75f6bffd2c165e|https://github.com/apache/polygene-java/commit/def7765f4a21a8ead434a7599c75f6bffd2c165e]
made ALL tests fail again

then [f21cc656a72b6fb5fdca112b05133d7e63455a3d|https://github.com/apache/polygene-java/commit/f21cc656a72b6fb5fdca112b05133d7e63455a3d]
got us back to the 9 failing tests above

then [103c59cbeb2907d0b3a132a1aa852e2e1b8585ae|https://github.com/apache/polygene-java/commit/103c59cbeb2907d0b3a132a1aa852e2e1b8585ae]
made a 10th test fail:

{code}
PostgreSQLComplexQueryTest. script03
PostgreSQLComplexQueryTest. script05
PostgreSQLComplexQueryTest. script06
PostgreSQLComplexQueryTest. script07
PostgreSQLComplexQueryTest. script08
PostgreSQLComplexQueryTest. script09
PostgreSQLComplexQueryTest. script10
PostgreSQLComplexQueryTest. script11
PostgreSQLQueryTest. script29
PostgreSQLQueryTest. script34
{code}

That last list is what actually fails on the head of {{develop}}.

Indexing SQL extension tests need a running PostgreSQL instance properly set up. That makes
asserting that changes don't break it difficult. We really need a test harness for required
external services, see POLYGENE-221




--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message