Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Duplicate
    • 10.11.5
    • N/A
    • Server
    • None

    Description

      INSERT INTO t1 VALUES ( 1 , 1 ) , ( 1 , 1 * 1 + 1 , x * 1 + 1 ) , ( 1 , 1 ) , ( 1 , 1 ) , ( 1 , 1 ) , ( 1 , 1 ) , ( 1 , 1 ) , ( 1 , 1 ) , ( 1 , 1 ) ;
      CREATE TABLE v0 ( v1 BIGINT UNIQUE CHECK ( v1 >= 0 AND v2 <= -32768 ) , v2 BIGINT ) ;
      SELECT v1 FROM v0 WHERE v1 = v1 AND v2 = 63422037.000000 28184457.000000 GROUP BY v1 , v1 HAVING ( v2 = v1 AND v1 IS NOT NULL ) ;
      SELECT * FROM v0 WHERE v1 NOT IN ( 10 + 49 , 0 >= ( SELECT v2 - 38 FROM v0 WHERE v1 IS NULL GROUP BY v2 , v2 HAVING ( CASE WHEN v2 IS NULL THEN v2 LIKE 'x' OR v1 = 'x' ELSE 127 END ) = -2147483648 ) ) GROUP BY v1 , v1 HAVING 86 = v1 ORDER BY v2 ;
      SELECT v1 , ( v1 ) , ( v1 ) , ( v1 ) FROM v0 ORDER BY v1 ;
      DROP TABLE t1 , t2 ;
      

      Attachments

        Issue Links

          Activity

            alice Alice Sherepa added a comment -

            Thanks! Fixed by 73ef86d commit ( MDEV-29731):

            Version: '10.4.32-MariaDB-debug-log'  
            mysqld: /sql/item.cc:5903: virtual bool Item_field::fix_fields(THD*, Item**): Assertion `context' failed.
            231031 12:22:26 [ERROR] mysqld got signal 6 ;
             
            Server version: 10.4.32-MariaDB-debug-log source revision: bf5c2512397b6bb44752528bff4315b06834cd7a
             
            sql/signal_handler.cc:238(handle_fatal_signal)[0x558cef781209]
            sigaction.c:0(__restore_rt)[0x7fa15028e420]
            /lib/x86_64-linux-gnu/libc.so.6(gsignal+0xcb)[0x7fa14fd7700b]
            /lib/x86_64-linux-gnu/libc.so.6(abort+0x12b)[0x7fa14fd56859]
            sql/item.cc:5911(Item_field::fix_fields(THD*, Item**))[0x558cef80407c]
            sql/item.h:966(Item::fix_fields_if_needed(THD*, Item**))[0x558ceed225ad]
            sql/item_func.cc:355(Item_func::fix_fields(THD*, Item**))[0x558cef8de3a0]
            sql/item.h:966(Item::fix_fields_if_needed(THD*, Item**))[0x558ceed225ad]
            sql/item.h:970(Item::fix_fields_if_needed_for_scalar(THD*, Item**))[0x558ceed225e7]
            sql/item.h:975(Item::fix_fields_if_needed_for_bool(THD*, Item**))[0x558ceee5a9e5]
            sql/item_cmpfunc.cc:4848(Item_cond::fix_fields(THD*, Item**))[0x558cef87bf26]
            sql/item.h:966(Item::fix_fields_if_needed(THD*, Item**))[0x558ceed225ad]
            sql/item_func.cc:355(Item_func::fix_fields(THD*, Item**))[0x558cef8de3a0]
            sql/item_cmpfunc.cc:3145(Item_func_case::fix_fields(THD*, Item**))[0x558cef86cdab]
            sql/item.h:966(Item::fix_fields_if_needed(THD*, Item**))[0x558ceed225ad]
            sql/item_func.cc:355(Item_func::fix_fields(THD*, Item**))[0x558cef8de3a0]
            sql/sql_lex.cc:10407(st_select_lex::pushdown_from_having_into_where(THD*, Item*))[0x558ceef826c8]
            sql/sql_select.cc:2139(JOIN::optimize_inner())[0x558cef07f727]
            sql/sql_select.cc:1711(JOIN::optimize())[0x558cef07aba7]
            sql/sql_lex.cc:4236(st_select_lex::optimize_unflattened_subqueries(bool))[0x558ceef535a0]
            sql/opt_subselect.cc:5603(JOIN::optimize_unflattened_subqueries())[0x558cef4c4b6f]
            sql/sql_select.cc:3165(JOIN::optimize_stage2())[0x558cef089db4]
            sql/sql_select.cc:2394(JOIN::optimize_inner())[0x558cef081e9c]
            sql/sql_select.cc:1711(JOIN::optimize())[0x558cef07aba7]
            sql/sql_select.cc:4812(mysql_select(THD*, TABLE_LIST*, unsigned int, List<Item>&, Item*, unsigned int, st_order*, st_order*, Item*, st_order*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*))[0x558cef09bb99]
            sql/sql_select.cc:442(handle_select(THD*, LEX*, select_result*, unsigned long))[0x558cef06c89e]
            sql/sql_parse.cc:6475(execute_sqlcom_select(THD*, TABLE_LIST*))[0x558ceefd86a8]
            sql/sql_parse.cc:3978(mysql_execute_command(THD*))[0x558ceefc5e1f]
            sql/sql_parse.cc:8012(mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool))[0x558ceefe1b83]
            sql/sql_parse.cc:1860(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool))[0x558ceefb7fa9]
            sql/sql_parse.cc:1378(do_command(THD*))[0x558ceefb4ad4]
            sql/sql_connect.cc:1420(do_handle_one_connection(CONNECT*))[0x558cef3c2709]
            sql/sql_connect.cc:1325(handle_one_connection)[0x558cef3c1fad]
            perfschema/pfs.cc:1871(pfs_spawn_thread)[0x558cf006c1c8]
            nptl/pthread_create.c:478(start_thread)[0x7fa150282609]
             
            Query (0x62b0000a1290): SELECT * FROM v0 WHERE v1 NOT IN ( 10 + 49 , 0 >= ( SELECT v2 - 38 FROM v0 WHERE v1 IS NULL GROUP BY v2 , v2 HAVING ( CASE WHEN v2 IS NULL THEN v2 LIKE 'x' OR v1 = 'x' ELSE 127 END ) = -2147483648 ) ) GROUP BY v1 , v1 HAVING 86 = v1 ORDER BY v2
            

            alice Alice Sherepa added a comment - Thanks! Fixed by 73ef86d commit ( MDEV-29731 ): Version: '10.4.32-MariaDB-debug-log' mysqld: /sql/item.cc:5903: virtual bool Item_field::fix_fields(THD*, Item**): Assertion `context' failed. 231031 12:22:26 [ERROR] mysqld got signal 6 ;   Server version: 10.4.32-MariaDB-debug-log source revision: bf5c2512397b6bb44752528bff4315b06834cd7a   sql/signal_handler.cc:238(handle_fatal_signal)[0x558cef781209] sigaction.c:0(__restore_rt)[0x7fa15028e420] /lib/x86_64-linux-gnu/libc.so.6(gsignal+0xcb)[0x7fa14fd7700b] /lib/x86_64-linux-gnu/libc.so.6(abort+0x12b)[0x7fa14fd56859] sql/item.cc:5911(Item_field::fix_fields(THD*, Item**))[0x558cef80407c] sql/item.h:966(Item::fix_fields_if_needed(THD*, Item**))[0x558ceed225ad] sql/item_func.cc:355(Item_func::fix_fields(THD*, Item**))[0x558cef8de3a0] sql/item.h:966(Item::fix_fields_if_needed(THD*, Item**))[0x558ceed225ad] sql/item.h:970(Item::fix_fields_if_needed_for_scalar(THD*, Item**))[0x558ceed225e7] sql/item.h:975(Item::fix_fields_if_needed_for_bool(THD*, Item**))[0x558ceee5a9e5] sql/item_cmpfunc.cc:4848(Item_cond::fix_fields(THD*, Item**))[0x558cef87bf26] sql/item.h:966(Item::fix_fields_if_needed(THD*, Item**))[0x558ceed225ad] sql/item_func.cc:355(Item_func::fix_fields(THD*, Item**))[0x558cef8de3a0] sql/item_cmpfunc.cc:3145(Item_func_case::fix_fields(THD*, Item**))[0x558cef86cdab] sql/item.h:966(Item::fix_fields_if_needed(THD*, Item**))[0x558ceed225ad] sql/item_func.cc:355(Item_func::fix_fields(THD*, Item**))[0x558cef8de3a0] sql/sql_lex.cc:10407(st_select_lex::pushdown_from_having_into_where(THD*, Item*))[0x558ceef826c8] sql/sql_select.cc:2139(JOIN::optimize_inner())[0x558cef07f727] sql/sql_select.cc:1711(JOIN::optimize())[0x558cef07aba7] sql/sql_lex.cc:4236(st_select_lex::optimize_unflattened_subqueries(bool))[0x558ceef535a0] sql/opt_subselect.cc:5603(JOIN::optimize_unflattened_subqueries())[0x558cef4c4b6f] sql/sql_select.cc:3165(JOIN::optimize_stage2())[0x558cef089db4] sql/sql_select.cc:2394(JOIN::optimize_inner())[0x558cef081e9c] sql/sql_select.cc:1711(JOIN::optimize())[0x558cef07aba7] sql/sql_select.cc:4812(mysql_select(THD*, TABLE_LIST*, unsigned int, List<Item>&, Item*, unsigned int, st_order*, st_order*, Item*, st_order*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*))[0x558cef09bb99] sql/sql_select.cc:442(handle_select(THD*, LEX*, select_result*, unsigned long))[0x558cef06c89e] sql/sql_parse.cc:6475(execute_sqlcom_select(THD*, TABLE_LIST*))[0x558ceefd86a8] sql/sql_parse.cc:3978(mysql_execute_command(THD*))[0x558ceefc5e1f] sql/sql_parse.cc:8012(mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool))[0x558ceefe1b83] sql/sql_parse.cc:1860(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool))[0x558ceefb7fa9] sql/sql_parse.cc:1378(do_command(THD*))[0x558ceefb4ad4] sql/sql_connect.cc:1420(do_handle_one_connection(CONNECT*))[0x558cef3c2709] sql/sql_connect.cc:1325(handle_one_connection)[0x558cef3c1fad] perfschema/pfs.cc:1871(pfs_spawn_thread)[0x558cf006c1c8] nptl/pthread_create.c:478(start_thread)[0x7fa150282609]   Query (0x62b0000a1290): SELECT * FROM v0 WHERE v1 NOT IN ( 10 + 49 , 0 >= ( SELECT v2 - 38 FROM v0 WHERE v1 IS NULL GROUP BY v2 , v2 HAVING ( CASE WHEN v2 IS NULL THEN v2 LIKE 'x' OR v1 = 'x' ELSE 127 END ) = -2147483648 ) ) GROUP BY v1 , v1 HAVING 86 = v1 ORDER BY v2

            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.