we have two database servers. one with Adaptive Server 11.9.2, the other
with Adaptive Server 18.104.22.168.
On both are exactly the same databases. In one table there is a char(1)
column bound to a user datatype including a rule, which allows only a "Y"
or a "N". The column is allowed to have NULL values
If I try to insert a row under 11.9.2 nothing happens, I can insert a NULL
value in this column.
Under 22.214.171.124 I get the error 522 "A column insert or update conflicts
with a rule bound to the column ..... "
I cannot explain that for myself. Is there a significant difference between
the two versions regarding rules and NULL values?
Since this is urgent, I would appreciate if anyone could give me an answer
about that "funny" behavior.