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

[Jesse Vincent]

On Jul 19, 2007, at 7:41 AM, Joop wrote:

> 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;
>

I'll get that fixed up.

> Further I have a question about regression testing:
> At the moment should there be ZERO tests failed?

I believe so

> 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,


The test suite needs to run on an empty database. Did that happen?


> 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
>

That's a warning related to a change we backed out at the last minute  
for 3.6.4. It's relatively safe.

> 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
> _______________________________________________
> List info: http://lists.bestpractical.com/cgi-bin/mailman/listinfo/ 
> rt-devel
>

-------------- next part --------------
A non-text attachment was scrubbed...
Name: PGP.sig
Type: application/pgp-signature
Size: 186 bytes
Desc: This is a digitally signed message part
Url : http://lists.bestpractical.com/pipermail/rt-devel/attachments/20070719/2daaa7bd/PGP.pgp