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

LDI into datetime columns, data got saturated.

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Minor
    • Resolution: Fixed
    • None
    • 1.0.1
    • ExeMgr
    • None
    • 1.0.2-1

    Description

      LDI into datetime columns, data got saturated. insert works correctly

      value used for testing is " 1400-01-01 00:00:00"
      "char data type only is ok
      +--------+--------+--------+--------+--------+--------+---------+----------+-----------+------------+
      | CCHAR1 | CCHAR2 | CCHAR3 | CCHAR4 | CCHAR5 | CCHAR6 | CCHAR7  | CCHAR8   | CCHAR9    | CCHAR255   |
      +--------+--------+--------+--------+--------+--------+---------+----------+-----------+------------+
      | z      | zz     | zzz    | zzzz   | zzzzz  | zzzzzz | zzzzzzz | zzzzzzzz | zzzzzzzzz | zzzzzzzzzz |
      +--------+--------+--------+--------+--------+--------+---------+----------+-----------+------------+
      1 row in set (0.26 sec)
       
      Adding a datetime datatype in front and use a value of ""1400-01-01 00:00:00""
      Both c1 and cchar255 got saturated
       
      MariaDB [mytest]> select * from t1;
      +------+--------+--------+--------+--------+--------+--------+---------+----------+-----------+----------+
      | c1   | CCHAR1 | CCHAR2 | CCHAR3 | CCHAR4 | CCHAR5 | CCHAR6 | CCHAR7  | CCHAR8   | CCHAR9    | CCHAR255 |
      +------+--------+--------+--------+--------+--------+--------+---------+----------+-----------+----------+
      | NULL | z      | zz     | zzz    | zzzz   | zzzzz  | zzzzzz | zzzzzzz | zzzzzzzz | zzzzzzzzz | zzzzzzz  |
       
       
      adding datetime to the end, then only c1 got saturated
      +--------+--------+--------+--------+--------+--------+---------+----------+-----------+------------+------+
      | CCHAR1 | CCHAR2 | CCHAR3 | CCHAR4 | CCHAR5 | CCHAR6 | CCHAR7  | CCHAR8   | CCHAR9    | CCHAR255   | c1   |
      +--------+--------+--------+--------+--------+--------+---------+----------+-----------+------------+------+
      | z      | zz     | zzz    | zzzz   | zzzzz  | zzzzzz | zzzzzzz | zzzzzzzz | zzzzzzzzz | zzzzzzzzzz | NULL |
      +--------+--------+--------+--------+--------+--------+---------+----------+-----------+------------+------+
      1 row in set (0.12 sec)
      

      "

      Attachments

        Activity

          People

            dleeyh Daniel Lee (Inactive)
            dshjoshi Dipti Joshi (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.