diff options
| author | bell@sanja.is.com.ua <> | 2005-07-15 01:22:14 +0300 |
|---|---|---|
| committer | bell@sanja.is.com.ua <> | 2005-07-15 01:22:14 +0300 |
| commit | a7834de02d80e9eda726d483a407bef895c656b3 (patch) | |
| tree | 591c810947dad041aaea7cabdc54f6c1170b7ccf /mysql-test/r/view.result | |
| parent | a25c4ead106bf36d0c9a5f18f9477bf238bcc05d (diff) | |
| download | mariadb-git-a7834de02d80e9eda726d483a407bef895c656b3.tar.gz | |
take into account table lock mode when opening table:
try to find most suitable table, to avouid pickup table with too low locking mode or occupy table with write mode for select when it will be need for update later
(BUG#9597)
Diffstat (limited to 'mysql-test/r/view.result')
| -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; |