> Did time become a keyword in 7.2? 7.1.3 allowed it as a column name...
> 7.2 rejects it.
Yes. We now support SQL99 time and timestamp precision, which require
that TIME(p) be a type specification. So there are parts of the grammar
which cannot easily fit "time" anymore.
You could/should use the SQL99 list of reserved words as a guide for
which keywords to *not* use, even though some of them are currently
accepted as, for example, column names. In the meantime, you can
double-quote the column name if you really need it to stay "time".
- Thomas