[Search for users] [Overall Top Noters] [List of all Conferences] [Download this site]

Conference orarep::nomahs::sql

Title:SQL notes
Moderator:NOVA::SMITHI
Created:Wed Aug 27 1986
Last Modified:Thu Jun 05 1997
Last Successful Update:Fri Jun 06 1997
Number of topics:3895
Total number of notes:17726

3892.0. "SQL-W-SMA_DAT_TYP" by chsr38.ch.oracle.com::RROHR (Cajun? Zydeco? Both!) Mon Jun 02 1997 10:04

AXP 7.1 Rdb 7.0 Eco1 and  VAX 6.1 Rdb 6.0-15
    
create domain int_day_test interval day;
sho dom int_day_test;
INT_DAY_TEST                    INTERVAL         
                                 DAY (2)
alter domain int_day_test interval day;
%SQL-W-SMA_DAT_TYP,  Altering domain INT_DAY_TEST to a smaller data type may cau
se data loss
sho dom int_day_test;
INT_DAY_TEST                    INTERVAL         
    
    Why is there a warning if the interval is of the same datatype. (Asks a
    confused customer).
    
    Thanks,
    Regina
T.RTitleUserPersonal
Name
DateLines
3892.1NOVA::SMITHIDon't understate or underestimate Rdb!Mon Jun 02 1997 11:013
There is no reason for this warning.  Bug it and we will get it fixed.

Ian
3892.2BUG 500381chsr38.ch.oracle.com::RROHRCajun? Zydeco? Both!Mon Jun 02 1997 11:152
    Thanks,
    Regina