possible parser error
От | Kyle Bateman |
---|---|
Тема | possible parser error |
Дата | |
Msg-id | 3773EFA9.F354E501@actarg.com обсуждение исходный текст |
Ответы |
Re: possible parser error
|
Список | pgsql-sql |
I'm using v6.5. I found out accidentally that the query: <p>update table set field = value' where key = keyvalue; --notice the accidental tick <p>silently ignores everything after the tick and does not generate any kindof syntax error. <br />This quietly clobbered a table by updating the field in every record in the table. (The where<br />clause was ignored.) <p>The tick shouldn't have been there, it was just a typing error. But unless I'm missingsomething, <br />it seems like it would be good to generate an error like "Unmatched quotes" or some such thing. <pre>-- ---------------------------------------------------- Kyle Bateman President, Action Target Inc. "Viva Yo!" kyle@actarg.com (801)377-8033x101 ----------------------------------------------------</pre>
В списке pgsql-sql по дате отправления: