Created
January 6, 2011 14:41
-
-
Save claco/767952 to your computer and use it in GitHub Desktop.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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 -- : [1m[36mEXECUTE (1.0ms)[0m [1mUSE [activerecord_unittest][0m | |
[1m[35mEXECUTE (2.0ms)[0m DROP TABLE [accounts] | |
[1m[36mEXECUTE (1.0ms)[0m [1mCREATE TABLE [accounts] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [firm_id] integer, [firm_name] varchar(255), [credit_limit] integer) [0m | |
[1m[35mEXECUTE (1.0ms)[0m DROP TABLE [admin_accounts] | |
[1m[36mEXECUTE (1.0ms)[0m [1mCREATE TABLE [admin_accounts] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [name] varchar(255)) [0m | |
[1m[35mEXECUTE (1.0ms)[0m DROP TABLE [admin_users] | |
[1m[36mEXECUTE (2.0ms)[0m [1mCREATE TABLE [admin_users] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [name] varchar(255), [account_id] integer) [0m | |
[1m[35mEXECUTE (14.0ms)[0m DROP TABLE [audit_logs] | |
[1m[36mEXECUTE (2.0ms)[0m [1mCREATE TABLE [audit_logs] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [message] varchar(255) NOT NULL, [developer_id] integer NOT NULL) [0m | |
[1m[35mEXECUTE (2.0ms)[0m DROP TABLE [authors] | |
[1m[36mEXECUTE (1.0ms)[0m [1mCREATE 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) [0m | |
[1m[35mEXECUTE (4.0ms)[0m DROP TABLE [author_addresses] | |
[1m[36mEXECUTE (1.0ms)[0m [1mCREATE TABLE [author_addresses] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY) [0m | |
[1m[35mEXECUTE (2.0ms)[0m DROP TABLE [author_favorites] | |
[1m[36mEXECUTE (3.0ms)[0m [1mCREATE TABLE [author_favorites] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [author_id] integer, [favorite_author_id] integer) [0m | |
[1m[35mEXECUTE (2.0ms)[0m DROP TABLE [auto_id_tests] | |
[1m[36mEXECUTE (2.0ms)[0m [1mCREATE TABLE [auto_id_tests] ([auto_id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [value] integer) [0m | |
[1m[35mEXECUTE (5.0ms)[0m DROP TABLE [binaries] | |
[1m[36mEXECUTE (2.0ms)[0m [1mCREATE TABLE [binaries] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [data] varbinary(max)) [0m | |
[1m[35mEXECUTE (2.0ms)[0m DROP TABLE [birds] | |
[1m[36mEXECUTE (2.0ms)[0m [1mCREATE TABLE [birds] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [name] varchar(255), [color] varchar(255), [pirate_id] integer) [0m | |
[1m[35mEXECUTE (1.0ms)[0m DROP TABLE [books] | |
[1m[36mEXECUTE (2.0ms)[0m [1mCREATE TABLE [books] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [name] varchar(255)) [0m | |
[1m[35mEXECUTE (4.0ms)[0m DROP TABLE [booleans] | |
[1m[36mEXECUTE (1.0ms)[0m [1mCREATE TABLE [booleans] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [value] bit) [0m | |
[1m[35mEXECUTE (1.0ms)[0m DROP TABLE [CamelCase] | |
[1m[36mEXECUTE (1.0ms)[0m [1mCREATE TABLE [CamelCase] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [name] varchar(255)) [0m | |
[1m[35mEXECUTE (37.0ms)[0m DROP TABLE [cars] | |
[1m[36mEXECUTE (2.0ms)[0m [1mCREATE TABLE [cars] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [name] varchar(255), [engines_count] integer, [wheels_count] integer) [0m | |
[1m[35mEXECUTE (2.0ms)[0m DROP TABLE [categories] | |
[1m[36mEXECUTE (2.0ms)[0m [1mCREATE TABLE [categories] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [name] varchar(255) NOT NULL, [type] varchar(255), [categorizations_count] integer) [0m | |
[1m[35mEXECUTE (2.0ms)[0m DROP TABLE [categories_posts] | |
[1m[36mEXECUTE (2.0ms)[0m [1mCREATE TABLE [categories_posts] ([category_id] integer NOT NULL, [post_id] integer NOT NULL) [0m | |
[1m[35mEXECUTE (2.0ms)[0m DROP TABLE [categorizations] | |
[1m[36mEXECUTE (2.0ms)[0m [1mCREATE TABLE [categorizations] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [category_id] integer, [post_id] integer, [author_id] integer) [0m | |
[1m[35mEXECUTE (1.0ms)[0m DROP TABLE [citations] | |
[1m[36mEXECUTE (2.0ms)[0m [1mCREATE TABLE [citations] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [book1_id] integer, [book2_id] integer) [0m | |
[1m[35mEXECUTE (1.0ms)[0m DROP TABLE [clubs] | |
[1m[36mEXECUTE (2.0ms)[0m [1mCREATE TABLE [clubs] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [name] varchar(255)) [0m | |
[1m[35mEXECUTE (20.0ms)[0m DROP TABLE [collections] | |
[1m[36mEXECUTE (2.0ms)[0m [1mCREATE TABLE [collections] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [name] varchar(255)) [0m | |
[1m[35mEXECUTE (1.0ms)[0m DROP TABLE [colnametests] | |
[1m[36mEXECUTE (1.0ms)[0m [1mCREATE TABLE [colnametests] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [references] integer NOT NULL) [0m | |
[1m[35mEXECUTE (2.0ms)[0m DROP TABLE [comments] | |
[1m[36mEXECUTE (2.0ms)[0m [1mCREATE TABLE [comments] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [post_id] integer NOT NULL, [body] varchar(max) NOT NULL, [type] varchar(255)) [0m | |
[1m[35mEXECUTE (2.0ms)[0m DROP TABLE [companies] | |
[1m[36mEXECUTE (1.0ms)[0m [1mCREATE 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) [0m | |
[1m[35mSQL (15.0ms)[0m EXEC sp_helpindex [companies] | |
[1m[36mEXECUTE (14.0ms)[0m [1mCREATE INDEX [company_index] ON [companies] ([firm_id], [type], [rating], [ruby_type])[0m | |
[1m[35mEXECUTE (2.0ms)[0m DROP TABLE [computers] | |
[1m[36mEXECUTE (4.0ms)[0m [1mCREATE TABLE [computers] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [developer] integer NOT NULL, [extendedWarranty] integer NOT NULL) [0m | |
[1m[35mEXECUTE (5.0ms)[0m DROP TABLE [contracts] | |
[1m[36mEXECUTE (2.0ms)[0m [1mCREATE TABLE [contracts] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [developer_id] integer, [company_id] integer) [0m | |
[1m[35mEXECUTE (1.0ms)[0m DROP TABLE [customers] | |
[1m[36mEXECUTE (2.0ms)[0m [1mCREATE 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)) [0m | |
[1m[35mEXECUTE (1.0ms)[0m DROP TABLE [dashboards] | |
[1m[36mEXECUTE (2.0ms)[0m [1mCREATE TABLE [dashboards] ([dashboard_id] varchar(255), [name] varchar(255)) [0m | |
[1m[35mEXECUTE (5.0ms)[0m DROP TABLE [developers] | |
[1m[36mEXECUTE (2.0ms)[0m [1mCREATE TABLE [developers] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [name] varchar(255), [salary] integer DEFAULT 70000, [created_at] datetime, [updated_at] datetime) [0m | |
[1m[35mEXECUTE (1.0ms)[0m DROP TABLE [developers_projects] | |
[1m[36mEXECUTE (1.0ms)[0m [1mCREATE TABLE [developers_projects] ([developer_id] integer NOT NULL, [project_id] integer NOT NULL, [joined_on] date, [access_level] integer DEFAULT 1) [0m | |
[1m[35mEXECUTE (76.0ms)[0m DROP TABLE [edges] | |
[1m[36mEXECUTE (2.0ms)[0m [1mCREATE TABLE [edges] ([source_id] integer NOT NULL, [sink_id] integer NOT NULL) [0m | |
[1m[35mSQL (1.0ms)[0m EXEC sp_helpindex [edges] | |
[1m[36mEXECUTE (1.0ms)[0m [1mCREATE UNIQUE INDEX [unique_edge_index] ON [edges] ([source_id], [sink_id])[0m | |
[1m[35mEXECUTE (2.0ms)[0m DROP TABLE [engines] | |
[1m[36mEXECUTE (2.0ms)[0m [1mCREATE TABLE [engines] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [car_id] integer) [0m | |
[1m[35mEXECUTE (2.0ms)[0m DROP TABLE [tyres] | |
[1m[36mEXECUTE (2.0ms)[0m [1mCREATE TABLE [tyres] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [car_id] integer) [0m | |
[1m[35mEXECUTE (2.0ms)[0m DROP TABLE [bulbs] | |
[1m[36mEXECUTE (2.0ms)[0m [1mCREATE TABLE [bulbs] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [car_id] integer, [name] varchar(255)) [0m | |
[1m[35mEXECUTE (2.0ms)[0m DROP TABLE [entrants] | |
[1m[36mEXECUTE (4.0ms)[0m [1mCREATE TABLE [entrants] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [name] varchar(255) NOT NULL, [course_id] integer NOT NULL) [0m | |
[1m[35mEXECUTE (2.0ms)[0m DROP TABLE [essays] | |
[1m[36mEXECUTE (2.0ms)[0m [1mCREATE TABLE [essays] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [name] varchar(255), [writer_id] varchar(255), [writer_type] varchar(255)) [0m | |
[1m[35mEXECUTE (2.0ms)[0m DROP TABLE [events] | |
[1m[36mEXECUTE (2.0ms)[0m [1mCREATE TABLE [events] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [title] varchar(5)) [0m | |
[1m[35mEXECUTE (1.0ms)[0m DROP TABLE [funny_jokes] | |
[1m[36mEXECUTE (1.0ms)[0m [1mCREATE TABLE [funny_jokes] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [name] varchar(255)) [0m | |
[1m[35mEXECUTE (19.0ms)[0m DROP TABLE [goofy_string_id] | |
[1m[36mEXECUTE (2.0ms)[0m [1mCREATE TABLE [goofy_string_id] ([id] varchar(255) NOT NULL, [info] varchar(255)) [0m | |
[1m[35mEXECUTE (1.0ms)[0m DROP TABLE [invoices] | |
[1m[36mEXECUTE (2.0ms)[0m [1mCREATE TABLE [invoices] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [balance] integer, [updated_at] datetime) [0m | |
[1m[35mEXECUTE (2.0ms)[0m DROP TABLE [items] | |
[1m[36mEXECUTE (1.0ms)[0m [1mCREATE TABLE [items] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [name] varchar(255)) [0m | |
[1m[35mEXECUTE (2.0ms)[0m DROP TABLE [inept_wizards] | |
[1m[36mEXECUTE (1.0ms)[0m [1mCREATE 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)) [0m | |
[1m[35mEXECUTE (50.0ms)[0m DROP TABLE [jobs] | |
[1m[36mEXECUTE (3.0ms)[0m [1mCREATE TABLE [jobs] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [ideal_reference_id] integer) [0m | |
[1m[35mEXECUTE (3.0ms)[0m DROP TABLE [keyboards] | |
[1m[36mEXECUTE (2.0ms)[0m [1mCREATE TABLE [keyboards] ([key_number] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [name] varchar(255)) [0m | |
[1m[35mEXECUTE (3.0ms)[0m DROP TABLE [legacy_things] | |
[1m[36mEXECUTE (3.0ms)[0m [1mCREATE TABLE [legacy_things] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [tps_report_number] integer, [version] integer DEFAULT 0 NOT NULL) [0m | |
[1m[35mEXECUTE (2.0ms)[0m DROP TABLE [line_items] | |
[1m[36mEXECUTE (2.0ms)[0m [1mCREATE TABLE [line_items] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [invoice_id] integer, [amount] integer) [0m | |
[1m[35mEXECUTE (1.0ms)[0m DROP TABLE [lock_without_defaults] | |
[1m[36mEXECUTE (75.0ms)[0m [1mCREATE TABLE [lock_without_defaults] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [lock_version] integer) [0m | |
[1m[35mEXECUTE (2.0ms)[0m DROP TABLE [lock_without_defaults_cust] | |
[1m[36mEXECUTE (2.0ms)[0m [1mCREATE TABLE [lock_without_defaults_cust] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [custom_lock_version] integer) [0m | |
[1m[35mEXECUTE (2.0ms)[0m DROP TABLE [mateys] | |
[1m[36mEXECUTE (1.0ms)[0m [1mCREATE TABLE [mateys] ([pirate_id] integer, [target_id] integer, [weight] integer) [0m | |
[1m[35mEXECUTE (1.0ms)[0m DROP TABLE [members] | |
[1m[36mEXECUTE (2.0ms)[0m [1mCREATE TABLE [members] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [name] varchar(255), [member_type_id] integer) [0m | |
[1m[35mEXECUTE (2.0ms)[0m DROP TABLE [member_details] | |
[1m[36mEXECUTE (2.0ms)[0m [1mCREATE TABLE [member_details] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [member_id] integer, [organization_id] integer, [extra_data] varchar(255)) [0m | |
[1m[35mEXECUTE (2.0ms)[0m DROP TABLE [memberships] | |
[1m[36mEXECUTE (2.0ms)[0m [1mCREATE 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)) [0m | |
[1m[35mEXECUTE (1.0ms)[0m DROP TABLE [member_types] | |
[1m[36mEXECUTE (1.0ms)[0m [1mCREATE TABLE [member_types] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [name] varchar(255)) [0m | |
[1m[35mEXECUTE (1.0ms)[0m DROP TABLE [references] | |
[1m[36mEXECUTE (2.0ms)[0m [1mCREATE TABLE [references] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [person_id] integer, [job_id] integer, [favourite] bit, [lock_version] integer DEFAULT 0) [0m | |
[1m[35mEXECUTE (1.0ms)[0m DROP TABLE [minivans] | |
[1m[36mEXECUTE (1.0ms)[0m [1mCREATE TABLE [minivans] ([minivan_id] varchar(255), [name] varchar(255), [speedometer_id] varchar(255), [color] varchar(255)) [0m | |
[1m[35mEXECUTE (2.0ms)[0m DROP TABLE [minimalistics] | |
[1m[36mEXECUTE (2.0ms)[0m [1mCREATE TABLE [minimalistics] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY) [0m | |
[1m[35mEXECUTE (1.0ms)[0m DROP TABLE [mixed_case_monkeys] | |
[1m[36mEXECUTE (1.0ms)[0m [1mCREATE TABLE [mixed_case_monkeys] ([monkeyID] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [fleaCount] integer) [0m | |
[1m[35mEXECUTE (1.0ms)[0m DROP TABLE [mixins] | |
[1m[36mEXECUTE (2.0ms)[0m [1mCREATE 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)) [0m | |
[1m[35mEXECUTE (2.0ms)[0m DROP TABLE [movies] | |
[1m[36mEXECUTE (1.0ms)[0m [1mCREATE TABLE [movies] ([movieid] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [name] varchar(255)) [0m | |
[1m[35mEXECUTE (2.0ms)[0m DROP TABLE [numeric_data] | |
[1m[36mEXECUTE (4.0ms)[0m [1mCREATE 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)) [0m | |
[1m[35mEXECUTE (2.0ms)[0m DROP TABLE [orders] | |
[1m[36mEXECUTE (3.0ms)[0m [1mCREATE TABLE [orders] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [name] varchar(255), [billing_customer_id] integer, [shipping_customer_id] integer) [0m | |
[1m[35mEXECUTE (4.0ms)[0m DROP TABLE [organizations] | |
[1m[36mEXECUTE (5.0ms)[0m [1mCREATE TABLE [organizations] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [name] varchar(255)) [0m | |
[1m[35mEXECUTE (3.0ms)[0m DROP TABLE [owners] | |
[1m[36mEXECUTE (2.0ms)[0m [1mCREATE TABLE [owners] ([owner_id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [name] varchar(255), [updated_at] datetime, [happy_at] datetime) [0m | |
[1m[35mEXECUTE (1.0ms)[0m DROP TABLE [paint_colors] | |
[1m[36mEXECUTE (2.0ms)[0m [1mCREATE TABLE [paint_colors] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [non_poly_one_id] integer) [0m | |
[1m[35mEXECUTE (1.0ms)[0m DROP TABLE [paint_textures] | |
[1m[36mEXECUTE (2.0ms)[0m [1mCREATE TABLE [paint_textures] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [non_poly_two_id] integer) [0m | |
[1m[35mEXECUTE (2.0ms)[0m DROP TABLE [parrots] | |
[1m[36mEXECUTE (2.0ms)[0m [1mCREATE 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) [0m | |
[1m[35mEXECUTE (2.0ms)[0m DROP TABLE [parrots_pirates] | |
[1m[36mEXECUTE (37.0ms)[0m [1mCREATE TABLE [parrots_pirates] ([parrot_id] integer, [pirate_id] integer) [0m | |
[1m[35mEXECUTE (2.0ms)[0m DROP TABLE [parrots_treasures] | |
[1m[36mEXECUTE (2.0ms)[0m [1mCREATE TABLE [parrots_treasures] ([parrot_id] integer, [treasure_id] integer) [0m | |
[1m[35mEXECUTE (1.0ms)[0m DROP TABLE [people] | |
[1m[36mEXECUTE (1.0ms)[0m [1mCREATE 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) [0m | |
[1m[35mEXECUTE (1.0ms)[0m DROP TABLE [pets] | |
[1m[36mEXECUTE (2.0ms)[0m [1mCREATE 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) [0m | |
[1m[35mEXECUTE (2.0ms)[0m DROP TABLE [pirates] | |
[1m[36mEXECUTE (1.0ms)[0m [1mCREATE TABLE [pirates] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [catchphrase] varchar(255), [parrot_id] integer, [created_on] datetime, [updated_on] datetime) [0m | |
[1m[35mEXECUTE (1.0ms)[0m DROP TABLE [posts] | |
[1m[36mEXECUTE (2.0ms)[0m [1mCREATE 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) [0m | |
[1m[35mEXECUTE (1.0ms)[0m DROP TABLE [price_estimates] | |
[1m[36mEXECUTE (1.0ms)[0m [1mCREATE TABLE [price_estimates] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [estimate_of_type] varchar(255), [estimate_of_id] integer, [price] integer) [0m | |
[1m[35mEXECUTE (1.0ms)[0m DROP TABLE [products] | |
[1m[36mEXECUTE (2.0ms)[0m [1mCREATE TABLE [products] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [collection_id] integer, [name] varchar(255)) [0m | |
[1m[35mEXECUTE (1.0ms)[0m DROP TABLE [projects] | |
[1m[36mEXECUTE (2.0ms)[0m [1mCREATE TABLE [projects] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [name] varchar(255), [type] varchar(255)) [0m | |
[1m[35mEXECUTE (2.0ms)[0m DROP TABLE [readers] | |
[1m[36mEXECUTE (2.0ms)[0m [1mCREATE 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) [0m | |
[1m[35mEXECUTE (4.0ms)[0m DROP TABLE [shape_expressions] | |
[1m[36mEXECUTE (2.0ms)[0m [1mCREATE 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) [0m | |
[1m[35mEXECUTE (2.0ms)[0m DROP TABLE [ships] | |
[1m[36mEXECUTE (1.0ms)[0m [1mCREATE 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) [0m | |
[1m[35mEXECUTE (2.0ms)[0m DROP TABLE [ship_parts] | |
[1m[36mEXECUTE (2.0ms)[0m [1mCREATE TABLE [ship_parts] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [name] varchar(255), [ship_id] integer) [0m | |
[1m[35mEXECUTE (4.0ms)[0m DROP TABLE [speedometers] | |
[1m[36mEXECUTE (1.0ms)[0m [1mCREATE TABLE [speedometers] ([speedometer_id] varchar(255), [name] varchar(255), [dashboard_id] varchar(255)) [0m | |
[1m[35mEXECUTE (2.0ms)[0m DROP TABLE [sponsors] | |
[1m[36mEXECUTE (3.0ms)[0m [1mCREATE TABLE [sponsors] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [club_id] integer, [sponsorable_id] integer, [sponsorable_type] varchar(255)) [0m | |
[1m[35mEXECUTE (1.0ms)[0m DROP TABLE [subscribers] | |
[1m[36mEXECUTE (2.0ms)[0m [1mCREATE TABLE [subscribers] ([nick] varchar(255) NOT NULL, [name] varchar(255)) [0m | |
[1m[35mSQL (0.0ms)[0m EXEC sp_helpindex [subscribers] | |
[1m[36mEXECUTE (1.0ms)[0m [1mCREATE UNIQUE INDEX [index_subscribers_on_nick] ON [subscribers] ([nick])[0m | |
[1m[35mEXECUTE (2.0ms)[0m DROP TABLE [subscriptions] | |
[1m[36mEXECUTE (1.0ms)[0m [1mCREATE TABLE [subscriptions] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [subscriber_id] varchar(255), [book_id] integer) [0m | |
[1m[35mEXECUTE (6.0ms)[0m DROP TABLE [tasks] | |
[1m[36mEXECUTE (2.0ms)[0m [1mCREATE TABLE [tasks] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [starting] datetime, [ending] datetime) [0m | |
[1m[35mEXECUTE (76.0ms)[0m DROP TABLE [topics] | |
[1m[36mEXECUTE (4.0ms)[0m [1mCREATE 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)) [0m | |
[1m[35mEXECUTE (2.0ms)[0m DROP TABLE [taggings] | |
[1m[36mEXECUTE (2.0ms)[0m [1mCREATE 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) [0m | |
[1m[35mEXECUTE (2.0ms)[0m DROP TABLE [tags] | |
[1m[36mEXECUTE (2.0ms)[0m [1mCREATE TABLE [tags] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [name] varchar(255), [taggings_count] integer DEFAULT 0) [0m | |
[1m[35mEXECUTE (2.0ms)[0m DROP TABLE [toys] | |
[1m[36mEXECUTE (2.0ms)[0m [1mCREATE 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) [0m | |
[1m[35mEXECUTE (1.0ms)[0m DROP TABLE [traffic_lights] | |
[1m[36mEXECUTE (2.0ms)[0m [1mCREATE TABLE [traffic_lights] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [location] varchar(255), [state] varchar(255), [created_at] datetime, [updated_at] datetime) [0m | |
[1m[35mEXECUTE (2.0ms)[0m DROP TABLE [treasures] | |
[1m[36mEXECUTE (2.0ms)[0m [1mCREATE TABLE [treasures] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [name] varchar(255), [looter_id] integer, [looter_type] varchar(255)) [0m | |
[1m[35mEXECUTE (2.0ms)[0m DROP TABLE [variants] | |
[1m[36mEXECUTE (2.0ms)[0m [1mCREATE TABLE [variants] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [product_id] integer, [name] varchar(255)) [0m | |
[1m[35mEXECUTE (2.0ms)[0m DROP TABLE [vertices] | |
[1m[36mEXECUTE (1.0ms)[0m [1mCREATE TABLE [vertices] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [label] varchar(255)) [0m | |
[1m[35mEXECUTE (5.0ms)[0m DROP TABLE [warehouse-things] | |
[1m[36mEXECUTE (3.0ms)[0m [1mCREATE TABLE [warehouse-things] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [value] integer) [0m | |
[1m[35mEXECUTE (1.0ms)[0m DROP TABLE [circles] | |
[1m[36mEXECUTE (16.0ms)[0m [1mCREATE TABLE [circles] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY) [0m | |
[1m[35mEXECUTE (3.0ms)[0m DROP TABLE [squares] | |
[1m[36mEXECUTE (3.0ms)[0m [1mCREATE TABLE [squares] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY) [0m | |
[1m[35mEXECUTE (2.0ms)[0m DROP TABLE [triangles] | |
[1m[36mEXECUTE (2.0ms)[0m [1mCREATE TABLE [triangles] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY) [0m | |
[1m[35mEXECUTE (2.0ms)[0m DROP TABLE [non_poly_ones] | |
[1m[36mEXECUTE (3.0ms)[0m [1mCREATE TABLE [non_poly_ones] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY) [0m | |
[1m[35mEXECUTE (3.0ms)[0m DROP TABLE [non_poly_twos] | |
[1m[36mEXECUTE (3.0ms)[0m [1mCREATE TABLE [non_poly_twos] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY) [0m | |
[1m[35mEXECUTE (2.0ms)[0m DROP TABLE [guids] | |
[1m[36mEXECUTE (2.0ms)[0m [1mCREATE TABLE [guids] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [key] varchar(255)) [0m | |
[1m[35mEXECUTE (42.0ms)[0m DROP TABLE [integer_limits] | |
[1m[36mEXECUTE (3.0ms)[0m [1mCREATE 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) [0m | |
[1m[35mEXECUTE (2.0ms)[0m DROP TABLE [men] | |
[1m[36mEXECUTE (2.0ms)[0m [1mCREATE TABLE [men] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [name] varchar(255)) [0m | |
[1m[35mEXECUTE (3.0ms)[0m DROP TABLE [faces] | |
[1m[36mEXECUTE (2.0ms)[0m [1mCREATE 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)) [0m | |
[1m[35mEXECUTE (2.0ms)[0m DROP TABLE [interests] | |
[1m[36mEXECUTE (2.0ms)[0m [1mCREATE 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) [0m | |
[1m[35mEXECUTE (2.0ms)[0m DROP TABLE [wheels] | |
[1m[36mEXECUTE (2.0ms)[0m [1mCREATE TABLE [wheels] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [wheelable_id] integer, [wheelable_type] varchar(255)) [0m | |
[1m[35mEXECUTE (2.0ms)[0m DROP TABLE [zines] | |
[1m[36mEXECUTE (2.0ms)[0m [1mCREATE TABLE [zines] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [title] varchar(255)) [0m | |
[1m[35mEXECUTE (2.0ms)[0m DROP TABLE [countries] | |
[1m[36mEXECUTE (2.0ms)[0m [1mCREATE TABLE [countries] ([country_id] varchar(255), [name] varchar(255)) [0m | |
[1m[35mEXECUTE (1.0ms)[0m DROP TABLE [treaties] | |
[1m[36mEXECUTE (2.0ms)[0m [1mCREATE TABLE [treaties] ([treaty_id] varchar(255), [name] varchar(255)) [0m | |
[1m[35mEXECUTE (3.0ms)[0m DROP TABLE [countries_treaties] | |
[1m[36mEXECUTE (2.0ms)[0m [1mCREATE TABLE [countries_treaties] ([country_id] varchar(255) NOT NULL, [treaty_id] varchar(255) NOT NULL, [created_at] datetime, [updated_at] datetime) [0m | |
[1m[35mEXECUTE (1.0ms)[0m DROP TABLE [liquid] | |
[1m[36mEXECUTE (1.0ms)[0m [1mCREATE TABLE [liquid] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [name] varchar(255)) [0m | |
[1m[35mEXECUTE (1.0ms)[0m DROP TABLE [molecules] | |
[1m[36mEXECUTE (2.0ms)[0m [1mCREATE TABLE [molecules] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [liquid_id] integer, [name] varchar(255)) [0m | |
[1m[35mEXECUTE (1.0ms)[0m DROP TABLE [electrons] | |
[1m[36mEXECUTE (2.0ms)[0m [1mCREATE TABLE [electrons] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [molecule_id] integer, [name] varchar(255)) [0m | |
[1m[35mEXECUTE (78.0ms)[0m DROP TABLE [fk_test_has_fk] | |
[1m[36mEXECUTE (6.0ms)[0m [1mCREATE TABLE [fk_test_has_fk] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [fk_id] integer NOT NULL) [0m | |
[1m[35mEXECUTE (2.0ms)[0m DROP TABLE [fk_test_has_pk] | |
[1m[36mEXECUTE (3.0ms)[0m [1mCREATE TABLE [fk_test_has_pk] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY) [0m | |
[1m[35mEXECUTE (3.0ms)[0m ALTER TABLE fk_test_has_fk ADD CONSTRAINT fk_name FOREIGN KEY ([fk_id]) REFERENCES [fk_test_has_pk] ([id]) | |
[1m[36mEXECUTE (1.0ms)[0m [1mUSE [activerecord_unittest2][0m | |
[1m[35mEXECUTE (11.0ms)[0m DROP TABLE [courses] | |
[1m[36mEXECUTE (2.0ms)[0m [1mCREATE TABLE [courses] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [name] varchar(255) NOT NULL) [0m | |
[1m[35mEXECUTE (7.0ms)[0m DROP TABLE [accounts] | |
[1m[36mEXECUTE (1.0ms)[0m [1mCREATE TABLE [accounts] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [firm_id] integer, [firm_name] varchar(255), [credit_limit] integer) [0m | |
[1m[35mEXECUTE (1.0ms)[0m DROP TABLE [admin_accounts] | |
[1m[36mEXECUTE (1.0ms)[0m [1mCREATE TABLE [admin_accounts] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [name] varchar(255)) [0m | |
[1m[35mEXECUTE (1.0ms)[0m DROP TABLE [admin_users] | |
[1m[36mEXECUTE (1.0ms)[0m [1mCREATE TABLE [admin_users] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [name] varchar(255), [account_id] integer) [0m | |
[1m[35mEXECUTE (1.0ms)[0m DROP TABLE [audit_logs] | |
[1m[36mEXECUTE (1.0ms)[0m [1mCREATE TABLE [audit_logs] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [message] varchar(255) NOT NULL, [developer_id] integer NOT NULL) [0m | |
[1m[35mEXECUTE (6.0ms)[0m DROP TABLE [authors] | |
[1m[36mEXECUTE (2.0ms)[0m [1mCREATE 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) [0m | |
[1m[35mEXECUTE (1.0ms)[0m DROP TABLE [author_addresses] | |
[1m[36mEXECUTE (3.0ms)[0m [1mCREATE TABLE [author_addresses] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY) [0m | |
[1m[35mEXECUTE (2.0ms)[0m DROP TABLE [author_favorites] | |
[1m[36mEXECUTE (2.0ms)[0m [1mCREATE TABLE [author_favorites] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [author_id] integer, [favorite_author_id] integer) [0m | |
[1m[35mEXECUTE (2.0ms)[0m DROP TABLE [auto_id_tests] | |
[1m[36mEXECUTE (3.0ms)[0m [1mCREATE TABLE [auto_id_tests] ([auto_id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [value] integer) [0m | |
[1m[35mEXECUTE (2.0ms)[0m DROP TABLE [binaries] | |
[1m[36mEXECUTE (2.0ms)[0m [1mCREATE TABLE [binaries] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [data] varbinary(max)) [0m | |
[1m[35mEXECUTE (1.0ms)[0m DROP TABLE [birds] | |
[1m[36mEXECUTE (5.0ms)[0m [1mCREATE TABLE [birds] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [name] varchar(255), [color] varchar(255), [pirate_id] integer) [0m | |
[1m[35mEXECUTE (3.0ms)[0m DROP TABLE [books] | |
[1m[36mEXECUTE (2.0ms)[0m [1mCREATE TABLE [books] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [name] varchar(255)) [0m | |
[1m[35mEXECUTE (2.0ms)[0m DROP TABLE [booleans] | |
[1m[36mEXECUTE (1.0ms)[0m [1mCREATE TABLE [booleans] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [value] bit) [0m | |
[1m[35mEXECUTE (2.0ms)[0m DROP TABLE [CamelCase] | |
[1m[36mEXECUTE (2.0ms)[0m [1mCREATE TABLE [CamelCase] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [name] varchar(255)) [0m | |
[1m[35mEXECUTE (63.0ms)[0m DROP TABLE [cars] | |
[1m[36mEXECUTE (2.0ms)[0m [1mCREATE TABLE [cars] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [name] varchar(255), [engines_count] integer, [wheels_count] integer) [0m | |
[1m[35mEXECUTE (2.0ms)[0m DROP TABLE [categories] | |
[1m[36mEXECUTE (2.0ms)[0m [1mCREATE TABLE [categories] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [name] varchar(255) NOT NULL, [type] varchar(255), [categorizations_count] integer) [0m | |
[1m[35mEXECUTE (2.0ms)[0m DROP TABLE [categories_posts] | |
[1m[36mEXECUTE (2.0ms)[0m [1mCREATE TABLE [categories_posts] ([category_id] integer NOT NULL, [post_id] integer NOT NULL) [0m | |
[1m[35mEXECUTE (2.0ms)[0m DROP TABLE [categorizations] | |
[1m[36mEXECUTE (3.0ms)[0m [1mCREATE TABLE [categorizations] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [category_id] integer, [post_id] integer, [author_id] integer) [0m | |
[1m[35mEXECUTE (2.0ms)[0m DROP TABLE [citations] | |
[1m[36mEXECUTE (2.0ms)[0m [1mCREATE TABLE [citations] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [book1_id] integer, [book2_id] integer) [0m | |
[1m[35mEXECUTE (2.0ms)[0m DROP TABLE [clubs] | |
[1m[36mEXECUTE (2.0ms)[0m [1mCREATE TABLE [clubs] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [name] varchar(255)) [0m | |
[1m[35mEXECUTE (1.0ms)[0m DROP TABLE [collections] | |
[1m[36mEXECUTE (2.0ms)[0m [1mCREATE TABLE [collections] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [name] varchar(255)) [0m | |
[1m[35mEXECUTE (2.0ms)[0m DROP TABLE [colnametests] | |
[1m[36mEXECUTE (1.0ms)[0m [1mCREATE TABLE [colnametests] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [references] integer NOT NULL) [0m | |
[1m[35mEXECUTE (1.0ms)[0m DROP TABLE [comments] | |
[1m[36mEXECUTE (2.0ms)[0m [1mCREATE TABLE [comments] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [post_id] integer NOT NULL, [body] varchar(max) NOT NULL, [type] varchar(255)) [0m | |
[1m[35mEXECUTE (2.0ms)[0m DROP TABLE [companies] | |
[1m[36mEXECUTE (2.0ms)[0m [1mCREATE 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) [0m | |
[1m[35mSQL (12.0ms)[0m EXEC sp_helpindex [companies] | |
[1m[36mEXECUTE (1.0ms)[0m [1mCREATE INDEX [company_index] ON [companies] ([firm_id], [type], [rating], [ruby_type])[0m | |
[1m[35mEXECUTE (1.0ms)[0m DROP TABLE [computers] | |
[1m[36mEXECUTE (1.0ms)[0m [1mCREATE TABLE [computers] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [developer] integer NOT NULL, [extendedWarranty] integer NOT NULL) [0m | |
[1m[35mEXECUTE (4.0ms)[0m DROP TABLE [contracts] | |
[1m[36mEXECUTE (3.0ms)[0m [1mCREATE TABLE [contracts] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [developer_id] integer, [company_id] integer) [0m | |
[1m[35mEXECUTE (2.0ms)[0m DROP TABLE [customers] | |
[1m[36mEXECUTE (5.0ms)[0m [1mCREATE 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)) [0m | |
[1m[35mEXECUTE (1.0ms)[0m DROP TABLE [dashboards] | |
[1m[36mEXECUTE (5.0ms)[0m [1mCREATE TABLE [dashboards] ([dashboard_id] varchar(255), [name] varchar(255)) [0m | |
[1m[35mEXECUTE (1.0ms)[0m DROP TABLE [developers] | |
[1m[36mEXECUTE (1.0ms)[0m [1mCREATE TABLE [developers] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [name] varchar(255), [salary] integer DEFAULT 70000, [created_at] datetime, [updated_at] datetime) [0m | |
[1m[35mEXECUTE (1.0ms)[0m DROP TABLE [developers_projects] | |
[1m[36mEXECUTE (3.0ms)[0m [1mCREATE TABLE [developers_projects] ([developer_id] integer NOT NULL, [project_id] integer NOT NULL, [joined_on] date, [access_level] integer DEFAULT 1) [0m | |
[1m[35mEXECUTE (3.0ms)[0m DROP TABLE [edges] | |
[1m[36mEXECUTE (1.0ms)[0m [1mCREATE TABLE [edges] ([source_id] integer NOT NULL, [sink_id] integer NOT NULL) [0m | |
[1m[35mSQL (1.0ms)[0m EXEC sp_helpindex [edges] | |
[1m[36mEXECUTE (1.0ms)[0m [1mCREATE UNIQUE INDEX [unique_edge_index] ON [edges] ([source_id], [sink_id])[0m | |
[1m[35mEXECUTE (4.0ms)[0m DROP TABLE [engines] | |
[1m[36mEXECUTE (1.0ms)[0m [1mCREATE TABLE [engines] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [car_id] integer) [0m | |
[1m[35mEXECUTE (1.0ms)[0m DROP TABLE [tyres] | |
[1m[36mEXECUTE (1.0ms)[0m [1mCREATE TABLE [tyres] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [car_id] integer) [0m | |
[1m[35mEXECUTE (1.0ms)[0m DROP TABLE [bulbs] | |
[1m[36mEXECUTE (1.0ms)[0m [1mCREATE TABLE [bulbs] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [car_id] integer, [name] varchar(255)) [0m | |
[1m[35mEXECUTE (7.0ms)[0m DROP TABLE [entrants] | |
[1m[36mEXECUTE (2.0ms)[0m [1mCREATE TABLE [entrants] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [name] varchar(255) NOT NULL, [course_id] integer NOT NULL) [0m | |
[1m[35mEXECUTE (7.0ms)[0m DROP TABLE [essays] | |
[1m[36mEXECUTE (1.0ms)[0m [1mCREATE TABLE [essays] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [name] varchar(255), [writer_id] varchar(255), [writer_type] varchar(255)) [0m | |
[1m[35mEXECUTE (1.0ms)[0m DROP TABLE [events] | |
[1m[36mEXECUTE (2.0ms)[0m [1mCREATE TABLE [events] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [title] varchar(5)) [0m | |
[1m[35mEXECUTE (2.0ms)[0m DROP TABLE [funny_jokes] | |
[1m[36mEXECUTE (1.0ms)[0m [1mCREATE TABLE [funny_jokes] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [name] varchar(255)) [0m | |
[1m[35mEXECUTE (1.0ms)[0m DROP TABLE [goofy_string_id] | |
[1m[36mEXECUTE (1.0ms)[0m [1mCREATE TABLE [goofy_string_id] ([id] varchar(255) NOT NULL, [info] varchar(255)) [0m | |
[1m[35mEXECUTE (1.0ms)[0m DROP TABLE [invoices] | |
[1m[36mEXECUTE (2.0ms)[0m [1mCREATE TABLE [invoices] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [balance] integer, [updated_at] datetime) [0m | |
[1m[35mEXECUTE (2.0ms)[0m DROP TABLE [items] | |
[1m[36mEXECUTE (1.0ms)[0m [1mCREATE TABLE [items] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [name] varchar(255)) [0m | |
[1m[35mEXECUTE (1.0ms)[0m DROP TABLE [inept_wizards] | |
[1m[36mEXECUTE (2.0ms)[0m [1mCREATE 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)) [0m | |
[1m[35mEXECUTE (1.0ms)[0m DROP TABLE [jobs] | |
[1m[36mEXECUTE (1.0ms)[0m [1mCREATE TABLE [jobs] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [ideal_reference_id] integer) [0m | |
[1m[35mEXECUTE (2.0ms)[0m DROP TABLE [keyboards] | |
[1m[36mEXECUTE (1.0ms)[0m [1mCREATE TABLE [keyboards] ([key_number] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [name] varchar(255)) [0m | |
[1m[35mEXECUTE (1.0ms)[0m DROP TABLE [legacy_things] | |
[1m[36mEXECUTE (2.0ms)[0m [1mCREATE TABLE [legacy_things] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [tps_report_number] integer, [version] integer DEFAULT 0 NOT NULL) [0m | |
[1m[35mEXECUTE (4.0ms)[0m DROP TABLE [line_items] | |
[1m[36mEXECUTE (3.0ms)[0m [1mCREATE TABLE [line_items] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [invoice_id] integer, [amount] integer) [0m | |
[1m[35mEXECUTE (2.0ms)[0m DROP TABLE [lock_without_defaults] | |
[1m[36mEXECUTE (3.0ms)[0m [1mCREATE TABLE [lock_without_defaults] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [lock_version] integer) [0m | |
[1m[35mEXECUTE (1.0ms)[0m DROP TABLE [lock_without_defaults_cust] | |
[1m[36mEXECUTE (2.0ms)[0m [1mCREATE TABLE [lock_without_defaults_cust] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [custom_lock_version] integer) [0m | |
[1m[35mEXECUTE (2.0ms)[0m DROP TABLE [mateys] | |
[1m[36mEXECUTE (1.0ms)[0m [1mCREATE TABLE [mateys] ([pirate_id] integer, [target_id] integer, [weight] integer) [0m | |
[1m[35mEXECUTE (1.0ms)[0m DROP TABLE [members] | |
[1m[36mEXECUTE (2.0ms)[0m [1mCREATE TABLE [members] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [name] varchar(255), [member_type_id] integer) [0m | |
[1m[35mEXECUTE (1.0ms)[0m DROP TABLE [member_details] | |
[1m[36mEXECUTE (2.0ms)[0m [1mCREATE TABLE [member_details] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [member_id] integer, [organization_id] integer, [extra_data] varchar(255)) [0m | |
[1m[35mEXECUTE (1.0ms)[0m DROP TABLE [memberships] | |
[1m[36mEXECUTE (84.0ms)[0m [1mCREATE 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)) [0m | |
[1m[35mEXECUTE (2.0ms)[0m DROP TABLE [member_types] | |
[1m[36mEXECUTE (3.0ms)[0m [1mCREATE TABLE [member_types] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [name] varchar(255)) [0m | |
[1m[35mEXECUTE (3.0ms)[0m DROP TABLE [references] | |
[1m[36mEXECUTE (3.0ms)[0m [1mCREATE TABLE [references] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [person_id] integer, [job_id] integer, [favourite] bit, [lock_version] integer DEFAULT 0) [0m | |
[1m[35mEXECUTE (2.0ms)[0m DROP TABLE [minivans] | |
[1m[36mEXECUTE (2.0ms)[0m [1mCREATE TABLE [minivans] ([minivan_id] varchar(255), [name] varchar(255), [speedometer_id] varchar(255), [color] varchar(255)) [0m | |
[1m[35mEXECUTE (1.0ms)[0m DROP TABLE [minimalistics] | |
[1m[36mEXECUTE (2.0ms)[0m [1mCREATE TABLE [minimalistics] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY) [0m | |
[1m[35mEXECUTE (2.0ms)[0m DROP TABLE [mixed_case_monkeys] | |
[1m[36mEXECUTE (1.0ms)[0m [1mCREATE TABLE [mixed_case_monkeys] ([monkeyID] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [fleaCount] integer) [0m | |
[1m[35mEXECUTE (2.0ms)[0m DROP TABLE [mixins] | |
[1m[36mEXECUTE (2.0ms)[0m [1mCREATE 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)) [0m | |
[1m[35mEXECUTE (2.0ms)[0m DROP TABLE [movies] | |
[1m[36mEXECUTE (1.0ms)[0m [1mCREATE TABLE [movies] ([movieid] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [name] varchar(255)) [0m | |
[1m[35mEXECUTE (1.0ms)[0m DROP TABLE [numeric_data] | |
[1m[36mEXECUTE (4.0ms)[0m [1mCREATE 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)) [0m | |
[1m[35mEXECUTE (3.0ms)[0m DROP TABLE [orders] | |
[1m[36mEXECUTE (3.0ms)[0m [1mCREATE TABLE [orders] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [name] varchar(255), [billing_customer_id] integer, [shipping_customer_id] integer) [0m | |
[1m[35mEXECUTE (3.0ms)[0m DROP TABLE [organizations] | |
[1m[36mEXECUTE (1.0ms)[0m [1mCREATE TABLE [organizations] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [name] varchar(255)) [0m | |
[1m[35mEXECUTE (2.0ms)[0m DROP TABLE [owners] | |
[1m[36mEXECUTE (3.0ms)[0m [1mCREATE TABLE [owners] ([owner_id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [name] varchar(255), [updated_at] datetime, [happy_at] datetime) [0m | |
[1m[35mEXECUTE (1.0ms)[0m DROP TABLE [paint_colors] | |
[1m[36mEXECUTE (2.0ms)[0m [1mCREATE TABLE [paint_colors] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [non_poly_one_id] integer) [0m | |
[1m[35mEXECUTE (2.0ms)[0m DROP TABLE [paint_textures] | |
[1m[36mEXECUTE (1.0ms)[0m [1mCREATE TABLE [paint_textures] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [non_poly_two_id] integer) [0m | |
[1m[35mEXECUTE (1.0ms)[0m DROP TABLE [parrots] | |
[1m[36mEXECUTE (1.0ms)[0m [1mCREATE 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) [0m | |
[1m[35mEXECUTE (2.0ms)[0m DROP TABLE [parrots_pirates] | |
[1m[36mEXECUTE (1.0ms)[0m [1mCREATE TABLE [parrots_pirates] ([parrot_id] integer, [pirate_id] integer) [0m | |
[1m[35mEXECUTE (31.0ms)[0m DROP TABLE [parrots_treasures] | |
[1m[36mEXECUTE (2.0ms)[0m [1mCREATE TABLE [parrots_treasures] ([parrot_id] integer, [treasure_id] integer) [0m | |
[1m[35mEXECUTE (2.0ms)[0m DROP TABLE [people] | |
[1m[36mEXECUTE (3.0ms)[0m [1mCREATE 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) [0m | |
[1m[35mEXECUTE (2.0ms)[0m DROP TABLE [pets] | |
[1m[36mEXECUTE (2.0ms)[0m [1mCREATE 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) [0m | |
[1m[35mEXECUTE (2.0ms)[0m DROP TABLE [pirates] | |
[1m[36mEXECUTE (3.0ms)[0m [1mCREATE TABLE [pirates] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [catchphrase] varchar(255), [parrot_id] integer, [created_on] datetime, [updated_on] datetime) [0m | |
[1m[35mEXECUTE (2.0ms)[0m DROP TABLE [posts] | |
[1m[36mEXECUTE (2.0ms)[0m [1mCREATE 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) [0m | |
[1m[35mEXECUTE (1.0ms)[0m DROP TABLE [price_estimates] | |
[1m[36mEXECUTE (1.0ms)[0m [1mCREATE TABLE [price_estimates] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [estimate_of_type] varchar(255), [estimate_of_id] integer, [price] integer) [0m | |
[1m[35mEXECUTE (1.0ms)[0m DROP TABLE [products] | |
[1m[36mEXECUTE (1.0ms)[0m [1mCREATE TABLE [products] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [collection_id] integer, [name] varchar(255)) [0m | |
[1m[35mEXECUTE (1.0ms)[0m DROP TABLE [projects] | |
[1m[36mEXECUTE (2.0ms)[0m [1mCREATE TABLE [projects] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [name] varchar(255), [type] varchar(255)) [0m | |
[1m[35mEXECUTE (2.0ms)[0m DROP TABLE [readers] | |
[1m[36mEXECUTE (2.0ms)[0m [1mCREATE 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) [0m | |
[1m[35mEXECUTE (1.0ms)[0m DROP TABLE [shape_expressions] | |
[1m[36mEXECUTE (1.0ms)[0m [1mCREATE 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) [0m | |
[1m[35mEXECUTE (2.0ms)[0m DROP TABLE [ships] | |
[1m[36mEXECUTE (2.0ms)[0m [1mCREATE 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) [0m | |
[1m[35mEXECUTE (2.0ms)[0m DROP TABLE [ship_parts] | |
[1m[36mEXECUTE (4.0ms)[0m [1mCREATE TABLE [ship_parts] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [name] varchar(255), [ship_id] integer) [0m | |
[1m[35mEXECUTE (4.0ms)[0m DROP TABLE [speedometers] | |
[1m[36mEXECUTE (2.0ms)[0m [1mCREATE TABLE [speedometers] ([speedometer_id] varchar(255), [name] varchar(255), [dashboard_id] varchar(255)) [0m | |
[1m[35mEXECUTE (3.0ms)[0m DROP TABLE [sponsors] | |
[1m[36mEXECUTE (4.0ms)[0m [1mCREATE TABLE [sponsors] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [club_id] integer, [sponsorable_id] integer, [sponsorable_type] varchar(255)) [0m | |
[1m[35mEXECUTE (1.0ms)[0m DROP TABLE [subscribers] | |
[1m[36mEXECUTE (1.0ms)[0m [1mCREATE TABLE [subscribers] ([nick] varchar(255) NOT NULL, [name] varchar(255)) [0m | |
[1m[35mSQL (1.0ms)[0m EXEC sp_helpindex [subscribers] | |
[1m[36mEXECUTE (1.0ms)[0m [1mCREATE UNIQUE INDEX [index_subscribers_on_nick] ON [subscribers] ([nick])[0m | |
[1m[35mEXECUTE (3.0ms)[0m DROP TABLE [subscriptions] | |
[1m[36mEXECUTE (2.0ms)[0m [1mCREATE TABLE [subscriptions] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [subscriber_id] varchar(255), [book_id] integer) [0m | |
[1m[35mEXECUTE (2.0ms)[0m DROP TABLE [tasks] | |
[1m[36mEXECUTE (2.0ms)[0m [1mCREATE TABLE [tasks] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [starting] datetime, [ending] datetime) [0m | |
[1m[35mEXECUTE (2.0ms)[0m DROP TABLE [topics] | |
[1m[36mEXECUTE (2.0ms)[0m [1mCREATE 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)) [0m | |
[1m[35mEXECUTE (10.0ms)[0m DROP TABLE [taggings] | |
[1m[36mEXECUTE (1.0ms)[0m [1mCREATE 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) [0m | |
[1m[35mEXECUTE (2.0ms)[0m DROP TABLE [tags] | |
[1m[36mEXECUTE (2.0ms)[0m [1mCREATE TABLE [tags] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [name] varchar(255), [taggings_count] integer DEFAULT 0) [0m | |
[1m[35mEXECUTE (1.0ms)[0m DROP TABLE [toys] | |
[1m[36mEXECUTE (1.0ms)[0m [1mCREATE 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) [0m | |
[1m[35mEXECUTE (2.0ms)[0m DROP TABLE [traffic_lights] | |
[1m[36mEXECUTE (2.0ms)[0m [1mCREATE TABLE [traffic_lights] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [location] varchar(255), [state] varchar(255), [created_at] datetime, [updated_at] datetime) [0m | |
[1m[35mEXECUTE (2.0ms)[0m DROP TABLE [treasures] | |
[1m[36mEXECUTE (2.0ms)[0m [1mCREATE TABLE [treasures] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [name] varchar(255), [looter_id] integer, [looter_type] varchar(255)) [0m | |
[1m[35mEXECUTE (1.0ms)[0m DROP TABLE [variants] | |
[1m[36mEXECUTE (2.0ms)[0m [1mCREATE TABLE [variants] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [product_id] integer, [name] varchar(255)) [0m | |
[1m[35mEXECUTE (1.0ms)[0m DROP TABLE [vertices] | |
[1m[36mEXECUTE (1.0ms)[0m [1mCREATE TABLE [vertices] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [label] varchar(255)) [0m | |
[1m[35mEXECUTE (1.0ms)[0m DROP TABLE [warehouse-things] | |
[1m[36mEXECUTE (1.0ms)[0m [1mCREATE TABLE [warehouse-things] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [value] integer) [0m | |
[1m[35mEXECUTE (1.0ms)[0m DROP TABLE [circles] | |
[1m[36mEXECUTE (1.0ms)[0m [1mCREATE TABLE [circles] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY) [0m | |
[1m[35mEXECUTE (1.0ms)[0m DROP TABLE [squares] | |
[1m[36mEXECUTE (1.0ms)[0m [1mCREATE TABLE [squares] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY) [0m | |
[1m[35mEXECUTE (1.0ms)[0m DROP TABLE [triangles] | |
[1m[36mEXECUTE (2.0ms)[0m [1mCREATE TABLE [triangles] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY) [0m | |
[1m[35mEXECUTE (1.0ms)[0m DROP TABLE [non_poly_ones] | |
[1m[36mEXECUTE (4.0ms)[0m [1mCREATE TABLE [non_poly_ones] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY) [0m | |
[1m[35mEXECUTE (4.0ms)[0m DROP TABLE [non_poly_twos] | |
[1m[36mEXECUTE (1.0ms)[0m [1mCREATE TABLE [non_poly_twos] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY) [0m | |
[1m[35mEXECUTE (5.0ms)[0m DROP TABLE [guids] | |
[1m[36mEXECUTE (2.0ms)[0m [1mCREATE TABLE [guids] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [key] varchar(255)) [0m | |
[1m[35mEXECUTE (2.0ms)[0m DROP TABLE [integer_limits] | |
[1m[36mEXECUTE (2.0ms)[0m [1mCREATE 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) [0m | |
[1m[35mEXECUTE (1.0ms)[0m DROP TABLE [men] | |
[1m[36mEXECUTE (2.0ms)[0m [1mCREATE TABLE [men] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [name] varchar(255)) [0m | |
[1m[35mEXECUTE (2.0ms)[0m DROP TABLE [faces] | |
[1m[36mEXECUTE (2.0ms)[0m [1mCREATE 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)) [0m | |
[1m[35mEXECUTE (1.0ms)[0m DROP TABLE [interests] | |
[1m[36mEXECUTE (1.0ms)[0m [1mCREATE 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) [0m | |
[1m[35mEXECUTE (1.0ms)[0m DROP TABLE [wheels] | |
[1m[36mEXECUTE (25.0ms)[0m [1mCREATE TABLE [wheels] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [wheelable_id] integer, [wheelable_type] varchar(255)) [0m | |
[1m[35mEXECUTE (2.0ms)[0m DROP TABLE [zines] | |
[1m[36mEXECUTE (1.0ms)[0m [1mCREATE TABLE [zines] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [title] varchar(255)) [0m | |
[1m[35mEXECUTE (1.0ms)[0m DROP TABLE [countries] | |
[1m[36mEXECUTE (1.0ms)[0m [1mCREATE TABLE [countries] ([country_id] varchar(255), [name] varchar(255)) [0m | |
[1m[35mEXECUTE (1.0ms)[0m DROP TABLE [treaties] | |
[1m[36mEXECUTE (1.0ms)[0m [1mCREATE TABLE [treaties] ([treaty_id] varchar(255), [name] varchar(255)) [0m | |
[1m[35mEXECUTE (1.0ms)[0m DROP TABLE [countries_treaties] | |
[1m[36mEXECUTE (1.0ms)[0m [1mCREATE TABLE [countries_treaties] ([country_id] varchar(255) NOT NULL, [treaty_id] varchar(255) NOT NULL, [created_at] datetime, [updated_at] datetime) [0m | |
[1m[35mEXECUTE (2.0ms)[0m DROP TABLE [liquid] | |
[1m[36mEXECUTE (1.0ms)[0m [1mCREATE TABLE [liquid] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [name] varchar(255)) [0m | |
[1m[35mEXECUTE (1.0ms)[0m DROP TABLE [molecules] | |
[1m[36mEXECUTE (2.0ms)[0m [1mCREATE TABLE [molecules] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [liquid_id] integer, [name] varchar(255)) [0m | |
[1m[35mEXECUTE (1.0ms)[0m DROP TABLE [electrons] | |
[1m[36mEXECUTE (1.0ms)[0m [1mCREATE TABLE [electrons] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [molecule_id] integer, [name] varchar(255)) [0m | |
[1m[35mEXECUTE (1.0ms)[0m DROP TABLE [fk_test_has_fk] | |
[1m[36mEXECUTE (2.0ms)[0m [1mCREATE TABLE [fk_test_has_fk] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [fk_id] integer NOT NULL) [0m | |
[1m[35mEXECUTE (2.0ms)[0m DROP TABLE [fk_test_has_pk] | |
[1m[36mEXECUTE (1.0ms)[0m [1mCREATE TABLE [fk_test_has_pk] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY) [0m | |
[1m[35mEXECUTE (1.0ms)[0m ALTER TABLE fk_test_has_fk ADD CONSTRAINT fk_name FOREIGN KEY ([fk_id]) REFERENCES [fk_test_has_pk] ([id]) | |
[1m[36mEXECUTE (2.0ms)[0m [1mDROP TABLE [courses][0m | |
[1m[35mEXECUTE (3.0ms)[0m CREATE TABLE [courses] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [name] varchar(255) NOT NULL) | |
[1m[36mEXECUTE (2.0ms)[0m [1mDROP TABLE [table_with_real_columns][0m | |
[1m[35mEXECUTE (1.0ms)[0m CREATE TABLE [table_with_real_columns] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [real_number] real) | |
[1m[36mEXECUTE (2.0ms)[0m [1mDROP TABLE [defaults][0m | |
[1m[35mEXECUTE (4.0ms)[0m 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) | |
[1m[36mEXECUTE (3.0ms)[0m [1mDROP TABLE [string_defaults][0m | |
[1m[35mEXECUTE (3.0ms)[0m 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.') | |
[1m[36mEXECUTE (2.0ms)[0m [1mDROP TABLE [sql_server_chronics][0m | |
[1m[35mEXECUTE (3.0ms)[0m 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) | |
[1m[36mEXECUTE (4.0ms)[0m [1mDROP TABLE [fk_test_has_fks][0m | |
[1m[35mEXECUTE (3.0ms)[0m CREATE TABLE [fk_test_has_fks] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [fk_id] integer NOT NULL) | |
[1m[36mEXECUTE (2.0ms)[0m [1mDROP TABLE [fk_test_has_pks][0m | |
[1m[35mEXECUTE (1.0ms)[0m CREATE TABLE [fk_test_has_pks] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY) | |
[1m[36mEXECUTE (1.0ms)[0m [1m 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]) | |
[0m | |
[1m[35mEXECUTE (1.0ms)[0m DROP TABLE [sql_server_unicodes] | |
[1m[36mEXECUTE (1.0ms)[0m [1mCREATE 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)) [0m | |
[1m[35mEXECUTE (2.0ms)[0m DROP TABLE [sql_server_strings] | |
[1m[36mEXECUTE (2.0ms)[0m [1mCREATE 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)) [0m | |
[1m[35mEXECUTE (58.0ms)[0m DROP TABLE [sql_server_binary_types] | |
[1m[36mEXECUTE (3.0ms)[0m [1mCREATE TABLE [sql_server_binary_types] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY) [0m | |
[1m[35mEXECUTE (2.0ms)[0m DROP TABLE [sql_server_edge_schemas] | |
[1m[36mEXECUTE (2.0ms)[0m [1mCREATE TABLE [sql_server_edge_schemas] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY, [description] varchar(255), [bigint] bigint, [tinyint] tinyint, [guid] uniqueidentifier) [0m | |
[1m[35mEXECUTE (2.0ms)[0m ALTER TABLE [sql_server_edge_schemas] ADD [guid_newid] uniqueidentifier DEFAULT NEWID(); | |
[1m[36mEXECUTE (2.0ms)[0m [1mALTER TABLE [sql_server_edge_schemas] ADD [guid_newseqid] uniqueidentifier DEFAULT NEWSEQUENTIALID();[0m | |
[1m[35mEXECUTE (2.0ms)[0m DROP TABLE [quoted-table] | |
[1m[36mEXECUTE (2.0ms)[0m [1mCREATE TABLE [quoted-table] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY) [0m | |
[1m[35mEXECUTE (22.0ms)[0m IF EXISTS (SELECT TABLE_NAME FROM INFORMATION_SCHEMA.VIEWS WHERE TABLE_NAME = 'quoted-view1') DROP VIEW [quoted-view1] | |
[1m[36mEXECUTE (2.0ms)[0m [1mCREATE VIEW [quoted-view1] AS SELECT * FROM [quoted-table][0m | |
[1m[35mEXECUTE (8.0ms)[0m IF EXISTS (SELECT TABLE_NAME FROM INFORMATION_SCHEMA.VIEWS WHERE TABLE_NAME = 'quoted-view2') DROP VIEW [quoted-view2] | |
[1m[36mEXECUTE (9.0ms)[0m [1mCREATE VIEW [quoted-view2] AS | |
/*xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx}*/ | |
SELECT * FROM [quoted-table][0m | |
[1m[35mEXECUTE (6.0ms)[0m IF EXISTS (SELECT TABLE_NAME FROM INFORMATION_SCHEMA.VIEWS WHERE TABLE_NAME = 'customers_view') DROP VIEW customers_view | |
[1m[36mEXECUTE (1.0ms)[0m [1m CREATE VIEW customers_view AS | |
SELECT id, name, balance | |
FROM customers | |
[0m | |
[1m[35mEXECUTE (5.0ms)[0m IF EXISTS (SELECT TABLE_NAME FROM INFORMATION_SCHEMA.VIEWS WHERE TABLE_NAME = 'string_defaults_view') DROP VIEW string_defaults_view | |
[1m[36mEXECUTE (2.0ms)[0m [1m CREATE VIEW string_defaults_view AS | |
SELECT id, string_with_pretend_null_one as pretend_null | |
FROM string_defaults | |
[0m | |
[1m[35mEXECUTE (13.0ms)[0m IF EXISTS (SELECT TABLE_NAME FROM INFORMATION_SCHEMA.VIEWS WHERE TABLE_NAME = 'string_defaults_big_view') DROP VIEW string_defaults_big_view | |
[1m[36mEXECUTE (9.0ms)[0m [1m CREATE VIEW string_defaults_big_view AS | |
SELECT id, string_with_pretend_null_one as pretend_null | |
/*xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx}*/ | |
FROM string_defaults | |
[0m | |
[1m[35mEXECUTE (0.0ms)[0m BEGIN TRANSACTION | |
[1m[36mEXECUTE (0.0ms)[0m [1mROLLBACK TRANSACTION[0m | |
[1m[35mEXECUTE (0.0ms)[0m BEGIN TRANSACTION | |
[1m[36mEXECUTE (0.0ms)[0m [1mROLLBACK TRANSACTION[0m | |
[1m[35mEXECUTE (0.0ms)[0m BEGIN TRANSACTION | |
[1m[36mEXECUTE (0.0ms)[0m [1mROLLBACK TRANSACTION[0m | |
[1m[35mEXECUTE (1.0ms)[0m BEGIN TRANSACTION | |
[1m[36mTask Load (3.0ms)[0m [1mSELECT TOP (1) [tasks].* FROM [tasks] WHERE ([tasks].[id] = 1)[0m | |
[1m[35mTask Load (1.0ms)[0m SELECT TOP (1) [tasks].* FROM [tasks] WHERE ([tasks].[id] = 2) | |
[1m[36mEXECUTE (1.0ms)[0m [1mSET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED[0m | |
[1m[35mEXECUTE (0.0ms)[0m SET TRANSACTION ISOLATION LEVEL READ COMMITTED | |
[1m[36mEXECUTE (1.0ms)[0m [1mROLLBACK TRANSACTION[0m | |
[1m[35mEXECUTE (1.0ms)[0m BEGIN TRANSACTION | |
[1m[36mTask Load (0.0ms)[0m [1mSELECT TOP (1) [tasks].* FROM [tasks] WHERE ([tasks].[id] = 1)[0m | |
[1m[35mTask Load (0.0ms)[0m SELECT TOP (1) [tasks].* FROM [tasks] WHERE ([tasks].[id] = 2) | |
[1m[36mEXECUTE (0.0ms)[0m [1mSAVE TRANSACTION active_record_1[0m | |
[1m[35mEXECUTE (2.0ms)[0m UPDATE [tasks] SET [starting] = '2011-01-06 09:38:06.671' WHERE ([tasks].[id] = 2) | |
[1m[36mSQL (0.0ms)[0m [1mSELECT @@ROWCOUNT AS AffectedRows[0m | |
[1m[35mEXECUTE (1.0ms)[0m SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED | |
[1m[36mTask Load (1.0ms)[0m [1mSELECT TOP (1) [tasks].* FROM [tasks] WHERE ([tasks].[id] = 2)[0m | |
[1m[35mEXECUTE (0.0ms)[0m SET TRANSACTION ISOLATION LEVEL read committed | |
[1m[36mEXECUTE (0.0ms)[0m [1mROLLBACK TRANSACTION active_record_1[0m | |
[1m[35mTask Load (0.0ms)[0m SELECT TOP (1) [tasks].* FROM [tasks] WHERE ([tasks].[id] = 2) | |
[1m[36mEXECUTE (0.0ms)[0m [1mROLLBACK TRANSACTION[0m | |
[1m[35mEXECUTE (1.0ms)[0m BEGIN TRANSACTION | |
[1m[36mTask Load (0.0ms)[0m [1mSELECT TOP (1) [tasks].* FROM [tasks] WHERE ([tasks].[id] = 1)[0m | |
[1m[35mTask Load (0.0ms)[0m SELECT TOP (1) [tasks].* FROM [tasks] WHERE ([tasks].[id] = 2) | |
[1m[36mTask Load (1.0ms)[0m [1mSELECT [tasks].* FROM [tasks][0m | |
[1m[35mEXECUTE (0.0ms)[0m SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED | |
[1m[36mTask Load (0.0ms)[0m [1mSELECT [tasks].* FROM [tasks][0m | |
[1m[35mEXECUTE (0.0ms)[0m SET TRANSACTION ISOLATION LEVEL read committed | |
[1m[36mEXECUTE (1.0ms)[0m [1mROLLBACK TRANSACTION[0m | |
[1m[35mEXECUTE (1.0ms)[0m BEGIN TRANSACTION | |
[1m[36mEXECUTE (0.0ms)[0m [1mROLLBACK TRANSACTION[0m | |
[1m[35mEXECUTE (0.0ms)[0m BEGIN TRANSACTION | |
[1m[36mEXECUTE (0.0ms)[0m [1mROLLBACK TRANSACTION[0m | |
[1m[35mEXECUTE (0.0ms)[0m BEGIN TRANSACTION | |
[1m[36mEXECUTE (1.0ms)[0m [1mROLLBACK TRANSACTION[0m | |
[1m[35mEXECUTE (0.0ms)[0m BEGIN TRANSACTION | |
[1m[36mEXECUTE (0.0ms)[0m [1mROLLBACK TRANSACTION[0m | |
[1m[35mEXECUTE (0.0ms)[0m BEGIN TRANSACTION | |
[1m[36mEXECUTE (0.0ms)[0m [1mROLLBACK TRANSACTION[0m | |
[1m[35mEXECUTE (0.0ms)[0m BEGIN TRANSACTION | |
[1m[36mEXECUTE (0.0ms)[0m [1mROLLBACK TRANSACTION[0m | |
[1m[35mEXECUTE (0.0ms)[0m BEGIN TRANSACTION | |
[1m[36mEXECUTE (0.0ms)[0m [1mROLLBACK TRANSACTION[0m | |
[1m[35mEXECUTE (0.0ms)[0m BEGIN TRANSACTION | |
[1m[36mEXECUTE (0.0ms)[0m [1mROLLBACK TRANSACTION[0m | |
[1m[35mEXECUTE (1.0ms)[0m BEGIN TRANSACTION | |
[1m[36mEXECUTE (0.0ms)[0m [1mROLLBACK TRANSACTION[0m | |
[1m[35mEXECUTE (0.0ms)[0m BEGIN TRANSACTION | |
[1m[36mEXECUTE (0.0ms)[0m [1mROLLBACK TRANSACTION[0m | |
[1m[35mEXECUTE (0.0ms)[0m BEGIN TRANSACTION | |
[1m[36mEXECUTE (0.0ms)[0m [1mROLLBACK TRANSACTION[0m | |
[1m[35mEXECUTE (0.0ms)[0m BEGIN TRANSACTION | |
[1m[36mEXECUTE (1.0ms)[0m [1mROLLBACK TRANSACTION[0m | |
[1m[35mEXECUTE (0.0ms)[0m BEGIN TRANSACTION | |
[1m[36mEXECUTE (1.0ms)[0m [1mROLLBACK TRANSACTION[0m | |
[1m[35mEXECUTE (0.0ms)[0m BEGIN TRANSACTION | |
[1m[36mEXECUTE (1.0ms)[0m [1mROLLBACK TRANSACTION[0m | |
[1m[35mEXECUTE (0.0ms)[0m BEGIN TRANSACTION | |
[1m[36mEXECUTE (0.0ms)[0m [1mROLLBACK TRANSACTION[0m | |
[1m[35mEXECUTE (0.0ms)[0m BEGIN TRANSACTION | |
[1m[36mEXECUTE (0.0ms)[0m [1mROLLBACK TRANSACTION[0m | |
[1m[35mEXECUTE (0.0ms)[0m BEGIN TRANSACTION | |
[1m[36mEXECUTE (0.0ms)[0m [1mROLLBACK TRANSACTION[0m | |
[1m[35mEXECUTE (0.0ms)[0m BEGIN TRANSACTION | |
[1m[36mEXECUTE (0.0ms)[0m [1mROLLBACK TRANSACTION[0m | |
[1m[35mEXECUTE (0.0ms)[0m BEGIN TRANSACTION | |
[1m[36mEXECUTE (0.0ms)[0m [1mROLLBACK TRANSACTION[0m | |
[1m[35mEXECUTE (0.0ms)[0m BEGIN TRANSACTION | |
[1m[36mEXECUTE (0.0ms)[0m [1mROLLBACK TRANSACTION[0m | |
[1m[35mEXECUTE (0.0ms)[0m BEGIN TRANSACTION | |
[1m[36mEXECUTE (0.0ms)[0m [1mROLLBACK TRANSACTION[0m | |
[1m[35mEXECUTE (0.0ms)[0m BEGIN TRANSACTION | |
[1m[36mEXECUTE (0.0ms)[0m [1mROLLBACK TRANSACTION[0m | |
[1m[35mEXECUTE (1.0ms)[0m BEGIN TRANSACTION | |
[1m[36mEXECUTE (0.0ms)[0m [1mROLLBACK TRANSACTION[0m | |
[1m[35mEXECUTE (0.0ms)[0m BEGIN TRANSACTION | |
[1m[36mEXECUTE (0.0ms)[0m [1mROLLBACK TRANSACTION[0m | |
[1m[35mEXECUTE (0.0ms)[0m BEGIN TRANSACTION | |
[1m[36mEXECUTE (0.0ms)[0m [1mUPDATE XXX[0m | |
ODBC::Error: 37000 (102) [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near 'XXX'.: UPDATE XXX | |
[1m[35mEXECUTE (1.0ms)[0m ROLLBACK TRANSACTION | |
[1m[36mEXECUTE (0.0ms)[0m [1mBEGIN TRANSACTION[0m | |
[1m[35mEXECUTE (0.0ms)[0m ROLLBACK TRANSACTION | |
[1m[36mEXECUTE (0.0ms)[0m [1mBEGIN TRANSACTION[0m | |
[1m[35mEXECUTE (1.0ms)[0m ROLLBACK TRANSACTION | |
[1m[36mEXECUTE (0.0ms)[0m [1mBEGIN TRANSACTION[0m | |
[1m[35mEXECUTE (0.0ms)[0m ROLLBACK TRANSACTION | |
[1m[36mEXECUTE (0.0ms)[0m [1mBEGIN TRANSACTION[0m | |
[1m[35mEXECUTE (1.0ms)[0m ROLLBACK TRANSACTION | |
[1m[36mEXECUTE (0.0ms)[0m [1mBEGIN TRANSACTION[0m | |
[1m[35mEXECUTE (0.0ms)[0m ROLLBACK TRANSACTION | |
[1m[36mEXECUTE (0.0ms)[0m [1mBEGIN TRANSACTION[0m | |
[1m[35mEXECUTE (1.0ms)[0m INSERT INTO [sql_server_chronics] ([datetime]) VALUES('2012-11-08 10:24:36.003') | |
[1m[36mEXECUTE (1.0ms)[0m [1mINSERT INTO [sql_server_chronics] ([datetime]) VALUES('2012-11-08 10:24:36.123')[0m | |
[1m[35mSqlServerChronic Load (2.0ms)[0m SELECT TOP (1) [sql_server_chronics].* FROM [sql_server_chronics] WHERE ([sql_server_chronics].[datetime] = N'2012-11-08 10:24:36.003') | |
[1m[36mEXECUTE (1.0ms)[0m [1mDELETE FROM [sql_server_chronics] WHERE [datetime] = '2012-11-08 10:24:36.003'[0m | |
[1m[35mEXECUTE (0.0ms)[0m DELETE FROM [sql_server_chronics] WHERE [datetime] = '2012-11-08 10:24:36.123' | |
[1m[36mEXECUTE (0.0ms)[0m [1mROLLBACK TRANSACTION[0m | |
[1m[35mEXECUTE (1.0ms)[0m BEGIN TRANSACTION | |
[1m[36mEXECUTE (0.0ms)[0m [1mINSERT INTO [sql_server_chronics] ([datetime]) VALUES('2012-11-08 10:24:36.003')[0m | |
[1m[35mEXECUTE (1.0ms)[0m INSERT INTO [sql_server_chronics] ([datetime]) VALUES('2012-11-08 10:24:36.123') | |
[1m[36mSqlServerChronic Load (1.0ms)[0m [1mSELECT TOP (1) [sql_server_chronics].* FROM [sql_server_chronics] WHERE ([sql_server_chronics].[datetime] = N'2012-11-08 10:24:36.123')[0m | |
[1m[35mEXECUTE (0.0ms)[0m DELETE FROM [sql_server_chronics] WHERE [datetime] = '2012-11-08 10:24:36.003' | |
[1m[36mEXECUTE (0.0ms)[0m [1mDELETE FROM [sql_server_chronics] WHERE [datetime] = '2012-11-08 10:24:36.123'[0m | |
[1m[35mEXECUTE (1.0ms)[0m ROLLBACK TRANSACTION | |
[1m[36mEXECUTE (1.0ms)[0m [1mBEGIN TRANSACTION[0m | |
[1m[35mEXECUTE (0.0ms)[0m INSERT INTO [sql_server_chronics] ([datetime]) VALUES('2012-11-08 10:24:36.003') | |
[1m[36mEXECUTE (1.0ms)[0m [1mINSERT INTO [sql_server_chronics] ([datetime]) VALUES('2012-11-08 10:24:36.123')[0m | |
[1m[35mEXECUTE (1.0ms)[0m SAVE TRANSACTION active_record_1 | |
[1m[36mEXECUTE (2.0ms)[0m [1mINSERT INTO [sql_server_chronics] ([date], [datetime], [smalldatetime], [ss_timestamp], [time], [timestamp]) VALUES (NULL, '2011-01-06 09:38:06.123', NULL, NULL, NULL, NULL)[0m | |
[1m[35mSQL (0.0ms)[0m SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident | |
[1m[36mSqlServerChronic Load (1.0ms)[0m [1mSELECT TOP (1) [sql_server_chronics].* FROM [sql_server_chronics] WHERE ([sql_server_chronics].[id] = 7)[0m | |
[1m[35mEXECUTE (0.0ms)[0m DELETE FROM [sql_server_chronics] WHERE [datetime] = '2012-11-08 10:24:36.003' | |
[1m[36mEXECUTE (0.0ms)[0m [1mDELETE FROM [sql_server_chronics] WHERE [datetime] = '2012-11-08 10:24:36.123'[0m | |
[1m[35mEXECUTE (0.0ms)[0m ROLLBACK TRANSACTION | |
[1m[36mEXECUTE (0.0ms)[0m [1mBEGIN TRANSACTION[0m | |
[1m[35mEXECUTE (0.0ms)[0m INSERT INTO [sql_server_chronics] ([datetime]) VALUES('2012-11-08 10:24:36.003') | |
[1m[36mEXECUTE (0.0ms)[0m [1mINSERT INTO [sql_server_chronics] ([datetime]) VALUES('2012-11-08 10:24:36.123')[0m | |
[1m[35mEXECUTE (0.0ms)[0m SAVE TRANSACTION active_record_1 | |
[1m[36mEXECUTE (0.0ms)[0m [1mINSERT INTO [sql_server_chronics] ([date], [datetime], [smalldatetime], [ss_timestamp], [time], [timestamp]) VALUES (NULL, '2011-01-06 09:38:06.003', NULL, NULL, NULL, NULL)[0m | |
[1m[35mSQL (1.0ms)[0m SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident | |
[1m[36mSqlServerChronic Load (1.0ms)[0m [1mSELECT TOP (1) [sql_server_chronics].* FROM [sql_server_chronics] WHERE ([sql_server_chronics].[id] = 10)[0m | |
[1m[35mEXECUTE (0.0ms)[0m DELETE FROM [sql_server_chronics] WHERE [datetime] = '2012-11-08 10:24:36.003' | |
[1m[36mEXECUTE (1.0ms)[0m [1mDELETE FROM [sql_server_chronics] WHERE [datetime] = '2012-11-08 10:24:36.123'[0m | |
[1m[35mEXECUTE (0.0ms)[0m ROLLBACK TRANSACTION | |
[1m[36mEXECUTE (0.0ms)[0m [1mBEGIN TRANSACTION[0m | |
[1m[35mEXECUTE (1.0ms)[0m ROLLBACK TRANSACTION | |
[1m[36mEXECUTE (0.0ms)[0m [1mBEGIN TRANSACTION[0m | |
[1m[35mEXECUTE (1.0ms)[0m ROLLBACK TRANSACTION | |
[1m[36mEXECUTE (0.0ms)[0m [1mBEGIN TRANSACTION[0m | |
[1m[35mEXECUTE (1.0ms)[0m ROLLBACK TRANSACTION | |
[1m[36mEXECUTE (0.0ms)[0m [1mBEGIN TRANSACTION[0m | |
[1m[35mEXECUTE (1.0ms)[0m ROLLBACK TRANSACTION | |
[1m[36mEXECUTE (0.0ms)[0m [1mBEGIN TRANSACTION[0m | |
[1m[35mEXECUTE (1.0ms)[0m CREATE INDEX idx_credit_limit_test_desc ON accounts (credit_limit DESC) | |
[1m[36mSQL (1.0ms)[0m [1mEXEC sp_helpindex [accounts][0m | |
[1m[35mEXECUTE (1.0ms)[0m DROP INDEX accounts.idx_credit_limit_test_desc | |
[1m[36mEXECUTE (1.0ms)[0m [1mROLLBACK TRANSACTION[0m | |
[1m[35mEXECUTE (0.0ms)[0m BEGIN TRANSACTION | |
[1m[36mIDENTITY_INSERT (1.0ms)[0m [1mSET IDENTITY_INSERT [customers] ON[0m | |
[1m[35mEXECUTE (1.0ms)[0m INSERT INTO [customers_view] ([id],[name],[balance]) VALUES (420,'Microsoft',0) | |
[1m[36mIDENTITY_INSERT (0.0ms)[0m [1mSET IDENTITY_INSERT [customers] OFF[0m | |
[1m[35mCustomersView Load (12.0ms)[0m SELECT TOP (1) [customers_view].* FROM [customers_view] WHERE ([customers_view].[id] = 420) | |
[1m[36mEXECUTE (0.0ms)[0m [1mROLLBACK TRANSACTION[0m | |
[1m[35mEXECUTE (0.0ms)[0m BEGIN TRANSACTION | |
[1m[36mEXECUTE (0.0ms)[0m [1mROLLBACK TRANSACTION[0m | |
[1m[35mEXECUTE (0.0ms)[0m BEGIN TRANSACTION | |
[1m[36mEXECUTE (1.0ms)[0m [1mROLLBACK TRANSACTION[0m | |
[1m[35mEXECUTE (0.0ms)[0m BEGIN TRANSACTION | |
[1m[36mEXECUTE (0.0ms)[0m [1mROLLBACK TRANSACTION[0m | |
[1m[35mEXECUTE (0.0ms)[0m BEGIN TRANSACTION | |
[1m[36mEXECUTE (0.0ms)[0m [1mROLLBACK TRANSACTION[0m | |
[1m[35mEXECUTE (0.0ms)[0m BEGIN TRANSACTION | |
[1m[36mEXECUTE (0.0ms)[0m [1mROLLBACK TRANSACTION[0m | |
[1m[35mEXECUTE (0.0ms)[0m BEGIN TRANSACTION | |
[1m[36mEXECUTE (0.0ms)[0m [1mROLLBACK TRANSACTION[0m | |
[1m[35mEXECUTE (0.0ms)[0m BEGIN TRANSACTION | |
[1m[36mEXECUTE (0.0ms)[0m [1mROLLBACK TRANSACTION[0m | |
[1m[35mEXECUTE (0.0ms)[0m BEGIN TRANSACTION | |
[1m[36mEXECUTE (0.0ms)[0m [1mROLLBACK TRANSACTION[0m | |
[1m[35mEXECUTE (0.0ms)[0m BEGIN TRANSACTION | |
[1m[36mEXECUTE (0.0ms)[0m [1mROLLBACK TRANSACTION[0m | |
[1m[35mEXECUTE (0.0ms)[0m BEGIN TRANSACTION | |
[1m[36mEXECUTE (0.0ms)[0m [1mROLLBACK TRANSACTION[0m | |
[1m[35mEXECUTE (0.0ms)[0m BEGIN TRANSACTION | |
[1m[36mEXECUTE (0.0ms)[0m [1mROLLBACK TRANSACTION[0m | |
[1m[35mEXECUTE (0.0ms)[0m BEGIN TRANSACTION | |
[1m[36mEXECUTE (0.0ms)[0m [1mROLLBACK TRANSACTION[0m | |
[1m[35mEXECUTE (0.0ms)[0m BEGIN TRANSACTION | |
[1m[36mEXECUTE (0.0ms)[0m [1mROLLBACK TRANSACTION[0m | |
[1m[35mEXECUTE (1.0ms)[0m BEGIN TRANSACTION | |
[1m[36mEXECUTE (0.0ms)[0m [1mROLLBACK TRANSACTION[0m | |
[1m[35mEXECUTE (1.0ms)[0m BEGIN TRANSACTION | |
[1m[36mEXECUTE (1.0ms)[0m [1mROLLBACK TRANSACTION[0m | |
[1m[35mEXECUTE (1.0ms)[0m BEGIN TRANSACTION | |
[1m[36mEXECUTE (0.0ms)[0m [1mROLLBACK TRANSACTION[0m | |
[1m[35mEXECUTE (0.0ms)[0m BEGIN TRANSACTION | |
[1m[36mEXECUTE (0.0ms)[0m [1mROLLBACK TRANSACTION[0m | |
[1m[35mEXECUTE (0.0ms)[0m BEGIN TRANSACTION | |
[1m[36mEXECUTE (0.0ms)[0m [1mROLLBACK TRANSACTION[0m | |
[1m[35mEXECUTE (0.0ms)[0m BEGIN TRANSACTION | |
[1m[36mEXECUTE (0.0ms)[0m [1mSAVE TRANSACTION active_record_1[0m | |
[1m[35mEXECUTE (1.0ms)[0m INSERT INTO [fk_test_has_pks] DEFAULT VALUES | |
[1m[36mSQL (1.0ms)[0m [1mSELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident[0m | |
[1m[35mEXECUTE (0.0ms)[0m SAVE TRANSACTION active_record_1 | |
[1m[36mEXECUTE (1.0ms)[0m [1mINSERT INTO [fk_test_has_fks] ([fk_id]) VALUES (1)[0m | |
[1m[35mSQL (0.0ms)[0m SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident | |
[1m[36mEXECUTE (54.0ms)[0m [1mEXEC sp_MSforeachtable 'ALTER TABLE ? NOCHECK CONSTRAINT ALL'[0m | |
[1m[35mEXECUTE (0.0ms)[0m SAVE TRANSACTION active_record_1 | |
[1m[36mEXECUTE (2.0ms)[0m [1mDELETE FROM [fk_test_has_pks] WHERE ([fk_test_has_pks].[id] = 1)[0m | |
[1m[35mSQL (0.0ms)[0m SELECT @@ROWCOUNT AS AffectedRows | |
[1m[36mEXECUTE (48.0ms)[0m [1mEXEC sp_MSforeachtable 'ALTER TABLE ? CHECK CONSTRAINT ALL'[0m | |
[1m[35mEXECUTE (18.0ms)[0m ROLLBACK TRANSACTION | |
[1m[36mEXECUTE (0.0ms)[0m [1mBEGIN TRANSACTION[0m | |
[1m[35mEXECUTE (0.0ms)[0m SAVE TRANSACTION active_record_1 | |
[1m[36mEXECUTE (0.0ms)[0m [1mINSERT INTO [fk_test_has_pks] DEFAULT VALUES[0m | |
[1m[35mSQL (1.0ms)[0m SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident | |
[1m[36mEXECUTE (0.0ms)[0m [1mSAVE TRANSACTION active_record_1[0m | |
[1m[35mEXECUTE (1.0ms)[0m INSERT INTO [fk_test_has_fks] ([fk_id]) VALUES (2) | |
[1m[36mSQL (0.0ms)[0m [1mSELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident[0m | |
[1m[35mEXECUTE (51.0ms)[0m EXEC sp_MSforeachtable 'ALTER TABLE ? NOCHECK CONSTRAINT ALL' | |
[1m[36mEXECUTE (58.0ms)[0m [1mEXEC sp_MSforeachtable 'ALTER TABLE ? CHECK CONSTRAINT ALL'[0m | |
[1m[35mEXECUTE (0.0ms)[0m SAVE TRANSACTION active_record_1 | |
[1m[36mEXECUTE (2.0ms)[0m [1mDELETE FROM [fk_test_has_pks] WHERE ([fk_test_has_pks].[id] = 2)[0m | |
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) | |
[1m[35mEXECUTE (0.0ms)[0m ROLLBACK TRANSACTION active_record_1 | |
[1m[36mEXECUTE (18.0ms)[0m [1mROLLBACK TRANSACTION[0m | |
[1m[35mEXECUTE (0.0ms)[0m BEGIN TRANSACTION | |
[1m[36mEXECUTE (0.0ms)[0m [1mSAVE TRANSACTION active_record_1[0m | |
[1m[35mEXECUTE (0.0ms)[0m INSERT INTO [fk_test_has_pks] DEFAULT VALUES | |
[1m[36mSQL (1.0ms)[0m [1mSELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident[0m | |
[1m[35mEXECUTE (0.0ms)[0m SAVE TRANSACTION active_record_1 | |
[1m[36mEXECUTE (0.0ms)[0m [1mINSERT INTO [fk_test_has_fks] ([fk_id]) VALUES (3)[0m | |
[1m[35mSQL (1.0ms)[0m SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident | |
[1m[36mEXECUTE (49.0ms)[0m [1mEXEC sp_MSforeachtable 'ALTER TABLE ? NOCHECK CONSTRAINT ALL'[0m | |
[1m[35mEXECUTE (48.0ms)[0m EXEC sp_MSforeachtable 'ALTER TABLE ? CHECK CONSTRAINT ALL' | |
[1m[36mEXECUTE (0.0ms)[0m [1mSAVE TRANSACTION active_record_1[0m | |
[1m[35mEXECUTE (2.0ms)[0m 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) | |
[1m[36mEXECUTE (1.0ms)[0m [1mROLLBACK TRANSACTION active_record_1[0m | |
[1m[35mEXECUTE (19.0ms)[0m ROLLBACK TRANSACTION | |
[1m[36mEXECUTE (0.0ms)[0m [1mBEGIN TRANSACTION[0m | |
[1m[35mDeveloper Load (1.0ms)[0m SELECT TOP (1) [developers].* FROM [developers] | |
[1m[36mEXECUTE (0.0ms)[0m [1mROLLBACK TRANSACTION[0m | |
[1m[35mEXECUTE (0.0ms)[0m BEGIN TRANSACTION | |
[1m[36mEXECUTE (1.0ms)[0m [1mSAVE TRANSACTION active_record_1[0m | |
[1m[35mEXECUTE (2.0ms)[0m 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'[email protected]', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, N'Budget', NULL, '2011-01-06 09:38:07.914') | |
[1m[36mSQL (1.0ms)[0m [1mSELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident[0m | |
[1m[35mTopic Load (1.0ms)[0m SELECT TOP (1) topics.*, CASE WHEN 1=2 THEN 1 ELSE 0 END as is_test FROM [topics] | |
[1m[36mEXECUTE (0.0ms)[0m [1mROLLBACK TRANSACTION[0m | |
[1m[35mEXECUTE (0.0ms)[0m BEGIN TRANSACTION | |
[1m[36mEXECUTE (1.0ms)[0m [1mSAVE TRANSACTION active_record_1[0m | |
[1m[35mEXECUTE (0.0ms)[0m 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'[email protected]', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, N'Budget', NULL, '2011-01-06 09:38:07.923') | |
[1m[36mSQL (1.0ms)[0m [1mSELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident[0m | |
[1m[35mTopic Load (1.0ms)[0m SELECT TOP (1) topics.*, CASE WHEN 2=2 THEN 1 ELSE 0 END as is_test FROM [topics] | |
[1m[36mEXECUTE (0.0ms)[0m [1mROLLBACK TRANSACTION[0m | |
[1m[35mEXECUTE (1.0ms)[0m BEGIN TRANSACTION | |
[1m[36mEXECUTE (1.0ms)[0m [1mROLLBACK TRANSACTION[0m | |
[1m[35mEXECUTE (0.0ms)[0m BEGIN TRANSACTION | |
[1m[36mSQL (1.0ms)[0m [1mSELECT SUM(2 * credit_limit) AS sum_id FROM [accounts][0m | |
[1m[35mEXECUTE (0.0ms)[0m ROLLBACK TRANSACTION | |
[1m[36mEXECUTE (0.0ms)[0m [1mBEGIN TRANSACTION[0m | |
[1m[35mEXECUTE (1.0ms)[0m ROLLBACK TRANSACTION | |
[1m[36mEXECUTE (0.0ms)[0m [1mBEGIN TRANSACTION[0m | |
[1m[35mEXECUTE (0.0ms)[0m ROLLBACK TRANSACTION | |
[1m[36mEXECUTE (0.0ms)[0m [1mBEGIN TRANSACTION[0m | |
[1m[35mEXECUTE (0.0ms)[0m ROLLBACK TRANSACTION | |
[1m[36mEXECUTE (0.0ms)[0m [1mBEGIN TRANSACTION[0m | |
[1m[35mEXECUTE (0.0ms)[0m ROLLBACK TRANSACTION | |
[1m[36mEXECUTE (0.0ms)[0m [1mBEGIN TRANSACTION[0m | |
[1m[35mEXECUTE (0.0ms)[0m ROLLBACK TRANSACTION | |
[1m[36mEXECUTE (0.0ms)[0m [1mBEGIN TRANSACTION[0m | |
[1m[35mEXECUTE (0.0ms)[0m ROLLBACK TRANSACTION | |
[1m[36mEXECUTE (0.0ms)[0m [1mBEGIN TRANSACTION[0m | |
[1m[35mEXECUTE (0.0ms)[0m ROLLBACK TRANSACTION | |
[1m[36mEXECUTE (0.0ms)[0m [1mBEGIN TRANSACTION[0m | |
[1m[35mEXECUTE (0.0ms)[0m SAVE TRANSACTION active_record_1 | |
[1m[36mEXECUTE (1.0ms)[0m [1mINSERT INTO [binaries] ([data]) VALUES (0x47494638396101000100800000ffffff00000021f90400000000002c00000000010001000002024401003b)[0m | |
[1m[35mSQL (0.0ms)[0m SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident | |
[1m[36mEXECUTE (0.0ms)[0m [1mROLLBACK TRANSACTION[0m | |
[1m[35mEXECUTE (0.0ms)[0m BEGIN TRANSACTION | |
[1m[36mEXECUTE (0.0ms)[0m [1mSAVE TRANSACTION active_record_1[0m | |
[1m[35mEXECUTE (1.0ms)[0m INSERT INTO [binaries] ([data]) VALUES (0x47494638396101000100800000ffffff00000021f90400000000002c00000000010001000002024401003b) | |
[1m[36mSQL (0.0ms)[0m [1mSELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident[0m | |
[1m[35mEXECUTE (0.0ms)[0m ROLLBACK TRANSACTION | |
[1m[36mEXECUTE (0.0ms)[0m [1mBEGIN TRANSACTION[0m | |
[1m[35mEXECUTE (1.0ms)[0m SAVE TRANSACTION active_record_1 | |
[1m[36mEXECUTE (1.0ms)[0m [1mINSERT INTO [binaries] ([data]) VALUES (0x47494638396101000100800000ffffff00000021f90400000000002c00000000010001000002024401003b)[0m | |
[1m[35mSQL (0.0ms)[0m SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident | |
[1m[36mBinary Load (2.0ms)[0m [1mSELECT TOP (1) [binaries].* FROM [binaries] WHERE ([binaries].[id] = 3)[0m | |
[1m[35mEXECUTE (1.0ms)[0m ROLLBACK TRANSACTION | |
[1m[36mEXECUTE (1.0ms)[0m [1mBEGIN TRANSACTION[0m | |
[1m[35mEXECUTE (0.0ms)[0m SAVE TRANSACTION active_record_1 | |
[1m[36mEXECUTE (1.0ms)[0m [1mINSERT INTO [sql_server_chronics] ([date], [datetime], [smalldatetime], [ss_timestamp], [time], [timestamp]) VALUES (NULL, NULL, '2011-01-06 09:38:08.388', NULL, NULL, NULL)[0m | |
[1m[35mSQL (1.0ms)[0m SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident | |
[1m[36mEXECUTE (1.0ms)[0m [1mROLLBACK TRANSACTION[0m | |
[1m[35mEXECUTE (0.0ms)[0m BEGIN TRANSACTION | |
[1m[36mEXECUTE (0.0ms)[0m [1mSAVE TRANSACTION active_record_1[0m | |
[1m[35mEXECUTE (1.0ms)[0m 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) | |
[1m[36mSQL (0.0ms)[0m [1mSELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident[0m | |
[1m[35mEXECUTE (0.0ms)[0m SAVE TRANSACTION active_record_1 | |
[1m[36mEXECUTE (2.0ms)[0m [1mUPDATE [sql_server_chronics] SET [smalldatetime] = '2011-01-06 09:38:08.396' WHERE ([sql_server_chronics].[id] = 12)[0m | |
[1m[35mSQL (1.0ms)[0m SELECT @@ROWCOUNT AS AffectedRows | |
[1m[36mEXECUTE (1.0ms)[0m [1mROLLBACK TRANSACTION[0m | |
[1m[35mEXECUTE (0.0ms)[0m BEGIN TRANSACTION | |
[1m[36mEXECUTE (1.0ms)[0m [1mROLLBACK TRANSACTION[0m | |
[1m[35mEXECUTE (0.0ms)[0m BEGIN TRANSACTION | |
[1m[36mEXECUTE (0.0ms)[0m [1mROLLBACK TRANSACTION[0m | |
[1m[35mEXECUTE (0.0ms)[0m BEGIN TRANSACTION | |
[1m[36mEXECUTE (0.0ms)[0m [1mROLLBACK TRANSACTION[0m | |
[1m[35mEXECUTE (0.0ms)[0m BEGIN TRANSACTION | |
[1m[36mEXECUTE (0.0ms)[0m [1mROLLBACK TRANSACTION[0m | |
[1m[35mEXECUTE (0.0ms)[0m BEGIN TRANSACTION | |
[1m[36mEXECUTE (0.0ms)[0m [1mSAVE TRANSACTION active_record_1[0m | |
[1m[35mEXECUTE (1.0ms)[0m 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) | |
[1m[36mSQL (1.0ms)[0m [1mSELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident[0m | |
[1m[35mSqlServerChronic Load (1.0ms)[0m SELECT TOP (1) [sql_server_chronics].* FROM [sql_server_chronics] WHERE ([sql_server_chronics].[id] = 13) | |
[1m[36mEXECUTE (0.0ms)[0m [1mSAVE TRANSACTION active_record_1[0m | |
[1m[35mEXECUTE (1.0ms)[0m 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) | |
[1m[36mSQL (1.0ms)[0m [1mSELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident[0m | |
[1m[35mSqlServerChronic Load (1.0ms)[0m SELECT TOP (1) [sql_server_chronics].* FROM [sql_server_chronics] WHERE ([sql_server_chronics].[id] = 14) | |
[1m[36mEXECUTE (1.0ms)[0m [1mROLLBACK TRANSACTION[0m | |
[1m[35mEXECUTE (0.0ms)[0m BEGIN TRANSACTION | |
[1m[36mEXECUTE (0.0ms)[0m [1mSAVE TRANSACTION active_record_1[0m | |
[1m[35mEXECUTE (1.0ms)[0m 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) | |
[1m[36mSQL (0.0ms)[0m [1mSELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident[0m | |
[1m[35mSqlServerChronic Load (1.0ms)[0m SELECT TOP (1) [sql_server_chronics].* FROM [sql_server_chronics] WHERE ([sql_server_chronics].[id] = 15) | |
[1m[36mEXECUTE (0.0ms)[0m [1mSAVE TRANSACTION active_record_1[0m | |
[1m[35mEXECUTE (0.0ms)[0m 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) | |
[1m[36mSQL (0.0ms)[0m [1mSELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident[0m | |
[1m[35mSqlServerChronic Load (1.0ms)[0m SELECT TOP (1) [sql_server_chronics].* FROM [sql_server_chronics] WHERE ([sql_server_chronics].[id] = 16) | |
[1m[36mEXECUTE (0.0ms)[0m [1mROLLBACK TRANSACTION[0m | |
[1m[35mEXECUTE (0.0ms)[0m BEGIN TRANSACTION | |
[1m[36mEXECUTE (0.0ms)[0m [1mSAVE TRANSACTION active_record_1[0m | |
[1m[35mEXECUTE (0.0ms)[0m 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) | |
[1m[36mSQL (1.0ms)[0m [1mSELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident[0m | |
[1m[35mSqlServerChronic Load (1.0ms)[0m SELECT TOP (1) [sql_server_chronics].* FROM [sql_server_chronics] WHERE ([sql_server_chronics].[id] = 17) | |
[1m[36mEXECUTE (0.0ms)[0m [1mSAVE TRANSACTION active_record_1[0m | |
[1m[35mEXECUTE (0.0ms)[0m 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) | |
[1m[36mSQL (1.0ms)[0m [1mSELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident[0m | |
[1m[35mSqlServerChronic Load (1.0ms)[0m SELECT TOP (1) [sql_server_chronics].* FROM [sql_server_chronics] WHERE ([sql_server_chronics].[id] = 18) | |
[1m[36mEXECUTE (0.0ms)[0m [1mROLLBACK TRANSACTION[0m | |
[1m[35mEXECUTE (0.0ms)[0m BEGIN TRANSACTION | |
[1m[36mEXECUTE (0.0ms)[0m [1mROLLBACK TRANSACTION[0m | |
[1m[35mEXECUTE (0.0ms)[0m BEGIN TRANSACTION | |
[1m[36mEXECUTE (0.0ms)[0m [1mSAVE TRANSACTION active_record_1[0m | |
[1m[35mEXECUTE (1.0ms)[0m INSERT INTO [sql_server_chronics] ([date], [datetime], [smalldatetime], [ss_timestamp], [time], [timestamp]) VALUES (NULL, NULL, NULL, NULL, NULL, NULL) | |
[1m[36mSQL (1.0ms)[0m [1mSELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident[0m | |
[1m[35mSqlServerChronic Load (1.0ms)[0m SELECT TOP (1) [sql_server_chronics].* FROM [sql_server_chronics] WHERE ([sql_server_chronics].[id] = 19) | |
[1m[36mEXECUTE (0.0ms)[0m [1mROLLBACK TRANSACTION[0m | |
[1m[35mEXECUTE (0.0ms)[0m BEGIN TRANSACTION | |
[1m[36mEXECUTE (0.0ms)[0m [1mROLLBACK TRANSACTION[0m | |
[1m[35mEXECUTE (0.0ms)[0m BEGIN TRANSACTION | |
[1m[36mEXECUTE (1.0ms)[0m [1mROLLBACK TRANSACTION[0m | |
[1m[35mEXECUTE (0.0ms)[0m BEGIN TRANSACTION | |
[1m[36mEXECUTE (0.0ms)[0m [1mROLLBACK TRANSACTION[0m | |
[1m[35mEXECUTE (0.0ms)[0m BEGIN TRANSACTION | |
[1m[36mEXECUTE (0.0ms)[0m [1mROLLBACK TRANSACTION[0m | |
[1m[35mEXECUTE (0.0ms)[0m BEGIN TRANSACTION | |
[1m[36mEXECUTE (1.0ms)[0m [1mROLLBACK TRANSACTION[0m | |
[1m[35mEXECUTE (1.0ms)[0m BEGIN TRANSACTION | |
[1m[36mEXECUTE (0.0ms)[0m [1mROLLBACK TRANSACTION[0m | |
[1m[35mEXECUTE (0.0ms)[0m BEGIN TRANSACTION | |
[1m[36mEXECUTE (0.0ms)[0m [1mROLLBACK TRANSACTION[0m | |
[1m[35mEXECUTE (0.0ms)[0m BEGIN TRANSACTION | |
[1m[36mEXECUTE (1.0ms)[0m [1mROLLBACK TRANSACTION[0m | |
[1m[35mEXECUTE (1.0ms)[0m BEGIN TRANSACTION | |
[1m[36mEXECUTE (0.0ms)[0m [1mROLLBACK TRANSACTION[0m | |
CONNECTION RETRY: ActiveRecord::ConnectionAdapters::SQLServerAdapter retry #0. | |
[1m[35mSQL (1012.1ms)[0m SELECT COUNT(*) AS count_id FROM [topics] | |
[1m[36mSQL (0.0ms)[0m [1mSELECT COUNT(*) AS count_id FROM [topics][0m | |
ODBC::Error: INTERN (0) [RubyODBC]Invalid handle: SELECT COUNT(*) AS count_id FROM [topics] | |
[1m[35mTopic Load (2.0ms)[0m SELECT TOP (1) [topics].* FROM [topics] WHERE ([topics].[id] = 1) | |
[1m[36mEXECUTE (1.0ms)[0m [1mBEGIN TRANSACTION[0m | |
[1m[35mEXECUTE (1.0ms)[0m UPDATE [topics] SET [content] = N'1 updated' WHERE ([topics].[id] = 1) | |
[1m[36mSQL (1.0ms)[0m [1mSELECT @@ROWCOUNT AS AffectedRows[0m | |
[1m[35mEXECUTE (1.0ms)[0m COMMIT TRANSACTION | |
[1m[36mTopic Load (1.0ms)[0m [1mSELECT TOP (1) [topics].* FROM [topics] WHERE ([topics].[id] = 2)[0m | |
[1m[35mEXECUTE (0.0ms)[0m BEGIN TRANSACTION | |
[1m[36mEXECUTE (3.0ms)[0m [1mUPDATE [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)[0m | |
[1m[35mSQL (0.0ms)[0m SELECT @@ROWCOUNT AS AffectedRows | |
[1m[36mEXECUTE (1.0ms)[0m [1mCOMMIT TRANSACTION[0m | |
[1m[35mTopic Load (0.0ms)[0m SELECT TOP (1) [topics].* FROM [topics] WHERE ([topics].[id] = 1) | |
[1m[36mTopic Load (1.0ms)[0m [1mSELECT TOP (1) [topics].* FROM [topics] WHERE ([topics].[id] = 2)[0m | |
[1m[35mEXECUTE (1.0ms)[0m DELETE FROM [topics] WHERE ([topics].[id] IN (1, 2)) | |
[1m[36mSQL (0.0ms)[0m [1mSELECT @@ROWCOUNT AS AffectedRows[0m | |
[1m[35mSQL (1.0ms)[0m SELECT DB_NAME() | |
[1m[36mEXECUTE (0.0ms)[0m [1mUSE [activerecord_unittest2][0m | |
[1m[35mSQL (0.0ms)[0m SELECT DB_NAME() | |
[1m[36mEXECUTE (0.0ms)[0m [1mUSE [activerecord_unittest][0m | |
[1m[35mSQL (1.0ms)[0m SELECT DB_NAME() | |
[1m[36mEXECUTE (1.0ms)[0m [1mSELECT 1[0m | |
[1m[35mEXECUTE (0.0ms)[0m SELECT 1 | |
[1m[36mEXECUTE (1.0ms)[0m [1mSELECT * FROM [topics][0m | |
[1m[35mSQL (0.0ms)[0m SELECT * FROM [topics] | |
[1m[36mIDENTITY_INSERT (1.0ms)[0m [1mSET IDENTITY_INSERT [accounts] ON[0m | |
[1m[35mEXECUTE (1.0ms)[0m INSERT INTO accounts ([id], [firm_id],[credit_limit]) values (999, 1, 50) | |
[1m[36mIDENTITY_INSERT (0.0ms)[0m [1mSET IDENTITY_INSERT [accounts] OFF[0m | |
[1m[35mSQL (1.0ms)[0m SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident | |
[1m[36mEXECUTE (2.0ms)[0m [1mINSERT INTO accounts ([firm_id],[credit_limit]) values (1, 50)[0m | |
[1m[35mSQL (0.0ms)[0m SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident | |
[1m[36mEXECUTE (0.0ms)[0m [1mSELECT * FROM [topics][0m | |
[1m[35mEXECUTE (1.0ms)[0m BEGIN TRANSACTION | |
[1m[36mAuthor Load (3.0ms)[0m [1mSELECT TOP (1) [authors].* FROM [authors] WHERE ([authors].[id] = 1)[0m | |
[1m[35mSQL (9.0ms)[0m 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) | |
[1m[36mEXECUTE (0.0ms)[0m [1mROLLBACK TRANSACTION[0m | |
[1m[35mEXECUTE (0.0ms)[0m BEGIN TRANSACTION | |
[1m[36mExecute Procedure (75.0ms)[0m [1mEXEC sp_helpconstraint N'accounts'[0m | |
[1m[35mEXECUTE (0.0ms)[0m ROLLBACK TRANSACTION | |
[1m[36mEXECUTE (0.0ms)[0m [1mBEGIN TRANSACTION[0m | |
[1m[35mExecute Procedure (49.0ms)[0m EXEC sp_tables | |
[1m[36mEXECUTE (0.0ms)[0m [1mROLLBACK TRANSACTION[0m | |
[1m[35mEXECUTE (0.0ms)[0m BEGIN TRANSACTION | |
[1m[36mExecute Procedure (3.0ms)[0m [1mEXEC sp_tables N'sql_server_chronics'[0m | |
[1m[35mEXECUTE (1.0ms)[0m ROLLBACK TRANSACTION | |
[1m[36mEXECUTE (0.0ms)[0m [1mBEGIN TRANSACTION[0m | |
[1m[35mEXECUTE (1.0ms)[0m ROLLBACK TRANSACTION | |
[1m[36mEXECUTE (0.0ms)[0m [1mBEGIN TRANSACTION[0m | |
[1m[35mEXECUTE (0.0ms)[0m ROLLBACK TRANSACTION | |
[1m[36mEXECUTE (0.0ms)[0m [1mBEGIN TRANSACTION[0m | |
[1m[35mEXECUTE (1.0ms)[0m delete from countries_treaties | |
[1m[36mEXECUTE (0.0ms)[0m [1mSAVE TRANSACTION active_record_1[0m | |
[1m[35mEXECUTE (1.0ms)[0m INSERT INTO [countries] ([country_id], [name]) VALUES (N'c1', N'India') | |
[1m[36mSQL (0.0ms)[0m [1mSELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident[0m | |
[1m[35mEXECUTE (0.0ms)[0m SAVE TRANSACTION active_record_1 | |
[1m[36mEXECUTE (1.0ms)[0m [1mINSERT INTO [treaties] ([name], [treaty_id]) VALUES (N'peace', N't1')[0m | |
[1m[35mSQL (0.0ms)[0m SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident | |
[1m[36mEXECUTE (1.0ms)[0m [1mINSERT 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')[0m | |
[1m[35mSQL (1.0ms)[0m SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident | |
[1m[36mSQL (1.0ms)[0m [1mselect * from countries_treaties[0m | |
[1m[35mEXECUTE (0.0ms)[0m ROLLBACK TRANSACTION | |
[1m[36mEXECUTE (0.0ms)[0m [1mBEGIN TRANSACTION[0m | |
[1m[35mAccount Load (2.0ms)[0m SELECT TOP (1) [accounts].* FROM [accounts] WHERE ([accounts].[id] = 1) | |
[1m[36mCompany Load (2.0ms)[0m [1mSELECT [companies].* FROM [companies] WHERE ([companies].[id] = 1)[0m | |
[1m[35mEXECUTE (0.0ms)[0m ROLLBACK TRANSACTION | |
[1m[36mEXECUTE (0.0ms)[0m [1mBEGIN TRANSACTION[0m | |
[1m[35mSQL (37.0ms)[0m EXEC sp_helpconstraint 'defaults','nomsg' | |
[1m[36mEXECUTE (2.0ms)[0m [1mALTER TABLE [defaults] ALTER COLUMN [decimal_number] decimal(4)[0m | |
[1m[35mSQL (28.0ms)[0m EXEC sp_helpconstraint 'defaults','nomsg' | |
[1m[36mEXECUTE (1.0ms)[0m [1mROLLBACK TRANSACTION[0m | |
[1m[35mEXECUTE (0.0ms)[0m BEGIN TRANSACTION | |
[1m[36mSQL (5.0ms)[0m [1mEXEC sp_helpconstraint 'people','nomsg'[0m | |
[1m[35mEXECUTE (0.0ms)[0m ALTER TABLE [people] DROP CONSTRAINT DF__people__lock_ver__7857F5CA | |
[1m[36mEXECUTE (2.0ms)[0m [1mALTER TABLE [people] ALTER COLUMN [lock_version] varchar(255)[0m | |
[1m[35mEXECUTE (1.0ms)[0m ROLLBACK TRANSACTION | |
[1m[36mEXECUTE (0.0ms)[0m [1mBEGIN TRANSACTION[0m | |
[1m[35mEXECUTE (1.0ms)[0m CREATE TABLE [schema_migrations] ([version] varchar(255) NOT NULL) | |
[1m[36mSQL (0.0ms)[0m [1mEXEC sp_helpindex [schema_migrations][0m | |
[1m[35mEXECUTE (1.0ms)[0m CREATE UNIQUE INDEX [unique_schema_migrations] ON [schema_migrations] ([version]) | |
[1m[36mSQL (1.0ms)[0m [1mSELECT [schema_migrations].[version] FROM [schema_migrations][0m | |
Migrating to TableWillNeverBeCreated (1) | |
[1m[35mEXECUTE (0.0ms)[0m SAVE TRANSACTION active_record_1 | |
[1m[36mEXECUTE (1.0ms)[0m [1mCREATE TABLE [sqlserver_trans_table1] ([id] int NOT NULL IDENTITY(1,1) PRIMARY KEY) [0m | |
[1m[35mEXECUTE (1.0ms)[0m ROLLBACK TRANSACTION active_record_1 | |
[1m[36mEXECUTE (0.0ms)[0m [1mROLLBACK TRANSACTION[0m | |
[1m[35mEXECUTE (0.0ms)[0m BEGIN TRANSACTION | |
[1m[36mDeveloper Load (4.0ms)[0m [1mSELECT TOP (1) [developers].* FROM [developers] WHERE ([developers].[id] = 11)[0m | |
[1m[35mDeveloper Load (3.0ms)[0m 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 | |
[1m[36mEXECUTE (1.0ms)[0m [1mROLLBACK TRANSACTION[0m | |
[1m[35mEXECUTE (0.0ms)[0m BEGIN TRANSACTION | |
[1m[36mEXECUTE (1.0ms)[0m [1mDELETE FROM [books][0m | |
[1m[35mSQL (0.0ms)[0m SELECT @@ROWCOUNT AS AffectedRows | |
[1m[36mEXECUTE (1.0ms)[0m [1mSAVE TRANSACTION active_record_1[0m | |
[1m[35mEXECUTE (0.0ms)[0m INSERT INTO [books] ([name]) VALUES (NULL) | |
[1m[36mSQL (0.0ms)[0m [1mSELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident[0m | |
[1m[35mEXECUTE (1.0ms)[0m SAVE TRANSACTION active_record_1 | |
[1m[36mEXECUTE (0.0ms)[0m [1mINSERT INTO [books] ([name]) VALUES (NULL)[0m | |
[1m[35mSQL (1.0ms)[0m SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident | |
[1m[36mEXECUTE (0.0ms)[0m [1mSAVE TRANSACTION active_record_1[0m | |
[1m[35mEXECUTE (0.0ms)[0m INSERT INTO [books] ([name]) VALUES (NULL) | |
[1m[36mSQL (1.0ms)[0m [1mSELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident[0m | |
[1m[35mEXECUTE (0.0ms)[0m SAVE TRANSACTION active_record_1 | |
[1m[36mEXECUTE (0.0ms)[0m [1mINSERT INTO [books] ([name]) VALUES (NULL)[0m | |
[1m[35mSQL (0.0ms)[0m SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident | |
[1m[36mEXECUTE (0.0ms)[0m [1mSAVE TRANSACTION active_record_1[0m | |
[1m[35mEXECUTE (0.0ms)[0m INSERT INTO [books] ([name]) VALUES (NULL) | |
[1m[36mSQL (0.0ms)[0m [1mSELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident[0m | |
[1m[35mEXECUTE (0.0ms)[0m SAVE TRANSACTION active_record_1 | |
[1m[36mEXECUTE (0.0ms)[0m [1mINSERT INTO [books] ([name]) VALUES (NULL)[0m | |
[1m[35mSQL (0.0ms)[0m SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident | |
[1m[36mEXECUTE (1.0ms)[0m [1mSAVE TRANSACTION active_record_1[0m | |
[1m[35mEXECUTE (0.0ms)[0m INSERT INTO [books] ([name]) VALUES (NULL) | |
[1m[36mSQL (0.0ms)[0m [1mSELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident[0m | |
[1m[35mEXECUTE (0.0ms)[0m SAVE TRANSACTION active_record_1 | |
[1m[36mEXECUTE (0.0ms)[0m [1mINSERT INTO [books] ([name]) VALUES (NULL)[0m | |
[1m[35mSQL (1.0ms)[0m SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident | |
[1m[36mEXECUTE (0.0ms)[0m [1mSAVE TRANSACTION active_record_1[0m | |
[1m[35mEXECUTE (0.0ms)[0m INSERT INTO [books] ([name]) VALUES (NULL) | |
[1m[36mSQL (0.0ms)[0m [1mSELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident[0m | |
[1m[35mEXECUTE (1.0ms)[0m SAVE TRANSACTION active_record_1 | |
[1m[36mEXECUTE (0.0ms)[0m [1mINSERT INTO [books] ([name]) VALUES (NULL)[0m | |
[1m[35mSQL (0.0ms)[0m SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident | |
[1m[36mBook Load (7.0ms)[0m [1mSELECT 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[0m | |
[1m[35mSQL (1.0ms)[0m 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 | |
[1m[36mEXECUTE (0.0ms)[0m [1mSAVE TRANSACTION active_record_1[0m | |
[1m[35mEXECUTE (1.0ms)[0m DELETE FROM [books] WHERE ([books].[id] = 1) | |
[1m[36mSQL (0.0ms)[0m [1mSELECT @@ROWCOUNT AS AffectedRows[0m | |
[1m[35mEXECUTE (0.0ms)[0m SAVE TRANSACTION active_record_1 | |
[1m[36mEXECUTE (0.0ms)[0m [1mDELETE FROM [books] WHERE ([books].[id] = 2)[0m | |
[1m[35mSQL (0.0ms)[0m SELECT @@ROWCOUNT AS AffectedRows | |
[1m[36mEXECUTE (0.0ms)[0m [1mSAVE TRANSACTION active_record_1[0m | |
[1m[35mEXECUTE (1.0ms)[0m DELETE FROM [books] WHERE ([books].[id] = 3) | |
[1m[36mSQL (0.0ms)[0m [1mSELECT @@ROWCOUNT AS AffectedRows[0m | |
[1m[35mEXECUTE (0.0ms)[0m SAVE TRANSACTION active_record_1 | |
[1m[36mEXECUTE (0.0ms)[0m [1mDELETE FROM [books] WHERE ([books].[id] = 4)[0m | |
[1m[35mSQL (0.0ms)[0m SELECT @@ROWCOUNT AS AffectedRows | |
[1m[36mEXECUTE (0.0ms)[0m [1mSAVE TRANSACTION active_record_1[0m | |
[1m[35mEXECUTE (0.0ms)[0m DELETE FROM [books] WHERE ([books].[id] = 5) | |
[1m[36mSQL (0.0ms)[0m [1mSELECT @@ROWCOUNT AS AffectedRows[0m | |
[1m[35mEXECUTE (0.0ms)[0m SAVE TRANSACTION active_record_1 | |
[1m[36mEXECUTE (0.0ms)[0m [1mDELETE FROM [books] WHERE ([books].[id] = 6)[0m | |
[1m[35mSQL (1.0ms)[0m SELECT @@ROWCOUNT AS AffectedRows | |
[1m[36mEXECUTE (0.0ms)[0m [1mSAVE TRANSACTION active_record_1[0m | |
[1m[35mEXECUTE (1.0ms)[0m DELETE FROM [books] WHERE ([books].[id] = 7) | |
[1m[36mSQL (0.0ms)[0m [1mSELECT @@ROWCOUNT AS AffectedRows[0m | |
[1m[35mEXECUTE (0.0ms)[0m SAVE TRANSACTION active_record_1 | |
[1m[36mEXECUTE (1.0ms)[0m [1mDELETE FROM [books] WHERE ([books].[id] = 8)[0m | |
[1m[35mSQL (0.0ms)[0m SELECT @@ROWCOUNT AS AffectedRows | |
[1m[36mEXECUTE (1.0ms)[0m [1mSAVE TRANSACTION active_record_1[0m | |
[1m[35mEXECUTE (0.0ms)[0m DELETE FROM [books] WHERE ([books].[id] = 9) | |
[1m[36mSQL (0.0ms)[0m [1mSELECT @@ROWCOUNT AS AffectedRows[0m | |
[1m[35mEXECUTE (0.0ms)[0m SAVE TRANSACTION active_record_1 | |
[1m[36mEXECUTE (1.0ms)[0m [1mDELETE FROM [books] WHERE ([books].[id] = 10)[0m | |
[1m[35mSQL (0.0ms)[0m SELECT @@ROWCOUNT AS AffectedRows | |
[1m[36mEXECUTE (1.0ms)[0m [1mROLLBACK TRANSACTION[0m | |
[1m[35mEXECUTE (0.0ms)[0m BEGIN TRANSACTION | |
[1m[36mEXECUTE (0.0ms)[0m [1mDELETE FROM [books][0m | |
[1m[35mSQL (0.0ms)[0m SELECT @@ROWCOUNT AS AffectedRows | |
[1m[36mEXECUTE (1.0ms)[0m [1mSAVE TRANSACTION active_record_1[0m | |
[1m[35mEXECUTE (0.0ms)[0m INSERT INTO [books] ([name]) VALUES (NULL) | |
[1m[36mSQL (1.0ms)[0m [1mSELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident[0m | |
[1m[35mEXECUTE (0.0ms)[0m SAVE TRANSACTION active_record_1 | |
[1m[36mEXECUTE (0.0ms)[0m [1mINSERT INTO [books] ([name]) VALUES (NULL)[0m | |
[1m[35mSQL (0.0ms)[0m SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident | |
[1m[36mEXECUTE (0.0ms)[0m [1mSAVE TRANSACTION active_record_1[0m | |
[1m[35mEXECUTE (0.0ms)[0m INSERT INTO [books] ([name]) VALUES (NULL) | |
[1m[36mSQL (0.0ms)[0m [1mSELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident[0m | |
[1m[35mEXECUTE (0.0ms)[0m SAVE TRANSACTION active_record_1 | |
[1m[36mEXECUTE (1.0ms)[0m [1mINSERT INTO [books] ([name]) VALUES (NULL)[0m | |
[1m[35mSQL (0.0ms)[0m SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident | |
[1m[36mEXECUTE (0.0ms)[0m [1mSAVE TRANSACTION active_record_1[0m | |
[1m[35mEXECUTE (0.0ms)[0m INSERT INTO [books] ([name]) VALUES (NULL) | |
[1m[36mSQL (0.0ms)[0m [1mSELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident[0m | |
[1m[35mEXECUTE (0.0ms)[0m SAVE TRANSACTION active_record_1 | |
[1m[36mEXECUTE (1.0ms)[0m [1mINSERT INTO [books] ([name]) VALUES (NULL)[0m | |
[1m[35mSQL (0.0ms)[0m SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident | |
[1m[36mEXECUTE (0.0ms)[0m [1mSAVE TRANSACTION active_record_1[0m | |
[1m[35mEXECUTE (0.0ms)[0m INSERT INTO [books] ([name]) VALUES (NULL) | |
[1m[36mSQL (0.0ms)[0m [1mSELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident[0m | |
[1m[35mEXECUTE (0.0ms)[0m SAVE TRANSACTION active_record_1 | |
[1m[36mEXECUTE (0.0ms)[0m [1mINSERT INTO [books] ([name]) VALUES (NULL)[0m | |
[1m[35mSQL (1.0ms)[0m SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident | |
[1m[36mEXECUTE (0.0ms)[0m [1mSAVE TRANSACTION active_record_1[0m | |
[1m[35mEXECUTE (0.0ms)[0m INSERT INTO [books] ([name]) VALUES (NULL) | |
[1m[36mSQL (0.0ms)[0m [1mSELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident[0m | |
[1m[35mEXECUTE (0.0ms)[0m SAVE TRANSACTION active_record_1 | |
[1m[36mEXECUTE (0.0ms)[0m [1mINSERT INTO [books] ([name]) VALUES (NULL)[0m | |
[1m[35mSQL (0.0ms)[0m SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident | |
[1m[36mBook Load (0.0ms)[0m [1mSELECT TOP (3) [__rnt].* FROM ( SELECT ROW_NUMBER() OVER (ORDER BY [books].[id]) AS [__rn], [books].* FROM [books] ) AS [__rnt] WHERE [__rnt].[__rn] > 5[0m | |
[1m[35mEXECUTE (0.0ms)[0m SAVE TRANSACTION active_record_1 | |
[1m[36mEXECUTE (0.0ms)[0m [1mDELETE FROM [books] WHERE ([books].[id] = 11)[0m | |
[1m[35mSQL (0.0ms)[0m SELECT @@ROWCOUNT AS AffectedRows | |
[1m[36mEXECUTE (0.0ms)[0m [1mSAVE TRANSACTION active_record_1[0m | |
[1m[35mEXECUTE (0.0ms)[0m DELETE FROM [books] WHERE ([books].[id] = 12) | |
[1m[36mSQL (0.0ms)[0m [1mSELECT @@ROWCOUNT AS AffectedRows[0m | |
[1m[35mEXECUTE (0.0ms)[0m SAVE TRANSACTION active_record_1 | |
[1m[36mEXECUTE (0.0ms)[0m [1mDELETE FROM [books] WHERE ([books].[id] = 13)[0m | |
[1m[35mSQL (0.0ms)[0m SELECT @@ROWCOUNT AS AffectedRows | |
[1m[36mEXECUTE (0.0ms)[0m [1mSAVE TRANSACTION active_record_1[0m | |
[1m[35mEXECUTE (0.0ms)[0m DELETE FROM [books] WHERE ([books].[id] = 14) | |
[1m[36mSQL (0.0ms)[0m [1mSELECT @@ROWCOUNT AS AffectedRows[0m | |
[1m[35mEXECUTE (0.0ms)[0m SAVE TRANSACTION active_record_1 | |
[1m[36mEXECUTE (0.0ms)[0m [1mDELETE FROM [books] WHERE ([books].[id] = 15)[0m | |
[1m[35mSQL (0.0ms)[0m SELECT @@ROWCOUNT AS AffectedRows | |
[1m[36mEXECUTE (0.0ms)[0m [1mSAVE TRANSACTION active_record_1[0m | |
[1m[35mEXECUTE (0.0ms)[0m DELETE FROM [books] WHERE ([books].[id] = 16) | |
[1m[36mSQL (0.0ms)[0m [1mSELECT @@ROWCOUNT AS AffectedRows[0m | |
[1m[35mEXECUTE (0.0ms)[0m SAVE TRANSACTION active_record_1 | |
[1m[36mEXECUTE (0.0ms)[0m [1mDELETE FROM [books] WHERE ([books].[id] = 17)[0m | |
[1m[35mSQL (0.0ms)[0m SELECT @@ROWCOUNT AS AffectedRows | |
[1m[36mEXECUTE (1.0ms)[0m [1mSAVE TRANSACTION active_record_1[0m | |
[1m[35mEXECUTE (0.0ms)[0m DELETE FROM [books] WHERE ([books].[id] = 18) | |
[1m[36mSQL (0.0ms)[0m [1mSELECT @@ROWCOUNT AS AffectedRows[0m | |
[1m[35mEXECUTE (1.0ms)[0m SAVE TRANSACTION active_record_1 | |
[1m[36mEXECUTE (0.0ms)[0m [1mDELETE FROM [books] WHERE ([books].[id] = 19)[0m | |
[1m[35mSQL (0.0ms)[0m SELECT @@ROWCOUNT AS AffectedRows | |
[1m[36mEXECUTE (1.0ms)[0m [1mSAVE TRANSACTION active_record_1[0m | |
[1m[35mEXECUTE (0.0ms)[0m DELETE FROM [books] WHERE ([books].[id] = 20) | |
[1m[36mSQL (0.0ms)[0m [1mSELECT @@ROWCOUNT AS AffectedRows[0m | |
[1m[35mEXECUTE (0.0ms)[0m ROLLBACK TRANSACTION | |
[1m[36mEXECUTE (0.0ms)[0m [1mBEGIN TRANSACTION[0m | |
[1m[35mEXECUTE (0.0ms)[0m DELETE FROM [books] | |
[1m[36mSQL (0.0ms)[0m [1mSELECT @@ROWCOUNT AS AffectedRows[0m | |
[1m[35mEXECUTE (0.0ms)[0m SAVE TRANSACTION active_record_1 | |
[1m[36mEXECUTE (0.0ms)[0m [1mINSERT INTO [books] ([name]) VALUES (NULL)[0m | |
[1m[35mSQL (1.0ms)[0m SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident | |
[1m[36mEXECUTE (0.0ms)[0m [1mSAVE TRANSACTION active_record_1[0m | |
[1m[35mEXECUTE (0.0ms)[0m INSERT INTO [books] ([name]) VALUES (NULL) | |
[1m[36mSQL (0.0ms)[0m [1mSELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident[0m | |
[1m[35mEXECUTE (0.0ms)[0m SAVE TRANSACTION active_record_1 | |
[1m[36mEXECUTE (0.0ms)[0m [1mINSERT INTO [books] ([name]) VALUES (NULL)[0m | |
[1m[35mSQL (0.0ms)[0m SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident | |
[1m[36mEXECUTE (1.0ms)[0m [1mSAVE TRANSACTION active_record_1[0m | |
[1m[35mEXECUTE (0.0ms)[0m INSERT INTO [books] ([name]) VALUES (NULL) | |
[1m[36mSQL (0.0ms)[0m [1mSELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident[0m | |
[1m[35mEXECUTE (0.0ms)[0m SAVE TRANSACTION active_record_1 | |
[1m[36mEXECUTE (0.0ms)[0m [1mINSERT INTO [books] ([name]) VALUES (NULL)[0m | |
[1m[35mSQL (1.0ms)[0m SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident | |
[1m[36mEXECUTE (0.0ms)[0m [1mSAVE TRANSACTION active_record_1[0m | |
[1m[35mEXECUTE (0.0ms)[0m INSERT INTO [books] ([name]) VALUES (NULL) | |
[1m[36mSQL (1.0ms)[0m [1mSELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident[0m | |
[1m[35mEXECUTE (0.0ms)[0m SAVE TRANSACTION active_record_1 | |
[1m[36mEXECUTE (0.0ms)[0m [1mINSERT INTO [books] ([name]) VALUES (NULL)[0m | |
[1m[35mSQL (0.0ms)[0m SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident | |
[1m[36mEXECUTE (0.0ms)[0m [1mSAVE TRANSACTION active_record_1[0m | |
[1m[35mEXECUTE (0.0ms)[0m INSERT INTO [books] ([name]) VALUES (NULL) | |
[1m[36mSQL (1.0ms)[0m [1mSELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident[0m | |
[1m[35mEXECUTE (0.0ms)[0m SAVE TRANSACTION active_record_1 | |
[1m[36mEXECUTE (0.0ms)[0m [1mINSERT INTO [books] ([name]) VALUES (NULL)[0m | |
[1m[35mSQL (0.0ms)[0m SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident | |
[1m[36mEXECUTE (0.0ms)[0m [1mSAVE TRANSACTION active_record_1[0m | |
[1m[35mEXECUTE (0.0ms)[0m INSERT INTO [books] ([name]) VALUES (NULL) | |
[1m[36mSQL (1.0ms)[0m [1mSELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident[0m | |
[1m[35mBook Load (1.0ms)[0m SELECT TOP (10) [__rnt].* FROM ( SELECT ROW_NUMBER() OVER (ORDER BY [books].[id]) AS [__rn], [books].* FROM [books] ) AS [__rnt] WHERE [__rnt].[__rn] > 5 | |
[1m[36mEXECUTE (1.0ms)[0m [1mSAVE TRANSACTION active_record_1[0m | |
[1m[35mEXECUTE (0.0ms)[0m DELETE FROM [books] WHERE ([books].[id] = 21) | |
[1m[36mSQL (0.0ms)[0m [1mSELECT @@ROWCOUNT AS AffectedRows[0m | |
[1m[35mEXECUTE (1.0ms)[0m SAVE TRANSACTION active_record_1 | |
[1m[36mEXECUTE (0.0ms)[0m [1mDELETE FROM [books] WHERE ([books].[id] = 22)[0m | |
[1m[35mSQL (0.0ms)[0m SELECT @@ROWCOUNT AS AffectedRows | |
[1m[36mEXECUTE (1.0ms)[0m [1mSAVE TRANSACTION active_record_1[0m | |
[1m[35mEXECUTE (0.0ms)[0m DELETE FROM [books] WHERE ([books].[id] = 23) | |
[1m[36mSQL (0.0ms)[0m [1mSELECT @@ROWCOUNT AS AffectedRows[0m | |
[1m[35mEXECUTE (1.0ms)[0m SAVE TRANSACTION active_record_1 | |
[1m[36mEXECUTE (0.0ms)[0m [1mDELETE FROM [books] WHERE ([books].[id] = 24)[0m | |
[1m[35mSQL (0.0ms)[0m SELECT @@ROWCOUNT AS AffectedRows | |
[1m[36mEXECUTE (1.0ms)[0m [1mSAVE TRANSACTION active_record_1[0m | |
[1m[35mEXECUTE (0.0ms)[0m DELETE FROM [books] WHERE ([books].[id] = 25) | |
[1m[36mSQL (0.0ms)[0m [1mSELECT @@ROWCOUNT AS AffectedRows[0m | |
[1m[35mEXECUTE (1.0ms)[0m SAVE TRANSACTION active_record_1 | |
[1m[36mEXECUTE (0.0ms)[0m [1mDELETE FROM [books] WHERE ([books].[id] = 26)[0m | |
[1m[35mSQL (0.0ms)[0m SELECT @@ROWCOUNT AS AffectedRows | |
[1m[36mEXECUTE (0.0ms)[0m [1mSAVE TRANSACTION active_record_1[0m | |
[1m[35mEXECUTE (0.0ms)[0m DELETE FROM [books] WHERE ([books].[id] = 27) | |
[1m[36mSQL (0.0ms)[0m [1mSELECT @@ROWCOUNT AS AffectedRows[0m | |
[1m[35mEXECUTE (0.0ms)[0m SAVE TRANSACTION active_record_1 | |
[1m[36mEXECUTE (0.0ms)[0m [1mDELETE FROM [books] WHERE ([books].[id] = 28)[0m | |
[1m[35mSQL (0.0ms)[0m SELECT @@ROWCOUNT AS AffectedRows | |
[1m[36mEXECUTE (0.0ms)[0m [1mSAVE TRANSACTION active_record_1[0m | |
[1m[35mEXECUTE (0.0ms)[0m DELETE FROM [books] WHERE ([books].[id] = 29) | |
[1m[36mSQL (1.0ms)[0m [1mSELECT @@ROWCOUNT AS AffectedRows[0m | |
[1m[35mEXECUTE (0.0ms)[0m SAVE TRANSACTION active_record_1 | |
[1m[36mEXECUTE (1.0ms)[0m [1mDELETE FROM [books] WHERE ([books].[id] = 30)[0m | |
[1m[35mSQL (0.0ms)[0m SELECT @@ROWCOUNT AS AffectedRows | |
[1m[36mEXECUTE (1.0ms)[0m [1mROLLBACK TRANSACTION[0m | |
[1m[35mEXECUTE (0.0ms)[0m BEGIN TRANSACTION | |
[1m[36mEXECUTE (1.0ms)[0m [1mDELETE FROM [books][0m | |
[1m[35mSQL (0.0ms)[0m SELECT @@ROWCOUNT AS AffectedRows | |
[1m[36mEXECUTE (0.0ms)[0m [1mSAVE TRANSACTION active_record_1[0m | |
[1m[35mEXECUTE (0.0ms)[0m INSERT INTO [books] ([name]) VALUES (NULL) | |
[1m[36mSQL (0.0ms)[0m [1mSELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident[0m | |
[1m[35mEXECUTE (1.0ms)[0m SAVE TRANSACTION active_record_1 | |
[1m[36mEXECUTE (0.0ms)[0m [1mINSERT INTO [books] ([name]) VALUES (NULL)[0m | |
[1m[35mSQL (1.0ms)[0m SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident | |
[1m[36mEXECUTE (0.0ms)[0m [1mSAVE TRANSACTION active_record_1[0m | |
[1m[35mEXECUTE (1.0ms)[0m INSERT INTO [books] ([name]) VALUES (NULL) | |
[1m[36mSQL (0.0ms)[0m [1mSELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident[0m | |
[1m[35mEXECUTE (0.0ms)[0m SAVE TRANSACTION active_record_1 | |
[1m[36mEXECUTE (0.0ms)[0m [1mINSERT INTO [books] ([name]) VALUES (NULL)[0m | |
[1m[35mSQL (0.0ms)[0m SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident | |
[1m[36mEXECUTE (0.0ms)[0m [1mSAVE TRANSACTION active_record_1[0m | |
[1m[35mEXECUTE (1.0ms)[0m INSERT INTO [books] ([name]) VALUES (NULL) | |
[1m[36mSQL (0.0ms)[0m [1mSELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident[0m | |
[1m[35mEXECUTE (0.0ms)[0m SAVE TRANSACTION active_record_1 | |
[1m[36mEXECUTE (0.0ms)[0m [1mINSERT INTO [books] ([name]) VALUES (NULL)[0m | |
[1m[35mSQL (0.0ms)[0m SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident | |
[1m[36mEXECUTE (0.0ms)[0m [1mSAVE TRANSACTION active_record_1[0m | |
[1m[35mEXECUTE (0.0ms)[0m INSERT INTO [books] ([name]) VALUES (NULL) | |
[1m[36mSQL (0.0ms)[0m [1mSELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident[0m | |
[1m[35mEXECUTE (0.0ms)[0m SAVE TRANSACTION active_record_1 | |
[1m[36mEXECUTE (0.0ms)[0m [1mINSERT INTO [books] ([name]) VALUES (NULL)[0m | |
[1m[35mSQL (0.0ms)[0m SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident | |
[1m[36mEXECUTE (0.0ms)[0m [1mSAVE TRANSACTION active_record_1[0m | |
[1m[35mEXECUTE (0.0ms)[0m INSERT INTO [books] ([name]) VALUES (NULL) | |
[1m[36mSQL (1.0ms)[0m [1mSELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident[0m | |
[1m[35mEXECUTE (0.0ms)[0m SAVE TRANSACTION active_record_1 | |
[1m[36mEXECUTE (0.0ms)[0m [1mINSERT INTO [books] ([name]) VALUES (NULL)[0m | |
[1m[35mSQL (0.0ms)[0m SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident | |
[1m[36mBook Load (1.0ms)[0m [1mSELECT TOP (10) [__rnt].* FROM ( SELECT ROW_NUMBER() OVER (ORDER BY [books].[id]) AS [__rn], [books].* FROM [books] ) AS [__rnt] WHERE [__rnt].[__rn] > 0[0m | |
[1m[35mEXECUTE (0.0ms)[0m SAVE TRANSACTION active_record_1 | |
[1m[36mEXECUTE (0.0ms)[0m [1mDELETE FROM [books] WHERE ([books].[id] = 31)[0m | |
[1m[35mSQL (0.0ms)[0m SELECT @@ROWCOUNT AS AffectedRows | |
[1m[36mEXECUTE (0.0ms)[0m [1mSAVE TRANSACTION active_record_1[0m | |
[1m[35mEXECUTE (0.0ms)[0m DELETE FROM [books] WHERE ([books].[id] = 32) | |
[1m[36mSQL (0.0ms)[0m [1mSELECT @@ROWCOUNT AS AffectedRows[0m | |
[1m[35mEXECUTE (0.0ms)[0m SAVE TRANSACTION active_record_1 | |
[1m[36mEXECUTE (0.0ms)[0m [1mDELETE FROM [books] WHERE ([books].[id] = 33)[0m | |
[1m[35mSQL (0.0ms)[0m SELECT @@ROWCOUNT AS AffectedRows | |
[1m[36mEXECUTE (0.0ms)[0m [1mSAVE TRANSACTION active_record_1[0m | |
[1m[35mEXECUTE (0.0ms)[0m DELETE FROM [books] WHERE ([books].[id] = 34) | |
[1m[36mSQL (0.0ms)[0m [1mSELECT @@ROWCOUNT AS AffectedRows[0m | |
[1m[35mEXECUTE (0.0ms)[0m SAVE TRANSACTION active_record_1 | |
[1m[36mEXECUTE (0.0ms)[0m [1mDELETE FROM [books] WHERE ([books].[id] = 35)[0m | |
[1m[35mSQL (0.0ms)[0m SELECT @@ROWCOUNT AS AffectedRows | |
[1m[36mEXECUTE (0.0ms)[0m [1mSAVE TRANSACTION active_record_1[0m | |
[1m[35mEXECUTE (0.0ms)[0m DELETE FROM [books] WHERE ([books].[id] = 36) | |
[1m[36mSQL (0.0ms)[0m [1mSELECT @@ROWCOUNT AS AffectedRows[0m | |
[1m[35mEXECUTE (0.0ms)[0m SAVE TRANSACTION active_record_1 | |
[1m[36mEXECUTE (0.0ms)[0m [1mDELETE FROM [books] WHERE ([books].[id] = 37)[0m | |
[1m[35mSQL (0.0ms)[0m SELECT @@ROWCOUNT AS AffectedRows | |
[1m[36mEXECUTE (0.0ms)[0m [1mSAVE TRANSACTION active_record_1[0m | |
[1m[35mEXECUTE (0.0ms)[0m DELETE FROM [books] WHERE ([books].[id] = 38) | |
[1m[36mSQL (0.0ms)[0m [1mSELECT @@ROWCOUNT AS AffectedRows[0m | |
[1m[35mEXECUTE (0.0ms)[0m SAVE TRANSACTION active_record_1 | |
[1m[36mEXECUTE (0.0ms)[0m [1mDELETE FROM [books] WHERE ([books].[id] = 39)[0m | |
[1m[35mSQL (0.0ms)[0m SELECT @@ROWCOUNT AS AffectedRows | |
[1m[36mEXECUTE (0.0ms)[0m [1mSAVE TRANSACTION active_record_1[0m | |
[1m[35mEXECUTE (0.0ms)[0m DELETE FROM [books] WHERE ([books].[id] = 40) | |
[1m[36mSQL (0.0ms)[0m [1mSELECT @@ROWCOUNT AS AffectedRows[0m | |
[1m[35mEXECUTE (0.0ms)[0m ROLLBACK TRANSACTION | |
[1m[36mEXECUTE (0.0ms)[0m [1mBEGIN TRANSACTION[0m | |
[1m[35mEXECUTE (0.0ms)[0m DELETE FROM [books] | |
[1m[36mSQL (0.0ms)[0m [1mSELECT @@ROWCOUNT AS AffectedRows[0m | |
[1m[35mEXECUTE (0.0ms)[0m SAVE TRANSACTION active_record_1 | |
[1m[36mEXECUTE (0.0ms)[0m [1mINSERT INTO [books] ([name]) VALUES (NULL)[0m | |
[1m[35mSQL (0.0ms)[0m SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident | |
[1m[36mEXECUTE (0.0ms)[0m [1mSAVE TRANSACTION active_record_1[0m | |
[1m[35mEXECUTE (0.0ms)[0m INSERT INTO [books] ([name]) VALUES (NULL) | |
[1m[36mSQL (0.0ms)[0m [1mSELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident[0m | |
[1m[35mEXECUTE (0.0ms)[0m SAVE TRANSACTION active_record_1 | |
[1m[36mEXECUTE (0.0ms)[0m [1mINSERT INTO [books] ([name]) VALUES (NULL)[0m | |
[1m[35mSQL (1.0ms)[0m SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident | |
[1m[36mEXECUTE (0.0ms)[0m [1mSAVE TRANSACTION active_record_1[0m | |
[1m[35mEXECUTE (0.0ms)[0m INSERT INTO [books] ([name]) VALUES (NULL) | |
[1m[36mSQL (0.0ms)[0m [1mSELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident[0m | |
[1m[35mEXECUTE (0.0ms)[0m SAVE TRANSACTION active_record_1 | |
[1m[36mEXECUTE (0.0ms)[0m [1mINSERT INTO [books] ([name]) VALUES (NULL)[0m | |
[1m[35mSQL (1.0ms)[0m SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident | |
[1m[36mEXECUTE (0.0ms)[0m [1mSAVE TRANSACTION active_record_1[0m | |
[1m[35mEXECUTE (1.0ms)[0m INSERT INTO [books] ([name]) VALUES (NULL) | |
[1m[36mSQL (0.0ms)[0m [1mSELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident[0m | |
[1m[35mEXECUTE (0.0ms)[0m SAVE TRANSACTION active_record_1 | |
[1m[36mEXECUTE (0.0ms)[0m [1mINSERT INTO [books] ([name]) VALUES (NULL)[0m | |
[1m[35mSQL (0.0ms)[0m SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident | |
[1m[36mEXECUTE (0.0ms)[0m [1mSAVE TRANSACTION active_record_1[0m | |
[1m[35mEXECUTE (1.0ms)[0m INSERT INTO [books] ([name]) VALUES (NULL) | |
[1m[36mSQL (0.0ms)[0m [1mSELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident[0m | |
[1m[35mEXECUTE (1.0ms)[0m SAVE TRANSACTION active_record_1 | |
[1m[36mEXECUTE (0.0ms)[0m [1mINSERT INTO [books] ([name]) VALUES (NULL)[0m | |
[1m[35mSQL (1.0ms)[0m SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident | |
[1m[36mEXECUTE (0.0ms)[0m [1mSAVE TRANSACTION active_record_1[0m | |
[1m[35mEXECUTE (0.0ms)[0m INSERT INTO [books] ([name]) VALUES (NULL) | |
[1m[36mSQL (0.0ms)[0m [1mSELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident[0m | |
[1m[35mSQL (1.0ms)[0m SELECT COUNT(*) AS count_id FROM [posts] | |
[1m[36mSQL (2.0ms)[0m [1mSELECT 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[0m | |
[1m[35mSQL (1.0ms)[0m 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 | |
[1m[36mSQL (1.0ms)[0m [1mSELECT 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[0m | |
[1m[35mSQL (1.0ms)[0m 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 | |
[1m[36mSQL (1.0ms)[0m [1mSELECT 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[0m | |
[1m[35mSQL (1.0ms)[0m 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 | |
[1m[36mSQL (1.0ms)[0m [1mSELECT 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[0m | |
[1m[35mSQL (2.0ms)[0m 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 | |
[1m[36mSQL (1.0ms)[0m [1mSELECT 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[0m | |
[1m[35mEXECUTE (0.0ms)[0m SAVE TRANSACTION active_record_1 | |
[1m[36mEXECUTE (0.0ms)[0m [1mDELETE FROM [books] WHERE ([books].[id] = 41)[0m | |
[1m[35mSQL (0.0ms)[0m SELECT @@ROWCOUNT AS AffectedRows | |
[1m[36mEXECUTE (0.0ms)[0m [1mSAVE TRANSACTION active_record_1[0m | |
[1m[35mEXECUTE (1.0ms)[0m DELETE FROM [books] WHERE ([books].[id] = 42) | |
[1m[36mSQL (0.0ms)[0m [1mSELECT @@ROWCOUNT AS AffectedRows[0m | |
[1m[35mEXECUTE (1.0ms)[0m SAVE TRANSACTION active_record_1 | |
[1m[36mEXECUTE (0.0ms)[0m [1mDELETE FROM [books] WHERE ([books].[id] = 43)[0m | |
[1m[35mSQL (0.0ms)[0m SELECT @@ROWCOUNT AS AffectedRows | |
[1m[36mEXECUTE (0.0ms)[0m [1mSAVE TRANSACTION active_record_1[0m | |
[1m[35mEXECUTE (1.0ms)[0m DELETE FROM [books] WHERE ([books].[id] = 44) | |
[1m[36mSQL (0.0ms)[0m [1mSELECT @@ROWCOUNT AS AffectedRows[0m | |
[1m[35mEXECUTE (0.0ms)[0m SAVE TRANSACTION active_record_1 | |
[1m[36mEXECUTE (0.0ms)[0m [1mDELETE FROM [books] WHERE ([books].[id] = 45)[0m | |
[1m[35mSQL (0.0ms)[0m SELECT @@ROWCOUNT AS AffectedRows | |
[1m[36mEXECUTE (0.0ms)[0m [1mSAVE TRANSACTION active_record_1[0m | |
[1m[35mEXECUTE (0.0ms)[0m DELETE FROM [books] WHERE ([books].[id] = 46) | |
[1m[36mSQL (0.0ms)[0m [1mSELECT @@ROWCOUNT AS AffectedRows[0m | |
[1m[35mEXECUTE (0.0ms)[0m SAVE TRANSACTION active_record_1 | |
[1m[36mEXECUTE (0.0ms)[0m [1mDELETE FROM [books] WHERE ([books].[id] = 47)[0m | |
[1m[35mSQL (1.0ms)[0m SELECT @@ROWCOUNT AS AffectedRows | |
[1m[36mEXECUTE (0.0ms)[0m [1mSAVE TRANSACTION active_record_1[0m | |
[1m[35mEXECUTE (1.0ms)[0m DELETE FROM [books] WHERE ([books].[id] = 48) | |
[1m[36mSQL (0.0ms)[0m [1mSELECT @@ROWCOUNT AS AffectedRows[0m | |
[1m[35mEXECUTE (0.0ms)[0m SAVE TRANSACTION active_record_1 | |
[1m[36mEXECUTE (0.0ms)[0m [1mDELETE FROM [books] WHERE ([books].[id] = 49)[0m | |
[1m[35mSQL (0.0ms)[0m SELECT @@ROWCOUNT AS AffectedRows | |
[1m[36mEXECUTE (0.0ms)[0m [1mSAVE TRANSACTION active_record_1[0m | |
[1m[35mEXECUTE (0.0ms)[0m DELETE FROM [books] WHERE ([books].[id] = 50) | |
[1m[36mSQL (1.0ms)[0m [1mSELECT @@ROWCOUNT AS AffectedRows[0m | |
[1m[35mEXECUTE (0.0ms)[0m ROLLBACK TRANSACTION | |
[1m[36mEXECUTE (0.0ms)[0m [1mBEGIN TRANSACTION[0m | |
[1m[35mEXECUTE (0.0ms)[0m DELETE FROM [books] | |
[1m[36mSQL (0.0ms)[0m [1mSELECT @@ROWCOUNT AS AffectedRows[0m | |
[1m[35mEXECUTE (0.0ms)[0m SAVE TRANSACTION active_record_1 | |
[1m[36mEXECUTE (0.0ms)[0m [1mINSERT INTO [books] ([name]) VALUES (NULL)[0m | |
[1m[35mSQL (0.0ms)[0m SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident | |
[1m[36mEXECUTE (0.0ms)[0m [1mSAVE TRANSACTION active_record_1[0m | |
[1m[35mEXECUTE (0.0ms)[0m INSERT INTO [books] ([name]) VALUES (NULL) | |
[1m[36mSQL (0.0ms)[0m [1mSELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident[0m | |
[1m[35mEXECUTE (0.0ms)[0m SAVE TRANSACTION active_record_1 | |
[1m[36mEXECUTE (0.0ms)[0m [1mINSERT INTO [books] ([name]) VALUES (NULL)[0m | |
[1m[35mSQL (1.0ms)[0m SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident | |
[1m[36mEXECUTE (0.0ms)[0m [1mSAVE TRANSACTION active_record_1[0m | |
[1m[35mEXECUTE (0.0ms)[0m INSERT INTO [books] ([name]) VALUES (NULL) | |
[1m[36mSQL (0.0ms)[0m [1mSELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident[0m | |
[1m[35mEXECUTE (0.0ms)[0m SAVE TRANSACTION active_record_1 | |
[1m[36mEXECUTE (0.0ms)[0m [1mINSERT INTO [books] ([name]) VALUES (NULL)[0m | |
[1m[35mSQL (1.0ms)[0m SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident | |
[1m[36mEXECUTE (0.0ms)[0m [1mSAVE TRANSACTION active_record_1[0m | |
[1m[35mEXECUTE (0.0ms)[0m INSERT INTO [books] ([name]) VALUES (NULL) | |
[1m[36mSQL (0.0ms)[0m [1mSELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident[0m | |
[1m[35mEXECUTE (1.0ms)[0m SAVE TRANSACTION active_record_1 | |
[1m[36mEXECUTE (0.0ms)[0m [1mINSERT INTO [books] ([name]) VALUES (NULL)[0m | |
[1m[35mSQL (1.0ms)[0m SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident | |
[1m[36mEXECUTE (0.0ms)[0m [1mSAVE TRANSACTION active_record_1[0m | |
[1m[35mEXECUTE (0.0ms)[0m INSERT INTO [books] ([name]) VALUES (NULL) | |
[1m[36mSQL (0.0ms)[0m [1mSELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident[0m | |
[1m[35mEXECUTE (0.0ms)[0m SAVE TRANSACTION active_record_1 | |
[1m[36mEXECUTE (0.0ms)[0m [1mINSERT INTO [books] ([name]) VALUES (NULL)[0m | |
[1m[35mSQL (1.0ms)[0m SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident | |
[1m[36mEXECUTE (0.0ms)[0m [1mSAVE TRANSACTION active_record_1[0m | |
[1m[35mEXECUTE (0.0ms)[0m INSERT INTO [books] ([name]) VALUES (NULL) | |
[1m[36mSQL (0.0ms)[0m [1mSELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident[0m | |
[1m[35mBook Load (1.0ms)[0m SELECT TOP (10) [books].* FROM [books] | |
[1m[36mEXECUTE (0.0ms)[0m [1mSAVE TRANSACTION active_record_1[0m | |
[1m[35mEXECUTE (1.0ms)[0m DELETE FROM [books] WHERE ([books].[id] = 51) | |
[1m[36mSQL (0.0ms)[0m [1mSELECT @@ROWCOUNT AS AffectedRows[0m | |
[1m[35mEXECUTE (1.0ms)[0m SAVE TRANSACTION active_record_1 | |
[1m[36mEXECUTE (0.0ms)[0m [1mDELETE FROM [books] WHERE ([books].[id] = 52)[0m | |
[1m[35mSQL (0.0ms)[0m SELECT @@ROWCOUNT AS AffectedRows | |
[1m[36mEXECUTE (0.0ms)[0m [1mSAVE TRANSACTION active_record_1[0m | |
[1m[35mEXECUTE (0.0ms)[0m DELETE FROM [books] WHERE ([books].[id] = 53) | |
[1m[36mSQL (0.0ms)[0m [1mSELECT @@ROWCOUNT AS AffectedRows[0m | |
[1m[35mEXECUTE (0.0ms)[0m SAVE TRANSACTION active_record_1 | |
[1m[36mEXECUTE (0.0ms)[0m [1mDELETE FROM [books] WHERE ([books].[id] = 54)[0m | |
[1m[35mSQL (0.0ms)[0m SELECT @@ROWCOUNT AS AffectedRows | |
[1m[36mEXECUTE (0.0ms)[0m [1mSAVE TRANSACTION active_record_1[0m | |
[1m[35mEXECUTE (1.0ms)[0m DELETE FROM [books] WHERE ([books].[id] = 55) | |
[1m[36mSQL (0.0ms)[0m [1mSELECT @@ROWCOUNT AS AffectedRows[0m | |
[1m[35mEXECUTE (0.0ms)[0m SAVE TRANSACTION active_record_1 | |
[1m[36mEXECUTE (0.0ms)[0m [1mDELETE FROM [books] WHERE ([books].[id] = 56)[0m | |
[1m[35mSQL (0.0ms)[0m SELECT @@ROWCOUNT AS AffectedRows | |
[1m[36mEXECUTE (1.0ms)[0m [1mSAVE TRANSACTION active_record_1[0m | |
[1m[35mEXECUTE (0.0ms)[0m DELETE FROM [books] WHERE ([books].[id] = 57) | |
[1m[36mSQL (0.0ms)[0m [1mSELECT @@ROWCOUNT AS AffectedRows[0m | |
[1m[35mEXECUTE (0.0ms)[0m SAVE TRANSACTION active_record_1 | |
[1m[36mEXECUTE (0.0ms)[0m [1mDELETE FROM [books] WHERE ([books].[id] = 58)[0m | |
[1m[35mSQL (0.0ms)[0m SELECT @@ROWCOUNT AS AffectedRows | |
[1m[36mEXECUTE (0.0ms)[0m [1mSAVE TRANSACTION active_record_1[0m | |
[1m[35mEXECUTE (0.0ms)[0m DELETE FROM [books] WHERE ([books].[id] = 59) | |
[1m[36mSQL (1.0ms)[0m [1mSELECT @@ROWCOUNT AS AffectedRows[0m | |
[1m[35mEXECUTE (0.0ms)[0m SAVE TRANSACTION active_record_1 | |
[1m[36mEXECUTE (0.0ms)[0m [1mDELETE FROM [books] WHERE ([books].[id] = 60)[0m | |
[1m[35mSQL (0.0ms)[0m SELECT @@ROWCOUNT AS AffectedRows | |
[1m[36mEXECUTE (0.0ms)[0m [1mROLLBACK TRANSACTION[0m | |
[1m[35mEXECUTE (0.0ms)[0m BEGIN TRANSACTION | |
[1m[36mEXECUTE (0.0ms)[0m [1mDELETE FROM [books][0m | |
[1m[35mSQL (1.0ms)[0m SELECT @@ROWCOUNT AS AffectedRows | |
[1m[36mEXECUTE (0.0ms)[0m [1mSAVE TRANSACTION active_record_1[0m | |
[1m[35mEXECUTE (1.0ms)[0m INSERT INTO [books] ([name]) VALUES (NULL) | |
[1m[36mSQL (0.0ms)[0m [1mSELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident[0m | |
[1m[35mEXECUTE (0.0ms)[0m SAVE TRANSACTION active_record_1 | |
[1m[36mEXECUTE (0.0ms)[0m [1mINSERT INTO [books] ([name]) VALUES (NULL)[0m | |
[1m[35mSQL (0.0ms)[0m SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident | |
[1m[36mEXECUTE (0.0ms)[0m [1mSAVE TRANSACTION active_record_1[0m | |
[1m[35mEXECUTE (1.0ms)[0m INSERT INTO [books] ([name]) VALUES (NULL) | |
[1m[36mSQL (0.0ms)[0m [1mSELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident[0m | |
[1m[35mEXECUTE (0.0ms)[0m SAVE TRANSACTION active_record_1 | |
[1m[36mEXECUTE (0.0ms)[0m [1mINSERT INTO [books] ([name]) VALUES (NULL)[0m | |
[1m[35mSQL (0.0ms)[0m SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident | |
[1m[36mEXECUTE (0.0ms)[0m [1mSAVE TRANSACTION active_record_1[0m | |
[1m[35mEXECUTE (0.0ms)[0m INSERT INTO [books] ([name]) VALUES (NULL) | |
[1m[36mSQL (0.0ms)[0m [1mSELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident[0m | |
[1m[35mEXECUTE (0.0ms)[0m SAVE TRANSACTION active_record_1 | |
[1m[36mEXECUTE (0.0ms)[0m [1mINSERT INTO [books] ([name]) VALUES (NULL)[0m | |
[1m[35mSQL (0.0ms)[0m SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident | |
[1m[36mEXECUTE (1.0ms)[0m [1mSAVE TRANSACTION active_record_1[0m | |
[1m[35mEXECUTE (0.0ms)[0m INSERT INTO [books] ([name]) VALUES (NULL) | |
[1m[36mSQL (1.0ms)[0m [1mSELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident[0m | |
[1m[35mEXECUTE (0.0ms)[0m SAVE TRANSACTION active_record_1 | |
[1m[36mEXECUTE (0.0ms)[0m [1mINSERT INTO [books] ([name]) VALUES (NULL)[0m | |
[1m[35mSQL (1.0ms)[0m SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident | |
[1m[36mEXECUTE (0.0ms)[0m [1mSAVE TRANSACTION active_record_1[0m | |
[1m[35mEXECUTE (0.0ms)[0m INSERT INTO [books] ([name]) VALUES (NULL) | |
[1m[36mSQL (0.0ms)[0m [1mSELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident[0m | |
[1m[35mEXECUTE (0.0ms)[0m SAVE TRANSACTION active_record_1 | |
[1m[36mEXECUTE (0.0ms)[0m [1mINSERT INTO [books] ([name]) VALUES (NULL)[0m | |
[1m[35mSQL (0.0ms)[0m SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident | |
[1m[36mBook Load (1.0ms)[0m [1mSELECT TOP (20) [books].* FROM [books][0m | |
[1m[35mEXECUTE (1.0ms)[0m SAVE TRANSACTION active_record_1 | |
[1m[36mEXECUTE (0.0ms)[0m [1mDELETE FROM [books] WHERE ([books].[id] = 61)[0m | |
[1m[35mSQL (1.0ms)[0m SELECT @@ROWCOUNT AS AffectedRows | |
[1m[36mEXECUTE (0.0ms)[0m [1mSAVE TRANSACTION active_record_1[0m | |
[1m[35mEXECUTE (0.0ms)[0m DELETE FROM [books] WHERE ([books].[id] = 62) | |
[1m[36mSQL (1.0ms)[0m [1mSELECT @@ROWCOUNT AS AffectedRows[0m | |
[1m[35mEXECUTE (0.0ms)[0m SAVE TRANSACTION active_record_1 | |
[1m[36mEXECUTE (1.0ms)[0m [1mDELETE FROM [books] WHERE ([books].[id] = 63)[0m | |
[1m[35mSQL (0.0ms)[0m SELECT @@ROWCOUNT AS AffectedRows | |
[1m[36mEXECUTE (0.0ms)[0m [1mSAVE TRANSACTION active_record_1[0m | |
[1m[35mEXECUTE (1.0ms)[0m DELETE FROM [books] WHERE ([books].[id] = 64) | |
[1m[36mSQL (0.0ms)[0m [1mSELECT @@ROWCOUNT AS AffectedRows[0m | |
[1m[35mEXECUTE (0.0ms)[0m SAVE TRANSACTION active_record_1 | |
[1m[36mEXECUTE (1.0ms)[0m [1mDELETE FROM [books] WHERE ([books].[id] = 65)[0m | |
[1m[35mSQL (0.0ms)[0m SELECT @@ROWCOUNT AS AffectedRows | |
[1m[36mEXECUTE (0.0ms)[0m [1mSAVE TRANSACTION active_record_1[0m | |
[1m[35mEXECUTE (1.0ms)[0m DELETE FROM [books] WHERE ([books].[id] = 66) | |
[1m[36mSQL (0.0ms)[0m [1mSELECT @@ROWCOUNT AS AffectedRows[0m | |
[1m[35mEXECUTE (0.0ms)[0m SAVE TRANSACTION active_record_1 | |
[1m[36mEXECUTE (1.0ms)[0m [1mDELETE FROM [books] WHERE ([books].[id] = 67)[0m | |
[1m[35mSQL (0.0ms)[0m SELECT @@ROWCOUNT AS AffectedRows | |
[1m[36mEXECUTE (0.0ms)[0m [1mSAVE TRANSACTION active_record_1[0m | |
[1m[35mEXECUTE (1.0ms)[0m DELETE FROM [books] WHERE ([books].[id] = 68) | |
[1m[36mSQL (0.0ms)[0m [1mSELECT @@ROWCOUNT AS AffectedRows[0m | |
[1m[35mEXECUTE (0.0ms)[0m SAVE TRANSACTION active_record_1 | |
[1m[36mEXECUTE (1.0ms)[0m [1mDELETE FROM [books] WHERE ([books].[id] = 69)[0m | |
[1m[35mSQL (0.0ms)[0m SELECT @@ROWCOUNT AS AffectedRows | |
[1m[36mEXECUTE (0.0ms)[0m [1mSAVE TRANSACTION active_record_1[0m | |
[1m[35mEXECUTE (1.0ms)[0m DELETE FROM [books] WHERE ([books].[id] = 70) | |
[1m[36mSQL (0.0ms)[0m [1mSELECT @@ROWCOUNT AS AffectedRows[0m | |
[1m[35mEXECUTE (0.0ms)[0m ROLLBACK TRANSACTION | |
[1m[36mEXECUTE (0.0ms)[0m [1mBEGIN TRANSACTION[0m | |
[1m[35mEXECUTE (0.0ms)[0m DELETE FROM [books] | |
[1m[36mSQL (0.0ms)[0m [1mSELECT @@ROWCOUNT AS AffectedRows[0m | |
[1m[35mEXECUTE (0.0ms)[0m SAVE TRANSACTION active_record_1 | |
[1m[36mEXECUTE (0.0ms)[0m [1mINSERT INTO [books] ([name]) VALUES (NULL)[0m | |
[1m[35mSQL (1.0ms)[0m SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident | |
[1m[36mEXECUTE (0.0ms)[0m [1mSAVE TRANSACTION active_record_1[0m | |
[1m[35mEXECUTE (0.0ms)[0m INSERT INTO [books] ([name]) VALUES (NULL) | |
[1m[36mSQL (1.0ms)[0m [1mSELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident[0m | |
[1m[35mEXECUTE (1.0ms)[0m SAVE TRANSACTION active_record_1 | |
[1m[36mEXECUTE (0.0ms)[0m [1mINSERT INTO [books] ([name]) VALUES (NULL)[0m | |
[1m[35mSQL (1.0ms)[0m SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident | |
[1m[36mEXECUTE (0.0ms)[0m [1mSAVE TRANSACTION active_record_1[0m | |
[1m[35mEXECUTE (0.0ms)[0m INSERT INTO [books] ([name]) VALUES (NULL) | |
[1m[36mSQL (0.0ms)[0m [1mSELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident[0m | |
[1m[35mEXECUTE (0.0ms)[0m SAVE TRANSACTION active_record_1 | |
[1m[36mEXECUTE (1.0ms)[0m [1mINSERT INTO [books] ([name]) VALUES (NULL)[0m | |
[1m[35mSQL (0.0ms)[0m SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident | |
[1m[36mEXECUTE (0.0ms)[0m [1mSAVE TRANSACTION active_record_1[0m | |
[1m[35mEXECUTE (1.0ms)[0m INSERT INTO [books] ([name]) VALUES (NULL) | |
[1m[36mSQL (0.0ms)[0m [1mSELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident[0m | |
[1m[35mEXECUTE (0.0ms)[0m SAVE TRANSACTION active_record_1 | |
[1m[36mEXECUTE (0.0ms)[0m [1mINSERT INTO [books] ([name]) VALUES (NULL)[0m | |
[1m[35mSQL (0.0ms)[0m SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident | |
[1m[36mEXECUTE (1.0ms)[0m [1mSAVE TRANSACTION active_record_1[0m | |
[1m[35mEXECUTE (0.0ms)[0m INSERT INTO [books] ([name]) VALUES (NULL) | |
[1m[36mSQL (0.0ms)[0m [1mSELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident[0m | |
[1m[35mEXECUTE (0.0ms)[0m SAVE TRANSACTION active_record_1 | |
[1m[36mEXECUTE (1.0ms)[0m [1mINSERT INTO [books] ([name]) VALUES (NULL)[0m | |
[1m[35mSQL (0.0ms)[0m SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident | |
[1m[36mEXECUTE (0.0ms)[0m [1mSAVE TRANSACTION active_record_1[0m | |
[1m[35mEXECUTE (0.0ms)[0m INSERT INTO [books] ([name]) VALUES (NULL) | |
[1m[36mSQL (1.0ms)[0m [1mSELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident[0m | |
[1m[35mBook Load (2.0ms)[0m SELECT [__rnt].* FROM ( SELECT ROW_NUMBER() OVER (ORDER BY [books].[id]) AS [__rn], [books].* FROM [books] ) AS [__rnt] WHERE [__rnt].[__rn] > 1 | |
[1m[36mEXECUTE (0.0ms)[0m [1mSAVE TRANSACTION active_record_1[0m | |
[1m[35mEXECUTE (1.0ms)[0m DELETE FROM [books] WHERE ([books].[id] = 71) | |
[1m[36mSQL (0.0ms)[0m [1mSELECT @@ROWCOUNT AS AffectedRows[0m | |
[1m[35mEXECUTE (0.0ms)[0m SAVE TRANSACTION active_record_1 | |
[1m[36mEXECUTE (1.0ms)[0m [1mDELETE FROM [books] WHERE ([books].[id] = 72)[0m | |
[1m[35mSQL (0.0ms)[0m SELECT @@ROWCOUNT AS AffectedRows | |
[1m[36mEXECUTE (0.0ms)[0m [1mSAVE TRANSACTION active_record_1[0m | |
[1m[35mEXECUTE (1.0ms)[0m DELETE FROM [books] WHERE ([books].[id] = 73) | |
[1m[36mSQL (0.0ms)[0m [1mSELECT @@ROWCOUNT AS AffectedRows[0m | |
[1m[35mEXECUTE (0.0ms)[0m SAVE TRANSACTION active_record_1 | |
[1m[36mEXECUTE (0.0ms)[0m [1mDELETE FROM [books] WHERE ([books].[id] = 74)[0m | |
[1m[35mSQL (0.0ms)[0m SELECT @@ROWCOUNT AS AffectedRows | |
[1m[36mEXECUTE (1.0ms)[0m [1mSAVE TRANSACTION active_record_1[0m | |
[1m[35mEXECUTE (0.0ms)[0m DELETE FROM [books] WHERE ([books].[id] = 75) | |
[1m[36mSQL (0.0ms)[0m [1mSELECT @@ROWCOUNT AS AffectedRows[0m | |
[1m[35mEXECUTE (1.0ms)[0m SAVE TRANSACTION active_record_1 | |
[1m[36mEXECUTE (0.0ms)[0m [1mDELETE FROM [books] WHERE ([books].[id] = 76)[0m | |
[1m[35mSQL (1.0ms)[0m SELECT @@ROWCOUNT AS AffectedRows | |
[1m[36mEXECUTE (1.0ms)[0m [1mSAVE TRANSACTION active_record_1[0m | |
[1m[35mEXECUTE (0.0ms)[0m DELETE FROM [books] WHERE ([books].[id] = 77) | |
[1m[36mSQL (1.0ms)[0m [1mSELECT @@ROWCOUNT AS AffectedRows[0m | |
[1m[35mEXECUTE (0.0ms)[0m SAVE TRANSACTION active_record_1 | |
[1m[36mEXECUTE (0.0ms)[0m [1mDELETE FROM [books] WHERE ([books].[id] = 78)[0m | |
[1m[35mSQL (0.0ms)[0m SELECT @@ROWCOUNT AS AffectedRows | |
[1m[36mEXECUTE (0.0ms)[0m [1mSAVE TRANSACTION active_record_1[0m | |
[1m[35mEXECUTE (1.0ms)[0m DELETE FROM [books] WHERE ([books].[id] = 79) | |
[1m[36mSQL (0.0ms)[0m [1mSELECT @@ROWCOUNT AS AffectedRows[0m | |
[1m[35mEXECUTE (0.0ms)[0m SAVE TRANSACTION active_record_1 | |
[1m[36mEXECUTE (0.0ms)[0m [1mDELETE FROM [books] WHERE ([books].[id] = 80)[0m | |
[1m[35mSQL (1.0ms)[0m SELECT @@ROWCOUNT AS AffectedRows | |
[1m[36mEXECUTE (1.0ms)[0m [1mROLLBACK TRANSACTION[0m | |
[1m[35mEXECUTE (0.0ms)[0m USE [activerecord_unittest] | |
[1m[36mEXECUTE (0.0ms)[0m [1mBEGIN TRANSACTION[0m | |
[1m[35mPerson Load (2.0ms)[0m SELECT TOP (1) [people].* FROM [people] WHERE ([people].[id] = 1) | |
[1m[36mEXECUTE (1.0ms)[0m [1mUSE [activerecord_unittest][0m | |
[1m[35mEXECUTE (0.0ms)[0m BEGIN TRANSACTION | |
[1m[36mPerson Load (1.0ms)[0m [1mSELECT TOP (1) [people].* FROM [people] WHERE ([people].[id] = 1)[0m | |
[1m[35mEXECUTE (0.0ms)[0m COMMIT TRANSACTION | |
[1m[36mEXECUTE (1.0ms)[0m [1mCOMMIT TRANSACTION[0m | |
[1m[35mEXECUTE (0.0ms)[0m USE [activerecord_unittest] | |
[1m[36mEXECUTE (1.0ms)[0m [1mUSE [activerecord_unittest][0m | |
[1m[35mEXECUTE (0.0ms)[0m BEGIN TRANSACTION | |
[1m[36mEXECUTE (1.0ms)[0m [1mINSERT INTO [people] ([first_name], [gender], [lock_version], [number1_fan_id], [primary_contact_id]) VALUES (N'Thing_0', NULL, 0, NULL, NULL)[0m | |
[1m[35mSQL (1.0ms)[0m SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident | |
[1m[36mEXECUTE (1.0ms)[0m [1mCOMMIT TRANSACTION[0m | |
[1m[35mEXECUTE (0.0ms)[0m BEGIN TRANSACTION | |
[1m[36mEXECUTE (1.0ms)[0m [1mINSERT INTO [people] ([first_name], [gender], [lock_version], [number1_fan_id], [primary_contact_id]) VALUES (N'Thing_1', NULL, 0, NULL, NULL)[0m | |
[1m[35mSQL (0.0ms)[0m SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident | |
[1m[36mEXECUTE (0.0ms)[0m [1mCOMMIT TRANSACTION[0m | |
[1m[35mEXECUTE (1.0ms)[0m BEGIN TRANSACTION | |
[1m[36mEXECUTE (1.0ms)[0m [1mINSERT INTO [people] ([first_name], [gender], [lock_version], [number1_fan_id], [primary_contact_id]) VALUES (N'Thing_2', NULL, 0, NULL, NULL)[0m | |
[1m[35mSQL (0.0ms)[0m SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident | |
[1m[36mEXECUTE (0.0ms)[0m [1mCOMMIT TRANSACTION[0m | |
[1m[35mEXECUTE (0.0ms)[0m BEGIN TRANSACTION | |
[1m[36mEXECUTE (0.0ms)[0m [1mINSERT INTO [people] ([first_name], [gender], [lock_version], [number1_fan_id], [primary_contact_id]) VALUES (N'Thing_3', NULL, 0, NULL, NULL)[0m | |
[1m[35mSQL (1.0ms)[0m SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident | |
[1m[36mEXECUTE (1.0ms)[0m [1mCOMMIT TRANSACTION[0m | |
[1m[35mEXECUTE (0.0ms)[0m BEGIN TRANSACTION | |
[1m[36mEXECUTE (0.0ms)[0m [1mINSERT INTO [people] ([first_name], [gender], [lock_version], [number1_fan_id], [primary_contact_id]) VALUES (N'Thing_4', NULL, 0, NULL, NULL)[0m | |
[1m[35mSQL (0.0ms)[0m SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident | |
[1m[36mEXECUTE (0.0ms)[0m [1mCOMMIT TRANSACTION[0m | |
[1m[35mEXECUTE (1.0ms)[0m BEGIN TRANSACTION | |
[1m[36mEXECUTE (1.0ms)[0m [1mINSERT INTO [people] ([first_name], [gender], [lock_version], [number1_fan_id], [primary_contact_id]) VALUES (N'Thing_5', NULL, 0, NULL, NULL)[0m | |
[1m[35mSQL (0.0ms)[0m SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident | |
[1m[36mEXECUTE (0.0ms)[0m [1mCOMMIT TRANSACTION[0m | |
[1m[35mEXECUTE (0.0ms)[0m BEGIN TRANSACTION | |
[1m[36mEXECUTE (1.0ms)[0m [1mINSERT INTO [people] ([first_name], [gender], [lock_version], [number1_fan_id], [primary_contact_id]) VALUES (N'Thing_6', NULL, 0, NULL, NULL)[0m | |
[1m[35mSQL (0.0ms)[0m SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident | |
[1m[36mEXECUTE (1.0ms)[0m [1mCOMMIT TRANSACTION[0m | |
[1m[35mEXECUTE (0.0ms)[0m BEGIN TRANSACTION | |
[1m[36mEXECUTE (0.0ms)[0m [1mINSERT INTO [people] ([first_name], [gender], [lock_version], [number1_fan_id], [primary_contact_id]) VALUES (N'Thing_7', NULL, 0, NULL, NULL)[0m | |
[1m[35mSQL (1.0ms)[0m SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident | |
[1m[36mEXECUTE (1.0ms)[0m [1mCOMMIT TRANSACTION[0m | |
[1m[35mEXECUTE (0.0ms)[0m BEGIN TRANSACTION | |
[1m[36mEXECUTE (0.0ms)[0m [1mINSERT INTO [people] ([first_name], [gender], [lock_version], [number1_fan_id], [primary_contact_id]) VALUES (N'Thing_8', NULL, 0, NULL, NULL)[0m | |
[1m[35mSQL (1.0ms)[0m SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident | |
[1m[36mEXECUTE (1.0ms)[0m [1mCOMMIT TRANSACTION[0m | |
[1m[35mEXECUTE (0.0ms)[0m BEGIN TRANSACTION | |
[1m[36mEXECUTE (0.0ms)[0m [1mINSERT INTO [people] ([first_name], [gender], [lock_version], [number1_fan_id], [primary_contact_id]) VALUES (N'Thing_9', NULL, 0, NULL, NULL)[0m | |
[1m[35mSQL (0.0ms)[0m SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident | |
[1m[36mEXECUTE (0.0ms)[0m [1mCOMMIT TRANSACTION[0m | |
[1m[35mEXECUTE (1.0ms)[0m BEGIN TRANSACTION | |
[1m[36mEXECUTE (1.0ms)[0m [1mINSERT INTO [people] ([first_name], [gender], [lock_version], [number1_fan_id], [primary_contact_id]) VALUES (N'Thing_10', NULL, 0, NULL, NULL)[0m | |
[1m[35mSQL (0.0ms)[0m SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident | |
[1m[36mEXECUTE (0.0ms)[0m [1mCOMMIT TRANSACTION[0m | |
[1m[35mEXECUTE (1.0ms)[0m BEGIN TRANSACTION | |
[1m[36mEXECUTE (1.0ms)[0m [1mINSERT INTO [people] ([first_name], [gender], [lock_version], [number1_fan_id], [primary_contact_id]) VALUES (N'Thing_11', NULL, 0, NULL, NULL)[0m | |
[1m[35mSQL (0.0ms)[0m SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident | |
[1m[36mEXECUTE (1.0ms)[0m [1mCOMMIT TRANSACTION[0m | |
[1m[35mEXECUTE (0.0ms)[0m BEGIN TRANSACTION | |
[1m[36mEXECUTE (0.0ms)[0m [1mINSERT INTO [people] ([first_name], [gender], [lock_version], [number1_fan_id], [primary_contact_id]) VALUES (N'Thing_12', NULL, 0, NULL, NULL)[0m | |
[1m[35mSQL (1.0ms)[0m SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident | |
[1m[36mEXECUTE (1.0ms)[0m [1mCOMMIT TRANSACTION[0m | |
[1m[35mEXECUTE (0.0ms)[0m BEGIN TRANSACTION | |
[1m[36mEXECUTE (0.0ms)[0m [1mINSERT INTO [people] ([first_name], [gender], [lock_version], [number1_fan_id], [primary_contact_id]) VALUES (N'Thing_13', NULL, 0, NULL, NULL)[0m | |
[1m[35mSQL (1.0ms)[0m SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident | |
[1m[36mEXECUTE (1.0ms)[0m [1mCOMMIT TRANSACTION[0m | |
[1m[35mEXECUTE (1.0ms)[0m BEGIN TRANSACTION | |
[1m[36mEXECUTE (1.0ms)[0m [1mINSERT INTO [people] ([first_name], [gender], [lock_version], [number1_fan_id], [primary_contact_id]) VALUES (N'Thing_14', NULL, 0, NULL, NULL)[0m | |
[1m[35mSQL (0.0ms)[0m SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident | |
[1m[36mEXECUTE (1.0ms)[0m [1mCOMMIT TRANSACTION[0m | |
[1m[35mEXECUTE (0.0ms)[0m BEGIN TRANSACTION | |
[1m[36mEXECUTE (0.0ms)[0m [1mINSERT INTO [people] ([first_name], [gender], [lock_version], [number1_fan_id], [primary_contact_id]) VALUES (N'Thing_15', NULL, 0, NULL, NULL)[0m | |
[1m[35mSQL (1.0ms)[0m SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident | |
[1m[36mEXECUTE (1.0ms)[0m [1mCOMMIT TRANSACTION[0m | |
[1m[35mEXECUTE (0.0ms)[0m BEGIN TRANSACTION | |
[1m[36mEXECUTE (0.0ms)[0m [1mINSERT INTO [people] ([first_name], [gender], [lock_version], [number1_fan_id], [primary_contact_id]) VALUES (N'Thing_16', NULL, 0, NULL, NULL)[0m | |
[1m[35mSQL (0.0ms)[0m SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident | |
[1m[36mEXECUTE (0.0ms)[0m [1mCOMMIT TRANSACTION[0m | |
[1m[35mEXECUTE (0.0ms)[0m BEGIN TRANSACTION | |
[1m[36mEXECUTE (0.0ms)[0m [1mINSERT INTO [people] ([first_name], [gender], [lock_version], [number1_fan_id], [primary_contact_id]) VALUES (N'Thing_17', NULL, 0, NULL, NULL)[0m | |
[1m[35mSQL (0.0ms)[0m SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident | |
[1m[36mEXECUTE (0.0ms)[0m [1mCOMMIT TRANSACTION[0m | |
[1m[35mEXECUTE (0.0ms)[0m BEGIN TRANSACTION | |
[1m[36mEXECUTE (0.0ms)[0m [1mINSERT INTO [people] ([first_name], [gender], [lock_version], [number1_fan_id], [primary_contact_id]) VALUES (N'Thing_18', NULL, 0, NULL, NULL)[0m | |
[1m[35mSQL (1.0ms)[0m SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident | |
[1m[36mEXECUTE (1.0ms)[0m [1mCOMMIT TRANSACTION[0m | |
[1m[35mEXECUTE (0.0ms)[0m BEGIN TRANSACTION | |
[1m[36mEXECUTE (0.0ms)[0m [1mINSERT INTO [people] ([first_name], [gender], [lock_version], [number1_fan_id], [primary_contact_id]) VALUES (N'Thing_19', NULL, 0, NULL, NULL)[0m | |
[1m[35mSQL (0.0ms)[0m SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident | |
[1m[36mEXECUTE (0.0ms)[0m [1mCOMMIT TRANSACTION[0m | |
[1m[35mPerson Load (1.0ms)[0m 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 | |
[1m[36mPerson Load (4.0ms)[0m [1mSELECT [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))[0m | |
[1m[35mEXECUTE (0.0ms)[0m USE [activerecord_unittest] | |
[1m[36mEXECUTE (1.0ms)[0m [1mUSE [activerecord_unittest][0m | |
[1m[35mEXECUTE (1.0ms)[0m BEGIN TRANSACTION | |
[1m[36mPerson Load (1.0ms)[0m [1mSELECT TOP (1) [people].* FROM [people] WITH(HOLDLOCK, ROWLOCK) WHERE ([people].[id] = 1)[0m | |
[1m[35mReader Load (1.0ms)[0m SELECT [readers].* FROM [readers] WHERE ([readers].person_id = 1) | |
[1m[36mEXECUTE (0.0ms)[0m [1mCOMMIT TRANSACTION[0m | |
[1m[35mEXECUTE (0.0ms)[0m USE [activerecord_unittest] | |
[1m[36mEXECUTE (0.0ms)[0m [1mUSE [activerecord_unittest][0m | |
[1m[35mEXECUTE (0.0ms)[0m BEGIN TRANSACTION | |
[1m[36mPerson Load (1.0ms)[0m [1mSELECT TOP (1) [people].* FROM [people] WITH(HOLDLOCK, ROWLOCK) WHERE ([people].[id] = 1)[0m | |
[1m[35mEXECUTE (0.0ms)[0m COMMIT TRANSACTION | |
[1m[36mEXECUTE (0.0ms)[0m [1mUSE [activerecord_unittest][0m | |
[1m[35mEXECUTE (0.0ms)[0m USE [activerecord_unittest] | |
[1m[36mEXECUTE (0.0ms)[0m [1mBEGIN TRANSACTION[0m | |
[1m[35mPerson Load (0.0ms)[0m SELECT TOP (1) [people].* FROM [people] WITH(HOLDLOCK, ROWLOCK) WHERE ([people].[id] = 1) | |
[1m[36mEXECUTE (0.0ms)[0m [1mCOMMIT TRANSACTION[0m | |
[1m[35mEXECUTE (0.0ms)[0m USE [activerecord_unittest] | |
[1m[36mEXECUTE (1.0ms)[0m [1mUSE [activerecord_unittest][0m | |
[1m[35mEXECUTE (0.0ms)[0m BEGIN TRANSACTION | |
[1m[36mPerson Load (1.0ms)[0m [1mSELECT TOP (1) [people].* FROM [people] WHERE ([people].[id] = 1)[0m | |
[1m[35mPerson Load (1.0ms)[0m SELECT TOP (1) [people].* FROM [people] WITH(HOLDLOCK, ROWLOCK) WHERE ([people].[id] = 1) | |
[1m[36mEXECUTE (1.0ms)[0m [1mCOMMIT TRANSACTION[0m | |
[1m[35mEXECUTE (0.0ms)[0m USE [activerecord_unittest] | |
[1m[36mEXECUTE (0.0ms)[0m [1mUSE [activerecord_unittest][0m | |
[1m[35mPerson Load (1.0ms)[0m SELECT [people].* FROM [people] WITH (NOLOCK) | |
[1m[36mEXECUTE (0.0ms)[0m [1mUSE [activerecord_unittest][0m | |
[1m[35mEXECUTE (0.0ms)[0m BEGIN TRANSACTION | |
[1m[36mSQL (1.0ms)[0m [1mSELECT count(*) AS count_all FROM tasks[0m | |
[1m[35mEXECUTE (0.0ms)[0m ROLLBACK TRANSACTION | |
[1m[36mEXECUTE (0.0ms)[0m [1mBEGIN TRANSACTION[0m | |
[1m[35mEXECUTE (0.0ms)[0m ROLLBACK TRANSACTION | |
[1m[36mEXECUTE (0.0ms)[0m [1mBEGIN TRANSACTION[0m | |
[1m[35mSQL (1.0ms)[0m EXEC sp_helpindex [integer_limits] | |
[1m[36mEXECUTE (1.0ms)[0m [1mROLLBACK TRANSACTION[0m | |
[1m[35mEXECUTE (1.0ms)[0m BEGIN TRANSACTION | |
[1m[36mSQL (1.0ms)[0m [1mEXEC sp_helpindex [movies][0m | |
[1m[35mEXECUTE (0.0ms)[0m ROLLBACK TRANSACTION | |
[1m[36mEXECUTE (0.0ms)[0m [1mBEGIN TRANSACTION[0m | |
[1m[35mSQL (1.0ms)[0m EXEC sp_helpindex [sql_server_strings] | |
[1m[36mEXECUTE (1.0ms)[0m [1mROLLBACK TRANSACTION[0m | |
[1m[35mEXECUTE (0.0ms)[0m BEGIN TRANSACTION | |
[1m[36mEXECUTE (0.0ms)[0m [1mROLLBACK TRANSACTION[0m | |
[1m[35mEXECUTE (0.0ms)[0m BEGIN TRANSACTION | |
[1m[36mEXECUTE (0.0ms)[0m [1mSAVE TRANSACTION active_record_1[0m | |
[1m[35mEXECUTE (2.0ms)[0m 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)') | |
[1m[36mSQL (0.0ms)[0m [1mSELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident[0m | |
[1m[35mEXECUTE (0.0ms)[0m ROLLBACK TRANSACTION | |
[1m[36mEXECUTE (0.0ms)[0m [1mBEGIN TRANSACTION[0m | |
[1m[35mEXECUTE (0.0ms)[0m ROLLBACK TRANSACTION | |
[1m[36mEXECUTE (0.0ms)[0m [1mBEGIN TRANSACTION[0m | |
[1m[35mEXECUTE (0.0ms)[0m SAVE TRANSACTION active_record_1 | |
[1m[36mEXECUTE (1.0ms)[0m [1mINSERT INTO [quoted-table] DEFAULT VALUES[0m | |
[1m[35mSQL (1.0ms)[0m SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident | |
[1m[36mSqlServerQuotedTable Load (1.0ms)[0m [1mSELECT TOP (1) [quoted-table].* FROM [quoted-table][0m | |
[1m[35mEXECUTE (1.0ms)[0m SAVE TRANSACTION active_record_1 | |
[1m[36mEXECUTE (1.0ms)[0m [1mINSERT INTO [quoted-view1] DEFAULT VALUES[0m | |
[1m[35mSQL (0.0ms)[0m SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident | |
[1m[36mSqlServerQuotedView1 Load (1.0ms)[0m [1mSELECT TOP (1) [quoted-view1].* FROM [quoted-view1][0m | |
[1m[35mEXECUTE (0.0ms)[0m SAVE TRANSACTION active_record_1 | |
[1m[36mEXECUTE (1.0ms)[0m [1mINSERT INTO [quoted-view2] DEFAULT VALUES[0m | |
[1m[35mSQL (0.0ms)[0m SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident | |
[1m[36mSqlServerQuotedView2 Load (0.0ms)[0m [1mSELECT TOP (1) [quoted-view2].* FROM [quoted-view2][0m | |
[1m[35mEXECUTE (0.0ms)[0m ROLLBACK TRANSACTION | |
[1m[36mEXECUTE (0.0ms)[0m [1mBEGIN TRANSACTION[0m | |
[1m[35mEXECUTE (0.0ms)[0m SAVE TRANSACTION active_record_1 | |
[1m[36mEXECUTE (1.0ms)[0m [1mINSERT INTO [sql_server_edge_schemas] ([bigint], [description], [guid], [guid_newid], [guid_newseqid], [tinyint]) VALUES (5000, N'Five Thousand', NULL, NULL, NULL, NULL)[0m | |
[1m[35mSQL (1.0ms)[0m SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident | |
[1m[36mEXECUTE (0.0ms)[0m [1mSAVE TRANSACTION active_record_1[0m | |
[1m[35mEXECUTE (1.0ms)[0m 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) | |
[1m[36mSQL (1.0ms)[0m [1mSELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident[0m | |
[1m[35mSqlServerEdgeSchema Load (2.0ms)[0m SELECT TOP (1) [sql_server_edge_schemas].* FROM [sql_server_edge_schemas] WHERE ([sql_server_edge_schemas].[bigint] = 5000) | |
[1m[36mSqlServerEdgeSchema Load (1.0ms)[0m [1mSELECT TOP (1) bigint FROM [sql_server_edge_schemas] WHERE ([sql_server_edge_schemas].[bigint] = 5000)[0m | |
[1m[35mSqlServerEdgeSchema Load (0.0ms)[0m SELECT TOP (1) [sql_server_edge_schemas].* FROM [sql_server_edge_schemas] WHERE ([sql_server_edge_schemas].[bigint] = 9000000000000000000) | |
[1m[36mSqlServerEdgeSchema Load (1.0ms)[0m [1mSELECT TOP (1) bigint FROM [sql_server_edge_schemas] WHERE ([sql_server_edge_schemas].[bigint] = 9000000000000000000)[0m | |
[1m[35mEXECUTE (0.0ms)[0m ROLLBACK TRANSACTION | |
[1m[36mEXECUTE (0.0ms)[0m [1mBEGIN TRANSACTION[0m | |
[1m[35mEXECUTE (1.0ms)[0m SAVE TRANSACTION active_record_1 | |
[1m[36mEXECUTE (1.0ms)[0m [1mINSERT INTO [sql_server_edge_schemas] ([bigint], [description], [guid], [guid_newid], [guid_newseqid], [tinyint]) VALUES (NULL, N'A', NULL, NULL, NULL, NULL)[0m | |
[1m[35mSQL (0.0ms)[0m SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident | |
[1m[36mEXECUTE (0.0ms)[0m [1mSAVE TRANSACTION active_record_1[0m | |
[1m[35mEXECUTE (0.0ms)[0m INSERT INTO [sql_server_edge_schemas] ([bigint], [description], [guid], [guid_newid], [guid_newseqid], [tinyint]) VALUES (NULL, N'B', NULL, NULL, NULL, NULL) | |
[1m[36mSQL (1.0ms)[0m [1mSELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident[0m | |
[1m[35mEXECUTE (0.0ms)[0m SAVE TRANSACTION active_record_1 | |
[1m[36mEXECUTE (0.0ms)[0m [1mINSERT INTO [sql_server_edge_schemas] ([bigint], [description], [guid], [guid_newid], [guid_newseqid], [tinyint]) VALUES (NULL, N'C', NULL, NULL, NULL, NULL)[0m | |
[1m[35mSQL (0.0ms)[0m SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident | |
[1m[36mSqlServerEdgeSchema Load (1.0ms)[0m [1mSELECT [sql_server_edge_schemas].* FROM [sql_server_edge_schemas] ORDER BY description[0m | |
[1m[35mSqlServerEdgeSchema Load (1.0ms)[0m SELECT [sql_server_edge_schemas].* FROM [sql_server_edge_schemas] ORDER BY description asc | |
[1m[36mSqlServerEdgeSchema Load (1.0ms)[0m [1mSELECT [sql_server_edge_schemas].* FROM [sql_server_edge_schemas] ORDER BY description ASC[0m | |
[1m[35mSqlServerEdgeSchema Load (1.0ms)[0m SELECT [sql_server_edge_schemas].* FROM [sql_server_edge_schemas] ORDER BY description desc | |
[1m[36mSqlServerEdgeSchema Load (1.0ms)[0m [1mSELECT [sql_server_edge_schemas].* FROM [sql_server_edge_schemas] ORDER BY description DESC[0m | |
[1m[35mEXECUTE (1.0ms)[0m DELETE FROM [sql_server_edge_schemas] | |
[1m[36mSQL (0.0ms)[0m [1mSELECT @@ROWCOUNT AS AffectedRows[0m | |
[1m[35mEXECUTE (1.0ms)[0m ROLLBACK TRANSACTION | |
[1m[36mEXECUTE (1.0ms)[0m [1mBEGIN TRANSACTION[0m | |
[1m[35mEXECUTE (0.0ms)[0m SAVE TRANSACTION active_record_1 | |
[1m[36mEXECUTE (1.0ms)[0m [1mINSERT INTO [sql_server_edge_schemas] ([bigint], [description], [guid], [guid_newid], [guid_newseqid], [tinyint]) VALUES (NULL, NULL, NULL, NULL, NULL, 1)[0m | |
[1m[35mSQL (1.0ms)[0m SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident | |
[1m[36mEXECUTE (0.0ms)[0m [1mSAVE TRANSACTION active_record_1[0m | |
[1m[35mEXECUTE (1.0ms)[0m INSERT INTO [sql_server_edge_schemas] ([bigint], [description], [guid], [guid_newid], [guid_newseqid], [tinyint]) VALUES (NULL, NULL, NULL, NULL, NULL, 255) | |
[1m[36mSQL (0.0ms)[0m [1mSELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident[0m | |
[1m[35mSqlServerEdgeSchema Load (2.0ms)[0m SELECT TOP (1) [sql_server_edge_schemas].* FROM [sql_server_edge_schemas] WHERE ([sql_server_edge_schemas].[tinyint] = 1) | |
[1m[36mSqlServerEdgeSchema Load (0.0ms)[0m [1mSELECT TOP (1) [sql_server_edge_schemas].* FROM [sql_server_edge_schemas] WHERE ([sql_server_edge_schemas].[tinyint] = 255)[0m | |
[1m[35mEXECUTE (0.0ms)[0m ROLLBACK TRANSACTION | |
[1m[36mEXECUTE (0.0ms)[0m [1mBEGIN TRANSACTION[0m | |
[1m[35mEXECUTE (0.0ms)[0m SAVE TRANSACTION active_record_1 | |
[1m[36mEXECUTE (1.0ms)[0m [1mINSERT INTO [sql_server_edge_schemas] ([bigint], [description], [guid], [guid_newid], [guid_newseqid], [tinyint]) VALUES (NULL, NULL, NULL, NULL, NULL, 1)[0m | |
[1m[35mSQL (0.0ms)[0m SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident | |
[1m[36mEXECUTE (0.0ms)[0m [1mSAVE TRANSACTION active_record_1[0m | |
[1m[35mEXECUTE (0.0ms)[0m INSERT INTO [sql_server_edge_schemas] ([bigint], [description], [guid], [guid_newid], [guid_newseqid], [tinyint]) VALUES (NULL, NULL, NULL, NULL, NULL, 255) | |
[1m[36mSQL (0.0ms)[0m [1mSELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident[0m | |
[1m[35mEXECUTE (0.0ms)[0m SAVE TRANSACTION active_record_1 | |
[1m[36mEXECUTE (1.0ms)[0m [1mINSERT INTO [sql_server_edge_schemas] ([bigint], [description], [guid], [guid_newid], [guid_newseqid], [tinyint]) VALUES (NULL, NULL, NULL, NULL, NULL, 256)[0m | |
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) | |
[1m[35mEXECUTE (1.0ms)[0m ROLLBACK TRANSACTION active_record_1 | |
[1m[36mEXECUTE (1.0ms)[0m [1mROLLBACK TRANSACTION[0m | |
[1m[35mEXECUTE (1.0ms)[0m BEGIN TRANSACTION | |
[1m[36mSQL (0.0ms)[0m [1mSELECT NEWID()[0m | |
[1m[35mEXECUTE (0.0ms)[0m SAVE TRANSACTION active_record_1 | |
[1m[36mEXECUTE (1.0ms)[0m [1mINSERT 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)[0m | |
[1m[35mSQL (0.0ms)[0m SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident | |
[1m[36mSqlServerEdgeSchema Load (2.0ms)[0m [1mSELECT TOP (1) [sql_server_edge_schemas].* FROM [sql_server_edge_schemas] WHERE ([sql_server_edge_schemas].[id] = 11)[0m | |
[1m[35mEXECUTE (1.0ms)[0m ROLLBACK TRANSACTION | |
[1m[36mEXECUTE (1.0ms)[0m [1mBEGIN TRANSACTION[0m | |
[1m[35mSQL (0.0ms)[0m SELECT NEWID() | |
[1m[36mEXECUTE (1.0ms)[0m [1mROLLBACK TRANSACTION[0m | |
[1m[35mEXECUTE (1.0ms)[0m BEGIN TRANSACTION | |
[1m[36mSQL (0.0ms)[0m [1mSELECT NEWID()[0m | |
[1m[35mEXECUTE (0.0ms)[0m SAVE TRANSACTION active_record_1 | |
[1m[36mSQL (0.0ms)[0m [1mSELECT NEWID()[0m | |
[1m[35mEXECUTE (1.0ms)[0m 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) | |
[1m[36mSQL (1.0ms)[0m [1mSELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident[0m | |
[1m[35mEXECUTE (0.0ms)[0m ROLLBACK TRANSACTION | |
[1m[36mOrder Load (1.0ms)[0m [1mSELECT [orders].* FROM [orders][0m | |
[1m[35mEXECUTE (1.0ms)[0m DELETE FROM [ships] | |
[1m[36mSQL (0.0ms)[0m [1mSELECT @@ROWCOUNT AS AffectedRows[0m | |
[1m[35mEXECUTE (1.0ms)[0m BEGIN TRANSACTION | |
[1m[36mEXECUTE (0.0ms)[0m [1mROLLBACK TRANSACTION[0m | |
[1m[35mEXECUTE (1.0ms)[0m DELETE FROM [ships] | |
[1m[36mSQL (0.0ms)[0m [1mSELECT @@ROWCOUNT AS AffectedRows[0m | |
[1m[35mEXECUTE (1.0ms)[0m BEGIN TRANSACTION | |
[1m[36mEXECUTE (0.0ms)[0m [1mROLLBACK TRANSACTION[0m | |
[1m[35mEXECUTE (0.0ms)[0m DELETE FROM [ships] | |
[1m[36mSQL (1.0ms)[0m [1mSELECT @@ROWCOUNT AS AffectedRows[0m | |
[1m[35mEXECUTE (1.0ms)[0m BEGIN TRANSACTION | |
[1m[36mEXECUTE (0.0ms)[0m [1mROLLBACK TRANSACTION[0m | |
[1m[35mEXECUTE (0.0ms)[0m DELETE FROM [ships] | |
[1m[36mSQL (1.0ms)[0m [1mSELECT @@ROWCOUNT AS AffectedRows[0m | |
[1m[35mEXECUTE (0.0ms)[0m BEGIN TRANSACTION | |
[1m[36mEXECUTE (1.0ms)[0m [1mCOMMIT TRANSACTION[0m | |
[1m[35mEXECUTE (0.0ms)[0m DELETE FROM [ships] | |
[1m[36mSQL (1.0ms)[0m [1mSELECT @@ROWCOUNT AS AffectedRows[0m | |
[1m[35mEXECUTE (0.0ms)[0m BEGIN TRANSACTION | |
[1m[36mEXECUTE (1.0ms)[0m [1mINSERT INTO [ships] ([created_at], [created_on], [name], [pirate_id], [updated_at], [updated_on]) VALUES (NULL, NULL, N'Black Pearl', NULL, NULL, NULL)[0m | |
[1m[35mSQL (0.0ms)[0m SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident | |
[1m[36mEXECUTE (0.0ms)[0m [1mROLLBACK TRANSACTION[0m | |
[1m[35mSQL (1.0ms)[0m SELECT COUNT(*) AS count_id FROM [ships] | |
[1m[36mShip Load (0.0ms)[0m [1mSELECT [ships].* FROM [ships][0m | |
[1m[35mEXECUTE (0.0ms)[0m DELETE FROM [ships] | |
[1m[36mSQL (0.0ms)[0m [1mSELECT @@ROWCOUNT AS AffectedRows[0m | |
[1m[35mEXECUTE (1.0ms)[0m BEGIN TRANSACTION | |
[1m[36mEXECUTE (1.0ms)[0m [1mINSERT INTO [ships] ([created_at], [created_on], [name], [pirate_id], [updated_at], [updated_on]) VALUES (NULL, NULL, N'Black Pearl', NULL, NULL, NULL)[0m | |
[1m[35mSQL (0.0ms)[0m SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident | |
[1m[36mEXECUTE (1.0ms)[0m [1mINSERT INTO [ships] ([created_at], [created_on], [name], [pirate_id], [updated_at], [updated_on]) VALUES (NULL, NULL, N'Flying Dutchman', NULL, NULL, NULL)[0m | |
[1m[35mSQL (0.0ms)[0m SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident | |
[1m[36mEXECUTE (1.0ms)[0m [1mROLLBACK TRANSACTION[0m | |
[1m[35mSQL (0.0ms)[0m SELECT COUNT(*) AS count_id FROM [ships] | |
[1m[36mShip Load (1.0ms)[0m [1mSELECT [ships].* FROM [ships][0m | |
[1m[35mEXECUTE (0.0ms)[0m BEGIN TRANSACTION | |
[1m[36mEXECUTE (0.0ms)[0m [1mSAVE TRANSACTION active_record_1[0m | |
[1m[35mEXECUTE (2.0ms)[0m 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) | |
[1m[36mEXECUTE (1.0ms)[0m [1mROLLBACK TRANSACTION active_record_1[0m | |
[1m[35mEXECUTE (1.0ms)[0m ROLLBACK TRANSACTION | |
[1m[36mEXECUTE (1.0ms)[0m [1mBEGIN TRANSACTION[0m | |
[1m[35mEXECUTE (0.0ms)[0m SAVE TRANSACTION active_record_1 | |
[1m[36mEXECUTE (2.0ms)[0m [1mINSERT 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)[0m | |
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) | |
[1m[35mEXECUTE (1.0ms)[0m ROLLBACK TRANSACTION active_record_1 | |
[1m[36mEXECUTE (1.0ms)[0m [1mROLLBACK TRANSACTION[0m | |
[1m[35mEXECUTE (1.0ms)[0m BEGIN TRANSACTION | |
[1m[36mEXECUTE (0.0ms)[0m [1mSAVE TRANSACTION active_record_1[0m | |
[1m[35mEXECUTE (0.0ms)[0m 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) | |
[1m[36mSQL (1.0ms)[0m [1mSELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident[0m | |
[1m[35mSqlServerUnicode Load (3.0ms)[0m SELECT TOP (1) [sql_server_unicodes].* FROM [sql_server_unicodes] WHERE ([sql_server_unicodes].[id] = 3) | |
[1m[36mEXECUTE (0.0ms)[0m [1mROLLBACK TRANSACTION[0m | |
[1m[35mEXECUTE (0.0ms)[0m BEGIN TRANSACTION | |
[1m[36mEXECUTE (0.0ms)[0m [1mSAVE TRANSACTION active_record_1[0m | |
[1m[35mEXECUTE (1.0ms)[0m 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) | |
[1m[36mSQL (0.0ms)[0m [1mSELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident[0m | |
[1m[35mSqlServerUnicode Load (1.0ms)[0m SELECT TOP (1) [sql_server_unicodes].* FROM [sql_server_unicodes] WHERE ([sql_server_unicodes].[id] = 4) | |
[1m[36mEXECUTE (0.0ms)[0m [1mROLLBACK TRANSACTION[0m | |
[1m[35mEXECUTE (0.0ms)[0m BEGIN TRANSACTION | |
[1m[36mEXECUTE (1.0ms)[0m [1mSAVE TRANSACTION active_record_1[0m | |
[1m[35mEXECUTE (1.0ms)[0m 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) | |
[1m[36mSQL (1.0ms)[0m [1mSELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident[0m | |
[1m[35mSqlServerUnicode Load (1.0ms)[0m SELECT TOP (1) [sql_server_unicodes].* FROM [sql_server_unicodes] WHERE ([sql_server_unicodes].[id] = 5) | |
[1m[36mEXECUTE (1.0ms)[0m [1mROLLBACK TRANSACTION[0m | |
[1m[35mEXECUTE (0.0ms)[0m BEGIN TRANSACTION | |
[1m[36mSQL (6.0ms)[0m [1mEXEC sp_helpconstraint 'events','nomsg'[0m | |
[1m[35mEXECUTE (2.0ms)[0m ALTER TABLE [events] ALTER COLUMN [title] nvarchar(30) | |
[1m[36mEXECUTE (0.0ms)[0m [1mSAVE TRANSACTION active_record_1[0m | |
[1m[35mEvent Load (2.0ms)[0m SELECT TOP (1) [events].[id] FROM [events] WHERE ([events].[title] COLLATE Latin1_General_CS_AS_WS = N'一二三四五') | |
[1m[36mEXECUTE (1.0ms)[0m [1mINSERT INTO [events] ([title]) VALUES (N'一二三四五')[0m | |
[1m[35mSQL (1.0ms)[0m SELECT CAST(SCOPE_IDENTITY() AS bigint) AS Ident | |
[1m[36mEvent Load (2.0ms)[0m [1mSELECT TOP (1) [events].[id] FROM [events] WHERE ([events].[title] COLLATE Latin1_General_CS_AS_WS = N'一二三四五') AND ([events].id <> 1)[0m | |
[1m[35mEXECUTE (0.0ms)[0m SAVE TRANSACTION active_record_1 | |
[1m[36mEvent Load (1.0ms)[0m [1mSELECT TOP (1) [events].[id] FROM [events] WHERE ([events].[title] COLLATE Latin1_General_CS_AS_WS = N'一二三四五')[0m | |
[1m[35mEXECUTE (0.0ms)[0m ROLLBACK TRANSACTION active_record_1 | |
[1m[36mEvent Load (0.0ms)[0m [1mSELECT TOP (1) [events].[id] FROM [events] WHERE ([events].[title] COLLATE Latin1_General_CS_AS_WS = N'一二三四五')[0m | |
[1m[35mEXECUTE (1.0ms)[0m ROLLBACK TRANSACTION |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment