1purge master logs before (select adddate(current_timestamp(), interval -4 day)); 2ERROR 42000: PURGE..BEFORE does not support subqueries or stored functions 3purge master logs before adddate(current_timestamp(), interval -4 day); 4drop table if exists t1; 5create table t1(a int,b int,key(a),key(b)); 6insert into t1(a,b) values (1,2),(2,1),(2,3),(3,4),(5,4),(5,5), 7(6,7),(7,4),(5,3); 85 94 103 112 121 1326 1425 1524 1623 1722 1821 1920 2019 2118 2217 2316 2415 2514 2613 2712 2811 2910 309 318 327 336 345 354 363 372 381 39drop table t1; 40End of 5.1 tests 41