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

LP:725050 - Crash with join_cache_hashed with semijoin and join_cache_level=3

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Minor
    • Resolution: Fixed
    • None
    • None
    • None

    Description

      The following example causes a crash in 5.3. The reason to set a
      debug trace is because it forces the call to print_keyuse() via:
      update_ref_and_keys -> print_keyuse_array -> print_keyuse.

      create table t1 (a int not null);

      set @@optimizer_switch='join_cache_hashed=on,semijoin=on';
      set join_cache_level=3;

      SET @@debug = 'd:t:O,/tmp/trace.out';

      explain
      select a from t1 where a in (
      select a from t1 where a in (
      select a from t1 where a in (
      select a from t1 where a in (
      select a from t1 where a in (
      select a from t1 where a in (
      select a from t1 where a in (
      select a from t1 where a in (
      select a from t1 where a in (
      select a from t1 where a in (
      select a from t1 where a in (
      select a from t1 where a in (
      select a from t1 where a in (
      select a from t1 where a in (
      select a from t1 where a in (
      select a from t1 where a in (
      select a from t1 where a in (
      select a from t1 where a in (
      select a from t1 where a in (
      select a from t1 where a in (
      select a from t1 where a in (
      select a from t1 where a in (
      select a from t1 where a in (
      select a from t1 where a in (
      select a from t1 where a in (
      select a from t1 where a in (
      select a from t1 where a in (
      select a from t1 where a in (
      select a from t1 where a in (
      select a from t1 where a in (
      select a from t1 where a in (
      select a from t1 where a in (
      select a from t1 where a in (
      select a from t1 where a in (
      select a from t1 where a in (
      select a from t1 where a in (
      select a from t1 where a in (
      select a from t1 where a in (
      select a from t1 where a in (
      select a from t1 where a in (
      select a from t1 where a in (
      select a from t1 where a in (
      select a from t1 where a in (
      select a from t1 where a in (
      select a from t1 where a in (
      select a from t1 where a in (
      select a from t1 where a in (
      select a from t1 where a in (
      select a from t1 where a in (
      select a from t1 where a in (
      select a from t1 where a in (
      select a from t1 where a in (
      select a from t1 where a in (
      select a from t1 where a in (
      select a from t1 where a in (
      select a from t1 where a in (
      select a from t1 where a in (
      select a from t1 where a in (
      select a from t1 where a in (
      select a from t1 where a in (
      select a from t1 where a in (
      select a from t1 where a in ( select a from t1)
      )))))))))))))))))))))))))))))))))))))))))))))))))))))))))))));

      drop table t1;

      Attachments

        Activity

          People

            igor Igor Babaev (Inactive)
            timour Timour Katchaounov (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            0 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.