Debian Codegraph @

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

raw
1 # WL#9814 Implement INFORMATION_SCHEMA system views for
2 # FILES/PARTITIONS/REFERENTIAL_CONSTRAINTS.
3 #
4 # Test INFORMATION_SCHEMA.FILES with multiple data file per tablespace.
5 # --bootstrap --innodb-data-file-path=ibdata1:50M;ibdata2:50M:autoextend
6 # The SELECT asserts without the fix.
7 SELECT * FROM INFORMATION_SCHEMA.FILES WHERE TABLESPACE_NAME='innodb_system';
8 FILE_ID FILE_NAME FILE_TYPE TABLESPACE_NAME TABLE_CATALOG TABLE_SCHEMA TABLE_NAME LOGFILE_GROUP_NAME LOGFILE_GROUP_NUMBER ENGINE FULLTEXT_KEYS DELETED_ROWS UPDATE_COUNT FREE_EXTENTS TOTAL_EXTENTS EXTENT_SIZE INITIAL_SIZE MAXIMUM_SIZE AUTOEXTEND_SIZE CREATION_TIME LAST_UPDATE_TIME LAST_ACCESS_TIME RECOVER_TIME TRANSACTION_COUNTER VERSION ROW_FORMAT TABLE_ROWS AVG_ROW_LENGTH DATA_LENGTH MAX_DATA_LENGTH INDEX_LENGTH DATA_FREE CREATE_TIME UPDATE_TIME CHECK_TIME CHECKSUM STATUS EXTRA
9 0 ./ibdata1 TABLESPACE innodb_system NULL NULL NULL NULL InnoDB NULL NULL NULL 2 100 1048576 52428800 52428800 67108864 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL # NULL NULL NULL NULL NORMAL NULL
10 0 ./ibdata2 TABLESPACE innodb_system NULL NULL NULL NULL InnoDB NULL NULL NULL 2 100 1048576 52428800 NULL 67108864 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL # NULL NULL NULL NULL NORMAL NULL