XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Critical
    • Resolution: Duplicate
    • 10.11.5, 11.1.3
    • N/A
    • Optimizer, Server
    • None
    • docker quay.io/mariadb-foundation/mariadb-devel:latest

    Description

      Reproduce testcase:

      SET default_storage_engine = InnoDB ;
      CREATE TABLE v0 ( v1 INT , v2 SMALLINT NOT NULL PRIMARY KEY ) ;
      SELECT v2 FROM v0 . TABLES WHERE v1 = 'x' AND v2 = 'x' ;
      INSERT INTO v0 VALUES ( 99 , 'x' ) ;
      INSERT INTO v0 VALUES ( v1 , v1 NOT IN ( WITH v0 AS ( SELECT 68 * 8 FROM v0 ) SELECT * FROM v0 GROUP BY v1 HAVING v1 >= NULL AND ( NULL , 9877221.000000 ) < ( NULL , 'x' ) ) ) ;
      INSERT INTO v0 VALUES ( v1 , 'x' ) ;
      SELECT * FROM v0 ORDER BY v2 ;
      DELETE FROM t1 ;
      SELECT * FROM v0 ORDER BY v1 ;
      ROLLBACK ;
      SELECT * FROM v0 ORDER BY v1 ;
      DELETE FROM t1 ;
      START TRANSACTION ;
      SELECT * FROM v0 ORDER BY v1 ;
      COMMIT ;
      SELECT * FROM v0 ORDER BY v2 ;
      DELETE FROM t1 ;
      START TRANSACTION ;
      SELECT * ORDER BY v2 ;
      ROLLBACK ;
      SELECT v1 , v1 FROM v0 WHERE v2 > 0 AND CASE ( 0 ) WHEN NOT NOT NULL THEN 'x' / 93 END < 'x' ;
      DELETE FROM t1 ;
      DROP TABLE v0 ;

      ERROR 2013 (HY000): Lost connection to server during query

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              csfuzz csfuzz
              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.