| 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 |