On Fri, Apr 15, 2011 at 1:01 PM, Dominic Hargreaves
wrote:
> On Fri, Apr 15, 2011 at 12:09:58PM +1000, Jesse Vincent wrote:
>> On Thu 14.Apr'11 at 15:26:33 +0200, Václav Ovsík wrote:
>> > SELECT * FROM Groups WHERE Instance = ? AND LOWER(Domain) = LOWER(?) AND
>> > LOWER(Type) = LOWER(?)
>> >
>>
On Fri, Apr 15, 2011 at 07:44:27AM -0500, Kenneth Marshall wrote:
> On Fri, Apr 15, 2011 at 12:09:58PM +1000, Jesse Vincent wrote:
> >
> >
> >
> > On Thu 14.Apr'11 at 15:26:33 +0200, V?clav Ovs?k wrote:
> > > Hi,
> > > because of horrible performance of spreadsheet export of tickets I found
> >
>
> Okay, but does removing the LOWER()'s make the product harder to use?
> In other words, when writing a Scrip that uses Type would it now be
> case sensitive? i.e. Were AdminCc and admincc both acceptable? Some
> of my most painful bug hunts were case-only related. Maybe the RT
> code already
On Fri, Apr 15, 2011 at 12:09:58PM +1000, Jesse Vincent wrote:
>
>
>
> On Thu 14.Apr'11 at 15:26:33 +0200, V?clav Ovs?k wrote:
> > Hi,
> > because of horrible performance of spreadsheet export of tickets I found
> > some badly created or missing indexes. I didn't investigate if other
> > RDBMS s
On Fri, Apr 15, 2011 at 12:09:58PM +1000, Jesse Vincent wrote:
> ...
> I'd actually consider this a code bug. We shouldn't be LOWER()ing either
> of those parameters. Please open a ticket by mailing
> rt-b...@bestpractical.com
I did it. It have received ticket [rt3 #17121].
About the second pro
On Fri, Apr 15, 2011 at 12:09:58PM +1000, Jesse Vincent wrote:
> On Thu 14.Apr'11 at 15:26:33 +0200, Václav Ovsík wrote:
> > SELECT * FROM Groups WHERE Instance = ? AND LOWER(Domain) = LOWER(?) AND
> > LOWER(Type) = LOWER(?)
> >
> > e.g. one my bind params: 106431 'RT::Ticket-Role' 'Requestor'
>
On Thu 14.Apr'11 at 15:26:33 +0200, Václav Ovsík wrote:
> Hi,
> because of horrible performance of spreadsheet export of tickets I found
> some badly created or missing indexes. I didn't investigate if other
> RDBMS schemas has the same problem.
> To discover problems I rewrote Results.tsv into
Hi,
because of horrible performance of spreadsheet export of tickets I found
some badly created or missing indexes. I didn't investigate if other
RDBMS schemas has the same problem.
To discover problems I rewrote Results.tsv into command-line shape and
run it with DBI_TRACE=2 finally.
For every r