@@ -13,23 +13,32 @@ INSERT INTO INET_TBL (c, i) VALUES ('10.1.2.3', '10.1.2.3/32');
13
13
INSERT INTO INET_TBL (c, i)VALUES (' 10.1.2' ,' 10.1.2.3/24' );
14
14
INSERT INTO INET_TBL (c, i)VALUES (' 10.1' ,' 10.1.2.3/16' );
15
15
INSERT INTO INET_TBL (c, i)VALUES (' 10' ,' 10.1.2.3/8' );
16
+ INSERT INTO INET_TBL (c, i)VALUES (' 10' ,' 11.1.2.3/8' );
17
+ INSERT INTO INET_TBL (c, i)VALUES (' 10' ,' 9.1.2.3/8' );
16
18
17
- SELECT ' ' as eight , cas cidr , ias inet FROM INET_TBL;
19
+ SELECT ' ' AS ten , cAS cidr , iAS inet FROM INET_TBL;
18
20
19
21
-- now test some support functions
20
22
21
- SELECT ' ' as eight , ias inet , host(i)FROM INET_TBL;
22
- SELECT ' ' as eight , cas cidr , broadcast(c),
23
- ias inet , broadcast(i)FROM INET_TBL;
24
- SELECT ' ' as eight , cas cidr , network(c)as " network(cidr)" ,
25
- ias inet , network(i)as " network(inet)" FROM INET_TBL;
26
- SELECT ' ' as eight , cas cidr , masklen(c)as " masklen(cidr)" ,
27
- ias inet , masklen(i)as " masklen(inet)" FROM INET_TBL;
23
+ SELECT ' ' AS ten , iAS inet , host(i)FROM INET_TBL;
24
+ SELECT ' ' AS ten , cAS cidr , broadcast(c),
25
+ iAS inet , broadcast(i)FROM INET_TBL;
26
+ SELECT ' ' AS ten , cAS cidr , network(c)AS " network(cidr)" ,
27
+ iAS inet , network(i)AS " network(inet)" FROM INET_TBL;
28
+ SELECT ' ' AS ten , cAS cidr , masklen(c)AS " masklen(cidr)" ,
29
+ iAS inet , masklen(i)AS " masklen(inet)" FROM INET_TBL;
28
30
29
- SELECT ' ' as two , cas cidr , masklen(c)as " masklen(cidr)" ,
30
- ias inet , masklen(i)as " masklen(inet)" FROM INET_TBL
31
+ SELECT ' ' AS four , cAS cidr , masklen(c)AS " masklen(cidr)" ,
32
+ iAS inet , masklen(i)AS " masklen(inet)" FROM INET_TBL
31
33
WHERE masklen(c)<= 8 ;
32
34
33
- SELECT ' ' as six, cas cidr , ias inet FROM INET_TBL
35
+ SELECT ' ' AS six, cAS cidr , iAS inet FROM INET_TBL
34
36
WHERE c= i;
35
37
38
+ SELECT ' ' AS ten, i, c,
39
+ i< cAS lt, i<= cAS le, i= cAS eq,
40
+ i>= cAS ge, i> cAS gt, i<> cAS ne,
41
+ i<< cAS sb, i<<= cAS sbe,
42
+ i>> cAS sup, i>>= cAS spe
43
+ FROM INET_TBL;
44
+