00001 # 00002 # Tests that a value is put in the transaction log for rand() 00003 # 00004 00005 --disable_warnings 00006 DROP TABLE IF EXISTS t1; 00007 --enable_warnings 00008 00009 CREATE TABLE t1 ( 00010 id INT NOT NULL 00011 , PRIMARY KEY (id) 00012 ); 00013 00014 INSERT INTO t1 VALUES (1); 00015 INSERT INTO t1 SELECT RAND(100)*100 FROM t1; 00016 00017 DROP TABLE t1;