On Thu, 11 Jul 2002, Victoria Reznichenko wrote: > robbat2, > Thursday, July 11, 2002, 11:57:16 AM, you wrote: > > >>Description: > r> The tokenizer is not behaving correctly with certain tokens relating to >comments. > > r> Correct Behaviour: > r> mysql> SELECT + /* foo */ 200; > r> ERROR 1064: You have an error in your SQL syntax near '+ /* foo */ 200' >at line 1 > > r> Incorrect Behavior: > r> mysql> SELECT - /* foo */ 200; > r> +-----------------+ > r> | - /* foo */ 200 | > r> +-----------------+ > r> | -200 | > r> +-----------------+ > r> 1 row in set (0.00 sec) > > r> Expected Behavior: > r> mysql> SELECT - /* foo */ 200; > r> ERROR 1064: You have an error in your SQL syntax near '- /* foo */ 200' >at line 1 > > r> Analysis: > r> The token '-/*' is causing problems with the comment section of the >tokenizer. > > MySQL doesn't allow set comments in the middle of constant. Yes, I am aware of that, given the correct behaviour of my "SELECT + /* foo */ 200;" query. (the error that it returns)
Why does the "SELECT - /* foo */ 200;" not produce the same error, instead of using the comment as part of the column title? -- Robin Hugh Johnson E-Mail : [EMAIL PROTECTED] Home Page : http://www.orbis-terrarum.net/?l=people.robbat2 ICQ# : 30269588 or 41961639 --------------------------------------------------------------------- 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