Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-3841 LevelDB storage engine
  3. MDEV-3963

JOIN or WHERE conditions involving keys on LevelDB tables don't work

    XMLWordPrintable

Details

    • Technical task
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • None
    • None
    • None

    Description

      CREATE TABLE t1 (i INT PRIMARY KEY) ENGINE=LevelDB;
      INSERT INTO t1 VALUES (1),(3);
      CREATE TABLE t2 (j INT PRIMARY KEY) ENGINE=LevelDB;
      INSERT INTO t2 VALUES (1),(4);
       
      EXPLAIN EXTENDED
      SELECT * FROM t1, t2 WHERE i=j;
      # id      select_type     table   type    possible_keys   key     key_len ref     rows    filtered        Extra
      # 1       SIMPLE  t1      ALL     PRIMARY NULL    NULL    NULL    1000    100.00  NULL
      # 1       SIMPLE  t2      eq_ref  PRIMARY PRIMARY 4       test.t1.i       1       100.00  NULL
      # Warnings:
      # Note    1003    /* select#1 */ select `test`.`t1`.`i` AS `i`,`test`.`t2`.`j` AS `j` from `test`.`t1` join `test`.`t2` where (`test`.`t2`.`j` = `test`.`t1`.`i`)
       
      SELECT * FROM t1, t2 WHERE i=j;
      # i       j
       

      revision-id: psergey@askmonty.org-20121221152341-9stvnkuiinslrt9h
      date: 2012-12-21 19:23:41 +0400
      build-date: 2012-12-21 22:11:06 +0400
      revno: 4471
      branch: mysql-5.6-leveldb

      Attachments

        Activity

          People

            psergei Sergei Petrunia
            elenst Elena Stepanova
            Votes:
            0 Vote for this issue
            Watchers:
            1 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.