You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@polygene.apache.org by "Paul Merlin (JIRA)" <ji...@apache.org> on 2017/08/01 14:37:00 UTC

[jira] [Resolved] (POLYGENE-222) Indexing-SQL is broken

     [ https://issues.apache.org/jira/browse/POLYGENE-222?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Paul Merlin resolved POLYGENE-222.
----------------------------------
    Resolution: Won't Fix

This was not fixed in 3.0 but the {{indexing-sql}} module was simply removed from the release.
See POLYGENE-244 for follow ups.

> Indexing-SQL is broken
> ----------------------
>
>                 Key: POLYGENE-222
>                 URL: https://issues.apache.org/jira/browse/POLYGENE-222
>             Project: Polygene
>          Issue Type: Bug
>            Reporter: Paul Merlin
>            Assignee: Niclas Hedhman
>             Fix For: 3.0.0
>
>         Attachments: indexing-sql-test-report-0984d0ba.zip
>
>
> 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.4.14#64029)