Conference orarep::nomahs::sql

3868.0. "SQL-F-DEFVALUNS Error" by M5::BLEHLBAC (RDB: 34% better than real life) Mon Feb 24 1997 12:11

Hi,

  rdb V6.0-14
  OpenVMS V6.2

  This is a script that is producing an SQL-F-DEFVALUNS error when a
domain default of current_user is dropped using the "alter domain"
statement.  If the domain default is then set to null, then the default
can be dropped.

  It also fails using Rdb V7.0-01.

  Is this a bug??

                                  Thanks,  Barry

-------------------------------------------
SQL> att 'file personnel';
SQL> create domain address_data2_dom char(31)
cont>  default current_user;
SQL> commit;
SQL> alter domain address_data2_dom
cont> drop default;
%SQL-F-DEFVALUNS, Default values are not supported for the data type of
ADDRESS_DATA2_DOM
SQL> alter domain address_data2_dom
cont> set default null;
SQL> commit;
SQL> alter domain address_data2_dom
cont> drop default;
SQL> commit;
SQL>  Exit
-------------------------------------------

please submit a BUG report...

Ian

>>  <<< Note 3868.1 by NOVA::SMITHI "Don't understate or underestimate Rdb!" >>>

>>please submit a BUG report...

>>Ian

  OK .....  will do.