397839 - would be nice to be able to display range of test cases, i.e. 50-60, and in any case such attempt should not spit SQL error

Status: RESOLVED FIXED

(Testopia :: Search, defect)

Description

[Nathan Parrish]

User-Agent:       Mozilla/5.0 (X11; U; Linux i686 (x86_64); en-US; rv:1.8.1.5) Gecko/20070718 Fedora/2.0.0.5-1.fc7 Firefox/2.0.0.5
Build Identifier: 1.3

yes, I know it says "comma separated lists":
  Associations (comma separated lists)
  Include cases numbered: 

but I'm bad at following instructions, so I tried specifying a dash-separated range, 50-68.  it would be really nice if this worked.  but, even if it doesn't, it oughtn't spew the following SQL error:

Software error:
DBD::Pg::db selectcol_arrayref failed: ERROR:  invalid input syntax for integer: "50-68"
 [for Statement "SELECT test_cases.case_id FROM test_cases  WHERE ((test_cases.case_id IN ('50-68'))) GROUP BY test_cases.case_id"] at Bugzilla/Testopia/Table.pm line 121
	Bugzilla::Testopia::Table::init('Bugzilla::Testopia::Table=HASH(0x968bb44)', 'case', 'tr_list_cases.cgi', 'Bugzilla::CGI=HASH(0x947a4e0)', 'undef', 'SELECT test_cases.case_id FROM test_cases  WHERE ((test_cases...') called at Bugzilla/Testopia/Table.pm line 88
	Bugzilla::Testopia::Table::new('Bugzilla::Testopia::Table', 'case', 'tr_list_cases.cgi', 'Bugzilla::CGI=HASH(0x947a4e0)', 'undef', 'SELECT test_cases.case_id FROM test_cases  WHERE ((test_cases...') called at /var/www/virts/bugs/bugs/tr_list_cases.cgi line 346


Reproducible: Always

Steps to Reproduce:
1.
2.
3.



I'm running atop postgresql, if that's relevant.

Comment 1

[Greg Hendricks]

    Checking in Bugzilla/Testopia/Search.pm;
    /cvsroot/mozilla/webtools/testopia/Bugzilla/Testopia/Search.pm,v  <--  Search.pm
    new revision: 1.72; previous revision: 1.71
    done