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

Some bugs in direct join

Details

    Description

      Some bugs in direct join
      Table: will1 (zone is primary key)
      Table: will2 (account is primary key)
      select name will1.zone as zone from will2,will1 where will2.zone=will1.zone and account = 'o110W5yqygj8LeFHXT2FEr-Ft_Zc';
      select * from will2
      (then crash)

      disable this feature

      Attachments

        Activity

          Ascending order - Click to sort in descending order
          Kentoku Kentoku Shiba (Inactive) added a comment -

          willhan
          It's already fixed. Additionally, I added const_table support to the direct join feature and condition pushdown feature.
          Please check test results of the following commit.
          ebf3376

          Kentoku Kentoku Shiba (Inactive) added a comment - willhan It's already fixed. Additionally, I added const_table support to the direct join feature and condition pushdown feature. Please check test results of the following commit. ebf3376
          willhan willhan added a comment -

          It's ok

          willhan willhan added a comment - It's ok
          Kentoku Kentoku Shiba (Inactive) added a comment -

          merging

          Kentoku Kentoku Shiba (Inactive) added a comment - merging

          People

            Kentoku Kentoku Shiba (Inactive)
            willhan willhan
            Votes:
            0 Vote for this issue
            Watchers:
            3 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.