On 1/11/08, André Knappstein, Controlling <[EMAIL PROTECTED]> wrote:
> Looking at a column which is not nullable because you set "NOT NULL"
> to the column, you would EXPECT the property "is_nullable" to be
> true, where "true" is represented by the numeric value 1.
> I would NOT, because literally the column is not nullable, and so I
> would not want to have this situation concluded as "column is
> nullable".
>
> Instead I would either expect that the result is 0 where 0 means
> "false" or 1 where 1 means "false" (because the NOT-NULL flag in the
> system table is set to 1 as Helen described...)
>
> Looking at a column which is not nullable because you (only) set it's
> domain to a domain for which you set "NOT NULL", not touching the NOT
> NULL constraint of the column itself, you would EXPECT the
> property "is_nullable" false. I also would, because the column is
> indeed not nullable.
>
> I am a bit worried, in any case, that you would expect different
> results for the 2 cases, because in both cases the column literally
> "is not nullable".
"is_nullable" means, that column accepts NULL values. So it should be
(keep eyes on me Helen :)):
1. domain has "NOT NULL" clause (no matter what's on column
definition) > is_nullable = false
2. column has "NOT NULL" clause > is_nullable = false
3. Othervise is_nullable = true
I'll check the problem during weekend.
> Maybe what you want and need is a (new?) property "NOT_NULL_SET" which
> could result to false for the column while "is_nullable" still _CAN_
> return false because of the underlying domain.
Isn't this just negation of is_nullable? BTW in schema table are some
well-known columns so you cannot adding/removing some in a free way.
--
Jiri {x2} Cincura (Microsoft Student Partner)
http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com
-------------------------------------------------------------------------
Check out the new SourceForge.net Marketplace.
It's the best place to buy or sell services for
just about anything Open Source.
http://ad.doubleclick.net/clk;164216239;13503038;w?http://sf.net/marketplace
_______________________________________________
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
