Using nulls with earthdistance operator crashes backend
| От | Mark Stosberg |
|---|---|
| Тема | Using nulls with earthdistance operator crashes backend |
| Дата | |
| Msg-id | 20010731095840.A94094-100000@nollie.summersault.com обсуждение исходный текст |
| Ответы |
Re: Using nulls with earthdistance operator crashes backend
Re: Using nulls with earthdistance operator crashes backend |
| Список | pgsql-bugs |
Hello!
Here's now to reproduce my bug:
* Start with Postgres 7.1.2
(specifically: PostgreSQL 7.1 on i386--freebsd4.3, compiled by GCC 2.95.3
)
* Install earthdistance operator from the contrib directory.
* try this:
cascade=> select null <@> '1,1'::point;
## The result I get:
pqReadData() -- backend closed the channel unexpectedly.
This probably means the backend terminated abnormally
before or while processing the request.
The connection to the server was lost. Attempting reset: Failed.
###############
I expected simply for "null" to be returned as the result. I can work
around
this by including an extra step to make sure that my data is not null
before
it's passed off a SQL statement like this.
Thanks!
-mark
http://mark.stosberg.com/
В списке pgsql-bugs по дате отправления: