Reiner-Saddeys-MacBook-Pro:MsSqlConstraints rsaddey$ grails test-app integration:spock Welcome to Grails 1.3.7 - http://grails.org/ Licensed under Apache Standard License 2.0 Grails home is set to: /usr/local/java/grails Base Directory: /Users/rsaddey/Documents/workspace-sts-137/MsSqlConstraints Resolving dependencies... Dependencies resolved in 1306ms. Running script /usr/local/java/grails/scripts/TestApp.groovy Environment set to test [groovyc] Compiling 1 source file to /Users/rsaddey/Documents/workspace-sts-137/MsSqlConstraints/target/classes [mkdir] Created dir: /Users/rsaddey/Documents/workspace-sts-137/MsSqlConstraints/target/test-reports/html [mkdir] Created dir: /Users/rsaddey/Documents/workspace-sts-137/MsSqlConstraints/target/test-reports/plain Starting integration test phase ... 2011-12-18 11:40:06,259 [main] INFO bootstrap.BootStrap - ALTER TABLE [person] DROP CONSTRAINT [UQ__person__1214A8B544D52468] 2011-12-18 11:40:06,261 [main] INFO bootstrap.BootStrap - CREATE UNIQUE NONCLUSTERED INDEX [UQ__person__1214A8B544D52468] on [person] ([name],[first_name]) WHERE [first_name] IS NOT NULL 2011-12-18 11:40:06,261 [main] INFO bootstrap.BootStrap - ALTER TABLE [person] DROP CONSTRAINT [UQ__person__2A33069B47B19113] 2011-12-18 11:40:06,261 [main] INFO bootstrap.BootStrap - CREATE UNIQUE NONCLUSTERED INDEX [UQ__person__2A33069B47B19113] on [person] ([student_id]) WHERE [student_id] IS NOT NULL 2011-12-18 11:40:06,261 [main] INFO bootstrap.BootStrap - Preserving constraint UQ__person__83BE02414D6A6A69 on table person as it does not contain any nullable columns. 2011-12-18 11:40:06,262 [main] INFO bootstrap.BootStrap - ALTER TABLE [person] DROP CONSTRAINT [UQ__person__9493F2565046D714] 2011-12-18 11:40:06,262 [main] INFO bootstrap.BootStrap - CREATE UNIQUE NONCLUSTERED INDEX [UQ__person__9493F2565046D714] on [person] ([drivers_licence_number]) WHERE [drivers_licence_number] IS NOT NULL ------------------------------------------------------- Running 4 spock tests... Running test demo.MsSqlConstraintsSpec...2011-12-18 11:40:07,242 [main] ERROR util.JDBCExceptionReporter - Violation of UNIQUE KEY constraint 'UQ__person__83BE02414D6A6A69'. Cannot insert duplicate key in object 'dbo.person'. The duplicate key value is (soc 1). 2011-12-18 11:40:07,264 [main] ERROR util.JDBCExceptionReporter - Cannot insert duplicate key row in object 'dbo.person' with unique index 'UQ__person__C52E0BA94A8DFDBE'. The duplicate key value is (emp 1). 2011-12-18 11:40:07,308 [main] ERROR util.JDBCExceptionReporter - Cannot insert duplicate key row in object 'dbo.person' with unique index 'UQ__person__1214A8B544D52468'. The duplicate key value is (Brown, Bill). PASSED Tests Completed in 938ms ... ------------------------------------------------------- Tests passed: 4 Tests failed: 0 ------------------------------------------------------- [junitreport] Processing /Users/rsaddey/Documents/workspace-sts-137/MsSqlConstraints/target/test-reports/TESTS-TestSuites.xml to /var/folders/h9/h10t95696fg82tsqndvg6tdr0000gn/T/null689337353 [junitreport] Loading stylesheet /usr/local/java/grails/lib/junit-frames.xsl [junitreport] Transform time: 334ms [junitreport] Deleting: /var/folders/h9/h10t95696fg82tsqndvg6tdr0000gn/T/null689337353 Tests PASSED - view reports in target/test-reports Application context shutting down... Application context shutdown. Reiner-Saddeys-MacBook-Pro:MsSqlConstraints rsaddey$