test: add a case for duplicate columns

gluesql · Nov 9, 2022 · b219726 · b219726
1 parent 6d147f5
commit b219726
Showing 1 changed file with 5 additions and 0 deletions.
diff --git a/test-suite/src/alter/create_table.rs b/test-suite/src/alter/create_table.rs
@@ -129,6 +129,11 @@ test_case!(create_table, async move {
             "CREATE TABLE TargetTableWithData2 AS SELECT * FROM NonExistentTable",
             Err(AlterError::CtasSourceTableNotFound("NonExistentTable".to_owned()).into()),
         ),
+        (
+            // Cannot create table with duplicate column name
+            "CREATE TABLE DuplicateColumns (id INT, id INT)",
+            Err(AlterError::DuplicateColumnName("id".to_owned()).into()),
+        ),
     ];
 
     for (sql, expected) in test_cases {