search

citusdata / test-automation

Tools for making our tests easier to run
14 stars 5 forks source link

hll's upgrade sql files are copied/installed with wrong names causing extension test failures. #265

Open emelsimsek opened 1 year ago

emelsimsek commented 1 year ago

When testing hll extension, setup.sql test for the extension fails. But this is a test setup issue. The sql files for the upgrade is not named appropriately in the test environment. See below file names.

diff -U3 /home/pguser/code/postgresql-hll/expected/setup.out /home/pguser/code/postgresql-hll/results/setup.out --- /home/pguser/code/postgresql-hll/expected/setup.out 2023-01-24 10:02:49.591282689 +0000 +++ /home/pguser/code/postgresql-hll/results/setup.out 2023-01-24 10:02:53.639283737 +0000 @@ -1,7 +1,13 @@ CREATE EXTENSION hll VERSION '2.10'; ALTER EXTENSION hll UPDATE TO '2.11'; +ERROR: extension "hll" has no update path from version "2.10" to version "2.11" ALTER EXTENSION hll UPDATE TO '2.12'; +ERROR: extension "hll" has no update path from version "2.10" to version "2.12" ALTER EXTENSION hll UPDATE TO '2.13'; +ERROR: extension "hll" has no update path from version "2.10" to version "2.13" ALTER EXTENSION hll UPDATE TO '2.14'; +ERROR: extension "hll" has no update path from version "2.10" to version "2.14" ALTER EXTENSION hll UPDATE TO '2.15'; +ERROR: extension "hll" has no update path from version "2.10" to version "2.15" ALTER EXTENSION hll UPDATE TO '2.16'; +ERROR: extension "hll" has no update path from version "2.10" to version "2.16"

[pguser@citustestclustervm0 ~]$ ls -al postgres-installation/share/postgresql/extension/hll* -rw-r--r--. 1 pguser pguser 12895 Jan 24 10:09 postgres-installation/share/postgresql/extension/hll--2.10.sql -rw-r--r--. 1 pguser pguser 14061 Jan 24 10:09 postgres-installation/share/postgresql/extension/hll--2.11.sql -rw-r--r--. 1 pguser pguser 14122 Jan 24 10:09 postgres-installation/share/postgresql/extension/hll--2.12.sql -rw-r--r--. 1 pguser pguser 14183 Jan 24 10:09 postgres-installation/share/postgresql/extension/hll--2.13.sql -rw-r--r--. 1 pguser pguser 14244 Jan 24 10:09 postgres-installation/share/postgresql/extension/hll--2.14.sql -rw-r--r--. 1 pguser pguser 19124 Jan 24 10:09 postgres-installation/share/postgresql/extension/hll--2.15.sql -rw-r--r--. 1 pguser pguser 19185 Jan 24 10:09 postgres-installation/share/postgresql/extension/hll--2.16.sql -rw-r--r--. 1 pguser pguser 709 Jan 24 10:09 postgres-installation/share/postgresql/extension/hll.control

[pguser@citustestclustervm0 ~]$ ls -al /home/pguser/code/postgresql-hll/ total 336 drwxrwxr-x. 9 pguser pguser 4096 Jan 24 12:32 . drwxrwxr-x. 6 pguser pguser 4096 Jan 24 10:10 .. -rw-r--r--. 1 pguser pguser 46 Jan 24 10:09 binary.dat -rw-rw-r--. 1 pguser pguser 1592 Jan 24 10:09 CHANGELOG.md -rw-rw-r--. 1 pguser pguser 464 Jan 24 10:09 DEVELOPER.md drwxrwxr-x. 2 pguser pguser 4096 Jan 24 10:09 expected drwxrwxr-x. 8 pguser pguser 4096 Jan 24 10:09 .git -rw-rw-r--. 1 pguser pguser 107 Jan 24 10:09 .gitignore -rw-rw-r--. 1 pguser pguser 1166 Jan 24 10:09 hll--2.10--2.11.sql -rw-rw-r--. 1 pguser pguser 12895 Jan 24 10:09 hll--2.10.sql -rw-rw-r--. 1 pguser pguser 61 Jan 24 10:09 hll--2.11--2.12.sql -rw-rw-r--. 1 pguser pguser 14061 Jan 24 10:09 hll--2.11.sql -rw-rw-r--. 1 pguser pguser 61 Jan 24 10:09 hll--2.12--2.13.sql -rw-rw-r--. 1 pguser pguser 14122 Jan 24 10:09 hll--2.12.sql -rw-rw-r--. 1 pguser pguser 61 Jan 24 10:09 hll--2.13--2.14.sql -rw-rw-r--. 1 pguser pguser 14183 Jan 24 10:09 hll--2.13.sql -rw-rw-r--. 1 pguser pguser 4880 Jan 24 10:09 hll--2.14--2.15.sql -rw-rw-r--. 1 pguser pguser 14244 Jan 24 10:09 hll--2.14.sql -rw-rw-r--. 1 pguser pguser 61 Jan 24 10:09 hll--2.15--2.16.sql -rw-rw-r--. 1 pguser pguser 19124 Jan 24 10:09 hll--2.15.sql -rw-rw-r--. 1 pguser pguser 19185 Jan 24 10:09 hll--2.16.sql -rw-rw-r--. 1 pguser pguser 709 Jan 24 10:09 hll.control