| Subject | Re: [firebird-support] Select problem --- numeric (13,4) field --- |
|---|---|
| Author | Helen Borrie |
| Post date | 2003-11-12T16:05:59Z |
At 03:20 PM 12/11/2003 +0000, you wrote:
100.0000 * 100.0000 * 100.0000 * 100.0000 gives a scale of 16 but you have
only defined 13 digits of precision.
h.
>Hi folks,price=100.0000 actually.
>
>I have a table with a NUMERIC(13,4) field,
>and a simple query:
>
>SELECT PRICE*PRICE*PRICE*PRICE FROM MY_TABLE
>
>This SQL gets an error:
>"Integer overflow. The result of an integer operation caused the most
>significant bit of the result to carry."
>
>But this works well:
>SELECT PRICE*PRICE*PRICE FROM MY_TABLE
>
>(PRICE=100 now, and one record exists in the table)
100.0000 * 100.0000 * 100.0000 * 100.0000 gives a scale of 16 but you have
only defined 13 digits of precision.
h.
>Do you know this problem?
>
>Sandor
>
>
>
>
>To unsubscribe from this group, send an email to:
>firebird-support-unsubscribe@yahoogroups.com
>
>
>
>Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/