eldenmoon commented on code in PR #41001:
URL: https://github.com/apache/doris/pull/41001#discussion_r1797641465
##########
regression-test/suites/nereids_function_p0/load.groovy:
##########
@@ -27,6 +27,109 @@ suite("load") {
DROP TABLE IF EXISTS `fn_test_bitmap`
"""
+ // test ipv4/ipv6
+ sql """ drop table if exists fn_test_ip_nullable """
+ sql """ CREATE TABLE IF NOT EXISTS fn_test_ip_nullable (id int, ip4 ipv4,
ip6 ipv6) engine=olap
Review Comment:
what about none nullable type
##########
regression-test/data/nereids_function_p0/scalar_function/IP.out:
##########
@@ -0,0 +1,3061 @@
+-- This file is automatically generated. You should know what you did if you
want to edit this
+-- !sql_cidr_ipv6 --
+1 :: ::ffff:ffff:ffff:ffff
+2 fc00:: fc00::ffff:ffff:ffff:ffff
+3 fdff:ffff:ffff:ffff:: fdff:ffff:ffff:ffff:ffff:ffff:ffff:ffff
+4 fc00:: fc00::ffff:ffff:ffff:ffff
+5 febf:ffff:ffff:ffff:: febf:ffff:ffff:ffff:ffff:ffff:ffff:ffff
+6 fe80:: fe80::ffff:ffff:ffff:ffff
+7 ffff:ffff:ffff:ffff:: ffff:ffff:ffff:ffff:ffff:ffff:ffff:ffff
+8 fe80:: fe80::ffff:ffff:ffff:ffff
+9 2001:4860:4860:: 2001:4860:4860:0:ffff:ffff:ffff:ffff
+10 2606:4700:4700:: 2606:4700:4700:0:ffff:ffff:ffff:ffff
+11 ff01:: ff01::ffff:ffff:ffff:ffff
+12 ff02:: ff02::ffff:ffff:ffff:ffff
+13 2001:db8:85a3:: 2001:db8:85a3:0:ffff:ffff:ffff:ffff
+14 2001:db8:: 2001:db8::ffff:ffff:ffff:ffff
+15 2001:db8:: 2001:db8::ffff:ffff:ffff:ffff
+16 :: ::ffff:ffff:ffff:ffff
+17 \N \N
+18 \N \N
+19 fd00:: fd00::ffff:ffff:ffff:ffff
+20 \N \N
+21 \N \N
+22 \N \N
+23 \N \N
+24 \N \N
+25 \N \N
+26 ff01:: ff01::ffff:ffff:ffff:ffff
+27 ff02:: ff02::ffff:ffff:ffff:ffff
+28 ff00:: ff00::ffff:ffff:ffff:ffff
+29 2001:db8:: 2001:db8::ffff:ffff:ffff:ffff
+30 2001:db8:: 2001:db8::ffff:ffff:ffff:ffff
+31 2001:db8:: 2001:db8::ffff:ffff:ffff:ffff
+32 2001:db8:: 2001:db8::ffff:ffff:ffff:ffff
+33 2001:db8:: 2001:db8::ffff:ffff:ffff:ffff
+34 2001:db8:: 2001:db8::ffff:ffff:ffff:ffff
+35 2001:db8:: 2001:db8::ffff:ffff:ffff:ffff
+36 2001:db8:: 2001:db8::ffff:ffff:ffff:ffff
+37 2001:db8:: 2001:db8::ffff:ffff:ffff:ffff
+38 2001:db8:: 2001:db8::ffff:ffff:ffff:ffff
+39 2001:db8:: 2001:db8::ffff:ffff:ffff:ffff
+40 2001:db8:: 2001:db8::ffff:ffff:ffff:ffff
+41 2001:db8:: 2001:db8::ffff:ffff:ffff:ffff
+42 2001:db8:: 2001:db8::ffff:ffff:ffff:ffff
+43 2001:db8:: 2001:db8::ffff:ffff:ffff:ffff
+44 2001:db8:: 2001:db8::ffff:ffff:ffff:ffff
+45 2001:db8:: 2001:db8::ffff:ffff:ffff:ffff
+46 2001:db8:: 2001:db8::ffff:ffff:ffff:ffff
+47 2001:db8:: 2001:db8::ffff:ffff:ffff:ffff
+48 2001:db8:: 2001:db8::ffff:ffff:ffff:ffff
+49 2001:db8:: 2001:db8::ffff:ffff:ffff:ffff
+50 2001:db8:: 2001:db8::ffff:ffff:ffff:ffff
+51 2001:db8:: 2001:db8::ffff:ffff:ffff:ffff
+52 2001:db8:: 2001:db8::ffff:ffff:ffff:ffff
+53 2001:db8:: 2001:db8::ffff:ffff:ffff:ffff
+54 2001:db8:: 2001:db8::ffff:ffff:ffff:ffff
+55 2001:db8:: 2001:db8::ffff:ffff:ffff:ffff
+56 2001:db8:: 2001:db8::ffff:ffff:ffff:ffff
+57 2001:db8:: 2001:db8::ffff:ffff:ffff:ffff
+58 2001:db8:: 2001:db8::ffff:ffff:ffff:ffff
+59 2001:db8:: 2001:db8::ffff:ffff:ffff:ffff
+60 2001:db8:: 2001:db8::ffff:ffff:ffff:ffff
+61 2001:db8:: 2001:db8::ffff:ffff:ffff:ffff
+62 2001:db8:: 2001:db8::ffff:ffff:ffff:ffff
+63 2001:db8:: 2001:db8::ffff:ffff:ffff:ffff
+64 2001:db8:: 2001:db8::ffff:ffff:ffff:ffff
+65 2001:db8:: 2001:db8::ffff:ffff:ffff:ffff
+66 2001:db8:: 2001:db8::ffff:ffff:ffff:ffff
+67 2001:db8:: 2001:db8::ffff:ffff:ffff:ffff
+68 2001:db8:: 2001:db8::ffff:ffff:ffff:ffff
+69 2001:db8:: 2001:db8::ffff:ffff:ffff:ffff
+70 2001:db8:: 2001:db8::ffff:ffff:ffff:ffff
+71 2001:db8:: 2001:db8::ffff:ffff:ffff:ffff
+72 2001:db8:: 2001:db8::ffff:ffff:ffff:ffff
+73 2001:db8:: 2001:db8::ffff:ffff:ffff:ffff
+74 2001:db8:: 2001:db8::ffff:ffff:ffff:ffff
+75 2001:db8:: 2001:db8::ffff:ffff:ffff:ffff
+76 2001:db8:: 2001:db8::ffff:ffff:ffff:ffff
+77 2001:db8:: 2001:db8::ffff:ffff:ffff:ffff
+78 2001:db8:: 2001:db8::ffff:ffff:ffff:ffff
+79 2001:db8:: 2001:db8::ffff:ffff:ffff:ffff
+80 2001:db8:: 2001:db8::ffff:ffff:ffff:ffff
+81 2001:db8:: 2001:db8::ffff:ffff:ffff:ffff
+82 2001:db8:: 2001:db8::ffff:ffff:ffff:ffff
+83 2001:db8:: 2001:db8::ffff:ffff:ffff:ffff
+84 2001:db8:: 2001:db8::ffff:ffff:ffff:ffff
+85 2001:db8:: 2001:db8::ffff:ffff:ffff:ffff
+86 2001:db8:: 2001:db8::ffff:ffff:ffff:ffff
+87 2001:db8:: 2001:db8::ffff:ffff:ffff:ffff
+88 ff01:: ff01::ffff:ffff:ffff:ffff
+89 ff01:: ff01::ffff:ffff:ffff:ffff
+90 ff01:: ff01::ffff:ffff:ffff:ffff
+91 ff01:: ff01::ffff:ffff:ffff:ffff
+92 ff01:: ff01::ffff:ffff:ffff:ffff
+93 ff01:: ff01::ffff:ffff:ffff:ffff
+94 ff01:: ff01::ffff:ffff:ffff:ffff
+95 ff01:: ff01::ffff:ffff:ffff:ffff
+96 ff01:: ff01::ffff:ffff:ffff:ffff
+97 ff01:: ff01::ffff:ffff:ffff:ffff
+98 ff01:: ff01::ffff:ffff:ffff:ffff
+99 ff01:: ff01::ffff:ffff:ffff:ffff
+100 ff01:: ff01::ffff:ffff:ffff:ffff
+
+-- !sql_cidr_ipv4 --
+1 127.0.0.1 127.0.0.1
+2 10.0.0.0 10.0.0.0
+3 10.255.255.255 10.255.255.255
+4 172.16.0.0 172.16.0.0
+5 172.31.255.255 172.31.255.255
+6 192.168.0.0 192.168.0.0
+7 192.168.255.255 192.168.255.255
+8 169.254.0.0 169.254.0.0
+9 8.8.8.8 8.8.8.8
+10 1.1.1.1 1.1.1.1
+11 224.0.0.0 224.0.0.0
+12 239.255.255.255 239.255.255.255
+13 192.0.2.0 192.0.2.0
+14 203.0.113.0 203.0.113.0
+15 198.51.100.0 198.51.100.0
+16 \N \N
+17 240.0.0.0 240.0.0.0
+18 255.255.255.255 255.255.255.255
+19 \N \N
+20 0.0.0.0 0.0.0.0
+21 127.255.255.255 127.255.255.255
+22 128.0.0.0 128.0.0.0
+23 191.255.255.255 191.255.255.255
+24 192.0.0.0 192.0.0.0
+25 223.255.255.255 223.255.255.255
+26 224.0.0.0 224.0.0.0
+27 239.255.255.255 239.255.255.255
+28 \N \N
+29 0.0.0.1 0.0.0.1
+30 0.0.1.10 0.0.1.10
+31 0.0.2.20 0.0.2.20
+32 0.0.3.30 0.0.3.30
+33 10.0.0.5 10.0.0.5
+34 10.0.1.15 10.0.1.15
+35 10.1.0.25 10.1.0.25
+36 10.2.0.35 10.2.0.35
+37 10.3.0.45 10.3.0.45
+38 10.4.0.55 10.4.0.55
+39 10.5.0.65 10.5.0.65
+40 10.6.0.75 10.6.0.75
+41 10.7.0.85 10.7.0.85
+42 10.8.0.95 10.8.0.95
+43 10.9.1.5 10.9.1.5
+44 10.10.1.15 10.10.1.15
+45 10.11.1.25 10.11.1.25
+46 10.12.1.35 10.12.1.35
+47 10.13.1.45 10.13.1.45
+48 10.14.1.55 10.14.1.55
+49 10.15.1.65 10.15.1.65
+50 10.16.1.75 10.16.1.75
+51 128.0.0.1 128.0.0.1
+52 128.1.0.10 128.1.0.10
+53 128.2.0.20 128.2.0.20
+54 128.3.0.30 128.3.0.30
+55 128.4.0.40 128.4.0.40
+56 128.5.0.50 128.5.0.50
+57 128.6.0.60 128.6.0.60
+58 128.7.0.70 128.7.0.70
+59 128.8.0.80 128.8.0.80
+60 128.9.0.90 128.9.0.90
+61 172.16.0.1 172.16.0.1
+62 172.16.0.5 172.16.0.5
+63 172.16.0.10 172.16.0.10
+64 172.16.0.15 172.16.0.15
+65 172.16.0.20 172.16.0.20
+66 172.16.0.25 172.16.0.25
+67 172.16.0.30 172.16.0.30
+68 172.16.0.35 172.16.0.35
+69 192.0.0.1 192.0.0.1
+70 192.0.0.2 192.0.0.2
+71 192.0.0.3 192.0.0.3
+72 192.0.0.4 192.0.0.4
+73 192.0.0.5 192.0.0.5
+74 192.0.0.6 192.0.0.6
+75 192.0.0.7 192.0.0.7
+76 192.0.0.8 192.0.0.8
+77 192.0.0.9 192.0.0.9
+78 192.0.0.10 192.0.0.10
+79 192.168.0.1 192.168.0.1
+80 192.168.0.2 192.168.0.2
+81 192.168.1.5 192.168.1.5
+82 192.168.1.10 192.168.1.10
+83 192.168.1.15 192.168.1.15
+84 192.168.1.20 192.168.1.20
+85 192.168.2.5 192.168.2.5
+86 192.168.2.10 192.168.2.10
+87 192.168.5.20 192.168.5.20
+88 224.0.0.1 224.0.0.1
+89 224.0.0.2 224.0.0.2
+90 224.0.0.3 224.0.0.3
+91 224.0.0.4 224.0.0.4
+92 224.0.0.5 224.0.0.5
+93 224.0.0.6 224.0.0.6
+94 224.0.0.7 224.0.0.7
+95 224.0.0.8 224.0.0.8
+96 224.0.0.9 224.0.0.9
+97 224.0.0.10 224.0.0.10
+98 224.0.0.11 224.0.0.11
+99 224.0.0.12 224.0.0.12
+100 224.0.0.13 224.0.0.13
+
+-- !sql_cidr_ipv6_all --
+1 {"min":"::", "max":"0:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+2 {"min":"fc00::", "max":"fc00:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+3 {"min":"fdff::", "max":"fdff:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+4 {"min":"fc00::", "max":"fc00:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+5 {"min":"febf::", "max":"febf:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+6 {"min":"fe80::", "max":"fe80:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+7 {"min":"ffff::", "max":"ffff:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+8 {"min":"fe80::", "max":"fe80:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+9 {"min":"2001::", "max":"2001:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+10 {"min":"2606::", "max":"2606:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+11 {"min":"ff01::", "max":"ff01:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+12 {"min":"ff02::", "max":"ff02:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+13 {"min":"2001::", "max":"2001:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+14 {"min":"2001::", "max":"2001:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+15 {"min":"2001::", "max":"2001:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+16 {"min":"::", "max":"0:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+17 \N
+18 \N
+19 {"min":"fd00::", "max":"fd00:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+20 \N
+21 \N
+22 \N
+23 \N
+24 \N
+25 \N
+26 {"min":"ff01::", "max":"ff01:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+27 {"min":"ff02::", "max":"ff02:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+28 {"min":"ff00::", "max":"ff00:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+29 {"min":"2001::", "max":"2001:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+30 {"min":"2001::", "max":"2001:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+31 {"min":"2001::", "max":"2001:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+32 {"min":"2001::", "max":"2001:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+33 {"min":"2001::", "max":"2001:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+34 {"min":"2001::", "max":"2001:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+35 {"min":"2001::", "max":"2001:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+36 {"min":"2001::", "max":"2001:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+37 {"min":"2001::", "max":"2001:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+38 {"min":"2001::", "max":"2001:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+39 {"min":"2001::", "max":"2001:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+40 {"min":"2001::", "max":"2001:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+41 {"min":"2001::", "max":"2001:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+42 {"min":"2001::", "max":"2001:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+43 {"min":"2001::", "max":"2001:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+44 {"min":"2001::", "max":"2001:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+45 {"min":"2001::", "max":"2001:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+46 {"min":"2001::", "max":"2001:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+47 {"min":"2001::", "max":"2001:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+48 {"min":"2001::", "max":"2001:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+49 {"min":"2001::", "max":"2001:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+50 {"min":"2001::", "max":"2001:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+51 {"min":"2001::", "max":"2001:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+52 {"min":"2001::", "max":"2001:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+53 {"min":"2001::", "max":"2001:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+54 {"min":"2001::", "max":"2001:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+55 {"min":"2001::", "max":"2001:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+56 {"min":"2001::", "max":"2001:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+57 {"min":"2001::", "max":"2001:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+58 {"min":"2001::", "max":"2001:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+59 {"min":"2001::", "max":"2001:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+60 {"min":"2001::", "max":"2001:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+61 {"min":"2001::", "max":"2001:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+62 {"min":"2001::", "max":"2001:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+63 {"min":"2001::", "max":"2001:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+64 {"min":"2001::", "max":"2001:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+65 {"min":"2001::", "max":"2001:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+66 {"min":"2001::", "max":"2001:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+67 {"min":"2001::", "max":"2001:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+68 {"min":"2001::", "max":"2001:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+69 {"min":"2001::", "max":"2001:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+70 {"min":"2001::", "max":"2001:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+71 {"min":"2001::", "max":"2001:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+72 {"min":"2001::", "max":"2001:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+73 {"min":"2001::", "max":"2001:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+74 {"min":"2001::", "max":"2001:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+75 {"min":"2001::", "max":"2001:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+76 {"min":"2001::", "max":"2001:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+77 {"min":"2001::", "max":"2001:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+78 {"min":"2001::", "max":"2001:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+79 {"min":"2001::", "max":"2001:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+80 {"min":"2001::", "max":"2001:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+81 {"min":"2001::", "max":"2001:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+82 {"min":"2001::", "max":"2001:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+83 {"min":"2001::", "max":"2001:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+84 {"min":"2001::", "max":"2001:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+85 {"min":"2001::", "max":"2001:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+86 {"min":"2001::", "max":"2001:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+87 {"min":"2001::", "max":"2001:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+88 {"min":"ff01::", "max":"ff01:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+89 {"min":"ff01::", "max":"ff01:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+90 {"min":"ff01::", "max":"ff01:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+91 {"min":"ff01::", "max":"ff01:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+92 {"min":"ff01::", "max":"ff01:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+93 {"min":"ff01::", "max":"ff01:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+94 {"min":"ff01::", "max":"ff01:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+95 {"min":"ff01::", "max":"ff01:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+96 {"min":"ff01::", "max":"ff01:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+97 {"min":"ff01::", "max":"ff01:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+98 {"min":"ff01::", "max":"ff01:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+99 {"min":"ff01::", "max":"ff01:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+100 {"min":"ff01::", "max":"ff01:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+
+-- !sql_cidr_ipv4_all --
+1 {"min":"127.0.0.0", "max":"127.0.255.255"}
+2 {"min":"10.0.0.0", "max":"10.0.255.255"}
+3 {"min":"10.255.0.0", "max":"10.255.255.255"}
+4 {"min":"172.16.0.0", "max":"172.16.255.255"}
+5 {"min":"172.31.0.0", "max":"172.31.255.255"}
+6 {"min":"192.168.0.0", "max":"192.168.255.255"}
+7 {"min":"192.168.0.0", "max":"192.168.255.255"}
+8 {"min":"169.254.0.0", "max":"169.254.255.255"}
+9 {"min":"8.8.0.0", "max":"8.8.255.255"}
+10 {"min":"1.1.0.0", "max":"1.1.255.255"}
+11 {"min":"224.0.0.0", "max":"224.0.255.255"}
+12 {"min":"239.255.0.0", "max":"239.255.255.255"}
+13 {"min":"192.0.0.0", "max":"192.0.255.255"}
+14 {"min":"203.0.0.0", "max":"203.0.255.255"}
+15 {"min":"198.51.0.0", "max":"198.51.255.255"}
+16 \N
+17 {"min":"240.0.0.0", "max":"240.0.255.255"}
+18 {"min":"255.255.0.0", "max":"255.255.255.255"}
+19 \N
+20 {"min":"0.0.0.0", "max":"0.0.255.255"}
+21 {"min":"127.255.0.0", "max":"127.255.255.255"}
+22 {"min":"128.0.0.0", "max":"128.0.255.255"}
+23 {"min":"191.255.0.0", "max":"191.255.255.255"}
+24 {"min":"192.0.0.0", "max":"192.0.255.255"}
+25 {"min":"223.255.0.0", "max":"223.255.255.255"}
+26 {"min":"224.0.0.0", "max":"224.0.255.255"}
+27 {"min":"239.255.0.0", "max":"239.255.255.255"}
+28 \N
+29 {"min":"0.0.0.0", "max":"0.0.255.255"}
+30 {"min":"0.0.0.0", "max":"0.0.255.255"}
+31 {"min":"0.0.0.0", "max":"0.0.255.255"}
+32 {"min":"0.0.0.0", "max":"0.0.255.255"}
+33 {"min":"10.0.0.0", "max":"10.0.255.255"}
+34 {"min":"10.0.0.0", "max":"10.0.255.255"}
+35 {"min":"10.1.0.0", "max":"10.1.255.255"}
+36 {"min":"10.2.0.0", "max":"10.2.255.255"}
+37 {"min":"10.3.0.0", "max":"10.3.255.255"}
+38 {"min":"10.4.0.0", "max":"10.4.255.255"}
+39 {"min":"10.5.0.0", "max":"10.5.255.255"}
+40 {"min":"10.6.0.0", "max":"10.6.255.255"}
+41 {"min":"10.7.0.0", "max":"10.7.255.255"}
+42 {"min":"10.8.0.0", "max":"10.8.255.255"}
+43 {"min":"10.9.0.0", "max":"10.9.255.255"}
+44 {"min":"10.10.0.0", "max":"10.10.255.255"}
+45 {"min":"10.11.0.0", "max":"10.11.255.255"}
+46 {"min":"10.12.0.0", "max":"10.12.255.255"}
+47 {"min":"10.13.0.0", "max":"10.13.255.255"}
+48 {"min":"10.14.0.0", "max":"10.14.255.255"}
+49 {"min":"10.15.0.0", "max":"10.15.255.255"}
+50 {"min":"10.16.0.0", "max":"10.16.255.255"}
+51 {"min":"128.0.0.0", "max":"128.0.255.255"}
+52 {"min":"128.1.0.0", "max":"128.1.255.255"}
+53 {"min":"128.2.0.0", "max":"128.2.255.255"}
+54 {"min":"128.3.0.0", "max":"128.3.255.255"}
+55 {"min":"128.4.0.0", "max":"128.4.255.255"}
+56 {"min":"128.5.0.0", "max":"128.5.255.255"}
+57 {"min":"128.6.0.0", "max":"128.6.255.255"}
+58 {"min":"128.7.0.0", "max":"128.7.255.255"}
+59 {"min":"128.8.0.0", "max":"128.8.255.255"}
+60 {"min":"128.9.0.0", "max":"128.9.255.255"}
+61 {"min":"172.16.0.0", "max":"172.16.255.255"}
+62 {"min":"172.16.0.0", "max":"172.16.255.255"}
+63 {"min":"172.16.0.0", "max":"172.16.255.255"}
+64 {"min":"172.16.0.0", "max":"172.16.255.255"}
+65 {"min":"172.16.0.0", "max":"172.16.255.255"}
+66 {"min":"172.16.0.0", "max":"172.16.255.255"}
+67 {"min":"172.16.0.0", "max":"172.16.255.255"}
+68 {"min":"172.16.0.0", "max":"172.16.255.255"}
+69 {"min":"192.0.0.0", "max":"192.0.255.255"}
+70 {"min":"192.0.0.0", "max":"192.0.255.255"}
+71 {"min":"192.0.0.0", "max":"192.0.255.255"}
+72 {"min":"192.0.0.0", "max":"192.0.255.255"}
+73 {"min":"192.0.0.0", "max":"192.0.255.255"}
+74 {"min":"192.0.0.0", "max":"192.0.255.255"}
+75 {"min":"192.0.0.0", "max":"192.0.255.255"}
+76 {"min":"192.0.0.0", "max":"192.0.255.255"}
+77 {"min":"192.0.0.0", "max":"192.0.255.255"}
+78 {"min":"192.0.0.0", "max":"192.0.255.255"}
+79 {"min":"192.168.0.0", "max":"192.168.255.255"}
+80 {"min":"192.168.0.0", "max":"192.168.255.255"}
+81 {"min":"192.168.0.0", "max":"192.168.255.255"}
+82 {"min":"192.168.0.0", "max":"192.168.255.255"}
+83 {"min":"192.168.0.0", "max":"192.168.255.255"}
+84 {"min":"192.168.0.0", "max":"192.168.255.255"}
+85 {"min":"192.168.0.0", "max":"192.168.255.255"}
+86 {"min":"192.168.0.0", "max":"192.168.255.255"}
+87 {"min":"192.168.0.0", "max":"192.168.255.255"}
+88 {"min":"224.0.0.0", "max":"224.0.255.255"}
+89 {"min":"224.0.0.0", "max":"224.0.255.255"}
+90 {"min":"224.0.0.0", "max":"224.0.255.255"}
+91 {"min":"224.0.0.0", "max":"224.0.255.255"}
+92 {"min":"224.0.0.0", "max":"224.0.255.255"}
+93 {"min":"224.0.0.0", "max":"224.0.255.255"}
+94 {"min":"224.0.0.0", "max":"224.0.255.255"}
+95 {"min":"224.0.0.0", "max":"224.0.255.255"}
+96 {"min":"224.0.0.0", "max":"224.0.255.255"}
+97 {"min":"224.0.0.0", "max":"224.0.255.255"}
+98 {"min":"224.0.0.0", "max":"224.0.255.255"}
+99 {"min":"224.0.0.0", "max":"224.0.255.255"}
+100 {"min":"224.0.0.0", "max":"224.0.255.255"}
+
+-- !sql_num2string_ipv6 --
+1 ::1
+2 fc00::
+3 fdff:ffff:ffff:ffff:ffff:ffff:ffff:ffff
+4 fc00::
+5 febf:ffff:ffff:ffff:ffff:ffff:ffff:ffff
+6 fe80::
+7 ffff:ffff:ffff:ffff:ffff:ffff:ffff:ffff
+8 fe80::
+9 2001:4860:4860::8888
+10 2606:4700:4700::1111
+11 ff01::
+12 ff02::1
+13 2001:db8:85a3::8a2e:370:7334
+14 2001:db8::1
+15 2001:db8::2
+16 ::1
+17 ::
+18 ::
+19 fd00::
+20 ::
+21 ::
+22 ::
+23 ::
+24 ::
+25 ::
+26 ff01::
+27 ff02::1
+28 ff00::
+29 2001:db8::1
+30 2001:db8::2
+31 2001:db8::3
+32 2001:db8::4
+33 2001:db8::5
+34 2001:db8::6
+35 2001:db8::7
+36 2001:db8::8
+37 2001:db8::9
+38 2001:db8::a
+39 2001:db8::b
+40 2001:db8::c
+41 2001:db8::d
+42 2001:db8::e
+43 2001:db8::f
+44 2001:db8::10
+45 2001:db8::11
+46 2001:db8::12
+47 2001:db8::13
+48 2001:db8::14
+49 2001:db8::15
+50 2001:db8::16
+51 2001:db8::17
+52 2001:db8::18
+53 2001:db8::19
+54 2001:db8::1a
+55 2001:db8::1b
+56 2001:db8::1c
+57 2001:db8::1d
+58 2001:db8::1e
+59 2001:db8::1f
+60 2001:db8::20
+61 2001:db8::21
+62 2001:db8::22
+63 2001:db8::23
+64 2001:db8::24
+65 2001:db8::25
+66 2001:db8::26
+67 2001:db8::27
+68 2001:db8::28
+69 2001:db8::29
+70 2001:db8::2a
+71 2001:db8::2b
+72 2001:db8::2c
+73 2001:db8::2d
+74 2001:db8::2e
+75 2001:db8::2f
+76 2001:db8::30
+77 2001:db8::31
+78 2001:db8::32
+79 2001:db8::33
+80 2001:db8::34
+81 2001:db8::35
+82 2001:db8::36
+83 2001:db8::37
+84 2001:db8::38
+85 2001:db8::39
+86 2001:db8::3a
+87 2001:db8::3b
+88 ff01::1
+89 ff01::2
+90 ff01::3
+91 ff01::4
+92 ff01::5
+93 ff01::6
+94 ff01::7
+95 ff01::8
+96 ff01::9
+97 ff01::a
+98 ff01::b
+99 ff01::c
+100 ff01::d
+
+-- !sql_num2string_ipv4 --
+1 127.0.0.1
+2 10.0.0.0
+3 10.255.255.255
+4 172.16.0.0
+5 172.31.255.255
+6 192.168.0.0
+7 192.168.255.255
+8 169.254.0.0
+9 8.8.8.8
+10 1.1.1.1
+11 224.0.0.0
+12 239.255.255.255
+13 192.0.2.0
+14 203.0.113.0
+15 198.51.100.0
+16 0.0.0.0
+17 240.0.0.0
+18 255.255.255.255
+19 0.0.0.0
+20 0.0.0.0
+21 127.255.255.255
+22 128.0.0.0
+23 191.255.255.255
+24 192.0.0.0
+25 223.255.255.255
+26 224.0.0.0
+27 239.255.255.255
+28 0.0.0.0
+29 0.0.0.1
+30 0.0.1.10
+31 0.0.2.20
+32 0.0.3.30
+33 10.0.0.5
+34 10.0.1.15
+35 10.1.0.25
+36 10.2.0.35
+37 10.3.0.45
+38 10.4.0.55
+39 10.5.0.65
+40 10.6.0.75
+41 10.7.0.85
+42 10.8.0.95
+43 10.9.1.5
+44 10.10.1.15
+45 10.11.1.25
+46 10.12.1.35
+47 10.13.1.45
+48 10.14.1.55
+49 10.15.1.65
+50 10.16.1.75
+51 128.0.0.1
+52 128.1.0.10
+53 128.2.0.20
+54 128.3.0.30
+55 128.4.0.40
+56 128.5.0.50
+57 128.6.0.60
+58 128.7.0.70
+59 128.8.0.80
+60 128.9.0.90
+61 172.16.0.1
+62 172.16.0.5
+63 172.16.0.10
+64 172.16.0.15
+65 172.16.0.20
+66 172.16.0.25
+67 172.16.0.30
+68 172.16.0.35
+69 192.0.0.1
+70 192.0.0.2
+71 192.0.0.3
+72 192.0.0.4
+73 192.0.0.5
+74 192.0.0.6
+75 192.0.0.7
+76 192.0.0.8
+77 192.0.0.9
+78 192.0.0.10
+79 192.168.0.1
+80 192.168.0.2
+81 192.168.1.5
+82 192.168.1.10
+83 192.168.1.15
+84 192.168.1.20
+85 192.168.2.5
+86 192.168.2.10
+87 192.168.5.20
+88 224.0.0.1
+89 224.0.0.2
+90 224.0.0.3
+91 224.0.0.4
+92 224.0.0.5
+93 224.0.0.6
+94 224.0.0.7
+95 224.0.0.8
+96 224.0.0.9
+97 224.0.0.10
+98 224.0.0.11
+99 224.0.0.12
+100 224.0.0.13
+
+-- !sql_inet6_ntoa --
+1 ::1
+2 fc00::
+3 fdff:ffff:ffff:ffff:ffff:ffff:ffff:ffff
+4 fc00::
+5 febf:ffff:ffff:ffff:ffff:ffff:ffff:ffff
+6 fe80::
+7 ffff:ffff:ffff:ffff:ffff:ffff:ffff:ffff
+8 fe80::
+9 2001:4860:4860::8888
+10 2606:4700:4700::1111
+11 ff01::
+12 ff02::1
+13 2001:db8:85a3::8a2e:370:7334
+14 2001:db8::1
+15 2001:db8::2
+16 ::1
+17 ::
+18 ::
+19 fd00::
+20 ::
+21 ::
+22 ::
+23 ::
+24 ::
+25 ::
+26 ff01::
+27 ff02::1
+28 ff00::
+29 2001:db8::1
+30 2001:db8::2
+31 2001:db8::3
+32 2001:db8::4
+33 2001:db8::5
+34 2001:db8::6
+35 2001:db8::7
+36 2001:db8::8
+37 2001:db8::9
+38 2001:db8::a
+39 2001:db8::b
+40 2001:db8::c
+41 2001:db8::d
+42 2001:db8::e
+43 2001:db8::f
+44 2001:db8::10
+45 2001:db8::11
+46 2001:db8::12
+47 2001:db8::13
+48 2001:db8::14
+49 2001:db8::15
+50 2001:db8::16
+51 2001:db8::17
+52 2001:db8::18
+53 2001:db8::19
+54 2001:db8::1a
+55 2001:db8::1b
+56 2001:db8::1c
+57 2001:db8::1d
+58 2001:db8::1e
+59 2001:db8::1f
+60 2001:db8::20
+61 2001:db8::21
+62 2001:db8::22
+63 2001:db8::23
+64 2001:db8::24
+65 2001:db8::25
+66 2001:db8::26
+67 2001:db8::27
+68 2001:db8::28
+69 2001:db8::29
+70 2001:db8::2a
+71 2001:db8::2b
+72 2001:db8::2c
+73 2001:db8::2d
+74 2001:db8::2e
+75 2001:db8::2f
+76 2001:db8::30
+77 2001:db8::31
+78 2001:db8::32
+79 2001:db8::33
+80 2001:db8::34
+81 2001:db8::35
+82 2001:db8::36
+83 2001:db8::37
+84 2001:db8::38
+85 2001:db8::39
+86 2001:db8::3a
+87 2001:db8::3b
+88 ff01::1
+89 ff01::2
+90 ff01::3
+91 ff01::4
+92 ff01::5
+93 ff01::6
+94 ff01::7
+95 ff01::8
+96 ff01::9
+97 ff01::a
+98 ff01::b
+99 ff01::c
+100 ff01::d
+
+-- !sql_inet_ntoa --
+1 127.0.0.1
+2 10.0.0.0
+3 10.255.255.255
+4 172.16.0.0
+5 172.31.255.255
+6 192.168.0.0
+7 192.168.255.255
+8 169.254.0.0
+9 8.8.8.8
+10 1.1.1.1
+11 224.0.0.0
+12 239.255.255.255
+13 192.0.2.0
+14 203.0.113.0
+15 198.51.100.0
+16 0.0.0.0
+17 240.0.0.0
+18 255.255.255.255
+19 0.0.0.0
+20 0.0.0.0
+21 127.255.255.255
+22 128.0.0.0
+23 191.255.255.255
+24 192.0.0.0
+25 223.255.255.255
+26 224.0.0.0
+27 239.255.255.255
+28 0.0.0.0
+29 0.0.0.1
+30 0.0.1.10
+31 0.0.2.20
+32 0.0.3.30
+33 10.0.0.5
+34 10.0.1.15
+35 10.1.0.25
+36 10.2.0.35
+37 10.3.0.45
+38 10.4.0.55
+39 10.5.0.65
+40 10.6.0.75
+41 10.7.0.85
+42 10.8.0.95
+43 10.9.1.5
+44 10.10.1.15
+45 10.11.1.25
+46 10.12.1.35
+47 10.13.1.45
+48 10.14.1.55
+49 10.15.1.65
+50 10.16.1.75
+51 128.0.0.1
+52 128.1.0.10
+53 128.2.0.20
+54 128.3.0.30
+55 128.4.0.40
+56 128.5.0.50
+57 128.6.0.60
+58 128.7.0.70
+59 128.8.0.80
+60 128.9.0.90
+61 172.16.0.1
+62 172.16.0.5
+63 172.16.0.10
+64 172.16.0.15
+65 172.16.0.20
+66 172.16.0.25
+67 172.16.0.30
+68 172.16.0.35
+69 192.0.0.1
+70 192.0.0.2
+71 192.0.0.3
+72 192.0.0.4
+73 192.0.0.5
+74 192.0.0.6
+75 192.0.0.7
+76 192.0.0.8
+77 192.0.0.9
+78 192.0.0.10
+79 192.168.0.1
+80 192.168.0.2
+81 192.168.1.5
+82 192.168.1.10
+83 192.168.1.15
+84 192.168.1.20
+85 192.168.2.5
+86 192.168.2.10
+87 192.168.5.20
+88 224.0.0.1
+89 224.0.0.2
+90 224.0.0.3
+91 224.0.0.4
+92 224.0.0.5
+93 224.0.0.6
+94 224.0.0.7
+95 224.0.0.8
+96 224.0.0.9
+97 224.0.0.10
+98 224.0.0.11
+99 224.0.0.12
+100 224.0.0.13
+
+-- !sql_string2num_or_default_ipv6 --
+1 ���������������
+2 ����������������
+3 ����������������
+4 ����������������
+5 ����������������
+6 ����������������
+7 ����������������
+8 ����������������
+9 H`H`����������
+10 &G�G���������
+11 ���������������
+12 ��������������
+13 \r��������.ps4
+14 \r������������
+15 \r������������
+16 ���������������
+17 ����������������
+18 ����������������
+19 ����������������
+20 ����������������
+21 ����������������
+22 ����������������
+23 ����������������
+24 ����������������
+25 ����������������
+26 ���������������
+27 ��������������
+28 ����������������
+29 \r������������
+30 \r������������
+31 \r������������
+32 \r������������
+33 \r������������
+34 \r������������
+35 \r������������
+36 \r������������
+37 \r������������\
+38 \r������������\n
+39 \r������������
+40 \r������������
+41 \r������������\r
+42 \r������������
+43 \r������������
+44 \r������������
+45 \r������������
+46 \r������������
+47 \r������������
+48 \r������������
+49 \r������������
+50 \r������������
+51 \r������������
+52 \r������������
+53 \r������������
+54 \r������������
+55 \r������������
+56 \r������������
+57 \r������������
+58 \r������������
+59 \r������������
+60 \r������������
+61 \r������������!
+62 \r������������"
+63 \r������������#
+64 \r������������$
+65 \r������������%
+66 \r������������&
+67 \r������������'
+68 \r������������(
+69 \r������������)
+70 \r������������*
+71 \r������������+
+72 \r������������,
+73 \r������������-
+74 \r������������.
+75 \r������������/
+76 \r������������0
+77 \r������������1
+78 \r������������2
+79 \r������������3
+80 \r������������4
+81 \r������������5
+82 \r������������6
+83 \r������������7
+84 \r������������8
+85 \r������������9
+86 \r������������:
+87 \r������������;
+88 ��������������
+89 ��������������
+90 ��������������
+91 ��������������
+92 ��������������
+93 ��������������
+94 ��������������
+95 ��������������
+96 ��������������\
+97 ��������������\n
+98 ��������������
+99 ��������������
+100 ��������������\r
+
+-- !sql_string2num_or_default_ipv4 --
+1 2130706433
+2 167772160
+3 184549375
+4 2886729728
+5 2887778303
+6 3232235520
+7 3232301055
+8 2851995648
+9 134744072
+10 16843009
+11 3758096384
+12 4026531839
+13 3221225984
+14 3405803776
+15 3325256704
+16 0
+17 4026531840
+18 4294967295
+19 0
+20 0
+21 2147483647
+22 2147483648
+23 3221225471
+24 3221225472
+25 3758096383
+26 3758096384
+27 4026531839
+28 0
+29 1
+30 266
+31 532
+32 798
+33 167772165
+34 167772431
+35 167837721
+36 167903267
+37 167968813
+38 168034359
+39 168099905
+40 168165451
+41 168230997
+42 168296543
+43 168362245
+44 168427791
+45 168493337
+46 168558883
+47 168624429
+48 168689975
+49 168755521
+50 168821067
+51 2147483649
+52 2147549194
+53 2147614740
+54 2147680286
+55 2147745832
+56 2147811378
+57 2147876924
+58 2147942470
+59 2148008016
+60 2148073562
+61 2886729729
+62 2886729733
+63 2886729738
+64 2886729743
+65 2886729748
+66 2886729753
+67 2886729758
+68 2886729763
+69 3221225473
+70 3221225474
+71 3221225475
+72 3221225476
+73 3221225477
+74 3221225478
+75 3221225479
+76 3221225480
+77 3221225481
+78 3221225482
+79 3232235521
+80 3232235522
+81 3232235781
+82 3232235786
+83 3232235791
+84 3232235796
+85 3232236037
+86 3232236042
+87 3232236820
+88 3758096385
+89 3758096386
+90 3758096387
+91 3758096388
+92 3758096389
+93 3758096390
+94 3758096391
+95 3758096392
+96 3758096393
+97 3758096394
+98 3758096395
+99 3758096396
+100 3758096397
+
+-- !sql_string2num_or_null_ipv6 --
+1 ���������������
+2 ����������������
+3 ����������������
+4 ����������������
+5 ����������������
+6 ����������������
+7 ����������������
+8 ����������������
+9 H`H`����������
+10 &G�G���������
+11 ���������������
+12 ��������������
+13 \r��������.ps4
+14 \r������������
+15 \r������������
+16 ���������������
+17 \N
+18 \N
+19 ����������������
+20 \N
+21 \N
+22 \N
+23 \N
+24 \N
+25 \N
+26 ���������������
+27 ��������������
+28 ����������������
+29 \r������������
+30 \r������������
+31 \r������������
+32 \r������������
+33 \r������������
+34 \r������������
+35 \r������������
+36 \r������������
+37 \r������������\
+38 \r������������\n
+39 \r������������
+40 \r������������
+41 \r������������\r
+42 \r������������
+43 \r������������
+44 \r������������
+45 \r������������
+46 \r������������
+47 \r������������
+48 \r������������
+49 \r������������
+50 \r������������
+51 \r������������
+52 \r������������
+53 \r������������
+54 \r������������
+55 \r������������
+56 \r������������
+57 \r������������
+58 \r������������
+59 \r������������
+60 \r������������
+61 \r������������!
+62 \r������������"
+63 \r������������#
+64 \r������������$
Review Comment:
ditto
##########
regression-test/data/nereids_function_p0/fn_test_ip_special.csv:
##########
@@ -0,0 +1,28 @@
+1;127.0.0.1;::1
Review Comment:
add invalid ip format string for example 'aaaa', 'bbbb'
##########
regression-test/data/nereids_function_p0/scalar_function/IP.out:
##########
@@ -0,0 +1,3061 @@
+-- This file is automatically generated. You should know what you did if you
want to edit this
+-- !sql_cidr_ipv6 --
+1 :: ::ffff:ffff:ffff:ffff
+2 fc00:: fc00::ffff:ffff:ffff:ffff
+3 fdff:ffff:ffff:ffff:: fdff:ffff:ffff:ffff:ffff:ffff:ffff:ffff
+4 fc00:: fc00::ffff:ffff:ffff:ffff
+5 febf:ffff:ffff:ffff:: febf:ffff:ffff:ffff:ffff:ffff:ffff:ffff
+6 fe80:: fe80::ffff:ffff:ffff:ffff
+7 ffff:ffff:ffff:ffff:: ffff:ffff:ffff:ffff:ffff:ffff:ffff:ffff
+8 fe80:: fe80::ffff:ffff:ffff:ffff
+9 2001:4860:4860:: 2001:4860:4860:0:ffff:ffff:ffff:ffff
+10 2606:4700:4700:: 2606:4700:4700:0:ffff:ffff:ffff:ffff
+11 ff01:: ff01::ffff:ffff:ffff:ffff
+12 ff02:: ff02::ffff:ffff:ffff:ffff
+13 2001:db8:85a3:: 2001:db8:85a3:0:ffff:ffff:ffff:ffff
+14 2001:db8:: 2001:db8::ffff:ffff:ffff:ffff
+15 2001:db8:: 2001:db8::ffff:ffff:ffff:ffff
+16 :: ::ffff:ffff:ffff:ffff
+17 \N \N
+18 \N \N
+19 fd00:: fd00::ffff:ffff:ffff:ffff
+20 \N \N
+21 \N \N
+22 \N \N
+23 \N \N
+24 \N \N
+25 \N \N
+26 ff01:: ff01::ffff:ffff:ffff:ffff
+27 ff02:: ff02::ffff:ffff:ffff:ffff
+28 ff00:: ff00::ffff:ffff:ffff:ffff
+29 2001:db8:: 2001:db8::ffff:ffff:ffff:ffff
+30 2001:db8:: 2001:db8::ffff:ffff:ffff:ffff
+31 2001:db8:: 2001:db8::ffff:ffff:ffff:ffff
+32 2001:db8:: 2001:db8::ffff:ffff:ffff:ffff
+33 2001:db8:: 2001:db8::ffff:ffff:ffff:ffff
+34 2001:db8:: 2001:db8::ffff:ffff:ffff:ffff
+35 2001:db8:: 2001:db8::ffff:ffff:ffff:ffff
+36 2001:db8:: 2001:db8::ffff:ffff:ffff:ffff
+37 2001:db8:: 2001:db8::ffff:ffff:ffff:ffff
+38 2001:db8:: 2001:db8::ffff:ffff:ffff:ffff
+39 2001:db8:: 2001:db8::ffff:ffff:ffff:ffff
+40 2001:db8:: 2001:db8::ffff:ffff:ffff:ffff
+41 2001:db8:: 2001:db8::ffff:ffff:ffff:ffff
+42 2001:db8:: 2001:db8::ffff:ffff:ffff:ffff
+43 2001:db8:: 2001:db8::ffff:ffff:ffff:ffff
+44 2001:db8:: 2001:db8::ffff:ffff:ffff:ffff
+45 2001:db8:: 2001:db8::ffff:ffff:ffff:ffff
+46 2001:db8:: 2001:db8::ffff:ffff:ffff:ffff
+47 2001:db8:: 2001:db8::ffff:ffff:ffff:ffff
+48 2001:db8:: 2001:db8::ffff:ffff:ffff:ffff
+49 2001:db8:: 2001:db8::ffff:ffff:ffff:ffff
+50 2001:db8:: 2001:db8::ffff:ffff:ffff:ffff
+51 2001:db8:: 2001:db8::ffff:ffff:ffff:ffff
+52 2001:db8:: 2001:db8::ffff:ffff:ffff:ffff
+53 2001:db8:: 2001:db8::ffff:ffff:ffff:ffff
+54 2001:db8:: 2001:db8::ffff:ffff:ffff:ffff
+55 2001:db8:: 2001:db8::ffff:ffff:ffff:ffff
+56 2001:db8:: 2001:db8::ffff:ffff:ffff:ffff
+57 2001:db8:: 2001:db8::ffff:ffff:ffff:ffff
+58 2001:db8:: 2001:db8::ffff:ffff:ffff:ffff
+59 2001:db8:: 2001:db8::ffff:ffff:ffff:ffff
+60 2001:db8:: 2001:db8::ffff:ffff:ffff:ffff
+61 2001:db8:: 2001:db8::ffff:ffff:ffff:ffff
+62 2001:db8:: 2001:db8::ffff:ffff:ffff:ffff
+63 2001:db8:: 2001:db8::ffff:ffff:ffff:ffff
+64 2001:db8:: 2001:db8::ffff:ffff:ffff:ffff
+65 2001:db8:: 2001:db8::ffff:ffff:ffff:ffff
+66 2001:db8:: 2001:db8::ffff:ffff:ffff:ffff
+67 2001:db8:: 2001:db8::ffff:ffff:ffff:ffff
+68 2001:db8:: 2001:db8::ffff:ffff:ffff:ffff
+69 2001:db8:: 2001:db8::ffff:ffff:ffff:ffff
+70 2001:db8:: 2001:db8::ffff:ffff:ffff:ffff
+71 2001:db8:: 2001:db8::ffff:ffff:ffff:ffff
+72 2001:db8:: 2001:db8::ffff:ffff:ffff:ffff
+73 2001:db8:: 2001:db8::ffff:ffff:ffff:ffff
+74 2001:db8:: 2001:db8::ffff:ffff:ffff:ffff
+75 2001:db8:: 2001:db8::ffff:ffff:ffff:ffff
+76 2001:db8:: 2001:db8::ffff:ffff:ffff:ffff
+77 2001:db8:: 2001:db8::ffff:ffff:ffff:ffff
+78 2001:db8:: 2001:db8::ffff:ffff:ffff:ffff
+79 2001:db8:: 2001:db8::ffff:ffff:ffff:ffff
+80 2001:db8:: 2001:db8::ffff:ffff:ffff:ffff
+81 2001:db8:: 2001:db8::ffff:ffff:ffff:ffff
+82 2001:db8:: 2001:db8::ffff:ffff:ffff:ffff
+83 2001:db8:: 2001:db8::ffff:ffff:ffff:ffff
+84 2001:db8:: 2001:db8::ffff:ffff:ffff:ffff
+85 2001:db8:: 2001:db8::ffff:ffff:ffff:ffff
+86 2001:db8:: 2001:db8::ffff:ffff:ffff:ffff
+87 2001:db8:: 2001:db8::ffff:ffff:ffff:ffff
+88 ff01:: ff01::ffff:ffff:ffff:ffff
+89 ff01:: ff01::ffff:ffff:ffff:ffff
+90 ff01:: ff01::ffff:ffff:ffff:ffff
+91 ff01:: ff01::ffff:ffff:ffff:ffff
+92 ff01:: ff01::ffff:ffff:ffff:ffff
+93 ff01:: ff01::ffff:ffff:ffff:ffff
+94 ff01:: ff01::ffff:ffff:ffff:ffff
+95 ff01:: ff01::ffff:ffff:ffff:ffff
+96 ff01:: ff01::ffff:ffff:ffff:ffff
+97 ff01:: ff01::ffff:ffff:ffff:ffff
+98 ff01:: ff01::ffff:ffff:ffff:ffff
+99 ff01:: ff01::ffff:ffff:ffff:ffff
+100 ff01:: ff01::ffff:ffff:ffff:ffff
+
+-- !sql_cidr_ipv4 --
+1 127.0.0.1 127.0.0.1
+2 10.0.0.0 10.0.0.0
+3 10.255.255.255 10.255.255.255
+4 172.16.0.0 172.16.0.0
+5 172.31.255.255 172.31.255.255
+6 192.168.0.0 192.168.0.0
+7 192.168.255.255 192.168.255.255
+8 169.254.0.0 169.254.0.0
+9 8.8.8.8 8.8.8.8
+10 1.1.1.1 1.1.1.1
+11 224.0.0.0 224.0.0.0
+12 239.255.255.255 239.255.255.255
+13 192.0.2.0 192.0.2.0
+14 203.0.113.0 203.0.113.0
+15 198.51.100.0 198.51.100.0
+16 \N \N
+17 240.0.0.0 240.0.0.0
+18 255.255.255.255 255.255.255.255
+19 \N \N
+20 0.0.0.0 0.0.0.0
+21 127.255.255.255 127.255.255.255
+22 128.0.0.0 128.0.0.0
+23 191.255.255.255 191.255.255.255
+24 192.0.0.0 192.0.0.0
+25 223.255.255.255 223.255.255.255
+26 224.0.0.0 224.0.0.0
+27 239.255.255.255 239.255.255.255
+28 \N \N
+29 0.0.0.1 0.0.0.1
+30 0.0.1.10 0.0.1.10
+31 0.0.2.20 0.0.2.20
+32 0.0.3.30 0.0.3.30
+33 10.0.0.5 10.0.0.5
+34 10.0.1.15 10.0.1.15
+35 10.1.0.25 10.1.0.25
+36 10.2.0.35 10.2.0.35
+37 10.3.0.45 10.3.0.45
+38 10.4.0.55 10.4.0.55
+39 10.5.0.65 10.5.0.65
+40 10.6.0.75 10.6.0.75
+41 10.7.0.85 10.7.0.85
+42 10.8.0.95 10.8.0.95
+43 10.9.1.5 10.9.1.5
+44 10.10.1.15 10.10.1.15
+45 10.11.1.25 10.11.1.25
+46 10.12.1.35 10.12.1.35
+47 10.13.1.45 10.13.1.45
+48 10.14.1.55 10.14.1.55
+49 10.15.1.65 10.15.1.65
+50 10.16.1.75 10.16.1.75
+51 128.0.0.1 128.0.0.1
+52 128.1.0.10 128.1.0.10
+53 128.2.0.20 128.2.0.20
+54 128.3.0.30 128.3.0.30
+55 128.4.0.40 128.4.0.40
+56 128.5.0.50 128.5.0.50
+57 128.6.0.60 128.6.0.60
+58 128.7.0.70 128.7.0.70
+59 128.8.0.80 128.8.0.80
+60 128.9.0.90 128.9.0.90
+61 172.16.0.1 172.16.0.1
+62 172.16.0.5 172.16.0.5
+63 172.16.0.10 172.16.0.10
+64 172.16.0.15 172.16.0.15
+65 172.16.0.20 172.16.0.20
+66 172.16.0.25 172.16.0.25
+67 172.16.0.30 172.16.0.30
+68 172.16.0.35 172.16.0.35
+69 192.0.0.1 192.0.0.1
+70 192.0.0.2 192.0.0.2
+71 192.0.0.3 192.0.0.3
+72 192.0.0.4 192.0.0.4
+73 192.0.0.5 192.0.0.5
+74 192.0.0.6 192.0.0.6
+75 192.0.0.7 192.0.0.7
+76 192.0.0.8 192.0.0.8
+77 192.0.0.9 192.0.0.9
+78 192.0.0.10 192.0.0.10
+79 192.168.0.1 192.168.0.1
+80 192.168.0.2 192.168.0.2
+81 192.168.1.5 192.168.1.5
+82 192.168.1.10 192.168.1.10
+83 192.168.1.15 192.168.1.15
+84 192.168.1.20 192.168.1.20
+85 192.168.2.5 192.168.2.5
+86 192.168.2.10 192.168.2.10
+87 192.168.5.20 192.168.5.20
+88 224.0.0.1 224.0.0.1
+89 224.0.0.2 224.0.0.2
+90 224.0.0.3 224.0.0.3
+91 224.0.0.4 224.0.0.4
+92 224.0.0.5 224.0.0.5
+93 224.0.0.6 224.0.0.6
+94 224.0.0.7 224.0.0.7
+95 224.0.0.8 224.0.0.8
+96 224.0.0.9 224.0.0.9
+97 224.0.0.10 224.0.0.10
+98 224.0.0.11 224.0.0.11
+99 224.0.0.12 224.0.0.12
+100 224.0.0.13 224.0.0.13
+
+-- !sql_cidr_ipv6_all --
+1 {"min":"::", "max":"0:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+2 {"min":"fc00::", "max":"fc00:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+3 {"min":"fdff::", "max":"fdff:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+4 {"min":"fc00::", "max":"fc00:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+5 {"min":"febf::", "max":"febf:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+6 {"min":"fe80::", "max":"fe80:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+7 {"min":"ffff::", "max":"ffff:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+8 {"min":"fe80::", "max":"fe80:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+9 {"min":"2001::", "max":"2001:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+10 {"min":"2606::", "max":"2606:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+11 {"min":"ff01::", "max":"ff01:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+12 {"min":"ff02::", "max":"ff02:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+13 {"min":"2001::", "max":"2001:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+14 {"min":"2001::", "max":"2001:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+15 {"min":"2001::", "max":"2001:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+16 {"min":"::", "max":"0:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+17 \N
+18 \N
+19 {"min":"fd00::", "max":"fd00:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+20 \N
+21 \N
+22 \N
+23 \N
+24 \N
+25 \N
+26 {"min":"ff01::", "max":"ff01:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+27 {"min":"ff02::", "max":"ff02:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+28 {"min":"ff00::", "max":"ff00:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+29 {"min":"2001::", "max":"2001:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+30 {"min":"2001::", "max":"2001:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+31 {"min":"2001::", "max":"2001:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+32 {"min":"2001::", "max":"2001:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+33 {"min":"2001::", "max":"2001:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+34 {"min":"2001::", "max":"2001:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+35 {"min":"2001::", "max":"2001:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+36 {"min":"2001::", "max":"2001:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+37 {"min":"2001::", "max":"2001:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+38 {"min":"2001::", "max":"2001:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+39 {"min":"2001::", "max":"2001:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+40 {"min":"2001::", "max":"2001:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+41 {"min":"2001::", "max":"2001:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+42 {"min":"2001::", "max":"2001:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+43 {"min":"2001::", "max":"2001:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+44 {"min":"2001::", "max":"2001:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+45 {"min":"2001::", "max":"2001:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+46 {"min":"2001::", "max":"2001:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+47 {"min":"2001::", "max":"2001:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+48 {"min":"2001::", "max":"2001:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+49 {"min":"2001::", "max":"2001:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+50 {"min":"2001::", "max":"2001:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+51 {"min":"2001::", "max":"2001:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+52 {"min":"2001::", "max":"2001:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+53 {"min":"2001::", "max":"2001:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+54 {"min":"2001::", "max":"2001:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+55 {"min":"2001::", "max":"2001:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+56 {"min":"2001::", "max":"2001:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+57 {"min":"2001::", "max":"2001:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+58 {"min":"2001::", "max":"2001:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+59 {"min":"2001::", "max":"2001:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+60 {"min":"2001::", "max":"2001:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+61 {"min":"2001::", "max":"2001:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+62 {"min":"2001::", "max":"2001:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+63 {"min":"2001::", "max":"2001:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+64 {"min":"2001::", "max":"2001:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+65 {"min":"2001::", "max":"2001:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+66 {"min":"2001::", "max":"2001:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+67 {"min":"2001::", "max":"2001:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+68 {"min":"2001::", "max":"2001:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+69 {"min":"2001::", "max":"2001:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+70 {"min":"2001::", "max":"2001:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+71 {"min":"2001::", "max":"2001:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+72 {"min":"2001::", "max":"2001:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+73 {"min":"2001::", "max":"2001:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+74 {"min":"2001::", "max":"2001:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+75 {"min":"2001::", "max":"2001:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+76 {"min":"2001::", "max":"2001:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+77 {"min":"2001::", "max":"2001:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+78 {"min":"2001::", "max":"2001:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+79 {"min":"2001::", "max":"2001:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+80 {"min":"2001::", "max":"2001:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+81 {"min":"2001::", "max":"2001:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+82 {"min":"2001::", "max":"2001:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+83 {"min":"2001::", "max":"2001:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+84 {"min":"2001::", "max":"2001:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+85 {"min":"2001::", "max":"2001:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+86 {"min":"2001::", "max":"2001:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+87 {"min":"2001::", "max":"2001:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+88 {"min":"ff01::", "max":"ff01:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+89 {"min":"ff01::", "max":"ff01:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+90 {"min":"ff01::", "max":"ff01:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+91 {"min":"ff01::", "max":"ff01:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+92 {"min":"ff01::", "max":"ff01:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+93 {"min":"ff01::", "max":"ff01:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+94 {"min":"ff01::", "max":"ff01:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+95 {"min":"ff01::", "max":"ff01:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+96 {"min":"ff01::", "max":"ff01:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+97 {"min":"ff01::", "max":"ff01:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+98 {"min":"ff01::", "max":"ff01:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+99 {"min":"ff01::", "max":"ff01:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+100 {"min":"ff01::", "max":"ff01:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+
+-- !sql_cidr_ipv4_all --
+1 {"min":"127.0.0.0", "max":"127.0.255.255"}
+2 {"min":"10.0.0.0", "max":"10.0.255.255"}
+3 {"min":"10.255.0.0", "max":"10.255.255.255"}
+4 {"min":"172.16.0.0", "max":"172.16.255.255"}
+5 {"min":"172.31.0.0", "max":"172.31.255.255"}
+6 {"min":"192.168.0.0", "max":"192.168.255.255"}
+7 {"min":"192.168.0.0", "max":"192.168.255.255"}
+8 {"min":"169.254.0.0", "max":"169.254.255.255"}
+9 {"min":"8.8.0.0", "max":"8.8.255.255"}
+10 {"min":"1.1.0.0", "max":"1.1.255.255"}
+11 {"min":"224.0.0.0", "max":"224.0.255.255"}
+12 {"min":"239.255.0.0", "max":"239.255.255.255"}
+13 {"min":"192.0.0.0", "max":"192.0.255.255"}
+14 {"min":"203.0.0.0", "max":"203.0.255.255"}
+15 {"min":"198.51.0.0", "max":"198.51.255.255"}
+16 \N
+17 {"min":"240.0.0.0", "max":"240.0.255.255"}
+18 {"min":"255.255.0.0", "max":"255.255.255.255"}
+19 \N
+20 {"min":"0.0.0.0", "max":"0.0.255.255"}
+21 {"min":"127.255.0.0", "max":"127.255.255.255"}
+22 {"min":"128.0.0.0", "max":"128.0.255.255"}
+23 {"min":"191.255.0.0", "max":"191.255.255.255"}
+24 {"min":"192.0.0.0", "max":"192.0.255.255"}
+25 {"min":"223.255.0.0", "max":"223.255.255.255"}
+26 {"min":"224.0.0.0", "max":"224.0.255.255"}
+27 {"min":"239.255.0.0", "max":"239.255.255.255"}
+28 \N
+29 {"min":"0.0.0.0", "max":"0.0.255.255"}
+30 {"min":"0.0.0.0", "max":"0.0.255.255"}
+31 {"min":"0.0.0.0", "max":"0.0.255.255"}
+32 {"min":"0.0.0.0", "max":"0.0.255.255"}
+33 {"min":"10.0.0.0", "max":"10.0.255.255"}
+34 {"min":"10.0.0.0", "max":"10.0.255.255"}
+35 {"min":"10.1.0.0", "max":"10.1.255.255"}
+36 {"min":"10.2.0.0", "max":"10.2.255.255"}
+37 {"min":"10.3.0.0", "max":"10.3.255.255"}
+38 {"min":"10.4.0.0", "max":"10.4.255.255"}
+39 {"min":"10.5.0.0", "max":"10.5.255.255"}
+40 {"min":"10.6.0.0", "max":"10.6.255.255"}
+41 {"min":"10.7.0.0", "max":"10.7.255.255"}
+42 {"min":"10.8.0.0", "max":"10.8.255.255"}
+43 {"min":"10.9.0.0", "max":"10.9.255.255"}
+44 {"min":"10.10.0.0", "max":"10.10.255.255"}
+45 {"min":"10.11.0.0", "max":"10.11.255.255"}
+46 {"min":"10.12.0.0", "max":"10.12.255.255"}
+47 {"min":"10.13.0.0", "max":"10.13.255.255"}
+48 {"min":"10.14.0.0", "max":"10.14.255.255"}
+49 {"min":"10.15.0.0", "max":"10.15.255.255"}
+50 {"min":"10.16.0.0", "max":"10.16.255.255"}
+51 {"min":"128.0.0.0", "max":"128.0.255.255"}
+52 {"min":"128.1.0.0", "max":"128.1.255.255"}
+53 {"min":"128.2.0.0", "max":"128.2.255.255"}
+54 {"min":"128.3.0.0", "max":"128.3.255.255"}
+55 {"min":"128.4.0.0", "max":"128.4.255.255"}
+56 {"min":"128.5.0.0", "max":"128.5.255.255"}
+57 {"min":"128.6.0.0", "max":"128.6.255.255"}
+58 {"min":"128.7.0.0", "max":"128.7.255.255"}
+59 {"min":"128.8.0.0", "max":"128.8.255.255"}
+60 {"min":"128.9.0.0", "max":"128.9.255.255"}
+61 {"min":"172.16.0.0", "max":"172.16.255.255"}
+62 {"min":"172.16.0.0", "max":"172.16.255.255"}
+63 {"min":"172.16.0.0", "max":"172.16.255.255"}
+64 {"min":"172.16.0.0", "max":"172.16.255.255"}
+65 {"min":"172.16.0.0", "max":"172.16.255.255"}
+66 {"min":"172.16.0.0", "max":"172.16.255.255"}
+67 {"min":"172.16.0.0", "max":"172.16.255.255"}
+68 {"min":"172.16.0.0", "max":"172.16.255.255"}
+69 {"min":"192.0.0.0", "max":"192.0.255.255"}
+70 {"min":"192.0.0.0", "max":"192.0.255.255"}
+71 {"min":"192.0.0.0", "max":"192.0.255.255"}
+72 {"min":"192.0.0.0", "max":"192.0.255.255"}
+73 {"min":"192.0.0.0", "max":"192.0.255.255"}
+74 {"min":"192.0.0.0", "max":"192.0.255.255"}
+75 {"min":"192.0.0.0", "max":"192.0.255.255"}
+76 {"min":"192.0.0.0", "max":"192.0.255.255"}
+77 {"min":"192.0.0.0", "max":"192.0.255.255"}
+78 {"min":"192.0.0.0", "max":"192.0.255.255"}
+79 {"min":"192.168.0.0", "max":"192.168.255.255"}
+80 {"min":"192.168.0.0", "max":"192.168.255.255"}
+81 {"min":"192.168.0.0", "max":"192.168.255.255"}
+82 {"min":"192.168.0.0", "max":"192.168.255.255"}
+83 {"min":"192.168.0.0", "max":"192.168.255.255"}
+84 {"min":"192.168.0.0", "max":"192.168.255.255"}
+85 {"min":"192.168.0.0", "max":"192.168.255.255"}
+86 {"min":"192.168.0.0", "max":"192.168.255.255"}
+87 {"min":"192.168.0.0", "max":"192.168.255.255"}
+88 {"min":"224.0.0.0", "max":"224.0.255.255"}
+89 {"min":"224.0.0.0", "max":"224.0.255.255"}
+90 {"min":"224.0.0.0", "max":"224.0.255.255"}
+91 {"min":"224.0.0.0", "max":"224.0.255.255"}
+92 {"min":"224.0.0.0", "max":"224.0.255.255"}
+93 {"min":"224.0.0.0", "max":"224.0.255.255"}
+94 {"min":"224.0.0.0", "max":"224.0.255.255"}
+95 {"min":"224.0.0.0", "max":"224.0.255.255"}
+96 {"min":"224.0.0.0", "max":"224.0.255.255"}
+97 {"min":"224.0.0.0", "max":"224.0.255.255"}
+98 {"min":"224.0.0.0", "max":"224.0.255.255"}
+99 {"min":"224.0.0.0", "max":"224.0.255.255"}
+100 {"min":"224.0.0.0", "max":"224.0.255.255"}
+
+-- !sql_num2string_ipv6 --
+1 ::1
+2 fc00::
+3 fdff:ffff:ffff:ffff:ffff:ffff:ffff:ffff
+4 fc00::
+5 febf:ffff:ffff:ffff:ffff:ffff:ffff:ffff
+6 fe80::
+7 ffff:ffff:ffff:ffff:ffff:ffff:ffff:ffff
+8 fe80::
+9 2001:4860:4860::8888
+10 2606:4700:4700::1111
+11 ff01::
+12 ff02::1
+13 2001:db8:85a3::8a2e:370:7334
+14 2001:db8::1
+15 2001:db8::2
+16 ::1
+17 ::
+18 ::
+19 fd00::
+20 ::
+21 ::
+22 ::
+23 ::
+24 ::
+25 ::
+26 ff01::
+27 ff02::1
+28 ff00::
+29 2001:db8::1
+30 2001:db8::2
+31 2001:db8::3
+32 2001:db8::4
+33 2001:db8::5
+34 2001:db8::6
+35 2001:db8::7
+36 2001:db8::8
+37 2001:db8::9
+38 2001:db8::a
+39 2001:db8::b
+40 2001:db8::c
+41 2001:db8::d
+42 2001:db8::e
+43 2001:db8::f
+44 2001:db8::10
+45 2001:db8::11
+46 2001:db8::12
+47 2001:db8::13
+48 2001:db8::14
+49 2001:db8::15
+50 2001:db8::16
+51 2001:db8::17
+52 2001:db8::18
+53 2001:db8::19
+54 2001:db8::1a
+55 2001:db8::1b
+56 2001:db8::1c
+57 2001:db8::1d
+58 2001:db8::1e
+59 2001:db8::1f
+60 2001:db8::20
+61 2001:db8::21
+62 2001:db8::22
+63 2001:db8::23
+64 2001:db8::24
+65 2001:db8::25
+66 2001:db8::26
+67 2001:db8::27
+68 2001:db8::28
+69 2001:db8::29
+70 2001:db8::2a
+71 2001:db8::2b
+72 2001:db8::2c
+73 2001:db8::2d
+74 2001:db8::2e
+75 2001:db8::2f
+76 2001:db8::30
+77 2001:db8::31
+78 2001:db8::32
+79 2001:db8::33
+80 2001:db8::34
+81 2001:db8::35
+82 2001:db8::36
+83 2001:db8::37
+84 2001:db8::38
+85 2001:db8::39
+86 2001:db8::3a
+87 2001:db8::3b
+88 ff01::1
+89 ff01::2
+90 ff01::3
+91 ff01::4
+92 ff01::5
+93 ff01::6
+94 ff01::7
+95 ff01::8
+96 ff01::9
+97 ff01::a
+98 ff01::b
+99 ff01::c
+100 ff01::d
+
+-- !sql_num2string_ipv4 --
+1 127.0.0.1
+2 10.0.0.0
+3 10.255.255.255
+4 172.16.0.0
+5 172.31.255.255
+6 192.168.0.0
+7 192.168.255.255
+8 169.254.0.0
+9 8.8.8.8
+10 1.1.1.1
+11 224.0.0.0
+12 239.255.255.255
+13 192.0.2.0
+14 203.0.113.0
+15 198.51.100.0
+16 0.0.0.0
+17 240.0.0.0
+18 255.255.255.255
+19 0.0.0.0
+20 0.0.0.0
+21 127.255.255.255
+22 128.0.0.0
+23 191.255.255.255
+24 192.0.0.0
+25 223.255.255.255
+26 224.0.0.0
+27 239.255.255.255
+28 0.0.0.0
+29 0.0.0.1
+30 0.0.1.10
+31 0.0.2.20
+32 0.0.3.30
+33 10.0.0.5
+34 10.0.1.15
+35 10.1.0.25
+36 10.2.0.35
+37 10.3.0.45
+38 10.4.0.55
+39 10.5.0.65
+40 10.6.0.75
+41 10.7.0.85
+42 10.8.0.95
+43 10.9.1.5
+44 10.10.1.15
+45 10.11.1.25
+46 10.12.1.35
+47 10.13.1.45
+48 10.14.1.55
+49 10.15.1.65
+50 10.16.1.75
+51 128.0.0.1
+52 128.1.0.10
+53 128.2.0.20
+54 128.3.0.30
+55 128.4.0.40
+56 128.5.0.50
+57 128.6.0.60
+58 128.7.0.70
+59 128.8.0.80
+60 128.9.0.90
+61 172.16.0.1
+62 172.16.0.5
+63 172.16.0.10
+64 172.16.0.15
+65 172.16.0.20
+66 172.16.0.25
+67 172.16.0.30
+68 172.16.0.35
+69 192.0.0.1
+70 192.0.0.2
+71 192.0.0.3
+72 192.0.0.4
+73 192.0.0.5
+74 192.0.0.6
+75 192.0.0.7
+76 192.0.0.8
+77 192.0.0.9
+78 192.0.0.10
+79 192.168.0.1
+80 192.168.0.2
+81 192.168.1.5
+82 192.168.1.10
+83 192.168.1.15
+84 192.168.1.20
+85 192.168.2.5
+86 192.168.2.10
+87 192.168.5.20
+88 224.0.0.1
+89 224.0.0.2
+90 224.0.0.3
+91 224.0.0.4
+92 224.0.0.5
+93 224.0.0.6
+94 224.0.0.7
+95 224.0.0.8
+96 224.0.0.9
+97 224.0.0.10
+98 224.0.0.11
+99 224.0.0.12
+100 224.0.0.13
+
+-- !sql_inet6_ntoa --
+1 ::1
+2 fc00::
+3 fdff:ffff:ffff:ffff:ffff:ffff:ffff:ffff
+4 fc00::
+5 febf:ffff:ffff:ffff:ffff:ffff:ffff:ffff
+6 fe80::
+7 ffff:ffff:ffff:ffff:ffff:ffff:ffff:ffff
+8 fe80::
+9 2001:4860:4860::8888
+10 2606:4700:4700::1111
+11 ff01::
+12 ff02::1
+13 2001:db8:85a3::8a2e:370:7334
+14 2001:db8::1
+15 2001:db8::2
+16 ::1
+17 ::
+18 ::
+19 fd00::
+20 ::
+21 ::
+22 ::
+23 ::
+24 ::
+25 ::
+26 ff01::
+27 ff02::1
+28 ff00::
+29 2001:db8::1
+30 2001:db8::2
+31 2001:db8::3
+32 2001:db8::4
+33 2001:db8::5
+34 2001:db8::6
+35 2001:db8::7
+36 2001:db8::8
+37 2001:db8::9
+38 2001:db8::a
+39 2001:db8::b
+40 2001:db8::c
+41 2001:db8::d
+42 2001:db8::e
+43 2001:db8::f
+44 2001:db8::10
+45 2001:db8::11
+46 2001:db8::12
+47 2001:db8::13
+48 2001:db8::14
+49 2001:db8::15
+50 2001:db8::16
+51 2001:db8::17
+52 2001:db8::18
+53 2001:db8::19
+54 2001:db8::1a
+55 2001:db8::1b
+56 2001:db8::1c
+57 2001:db8::1d
+58 2001:db8::1e
+59 2001:db8::1f
+60 2001:db8::20
+61 2001:db8::21
+62 2001:db8::22
+63 2001:db8::23
+64 2001:db8::24
+65 2001:db8::25
+66 2001:db8::26
+67 2001:db8::27
+68 2001:db8::28
+69 2001:db8::29
+70 2001:db8::2a
+71 2001:db8::2b
+72 2001:db8::2c
+73 2001:db8::2d
+74 2001:db8::2e
+75 2001:db8::2f
+76 2001:db8::30
+77 2001:db8::31
+78 2001:db8::32
+79 2001:db8::33
+80 2001:db8::34
+81 2001:db8::35
+82 2001:db8::36
+83 2001:db8::37
+84 2001:db8::38
+85 2001:db8::39
+86 2001:db8::3a
+87 2001:db8::3b
+88 ff01::1
+89 ff01::2
+90 ff01::3
+91 ff01::4
+92 ff01::5
+93 ff01::6
+94 ff01::7
+95 ff01::8
+96 ff01::9
+97 ff01::a
+98 ff01::b
+99 ff01::c
+100 ff01::d
+
+-- !sql_inet_ntoa --
+1 127.0.0.1
+2 10.0.0.0
+3 10.255.255.255
+4 172.16.0.0
+5 172.31.255.255
+6 192.168.0.0
+7 192.168.255.255
+8 169.254.0.0
+9 8.8.8.8
+10 1.1.1.1
+11 224.0.0.0
+12 239.255.255.255
+13 192.0.2.0
+14 203.0.113.0
+15 198.51.100.0
+16 0.0.0.0
+17 240.0.0.0
+18 255.255.255.255
+19 0.0.0.0
+20 0.0.0.0
+21 127.255.255.255
+22 128.0.0.0
+23 191.255.255.255
+24 192.0.0.0
+25 223.255.255.255
+26 224.0.0.0
+27 239.255.255.255
+28 0.0.0.0
+29 0.0.0.1
+30 0.0.1.10
+31 0.0.2.20
+32 0.0.3.30
+33 10.0.0.5
+34 10.0.1.15
+35 10.1.0.25
+36 10.2.0.35
+37 10.3.0.45
+38 10.4.0.55
+39 10.5.0.65
+40 10.6.0.75
+41 10.7.0.85
+42 10.8.0.95
+43 10.9.1.5
+44 10.10.1.15
+45 10.11.1.25
+46 10.12.1.35
+47 10.13.1.45
+48 10.14.1.55
+49 10.15.1.65
+50 10.16.1.75
+51 128.0.0.1
+52 128.1.0.10
+53 128.2.0.20
+54 128.3.0.30
+55 128.4.0.40
+56 128.5.0.50
+57 128.6.0.60
+58 128.7.0.70
+59 128.8.0.80
+60 128.9.0.90
+61 172.16.0.1
+62 172.16.0.5
+63 172.16.0.10
+64 172.16.0.15
+65 172.16.0.20
+66 172.16.0.25
+67 172.16.0.30
+68 172.16.0.35
+69 192.0.0.1
+70 192.0.0.2
+71 192.0.0.3
+72 192.0.0.4
+73 192.0.0.5
+74 192.0.0.6
+75 192.0.0.7
+76 192.0.0.8
+77 192.0.0.9
+78 192.0.0.10
+79 192.168.0.1
+80 192.168.0.2
+81 192.168.1.5
+82 192.168.1.10
+83 192.168.1.15
+84 192.168.1.20
+85 192.168.2.5
+86 192.168.2.10
+87 192.168.5.20
+88 224.0.0.1
+89 224.0.0.2
+90 224.0.0.3
+91 224.0.0.4
+92 224.0.0.5
+93 224.0.0.6
+94 224.0.0.7
+95 224.0.0.8
+96 224.0.0.9
+97 224.0.0.10
+98 224.0.0.11
+99 224.0.0.12
+100 224.0.0.13
+
+-- !sql_string2num_or_default_ipv6 --
+1 ���������������
+2 ����������������
+3 ����������������
+4 ����������������
+5 ����������������
+6 ����������������
+7 ����������������
+8 ����������������
+9 H`H`����������
+10 &G�G���������
+11 ���������������
+12 ��������������
+13 \r��������.ps4
+14 \r������������
+15 \r������������
+16 ���������������
+17 ����������������
+18 ����������������
+19 ����������������
+20 ����������������
+21 ����������������
+22 ����������������
+23 ����������������
+24 ����������������
+25 ����������������
+26 ���������������
+27 ��������������
+28 ����������������
+29 \r������������
+30 \r������������
+31 \r������������
+32 \r������������
+33 \r������������
+34 \r������������
+35 \r������������
+36 \r������������
+37 \r������������\
+38 \r������������\n
+39 \r������������
+40 \r������������
+41 \r������������\r
+42 \r������������
+43 \r������������
+44 \r������������
+45 \r������������
+46 \r������������
+47 \r������������
+48 \r������������
+49 \r������������
+50 \r������������
+51 \r������������
+52 \r������������
+53 \r������������
+54 \r������������
+55 \r������������
+56 \r������������
+57 \r������������
+58 \r������������
+59 \r������������
+60 \r������������
+61 \r������������!
+62 \r������������"
+63 \r������������#
+64 \r������������$
+65 \r������������%
+66 \r������������&
+67 \r������������'
+68 \r������������(
+69 \r������������)
+70 \r������������*
+71 \r������������+
+72 \r������������,
+73 \r������������-
+74 \r������������.
+75 \r������������/
+76 \r������������0
+77 \r������������1
+78 \r������������2
+79 \r������������3
+80 \r������������4
+81 \r������������5
+82 \r������������6
+83 \r������������7
+84 \r������������8
+85 \r������������9
+86 \r������������:
+87 \r������������;
+88 ��������������
+89 ��������������
+90 ��������������
+91 ��������������
+92 ��������������
+93 ��������������
+94 ��������������
+95 ��������������
+96 ��������������\
+97 ��������������\n
+98 ��������������
+99 ��������������
+100 ��������������\r
+
+-- !sql_string2num_or_default_ipv4 --
+1 2130706433
+2 167772160
+3 184549375
+4 2886729728
+5 2887778303
+6 3232235520
+7 3232301055
+8 2851995648
+9 134744072
+10 16843009
+11 3758096384
+12 4026531839
+13 3221225984
+14 3405803776
+15 3325256704
+16 0
+17 4026531840
+18 4294967295
+19 0
+20 0
+21 2147483647
+22 2147483648
+23 3221225471
+24 3221225472
+25 3758096383
+26 3758096384
+27 4026531839
+28 0
+29 1
+30 266
+31 532
+32 798
+33 167772165
+34 167772431
+35 167837721
+36 167903267
+37 167968813
+38 168034359
+39 168099905
+40 168165451
+41 168230997
+42 168296543
+43 168362245
+44 168427791
+45 168493337
+46 168558883
+47 168624429
+48 168689975
+49 168755521
+50 168821067
+51 2147483649
+52 2147549194
+53 2147614740
+54 2147680286
+55 2147745832
+56 2147811378
+57 2147876924
+58 2147942470
+59 2148008016
+60 2148073562
+61 2886729729
+62 2886729733
+63 2886729738
+64 2886729743
+65 2886729748
+66 2886729753
+67 2886729758
+68 2886729763
+69 3221225473
+70 3221225474
+71 3221225475
+72 3221225476
+73 3221225477
+74 3221225478
+75 3221225479
+76 3221225480
+77 3221225481
+78 3221225482
+79 3232235521
+80 3232235522
+81 3232235781
+82 3232235786
+83 3232235791
+84 3232235796
+85 3232236037
+86 3232236042
+87 3232236820
+88 3758096385
+89 3758096386
+90 3758096387
+91 3758096388
+92 3758096389
+93 3758096390
+94 3758096391
+95 3758096392
+96 3758096393
+97 3758096394
+98 3758096395
+99 3758096396
+100 3758096397
+
+-- !sql_string2num_or_null_ipv6 --
+1 ���������������
+2 ����������������
+3 ����������������
Review Comment:
maybe use hex like `hex(ipv6_string_to_num_or_null('1111::ffff'))` to check
##########
regression-test/data/nereids_function_p0/scalar_function/IP.out:
##########
@@ -0,0 +1,3061 @@
+-- This file is automatically generated. You should know what you did if you
want to edit this
+-- !sql_cidr_ipv6 --
+1 :: ::ffff:ffff:ffff:ffff
+2 fc00:: fc00::ffff:ffff:ffff:ffff
+3 fdff:ffff:ffff:ffff:: fdff:ffff:ffff:ffff:ffff:ffff:ffff:ffff
+4 fc00:: fc00::ffff:ffff:ffff:ffff
+5 febf:ffff:ffff:ffff:: febf:ffff:ffff:ffff:ffff:ffff:ffff:ffff
+6 fe80:: fe80::ffff:ffff:ffff:ffff
+7 ffff:ffff:ffff:ffff:: ffff:ffff:ffff:ffff:ffff:ffff:ffff:ffff
+8 fe80:: fe80::ffff:ffff:ffff:ffff
+9 2001:4860:4860:: 2001:4860:4860:0:ffff:ffff:ffff:ffff
+10 2606:4700:4700:: 2606:4700:4700:0:ffff:ffff:ffff:ffff
+11 ff01:: ff01::ffff:ffff:ffff:ffff
+12 ff02:: ff02::ffff:ffff:ffff:ffff
+13 2001:db8:85a3:: 2001:db8:85a3:0:ffff:ffff:ffff:ffff
+14 2001:db8:: 2001:db8::ffff:ffff:ffff:ffff
+15 2001:db8:: 2001:db8::ffff:ffff:ffff:ffff
+16 :: ::ffff:ffff:ffff:ffff
+17 \N \N
+18 \N \N
+19 fd00:: fd00::ffff:ffff:ffff:ffff
+20 \N \N
+21 \N \N
+22 \N \N
+23 \N \N
+24 \N \N
+25 \N \N
+26 ff01:: ff01::ffff:ffff:ffff:ffff
+27 ff02:: ff02::ffff:ffff:ffff:ffff
+28 ff00:: ff00::ffff:ffff:ffff:ffff
+29 2001:db8:: 2001:db8::ffff:ffff:ffff:ffff
+30 2001:db8:: 2001:db8::ffff:ffff:ffff:ffff
+31 2001:db8:: 2001:db8::ffff:ffff:ffff:ffff
+32 2001:db8:: 2001:db8::ffff:ffff:ffff:ffff
+33 2001:db8:: 2001:db8::ffff:ffff:ffff:ffff
+34 2001:db8:: 2001:db8::ffff:ffff:ffff:ffff
+35 2001:db8:: 2001:db8::ffff:ffff:ffff:ffff
+36 2001:db8:: 2001:db8::ffff:ffff:ffff:ffff
+37 2001:db8:: 2001:db8::ffff:ffff:ffff:ffff
+38 2001:db8:: 2001:db8::ffff:ffff:ffff:ffff
+39 2001:db8:: 2001:db8::ffff:ffff:ffff:ffff
+40 2001:db8:: 2001:db8::ffff:ffff:ffff:ffff
+41 2001:db8:: 2001:db8::ffff:ffff:ffff:ffff
+42 2001:db8:: 2001:db8::ffff:ffff:ffff:ffff
+43 2001:db8:: 2001:db8::ffff:ffff:ffff:ffff
+44 2001:db8:: 2001:db8::ffff:ffff:ffff:ffff
+45 2001:db8:: 2001:db8::ffff:ffff:ffff:ffff
+46 2001:db8:: 2001:db8::ffff:ffff:ffff:ffff
+47 2001:db8:: 2001:db8::ffff:ffff:ffff:ffff
+48 2001:db8:: 2001:db8::ffff:ffff:ffff:ffff
+49 2001:db8:: 2001:db8::ffff:ffff:ffff:ffff
+50 2001:db8:: 2001:db8::ffff:ffff:ffff:ffff
+51 2001:db8:: 2001:db8::ffff:ffff:ffff:ffff
+52 2001:db8:: 2001:db8::ffff:ffff:ffff:ffff
+53 2001:db8:: 2001:db8::ffff:ffff:ffff:ffff
+54 2001:db8:: 2001:db8::ffff:ffff:ffff:ffff
+55 2001:db8:: 2001:db8::ffff:ffff:ffff:ffff
+56 2001:db8:: 2001:db8::ffff:ffff:ffff:ffff
+57 2001:db8:: 2001:db8::ffff:ffff:ffff:ffff
+58 2001:db8:: 2001:db8::ffff:ffff:ffff:ffff
+59 2001:db8:: 2001:db8::ffff:ffff:ffff:ffff
+60 2001:db8:: 2001:db8::ffff:ffff:ffff:ffff
+61 2001:db8:: 2001:db8::ffff:ffff:ffff:ffff
+62 2001:db8:: 2001:db8::ffff:ffff:ffff:ffff
+63 2001:db8:: 2001:db8::ffff:ffff:ffff:ffff
+64 2001:db8:: 2001:db8::ffff:ffff:ffff:ffff
+65 2001:db8:: 2001:db8::ffff:ffff:ffff:ffff
+66 2001:db8:: 2001:db8::ffff:ffff:ffff:ffff
+67 2001:db8:: 2001:db8::ffff:ffff:ffff:ffff
+68 2001:db8:: 2001:db8::ffff:ffff:ffff:ffff
+69 2001:db8:: 2001:db8::ffff:ffff:ffff:ffff
+70 2001:db8:: 2001:db8::ffff:ffff:ffff:ffff
+71 2001:db8:: 2001:db8::ffff:ffff:ffff:ffff
+72 2001:db8:: 2001:db8::ffff:ffff:ffff:ffff
+73 2001:db8:: 2001:db8::ffff:ffff:ffff:ffff
+74 2001:db8:: 2001:db8::ffff:ffff:ffff:ffff
+75 2001:db8:: 2001:db8::ffff:ffff:ffff:ffff
+76 2001:db8:: 2001:db8::ffff:ffff:ffff:ffff
+77 2001:db8:: 2001:db8::ffff:ffff:ffff:ffff
+78 2001:db8:: 2001:db8::ffff:ffff:ffff:ffff
+79 2001:db8:: 2001:db8::ffff:ffff:ffff:ffff
+80 2001:db8:: 2001:db8::ffff:ffff:ffff:ffff
+81 2001:db8:: 2001:db8::ffff:ffff:ffff:ffff
+82 2001:db8:: 2001:db8::ffff:ffff:ffff:ffff
+83 2001:db8:: 2001:db8::ffff:ffff:ffff:ffff
+84 2001:db8:: 2001:db8::ffff:ffff:ffff:ffff
+85 2001:db8:: 2001:db8::ffff:ffff:ffff:ffff
+86 2001:db8:: 2001:db8::ffff:ffff:ffff:ffff
+87 2001:db8:: 2001:db8::ffff:ffff:ffff:ffff
+88 ff01:: ff01::ffff:ffff:ffff:ffff
+89 ff01:: ff01::ffff:ffff:ffff:ffff
+90 ff01:: ff01::ffff:ffff:ffff:ffff
+91 ff01:: ff01::ffff:ffff:ffff:ffff
+92 ff01:: ff01::ffff:ffff:ffff:ffff
+93 ff01:: ff01::ffff:ffff:ffff:ffff
+94 ff01:: ff01::ffff:ffff:ffff:ffff
+95 ff01:: ff01::ffff:ffff:ffff:ffff
+96 ff01:: ff01::ffff:ffff:ffff:ffff
+97 ff01:: ff01::ffff:ffff:ffff:ffff
+98 ff01:: ff01::ffff:ffff:ffff:ffff
+99 ff01:: ff01::ffff:ffff:ffff:ffff
+100 ff01:: ff01::ffff:ffff:ffff:ffff
+
+-- !sql_cidr_ipv4 --
+1 127.0.0.1 127.0.0.1
+2 10.0.0.0 10.0.0.0
+3 10.255.255.255 10.255.255.255
+4 172.16.0.0 172.16.0.0
+5 172.31.255.255 172.31.255.255
+6 192.168.0.0 192.168.0.0
+7 192.168.255.255 192.168.255.255
+8 169.254.0.0 169.254.0.0
+9 8.8.8.8 8.8.8.8
+10 1.1.1.1 1.1.1.1
+11 224.0.0.0 224.0.0.0
+12 239.255.255.255 239.255.255.255
+13 192.0.2.0 192.0.2.0
+14 203.0.113.0 203.0.113.0
+15 198.51.100.0 198.51.100.0
+16 \N \N
+17 240.0.0.0 240.0.0.0
+18 255.255.255.255 255.255.255.255
+19 \N \N
+20 0.0.0.0 0.0.0.0
+21 127.255.255.255 127.255.255.255
+22 128.0.0.0 128.0.0.0
+23 191.255.255.255 191.255.255.255
+24 192.0.0.0 192.0.0.0
+25 223.255.255.255 223.255.255.255
+26 224.0.0.0 224.0.0.0
+27 239.255.255.255 239.255.255.255
+28 \N \N
+29 0.0.0.1 0.0.0.1
+30 0.0.1.10 0.0.1.10
+31 0.0.2.20 0.0.2.20
+32 0.0.3.30 0.0.3.30
+33 10.0.0.5 10.0.0.5
+34 10.0.1.15 10.0.1.15
+35 10.1.0.25 10.1.0.25
+36 10.2.0.35 10.2.0.35
+37 10.3.0.45 10.3.0.45
+38 10.4.0.55 10.4.0.55
+39 10.5.0.65 10.5.0.65
+40 10.6.0.75 10.6.0.75
+41 10.7.0.85 10.7.0.85
+42 10.8.0.95 10.8.0.95
+43 10.9.1.5 10.9.1.5
+44 10.10.1.15 10.10.1.15
+45 10.11.1.25 10.11.1.25
+46 10.12.1.35 10.12.1.35
+47 10.13.1.45 10.13.1.45
+48 10.14.1.55 10.14.1.55
+49 10.15.1.65 10.15.1.65
+50 10.16.1.75 10.16.1.75
+51 128.0.0.1 128.0.0.1
+52 128.1.0.10 128.1.0.10
+53 128.2.0.20 128.2.0.20
+54 128.3.0.30 128.3.0.30
+55 128.4.0.40 128.4.0.40
+56 128.5.0.50 128.5.0.50
+57 128.6.0.60 128.6.0.60
+58 128.7.0.70 128.7.0.70
+59 128.8.0.80 128.8.0.80
+60 128.9.0.90 128.9.0.90
+61 172.16.0.1 172.16.0.1
+62 172.16.0.5 172.16.0.5
+63 172.16.0.10 172.16.0.10
+64 172.16.0.15 172.16.0.15
+65 172.16.0.20 172.16.0.20
+66 172.16.0.25 172.16.0.25
+67 172.16.0.30 172.16.0.30
+68 172.16.0.35 172.16.0.35
+69 192.0.0.1 192.0.0.1
+70 192.0.0.2 192.0.0.2
+71 192.0.0.3 192.0.0.3
+72 192.0.0.4 192.0.0.4
+73 192.0.0.5 192.0.0.5
+74 192.0.0.6 192.0.0.6
+75 192.0.0.7 192.0.0.7
+76 192.0.0.8 192.0.0.8
+77 192.0.0.9 192.0.0.9
+78 192.0.0.10 192.0.0.10
+79 192.168.0.1 192.168.0.1
+80 192.168.0.2 192.168.0.2
+81 192.168.1.5 192.168.1.5
+82 192.168.1.10 192.168.1.10
+83 192.168.1.15 192.168.1.15
+84 192.168.1.20 192.168.1.20
+85 192.168.2.5 192.168.2.5
+86 192.168.2.10 192.168.2.10
+87 192.168.5.20 192.168.5.20
+88 224.0.0.1 224.0.0.1
+89 224.0.0.2 224.0.0.2
+90 224.0.0.3 224.0.0.3
+91 224.0.0.4 224.0.0.4
+92 224.0.0.5 224.0.0.5
+93 224.0.0.6 224.0.0.6
+94 224.0.0.7 224.0.0.7
+95 224.0.0.8 224.0.0.8
+96 224.0.0.9 224.0.0.9
+97 224.0.0.10 224.0.0.10
+98 224.0.0.11 224.0.0.11
+99 224.0.0.12 224.0.0.12
+100 224.0.0.13 224.0.0.13
+
+-- !sql_cidr_ipv6_all --
+1 {"min":"::", "max":"0:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+2 {"min":"fc00::", "max":"fc00:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+3 {"min":"fdff::", "max":"fdff:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+4 {"min":"fc00::", "max":"fc00:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+5 {"min":"febf::", "max":"febf:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+6 {"min":"fe80::", "max":"fe80:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+7 {"min":"ffff::", "max":"ffff:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+8 {"min":"fe80::", "max":"fe80:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+9 {"min":"2001::", "max":"2001:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+10 {"min":"2606::", "max":"2606:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+11 {"min":"ff01::", "max":"ff01:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+12 {"min":"ff02::", "max":"ff02:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+13 {"min":"2001::", "max":"2001:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+14 {"min":"2001::", "max":"2001:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+15 {"min":"2001::", "max":"2001:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+16 {"min":"::", "max":"0:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+17 \N
+18 \N
+19 {"min":"fd00::", "max":"fd00:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+20 \N
+21 \N
+22 \N
+23 \N
+24 \N
+25 \N
+26 {"min":"ff01::", "max":"ff01:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+27 {"min":"ff02::", "max":"ff02:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+28 {"min":"ff00::", "max":"ff00:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+29 {"min":"2001::", "max":"2001:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+30 {"min":"2001::", "max":"2001:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+31 {"min":"2001::", "max":"2001:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+32 {"min":"2001::", "max":"2001:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+33 {"min":"2001::", "max":"2001:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+34 {"min":"2001::", "max":"2001:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+35 {"min":"2001::", "max":"2001:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+36 {"min":"2001::", "max":"2001:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+37 {"min":"2001::", "max":"2001:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+38 {"min":"2001::", "max":"2001:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+39 {"min":"2001::", "max":"2001:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+40 {"min":"2001::", "max":"2001:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+41 {"min":"2001::", "max":"2001:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+42 {"min":"2001::", "max":"2001:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+43 {"min":"2001::", "max":"2001:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+44 {"min":"2001::", "max":"2001:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+45 {"min":"2001::", "max":"2001:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+46 {"min":"2001::", "max":"2001:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+47 {"min":"2001::", "max":"2001:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+48 {"min":"2001::", "max":"2001:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+49 {"min":"2001::", "max":"2001:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+50 {"min":"2001::", "max":"2001:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+51 {"min":"2001::", "max":"2001:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+52 {"min":"2001::", "max":"2001:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+53 {"min":"2001::", "max":"2001:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+54 {"min":"2001::", "max":"2001:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+55 {"min":"2001::", "max":"2001:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+56 {"min":"2001::", "max":"2001:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+57 {"min":"2001::", "max":"2001:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+58 {"min":"2001::", "max":"2001:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+59 {"min":"2001::", "max":"2001:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+60 {"min":"2001::", "max":"2001:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+61 {"min":"2001::", "max":"2001:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+62 {"min":"2001::", "max":"2001:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+63 {"min":"2001::", "max":"2001:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+64 {"min":"2001::", "max":"2001:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+65 {"min":"2001::", "max":"2001:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+66 {"min":"2001::", "max":"2001:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+67 {"min":"2001::", "max":"2001:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+68 {"min":"2001::", "max":"2001:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+69 {"min":"2001::", "max":"2001:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+70 {"min":"2001::", "max":"2001:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+71 {"min":"2001::", "max":"2001:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+72 {"min":"2001::", "max":"2001:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+73 {"min":"2001::", "max":"2001:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+74 {"min":"2001::", "max":"2001:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+75 {"min":"2001::", "max":"2001:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+76 {"min":"2001::", "max":"2001:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+77 {"min":"2001::", "max":"2001:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+78 {"min":"2001::", "max":"2001:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+79 {"min":"2001::", "max":"2001:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+80 {"min":"2001::", "max":"2001:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+81 {"min":"2001::", "max":"2001:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+82 {"min":"2001::", "max":"2001:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+83 {"min":"2001::", "max":"2001:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+84 {"min":"2001::", "max":"2001:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+85 {"min":"2001::", "max":"2001:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+86 {"min":"2001::", "max":"2001:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+87 {"min":"2001::", "max":"2001:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+88 {"min":"ff01::", "max":"ff01:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+89 {"min":"ff01::", "max":"ff01:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+90 {"min":"ff01::", "max":"ff01:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+91 {"min":"ff01::", "max":"ff01:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+92 {"min":"ff01::", "max":"ff01:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+93 {"min":"ff01::", "max":"ff01:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+94 {"min":"ff01::", "max":"ff01:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+95 {"min":"ff01::", "max":"ff01:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+96 {"min":"ff01::", "max":"ff01:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+97 {"min":"ff01::", "max":"ff01:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+98 {"min":"ff01::", "max":"ff01:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+99 {"min":"ff01::", "max":"ff01:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+100 {"min":"ff01::", "max":"ff01:ffff:ffff:ffff:ffff:ffff:ffff:ffff"}
+
+-- !sql_cidr_ipv4_all --
+1 {"min":"127.0.0.0", "max":"127.0.255.255"}
+2 {"min":"10.0.0.0", "max":"10.0.255.255"}
+3 {"min":"10.255.0.0", "max":"10.255.255.255"}
+4 {"min":"172.16.0.0", "max":"172.16.255.255"}
+5 {"min":"172.31.0.0", "max":"172.31.255.255"}
+6 {"min":"192.168.0.0", "max":"192.168.255.255"}
+7 {"min":"192.168.0.0", "max":"192.168.255.255"}
+8 {"min":"169.254.0.0", "max":"169.254.255.255"}
+9 {"min":"8.8.0.0", "max":"8.8.255.255"}
+10 {"min":"1.1.0.0", "max":"1.1.255.255"}
+11 {"min":"224.0.0.0", "max":"224.0.255.255"}
+12 {"min":"239.255.0.0", "max":"239.255.255.255"}
+13 {"min":"192.0.0.0", "max":"192.0.255.255"}
+14 {"min":"203.0.0.0", "max":"203.0.255.255"}
+15 {"min":"198.51.0.0", "max":"198.51.255.255"}
+16 \N
+17 {"min":"240.0.0.0", "max":"240.0.255.255"}
+18 {"min":"255.255.0.0", "max":"255.255.255.255"}
+19 \N
+20 {"min":"0.0.0.0", "max":"0.0.255.255"}
+21 {"min":"127.255.0.0", "max":"127.255.255.255"}
+22 {"min":"128.0.0.0", "max":"128.0.255.255"}
+23 {"min":"191.255.0.0", "max":"191.255.255.255"}
+24 {"min":"192.0.0.0", "max":"192.0.255.255"}
+25 {"min":"223.255.0.0", "max":"223.255.255.255"}
+26 {"min":"224.0.0.0", "max":"224.0.255.255"}
+27 {"min":"239.255.0.0", "max":"239.255.255.255"}
+28 \N
+29 {"min":"0.0.0.0", "max":"0.0.255.255"}
+30 {"min":"0.0.0.0", "max":"0.0.255.255"}
+31 {"min":"0.0.0.0", "max":"0.0.255.255"}
+32 {"min":"0.0.0.0", "max":"0.0.255.255"}
+33 {"min":"10.0.0.0", "max":"10.0.255.255"}
+34 {"min":"10.0.0.0", "max":"10.0.255.255"}
+35 {"min":"10.1.0.0", "max":"10.1.255.255"}
+36 {"min":"10.2.0.0", "max":"10.2.255.255"}
+37 {"min":"10.3.0.0", "max":"10.3.255.255"}
+38 {"min":"10.4.0.0", "max":"10.4.255.255"}
+39 {"min":"10.5.0.0", "max":"10.5.255.255"}
+40 {"min":"10.6.0.0", "max":"10.6.255.255"}
+41 {"min":"10.7.0.0", "max":"10.7.255.255"}
+42 {"min":"10.8.0.0", "max":"10.8.255.255"}
+43 {"min":"10.9.0.0", "max":"10.9.255.255"}
+44 {"min":"10.10.0.0", "max":"10.10.255.255"}
+45 {"min":"10.11.0.0", "max":"10.11.255.255"}
+46 {"min":"10.12.0.0", "max":"10.12.255.255"}
+47 {"min":"10.13.0.0", "max":"10.13.255.255"}
+48 {"min":"10.14.0.0", "max":"10.14.255.255"}
+49 {"min":"10.15.0.0", "max":"10.15.255.255"}
+50 {"min":"10.16.0.0", "max":"10.16.255.255"}
+51 {"min":"128.0.0.0", "max":"128.0.255.255"}
+52 {"min":"128.1.0.0", "max":"128.1.255.255"}
+53 {"min":"128.2.0.0", "max":"128.2.255.255"}
+54 {"min":"128.3.0.0", "max":"128.3.255.255"}
+55 {"min":"128.4.0.0", "max":"128.4.255.255"}
+56 {"min":"128.5.0.0", "max":"128.5.255.255"}
+57 {"min":"128.6.0.0", "max":"128.6.255.255"}
+58 {"min":"128.7.0.0", "max":"128.7.255.255"}
+59 {"min":"128.8.0.0", "max":"128.8.255.255"}
+60 {"min":"128.9.0.0", "max":"128.9.255.255"}
+61 {"min":"172.16.0.0", "max":"172.16.255.255"}
+62 {"min":"172.16.0.0", "max":"172.16.255.255"}
+63 {"min":"172.16.0.0", "max":"172.16.255.255"}
+64 {"min":"172.16.0.0", "max":"172.16.255.255"}
+65 {"min":"172.16.0.0", "max":"172.16.255.255"}
+66 {"min":"172.16.0.0", "max":"172.16.255.255"}
+67 {"min":"172.16.0.0", "max":"172.16.255.255"}
+68 {"min":"172.16.0.0", "max":"172.16.255.255"}
+69 {"min":"192.0.0.0", "max":"192.0.255.255"}
+70 {"min":"192.0.0.0", "max":"192.0.255.255"}
+71 {"min":"192.0.0.0", "max":"192.0.255.255"}
+72 {"min":"192.0.0.0", "max":"192.0.255.255"}
+73 {"min":"192.0.0.0", "max":"192.0.255.255"}
+74 {"min":"192.0.0.0", "max":"192.0.255.255"}
+75 {"min":"192.0.0.0", "max":"192.0.255.255"}
+76 {"min":"192.0.0.0", "max":"192.0.255.255"}
+77 {"min":"192.0.0.0", "max":"192.0.255.255"}
+78 {"min":"192.0.0.0", "max":"192.0.255.255"}
+79 {"min":"192.168.0.0", "max":"192.168.255.255"}
+80 {"min":"192.168.0.0", "max":"192.168.255.255"}
+81 {"min":"192.168.0.0", "max":"192.168.255.255"}
+82 {"min":"192.168.0.0", "max":"192.168.255.255"}
+83 {"min":"192.168.0.0", "max":"192.168.255.255"}
+84 {"min":"192.168.0.0", "max":"192.168.255.255"}
+85 {"min":"192.168.0.0", "max":"192.168.255.255"}
+86 {"min":"192.168.0.0", "max":"192.168.255.255"}
+87 {"min":"192.168.0.0", "max":"192.168.255.255"}
+88 {"min":"224.0.0.0", "max":"224.0.255.255"}
+89 {"min":"224.0.0.0", "max":"224.0.255.255"}
+90 {"min":"224.0.0.0", "max":"224.0.255.255"}
+91 {"min":"224.0.0.0", "max":"224.0.255.255"}
+92 {"min":"224.0.0.0", "max":"224.0.255.255"}
+93 {"min":"224.0.0.0", "max":"224.0.255.255"}
+94 {"min":"224.0.0.0", "max":"224.0.255.255"}
+95 {"min":"224.0.0.0", "max":"224.0.255.255"}
+96 {"min":"224.0.0.0", "max":"224.0.255.255"}
+97 {"min":"224.0.0.0", "max":"224.0.255.255"}
+98 {"min":"224.0.0.0", "max":"224.0.255.255"}
+99 {"min":"224.0.0.0", "max":"224.0.255.255"}
+100 {"min":"224.0.0.0", "max":"224.0.255.255"}
+
+-- !sql_num2string_ipv6 --
+1 ::1
+2 fc00::
+3 fdff:ffff:ffff:ffff:ffff:ffff:ffff:ffff
+4 fc00::
+5 febf:ffff:ffff:ffff:ffff:ffff:ffff:ffff
+6 fe80::
+7 ffff:ffff:ffff:ffff:ffff:ffff:ffff:ffff
+8 fe80::
+9 2001:4860:4860::8888
+10 2606:4700:4700::1111
+11 ff01::
+12 ff02::1
+13 2001:db8:85a3::8a2e:370:7334
+14 2001:db8::1
+15 2001:db8::2
+16 ::1
+17 ::
+18 ::
+19 fd00::
+20 ::
+21 ::
+22 ::
+23 ::
+24 ::
+25 ::
+26 ff01::
+27 ff02::1
+28 ff00::
+29 2001:db8::1
+30 2001:db8::2
+31 2001:db8::3
+32 2001:db8::4
+33 2001:db8::5
+34 2001:db8::6
+35 2001:db8::7
+36 2001:db8::8
+37 2001:db8::9
+38 2001:db8::a
+39 2001:db8::b
+40 2001:db8::c
+41 2001:db8::d
+42 2001:db8::e
+43 2001:db8::f
+44 2001:db8::10
+45 2001:db8::11
+46 2001:db8::12
+47 2001:db8::13
+48 2001:db8::14
+49 2001:db8::15
+50 2001:db8::16
+51 2001:db8::17
+52 2001:db8::18
+53 2001:db8::19
+54 2001:db8::1a
+55 2001:db8::1b
+56 2001:db8::1c
+57 2001:db8::1d
+58 2001:db8::1e
+59 2001:db8::1f
+60 2001:db8::20
+61 2001:db8::21
+62 2001:db8::22
+63 2001:db8::23
+64 2001:db8::24
+65 2001:db8::25
+66 2001:db8::26
+67 2001:db8::27
+68 2001:db8::28
+69 2001:db8::29
+70 2001:db8::2a
+71 2001:db8::2b
+72 2001:db8::2c
+73 2001:db8::2d
+74 2001:db8::2e
+75 2001:db8::2f
+76 2001:db8::30
+77 2001:db8::31
+78 2001:db8::32
+79 2001:db8::33
+80 2001:db8::34
+81 2001:db8::35
+82 2001:db8::36
+83 2001:db8::37
+84 2001:db8::38
+85 2001:db8::39
+86 2001:db8::3a
+87 2001:db8::3b
+88 ff01::1
+89 ff01::2
+90 ff01::3
+91 ff01::4
+92 ff01::5
+93 ff01::6
+94 ff01::7
+95 ff01::8
+96 ff01::9
+97 ff01::a
+98 ff01::b
+99 ff01::c
+100 ff01::d
+
+-- !sql_num2string_ipv4 --
+1 127.0.0.1
+2 10.0.0.0
+3 10.255.255.255
+4 172.16.0.0
+5 172.31.255.255
+6 192.168.0.0
+7 192.168.255.255
+8 169.254.0.0
+9 8.8.8.8
+10 1.1.1.1
+11 224.0.0.0
+12 239.255.255.255
+13 192.0.2.0
+14 203.0.113.0
+15 198.51.100.0
+16 0.0.0.0
+17 240.0.0.0
+18 255.255.255.255
+19 0.0.0.0
+20 0.0.0.0
+21 127.255.255.255
+22 128.0.0.0
+23 191.255.255.255
+24 192.0.0.0
+25 223.255.255.255
+26 224.0.0.0
+27 239.255.255.255
+28 0.0.0.0
+29 0.0.0.1
+30 0.0.1.10
+31 0.0.2.20
+32 0.0.3.30
+33 10.0.0.5
+34 10.0.1.15
+35 10.1.0.25
+36 10.2.0.35
+37 10.3.0.45
+38 10.4.0.55
+39 10.5.0.65
+40 10.6.0.75
+41 10.7.0.85
+42 10.8.0.95
+43 10.9.1.5
+44 10.10.1.15
+45 10.11.1.25
+46 10.12.1.35
+47 10.13.1.45
+48 10.14.1.55
+49 10.15.1.65
+50 10.16.1.75
+51 128.0.0.1
+52 128.1.0.10
+53 128.2.0.20
+54 128.3.0.30
+55 128.4.0.40
+56 128.5.0.50
+57 128.6.0.60
+58 128.7.0.70
+59 128.8.0.80
+60 128.9.0.90
+61 172.16.0.1
+62 172.16.0.5
+63 172.16.0.10
+64 172.16.0.15
+65 172.16.0.20
+66 172.16.0.25
+67 172.16.0.30
+68 172.16.0.35
+69 192.0.0.1
+70 192.0.0.2
+71 192.0.0.3
+72 192.0.0.4
+73 192.0.0.5
+74 192.0.0.6
+75 192.0.0.7
+76 192.0.0.8
+77 192.0.0.9
+78 192.0.0.10
+79 192.168.0.1
+80 192.168.0.2
+81 192.168.1.5
+82 192.168.1.10
+83 192.168.1.15
+84 192.168.1.20
+85 192.168.2.5
+86 192.168.2.10
+87 192.168.5.20
+88 224.0.0.1
+89 224.0.0.2
+90 224.0.0.3
+91 224.0.0.4
+92 224.0.0.5
+93 224.0.0.6
+94 224.0.0.7
+95 224.0.0.8
+96 224.0.0.9
+97 224.0.0.10
+98 224.0.0.11
+99 224.0.0.12
+100 224.0.0.13
+
+-- !sql_inet6_ntoa --
+1 ::1
+2 fc00::
+3 fdff:ffff:ffff:ffff:ffff:ffff:ffff:ffff
+4 fc00::
+5 febf:ffff:ffff:ffff:ffff:ffff:ffff:ffff
+6 fe80::
+7 ffff:ffff:ffff:ffff:ffff:ffff:ffff:ffff
+8 fe80::
+9 2001:4860:4860::8888
+10 2606:4700:4700::1111
+11 ff01::
+12 ff02::1
+13 2001:db8:85a3::8a2e:370:7334
+14 2001:db8::1
+15 2001:db8::2
+16 ::1
+17 ::
+18 ::
+19 fd00::
+20 ::
+21 ::
+22 ::
+23 ::
+24 ::
+25 ::
+26 ff01::
+27 ff02::1
+28 ff00::
+29 2001:db8::1
+30 2001:db8::2
+31 2001:db8::3
+32 2001:db8::4
+33 2001:db8::5
+34 2001:db8::6
+35 2001:db8::7
+36 2001:db8::8
+37 2001:db8::9
+38 2001:db8::a
+39 2001:db8::b
+40 2001:db8::c
+41 2001:db8::d
+42 2001:db8::e
+43 2001:db8::f
+44 2001:db8::10
+45 2001:db8::11
+46 2001:db8::12
+47 2001:db8::13
+48 2001:db8::14
+49 2001:db8::15
+50 2001:db8::16
+51 2001:db8::17
+52 2001:db8::18
+53 2001:db8::19
+54 2001:db8::1a
+55 2001:db8::1b
+56 2001:db8::1c
+57 2001:db8::1d
+58 2001:db8::1e
+59 2001:db8::1f
+60 2001:db8::20
+61 2001:db8::21
+62 2001:db8::22
+63 2001:db8::23
+64 2001:db8::24
+65 2001:db8::25
+66 2001:db8::26
+67 2001:db8::27
+68 2001:db8::28
+69 2001:db8::29
+70 2001:db8::2a
+71 2001:db8::2b
+72 2001:db8::2c
+73 2001:db8::2d
+74 2001:db8::2e
+75 2001:db8::2f
+76 2001:db8::30
+77 2001:db8::31
+78 2001:db8::32
+79 2001:db8::33
+80 2001:db8::34
+81 2001:db8::35
+82 2001:db8::36
+83 2001:db8::37
+84 2001:db8::38
+85 2001:db8::39
+86 2001:db8::3a
+87 2001:db8::3b
+88 ff01::1
+89 ff01::2
+90 ff01::3
+91 ff01::4
+92 ff01::5
+93 ff01::6
+94 ff01::7
+95 ff01::8
+96 ff01::9
+97 ff01::a
+98 ff01::b
+99 ff01::c
+100 ff01::d
+
+-- !sql_inet_ntoa --
+1 127.0.0.1
+2 10.0.0.0
+3 10.255.255.255
+4 172.16.0.0
+5 172.31.255.255
+6 192.168.0.0
+7 192.168.255.255
+8 169.254.0.0
+9 8.8.8.8
+10 1.1.1.1
+11 224.0.0.0
+12 239.255.255.255
+13 192.0.2.0
+14 203.0.113.0
+15 198.51.100.0
+16 0.0.0.0
+17 240.0.0.0
+18 255.255.255.255
+19 0.0.0.0
+20 0.0.0.0
+21 127.255.255.255
+22 128.0.0.0
+23 191.255.255.255
+24 192.0.0.0
+25 223.255.255.255
+26 224.0.0.0
+27 239.255.255.255
+28 0.0.0.0
+29 0.0.0.1
+30 0.0.1.10
+31 0.0.2.20
+32 0.0.3.30
+33 10.0.0.5
+34 10.0.1.15
+35 10.1.0.25
+36 10.2.0.35
+37 10.3.0.45
+38 10.4.0.55
+39 10.5.0.65
+40 10.6.0.75
+41 10.7.0.85
+42 10.8.0.95
+43 10.9.1.5
+44 10.10.1.15
+45 10.11.1.25
+46 10.12.1.35
+47 10.13.1.45
+48 10.14.1.55
+49 10.15.1.65
+50 10.16.1.75
+51 128.0.0.1
+52 128.1.0.10
+53 128.2.0.20
+54 128.3.0.30
+55 128.4.0.40
+56 128.5.0.50
+57 128.6.0.60
+58 128.7.0.70
+59 128.8.0.80
+60 128.9.0.90
+61 172.16.0.1
+62 172.16.0.5
+63 172.16.0.10
+64 172.16.0.15
+65 172.16.0.20
+66 172.16.0.25
+67 172.16.0.30
+68 172.16.0.35
+69 192.0.0.1
+70 192.0.0.2
+71 192.0.0.3
+72 192.0.0.4
+73 192.0.0.5
+74 192.0.0.6
+75 192.0.0.7
+76 192.0.0.8
+77 192.0.0.9
+78 192.0.0.10
+79 192.168.0.1
+80 192.168.0.2
+81 192.168.1.5
+82 192.168.1.10
+83 192.168.1.15
+84 192.168.1.20
+85 192.168.2.5
+86 192.168.2.10
+87 192.168.5.20
+88 224.0.0.1
+89 224.0.0.2
+90 224.0.0.3
+91 224.0.0.4
+92 224.0.0.5
+93 224.0.0.6
+94 224.0.0.7
+95 224.0.0.8
+96 224.0.0.9
+97 224.0.0.10
+98 224.0.0.11
+99 224.0.0.12
+100 224.0.0.13
+
+-- !sql_string2num_or_default_ipv6 --
+1 ���������������
+2 ����������������
+3 ����������������
+4 ����������������
+5 ����������������
+6 ����������������
+7 ����������������
+8 ����������������
+9 H`H`����������
+10 &G�G���������
+11 ���������������
+12 ��������������
+13 \r��������.ps4
+14 \r������������
+15 \r������������
+16 ���������������
+17 ����������������
+18 ����������������
+19 ����������������
+20 ����������������
+21 ����������������
+22 ����������������
+23 ����������������
+24 ����������������
+25 ����������������
+26 ���������������
+27 ��������������
+28 ����������������
+29 \r������������
+30 \r������������
+31 \r������������
+32 \r������������
+33 \r������������
+34 \r������������
+35 \r������������
+36 \r������������
+37 \r������������\
+38 \r������������\n
+39 \r������������
+40 \r������������
+41 \r������������\r
+42 \r������������
+43 \r������������
+44 \r������������
+45 \r������������
+46 \r������������
+47 \r������������
+48 \r������������
+49 \r������������
+50 \r������������
+51 \r������������
+52 \r������������
+53 \r������������
+54 \r������������
+55 \r������������
+56 \r������������
+57 \r������������
+58 \r������������
+59 \r������������
+60 \r������������
+61 \r������������!
+62 \r������������"
+63 \r������������#
+64 \r������������$
+65 \r������������%
+66 \r������������&
+67 \r������������'
+68 \r������������(
+69 \r������������)
+70 \r������������*
+71 \r������������+
+72 \r������������,
+73 \r������������-
+74 \r������������.
+75 \r������������/
+76 \r������������0
+77 \r������������1
+78 \r������������2
+79 \r������������3
+80 \r������������4
+81 \r������������5
+82 \r������������6
+83 \r������������7
+84 \r������������8
+85 \r������������9
+86 \r������������:
+87 \r������������;
+88 ��������������
+89 ��������������
+90 ��������������
+91 ��������������
+92 ��������������
+93 ��������������
+94 ��������������
+95 ��������������
+96 ��������������\
+97 ��������������\n
+98 ��������������
+99 ��������������
+100 ��������������\r
+
+-- !sql_string2num_or_default_ipv4 --
+1 2130706433
+2 167772160
+3 184549375
+4 2886729728
+5 2887778303
+6 3232235520
+7 3232301055
+8 2851995648
+9 134744072
+10 16843009
+11 3758096384
+12 4026531839
+13 3221225984
+14 3405803776
+15 3325256704
+16 0
+17 4026531840
+18 4294967295
+19 0
+20 0
+21 2147483647
+22 2147483648
+23 3221225471
+24 3221225472
+25 3758096383
+26 3758096384
+27 4026531839
+28 0
+29 1
+30 266
+31 532
+32 798
+33 167772165
+34 167772431
+35 167837721
+36 167903267
+37 167968813
+38 168034359
+39 168099905
+40 168165451
+41 168230997
+42 168296543
+43 168362245
+44 168427791
+45 168493337
+46 168558883
+47 168624429
+48 168689975
+49 168755521
+50 168821067
+51 2147483649
+52 2147549194
+53 2147614740
+54 2147680286
+55 2147745832
+56 2147811378
+57 2147876924
+58 2147942470
+59 2148008016
+60 2148073562
+61 2886729729
+62 2886729733
+63 2886729738
+64 2886729743
+65 2886729748
+66 2886729753
+67 2886729758
+68 2886729763
+69 3221225473
+70 3221225474
+71 3221225475
+72 3221225476
+73 3221225477
+74 3221225478
+75 3221225479
+76 3221225480
+77 3221225481
+78 3221225482
+79 3232235521
+80 3232235522
+81 3232235781
+82 3232235786
+83 3232235791
+84 3232235796
+85 3232236037
+86 3232236042
+87 3232236820
+88 3758096385
+89 3758096386
+90 3758096387
+91 3758096388
+92 3758096389
+93 3758096390
+94 3758096391
+95 3758096392
+96 3758096393
+97 3758096394
+98 3758096395
+99 3758096396
+100 3758096397
+
+-- !sql_string2num_or_null_ipv6 --
+1 ���������������
+2 ����������������
+3 ����������������
Review Comment:
is these messy result correct?
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org
For queries about this service, please contact Infrastructure at:
us...@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org
For additional commands, e-mail: commits-h...@doris.apache.org
