(SEMANTIC CHANGE) update-objects-joins now simpler and more predicatble

[clsql.git] / tests / ds-employees.lisp

diff --git a/tests/ds-employees.lisp b/tests/ds-employees.lisp
index 6c464d13bd1588d53c9f8695c534da644e4f4041..55312a4e9cb35b6a455d3273d4bd3cee2854c249 100644 (file)
--- a/tests/ds-employees.lisp
+++ b/tests/ds-employees.lisp
@@ -1,6 +1,6 @@
 (in-package #:clsql-tests)
 
-#.(clsql:locally-enable-sql-reader-syntax)
+(clsql-sys:file-enable-sql-reader-syntax)
 (defparameter company1 nil)
 (defparameter employee1 nil)
 (defparameter employee2 nil)
@@ -14,11 +14,13 @@
 (defparameter employee10 nil)
 (defparameter address1 nil)
 (defparameter address2 nil)
+(defparameter address3 nil)
 (defparameter employee-address1 nil)
 (defparameter employee-address2 nil)
 (defparameter employee-address3 nil)
 (defparameter employee-address4 nil)
 (defparameter employee-address5 nil)
+(defparameter employee-address6 nil)
 
 (defclass thing ()
   ((extraterrestrial :initform nil :initarg :extraterrestrial)))
@@ -318,6 +320,8 @@
                                   :postal-code 123)
           address2 (make-instance 'address
                                   :addressid 2)
+          address3 (make-instance 'address
+                                  :addressid 3)
           employee-address1 (make-instance 'employee-address
                                            :emplid 1
                                            :addressid 1
@@ -336,7 +340,10 @@
                                            :verified nil)
           employee-address5 (make-instance 'employee-address
                                            :emplid 3
-                                           :addressid 2)))
+                                           :addressid 2)
+          employee-address6 (make-instance 'employee-address
+                                           :emplid 4
+                                           :addressid 3)))
 
   ;; sleep to ensure birthdays are no longer at current time
   ;(sleep 1) ;want to find the test that depends on it, put the sleep there.
@@ -394,5 +401,3 @@
               (ignore-errors
                 (clsql-sys:execute-command "DROP TABLE ea_join")))))
 
-#.(clsql:restore-sql-reader-syntax-state)
-