> -----Original Message-----
> From: Jirí Cincura [mailto:j...@cincura.net] 
> Sent: Lunes, 14 de Septiembre de 2015 11:30
> 
> The resulting "show domain" produces different results. Which is at
> least confusing.

You never do 
show domain <implicit domain>
under normal circumstances. You do
show domain <explicit domain>
or
show table <t>
where the tool should recover the information from both implicit and
explicit domains and merge it with the each field's information.

> Of course tools like IBExpert are confused by this as
> well. Especially for raw DDL exports (which for computed columns is
> weird, I know).

The rule has been the same for 25 years:
- look at the domain (implicit or explicit) that is referenced in the rel
field
- look at the relation field
- if the rel field has some not null value V that overrides the domain, use
V. This is the case with the collation and there may be more cases that I
forgot.

If a tool has a problem with that, tell the author to enhance it. The
situation inside FB may not be 100% ideal but it's not a bug. Now if you
want to log it as a bug, it's your pleasure.

C.


------------------------------------------------------------------------------
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Reply via email to