diff options
author | unknown <serg@serg.mylan> | 2004-07-22 00:57:31 +0200 |
---|---|---|
committer | unknown <serg@serg.mylan> | 2004-07-22 00:57:31 +0200 |
commit | 78b5893f2bdfa3ef9bb6acb459ea7eae56ca98d5 (patch) | |
tree | 985b3ebdce3b1e8c60a8b31f8dcfa494df083a44 /mysql-test | |
parent | 1d29e6b0d46abd0416a151734e3b95171a9666a4 (diff) | |
download | mariadb-git-78b5893f2bdfa3ef9bb6acb459ea7eae56ca98d5.tar.gz |
after merge fixes 2
Diffstat (limited to 'mysql-test')
-rw-r--r-- | mysql-test/r/variables.result | 2 | ||||
-rw-r--r-- | mysql-test/r/view.result | 4 | ||||
-rw-r--r-- | mysql-test/t/view.test | 40 |
3 files changed, 23 insertions, 23 deletions
diff --git a/mysql-test/r/variables.result b/mysql-test/r/variables.result index 37e848ad0d9..498e1634dc4 100644 --- a/mysql-test/r/variables.result +++ b/mysql-test/r/variables.result @@ -364,7 +364,7 @@ set sql_log_bin=1; set sql_log_off=1; set sql_log_update=1; Warnings: -Note 1313 The update log is deprecated and replaced by the binary log; SET SQL_LOG_UPDATE has been ignored +Note 1314 The update log is deprecated and replaced by the binary log; SET SQL_LOG_UPDATE has been ignored set sql_low_priority_updates=1; set sql_max_join_size=200; select @@sql_max_join_size,@@max_join_size; diff --git a/mysql-test/r/view.result b/mysql-test/r/view.result index 00ddc497b54..1cd80b857ab 100644 --- a/mysql-test/r/view.result +++ b/mysql-test/r/view.result @@ -761,7 +761,7 @@ set sql_updatable_view_key=LIMIT1; update v1 set x=x+1; update v2 set x=x+1; Warnings: -Note 1353 View being update does not have complete key of underlying table in it +Note 1354 View being update does not have complete key of underlying table in it update v1 set x=x+1 limit 1; update v2 set x=x+1 limit 1; ERROR HY000: The target table v2 of the UPDATE is not updatable @@ -769,7 +769,7 @@ set sql_updatable_view_key=NO; update v1 set x=x+1 limit 1; update v2 set x=x+1 limit 1; Warnings: -Note 1353 View being update does not have complete key of underlying table in it +Note 1354 View being update does not have complete key of underlying table in it set sql_updatable_view_key=DEFAULT; select * from t1; a b c diff --git a/mysql-test/t/view.test b/mysql-test/t/view.test index dc8ea065902..b6ea504bc2e 100644 --- a/mysql-test/t/view.test +++ b/mysql-test/t/view.test @@ -15,7 +15,7 @@ create view v1 (c,d) as select a,b from t1; create temporary table t1 (a int, b int); #view on temporary table --- error 1350 +-- error 1351 create view v1 (c) as select b+1 from t1; drop table t1; @@ -23,7 +23,7 @@ create table t1 (a int, b int); insert into t1 values (1,2), (1,3), (2,4), (2,5), (3,10); #view with variable --- error 1349 +-- error 1350 create view v1 (c,d) as select a,b+@@global.max_user_connections from t1; # simple view @@ -38,7 +38,7 @@ select * from t1; select c from v1; show create table v1; show create view v1; --- error 1345 +-- error 1346 show create view t1; drop table t1; @@ -131,7 +131,7 @@ show grants for test@localhost; drop view v100; #try to drop table with DROP VIEW --- error 1345 +-- error 1346 drop view t1; #try to drop VIEW with DROP TABLE @@ -265,21 +265,21 @@ select c from mysqltest.v4; show columns from mysqltest.v1; show columns from mysqltest.v2; # but explain/show do not --- error 1343 +-- error 1344 explain select c from mysqltest.v1; --- error 1343 +-- error 1344 show create table mysqltest.v1; --- error 1343 +-- error 1344 explain select c from mysqltest.v2; --- error 1343 +-- error 1344 show create table mysqltest.v2; --- error 1343 +-- error 1344 explain select c from mysqltest.v3; --- error 1343 +-- error 1344 show create table mysqltest.v3; --- error 1343 +-- error 1344 explain select c from mysqltest.v4; --- error 1343 +-- error 1344 show create table mysqltest.v4; # allow to see one of underlaing table @@ -292,13 +292,13 @@ show create table mysqltest.v1; explain select c from mysqltest.v2; show create table mysqltest.v2; # but other EXPLAINs do not --- error 1343 +-- error 1344 explain select c from mysqltest.v3; --- error 1343 +-- error 1344 show create table mysqltest.v3; --- error 1343 +-- error 1344 explain select c from mysqltest.v4; --- error 1343 +-- error 1344 show create table mysqltest.v4; # allow to see any view in mysqltest database @@ -445,7 +445,7 @@ insert into t1 values (10,2), (20,3), (30,4), (40,5), (50,10); create view v1 (a,c) as select a, b+1 from t1; create algorithm=temptable view v2 (a,c) as select a, b+1 from t1; # try to update expression --- error 1346 +-- error 1347 update v1 set c=a+c; # try to update VIEW with forced TEMPORARY TABLE algorithm -- error 1288 @@ -467,7 +467,7 @@ insert into t2 values (10), (20); create view v1 (a,c) as select a, b+1 from t1; create algorithm=temptable view v2 (a,c) as select a, b+1 from t1; # try to update expression --- error 1346 +-- error 1347 update t2,v1 set v1.c=v1.a+v1.c where t2.x=v1.a; # try to update VIEW with forced TEMPORARY TABLE algorithm -- error 1288 @@ -888,10 +888,10 @@ create table t1 (col1 char(5),col2 char(5)); create view v1 as select * from t1; drop table t1; create table t1 (col1 char(5),newcol2 char(5)); --- error 1354 +-- error 1355 insert into v1 values('a','aa'); drop table t1; --- error 1354 +-- error 1355 select * from v1; drop view v1; |