inet regression test

From: Rod Taylor <rbt(at)rbt(dot)ca>
To: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
Cc: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: inet regression test
Date: 2003-01-15 16:05:25
Message-ID: 1042646725.61110.19.camel@jester
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Looks like some ORDER BY statements would be useful.

*** ./expected/inet.out Sat Jun 16 22:05:20 2001
--- ./results/inet.out Wed Jan 15 10:18:40 2003
***************
*** 193,212 ****
select * from inet_tbl where i<<'192.168.1.0/24'::cidr;
c | i
----------------+------------------
192.168.1.0/24 | 192.168.1.0/25
192.168.1.0/24 | 192.168.1.255/25
- 192.168.1.0/24 | 192.168.1.226
(3 rows)

select * from inet_tbl where i<<='192.168.1.0/24'::cidr;
c | i
----------------+------------------
- 192.168.1.0/24 | 192.168.1.0/24
192.168.1.0/24 | 192.168.1.226/24
! 192.168.1.0/24 | 192.168.1.255/24
192.168.1.0/24 | 192.168.1.0/25
192.168.1.0/24 | 192.168.1.255/25
- 192.168.1.0/24 | 192.168.1.226
(6 rows)

set enable_seqscan to on;
--- 193,212 ----
select * from inet_tbl where i<<'192.168.1.0/24'::cidr;
c | i
----------------+------------------
+ 192.168.1.0/24 | 192.168.1.226
192.168.1.0/24 | 192.168.1.0/25
192.168.1.0/24 | 192.168.1.255/25
(3 rows)

select * from inet_tbl where i<<='192.168.1.0/24'::cidr;
c | i
----------------+------------------
192.168.1.0/24 | 192.168.1.226/24
! 192.168.1.0/24 | 192.168.1.226
! 192.168.1.0/24 | 192.168.1.0/24
192.168.1.0/24 | 192.168.1.0/25
+ 192.168.1.0/24 | 192.168.1.255/24
192.168.1.0/24 | 192.168.1.255/25
(6 rows)

set enable_seqscan to on;

--
Rod Taylor <rbt(at)rbt(dot)ca>

PGP Key: http://www.rbt.ca/rbtpub.asc

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2003-01-15 16:10:02 Re: UNION result
Previous Message Stephan Szabo 2003-01-15 15:54:12 Re: UNION result