Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Won't Do
-
1.2.2
-
None
Description
sql_mode does not include STRICT_TRANS_TABLES by defaults
note: that will affect both Columnstore or InnoDB tables created under columnstore
installation
note2:builtin innodb_version 10.3.11 and server version 10.3.11-MariaDB
expected :STRICT_TRANS_TABLES is included in sql_mode by defaults referring to MariaDB documentation, from MariaDB server version 10.2.4
MariaDB [a]> SELECT @@sql_mode;
|
+-----------------------------------------------------------------------+
|
| @@sql_mode |
|
+-----------------------------------------------------------------------+
|
| ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION |
|
+-----------------------------------------------------------------------+
|
1 row in set (0.005 sec)
|
|
Attachments
Issue Links
- relates to
-
MCOL-2059 Strings or empty strings are inserted as zero values in numeric data types
- Closed