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

A connection can control RAND() in following connection

Details

    Description

      show variables like 'thread_cache_size';
      		 
      --connect foo,localhost,root
      		 
      set rand_seed1=0, rand_seed2=0;
      		 
      create table t1 (id int auto_increment key, b double);
      		 
      --disable_query_log
      		 
      --let $a=30
      		 
      --while ($a) {
      		 
        insert t1 (b) values (rand());
      		 
        --dec $a
      		 
      }
      		 
      --enable_query_log
      		 
      set rand_seed1=0, rand_seed2=0;
      		 
      --disconnect foo
      		 
      --connect bar,localhost,root
      		 
      set @a=rand();
      		 
      select * from t1 where b = @a;
      		 
      drop table t1;
      		 
      --disconnect bar

      this always prints

      id      b
      		 
      21      0.5129564902865854

      Attachments

        Activity

          Ascending order - Click to sort in descending order
          serg Sergei Golubchik created issue -
          serg Sergei Golubchik made changes -
          Field Original Value New Value
          Description {code:sql}
          show variables like 'thread_cache_size';
          --connect foo,localhost,root
          set rand_seed1=0, rand_seed2=0;
          create table t1 (id int auto_increment key, b double);
          --disable_query_log
          --let $a=30
          --while ($a) {
            insert t1 (b) values (rand());
            --dec $a;
          }
          --enable_query_log
          set rand_seed1=0, rand_seed2=0;
          --disconnect foo
          --connect bar,localhost,root
          set @a=rand();
          select * from t1 where b = @a;
          drop table t1;
          --disconnect bar
          {code}
          this always prints
          {noformat}
          id b
          21 0.5129564902865854
          {noformat}           		{code:sql}
          show variables like 'thread_cache_size';
          --connect foo,localhost,root
          set rand_seed1=0, rand_seed2=0;
          create table t1 (id int auto_increment key, b double);
          --disable_query_log
          --let $a=30
          --while ($a) {
            insert t1 (b) values (rand());
            --dec $a
          }
          --enable_query_log
          set rand_seed1=0, rand_seed2=0;
          --disconnect foo
          --connect bar,localhost,root
          set @a=rand();
          select * from t1 where b = @a;
          drop table t1;
          --disconnect bar
          {code}
          this always prints
          {noformat}
          id b
          21 0.5129564902865854
          {noformat}
          serg Sergei Golubchik made changes -
          Summary A connection can targetedly influence RAND() in following connection A connection can control RAND() in following connection
          serg Sergei Golubchik made changes -
          Status Open [ 1 ] In Progress [ 3 ]
          serg Sergei Golubchik made changes -
          Status In Progress [ 3 ] Stalled [ 10000 ]
          serg Sergei Golubchik made changes -
          Status Stalled [ 10000 ] In Testing [ 10301 ]
          serg Sergei Golubchik made changes -
          Comment [ {noformat}
          commit 8b0ebe31bb7 (HEAD, github/bb-10.4-serg)
          Author: Sergei Golubchik <serg@mariadb.org>
          Date: Sun Dec 31 23:30:48 2023 +0100

              MDEV-33148 A connection can control RAND() in following connection
          {noformat} ]
          serg Sergei Golubchik made changes -
          Status In Testing [ 10301 ] Stalled [ 10000 ]
          serg Sergei Golubchik made changes -
          Assignee Sergei Golubchik [ serg ] Alexander Barkov [ bar ]
          Status Stalled [ 10000 ] In Review [ 10002 ]
          bar Alexander Barkov made changes -
          Assignee Alexander Barkov [ bar ] Sergei Golubchik [ serg ]
          Status In Review [ 10002 ] Stalled [ 10000 ]
          serg Sergei Golubchik made changes -
          Status Stalled [ 10000 ] In Testing [ 10301 ]
          serg Sergei Golubchik made changes -
          Fix Version/s 10.4.33 [ 29516 ]
          Fix Version/s 10.5.24 [ 29517 ]
          Fix Version/s 10.6.17 [ 29518 ]
          Fix Version/s 10.11.7 [ 29519 ]
          Fix Version/s 11.0.5 [ 29520 ]
          Fix Version/s 11.1.4 [ 29024 ]
          Fix Version/s 11.2.3 [ 29521 ]
          Fix Version/s 10.4 [ 22408 ]
          Fix Version/s 10.5 [ 23123 ]
          Fix Version/s 10.6 [ 24028 ]
          Fix Version/s 10.11 [ 27614 ]
          Fix Version/s 11.0 [ 28320 ]
          Fix Version/s 11.1 [ 28549 ]
          Fix Version/s 11.2 [ 28603 ]
          Resolution Fixed [ 1 ]
          Status In Testing [ 10301 ] Closed [ 6 ]

          People

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