(sort (mapcar #'string-downcase
(clsql:list-tables :owner *test-database-user*))
#'string<)
- ("addr" "big" "company" "ea_join" "employee" "type_bigint" "type_table"))
+ ("addr" "big" "company" "ea_join" "employee" "node" "setting"
+ "subloc" "theme" "type_bigint" "type_table" "user"))
;; create a table, test for its existence, drop it and test again
(deftest :fddl/table/2
(prog1
(progn
(clsql:create-table "MyMixedCase" '(([a] integer)))
- (clsql:execute-command "insert into MyMixedCase values (5)")
+ (clsql:execute-command "insert into \"MyMixedCase\" values (5)")
(clsql:insert-records :into "MyMixedCase" :values '(6))
(clsql:select [a] :from "MyMixedCase" :order-by '((a :asc))))
(clsql:drop-table "MyMixedCase"))