Uploaded image for project: 'MariaDB ColumnStore'
  1. MariaDB ColumnStore
  2. MCOL-5107

Columnstore Query crashes MariaDB, signal 11 when function in WHERE clause

    XMLWordPrintable

Details

    • Bug
    • Status: Open (View Workflow)
    • Major
    • Resolution: Unresolved
    • None
    • Icebox
    • None
    • None

    Description

      root@logs:~$ mariadb -s
      MariaDB [(none)]> use ez1_schema;
      MariaDB [ez1_schema]> create table tabCS(col1 integer) engine=columnstore;
      MariaDB [ez1_schema]> create table tabIN(col1 integer) engine=innoDB;
      MariaDB [ez1_schema]> insert into tabCS values ('1');
      MariaDB [ez1_schema]> insert into tabIN values ('1');
      MariaDB [ez1_schema]> drop function if exists F1;
      MariaDB [ez1_schema]> delimiter //
      MariaDB [ez1_schema]> CREATE FUNCTION F1(pDescriprion varchar(100)) RETURNS INT begin
          -> declare g INT;
          -> select col1 into g from tabCS limit 1;
          -> return g;
          -> END;
          -> //
      delimiter ;
       
      drop function if exists F2;
      delimiter //
      MariaDB [ez1_schema]> delimiter ;
      MariaDB [ez1_schema]>
      MariaDB [ez1_schema]> drop function if exists F2;
      MariaDB [ez1_schema]> delimiter //
      MariaDB [ez1_schema]> CREATE FUNCTION F2(pDescriprion varchar(100)) RETURNS INT begin
          -> declare g INT;
          -> select col1 into g from tabIN limit 1;
          -> return g;
          -> END;
          -> //
      delimiter ;MariaDB [ez1_schema]> delimiter ;
      MariaDB [ez1_schema]> create table tabY (col1 varchar(100),col2 int) engine=columnstore;
      MariaDB [ez1_schema]> insert into tabY values ('hello',1);
      MariaDB [ez1_schema]> select F1('x');
      F1('x')
      1
      MariaDB [ez1_schema]> select F2('x');
      F2('x')
      1
      MariaDB [ez1_schema]> select col1 from tabY where col2=F1('x');
      ERROR 2013 (HY000): Lost connection to server during query
      MariaDB [ez1_schema]> select F1('x');
      ERROR 2006 (HY000): Server has gone away
      F1('x')
      1
      MariaDB [ez1_schema]> select F1('x');
      F1('x')
      1
      MariaDB [ez1_schema]> select col1 from tabY where col2=F2('x');
      ERROR 2013 (HY000): Lost connection to server during query
      MariaDB [ez1_schema]> exit
      

      If a function returns a value that is selected out of a database table, Columnstore crashes MariaDB with a signal 11. The function can return data from a Columnstore or InnoDB table. In either case, the database crashes.

      Attachments

        Activity

          People

            Unassigned Unassigned
            edward Edward Stoever
            Votes:
            0 Vote for this issue
            Watchers:
            1 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.