Allow user to get original names of meta-objects (tables, fields, views,
SP(with params), etc)
----------------------------------------------------------------------------------------------
Key: CORE-4455
URL: http://tracker.firebirdsql.org/browse/CORE-4455
Project: Firebird Core
Issue Type: New Feature
Reporter: Nick Dee
Priority: Minor
Attachments: screen4.gif
It will be useful in IDEs.
case 1: create table FirebirdFeatures(Id integer not null, ShortDescription
varchar(200), LongDescription blob sub_type text);
case 2: create table "FirebirdFeatures"("Id" integer not null,
"ShortDescription" varchar(200), "LongDescription" blob sub_type text);
After it in system tables we have:
case 1:
RDB$RELATIONS.RDB$RELATION_NAME = 'FIREBIRDFEATURES';
RDB$RELATION_FIELDS.RDB$FIELD_NAME = 'ID';
RDB$RELATION_FIELDS.RDB$FIELD_NAME = 'SHORTDESCRIPTION';
RDB$RELATION_FIELDS.RDB$FIELD_NAME = 'LONGDESCRIPTION';
All in UPPERCASE, and original case is lost forewer.
case 2:
RDB$RELATIONS.RDB$RELATION_NAME = 'FirebirdFeatures';
RDB$RELATION_FIELDS.RDB$FIELD_NAME = 'Id';
RDB$RELATION_FIELDS.RDB$FIELD_NAME = 'ShortDescription';
RDB$RELATION_FIELDS.RDB$FIELD_NAME = 'LongDescription';
All in original case. It's ok. But now we must add double quotes (" ") in any
sql:
select "Id", "ShortDescription, "LongDescription" from "FirebirdFeatures";
So. Case 1 is unusable because of original case lost. Case 2 is unusable
because of double quotes everywhere in sql code.
I suggest to add fields RDB$SRC_*_NAME to all system tables with system object
names, and put there names in original case.
So we can get it from there and use in query builder (for example) with
original word-cases, like in attached picture.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
------------------------------------------------------------------------------
Learn Graph Databases - Download FREE O'Reilly Book
"Graph Databases" is the definitive new guide to graph databases and their
applications. Written by three acclaimed leaders in the field,
this first edition is now available. Download your free book today!
http://p.sf.net/sfu/NeoTech
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
