Icon View Incident Report

Serious Serious
Reported By: Roy Lambert
Reported On: 3/17/2003
For: Version 3.22 Build 1
# 1331 Including a Double Quote in INCLUDE CHARS or SPACE CHARS Causes Reverse Engineer to Generate Bad SQL

Reverse engineering generates invalid SQL when a full text index exists and 'quote' characters are in the INCLUDE CHARS list.

DROP TABLE IF EXISTS "Table1";

CREATE TABLE IF NOT EXISTS "Table1"
(
   "id" AUTOINC,
   "field1" CHARACTER(30),
PRIMARY KEY ("id") COMPRESS NONE
TEXT INDEX ("field1")
STOP WORDS 
"A AN AND BE FOR HOW IN IS IT OF ON OR THAT THE THIS 
TO WAS WHAT WHEN WHICH WHY WILL"
SPACE 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 #32 "* " 
",-./:;<=>\`"
INCLUDE CHARS ""#$%&'()* ,-./0123456789:;<=>?@ABCDEFGH" 
"IJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnop" 
"qrstuvwxyz"
LANGUAGE "ANSI Standard" SORT "Default Order"
USER MAJOR VERSION 1
);



Resolution Resolution
Fixed Problem on 3/18/2003 in version 3.23 build 1
Image