text: #
  # This tests the use of large blobs in InnoDB.
  #
  call mtr.add_suppression("InnoDB: Warning: a long semaphore wait");
  SET GLOBAL innodb_file_per_table = OFF;
  #
  # System tablespace, Row Format = Redundant
  #
  CREATE TABLE t1 (
  c1 INT DEFAULT NULL,
  c2 LONGBLOB NOT NULL,
  KEY k2 (c2(250), c1)
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=REDUNDANT;
  INSERT INTO t1 VALUES (1, '');
  UPDATE t1 SET c2=@longblob;
  DROP TABLE t1;
  #
  # System tablespace, Row Format = Compact
  #
  CREATE TABLE t1 (
  c1 INT DEFAULT NULL,
  c2 LONGBLOB NOT NULL,
  KEY k2 (c2(250), c1)
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;
  INSERT INTO t1 VALUES (1, '');
  UPDATE t1 SET c2=@longblob;
  DROP TABLE t1;
  SET GLOBAL innodb_file_per_table = ON;
  #
  # Separate tablespace, Row Format = Redundant
  #
  CREATE TABLE t1 (
  c1 INT DEFAULT NULL,
  c2 LONGBLOB NOT NULL,
  KEY k2 (c2(250), c1)
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=REDUNDANT;
  INSERT INTO t1 VALUES (1, '');
  UPDATE t1 SET c2=@longblob;
  DROP TABLE t1;
  #
  # Separate tablespace, Row Format = Compact
  #
  CREATE TABLE t1 (
  c1 INT DEFAULT NULL,
  c2 LONGBLOB NOT NULL,
  KEY k2 (c2(250), c1)
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;
  INSERT INTO t1 VALUES (1, '');
  UPDATE t1 SET c2=@longblob;
  DROP TABLE t1;
  #
  # Separate tablespace, Row Format = Compressed, Key Block Size = 2k
  #
  CREATE TABLE t1 (
  c1 INT DEFAULT NULL,
  c2 LONGBLOB NOT NULL,
  KEY k2 (c2(250), c1)
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1 KEY_BLOCK_SIZE=2;
  INSERT INTO t1 VALUES (1, '');
  UPDATE t1 SET c2=@longblob;
  DROP TABLE t1;
  #
  # Separate tablespace, Row Format = Compressed, Key Block Size = 1k
  #
  CREATE TABLE t1 (
  c1 INT DEFAULT NULL,
  c2 LONGBLOB NOT NULL,
  KEY k2 (c2(250), c1)
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1 KEY_BLOCK_SIZE=1;
  INSERT INTO t1 VALUES (1, '');
  UPDATE t1 SET c2=@longblob;
  DROP TABLE t1;
  #
  # Separate tablespace, Row Format = Dynamic
  #
  CREATE TABLE t1 (
  c1 INT DEFAULT NULL,
  c2 LONGBLOB NOT NULL,
  KEY k2 (c2(250), c1)
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;
  INSERT INTO t1 VALUES (1, '');
  UPDATE t1 SET c2=@longblob;
  DROP TABLE t1;
  