[DOC] Add example creating a value with a user-defined type

mihaibudiu · mihaibudiu · commit f42b1cc87faf · 2025-11-07T01:24:08.000Z
Signed-off-by: Mihai Budiu &lt;mbudiu@feldera.com&gt;
diff --git a/docs.feldera.com/docs/sql/types.md b/docs.feldera.com/docs/sql/types.md
@@ -156,6 +156,15 @@ employee_typ(315, 'Francis', 'Logan', 'FLOGAN',
      address_typ('376 Mission', 'San Francisco', 'CA', '94222'))
 ```
 
+Here is an example query creating an object with the user-defined type
+`address_typ` defined above (the `CREATE TYPE` definition should be in
+the same program):
+
+```sql
+CREATE TABLE T(street VARCHAR, city VARCHAR, year INT);
+CREATE VIEW V AS SELECT address_typ(T.street, city, 'CA', 94087) as address, T.year as year FROM T;
+```
+
 Tables can have structure-valued columns, but these have to be fully
 qualified using both the table name and the column name in programs:
 
diff --git a/sql-to-dbsp-compiler/SQL-compiler/src/test/java/org/dbsp/sqlCompiler/compiler/sql/OtherTests.java b/sql-to-dbsp-compiler/SQL-compiler/src/test/java/org/dbsp/sqlCompiler/compiler/sql/OtherTests.java
@@ -611,6 +611,18 @@ public void testCompilerToPng() throws IOException, SQLException {
         ImageIO.read(new File(png.getPath()));
     }
 
+    @Test
+    public void testUDT() {
+        this.getCCS("""
+                CREATE TYPE address_typ AS (
+                   street          VARCHAR(30),
+                   city            VARCHAR(20),
+                   state           CHAR(2),
+                   postal_code     VARCHAR(6));
+                CREATE TABLE T(street VARCHAR, city VARCHAR, year INT);
+                CREATE VIEW V AS SELECT address_typ(T.street, city, 'CA', 94087) as address, T.year as year FROM T;""");
+    }
+
     @Test
     public void rawCalciteTest() throws SQLException {
         Connection connection = DriverManager.getConnection("jdbc:calcite:");
