Debian Codegraph @

mysql-test/suite/innodb/r/upgrade_partition.result

raw
1 #
2 # This test upgrades a partitioned table from 5.7 to 8.0.x and
3 # checks that INFORMATION_SCHEMA.INNODB_COLUMNS shows columns
4 # for all the partitions
5 #
6 # Stop the running the server
7 ######################################################################
8 # Unzip a 5.7 datadir with partitioned table, start the server using
9 # this directory
10 ######################################################################
11 ######################################################################
12 # Copy and unzip the datadir.
13 ######################################################################
14 # Restart the server against the unzipped datadir
15 # restart: --datadir=BUGDATADIR --innodb_page_size=16k
16 # Checks the contents of INFORMATION_SCHEMA.INNODB_COLUMNS
17 SELECT lower(t.name), lower(c.name) FROM
18 INFORMATION_SCHEMA.INNODB_COLUMNS c
19 JOIN INFORMATION_SCHEMA.INNODB_TABLES t
20 WHERE t.table_id=c.table_id AND t.name LIKE '%t1%'
21 ORDER BY t.name, c.name;
22 lower(t.name) lower(c.name)
23 partitions/t1#p#p0 a
24 partitions/t1#p#p0 b
25 partitions/t1#p#p1 a
26 partitions/t1#p#p1 b
27 # Cleanup
28 # Shutdown server
29 # Remove copied files
30 # Resart the server
31 # restart