summaryrefslogtreecommitdiff
path: root/mysql-test/t/truncate.test
diff options
context:
space:
mode:
authorunknown <serg@janus.mylan>2007-04-17 12:32:01 +0200
committerunknown <serg@janus.mylan>2007-04-17 12:32:01 +0200
commit5234f5adb786718c90bc96280ad598467da69e69 (patch)
treefc97bc2772b01ff59627c791f4abb18dfc30b443 /mysql-test/t/truncate.test
parentc2951b70d6578e6e713e33a8ba023917e59c06f0 (diff)
downloadmariadb-git-5234f5adb786718c90bc96280ad598467da69e69.tar.gz
reverted the fix for Bug#5507
Diffstat (limited to 'mysql-test/t/truncate.test')
-rw-r--r--mysql-test/t/truncate.test31
1 files changed, 8 insertions, 23 deletions
diff --git a/mysql-test/t/truncate.test b/mysql-test/t/truncate.test
index c52260124cb..ba5364bd324 100644
--- a/mysql-test/t/truncate.test
+++ b/mysql-test/t/truncate.test
@@ -54,33 +54,18 @@ drop table t1;
# End of 4.1 tests
# Test for Bug#5507 "TRUNCATE should work with views"
+#
+# when it'll be fixed, the error should become 1347
+# (test.v1' is not BASE TABLE)
+#
create table t1 (s1 int);
-
insert into t1 (s1) values (1), (2), (3), (4), (5);
create view v1 as select * from t1;
+--error 1146
truncate table v1;
-select count(*) from t1;
-
-insert into t1 (s1) values (1), (2), (3), (4), (5);
-create view v2 as select * from t1 where s1 > 3;
-truncate table v2;
-select * from t1;
-select * from v2;
-delete from t1;
-
-# The following should fail
-create table t2 (s1 int, s2 int);
-create view v3 as select a.s1, b.s2 from t1 a join t2 b on a.s1 = b.s1 where a.s1 > 3;
---error 1395
-truncate table v3;
-
-# The following should fail
-create view v4 as select * from t1 limit 1,1;
---error 1288
-truncate table v4;
-
-drop view v1, v2, v3, v4;
-drop table t1, t2;
+drop view v1;
+drop table t1;
# End of 5.0 tests
+