This is an automated email from the ASF dual-hosted git repository. struberg pushed a commit to branch master in repository https://gitbox.apache.org/repos/asf/openjpa.git
commit a5b50a5bd4ca8b0de8ca8032aeaca0b383163bc9 Author: Mark Struberg <[email protected]> AuthorDate: Wed Apr 3 00:21:02 2019 +0200 OPENJPA-2784 add docs for sub-second fractions in MariaDB and MySQL --- .../src/doc/manual/supported_databases.xml | 31 ++++++++++++++++++++++ 1 file changed, 31 insertions(+) diff --git a/openjpa-project/src/doc/manual/supported_databases.xml b/openjpa-project/src/doc/manual/supported_databases.xml index a4e8dad..d194276 100644 --- a/openjpa-project/src/doc/manual/supported_databases.xml +++ b/openjpa-project/src/doc/manual/supported_databases.xml @@ -1176,6 +1176,37 @@ When reading LOB data from the database, the MySQL JDBC driver will actually load all the data into memory at the same time. </para> </listitem> + <listitem> + <para> +As of MySQL 5.7 the <code>DATETIME</code> data type supports sub-second fractions. +The default of MySQL is to use no fractions. +The number of fractions can be explicitly set via scale: +<code>@Column(scale=3)</code> will lead to a <code>DATETIME(3)</code> column. + </para> + </listitem> + + </itemizedlist> + </section> + </section> + + <section id="dbsupport_mariadb"> + <title> + MariaDB + </title> + <section id="dbsupport_mariadb_issues"> + <title> + Known issues with MariaDB + </title> + <itemizedlist> + <listitem> + <para> + As of MariaDB 10.2 the <code>DATETIME</code> data type supports sub-second fractions. + The default of MariaDB is to use no fractions. + The number of fractions can be explicitly set via scale: + <code>@Column(scale=3)</code> will lead to a <code>DATETIME(3)</code> column. + </para> + </listitem> + </itemizedlist> </section> </section>
