Hi Carsten, Tom, ----- Original Message ----- From: "Carsten H. Pedersen" <[EMAIL PROTECTED]> To: "Tom McGlynn" <[EMAIL PROTECTED]>
> > >Description: > > The name dec does not work as an unqualified name > > when creating tables on inside queries. A syntax error > > is given. If escaped as `dec`, no error is given. dec is > > not on the list of reserved words. Thus this could be > > either a documentation or software bug. > It's a documentation bug. Although not on the list of reserved > words, the manual does say: > --- > 6.2.1 Numeric Types > ... and the keyword DEC is a synonym for DECIMAL. > --- Yea. We use a script to grab the reserved words from the source; it's not a straightforward dump of all symbols since many are in fact allowed. Based on your info I checked the script and made some changes: 2 keywords and all 15 synonyms had been missing. DEC was one of the synonyms, of course. The online manual should reflect this change soon. So, thanks for the feedback! Regards, Arjen. -- MySQL Training Worldwide, http://www.mysql.com/training/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Mr. Arjen G. Lentz <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Technical Writer /_/ /_/\_, /___/\___\_\___/ Brisbane, QLD Australia <___/ www.mysql.com --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php