[MDEV-11816] Disallow CREATE TEMPORARY TABLE…ROW_FORMAT=COMPRESSED Created: 2017-01-16  Updated: 2023-11-06  Resolved: 2017-01-18

Status: Closed
Project: MariaDB Server
Component/s: Storage Engine - InnoDB
Affects Version/s: 10.2.3
Fix Version/s: 10.2.4

Type: Bug Priority: Major
Reporter: Marko Mäkelä Assignee: Marko Mäkelä
Resolution: Fixed Votes: 0
Labels: None

Issue Links:
Relates
relates to MDEV-11824 Allow ROW_FORMAT=DYNAMIC in the InnoD... Closed
relates to MDEV-11202 InnoDB 10.1 -> 10.2 migration does no... Closed
relates to MDEV-11585 Hard-code the shared InnoDB temporary... Closed
relates to MDEV-11623 MariaDB 10.1 fails to start datadir c... Closed
relates to MDEV-14240 sync0rw.ic:285 Assertion `!rw_lock_ow... Closed
relates to MDEV-29980 CREATE TEMPORARY TABLE ... LIKE does ... Open
Sprint: 10.1.21

 Description   

MySQL 5.7 allows temporary tables to be created in ROW_FORMAT=COMPRESSED.
The usefulness of this is questionable. In MySQL 8.0, WL#7899 prevents the creation of such compressed tables, so that all InnoDB temporary tables will be located inside the predefined InnoDB temporary tablespace.

 Comments   
Comment by Marko Mäkelä [ 2017-01-17 ]

bb-10.2-mdev-11816
(this contains also some other work on top of 10.2 in the preceding commits)

Comment by Jan Lindström (Inactive) [ 2017-01-17 ]

ok to push.

Comment by Marko Mäkelä [ 2017-01-17 ]

repushed bb-10.2-mdev-11816, this time with the test files (and with the rebased/revised removal of MYSQL_ENCRYPTION, MYSQL_COMPRESSION, MYSQL_TABLESPACES)

Generated at Thu Feb 08 07:52:53 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.