Обсуждение: Bug #840: Query with null string

Stéphane Bérubé (sirber@webernic.com) reports a bug with a severity of 2
The lower the number the more severe it is.

Short Description
Query with null string

Long Description
When I do a query (SELECT or INSERT) with null vars (see example) I get warnings from php:

Warning: pg_query() query failed: ERROR: pg_atoi: zero-length string in
/var/www/include/fr/sub/info/news/newdisplay.phpon line 27 

Warning: pg_fetch_object(): supplied argument is not a valid PostgreSQL result resource in
/var/www/include/fr/sub/info/news/newdisplay.phpon line 28 

because the WHERE was empty. This code worked fine on PostGreSQL 7.2.x. Now I'm on 7.3rel-4.

Any idea?

Thanks

Stéphane Bérubé

Sample Code
SELECT * FROM tbluser WHERE userid = ""


No file was uploaded with this report

On Fri, 6 Dec 2002 pgsql-bugs@postgresql.org wrote:

> Sample Code
> SELECT * FROM tbluser WHERE userid = ""

I assume you mean '' rather than "".

0 length strings used to be interpreted as having
the value 0 when converted into an integer.  Now it
throws an error instead.  There was some discussion
at the time it happened and some more recently on
the mailing lists, you should be able to get more
info from the archives.