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

LP:737104 - Crash in DTCollation::set in 5.1-micro

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Critical
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: None
    • Labels:

      Description

      not repeatable with mysql-5.1

      backtrace:

      #4 <signal handler called>
      #5 0x081ba953 in DTCollation::set (this=0x38, dt=...) at item.h:73
      #6 0x082e80e7 in change_cond_ref_to_const (thd=0xa26c090, save_list=0xb6e41c24, and_father=0xb6b2c210, cond=0xb6b2be08, field=0xb6b2bef0, value=0xb6b2c098)
      at sql_select.cc:8499
      #7 0x082e7fa5 in change_cond_ref_to_const (thd=0xa26c090, save_list=0xb6e41c24, and_father=0xb6b2c210, cond=0xb6b2c210, field=0xb6b2bef0, value=0xb6b2c098)
      at sql_select.cc:8480
      #8 0x082e875e in propagate_cond_constants (thd=0xa26c090, save_list=0xb6e41c24, and_father=0xb6b2c210, cond=0xb6b2c130) at sql_select.cc:8623
      #9 0x082e84e8 in propagate_cond_constants (thd=0xa26c090, save_list=0x0, and_father=0xb6b2c210, cond=0xb6b2c210) at sql_select.cc:8590
      #10 0x082e969f in optimize_cond (join=0xb6b2c348, conds=0xb6b2c210, join_list=0xa26d53c, cond_value=0xb6b2d460) at sql_select.cc:9244
      #11 0x082d427c in JOIN::optimize (this=0xb6b2c348) at sql_select.cc:887
      #12 0x082d9ebd in mysql_select (thd=0xa26c090, rref_pointer_array=0xa26d570, tables=0xb6b2baf0, wild_num=1, fields=..., conds=0xb6b2c210, og_num=0,
      order=0x0, group=0x0, having=0x0, proc_param=0x0, select_options=2147764736, result=0xb6b2c330, unit=0xa26d208, select_lex=0xa26d478)
      at sql_select.cc:2530
      #13 0x082d292e in handle_select (thd=0xa26c090, lex=0xa26d1ac, result=0xb6b2c330, setup_tables_done_option=0) at sql_select.cc:269
      #14 0x0827aa6f in execute_sqlcom_select (thd=0xa26c090, all_tables=0xb6b2baf0) at sql_parse.cc:5129
      #15 0x08271926 in mysql_execute_command (thd=0xa26c090) at sql_parse.cc:2278
      #16 0x0827cc28 in mysql_parse (thd=0xa26c090,
      rawbuf=0xb6b2b930 "SELECT * FROM t1 WHERE f1 > f1 AND f1 <=> TIMESTAMPADD( HOUR , 9 , '2010-01-01 16:55:35' )", length=90, found_semicolon=0xb6e43210)
      at sql_parse.cc:6054
      #17 0x0826f580 in dispatch_command (command=COM_QUERY, thd=0xa26c090,
      packet=0xa2b1539 "SELECT * FROM t1 WHERE f1 > f1 AND f1 <=> TIMESTAMPADD( HOUR , 9 , '2010-01-01 16:55:35' ) ", packet_length=91) at sql_parse.cc:1249
      #18 0x0826e7b0 in do_command (thd=0xa26c090) at sql_parse.cc:889
      #19 0x0826caf5 in handle_one_connection (arg=0xa26c090) at sql_connect.cc:1136
      #20 0x00821919 in start_thread () from /lib/libpthread.so.0
      #21 0x0076acce in clone () from /lib/libc.so.6

      test case:

      CREATE TABLE t1 ( f1 timestamp) ;
      SELECT * FROM t1 WHERE f1 > f1 AND f1 <=> TIMESTAMPADD( HOUR , 9 , '2010-01-01 16:55:35' ) ;

        Gliffy Diagrams

          Attachments

            Activity

            Hide
            ratzpo Rasmus Johansson added a comment -

            Launchpad bug id: 737104

            Show
            ratzpo Rasmus Johansson added a comment - Launchpad bug id: 737104

              People

              • Assignee:
                serg Sergei Golubchik
                Reporter:
                philipstoev Philip Stoev
              • Votes:
                0 Vote for this issue
                Watchers:
                0 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: