Debian Codegraph @

mysql-test/suite/information_schema/r/upgrade_cs.result

raw
1 ########################################################################
2 # This test scripts covers meta data related aspects of upgrade
3 # after 8.0.
4 ########################################################################
5 #-----------------------------------------------------------------------
6 # WL#10895: INFORMATION_SCHEMA views for Roles
7 # Test case to verify that new I_S tables introduced by this WL
8 # are present after upgrade.
9 #-----------------------------------------------------------------------
10 # Copy the remote tablespace & DB zip files from suite location to working location.
11 # Check that the file exists in the working folder.
12 # Set different paths for --datadir
13 # Check that the file exits after unzip
14 # Stop / restart DB server which was created by MTR default
15 # restart: --datadir=MYSQLD_DATADIR1 --log-error=MYSQLD_LOG
16 SELECT COUNT(*) < 0 FROM INFORMATION_SCHEMA.APPLICABLE_ROLES;
17 COUNT(*) < 0
18 0
19 SELECT COUNT(*) < 0 FROM INFORMATION_SCHEMA.ADMINISTRABLE_ROLE_AUTHORIZATIONS;
20 COUNT(*) < 0
21 0
22 SELECT COUNT(*) < 0 FROM INFORMATION_SCHEMA.ENABLED_ROLES;
23 COUNT(*) < 0
24 0
25 SELECT COUNT(*) < 0 FROM INFORMATION_SCHEMA.ROLE_TABLE_GRANTS;
26 COUNT(*) < 0
27 0
28 SELECT COUNT(*) < 0 FROM INFORMATION_SCHEMA.ROLE_COLUMN_GRANTS;
29 COUNT(*) < 0
30 0
31 SELECT COUNT(*) < 0 FROM INFORMATION_SCHEMA.ROLE_ROUTINE_GRANTS;
32 COUNT(*) < 0
33 0
34 # Stop the server and do cleanup
35 # Remove copied files
36 # Restart the server with default options.
37 # restart:
38 #
39 # WL#10895 Upgrade from 5.7->8.0 should show I_S tables.
40 #
41 #
42 # Copy zip files from suite location to working location.
43 # Check that the file exists in the working folder.
44 # Unzip the zip file.
45 # Set different paths for --datadir
46 # Stop DB server which was created by MTR default
47 # Start the DB server to do upgrade.
48 SELECT COUNT(*) < 0 FROM INFORMATION_SCHEMA.APPLICABLE_ROLES;
49 COUNT(*) < 0
50 0
51 SELECT COUNT(*) < 0 FROM INFORMATION_SCHEMA.ADMINISTRABLE_ROLE_AUTHORIZATIONS;
52 COUNT(*) < 0
53 0
54 SELECT COUNT(*) < 0 FROM INFORMATION_SCHEMA.ENABLED_ROLES;
55 COUNT(*) < 0
56 0
57 SELECT COUNT(*) < 0 FROM INFORMATION_SCHEMA.ROLE_TABLE_GRANTS;
58 COUNT(*) < 0
59 0
60 SELECT COUNT(*) < 0 FROM INFORMATION_SCHEMA.ROLE_COLUMN_GRANTS;
61 COUNT(*) < 0
62 0
63 SELECT COUNT(*) < 0 FROM INFORMATION_SCHEMA.ROLE_ROUTINE_GRANTS;
64 COUNT(*) < 0
65 0
66 # Stop the server
67 # Remove copied files
68 # Restart the server with default options.
69 # restart: