358103 - tr_install.pl uses Multi-value INSERT

Status: RESOLVED FIXED

(Testopia :: General, defect)

Description

[Vance Baarda]

User-Agent:       Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.8.0.7) Gecko/20060911 SUSE/1.5.0.7-1.5 Firefox/1.5.0.7
Build Identifier: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.8.0.7) Gecko/20060911 SUSE/1.5.0.7-1.5 Firefox/1.5.0.7

tr_install.pl uses Multi-value INSERT -- breaks on PostgreSQL

Reproducible: Always

Actual Results:  
[Sun Oct 15 15:18:17 2006] tr_install.pl: DBD::Pg::db do failed: ERROR: 
syntaxerror at or near "," at character 154 [for Statement "INSERT INTO
test_environment_category (env_category_id, product_id, name) VALUES (1, 0,
'Operating System'), (2, 0, 'Hardware')"] at ./tr_install.pl line 433

Comment 1

[Vance Baarda]

Attachment: patch version 1

We no longer do the multi-value INSERT.

Comment 2

[Vance Baarda]

------------------------------------------------------------------------
r2329 | vrb | 2006-10-26 11:58:04 -0600 (Thu, 26 Oct 2006) | 4 lines
Changed paths:
   M /trunk/tr_install.pl

Comment 3

[Greg Hendricks]

    Checking in tr_install.pl;
    /cvsroot/mozilla/webtools/testopia/tr_install.pl,v  <--  tr_install.pl
    new revision: 1.8; previous revision: 1.7
    done

Comment 4

[JK]

Many thanks - installation succeeded!