Обсуждение: patch for xidin

Поиск
Список
Период
Сортировка

patch for xidin

От
"Zhang Zq"
Дата:
hi,
   The implements of 'xidin' use only ‘strtoul’ to cast from string to xid. So in some cases, may cause confusion, for example,
The sql 'select c1 from test where xmin='abc' can be executed.  and sometimes will make mistakes, I want to query "select c1 from test where xmin='0x10'" ,but write 'Ox10', '0' to 'O',The result is obviously wrong.

The patch will correct it. I have justly copy some code of 'OID'. Whether we need to extract the common code?

Thanks.
Вложения

Re: patch for xidin

От
Tom Lane
Дата:
"Zhang Zq" <zqzhangmail@163.com> writes:
>    The implements of 'xidin' use only ¡®strtoul¡¯ to cast from string to xid. So in some cases, may cause confusion,
forexample,
 
> The sql 'select c1 from test where xmin='abc' can be executed.  and sometimes will make mistakes, I want to query
"selectc1 from test where xmin='0x10'" ,but write 'Ox10', '0' to 'O',The result is obviously wrong.
 

> The patch will correct it. I have justly copy some code of 'OID'. Whether we need to extract the common code?

This seems like an awful lot of code to solve a problem that will never
occur in practice.
        regards, tom lane

Re: patch for xidin

От
Robert Haas
Дата:
On Fri, Apr 17, 2015 at 10:27 AM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>> The patch will correct it. I have justly copy some code of 'OID'. Whether we need to extract the common code?
>
> This seems like an awful lot of code to solve a problem that will never
> occur in practice.

It does seem like an awful lot of code.  We should be able to come up
with something shorter.  But the bug report is legitimate.  It's not
too much to ask that data types sanity check their inputs.

-- 
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company