Update doc for INET and MAC

crossdb-org · Nov 15, 2024 · 3b27e2e · 3b27e2e
1 parent 1ab9f4c
commit 3b27e2e
Show file tree

Hide file tree

Showing 3 changed files with 20 additions and 0 deletions.
diff --git a/docs/CHANGELOG.md b/docs/CHANGELOG.md
@@ -26,6 +26,19 @@
 - Support simple SQL inner join
 - Support new statements: `FLUSH` `REPAIR`
 
+## 0.12.0 <small>(2024-11-22)</small>
+
+**Features**
+
+- Support data types: `INET`(IPv4 and IPv6 host and subnet), `MAC` address
+- Support SQL statements: 
+
+**Improvements**
+
+**Test**
+
+**Bug Fixes**
+
 -->
 
 ## 0.11.0 <small>(2024-11-11)</small>

diff --git a/docs/client/api-c.md b/docs/client/api-c.md
@@ -433,6 +433,9 @@ typedef enum {
 	XDB_TYPE_BINARY     = 13, // fixed-length binary(at most 65535 byte)
 	XDB_TYPE_VCHAR      = 14, // varied-length string(at most 65535 byte)
 	XDB_TYPE_VBINARY    = 15, // varied-length binary(at most 65535 byte)
+	XDB_TYPE_BOOL		= 16, // 1 byte
+	XDB_TYPE_INET		= 17, // 18 bytes
+	XDB_TYPE_MAC		= 18, // 6 bytes
 	XDB_TYPE_MAX        = 21
 } xdb_type_t;
 ```

diff --git a/docs/sql/data-types.md b/docs/sql/data-types.md
@@ -22,6 +22,8 @@ template: overrides/blog.html
         VARCHAR [COLLATE collation_name] | User-defined, max 65535 | Variable-length UTF-8 string.	|
          BINARY     | User-defined, max 65535 | Fixed-length binary data. 		|
        VARBINARY    | User-defined, max 65535 | Variable-length binary data.	|
+        INET        | 18           | IPv4 or IPv6 address, and optionally subnet. |
+         MAC        | 6            | MAC addresses.	|
 
 ## Collation
 
@@ -40,6 +42,8 @@ template: overrides/blog.html
         Character   | `'abc'`, `"abc"`
         Binary      | `x'a23f5fde'`, `X'A23F5FDE'`, `0xa23f5fde`, `0XA23F5FDE`
       Timestamp     | `'2024-11-01'`, `'2024-11-01T19:05:12'`, `'2024-11-01T19:05:12.561'`, `'2024-11-01T19:05:12.561288'`, `1730459112561288`(*millisecond*)
+      Inet Address  | `'10.1.1.1'`, `'10.1.1.0/24'`, `'2001:4f8:3:ba:2e0:81ff:fe22:d1f1'`, `'2001:4f8:3:ba::/64'`
+      Mac Address   | `'08:00:2b:01:02:03'`, `'08-00-2b-01-02-03'`, `'0800.2b01.0203'`, `'0800-2b01-0203'`, `'08002b:010203'`, `'08002b-010203'`, `'08002b010203'`
 
 ## Escape Characters
 | **Escape Character**	| **Actual Meaning**