[Rt-devel] Small Oracle problems in rt-3.6.4
JoopvandeWege at mococo.nl
Thu Jul 19 07:41:23 EDT 2007
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)
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.
More information about the Rt-devel