Bug #90345 | MySQL 8.0 | ||
---|---|---|---|
Submitted: | 9 Apr 2018 6:48 | Modified: | 9 Apr 2018 9:05 |
Reporter: | Hanzhi W | Email Updates: | |
Status: | Can't repeat | Impact on me: | |
Category: | MySQL Server: DDL | Severity: | S3 (Non-critical) |
Version: | 8.0.4 | OS: | Windows |
Assigned to: | CPU Architecture: | x86 | |
Tags: | innodb, mysql-test |
[9 Apr 2018 6:48]
Hanzhi W
[9 Apr 2018 8:11]
MySQL Verification Team
Not repeatable with most recent source server on Linux: miguel@tikal:~/dbs $ ./80c Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 9 Server version: 8.0.12 Source distribution 2018-APR-04 Copyright (c) 2000, 2018, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql 8.0 > USE test Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Database changed mysql 8.0 > CREATE TABLE t_cdefgh10abcdefgh20abcdefgh30abcdefgh40abcdefgh50abcdefgh60abcd -> (a INT, b INT) ENGINE=INNODB -> PARTITION BY RANGE (a) -> SUBPARTITION BY HASH(b) -> ( -> PARTITION p1_defgh10abcdefgh20abcdefgh30abcdefgh40abcdefgh50abcdefgh60abcd -> VALUES LESS THAN (100) -> ( -> SUBPARTITION -> p1s1_fgh10abcdefgh20abcdefgh30abcdefgh40abcdefgh50abcdefgh60abcd, -> SUBPARTITION -> p1s2_fgh10abcdefgh20abcdefgh30abcdefgh40abcdefgh50abcdefgh60abcd -> ), -> PARTITION p2_defgh10abcdefgh20abcdefgh30abcdefgh40abcdefgh50abcdefgh60abcd -> VALUES LESS THAN (200) -> ( -> SUBPARTITION -> p2s1_fgh10abcdefgh20abcdefgh30abcdefgh40abcdefgh50abcdefgh60abcd, -> SUBPARTITION -> p2s2_fgh10abcdefgh20abcdefgh30abcdefgh40abcdefgh50abcdefgh60abcd -> ) -> ); Query OK, 0 rows affected (1,23 sec) mysql 8.0 >
[9 Apr 2018 8:18]
MySQL Verification Team
On Windows: mysql 8.0 > CREATE TABLE t_cdefgh10abcdefgh20abcdefgh30abcdefgh40abcdefgh50abcdefgh60abcd -> (a INT, b INT) ENGINE=INNODB -> PARTITION BY RANGE (a) -> SUBPARTITION BY HASH(b) -> ( -> PARTITION p1_defgh10abcdefgh20abcdefgh30abcdefgh40abcdefgh50abcdefgh60abcd -> VALUES LESS THAN (100) -> ( -> SUBPARTITION -> p1s1_fgh10abcdefgh20abcdefgh30abcdefgh40abcdefgh50abcdefgh60abcd, -> SUBPARTITION -> p1s2_fgh10abcdefgh20abcdefgh30abcdefgh40abcdefgh50abcdefgh60abcd -> ), -> PARTITION p2_defgh10abcdefgh20abcdefgh30abcdefgh40abcdefgh50abcdefgh60abcd -> VALUES LESS THAN (200) -> ( -> SUBPARTITION -> p2s1_fgh10abcdefgh20abcdefgh30abcdefgh40abcdefgh50abcdefgh60abcd, -> SUBPARTITION -> p2s2_fgh10abcdefgh20abcdefgh30abcdefgh40abcdefgh50abcdefgh60abcd -> ) -> ); Query OK, 0 rows affected (0.17 sec) mysql 8.0 > SHOW VARIABLES LIKE "%version%"; +-------------------------+---------------------------------+ | Variable_name | Value | +-------------------------+---------------------------------+ | innodb_version | 8.0.5 | | protocol_version | 10 | | slave_type_conversions | | | tls_version | TLSv1,TLSv1.1 | | version | 8.0.5-log | | version_comment | Source distribution 2018-JAN-07 | | version_compile_machine | x86_64 | | version_compile_os | Win64 | +-------------------------+---------------------------------+ 8 rows in set (0.01 sec) mysql 8.0 >
[9 Apr 2018 8:56]
MySQL Verification Team
Not repeatable with 8.0.4 released version, also: C:\tmp\mysql-8.0.4-rc-winx64>bin\mysql -uroot -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 8 Server version: 8.0.4-rc-log MySQL Community Server (GPL) Copyright (c) 2000, 2018, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql> use test Database changed mysql> CREATE TABLE t_cdefgh10abcdefgh20abcdefgh30abcdefgh40abcdefgh50abcdefgh60abcd -> (a INT, b INT) ENGINE=INNODB -> PARTITION BY RANGE (a) -> SUBPARTITION BY HASH(b) -> ( -> PARTITION p1_defgh10abcdefgh20abcdefgh30abcdefgh40abcdefgh50abcdefgh60abcd -> VALUES LESS THAN (100) -> ( -> SUBPARTITION -> p1s1_fgh10abcdefgh20abcdefgh30abcdefgh40abcdefgh50abcdefgh60abcd, -> SUBPARTITION -> p1s2_fgh10abcdefgh20abcdefgh30abcdefgh40abcdefgh50abcdefgh60abcd -> ), -> PARTITION p2_defgh10abcdefgh20abcdefgh30abcdefgh40abcdefgh50abcdefgh60abcd -> VALUES LESS THAN (200) -> ( -> SUBPARTITION -> p2s1_fgh10abcdefgh20abcdefgh30abcdefgh40abcdefgh50abcdefgh60abcd, -> SUBPARTITION -> p2s2_fgh10abcdefgh20abcdefgh30abcdefgh40abcdefgh50abcdefgh60abcd -> ) -> ); Query OK, 0 rows affected (0.13 sec) mysql>
[9 Apr 2018 9:05]
MySQL Verification Team
Thank you for the bug report. miguel@tikal:~/dbs/8.0/mysql-test $ ./mtr innodb_stats_long_names Logging: ./mtr innodb_stats_long_names 2018-04-09T08:57:42.732690Z 0 [Warning] [MY-010139] [Server] Changed limits: max_open_files: 1024 (requested 8161) 2018-04-09T08:57:42.732730Z 0 [Warning] [MY-010142] [Server] Changed limits: table_open_cache: 431 (requested 4000) 2018-04-09T08:57:42.732880Z 0 [System] [MY-010116] [Server] /home/miguel/dbs/8.0/bin/mysqld (mysqld 8.0.12) starting as process 1986 MySQL Version 8.0.12 Checking supported features... - SSL connections supported Collecting tests... Removing old var directory... Creating var directory '/home/miguel/dbs/8.0/mysql-test/var'... Installing system database... Using parallel: 1 ============================================================================== TEST RESULT TIME (ms) or COMMENT -------------------------------------------------------------------------- worker[1] Using MTR_BUILD_THREAD 300, with reserved ports 13000..13009 innodb.innodb_stats_long_names [ pass ] 2853 -------------------------------------------------------------------------- The servers were restarted 0 times Spent 2.853 of 387 seconds executing testcases Completed: All 1 tests were successful.