iX0EU7YC

1PS C:\Users\claco\activerecord-sqlserver-adapter> bundle exec rake test:odbc
2(in C:/Users/claco/activerecord-sqlserver-adapter)
3C:/Ruby192/bin/ruby.exe -I"lib;test;test/connections/native_sqlserver_odbc;C:\Users\claco\rails/activerecord/test" "C:/Ruby192/lib/ruby/1.9.1/rake/rake_test_loader.rb" "test/cases/aaaa_create_tables_test_sqlserver.rb" "test/cases/adapter_test_sqlserver.rb" "test/cases/attribute_methods_test_sqlserver.rb" "test/cases/belongs_to_associations_test_sqlserver.rb" "test/cases/calculations_test_sqlserver.rb" "test/cases/column_test_sqlserver.rb" "test/cases/connection_test_sqlserver.rb" "test/cases/eager_test_sqlserver.rb" "test/cases/execute_procedure_test_sqlserver.rb" "test/cases/finder_test_sqlserver.rb" "test/cases/has_and_belongs_to_many_associations_test_sqlserver.rb" "test/cases/inheritance_test_sqlserver.rb" "test/cases/method_scoping_test_sqlserver.rb" "test/cases/migration_test_sqlserver.rb" "test/cases/offset_and_limit_test_sqlserver.rb" "test/cases/pessimistic_locking_test_sqlserver.rb" "test/cases/query_cache_test_sqlserver.rb" "test/cases/schema_dumper_test_sqlserver.rb" "test/cases/session_test_sqlserver.rb" "test/cases/specific_schema_test_sqlserver.rb" "test/cases/table_name_test_sqlserver.rb" "test/cases/transaction_test_sqlserver.rb" "test/cases/unicode_test_sqlserver.rb" "test/cases/uniqueness_validation_test_sqlserver.rb"
4Using SQLServer via ODBC to activerecord_unittest
5With enabled unicode string types
6  * DEFERRED: For abstract behavior with different language should do a date insertion when language is german.
7Loaded suite C:/Ruby192/lib/ruby/1.9.1/rake/rake_test_loader
8Started
9..................................................F..............................................................................................E.........................F.F.
10Finished in 18.627862 seconds.
11
12  1) Failure:
13test: For views that have more than 4000 chars for their defintion should using alternate view defintion still be able to find real default. (AdapterTestSqlserver) [test/cases/adapter_test_sqlserver.rb:570]:
14#<ActiveRecord::ConnectionAdapters::SQLServerColumn:0x30bb938 @sqlserver_options={:table_name=>"string_defaults_big_view", :numeric_scale=>nil, :numeric_precision=>nil, :length=>255, :is_identity=>nil, :database_year=>2008}, @null=true, @sql_type="varchar(255)", @name="pretend_null", @scale=nil, @precision=nil, @limit=255, @type=:string, @default=nil, @primary=false>.
15<"null"> expected but was
16<nil>.
17
18  2) Error:
19test_coerced_schema_dump_keeps_large_precision_integer_columns_as_decimal(SchemaDumperTest):
20NameError: undefined local variable or method `standard_dump' for #<SchemaDumperTest:0x4de1538>
21    test/cases/schema_dumper_test_sqlserver.rb:81:in `test_coerced_schema_dump_keeps_large_precision_integer_columns_as_decimal'
22    C:/Ruby192/lib/ruby/gems/1.9.1/gems/mocha-0.9.8/lib/mocha/integration/mini_test/version_131_and_above.rb:26:in `run'
23    C:/Users/claco/rails/activesupport/lib/active_support/testing/setup_and_teardown.rb:35:in `block in run'
24    C:/Users/claco/rails/activesupport/lib/active_support/callbacks.rb:418:in `_run_setup_callbacks'
25    C:/Users/claco/rails/activesupport/lib/active_support/testing/setup_and_teardown.rb:34:in `run'
26
27  3) Failure:
28test: Testing basic saves and unicode limits should save and reload simple nchar string. (UnicodeTestSqlserver) [test/cases/unicode_test_sqlserver.rb:11]:
29<"A"> expected but was
30<"\x00m">.
31
32  4) Failure:
33test: Testing unicode data should insert and retrieve unicode data. (UnicodeTestSqlserver) [test/cases/unicode_test_sqlserver.rb:41]:
34perhaps you are not using the utf8 odbc that does this legwork.
35<"\u4E00\u4E8C34\u4E94\u516D"> expected but was
36<"\xE4\xB8\x80\xE4\xBA\x8C34\xE4\xBA\x94\xE5\x85\xAD">.
37
38175 tests, 436 assertions, 3 failures, 1 errors, 0 skips
39
40Test run options: --seed 52528
41rake aborted!
42Command failed with status (1): [C:/Ruby192/bin/ruby.exe -I"lib;test;test/c...]
43C:/Ruby192/lib/ruby/1.9.1/rake.rb:993:in `block in sh'
44C:/Ruby192/lib/ruby/1.9.1/rake.rb:1008:in `call'
45C:/Ruby192/lib/ruby/1.9.1/rake.rb:1008:in `sh'
46C:/Ruby192/lib/ruby/1.9.1/rake.rb:1092:in `sh'
47C:/Ruby192/lib/ruby/1.9.1/rake.rb:1027:in `ruby'
48C:/Ruby192/lib/ruby/1.9.1/rake.rb:1092:in `ruby'
49C:/Ruby192/lib/ruby/1.9.1/rake/testtask.rb:115:in `block (2 levels) in define'
50C:/Ruby192/lib/ruby/1.9.1/rake.rb:1110:in `verbose'
51C:/Ruby192/lib/ruby/1.9.1/rake/testtask.rb:100:in `block in define'
52C:/Ruby192/lib/ruby/1.9.1/rake.rb:634:in `call'
53C:/Ruby192/lib/ruby/1.9.1/rake.rb:634:in `block in execute'
54C:/Ruby192/lib/ruby/1.9.1/rake.rb:629:in `each'
55C:/Ruby192/lib/ruby/1.9.1/rake.rb:629:in `execute'
56C:/Ruby192/lib/ruby/1.9.1/rake.rb:595:in `block in invoke_with_call_chain'
57C:/Ruby192/lib/ruby/1.9.1/monitor.rb:201:in `mon_synchronize'
58C:/Ruby192/lib/ruby/1.9.1/rake.rb:588:in `invoke_with_call_chain'
59C:/Ruby192/lib/ruby/1.9.1/rake.rb:581:in `invoke'
60C:/Ruby192/lib/ruby/1.9.1/rake.rb:2041:in `invoke_task'
61C:/Ruby192/lib/ruby/1.9.1/rake.rb:2019:in `block (2 levels) in top_level'
62C:/Ruby192/lib/ruby/1.9.1/rake.rb:2019:in `each'
63C:/Ruby192/lib/ruby/1.9.1/rake.rb:2019:in `block in top_level'
64C:/Ruby192/lib/ruby/1.9.1/rake.rb:2058:in `standard_exception_handling'
65C:/Ruby192/lib/ruby/1.9.1/rake.rb:2013:in `top_level'
66C:/Ruby192/lib/ruby/1.9.1/rake.rb:1992:in `run'
67C:/Ruby192/bin/rake:31:in `<main>'
68
69-------
70
71
72
73
74D, [2011-01-06T09:38:00.904792 #11768] DEBUG -- :   EXECUTE (1.0ms)  USE [activerecord_unittest]
75  EXECUTE (2.0ms)  DROP TABLE [accounts]
76  EXECUTE (1.0ms)  CREATE TABLE [accounts] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [firm_id] integer, [firm_name] varchar(255), [credit_limit] integer) 
77  EXECUTE (1.0ms)  DROP TABLE [admin_accounts]
78  EXECUTE (1.0ms)  CREATE TABLE [admin_accounts] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [name] varchar(255)) 
79  EXECUTE (1.0ms)  DROP TABLE [admin_users]
80  EXECUTE (2.0ms)  CREATE TABLE [admin_users] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [name] varchar(255), [account_id] integer) 
81  EXECUTE (14.0ms)  DROP TABLE [audit_logs]
82  EXECUTE (2.0ms)  CREATE TABLE [audit_logs] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [message] varchar(255) NOT NULL, [developer_id] integer NOT NULL) 
83  EXECUTE (2.0ms)  DROP TABLE [authors]
84  EXECUTE (1.0ms)  CREATE TABLE [authors] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [name] varchar(255) NOT NULL, [author_address_id] integer, [author_address_extra_id] integer) 
85  EXECUTE (4.0ms)  DROP TABLE [author_addresses]
86  EXECUTE (1.0ms)  CREATE TABLE [author_addresses] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY) 
87  EXECUTE (2.0ms)  DROP TABLE [author_favorites]
88  EXECUTE (3.0ms)  CREATE TABLE [author_favorites] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [author_id] integer, [favorite_author_id] integer) 
89  EXECUTE (2.0ms)  DROP TABLE [auto_id_tests]
90  EXECUTE (2.0ms)  CREATE TABLE [auto_id_tests] ([auto_id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [value] integer) 
91  EXECUTE (5.0ms)  DROP TABLE [binaries]
92  EXECUTE (2.0ms)  CREATE TABLE [binaries] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [data] varbinary(max)) 
93  EXECUTE (2.0ms)  DROP TABLE [birds]
94  EXECUTE (2.0ms)  CREATE TABLE [birds] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [name] varchar(255), [color] varchar(255), [pirate_id] integer) 
95  EXECUTE (1.0ms)  DROP TABLE [books]
96  EXECUTE (2.0ms)  CREATE TABLE [books] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [name] varchar(255)) 
97  EXECUTE (4.0ms)  DROP TABLE [booleans]
98  EXECUTE (1.0ms)  CREATE TABLE [booleans] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [value] bit) 
99  EXECUTE (1.0ms)  DROP TABLE [CamelCase]
100  EXECUTE (1.0ms)  CREATE TABLE [CamelCase] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [name] varchar(255)) 
101  EXECUTE (37.0ms)  DROP TABLE [cars]
102  EXECUTE (2.0ms)  CREATE TABLE [cars] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [name] varchar(255), [engines_count] integer, [wheels_count] integer) 
103  EXECUTE (2.0ms)  DROP TABLE [categories]
104  EXECUTE (2.0ms)  CREATE TABLE [categories] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [name] varchar(255) NOT NULL, [type] varchar(255), [categorizations_count] integer) 
105  EXECUTE (2.0ms)  DROP TABLE [categories_posts]
106  EXECUTE (2.0ms)  CREATE TABLE [categories_posts] ([category_id] integer NOT NULL, [post_id] integer NOT NULL) 
107  EXECUTE (2.0ms)  DROP TABLE [categorizations]
108  EXECUTE (2.0ms)  CREATE TABLE [categorizations] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [category_id] integer, [post_id] integer, [author_id] integer) 
109  EXECUTE (1.0ms)  DROP TABLE [citations]
110  EXECUTE (2.0ms)  CREATE TABLE [citations] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [book1_id] integer, [book2_id] integer) 
111  EXECUTE (1.0ms)  DROP TABLE [clubs]
112  EXECUTE (2.0ms)  CREATE TABLE [clubs] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [name] varchar(255)) 
113  EXECUTE (20.0ms)  DROP TABLE [collections]
114  EXECUTE (2.0ms)  CREATE TABLE [collections] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [name] varchar(255)) 
115  EXECUTE (1.0ms)  DROP TABLE [colnametests]
116  EXECUTE (1.0ms)  CREATE TABLE [colnametests] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [references] integer NOT NULL) 
117  EXECUTE (2.0ms)  DROP TABLE [comments]
118  EXECUTE (2.0ms)  CREATE TABLE [comments] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [post_id] integer NOT NULL, [body] varchar(max) NOT NULL, [type] varchar(255)) 
119  EXECUTE (2.0ms)  DROP TABLE [companies]
120  EXECUTE (1.0ms)  CREATE TABLE [companies] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [type] varchar(255), [ruby_type] varchar(255), [firm_id] integer, [firm_name] varchar(255), [name] varchar(255), [client_of] integer, [rating] integer DEFAULT 1) 
121  SQL (15.0ms)  EXEC sp_helpindex [companies]
122  EXECUTE (14.0ms)  CREATE INDEX [company_index] ON [companies] ([firm_id], [type], [rating], [ruby_type])
123  EXECUTE (2.0ms)  DROP TABLE [computers]
124  EXECUTE (4.0ms)  CREATE TABLE [computers] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [developer] integer NOT NULL, [extendedWarranty] integer NOT NULL) 
125  EXECUTE (5.0ms)  DROP TABLE [contracts]
126  EXECUTE (2.0ms)  CREATE TABLE [contracts] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [developer_id] integer, [company_id] integer) 
127  EXECUTE (1.0ms)  DROP TABLE [customers]
128  EXECUTE (2.0ms)  CREATE TABLE [customers] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [name] varchar(255), [balance] integer DEFAULT 0, [address_street] varchar(255), [address_city] varchar(255), [address_country] varchar(255), [gps_location] varchar(255)) 
129  EXECUTE (1.0ms)  DROP TABLE [dashboards]
130  EXECUTE (2.0ms)  CREATE TABLE [dashboards] ([dashboard_id] varchar(255), [name] varchar(255)) 
131  EXECUTE (5.0ms)  DROP TABLE [developers]
132  EXECUTE (2.0ms)  CREATE TABLE [developers] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [name] varchar(255), [salary] integer DEFAULT 70000, [created_at] datetime, [updated_at] datetime) 
133  EXECUTE (1.0ms)  DROP TABLE [developers_projects]
134  EXECUTE (1.0ms)  CREATE TABLE [developers_projects] ([developer_id] integer NOT NULL, [project_id] integer NOT NULL, [joined_on] date, [access_level] integer DEFAULT 1) 
135  EXECUTE (76.0ms)  DROP TABLE [edges]
136  EXECUTE (2.0ms)  CREATE TABLE [edges] ([source_id] integer NOT NULL, [sink_id] integer NOT NULL) 
137  SQL (1.0ms)  EXEC sp_helpindex [edges]
138  EXECUTE (1.0ms)  CREATE UNIQUE INDEX [unique_edge_index] ON [edges] ([source_id], [sink_id])
139  EXECUTE (2.0ms)  DROP TABLE [engines]
140  EXECUTE (2.0ms)  CREATE TABLE [engines] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [car_id] integer) 
141  EXECUTE (2.0ms)  DROP TABLE [tyres]
142  EXECUTE (2.0ms)  CREATE TABLE [tyres] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [car_id] integer) 
143  EXECUTE (2.0ms)  DROP TABLE [bulbs]
144  EXECUTE (2.0ms)  CREATE TABLE [bulbs] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [car_id] integer, [name] varchar(255)) 
145  EXECUTE (2.0ms)  DROP TABLE [entrants]
146  EXECUTE (4.0ms)  CREATE TABLE [entrants] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [name] varchar(255) NOT NULL, [course_id] integer NOT NULL) 
147  EXECUTE (2.0ms)  DROP TABLE [essays]
148  EXECUTE (2.0ms)  CREATE TABLE [essays] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [name] varchar(255), [writer_id] varchar(255), [writer_type] varchar(255)) 
149  EXECUTE (2.0ms)  DROP TABLE [events]
150  EXECUTE (2.0ms)  CREATE TABLE [events] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [title] varchar(5)) 
151  EXECUTE (1.0ms)  DROP TABLE [funny_jokes]
152  EXECUTE (1.0ms)  CREATE TABLE [funny_jokes] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [name] varchar(255)) 
153  EXECUTE (19.0ms)  DROP TABLE [goofy_string_id]
154  EXECUTE (2.0ms)  CREATE TABLE [goofy_string_id] ([id] varchar(255) NOT NULL, [info] varchar(255)) 
155  EXECUTE (1.0ms)  DROP TABLE [invoices]
156  EXECUTE (2.0ms)  CREATE TABLE [invoices] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [balance] integer, [updated_at] datetime) 
157  EXECUTE (2.0ms)  DROP TABLE [items]
158  EXECUTE (1.0ms)  CREATE TABLE [items] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [name] varchar(255)) 
159  EXECUTE (2.0ms)  DROP TABLE [inept_wizards]
160  EXECUTE (1.0ms)  CREATE TABLE [inept_wizards] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [name] varchar(255) NOT NULL, [city] varchar(255) NOT NULL, [type] varchar(255)) 
161  EXECUTE (50.0ms)  DROP TABLE [jobs]
162  EXECUTE (3.0ms)  CREATE TABLE [jobs] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [ideal_reference_id] integer) 
163  EXECUTE (3.0ms)  DROP TABLE [keyboards]
164  EXECUTE (2.0ms)  CREATE TABLE [keyboards] ([key_number] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [name] varchar(255)) 
165  EXECUTE (3.0ms)  DROP TABLE [legacy_things]
166  EXECUTE (3.0ms)  CREATE TABLE [legacy_things] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [tps_report_number] integer, [version] integer DEFAULT 0 NOT NULL) 
167  EXECUTE (2.0ms)  DROP TABLE [line_items]
168  EXECUTE (2.0ms)  CREATE TABLE [line_items] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [invoice_id] integer, [amount] integer) 
169  EXECUTE (1.0ms)  DROP TABLE [lock_without_defaults]
170  EXECUTE (75.0ms)  CREATE TABLE [lock_without_defaults] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [lock_version] integer) 
171  EXECUTE (2.0ms)  DROP TABLE [lock_without_defaults_cust]
172  EXECUTE (2.0ms)  CREATE TABLE [lock_without_defaults_cust] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [custom_lock_version] integer) 
173  EXECUTE (2.0ms)  DROP TABLE [mateys]
174  EXECUTE (1.0ms)  CREATE TABLE [mateys] ([pirate_id] integer, [target_id] integer, [weight] integer) 
175  EXECUTE (1.0ms)  DROP TABLE [members]
176  EXECUTE (2.0ms)  CREATE TABLE [members] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [name] varchar(255), [member_type_id] integer) 
177  EXECUTE (2.0ms)  DROP TABLE [member_details]
178  EXECUTE (2.0ms)  CREATE TABLE [member_details] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [member_id] integer, [organization_id] integer, [extra_data] varchar(255)) 
179  EXECUTE (2.0ms)  DROP TABLE [memberships]
180  EXECUTE (2.0ms)  CREATE TABLE [memberships] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [joined_on] datetime, [club_id] integer, [member_id] integer, [favourite] bit DEFAULT 0, [type] varchar(255)) 
181  EXECUTE (1.0ms)  DROP TABLE [member_types]
182  EXECUTE (1.0ms)  CREATE TABLE [member_types] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [name] varchar(255)) 
183  EXECUTE (1.0ms)  DROP TABLE [references]
184  EXECUTE (2.0ms)  CREATE TABLE [references] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [person_id] integer, [job_id] integer, [favourite] bit, [lock_version] integer DEFAULT 0) 
185  EXECUTE (1.0ms)  DROP TABLE [minivans]
186  EXECUTE (1.0ms)  CREATE TABLE [minivans] ([minivan_id] varchar(255), [name] varchar(255), [speedometer_id] varchar(255), [color] varchar(255)) 
187  EXECUTE (2.0ms)  DROP TABLE [minimalistics]
188  EXECUTE (2.0ms)  CREATE TABLE [minimalistics] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY) 
189  EXECUTE (1.0ms)  DROP TABLE [mixed_case_monkeys]
190  EXECUTE (1.0ms)  CREATE TABLE [mixed_case_monkeys] ([monkeyID] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [fleaCount] integer) 
191  EXECUTE (1.0ms)  DROP TABLE [mixins]
192  EXECUTE (2.0ms)  CREATE TABLE [mixins] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [parent_id] integer, [pos] integer, [created_at] datetime, [updated_at] datetime, [lft] integer, [rgt] integer, [root_id] integer, [type] varchar(255)) 
193  EXECUTE (2.0ms)  DROP TABLE [movies]
194  EXECUTE (1.0ms)  CREATE TABLE [movies] ([movieid] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [name] varchar(255)) 
195  EXECUTE (2.0ms)  DROP TABLE [numeric_data]
196  EXECUTE (4.0ms)  CREATE TABLE [numeric_data] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [bank_balance] decimal(10,2), [big_bank_balance] decimal(15,2), [world_population] decimal(10,0), [my_house_population] decimal(2,0), [decimal_number_with_default] decimal(3,2) DEFAULT 2.78, [temperature] float(8), [atoms_in_universe] decimal(38,0)) 
197  EXECUTE (2.0ms)  DROP TABLE [orders]
198  EXECUTE (3.0ms)  CREATE TABLE [orders] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [name] varchar(255), [billing_customer_id] integer, [shipping_customer_id] integer) 
199  EXECUTE (4.0ms)  DROP TABLE [organizations]
200  EXECUTE (5.0ms)  CREATE TABLE [organizations] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [name] varchar(255)) 
201  EXECUTE (3.0ms)  DROP TABLE [owners]
202  EXECUTE (2.0ms)  CREATE TABLE [owners] ([owner_id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [name] varchar(255), [updated_at] datetime, [happy_at] datetime) 
203  EXECUTE (1.0ms)  DROP TABLE [paint_colors]
204  EXECUTE (2.0ms)  CREATE TABLE [paint_colors] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [non_poly_one_id] integer) 
205  EXECUTE (1.0ms)  DROP TABLE [paint_textures]
206  EXECUTE (2.0ms)  CREATE TABLE [paint_textures] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [non_poly_two_id] integer) 
207  EXECUTE (2.0ms)  DROP TABLE [parrots]
208  EXECUTE (2.0ms)  CREATE TABLE [parrots] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [name] varchar(255), [parrot_sti_class] varchar(255), [killer_id] integer, [created_at] datetime, [created_on] datetime, [updated_at] datetime, [updated_on] datetime) 
209  EXECUTE (2.0ms)  DROP TABLE [parrots_pirates]
210  EXECUTE (37.0ms)  CREATE TABLE [parrots_pirates] ([parrot_id] integer, [pirate_id] integer) 
211  EXECUTE (2.0ms)  DROP TABLE [parrots_treasures]
212  EXECUTE (2.0ms)  CREATE TABLE [parrots_treasures] ([parrot_id] integer, [treasure_id] integer) 
213  EXECUTE (1.0ms)  DROP TABLE [people]
214  EXECUTE (1.0ms)  CREATE TABLE [people] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [first_name] varchar(255) NOT NULL, [primary_contact_id] integer, [gender] varchar(1), [number1_fan_id] integer, [lock_version] integer DEFAULT 0 NOT NULL) 
215  EXECUTE (1.0ms)  DROP TABLE [pets]
216  EXECUTE (2.0ms)  CREATE TABLE [pets] ([pet_id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [name] varchar(255), [owner_id] integer, [integer] integer, [created_at] datetime, [updated_at] datetime) 
217  EXECUTE (2.0ms)  DROP TABLE [pirates]
218  EXECUTE (1.0ms)  CREATE TABLE [pirates] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [catchphrase] varchar(255), [parrot_id] integer, [created_on] datetime, [updated_on] datetime) 
219  EXECUTE (1.0ms)  DROP TABLE [posts]
220  EXECUTE (2.0ms)  CREATE TABLE [posts] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [author_id] integer, [title] varchar(255) NOT NULL, [body] varchar(max) NOT NULL, [type] varchar(255), [comments_count] integer DEFAULT 0, [taggings_count] integer DEFAULT 0) 
221  EXECUTE (1.0ms)  DROP TABLE [price_estimates]
222  EXECUTE (1.0ms)  CREATE TABLE [price_estimates] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [estimate_of_type] varchar(255), [estimate_of_id] integer, [price] integer) 
223  EXECUTE (1.0ms)  DROP TABLE [products]
224  EXECUTE (2.0ms)  CREATE TABLE [products] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [collection_id] integer, [name] varchar(255)) 
225  EXECUTE (1.0ms)  DROP TABLE [projects]
226  EXECUTE (2.0ms)  CREATE TABLE [projects] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [name] varchar(255), [type] varchar(255)) 
227  EXECUTE (2.0ms)  DROP TABLE [readers]
228  EXECUTE (2.0ms)  CREATE TABLE [readers] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [post_id] integer NOT NULL, [person_id] integer NOT NULL, [skimmer] bit DEFAULT 0) 
229  EXECUTE (4.0ms)  DROP TABLE [shape_expressions]
230  EXECUTE (2.0ms)  CREATE TABLE [shape_expressions] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [paint_type] varchar(255), [paint_id] integer, [shape_type] varchar(255), [shape_id] integer) 
231  EXECUTE (2.0ms)  DROP TABLE [ships]
232  EXECUTE (1.0ms)  CREATE TABLE [ships] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [name] varchar(255), [pirate_id] integer, [created_at] datetime, [created_on] datetime, [updated_at] datetime, [updated_on] datetime) 
233  EXECUTE (2.0ms)  DROP TABLE [ship_parts]
234  EXECUTE (2.0ms)  CREATE TABLE [ship_parts] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [name] varchar(255), [ship_id] integer) 
235  EXECUTE (4.0ms)  DROP TABLE [speedometers]
236  EXECUTE (1.0ms)  CREATE TABLE [speedometers] ([speedometer_id] varchar(255), [name] varchar(255), [dashboard_id] varchar(255)) 
237  EXECUTE (2.0ms)  DROP TABLE [sponsors]
238  EXECUTE (3.0ms)  CREATE TABLE [sponsors] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [club_id] integer, [sponsorable_id] integer, [sponsorable_type] varchar(255)) 
239  EXECUTE (1.0ms)  DROP TABLE [subscribers]
240  EXECUTE (2.0ms)  CREATE TABLE [subscribers] ([nick] varchar(255) NOT NULL, [name] varchar(255)) 
241  SQL (0.0ms)  EXEC sp_helpindex [subscribers]
242  EXECUTE (1.0ms)  CREATE UNIQUE INDEX [index_subscribers_on_nick] ON [subscribers] ([nick])
243  EXECUTE (2.0ms)  DROP TABLE [subscriptions]
244  EXECUTE (1.0ms)  CREATE TABLE [subscriptions] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [subscriber_id] varchar(255), [book_id] integer) 
245  EXECUTE (6.0ms)  DROP TABLE [tasks]
246  EXECUTE (2.0ms)  CREATE TABLE [tasks] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [starting] datetime, [ending] datetime) 
247  EXECUTE (76.0ms)  DROP TABLE [topics]
248  EXECUTE (4.0ms)  CREATE TABLE [topics] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [title] varchar(255), [author_name] varchar(255), [author_email_address] varchar(255), [written_on] datetime, [bonus_time] time, [last_read] date, [content] varchar(max), [approved] bit DEFAULT 1, [replies_count] integer DEFAULT 0, [parent_id] integer, [parent_title] varchar(255), [type] varchar(255), [group] varchar(255)) 
249  EXECUTE (2.0ms)  DROP TABLE [taggings]
250  EXECUTE (2.0ms)  CREATE TABLE [taggings] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [tag_id] integer, [super_tag_id] integer, [taggable_type] varchar(255), [taggable_id] integer) 
251  EXECUTE (2.0ms)  DROP TABLE [tags]
252  EXECUTE (2.0ms)  CREATE TABLE [tags] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [name] varchar(255), [taggings_count] integer DEFAULT 0) 
253  EXECUTE (2.0ms)  DROP TABLE [toys]
254  EXECUTE (2.0ms)  CREATE TABLE [toys] ([toy_id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [name] varchar(255), [pet_id] integer, [integer] integer, [created_at] datetime, [updated_at] datetime) 
255  EXECUTE (1.0ms)  DROP TABLE [traffic_lights]
256  EXECUTE (2.0ms)  CREATE TABLE [traffic_lights] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [location] varchar(255), [state] varchar(255), [created_at] datetime, [updated_at] datetime) 
257  EXECUTE (2.0ms)  DROP TABLE [treasures]
258  EXECUTE (2.0ms)  CREATE TABLE [treasures] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [name] varchar(255), [looter_id] integer, [looter_type] varchar(255)) 
259  EXECUTE (2.0ms)  DROP TABLE [variants]
260  EXECUTE (2.0ms)  CREATE TABLE [variants] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [product_id] integer, [name] varchar(255)) 
261  EXECUTE (2.0ms)  DROP TABLE [vertices]
262  EXECUTE (1.0ms)  CREATE TABLE [vertices] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [label] varchar(255)) 
263  EXECUTE (5.0ms)  DROP TABLE [warehouse-things]
264  EXECUTE (3.0ms)  CREATE TABLE [warehouse-things] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [value] integer) 
265  EXECUTE (1.0ms)  DROP TABLE [circles]
266  EXECUTE (16.0ms)  CREATE TABLE [circles] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY) 
267  EXECUTE (3.0ms)  DROP TABLE [squares]
268  EXECUTE (3.0ms)  CREATE TABLE [squares] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY) 
269  EXECUTE (2.0ms)  DROP TABLE [triangles]
270  EXECUTE (2.0ms)  CREATE TABLE [triangles] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY) 
271  EXECUTE (2.0ms)  DROP TABLE [non_poly_ones]
272  EXECUTE (3.0ms)  CREATE TABLE [non_poly_ones] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY) 
273  EXECUTE (3.0ms)  DROP TABLE [non_poly_twos]
274  EXECUTE (3.0ms)  CREATE TABLE [non_poly_twos] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY) 
275  EXECUTE (2.0ms)  DROP TABLE [guids]
276  EXECUTE (2.0ms)  CREATE TABLE [guids] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [key] varchar(255)) 
277  EXECUTE (42.0ms)  DROP TABLE [integer_limits]
278  EXECUTE (3.0ms)  CREATE TABLE [integer_limits] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [c_int_without_limit] integer, [c_int_1] smallint, [c_int_2] smallint, [c_int_3] integer, [c_int_4] integer, [c_int_5] bigint, [c_int_6] bigint, [c_int_7] bigint, [c_int_8] bigint) 
279  EXECUTE (2.0ms)  DROP TABLE [men]
280  EXECUTE (2.0ms)  CREATE TABLE [men] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [name] varchar(255)) 
281  EXECUTE (3.0ms)  DROP TABLE [faces]
282  EXECUTE (2.0ms)  CREATE TABLE [faces] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [description] varchar(255), [man_id] integer, [polymorphic_man_id] integer, [polymorphic_man_type] varchar(255)) 
283  EXECUTE (2.0ms)  DROP TABLE [interests]
284  EXECUTE (2.0ms)  CREATE TABLE [interests] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [topic] varchar(255), [man_id] integer, [polymorphic_man_id] integer, [polymorphic_man_type] varchar(255), [zine_id] integer) 
285  EXECUTE (2.0ms)  DROP TABLE [wheels]
286  EXECUTE (2.0ms)  CREATE TABLE [wheels] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [wheelable_id] integer, [wheelable_type] varchar(255)) 
287  EXECUTE (2.0ms)  DROP TABLE [zines]
288  EXECUTE (2.0ms)  CREATE TABLE [zines] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [title] varchar(255)) 
289  EXECUTE (2.0ms)  DROP TABLE [countries]
290  EXECUTE (2.0ms)  CREATE TABLE [countries] ([country_id] varchar(255), [name] varchar(255)) 
291  EXECUTE (1.0ms)  DROP TABLE [treaties]
292  EXECUTE (2.0ms)  CREATE TABLE [treaties] ([treaty_id] varchar(255), [name] varchar(255)) 
293  EXECUTE (3.0ms)  DROP TABLE [countries_treaties]
294  EXECUTE (2.0ms)  CREATE TABLE [countries_treaties] ([country_id] varchar(255) NOT NULL, [treaty_id] varchar(255) NOT NULL, [created_at] datetime, [updated_at] datetime) 
295  EXECUTE (1.0ms)  DROP TABLE [liquid]
296  EXECUTE (1.0ms)  CREATE TABLE [liquid] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [name] varchar(255)) 
297  EXECUTE (1.0ms)  DROP TABLE [molecules]
298  EXECUTE (2.0ms)  CREATE TABLE [molecules] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [liquid_id] integer, [name] varchar(255)) 
299  EXECUTE (1.0ms)  DROP TABLE [electrons]
300  EXECUTE (2.0ms)  CREATE TABLE [electrons] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [molecule_id] integer, [name] varchar(255)) 
301  EXECUTE (78.0ms)  DROP TABLE [fk_test_has_fk]
302  EXECUTE (6.0ms)  CREATE TABLE [fk_test_has_fk] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [fk_id] integer NOT NULL) 
303  EXECUTE (2.0ms)  DROP TABLE [fk_test_has_pk]
304  EXECUTE (3.0ms)  CREATE TABLE [fk_test_has_pk] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY) 
305  EXECUTE (3.0ms)  ALTER TABLE fk_test_has_fk ADD CONSTRAINT fk_name FOREIGN KEY ([fk_id]) REFERENCES [fk_test_has_pk] ([id])
306  EXECUTE (1.0ms)  USE [activerecord_unittest2]
307  EXECUTE (11.0ms)  DROP TABLE [courses]
308  EXECUTE (2.0ms)  CREATE TABLE [courses] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [name] varchar(255) NOT NULL) 
309  EXECUTE (7.0ms)  DROP TABLE [accounts]
310  EXECUTE (1.0ms)  CREATE TABLE [accounts] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [firm_id] integer, [firm_name] varchar(255), [credit_limit] integer) 
311  EXECUTE (1.0ms)  DROP TABLE [admin_accounts]
312  EXECUTE (1.0ms)  CREATE TABLE [admin_accounts] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [name] varchar(255)) 
313  EXECUTE (1.0ms)  DROP TABLE [admin_users]
314  EXECUTE (1.0ms)  CREATE TABLE [admin_users] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [name] varchar(255), [account_id] integer) 
315  EXECUTE (1.0ms)  DROP TABLE [audit_logs]
316  EXECUTE (1.0ms)  CREATE TABLE [audit_logs] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [message] varchar(255) NOT NULL, [developer_id] integer NOT NULL) 
317  EXECUTE (6.0ms)  DROP TABLE [authors]
318  EXECUTE (2.0ms)  CREATE TABLE [authors] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [name] varchar(255) NOT NULL, [author_address_id] integer, [author_address_extra_id] integer) 
319  EXECUTE (1.0ms)  DROP TABLE [author_addresses]
320  EXECUTE (3.0ms)  CREATE TABLE [author_addresses] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY) 
321  EXECUTE (2.0ms)  DROP TABLE [author_favorites]
322  EXECUTE (2.0ms)  CREATE TABLE [author_favorites] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [author_id] integer, [favorite_author_id] integer) 
323  EXECUTE (2.0ms)  DROP TABLE [auto_id_tests]
324  EXECUTE (3.0ms)  CREATE TABLE [auto_id_tests] ([auto_id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [value] integer) 
325  EXECUTE (2.0ms)  DROP TABLE [binaries]
326  EXECUTE (2.0ms)  CREATE TABLE [binaries] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [data] varbinary(max)) 
327  EXECUTE (1.0ms)  DROP TABLE [birds]
328  EXECUTE (5.0ms)  CREATE TABLE [birds] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [name] varchar(255), [color] varchar(255), [pirate_id] integer) 
329  EXECUTE (3.0ms)  DROP TABLE [books]
330  EXECUTE (2.0ms)  CREATE TABLE [books] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [name] varchar(255)) 
331  EXECUTE (2.0ms)  DROP TABLE [booleans]
332  EXECUTE (1.0ms)  CREATE TABLE [booleans] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [value] bit) 
333  EXECUTE (2.0ms)  DROP TABLE [CamelCase]
334  EXECUTE (2.0ms)  CREATE TABLE [CamelCase] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [name] varchar(255)) 
335  EXECUTE (63.0ms)  DROP TABLE [cars]
336  EXECUTE (2.0ms)  CREATE TABLE [cars] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [name] varchar(255), [engines_count] integer, [wheels_count] integer) 
337  EXECUTE (2.0ms)  DROP TABLE [categories]
338  EXECUTE (2.0ms)  CREATE TABLE [categories] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [name] varchar(255) NOT NULL, [type] varchar(255), [categorizations_count] integer) 
339  EXECUTE (2.0ms)  DROP TABLE [categories_posts]
340  EXECUTE (2.0ms)  CREATE TABLE [categories_posts] ([category_id] integer NOT NULL, [post_id] integer NOT NULL) 
341  EXECUTE (2.0ms)  DROP TABLE [categorizations]
342  EXECUTE (3.0ms)  CREATE TABLE [categorizations] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [category_id] integer, [post_id] integer, [author_id] integer) 
343  EXECUTE (2.0ms)  DROP TABLE [citations]
344  EXECUTE (2.0ms)  CREATE TABLE [citations] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [book1_id] integer, [book2_id] integer) 
345  EXECUTE (2.0ms)  DROP TABLE [clubs]
346  EXECUTE (2.0ms)  CREATE TABLE [clubs] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [name] varchar(255)) 
347  EXECUTE (1.0ms)  DROP TABLE [collections]
348  EXECUTE (2.0ms)  CREATE TABLE [collections] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [name] varchar(255)) 
349  EXECUTE (2.0ms)  DROP TABLE [colnametests]
350  EXECUTE (1.0ms)  CREATE TABLE [colnametests] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [references] integer NOT NULL) 
351  EXECUTE (1.0ms)  DROP TABLE [comments]
352  EXECUTE (2.0ms)  CREATE TABLE [comments] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [post_id] integer NOT NULL, [body] varchar(max) NOT NULL, [type] varchar(255)) 
353  EXECUTE (2.0ms)  DROP TABLE [companies]
354  EXECUTE (2.0ms)  CREATE TABLE [companies] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [type] varchar(255), [ruby_type] varchar(255), [firm_id] integer, [firm_name] varchar(255), [name] varchar(255), [client_of] integer, [rating] integer DEFAULT 1) 
355  SQL (12.0ms)  EXEC sp_helpindex [companies]
356  EXECUTE (1.0ms)  CREATE INDEX [company_index] ON [companies] ([firm_id], [type], [rating], [ruby_type])
357  EXECUTE (1.0ms)  DROP TABLE [computers]
358  EXECUTE (1.0ms)  CREATE TABLE [computers] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [developer] integer NOT NULL, [extendedWarranty] integer NOT NULL) 
359  EXECUTE (4.0ms)  DROP TABLE [contracts]
360  EXECUTE (3.0ms)  CREATE TABLE [contracts] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [developer_id] integer, [company_id] integer) 
361  EXECUTE (2.0ms)  DROP TABLE [customers]
362  EXECUTE (5.0ms)  CREATE TABLE [customers] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [name] varchar(255), [balance] integer DEFAULT 0, [address_street] varchar(255), [address_city] varchar(255), [address_country] varchar(255), [gps_location] varchar(255)) 
363  EXECUTE (1.0ms)  DROP TABLE [dashboards]
364  EXECUTE (5.0ms)  CREATE TABLE [dashboards] ([dashboard_id] varchar(255), [name] varchar(255)) 
365  EXECUTE (1.0ms)  DROP TABLE [developers]
366  EXECUTE (1.0ms)  CREATE TABLE [developers] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [name] varchar(255), [salary] integer DEFAULT 70000, [created_at] datetime, [updated_at] datetime) 
367  EXECUTE (1.0ms)  DROP TABLE [developers_projects]
368  EXECUTE (3.0ms)  CREATE TABLE [developers_projects] ([developer_id] integer NOT NULL, [project_id] integer NOT NULL, [joined_on] date, [access_level] integer DEFAULT 1) 
369  EXECUTE (3.0ms)  DROP TABLE [edges]
370  EXECUTE (1.0ms)  CREATE TABLE [edges] ([source_id] integer NOT NULL, [sink_id] integer NOT NULL) 
371  SQL (1.0ms)  EXEC sp_helpindex [edges]
372  EXECUTE (1.0ms)  CREATE UNIQUE INDEX [unique_edge_index] ON [edges] ([source_id], [sink_id])
373  EXECUTE (4.0ms)  DROP TABLE [engines]
374  EXECUTE (1.0ms)  CREATE TABLE [engines] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [car_id] integer) 
375  EXECUTE (1.0ms)  DROP TABLE [tyres]
376  EXECUTE (1.0ms)  CREATE TABLE [tyres] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [car_id] integer) 
377  EXECUTE (1.0ms)  DROP TABLE [bulbs]
378  EXECUTE (1.0ms)  CREATE TABLE [bulbs] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [car_id] integer, [name] varchar(255)) 
379  EXECUTE (7.0ms)  DROP TABLE [entrants]
380  EXECUTE (2.0ms)  CREATE TABLE [entrants] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [name] varchar(255) NOT NULL, [course_id] integer NOT NULL) 
381  EXECUTE (7.0ms)  DROP TABLE [essays]
382  EXECUTE (1.0ms)  CREATE TABLE [essays] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [name] varchar(255), [writer_id] varchar(255), [writer_type] varchar(255)) 
383  EXECUTE (1.0ms)  DROP TABLE [events]
384  EXECUTE (2.0ms)  CREATE TABLE [events] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [title] varchar(5)) 
385  EXECUTE (2.0ms)  DROP TABLE [funny_jokes]
386  EXECUTE (1.0ms)  CREATE TABLE [funny_jokes] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [name] varchar(255)) 
387  EXECUTE (1.0ms)  DROP TABLE [goofy_string_id]
388  EXECUTE (1.0ms)  CREATE TABLE [goofy_string_id] ([id] varchar(255) NOT NULL, [info] varchar(255)) 
389  EXECUTE (1.0ms)  DROP TABLE [invoices]
390  EXECUTE (2.0ms)  CREATE TABLE [invoices] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [balance] integer, [updated_at] datetime) 
391  EXECUTE (2.0ms)  DROP TABLE [items]
392  EXECUTE (1.0ms)  CREATE TABLE [items] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [name] varchar(255)) 
393  EXECUTE (1.0ms)  DROP TABLE [inept_wizards]
394  EXECUTE (2.0ms)  CREATE TABLE [inept_wizards] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [name] varchar(255) NOT NULL, [city] varchar(255) NOT NULL, [type] varchar(255)) 
395  EXECUTE (1.0ms)  DROP TABLE [jobs]
396  EXECUTE (1.0ms)  CREATE TABLE [jobs] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [ideal_reference_id] integer) 
397  EXECUTE (2.0ms)  DROP TABLE [keyboards]
398  EXECUTE (1.0ms)  CREATE TABLE [keyboards] ([key_number] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [name] varchar(255)) 
399  EXECUTE (1.0ms)  DROP TABLE [legacy_things]
400  EXECUTE (2.0ms)  CREATE TABLE [legacy_things] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [tps_report_number] integer, [version] integer DEFAULT 0 NOT NULL) 
401  EXECUTE (4.0ms)  DROP TABLE [line_items]
402  EXECUTE (3.0ms)  CREATE TABLE [line_items] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [invoice_id] integer, [amount] integer) 
403  EXECUTE (2.0ms)  DROP TABLE [lock_without_defaults]
404  EXECUTE (3.0ms)  CREATE TABLE [lock_without_defaults] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [lock_version] integer) 
405  EXECUTE (1.0ms)  DROP TABLE [lock_without_defaults_cust]
406  EXECUTE (2.0ms)  CREATE TABLE [lock_without_defaults_cust] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [custom_lock_version] integer) 
407  EXECUTE (2.0ms)  DROP TABLE [mateys]
408  EXECUTE (1.0ms)  CREATE TABLE [mateys] ([pirate_id] integer, [target_id] integer, [weight] integer) 
409  EXECUTE (1.0ms)  DROP TABLE [members]
410  EXECUTE (2.0ms)  CREATE TABLE [members] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [name] varchar(255), [member_type_id] integer) 
411  EXECUTE (1.0ms)  DROP TABLE [member_details]
412  EXECUTE (2.0ms)  CREATE TABLE [member_details] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [member_id] integer, [organization_id] integer, [extra_data] varchar(255)) 
413  EXECUTE (1.0ms)  DROP TABLE [memberships]
414  EXECUTE (84.0ms)  CREATE TABLE [memberships] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [joined_on] datetime, [club_id] integer, [member_id] integer, [favourite] bit DEFAULT 0, [type] varchar(255)) 
415  EXECUTE (2.0ms)  DROP TABLE [member_types]
416  EXECUTE (3.0ms)  CREATE TABLE [member_types] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [name] varchar(255)) 
417  EXECUTE (3.0ms)  DROP TABLE [references]
418  EXECUTE (3.0ms)  CREATE TABLE [references] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [person_id] integer, [job_id] integer, [favourite] bit, [lock_version] integer DEFAULT 0) 
419  EXECUTE (2.0ms)  DROP TABLE [minivans]
420  EXECUTE (2.0ms)  CREATE TABLE [minivans] ([minivan_id] varchar(255), [name] varchar(255), [speedometer_id] varchar(255), [color] varchar(255)) 
421  EXECUTE (1.0ms)  DROP TABLE [minimalistics]
422  EXECUTE (2.0ms)  CREATE TABLE [minimalistics] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY) 
423  EXECUTE (2.0ms)  DROP TABLE [mixed_case_monkeys]
424  EXECUTE (1.0ms)  CREATE TABLE [mixed_case_monkeys] ([monkeyID] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [fleaCount] integer) 
425  EXECUTE (2.0ms)  DROP TABLE [mixins]
426  EXECUTE (2.0ms)  CREATE TABLE [mixins] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [parent_id] integer, [pos] integer, [created_at] datetime, [updated_at] datetime, [lft] integer, [rgt] integer, [root_id] integer, [type] varchar(255)) 
427  EXECUTE (2.0ms)  DROP TABLE [movies]
428  EXECUTE (1.0ms)  CREATE TABLE [movies] ([movieid] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [name] varchar(255)) 
429  EXECUTE (1.0ms)  DROP TABLE [numeric_data]
430  EXECUTE (4.0ms)  CREATE TABLE [numeric_data] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [bank_balance] decimal(10,2), [big_bank_balance] decimal(15,2), [world_population] decimal(10,0), [my_house_population] decimal(2,0), [decimal_number_with_default] decimal(3,2) DEFAULT 2.78, [temperature] float(8), [atoms_in_universe] decimal(38,0)) 
431  EXECUTE (3.0ms)  DROP TABLE [orders]
432  EXECUTE (3.0ms)  CREATE TABLE [orders] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [name] varchar(255), [billing_customer_id] integer, [shipping_customer_id] integer) 
433  EXECUTE (3.0ms)  DROP TABLE [organizations]
434  EXECUTE (1.0ms)  CREATE TABLE [organizations] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [name] varchar(255)) 
435  EXECUTE (2.0ms)  DROP TABLE [owners]
436  EXECUTE (3.0ms)  CREATE TABLE [owners] ([owner_id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [name] varchar(255), [updated_at] datetime, [happy_at] datetime) 
437  EXECUTE (1.0ms)  DROP TABLE [paint_colors]
438  EXECUTE (2.0ms)  CREATE TABLE [paint_colors] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [non_poly_one_id] integer) 
439  EXECUTE (2.0ms)  DROP TABLE [paint_textures]
440  EXECUTE (1.0ms)  CREATE TABLE [paint_textures] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [non_poly_two_id] integer) 
441  EXECUTE (1.0ms)  DROP TABLE [parrots]
442  EXECUTE (1.0ms)  CREATE TABLE [parrots] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [name] varchar(255), [parrot_sti_class] varchar(255), [killer_id] integer, [created_at] datetime, [created_on] datetime, [updated_at] datetime, [updated_on] datetime) 
443  EXECUTE (2.0ms)  DROP TABLE [parrots_pirates]
444  EXECUTE (1.0ms)  CREATE TABLE [parrots_pirates] ([parrot_id] integer, [pirate_id] integer) 
445  EXECUTE (31.0ms)  DROP TABLE [parrots_treasures]
446  EXECUTE (2.0ms)  CREATE TABLE [parrots_treasures] ([parrot_id] integer, [treasure_id] integer) 
447  EXECUTE (2.0ms)  DROP TABLE [people]
448  EXECUTE (3.0ms)  CREATE TABLE [people] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [first_name] varchar(255) NOT NULL, [primary_contact_id] integer, [gender] varchar(1), [number1_fan_id] integer, [lock_version] integer DEFAULT 0 NOT NULL) 
449  EXECUTE (2.0ms)  DROP TABLE [pets]
450  EXECUTE (2.0ms)  CREATE TABLE [pets] ([pet_id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [name] varchar(255), [owner_id] integer, [integer] integer, [created_at] datetime, [updated_at] datetime) 
451  EXECUTE (2.0ms)  DROP TABLE [pirates]
452  EXECUTE (3.0ms)  CREATE TABLE [pirates] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [catchphrase] varchar(255), [parrot_id] integer, [created_on] datetime, [updated_on] datetime) 
453  EXECUTE (2.0ms)  DROP TABLE [posts]
454  EXECUTE (2.0ms)  CREATE TABLE [posts] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [author_id] integer, [title] varchar(255) NOT NULL, [body] varchar(max) NOT NULL, [type] varchar(255), [comments_count] integer DEFAULT 0, [taggings_count] integer DEFAULT 0) 
455  EXECUTE (1.0ms)  DROP TABLE [price_estimates]
456  EXECUTE (1.0ms)  CREATE TABLE [price_estimates] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [estimate_of_type] varchar(255), [estimate_of_id] integer, [price] integer) 
457  EXECUTE (1.0ms)  DROP TABLE [products]
458  EXECUTE (1.0ms)  CREATE TABLE [products] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [collection_id] integer, [name] varchar(255)) 
459  EXECUTE (1.0ms)  DROP TABLE [projects]
460  EXECUTE (2.0ms)  CREATE TABLE [projects] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [name] varchar(255), [type] varchar(255)) 
461  EXECUTE (2.0ms)  DROP TABLE [readers]
462  EXECUTE (2.0ms)  CREATE TABLE [readers] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [post_id] integer NOT NULL, [person_id] integer NOT NULL, [skimmer] bit DEFAULT 0) 
463  EXECUTE (1.0ms)  DROP TABLE [shape_expressions]
464  EXECUTE (1.0ms)  CREATE TABLE [shape_expressions] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [paint_type] varchar(255), [paint_id] integer, [shape_type] varchar(255), [shape_id] integer) 
465  EXECUTE (2.0ms)  DROP TABLE [ships]
466  EXECUTE (2.0ms)  CREATE TABLE [ships] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [name] varchar(255), [pirate_id] integer, [created_at] datetime, [created_on] datetime, [updated_at] datetime, [updated_on] datetime) 
467  EXECUTE (2.0ms)  DROP TABLE [ship_parts]
468  EXECUTE (4.0ms)  CREATE TABLE [ship_parts] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [name] varchar(255), [ship_id] integer) 
469  EXECUTE (4.0ms)  DROP TABLE [speedometers]
470  EXECUTE (2.0ms)  CREATE TABLE [speedometers] ([speedometer_id] varchar(255), [name] varchar(255), [dashboard_id] varchar(255)) 
471  EXECUTE (3.0ms)  DROP TABLE [sponsors]
472  EXECUTE (4.0ms)  CREATE TABLE [sponsors] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [club_id] integer, [sponsorable_id] integer, [sponsorable_type] varchar(255)) 
473  EXECUTE (1.0ms)  DROP TABLE [subscribers]
474  EXECUTE (1.0ms)  CREATE TABLE [subscribers] ([nick] varchar(255) NOT NULL, [name] varchar(255)) 
475  SQL (1.0ms)  EXEC sp_helpindex [subscribers]
476  EXECUTE (1.0ms)  CREATE UNIQUE INDEX [index_subscribers_on_nick] ON [subscribers] ([nick])
477  EXECUTE (3.0ms)  DROP TABLE [subscriptions]
478  EXECUTE (2.0ms)  CREATE TABLE [subscriptions] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [subscriber_id] varchar(255), [book_id] integer) 
479  EXECUTE (2.0ms)  DROP TABLE [tasks]
480  EXECUTE (2.0ms)  CREATE TABLE [tasks] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [starting] datetime, [ending] datetime) 
481  EXECUTE (2.0ms)  DROP TABLE [topics]
482  EXECUTE (2.0ms)  CREATE TABLE [topics] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [title] varchar(255), [author_name] varchar(255), [author_email_address] varchar(255), [written_on] datetime, [bonus_time] time, [last_read] date, [content] varchar(max), [approved] bit DEFAULT 1, [replies_count] integer DEFAULT 0, [parent_id] integer, [parent_title] varchar(255), [type] varchar(255), [group] varchar(255)) 
483  EXECUTE (10.0ms)  DROP TABLE [taggings]
484  EXECUTE (1.0ms)  CREATE TABLE [taggings] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [tag_id] integer, [super_tag_id] integer, [taggable_type] varchar(255), [taggable_id] integer) 
485  EXECUTE (2.0ms)  DROP TABLE [tags]
486  EXECUTE (2.0ms)  CREATE TABLE [tags] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [name] varchar(255), [taggings_count] integer DEFAULT 0) 
487  EXECUTE (1.0ms)  DROP TABLE [toys]
488  EXECUTE (1.0ms)  CREATE TABLE [toys] ([toy_id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [name] varchar(255), [pet_id] integer, [integer] integer, [created_at] datetime, [updated_at] datetime) 
489  EXECUTE (2.0ms)  DROP TABLE [traffic_lights]
490  EXECUTE (2.0ms)  CREATE TABLE [traffic_lights] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [location] varchar(255), [state] varchar(255), [created_at] datetime, [updated_at] datetime) 
491  EXECUTE (2.0ms)  DROP TABLE [treasures]
492  EXECUTE (2.0ms)  CREATE TABLE [treasures] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [name] varchar(255), [looter_id] integer, [looter_type] varchar(255)) 
493  EXECUTE (1.0ms)  DROP TABLE [variants]
494  EXECUTE (2.0ms)  CREATE TABLE [variants] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [product_id] integer, [name] varchar(255)) 
495  EXECUTE (1.0ms)  DROP TABLE [vertices]
496  EXECUTE (1.0ms)  CREATE TABLE [vertices] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [label] varchar(255)) 
497  EXECUTE (1.0ms)  DROP TABLE [warehouse-things]
498  EXECUTE (1.0ms)  CREATE TABLE [warehouse-things] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [value] integer) 
499  EXECUTE (1.0ms)  DROP TABLE [circles]
500  EXECUTE (1.0ms)  CREATE TABLE [circles] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY) 
501  EXECUTE (1.0ms)  DROP TABLE [squares]
502  EXECUTE (1.0ms)  CREATE TABLE [squares] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY) 
503  EXECUTE (1.0ms)  DROP TABLE [triangles]
504  EXECUTE (2.0ms)  CREATE TABLE [triangles] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY) 
505  EXECUTE (1.0ms)  DROP TABLE [non_poly_ones]
506  EXECUTE (4.0ms)  CREATE TABLE [non_poly_ones] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY) 
507  EXECUTE (4.0ms)  DROP TABLE [non_poly_twos]
508  EXECUTE (1.0ms)  CREATE TABLE [non_poly_twos] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY) 
509  EXECUTE (5.0ms)  DROP TABLE [guids]
510  EXECUTE (2.0ms)  CREATE TABLE [guids] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [key] varchar(255)) 
511  EXECUTE (2.0ms)  DROP TABLE [integer_limits]
512  EXECUTE (2.0ms)  CREATE TABLE [integer_limits] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [c_int_without_limit] integer, [c_int_1] smallint, [c_int_2] smallint, [c_int_3] integer, [c_int_4] integer, [c_int_5] bigint, [c_int_6] bigint, [c_int_7] bigint, [c_int_8] bigint) 
513  EXECUTE (1.0ms)  DROP TABLE [men]
514  EXECUTE (2.0ms)  CREATE TABLE [men] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [name] varchar(255)) 
515  EXECUTE (2.0ms)  DROP TABLE [faces]
516  EXECUTE (2.0ms)  CREATE TABLE [faces] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [description] varchar(255), [man_id] integer, [polymorphic_man_id] integer, [polymorphic_man_type] varchar(255)) 
517  EXECUTE (1.0ms)  DROP TABLE [interests]
518  EXECUTE (1.0ms)  CREATE TABLE [interests] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [topic] varchar(255), [man_id] integer, [polymorphic_man_id] integer, [polymorphic_man_type] varchar(255), [zine_id] integer) 
519  EXECUTE (1.0ms)  DROP TABLE [wheels]
520  EXECUTE (25.0ms)  CREATE TABLE [wheels] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [wheelable_id] integer, [wheelable_type] varchar(255)) 
521  EXECUTE (2.0ms)  DROP TABLE [zines]
522  EXECUTE (1.0ms)  CREATE TABLE [zines] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [title] varchar(255)) 
523  EXECUTE (1.0ms)  DROP TABLE [countries]
524  EXECUTE (1.0ms)  CREATE TABLE [countries] ([country_id] varchar(255), [name] varchar(255)) 
525  EXECUTE (1.0ms)  DROP TABLE [treaties]
526  EXECUTE (1.0ms)  CREATE TABLE [treaties] ([treaty_id] varchar(255), [name] varchar(255)) 
527  EXECUTE (1.0ms)  DROP TABLE [countries_treaties]
528  EXECUTE (1.0ms)  CREATE TABLE [countries_treaties] ([country_id] varchar(255) NOT NULL, [treaty_id] varchar(255) NOT NULL, [created_at] datetime, [updated_at] datetime) 
529  EXECUTE (2.0ms)  DROP TABLE [liquid]
530  EXECUTE (1.0ms)  CREATE TABLE [liquid] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [name] varchar(255)) 
531  EXECUTE (1.0ms)  DROP TABLE [molecules]
532  EXECUTE (2.0ms)  CREATE TABLE [molecules] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [liquid_id] integer, [name] varchar(255)) 
533  EXECUTE (1.0ms)  DROP TABLE [electrons]
534  EXECUTE (1.0ms)  CREATE TABLE [electrons] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [molecule_id] integer, [name] varchar(255)) 
535  EXECUTE (1.0ms)  DROP TABLE [fk_test_has_fk]
536  EXECUTE (2.0ms)  CREATE TABLE [fk_test_has_fk] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [fk_id] integer NOT NULL) 
537  EXECUTE (2.0ms)  DROP TABLE [fk_test_has_pk]
538  EXECUTE (1.0ms)  CREATE TABLE [fk_test_has_pk] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY) 
539  EXECUTE (1.0ms)  ALTER TABLE fk_test_has_fk ADD CONSTRAINT fk_name FOREIGN KEY ([fk_id]) REFERENCES [fk_test_has_pk] ([id])
540  EXECUTE (2.0ms)  DROP TABLE [courses]
541  EXECUTE (3.0ms)  CREATE TABLE [courses] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [name] varchar(255) NOT NULL) 
542  EXECUTE (2.0ms)  DROP TABLE [table_with_real_columns]
543  EXECUTE (1.0ms)  CREATE TABLE [table_with_real_columns] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [real_number] real) 
544  EXECUTE (2.0ms)  DROP TABLE [defaults]
545  EXECUTE (4.0ms)  CREATE TABLE [defaults] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [positive_integer] integer DEFAULT 1, [negative_integer] integer DEFAULT -1, [decimal_number] decimal(3,2) DEFAULT 2.78) 
546  EXECUTE (3.0ms)  DROP TABLE [string_defaults]
547  EXECUTE (3.0ms)  CREATE TABLE [string_defaults] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [string_with_null_default] varchar(255), [string_with_pretend_null_one] varchar(255) DEFAULT N'null', [string_with_pretend_null_two] varchar(255) DEFAULT N'(null)', [string_with_pretend_null_three] varchar(255) DEFAULT N'NULL', [string_with_pretend_null_four] varchar(255) DEFAULT N'(NULL)', [string_with_pretend_paren_three] varchar(255) DEFAULT N'(3)', [string_with_multiline_default] varchar(255) DEFAULT N'Some long default with a
548new line.') 
549  EXECUTE (2.0ms)  DROP TABLE [sql_server_chronics]
550  EXECUTE (3.0ms)  CREATE TABLE [sql_server_chronics] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [date] date, [time] time, [datetime] datetime, [timestamp] datetime, [ss_timestamp] timestamp, [smalldatetime] smalldatetime) 
551  EXECUTE (4.0ms)  DROP TABLE [fk_test_has_fks]
552  EXECUTE (3.0ms)  CREATE TABLE [fk_test_has_fks] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [fk_id] integer NOT NULL) 
553  EXECUTE (2.0ms)  DROP TABLE [fk_test_has_pks]
554  EXECUTE (1.0ms)  CREATE TABLE [fk_test_has_pks] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY) 
555  EXECUTE (1.0ms)   ALTER TABLE fk_test_has_fks 
556 ADD CONSTRAINT FK__fk_test_has_fk_fk_id
557 FOREIGN KEY ([fk_id]) 
558 REFERENCES [fk_test_has_pks] ([id])
559
560  EXECUTE (1.0ms)  DROP TABLE [sql_server_unicodes]
561  EXECUTE (1.0ms)  CREATE TABLE [sql_server_unicodes] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [nchar] nchar, [nvarchar] nvarchar(255), [ntext] ntext, [ntext_10] ntext, [nchar_10] nchar(10), [nvarchar_100] nvarchar(100), [nvarchar_max] nvarchar(max), [nvarchar_max_10] nvarchar(max)) 
562  EXECUTE (2.0ms)  DROP TABLE [sql_server_strings]
563  EXECUTE (2.0ms)  CREATE TABLE [sql_server_strings] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [char] char, [char_10] char(10), [varchar_max] varchar(max), [varchar_max_10] varchar(max)) 
564  EXECUTE (58.0ms)  DROP TABLE [sql_server_binary_types]
565  EXECUTE (3.0ms)  CREATE TABLE [sql_server_binary_types] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY) 
566  EXECUTE (2.0ms)  DROP TABLE [sql_server_edge_schemas]
567  EXECUTE (2.0ms)  CREATE TABLE [sql_server_edge_schemas] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [description] varchar(255), [bigint] bigint, [tinyint] tinyint, [guid] uniqueidentifier) 
568  EXECUTE (2.0ms)  ALTER TABLE [sql_server_edge_schemas] ADD [guid_newid] uniqueidentifier DEFAULT NEWID();
569  EXECUTE (2.0ms)  ALTER TABLE [sql_server_edge_schemas] ADD [guid_newseqid] uniqueidentifier DEFAULT NEWSEQUENTIALID();
570  EXECUTE (2.0ms)  DROP TABLE [quoted-table]
571  EXECUTE (2.0ms)  CREATE TABLE [quoted-table] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY) 
572  EXECUTE (22.0ms)  IF EXISTS (SELECT TABLE_NAME FROM INFORMATION_SCHEMA.VIEWS WHERE TABLE_NAME = 'quoted-view1') DROP VIEW [quoted-view1]
573  EXECUTE (2.0ms)  CREATE VIEW [quoted-view1] AS SELECT * FROM [quoted-table]
574  EXECUTE (8.0ms)  IF EXISTS (SELECT TABLE_NAME FROM INFORMATION_SCHEMA.VIEWS WHERE TABLE_NAME = 'quoted-view2') DROP VIEW [quoted-view2]
575  EXECUTE (9.0ms)  CREATE VIEW [quoted-view2] AS 
576 /*xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx}*/ 
577 SELECT * FROM [quoted-table]
578  EXECUTE (6.0ms)  IF EXISTS (SELECT TABLE_NAME FROM INFORMATION_SCHEMA.VIEWS WHERE TABLE_NAME = 'customers_view') DROP VIEW customers_view
579  EXECUTE (1.0ms)   CREATE VIEW customers_view AS
580 SELECT id, name, balance
581 FROM customers
582
583  EXECUTE (5.0ms)  IF EXISTS (SELECT TABLE_NAME FROM INFORMATION_SCHEMA.VIEWS WHERE TABLE_NAME = 'string_defaults_view') DROP VIEW string_defaults_view
584  EXECUTE (2.0ms)   CREATE VIEW string_defaults_view AS
585 SELECT id, string_with_pretend_null_one as pretend_null
586 FROM string_defaults
587
588  EXECUTE (13.0ms)  IF EXISTS (SELECT TABLE_NAME FROM INFORMATION_SCHEMA.VIEWS WHERE TABLE_NAME = 'string_defaults_big_view') DROP VIEW string_defaults_big_view
589  EXECUTE (9.0ms)   CREATE VIEW string_defaults_big_view AS
590 SELECT id, string_with_pretend_null_one as pretend_null
591 /*xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx}*/
592 FROM string_defaults
593
594  EXECUTE (0.0ms)  BEGIN TRANSACTION
595  EXECUTE (0.0ms)  ROLLBACK TRANSACTION
596  EXECUTE (0.0ms)  BEGIN TRANSACTION
597  EXECUTE (0.0ms)  ROLLBACK TRANSACTION
598  EXECUTE (0.0ms)  BEGIN TRANSACTION
599  EXECUTE (0.0ms)  ROLLBACK TRANSACTION
600  EXECUTE (1.0ms)  BEGIN TRANSACTION
601  Task Load (3.0ms)  SELECT TOP (1) [tasks].* FROM [tasks] WHERE ([tasks].[id] = 1)
602  Task Load (1.0ms)  SELECT TOP (1) [tasks].* FROM [tasks] WHERE ([tasks].[id] = 2)
603  EXECUTE (1.0ms)  SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED
604  EXECUTE (0.0ms)  SET TRANSACTION ISOLATION LEVEL READ COMMITTED
605  EXECUTE (1.0ms)  ROLLBACK TRANSACTION
606  EXECUTE (1.0ms)  BEGIN TRANSACTION
607  Task Load (0.0ms)  SELECT TOP (1) [tasks].* FROM [tasks] WHERE ([tasks].[id] = 1)
608  Task Load (0.0ms)  SELECT TOP (1) [tasks].* FROM [tasks] WHERE ([tasks].[id] = 2)
609  EXECUTE (0.0ms)  SAVE TRANSACTION active_record_1
610  EXECUTE (2.0ms)  UPDATE [tasks] SET [starting] = '2011-01-06 09:38:06.671' WHERE ([tasks].[id] = 2)
611  SQL (0.0ms)  SELECT @@ROWCOUNT AS AffectedRows
612  EXECUTE (1.0ms)  SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED
613  Task Load (1.0ms)  SELECT TOP (1) [tasks].* FROM [tasks] WHERE ([tasks].[id] = 2)
614  EXECUTE (0.0ms)  SET TRANSACTION ISOLATION LEVEL read committed
615  EXECUTE (0.0ms)  ROLLBACK TRANSACTION active_record_1
616  Task Load (0.0ms)  SELECT TOP (1) [tasks].* FROM [tasks] WHERE ([tasks].[id] = 2)
617  EXECUTE (0.0ms)  ROLLBACK TRANSACTION
618  EXECUTE (1.0ms)  BEGIN TRANSACTION
619  Task Load (0.0ms)  SELECT TOP (1) [tasks].* FROM [tasks] WHERE ([tasks].[id] = 1)
620  Task Load (0.0ms)  SELECT TOP (1) [tasks].* FROM [tasks] WHERE ([tasks].[id] = 2)
621  Task Load (1.0ms)  SELECT [tasks].* FROM [tasks]
622  EXECUTE (0.0ms)  SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED
623  Task Load (0.0ms)  SELECT [tasks].* FROM [tasks]
624  EXECUTE (0.0ms)  SET TRANSACTION ISOLATION LEVEL read committed
625  EXECUTE (1.0ms)  ROLLBACK TRANSACTION
626  EXECUTE (1.0ms)  BEGIN TRANSACTION
627  EXECUTE (0.0ms)  ROLLBACK TRANSACTION
628  EXECUTE (0.0ms)  BEGIN TRANSACTION
629  EXECUTE (0.0ms)  ROLLBACK TRANSACTION
630  EXECUTE (0.0ms)  BEGIN TRANSACTION
631  EXECUTE (1.0ms)  ROLLBACK TRANSACTION
632  EXECUTE (0.0ms)  BEGIN TRANSACTION
633  EXECUTE (0.0ms)  ROLLBACK TRANSACTION
634  EXECUTE (0.0ms)  BEGIN TRANSACTION
635  EXECUTE (0.0ms)  ROLLBACK TRANSACTION
636  EXECUTE (0.0ms)  BEGIN TRANSACTION
637  EXECUTE (0.0ms)  ROLLBACK TRANSACTION
638  EXECUTE (0.0ms)  BEGIN TRANSACTION
639  EXECUTE (0.0ms)  ROLLBACK TRANSACTION
640  EXECUTE (0.0ms)  BEGIN TRANSACTION
641  EXECUTE (0.0ms)  ROLLBACK TRANSACTION
642  EXECUTE (1.0ms)  BEGIN TRANSACTION
643  EXECUTE (0.0ms)  ROLLBACK TRANSACTION
644  EXECUTE (0.0ms)  BEGIN TRANSACTION
645  EXECUTE (0.0ms)  ROLLBACK TRANSACTION
646  EXECUTE (0.0ms)  BEGIN TRANSACTION
647  EXECUTE (0.0ms)  ROLLBACK TRANSACTION
648  EXECUTE (0.0ms)  BEGIN TRANSACTION
649  EXECUTE (1.0ms)  ROLLBACK TRANSACTION
650  EXECUTE (0.0ms)  BEGIN TRANSACTION
651  EXECUTE (1.0ms)  ROLLBACK TRANSACTION
652  EXECUTE (0.0ms)  BEGIN TRANSACTION
653  EXECUTE (1.0ms)  ROLLBACK TRANSACTION
654  EXECUTE (0.0ms)  BEGIN TRANSACTION
655  EXECUTE (0.0ms)  ROLLBACK TRANSACTION
656  EXECUTE (0.0ms)  BEGIN TRANSACTION
657  EXECUTE (0.0ms)  ROLLBACK TRANSACTION
658  EXECUTE (0.0ms)  BEGIN TRANSACTION
659  EXECUTE (0.0ms)  ROLLBACK TRANSACTION
660  EXECUTE (0.0ms)  BEGIN TRANSACTION
661  EXECUTE (0.0ms)  ROLLBACK TRANSACTION
662  EXECUTE (0.0ms)  BEGIN TRANSACTION
663  EXECUTE (0.0ms)  ROLLBACK TRANSACTION
664  EXECUTE (0.0ms)  BEGIN TRANSACTION
665  EXECUTE (0.0ms)  ROLLBACK TRANSACTION
666  EXECUTE (0.0ms)  BEGIN TRANSACTION
667  EXECUTE (0.0ms)  ROLLBACK TRANSACTION
668  EXECUTE (0.0ms)  BEGIN TRANSACTION
669  EXECUTE (0.0ms)  ROLLBACK TRANSACTION
670  EXECUTE (1.0ms)  BEGIN TRANSACTION
671  EXECUTE (0.0ms)  ROLLBACK TRANSACTION
672  EXECUTE (0.0ms)  BEGIN TRANSACTION
673  EXECUTE (0.0ms)  ROLLBACK TRANSACTION
674  EXECUTE (0.0ms)  BEGIN TRANSACTION
675  EXECUTE (0.0ms)  UPDATE XXX
676ODBC::Error: 37000 (102) [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near 'XXX'.: UPDATE XXX
677  EXECUTE (1.0ms)  ROLLBACK TRANSACTION
678  EXECUTE (0.0ms)  BEGIN TRANSACTION
679  EXECUTE (0.0ms)  ROLLBACK TRANSACTION
680  EXECUTE (0.0ms)  BEGIN TRANSACTION
681  EXECUTE (1.0ms)  ROLLBACK TRANSACTION
682  EXECUTE (0.0ms)  BEGIN TRANSACTION
683  EXECUTE (0.0ms)  ROLLBACK TRANSACTION
684  EXECUTE (0.0ms)  BEGIN TRANSACTION
685  EXECUTE (1.0ms)  ROLLBACK TRANSACTION
686  EXECUTE (0.0ms)  BEGIN TRANSACTION
687  EXECUTE (0.0ms)  ROLLBACK TRANSACTION
688  EXECUTE (0.0ms)  BEGIN TRANSACTION
689  EXECUTE (1.0ms)  INSERT INTO [sql_server_chronics] ([datetime]) VALUES('2012-11-08 10:24:36.003')
690  EXECUTE (1.0ms)  INSERT INTO [sql_server_chronics] ([datetime]) VALUES('2012-11-08 10:24:36.123')
691  SqlServerChronic Load (2.0ms)  SELECT TOP (1) [sql_server_chronics].* FROM [sql_server_chronics] WHERE ([sql_server_chronics].[datetime] = N'2012-11-08 10:24:36.003')
692  EXECUTE (1.0ms)  DELETE FROM [sql_server_chronics] WHERE [datetime] = '2012-11-08 10:24:36.003'
693  EXECUTE (0.0ms)  DELETE FROM [sql_server_chronics] WHERE [datetime] = '2012-11-08 10:24:36.123'
694  EXECUTE (0.0ms)  ROLLBACK TRANSACTION
695  EXECUTE (1.0ms)  BEGIN TRANSACTION
696  EXECUTE (0.0ms)  INSERT INTO [sql_server_chronics] ([datetime]) VALUES('2012-11-08 10:24:36.003')
697  EXECUTE (1.0ms)  INSERT INTO [sql_server_chronics] ([datetime]) VALUES('2012-11-08 10:24:36.123')
698  SqlServerChronic Load (1.0ms)  SELECT TOP (1) [sql_server_chronics].* FROM [sql_server_chronics] WHERE ([sql_server_chronics].[datetime] = N'2012-11-08 10:24:36.123')
699  EXECUTE (0.0ms)  DELETE FROM [sql_server_chronics] WHERE [datetime] = '2012-11-08 10:24:36.003'
700  EXECUTE (0.0ms)  DELETE FROM [sql_server_chronics] WHERE [datetime] = '2012-11-08 10:24:36.123'
701  EXECUTE (1.0ms)  ROLLBACK TRANSACTION
702  EXECUTE (1.0ms)  BEGIN TRANSACTION
703  EXECUTE (0.0ms)  INSERT INTO [sql_server_chronics] ([datetime]) VALUES('2012-11-08 10:24:36.003')
704  EXECUTE (1.0ms)  INSERT INTO [sql_server_chronics] ([datetime]) VALUES('2012-11-08 10:24:36.123')
705  EXECUTE (1.0ms)  SAVE TRANSACTION active_record_1
706  EXECUTE (2.0ms)  INSERT INTO [sql_server_chronics] ([date], [datetime], [smalldatetime], [ss_timestamp], [time], [timestamp]) VALUES (NULL, '2011-01-06 09:38:06.123', NULL, NULL, NULL, NULL)
707  SQL (0.0ms)  SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
708  SqlServerChronic Load (1.0ms)  SELECT TOP (1) [sql_server_chronics].* FROM [sql_server_chronics] WHERE ([sql_server_chronics].[id] = 7)
709  EXECUTE (0.0ms)  DELETE FROM [sql_server_chronics] WHERE [datetime] = '2012-11-08 10:24:36.003'
710  EXECUTE (0.0ms)  DELETE FROM [sql_server_chronics] WHERE [datetime] = '2012-11-08 10:24:36.123'
711  EXECUTE (0.0ms)  ROLLBACK TRANSACTION
712  EXECUTE (0.0ms)  BEGIN TRANSACTION
713  EXECUTE (0.0ms)  INSERT INTO [sql_server_chronics] ([datetime]) VALUES('2012-11-08 10:24:36.003')
714  EXECUTE (0.0ms)  INSERT INTO [sql_server_chronics] ([datetime]) VALUES('2012-11-08 10:24:36.123')
715  EXECUTE (0.0ms)  SAVE TRANSACTION active_record_1
716  EXECUTE (0.0ms)  INSERT INTO [sql_server_chronics] ([date], [datetime], [smalldatetime], [ss_timestamp], [time], [timestamp]) VALUES (NULL, '2011-01-06 09:38:06.003', NULL, NULL, NULL, NULL)
717  SQL (1.0ms)  SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
718  SqlServerChronic Load (1.0ms)  SELECT TOP (1) [sql_server_chronics].* FROM [sql_server_chronics] WHERE ([sql_server_chronics].[id] = 10)
719  EXECUTE (0.0ms)  DELETE FROM [sql_server_chronics] WHERE [datetime] = '2012-11-08 10:24:36.003'
720  EXECUTE (1.0ms)  DELETE FROM [sql_server_chronics] WHERE [datetime] = '2012-11-08 10:24:36.123'
721  EXECUTE (0.0ms)  ROLLBACK TRANSACTION
722  EXECUTE (0.0ms)  BEGIN TRANSACTION
723  EXECUTE (1.0ms)  ROLLBACK TRANSACTION
724  EXECUTE (0.0ms)  BEGIN TRANSACTION
725  EXECUTE (1.0ms)  ROLLBACK TRANSACTION
726  EXECUTE (0.0ms)  BEGIN TRANSACTION
727  EXECUTE (1.0ms)  ROLLBACK TRANSACTION
728  EXECUTE (0.0ms)  BEGIN TRANSACTION
729  EXECUTE (1.0ms)  ROLLBACK TRANSACTION
730  EXECUTE (0.0ms)  BEGIN TRANSACTION
731  EXECUTE (1.0ms)  CREATE INDEX idx_credit_limit_test_desc ON accounts (credit_limit DESC)
732  SQL (1.0ms)  EXEC sp_helpindex [accounts]
733  EXECUTE (1.0ms)  DROP INDEX accounts.idx_credit_limit_test_desc
734  EXECUTE (1.0ms)  ROLLBACK TRANSACTION
735  EXECUTE (0.0ms)  BEGIN TRANSACTION
736  IDENTITY_INSERT (1.0ms)  SET IDENTITY_INSERT [customers] ON
737  EXECUTE (1.0ms)  INSERT INTO [customers_view] ([id],[name],[balance]) VALUES (420,'Microsoft',0)
738  IDENTITY_INSERT (0.0ms)  SET IDENTITY_INSERT [customers] OFF
739  CustomersView Load (12.0ms)  SELECT TOP (1) [customers_view].* FROM [customers_view] WHERE ([customers_view].[id] = 420)
740  EXECUTE (0.0ms)  ROLLBACK TRANSACTION
741  EXECUTE (0.0ms)  BEGIN TRANSACTION
742  EXECUTE (0.0ms)  ROLLBACK TRANSACTION
743  EXECUTE (0.0ms)  BEGIN TRANSACTION
744  EXECUTE (1.0ms)  ROLLBACK TRANSACTION
745  EXECUTE (0.0ms)  BEGIN TRANSACTION
746  EXECUTE (0.0ms)  ROLLBACK TRANSACTION
747  EXECUTE (0.0ms)  BEGIN TRANSACTION
748  EXECUTE (0.0ms)  ROLLBACK TRANSACTION
749  EXECUTE (0.0ms)  BEGIN TRANSACTION
750  EXECUTE (0.0ms)  ROLLBACK TRANSACTION
751  EXECUTE (0.0ms)  BEGIN TRANSACTION
752  EXECUTE (0.0ms)  ROLLBACK TRANSACTION
753  EXECUTE (0.0ms)  BEGIN TRANSACTION
754  EXECUTE (0.0ms)  ROLLBACK TRANSACTION
755  EXECUTE (0.0ms)  BEGIN TRANSACTION
756  EXECUTE (0.0ms)  ROLLBACK TRANSACTION
757  EXECUTE (0.0ms)  BEGIN TRANSACTION
758  EXECUTE (0.0ms)  ROLLBACK TRANSACTION
759  EXECUTE (0.0ms)  BEGIN TRANSACTION
760  EXECUTE (0.0ms)  ROLLBACK TRANSACTION
761  EXECUTE (0.0ms)  BEGIN TRANSACTION
762  EXECUTE (0.0ms)  ROLLBACK TRANSACTION
763  EXECUTE (0.0ms)  BEGIN TRANSACTION
764  EXECUTE (0.0ms)  ROLLBACK TRANSACTION
765  EXECUTE (0.0ms)  BEGIN TRANSACTION
766  EXECUTE (0.0ms)  ROLLBACK TRANSACTION
767  EXECUTE (1.0ms)  BEGIN TRANSACTION
768  EXECUTE (0.0ms)  ROLLBACK TRANSACTION
769  EXECUTE (1.0ms)  BEGIN TRANSACTION
770  EXECUTE (1.0ms)  ROLLBACK TRANSACTION
771  EXECUTE (1.0ms)  BEGIN TRANSACTION
772  EXECUTE (0.0ms)  ROLLBACK TRANSACTION
773  EXECUTE (0.0ms)  BEGIN TRANSACTION
774  EXECUTE (0.0ms)  ROLLBACK TRANSACTION
775  EXECUTE (0.0ms)  BEGIN TRANSACTION
776  EXECUTE (0.0ms)  ROLLBACK TRANSACTION
777  EXECUTE (0.0ms)  BEGIN TRANSACTION
778  EXECUTE (0.0ms)  SAVE TRANSACTION active_record_1
779  EXECUTE (1.0ms)  INSERT INTO [fk_test_has_pks] DEFAULT VALUES
780  SQL (1.0ms)  SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
781  EXECUTE (0.0ms)  SAVE TRANSACTION active_record_1
782  EXECUTE (1.0ms)  INSERT INTO [fk_test_has_fks] ([fk_id]) VALUES (1)
783  SQL (0.0ms)  SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
784  EXECUTE (54.0ms)  EXEC sp_MSforeachtable 'ALTER TABLE ? NOCHECK CONSTRAINT ALL'
785  EXECUTE (0.0ms)  SAVE TRANSACTION active_record_1
786  EXECUTE (2.0ms)  DELETE FROM [fk_test_has_pks] WHERE ([fk_test_has_pks].[id] = 1)
787  SQL (0.0ms)  SELECT @@ROWCOUNT AS AffectedRows
788  EXECUTE (48.0ms)  EXEC sp_MSforeachtable 'ALTER TABLE ? CHECK CONSTRAINT ALL'
789  EXECUTE (18.0ms)  ROLLBACK TRANSACTION
790  EXECUTE (0.0ms)  BEGIN TRANSACTION
791  EXECUTE (0.0ms)  SAVE TRANSACTION active_record_1
792  EXECUTE (0.0ms)  INSERT INTO [fk_test_has_pks] DEFAULT VALUES
793  SQL (1.0ms)  SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
794  EXECUTE (0.0ms)  SAVE TRANSACTION active_record_1
795  EXECUTE (1.0ms)  INSERT INTO [fk_test_has_fks] ([fk_id]) VALUES (2)
796  SQL (0.0ms)  SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
797  EXECUTE (51.0ms)  EXEC sp_MSforeachtable 'ALTER TABLE ? NOCHECK CONSTRAINT ALL'
798  EXECUTE (58.0ms)  EXEC sp_MSforeachtable 'ALTER TABLE ? CHECK CONSTRAINT ALL'
799  EXECUTE (0.0ms)  SAVE TRANSACTION active_record_1
800  EXECUTE (2.0ms)  DELETE FROM [fk_test_has_pks] WHERE ([fk_test_has_pks].[id] = 2)
801ODBC::Error: 23000 (547) [Microsoft][ODBC SQL Server Driver][SQL Server]The DELETE statement conflicted with the REFERENCE constraint "FK__fk_test_has_fk_fk_id". The conflict occurred in database "activerecord_unittest", table "dbo.fk_test_has_fks", column 'fk_id'.: DELETE FROM [fk_test_has_pks] WHERE ([fk_test_has_pks].[id] = 2)
802  EXECUTE (0.0ms)  ROLLBACK TRANSACTION active_record_1
803  EXECUTE (18.0ms)  ROLLBACK TRANSACTION
804  EXECUTE (0.0ms)  BEGIN TRANSACTION
805  EXECUTE (0.0ms)  SAVE TRANSACTION active_record_1
806  EXECUTE (0.0ms)  INSERT INTO [fk_test_has_pks] DEFAULT VALUES
807  SQL (1.0ms)  SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
808  EXECUTE (0.0ms)  SAVE TRANSACTION active_record_1
809  EXECUTE (0.0ms)  INSERT INTO [fk_test_has_fks] ([fk_id]) VALUES (3)
810  SQL (1.0ms)  SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
811  EXECUTE (49.0ms)  EXEC sp_MSforeachtable 'ALTER TABLE ? NOCHECK CONSTRAINT ALL'
812  EXECUTE (48.0ms)  EXEC sp_MSforeachtable 'ALTER TABLE ? CHECK CONSTRAINT ALL'
813  EXECUTE (0.0ms)  SAVE TRANSACTION active_record_1
814  EXECUTE (2.0ms)  DELETE FROM [fk_test_has_pks] WHERE ([fk_test_has_pks].[id] = 3)
815ODBC::Error: 23000 (547) [Microsoft][ODBC SQL Server Driver][SQL Server]The DELETE statement conflicted with the REFERENCE constraint "FK__fk_test_has_fk_fk_id". The conflict occurred in database "activerecord_unittest", table "dbo.fk_test_has_fks", column 'fk_id'.: DELETE FROM [fk_test_has_pks] WHERE ([fk_test_has_pks].[id] = 3)
816  EXECUTE (1.0ms)  ROLLBACK TRANSACTION active_record_1
817  EXECUTE (19.0ms)  ROLLBACK TRANSACTION
818  EXECUTE (0.0ms)  BEGIN TRANSACTION
819  Developer Load (1.0ms)  SELECT TOP (1) [developers].* FROM [developers]
820  EXECUTE (0.0ms)  ROLLBACK TRANSACTION
821  EXECUTE (0.0ms)  BEGIN TRANSACTION
822  EXECUTE (1.0ms)  SAVE TRANSACTION active_record_1
823  EXECUTE (2.0ms)  INSERT INTO [topics] ([approved], [author_email_address], [author_name], [bonus_time], [content], [group], [last_read], [parent_id], [parent_title], [replies_count], [title], [type], [written_on]) VALUES (1, N'test@test.com', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, N'Budget', NULL, '2011-01-06 09:38:07.914')
824  SQL (1.0ms)  SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
825  Topic Load (1.0ms)  SELECT TOP (1) topics.*, CASE WHEN 1=2 THEN 1 ELSE 0 END as is_test FROM [topics]
826  EXECUTE (0.0ms)  ROLLBACK TRANSACTION
827  EXECUTE (0.0ms)  BEGIN TRANSACTION
828  EXECUTE (1.0ms)  SAVE TRANSACTION active_record_1
829  EXECUTE (0.0ms)  INSERT INTO [topics] ([approved], [author_email_address], [author_name], [bonus_time], [content], [group], [last_read], [parent_id], [parent_title], [replies_count], [title], [type], [written_on]) VALUES (1, N'test@test.com', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, N'Budget', NULL, '2011-01-06 09:38:07.923')
830  SQL (1.0ms)  SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
831  Topic Load (1.0ms)  SELECT TOP (1) topics.*, CASE WHEN 2=2 THEN 1 ELSE 0 END as is_test FROM [topics]
832  EXECUTE (0.0ms)  ROLLBACK TRANSACTION
833  EXECUTE (1.0ms)  BEGIN TRANSACTION
834  EXECUTE (1.0ms)  ROLLBACK TRANSACTION
835  EXECUTE (0.0ms)  BEGIN TRANSACTION
836  SQL (1.0ms)  SELECT SUM(2 * credit_limit) AS sum_id FROM [accounts]
837  EXECUTE (0.0ms)  ROLLBACK TRANSACTION
838  EXECUTE (0.0ms)  BEGIN TRANSACTION
839  EXECUTE (1.0ms)  ROLLBACK TRANSACTION
840  EXECUTE (0.0ms)  BEGIN TRANSACTION
841  EXECUTE (0.0ms)  ROLLBACK TRANSACTION
842  EXECUTE (0.0ms)  BEGIN TRANSACTION
843  EXECUTE (0.0ms)  ROLLBACK TRANSACTION
844  EXECUTE (0.0ms)  BEGIN TRANSACTION
845  EXECUTE (0.0ms)  ROLLBACK TRANSACTION
846  EXECUTE (0.0ms)  BEGIN TRANSACTION
847  EXECUTE (0.0ms)  ROLLBACK TRANSACTION
848  EXECUTE (0.0ms)  BEGIN TRANSACTION
849  EXECUTE (0.0ms)  ROLLBACK TRANSACTION
850  EXECUTE (0.0ms)  BEGIN TRANSACTION
851  EXECUTE (0.0ms)  ROLLBACK TRANSACTION
852  EXECUTE (0.0ms)  BEGIN TRANSACTION
853  EXECUTE (0.0ms)  SAVE TRANSACTION active_record_1
854  EXECUTE (1.0ms)  INSERT INTO [binaries] ([data]) VALUES (0x47494638396101000100800000ffffff00000021f90400000000002c00000000010001000002024401003b)
855  SQL (0.0ms)  SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
856  EXECUTE (0.0ms)  ROLLBACK TRANSACTION
857  EXECUTE (0.0ms)  BEGIN TRANSACTION
858  EXECUTE (0.0ms)  SAVE TRANSACTION active_record_1
859  EXECUTE (1.0ms)  INSERT INTO [binaries] ([data]) VALUES (0x47494638396101000100800000ffffff00000021f90400000000002c00000000010001000002024401003b)
860  SQL (0.0ms)  SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
861  EXECUTE (0.0ms)  ROLLBACK TRANSACTION
862  EXECUTE (0.0ms)  BEGIN TRANSACTION
863  EXECUTE (1.0ms)  SAVE TRANSACTION active_record_1
864  EXECUTE (1.0ms)  INSERT INTO [binaries] ([data]) VALUES (0x47494638396101000100800000ffffff00000021f90400000000002c00000000010001000002024401003b)
865  SQL (0.0ms)  SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
866  Binary Load (2.0ms)  SELECT TOP (1) [binaries].* FROM [binaries] WHERE ([binaries].[id] = 3)
867  EXECUTE (1.0ms)  ROLLBACK TRANSACTION
868  EXECUTE (1.0ms)  BEGIN TRANSACTION
869  EXECUTE (0.0ms)  SAVE TRANSACTION active_record_1
870  EXECUTE (1.0ms)  INSERT INTO [sql_server_chronics] ([date], [datetime], [smalldatetime], [ss_timestamp], [time], [timestamp]) VALUES (NULL, NULL, '2011-01-06 09:38:08.388', NULL, NULL, NULL)
871  SQL (1.0ms)  SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
872  EXECUTE (1.0ms)  ROLLBACK TRANSACTION
873  EXECUTE (0.0ms)  BEGIN TRANSACTION
874  EXECUTE (0.0ms)  SAVE TRANSACTION active_record_1
875  EXECUTE (1.0ms)  INSERT INTO [sql_server_chronics] ([date], [datetime], [smalldatetime], [ss_timestamp], [time], [timestamp]) VALUES (NULL, NULL, '2011-01-04 09:38:08.393', NULL, NULL, NULL)
876  SQL (0.0ms)  SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
877  EXECUTE (0.0ms)  SAVE TRANSACTION active_record_1
878  EXECUTE (2.0ms)  UPDATE [sql_server_chronics] SET [smalldatetime] = '2011-01-06 09:38:08.396' WHERE ([sql_server_chronics].[id] = 12)
879  SQL (1.0ms)  SELECT @@ROWCOUNT AS AffectedRows
880  EXECUTE (1.0ms)  ROLLBACK TRANSACTION
881  EXECUTE (0.0ms)  BEGIN TRANSACTION
882  EXECUTE (1.0ms)  ROLLBACK TRANSACTION
883  EXECUTE (0.0ms)  BEGIN TRANSACTION
884  EXECUTE (0.0ms)  ROLLBACK TRANSACTION
885  EXECUTE (0.0ms)  BEGIN TRANSACTION
886  EXECUTE (0.0ms)  ROLLBACK TRANSACTION
887  EXECUTE (0.0ms)  BEGIN TRANSACTION
888  EXECUTE (0.0ms)  ROLLBACK TRANSACTION
889  EXECUTE (0.0ms)  BEGIN TRANSACTION
890  EXECUTE (0.0ms)  SAVE TRANSACTION active_record_1
891  EXECUTE (1.0ms)  INSERT INTO [sql_server_chronics] ([date], [datetime], [smalldatetime], [ss_timestamp], [time], [timestamp]) VALUES ('2008-12-24 19:00:00.000', NULL, NULL, NULL, NULL, NULL)
892  SQL (1.0ms)  SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
893  SqlServerChronic Load (1.0ms)  SELECT TOP (1) [sql_server_chronics].* FROM [sql_server_chronics] WHERE ([sql_server_chronics].[id] = 13)
894  EXECUTE (0.0ms)  SAVE TRANSACTION active_record_1
895  EXECUTE (1.0ms)  INSERT INTO [sql_server_chronics] ([date], [datetime], [smalldatetime], [ss_timestamp], [time], [timestamp]) VALUES (NULL, NULL, NULL, NULL, '2008-12-25 07:00:00.000', NULL)
896  SQL (1.0ms)  SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
897  SqlServerChronic Load (1.0ms)  SELECT TOP (1) [sql_server_chronics].* FROM [sql_server_chronics] WHERE ([sql_server_chronics].[id] = 14)
898  EXECUTE (1.0ms)  ROLLBACK TRANSACTION
899  EXECUTE (0.0ms)  BEGIN TRANSACTION
900  EXECUTE (0.0ms)  SAVE TRANSACTION active_record_1
901  EXECUTE (1.0ms)  INSERT INTO [sql_server_chronics] ([date], [datetime], [smalldatetime], [ss_timestamp], [time], [timestamp]) VALUES ('2008-12-24 19:00:00.000', NULL, NULL, NULL, NULL, NULL)
902  SQL (0.0ms)  SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
903  SqlServerChronic Load (1.0ms)  SELECT TOP (1) [sql_server_chronics].* FROM [sql_server_chronics] WHERE ([sql_server_chronics].[id] = 15)
904  EXECUTE (0.0ms)  SAVE TRANSACTION active_record_1
905  EXECUTE (0.0ms)  INSERT INTO [sql_server_chronics] ([date], [datetime], [smalldatetime], [ss_timestamp], [time], [timestamp]) VALUES (NULL, NULL, NULL, NULL, '2008-12-25 07:00:00.000', NULL)
906  SQL (0.0ms)  SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
907  SqlServerChronic Load (1.0ms)  SELECT TOP (1) [sql_server_chronics].* FROM [sql_server_chronics] WHERE ([sql_server_chronics].[id] = 16)
908  EXECUTE (0.0ms)  ROLLBACK TRANSACTION
909  EXECUTE (0.0ms)  BEGIN TRANSACTION
910  EXECUTE (0.0ms)  SAVE TRANSACTION active_record_1
911  EXECUTE (0.0ms)  INSERT INTO [sql_server_chronics] ([date], [datetime], [smalldatetime], [ss_timestamp], [time], [timestamp]) VALUES ('2008-12-24 19:00:00.000', NULL, NULL, NULL, NULL, NULL)
912  SQL (1.0ms)  SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
913  SqlServerChronic Load (1.0ms)  SELECT TOP (1) [sql_server_chronics].* FROM [sql_server_chronics] WHERE ([sql_server_chronics].[id] = 17)
914  EXECUTE (0.0ms)  SAVE TRANSACTION active_record_1
915  EXECUTE (0.0ms)  INSERT INTO [sql_server_chronics] ([date], [datetime], [smalldatetime], [ss_timestamp], [time], [timestamp]) VALUES (NULL, NULL, NULL, NULL, '2008-12-25 07:00:00.000', NULL)
916  SQL (1.0ms)  SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
917  SqlServerChronic Load (1.0ms)  SELECT TOP (1) [sql_server_chronics].* FROM [sql_server_chronics] WHERE ([sql_server_chronics].[id] = 18)
918  EXECUTE (0.0ms)  ROLLBACK TRANSACTION
919  EXECUTE (0.0ms)  BEGIN TRANSACTION
920  EXECUTE (0.0ms)  ROLLBACK TRANSACTION
921  EXECUTE (0.0ms)  BEGIN TRANSACTION
922  EXECUTE (0.0ms)  SAVE TRANSACTION active_record_1
923  EXECUTE (1.0ms)  INSERT INTO [sql_server_chronics] ([date], [datetime], [smalldatetime], [ss_timestamp], [time], [timestamp]) VALUES (NULL, NULL, NULL, NULL, NULL, NULL)
924  SQL (1.0ms)  SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
925  SqlServerChronic Load (1.0ms)  SELECT TOP (1) [sql_server_chronics].* FROM [sql_server_chronics] WHERE ([sql_server_chronics].[id] = 19)
926  EXECUTE (0.0ms)  ROLLBACK TRANSACTION
927  EXECUTE (0.0ms)  BEGIN TRANSACTION
928  EXECUTE (0.0ms)  ROLLBACK TRANSACTION
929  EXECUTE (0.0ms)  BEGIN TRANSACTION
930  EXECUTE (1.0ms)  ROLLBACK TRANSACTION
931  EXECUTE (0.0ms)  BEGIN TRANSACTION
932  EXECUTE (0.0ms)  ROLLBACK TRANSACTION
933  EXECUTE (0.0ms)  BEGIN TRANSACTION
934  EXECUTE (0.0ms)  ROLLBACK TRANSACTION
935  EXECUTE (0.0ms)  BEGIN TRANSACTION
936  EXECUTE (1.0ms)  ROLLBACK TRANSACTION
937  EXECUTE (1.0ms)  BEGIN TRANSACTION
938  EXECUTE (0.0ms)  ROLLBACK TRANSACTION
939  EXECUTE (0.0ms)  BEGIN TRANSACTION
940  EXECUTE (0.0ms)  ROLLBACK TRANSACTION
941  EXECUTE (0.0ms)  BEGIN TRANSACTION
942  EXECUTE (1.0ms)  ROLLBACK TRANSACTION
943  EXECUTE (1.0ms)  BEGIN TRANSACTION
944  EXECUTE (0.0ms)  ROLLBACK TRANSACTION
945CONNECTION RETRY: ActiveRecord::ConnectionAdapters::SQLServerAdapter retry #0.
946  SQL (1012.1ms)  SELECT COUNT(*) AS count_id FROM [topics]
947  SQL (0.0ms)  SELECT COUNT(*) AS count_id FROM [topics]
948ODBC::Error: INTERN (0) [RubyODBC]Invalid handle: SELECT COUNT(*) AS count_id FROM [topics]
949  Topic Load (2.0ms)  SELECT TOP (1) [topics].* FROM [topics] WHERE ([topics].[id] = 1)
950  EXECUTE (1.0ms)  BEGIN TRANSACTION
951  EXECUTE (1.0ms)  UPDATE [topics] SET [content] = N'1 updated' WHERE ([topics].[id] = 1)
952  SQL (1.0ms)  SELECT @@ROWCOUNT AS AffectedRows
953  EXECUTE (1.0ms)  COMMIT TRANSACTION
954  Topic Load (1.0ms)  SELECT TOP (1) [topics].* FROM [topics] WHERE ([topics].[id] = 2)
955  EXECUTE (0.0ms)  BEGIN TRANSACTION
956  EXECUTE (3.0ms)  UPDATE [topics] SET [content] = N'2 updated' WHERE ((([topics].[type] = N'Reply' OR [topics].[type] = N'WrongReply') OR [topics].[type] = N'SillyReply')) AND ([topics].[id] = 2)
957  SQL (0.0ms)  SELECT @@ROWCOUNT AS AffectedRows
958  EXECUTE (1.0ms)  COMMIT TRANSACTION
959  Topic Load (0.0ms)  SELECT TOP (1) [topics].* FROM [topics] WHERE ([topics].[id] = 1)
960  Topic Load (1.0ms)  SELECT TOP (1) [topics].* FROM [topics] WHERE ([topics].[id] = 2)
961  EXECUTE (1.0ms)  DELETE FROM [topics] WHERE ([topics].[id] IN (1, 2))
962  SQL (0.0ms)  SELECT @@ROWCOUNT AS AffectedRows
963  SQL (1.0ms)  SELECT DB_NAME()
964  EXECUTE (0.0ms)  USE [activerecord_unittest2]
965  SQL (0.0ms)  SELECT DB_NAME()
966  EXECUTE (0.0ms)  USE [activerecord_unittest]
967  SQL (1.0ms)  SELECT DB_NAME()
968  EXECUTE (1.0ms)  SELECT 1
969  EXECUTE (0.0ms)  SELECT 1
970  EXECUTE (1.0ms)  SELECT * FROM [topics]
971  SQL (0.0ms)  SELECT * FROM [topics]
972  IDENTITY_INSERT (1.0ms)  SET IDENTITY_INSERT [accounts] ON
973  EXECUTE (1.0ms)  INSERT INTO accounts ([id], [firm_id],[credit_limit]) values (999, 1, 50)
974  IDENTITY_INSERT (0.0ms)  SET IDENTITY_INSERT [accounts] OFF
975  SQL (1.0ms)  SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
976  EXECUTE (2.0ms)  INSERT INTO accounts ([firm_id],[credit_limit]) values (1, 50)
977  SQL (0.0ms)  SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
978  EXECUTE (0.0ms)  SELECT * FROM [topics]
979  EXECUTE (1.0ms)  BEGIN TRANSACTION
980  Author Load (3.0ms)  SELECT TOP (1) [authors].* FROM [authors] WHERE ([authors].[id] = 1)
981  SQL (9.0ms)  SELECT COUNT(DISTINCT [posts].[id]) AS count_id FROM [posts] LEFT OUTER JOIN [comments] ON [comments].[post_id] = [posts].[id] WHERE ([posts].author_id = 1) AND (len(comments.body) > 15)
982  EXECUTE (0.0ms)  ROLLBACK TRANSACTION
983  EXECUTE (0.0ms)  BEGIN TRANSACTION
984  Execute Procedure (75.0ms)  EXEC sp_helpconstraint N'accounts'
985  EXECUTE (0.0ms)  ROLLBACK TRANSACTION
986  EXECUTE (0.0ms)  BEGIN TRANSACTION
987  Execute Procedure (49.0ms)  EXEC sp_tables
988  EXECUTE (0.0ms)  ROLLBACK TRANSACTION
989  EXECUTE (0.0ms)  BEGIN TRANSACTION
990  Execute Procedure (3.0ms)  EXEC sp_tables N'sql_server_chronics'
991  EXECUTE (1.0ms)  ROLLBACK TRANSACTION
992  EXECUTE (0.0ms)  BEGIN TRANSACTION
993  EXECUTE (1.0ms)  ROLLBACK TRANSACTION
994  EXECUTE (0.0ms)  BEGIN TRANSACTION
995  EXECUTE (0.0ms)  ROLLBACK TRANSACTION
996  EXECUTE (0.0ms)  BEGIN TRANSACTION
997  EXECUTE (1.0ms)  delete from countries_treaties
998  EXECUTE (0.0ms)  SAVE TRANSACTION active_record_1
999  EXECUTE (1.0ms)  INSERT INTO [countries] ([country_id], [name]) VALUES (N'c1', N'India')
1000  SQL (0.0ms)  SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
1001  EXECUTE (0.0ms)  SAVE TRANSACTION active_record_1
1002  EXECUTE (1.0ms)  INSERT INTO [treaties] ([name], [treaty_id]) VALUES (N'peace', N't1')
1003  SQL (0.0ms)  SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
1004  EXECUTE (1.0ms)  INSERT INTO [countries_treaties] ([country_id], [created_at], [treaty_id], [updated_at]) VALUES (N'c1', '2011-01-06 09:38:14.677', N't1', '2011-01-06 09:38:14.677')
1005  SQL (1.0ms)  SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
1006  SQL (1.0ms)  select * from countries_treaties
1007  EXECUTE (0.0ms)  ROLLBACK TRANSACTION
1008  EXECUTE (0.0ms)  BEGIN TRANSACTION
1009  Account Load (2.0ms)  SELECT TOP (1) [accounts].* FROM [accounts] WHERE ([accounts].[id] = 1)
1010  Company Load (2.0ms)  SELECT [companies].* FROM [companies] WHERE ([companies].[id] = 1)
1011  EXECUTE (0.0ms)  ROLLBACK TRANSACTION
1012  EXECUTE (0.0ms)  BEGIN TRANSACTION
1013  SQL (37.0ms)  EXEC sp_helpconstraint 'defaults','nomsg'
1014  EXECUTE (2.0ms)  ALTER TABLE [defaults] ALTER COLUMN [decimal_number] decimal(4)
1015  SQL (28.0ms)  EXEC sp_helpconstraint 'defaults','nomsg'
1016  EXECUTE (1.0ms)  ROLLBACK TRANSACTION
1017  EXECUTE (0.0ms)  BEGIN TRANSACTION
1018  SQL (5.0ms)  EXEC sp_helpconstraint 'people','nomsg'
1019  EXECUTE (0.0ms)  ALTER TABLE [people] DROP CONSTRAINT DF__people__lock_ver__7857F5CA
1020  EXECUTE (2.0ms)  ALTER TABLE [people] ALTER COLUMN [lock_version] varchar(255)
1021  EXECUTE (1.0ms)  ROLLBACK TRANSACTION
1022  EXECUTE (0.0ms)  BEGIN TRANSACTION
1023  EXECUTE (1.0ms)  CREATE TABLE [schema_migrations] ([version] varchar(255) NOT NULL) 
1024  SQL (0.0ms)  EXEC sp_helpindex [schema_migrations]
1025  EXECUTE (1.0ms)  CREATE UNIQUE INDEX [unique_schema_migrations] ON [schema_migrations] ([version])
1026  SQL (1.0ms)  SELECT [schema_migrations].[version] FROM [schema_migrations]
1027Migrating to TableWillNeverBeCreated (1)
1028  EXECUTE (0.0ms)  SAVE TRANSACTION active_record_1
1029  EXECUTE (1.0ms)  CREATE TABLE [sqlserver_trans_table1] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY) 
1030  EXECUTE (1.0ms)  ROLLBACK TRANSACTION active_record_1
1031  EXECUTE (0.0ms)  ROLLBACK TRANSACTION
1032  EXECUTE (0.0ms)  BEGIN TRANSACTION
1033  Developer Load (4.0ms)  SELECT TOP (1) [developers].* FROM [developers] WHERE ([developers].[id] = 11)
1034  Developer Load (3.0ms)  SELECT TOP (1) [__rnt].* FROM ( SELECT ROW_NUMBER() OVER (ORDER BY id asc) AS [__rn], [developers].* FROM [developers] WHERE (salary < 100000) ) AS [__rnt] WHERE [__rnt].[__rn] > 1
1035  EXECUTE (1.0ms)  ROLLBACK TRANSACTION
1036  EXECUTE (0.0ms)  BEGIN TRANSACTION
1037  EXECUTE (1.0ms)  DELETE FROM [books]
1038  SQL (0.0ms)  SELECT @@ROWCOUNT AS AffectedRows
1039  EXECUTE (1.0ms)  SAVE TRANSACTION active_record_1
1040  EXECUTE (0.0ms)  INSERT INTO [books] ([name]) VALUES (NULL)
1041  SQL (0.0ms)  SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
1042  EXECUTE (1.0ms)  SAVE TRANSACTION active_record_1
1043  EXECUTE (0.0ms)  INSERT INTO [books] ([name]) VALUES (NULL)
1044  SQL (1.0ms)  SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
1045  EXECUTE (0.0ms)  SAVE TRANSACTION active_record_1
1046  EXECUTE (0.0ms)  INSERT INTO [books] ([name]) VALUES (NULL)
1047  SQL (1.0ms)  SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
1048  EXECUTE (0.0ms)  SAVE TRANSACTION active_record_1
1049  EXECUTE (0.0ms)  INSERT INTO [books] ([name]) VALUES (NULL)
1050  SQL (0.0ms)  SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
1051  EXECUTE (0.0ms)  SAVE TRANSACTION active_record_1
1052  EXECUTE (0.0ms)  INSERT INTO [books] ([name]) VALUES (NULL)
1053  SQL (0.0ms)  SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
1054  EXECUTE (0.0ms)  SAVE TRANSACTION active_record_1
1055  EXECUTE (0.0ms)  INSERT INTO [books] ([name]) VALUES (NULL)
1056  SQL (0.0ms)  SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
1057  EXECUTE (1.0ms)  SAVE TRANSACTION active_record_1
1058  EXECUTE (0.0ms)  INSERT INTO [books] ([name]) VALUES (NULL)
1059  SQL (0.0ms)  SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
1060  EXECUTE (0.0ms)  SAVE TRANSACTION active_record_1
1061  EXECUTE (0.0ms)  INSERT INTO [books] ([name]) VALUES (NULL)
1062  SQL (1.0ms)  SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
1063  EXECUTE (0.0ms)  SAVE TRANSACTION active_record_1
1064  EXECUTE (0.0ms)  INSERT INTO [books] ([name]) VALUES (NULL)
1065  SQL (0.0ms)  SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
1066  EXECUTE (1.0ms)  SAVE TRANSACTION active_record_1
1067  EXECUTE (0.0ms)  INSERT INTO [books] ([name]) VALUES (NULL)
1068  SQL (0.0ms)  SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
1069  Book Load (7.0ms)  SELECT TOP (3) [__rnt].* FROM ( SELECT ROW_NUMBER() OVER (ORDER BY [books].[id]) AS [__rn], [books].* FROM [books] WITH (NOLOCK) ) AS [__rnt] WHERE [__rnt].[__rn] > 5
1070  SQL (1.0ms)  SELECT COUNT([count]) AS [count_id] FROM ( SELECT TOP (8) ROW_NUMBER() OVER (ORDER BY [books].[id]) AS [__rn], 1 AS [count] FROM [books] WITH (NOLOCK) ) AS [__rnt] WHERE [__rnt].[__rn] > 5
1071  EXECUTE (0.0ms)  SAVE TRANSACTION active_record_1
1072  EXECUTE (1.0ms)  DELETE FROM [books] WHERE ([books].[id] = 1)
1073  SQL (0.0ms)  SELECT @@ROWCOUNT AS AffectedRows
1074  EXECUTE (0.0ms)  SAVE TRANSACTION active_record_1
1075  EXECUTE (0.0ms)  DELETE FROM [books] WHERE ([books].[id] = 2)
1076  SQL (0.0ms)  SELECT @@ROWCOUNT AS AffectedRows
1077  EXECUTE (0.0ms)  SAVE TRANSACTION active_record_1
1078  EXECUTE (1.0ms)  DELETE FROM [books] WHERE ([books].[id] = 3)
1079  SQL (0.0ms)  SELECT @@ROWCOUNT AS AffectedRows
1080  EXECUTE (0.0ms)  SAVE TRANSACTION active_record_1
1081  EXECUTE (0.0ms)  DELETE FROM [books] WHERE ([books].[id] = 4)
1082  SQL (0.0ms)  SELECT @@ROWCOUNT AS AffectedRows
1083  EXECUTE (0.0ms)  SAVE TRANSACTION active_record_1
1084  EXECUTE (0.0ms)  DELETE FROM [books] WHERE ([books].[id] = 5)
1085  SQL (0.0ms)  SELECT @@ROWCOUNT AS AffectedRows
1086  EXECUTE (0.0ms)  SAVE TRANSACTION active_record_1
1087  EXECUTE (0.0ms)  DELETE FROM [books] WHERE ([books].[id] = 6)
1088  SQL (1.0ms)  SELECT @@ROWCOUNT AS AffectedRows
1089  EXECUTE (0.0ms)  SAVE TRANSACTION active_record_1
1090  EXECUTE (1.0ms)  DELETE FROM [books] WHERE ([books].[id] = 7)
1091  SQL (0.0ms)  SELECT @@ROWCOUNT AS AffectedRows
1092  EXECUTE (0.0ms)  SAVE TRANSACTION active_record_1
1093  EXECUTE (1.0ms)  DELETE FROM [books] WHERE ([books].[id] = 8)
1094  SQL (0.0ms)  SELECT @@ROWCOUNT AS AffectedRows
1095  EXECUTE (1.0ms)  SAVE TRANSACTION active_record_1
1096  EXECUTE (0.0ms)  DELETE FROM [books] WHERE ([books].[id] = 9)
1097  SQL (0.0ms)  SELECT @@ROWCOUNT AS AffectedRows
1098  EXECUTE (0.0ms)  SAVE TRANSACTION active_record_1
1099  EXECUTE (1.0ms)  DELETE FROM [books] WHERE ([books].[id] = 10)
1100  SQL (0.0ms)  SELECT @@ROWCOUNT AS AffectedRows
1101  EXECUTE (1.0ms)  ROLLBACK TRANSACTION
1102  EXECUTE (0.0ms)  BEGIN TRANSACTION
1103  EXECUTE (0.0ms)  DELETE FROM [books]
1104  SQL (0.0ms)  SELECT @@ROWCOUNT AS AffectedRows
1105  EXECUTE (1.0ms)  SAVE TRANSACTION active_record_1
1106  EXECUTE (0.0ms)  INSERT INTO [books] ([name]) VALUES (NULL)
1107  SQL (1.0ms)  SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
1108  EXECUTE (0.0ms)  SAVE TRANSACTION active_record_1
1109  EXECUTE (0.0ms)  INSERT INTO [books] ([name]) VALUES (NULL)
1110  SQL (0.0ms)  SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
1111  EXECUTE (0.0ms)  SAVE TRANSACTION active_record_1
1112  EXECUTE (0.0ms)  INSERT INTO [books] ([name]) VALUES (NULL)
1113  SQL (0.0ms)  SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
1114  EXECUTE (0.0ms)  SAVE TRANSACTION active_record_1
1115  EXECUTE (1.0ms)  INSERT INTO [books] ([name]) VALUES (NULL)
1116  SQL (0.0ms)  SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
1117  EXECUTE (0.0ms)  SAVE TRANSACTION active_record_1
1118  EXECUTE (0.0ms)  INSERT INTO [books] ([name]) VALUES (NULL)
1119  SQL (0.0ms)  SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
1120  EXECUTE (0.0ms)  SAVE TRANSACTION active_record_1
1121  EXECUTE (1.0ms)  INSERT INTO [books] ([name]) VALUES (NULL)
1122  SQL (0.0ms)  SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
1123  EXECUTE (0.0ms)  SAVE TRANSACTION active_record_1
1124  EXECUTE (0.0ms)  INSERT INTO [books] ([name]) VALUES (NULL)
1125  SQL (0.0ms)  SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
1126  EXECUTE (0.0ms)  SAVE TRANSACTION active_record_1
1127  EXECUTE (0.0ms)  INSERT INTO [books] ([name]) VALUES (NULL)
1128  SQL (1.0ms)  SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
1129  EXECUTE (0.0ms)  SAVE TRANSACTION active_record_1
1130  EXECUTE (0.0ms)  INSERT INTO [books] ([name]) VALUES (NULL)
1131  SQL (0.0ms)  SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
1132  EXECUTE (0.0ms)  SAVE TRANSACTION active_record_1
1133  EXECUTE (0.0ms)  INSERT INTO [books] ([name]) VALUES (NULL)
1134  SQL (0.0ms)  SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
1135  Book Load (0.0ms)  SELECT TOP (3) [__rnt].* FROM ( SELECT ROW_NUMBER() OVER (ORDER BY [books].[id]) AS [__rn], [books].* FROM [books] ) AS [__rnt] WHERE [__rnt].[__rn] > 5
1136  EXECUTE (0.0ms)  SAVE TRANSACTION active_record_1
1137  EXECUTE (0.0ms)  DELETE FROM [books] WHERE ([books].[id] = 11)
1138  SQL (0.0ms)  SELECT @@ROWCOUNT AS AffectedRows
1139  EXECUTE (0.0ms)  SAVE TRANSACTION active_record_1
1140  EXECUTE (0.0ms)  DELETE FROM [books] WHERE ([books].[id] = 12)
1141  SQL (0.0ms)  SELECT @@ROWCOUNT AS AffectedRows
1142  EXECUTE (0.0ms)  SAVE TRANSACTION active_record_1
1143  EXECUTE (0.0ms)  DELETE FROM [books] WHERE ([books].[id] = 13)
1144  SQL (0.0ms)  SELECT @@ROWCOUNT AS AffectedRows
1145  EXECUTE (0.0ms)  SAVE TRANSACTION active_record_1
1146  EXECUTE (0.0ms)  DELETE FROM [books] WHERE ([books].[id] = 14)
1147  SQL (0.0ms)  SELECT @@ROWCOUNT AS AffectedRows
1148  EXECUTE (0.0ms)  SAVE TRANSACTION active_record_1
1149  EXECUTE (0.0ms)  DELETE FROM [books] WHERE ([books].[id] = 15)
1150  SQL (0.0ms)  SELECT @@ROWCOUNT AS AffectedRows
1151  EXECUTE (0.0ms)  SAVE TRANSACTION active_record_1
1152  EXECUTE (0.0ms)  DELETE FROM [books] WHERE ([books].[id] = 16)
1153  SQL (0.0ms)  SELECT @@ROWCOUNT AS AffectedRows
1154  EXECUTE (0.0ms)  SAVE TRANSACTION active_record_1
1155  EXECUTE (0.0ms)  DELETE FROM [books] WHERE ([books].[id] = 17)
1156  SQL (0.0ms)  SELECT @@ROWCOUNT AS AffectedRows
1157  EXECUTE (1.0ms)  SAVE TRANSACTION active_record_1
1158  EXECUTE (0.0ms)  DELETE FROM [books] WHERE ([books].[id] = 18)
1159  SQL (0.0ms)  SELECT @@ROWCOUNT AS AffectedRows
1160  EXECUTE (1.0ms)  SAVE TRANSACTION active_record_1
1161  EXECUTE (0.0ms)  DELETE FROM [books] WHERE ([books].[id] = 19)
1162  SQL (0.0ms)  SELECT @@ROWCOUNT AS AffectedRows
1163  EXECUTE (1.0ms)  SAVE TRANSACTION active_record_1
1164  EXECUTE (0.0ms)  DELETE FROM [books] WHERE ([books].[id] = 20)
1165  SQL (0.0ms)  SELECT @@ROWCOUNT AS AffectedRows
1166  EXECUTE (0.0ms)  ROLLBACK TRANSACTION
1167  EXECUTE (0.0ms)  BEGIN TRANSACTION
1168  EXECUTE (0.0ms)  DELETE FROM [books]
1169  SQL (0.0ms)  SELECT @@ROWCOUNT AS AffectedRows
1170  EXECUTE (0.0ms)  SAVE TRANSACTION active_record_1
1171  EXECUTE (0.0ms)  INSERT INTO [books] ([name]) VALUES (NULL)
1172  SQL (1.0ms)  SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
1173  EXECUTE (0.0ms)  SAVE TRANSACTION active_record_1
1174  EXECUTE (0.0ms)  INSERT INTO [books] ([name]) VALUES (NULL)
1175  SQL (0.0ms)  SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
1176  EXECUTE (0.0ms)  SAVE TRANSACTION active_record_1
1177  EXECUTE (0.0ms)  INSERT INTO [books] ([name]) VALUES (NULL)
1178  SQL (0.0ms)  SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
1179  EXECUTE (1.0ms)  SAVE TRANSACTION active_record_1
1180  EXECUTE (0.0ms)  INSERT INTO [books] ([name]) VALUES (NULL)
1181  SQL (0.0ms)  SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
1182  EXECUTE (0.0ms)  SAVE TRANSACTION active_record_1
1183  EXECUTE (0.0ms)  INSERT INTO [books] ([name]) VALUES (NULL)
1184  SQL (1.0ms)  SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
1185  EXECUTE (0.0ms)  SAVE TRANSACTION active_record_1
1186  EXECUTE (0.0ms)  INSERT INTO [books] ([name]) VALUES (NULL)
1187  SQL (1.0ms)  SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
1188  EXECUTE (0.0ms)  SAVE TRANSACTION active_record_1
1189  EXECUTE (0.0ms)  INSERT INTO [books] ([name]) VALUES (NULL)
1190  SQL (0.0ms)  SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
1191  EXECUTE (0.0ms)  SAVE TRANSACTION active_record_1
1192  EXECUTE (0.0ms)  INSERT INTO [books] ([name]) VALUES (NULL)
1193  SQL (1.0ms)  SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
1194  EXECUTE (0.0ms)  SAVE TRANSACTION active_record_1
1195  EXECUTE (0.0ms)  INSERT INTO [books] ([name]) VALUES (NULL)
1196  SQL (0.0ms)  SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
1197  EXECUTE (0.0ms)  SAVE TRANSACTION active_record_1
1198  EXECUTE (0.0ms)  INSERT INTO [books] ([name]) VALUES (NULL)
1199  SQL (1.0ms)  SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
1200  Book Load (1.0ms)  SELECT TOP (10) [__rnt].* FROM ( SELECT ROW_NUMBER() OVER (ORDER BY [books].[id]) AS [__rn], [books].* FROM [books] ) AS [__rnt] WHERE [__rnt].[__rn] > 5
1201  EXECUTE (1.0ms)  SAVE TRANSACTION active_record_1
1202  EXECUTE (0.0ms)  DELETE FROM [books] WHERE ([books].[id] = 21)
1203  SQL (0.0ms)  SELECT @@ROWCOUNT AS AffectedRows
1204  EXECUTE (1.0ms)  SAVE TRANSACTION active_record_1
1205  EXECUTE (0.0ms)  DELETE FROM [books] WHERE ([books].[id] = 22)
1206  SQL (0.0ms)  SELECT @@ROWCOUNT AS AffectedRows
1207  EXECUTE (1.0ms)  SAVE TRANSACTION active_record_1
1208  EXECUTE (0.0ms)  DELETE FROM [books] WHERE ([books].[id] = 23)
1209  SQL (0.0ms)  SELECT @@ROWCOUNT AS AffectedRows
1210  EXECUTE (1.0ms)  SAVE TRANSACTION active_record_1
1211  EXECUTE (0.0ms)  DELETE FROM [books] WHERE ([books].[id] = 24)
1212  SQL (0.0ms)  SELECT @@ROWCOUNT AS AffectedRows
1213  EXECUTE (1.0ms)  SAVE TRANSACTION active_record_1
1214  EXECUTE (0.0ms)  DELETE FROM [books] WHERE ([books].[id] = 25)
1215  SQL (0.0ms)  SELECT @@ROWCOUNT AS AffectedRows
1216  EXECUTE (1.0ms)  SAVE TRANSACTION active_record_1
1217  EXECUTE (0.0ms)  DELETE FROM [books] WHERE ([books].[id] = 26)
1218  SQL (0.0ms)  SELECT @@ROWCOUNT AS AffectedRows
1219  EXECUTE (0.0ms)  SAVE TRANSACTION active_record_1
1220  EXECUTE (0.0ms)  DELETE FROM [books] WHERE ([books].[id] = 27)
1221  SQL (0.0ms)  SELECT @@ROWCOUNT AS AffectedRows
1222  EXECUTE (0.0ms)  SAVE TRANSACTION active_record_1
1223  EXECUTE (0.0ms)  DELETE FROM [books] WHERE ([books].[id] = 28)
1224  SQL (0.0ms)  SELECT @@ROWCOUNT AS AffectedRows
1225  EXECUTE (0.0ms)  SAVE TRANSACTION active_record_1
1226  EXECUTE (0.0ms)  DELETE FROM [books] WHERE ([books].[id] = 29)
1227  SQL (1.0ms)  SELECT @@ROWCOUNT AS AffectedRows
1228  EXECUTE (0.0ms)  SAVE TRANSACTION active_record_1
1229  EXECUTE (1.0ms)  DELETE FROM [books] WHERE ([books].[id] = 30)
1230  SQL (0.0ms)  SELECT @@ROWCOUNT AS AffectedRows
1231  EXECUTE (1.0ms)  ROLLBACK TRANSACTION
1232  EXECUTE (0.0ms)  BEGIN TRANSACTION
1233  EXECUTE (1.0ms)  DELETE FROM [books]
1234  SQL (0.0ms)  SELECT @@ROWCOUNT AS AffectedRows
1235  EXECUTE (0.0ms)  SAVE TRANSACTION active_record_1
1236  EXECUTE (0.0ms)  INSERT INTO [books] ([name]) VALUES (NULL)
1237  SQL (0.0ms)  SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
1238  EXECUTE (1.0ms)  SAVE TRANSACTION active_record_1
1239  EXECUTE (0.0ms)  INSERT INTO [books] ([name]) VALUES (NULL)
1240  SQL (1.0ms)  SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
1241  EXECUTE (0.0ms)  SAVE TRANSACTION active_record_1
1242  EXECUTE (1.0ms)  INSERT INTO [books] ([name]) VALUES (NULL)
1243  SQL (0.0ms)  SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
1244  EXECUTE (0.0ms)  SAVE TRANSACTION active_record_1
1245  EXECUTE (0.0ms)  INSERT INTO [books] ([name]) VALUES (NULL)
1246  SQL (0.0ms)  SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
1247  EXECUTE (0.0ms)  SAVE TRANSACTION active_record_1
1248  EXECUTE (1.0ms)  INSERT INTO [books] ([name]) VALUES (NULL)
1249  SQL (0.0ms)  SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
1250  EXECUTE (0.0ms)  SAVE TRANSACTION active_record_1
1251  EXECUTE (0.0ms)  INSERT INTO [books] ([name]) VALUES (NULL)
1252  SQL (0.0ms)  SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
1253  EXECUTE (0.0ms)  SAVE TRANSACTION active_record_1
1254  EXECUTE (0.0ms)  INSERT INTO [books] ([name]) VALUES (NULL)
1255  SQL (0.0ms)  SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
1256  EXECUTE (0.0ms)  SAVE TRANSACTION active_record_1
1257  EXECUTE (0.0ms)  INSERT INTO [books] ([name]) VALUES (NULL)
1258  SQL (0.0ms)  SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
1259  EXECUTE (0.0ms)  SAVE TRANSACTION active_record_1
1260  EXECUTE (0.0ms)  INSERT INTO [books] ([name]) VALUES (NULL)
1261  SQL (1.0ms)  SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
1262  EXECUTE (0.0ms)  SAVE TRANSACTION active_record_1
1263  EXECUTE (0.0ms)  INSERT INTO [books] ([name]) VALUES (NULL)
1264  SQL (0.0ms)  SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
1265  Book Load (1.0ms)  SELECT TOP (10) [__rnt].* FROM ( SELECT ROW_NUMBER() OVER (ORDER BY [books].[id]) AS [__rn], [books].* FROM [books] ) AS [__rnt] WHERE [__rnt].[__rn] > 0
1266  EXECUTE (0.0ms)  SAVE TRANSACTION active_record_1
1267  EXECUTE (0.0ms)  DELETE FROM [books] WHERE ([books].[id] = 31)
1268  SQL (0.0ms)  SELECT @@ROWCOUNT AS AffectedRows
1269  EXECUTE (0.0ms)  SAVE TRANSACTION active_record_1
1270  EXECUTE (0.0ms)  DELETE FROM [books] WHERE ([books].[id] = 32)
1271  SQL (0.0ms)  SELECT @@ROWCOUNT AS AffectedRows
1272  EXECUTE (0.0ms)  SAVE TRANSACTION active_record_1
1273  EXECUTE (0.0ms)  DELETE FROM [books] WHERE ([books].[id] = 33)
1274  SQL (0.0ms)  SELECT @@ROWCOUNT AS AffectedRows
1275  EXECUTE (0.0ms)  SAVE TRANSACTION active_record_1
1276  EXECUTE (0.0ms)  DELETE FROM [books] WHERE ([books].[id] = 34)
1277  SQL (0.0ms)  SELECT @@ROWCOUNT AS AffectedRows
1278  EXECUTE (0.0ms)  SAVE TRANSACTION active_record_1
1279  EXECUTE (0.0ms)  DELETE FROM [books] WHERE ([books].[id] = 35)
1280  SQL (0.0ms)  SELECT @@ROWCOUNT AS AffectedRows
1281  EXECUTE (0.0ms)  SAVE TRANSACTION active_record_1
1282  EXECUTE (0.0ms)  DELETE FROM [books] WHERE ([books].[id] = 36)
1283  SQL (0.0ms)  SELECT @@ROWCOUNT AS AffectedRows
1284  EXECUTE (0.0ms)  SAVE TRANSACTION active_record_1
1285  EXECUTE (0.0ms)  DELETE FROM [books] WHERE ([books].[id] = 37)
1286  SQL (0.0ms)  SELECT @@ROWCOUNT AS AffectedRows
1287  EXECUTE (0.0ms)  SAVE TRANSACTION active_record_1
1288  EXECUTE (0.0ms)  DELETE FROM [books] WHERE ([books].[id] = 38)
1289  SQL (0.0ms)  SELECT @@ROWCOUNT AS AffectedRows
1290  EXECUTE (0.0ms)  SAVE TRANSACTION active_record_1
1291  EXECUTE (0.0ms)  DELETE FROM [books] WHERE ([books].[id] = 39)
1292  SQL (0.0ms)  SELECT @@ROWCOUNT AS AffectedRows
1293  EXECUTE (0.0ms)  SAVE TRANSACTION active_record_1
1294  EXECUTE (0.0ms)  DELETE FROM [books] WHERE ([books].[id] = 40)
1295  SQL (0.0ms)  SELECT @@ROWCOUNT AS AffectedRows
1296  EXECUTE (0.0ms)  ROLLBACK TRANSACTION
1297  EXECUTE (0.0ms)  BEGIN TRANSACTION
1298  EXECUTE (0.0ms)  DELETE FROM [books]
1299  SQL (0.0ms)  SELECT @@ROWCOUNT AS AffectedRows
1300  EXECUTE (0.0ms)  SAVE TRANSACTION active_record_1
1301  EXECUTE (0.0ms)  INSERT INTO [books] ([name]) VALUES (NULL)
1302  SQL (0.0ms)  SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
1303  EXECUTE (0.0ms)  SAVE TRANSACTION active_record_1
1304  EXECUTE (0.0ms)  INSERT INTO [books] ([name]) VALUES (NULL)
1305  SQL (0.0ms)  SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
1306  EXECUTE (0.0ms)  SAVE TRANSACTION active_record_1
1307  EXECUTE (0.0ms)  INSERT INTO [books] ([name]) VALUES (NULL)
1308  SQL (1.0ms)  SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
1309  EXECUTE (0.0ms)  SAVE TRANSACTION active_record_1
1310  EXECUTE (0.0ms)  INSERT INTO [books] ([name]) VALUES (NULL)
1311  SQL (0.0ms)  SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
1312  EXECUTE (0.0ms)  SAVE TRANSACTION active_record_1
1313  EXECUTE (0.0ms)  INSERT INTO [books] ([name]) VALUES (NULL)
1314  SQL (1.0ms)  SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
1315  EXECUTE (0.0ms)  SAVE TRANSACTION active_record_1
1316  EXECUTE (1.0ms)  INSERT INTO [books] ([name]) VALUES (NULL)
1317  SQL (0.0ms)  SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
1318  EXECUTE (0.0ms)  SAVE TRANSACTION active_record_1
1319  EXECUTE (0.0ms)  INSERT INTO [books] ([name]) VALUES (NULL)
1320  SQL (0.0ms)  SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
1321  EXECUTE (0.0ms)  SAVE TRANSACTION active_record_1
1322  EXECUTE (1.0ms)  INSERT INTO [books] ([name]) VALUES (NULL)
1323  SQL (0.0ms)  SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
1324  EXECUTE (1.0ms)  SAVE TRANSACTION active_record_1
1325  EXECUTE (0.0ms)  INSERT INTO [books] ([name]) VALUES (NULL)
1326  SQL (1.0ms)  SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
1327  EXECUTE (0.0ms)  SAVE TRANSACTION active_record_1
1328  EXECUTE (0.0ms)  INSERT INTO [books] ([name]) VALUES (NULL)
1329  SQL (0.0ms)  SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
1330  SQL (1.0ms)  SELECT COUNT(*) AS count_id FROM [posts]
1331  SQL (2.0ms)  SELECT COUNT([count]) AS [count_id] FROM ( SELECT TOP (2) ROW_NUMBER() OVER (ORDER BY [posts].[id]) AS [__rn], 1 AS [count] FROM [posts] ) AS [__rnt] WHERE [__rnt].[__rn] > 1
1332  SQL (1.0ms)  SELECT COUNT([count]) AS [count_id] FROM ( SELECT TOP (6) ROW_NUMBER() OVER (ORDER BY [posts].[id]) AS [__rn], 1 AS [count] FROM [posts] ) AS [__rnt] WHERE [__rnt].[__rn] > 5
1333  SQL (1.0ms)  SELECT COUNT([count]) AS [count_id] FROM ( SELECT TOP (7) ROW_NUMBER() OVER (ORDER BY [posts].[id]) AS [__rn], 1 AS [count] FROM [posts] ) AS [__rnt] WHERE [__rnt].[__rn] > 6
1334  SQL (1.0ms)  SELECT COUNT([count]) AS [count_id] FROM ( SELECT TOP (8) ROW_NUMBER() OVER (ORDER BY [posts].[id]) AS [__rn], 1 AS [count] FROM [posts] ) AS [__rnt] WHERE [__rnt].[__rn] > 7
1335  SQL (1.0ms)  SELECT COUNT([count]) AS [count_id] FROM ( SELECT TOP (7) ROW_NUMBER() OVER (ORDER BY [posts].[id]) AS [__rn], 1 AS [count] FROM [posts] ) AS [__rnt] WHERE [__rnt].[__rn] > 4
1336  SQL (1.0ms)  SELECT COUNT([count]) AS [count_id] FROM ( SELECT TOP (8) ROW_NUMBER() OVER (ORDER BY [posts].[id]) AS [__rn], 1 AS [count] FROM [posts] ) AS [__rnt] WHERE [__rnt].[__rn] > 5
1337  SQL (1.0ms)  SELECT COUNT([count]) AS [count_id] FROM ( SELECT TOP (9) ROW_NUMBER() OVER (ORDER BY [posts].[id]) AS [__rn], 1 AS [count] FROM [posts] ) AS [__rnt] WHERE [__rnt].[__rn] > 6
1338  SQL (2.0ms)  SELECT COUNT([count]) AS [count_id] FROM ( SELECT TOP (10) ROW_NUMBER() OVER (ORDER BY [posts].[id]) AS [__rn], 1 AS [count] FROM [posts] ) AS [__rnt] WHERE [__rnt].[__rn] > 7
1339  SQL (1.0ms)  SELECT COUNT([count]) AS [count_id] FROM ( SELECT TOP (11) ROW_NUMBER() OVER (ORDER BY [posts].[id]) AS [__rn], 1 AS [count] FROM [posts] ) AS [__rnt] WHERE [__rnt].[__rn] > 8
1340  EXECUTE (0.0ms)  SAVE TRANSACTION active_record_1
1341  EXECUTE (0.0ms)  DELETE FROM [books] WHERE ([books].[id] = 41)
1342  SQL (0.0ms)  SELECT @@ROWCOUNT AS AffectedRows
1343  EXECUTE (0.0ms)  SAVE TRANSACTION active_record_1
1344  EXECUTE (1.0ms)  DELETE FROM [books] WHERE ([books].[id] = 42)
1345  SQL (0.0ms)  SELECT @@ROWCOUNT AS AffectedRows
1346  EXECUTE (1.0ms)  SAVE TRANSACTION active_record_1
1347  EXECUTE (0.0ms)  DELETE FROM [books] WHERE ([books].[id] = 43)
1348  SQL (0.0ms)  SELECT @@ROWCOUNT AS AffectedRows
1349  EXECUTE (0.0ms)  SAVE TRANSACTION active_record_1
1350  EXECUTE (1.0ms)  DELETE FROM [books] WHERE ([books].[id] = 44)
1351  SQL (0.0ms)  SELECT @@ROWCOUNT AS AffectedRows
1352  EXECUTE (0.0ms)  SAVE TRANSACTION active_record_1
1353  EXECUTE (0.0ms)  DELETE FROM [books] WHERE ([books].[id] = 45)
1354  SQL (0.0ms)  SELECT @@ROWCOUNT AS AffectedRows
1355  EXECUTE (0.0ms)  SAVE TRANSACTION active_record_1
1356  EXECUTE (0.0ms)  DELETE FROM [books] WHERE ([books].[id] = 46)
1357  SQL (0.0ms)  SELECT @@ROWCOUNT AS AffectedRows
1358  EXECUTE (0.0ms)  SAVE TRANSACTION active_record_1
1359  EXECUTE (0.0ms)  DELETE FROM [books] WHERE ([books].[id] = 47)
1360  SQL (1.0ms)  SELECT @@ROWCOUNT AS AffectedRows
1361  EXECUTE (0.0ms)  SAVE TRANSACTION active_record_1
1362  EXECUTE (1.0ms)  DELETE FROM [books] WHERE ([books].[id] = 48)
1363  SQL (0.0ms)  SELECT @@ROWCOUNT AS AffectedRows
1364  EXECUTE (0.0ms)  SAVE TRANSACTION active_record_1
1365  EXECUTE (0.0ms)  DELETE FROM [books] WHERE ([books].[id] = 49)
1366  SQL (0.0ms)  SELECT @@ROWCOUNT AS AffectedRows
1367  EXECUTE (0.0ms)  SAVE TRANSACTION active_record_1
1368  EXECUTE (0.0ms)  DELETE FROM [books] WHERE ([books].[id] = 50)
1369  SQL (1.0ms)  SELECT @@ROWCOUNT AS AffectedRows
1370  EXECUTE (0.0ms)  ROLLBACK TRANSACTION
1371  EXECUTE (0.0ms)  BEGIN TRANSACTION
1372  EXECUTE (0.0ms)  DELETE FROM [books]
1373  SQL (0.0ms)  SELECT @@ROWCOUNT AS AffectedRows
1374  EXECUTE (0.0ms)  SAVE TRANSACTION active_record_1
1375  EXECUTE (0.0ms)  INSERT INTO [books] ([name]) VALUES (NULL)
1376  SQL (0.0ms)  SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
1377  EXECUTE (0.0ms)  SAVE TRANSACTION active_record_1
1378  EXECUTE (0.0ms)  INSERT INTO [books] ([name]) VALUES (NULL)
1379  SQL (0.0ms)  SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
1380  EXECUTE (0.0ms)  SAVE TRANSACTION active_record_1
1381  EXECUTE (0.0ms)  INSERT INTO [books] ([name]) VALUES (NULL)
1382  SQL (1.0ms)  SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
1383  EXECUTE (0.0ms)  SAVE TRANSACTION active_record_1
1384  EXECUTE (0.0ms)  INSERT INTO [books] ([name]) VALUES (NULL)
1385  SQL (0.0ms)  SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
1386  EXECUTE (0.0ms)  SAVE TRANSACTION active_record_1
1387  EXECUTE (0.0ms)  INSERT INTO [books] ([name]) VALUES (NULL)
1388  SQL (1.0ms)  SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
1389  EXECUTE (0.0ms)  SAVE TRANSACTION active_record_1
1390  EXECUTE (0.0ms)  INSERT INTO [books] ([name]) VALUES (NULL)
1391  SQL (0.0ms)  SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
1392  EXECUTE (1.0ms)  SAVE TRANSACTION active_record_1
1393  EXECUTE (0.0ms)  INSERT INTO [books] ([name]) VALUES (NULL)
1394  SQL (1.0ms)  SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
1395  EXECUTE (0.0ms)  SAVE TRANSACTION active_record_1
1396  EXECUTE (0.0ms)  INSERT INTO [books] ([name]) VALUES (NULL)
1397  SQL (0.0ms)  SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
1398  EXECUTE (0.0ms)  SAVE TRANSACTION active_record_1
1399  EXECUTE (0.0ms)  INSERT INTO [books] ([name]) VALUES (NULL)
1400  SQL (1.0ms)  SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
1401  EXECUTE (0.0ms)  SAVE TRANSACTION active_record_1
1402  EXECUTE (0.0ms)  INSERT INTO [books] ([name]) VALUES (NULL)
1403  SQL (0.0ms)  SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
1404  Book Load (1.0ms)  SELECT TOP (10) [books].* FROM [books]
1405  EXECUTE (0.0ms)  SAVE TRANSACTION active_record_1
1406  EXECUTE (1.0ms)  DELETE FROM [books] WHERE ([books].[id] = 51)
1407  SQL (0.0ms)  SELECT @@ROWCOUNT AS AffectedRows
1408  EXECUTE (1.0ms)  SAVE TRANSACTION active_record_1
1409  EXECUTE (0.0ms)  DELETE FROM [books] WHERE ([books].[id] = 52)
1410  SQL (0.0ms)  SELECT @@ROWCOUNT AS AffectedRows
1411  EXECUTE (0.0ms)  SAVE TRANSACTION active_record_1
1412  EXECUTE (0.0ms)  DELETE FROM [books] WHERE ([books].[id] = 53)
1413  SQL (0.0ms)  SELECT @@ROWCOUNT AS AffectedRows
1414  EXECUTE (0.0ms)  SAVE TRANSACTION active_record_1
1415  EXECUTE (0.0ms)  DELETE FROM [books] WHERE ([books].[id] = 54)
1416  SQL (0.0ms)  SELECT @@ROWCOUNT AS AffectedRows
1417  EXECUTE (0.0ms)  SAVE TRANSACTION active_record_1
1418  EXECUTE (1.0ms)  DELETE FROM [books] WHERE ([books].[id] = 55)
1419  SQL (0.0ms)  SELECT @@ROWCOUNT AS AffectedRows
1420  EXECUTE (0.0ms)  SAVE TRANSACTION active_record_1
1421  EXECUTE (0.0ms)  DELETE FROM [books] WHERE ([books].[id] = 56)
1422  SQL (0.0ms)  SELECT @@ROWCOUNT AS AffectedRows
1423  EXECUTE (1.0ms)  SAVE TRANSACTION active_record_1
1424  EXECUTE (0.0ms)  DELETE FROM [books] WHERE ([books].[id] = 57)
1425  SQL (0.0ms)  SELECT @@ROWCOUNT AS AffectedRows
1426  EXECUTE (0.0ms)  SAVE TRANSACTION active_record_1
1427  EXECUTE (0.0ms)  DELETE FROM [books] WHERE ([books].[id] = 58)
1428  SQL (0.0ms)  SELECT @@ROWCOUNT AS AffectedRows
1429  EXECUTE (0.0ms)  SAVE TRANSACTION active_record_1
1430  EXECUTE (0.0ms)  DELETE FROM [books] WHERE ([books].[id] = 59)
1431  SQL (1.0ms)  SELECT @@ROWCOUNT AS AffectedRows
1432  EXECUTE (0.0ms)  SAVE TRANSACTION active_record_1
1433  EXECUTE (0.0ms)  DELETE FROM [books] WHERE ([books].[id] = 60)
1434  SQL (0.0ms)  SELECT @@ROWCOUNT AS AffectedRows
1435  EXECUTE (0.0ms)  ROLLBACK TRANSACTION
1436  EXECUTE (0.0ms)  BEGIN TRANSACTION
1437  EXECUTE (0.0ms)  DELETE FROM [books]
1438  SQL (1.0ms)  SELECT @@ROWCOUNT AS AffectedRows
1439  EXECUTE (0.0ms)  SAVE TRANSACTION active_record_1
1440  EXECUTE (1.0ms)  INSERT INTO [books] ([name]) VALUES (NULL)
1441  SQL (0.0ms)  SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
1442  EXECUTE (0.0ms)  SAVE TRANSACTION active_record_1
1443  EXECUTE (0.0ms)  INSERT INTO [books] ([name]) VALUES (NULL)
1444  SQL (0.0ms)  SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
1445  EXECUTE (0.0ms)  SAVE TRANSACTION active_record_1
1446  EXECUTE (1.0ms)  INSERT INTO [books] ([name]) VALUES (NULL)
1447  SQL (0.0ms)  SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
1448  EXECUTE (0.0ms)  SAVE TRANSACTION active_record_1
1449  EXECUTE (0.0ms)  INSERT INTO [books] ([name]) VALUES (NULL)
1450  SQL (0.0ms)  SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
1451  EXECUTE (0.0ms)  SAVE TRANSACTION active_record_1
1452  EXECUTE (0.0ms)  INSERT INTO [books] ([name]) VALUES (NULL)
1453  SQL (0.0ms)  SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
1454  EXECUTE (0.0ms)  SAVE TRANSACTION active_record_1
1455  EXECUTE (0.0ms)  INSERT INTO [books] ([name]) VALUES (NULL)
1456  SQL (0.0ms)  SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
1457  EXECUTE (1.0ms)  SAVE TRANSACTION active_record_1
1458  EXECUTE (0.0ms)  INSERT INTO [books] ([name]) VALUES (NULL)
1459  SQL (1.0ms)  SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
1460  EXECUTE (0.0ms)  SAVE TRANSACTION active_record_1
1461  EXECUTE (0.0ms)  INSERT INTO [books] ([name]) VALUES (NULL)
1462  SQL (1.0ms)  SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
1463  EXECUTE (0.0ms)  SAVE TRANSACTION active_record_1
1464  EXECUTE (0.0ms)  INSERT INTO [books] ([name]) VALUES (NULL)
1465  SQL (0.0ms)  SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
1466  EXECUTE (0.0ms)  SAVE TRANSACTION active_record_1
1467  EXECUTE (0.0ms)  INSERT INTO [books] ([name]) VALUES (NULL)
1468  SQL (0.0ms)  SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
1469  Book Load (1.0ms)  SELECT TOP (20) [books].* FROM [books]
1470  EXECUTE (1.0ms)  SAVE TRANSACTION active_record_1
1471  EXECUTE (0.0ms)  DELETE FROM [books] WHERE ([books].[id] = 61)
1472  SQL (1.0ms)  SELECT @@ROWCOUNT AS AffectedRows
1473  EXECUTE (0.0ms)  SAVE TRANSACTION active_record_1
1474  EXECUTE (0.0ms)  DELETE FROM [books] WHERE ([books].[id] = 62)
1475  SQL (1.0ms)  SELECT @@ROWCOUNT AS AffectedRows
1476  EXECUTE (0.0ms)  SAVE TRANSACTION active_record_1
1477  EXECUTE (1.0ms)  DELETE FROM [books] WHERE ([books].[id] = 63)
1478  SQL (0.0ms)  SELECT @@ROWCOUNT AS AffectedRows
1479  EXECUTE (0.0ms)  SAVE TRANSACTION active_record_1
1480  EXECUTE (1.0ms)  DELETE FROM [books] WHERE ([books].[id] = 64)
1481  SQL (0.0ms)  SELECT @@ROWCOUNT AS AffectedRows
1482  EXECUTE (0.0ms)  SAVE TRANSACTION active_record_1
1483  EXECUTE (1.0ms)  DELETE FROM [books] WHERE ([books].[id] = 65)
1484  SQL (0.0ms)  SELECT @@ROWCOUNT AS AffectedRows
1485  EXECUTE (0.0ms)  SAVE TRANSACTION active_record_1
1486  EXECUTE (1.0ms)  DELETE FROM [books] WHERE ([books].[id] = 66)
1487  SQL (0.0ms)  SELECT @@ROWCOUNT AS AffectedRows
1488  EXECUTE (0.0ms)  SAVE TRANSACTION active_record_1
1489  EXECUTE (1.0ms)  DELETE FROM [books] WHERE ([books].[id] = 67)
1490  SQL (0.0ms)  SELECT @@ROWCOUNT AS AffectedRows
1491  EXECUTE (0.0ms)  SAVE TRANSACTION active_record_1
1492  EXECUTE (1.0ms)  DELETE FROM [books] WHERE ([books].[id] = 68)
1493  SQL (0.0ms)  SELECT @@ROWCOUNT AS AffectedRows
1494  EXECUTE (0.0ms)  SAVE TRANSACTION active_record_1
1495  EXECUTE (1.0ms)  DELETE FROM [books] WHERE ([books].[id] = 69)
1496  SQL (0.0ms)  SELECT @@ROWCOUNT AS AffectedRows
1497  EXECUTE (0.0ms)  SAVE TRANSACTION active_record_1
1498  EXECUTE (1.0ms)  DELETE FROM [books] WHERE ([books].[id] = 70)
1499  SQL (0.0ms)  SELECT @@ROWCOUNT AS AffectedRows
1500  EXECUTE (0.0ms)  ROLLBACK TRANSACTION
1501  EXECUTE (0.0ms)  BEGIN TRANSACTION
1502  EXECUTE (0.0ms)  DELETE FROM [books]
1503  SQL (0.0ms)  SELECT @@ROWCOUNT AS AffectedRows
1504  EXECUTE (0.0ms)  SAVE TRANSACTION active_record_1
1505  EXECUTE (0.0ms)  INSERT INTO [books] ([name]) VALUES (NULL)
1506  SQL (1.0ms)  SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
1507  EXECUTE (0.0ms)  SAVE TRANSACTION active_record_1
1508  EXECUTE (0.0ms)  INSERT INTO [books] ([name]) VALUES (NULL)
1509  SQL (1.0ms)  SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
1510  EXECUTE (1.0ms)  SAVE TRANSACTION active_record_1
1511  EXECUTE (0.0ms)  INSERT INTO [books] ([name]) VALUES (NULL)
1512  SQL (1.0ms)  SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
1513  EXECUTE (0.0ms)  SAVE TRANSACTION active_record_1
1514  EXECUTE (0.0ms)  INSERT INTO [books] ([name]) VALUES (NULL)
1515  SQL (0.0ms)  SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
1516  EXECUTE (0.0ms)  SAVE TRANSACTION active_record_1
1517  EXECUTE (1.0ms)  INSERT INTO [books] ([name]) VALUES (NULL)
1518  SQL (0.0ms)  SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
1519  EXECUTE (0.0ms)  SAVE TRANSACTION active_record_1
1520  EXECUTE (1.0ms)  INSERT INTO [books] ([name]) VALUES (NULL)
1521  SQL (0.0ms)  SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
1522  EXECUTE (0.0ms)  SAVE TRANSACTION active_record_1
1523  EXECUTE (0.0ms)  INSERT INTO [books] ([name]) VALUES (NULL)
1524  SQL (0.0ms)  SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
1525  EXECUTE (1.0ms)  SAVE TRANSACTION active_record_1
1526  EXECUTE (0.0ms)  INSERT INTO [books] ([name]) VALUES (NULL)
1527  SQL (0.0ms)  SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
1528  EXECUTE (0.0ms)  SAVE TRANSACTION active_record_1
1529  EXECUTE (1.0ms)  INSERT INTO [books] ([name]) VALUES (NULL)
1530  SQL (0.0ms)  SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
1531  EXECUTE (0.0ms)  SAVE TRANSACTION active_record_1
1532  EXECUTE (0.0ms)  INSERT INTO [books] ([name]) VALUES (NULL)
1533  SQL (1.0ms)  SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
1534  Book Load (2.0ms)  SELECT [__rnt].* FROM ( SELECT ROW_NUMBER() OVER (ORDER BY [books].[id]) AS [__rn], [books].* FROM [books] ) AS [__rnt] WHERE [__rnt].[__rn] > 1
1535  EXECUTE (0.0ms)  SAVE TRANSACTION active_record_1
1536  EXECUTE (1.0ms)  DELETE FROM [books] WHERE ([books].[id] = 71)
1537  SQL (0.0ms)  SELECT @@ROWCOUNT AS AffectedRows
1538  EXECUTE (0.0ms)  SAVE TRANSACTION active_record_1
1539  EXECUTE (1.0ms)  DELETE FROM [books] WHERE ([books].[id] = 72)
1540  SQL (0.0ms)  SELECT @@ROWCOUNT AS AffectedRows
1541  EXECUTE (0.0ms)  SAVE TRANSACTION active_record_1
1542  EXECUTE (1.0ms)  DELETE FROM [books] WHERE ([books].[id] = 73)
1543  SQL (0.0ms)  SELECT @@ROWCOUNT AS AffectedRows
1544  EXECUTE (0.0ms)  SAVE TRANSACTION active_record_1
1545  EXECUTE (0.0ms)  DELETE FROM [books] WHERE ([books].[id] = 74)
1546  SQL (0.0ms)  SELECT @@ROWCOUNT AS AffectedRows
1547  EXECUTE (1.0ms)  SAVE TRANSACTION active_record_1
1548  EXECUTE (0.0ms)  DELETE FROM [books] WHERE ([books].[id] = 75)
1549  SQL (0.0ms)  SELECT @@ROWCOUNT AS AffectedRows
1550  EXECUTE (1.0ms)  SAVE TRANSACTION active_record_1
1551  EXECUTE (0.0ms)  DELETE FROM [books] WHERE ([books].[id] = 76)
1552  SQL (1.0ms)  SELECT @@ROWCOUNT AS AffectedRows
1553  EXECUTE (1.0ms)  SAVE TRANSACTION active_record_1
1554  EXECUTE (0.0ms)  DELETE FROM [books] WHERE ([books].[id] = 77)
1555  SQL (1.0ms)  SELECT @@ROWCOUNT AS AffectedRows
1556  EXECUTE (0.0ms)  SAVE TRANSACTION active_record_1
1557  EXECUTE (0.0ms)  DELETE FROM [books] WHERE ([books].[id] = 78)
1558  SQL (0.0ms)  SELECT @@ROWCOUNT AS AffectedRows
1559  EXECUTE (0.0ms)  SAVE TRANSACTION active_record_1
1560  EXECUTE (1.0ms)  DELETE FROM [books] WHERE ([books].[id] = 79)
1561  SQL (0.0ms)  SELECT @@ROWCOUNT AS AffectedRows
1562  EXECUTE (0.0ms)  SAVE TRANSACTION active_record_1
1563  EXECUTE (0.0ms)  DELETE FROM [books] WHERE ([books].[id] = 80)
1564  SQL (1.0ms)  SELECT @@ROWCOUNT AS AffectedRows
1565  EXECUTE (1.0ms)  ROLLBACK TRANSACTION
1566  EXECUTE (0.0ms)  USE [activerecord_unittest]
1567  EXECUTE (0.0ms)  BEGIN TRANSACTION
1568  Person Load (2.0ms)  SELECT TOP (1) [people].* FROM [people] WHERE ([people].[id] = 1)
1569  EXECUTE (1.0ms)  USE [activerecord_unittest]
1570  EXECUTE (0.0ms)  BEGIN TRANSACTION
1571  Person Load (1.0ms)  SELECT TOP (1) [people].* FROM [people] WHERE ([people].[id] = 1)
1572  EXECUTE (0.0ms)  COMMIT TRANSACTION
1573  EXECUTE (1.0ms)  COMMIT TRANSACTION
1574  EXECUTE (0.0ms)  USE [activerecord_unittest]
1575  EXECUTE (1.0ms)  USE [activerecord_unittest]
1576  EXECUTE (0.0ms)  BEGIN TRANSACTION
1577  EXECUTE (1.0ms)  INSERT INTO [people] ([first_name], [gender], [lock_version], [number1_fan_id], [primary_contact_id]) VALUES (N'Thing_0', NULL, 0, NULL, NULL)
1578  SQL (1.0ms)  SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
1579  EXECUTE (1.0ms)  COMMIT TRANSACTION
1580  EXECUTE (0.0ms)  BEGIN TRANSACTION
1581  EXECUTE (1.0ms)  INSERT INTO [people] ([first_name], [gender], [lock_version], [number1_fan_id], [primary_contact_id]) VALUES (N'Thing_1', NULL, 0, NULL, NULL)
1582  SQL (0.0ms)  SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
1583  EXECUTE (0.0ms)  COMMIT TRANSACTION
1584  EXECUTE (1.0ms)  BEGIN TRANSACTION
1585  EXECUTE (1.0ms)  INSERT INTO [people] ([first_name], [gender], [lock_version], [number1_fan_id], [primary_contact_id]) VALUES (N'Thing_2', NULL, 0, NULL, NULL)
1586  SQL (0.0ms)  SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
1587  EXECUTE (0.0ms)  COMMIT TRANSACTION
1588  EXECUTE (0.0ms)  BEGIN TRANSACTION
1589  EXECUTE (0.0ms)  INSERT INTO [people] ([first_name], [gender], [lock_version], [number1_fan_id], [primary_contact_id]) VALUES (N'Thing_3', NULL, 0, NULL, NULL)
1590  SQL (1.0ms)  SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
1591  EXECUTE (1.0ms)  COMMIT TRANSACTION
1592  EXECUTE (0.0ms)  BEGIN TRANSACTION
1593  EXECUTE (0.0ms)  INSERT INTO [people] ([first_name], [gender], [lock_version], [number1_fan_id], [primary_contact_id]) VALUES (N'Thing_4', NULL, 0, NULL, NULL)
1594  SQL (0.0ms)  SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
1595  EXECUTE (0.0ms)  COMMIT TRANSACTION
1596  EXECUTE (1.0ms)  BEGIN TRANSACTION
1597  EXECUTE (1.0ms)  INSERT INTO [people] ([first_name], [gender], [lock_version], [number1_fan_id], [primary_contact_id]) VALUES (N'Thing_5', NULL, 0, NULL, NULL)
1598  SQL (0.0ms)  SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
1599  EXECUTE (0.0ms)  COMMIT TRANSACTION
1600  EXECUTE (0.0ms)  BEGIN TRANSACTION
1601  EXECUTE (1.0ms)  INSERT INTO [people] ([first_name], [gender], [lock_version], [number1_fan_id], [primary_contact_id]) VALUES (N'Thing_6', NULL, 0, NULL, NULL)
1602  SQL (0.0ms)  SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
1603  EXECUTE (1.0ms)  COMMIT TRANSACTION
1604  EXECUTE (0.0ms)  BEGIN TRANSACTION
1605  EXECUTE (0.0ms)  INSERT INTO [people] ([first_name], [gender], [lock_version], [number1_fan_id], [primary_contact_id]) VALUES (N'Thing_7', NULL, 0, NULL, NULL)
1606  SQL (1.0ms)  SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
1607  EXECUTE (1.0ms)  COMMIT TRANSACTION
1608  EXECUTE (0.0ms)  BEGIN TRANSACTION
1609  EXECUTE (0.0ms)  INSERT INTO [people] ([first_name], [gender], [lock_version], [number1_fan_id], [primary_contact_id]) VALUES (N'Thing_8', NULL, 0, NULL, NULL)
1610  SQL (1.0ms)  SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
1611  EXECUTE (1.0ms)  COMMIT TRANSACTION
1612  EXECUTE (0.0ms)  BEGIN TRANSACTION
1613  EXECUTE (0.0ms)  INSERT INTO [people] ([first_name], [gender], [lock_version], [number1_fan_id], [primary_contact_id]) VALUES (N'Thing_9', NULL, 0, NULL, NULL)
1614  SQL (0.0ms)  SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
1615  EXECUTE (0.0ms)  COMMIT TRANSACTION
1616  EXECUTE (1.0ms)  BEGIN TRANSACTION
1617  EXECUTE (1.0ms)  INSERT INTO [people] ([first_name], [gender], [lock_version], [number1_fan_id], [primary_contact_id]) VALUES (N'Thing_10', NULL, 0, NULL, NULL)
1618  SQL (0.0ms)  SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
1619  EXECUTE (0.0ms)  COMMIT TRANSACTION
1620  EXECUTE (1.0ms)  BEGIN TRANSACTION
1621  EXECUTE (1.0ms)  INSERT INTO [people] ([first_name], [gender], [lock_version], [number1_fan_id], [primary_contact_id]) VALUES (N'Thing_11', NULL, 0, NULL, NULL)
1622  SQL (0.0ms)  SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
1623  EXECUTE (1.0ms)  COMMIT TRANSACTION
1624  EXECUTE (0.0ms)  BEGIN TRANSACTION
1625  EXECUTE (0.0ms)  INSERT INTO [people] ([first_name], [gender], [lock_version], [number1_fan_id], [primary_contact_id]) VALUES (N'Thing_12', NULL, 0, NULL, NULL)
1626  SQL (1.0ms)  SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
1627  EXECUTE (1.0ms)  COMMIT TRANSACTION
1628  EXECUTE (0.0ms)  BEGIN TRANSACTION
1629  EXECUTE (0.0ms)  INSERT INTO [people] ([first_name], [gender], [lock_version], [number1_fan_id], [primary_contact_id]) VALUES (N'Thing_13', NULL, 0, NULL, NULL)
1630  SQL (1.0ms)  SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
1631  EXECUTE (1.0ms)  COMMIT TRANSACTION
1632  EXECUTE (1.0ms)  BEGIN TRANSACTION
1633  EXECUTE (1.0ms)  INSERT INTO [people] ([first_name], [gender], [lock_version], [number1_fan_id], [primary_contact_id]) VALUES (N'Thing_14', NULL, 0, NULL, NULL)
1634  SQL (0.0ms)  SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
1635  EXECUTE (1.0ms)  COMMIT TRANSACTION
1636  EXECUTE (0.0ms)  BEGIN TRANSACTION
1637  EXECUTE (0.0ms)  INSERT INTO [people] ([first_name], [gender], [lock_version], [number1_fan_id], [primary_contact_id]) VALUES (N'Thing_15', NULL, 0, NULL, NULL)
1638  SQL (1.0ms)  SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
1639  EXECUTE (1.0ms)  COMMIT TRANSACTION
1640  EXECUTE (0.0ms)  BEGIN TRANSACTION
1641  EXECUTE (0.0ms)  INSERT INTO [people] ([first_name], [gender], [lock_version], [number1_fan_id], [primary_contact_id]) VALUES (N'Thing_16', NULL, 0, NULL, NULL)
1642  SQL (0.0ms)  SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
1643  EXECUTE (0.0ms)  COMMIT TRANSACTION
1644  EXECUTE (0.0ms)  BEGIN TRANSACTION
1645  EXECUTE (0.0ms)  INSERT INTO [people] ([first_name], [gender], [lock_version], [number1_fan_id], [primary_contact_id]) VALUES (N'Thing_17', NULL, 0, NULL, NULL)
1646  SQL (0.0ms)  SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
1647  EXECUTE (0.0ms)  COMMIT TRANSACTION
1648  EXECUTE (0.0ms)  BEGIN TRANSACTION
1649  EXECUTE (0.0ms)  INSERT INTO [people] ([first_name], [gender], [lock_version], [number1_fan_id], [primary_contact_id]) VALUES (N'Thing_18', NULL, 0, NULL, NULL)
1650  SQL (1.0ms)  SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
1651  EXECUTE (1.0ms)  COMMIT TRANSACTION
1652  EXECUTE (0.0ms)  BEGIN TRANSACTION
1653  EXECUTE (0.0ms)  INSERT INTO [people] ([first_name], [gender], [lock_version], [number1_fan_id], [primary_contact_id]) VALUES (N'Thing_19', NULL, 0, NULL, NULL)
1654  SQL (0.0ms)  SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
1655  EXECUTE (0.0ms)  COMMIT TRANSACTION
1656  Person Load (1.0ms)  SELECT DISTINCT TOP (5) [__rnt].id FROM ( SELECT ROW_NUMBER() OVER (ORDER BY [people].[id]) AS [__rn], [people].id FROM [people] WITH (NOLOCK) LEFT OUTER JOIN [readers] ON [readers].[person_id] = [people].[id] ) AS [__rnt] WHERE [__rnt].[__rn] > 10
1657  Person Load (4.0ms)  SELECT [people].[id] AS t0_r0, [people].[first_name] AS t0_r1, [people].[primary_contact_id] AS t0_r2, [people].[gender] AS t0_r3, [people].[number1_fan_id] AS t0_r4, [people].[lock_version] AS t0_r5, [readers].[id] AS t1_r0, [readers].[post_id] AS t1_r1, [readers].[person_id] AS t1_r2, [readers].[skimmer] AS t1_r3 FROM [people] WITH (NOLOCK) LEFT OUTER JOIN [readers] ON [readers].[person_id] = [people].[id] WHERE ([people].[id] IN (11, 12, 13, 14, 15))
1658  EXECUTE (0.0ms)  USE [activerecord_unittest]
1659  EXECUTE (1.0ms)  USE [activerecord_unittest]
1660  EXECUTE (1.0ms)  BEGIN TRANSACTION
1661  Person Load (1.0ms)  SELECT TOP (1) [people].* FROM [people] WITH(HOLDLOCK, ROWLOCK) WHERE ([people].[id] = 1)
1662  Reader Load (1.0ms)  SELECT [readers].* FROM [readers] WHERE ([readers].person_id = 1)
1663  EXECUTE (0.0ms)  COMMIT TRANSACTION
1664  EXECUTE (0.0ms)  USE [activerecord_unittest]
1665  EXECUTE (0.0ms)  USE [activerecord_unittest]
1666  EXECUTE (0.0ms)  BEGIN TRANSACTION
1667  Person Load (1.0ms)  SELECT TOP (1) [people].* FROM [people] WITH(HOLDLOCK, ROWLOCK) WHERE ([people].[id] = 1)
1668  EXECUTE (0.0ms)  COMMIT TRANSACTION
1669  EXECUTE (0.0ms)  USE [activerecord_unittest]
1670  EXECUTE (0.0ms)  USE [activerecord_unittest]
1671  EXECUTE (0.0ms)  BEGIN TRANSACTION
1672  Person Load (0.0ms)  SELECT TOP (1) [people].* FROM [people] WITH(HOLDLOCK, ROWLOCK) WHERE ([people].[id] = 1)
1673  EXECUTE (0.0ms)  COMMIT TRANSACTION
1674  EXECUTE (0.0ms)  USE [activerecord_unittest]
1675  EXECUTE (1.0ms)  USE [activerecord_unittest]
1676  EXECUTE (0.0ms)  BEGIN TRANSACTION
1677  Person Load (1.0ms)  SELECT TOP (1) [people].* FROM [people] WHERE ([people].[id] = 1)
1678  Person Load (1.0ms)  SELECT TOP (1) [people].* FROM [people] WITH(HOLDLOCK, ROWLOCK) WHERE ([people].[id] = 1)
1679  EXECUTE (1.0ms)  COMMIT TRANSACTION
1680  EXECUTE (0.0ms)  USE [activerecord_unittest]
1681  EXECUTE (0.0ms)  USE [activerecord_unittest]
1682  Person Load (1.0ms)  SELECT [people].* FROM [people] WITH (NOLOCK)
1683  EXECUTE (0.0ms)  USE [activerecord_unittest]
1684  EXECUTE (0.0ms)  BEGIN TRANSACTION
1685  SQL (1.0ms)  SELECT count(*) AS count_all FROM tasks
1686  EXECUTE (0.0ms)  ROLLBACK TRANSACTION
1687  EXECUTE (0.0ms)  BEGIN TRANSACTION
1688  EXECUTE (0.0ms)  ROLLBACK TRANSACTION
1689  EXECUTE (0.0ms)  BEGIN TRANSACTION
1690  SQL (1.0ms)  EXEC sp_helpindex [integer_limits]
1691  EXECUTE (1.0ms)  ROLLBACK TRANSACTION
1692  EXECUTE (1.0ms)  BEGIN TRANSACTION
1693  SQL (1.0ms)  EXEC sp_helpindex [movies]
1694  EXECUTE (0.0ms)  ROLLBACK TRANSACTION
1695  EXECUTE (0.0ms)  BEGIN TRANSACTION
1696  SQL (1.0ms)  EXEC sp_helpindex [sql_server_strings]
1697  EXECUTE (1.0ms)  ROLLBACK TRANSACTION
1698  EXECUTE (0.0ms)  BEGIN TRANSACTION
1699  EXECUTE (0.0ms)  ROLLBACK TRANSACTION
1700  EXECUTE (0.0ms)  BEGIN TRANSACTION
1701  EXECUTE (0.0ms)  SAVE TRANSACTION active_record_1
1702  EXECUTE (2.0ms)  INSERT INTO [string_defaults] ([string_with_multiline_default], [string_with_null_default], [string_with_pretend_null_four], [string_with_pretend_null_one], [string_with_pretend_null_three], [string_with_pretend_null_two], [string_with_pretend_paren_three]) VALUES (N'Some long default with a
1703new line.', NULL, N'(NULL)', N'null', N'NULL', N'(null)', N'(3)')
1704  SQL (0.0ms)  SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
1705  EXECUTE (0.0ms)  ROLLBACK TRANSACTION
1706  EXECUTE (0.0ms)  BEGIN TRANSACTION
1707  EXECUTE (0.0ms)  ROLLBACK TRANSACTION
1708  EXECUTE (0.0ms)  BEGIN TRANSACTION
1709  EXECUTE (0.0ms)  SAVE TRANSACTION active_record_1
1710  EXECUTE (1.0ms)  INSERT INTO [quoted-table] DEFAULT VALUES
1711  SQL (1.0ms)  SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
1712  SqlServerQuotedTable Load (1.0ms)  SELECT TOP (1) [quoted-table].* FROM [quoted-table]
1713  EXECUTE (1.0ms)  SAVE TRANSACTION active_record_1
1714  EXECUTE (1.0ms)  INSERT INTO [quoted-view1] DEFAULT VALUES
1715  SQL (0.0ms)  SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
1716  SqlServerQuotedView1 Load (1.0ms)  SELECT TOP (1) [quoted-view1].* FROM [quoted-view1]
1717  EXECUTE (0.0ms)  SAVE TRANSACTION active_record_1
1718  EXECUTE (1.0ms)  INSERT INTO [quoted-view2] DEFAULT VALUES
1719  SQL (0.0ms)  SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
1720  SqlServerQuotedView2 Load (0.0ms)  SELECT TOP (1) [quoted-view2].* FROM [quoted-view2]
1721  EXECUTE (0.0ms)  ROLLBACK TRANSACTION
1722  EXECUTE (0.0ms)  BEGIN TRANSACTION
1723  EXECUTE (0.0ms)  SAVE TRANSACTION active_record_1
1724  EXECUTE (1.0ms)  INSERT INTO [sql_server_edge_schemas] ([bigint], [description], [guid], [guid_newid], [guid_newseqid], [tinyint]) VALUES (5000, N'Five Thousand', NULL, NULL, NULL, NULL)
1725  SQL (1.0ms)  SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
1726  EXECUTE (0.0ms)  SAVE TRANSACTION active_record_1
1727  EXECUTE (1.0ms)  INSERT INTO [sql_server_edge_schemas] ([bigint], [description], [guid], [guid_newid], [guid_newseqid], [tinyint]) VALUES (9000000000000000000, N'Close to max bignum', NULL, NULL, NULL, NULL)
1728  SQL (1.0ms)  SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
1729  SqlServerEdgeSchema Load (2.0ms)  SELECT TOP (1) [sql_server_edge_schemas].* FROM [sql_server_edge_schemas] WHERE ([sql_server_edge_schemas].[bigint] = 5000)
1730  SqlServerEdgeSchema Load (1.0ms)  SELECT TOP (1) bigint FROM [sql_server_edge_schemas] WHERE ([sql_server_edge_schemas].[bigint] = 5000)
1731  SqlServerEdgeSchema Load (0.0ms)  SELECT TOP (1) [sql_server_edge_schemas].* FROM [sql_server_edge_schemas] WHERE ([sql_server_edge_schemas].[bigint] = 9000000000000000000)
1732  SqlServerEdgeSchema Load (1.0ms)  SELECT TOP (1) bigint FROM [sql_server_edge_schemas] WHERE ([sql_server_edge_schemas].[bigint] = 9000000000000000000)
1733  EXECUTE (0.0ms)  ROLLBACK TRANSACTION
1734  EXECUTE (0.0ms)  BEGIN TRANSACTION
1735  EXECUTE (1.0ms)  SAVE TRANSACTION active_record_1
1736  EXECUTE (1.0ms)  INSERT INTO [sql_server_edge_schemas] ([bigint], [description], [guid], [guid_newid], [guid_newseqid], [tinyint]) VALUES (NULL, N'A', NULL, NULL, NULL, NULL)
1737  SQL (0.0ms)  SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
1738  EXECUTE (0.0ms)  SAVE TRANSACTION active_record_1
1739  EXECUTE (0.0ms)  INSERT INTO [sql_server_edge_schemas] ([bigint], [description], [guid], [guid_newid], [guid_newseqid], [tinyint]) VALUES (NULL, N'B', NULL, NULL, NULL, NULL)
1740  SQL (1.0ms)  SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
1741  EXECUTE (0.0ms)  SAVE TRANSACTION active_record_1
1742  EXECUTE (0.0ms)  INSERT INTO [sql_server_edge_schemas] ([bigint], [description], [guid], [guid_newid], [guid_newseqid], [tinyint]) VALUES (NULL, N'C', NULL, NULL, NULL, NULL)
1743  SQL (0.0ms)  SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
1744  SqlServerEdgeSchema Load (1.0ms)  SELECT [sql_server_edge_schemas].* FROM [sql_server_edge_schemas] ORDER BY description
1745  SqlServerEdgeSchema Load (1.0ms)  SELECT [sql_server_edge_schemas].* FROM [sql_server_edge_schemas] ORDER BY description asc
1746  SqlServerEdgeSchema Load (1.0ms)  SELECT [sql_server_edge_schemas].* FROM [sql_server_edge_schemas] ORDER BY description ASC
1747  SqlServerEdgeSchema Load (1.0ms)  SELECT [sql_server_edge_schemas].* FROM [sql_server_edge_schemas] ORDER BY description desc
1748  SqlServerEdgeSchema Load (1.0ms)  SELECT [sql_server_edge_schemas].* FROM [sql_server_edge_schemas] ORDER BY description DESC
1749  EXECUTE (1.0ms)  DELETE FROM [sql_server_edge_schemas]
1750  SQL (0.0ms)  SELECT @@ROWCOUNT AS AffectedRows
1751  EXECUTE (1.0ms)  ROLLBACK TRANSACTION
1752  EXECUTE (1.0ms)  BEGIN TRANSACTION
1753  EXECUTE (0.0ms)  SAVE TRANSACTION active_record_1
1754  EXECUTE (1.0ms)  INSERT INTO [sql_server_edge_schemas] ([bigint], [description], [guid], [guid_newid], [guid_newseqid], [tinyint]) VALUES (NULL, NULL, NULL, NULL, NULL, 1)
1755  SQL (1.0ms)  SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
1756  EXECUTE (0.0ms)  SAVE TRANSACTION active_record_1
1757  EXECUTE (1.0ms)  INSERT INTO [sql_server_edge_schemas] ([bigint], [description], [guid], [guid_newid], [guid_newseqid], [tinyint]) VALUES (NULL, NULL, NULL, NULL, NULL, 255)
1758  SQL (0.0ms)  SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
1759  SqlServerEdgeSchema Load (2.0ms)  SELECT TOP (1) [sql_server_edge_schemas].* FROM [sql_server_edge_schemas] WHERE ([sql_server_edge_schemas].[tinyint] = 1)
1760  SqlServerEdgeSchema Load (0.0ms)  SELECT TOP (1) [sql_server_edge_schemas].* FROM [sql_server_edge_schemas] WHERE ([sql_server_edge_schemas].[tinyint] = 255)
1761  EXECUTE (0.0ms)  ROLLBACK TRANSACTION
1762  EXECUTE (0.0ms)  BEGIN TRANSACTION
1763  EXECUTE (0.0ms)  SAVE TRANSACTION active_record_1
1764  EXECUTE (1.0ms)  INSERT INTO [sql_server_edge_schemas] ([bigint], [description], [guid], [guid_newid], [guid_newseqid], [tinyint]) VALUES (NULL, NULL, NULL, NULL, NULL, 1)
1765  SQL (0.0ms)  SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
1766  EXECUTE (0.0ms)  SAVE TRANSACTION active_record_1
1767  EXECUTE (0.0ms)  INSERT INTO [sql_server_edge_schemas] ([bigint], [description], [guid], [guid_newid], [guid_newseqid], [tinyint]) VALUES (NULL, NULL, NULL, NULL, NULL, 255)
1768  SQL (0.0ms)  SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
1769  EXECUTE (0.0ms)  SAVE TRANSACTION active_record_1
1770  EXECUTE (1.0ms)  INSERT INTO [sql_server_edge_schemas] ([bigint], [description], [guid], [guid_newid], [guid_newseqid], [tinyint]) VALUES (NULL, NULL, NULL, NULL, NULL, 256)
1771ODBC::Error: 22003 (220) [Microsoft][ODBC SQL Server Driver][SQL Server]Arithmetic overflow error for data type tinyint, value = 256.: INSERT INTO [sql_server_edge_schemas] ([bigint], [description], [guid], [guid_newid], [guid_newseqid], [tinyint]) VALUES (NULL, NULL, NULL, NULL, NULL, 256)
1772  EXECUTE (1.0ms)  ROLLBACK TRANSACTION active_record_1
1773  EXECUTE (1.0ms)  ROLLBACK TRANSACTION
1774  EXECUTE (1.0ms)  BEGIN TRANSACTION
1775  SQL (0.0ms)  SELECT NEWID()
1776  EXECUTE (0.0ms)  SAVE TRANSACTION active_record_1
1777  EXECUTE (1.0ms)  INSERT INTO [sql_server_edge_schemas] ([bigint], [description], [guid], [guid_newid], [guid_newseqid], [tinyint]) VALUES (NULL, NULL, N'27B60410-9394-4500-A22E-75D64476E091', NULL, NULL, NULL)
1778  SQL (0.0ms)  SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
1779  SqlServerEdgeSchema Load (2.0ms)  SELECT TOP (1) [sql_server_edge_schemas].* FROM [sql_server_edge_schemas] WHERE ([sql_server_edge_schemas].[id] = 11)
1780  EXECUTE (1.0ms)  ROLLBACK TRANSACTION
1781  EXECUTE (1.0ms)  BEGIN TRANSACTION
1782  SQL (0.0ms)  SELECT NEWID()
1783  EXECUTE (1.0ms)  ROLLBACK TRANSACTION
1784  EXECUTE (1.0ms)  BEGIN TRANSACTION
1785  SQL (0.0ms)  SELECT NEWID()
1786  EXECUTE (0.0ms)  SAVE TRANSACTION active_record_1
1787  SQL (0.0ms)  SELECT NEWID()
1788  EXECUTE (1.0ms)  INSERT INTO [sql_server_edge_schemas] ([bigint], [description], [guid], [guid_newid], [guid_newseqid], [tinyint]) VALUES (NULL, NULL, NULL, N'61ECA329-56A7-421D-928C-A7609988CC44', NULL, NULL)
1789  SQL (1.0ms)  SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
1790  EXECUTE (0.0ms)  ROLLBACK TRANSACTION
1791  Order Load (1.0ms)  SELECT [orders].* FROM [orders]
1792  EXECUTE (1.0ms)  DELETE FROM [ships]
1793  SQL (0.0ms)  SELECT @@ROWCOUNT AS AffectedRows
1794  EXECUTE (1.0ms)  BEGIN TRANSACTION
1795  EXECUTE (0.0ms)  ROLLBACK TRANSACTION
1796  EXECUTE (1.0ms)  DELETE FROM [ships]
1797  SQL (0.0ms)  SELECT @@ROWCOUNT AS AffectedRows
1798  EXECUTE (1.0ms)  BEGIN TRANSACTION
1799  EXECUTE (0.0ms)  ROLLBACK TRANSACTION
1800  EXECUTE (0.0ms)  DELETE FROM [ships]
1801  SQL (1.0ms)  SELECT @@ROWCOUNT AS AffectedRows
1802  EXECUTE (1.0ms)  BEGIN TRANSACTION
1803  EXECUTE (0.0ms)  ROLLBACK TRANSACTION
1804  EXECUTE (0.0ms)  DELETE FROM [ships]
1805  SQL (1.0ms)  SELECT @@ROWCOUNT AS AffectedRows
1806  EXECUTE (0.0ms)  BEGIN TRANSACTION
1807  EXECUTE (1.0ms)  COMMIT TRANSACTION
1808  EXECUTE (0.0ms)  DELETE FROM [ships]
1809  SQL (1.0ms)  SELECT @@ROWCOUNT AS AffectedRows
1810  EXECUTE (0.0ms)  BEGIN TRANSACTION
1811  EXECUTE (1.0ms)  INSERT INTO [ships] ([created_at], [created_on], [name], [pirate_id], [updated_at], [updated_on]) VALUES (NULL, NULL, N'Black Pearl', NULL, NULL, NULL)
1812  SQL (0.0ms)  SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
1813  EXECUTE (0.0ms)  ROLLBACK TRANSACTION
1814  SQL (1.0ms)  SELECT COUNT(*) AS count_id FROM [ships]
1815  Ship Load (0.0ms)  SELECT [ships].* FROM [ships]
1816  EXECUTE (0.0ms)  DELETE FROM [ships]
1817  SQL (0.0ms)  SELECT @@ROWCOUNT AS AffectedRows
1818  EXECUTE (1.0ms)  BEGIN TRANSACTION
1819  EXECUTE (1.0ms)  INSERT INTO [ships] ([created_at], [created_on], [name], [pirate_id], [updated_at], [updated_on]) VALUES (NULL, NULL, N'Black Pearl', NULL, NULL, NULL)
1820  SQL (0.0ms)  SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
1821  EXECUTE (1.0ms)  INSERT INTO [ships] ([created_at], [created_on], [name], [pirate_id], [updated_at], [updated_on]) VALUES (NULL, NULL, N'Flying Dutchman', NULL, NULL, NULL)
1822  SQL (0.0ms)  SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
1823  EXECUTE (1.0ms)  ROLLBACK TRANSACTION
1824  SQL (0.0ms)  SELECT COUNT(*) AS count_id FROM [ships]
1825  Ship Load (1.0ms)  SELECT [ships].* FROM [ships]
1826  EXECUTE (0.0ms)  BEGIN TRANSACTION
1827  EXECUTE (0.0ms)  SAVE TRANSACTION active_record_1
1828  EXECUTE (2.0ms)  INSERT INTO [sql_server_unicodes] ([nchar], [nchar_10], [ntext], [ntext_10], [nvarchar], [nvarchar_100], [nvarchar_max], [nvarchar_max_10]) VALUES (N'01234567891', NULL, NULL, NULL, NULL, NULL, NULL, NULL)
1829ODBC::Error: 22001 (8152) [Microsoft][ODBC SQL Server Driver][SQL Server]String or binary data would be truncated.: INSERT INTO [sql_server_unicodes] ([nchar], [nchar_10], [ntext], [ntext_10], [nvarchar], [nvarchar_100], [nvarchar_max], [nvarchar_max_10]) VALUES (N'01234567891', NULL, NULL, NULL, NULL, NULL, NULL, NULL)
1830  EXECUTE (1.0ms)  ROLLBACK TRANSACTION active_record_1
1831  EXECUTE (1.0ms)  ROLLBACK TRANSACTION
1832  EXECUTE (1.0ms)  BEGIN TRANSACTION
1833  EXECUTE (0.0ms)  SAVE TRANSACTION active_record_1
1834  EXECUTE (2.0ms)  INSERT INTO [sql_server_unicodes] ([nchar], [nchar_10], [ntext], [ntext_10], [nvarchar], [nvarchar_100], [nvarchar_max], [nvarchar_max_10]) VALUES (NULL, NULL, NULL, NULL, NULL, N'01234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567891', NULL, NULL)
1835ODBC::Error: 22001 (8152) [Microsoft][ODBC SQL Server Driver][SQL Server]String or binary data would be truncated.: INSERT INTO [sql_server_unicodes] ([nchar], [nchar_10], [ntext], [ntext_10], [nvarchar], [nvarchar_100], [nvarchar_max], [nvarchar_max_10]) VALUES (NULL, NULL, NULL, NULL, NULL, N'01234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567891', NULL, NULL)
1836  EXECUTE (1.0ms)  ROLLBACK TRANSACTION active_record_1
1837  EXECUTE (1.0ms)  ROLLBACK TRANSACTION
1838  EXECUTE (1.0ms)  BEGIN TRANSACTION
1839  EXECUTE (0.0ms)  SAVE TRANSACTION active_record_1
1840  EXECUTE (0.0ms)  INSERT INTO [sql_server_unicodes] ([nchar], [nchar_10], [ntext], [ntext_10], [nvarchar], [nvarchar_100], [nvarchar_max], [nvarchar_max_10]) VALUES (N'A', NULL, NULL, NULL, NULL, NULL, NULL, NULL)
1841  SQL (1.0ms)  SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
1842  SqlServerUnicode Load (3.0ms)  SELECT TOP (1) [sql_server_unicodes].* FROM [sql_server_unicodes] WHERE ([sql_server_unicodes].[id] = 3)
1843  EXECUTE (0.0ms)  ROLLBACK TRANSACTION
1844  EXECUTE (0.0ms)  BEGIN TRANSACTION
1845  EXECUTE (0.0ms)  SAVE TRANSACTION active_record_1
1846  EXECUTE (1.0ms)  INSERT INTO [sql_server_unicodes] ([nchar], [nchar_10], [ntext], [ntext_10], [nvarchar], [nvarchar_100], [nvarchar_max], [nvarchar_max_10]) VALUES (NULL, NULL, NULL, NULL, NULL, NULL, N'Ken Collins', NULL)
1847  SQL (0.0ms)  SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
1848  SqlServerUnicode Load (1.0ms)  SELECT TOP (1) [sql_server_unicodes].* FROM [sql_server_unicodes] WHERE ([sql_server_unicodes].[id] = 4)
1849  EXECUTE (0.0ms)  ROLLBACK TRANSACTION
1850  EXECUTE (0.0ms)  BEGIN TRANSACTION
1851  EXECUTE (1.0ms)  SAVE TRANSACTION active_record_1
1852  EXECUTE (1.0ms)  INSERT INTO [sql_server_unicodes] ([nchar], [nchar_10], [ntext], [ntext_10], [nvarchar], [nvarchar_100], [nvarchar_max], [nvarchar_max_10]) VALUES (NULL, NULL, NULL, NULL, N'一二34五六', NULL, NULL, NULL)
1853  SQL (1.0ms)  SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
1854  SqlServerUnicode Load (1.0ms)  SELECT TOP (1) [sql_server_unicodes].* FROM [sql_server_unicodes] WHERE ([sql_server_unicodes].[id] = 5)
1855  EXECUTE (1.0ms)  ROLLBACK TRANSACTION
1856  EXECUTE (0.0ms)  BEGIN TRANSACTION
1857  SQL (6.0ms)  EXEC sp_helpconstraint 'events','nomsg'
1858  EXECUTE (2.0ms)  ALTER TABLE [events] ALTER COLUMN [title] nvarchar(30)
1859  EXECUTE (0.0ms)  SAVE TRANSACTION active_record_1
1860  Event Load (2.0ms)  SELECT TOP (1) [events].[id] FROM [events] WHERE ([events].[title] COLLATE Latin1_General_CS_AS_WS = N'一二三四五')
1861  EXECUTE (1.0ms)  INSERT INTO [events] ([title]) VALUES (N'一二三四五')
1862  SQL (1.0ms)  SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
1863  Event Load (2.0ms)  SELECT TOP (1) [events].[id] FROM [events] WHERE ([events].[title] COLLATE Latin1_General_CS_AS_WS = N'一二三四五') AND ([events].id <> 1)
1864  EXECUTE (0.0ms)  SAVE TRANSACTION active_record_1
1865  Event Load (1.0ms)  SELECT TOP (1) [events].[id] FROM [events] WHERE ([events].[title] COLLATE Latin1_General_CS_AS_WS = N'一二三四五')
1866  EXECUTE (0.0ms)  ROLLBACK TRANSACTION active_record_1
1867  Event Load (0.0ms)  SELECT TOP (1) [events].[id] FROM [events] WHERE ([events].[title] COLLATE Latin1_General_CS_AS_WS = N'一二三四五')
1868  EXECUTE (1.0ms)  ROLLBACK TRANSACTION