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

Assertion `! is_set()' failed in Diagnostics_area::set_ok_status on CREATE TABLE with invalid default

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Cannot Reproduce
    • 10.2(EOL)
    • N/A
    • OTHER
    • None

    Description

      Note: EXP(710) normally produces ERROR 1690 (22003): DOUBLE value is out of range.

      CREATE OR REPLACE TABLE t1 ( col INT DEFAULT ( YEARWEEK( ( EXP( 710 ) ) ) ) )
      

      Stackt race from 10.2 commit 848d211c5c4df00b819cd84d7530cf7d29bb0524

      mysqld: /data/src/10.2-bug/sql/sql_error.cc:379: void Diagnostics_area::set_ok_status(ulonglong, ulonglong, const char*): Assertion `! is_set()' failed.
      160710 23:11:41 [ERROR] mysqld got signal 6 ;
       
      #6  0x00007f5962ca3266 in __assert_fail_base (fmt=0x7f5962ddc238 "%s%s%s:%u: %s%sAssertion `%s' failed.\n%n", assertion=assertion@entry=0x7f5965e02c7c "! is_set()", file=file@entry=0x7f5965e02bb0 "/data/src/10.2-bug/sql/sql_error.cc", line=line@entry=379, function=function@entry=0x7f5965e03080 <Diagnostics_area::set_ok_status(unsigned long long, unsigned long long, char const*)::__PRETTY_FUNCTION__> "void Diagnostics_area::set_ok_status(ulonglong, ulonglong, const char*)") at assert.c:92
      #7  0x00007f5962ca3312 in __GI___assert_fail (assertion=0x7f5965e02c7c "! is_set()", file=0x7f5965e02bb0 "/data/src/10.2-bug/sql/sql_error.cc", line=379, function=0x7f5965e03080 <Diagnostics_area::set_ok_status(unsigned long long, unsigned long long, char const*)::__PRETTY_FUNCTION__> "void Diagnostics_area::set_ok_status(ulonglong, ulonglong, const char*)") at assert.c:101
      #8  0x00007f59654b7b08 in Diagnostics_area::set_ok_status (this=0x7f59348bff88, affected_rows=0, last_insert_id=0, message=0x0) at /data/src/10.2-bug/sql/sql_error.cc:379
      #9  0x00007f5965474057 in my_ok (thd=0x7f59348bb070, affected_rows=0, id=0, message=0x0) at /data/src/10.2-bug/sql/sql_class.h:4274
      #10 0x00007f59654e2a27 in mysql_execute_command (thd=0x7f59348bb070) at /data/src/10.2-bug/sql/sql_parse.cc:3855
      #11 0x00007f59654eeed1 in mysql_parse (thd=0x7f59348bb070, rawbuf=0x7f5934912088 "CREATE OR REPLACE TABLE t1 ( col INT DEFAULT ( YEARWEEK( ( EXP( 710 ) ) ) ) )", length=77, parser_state=0x7f5966437e30, is_com_multi=false, is_next_command=false) at /data/src/10.2-bug/sql/sql_parse.cc:7742
      #12 0x00007f59654dd33d in dispatch_command (command=COM_QUERY, thd=0x7f59348bb070, packet=0x7f59348dc071 "CREATE OR REPLACE TABLE t1 ( col INT DEFAULT ( YEARWEEK( ( EXP( 710 ) ) ) ) )", packet_length=77, is_com_multi=false, is_next_command=false) at /data/src/10.2-bug/sql/sql_parse.cc:1790
      #13 0x00007f59654dbda9 in do_command (thd=0x7f59348bb070) at /data/src/10.2-bug/sql/sql_parse.cc:1353
      #14 0x00007f59656141a2 in do_handle_one_connection (connect=0x7f596245cad0) at /data/src/10.2-bug/sql/sql_connect.cc:1354
      #15 0x00007f5965613f2f in handle_one_connection (arg=0x7f596245cad0) at /data/src/10.2-bug/sql/sql_connect.cc:1260
      #16 0x00007f5964ba50a4 in start_thread (arg=0x7f5966439300) at pthread_create.c:309
      #17 0x00007f5962d5d87d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:111
      

      Attachments

        Issue Links

          Activity

            People

              serg Sergei Golubchik
              elenst Elena Stepanova
              Votes:
              0 Vote for this issue
              Watchers:
              2 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.