Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-31425

Update range partitoning example in KB

    XMLWordPrintable

Details

    • Bug
    • Status: Open (View Workflow)
    • Minor
    • Resolution: Unresolved
    • None
    • N/A
    • Documentation
    • None

    Description

      On page https://mariadb.com/kb/en/range-partitioning-type/ there is example that leads to error message

      ERROR 1364 (HY000): Field 'ip' doesn't have a default value
      

      Suggestion to remove ip and action not null, non-default fields.
      Besides that there is a column timestamp with datetime and TIMESTAMP field with insert statement related to later, but with the error message returned for former.

      INSERT INTO log(id,timestamp) VALUES 
        (1, '2016-01-01 01:01:01'), 
        (2, '2015-01-01 01:01:01');
      

      This should return error for timestamp type:

      ERROR 1526 (HY000): Table has no partition for value 1451606461
      

      instead of datetime type:

      ERROR 1526 (HY000): Table has no partition for value 2016
      

      that is returned for other type of insert

      INSERT INTO log(id,timestamp) VALUES 
        (1, '2016-01-01'), 
        (2, '2015-01-01');
      

      Maybe to add both tables?

      Attachments

        Activity

          People

            greenman Ian Gilfillan
            anel Anel Husakovic
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:

              Git Integration

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