[rt-users] Searching on TransactionDate > xxx = no results

[Ben Goodwin]

> Right. But if nobody _tells_ us what the error is or even that they're
> getting an error, then we're never, ever going to fix it. Versions with
> _ in them are development versions and shouldn't be automatically
> installed. But if you can send a stacktrace of the error, we'd really
> appreciate it.

Sorry I meant I didn't take down the error and trace since it was so readily
reproduceable at the time.  I've attached crash.txt with the results.  This
happens with both 0.93_3 and _4, seemingly no matter what search I try
(specifically this crash was searching for tickets owned by me, no other
parameters).

> I haven't noticed this one, but 0.92 did fix important issues relative
> to 0.88. Can you upgrade to 0.92 and send us the query that RT generates
> to find tickets that you own? That's how we can trace down the issue you
> report.

I've attached search_order.txt to demonstrate.  It looks like it's related
to the SELECT DISTINCT change made in 0.89_01

BTW (saw your later emails) this is all with Locale::Maketext::Lexicon 0.32

BTW #2 cpan2rpm didn't find an author in searchbuilder 0.93_4

    -=| Ben
-------------- next part --------------
An embedded and charset-unspecified text was scrubbed...
Name: crash.txt
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20031030/564e6ec5/attachment.txt>
-------------- next part --------------
An embedded and charset-unspecified text was scrubbed...
Name: search_order.txt
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20031030/564e6ec5/attachment-0001.txt>