1 files changed, 19 insertions, 0 deletions
diff --git a/mysql-test/t/limit.test b/mysql-test/t/limit.test
new file mode 100644
index 00000000000..ba075f73d37
--- /dev/null
+++ b/mysql-test/t/limit.test
@@ -0,0 +1,19 @@
+#
+# Test of update and delete with limit
+#
+
+drop table if exists t1;
+create table t1 (a int primary key, b int not null);
+insert into t1 () values ();		-- Testing default values
+insert into t1 values (1,1),(2,1),(3,1);
+update t1 set a=4 where b=1 limit 1;
+select * from t1;
+update t1 set b=2 where b=1 limit 2;
+select * from t1;
+update t1 set b=4 where b=1;
+select * from t1;
+delete from t1 where b=2 limit 1;
+select * from t1;
+delete from t1 limit 1;
+select * from t1;
+drop table t1;