BUG #5732: parsing of: "WHERE mycol=123AND ..."
От | Josh Kupershmidt |
---|---|
Тема | BUG #5732: parsing of: "WHERE mycol=123AND ..." |
Дата | |
Msg-id | 201010282346.o9SNkpOj074029@wwwmaster.postgresql.org обсуждение исходный текст |
Ответы |
Re: BUG #5732: parsing of: "WHERE mycol=123AND ..."
Re: BUG #5732: parsing of: "WHERE mycol=123AND ..." |
Список | pgsql-bugs |
The following bug has been logged online: Bug reference: 5732 Logged by: Josh Kupershmidt Email address: schmiddy@gmail.com PostgreSQL version: 8.3 and HEAD Operating system: Linux and OS X Description: parsing of: "WHERE mycol=123AND ..." Details: I noticed that Postgres in many cases will happily tokenize WHERE clauses having no space between a condition and "AND" or "OR". For example: CREATE TABLE mytab (mycol int); INSERT INTO mytab (mycol) VALUES (1), (2); SELECT * FROM mytab WHERE mycol = 1AND true; SELECT * FROM mytab WHERE mycol = 2OR true; although some cases produce an error, as I would expect, such as: SELECT * FROM mytab WHERE mycol = 2::intOR true; I think it would be more consistent to raise syntax errors in all these cases. Josh
В списке pgsql-bugs по дате отправления: