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

Details

    • Bug
    • Status: Confirmed (View Workflow)
    • Major
    • Resolution: Unresolved
    • 10.4.28, 10.4(EOL), 10.5, 10.6, 10.7(EOL), 10.8(EOL), 10.9(EOL), 10.10(EOL), 10.11, 11.0(EOL), 11.4, 11.8
    • 10.5, 10.6, 10.11, 11.4, 11.8
    • 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

        Issue Links

          Activity

            Transition Time In Source Status Execution Times
            Alice Sherepa made transition -
            Open Confirmed
            3h 24m 1

            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.