CREATE TABLE integers(i TIMESTAMP TIME INDEX);

Affected Rows: 0

INSERT INTO integers VALUES (0), (1), (2), (3), (4);

Affected Rows: 5

SELECT * FROM integers UNION ALL SELECT * FROM integers LIMIT 7;

+-------------------------+
| i                       |
+-------------------------+
| 1970-01-01T00:00:00     |
| 1970-01-01T00:00:00.001 |
| 1970-01-01T00:00:00.002 |
| 1970-01-01T00:00:00.003 |
| 1970-01-01T00:00:00.004 |
| 1970-01-01T00:00:00     |
| 1970-01-01T00:00:00.001 |
+-------------------------+

SELECT COUNT(*) FROM (SELECT * FROM integers UNION ALL SELECT * FROM integers LIMIT 7) tbl;

+----------+
| COUNT(*) |
+----------+
| 7        |
+----------+

DROP TABLE integers;

Affected Rows: 0