Default page

Your IP: 216.73.216.124
Server IP: 50.28.103.30
Server: Linux host.jcukjv-lwsites.com 4.18.0-553.22.1.el8_10.x86_64 #1 SMP Tue Sep 24 05:16:59 EDT 2024 x86_64
Server Software: nginx/1.28.0
PHP Version: 8.3.12
Buat File | Buat Folder

Dir : ~/www/server/mysql/mysql-test/suite/innodb/r/

View File Name : innodb_tablespace_zip.result

SET default_storage_engine=InnoDB;
SET GLOBAL innodb_file_per_table=ON;
SET SESSION innodb_strict_mode = ON;
#
# CREATE TEMPORARY compressed TABLE with DATA DIRECTORY is rejected in strict mode.
#
CREATE TEMPORARY TABLE t1 (a int KEY, b text) engine=InnoDB row_format=compressed DATA DIRECTORY='MYSQL_TMP_DIR/alt_dir';
ERROR HY000: Table storage engine for 't1' doesn't have this option
SHOW WARNINGS;
Level	Code	Message
Warning	1478	InnoDB: DATA DIRECTORY cannot be used for TEMPORARY tables.
Error	1031	Table storage engine for 't1' doesn't have this option
SET SESSION innodb_strict_mode = OFF;
# DATA DIRECTORY is ignored in CREATE TEMPORARY compressed TABLE in non-strict mode.
CREATE TEMPORARY TABLE t1 (a int KEY, b text) engine=InnoDB row_format=compressed DATA DIRECTORY='MYSQL_TMP_DIR/alt_dir';
Warnings:
Warning	1478	InnoDB: DATA DIRECTORY cannot be used for TEMPORARY tables.
Warning	1618	<DATA DIRECTORY> option ignored
SHOW CREATE TABLE t1;
Table	Create Table
t1	CREATE TEMPORARY TABLE `t1` (
  `a` int(11) NOT NULL,
  `b` text,
  PRIMARY KEY (`a`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPRESSED
DROP TABLE t1;
#
# Cleanup
#