Changeset: 1497a4907297 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/1497a4907297
Added Files:
        sql/test/Tests/inet4.test
        sql/test/Tests/inet6.test
Modified Files:
        sql/test/Tests/All
Branch: Dec2025
Log Message:

Add tests for inet4 and inet6


diffs (75 lines):

diff --git a/sql/test/Tests/All b/sql/test/Tests/All
--- a/sql/test/Tests/All
+++ b/sql/test/Tests/All
@@ -150,3 +150,6 @@ as3ap
 orderby-nulls-first-last
 
 blob_query
+
+inet4
+inet6
diff --git a/sql/test/Tests/inet4.test b/sql/test/Tests/inet4.test
new file mode 100644
--- /dev/null
+++ b/sql/test/Tests/inet4.test
@@ -0,0 +1,24 @@
+
+query T
+select inet4 '127.0.0.1'
+----
+127.0.0.1
+
+query T
+select inet4 '127.000.000.001'
+----
+127.0.0.1
+
+query T
+select inet4 '127.000.000000000000000000.001'
+----
+127.0.0.1
+
+# out of range
+statement error
+select inet4 '256.0.0.1'
+
+# 0.0.0.0 is reserved for the nil representation
+statement error
+select inet4 '0.0.0.0'
+
diff --git a/sql/test/Tests/inet6.test b/sql/test/Tests/inet6.test
new file mode 100644
--- /dev/null
+++ b/sql/test/Tests/inet6.test
@@ -0,0 +1,31 @@
+
+query T
+select inet6 '::1'
+----
+::1
+
+query T
+select inet6 '::1:0'
+----
+::1:0
+
+query T
+select inet6 '1111:2222:3333:4444:5555:6666:7777:8888'
+----
+1111:2222:3333:4444:5555:6666:7777:8888
+
+query T
+select inet6 '1111:0:0:4444:5555:0:0:8888'
+----
+1111::4444:5555:0:0:8888
+
+query T
+select inet6 '1111:2222:3333:4444:5555:0:0:0'
+----
+1111:2222:3333:4444:5555::
+
+query T
+select inet6 'ffee:ddcc:bbaa:9988:7766:5544:3322:1100'
+----
+ffee:ddcc:bbaa:9988:7766:5544:3322:1100
+
_______________________________________________
checkin-list mailing list -- [email protected]
To unsubscribe send an email to [email protected]

Reply via email to