Changing a column definition for a column defined with a domain, should
result in an error.
ie
alter table alter type should not work for columns that use domains.
but the following should work (syntax to be agreed upon as I have seen it
used differently in different databases)
alter table X alter Y domain Z would work (would require the domain being
changed to, exists)
alter domain alter type would also work is all versions of that column need
to change.
best regards
On 3 September 2015 at 14:22, Claudio Valderrama C. <[email protected]> wrote:
> Hello, maybe we can stop this before FB3 is released:
>
> create database 'based.fdb';
> create table t1(a int);
> /* RDB$1 is created */
>
> create table t2(a RDB$1);
> show table t2;
> A INTEGER Nullable
>
> Now two fields point to an implicit domain.
>
> alter table t2 alter a type double precision;
> show table t2;
> A DOUBLE PRECISION Nullable
>
> So far so good, but:
>
> show table t1;
> A DOUBLE PRECISION Nullable
>
> We have a problem of quantum entanglement between fields from different
> tables.
> :-)
>
> C.
> ---
> Claudio Valderrama C.
> Consultant, SW developer.
>
>
>
> ------------------------------------------------------------------------------
> Monitor Your Dynamic Infrastructure at Any Scale With Datadog!
> Get real-time metrics from all of your servers, apps and tools
> in one place.
> SourceForge users - Click here to start your Free Trial of Datadog now!
> http://pubads.g.doubleclick.net/gampad/clk?id=241902991&iu=/4140
> Firebird-Devel mailing list, web interface at
> https://lists.sourceforge.net/lists/listinfo/firebird-devel
>
------------------------------------------------------------------------------
Monitor Your Dynamic Infrastructure at Any Scale With Datadog!
Get real-time metrics from all of your servers, apps and tools
in one place.
SourceForge users - Click here to start your Free Trial of Datadog now!
http://pubads.g.doubleclick.net/gampad/clk?id=241902991&iu=/4140
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
