Details
-
Type:
Bug
-
Status: Closed
-
Priority:
Critical
-
Resolution: Fixed
-
Affects Version/s: None
-
Fix Version/s: None
-
Component/s: None
-
Labels:
Description
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
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.
Gliffy Diagrams
Attachments
Activity
- All
- Comments
- Work Log
- History
- Activity
- Transitions
Launchpad bug id: 784303