wrong_db.sql

text/plain

Filename: wrong_db.sql

Type: text/plain

Part: 1

Message: PostgreSQL crashes using distance operator whith records where 'point' data type set to null

\connect - postgres
DROP TABLE "foo";
CREATE TABLE "foo" (
	"bar" point,
	"text" character varying,
	"bar2" point
);
INSERT INTO "foo" ("bar","text","bar2") VALUES ('(0,0)','hello1','(0,0)');
INSERT INTO "foo" ("bar","text","bar2") VALUES ('(0,0)','hello2',NULL);