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

main.thread_id_overflow fails in ps-protocol

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 10.3(EOL)
    • 10.3.6
    • Tests
    • None

    Description

      On Linux ./mtr --ps-protocol thread_id_overflow gives:

      main.thread_id_overflow                  [ fail ]
              Test ended at 2018-03-29 19:47:18
       
      CURRENT_TEST: main.thread_id_overflow
      --- /home/svoj/devel/maria/mariadb/mysql-test/r/thread_id_overflow.result	2018-03-29 19:44:00.133283709 +0400
      +++ /home/svoj/devel/maria/mariadb/mysql-test/r/thread_id_overflow.reject	2018-03-29 19:47:18.017905411 +0400
      @@ -9,7 +9,7 @@
       connection con3;
       SELECT CONNECTION_ID();
       CONNECTION_ID()
      -4294967294
      +-2
       connection default;
       SET GLOBAL DEBUG_DBUG=@orig_debug;
       connect con4, localhost,root;
      

      There seem to be no problems until the value gets to CONNECTION_ID(). This patch helps, but I fail to understand why original code works in normal mode:

      diff --git a/sql/item_func.h b/sql/item_func.h
      index f33b936..6be2a32 100644
      --- a/sql/item_func.h
      +++ b/sql/item_func.h
      @@ -849,7 +849,7 @@ class Item_func_connection_id :public Item_long_func
         longlong value;
       
       public:
      -  Item_func_connection_id(THD *thd): Item_long_func(thd) {}
      +  Item_func_connection_id(THD *thd): Item_long_func(thd) { unsigned_flag= 1; }
         const char *func_name() const { return "connection_id"; }
         void fix_length_and_dec();
         bool fix_fields(THD *thd, Item **ref);
      

      Attachments

        Activity

          People

            serg Sergei Golubchik
            svoj Sergey Vojtovich
            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.