496740 - SQL error when searching with "contains any of the words" option

Status: VERIFIED FIXED

(Webtools Graveyard :: Litmus, defect, P2)

Description

[Henrik Skupin [:whimboo][⌚️UTC+1]]

When you search for multiple strings in the result status field (just open the URL) the following error is shown:

Error - Litmus has suffered a serious fatal internal error - Litmus::DB::Testresult can't SELECT DISTINCT(tr.testresult_id),tr.testcase_id,t.summary,tr.submission_time AS created,pl.name AS platform_name,pr.name as product_name,trsl.name AS result_status,trsl.class_name AS result_status_class,b.name AS branch_name,tg.name AS test_group_name, tr.locale_abbrev, u.email, pl.iconpath FROM test_results tr, testcases t, platforms pl, opsyses o, branches b, products pr, test_result_status_lookup trsl, testgroups tg, subgroups sg, users u, testcase_subgroups tcsg, subgroup_testgroups sgtg WHERE tr.testcase_id=t.testcase_id AND tr.opsys_id=o.opsys_id AND o.platform_id=pl.platform_id AND tr.branch_id=b.branch_id AND b.product_id=pr.product_id AND tr.result_status_id=trsl.result_status_id AND tcsg.testcase_id=tr.testcase_id AND tcsg.subgroup_id=sg.subgroup_id AND sg.subgroup_id=sgtg.subgroup_id AND sgtg.testgroup_id=tg.testgroup_id AND tr.user_id=u.user_id AND pr.product_id=1 AND b.branch_id=26 AND tg.testgroup_id=105 AND sg.subgroup_id=1047 AND (UPPER(trsl.name) LIKE UPPER('%%failed%%') OR UPPER(trsl.name) LIKE UPPER('%%unclear%%')) AND () AND tr.vetted=0 GROUP BY tr.testresult_id ORDER BY tr.submission_time DESC: Can't use an undefined value as an ARRAY reference at /usr/lib/perl5/site_perl/5.8.8/Class/DBI.pm line 1140.

Comment 1

[Henrik Skupin [:whimboo][⌚️UTC+1]]

Ok it's related to the "contains any of the words" search option. There is no difference how many strings were specified.

Comment 2

[Chris Cooper [:coop] (he/him)]

changeset:   532:b7b04c0a7f12