[Rt-devel] Small Oracle problems in rt-3.6.4

[Joop]

Hello All,

I'm currently playing around with a new VM installation of Oracle XE and 
RT-3.6.4 and tried to run the regression test and found that drop.Oracle 
has two spelling mistakes:
DROP TABLE OBJECTUSTOMFIELDS;
DROP TABLE OBJECTUSTOMFIELDVALUES;
should ofcourse be:
DROP TABLE OBJECTCUSTOMFIELDS;
DROP TABLE OBJECTCUSTOMFIELDVALUES;

Further I have a question about regression testing:
At the moment should there be ZERO tests failed?
I ask because 12 tests fail with 128 subtests failed of which quite a 
bit can be explained because this wasn't a totally clean rt-3.6.4 
install, mail-gateway isn't setup and probably some other small things. 
Others are probably more serious such as the following:
#   at lib/t/regression/22search_tix_by_watcher.t line 54.
# Wrong SQL query for 'Requestor NOT LIKE "@example.com"':SELECT main.* 
FROM ( SELECT DISTINCT main.id FROM Tickets main JOIN Groups Groups_1 
ON ( Groups_1.Domain = 'RT::Ticket-Role' ) AND ( Groups_1.Type = 
'Requestor' ) AND ( Groups_1.Instance = main.id ) LEFT JOIN 
CachedGroupMembers CachedGroupMembers_2  ON ( 
CachedGroupMembers_2.MemberId = '0' ) AND ( CachedGroupMembers_2.GroupId 
= Groups_1.id )  WHERE (main.Status != 'deleted') AND ( ( main.id = 
'302' OR main.id = '303' OR main.id = '304' OR main.id = '305' OR 
main.id = '306' )  AND  (  ( CachedGroupMembers_2.id IS NULL )  ) ) AND 
(main.Type = 'ticket') AND (main.EffectiveId = main.id)  ) 
distinctquery, Tickets main WHERE (main.id = distinctquery.id)
lib/t/regression/22search_tix_by_watcher.................NOK 68

The query itself is valid and in production returns 5 rows, just plain 
luck since the ticket ids exist ;-)
So what does the error in the test mean?

If there is interest I can setup a pristine environment and run 
regression tests against it.

Thanks,

Joop