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

Index prefix is ignored (Connect engine)

    Details

      Description

      When using col_name(length) syntax to specify an index prefix length, Connect engine ignores prefix and build whole index

      create table t1 (
      	id int not null,
        `name` varchar(150) NOT NULL,
        b varbinary (50) NOT NULL,
        c char (20) NOT NULL,
      index (name(5)),
      index (b(5)),
      index (c(5))
      )engine=CONNECT;
      Query OK, 0 rows affected, 2 warnings (0.05 sec)
       
      show create table t1;
      +-------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
      | Table | Create Table                                                                                                                                                                                                                        |
      +-------+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
      | t1    | CREATE TABLE `t1` (
        `id` int(11) NOT NULL,
        `name` varchar(150) NOT NULL,
        `b` varbinary(50) NOT NULL,
        `c` char(20) NOT NULL,
        KEY `name` (`name`),
        KEY `b` (`b`),
        KEY `c` (`c`)
      ) ENGINE=CONNECT DEFAULT CHARSET=latin1 |
      

        Attachments

          Activity

            People

            • Assignee:
              bertrandop Olivier Bertrand
              Reporter:
              alice Alice Sherepa
            • Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: