453532 - Postgresql: ERROR: for SELECT DISTINCT, ORDER BY expressions must appear in select list thrown when trying to access test run

Status: RESOLVED FIXED

(Testopia :: Test Runs, defect)

Description

[Nick Lamb]

User-Agent:       Mozilla/5.0 (X11; U; Linux x86_64; en-US; rv:1.9.0.1) Gecko/2008071615 Fedora/3.0.1-1.fc9 Firefox/3.0.1
Build Identifier: Testopia 2.0, Bugzilla 3.0.5, PGSQL 8.3.1

The following error is run when trying to access test run

URL: http://bugstest/tr_show_run.cgi?run_id=837

undef error - DBD::Pg::db selectcol_arrayref failed: ERROR: for SELECT DISTINCT, ORDER BY expressions must appear in select list [for Statement "SELECT DISTINCT tcc.category_id FROM test_case_categories AS tcc JOIN test_cases ON test_cases.category_id = tcc.category_id JOIN test_case_runs AS tcr ON test_cases.case_id = tcr.case_id WHERE run_id = ? ORDER BY tcc.name"] at Bugzilla/Testopia/TestRun.pm line 673 Bugzilla::Testopia::TestRun::filter_case_categories('Bugzilla::Testopia::TestRun=HASH(0x7f85b85f4190)') called at data/template/template/en/default/testopia/caserun/filter.html.tmpl line 54 eval {...} called at data/template/template/en/default/testopia/caserun/filter.html.tmpl line 54 eval {...} called at data/template/template/en/default/testopia/caserun/filter.html.tmpl line 16 Template::Provider::__ANON__('Template::Context=HASH(0x7f85b87aa7b8)') called at /usr/lib64/perl5/vendor_perl/5.10.0/x86_64-linux-thread-multi/Template/Document.pm line 155 eval {...} called at /usr/lib64/perl5/vendor_perl/5.10.0/x86_64-linux-thread-multi/Template/Document.pm line 153 Template::Document::process('Template::Document=HASH(0x7f85b814edf0)', 'Template::Context=HASH(0x7f85b87aa7b8)') called at /usr/lib64/perl5/vendor_perl/5.10.0/x86_64-linux-thread-multi/Template/Context.pm line 349 eval {...} called at /usr/lib64/perl5/vendor_perl/5.10.0/x86_64-linux-thread-multi/Template/Context.pm line 319 Template::Context::process('Template::Context=HASH(0x7f85b87aa7b8)', 'testopia/caserun/filter.html.tmpl') called at data/template/template/en/default/testopia/run/show.html.tmpl line 414 eval {...} called at data/template/template/en/default/testopia/run/show.html.tmpl line 16 Template::Provider::__ANON__('Template::Context=HASH(0x7f85b87aa7b8)') called at /usr/lib64/perl5/vendor_perl/5.10.0/x86_64-linux-thread-multi/Template/Document.pm line 155 eval {...} called at /usr/lib64/perl5/vendor_perl/5.10.0/x86_64-linux-thread-multi/Template/Document.pm line 153 Template::Document::process('Template::Document=HASH(0x7f85b8629770)', 'Template::Context=HASH(0x7f85b87aa7b8)') called at /usr/lib64/perl5/vendor_perl/5.10.0/x86_64-linux-thread-multi/Template/Context.pm line 349 eval {...} called at /usr/lib64/perl5/vendor_perl/5.10.0/x86_64-linux-thread-multi/Template/Context.pm line 319 Template::Context::process('Template::Context=HASH(0x7f85b87aa7b8)', 'Template::Document=HASH(0x7f85b8629770)') called at /usr/lib64/perl5/vendor_perl/5.10.0/x86_64-linux-thread-multi/Template/Service.pm line 94 eval {...} called at /usr/lib64/perl5/vendor_perl/5.10.0/x86_64-linux-thread-multi/Template/Service.pm line 91 Template::Service::process('Template::Service=HASH(0x7f85b8977de0)', 'testopia/run/show.html.tmpl', 'HASH(0x2045e88)') called at /usr/lib64/perl5/vendor_perl/5.10.0/x86_64-linux-thread-multi/Template.pm line 68 Template::process('Bugzilla::Template=HASH(0x7f85b890cf78)', 'testopia/run/show.html.tmpl', 'HASH(0x2045e88)') called at /var/www/virts/bugs/tr_show_run.cgi line 58 

---------------------------------------------------
The same/similar error is given when running the command in PSQL:

bugzilla=> SELECT DISTINCT tcc.category_id FROM test_case_categories AS tcc JOIN test_cases ON test_cases.category_id = tcc.category_id JOIN test_case_runs AS tcr ON test_cases.case_id = tcr.case_id WHERE run_id = 837 ORDER BY tcc.name;

ERROR:  for SELECT DISTINCT, ORDER BY expressions must appear in select list



Reproducible: Always

Steps to Reproduce:
1. Upgrade previous install of Testopia 1.3 to 2.0 on postgres
2. Attempt to access test run
Actual Results:  
See details

Expected Results:  
Proper run view

Comment 1

[Greg Hendricks]

Please upgrade to 2.1 where this has been fixed.