Icon View Incident Report

Serious Serious
Reported By: Danny Humphress
Reported On: 8/20/2004
For: Version 4.10 Build 1
# 1833 CREATE 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
);



Resolution Resolution
Fixed Problem on 8/22/2004 in version 4.11 build 1
Image