summaryrefslogtreecommitdiff
path: root/mysql-test/suite/funcs_1/t/processlist_priv_no_prot.test
blob: d6746d9225053f247d2b60ea0e1c4d350a740ed6 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
############ suite/funcs_1/t/processlist_priv_no_prot.test #############
#                                                                      #
# Testing of privileges around                                         #
#     SELECT ... PROCESSLIST/SHOW PROCESSLIST                          #
#                                                                      #
# The prepared statement variant of this test is                       #
# suite/funcs_1/t/b_processlist_priv_ps.test.                          #
#                                                                      #
# There is important documentation within                              #
#       suite/funcs_1/datadict/processlist_priv.inc                    #
#                                                                      #
# Creation:                                                            #
# 2007-08-14 mleich  Create this test as part of                       #
#                    WL#3982 Test information_schema.processlist       #
#                                                                      #
########################################################################

# One subtest is skipped because of
#    Bug#30395 strange results after REVOKE PROCESS ON *.* FROM ...
let $fixed_bug_30395= 0;

# This test does not make sense on the embedded server because processlist
# will be empty.
--source include/not_embedded.inc

# The file with expected results fits only to a run without
# ps-protocol/sp-protocol/cursor-protocol/view-protocol.
if (`SELECT $PS_PROTOCOL + $SP_PROTOCOL + $CURSOR_PROTOCOL
            + $VIEW_PROTOCOL > 0`)
{
   --skip Test requires: ps-protocol/sp-protocol/cursor-protocol/view-protocol disabled
}

--source suite/funcs_1/datadict/processlist_priv.inc