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

CONNECT BIN unsigned fails on DISTRIB=sorted

    XMLWordPrintable

    Details

      Description

      create a CONNECT BIN table with a unsigned field is not creating the .bop block_index file,
      also fails on optimize table as well.:

      create table tm (
       time INT4 unsigned not null DEFAULT 0 field_format='X' DISTRIB=sorted,
       data INT4 unsigned not null DEFAULT 0 field_format='X'
      ) engine=CONNECT table_type=BIN block_size=128  file_name='tm.dat';
      

      then INSERT 1000 rows,

      MariaDB [test]> select * from tm limit 10;
       
      | time       | data    |
       
      | 1651378127 | 7447060 |
      | 1651378187 | 6197231 |
      | 1651378288 | 9090561 |
      | 1651378390 | 9525601 |
      | 1651378451 | 4827450 |
      | 1651378511 | 4905942 |
      | 1651378579 | 5260349 |
      

      no tm.bop file shows up:

      -rw-rw---- 1 mysql mysql 8000 Aug 19 14:31 tm.dat
      -rw-rw---- 1 mysql mysql  565 Aug 19 14:31 tm.frm
      

      Optimize fails as well:

      MariaDB [test]> optimize table tm;
       
      | Table   | Op       | Msg_type | Msg_text                                      |
       
      | test.tm | optimize | Error    | Non matching Value types                      |
      | test.tm | optimize | error    | Unknown - internal error 122 during operation |
       
      2 rows in set (0.000 sec)
      

      Recreate table with signed

      drop table tm;
      create table tm (
       time INT4 not null DEFAULT 0 field_format='X' DISTRIB=sorted,
       data INT4 unsigned not null DEFAULT 0 field_format='X'
      ) engine=CONNECT table_type=BIN block_size=128  file_name='tm.dat';

      update tm set time=time-1 limit 1;
      update tm set time=time+1 limit 1

      Now we have tm.bop file:

      -rw-rw---- 1 mysql mysql   80 Aug 19 14:33 tm.bop
      -rw-rw---- 1 mysql mysql 8000 Aug 19 14:33 tm.dat
      -rw-rw---- 1 mysql mysql  565 Aug 19 14:33 tm.frm
      

      And also optimize works

      MariaDB [test]> optimize table tm;
       
      | Table   | Op       | Msg_type | Msg_text |
       
      | test.tm | optimize | status   | OK       |
       
      1 row in set (0.000 sec)
      

      So there seems to be an issue with unsigned types (I tried short as well) and this DISTRIB sorted

        Attachments

          Activity

            People

            Assignee:
            anel Anel Husakovic
            Reporter:
            catam catam
            Votes:
            0 Vote for this issue
            Watchers:
            4 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.