Execution of the test case for bug #21261 fails in the ps-protocol mode

[Igor Babaev]

With the current LP tree maria-5.3-mwl106 execution of the test case for bug #21261 from
mysql-test/t/view.test fails:

igor@sophia:~/maria/maria-5.3-mwl148-mwl106-bugs/mysql-test> ./mysql-test-run --ps-protocol view
Logging: ./mysql-test-run --ps-protocol view
vardir: /home/igor/maria/maria-5.3-mwl148-mwl106-bugs/mysql-test/var
Checking leftover processes...
Removing old var directory...
Creating var directory '/home/igor/maria/maria-5.3-mwl148-mwl106-bugs/mysql-test/var'...
Installing system database...
Checking supported features...
MariaDB Version 5.3.0
 - skipping ndbcluster
 - SSL connections supported
 - binaries are debug compiled
Collecting tests...
Using server port 55279

==============================================================================

TEST RESULT TIME (ms)
------------------------------------------------------------

worker[1] Using MTR_BUILD_THREAD 300, with reserved ports 16000..16019
main.view [ fail ]
        Test ended at 2011-05-17 15:12:00

CURRENT_TEST: main.view
mysqltest: At line 2803: query 'INSERT INTO v1 (x) VALUES (5)' failed: 1356: View 'bug21261DB.v1' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them

The result from queries just before the failure was:
< snip >
ERROR 42S02: Unknown table 'v2'
SHOW TABLES;
Tables_in_test
t1
CREATE VIEW v1 AS SELECT id FROM t1;
DROP VIEW t1,v1;
ERROR HY000: 'test.t1' is not VIEW
SHOW TABLES;
Tables_in_test
t1
DROP TABLE t1;
DROP VIEW IF EXISTS v1;
CREATE DATABASE bug21261DB;
USE bug21261DB;
CREATE TABLE t1 (x INT);
CREATE SQL SECURITY INVOKER VIEW v1 AS SELECT x FROM t1;
GRANT INSERT, UPDATE ON v1 TO 'user21261'@'localhost';
GRANT INSERT, UPDATE ON t1 TO 'user21261'@'localhost';
CREATE TABLE t2 (y INT);
GRANT SELECT ON t2 TO 'user21261'@'localhost';

More results from queries before failure can be found in /home/igor/maria/maria-5.3-mwl148-mwl106-bugs/mysql-test/var/log/view.log

Warnings from just before the error:
Error 1143 SELECT command denied to user 'user21261'@'localhost' for column 'x' in table 't1'
Error 1356 View 'bug21261DB.v1' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them

 - saving '/home/igor/maria/maria-5.3-mwl148-mwl106-bugs/mysql-test/var/log/main.view/' to '/home/igor/maria/maria-5.3-mwl148-mwl106-bugs/mysql-test/var/log/main.view/'
------------------------------------------------------------
The servers were restarted 0 times
Spent 0.000 of 9 seconds executing testcases

Failure: Failed 1/1 tests, 0.00% were successful.

Failing test(s): main.view

The log files in var/log may give you some hint of what went wrong.