Welcome to ModelRight Database Design Tool - Database Modeling Done Right Sign in | Join | Help
in
ModelRight Database Design Too... » ModelRight » General » Wrong Max Value of sequence in reverse engineering (Oracle)

Wrong Max Value of sequence in reverse engineering (Oracle)

Last post 10-12-2009, 2:50 AM by peter. 2 replies.
Sort Posts: Previous Next

  •  10-09-2009, 4:57 AM 1339

    Wrong Max Value of sequence in reverse engineering (Oracle)

    Reply Quote

    I've got a sequence with MAXVALUE 999999999
    which will result in MAXVALUE 1e+009 after reverse engineering
    which is MAXVALUE 1000000000

    This will lead to problems when using this sequence with CYCLE for a NUMER(9) field, since MAXVALUE exceeds the possible range.

    Regards, Peter

  •  10-09-2009, 7:29 AM 1341 in reply to 1339

    Re: Wrong Max Value of sequence in reverse engineering (Oracle)

    Reply Quote
    Could you please send bugs to [email protected].  That way they get tracked in our bug tracking system.
    Scott Reynolds
    Technical Support Engineer
    ModelRight, Inc.
    www.modelright.com
    p: (609) 423-9296
    f: (866) 812-3742

  •  10-12-2009, 2:50 AM 1348 in reply to 1341

    Re: Wrong Max Value of sequence in reverse engineering (Oracle)

    Reply Quote
    Sure, sorry. Now reported as "Rounding error in MAXVALUE of sequence"
[email protected]    609-423-9296    /    [email protected]    609-423-9297        Copyright @ 2006-2009 ModelRight, Inc. All rights reserved.