Hi, Edson Carlos Ericksson Richter wrote: > Is not possible to create a index based on function results?
Not for the moment. It is proposed as a new feature (https://issues.apache.org/jira/browse/DERBY-455), but I don't think anyone is working on it presently. > > Regards, > > Richter > > > > > Terry Kilshaw escreveu: > >> Kristian, >> >> I mean like in MySQL. You configure it for case insensitive searching and >> that's it. >> >> For example the following two SELECT statements return the same row, >> whose >> actual value is 'jdoe': >> >> select userID from tbl_personnel where userID = 'jdoe' >> select userID from tbl_personnel where userID = 'JDOE' >> Most of the feedback so far seems to indicate that although >> cas-insensitive >> searching can be done it Derby, it carries the penalty of not using >> indexes. >> >> Terry >> >> -----Original Message----- >> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: >> Wednesday, August 09, 2006 3:20 PM >> To: Derby Discussion >> Subject: Re: case insensitive searches >> >> Terry Kilshaw wrote: >> >> >>> Is it possible to set Derby to do case-insensitive searches? The >>> default seems to be case-sensitive. This would be fine as a global >>> setting that never needs to change. >>> >> >> >> Hi Terry, >> >> Could give us some more information on what kind of searches you are >> talking >> about? Most importantly, what searching mechanism is being used. >> >> >> >> Thank you, >> > > -- Bernt Marius Johnsen, Database Technology Group, Staff Engineer, Technical Lead Derby/Java DB Sun Microsystems, Trondheim, Norway
signature.asc
Description: OpenPGP digital signature
