At 09:49 AM 10/26/2001 -0500, Woody wrote:

>Since I haven't looked at code for either IB or FB, maybe I'm off-base here,
>but, could you give a simple explanation as to why it would effect so much
>Ann? It would be my contention that it should only really effect the SQL
>parser code since it would be there that table and field names would be
>tested for validity, no?

No. The SQL parsing is only the first step. The names are carried through
DSQL compilation and the generation of BLR. They then go to the main part
of the engine where the blr is parsed and the result is compiled and optimized.
Only at the end of that process have names been replaced with field and
table ids. Those ids are transient - they change every time the database
is restored from a backup. The name is the true identifier for a field
or table. For DDL requests, of course, the names must be preserved throughout.

Throughout the engine there are routines that compare names. If I had
added quoted identifiers, I hope I would have had the sense to centralize
those operations - something we may yet do to allow native language and
long names. As it is, there is code everywhere that had to be taught to
deal with spaces, for example. Claudio can expand on that, having found
at least 4 different places that hadn't been fixed.

Regards,

Ann
www.ibphoenix.com
We have answers.