[MDEV-2698] LP:784303 - Execution of the test case for bug #21261 fails in the ps-protocol mode Created: 2011-05-17  Updated: 2015-02-02  Resolved: 2012-10-04

Status: Closed
Project: MariaDB Server
Component/s: None
Affects Version/s: None
Fix Version/s: None

Type: Bug Priority: Critical
Reporter: Igor Babaev Assignee: Oleksandr Byelkin
Resolution: Fixed Votes: 0
Labels: Launchpad

Attachments: XML File LPexportBug784303.xml    

 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.



 Comments   
Comment by Rasmus Johansson (Inactive) [ 2011-07-29 ]

Launchpad bug id: 784303

Generated at Thu Feb 08 06:43:36 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.