Hi all,
this one is kinda weird on the one hand but on the other, if it's accepted
behaviour, then I can use it for good (not evil).
I've created an i-type field on a file:
0001 I me me mine test index field
0002 if F1 then F1:@tm:F2 else ''
00...
I have created an index on this field and updated it. So far, so good.
However, the index seems to be inverting the result of the i-type resulting
in an index with index_id = F1 and an index_record = F2:@tm:F0. Whereas I
would have expected index_id = F1:@TM:F2 and index_record = F0
The i-type by itself works okay as can be demonstrated by examining the
index file or listing the field without the index:
LIST TESTFILE I.INDEX.FIELD WITH I.INDEX.FIELD NO.INDEX EXPLAIN
Optimizing query block 0
Tuple restriction: F-1 <> ''
Driver source: TESTFILE
Access method: file scan
UniVerse/SQL: Press any key to continue or 'Q' to quit
LIST TESTFILE I.INDEX.FIELD WITH I.INDEX.FIELD NO.INDEX EXPLAIN 05:46:56pm
24 Mar 2004 PAGE 1
TESTFILE I.INDEX.FIELD
63275 750412066
2
1 records listed.
But when listing using the index it bombs out.
LIST TESTFILE I.INDEX.FIELD WITH I.INDEX.FIELD EXPLAIN
Single-variable predicates processed in index:
F-1 <> ''
Optimizing query block 0
Driver source: TESTFILE
Access method: select list 0 with 1 ids
UniVerse/SQL: Press any key to continue or 'Q' to quit
0 records listed.
"2û63275" not found.
Using a separator character such as '*' instead of the @tm the index works
okay. The reason I chose the @tm character as a separator is because SQL
indexes use it in UV. I thought I'd be consistent. Obviously I can either
use a different character or if this is normative behaviour than I can use
it to my advantage. Any clues or should I report this as a bug?
--
Cheers
Stuart Boydell
**********************************************************************
This email message and any files transmitted with it are confidential
and intended solely for the use of addressed recipient(s). If you have
received this email in error please notify the Spotless IS Support Centre (61 3 9269
7555) immediately who will advise further action.
This footnote also confirms that this email message has been scanned
for the presence of computer viruses.
**********************************************************************
--
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users
