Teach expressions how to deal with identity columns

  prev: 667c9db132c12759b33419fd408c0718d4694cb3

diff --git a/sql/expressions.lisp b/sql/expressions.lisp
index 45d4631b5eaccf70b878b49a6b79907b9d4930c4..2b9b913da4685ed9180d0abd5156015092037ff9 100644 (file)
--- a/sql/expressions.lisp
+++ b/sql/expressions.lisp
@@ -991,7 +991,9 @@ uninclusive, and the args from that keyword to the end."
    (cons (symbol-name-default-case "ZEROFILL") "ZEROFILL")
    (cons (symbol-name-default-case "AUTO-INCREMENT") "AUTO_INCREMENT")
    (cons (symbol-name-default-case "DEFAULT") "DEFAULT")
-   (cons (symbol-name-default-case "UNIQUE") "UNIQUE")))
+   (cons (symbol-name-default-case "UNIQUE") "UNIQUE")
+   (cons (symbol-name-default-case "IDENTITY") "IDENTITY (1,1)") ;; added for sql-server support
+   ))
 
 (defmethod database-constraint-statement (constraint-list database)
   (declare (ignore database))