From: | "Donald Fraser" <postgres(at)kiwi-fraser(dot)net> |
---|---|
To: | "[BUGS]" <pgsql-bugs(at)postgresql(dot)org> |
Subject: | No length checking for "name" input |
Date: | 2006-03-20 22:41:11 |
Message-ID: | 00a601c64c6f$6321acf0$0264a8c0@demolish1 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
PostgreSQL versions: 7.4.x and 8.0.x
(I don't have a 8.1.x installation to test against)
There appears to be no length checking for data types of "name".
For example:
template1=# SELECT length('rpt_cisx_total_principal_amount_of_security_type_between_dates('::name) AS name_len;
name_len
----------
63
(1 row)
I get exactly the same result for this query which is obviously not the same length and yet I get no error?
template1=# SELECT length('rpt_cisx_total_principal_amount_of_security_type_between_dates(date,date)'::name) AS name_len;
name_len
----------
63
(1 row)
I don't know whether you consider this a bug, certainly most of the other data types appear to have range checking as part of the input.
Regards
Donald Fraser
From | Date | Subject | |
---|---|---|---|
Next Message | Kashin Oleg | 2006-03-21 07:53:04 | BUG #2345: odbc driver doesn't work |
Previous Message | Tom Lane | 2006-03-20 22:12:05 | Re: BUG #2342: Extremely bad performance on a specific query, compared to 7.4 |