This is an automated email from the ASF dual-hosted git repository. dongjoon pushed a commit to branch master in repository https://gitbox.apache.org/repos/asf/spark.git
The following commit(s) were added to refs/heads/master by this push: new 10a308774b71 [SPARK-47781][SPARK-47791][SPARK-47798][DOCS][FOLLOWUP] Update the decimal mapping remarks with JDBC data sources 10a308774b71 is described below commit 10a308774b71cf774f1e661c5f55829b61c00521 Author: Kent Yao <y...@apache.org> AuthorDate: Wed Apr 10 14:05:49 2024 -0700 [SPARK-47781][SPARK-47791][SPARK-47798][DOCS][FOLLOWUP] Update the decimal mapping remarks with JDBC data sources ### What changes were proposed in this pull request? Followup of SPARK-47781, SPARK-47791 and SPARK-47798, to update the decimal mapping remarks with JDBC data sources ### Why are the changes needed? doc revision ### Does this PR introduce _any_ user-facing change? no ### How was this patch tested? doc build ### Was this patch authored or co-authored using generative AI tooling? no Closes #45984 from yaooqinn/SPARK-47781-F. Authored-by: Kent Yao <y...@apache.org> Signed-off-by: Dongjoon Hyun <dh...@apple.com> --- docs/sql-data-sources-jdbc.md | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/docs/sql-data-sources-jdbc.md b/docs/sql-data-sources-jdbc.md index 84e2d7f06381..d99e7bc9e519 100644 --- a/docs/sql-data-sources-jdbc.md +++ b/docs/sql-data-sources-jdbc.md @@ -544,7 +544,7 @@ are also available to connect MySQL, may have different mapping rules. <tr> <td>DECIMAL(p,s) [UNSIGNED]</td> <td>DecimalType(min(38, p),(min(18,s)))</td> - <td>The column type is bounded to DecimalType(38, 18), thus if any value of this column have a actual presion greater 38 will fail with DECIMAL_PRECISION_EXCEEDS_MAX_PRECISION </td> + <td>The column type is bounded to DecimalType(38, 18), if 'p>38', the fraction part will be truncated if exceeded. And if any value of this column have an actual precision greater 38 will fail with NUMERIC_VALUE_OUT_OF_RANGE.WITHOUT_SUGGESTION error</td> </tr> <tr> <td>DATE</td> @@ -845,7 +845,7 @@ as the activated JDBC Driver. Note that, different JDBC drivers, or different ve <tr> <td>numeric, decimal</td> <td>DecimalType</td> - <td></td> + <td>Since PostgreSQL 15, 's' can be negative. If 's<0' it'll be adjusted to DecimalType(min(p-s, 38), 0); Otherwise, DecimalType(p, s), and if 'p>38', the fraction part will be truncated if exceeded. And if any value of this column have an actual precision greater 38 will fail with NUMERIC_VALUE_OUT_OF_RANGE.WITHOUT_SUGGESTION error</td> </tr> <tr> <td>character varying(n), varchar(n)</td> --------------------------------------------------------------------- To unsubscribe, e-mail: commits-unsubscr...@spark.apache.org For additional commands, e-mail: commits-h...@spark.apache.org