I realized the other day that I need the sleep() function, which up until this morning, Drizzle did not have, for testing the memcached Drizzle UDFs. Well, now it does:
drizzle> select sleep(3);
+----------+
| sleep(3) |
+----------+
| 0 |
+----------+
1 row in set (3 sec)
drizzle> select sleep(0);
+----------+
| sleep(0) |
+----------+
| 0 |
+----------+
1 row in set (0 sec)
drizzle> select sleep(20);
+-----------+
| sleep(20) |
+-----------+
| 0 |
+-----------+
1 row in set (20 sec)
As you see, it returns zero, just as the MySQL sleep() function does.
The code can be had at:
lp:~capttofu/drizzle/sleep