Reported By: Danny Humphress Reported On: 8/20/2004 For: Version 4.10 Build 1
# 1833CREATE TABLE SQL Statement with TEXT INDEX Specified Causes List Out of Bounds Error I get an index list out of bounds (3) error on the following.
DROP TABLE IF EXISTS InvMarc;
CREATE TABLE InvMarc (
"Number" LARGEINT,
"Contents" MEMO,
"Keywords" MEMO,
PRIMARY KEY (Number)
TEXT INDEX ("Keywords")
STOP WORDS ''
INCLUDE CHARS #1+#2+#3+#4+#5+#6+#7+#8+#9+#10+#11+#12+#13
+#14+#15+#16+#17+#18+#19+#20+#21+#22+#23
+#24+#25+#26+#27+#28+#29+#30+#31+'!"#$%&'+
'''()*+,-./0123456789:;<=>?@ABCDEFGHIJKLM'+
'NOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrstu'+
'vwxyz{|}~'+
' '+
''+
''
BLOB BLOCK SIZE 64
USER MAJOR VERSION 4
USER MINOR VERSION 28
);
ResolutionFixed Problem on 8/22/2004 in version 4.11 build 1