Re: Language based ordering is possible in Derby

2005-11-03 Thread Mike Matrigali
those interested in this or any other feature/bug fix but don't have the ability to implement it (scratch their own itch) themselves may want to vote for it in JIRA. The JIRA entry is DERBY-455. I think this feature could provide a lot of interesting applications which we have not even thought

Re: Language based ordering is possible in Derby

2005-11-03 Thread Rick Hillegas
I did log an enhancement request but I'm not working on it right now. Regards, -Rick Satheesh Bandaram wrote: Derby doesn't allow creating functional indexes Rick started a discussion about how to provide that functionality about 6 months ago. I thought an agreement was reached in the comm

Re: Language based ordering is possible in Derby

2005-11-03 Thread Satheesh Bandaram
Derby doesn't allow creating functional indexes Rick started a discussion about how to provide that functionality about 6 months ago. I thought an agreement was reached in the community and I was under the impression he is working on it, though I haven't seen any follow ups. Rick may know more.

Re: Language based ordering is possible in Derby

2005-11-03 Thread Daniel John Debrunner
Edson Carlos Ericksson Richter wrote: > Probably, the most important are that using large tables with "order by > SOME_FUNCTION(some_col)" could not be optimized unless you could index > as "create index IDX_SOMETHING on MY_TABLE (SOME_FUNCTION(some_col))" > too... Could Derby create and use inde

Re: Language based ordering is possible in Derby

2005-11-03 Thread Edson Carlos Ericksson Richter
See comments inline, please... Daniel John Debrunner escreveu: Rick Hillegas wrote: Dan's workaround is very useful and Øyvind's suggestion is interesting also. It's worth pointing out that the need for these workarounds should decrease after we fix bug 533 (the re-enabling of the natonal

Re: Language based ordering is possible in Derby

2005-11-03 Thread Daniel John Debrunner
Rick Hillegas wrote: > Dan's workaround is very useful and Øyvind's suggestion is interesting > also. It's worth pointing out that the need for these workarounds should > decrease after we fix bug 533 (the re-enabling of the natonal character > datatypes). I hope to get to that bug in 10.2. The na

Re: Language based ordering is possible in Derby

2005-11-03 Thread Rick Hillegas
Dan's workaround is very useful and Øyvind's suggestion is interesting also. It's worth pointing out that the need for these workarounds should decrease after we fix bug 533 (the re-enabling of the natonal character datatypes). I hope to get to that bug in 10.2. The national character datatypes

Re: Language based ordering is possible in Derby

2005-11-03 Thread Michael Segel
On Thursday 03 November 2005 03:59, [EMAIL PROTECTED] wrote: Is it just me, or didn't someone just post that UDRs were not available in Derby, but that the code was still there in Cloudscape? According to the Derby site at Apache, Derby supports UNICODE. (Really a small little blurb.) So in the

Re: Language based ordering is possible in Derby

2005-11-03 Thread Oyvind . Bakksjo
Daniel John Debrunner wrote: A post on the Cloudscape forum asked how to do ordering based upon the Polish alphabet. I think there have been similar posts here. http://www-128.ibm.com/developerworks/forums/dw_thread.jsp?forum=370&thread=96898&message=13759450&cat=19 I realised today there is a