search

pgadmin-org / pgadmin4

pgAdmin is the most popular and feature rich Open Source administration and development platform for PostgreSQL, the most advanced Open Source database in the world.
https://www.pgadmin.org
Other
2.43k stars 638 forks source link

Sequences API test cases are not working in PG9.2 and PPAS9.2 (RM #2173) #981

Closed dpage closed 2 years ago

dpage commented 7 years ago

Issue migrated from Redmine: https://redmine.postgresql.org/issues/2173 Originally created by navnath gadakh at 2017-02-14 07:11:32 UTC.

Run test-suite for Sequences:

python runtests.py --pkg browser.server_groups.servers.databases.schemas.sequences

See the output on consoles. For more refrence see attached log file. Summary of log:

runTest (pgadmin.browser.server_groups.servers.databases.schemas.sequences.tests.test_sequence_get.SequenceGetTestCase)
This function will fetch added sequence under schema node. (Fetch sequence Node URL) ... 2017-02-14 12:08:05,770: ERROR pgadmin:    Failed to execute query (execute_dict) for the server #3- DB:test_db_331b8 (Query-id: 7556190):
Error Message:ERROR:  function expression in FROM cannot refer to other relations of same query level
LINE 26:         aclexplode(relacl) d
dpage commented 7 years ago

Attachment migrated from Redmine: https://redmine.postgresql.org/attachments/download/2065 Originally created by navnath gadakh at 2017-02-14 07:10:21 UTC.

https://pgadmin-archive.postgresql.org/redmine/2173/2065-regression.log

dpage commented 7 years ago

Comment migrated from Redmine: https://redmine.postgresql.org/issues/2173#note-2 Originally created by Ashesh Vashi at 2017-03-01 09:21:53 UTC.

Please fix it asap.

Redmine ticket header update:

Name Old Value New Value
Assigned To changed Ashesh Vashi Khushboo Vashi
Fixed Version changed 1.3
dpage commented 7 years ago

Comment migrated from Redmine: https://redmine.postgresql.org/issues/2173#note-3 Originally created by Khushboo Vashi at 2017-03-01 10:48:56 UTC.

Redmine ticket header update:

Name Old Value New Value
Status changed New In Progress
dpage commented 7 years ago

Comment migrated from Redmine: https://redmine.postgresql.org/issues/2173#note-4 Originally created by Khushboo Vashi at 2017-03-01 11:47:16 UTC.

The patch submitted.

https://www.postgresql.org/message-id/CAFOhELcPFpyCdYpXiTCt6JDr7oRdfSrpKJK9e54h8H0QDX-O_Q@mail.gmail.com

dpage commented 7 years ago

Comment migrated from Redmine: https://redmine.postgresql.org/issues/2173#note-5 Originally created by Dave Page at 2017-03-01 12:50:47 UTC.

Fixed in commit:ddb8bad2019f8d5f0b3583482fcfdd2a5de38f22

Redmine ticket header update:

Name Old Value New Value
Status changed In Progress In Testing
Assigned To changed Khushboo Vashi
Done Ratio changed 0 90
dpage commented 7 years ago

Comment migrated from Redmine: https://redmine.postgresql.org/issues/2173#note-6 Originally created by navnath gadakh at 2017-03-06 05:55:25 UTC.

Resolved. ddb8bad2019f8d5f0b3583482fcfdd2a5de38f22

Redmine ticket header update:

Name Old Value New Value
Status changed In Testing Resolved
dpage commented 6 years ago

Comment migrated from Redmine: https://redmine.postgresql.org/issues/2173#note-7 Originally created by Fahar Abbas at 2018-01-09 05:29:32 UTC.

Redmine ticket header update:

Name Old Value New Value
Done Ratio changed 90 100
dpage commented 2 years ago

Issue closed on Redmine.