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

Server crash in /sql/item.cc:6192: virtual bool Item_field::fix_fields(THD*, Item**)

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Critical
    • Resolution: Duplicate
    • 10.2.43, 10.3.35
    • N/A
    • Optimizer
    • None
    • ubuntu 18.04

    Description

      poc:

      CREATE TEMPORARY TABLE v1426 ( v1427 TEXT ( 1 ) NOT NULL ) ;
       INSERT INTO v1426 ( v1427 ) VALUES ( 67 ) ;
       UPDATE v1426 SET v1427 = 61 WHERE v1427 = 25 ;
       INSERT INTO v1426 ( v1427 ) VALUES ( ( WITH v1431 AS ( SELECT v1427 FROM ( SELECT v1427 FROM ( SELECT v1427 FROM v1426 WHERE v1427 = CASE v1427 * 19 = -128 WHEN 255 THEN 'x' WHEN ( v1427 IN ( 'x' , -1 , -128 , 62 , 'x' / v1427 = v1427 + CASE FALSE / v1427 = v1427 + CASE v1427 WHEN TRUE THEN -128 ELSE 0 END OR v1427 = v1427 WHEN TRUE THEN 12 ELSE 0 END OR v1427 = v1427 OR v1427 = v1427 ) ) THEN 255 ELSE -1 END / -2147483648 ) AS v1428 NATURAL JOIN v1426 AS v1429 NATURAL JOIN v1426 ) AS v1430 ) SELECT v1427 FROM v1431 WHERE ( ( v1427 , v1427 , v1427 ) < ( 87 , 89998042.000000 NOT LIKE -128 , -2147483648 ) OR v1427 = 53 ) NOT LIKE 'x' AND CASE v1427 * 37 = 0 WHEN 31 THEN FALSE WHEN -1 THEN 'x' ELSE -1 END != 93 WINDOW v1432 AS ( ORDER BY v1427 ) ) ) , ( 54 ) ;
       WITH v1433 AS ( SELECT v1427 FROM v1426 ORDER BY 74927827.000000 ) SELECT ( ( v1427 OR NOT v1427 ) BETWEEN ( ( ( NOT ( ( ( v1427 , NOT ( v1427 = ( SELECT v1427 FROM v1426 WHERE ( ( ( -1 ^ 16 * NULL , v1427 , v1427 ) < ( 3944709.000000 , 0 NOT LIKE 56 , -2147483648 ) ) + -128 , v1427 ) NOT IN ( SELECT ( 'x' = ( v1427 IN ( SELECT v1427 FROM v1426 WHERE v1427 = CASE WHEN v1427 < 'x' THEN 'x' ELSE v1427 END / -1 ) ) ) , 'x' FROM v1426 ) ) * 61 + 2147483647 ^ 66 ) IN ( -32768 , 14 ) , v1427 ) < ( 2147483647 , 92 NOT LIKE 19 , FALSE ) ) * NULL ) ) ) ) AND 47045683.000000 ) , 'x' FROM v1433 WINDOW v1434 AS ( PARTITION BY v1427 ORDER BY v1427 DESC ) ORDER BY v1427 , v1427 DESC ;
      

      output:
      mysqld: /sql/item.cc:6192: virtual bool Item_field::fix_fields(THD*, Item**): Assertion `context' failed.

      The full error log is in the attachment.

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              nobody Shihao Wen
              Votes:
              0 Vote for this issue
              Watchers:
              5 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.