diff options
| author | bell@sanja.is.com.ua <> | 2005-07-15 01:29:37 +0300 |
|---|---|---|
| committer | bell@sanja.is.com.ua <> | 2005-07-15 01:29:37 +0300 |
| commit | 0f6e1380dcd1004b466d6eb438c73a4eeb6f78ae (patch) | |
| tree | 60ae2f2793d7d674e0bf5ead3137364dc20fea83 /mysql-test/r | |
| parent | fbf35e0e373be204c1206e13c9614d456c3aa6c0 (diff) | |
| parent | a7834de02d80e9eda726d483a407bef895c656b3 (diff) | |
| download | mariadb-git-0f6e1380dcd1004b466d6eb438c73a4eeb6f78ae.tar.gz | |
Merge sanja.is.com.ua:/home/bell/mysql/bk/mysql-5.0
into sanja.is.com.ua:/home/bell/mysql/bk/work-bug4-5.0
Diffstat (limited to 'mysql-test/r')
| -rw-r--r-- | mysql-test/r/view.result | 14 |
1 files changed, 14 insertions, 0 deletions
diff --git a/mysql-test/r/view.result b/mysql-test/r/view.result index ef40a408932..684c4950acd 100644 --- a/mysql-test/r/view.result +++ b/mysql-test/r/view.result @@ -1977,3 +1977,17 @@ A B DROP VIEW v1; DROP TABLE t1; +CREATE TABLE t1 ( bug_table_seq INTEGER NOT NULL); +CREATE OR REPLACE VIEW v1 AS SELECT * from t1; +DROP PROCEDURE IF EXISTS p1; +Warnings: +Note 1305 PROCEDURE p1 does not exist +CREATE PROCEDURE p1 ( ) +BEGIN +DO (SELECT @next := IFNULL(max(bug_table_seq),0) + 1 FROM v1); +INSERT INTO t1 VALUES (1); +END // +CALL p1(); +DROP PROCEDURE p1; +DROP VIEW v1; +DROP TABLE t1; |