Bug #779: query 'SELECT '{1,2}' *= NULL' crash backend

Vadim Passynkov (Vadim(dot)Passynkov(at)pathcom(dot)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(at)postgresql(dot)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