<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.2800.1458" name=GENERATOR></HEAD>
<BODY>
<DIV><SPAN class=369472318-20092004><FONT face=Arial size=2>I'll preface this
with the "Yeah, I'm running perl 5.6.1 and I know I shouldn't be, and it COULD
be the problem, BUT"</FONT></SPAN></DIV>
<DIV><SPAN class=369472318-20092004><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=369472318-20092004><FONT face=Arial size=2>Was running 3.0.10
and upgraded to .12 recently. I noticed that my tweaked "weekly.html"
stopped working. The following code produces an invalid MySQL query on .12
but not on .10:</FONT></SPAN></DIV>
<DIV><SPAN class=369472318-20092004><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=369472318-20092004><FONT face=Arial size=2>my $startobj =
RT::Date->new($RT::SystemUser);<BR>my $endobj =
RT::Date->new($RT::SystemUser);<BR>$startobj->Set(Format => 'unix',
Value => (time - (86400 * 7)));<BR>$endobj->Set(Format => 'unix', Value
=> time);</FONT></SPAN></DIV>
<DIV> </DIV>
<DIV><SPAN class=369472318-20092004><FONT face=Arial size=2>my $Creator =
96;</FONT></SPAN></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><SPAN class=369472318-20092004><FONT face=Arial size=2>my $queue = new
RT::Queue($RT::SystemUser);</FONT></SPAN></DIV>
<DIV> </DIV>
<DIV><SPAN class=369472318-20092004><FONT face=Arial size=2>my $tickets = new
RT::Tickets($RT::SystemUser);<BR>$tickets->LimitTransactionDate( VALUE =>
$startobj->ISO, OPERATOR => '>');<BR>$tickets->LimitTransactionDate(
VALUE => $endobj->ISO, OPERATOR =>
'<');<BR>$tickets->DEBUG(1);<BR>$tickets->Next();<BR></FONT></SPAN></DIV>
<DIV><SPAN class=369472318-20092004><FONT face=Arial size=2>I'm testing on the
same machine, simply switching my "use lib" statement at the top between
versions of RT3, so all my perl libraries are remaining the
same.</FONT></SPAN></DIV>
<DIV><SPAN class=369472318-20092004><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=369472318-20092004><FONT face=Arial size=2>The two queries
produced follows - first 3.0.10's and then 3.0.12's:</FONT></SPAN></DIV>
<DIV><SPAN class=369472318-20092004><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=369472318-20092004><FONT face=Arial size=2>SELECT DISTINCT
main.* FROM Tickets main , Transactions Transactions_1, Attachments
Attachments_2 WHERE ((Attachments_2.TransactionId =
Transactions_1.id)AND(Attachments_2.TransactionId = Transactions_1.id)) AND
((main.EffectiveId = main.id)) AND ((main.Type = 'ticket')) AND ((main.id =
Transactions_1.Ticket)AND(main.id = Transactions_1.Ticket)) AND ( ( (
(Attachments_2.Created > '2004-09-13 18:26:39') ) AND (
(Attachments_2.Created < '2004-09-20 18:26:39') ) )
)</FONT></SPAN></DIV>
<DIV><SPAN class=369472318-20092004><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=369472318-20092004><FONT face=Arial size=2>SELECT DISTINCT
main.* FROM Tickets main , Transactions Transactions_1, Attachments
Attachments_2 WHERE ((main.EffectiveId = main.id)) AND ((main.Type =
'ticket')) AND ( ( ( (Attachments_2.TransactionId =
Transactions_1.id)AND(main.id = Transactions_1.Ticket)(Attachments_2.Created
> '2004-09-13 18:26:58') ) AND ( (Attachments_2.TransactionId =
Transactions_1.id)AND(main.id = Transactions_1.Ticket)AND(Attachments_2.Created
< '2004-09-20 18:26:58') ) ) )</FONT></SPAN></DIV>
<DIV><SPAN class=369472318-20092004><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=369472318-20092004><FONT face=Arial size=2>I'll probably
continue hunting (knowing me) but wanted to throw this out there in case someone
knows something ..</FONT></SPAN></DIV>
<DIV><SPAN class=369472318-20092004><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=369472318-20092004><FONT face=Arial size=2>
-=| Ben</DIV></FONT></SPAN></BODY></HTML>