[HACKERS] inet regression test

[Rod Taylor]

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 <[EMAIL PROTECTED]>

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

signature.asc
Description: This is a digitally signed message part