granicus.if.org Git - postgresql/blob - src/test/regress/expected/macaddr8.out

   1 --
   2 -- macaddr8
   3 --
   4 -- test various cases of valid and invalid input
   5 -- valid
   6 SELECT '08:00:2b:01:02:03     '::macaddr8;
   7         macaddr8
   8 -------------------------
   9  08:00:2b:ff:fe:01:02:03
  10 (1 row)
  11
  12 SELECT '    08:00:2b:01:02:03     '::macaddr8;
  13         macaddr8
  14 -------------------------
  15  08:00:2b:ff:fe:01:02:03
  16 (1 row)
  17
  18 SELECT '    08:00:2b:01:02:03'::macaddr8;
  19         macaddr8
  20 -------------------------
  21  08:00:2b:ff:fe:01:02:03
  22 (1 row)
  23
  24 SELECT '08:00:2b:01:02:03:04:05     '::macaddr8;
  25         macaddr8
  26 -------------------------
  27  08:00:2b:01:02:03:04:05
  28 (1 row)
  29
  30 SELECT '    08:00:2b:01:02:03:04:05     '::macaddr8;
  31         macaddr8
  32 -------------------------
  33  08:00:2b:01:02:03:04:05
  34 (1 row)
  35
  36 SELECT '    08:00:2b:01:02:03:04:05'::macaddr8;
  37         macaddr8
  38 -------------------------
  39  08:00:2b:01:02:03:04:05
  40 (1 row)
  41
  42 SELECT '123    08:00:2b:01:02:03'::macaddr8; -- invalid
  43 ERROR:  invalid input syntax for type macaddr8: "123    08:00:2b:01:02:03"
  44 LINE 1: SELECT '123    08:00:2b:01:02:03'::macaddr8;
  45                ^
  46 SELECT '08:00:2b:01:02:03  123'::macaddr8; -- invalid
  47 ERROR:  invalid input syntax for type macaddr8: "08:00:2b:01:02:03  123"
  48 LINE 1: SELECT '08:00:2b:01:02:03  123'::macaddr8;
  49                ^
  50 SELECT '123    08:00:2b:01:02:03:04:05'::macaddr8; -- invalid
  51 ERROR:  invalid input syntax for type macaddr8: "123    08:00:2b:01:02:03:04:05"
  52 LINE 1: SELECT '123    08:00:2b:01:02:03:04:05'::macaddr8;
  53                ^
  54 SELECT '08:00:2b:01:02:03:04:05  123'::macaddr8; -- invalid
  55 ERROR:  invalid input syntax for type macaddr8: "08:00:2b:01:02:03:04:05  123"
  56 LINE 1: SELECT '08:00:2b:01:02:03:04:05  123'::macaddr8;
  57                ^
  58 SELECT '08:00:2b:01:02:03:04:05:06:07'::macaddr8; -- invalid
  59 ERROR:  invalid input syntax for type macaddr8: "08:00:2b:01:02:03:04:05:06:07"
  60 LINE 1: SELECT '08:00:2b:01:02:03:04:05:06:07'::macaddr8;
  61                ^
  62 SELECT '08-00-2b-01-02-03-04-05-06-07'::macaddr8; -- invalid
  63 ERROR:  invalid input syntax for type macaddr8: "08-00-2b-01-02-03-04-05-06-07"
  64 LINE 1: SELECT '08-00-2b-01-02-03-04-05-06-07'::macaddr8;
  65                ^
  66 SELECT '08002b:01020304050607'::macaddr8; -- invalid
  67 ERROR:  invalid input syntax for type macaddr8: "08002b:01020304050607"
  68 LINE 1: SELECT '08002b:01020304050607'::macaddr8;
  69                ^
  70 SELECT '08002b01020304050607'::macaddr8; -- invalid
  71 ERROR:  invalid input syntax for type macaddr8: "08002b01020304050607"
  72 LINE 1: SELECT '08002b01020304050607'::macaddr8;
  73                ^
  74 SELECT '0z002b0102030405'::macaddr8; -- invalid
  75 ERROR:  invalid input syntax for type macaddr8: "0z002b0102030405"
  76 LINE 1: SELECT '0z002b0102030405'::macaddr8;
  77                ^
  78 SELECT '08002b010203xyza'::macaddr8; -- invalid
  79 ERROR:  invalid input syntax for type macaddr8: "08002b010203xyza"
  80 LINE 1: SELECT '08002b010203xyza'::macaddr8;
  81                ^
  82 SELECT '08:00-2b:01:02:03:04:05'::macaddr8; -- invalid
  83 ERROR:  invalid input syntax for type macaddr8: "08:00-2b:01:02:03:04:05"
  84 LINE 1: SELECT '08:00-2b:01:02:03:04:05'::macaddr8;
  85                ^
  86 SELECT '08:00-2b:01:02:03:04:05'::macaddr8; -- invalid
  87 ERROR:  invalid input syntax for type macaddr8: "08:00-2b:01:02:03:04:05"
  88 LINE 1: SELECT '08:00-2b:01:02:03:04:05'::macaddr8;
  89                ^
  90 SELECT '08:00:2b:01.02:03:04:05'::macaddr8; -- invalid
  91 ERROR:  invalid input syntax for type macaddr8: "08:00:2b:01.02:03:04:05"
  92 LINE 1: SELECT '08:00:2b:01.02:03:04:05'::macaddr8;
  93                ^
  94 SELECT '08:00:2b:01.02:03:04:05'::macaddr8; -- invalid
  95 ERROR:  invalid input syntax for type macaddr8: "08:00:2b:01.02:03:04:05"
  96 LINE 1: SELECT '08:00:2b:01.02:03:04:05'::macaddr8;
  97                ^
  98 -- test converting a MAC address to modified EUI-64 for inclusion
  99 -- in an ipv6 address
 100 SELECT macaddr8_set7bit('00:08:2b:01:02:03'::macaddr8);
 101     macaddr8_set7bit
 102 -------------------------
 103  02:08:2b:ff:fe:01:02:03
 104 (1 row)
 105
 106 CREATE TABLE macaddr8_data (a int, b macaddr8);
 107 INSERT INTO macaddr8_data VALUES (1, '08:00:2b:01:02:03');
 108 INSERT INTO macaddr8_data VALUES (2, '08-00-2b-01-02-03');
 109 INSERT INTO macaddr8_data VALUES (3, '08002b:010203');
 110 INSERT INTO macaddr8_data VALUES (4, '08002b-010203');
 111 INSERT INTO macaddr8_data VALUES (5, '0800.2b01.0203');
 112 INSERT INTO macaddr8_data VALUES (6, '0800-2b01-0203');
 113 INSERT INTO macaddr8_data VALUES (7, '08002b010203');
 114 INSERT INTO macaddr8_data VALUES (8, '0800:2b01:0203');
 115 INSERT INTO macaddr8_data VALUES (9, 'not even close'); -- invalid
 116 ERROR:  invalid input syntax for type macaddr8: "not even close"
 117 LINE 1: INSERT INTO macaddr8_data VALUES (9, 'not even close');
 118                                              ^
 119 INSERT INTO macaddr8_data VALUES (10, '08:00:2b:01:02:04');
 120 INSERT INTO macaddr8_data VALUES (11, '08:00:2b:01:02:02');
 121 INSERT INTO macaddr8_data VALUES (12, '08:00:2a:01:02:03');
 122 INSERT INTO macaddr8_data VALUES (13, '08:00:2c:01:02:03');
 123 INSERT INTO macaddr8_data VALUES (14, '08:00:2a:01:02:04');
 124 INSERT INTO macaddr8_data VALUES (15, '08:00:2b:01:02:03:04:05');
 125 INSERT INTO macaddr8_data VALUES (16, '08-00-2b-01-02-03-04-05');
 126 INSERT INTO macaddr8_data VALUES (17, '08002b:0102030405');
 127 INSERT INTO macaddr8_data VALUES (18, '08002b-0102030405');
 128 INSERT INTO macaddr8_data VALUES (19, '0800.2b01.0203.0405');
 129 INSERT INTO macaddr8_data VALUES (20, '08002b01:02030405');
 130 INSERT INTO macaddr8_data VALUES (21, '08002b0102030405');
 131 SELECT * FROM macaddr8_data ORDER BY 1;
 132  a  |            b
 133 ----+-------------------------
 134   1 | 08:00:2b:ff:fe:01:02:03
 135   2 | 08:00:2b:ff:fe:01:02:03
 136   3 | 08:00:2b:ff:fe:01:02:03
 137   4 | 08:00:2b:ff:fe:01:02:03
 138   5 | 08:00:2b:ff:fe:01:02:03
 139   6 | 08:00:2b:ff:fe:01:02:03
 140   7 | 08:00:2b:ff:fe:01:02:03
 141   8 | 08:00:2b:ff:fe:01:02:03
 142  10 | 08:00:2b:ff:fe:01:02:04
 143  11 | 08:00:2b:ff:fe:01:02:02
 144  12 | 08:00:2a:ff:fe:01:02:03
 145  13 | 08:00:2c:ff:fe:01:02:03
 146  14 | 08:00:2a:ff:fe:01:02:04
 147  15 | 08:00:2b:01:02:03:04:05
 148  16 | 08:00:2b:01:02:03:04:05
 149  17 | 08:00:2b:01:02:03:04:05
 150  18 | 08:00:2b:01:02:03:04:05
 151  19 | 08:00:2b:01:02:03:04:05
 152  20 | 08:00:2b:01:02:03:04:05
 153  21 | 08:00:2b:01:02:03:04:05
 154 (20 rows)
 155
 156 CREATE INDEX macaddr8_data_btree ON macaddr8_data USING btree (b);
 157 CREATE INDEX macaddr8_data_hash ON macaddr8_data USING hash (b);
 158 SELECT a, b, trunc(b) FROM macaddr8_data ORDER BY 2, 1;
 159  a  |            b            |          trunc
 160 ----+-------------------------+-------------------------
 161  12 | 08:00:2a:ff:fe:01:02:03 | 08:00:2a:00:00:00:00:00
 162  14 | 08:00:2a:ff:fe:01:02:04 | 08:00:2a:00:00:00:00:00
 163  15 | 08:00:2b:01:02:03:04:05 | 08:00:2b:00:00:00:00:00
 164  16 | 08:00:2b:01:02:03:04:05 | 08:00:2b:00:00:00:00:00
 165  17 | 08:00:2b:01:02:03:04:05 | 08:00:2b:00:00:00:00:00
 166  18 | 08:00:2b:01:02:03:04:05 | 08:00:2b:00:00:00:00:00
 167  19 | 08:00:2b:01:02:03:04:05 | 08:00:2b:00:00:00:00:00
 168  20 | 08:00:2b:01:02:03:04:05 | 08:00:2b:00:00:00:00:00
 169  21 | 08:00:2b:01:02:03:04:05 | 08:00:2b:00:00:00:00:00
 170  11 | 08:00:2b:ff:fe:01:02:02 | 08:00:2b:00:00:00:00:00
 171   1 | 08:00:2b:ff:fe:01:02:03 | 08:00:2b:00:00:00:00:00
 172   2 | 08:00:2b:ff:fe:01:02:03 | 08:00:2b:00:00:00:00:00
 173   3 | 08:00:2b:ff:fe:01:02:03 | 08:00:2b:00:00:00:00:00
 174   4 | 08:00:2b:ff:fe:01:02:03 | 08:00:2b:00:00:00:00:00
 175   5 | 08:00:2b:ff:fe:01:02:03 | 08:00:2b:00:00:00:00:00
 176   6 | 08:00:2b:ff:fe:01:02:03 | 08:00:2b:00:00:00:00:00
 177   7 | 08:00:2b:ff:fe:01:02:03 | 08:00:2b:00:00:00:00:00
 178   8 | 08:00:2b:ff:fe:01:02:03 | 08:00:2b:00:00:00:00:00
 179  10 | 08:00:2b:ff:fe:01:02:04 | 08:00:2b:00:00:00:00:00
 180  13 | 08:00:2c:ff:fe:01:02:03 | 08:00:2c:00:00:00:00:00
 181 (20 rows)
 182
 183 SELECT b <  '08:00:2b:01:02:04' FROM macaddr8_data WHERE a = 1; -- true
 184  ?column?
 185 ----------
 186  t
 187 (1 row)
 188
 189 SELECT b >  '08:00:2b:ff:fe:01:02:04' FROM macaddr8_data WHERE a = 1; -- false
 190  ?column?
 191 ----------
 192  f
 193 (1 row)
 194
 195 SELECT b >  '08:00:2b:ff:fe:01:02:03' FROM macaddr8_data WHERE a = 1; -- false
 196  ?column?
 197 ----------
 198  f
 199 (1 row)
 200
 201 SELECT b::macaddr <= '08:00:2b:01:02:04' FROM macaddr8_data WHERE a = 1; -- true
 202  ?column?
 203 ----------
 204  t
 205 (1 row)
 206
 207 SELECT b::macaddr >= '08:00:2b:01:02:04' FROM macaddr8_data WHERE a = 1; -- false
 208  ?column?
 209 ----------
 210  f
 211 (1 row)
 212
 213 SELECT b =  '08:00:2b:ff:fe:01:02:03' FROM macaddr8_data WHERE a = 1; -- true
 214  ?column?
 215 ----------
 216  t
 217 (1 row)
 218
 219 SELECT b::macaddr <> '08:00:2b:01:02:04'::macaddr FROM macaddr8_data WHERE a = 1; -- true
 220  ?column?
 221 ----------
 222  t
 223 (1 row)
 224
 225 SELECT b::macaddr <> '08:00:2b:01:02:03'::macaddr FROM macaddr8_data WHERE a = 1; -- false
 226  ?column?
 227 ----------
 228  f
 229 (1 row)
 230
 231 SELECT b <  '08:00:2b:01:02:03:04:06' FROM macaddr8_data WHERE a = 15; -- true
 232  ?column?
 233 ----------
 234  t
 235 (1 row)
 236
 237 SELECT b >  '08:00:2b:01:02:03:04:06' FROM macaddr8_data WHERE a = 15; -- false
 238  ?column?
 239 ----------
 240  f
 241 (1 row)
 242
 243 SELECT b >  '08:00:2b:01:02:03:04:05' FROM macaddr8_data WHERE a = 15; -- false
 244  ?column?
 245 ----------
 246  f
 247 (1 row)
 248
 249 SELECT b <= '08:00:2b:01:02:03:04:06' FROM macaddr8_data WHERE a = 15; -- true
 250  ?column?
 251 ----------
 252  t
 253 (1 row)
 254
 255 SELECT b >= '08:00:2b:01:02:03:04:06' FROM macaddr8_data WHERE a = 15; -- false
 256  ?column?
 257 ----------
 258  f
 259 (1 row)
 260
 261 SELECT b =  '08:00:2b:01:02:03:04:05' FROM macaddr8_data WHERE a = 15; -- true
 262  ?column?
 263 ----------
 264  t
 265 (1 row)
 266
 267 SELECT b <> '08:00:2b:01:02:03:04:06' FROM macaddr8_data WHERE a = 15; -- true
 268  ?column?
 269 ----------
 270  t
 271 (1 row)
 272
 273 SELECT b <> '08:00:2b:01:02:03:04:05' FROM macaddr8_data WHERE a = 15; -- false
 274  ?column?
 275 ----------
 276  f
 277 (1 row)
 278
 279 SELECT ~b                       FROM macaddr8_data;
 280         ?column?
 281 -------------------------
 282  f7:ff:d4:00:01:fe:fd:fc
 283  f7:ff:d4:00:01:fe:fd:fc
 284  f7:ff:d4:00:01:fe:fd:fc
 285  f7:ff:d4:00:01:fe:fd:fc
 286  f7:ff:d4:00:01:fe:fd:fc
 287  f7:ff:d4:00:01:fe:fd:fc
 288  f7:ff:d4:00:01:fe:fd:fc
 289  f7:ff:d4:00:01:fe:fd:fc
 290  f7:ff:d4:00:01:fe:fd:fb
 291  f7:ff:d4:00:01:fe:fd:fd
 292  f7:ff:d5:00:01:fe:fd:fc
 293  f7:ff:d3:00:01:fe:fd:fc
 294  f7:ff:d5:00:01:fe:fd:fb
 295  f7:ff:d4:fe:fd:fc:fb:fa
 296  f7:ff:d4:fe:fd:fc:fb:fa
 297  f7:ff:d4:fe:fd:fc:fb:fa
 298  f7:ff:d4:fe:fd:fc:fb:fa
 299  f7:ff:d4:fe:fd:fc:fb:fa
 300  f7:ff:d4:fe:fd:fc:fb:fa
 301  f7:ff:d4:fe:fd:fc:fb:fa
 302 (20 rows)
 303
 304 SELECT  b & '00:00:00:ff:ff:ff' FROM macaddr8_data;
 305         ?column?
 306 -------------------------
 307  00:00:00:ff:fe:01:02:03
 308  00:00:00:ff:fe:01:02:03
 309  00:00:00:ff:fe:01:02:03
 310  00:00:00:ff:fe:01:02:03
 311  00:00:00:ff:fe:01:02:03
 312  00:00:00:ff:fe:01:02:03
 313  00:00:00:ff:fe:01:02:03
 314  00:00:00:ff:fe:01:02:03
 315  00:00:00:ff:fe:01:02:04
 316  00:00:00:ff:fe:01:02:02
 317  00:00:00:ff:fe:01:02:03
 318  00:00:00:ff:fe:01:02:03
 319  00:00:00:ff:fe:01:02:04
 320  00:00:00:01:02:03:04:05
 321  00:00:00:01:02:03:04:05
 322  00:00:00:01:02:03:04:05
 323  00:00:00:01:02:03:04:05
 324  00:00:00:01:02:03:04:05
 325  00:00:00:01:02:03:04:05
 326  00:00:00:01:02:03:04:05
 327 (20 rows)
 328
 329 SELECT  b | '01:02:03:04:05:06' FROM macaddr8_data;
 330         ?column?
 331 -------------------------
 332  09:02:2b:ff:fe:05:07:07
 333  09:02:2b:ff:fe:05:07:07
 334  09:02:2b:ff:fe:05:07:07
 335  09:02:2b:ff:fe:05:07:07
 336  09:02:2b:ff:fe:05:07:07
 337  09:02:2b:ff:fe:05:07:07
 338  09:02:2b:ff:fe:05:07:07
 339  09:02:2b:ff:fe:05:07:07
 340  09:02:2b:ff:fe:05:07:06
 341  09:02:2b:ff:fe:05:07:06
 342  09:02:2b:ff:fe:05:07:07
 343  09:02:2f:ff:fe:05:07:07
 344  09:02:2b:ff:fe:05:07:06
 345  09:02:2b:ff:fe:07:05:07
 346  09:02:2b:ff:fe:07:05:07
 347  09:02:2b:ff:fe:07:05:07
 348  09:02:2b:ff:fe:07:05:07
 349  09:02:2b:ff:fe:07:05:07
 350  09:02:2b:ff:fe:07:05:07
 351  09:02:2b:ff:fe:07:05:07
 352 (20 rows)
 353
 354 DROP TABLE macaddr8_data;