Computed columns with implicit/explicit datatypes are not distinguishable
-------------------------------------------------------------------------
Key: CORE-5168
URL: http://tracker.firebirdsql.org/browse/CORE-5168
Project: Firebird Core
Issue Type: Sub-task
Affects Versions: 3.0 RC2, 2.5.5, 2.1.7
Reporter: Arioch
Priority: Minor
As of know when inspecting the database (extracting metadata) tools can not
tell inspecting COMPUTED-BY columns whether it was generated with specific
user-mandate type or with default type.
create table xxx(
ID SMALLINT NOT NULL,
g_Default COMPUTED BY ( -ID )
g_Explicit SMALLINT COMPUTED BY (-ID)
g_Extended INTEGER COMPUTED BY (-ID)
);
At best one can use heuristics to for a guesswork whether the column LOOKS like
being created with explicit/default datatype.
http://www.sql.ru/forum/1205742/skript-tablic-s-polem-vychislimogo-polya-s-yavnym-tipom
There seems to be no way to inspect the table and reconstruct/distinguish the
declarations of both g_Default and g_Explicit
--
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
------------------------------------------------------------------------------
Transform Data into Opportunity.
Accelerate data analysis in your applications with
Intel Data Analytics Acceleration Library.
Click to learn more.
http://pubads.g.doubleclick.net/gampad/clk?id=278785351&iu=/4140
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
