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

Problems with Mroonga storage engine

    XMLWordPrintable

Details

    Description

      I have detected an issue when execute a select count of another query that internaly uses myisam with mroonga with an index.

      I have attached a file that demostrates the problem.

      The result of the sql script is:

      SELECT COUNT(*) FROM tbl_aaa;
       
      COUNT(*)
      10
       
      SELECT COUNT(*) FROM tbl_bbb;
       
      COUNT(*)
      20
       
      SELECT COUNT(*)
      FROM (
      	SELECT a.id
      	FROM tbl_aaa a
      	LEFT JOIN tbl_bbb b ON b.id_aplicacion=21 AND b.id_registro=a.id
      ) c;
       
      COUNT(*)
      10
       
      CREATE INDEX ccc ON tbl_bbb (id_registro);
       
      SELECT COUNT(*)
      FROM (
      	SELECT a.id
      	FROM tbl_aaa a
      	LEFT JOIN tbl_bbb b ON b.id_aplicacion=21 AND b.id_registro=a.id
      ) c;
       
      COUNT(*)
      15
      

      Attachments

        Activity

          People

            kou Kouhei Sutou
            sanz Josep Sanz
            Votes:
            0 Vote for this issue
            Watchers:
            2 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.