Uploaded image for project: 'MariaDB ColumnStore'
  1. MariaDB ColumnStore
  2. MCOL-2060

sql_mode does not include STRICT_TRANS_TABLES by defaults

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Open (View Workflow)
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: 1.2.2
    • Fix Version/s: 1.4
    • Component/s: None
    • Labels:
      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

            Activity

              People

              Assignee:
              Unassigned
              Reporter:
              winstone Zdravelina Sokolovska
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Dates

                Created:
                Updated: