Skip to content

Instantly share code, notes, and snippets.

@claco
Created January 6, 2011 14:41
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save claco/767952 to your computer and use it in GitHub Desktop.
Save claco/767952 to your computer and use it in GitHub Desktop.
PS C:\Users\claco\activerecord-sqlserver-adapter> bundle exec rake test:odbc
(in C:/Users/claco/activerecord-sqlserver-adapter)
C:/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"
Using SQLServer via ODBC to activerecord_unittest
With enabled unicode string types
* DEFERRED: For abstract behavior with different language should do a date insertion when language is german.
Loaded suite C:/Ruby192/lib/ruby/1.9.1/rake/rake_test_loader
Started
..................................................F..............................................................................................E.........................F.F.
Finished in 18.627862 seconds.
1) Failure:
test: 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]:
#<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>.
<"null"> expected but was
<nil>.
2) Error:
test_coerced_schema_dump_keeps_large_precision_integer_columns_as_decimal(SchemaDumperTest):
NameError: undefined local variable or method `standard_dump' for #<SchemaDumperTest:0x4de1538>
test/cases/schema_dumper_test_sqlserver.rb:81:in `test_coerced_schema_dump_keeps_large_precision_integer_columns_as_decimal'
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'
C:/Users/claco/rails/activesupport/lib/active_support/testing/setup_and_teardown.rb:35:in `block in run'
C:/Users/claco/rails/activesupport/lib/active_support/callbacks.rb:418:in `_run_setup_callbacks'
C:/Users/claco/rails/activesupport/lib/active_support/testing/setup_and_teardown.rb:34:in `run'
3) Failure:
test: Testing basic saves and unicode limits should save and reload simple nchar string. (UnicodeTestSqlserver) [test/cases/unicode_test_sqlserver.rb:11]:
<"A"> expected but was
<"\x00m">.
4) Failure:
test: Testing unicode data should insert and retrieve unicode data. (UnicodeTestSqlserver) [test/cases/unicode_test_sqlserver.rb:41]:
perhaps you are not using the utf8 odbc that does this legwork.
<"\u4E00\u4E8C34\u4E94\u516D"> expected but was
<"\xE4\xB8\x80\xE4\xBA\x8C34\xE4\xBA\x94\xE5\x85\xAD">.
175 tests, 436 assertions, 3 failures, 1 errors, 0 skips
Test run options: --seed 52528
rake aborted!
Command failed with status (1): [C:/Ruby192/bin/ruby.exe -I"lib;test;test/c...]
C:/Ruby192/lib/ruby/1.9.1/rake.rb:993:in `block in sh'
C:/Ruby192/lib/ruby/1.9.1/rake.rb:1008:in `call'
C:/Ruby192/lib/ruby/1.9.1/rake.rb:1008:in `sh'
C:/Ruby192/lib/ruby/1.9.1/rake.rb:1092:in `sh'
C:/Ruby192/lib/ruby/1.9.1/rake.rb:1027:in `ruby'
C:/Ruby192/lib/ruby/1.9.1/rake.rb:1092:in `ruby'
C:/Ruby192/lib/ruby/1.9.1/rake/testtask.rb:115:in `block (2 levels) in define'
C:/Ruby192/lib/ruby/1.9.1/rake.rb:1110:in `verbose'
C:/Ruby192/lib/ruby/1.9.1/rake/testtask.rb:100:in `block in define'
C:/Ruby192/lib/ruby/1.9.1/rake.rb:634:in `call'
C:/Ruby192/lib/ruby/1.9.1/rake.rb:634:in `block in execute'
C:/Ruby192/lib/ruby/1.9.1/rake.rb:629:in `each'
C:/Ruby192/lib/ruby/1.9.1/rake.rb:629:in `execute'
C:/Ruby192/lib/ruby/1.9.1/rake.rb:595:in `block in invoke_with_call_chain'
C:/Ruby192/lib/ruby/1.9.1/monitor.rb:201:in `mon_synchronize'
C:/Ruby192/lib/ruby/1.9.1/rake.rb:588:in `invoke_with_call_chain'
C:/Ruby192/lib/ruby/1.9.1/rake.rb:581:in `invoke'
C:/Ruby192/lib/ruby/1.9.1/rake.rb:2041:in `invoke_task'
C:/Ruby192/lib/ruby/1.9.1/rake.rb:2019:in `block (2 levels) in top_level'
C:/Ruby192/lib/ruby/1.9.1/rake.rb:2019:in `each'
C:/Ruby192/lib/ruby/1.9.1/rake.rb:2019:in `block in top_level'
C:/Ruby192/lib/ruby/1.9.1/rake.rb:2058:in `standard_exception_handling'
C:/Ruby192/lib/ruby/1.9.1/rake.rb:2013:in `top_level'
C:/Ruby192/lib/ruby/1.9.1/rake.rb:1992:in `run'
C:/Ruby192/bin/rake:31:in `<main>'
-------
D, [2011-01-06T09:38:00.904792 #11768] DEBUG -- : EXECUTE (1.0ms) USE [activerecord_unittest]
EXECUTE (2.0ms) DROP TABLE [accounts]
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) 
EXECUTE (1.0ms) DROP TABLE [admin_accounts]
EXECUTE (1.0ms) CREATE TABLE [admin_accounts] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [name] varchar(255)) 
EXECUTE (1.0ms) DROP TABLE [admin_users]
EXECUTE (2.0ms) CREATE TABLE [admin_users] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [name] varchar(255), [account_id] integer) 
EXECUTE (14.0ms) DROP TABLE [audit_logs]
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) 
EXECUTE (2.0ms) DROP TABLE [authors]
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) 
EXECUTE (4.0ms) DROP TABLE [author_addresses]
EXECUTE (1.0ms) CREATE TABLE [author_addresses] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY) 
EXECUTE (2.0ms) DROP TABLE [author_favorites]
EXECUTE (3.0ms) CREATE TABLE [author_favorites] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [author_id] integer, [favorite_author_id] integer) 
EXECUTE (2.0ms) DROP TABLE [auto_id_tests]
EXECUTE (2.0ms) CREATE TABLE [auto_id_tests] ([auto_id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [value] integer) 
EXECUTE (5.0ms) DROP TABLE [binaries]
EXECUTE (2.0ms) CREATE TABLE [binaries] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [data] varbinary(max)) 
EXECUTE (2.0ms) DROP TABLE [birds]
EXECUTE (2.0ms) CREATE TABLE [birds] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [name] varchar(255), [color] varchar(255), [pirate_id] integer) 
EXECUTE (1.0ms) DROP TABLE [books]
EXECUTE (2.0ms) CREATE TABLE [books] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [name] varchar(255)) 
EXECUTE (4.0ms) DROP TABLE [booleans]
EXECUTE (1.0ms) CREATE TABLE [booleans] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [value] bit) 
EXECUTE (1.0ms) DROP TABLE [CamelCase]
EXECUTE (1.0ms) CREATE TABLE [CamelCase] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [name] varchar(255)) 
EXECUTE (37.0ms) DROP TABLE [cars]
EXECUTE (2.0ms) CREATE TABLE [cars] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [name] varchar(255), [engines_count] integer, [wheels_count] integer) 
EXECUTE (2.0ms) DROP TABLE [categories]
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) 
EXECUTE (2.0ms) DROP TABLE [categories_posts]
EXECUTE (2.0ms) CREATE TABLE [categories_posts] ([category_id] integer NOT NULL, [post_id] integer NOT NULL) 
EXECUTE (2.0ms) DROP TABLE [categorizations]
EXECUTE (2.0ms) CREATE TABLE [categorizations] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [category_id] integer, [post_id] integer, [author_id] integer) 
EXECUTE (1.0ms) DROP TABLE [citations]
EXECUTE (2.0ms) CREATE TABLE [citations] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [book1_id] integer, [book2_id] integer) 
EXECUTE (1.0ms) DROP TABLE [clubs]
EXECUTE (2.0ms) CREATE TABLE [clubs] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [name] varchar(255)) 
EXECUTE (20.0ms) DROP TABLE [collections]
EXECUTE (2.0ms) CREATE TABLE [collections] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [name] varchar(255)) 
EXECUTE (1.0ms) DROP TABLE [colnametests]
EXECUTE (1.0ms) CREATE TABLE [colnametests] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [references] integer NOT NULL) 
EXECUTE (2.0ms) DROP TABLE [comments]
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)) 
EXECUTE (2.0ms) DROP TABLE [companies]
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) 
SQL (15.0ms) EXEC sp_helpindex [companies]
EXECUTE (14.0ms) CREATE INDEX [company_index] ON [companies] ([firm_id], [type], [rating], [ruby_type])
EXECUTE (2.0ms) DROP TABLE [computers]
EXECUTE (4.0ms) CREATE TABLE [computers] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [developer] integer NOT NULL, [extendedWarranty] integer NOT NULL) 
EXECUTE (5.0ms) DROP TABLE [contracts]
EXECUTE (2.0ms) CREATE TABLE [contracts] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [developer_id] integer, [company_id] integer) 
EXECUTE (1.0ms) DROP TABLE [customers]
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)) 
EXECUTE (1.0ms) DROP TABLE [dashboards]
EXECUTE (2.0ms) CREATE TABLE [dashboards] ([dashboard_id] varchar(255), [name] varchar(255)) 
EXECUTE (5.0ms) DROP TABLE [developers]
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) 
EXECUTE (1.0ms) DROP TABLE [developers_projects]
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) 
EXECUTE (76.0ms) DROP TABLE [edges]
EXECUTE (2.0ms) CREATE TABLE [edges] ([source_id] integer NOT NULL, [sink_id] integer NOT NULL) 
SQL (1.0ms) EXEC sp_helpindex [edges]
EXECUTE (1.0ms) CREATE UNIQUE INDEX [unique_edge_index] ON [edges] ([source_id], [sink_id])
EXECUTE (2.0ms) DROP TABLE [engines]
EXECUTE (2.0ms) CREATE TABLE [engines] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [car_id] integer) 
EXECUTE (2.0ms) DROP TABLE [tyres]
EXECUTE (2.0ms) CREATE TABLE [tyres] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [car_id] integer) 
EXECUTE (2.0ms) DROP TABLE [bulbs]
EXECUTE (2.0ms) CREATE TABLE [bulbs] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [car_id] integer, [name] varchar(255)) 
EXECUTE (2.0ms) DROP TABLE [entrants]
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) 
EXECUTE (2.0ms) DROP TABLE [essays]
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)) 
EXECUTE (2.0ms) DROP TABLE [events]
EXECUTE (2.0ms) CREATE TABLE [events] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [title] varchar(5)) 
EXECUTE (1.0ms) DROP TABLE [funny_jokes]
EXECUTE (1.0ms) CREATE TABLE [funny_jokes] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [name] varchar(255)) 
EXECUTE (19.0ms) DROP TABLE [goofy_string_id]
EXECUTE (2.0ms) CREATE TABLE [goofy_string_id] ([id] varchar(255) NOT NULL, [info] varchar(255)) 
EXECUTE (1.0ms) DROP TABLE [invoices]
EXECUTE (2.0ms) CREATE TABLE [invoices] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [balance] integer, [updated_at] datetime) 
EXECUTE (2.0ms) DROP TABLE [items]
EXECUTE (1.0ms) CREATE TABLE [items] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [name] varchar(255)) 
EXECUTE (2.0ms) DROP TABLE [inept_wizards]
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)) 
EXECUTE (50.0ms) DROP TABLE [jobs]
EXECUTE (3.0ms) CREATE TABLE [jobs] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [ideal_reference_id] integer) 
EXECUTE (3.0ms) DROP TABLE [keyboards]
EXECUTE (2.0ms) CREATE TABLE [keyboards] ([key_number] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [name] varchar(255)) 
EXECUTE (3.0ms) DROP TABLE [legacy_things]
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) 
EXECUTE (2.0ms) DROP TABLE [line_items]
EXECUTE (2.0ms) CREATE TABLE [line_items] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [invoice_id] integer, [amount] integer) 
EXECUTE (1.0ms) DROP TABLE [lock_without_defaults]
EXECUTE (75.0ms) CREATE TABLE [lock_without_defaults] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [lock_version] integer) 
EXECUTE (2.0ms) DROP TABLE [lock_without_defaults_cust]
EXECUTE (2.0ms) CREATE TABLE [lock_without_defaults_cust] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [custom_lock_version] integer) 
EXECUTE (2.0ms) DROP TABLE [mateys]
EXECUTE (1.0ms) CREATE TABLE [mateys] ([pirate_id] integer, [target_id] integer, [weight] integer) 
EXECUTE (1.0ms) DROP TABLE [members]
EXECUTE (2.0ms) CREATE TABLE [members] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [name] varchar(255), [member_type_id] integer) 
EXECUTE (2.0ms) DROP TABLE [member_details]
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)) 
EXECUTE (2.0ms) DROP TABLE [memberships]
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)) 
EXECUTE (1.0ms) DROP TABLE [member_types]
EXECUTE (1.0ms) CREATE TABLE [member_types] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [name] varchar(255)) 
EXECUTE (1.0ms) DROP TABLE [references]
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) 
EXECUTE (1.0ms) DROP TABLE [minivans]
EXECUTE (1.0ms) CREATE TABLE [minivans] ([minivan_id] varchar(255), [name] varchar(255), [speedometer_id] varchar(255), [color] varchar(255)) 
EXECUTE (2.0ms) DROP TABLE [minimalistics]
EXECUTE (2.0ms) CREATE TABLE [minimalistics] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY) 
EXECUTE (1.0ms) DROP TABLE [mixed_case_monkeys]
EXECUTE (1.0ms) CREATE TABLE [mixed_case_monkeys] ([monkeyID] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [fleaCount] integer) 
EXECUTE (1.0ms) DROP TABLE [mixins]
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)) 
EXECUTE (2.0ms) DROP TABLE [movies]
EXECUTE (1.0ms) CREATE TABLE [movies] ([movieid] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [name] varchar(255)) 
EXECUTE (2.0ms) DROP TABLE [numeric_data]
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)) 
EXECUTE (2.0ms) DROP TABLE [orders]
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) 
EXECUTE (4.0ms) DROP TABLE [organizations]
EXECUTE (5.0ms) CREATE TABLE [organizations] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [name] varchar(255)) 
EXECUTE (3.0ms) DROP TABLE [owners]
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) 
EXECUTE (1.0ms) DROP TABLE [paint_colors]
EXECUTE (2.0ms) CREATE TABLE [paint_colors] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [non_poly_one_id] integer) 
EXECUTE (1.0ms) DROP TABLE [paint_textures]
EXECUTE (2.0ms) CREATE TABLE [paint_textures] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [non_poly_two_id] integer) 
EXECUTE (2.0ms) DROP TABLE [parrots]
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) 
EXECUTE (2.0ms) DROP TABLE [parrots_pirates]
EXECUTE (37.0ms) CREATE TABLE [parrots_pirates] ([parrot_id] integer, [pirate_id] integer) 
EXECUTE (2.0ms) DROP TABLE [parrots_treasures]
EXECUTE (2.0ms) CREATE TABLE [parrots_treasures] ([parrot_id] integer, [treasure_id] integer) 
EXECUTE (1.0ms) DROP TABLE [people]
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) 
EXECUTE (1.0ms) DROP TABLE [pets]
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) 
EXECUTE (2.0ms) DROP TABLE [pirates]
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) 
EXECUTE (1.0ms) DROP TABLE [posts]
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) 
EXECUTE (1.0ms) DROP TABLE [price_estimates]
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) 
EXECUTE (1.0ms) DROP TABLE [products]
EXECUTE (2.0ms) CREATE TABLE [products] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [collection_id] integer, [name] varchar(255)) 
EXECUTE (1.0ms) DROP TABLE [projects]
EXECUTE (2.0ms) CREATE TABLE [projects] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [name] varchar(255), [type] varchar(255)) 
EXECUTE (2.0ms) DROP TABLE [readers]
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) 
EXECUTE (4.0ms) DROP TABLE [shape_expressions]
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) 
EXECUTE (2.0ms) DROP TABLE [ships]
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) 
EXECUTE (2.0ms) DROP TABLE [ship_parts]
EXECUTE (2.0ms) CREATE TABLE [ship_parts] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [name] varchar(255), [ship_id] integer) 
EXECUTE (4.0ms) DROP TABLE [speedometers]
EXECUTE (1.0ms) CREATE TABLE [speedometers] ([speedometer_id] varchar(255), [name] varchar(255), [dashboard_id] varchar(255)) 
EXECUTE (2.0ms) DROP TABLE [sponsors]
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)) 
EXECUTE (1.0ms) DROP TABLE [subscribers]
EXECUTE (2.0ms) CREATE TABLE [subscribers] ([nick] varchar(255) NOT NULL, [name] varchar(255)) 
SQL (0.0ms) EXEC sp_helpindex [subscribers]
EXECUTE (1.0ms) CREATE UNIQUE INDEX [index_subscribers_on_nick] ON [subscribers] ([nick])
EXECUTE (2.0ms) DROP TABLE [subscriptions]
EXECUTE (1.0ms) CREATE TABLE [subscriptions] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [subscriber_id] varchar(255), [book_id] integer) 
EXECUTE (6.0ms) DROP TABLE [tasks]
EXECUTE (2.0ms) CREATE TABLE [tasks] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [starting] datetime, [ending] datetime) 
EXECUTE (76.0ms) DROP TABLE [topics]
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)) 
EXECUTE (2.0ms) DROP TABLE [taggings]
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) 
EXECUTE (2.0ms) DROP TABLE [tags]
EXECUTE (2.0ms) CREATE TABLE [tags] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [name] varchar(255), [taggings_count] integer DEFAULT 0) 
EXECUTE (2.0ms) DROP TABLE [toys]
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) 
EXECUTE (1.0ms) DROP TABLE [traffic_lights]
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) 
EXECUTE (2.0ms) DROP TABLE [treasures]
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)) 
EXECUTE (2.0ms) DROP TABLE [variants]
EXECUTE (2.0ms) CREATE TABLE [variants] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [product_id] integer, [name] varchar(255)) 
EXECUTE (2.0ms) DROP TABLE [vertices]
EXECUTE (1.0ms) CREATE TABLE [vertices] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [label] varchar(255)) 
EXECUTE (5.0ms) DROP TABLE [warehouse-things]
EXECUTE (3.0ms) CREATE TABLE [warehouse-things] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [value] integer) 
EXECUTE (1.0ms) DROP TABLE [circles]
EXECUTE (16.0ms) CREATE TABLE [circles] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY) 
EXECUTE (3.0ms) DROP TABLE [squares]
EXECUTE (3.0ms) CREATE TABLE [squares] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY) 
EXECUTE (2.0ms) DROP TABLE [triangles]
EXECUTE (2.0ms) CREATE TABLE [triangles] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY) 
EXECUTE (2.0ms) DROP TABLE [non_poly_ones]
EXECUTE (3.0ms) CREATE TABLE [non_poly_ones] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY) 
EXECUTE (3.0ms) DROP TABLE [non_poly_twos]
EXECUTE (3.0ms) CREATE TABLE [non_poly_twos] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY) 
EXECUTE (2.0ms) DROP TABLE [guids]
EXECUTE (2.0ms) CREATE TABLE [guids] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [key] varchar(255)) 
EXECUTE (42.0ms) DROP TABLE [integer_limits]
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) 
EXECUTE (2.0ms) DROP TABLE [men]
EXECUTE (2.0ms) CREATE TABLE [men] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [name] varchar(255)) 
EXECUTE (3.0ms) DROP TABLE [faces]
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)) 
EXECUTE (2.0ms) DROP TABLE [interests]
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) 
EXECUTE (2.0ms) DROP TABLE [wheels]
EXECUTE (2.0ms) CREATE TABLE [wheels] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [wheelable_id] integer, [wheelable_type] varchar(255)) 
EXECUTE (2.0ms) DROP TABLE [zines]
EXECUTE (2.0ms) CREATE TABLE [zines] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [title] varchar(255)) 
EXECUTE (2.0ms) DROP TABLE [countries]
EXECUTE (2.0ms) CREATE TABLE [countries] ([country_id] varchar(255), [name] varchar(255)) 
EXECUTE (1.0ms) DROP TABLE [treaties]
EXECUTE (2.0ms) CREATE TABLE [treaties] ([treaty_id] varchar(255), [name] varchar(255)) 
EXECUTE (3.0ms) DROP TABLE [countries_treaties]
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) 
EXECUTE (1.0ms) DROP TABLE [liquid]
EXECUTE (1.0ms) CREATE TABLE [liquid] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [name] varchar(255)) 
EXECUTE (1.0ms) DROP TABLE [molecules]
EXECUTE (2.0ms) CREATE TABLE [molecules] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [liquid_id] integer, [name] varchar(255)) 
EXECUTE (1.0ms) DROP TABLE [electrons]
EXECUTE (2.0ms) CREATE TABLE [electrons] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [molecule_id] integer, [name] varchar(255)) 
EXECUTE (78.0ms) DROP TABLE [fk_test_has_fk]
EXECUTE (6.0ms) CREATE TABLE [fk_test_has_fk] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [fk_id] integer NOT NULL) 
EXECUTE (2.0ms) DROP TABLE [fk_test_has_pk]
EXECUTE (3.0ms) CREATE TABLE [fk_test_has_pk] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY) 
EXECUTE (3.0ms) ALTER TABLE fk_test_has_fk ADD CONSTRAINT fk_name FOREIGN KEY ([fk_id]) REFERENCES [fk_test_has_pk] ([id])
EXECUTE (1.0ms) USE [activerecord_unittest2]
EXECUTE (11.0ms) DROP TABLE [courses]
EXECUTE (2.0ms) CREATE TABLE [courses] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [name] varchar(255) NOT NULL) 
EXECUTE (7.0ms) DROP TABLE [accounts]
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) 
EXECUTE (1.0ms) DROP TABLE [admin_accounts]
EXECUTE (1.0ms) CREATE TABLE [admin_accounts] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [name] varchar(255)) 
EXECUTE (1.0ms) DROP TABLE [admin_users]
EXECUTE (1.0ms) CREATE TABLE [admin_users] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [name] varchar(255), [account_id] integer) 
EXECUTE (1.0ms) DROP TABLE [audit_logs]
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) 
EXECUTE (6.0ms) DROP TABLE [authors]
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) 
EXECUTE (1.0ms) DROP TABLE [author_addresses]
EXECUTE (3.0ms) CREATE TABLE [author_addresses] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY) 
EXECUTE (2.0ms) DROP TABLE [author_favorites]
EXECUTE (2.0ms) CREATE TABLE [author_favorites] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [author_id] integer, [favorite_author_id] integer) 
EXECUTE (2.0ms) DROP TABLE [auto_id_tests]
EXECUTE (3.0ms) CREATE TABLE [auto_id_tests] ([auto_id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [value] integer) 
EXECUTE (2.0ms) DROP TABLE [binaries]
EXECUTE (2.0ms) CREATE TABLE [binaries] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [data] varbinary(max)) 
EXECUTE (1.0ms) DROP TABLE [birds]
EXECUTE (5.0ms) CREATE TABLE [birds] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [name] varchar(255), [color] varchar(255), [pirate_id] integer) 
EXECUTE (3.0ms) DROP TABLE [books]
EXECUTE (2.0ms) CREATE TABLE [books] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [name] varchar(255)) 
EXECUTE (2.0ms) DROP TABLE [booleans]
EXECUTE (1.0ms) CREATE TABLE [booleans] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [value] bit) 
EXECUTE (2.0ms) DROP TABLE [CamelCase]
EXECUTE (2.0ms) CREATE TABLE [CamelCase] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [name] varchar(255)) 
EXECUTE (63.0ms) DROP TABLE [cars]
EXECUTE (2.0ms) CREATE TABLE [cars] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [name] varchar(255), [engines_count] integer, [wheels_count] integer) 
EXECUTE (2.0ms) DROP TABLE [categories]
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) 
EXECUTE (2.0ms) DROP TABLE [categories_posts]
EXECUTE (2.0ms) CREATE TABLE [categories_posts] ([category_id] integer NOT NULL, [post_id] integer NOT NULL) 
EXECUTE (2.0ms) DROP TABLE [categorizations]
EXECUTE (3.0ms) CREATE TABLE [categorizations] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [category_id] integer, [post_id] integer, [author_id] integer) 
EXECUTE (2.0ms) DROP TABLE [citations]
EXECUTE (2.0ms) CREATE TABLE [citations] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [book1_id] integer, [book2_id] integer) 
EXECUTE (2.0ms) DROP TABLE [clubs]
EXECUTE (2.0ms) CREATE TABLE [clubs] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [name] varchar(255)) 
EXECUTE (1.0ms) DROP TABLE [collections]
EXECUTE (2.0ms) CREATE TABLE [collections] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [name] varchar(255)) 
EXECUTE (2.0ms) DROP TABLE [colnametests]
EXECUTE (1.0ms) CREATE TABLE [colnametests] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [references] integer NOT NULL) 
EXECUTE (1.0ms) DROP TABLE [comments]
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)) 
EXECUTE (2.0ms) DROP TABLE [companies]
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) 
SQL (12.0ms) EXEC sp_helpindex [companies]
EXECUTE (1.0ms) CREATE INDEX [company_index] ON [companies] ([firm_id], [type], [rating], [ruby_type])
EXECUTE (1.0ms) DROP TABLE [computers]
EXECUTE (1.0ms) CREATE TABLE [computers] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [developer] integer NOT NULL, [extendedWarranty] integer NOT NULL) 
EXECUTE (4.0ms) DROP TABLE [contracts]
EXECUTE (3.0ms) CREATE TABLE [contracts] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [developer_id] integer, [company_id] integer) 
EXECUTE (2.0ms) DROP TABLE [customers]
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)) 
EXECUTE (1.0ms) DROP TABLE [dashboards]
EXECUTE (5.0ms) CREATE TABLE [dashboards] ([dashboard_id] varchar(255), [name] varchar(255)) 
EXECUTE (1.0ms) DROP TABLE [developers]
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) 
EXECUTE (1.0ms) DROP TABLE [developers_projects]
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) 
EXECUTE (3.0ms) DROP TABLE [edges]
EXECUTE (1.0ms) CREATE TABLE [edges] ([source_id] integer NOT NULL, [sink_id] integer NOT NULL) 
SQL (1.0ms) EXEC sp_helpindex [edges]
EXECUTE (1.0ms) CREATE UNIQUE INDEX [unique_edge_index] ON [edges] ([source_id], [sink_id])
EXECUTE (4.0ms) DROP TABLE [engines]
EXECUTE (1.0ms) CREATE TABLE [engines] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [car_id] integer) 
EXECUTE (1.0ms) DROP TABLE [tyres]
EXECUTE (1.0ms) CREATE TABLE [tyres] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [car_id] integer) 
EXECUTE (1.0ms) DROP TABLE [bulbs]
EXECUTE (1.0ms) CREATE TABLE [bulbs] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [car_id] integer, [name] varchar(255)) 
EXECUTE (7.0ms) DROP TABLE [entrants]
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) 
EXECUTE (7.0ms) DROP TABLE [essays]
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)) 
EXECUTE (1.0ms) DROP TABLE [events]
EXECUTE (2.0ms) CREATE TABLE [events] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [title] varchar(5)) 
EXECUTE (2.0ms) DROP TABLE [funny_jokes]
EXECUTE (1.0ms) CREATE TABLE [funny_jokes] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [name] varchar(255)) 
EXECUTE (1.0ms) DROP TABLE [goofy_string_id]
EXECUTE (1.0ms) CREATE TABLE [goofy_string_id] ([id] varchar(255) NOT NULL, [info] varchar(255)) 
EXECUTE (1.0ms) DROP TABLE [invoices]
EXECUTE (2.0ms) CREATE TABLE [invoices] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [balance] integer, [updated_at] datetime) 
EXECUTE (2.0ms) DROP TABLE [items]
EXECUTE (1.0ms) CREATE TABLE [items] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [name] varchar(255)) 
EXECUTE (1.0ms) DROP TABLE [inept_wizards]
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)) 
EXECUTE (1.0ms) DROP TABLE [jobs]
EXECUTE (1.0ms) CREATE TABLE [jobs] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [ideal_reference_id] integer) 
EXECUTE (2.0ms) DROP TABLE [keyboards]
EXECUTE (1.0ms) CREATE TABLE [keyboards] ([key_number] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [name] varchar(255)) 
EXECUTE (1.0ms) DROP TABLE [legacy_things]
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) 
EXECUTE (4.0ms) DROP TABLE [line_items]
EXECUTE (3.0ms) CREATE TABLE [line_items] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [invoice_id] integer, [amount] integer) 
EXECUTE (2.0ms) DROP TABLE [lock_without_defaults]
EXECUTE (3.0ms) CREATE TABLE [lock_without_defaults] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [lock_version] integer) 
EXECUTE (1.0ms) DROP TABLE [lock_without_defaults_cust]
EXECUTE (2.0ms) CREATE TABLE [lock_without_defaults_cust] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [custom_lock_version] integer) 
EXECUTE (2.0ms) DROP TABLE [mateys]
EXECUTE (1.0ms) CREATE TABLE [mateys] ([pirate_id] integer, [target_id] integer, [weight] integer) 
EXECUTE (1.0ms) DROP TABLE [members]
EXECUTE (2.0ms) CREATE TABLE [members] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [name] varchar(255), [member_type_id] integer) 
EXECUTE (1.0ms) DROP TABLE [member_details]
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)) 
EXECUTE (1.0ms) DROP TABLE [memberships]
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)) 
EXECUTE (2.0ms) DROP TABLE [member_types]
EXECUTE (3.0ms) CREATE TABLE [member_types] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [name] varchar(255)) 
EXECUTE (3.0ms) DROP TABLE [references]
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) 
EXECUTE (2.0ms) DROP TABLE [minivans]
EXECUTE (2.0ms) CREATE TABLE [minivans] ([minivan_id] varchar(255), [name] varchar(255), [speedometer_id] varchar(255), [color] varchar(255)) 
EXECUTE (1.0ms) DROP TABLE [minimalistics]
EXECUTE (2.0ms) CREATE TABLE [minimalistics] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY) 
EXECUTE (2.0ms) DROP TABLE [mixed_case_monkeys]
EXECUTE (1.0ms) CREATE TABLE [mixed_case_monkeys] ([monkeyID] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [fleaCount] integer) 
EXECUTE (2.0ms) DROP TABLE [mixins]
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)) 
EXECUTE (2.0ms) DROP TABLE [movies]
EXECUTE (1.0ms) CREATE TABLE [movies] ([movieid] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [name] varchar(255)) 
EXECUTE (1.0ms) DROP TABLE [numeric_data]
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)) 
EXECUTE (3.0ms) DROP TABLE [orders]
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) 
EXECUTE (3.0ms) DROP TABLE [organizations]
EXECUTE (1.0ms) CREATE TABLE [organizations] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [name] varchar(255)) 
EXECUTE (2.0ms) DROP TABLE [owners]
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) 
EXECUTE (1.0ms) DROP TABLE [paint_colors]
EXECUTE (2.0ms) CREATE TABLE [paint_colors] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [non_poly_one_id] integer) 
EXECUTE (2.0ms) DROP TABLE [paint_textures]
EXECUTE (1.0ms) CREATE TABLE [paint_textures] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [non_poly_two_id] integer) 
EXECUTE (1.0ms) DROP TABLE [parrots]
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) 
EXECUTE (2.0ms) DROP TABLE [parrots_pirates]
EXECUTE (1.0ms) CREATE TABLE [parrots_pirates] ([parrot_id] integer, [pirate_id] integer) 
EXECUTE (31.0ms) DROP TABLE [parrots_treasures]
EXECUTE (2.0ms) CREATE TABLE [parrots_treasures] ([parrot_id] integer, [treasure_id] integer) 
EXECUTE (2.0ms) DROP TABLE [people]
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) 
EXECUTE (2.0ms) DROP TABLE [pets]
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) 
EXECUTE (2.0ms) DROP TABLE [pirates]
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) 
EXECUTE (2.0ms) DROP TABLE [posts]
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) 
EXECUTE (1.0ms) DROP TABLE [price_estimates]
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) 
EXECUTE (1.0ms) DROP TABLE [products]
EXECUTE (1.0ms) CREATE TABLE [products] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [collection_id] integer, [name] varchar(255)) 
EXECUTE (1.0ms) DROP TABLE [projects]
EXECUTE (2.0ms) CREATE TABLE [projects] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [name] varchar(255), [type] varchar(255)) 
EXECUTE (2.0ms) DROP TABLE [readers]
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) 
EXECUTE (1.0ms) DROP TABLE [shape_expressions]
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) 
EXECUTE (2.0ms) DROP TABLE [ships]
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) 
EXECUTE (2.0ms) DROP TABLE [ship_parts]
EXECUTE (4.0ms) CREATE TABLE [ship_parts] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [name] varchar(255), [ship_id] integer) 
EXECUTE (4.0ms) DROP TABLE [speedometers]
EXECUTE (2.0ms) CREATE TABLE [speedometers] ([speedometer_id] varchar(255), [name] varchar(255), [dashboard_id] varchar(255)) 
EXECUTE (3.0ms) DROP TABLE [sponsors]
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)) 
EXECUTE (1.0ms) DROP TABLE [subscribers]
EXECUTE (1.0ms) CREATE TABLE [subscribers] ([nick] varchar(255) NOT NULL, [name] varchar(255)) 
SQL (1.0ms) EXEC sp_helpindex [subscribers]
EXECUTE (1.0ms) CREATE UNIQUE INDEX [index_subscribers_on_nick] ON [subscribers] ([nick])
EXECUTE (3.0ms) DROP TABLE [subscriptions]
EXECUTE (2.0ms) CREATE TABLE [subscriptions] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [subscriber_id] varchar(255), [book_id] integer) 
EXECUTE (2.0ms) DROP TABLE [tasks]
EXECUTE (2.0ms) CREATE TABLE [tasks] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [starting] datetime, [ending] datetime) 
EXECUTE (2.0ms) DROP TABLE [topics]
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)) 
EXECUTE (10.0ms) DROP TABLE [taggings]
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) 
EXECUTE (2.0ms) DROP TABLE [tags]
EXECUTE (2.0ms) CREATE TABLE [tags] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [name] varchar(255), [taggings_count] integer DEFAULT 0) 
EXECUTE (1.0ms) DROP TABLE [toys]
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) 
EXECUTE (2.0ms) DROP TABLE [traffic_lights]
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) 
EXECUTE (2.0ms) DROP TABLE [treasures]
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)) 
EXECUTE (1.0ms) DROP TABLE [variants]
EXECUTE (2.0ms) CREATE TABLE [variants] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [product_id] integer, [name] varchar(255)) 
EXECUTE (1.0ms) DROP TABLE [vertices]
EXECUTE (1.0ms) CREATE TABLE [vertices] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [label] varchar(255)) 
EXECUTE (1.0ms) DROP TABLE [warehouse-things]
EXECUTE (1.0ms) CREATE TABLE [warehouse-things] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [value] integer) 
EXECUTE (1.0ms) DROP TABLE [circles]
EXECUTE (1.0ms) CREATE TABLE [circles] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY) 
EXECUTE (1.0ms) DROP TABLE [squares]
EXECUTE (1.0ms) CREATE TABLE [squares] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY) 
EXECUTE (1.0ms) DROP TABLE [triangles]
EXECUTE (2.0ms) CREATE TABLE [triangles] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY) 
EXECUTE (1.0ms) DROP TABLE [non_poly_ones]
EXECUTE (4.0ms) CREATE TABLE [non_poly_ones] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY) 
EXECUTE (4.0ms) DROP TABLE [non_poly_twos]
EXECUTE (1.0ms) CREATE TABLE [non_poly_twos] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY) 
EXECUTE (5.0ms) DROP TABLE [guids]
EXECUTE (2.0ms) CREATE TABLE [guids] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [key] varchar(255)) 
EXECUTE (2.0ms) DROP TABLE [integer_limits]
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) 
EXECUTE (1.0ms) DROP TABLE [men]
EXECUTE (2.0ms) CREATE TABLE [men] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [name] varchar(255)) 
EXECUTE (2.0ms) DROP TABLE [faces]
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)) 
EXECUTE (1.0ms) DROP TABLE [interests]
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) 
EXECUTE (1.0ms) DROP TABLE [wheels]
EXECUTE (25.0ms) CREATE TABLE [wheels] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [wheelable_id] integer, [wheelable_type] varchar(255)) 
EXECUTE (2.0ms) DROP TABLE [zines]
EXECUTE (1.0ms) CREATE TABLE [zines] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [title] varchar(255)) 
EXECUTE (1.0ms) DROP TABLE [countries]
EXECUTE (1.0ms) CREATE TABLE [countries] ([country_id] varchar(255), [name] varchar(255)) 
EXECUTE (1.0ms) DROP TABLE [treaties]
EXECUTE (1.0ms) CREATE TABLE [treaties] ([treaty_id] varchar(255), [name] varchar(255)) 
EXECUTE (1.0ms) DROP TABLE [countries_treaties]
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) 
EXECUTE (2.0ms) DROP TABLE [liquid]
EXECUTE (1.0ms) CREATE TABLE [liquid] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [name] varchar(255)) 
EXECUTE (1.0ms) DROP TABLE [molecules]
EXECUTE (2.0ms) CREATE TABLE [molecules] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [liquid_id] integer, [name] varchar(255)) 
EXECUTE (1.0ms) DROP TABLE [electrons]
EXECUTE (1.0ms) CREATE TABLE [electrons] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [molecule_id] integer, [name] varchar(255)) 
EXECUTE (1.0ms) DROP TABLE [fk_test_has_fk]
EXECUTE (2.0ms) CREATE TABLE [fk_test_has_fk] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [fk_id] integer NOT NULL) 
EXECUTE (2.0ms) DROP TABLE [fk_test_has_pk]
EXECUTE (1.0ms) CREATE TABLE [fk_test_has_pk] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY) 
EXECUTE (1.0ms) ALTER TABLE fk_test_has_fk ADD CONSTRAINT fk_name FOREIGN KEY ([fk_id]) REFERENCES [fk_test_has_pk] ([id])
EXECUTE (2.0ms) DROP TABLE [courses]
EXECUTE (3.0ms) CREATE TABLE [courses] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [name] varchar(255) NOT NULL)
EXECUTE (2.0ms) DROP TABLE [table_with_real_columns]
EXECUTE (1.0ms) CREATE TABLE [table_with_real_columns] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [real_number] real)
EXECUTE (2.0ms) DROP TABLE [defaults]
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)
EXECUTE (3.0ms) DROP TABLE [string_defaults]
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
new line.')
EXECUTE (2.0ms) DROP TABLE [sql_server_chronics]
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)
EXECUTE (4.0ms) DROP TABLE [fk_test_has_fks]
EXECUTE (3.0ms) CREATE TABLE [fk_test_has_fks] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [fk_id] integer NOT NULL)
EXECUTE (2.0ms) DROP TABLE [fk_test_has_pks]
EXECUTE (1.0ms) CREATE TABLE [fk_test_has_pks] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY)
EXECUTE (1.0ms)  ALTER TABLE fk_test_has_fks
ADD CONSTRAINT FK__fk_test_has_fk_fk_id
FOREIGN KEY ([fk_id])
REFERENCES [fk_test_has_pks] ([id])

EXECUTE (1.0ms) DROP TABLE [sql_server_unicodes]
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)) 
EXECUTE (2.0ms) DROP TABLE [sql_server_strings]
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)) 
EXECUTE (58.0ms) DROP TABLE [sql_server_binary_types]
EXECUTE (3.0ms) CREATE TABLE [sql_server_binary_types] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY) 
EXECUTE (2.0ms) DROP TABLE [sql_server_edge_schemas]
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) 
EXECUTE (2.0ms) ALTER TABLE [sql_server_edge_schemas] ADD [guid_newid] uniqueidentifier DEFAULT NEWID();
EXECUTE (2.0ms) ALTER TABLE [sql_server_edge_schemas] ADD [guid_newseqid] uniqueidentifier DEFAULT NEWSEQUENTIALID();
EXECUTE (2.0ms) DROP TABLE [quoted-table]
EXECUTE (2.0ms) CREATE TABLE [quoted-table] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY) 
EXECUTE (22.0ms) IF EXISTS (SELECT TABLE_NAME FROM INFORMATION_SCHEMA.VIEWS WHERE TABLE_NAME = 'quoted-view1') DROP VIEW [quoted-view1]
EXECUTE (2.0ms) CREATE VIEW [quoted-view1] AS SELECT * FROM [quoted-table]
EXECUTE (8.0ms) IF EXISTS (SELECT TABLE_NAME FROM INFORMATION_SCHEMA.VIEWS WHERE TABLE_NAME = 'quoted-view2') DROP VIEW [quoted-view2]
EXECUTE (9.0ms) CREATE VIEW [quoted-view2] AS
/*xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx}*/
SELECT * FROM [quoted-table]
EXECUTE (6.0ms) IF EXISTS (SELECT TABLE_NAME FROM INFORMATION_SCHEMA.VIEWS WHERE TABLE_NAME = 'customers_view') DROP VIEW customers_view
EXECUTE (1.0ms)  CREATE VIEW customers_view AS
SELECT id, name, balance
FROM customers

EXECUTE (5.0ms) IF EXISTS (SELECT TABLE_NAME FROM INFORMATION_SCHEMA.VIEWS WHERE TABLE_NAME = 'string_defaults_view') DROP VIEW string_defaults_view
EXECUTE (2.0ms)  CREATE VIEW string_defaults_view AS
SELECT id, string_with_pretend_null_one as pretend_null
FROM string_defaults

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
EXECUTE (9.0ms)  CREATE VIEW string_defaults_big_view AS
SELECT id, string_with_pretend_null_one as pretend_null
/*xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx}*/
FROM string_defaults

EXECUTE (0.0ms) BEGIN TRANSACTION
EXECUTE (0.0ms) ROLLBACK TRANSACTION
EXECUTE (0.0ms) BEGIN TRANSACTION
EXECUTE (0.0ms) ROLLBACK TRANSACTION
EXECUTE (0.0ms) BEGIN TRANSACTION
EXECUTE (0.0ms) ROLLBACK TRANSACTION
EXECUTE (1.0ms) BEGIN TRANSACTION
Task Load (3.0ms) SELECT TOP (1) [tasks].* FROM [tasks] WHERE ([tasks].[id] = 1)
Task Load (1.0ms) SELECT TOP (1) [tasks].* FROM [tasks] WHERE ([tasks].[id] = 2)
EXECUTE (1.0ms) SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED
EXECUTE (0.0ms) SET TRANSACTION ISOLATION LEVEL READ COMMITTED
EXECUTE (1.0ms) ROLLBACK TRANSACTION
EXECUTE (1.0ms) BEGIN TRANSACTION
Task Load (0.0ms) SELECT TOP (1) [tasks].* FROM [tasks] WHERE ([tasks].[id] = 1)
Task Load (0.0ms) SELECT TOP (1) [tasks].* FROM [tasks] WHERE ([tasks].[id] = 2)
EXECUTE (0.0ms) SAVE TRANSACTION active_record_1
EXECUTE (2.0ms) UPDATE [tasks] SET [starting] = '2011-01-06 09:38:06.671' WHERE ([tasks].[id] = 2)
SQL (0.0ms) SELECT @@ROWCOUNT AS AffectedRows
EXECUTE (1.0ms) SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED
Task Load (1.0ms) SELECT TOP (1) [tasks].* FROM [tasks] WHERE ([tasks].[id] = 2)
EXECUTE (0.0ms) SET TRANSACTION ISOLATION LEVEL read committed
EXECUTE (0.0ms) ROLLBACK TRANSACTION active_record_1
Task Load (0.0ms) SELECT TOP (1) [tasks].* FROM [tasks] WHERE ([tasks].[id] = 2)
EXECUTE (0.0ms) ROLLBACK TRANSACTION
EXECUTE (1.0ms) BEGIN TRANSACTION
Task Load (0.0ms) SELECT TOP (1) [tasks].* FROM [tasks] WHERE ([tasks].[id] = 1)
Task Load (0.0ms) SELECT TOP (1) [tasks].* FROM [tasks] WHERE ([tasks].[id] = 2)
Task Load (1.0ms) SELECT [tasks].* FROM [tasks]
EXECUTE (0.0ms) SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED
Task Load (0.0ms) SELECT [tasks].* FROM [tasks]
EXECUTE (0.0ms) SET TRANSACTION ISOLATION LEVEL read committed
EXECUTE (1.0ms) ROLLBACK TRANSACTION
EXECUTE (1.0ms) BEGIN TRANSACTION
EXECUTE (0.0ms) ROLLBACK TRANSACTION
EXECUTE (0.0ms) BEGIN TRANSACTION
EXECUTE (0.0ms) ROLLBACK TRANSACTION
EXECUTE (0.0ms) BEGIN TRANSACTION
EXECUTE (1.0ms) ROLLBACK TRANSACTION
EXECUTE (0.0ms) BEGIN TRANSACTION
EXECUTE (0.0ms) ROLLBACK TRANSACTION
EXECUTE (0.0ms) BEGIN TRANSACTION
EXECUTE (0.0ms) ROLLBACK TRANSACTION
EXECUTE (0.0ms) BEGIN TRANSACTION
EXECUTE (0.0ms) ROLLBACK TRANSACTION
EXECUTE (0.0ms) BEGIN TRANSACTION
EXECUTE (0.0ms) ROLLBACK TRANSACTION
EXECUTE (0.0ms) BEGIN TRANSACTION
EXECUTE (0.0ms) ROLLBACK TRANSACTION
EXECUTE (1.0ms) BEGIN TRANSACTION
EXECUTE (0.0ms) ROLLBACK TRANSACTION
EXECUTE (0.0ms) BEGIN TRANSACTION
EXECUTE (0.0ms) ROLLBACK TRANSACTION
EXECUTE (0.0ms) BEGIN TRANSACTION
EXECUTE (0.0ms) ROLLBACK TRANSACTION
EXECUTE (0.0ms) BEGIN TRANSACTION
EXECUTE (1.0ms) ROLLBACK TRANSACTION
EXECUTE (0.0ms) BEGIN TRANSACTION
EXECUTE (1.0ms) ROLLBACK TRANSACTION
EXECUTE (0.0ms) BEGIN TRANSACTION
EXECUTE (1.0ms) ROLLBACK TRANSACTION
EXECUTE (0.0ms) BEGIN TRANSACTION
EXECUTE (0.0ms) ROLLBACK TRANSACTION
EXECUTE (0.0ms) BEGIN TRANSACTION
EXECUTE (0.0ms) ROLLBACK TRANSACTION
EXECUTE (0.0ms) BEGIN TRANSACTION
EXECUTE (0.0ms) ROLLBACK TRANSACTION
EXECUTE (0.0ms) BEGIN TRANSACTION
EXECUTE (0.0ms) ROLLBACK TRANSACTION
EXECUTE (0.0ms) BEGIN TRANSACTION
EXECUTE (0.0ms) ROLLBACK TRANSACTION
EXECUTE (0.0ms) BEGIN TRANSACTION
EXECUTE (0.0ms) ROLLBACK TRANSACTION
EXECUTE (0.0ms) BEGIN TRANSACTION
EXECUTE (0.0ms) ROLLBACK TRANSACTION
EXECUTE (0.0ms) BEGIN TRANSACTION
EXECUTE (0.0ms) ROLLBACK TRANSACTION
EXECUTE (1.0ms) BEGIN TRANSACTION
EXECUTE (0.0ms) ROLLBACK TRANSACTION
EXECUTE (0.0ms) BEGIN TRANSACTION
EXECUTE (0.0ms) ROLLBACK TRANSACTION
EXECUTE (0.0ms) BEGIN TRANSACTION
EXECUTE (0.0ms) UPDATE XXX
ODBC::Error: 37000 (102) [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near 'XXX'.: UPDATE XXX
EXECUTE (1.0ms) ROLLBACK TRANSACTION
EXECUTE (0.0ms) BEGIN TRANSACTION
EXECUTE (0.0ms) ROLLBACK TRANSACTION
EXECUTE (0.0ms) BEGIN TRANSACTION
EXECUTE (1.0ms) ROLLBACK TRANSACTION
EXECUTE (0.0ms) BEGIN TRANSACTION
EXECUTE (0.0ms) ROLLBACK TRANSACTION
EXECUTE (0.0ms) BEGIN TRANSACTION
EXECUTE (1.0ms) ROLLBACK TRANSACTION
EXECUTE (0.0ms) BEGIN TRANSACTION
EXECUTE (0.0ms) ROLLBACK TRANSACTION
EXECUTE (0.0ms) BEGIN TRANSACTION
EXECUTE (1.0ms) INSERT INTO [sql_server_chronics] ([datetime]) VALUES('2012-11-08 10:24:36.003')
EXECUTE (1.0ms) INSERT INTO [sql_server_chronics] ([datetime]) VALUES('2012-11-08 10:24:36.123')
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')
EXECUTE (1.0ms) DELETE FROM [sql_server_chronics] WHERE [datetime] = '2012-11-08 10:24:36.003'
EXECUTE (0.0ms) DELETE FROM [sql_server_chronics] WHERE [datetime] = '2012-11-08 10:24:36.123'
EXECUTE (0.0ms) ROLLBACK TRANSACTION
EXECUTE (1.0ms) BEGIN TRANSACTION
EXECUTE (0.0ms) INSERT INTO [sql_server_chronics] ([datetime]) VALUES('2012-11-08 10:24:36.003')
EXECUTE (1.0ms) INSERT INTO [sql_server_chronics] ([datetime]) VALUES('2012-11-08 10:24:36.123')
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')
EXECUTE (0.0ms) DELETE FROM [sql_server_chronics] WHERE [datetime] = '2012-11-08 10:24:36.003'
EXECUTE (0.0ms) DELETE FROM [sql_server_chronics] WHERE [datetime] = '2012-11-08 10:24:36.123'
EXECUTE (1.0ms) ROLLBACK TRANSACTION
EXECUTE (1.0ms) BEGIN TRANSACTION
EXECUTE (0.0ms) INSERT INTO [sql_server_chronics] ([datetime]) VALUES('2012-11-08 10:24:36.003')
EXECUTE (1.0ms) INSERT INTO [sql_server_chronics] ([datetime]) VALUES('2012-11-08 10:24:36.123')
EXECUTE (1.0ms) SAVE TRANSACTION active_record_1
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)
SQL (0.0ms) SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
SqlServerChronic Load (1.0ms) SELECT TOP (1) [sql_server_chronics].* FROM [sql_server_chronics] WHERE ([sql_server_chronics].[id] = 7)
EXECUTE (0.0ms) DELETE FROM [sql_server_chronics] WHERE [datetime] = '2012-11-08 10:24:36.003'
EXECUTE (0.0ms) DELETE FROM [sql_server_chronics] WHERE [datetime] = '2012-11-08 10:24:36.123'
EXECUTE (0.0ms) ROLLBACK TRANSACTION
EXECUTE (0.0ms) BEGIN TRANSACTION
EXECUTE (0.0ms) INSERT INTO [sql_server_chronics] ([datetime]) VALUES('2012-11-08 10:24:36.003')
EXECUTE (0.0ms) INSERT INTO [sql_server_chronics] ([datetime]) VALUES('2012-11-08 10:24:36.123')
EXECUTE (0.0ms) SAVE TRANSACTION active_record_1
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)
SQL (1.0ms) SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
SqlServerChronic Load (1.0ms) SELECT TOP (1) [sql_server_chronics].* FROM [sql_server_chronics] WHERE ([sql_server_chronics].[id] = 10)
EXECUTE (0.0ms) DELETE FROM [sql_server_chronics] WHERE [datetime] = '2012-11-08 10:24:36.003'
EXECUTE (1.0ms) DELETE FROM [sql_server_chronics] WHERE [datetime] = '2012-11-08 10:24:36.123'
EXECUTE (0.0ms) ROLLBACK TRANSACTION
EXECUTE (0.0ms) BEGIN TRANSACTION
EXECUTE (1.0ms) ROLLBACK TRANSACTION
EXECUTE (0.0ms) BEGIN TRANSACTION
EXECUTE (1.0ms) ROLLBACK TRANSACTION
EXECUTE (0.0ms) BEGIN TRANSACTION
EXECUTE (1.0ms) ROLLBACK TRANSACTION
EXECUTE (0.0ms) BEGIN TRANSACTION
EXECUTE (1.0ms) ROLLBACK TRANSACTION
EXECUTE (0.0ms) BEGIN TRANSACTION
EXECUTE (1.0ms) CREATE INDEX idx_credit_limit_test_desc ON accounts (credit_limit DESC)
SQL (1.0ms) EXEC sp_helpindex [accounts]
EXECUTE (1.0ms) DROP INDEX accounts.idx_credit_limit_test_desc
EXECUTE (1.0ms) ROLLBACK TRANSACTION
EXECUTE (0.0ms) BEGIN TRANSACTION
IDENTITY_INSERT (1.0ms) SET IDENTITY_INSERT [customers] ON
EXECUTE (1.0ms) INSERT INTO [customers_view] ([id],[name],[balance]) VALUES (420,'Microsoft',0)
IDENTITY_INSERT (0.0ms) SET IDENTITY_INSERT [customers] OFF
CustomersView Load (12.0ms) SELECT TOP (1) [customers_view].* FROM [customers_view] WHERE ([customers_view].[id] = 420)
EXECUTE (0.0ms) ROLLBACK TRANSACTION
EXECUTE (0.0ms) BEGIN TRANSACTION
EXECUTE (0.0ms) ROLLBACK TRANSACTION
EXECUTE (0.0ms) BEGIN TRANSACTION
EXECUTE (1.0ms) ROLLBACK TRANSACTION
EXECUTE (0.0ms) BEGIN TRANSACTION
EXECUTE (0.0ms) ROLLBACK TRANSACTION
EXECUTE (0.0ms) BEGIN TRANSACTION
EXECUTE (0.0ms) ROLLBACK TRANSACTION
EXECUTE (0.0ms) BEGIN TRANSACTION
EXECUTE (0.0ms) ROLLBACK TRANSACTION
EXECUTE (0.0ms) BEGIN TRANSACTION
EXECUTE (0.0ms) ROLLBACK TRANSACTION
EXECUTE (0.0ms) BEGIN TRANSACTION
EXECUTE (0.0ms) ROLLBACK TRANSACTION
EXECUTE (0.0ms) BEGIN TRANSACTION
EXECUTE (0.0ms) ROLLBACK TRANSACTION
EXECUTE (0.0ms) BEGIN TRANSACTION
EXECUTE (0.0ms) ROLLBACK TRANSACTION
EXECUTE (0.0ms) BEGIN TRANSACTION
EXECUTE (0.0ms) ROLLBACK TRANSACTION
EXECUTE (0.0ms) BEGIN TRANSACTION
EXECUTE (0.0ms) ROLLBACK TRANSACTION
EXECUTE (0.0ms) BEGIN TRANSACTION
EXECUTE (0.0ms) ROLLBACK TRANSACTION
EXECUTE (0.0ms) BEGIN TRANSACTION
EXECUTE (0.0ms) ROLLBACK TRANSACTION
EXECUTE (1.0ms) BEGIN TRANSACTION
EXECUTE (0.0ms) ROLLBACK TRANSACTION
EXECUTE (1.0ms) BEGIN TRANSACTION
EXECUTE (1.0ms) ROLLBACK TRANSACTION
EXECUTE (1.0ms) BEGIN TRANSACTION
EXECUTE (0.0ms) ROLLBACK TRANSACTION
EXECUTE (0.0ms) BEGIN TRANSACTION
EXECUTE (0.0ms) ROLLBACK TRANSACTION
EXECUTE (0.0ms) BEGIN TRANSACTION
EXECUTE (0.0ms) ROLLBACK TRANSACTION
EXECUTE (0.0ms) BEGIN TRANSACTION
EXECUTE (0.0ms) SAVE TRANSACTION active_record_1
EXECUTE (1.0ms) INSERT INTO [fk_test_has_pks] DEFAULT VALUES
SQL (1.0ms) SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
EXECUTE (0.0ms) SAVE TRANSACTION active_record_1
EXECUTE (1.0ms) INSERT INTO [fk_test_has_fks] ([fk_id]) VALUES (1)
SQL (0.0ms) SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
EXECUTE (54.0ms) EXEC sp_MSforeachtable 'ALTER TABLE ? NOCHECK CONSTRAINT ALL'
EXECUTE (0.0ms) SAVE TRANSACTION active_record_1
EXECUTE (2.0ms) DELETE FROM [fk_test_has_pks] WHERE ([fk_test_has_pks].[id] = 1)
SQL (0.0ms) SELECT @@ROWCOUNT AS AffectedRows
EXECUTE (48.0ms) EXEC sp_MSforeachtable 'ALTER TABLE ? CHECK CONSTRAINT ALL'
EXECUTE (18.0ms) ROLLBACK TRANSACTION
EXECUTE (0.0ms) BEGIN TRANSACTION
EXECUTE (0.0ms) SAVE TRANSACTION active_record_1
EXECUTE (0.0ms) INSERT INTO [fk_test_has_pks] DEFAULT VALUES
SQL (1.0ms) SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
EXECUTE (0.0ms) SAVE TRANSACTION active_record_1
EXECUTE (1.0ms) INSERT INTO [fk_test_has_fks] ([fk_id]) VALUES (2)
SQL (0.0ms) SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
EXECUTE (51.0ms) EXEC sp_MSforeachtable 'ALTER TABLE ? NOCHECK CONSTRAINT ALL'
EXECUTE (58.0ms) EXEC sp_MSforeachtable 'ALTER TABLE ? CHECK CONSTRAINT ALL'
EXECUTE (0.0ms) SAVE TRANSACTION active_record_1
EXECUTE (2.0ms) DELETE FROM [fk_test_has_pks] WHERE ([fk_test_has_pks].[id] = 2)
ODBC::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)
EXECUTE (0.0ms) ROLLBACK TRANSACTION active_record_1
EXECUTE (18.0ms) ROLLBACK TRANSACTION
EXECUTE (0.0ms) BEGIN TRANSACTION
EXECUTE (0.0ms) SAVE TRANSACTION active_record_1
EXECUTE (0.0ms) INSERT INTO [fk_test_has_pks] DEFAULT VALUES
SQL (1.0ms) SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
EXECUTE (0.0ms) SAVE TRANSACTION active_record_1
EXECUTE (0.0ms) INSERT INTO [fk_test_has_fks] ([fk_id]) VALUES (3)
SQL (1.0ms) SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
EXECUTE (49.0ms) EXEC sp_MSforeachtable 'ALTER TABLE ? NOCHECK CONSTRAINT ALL'
EXECUTE (48.0ms) EXEC sp_MSforeachtable 'ALTER TABLE ? CHECK CONSTRAINT ALL'
EXECUTE (0.0ms) SAVE TRANSACTION active_record_1
EXECUTE (2.0ms) DELETE FROM [fk_test_has_pks] WHERE ([fk_test_has_pks].[id] = 3)
ODBC::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)
EXECUTE (1.0ms) ROLLBACK TRANSACTION active_record_1
EXECUTE (19.0ms) ROLLBACK TRANSACTION
EXECUTE (0.0ms) BEGIN TRANSACTION
Developer Load (1.0ms) SELECT TOP (1) [developers].* FROM [developers]
EXECUTE (0.0ms) ROLLBACK TRANSACTION
EXECUTE (0.0ms) BEGIN TRANSACTION
EXECUTE (1.0ms) SAVE TRANSACTION active_record_1
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')
SQL (1.0ms) SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
Topic Load (1.0ms) SELECT TOP (1) topics.*, CASE WHEN 1=2 THEN 1 ELSE 0 END as is_test FROM [topics]
EXECUTE (0.0ms) ROLLBACK TRANSACTION
EXECUTE (0.0ms) BEGIN TRANSACTION
EXECUTE (1.0ms) SAVE TRANSACTION active_record_1
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')
SQL (1.0ms) SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
Topic Load (1.0ms) SELECT TOP (1) topics.*, CASE WHEN 2=2 THEN 1 ELSE 0 END as is_test FROM [topics]
EXECUTE (0.0ms) ROLLBACK TRANSACTION
EXECUTE (1.0ms) BEGIN TRANSACTION
EXECUTE (1.0ms) ROLLBACK TRANSACTION
EXECUTE (0.0ms) BEGIN TRANSACTION
SQL (1.0ms) SELECT SUM(2 * credit_limit) AS sum_id FROM [accounts]
EXECUTE (0.0ms) ROLLBACK TRANSACTION
EXECUTE (0.0ms) BEGIN TRANSACTION
EXECUTE (1.0ms) ROLLBACK TRANSACTION
EXECUTE (0.0ms) BEGIN TRANSACTION
EXECUTE (0.0ms) ROLLBACK TRANSACTION
EXECUTE (0.0ms) BEGIN TRANSACTION
EXECUTE (0.0ms) ROLLBACK TRANSACTION
EXECUTE (0.0ms) BEGIN TRANSACTION
EXECUTE (0.0ms) ROLLBACK TRANSACTION
EXECUTE (0.0ms) BEGIN TRANSACTION
EXECUTE (0.0ms) ROLLBACK TRANSACTION
EXECUTE (0.0ms) BEGIN TRANSACTION
EXECUTE (0.0ms) ROLLBACK TRANSACTION
EXECUTE (0.0ms) BEGIN TRANSACTION
EXECUTE (0.0ms) ROLLBACK TRANSACTION
EXECUTE (0.0ms) BEGIN TRANSACTION
EXECUTE (0.0ms) SAVE TRANSACTION active_record_1
EXECUTE (1.0ms) INSERT INTO [binaries] ([data]) VALUES (0x47494638396101000100800000ffffff00000021f90400000000002c00000000010001000002024401003b)
SQL (0.0ms) SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
EXECUTE (0.0ms) ROLLBACK TRANSACTION
EXECUTE (0.0ms) BEGIN TRANSACTION
EXECUTE (0.0ms) SAVE TRANSACTION active_record_1
EXECUTE (1.0ms) INSERT INTO [binaries] ([data]) VALUES (0x47494638396101000100800000ffffff00000021f90400000000002c00000000010001000002024401003b)
SQL (0.0ms) SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
EXECUTE (0.0ms) ROLLBACK TRANSACTION
EXECUTE (0.0ms) BEGIN TRANSACTION
EXECUTE (1.0ms) SAVE TRANSACTION active_record_1
EXECUTE (1.0ms) INSERT INTO [binaries] ([data]) VALUES (0x47494638396101000100800000ffffff00000021f90400000000002c00000000010001000002024401003b)
SQL (0.0ms) SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
Binary Load (2.0ms) SELECT TOP (1) [binaries].* FROM [binaries] WHERE ([binaries].[id] = 3)
EXECUTE (1.0ms) ROLLBACK TRANSACTION
EXECUTE (1.0ms) BEGIN TRANSACTION
EXECUTE (0.0ms) SAVE TRANSACTION active_record_1
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)
SQL (1.0ms) SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
EXECUTE (1.0ms) ROLLBACK TRANSACTION
EXECUTE (0.0ms) BEGIN TRANSACTION
EXECUTE (0.0ms) SAVE TRANSACTION active_record_1
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)
SQL (0.0ms) SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
EXECUTE (0.0ms) SAVE TRANSACTION active_record_1
EXECUTE (2.0ms) UPDATE [sql_server_chronics] SET [smalldatetime] = '2011-01-06 09:38:08.396' WHERE ([sql_server_chronics].[id] = 12)
SQL (1.0ms) SELECT @@ROWCOUNT AS AffectedRows
EXECUTE (1.0ms) ROLLBACK TRANSACTION
EXECUTE (0.0ms) BEGIN TRANSACTION
EXECUTE (1.0ms) ROLLBACK TRANSACTION
EXECUTE (0.0ms) BEGIN TRANSACTION
EXECUTE (0.0ms) ROLLBACK TRANSACTION
EXECUTE (0.0ms) BEGIN TRANSACTION
EXECUTE (0.0ms) ROLLBACK TRANSACTION
EXECUTE (0.0ms) BEGIN TRANSACTION
EXECUTE (0.0ms) ROLLBACK TRANSACTION
EXECUTE (0.0ms) BEGIN TRANSACTION
EXECUTE (0.0ms) SAVE TRANSACTION active_record_1
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)
SQL (1.0ms) SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
SqlServerChronic Load (1.0ms) SELECT TOP (1) [sql_server_chronics].* FROM [sql_server_chronics] WHERE ([sql_server_chronics].[id] = 13)
EXECUTE (0.0ms) SAVE TRANSACTION active_record_1
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)
SQL (1.0ms) SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
SqlServerChronic Load (1.0ms) SELECT TOP (1) [sql_server_chronics].* FROM [sql_server_chronics] WHERE ([sql_server_chronics].[id] = 14)
EXECUTE (1.0ms) ROLLBACK TRANSACTION
EXECUTE (0.0ms) BEGIN TRANSACTION
EXECUTE (0.0ms) SAVE TRANSACTION active_record_1
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)
SQL (0.0ms) SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
SqlServerChronic Load (1.0ms) SELECT TOP (1) [sql_server_chronics].* FROM [sql_server_chronics] WHERE ([sql_server_chronics].[id] = 15)
EXECUTE (0.0ms) SAVE TRANSACTION active_record_1
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)
SQL (0.0ms) SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
SqlServerChronic Load (1.0ms) SELECT TOP (1) [sql_server_chronics].* FROM [sql_server_chronics] WHERE ([sql_server_chronics].[id] = 16)
EXECUTE (0.0ms) ROLLBACK TRANSACTION
EXECUTE (0.0ms) BEGIN TRANSACTION
EXECUTE (0.0ms) SAVE TRANSACTION active_record_1
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)
SQL (1.0ms) SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
SqlServerChronic Load (1.0ms) SELECT TOP (1) [sql_server_chronics].* FROM [sql_server_chronics] WHERE ([sql_server_chronics].[id] = 17)
EXECUTE (0.0ms) SAVE TRANSACTION active_record_1
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)
SQL (1.0ms) SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
SqlServerChronic Load (1.0ms) SELECT TOP (1) [sql_server_chronics].* FROM [sql_server_chronics] WHERE ([sql_server_chronics].[id] = 18)
EXECUTE (0.0ms) ROLLBACK TRANSACTION
EXECUTE (0.0ms) BEGIN TRANSACTION
EXECUTE (0.0ms) ROLLBACK TRANSACTION
EXECUTE (0.0ms) BEGIN TRANSACTION
EXECUTE (0.0ms) SAVE TRANSACTION active_record_1
EXECUTE (1.0ms) INSERT INTO [sql_server_chronics] ([date], [datetime], [smalldatetime], [ss_timestamp], [time], [timestamp]) VALUES (NULL, NULL, NULL, NULL, NULL, NULL)
SQL (1.0ms) SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
SqlServerChronic Load (1.0ms) SELECT TOP (1) [sql_server_chronics].* FROM [sql_server_chronics] WHERE ([sql_server_chronics].[id] = 19)
EXECUTE (0.0ms) ROLLBACK TRANSACTION
EXECUTE (0.0ms) BEGIN TRANSACTION
EXECUTE (0.0ms) ROLLBACK TRANSACTION
EXECUTE (0.0ms) BEGIN TRANSACTION
EXECUTE (1.0ms) ROLLBACK TRANSACTION
EXECUTE (0.0ms) BEGIN TRANSACTION
EXECUTE (0.0ms) ROLLBACK TRANSACTION
EXECUTE (0.0ms) BEGIN TRANSACTION
EXECUTE (0.0ms) ROLLBACK TRANSACTION
EXECUTE (0.0ms) BEGIN TRANSACTION
EXECUTE (1.0ms) ROLLBACK TRANSACTION
EXECUTE (1.0ms) BEGIN TRANSACTION
EXECUTE (0.0ms) ROLLBACK TRANSACTION
EXECUTE (0.0ms) BEGIN TRANSACTION
EXECUTE (0.0ms) ROLLBACK TRANSACTION
EXECUTE (0.0ms) BEGIN TRANSACTION
EXECUTE (1.0ms) ROLLBACK TRANSACTION
EXECUTE (1.0ms) BEGIN TRANSACTION
EXECUTE (0.0ms) ROLLBACK TRANSACTION
CONNECTION RETRY: ActiveRecord::ConnectionAdapters::SQLServerAdapter retry #0.
SQL (1012.1ms) SELECT COUNT(*) AS count_id FROM [topics]
SQL (0.0ms) SELECT COUNT(*) AS count_id FROM [topics]
ODBC::Error: INTERN (0) [RubyODBC]Invalid handle: SELECT COUNT(*) AS count_id FROM [topics]
Topic Load (2.0ms) SELECT TOP (1) [topics].* FROM [topics] WHERE ([topics].[id] = 1)
EXECUTE (1.0ms) BEGIN TRANSACTION
EXECUTE (1.0ms) UPDATE [topics] SET [content] = N'1 updated' WHERE ([topics].[id] = 1)
SQL (1.0ms) SELECT @@ROWCOUNT AS AffectedRows
EXECUTE (1.0ms) COMMIT TRANSACTION
Topic Load (1.0ms) SELECT TOP (1) [topics].* FROM [topics] WHERE ([topics].[id] = 2)
EXECUTE (0.0ms) BEGIN TRANSACTION
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)
SQL (0.0ms) SELECT @@ROWCOUNT AS AffectedRows
EXECUTE (1.0ms) COMMIT TRANSACTION
Topic Load (0.0ms) SELECT TOP (1) [topics].* FROM [topics] WHERE ([topics].[id] = 1)
Topic Load (1.0ms) SELECT TOP (1) [topics].* FROM [topics] WHERE ([topics].[id] = 2)
EXECUTE (1.0ms) DELETE FROM [topics] WHERE ([topics].[id] IN (1, 2))
SQL (0.0ms) SELECT @@ROWCOUNT AS AffectedRows
SQL (1.0ms) SELECT DB_NAME()
EXECUTE (0.0ms) USE [activerecord_unittest2]
SQL (0.0ms) SELECT DB_NAME()
EXECUTE (0.0ms) USE [activerecord_unittest]
SQL (1.0ms) SELECT DB_NAME()
EXECUTE (1.0ms) SELECT 1
EXECUTE (0.0ms) SELECT 1
EXECUTE (1.0ms) SELECT * FROM [topics]
SQL (0.0ms) SELECT * FROM [topics]
IDENTITY_INSERT (1.0ms) SET IDENTITY_INSERT [accounts] ON
EXECUTE (1.0ms) INSERT INTO accounts ([id], [firm_id],[credit_limit]) values (999, 1, 50)
IDENTITY_INSERT (0.0ms) SET IDENTITY_INSERT [accounts] OFF
SQL (1.0ms) SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
EXECUTE (2.0ms) INSERT INTO accounts ([firm_id],[credit_limit]) values (1, 50)
SQL (0.0ms) SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
EXECUTE (0.0ms) SELECT * FROM [topics]
EXECUTE (1.0ms) BEGIN TRANSACTION
Author Load (3.0ms) SELECT TOP (1) [authors].* FROM [authors] WHERE ([authors].[id] = 1)
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)
EXECUTE (0.0ms) ROLLBACK TRANSACTION
EXECUTE (0.0ms) BEGIN TRANSACTION
Execute Procedure (75.0ms) EXEC sp_helpconstraint N'accounts'
EXECUTE (0.0ms) ROLLBACK TRANSACTION
EXECUTE (0.0ms) BEGIN TRANSACTION
Execute Procedure (49.0ms) EXEC sp_tables
EXECUTE (0.0ms) ROLLBACK TRANSACTION
EXECUTE (0.0ms) BEGIN TRANSACTION
Execute Procedure (3.0ms) EXEC sp_tables N'sql_server_chronics'
EXECUTE (1.0ms) ROLLBACK TRANSACTION
EXECUTE (0.0ms) BEGIN TRANSACTION
EXECUTE (1.0ms) ROLLBACK TRANSACTION
EXECUTE (0.0ms) BEGIN TRANSACTION
EXECUTE (0.0ms) ROLLBACK TRANSACTION
EXECUTE (0.0ms) BEGIN TRANSACTION
EXECUTE (1.0ms) delete from countries_treaties
EXECUTE (0.0ms) SAVE TRANSACTION active_record_1
EXECUTE (1.0ms) INSERT INTO [countries] ([country_id], [name]) VALUES (N'c1', N'India')
SQL (0.0ms) SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
EXECUTE (0.0ms) SAVE TRANSACTION active_record_1
EXECUTE (1.0ms) INSERT INTO [treaties] ([name], [treaty_id]) VALUES (N'peace', N't1')
SQL (0.0ms) SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
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')
SQL (1.0ms) SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
SQL (1.0ms) select * from countries_treaties
EXECUTE (0.0ms) ROLLBACK TRANSACTION
EXECUTE (0.0ms) BEGIN TRANSACTION
Account Load (2.0ms) SELECT TOP (1) [accounts].* FROM [accounts] WHERE ([accounts].[id] = 1)
Company Load (2.0ms) SELECT [companies].* FROM [companies] WHERE ([companies].[id] = 1)
EXECUTE (0.0ms) ROLLBACK TRANSACTION
EXECUTE (0.0ms) BEGIN TRANSACTION
SQL (37.0ms) EXEC sp_helpconstraint 'defaults','nomsg'
EXECUTE (2.0ms) ALTER TABLE [defaults] ALTER COLUMN [decimal_number] decimal(4)
SQL (28.0ms) EXEC sp_helpconstraint 'defaults','nomsg'
EXECUTE (1.0ms) ROLLBACK TRANSACTION
EXECUTE (0.0ms) BEGIN TRANSACTION
SQL (5.0ms) EXEC sp_helpconstraint 'people','nomsg'
EXECUTE (0.0ms) ALTER TABLE [people] DROP CONSTRAINT DF__people__lock_ver__7857F5CA
EXECUTE (2.0ms) ALTER TABLE [people] ALTER COLUMN [lock_version] varchar(255)
EXECUTE (1.0ms) ROLLBACK TRANSACTION
EXECUTE (0.0ms) BEGIN TRANSACTION
EXECUTE (1.0ms) CREATE TABLE [schema_migrations] ([version] varchar(255) NOT NULL)
SQL (0.0ms) EXEC sp_helpindex [schema_migrations]
EXECUTE (1.0ms) CREATE UNIQUE INDEX [unique_schema_migrations] ON [schema_migrations] ([version])
SQL (1.0ms) SELECT [schema_migrations].[version] FROM [schema_migrations]
Migrating to TableWillNeverBeCreated (1)
EXECUTE (0.0ms) SAVE TRANSACTION active_record_1
EXECUTE (1.0ms) CREATE TABLE [sqlserver_trans_table1] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY) 
EXECUTE (1.0ms) ROLLBACK TRANSACTION active_record_1
EXECUTE (0.0ms) ROLLBACK TRANSACTION
EXECUTE (0.0ms) BEGIN TRANSACTION
Developer Load (4.0ms) SELECT TOP (1) [developers].* FROM [developers] WHERE ([developers].[id] = 11)
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
EXECUTE (1.0ms) ROLLBACK TRANSACTION
EXECUTE (0.0ms) BEGIN TRANSACTION
EXECUTE (1.0ms) DELETE FROM [books]
SQL (0.0ms) SELECT @@ROWCOUNT AS AffectedRows
EXECUTE (1.0ms) SAVE TRANSACTION active_record_1
EXECUTE (0.0ms) INSERT INTO [books] ([name]) VALUES (NULL)
SQL (0.0ms) SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
EXECUTE (1.0ms) SAVE TRANSACTION active_record_1
EXECUTE (0.0ms) INSERT INTO [books] ([name]) VALUES (NULL)
SQL (1.0ms) SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
EXECUTE (0.0ms) SAVE TRANSACTION active_record_1
EXECUTE (0.0ms) INSERT INTO [books] ([name]) VALUES (NULL)
SQL (1.0ms) SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
EXECUTE (0.0ms) SAVE TRANSACTION active_record_1
EXECUTE (0.0ms) INSERT INTO [books] ([name]) VALUES (NULL)
SQL (0.0ms) SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
EXECUTE (0.0ms) SAVE TRANSACTION active_record_1
EXECUTE (0.0ms) INSERT INTO [books] ([name]) VALUES (NULL)
SQL (0.0ms) SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
EXECUTE (0.0ms) SAVE TRANSACTION active_record_1
EXECUTE (0.0ms) INSERT INTO [books] ([name]) VALUES (NULL)
SQL (0.0ms) SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
EXECUTE (1.0ms) SAVE TRANSACTION active_record_1
EXECUTE (0.0ms) INSERT INTO [books] ([name]) VALUES (NULL)
SQL (0.0ms) SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
EXECUTE (0.0ms) SAVE TRANSACTION active_record_1
EXECUTE (0.0ms) INSERT INTO [books] ([name]) VALUES (NULL)
SQL (1.0ms) SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
EXECUTE (0.0ms) SAVE TRANSACTION active_record_1
EXECUTE (0.0ms) INSERT INTO [books] ([name]) VALUES (NULL)
SQL (0.0ms) SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
EXECUTE (1.0ms) SAVE TRANSACTION active_record_1
EXECUTE (0.0ms) INSERT INTO [books] ([name]) VALUES (NULL)
SQL (0.0ms) SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
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
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
EXECUTE (0.0ms) SAVE TRANSACTION active_record_1
EXECUTE (1.0ms) DELETE FROM [books] WHERE ([books].[id] = 1)
SQL (0.0ms) SELECT @@ROWCOUNT AS AffectedRows
EXECUTE (0.0ms) SAVE TRANSACTION active_record_1
EXECUTE (0.0ms) DELETE FROM [books] WHERE ([books].[id] = 2)
SQL (0.0ms) SELECT @@ROWCOUNT AS AffectedRows
EXECUTE (0.0ms) SAVE TRANSACTION active_record_1
EXECUTE (1.0ms) DELETE FROM [books] WHERE ([books].[id] = 3)
SQL (0.0ms) SELECT @@ROWCOUNT AS AffectedRows
EXECUTE (0.0ms) SAVE TRANSACTION active_record_1
EXECUTE (0.0ms) DELETE FROM [books] WHERE ([books].[id] = 4)
SQL (0.0ms) SELECT @@ROWCOUNT AS AffectedRows
EXECUTE (0.0ms) SAVE TRANSACTION active_record_1
EXECUTE (0.0ms) DELETE FROM [books] WHERE ([books].[id] = 5)
SQL (0.0ms) SELECT @@ROWCOUNT AS AffectedRows
EXECUTE (0.0ms) SAVE TRANSACTION active_record_1
EXECUTE (0.0ms) DELETE FROM [books] WHERE ([books].[id] = 6)
SQL (1.0ms) SELECT @@ROWCOUNT AS AffectedRows
EXECUTE (0.0ms) SAVE TRANSACTION active_record_1
EXECUTE (1.0ms) DELETE FROM [books] WHERE ([books].[id] = 7)
SQL (0.0ms) SELECT @@ROWCOUNT AS AffectedRows
EXECUTE (0.0ms) SAVE TRANSACTION active_record_1
EXECUTE (1.0ms) DELETE FROM [books] WHERE ([books].[id] = 8)
SQL (0.0ms) SELECT @@ROWCOUNT AS AffectedRows
EXECUTE (1.0ms) SAVE TRANSACTION active_record_1
EXECUTE (0.0ms) DELETE FROM [books] WHERE ([books].[id] = 9)
SQL (0.0ms) SELECT @@ROWCOUNT AS AffectedRows
EXECUTE (0.0ms) SAVE TRANSACTION active_record_1
EXECUTE (1.0ms) DELETE FROM [books] WHERE ([books].[id] = 10)
SQL (0.0ms) SELECT @@ROWCOUNT AS AffectedRows
EXECUTE (1.0ms) ROLLBACK TRANSACTION
EXECUTE (0.0ms) BEGIN TRANSACTION
EXECUTE (0.0ms) DELETE FROM [books]
SQL (0.0ms) SELECT @@ROWCOUNT AS AffectedRows
EXECUTE (1.0ms) SAVE TRANSACTION active_record_1
EXECUTE (0.0ms) INSERT INTO [books] ([name]) VALUES (NULL)
SQL (1.0ms) SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
EXECUTE (0.0ms) SAVE TRANSACTION active_record_1
EXECUTE (0.0ms) INSERT INTO [books] ([name]) VALUES (NULL)
SQL (0.0ms) SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
EXECUTE (0.0ms) SAVE TRANSACTION active_record_1
EXECUTE (0.0ms) INSERT INTO [books] ([name]) VALUES (NULL)
SQL (0.0ms) SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
EXECUTE (0.0ms) SAVE TRANSACTION active_record_1
EXECUTE (1.0ms) INSERT INTO [books] ([name]) VALUES (NULL)
SQL (0.0ms) SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
EXECUTE (0.0ms) SAVE TRANSACTION active_record_1
EXECUTE (0.0ms) INSERT INTO [books] ([name]) VALUES (NULL)
SQL (0.0ms) SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
EXECUTE (0.0ms) SAVE TRANSACTION active_record_1
EXECUTE (1.0ms) INSERT INTO [books] ([name]) VALUES (NULL)
SQL (0.0ms) SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
EXECUTE (0.0ms) SAVE TRANSACTION active_record_1
EXECUTE (0.0ms) INSERT INTO [books] ([name]) VALUES (NULL)
SQL (0.0ms) SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
EXECUTE (0.0ms) SAVE TRANSACTION active_record_1
EXECUTE (0.0ms) INSERT INTO [books] ([name]) VALUES (NULL)
SQL (1.0ms) SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
EXECUTE (0.0ms) SAVE TRANSACTION active_record_1
EXECUTE (0.0ms) INSERT INTO [books] ([name]) VALUES (NULL)
SQL (0.0ms) SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
EXECUTE (0.0ms) SAVE TRANSACTION active_record_1
EXECUTE (0.0ms) INSERT INTO [books] ([name]) VALUES (NULL)
SQL (0.0ms) SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
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
EXECUTE (0.0ms) SAVE TRANSACTION active_record_1
EXECUTE (0.0ms) DELETE FROM [books] WHERE ([books].[id] = 11)
SQL (0.0ms) SELECT @@ROWCOUNT AS AffectedRows
EXECUTE (0.0ms) SAVE TRANSACTION active_record_1
EXECUTE (0.0ms) DELETE FROM [books] WHERE ([books].[id] = 12)
SQL (0.0ms) SELECT @@ROWCOUNT AS AffectedRows
EXECUTE (0.0ms) SAVE TRANSACTION active_record_1
EXECUTE (0.0ms) DELETE FROM [books] WHERE ([books].[id] = 13)
SQL (0.0ms) SELECT @@ROWCOUNT AS AffectedRows
EXECUTE (0.0ms) SAVE TRANSACTION active_record_1
EXECUTE (0.0ms) DELETE FROM [books] WHERE ([books].[id] = 14)
SQL (0.0ms) SELECT @@ROWCOUNT AS AffectedRows
EXECUTE (0.0ms) SAVE TRANSACTION active_record_1
EXECUTE (0.0ms) DELETE FROM [books] WHERE ([books].[id] = 15)
SQL (0.0ms) SELECT @@ROWCOUNT AS AffectedRows
EXECUTE (0.0ms) SAVE TRANSACTION active_record_1
EXECUTE (0.0ms) DELETE FROM [books] WHERE ([books].[id] = 16)
SQL (0.0ms) SELECT @@ROWCOUNT AS AffectedRows
EXECUTE (0.0ms) SAVE TRANSACTION active_record_1
EXECUTE (0.0ms) DELETE FROM [books] WHERE ([books].[id] = 17)
SQL (0.0ms) SELECT @@ROWCOUNT AS AffectedRows
EXECUTE (1.0ms) SAVE TRANSACTION active_record_1
EXECUTE (0.0ms) DELETE FROM [books] WHERE ([books].[id] = 18)
SQL (0.0ms) SELECT @@ROWCOUNT AS AffectedRows
EXECUTE (1.0ms) SAVE TRANSACTION active_record_1
EXECUTE (0.0ms) DELETE FROM [books] WHERE ([books].[id] = 19)
SQL (0.0ms) SELECT @@ROWCOUNT AS AffectedRows
EXECUTE (1.0ms) SAVE TRANSACTION active_record_1
EXECUTE (0.0ms) DELETE FROM [books] WHERE ([books].[id] = 20)
SQL (0.0ms) SELECT @@ROWCOUNT AS AffectedRows
EXECUTE (0.0ms) ROLLBACK TRANSACTION
EXECUTE (0.0ms) BEGIN TRANSACTION
EXECUTE (0.0ms) DELETE FROM [books]
SQL (0.0ms) SELECT @@ROWCOUNT AS AffectedRows
EXECUTE (0.0ms) SAVE TRANSACTION active_record_1
EXECUTE (0.0ms) INSERT INTO [books] ([name]) VALUES (NULL)
SQL (1.0ms) SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
EXECUTE (0.0ms) SAVE TRANSACTION active_record_1
EXECUTE (0.0ms) INSERT INTO [books] ([name]) VALUES (NULL)
SQL (0.0ms) SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
EXECUTE (0.0ms) SAVE TRANSACTION active_record_1
EXECUTE (0.0ms) INSERT INTO [books] ([name]) VALUES (NULL)
SQL (0.0ms) SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
EXECUTE (1.0ms) SAVE TRANSACTION active_record_1
EXECUTE (0.0ms) INSERT INTO [books] ([name]) VALUES (NULL)
SQL (0.0ms) SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
EXECUTE (0.0ms) SAVE TRANSACTION active_record_1
EXECUTE (0.0ms) INSERT INTO [books] ([name]) VALUES (NULL)
SQL (1.0ms) SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
EXECUTE (0.0ms) SAVE TRANSACTION active_record_1
EXECUTE (0.0ms) INSERT INTO [books] ([name]) VALUES (NULL)
SQL (1.0ms) SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
EXECUTE (0.0ms) SAVE TRANSACTION active_record_1
EXECUTE (0.0ms) INSERT INTO [books] ([name]) VALUES (NULL)
SQL (0.0ms) SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
EXECUTE (0.0ms) SAVE TRANSACTION active_record_1
EXECUTE (0.0ms) INSERT INTO [books] ([name]) VALUES (NULL)
SQL (1.0ms) SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
EXECUTE (0.0ms) SAVE TRANSACTION active_record_1
EXECUTE (0.0ms) INSERT INTO [books] ([name]) VALUES (NULL)
SQL (0.0ms) SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
EXECUTE (0.0ms) SAVE TRANSACTION active_record_1
EXECUTE (0.0ms) INSERT INTO [books] ([name]) VALUES (NULL)
SQL (1.0ms) SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
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
EXECUTE (1.0ms) SAVE TRANSACTION active_record_1
EXECUTE (0.0ms) DELETE FROM [books] WHERE ([books].[id] = 21)
SQL (0.0ms) SELECT @@ROWCOUNT AS AffectedRows
EXECUTE (1.0ms) SAVE TRANSACTION active_record_1
EXECUTE (0.0ms) DELETE FROM [books] WHERE ([books].[id] = 22)
SQL (0.0ms) SELECT @@ROWCOUNT AS AffectedRows
EXECUTE (1.0ms) SAVE TRANSACTION active_record_1
EXECUTE (0.0ms) DELETE FROM [books] WHERE ([books].[id] = 23)
SQL (0.0ms) SELECT @@ROWCOUNT AS AffectedRows
EXECUTE (1.0ms) SAVE TRANSACTION active_record_1
EXECUTE (0.0ms) DELETE FROM [books] WHERE ([books].[id] = 24)
SQL (0.0ms) SELECT @@ROWCOUNT AS AffectedRows
EXECUTE (1.0ms) SAVE TRANSACTION active_record_1
EXECUTE (0.0ms) DELETE FROM [books] WHERE ([books].[id] = 25)
SQL (0.0ms) SELECT @@ROWCOUNT AS AffectedRows
EXECUTE (1.0ms) SAVE TRANSACTION active_record_1
EXECUTE (0.0ms) DELETE FROM [books] WHERE ([books].[id] = 26)
SQL (0.0ms) SELECT @@ROWCOUNT AS AffectedRows
EXECUTE (0.0ms) SAVE TRANSACTION active_record_1
EXECUTE (0.0ms) DELETE FROM [books] WHERE ([books].[id] = 27)
SQL (0.0ms) SELECT @@ROWCOUNT AS AffectedRows
EXECUTE (0.0ms) SAVE TRANSACTION active_record_1
EXECUTE (0.0ms) DELETE FROM [books] WHERE ([books].[id] = 28)
SQL (0.0ms) SELECT @@ROWCOUNT AS AffectedRows
EXECUTE (0.0ms) SAVE TRANSACTION active_record_1
EXECUTE (0.0ms) DELETE FROM [books] WHERE ([books].[id] = 29)
SQL (1.0ms) SELECT @@ROWCOUNT AS AffectedRows
EXECUTE (0.0ms) SAVE TRANSACTION active_record_1
EXECUTE (1.0ms) DELETE FROM [books] WHERE ([books].[id] = 30)
SQL (0.0ms) SELECT @@ROWCOUNT AS AffectedRows
EXECUTE (1.0ms) ROLLBACK TRANSACTION
EXECUTE (0.0ms) BEGIN TRANSACTION
EXECUTE (1.0ms) DELETE FROM [books]
SQL (0.0ms) SELECT @@ROWCOUNT AS AffectedRows
EXECUTE (0.0ms) SAVE TRANSACTION active_record_1
EXECUTE (0.0ms) INSERT INTO [books] ([name]) VALUES (NULL)
SQL (0.0ms) SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
EXECUTE (1.0ms) SAVE TRANSACTION active_record_1
EXECUTE (0.0ms) INSERT INTO [books] ([name]) VALUES (NULL)
SQL (1.0ms) SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
EXECUTE (0.0ms) SAVE TRANSACTION active_record_1
EXECUTE (1.0ms) INSERT INTO [books] ([name]) VALUES (NULL)
SQL (0.0ms) SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
EXECUTE (0.0ms) SAVE TRANSACTION active_record_1
EXECUTE (0.0ms) INSERT INTO [books] ([name]) VALUES (NULL)
SQL (0.0ms) SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
EXECUTE (0.0ms) SAVE TRANSACTION active_record_1
EXECUTE (1.0ms) INSERT INTO [books] ([name]) VALUES (NULL)
SQL (0.0ms) SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
EXECUTE (0.0ms) SAVE TRANSACTION active_record_1
EXECUTE (0.0ms) INSERT INTO [books] ([name]) VALUES (NULL)
SQL (0.0ms) SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
EXECUTE (0.0ms) SAVE TRANSACTION active_record_1
EXECUTE (0.0ms) INSERT INTO [books] ([name]) VALUES (NULL)
SQL (0.0ms) SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
EXECUTE (0.0ms) SAVE TRANSACTION active_record_1
EXECUTE (0.0ms) INSERT INTO [books] ([name]) VALUES (NULL)
SQL (0.0ms) SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
EXECUTE (0.0ms) SAVE TRANSACTION active_record_1
EXECUTE (0.0ms) INSERT INTO [books] ([name]) VALUES (NULL)
SQL (1.0ms) SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
EXECUTE (0.0ms) SAVE TRANSACTION active_record_1
EXECUTE (0.0ms) INSERT INTO [books] ([name]) VALUES (NULL)
SQL (0.0ms) SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
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
EXECUTE (0.0ms) SAVE TRANSACTION active_record_1
EXECUTE (0.0ms) DELETE FROM [books] WHERE ([books].[id] = 31)
SQL (0.0ms) SELECT @@ROWCOUNT AS AffectedRows
EXECUTE (0.0ms) SAVE TRANSACTION active_record_1
EXECUTE (0.0ms) DELETE FROM [books] WHERE ([books].[id] = 32)
SQL (0.0ms) SELECT @@ROWCOUNT AS AffectedRows
EXECUTE (0.0ms) SAVE TRANSACTION active_record_1
EXECUTE (0.0ms) DELETE FROM [books] WHERE ([books].[id] = 33)
SQL (0.0ms) SELECT @@ROWCOUNT AS AffectedRows
EXECUTE (0.0ms) SAVE TRANSACTION active_record_1
EXECUTE (0.0ms) DELETE FROM [books] WHERE ([books].[id] = 34)
SQL (0.0ms) SELECT @@ROWCOUNT AS AffectedRows
EXECUTE (0.0ms) SAVE TRANSACTION active_record_1
EXECUTE (0.0ms) DELETE FROM [books] WHERE ([books].[id] = 35)
SQL (0.0ms) SELECT @@ROWCOUNT AS AffectedRows
EXECUTE (0.0ms) SAVE TRANSACTION active_record_1
EXECUTE (0.0ms) DELETE FROM [books] WHERE ([books].[id] = 36)
SQL (0.0ms) SELECT @@ROWCOUNT AS AffectedRows
EXECUTE (0.0ms) SAVE TRANSACTION active_record_1
EXECUTE (0.0ms) DELETE FROM [books] WHERE ([books].[id] = 37)
SQL (0.0ms) SELECT @@ROWCOUNT AS AffectedRows
EXECUTE (0.0ms) SAVE TRANSACTION active_record_1
EXECUTE (0.0ms) DELETE FROM [books] WHERE ([books].[id] = 38)
SQL (0.0ms) SELECT @@ROWCOUNT AS AffectedRows
EXECUTE (0.0ms) SAVE TRANSACTION active_record_1
EXECUTE (0.0ms) DELETE FROM [books] WHERE ([books].[id] = 39)
SQL (0.0ms) SELECT @@ROWCOUNT AS AffectedRows
EXECUTE (0.0ms) SAVE TRANSACTION active_record_1
EXECUTE (0.0ms) DELETE FROM [books] WHERE ([books].[id] = 40)
SQL (0.0ms) SELECT @@ROWCOUNT AS AffectedRows
EXECUTE (0.0ms) ROLLBACK TRANSACTION
EXECUTE (0.0ms) BEGIN TRANSACTION
EXECUTE (0.0ms) DELETE FROM [books]
SQL (0.0ms) SELECT @@ROWCOUNT AS AffectedRows
EXECUTE (0.0ms) SAVE TRANSACTION active_record_1
EXECUTE (0.0ms) INSERT INTO [books] ([name]) VALUES (NULL)
SQL (0.0ms) SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
EXECUTE (0.0ms) SAVE TRANSACTION active_record_1
EXECUTE (0.0ms) INSERT INTO [books] ([name]) VALUES (NULL)
SQL (0.0ms) SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
EXECUTE (0.0ms) SAVE TRANSACTION active_record_1
EXECUTE (0.0ms) INSERT INTO [books] ([name]) VALUES (NULL)
SQL (1.0ms) SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
EXECUTE (0.0ms) SAVE TRANSACTION active_record_1
EXECUTE (0.0ms) INSERT INTO [books] ([name]) VALUES (NULL)
SQL (0.0ms) SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
EXECUTE (0.0ms) SAVE TRANSACTION active_record_1
EXECUTE (0.0ms) INSERT INTO [books] ([name]) VALUES (NULL)
SQL (1.0ms) SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
EXECUTE (0.0ms) SAVE TRANSACTION active_record_1
EXECUTE (1.0ms) INSERT INTO [books] ([name]) VALUES (NULL)
SQL (0.0ms) SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
EXECUTE (0.0ms) SAVE TRANSACTION active_record_1
EXECUTE (0.0ms) INSERT INTO [books] ([name]) VALUES (NULL)
SQL (0.0ms) SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
EXECUTE (0.0ms) SAVE TRANSACTION active_record_1
EXECUTE (1.0ms) INSERT INTO [books] ([name]) VALUES (NULL)
SQL (0.0ms) SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
EXECUTE (1.0ms) SAVE TRANSACTION active_record_1
EXECUTE (0.0ms) INSERT INTO [books] ([name]) VALUES (NULL)
SQL (1.0ms) SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
EXECUTE (0.0ms) SAVE TRANSACTION active_record_1
EXECUTE (0.0ms) INSERT INTO [books] ([name]) VALUES (NULL)
SQL (0.0ms) SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
SQL (1.0ms) SELECT COUNT(*) AS count_id FROM [posts]
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
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
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
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
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
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
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
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
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
EXECUTE (0.0ms) SAVE TRANSACTION active_record_1
EXECUTE (0.0ms) DELETE FROM [books] WHERE ([books].[id] = 41)
SQL (0.0ms) SELECT @@ROWCOUNT AS AffectedRows
EXECUTE (0.0ms) SAVE TRANSACTION active_record_1
EXECUTE (1.0ms) DELETE FROM [books] WHERE ([books].[id] = 42)
SQL (0.0ms) SELECT @@ROWCOUNT AS AffectedRows
EXECUTE (1.0ms) SAVE TRANSACTION active_record_1
EXECUTE (0.0ms) DELETE FROM [books] WHERE ([books].[id] = 43)
SQL (0.0ms) SELECT @@ROWCOUNT AS AffectedRows
EXECUTE (0.0ms) SAVE TRANSACTION active_record_1
EXECUTE (1.0ms) DELETE FROM [books] WHERE ([books].[id] = 44)
SQL (0.0ms) SELECT @@ROWCOUNT AS AffectedRows
EXECUTE (0.0ms) SAVE TRANSACTION active_record_1
EXECUTE (0.0ms) DELETE FROM [books] WHERE ([books].[id] = 45)
SQL (0.0ms) SELECT @@ROWCOUNT AS AffectedRows
EXECUTE (0.0ms) SAVE TRANSACTION active_record_1
EXECUTE (0.0ms) DELETE FROM [books] WHERE ([books].[id] = 46)
SQL (0.0ms) SELECT @@ROWCOUNT AS AffectedRows
EXECUTE (0.0ms) SAVE TRANSACTION active_record_1
EXECUTE (0.0ms) DELETE FROM [books] WHERE ([books].[id] = 47)
SQL (1.0ms) SELECT @@ROWCOUNT AS AffectedRows
EXECUTE (0.0ms) SAVE TRANSACTION active_record_1
EXECUTE (1.0ms) DELETE FROM [books] WHERE ([books].[id] = 48)
SQL (0.0ms) SELECT @@ROWCOUNT AS AffectedRows
EXECUTE (0.0ms) SAVE TRANSACTION active_record_1
EXECUTE (0.0ms) DELETE FROM [books] WHERE ([books].[id] = 49)
SQL (0.0ms) SELECT @@ROWCOUNT AS AffectedRows
EXECUTE (0.0ms) SAVE TRANSACTION active_record_1
EXECUTE (0.0ms) DELETE FROM [books] WHERE ([books].[id] = 50)
SQL (1.0ms) SELECT @@ROWCOUNT AS AffectedRows
EXECUTE (0.0ms) ROLLBACK TRANSACTION
EXECUTE (0.0ms) BEGIN TRANSACTION
EXECUTE (0.0ms) DELETE FROM [books]
SQL (0.0ms) SELECT @@ROWCOUNT AS AffectedRows
EXECUTE (0.0ms) SAVE TRANSACTION active_record_1
EXECUTE (0.0ms) INSERT INTO [books] ([name]) VALUES (NULL)
SQL (0.0ms) SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
EXECUTE (0.0ms) SAVE TRANSACTION active_record_1
EXECUTE (0.0ms) INSERT INTO [books] ([name]) VALUES (NULL)
SQL (0.0ms) SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
EXECUTE (0.0ms) SAVE TRANSACTION active_record_1
EXECUTE (0.0ms) INSERT INTO [books] ([name]) VALUES (NULL)
SQL (1.0ms) SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
EXECUTE (0.0ms) SAVE TRANSACTION active_record_1
EXECUTE (0.0ms) INSERT INTO [books] ([name]) VALUES (NULL)
SQL (0.0ms) SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
EXECUTE (0.0ms) SAVE TRANSACTION active_record_1
EXECUTE (0.0ms) INSERT INTO [books] ([name]) VALUES (NULL)
SQL (1.0ms) SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
EXECUTE (0.0ms) SAVE TRANSACTION active_record_1
EXECUTE (0.0ms) INSERT INTO [books] ([name]) VALUES (NULL)
SQL (0.0ms) SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
EXECUTE (1.0ms) SAVE TRANSACTION active_record_1
EXECUTE (0.0ms) INSERT INTO [books] ([name]) VALUES (NULL)
SQL (1.0ms) SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
EXECUTE (0.0ms) SAVE TRANSACTION active_record_1
EXECUTE (0.0ms) INSERT INTO [books] ([name]) VALUES (NULL)
SQL (0.0ms) SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
EXECUTE (0.0ms) SAVE TRANSACTION active_record_1
EXECUTE (0.0ms) INSERT INTO [books] ([name]) VALUES (NULL)
SQL (1.0ms) SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
EXECUTE (0.0ms) SAVE TRANSACTION active_record_1
EXECUTE (0.0ms) INSERT INTO [books] ([name]) VALUES (NULL)
SQL (0.0ms) SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
Book Load (1.0ms) SELECT TOP (10) [books].* FROM [books]
EXECUTE (0.0ms) SAVE TRANSACTION active_record_1
EXECUTE (1.0ms) DELETE FROM [books] WHERE ([books].[id] = 51)
SQL (0.0ms) SELECT @@ROWCOUNT AS AffectedRows
EXECUTE (1.0ms) SAVE TRANSACTION active_record_1
EXECUTE (0.0ms) DELETE FROM [books] WHERE ([books].[id] = 52)
SQL (0.0ms) SELECT @@ROWCOUNT AS AffectedRows
EXECUTE (0.0ms) SAVE TRANSACTION active_record_1
EXECUTE (0.0ms) DELETE FROM [books] WHERE ([books].[id] = 53)
SQL (0.0ms) SELECT @@ROWCOUNT AS AffectedRows
EXECUTE (0.0ms) SAVE TRANSACTION active_record_1
EXECUTE (0.0ms) DELETE FROM [books] WHERE ([books].[id] = 54)
SQL (0.0ms) SELECT @@ROWCOUNT AS AffectedRows
EXECUTE (0.0ms) SAVE TRANSACTION active_record_1
EXECUTE (1.0ms) DELETE FROM [books] WHERE ([books].[id] = 55)
SQL (0.0ms) SELECT @@ROWCOUNT AS AffectedRows
EXECUTE (0.0ms) SAVE TRANSACTION active_record_1
EXECUTE (0.0ms) DELETE FROM [books] WHERE ([books].[id] = 56)
SQL (0.0ms) SELECT @@ROWCOUNT AS AffectedRows
EXECUTE (1.0ms) SAVE TRANSACTION active_record_1
EXECUTE (0.0ms) DELETE FROM [books] WHERE ([books].[id] = 57)
SQL (0.0ms) SELECT @@ROWCOUNT AS AffectedRows
EXECUTE (0.0ms) SAVE TRANSACTION active_record_1
EXECUTE (0.0ms) DELETE FROM [books] WHERE ([books].[id] = 58)
SQL (0.0ms) SELECT @@ROWCOUNT AS AffectedRows
EXECUTE (0.0ms) SAVE TRANSACTION active_record_1
EXECUTE (0.0ms) DELETE FROM [books] WHERE ([books].[id] = 59)
SQL (1.0ms) SELECT @@ROWCOUNT AS AffectedRows
EXECUTE (0.0ms) SAVE TRANSACTION active_record_1
EXECUTE (0.0ms) DELETE FROM [books] WHERE ([books].[id] = 60)
SQL (0.0ms) SELECT @@ROWCOUNT AS AffectedRows
EXECUTE (0.0ms) ROLLBACK TRANSACTION
EXECUTE (0.0ms) BEGIN TRANSACTION
EXECUTE (0.0ms) DELETE FROM [books]
SQL (1.0ms) SELECT @@ROWCOUNT AS AffectedRows
EXECUTE (0.0ms) SAVE TRANSACTION active_record_1
EXECUTE (1.0ms) INSERT INTO [books] ([name]) VALUES (NULL)
SQL (0.0ms) SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
EXECUTE (0.0ms) SAVE TRANSACTION active_record_1
EXECUTE (0.0ms) INSERT INTO [books] ([name]) VALUES (NULL)
SQL (0.0ms) SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
EXECUTE (0.0ms) SAVE TRANSACTION active_record_1
EXECUTE (1.0ms) INSERT INTO [books] ([name]) VALUES (NULL)
SQL (0.0ms) SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
EXECUTE (0.0ms) SAVE TRANSACTION active_record_1
EXECUTE (0.0ms) INSERT INTO [books] ([name]) VALUES (NULL)
SQL (0.0ms) SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
EXECUTE (0.0ms) SAVE TRANSACTION active_record_1
EXECUTE (0.0ms) INSERT INTO [books] ([name]) VALUES (NULL)
SQL (0.0ms) SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
EXECUTE (0.0ms) SAVE TRANSACTION active_record_1
EXECUTE (0.0ms) INSERT INTO [books] ([name]) VALUES (NULL)
SQL (0.0ms) SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
EXECUTE (1.0ms) SAVE TRANSACTION active_record_1
EXECUTE (0.0ms) INSERT INTO [books] ([name]) VALUES (NULL)
SQL (1.0ms) SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
EXECUTE (0.0ms) SAVE TRANSACTION active_record_1
EXECUTE (0.0ms) INSERT INTO [books] ([name]) VALUES (NULL)
SQL (1.0ms) SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
EXECUTE (0.0ms) SAVE TRANSACTION active_record_1
EXECUTE (0.0ms) INSERT INTO [books] ([name]) VALUES (NULL)
SQL (0.0ms) SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
EXECUTE (0.0ms) SAVE TRANSACTION active_record_1
EXECUTE (0.0ms) INSERT INTO [books] ([name]) VALUES (NULL)
SQL (0.0ms) SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
Book Load (1.0ms) SELECT TOP (20) [books].* FROM [books]
EXECUTE (1.0ms) SAVE TRANSACTION active_record_1
EXECUTE (0.0ms) DELETE FROM [books] WHERE ([books].[id] = 61)
SQL (1.0ms) SELECT @@ROWCOUNT AS AffectedRows
EXECUTE (0.0ms) SAVE TRANSACTION active_record_1
EXECUTE (0.0ms) DELETE FROM [books] WHERE ([books].[id] = 62)
SQL (1.0ms) SELECT @@ROWCOUNT AS AffectedRows
EXECUTE (0.0ms) SAVE TRANSACTION active_record_1
EXECUTE (1.0ms) DELETE FROM [books] WHERE ([books].[id] = 63)
SQL (0.0ms) SELECT @@ROWCOUNT AS AffectedRows
EXECUTE (0.0ms) SAVE TRANSACTION active_record_1
EXECUTE (1.0ms) DELETE FROM [books] WHERE ([books].[id] = 64)
SQL (0.0ms) SELECT @@ROWCOUNT AS AffectedRows
EXECUTE (0.0ms) SAVE TRANSACTION active_record_1
EXECUTE (1.0ms) DELETE FROM [books] WHERE ([books].[id] = 65)
SQL (0.0ms) SELECT @@ROWCOUNT AS AffectedRows
EXECUTE (0.0ms) SAVE TRANSACTION active_record_1
EXECUTE (1.0ms) DELETE FROM [books] WHERE ([books].[id] = 66)
SQL (0.0ms) SELECT @@ROWCOUNT AS AffectedRows
EXECUTE (0.0ms) SAVE TRANSACTION active_record_1
EXECUTE (1.0ms) DELETE FROM [books] WHERE ([books].[id] = 67)
SQL (0.0ms) SELECT @@ROWCOUNT AS AffectedRows
EXECUTE (0.0ms) SAVE TRANSACTION active_record_1
EXECUTE (1.0ms) DELETE FROM [books] WHERE ([books].[id] = 68)
SQL (0.0ms) SELECT @@ROWCOUNT AS AffectedRows
EXECUTE (0.0ms) SAVE TRANSACTION active_record_1
EXECUTE (1.0ms) DELETE FROM [books] WHERE ([books].[id] = 69)
SQL (0.0ms) SELECT @@ROWCOUNT AS AffectedRows
EXECUTE (0.0ms) SAVE TRANSACTION active_record_1
EXECUTE (1.0ms) DELETE FROM [books] WHERE ([books].[id] = 70)
SQL (0.0ms) SELECT @@ROWCOUNT AS AffectedRows
EXECUTE (0.0ms) ROLLBACK TRANSACTION
EXECUTE (0.0ms) BEGIN TRANSACTION
EXECUTE (0.0ms) DELETE FROM [books]
SQL (0.0ms) SELECT @@ROWCOUNT AS AffectedRows
EXECUTE (0.0ms) SAVE TRANSACTION active_record_1
EXECUTE (0.0ms) INSERT INTO [books] ([name]) VALUES (NULL)
SQL (1.0ms) SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
EXECUTE (0.0ms) SAVE TRANSACTION active_record_1
EXECUTE (0.0ms) INSERT INTO [books] ([name]) VALUES (NULL)
SQL (1.0ms) SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
EXECUTE (1.0ms) SAVE TRANSACTION active_record_1
EXECUTE (0.0ms) INSERT INTO [books] ([name]) VALUES (NULL)
SQL (1.0ms) SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
EXECUTE (0.0ms) SAVE TRANSACTION active_record_1
EXECUTE (0.0ms) INSERT INTO [books] ([name]) VALUES (NULL)
SQL (0.0ms) SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
EXECUTE (0.0ms) SAVE TRANSACTION active_record_1
EXECUTE (1.0ms) INSERT INTO [books] ([name]) VALUES (NULL)
SQL (0.0ms) SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
EXECUTE (0.0ms) SAVE TRANSACTION active_record_1
EXECUTE (1.0ms) INSERT INTO [books] ([name]) VALUES (NULL)
SQL (0.0ms) SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
EXECUTE (0.0ms) SAVE TRANSACTION active_record_1
EXECUTE (0.0ms) INSERT INTO [books] ([name]) VALUES (NULL)
SQL (0.0ms) SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
EXECUTE (1.0ms) SAVE TRANSACTION active_record_1
EXECUTE (0.0ms) INSERT INTO [books] ([name]) VALUES (NULL)
SQL (0.0ms) SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
EXECUTE (0.0ms) SAVE TRANSACTION active_record_1
EXECUTE (1.0ms) INSERT INTO [books] ([name]) VALUES (NULL)
SQL (0.0ms) SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
EXECUTE (0.0ms) SAVE TRANSACTION active_record_1
EXECUTE (0.0ms) INSERT INTO [books] ([name]) VALUES (NULL)
SQL (1.0ms) SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
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
EXECUTE (0.0ms) SAVE TRANSACTION active_record_1
EXECUTE (1.0ms) DELETE FROM [books] WHERE ([books].[id] = 71)
SQL (0.0ms) SELECT @@ROWCOUNT AS AffectedRows
EXECUTE (0.0ms) SAVE TRANSACTION active_record_1
EXECUTE (1.0ms) DELETE FROM [books] WHERE ([books].[id] = 72)
SQL (0.0ms) SELECT @@ROWCOUNT AS AffectedRows
EXECUTE (0.0ms) SAVE TRANSACTION active_record_1
EXECUTE (1.0ms) DELETE FROM [books] WHERE ([books].[id] = 73)
SQL (0.0ms) SELECT @@ROWCOUNT AS AffectedRows
EXECUTE (0.0ms) SAVE TRANSACTION active_record_1
EXECUTE (0.0ms) DELETE FROM [books] WHERE ([books].[id] = 74)
SQL (0.0ms) SELECT @@ROWCOUNT AS AffectedRows
EXECUTE (1.0ms) SAVE TRANSACTION active_record_1
EXECUTE (0.0ms) DELETE FROM [books] WHERE ([books].[id] = 75)
SQL (0.0ms) SELECT @@ROWCOUNT AS AffectedRows
EXECUTE (1.0ms) SAVE TRANSACTION active_record_1
EXECUTE (0.0ms) DELETE FROM [books] WHERE ([books].[id] = 76)
SQL (1.0ms) SELECT @@ROWCOUNT AS AffectedRows
EXECUTE (1.0ms) SAVE TRANSACTION active_record_1
EXECUTE (0.0ms) DELETE FROM [books] WHERE ([books].[id] = 77)
SQL (1.0ms) SELECT @@ROWCOUNT AS AffectedRows
EXECUTE (0.0ms) SAVE TRANSACTION active_record_1
EXECUTE (0.0ms) DELETE FROM [books] WHERE ([books].[id] = 78)
SQL (0.0ms) SELECT @@ROWCOUNT AS AffectedRows
EXECUTE (0.0ms) SAVE TRANSACTION active_record_1
EXECUTE (1.0ms) DELETE FROM [books] WHERE ([books].[id] = 79)
SQL (0.0ms) SELECT @@ROWCOUNT AS AffectedRows
EXECUTE (0.0ms) SAVE TRANSACTION active_record_1
EXECUTE (0.0ms) DELETE FROM [books] WHERE ([books].[id] = 80)
SQL (1.0ms) SELECT @@ROWCOUNT AS AffectedRows
EXECUTE (1.0ms) ROLLBACK TRANSACTION
EXECUTE (0.0ms) USE [activerecord_unittest]
EXECUTE (0.0ms) BEGIN TRANSACTION
Person Load (2.0ms) SELECT TOP (1) [people].* FROM [people] WHERE ([people].[id] = 1)
EXECUTE (1.0ms) USE [activerecord_unittest]
EXECUTE (0.0ms) BEGIN TRANSACTION
Person Load (1.0ms) SELECT TOP (1) [people].* FROM [people] WHERE ([people].[id] = 1)
EXECUTE (0.0ms) COMMIT TRANSACTION
EXECUTE (1.0ms) COMMIT TRANSACTION
EXECUTE (0.0ms) USE [activerecord_unittest]
EXECUTE (1.0ms) USE [activerecord_unittest]
EXECUTE (0.0ms) BEGIN TRANSACTION
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)
SQL (1.0ms) SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
EXECUTE (1.0ms) COMMIT TRANSACTION
EXECUTE (0.0ms) BEGIN TRANSACTION
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)
SQL (0.0ms) SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
EXECUTE (0.0ms) COMMIT TRANSACTION
EXECUTE (1.0ms) BEGIN TRANSACTION
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)
SQL (0.0ms) SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
EXECUTE (0.0ms) COMMIT TRANSACTION
EXECUTE (0.0ms) BEGIN TRANSACTION
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)
SQL (1.0ms) SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
EXECUTE (1.0ms) COMMIT TRANSACTION
EXECUTE (0.0ms) BEGIN TRANSACTION
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)
SQL (0.0ms) SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
EXECUTE (0.0ms) COMMIT TRANSACTION
EXECUTE (1.0ms) BEGIN TRANSACTION
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)
SQL (0.0ms) SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
EXECUTE (0.0ms) COMMIT TRANSACTION
EXECUTE (0.0ms) BEGIN TRANSACTION
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)
SQL (0.0ms) SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
EXECUTE (1.0ms) COMMIT TRANSACTION
EXECUTE (0.0ms) BEGIN TRANSACTION
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)
SQL (1.0ms) SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
EXECUTE (1.0ms) COMMIT TRANSACTION
EXECUTE (0.0ms) BEGIN TRANSACTION
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)
SQL (1.0ms) SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
EXECUTE (1.0ms) COMMIT TRANSACTION
EXECUTE (0.0ms) BEGIN TRANSACTION
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)
SQL (0.0ms) SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
EXECUTE (0.0ms) COMMIT TRANSACTION
EXECUTE (1.0ms) BEGIN TRANSACTION
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)
SQL (0.0ms) SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
EXECUTE (0.0ms) COMMIT TRANSACTION
EXECUTE (1.0ms) BEGIN TRANSACTION
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)
SQL (0.0ms) SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
EXECUTE (1.0ms) COMMIT TRANSACTION
EXECUTE (0.0ms) BEGIN TRANSACTION
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)
SQL (1.0ms) SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
EXECUTE (1.0ms) COMMIT TRANSACTION
EXECUTE (0.0ms) BEGIN TRANSACTION
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)
SQL (1.0ms) SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
EXECUTE (1.0ms) COMMIT TRANSACTION
EXECUTE (1.0ms) BEGIN TRANSACTION
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)
SQL (0.0ms) SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
EXECUTE (1.0ms) COMMIT TRANSACTION
EXECUTE (0.0ms) BEGIN TRANSACTION
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)
SQL (1.0ms) SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
EXECUTE (1.0ms) COMMIT TRANSACTION
EXECUTE (0.0ms) BEGIN TRANSACTION
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)
SQL (0.0ms) SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
EXECUTE (0.0ms) COMMIT TRANSACTION
EXECUTE (0.0ms) BEGIN TRANSACTION
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)
SQL (0.0ms) SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
EXECUTE (0.0ms) COMMIT TRANSACTION
EXECUTE (0.0ms) BEGIN TRANSACTION
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)
SQL (1.0ms) SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
EXECUTE (1.0ms) COMMIT TRANSACTION
EXECUTE (0.0ms) BEGIN TRANSACTION
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)
SQL (0.0ms) SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
EXECUTE (0.0ms) COMMIT TRANSACTION
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
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))
EXECUTE (0.0ms) USE [activerecord_unittest]
EXECUTE (1.0ms) USE [activerecord_unittest]
EXECUTE (1.0ms) BEGIN TRANSACTION
Person Load (1.0ms) SELECT TOP (1) [people].* FROM [people] WITH(HOLDLOCK, ROWLOCK) WHERE ([people].[id] = 1)
Reader Load (1.0ms) SELECT [readers].* FROM [readers] WHERE ([readers].person_id = 1)
EXECUTE (0.0ms) COMMIT TRANSACTION
EXECUTE (0.0ms) USE [activerecord_unittest]
EXECUTE (0.0ms) USE [activerecord_unittest]
EXECUTE (0.0ms) BEGIN TRANSACTION
Person Load (1.0ms) SELECT TOP (1) [people].* FROM [people] WITH(HOLDLOCK, ROWLOCK) WHERE ([people].[id] = 1)
EXECUTE (0.0ms) COMMIT TRANSACTION
EXECUTE (0.0ms) USE [activerecord_unittest]
EXECUTE (0.0ms) USE [activerecord_unittest]
EXECUTE (0.0ms) BEGIN TRANSACTION
Person Load (0.0ms) SELECT TOP (1) [people].* FROM [people] WITH(HOLDLOCK, ROWLOCK) WHERE ([people].[id] = 1)
EXECUTE (0.0ms) COMMIT TRANSACTION
EXECUTE (0.0ms) USE [activerecord_unittest]
EXECUTE (1.0ms) USE [activerecord_unittest]
EXECUTE (0.0ms) BEGIN TRANSACTION
Person Load (1.0ms) SELECT TOP (1) [people].* FROM [people] WHERE ([people].[id] = 1)
Person Load (1.0ms) SELECT TOP (1) [people].* FROM [people] WITH(HOLDLOCK, ROWLOCK) WHERE ([people].[id] = 1)
EXECUTE (1.0ms) COMMIT TRANSACTION
EXECUTE (0.0ms) USE [activerecord_unittest]
EXECUTE (0.0ms) USE [activerecord_unittest]
Person Load (1.0ms) SELECT [people].* FROM [people] WITH (NOLOCK)
EXECUTE (0.0ms) USE [activerecord_unittest]
EXECUTE (0.0ms) BEGIN TRANSACTION
SQL (1.0ms) SELECT count(*) AS count_all FROM tasks
EXECUTE (0.0ms) ROLLBACK TRANSACTION
EXECUTE (0.0ms) BEGIN TRANSACTION
EXECUTE (0.0ms) ROLLBACK TRANSACTION
EXECUTE (0.0ms) BEGIN TRANSACTION
SQL (1.0ms) EXEC sp_helpindex [integer_limits]
EXECUTE (1.0ms) ROLLBACK TRANSACTION
EXECUTE (1.0ms) BEGIN TRANSACTION
SQL (1.0ms) EXEC sp_helpindex [movies]
EXECUTE (0.0ms) ROLLBACK TRANSACTION
EXECUTE (0.0ms) BEGIN TRANSACTION
SQL (1.0ms) EXEC sp_helpindex [sql_server_strings]
EXECUTE (1.0ms) ROLLBACK TRANSACTION
EXECUTE (0.0ms) BEGIN TRANSACTION
EXECUTE (0.0ms) ROLLBACK TRANSACTION
EXECUTE (0.0ms) BEGIN TRANSACTION
EXECUTE (0.0ms) SAVE TRANSACTION active_record_1
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
new line.', NULL, N'(NULL)', N'null', N'NULL', N'(null)', N'(3)')
SQL (0.0ms) SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
EXECUTE (0.0ms) ROLLBACK TRANSACTION
EXECUTE (0.0ms) BEGIN TRANSACTION
EXECUTE (0.0ms) ROLLBACK TRANSACTION
EXECUTE (0.0ms) BEGIN TRANSACTION
EXECUTE (0.0ms) SAVE TRANSACTION active_record_1
EXECUTE (1.0ms) INSERT INTO [quoted-table] DEFAULT VALUES
SQL (1.0ms) SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
SqlServerQuotedTable Load (1.0ms) SELECT TOP (1) [quoted-table].* FROM [quoted-table]
EXECUTE (1.0ms) SAVE TRANSACTION active_record_1
EXECUTE (1.0ms) INSERT INTO [quoted-view1] DEFAULT VALUES
SQL (0.0ms) SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
SqlServerQuotedView1 Load (1.0ms) SELECT TOP (1) [quoted-view1].* FROM [quoted-view1]
EXECUTE (0.0ms) SAVE TRANSACTION active_record_1
EXECUTE (1.0ms) INSERT INTO [quoted-view2] DEFAULT VALUES
SQL (0.0ms) SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
SqlServerQuotedView2 Load (0.0ms) SELECT TOP (1) [quoted-view2].* FROM [quoted-view2]
EXECUTE (0.0ms) ROLLBACK TRANSACTION
EXECUTE (0.0ms) BEGIN TRANSACTION
EXECUTE (0.0ms) SAVE TRANSACTION active_record_1
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)
SQL (1.0ms) SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
EXECUTE (0.0ms) SAVE TRANSACTION active_record_1
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)
SQL (1.0ms) SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
SqlServerEdgeSchema Load (2.0ms) SELECT TOP (1) [sql_server_edge_schemas].* FROM [sql_server_edge_schemas] WHERE ([sql_server_edge_schemas].[bigint] = 5000)
SqlServerEdgeSchema Load (1.0ms) SELECT TOP (1) bigint FROM [sql_server_edge_schemas] WHERE ([sql_server_edge_schemas].[bigint] = 5000)
SqlServerEdgeSchema Load (0.0ms) SELECT TOP (1) [sql_server_edge_schemas].* FROM [sql_server_edge_schemas] WHERE ([sql_server_edge_schemas].[bigint] = 9000000000000000000)
SqlServerEdgeSchema Load (1.0ms) SELECT TOP (1) bigint FROM [sql_server_edge_schemas] WHERE ([sql_server_edge_schemas].[bigint] = 9000000000000000000)
EXECUTE (0.0ms) ROLLBACK TRANSACTION
EXECUTE (0.0ms) BEGIN TRANSACTION
EXECUTE (1.0ms) SAVE TRANSACTION active_record_1
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)
SQL (0.0ms) SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
EXECUTE (0.0ms) SAVE TRANSACTION active_record_1
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)
SQL (1.0ms) SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
EXECUTE (0.0ms) SAVE TRANSACTION active_record_1
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)
SQL (0.0ms) SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
SqlServerEdgeSchema Load (1.0ms) SELECT [sql_server_edge_schemas].* FROM [sql_server_edge_schemas] ORDER BY description
SqlServerEdgeSchema Load (1.0ms) SELECT [sql_server_edge_schemas].* FROM [sql_server_edge_schemas] ORDER BY description asc
SqlServerEdgeSchema Load (1.0ms) SELECT [sql_server_edge_schemas].* FROM [sql_server_edge_schemas] ORDER BY description ASC
SqlServerEdgeSchema Load (1.0ms) SELECT [sql_server_edge_schemas].* FROM [sql_server_edge_schemas] ORDER BY description desc
SqlServerEdgeSchema Load (1.0ms) SELECT [sql_server_edge_schemas].* FROM [sql_server_edge_schemas] ORDER BY description DESC
EXECUTE (1.0ms) DELETE FROM [sql_server_edge_schemas]
SQL (0.0ms) SELECT @@ROWCOUNT AS AffectedRows
EXECUTE (1.0ms) ROLLBACK TRANSACTION
EXECUTE (1.0ms) BEGIN TRANSACTION
EXECUTE (0.0ms) SAVE TRANSACTION active_record_1
EXECUTE (1.0ms) INSERT INTO [sql_server_edge_schemas] ([bigint], [description], [guid], [guid_newid], [guid_newseqid], [tinyint]) VALUES (NULL, NULL, NULL, NULL, NULL, 1)
SQL (1.0ms) SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
EXECUTE (0.0ms) SAVE TRANSACTION active_record_1
EXECUTE (1.0ms) INSERT INTO [sql_server_edge_schemas] ([bigint], [description], [guid], [guid_newid], [guid_newseqid], [tinyint]) VALUES (NULL, NULL, NULL, NULL, NULL, 255)
SQL (0.0ms) SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
SqlServerEdgeSchema Load (2.0ms) SELECT TOP (1) [sql_server_edge_schemas].* FROM [sql_server_edge_schemas] WHERE ([sql_server_edge_schemas].[tinyint] = 1)
SqlServerEdgeSchema Load (0.0ms) SELECT TOP (1) [sql_server_edge_schemas].* FROM [sql_server_edge_schemas] WHERE ([sql_server_edge_schemas].[tinyint] = 255)
EXECUTE (0.0ms) ROLLBACK TRANSACTION
EXECUTE (0.0ms) BEGIN TRANSACTION
EXECUTE (0.0ms) SAVE TRANSACTION active_record_1
EXECUTE (1.0ms) INSERT INTO [sql_server_edge_schemas] ([bigint], [description], [guid], [guid_newid], [guid_newseqid], [tinyint]) VALUES (NULL, NULL, NULL, NULL, NULL, 1)
SQL (0.0ms) SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
EXECUTE (0.0ms) SAVE TRANSACTION active_record_1
EXECUTE (0.0ms) INSERT INTO [sql_server_edge_schemas] ([bigint], [description], [guid], [guid_newid], [guid_newseqid], [tinyint]) VALUES (NULL, NULL, NULL, NULL, NULL, 255)
SQL (0.0ms) SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
EXECUTE (0.0ms) SAVE TRANSACTION active_record_1
EXECUTE (1.0ms) INSERT INTO [sql_server_edge_schemas] ([bigint], [description], [guid], [guid_newid], [guid_newseqid], [tinyint]) VALUES (NULL, NULL, NULL, NULL, NULL, 256)
ODBC::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)
EXECUTE (1.0ms) ROLLBACK TRANSACTION active_record_1
EXECUTE (1.0ms) ROLLBACK TRANSACTION
EXECUTE (1.0ms) BEGIN TRANSACTION
SQL (0.0ms) SELECT NEWID()
EXECUTE (0.0ms) SAVE TRANSACTION active_record_1
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)
SQL (0.0ms) SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
SqlServerEdgeSchema Load (2.0ms) SELECT TOP (1) [sql_server_edge_schemas].* FROM [sql_server_edge_schemas] WHERE ([sql_server_edge_schemas].[id] = 11)
EXECUTE (1.0ms) ROLLBACK TRANSACTION
EXECUTE (1.0ms) BEGIN TRANSACTION
SQL (0.0ms) SELECT NEWID()
EXECUTE (1.0ms) ROLLBACK TRANSACTION
EXECUTE (1.0ms) BEGIN TRANSACTION
SQL (0.0ms) SELECT NEWID()
EXECUTE (0.0ms) SAVE TRANSACTION active_record_1
SQL (0.0ms) SELECT NEWID()
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)
SQL (1.0ms) SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
EXECUTE (0.0ms) ROLLBACK TRANSACTION
Order Load (1.0ms) SELECT [orders].* FROM [orders]
EXECUTE (1.0ms) DELETE FROM [ships]
SQL (0.0ms) SELECT @@ROWCOUNT AS AffectedRows
EXECUTE (1.0ms) BEGIN TRANSACTION
EXECUTE (0.0ms) ROLLBACK TRANSACTION
EXECUTE (1.0ms) DELETE FROM [ships]
SQL (0.0ms) SELECT @@ROWCOUNT AS AffectedRows
EXECUTE (1.0ms) BEGIN TRANSACTION
EXECUTE (0.0ms) ROLLBACK TRANSACTION
EXECUTE (0.0ms) DELETE FROM [ships]
SQL (1.0ms) SELECT @@ROWCOUNT AS AffectedRows
EXECUTE (1.0ms) BEGIN TRANSACTION
EXECUTE (0.0ms) ROLLBACK TRANSACTION
EXECUTE (0.0ms) DELETE FROM [ships]
SQL (1.0ms) SELECT @@ROWCOUNT AS AffectedRows
EXECUTE (0.0ms) BEGIN TRANSACTION
EXECUTE (1.0ms) COMMIT TRANSACTION
EXECUTE (0.0ms) DELETE FROM [ships]
SQL (1.0ms) SELECT @@ROWCOUNT AS AffectedRows
EXECUTE (0.0ms) BEGIN TRANSACTION
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)
SQL (0.0ms) SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
EXECUTE (0.0ms) ROLLBACK TRANSACTION
SQL (1.0ms) SELECT COUNT(*) AS count_id FROM [ships]
Ship Load (0.0ms) SELECT [ships].* FROM [ships]
EXECUTE (0.0ms) DELETE FROM [ships]
SQL (0.0ms) SELECT @@ROWCOUNT AS AffectedRows
EXECUTE (1.0ms) BEGIN TRANSACTION
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)
SQL (0.0ms) SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
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)
SQL (0.0ms) SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
EXECUTE (1.0ms) ROLLBACK TRANSACTION
SQL (0.0ms) SELECT COUNT(*) AS count_id FROM [ships]
Ship Load (1.0ms) SELECT [ships].* FROM [ships]
EXECUTE (0.0ms) BEGIN TRANSACTION
EXECUTE (0.0ms) SAVE TRANSACTION active_record_1
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)
ODBC::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)
EXECUTE (1.0ms) ROLLBACK TRANSACTION active_record_1
EXECUTE (1.0ms) ROLLBACK TRANSACTION
EXECUTE (1.0ms) BEGIN TRANSACTION
EXECUTE (0.0ms) SAVE TRANSACTION active_record_1
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)
ODBC::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)
EXECUTE (1.0ms) ROLLBACK TRANSACTION active_record_1
EXECUTE (1.0ms) ROLLBACK TRANSACTION
EXECUTE (1.0ms) BEGIN TRANSACTION
EXECUTE (0.0ms) SAVE TRANSACTION active_record_1
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)
SQL (1.0ms) SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
SqlServerUnicode Load (3.0ms) SELECT TOP (1) [sql_server_unicodes].* FROM [sql_server_unicodes] WHERE ([sql_server_unicodes].[id] = 3)
EXECUTE (0.0ms) ROLLBACK TRANSACTION
EXECUTE (0.0ms) BEGIN TRANSACTION
EXECUTE (0.0ms) SAVE TRANSACTION active_record_1
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)
SQL (0.0ms) SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
SqlServerUnicode Load (1.0ms) SELECT TOP (1) [sql_server_unicodes].* FROM [sql_server_unicodes] WHERE ([sql_server_unicodes].[id] = 4)
EXECUTE (0.0ms) ROLLBACK TRANSACTION
EXECUTE (0.0ms) BEGIN TRANSACTION
EXECUTE (1.0ms) SAVE TRANSACTION active_record_1
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)
SQL (1.0ms) SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
SqlServerUnicode Load (1.0ms) SELECT TOP (1) [sql_server_unicodes].* FROM [sql_server_unicodes] WHERE ([sql_server_unicodes].[id] = 5)
EXECUTE (1.0ms) ROLLBACK TRANSACTION
EXECUTE (0.0ms) BEGIN TRANSACTION
SQL (6.0ms) EXEC sp_helpconstraint 'events','nomsg'
EXECUTE (2.0ms) ALTER TABLE [events] ALTER COLUMN [title] nvarchar(30)
EXECUTE (0.0ms) SAVE TRANSACTION active_record_1
Event Load (2.0ms) SELECT TOP (1) [events].[id] FROM [events] WHERE ([events].[title] COLLATE Latin1_General_CS_AS_WS = N'一二三四五')
EXECUTE (1.0ms) INSERT INTO [events] ([title]) VALUES (N'一二三四五')
SQL (1.0ms) SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident
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)
EXECUTE (0.0ms) SAVE TRANSACTION active_record_1
Event Load (1.0ms) SELECT TOP (1) [events].[id] FROM [events] WHERE ([events].[title] COLLATE Latin1_General_CS_AS_WS = N'一二三四五')
EXECUTE (0.0ms) ROLLBACK TRANSACTION active_record_1
Event Load (0.0ms) SELECT TOP (1) [events].[id] FROM [events] WHERE ([events].[title] COLLATE Latin1_General_CS_AS_WS = N'一二三四五')
EXECUTE (1.0ms) ROLLBACK TRANSACTION
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment