Select Statments by Rule_id gives too many returned values

What is the URL of your deployment?
http://biodata.mdanderson.org/s3db/S3QL.php

What steps will reproduce the problem?

Run the following query:
http://biodata.mdanderson.org/s3db/S3QL.php?query=<s3ql><key>sVsQDlcCFT1YK9u</ke
y><select>*</select><from>statements</from><where><rule_id>~'47011|47029'</rule_
id></where><format>xml</format></s3ql>

(Note that the specified key will disappear very soon....) 

What is the expected output? 
Just the statements belonging to the two specified rule IDs. 

What do you see instead?
Gazoodles of statemets from different rules and different projects.

What version of the product are you using? On what operating system?
S3DB 3.5.2, D1356676

Please provide any additional information below.

If you specify the project_id as well, then the query appear to fail in a
different way (even though project_id is not documented as a valid field
for selecting statements...), which I will file as a second bug repotr

Original issue reported on code.google.com by krcoom...@mdanderson.org on 6 Aug 2009 at 4:13

google-code-export / s3db

Select Statments by Rule_id gives too many returned values #30