@@ -13,23 +13,32 @@ INSERT INTO INET_TBL (c, i) VALUES ('10.1.2.3', '10.1.2.3/32');
1313INSERT INTO INET_TBL (c, i)VALUES (' 10.1.2' ' 10.1.2.3/24'
1414INSERT INTO INET_TBL (c, i)VALUES (' 10.1' ' 10.1.2.3/16'
1515INSERT 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'
1618
17- SELECT ' ' as eight , cas cidr , ias inet FROM INET_TBL;
19+ SELECT ' ' AS ten , cAS cidr , iAS inet FROM INET_TBL;
1820
1921-- now test some support functions
2022
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;
2830
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
3133WHERE masklen(c)<= 8 ;
3234
33- SELECT ' ' as six, cas cidr , ias inet FROM INET_TBL
35+ SELECT ' ' AS six, cAS cidr , iAS inet FROM INET_TBL
3436WHERE c= i;
3537
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+
