Обсуждение: Bug #779: query 'SELECT '{1,2}' *= NULL' crash backend

Vadim Passynkov (Vadim.Passynkov@pathcom.com) reports a bug with a severity of 1
The lower the number the more severe it is.

Short Description
query 'SELECT '{1,2}' *= NULL' crash backend

Long Description
SELECT version();
                               version
---------------------------------------------------------------------
 PostgreSQL 7.2.2 on i386-portbld-freebsd4.7, compiled by GCC 2.95.4
(1 row)

SELECT '{1,2}' *= NULL;
server closed the connection unexpectedly
        This probably means the server terminated abnormally
        before or while processing the request.
The connection to the server was lost. Attempting reset: Failed.


Sample Code
SELECT '{1,2}' *= NULL;

No file was uploaded with this report

pgsql-bugs@postgresql.org writes:
> query 'SELECT '{1,2}' *= NULL' crash backend

The functions defined by the contrib/array module should all be marked
strict.  But they were not in 7.2 :-(.

Current sources have, for example,

create or replace function array_texteq(_text, text) returns bool
  as 'MODULE_PATHNAME'
  language C with (isStrict);

in array_iterator.sql.in.

            regards, tom lane