← Back to branch summary

~vkolesnikov/pbxt/pbxt-preload-test-bug

« back to all changes in this revision

Viewing changes to pbxt/mysql-test-update/mysql-test/r/skip_grants.result

  • Committer: paul-mccullagh
  • Date: 2008-03-10 11:36:34 UTC
  • Revision ID: paul-mccullagh-417ebf175a9c8ee6e5b3777d9e2398e1fb197391
Implemented full durability

Show diffs side-by-side

added added

removed removed

Lines of Context:
pbxt/mysql-test-update/mysql-test/r/skip_grants.result
51
51
Warnings:
52
52
Note    1449    There is no 'a'@'' registered
53
53
SHOW CREATE VIEW v3;
54
 
View    Create View
55
 
v3      CREATE ALGORITHM=UNDEFINED DEFINER=`a`@`` SQL SECURITY DEFINER VIEW `v3` AS select `t1`.`c` AS `c` from `t1`
 
54
View    Create View     character_set_client    collation_connection
 
55
v3      CREATE ALGORITHM=UNDEFINED DEFINER=`a`@`` SQL SECURITY DEFINER VIEW `v3` AS select `test`.`t1`.`c` AS `c` from `t1`     latin1  latin1_swedish_ci
56
56
Warnings:
57
 
Note    1449    There is no 'a'@'' registered
 
57
Warning 1356    View 'test.v3' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them
58
58
SHOW CREATE PROCEDURE p3;
59
 
Procedure       sql_mode        Create Procedure
 
59
Procedure       sql_mode        Create Procedure        character_set_client    collation_connection    Database Collation
60
60
p3              CREATE DEFINER=`a`@`` PROCEDURE `p3`()
61
 
SELECT 3
 
61
SELECT 3        latin1  latin1_swedish_ci       latin1_swedish_ci
62
62
SHOW CREATE FUNCTION f3;
63
 
Function        sql_mode        Create Function
 
63
Function        sql_mode        Create Function character_set_client    collation_connection    Database Collation
64
64
f3              CREATE DEFINER=`a`@`` FUNCTION `f3`() RETURNS int(11)
65
 
RETURN 3
 
65
RETURN 3        latin1  latin1_swedish_ci       latin1_swedish_ci
66
66
DROP TRIGGER t1_bi;
67
67
DROP TRIGGER ti_ai;
68
68
DROP TRIGGER ti_bu;