Description:
On macOS, test main.partition_innodb_tablespace fails with
[ 50%] main.partition_innodb_tablespace [ fail ]
Test ended at 2024-07-02 07:21:27
CURRENT_TEST: main.partition_innodb_tablespace
WARNING: MYSQL_OPT_RECONNECT is deprecated and will be removed in a future version.
WARNING: MYSQL_OPT_RECONNECT is deprecated and will be removed in a future version.
WARNING: MYSQL_OPT_RECONNECT is deprecated and will be removed in a future version.
--- /Users/laurynas/vilniusdb/mysql-8.0.38/mysql-test/r/partition_innodb_tablespace.result 2024-07-01 21:20:33
+++ /Users/laurynas/vilniusdb/mysql-8.0.38/_build-debug/mysql-test/var/log/partition_innodb_tablespace.reject 2024-07-02 07:21:27
@@ -476,7 +476,7 @@
PRIMARY KEY (`a`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
/*!50100 PARTITION BY KEY (a)
-(PARTITION p0 DATA DIRECTORY = 'MYSQL_TMP_DIR/alternate_dir/data_part' ENGINE = InnoDB) */
+(PARTITION p0 DATA DIRECTORY = '/private/tmp/mtr-2guc/alternate_dir/data_part' ENGINE = InnoDB) */
SET @old_sql_quote_show_create=@@sql_quote_show_create;
SET @@sql_quote_show_create=0;
SHOW CREATE TABLE t1;
@@ -486,7 +486,7 @@
PRIMARY KEY (a)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
/*!50100 PARTITION BY KEY (a)
-(PARTITION p0 DATA DIRECTORY = 'MYSQL_TMP_DIR/alternate_dir/data_part' ENGINE = InnoDB) */
+(PARTITION p0 DATA DIRECTORY = '/private/tmp/mtr-2guc/alternate_dir/data_part' ENGINE = InnoDB) */
SET @@sql_quote_show_create=@old_sql_quote_show_create;
=== information_schema.innodb_tables and innodb_tablespaces ===
Table Name Tablespace Table Flags Columns Row Format Zip Size Space Type
@@ -503,7 +503,7 @@
mtr/global_suppressions Single DEFAULT 0 1 1 Dynamic MYSQLD_DATADIR/mtr/global_suppressions.ibd
mtr/test_ignored_global_suppressions Single DEFAULT 0 1 1 Dynamic MYSQLD_DATADIR/mtr/test_ignored_global_suppressions.ibd
mtr/test_suppressions Single DEFAULT 0 1 1 Dynamic MYSQLD_DATADIR/mtr/test_suppressions.ibd
-test/t1#p#p0 Single DEFAULT 0 1 1 Dynamic MYSQL_TMP_DIR/alternate_dir/data_part/test/t1#p#p0.ibd
+test/t1#p#p0 Single DEFAULT 0 1 1 Dynamic /private/tmp/mtr-2guc/alternate_dir/data_part/test/t1#p#p0.ibd
test/t_file_per_table_on Single DEFAULT 0 1 1 Dynamic MYSQLD_DATADIR/test/t_file_per_table_on.ibd
=== information_schema.files ===
Space_Name File_Type Engine Status Tablespace_Name Path
@@ -511,7 +511,7 @@
mtr/global_suppressions TABLESPACE InnoDB NORMAL mtr/global_suppressions MYSQLD_DATADIR/mtr/global_suppressions.ibd
mtr/test_ignored_global_suppressions TABLESPACE InnoDB NORMAL mtr/test_ignored_global_suppressions MYSQLD_DATADIR/mtr/test_ignored_global_suppressions.ibd
mtr/test_suppressions TABLESPACE InnoDB NORMAL mtr/test_suppressions MYSQLD_DATADIR/mtr/test_suppressions.ibd
-test/t1#p#p0 TABLESPACE InnoDB NORMAL test/t1#p#p0 MYSQL_TMP_DIR/alternate_dir/data_part/test/t1#p#p0.ibd
+test/t1#p#p0 TABLESPACE InnoDB NORMAL test/t1#p#p0 /private/tmp/mtr-2guc/alternate_dir/data_part/test/t1#p#p0.ibd
test/t_file_per_table_on TABLESPACE InnoDB NORMAL test/t_file_per_table_on MYSQLD_DATADIR/test/t_file_per_table_on.ibd
DROP TABLE t1;
SET @@global.innodb_file_per_table = ON;
mysqltest: Result content mismatch
How to repeat:
See above
Description: On macOS, test main.partition_innodb_tablespace fails with [ 50%] main.partition_innodb_tablespace [ fail ] Test ended at 2024-07-02 07:21:27 CURRENT_TEST: main.partition_innodb_tablespace WARNING: MYSQL_OPT_RECONNECT is deprecated and will be removed in a future version. WARNING: MYSQL_OPT_RECONNECT is deprecated and will be removed in a future version. WARNING: MYSQL_OPT_RECONNECT is deprecated and will be removed in a future version. --- /Users/laurynas/vilniusdb/mysql-8.0.38/mysql-test/r/partition_innodb_tablespace.result 2024-07-01 21:20:33 +++ /Users/laurynas/vilniusdb/mysql-8.0.38/_build-debug/mysql-test/var/log/partition_innodb_tablespace.reject 2024-07-02 07:21:27 @@ -476,7 +476,7 @@ PRIMARY KEY (`a`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci /*!50100 PARTITION BY KEY (a) -(PARTITION p0 DATA DIRECTORY = 'MYSQL_TMP_DIR/alternate_dir/data_part' ENGINE = InnoDB) */ +(PARTITION p0 DATA DIRECTORY = '/private/tmp/mtr-2guc/alternate_dir/data_part' ENGINE = InnoDB) */ SET @old_sql_quote_show_create=@@sql_quote_show_create; SET @@sql_quote_show_create=0; SHOW CREATE TABLE t1; @@ -486,7 +486,7 @@ PRIMARY KEY (a) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci /*!50100 PARTITION BY KEY (a) -(PARTITION p0 DATA DIRECTORY = 'MYSQL_TMP_DIR/alternate_dir/data_part' ENGINE = InnoDB) */ +(PARTITION p0 DATA DIRECTORY = '/private/tmp/mtr-2guc/alternate_dir/data_part' ENGINE = InnoDB) */ SET @@sql_quote_show_create=@old_sql_quote_show_create; === information_schema.innodb_tables and innodb_tablespaces === Table Name Tablespace Table Flags Columns Row Format Zip Size Space Type @@ -503,7 +503,7 @@ mtr/global_suppressions Single DEFAULT 0 1 1 Dynamic MYSQLD_DATADIR/mtr/global_suppressions.ibd mtr/test_ignored_global_suppressions Single DEFAULT 0 1 1 Dynamic MYSQLD_DATADIR/mtr/test_ignored_global_suppressions.ibd mtr/test_suppressions Single DEFAULT 0 1 1 Dynamic MYSQLD_DATADIR/mtr/test_suppressions.ibd -test/t1#p#p0 Single DEFAULT 0 1 1 Dynamic MYSQL_TMP_DIR/alternate_dir/data_part/test/t1#p#p0.ibd +test/t1#p#p0 Single DEFAULT 0 1 1 Dynamic /private/tmp/mtr-2guc/alternate_dir/data_part/test/t1#p#p0.ibd test/t_file_per_table_on Single DEFAULT 0 1 1 Dynamic MYSQLD_DATADIR/test/t_file_per_table_on.ibd === information_schema.files === Space_Name File_Type Engine Status Tablespace_Name Path @@ -511,7 +511,7 @@ mtr/global_suppressions TABLESPACE InnoDB NORMAL mtr/global_suppressions MYSQLD_DATADIR/mtr/global_suppressions.ibd mtr/test_ignored_global_suppressions TABLESPACE InnoDB NORMAL mtr/test_ignored_global_suppressions MYSQLD_DATADIR/mtr/test_ignored_global_suppressions.ibd mtr/test_suppressions TABLESPACE InnoDB NORMAL mtr/test_suppressions MYSQLD_DATADIR/mtr/test_suppressions.ibd -test/t1#p#p0 TABLESPACE InnoDB NORMAL test/t1#p#p0 MYSQL_TMP_DIR/alternate_dir/data_part/test/t1#p#p0.ibd +test/t1#p#p0 TABLESPACE InnoDB NORMAL test/t1#p#p0 /private/tmp/mtr-2guc/alternate_dir/data_part/test/t1#p#p0.ibd test/t_file_per_table_on TABLESPACE InnoDB NORMAL test/t_file_per_table_on MYSQLD_DATADIR/test/t_file_per_table_on.ibd DROP TABLE t1; SET @@global.innodb_file_per_table = ON; mysqltest: Result content mismatch How to repeat: See above