Re: Bug in function index

On Tue, 12 Aug 2003 10:48:18 -0400, John Carlson wrote: Working on an rewrite of functional index handling in myschema. It does not handle multiple function keys or mixed column & function keys either in the current release. That's what I get for writing that support when we no longer had a 9.xx online for me to play with. Coding done, debugging...... Art S. Kagel > On Tue, 12 Aug 2003 10:39:10 -0400, John Carlson > <john_carlson@whsmithusa.com> wrote: > >>On Tue, 12 Aug 2003 10:38:07 -0400, John Carlson >><john_carlson@whsmithusa.com> wrote: >> >>>On Mon, 11 Aug 2003 09:48:29 -0400, "rkusenet" <rkusenet@sympatico.ca> >>>wrote: >>> >>>>I found a bug in informix function index which has been confirmed in >>>>IDS 9.21.UC4 and IDS 9.40.UC1. I am assuming that it must be existing >>>>in IDS 9.30 also. >>>> >>>> >>>Yes, it's there . . . .in 9.30.HC3 >>> >>>Looks like myschema is afflicted as well . . . missing the DESC keyword >>>on the create for index 'rwet'..... >> >>Myschema features version 6.21 -- source version 2.95. > > Ditto for features version 6.24 -- Source revision 2.115 (most recent > version on IIUG website).

On Tue, 12 Aug 2003 16:59:35 -0400, "Art S. Kagel" <kagel@bloomberg.net> wrote: >On Tue, 12 Aug 2003 10:48:18 -0400, John Carlson wrote: > >Working on an rewrite of functional index handling in myschema. It does >not handle multiple function keys or mixed column & function keys either >in the current release. That's what I get for writing that support when >we no longer had a 9.xx online for me to play with. Coding done, >debugging...... > Sorry, Art . . . .it wasn't meant as a criticism . . . I really enjoy myschema . . . . much more flexible than dbschema . . . No longer having 9.xx online . . .? Doesn't sound good . . . . did you have to revert back to 7.3x?? If you don't have 9.xx in house, then how can you code the fixes? I know that you're good, but . . . wow . . . . 8-) JWC

On Tue, 12 Aug 2003 17:53:24 -0400, John Carlson wrote: > On Tue, 12 Aug 2003 16:59:35 -0400, "Art S. Kagel" <kagel@bloomberg.net> > wrote: > >>On Tue, 12 Aug 2003 10:48:18 -0400, John Carlson wrote: >> >>Working on an rewrite of functional index handling in myschema. It does >>not handle multiple function keys or mixed column & function keys either >>in the current release. That's what I get for writing that support when >>we no longer had a 9.xx online for me to play with. Coding done, >>debugging...... >> >> > Sorry, Art . . . .it wasn't meant as a criticism . . . I really enjoy > myschema . . . . much more flexible than dbschema . . . I did not take your post as criticism. Just wanted to let everyone know I'm on the case! > No longer having 9.xx online . . .? Doesn't sound good . . . . did you > have to revert back to 7.3x?? If you don't have 9.xx in house, then how > can you code the fixes? I know that you're good, but . . . wow . . . . We only use 7.31 here, mostly because we are still running many servers on a desupported platform (don't ask!) and partly because I'm not doing the DBA stuff here anymore and the guys who replaced me are not quite as brave nor as assertive. I had a 9.21 instance on one machine for testing and for maintaining the utilities on 9, but it was taken down to release its disk space for reuse. I actually coded the original functional key support using only the manuals and some sysindices dumps someone was kind enough to send me and look how good that turned out! So I guess I am really not THAT good! ;-) Anyway I now have 9.4UC2 up on Linux 7.3 and have completed recoding the functional index key support. Anyone brave want to exercise it a bit for me? This is a major rewrite to all of the 9.xx index handling so it needs a good shakout before I'll post it to the Repository and I don't have nearly enough data in 9 to test it thoroughly. Art S. Kagel > JWC