1 files changed, 40 insertions, 0 deletions
diff --git a/mysql-test/main/subselect_notembedded.result b/mysql-test/main/subselect_notembedded.result
new file mode 100644
index 00000000..23a35a28
--- /dev/null
+++ b/mysql-test/main/subselect_notembedded.result
@@ -0,0 +1,40 @@
+purge master logs before (select adddate(current_timestamp(), interval -4 day));
+ERROR 42000: PURGE..BEFORE does not support subqueries or stored functions
+purge master logs before adddate(current_timestamp(), interval -4 day);
+drop table if exists t1;
+create table t1(a int,b int,key(a),key(b));
+insert into t1(a,b) values (1,2),(2,1),(2,3),(3,4),(5,4),(5,5),
+(6,7),(7,4),(5,3);
+5
+4
+3
+2
+1
+26
+25
+24
+23
+22
+21
+20
+19
+18
+17
+16
+15
+14
+13
+12
+11
+10
+9
+8
+7
+6
+5
+4
+3
+2
+1
+drop table t1;
+End of 5.1 tests