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)
