X-Git-Url: http://git.kpe.io/?a=blobdiff_plain;f=sql%2Foodml.lisp;h=499a4ed64a95190896eaafa2cd68e23937a4d851;hb=d528dfe7e23fe5732fdbf1a282498fbec298d6cd;hp=d701f0906e3a2352cbf01262c8b4179f6b02990a;hpb=bb71f27c241187a32c7839aea501114d65e29f85;p=clsql.git

diff --git a/sql/oodml.lisp b/sql/oodml.lisp
index d701f09..499a4ed 100644
--- a/sql/oodml.lisp
+++ b/sql/oodml.lisp
@@ -315,7 +315,15 @@
   (declare (ignore database db-type))
   (if args
       (format nil "INT(~A)" (car args))
-      "INT"))
+    "INT"))
+
+(deftype smallint () 
+  "An integer smaller than a 32-bit integer, this width may vary by SQL implementation."
+  'integer)
+
+(defmethod database-get-type-specifier ((type (eql 'smallint)) args database db-type)
+  (declare (ignore args database db-type))
+  "INT")
 
 (deftype bigint () 
   "An integer larger than a 32-bit integer, this width may vary by SQL implementation."
@@ -499,6 +507,14 @@
        (parse-integer val)))
     (number val)))
 
+(defmethod read-sql-value (val (type (eql 'smallint)) database db-type)
+  (declare (ignore database db-type))
+  (etypecase val
+    (string
+     (unless (string-equal "NIL" val)
+       (parse-integer val)))
+    (number val)))
+
 (defmethod read-sql-value (val (type (eql 'bigint)) database db-type)
   (declare (ignore database db-type))
   (etypecase val