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

Procedure call with boolean expression parameter using more than one exists function crash the server

    XMLWordPrintable

Details

    • Bug
    • Status: Confirmed (View Workflow)
    • Major
    • Resolution: Unresolved
    • 10.4, 10.4.28, 10.5, 10.6, 10.7, 10.8, 10.9, 10.10, 10.11, 11.0
    • 10.4, 10.5, 10.6, 10.11, 11.0
    • None
    • Red Hat Enterprise Linux release 8.7 (Ootpa)

    Description

      After upgrading from 10.4.25 to 10.4.28 the call of a procedure using booelan parameter with multiple existsf does not work and make the server crash.

      The error log shows that server restarts but there is no stack trace or other information.

      Steps to reproduce:

      create or replace schema bug_boolean_parameter;

      use bug_boolean_parameter;

      create table table_1
      (
      id bigint not null,
      primary key (id)
      );

      delimiter #

      create procedure proc_1(param_1 boolean)
      begin
      select param_1;
      end#

      delimiter ;

      call proc_1(exists(select * from table_1)); – works fine
      call proc_1(exists(select * from table_1) or exists(select * from table_1)); – crashes

      drop schema bug_boolean_parameter;

      Attachments

        Activity

          People

            shulga Dmitry Shulga
            marc.langevin@usherbrooke.ca Marc
            Votes:
            0 Vote for this issue
            Watchers:
            4 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.