jackye1995 commented on issue #7420: URL: https://github.com/apache/iceberg/issues/7420#issuecomment-1523756849
According to Oracle Documentation https://docs.oracle.com/cd/B19306_01/server.102/b14200/sql_elements001.htm, in the section of `NUMBER Datatype`: > Scale can be greater than precision, most commonly when e notation is used. When scale is greater than precision, the precision specifies the maximum number of significant digits to the right of the decimal point. For example, a column defined as NUMBER(4,5) requires a zero for the first digit after the decimal point and rounds all values past the fifth digit after the decimal point. > It is good practice to specify the scale and precision of a fixed-point number column for extra integrity checking on input. Specifying scale and precision does not force all values to a fixed length. If a value exceeds the p We probably want to look a bit more into the SQL standard of the definition of Decimal. -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
