|
CREATE TABLE t1 (pk int);
|
INSERT INTO t1 VALUES (1),(2),(3),(4),(5);
|
|
prepare stmt from "(((SELECT * FROM t1 order by pk ) order by rand()) UNION (SELECT * FROM t1) );";
|
|
execute stmt;
|
execute stmt;
|
|
10.4 77109285f918a6b07
|
MariaDB [test]> prepare stmt from "(((SELECT * FROM t1 order by pk ) order by rand()) UNION (SELECT * FROM t1) );";
|
Query OK, 0 rows affected (0.007 sec)
|
Statement prepared
|
|
MariaDB [test]> execute stmt;
|
+------+
|
| pk |
|
+------+
|
| 1 |
|
| 2 |
|
| 3 |
|
| 4 |
|
| 5 |
|
+------+
|
5 rows in set (0.002 sec)
|
|
MariaDB [test]> execute stmt;
|
ERROR 1030 (HY000): Got error 1 "Operation not permitted" from storage engine MEMORY
|
|