??changed:
- SELECT bug_id, unix_group_name FROM groups, task WHERE groups.status='P' AND
task.summary LIKE CONCAT("Submission of ", groups.group_name) AND
task.status_id=3
-
-It only fails if the task summary or group name was changed after the
submission.
SELECT groups.group_id, unix_group_name, groups.status, task.bug_id,
task.status_id, groups.group_name FROM groups, task WHERE groups.status='P' AND
task.group_id=5802 AND task.status_id=3 AND task.category_id=1 AND task.details
LIKE CONCAT("%* System Name: *", groups.unix_group_name, "*%") AND (SELECT
count(*) FROM task WHERE task.group_id=5802 AND task.status_id=1 AND
task.category_id=1 AND task.details LIKE CONCAT("%* System Name: *",
groups.unix_group_name, "*%")) = 0 GROUP BY groups.group_id ORDER BY bug_id;
DELETE groups FROM groups, task WHERE groups.status='P' AND task.group_id=5802
AND task.status_id=3 AND task.category_id=1 AND task.details LIKE CONCAT("%*
System Name: *", groups.unix_group_name, "*%") AND (SELECT count(*) FROM task
WHERE task.group_id=5802 AND task.status_id=1 AND task.category_id=1 AND
task.details LIKE CONCAT("%* System Name: *", groups.unix_group_name, "*%")) =
0;
It only fails if the group name was changed after the submission, or if a user
maliciously fakes a submission item.
--
forwarded from
https://savannah.gnu.org/maintenance/foradministrators#msg20081212155328+0...@https://savannah.gnu.org/maintenance
_______________________________________________
Savannah-cvs mailing list
[email protected]
http://lists.gnu.org/mailman/listinfo/savannah-cvs
