This file is indexed.

/usr/lib/mysql-testsuite/r/bug1294190.result is in percona-server-test-5.6 5.6.22-rel71.0-0ubuntu4.

This file is owned by root:root, with mode 0o644.

The actual contents of the file can be viewed below.

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
CREATE TABLE foo (id SERIAL PRIMARY KEY) ENGINE=innodb;
INSERT INTO foo SELECT NULL;
INSERT INTO foo SELECT NULL FROM foo;
SET DEBUG_SYNC="after_open_altered_table signal open_done wait_for select_done";
ALTER TABLE foo ADD COLUMN x INT, ADD KEY (x), ALGORITHM=INPLACE;
SET DEBUG_SYNC="now wait_for open_done";
SELECT TABLE_SCHEMA, ENGINE, TABLE_ROWS
FROM INFORMATION_SCHEMA.GLOBAL_TEMPORARY_TABLES;
TABLE_SCHEMA	ENGINE	TABLE_ROWS
test	InnoDB	0
SET DEBUG_SYNC = "now signal select_done";
DROP TABLE foo;