[Dovecot] v1.1.3 release candidate

[Ben Winslow]

On Sun, 31 Aug 2008 08:40:34 +0300
Timo Sirainen <tss at iki.fi> wrote:

> How were you able to create a "when" column? I only get syntax error
> if I try to do that.

Just FYI, it's possible to use reserved words as column/table names in
MySQL by quoting them with backticks, e.g.:

(root at localhost) [test]> CREATE TABLE `where` (`when` TIMESTAMP);
Query OK, 0 rows affected (0.18 sec)

(root at localhost) [test]> SELECT * FROM `where`;
Empty set (0.00 sec)

The quoting isn't standard, though, and varies between DB backends.  I
know that MySQL uses backticks (`foo`), PostgreSQL uses double quotes
("foo"), and MS's DB products use square brackets ([foo]).

It's probably not worth the trouble to have dovecot escape them as long
as it's possible to quote items this way in the config file.

-- 
Ben Winslow <rain at bluecherry.net>