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

sql_mode does not include STRICT_TRANS_TABLES by defaults

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Won't Do
    • 1.2.2
    • N/A, 1.4.5
    • N/A
    • 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

              Unassigned Unassigned
              winstone Zdravelina Sokolovska (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.