r9254: 4 May 2004 Kevin Rosenberg (kevin@rosenberg.net)

[clsql.git] / tests / test-syntax.lisp

diff --git a/tests/test-syntax.lisp b/tests/test-syntax.lisp
index 62fe3f33803283f59303c8fa32c2cfb036311081..2329a6c5035a55aa7460b0e2abbabf2d445da784 100644 (file)
--- a/tests/test-syntax.lisp
+++ b/tests/test-syntax.lisp
@@ -49,10 +49,9 @@
     (clsql:sql [foo bar])
   "FOO.BAR")
 
-;; not sure about this one 
 (deftest :syntax/ident/3
     (clsql:sql ["foo" bar])
-  "foo.BAR")
+  "FOO.BAR")
 
 ;(deftest :syntax/ident/4
 ;    (clsql:sql [foo "bar"])
@@ -60,17 +59,15 @@
 
 (deftest :syntax/ident/5
     (clsql:sql [foo :integer])
-  "FOO INTEGER")
+  "FOO")
 
 (deftest :syntax/ident/6
     (clsql:sql [foo bar :integer])
-  "FOO.BAR INTEGER")
+  "FOO.BAR")
 
-;; not sure about this one 
 (deftest :syntax/ident/7
     (clsql:sql ["foo" bar :integer])
-  "foo.BAR INTEGER")
-
+  "FOO.BAR")
 
 (deftest :syntax/value/1
     (clsql:sql [any '(3 4)])
@@ -121,6 +118,13 @@
     (clsql:sql [select [count [*]] :from [emp]])
   "SELECT COUNT(*) FROM EMP")
   
+(deftest :syntax/query/5
+    (string-downcase (clsql:sql [select 'employee]))
+  "(employee)")
+
+(deftest :syntax/query/6
+    (string-downcase (clsql:sql [select 'employee 'address]))
+  "(employee address)")
 
 (deftest :syntax/expression1
     (clsql:sql