aboutsummaryrefslogtreecommitdiffstats
path: root/activerecord/test/fixtures/db_definitions/sqlserver.sql
Commit message (Collapse)AuthorAgeFilesLines
* Send the correct INSERT statement when dealing with objects with only ↵Michael Koziarski2007-10-061-0/+4
| | | | | | primary keys. Closes #9523 [tarmo] git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@7753 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
* Consistently quote primary key column names. Closes #7763.Jeremy Kemper2007-03-091-0/+5
| | | | git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@6364 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
* SQLServer: handle [quoted] table names. Closes #6635.Jeremy Kemper2007-01-121-0/+8
| | | | git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@5891 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
* r4704@asus: jeremy | 2006-06-27 12:00:19 -0700Jeremy Kemper2006-07-081-0/+27
| | | | | | | | | | | | | | | decimal r4705@asus: jeremy | 2006-06-27 12:20:47 -0700 current_adapter? checks whether any of its arguments is the name of the current adapter class r4834@asus: jeremy | 2006-07-08 13:08:24 -0700 Room to float. r4835@asus: jeremy | 2006-07-08 13:09:18 -0700 Give lock test a few chances. r4836@asus: jeremy | 2006-07-08 13:12:05 -0700 Numeric and decimal columns map to BigDecimal instead of Float. Those with scale 0 map to Integer. Closes #5454. git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@4596 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
* SQL Server adapter gets some love (closes #4298) [rtomayko@gmail.com]David Heinemeier Hansson2006-03-181-1/+1
| | | | git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@3949 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
* Added new column to all db definitions. Where, oh where, is our hereo that ↵David Heinemeier Hansson2006-02-281-0/+5
| | | | | | will convert all the legacy fixture schemas to schema.rb? (closes #3993) [Bob Silva] git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@3695 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
* Allow has_many :through to work with :include [Michael Schoen]. Closes #3611Michael Koziarski2006-02-101-0/+7
| | | | git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@3566 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
* SQL Server cannot sort on type text. This causes three errors in the ↵Jeremy Kemper2006-02-091-2/+2
| | | | | | activerecord test suite, where tests sort on the comments.body or posts.body columns. This patch changes these columns from text to varchar(4096), allowing these tests to proceed (and pass). All activerecord tests now pass under sqlserver. References #3581. [Tom Ward] git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@3559 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
* allow the 'lock_version' column to be configured with set_locking_column. ↵Michael Koziarski2006-01-141-0/+8
| | | | | | Closes #3402 git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@3422 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
* Add test coverage for customized primary keys including a failing test for ↵Marcel Molina2005-10-121-0/+5
| | | | | | #2444. git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@2540 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
* Make the test_find_all_by_one_attribute and ↵David Heinemeier Hansson2005-09-091-1/+1
| | | | | | test_find_all_by_one_attribute_with_options tests not fail in SQL Server #2128 [Tom Ward] git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@2168 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
* Saving a record with two unsaved belongs_to associations pointing to the ↵Jamis Buck2005-08-231-0/+8
| | | | | | same object fails #2023 [Tobias Luetke] git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@2040 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
* Allow unspecified join-table columns to use to their default values when ↵Jamis Buck2005-07-181-1/+2
| | | | | | adding to a habtm collection git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@1860 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
* Fixed that has_and_belongs_to_many didn't respect single table inheritance ↵David Heinemeier Hansson2005-07-031-1/+2
| | | | | | types #1081 [Florian Weber] git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@1641 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
* Fixed that single-table inheritance sub-classes couldn't be used to limit ↵David Heinemeier Hansson2005-07-031-1/+2
| | | | | | the result set with eager loading #1215 [Chris McGrath] git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@1619 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
* Added support for ODBC connections to MS SQL Server so you can connect from ↵David Heinemeier Hansson2005-07-011-3/+3
| | | | | | a non-Windows machine #1569 [Mark Imbriaco/DeLynn Berry] Added support for limit/offset with the MS SQL Server driver so that pagination will now work #1569 [DeLynn Berry] git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@1583 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
* Fixed that adding a record to a has_and_belongs_to collection would always ↵David Heinemeier Hansson2005-06-181-1/+3
| | | | | | save it -- now it only saves if its a new record #1203 [Alisdair McDiarmid] git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@1453 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
* Added compatibility with camelCase column names for dynamic finders #533 ↵David Heinemeier Hansson2005-04-301-1/+2
| | | | | | [Dee.Zsombor] git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@1263 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
* Fixed that fixtures were being deleted in the same order as inserts causing ↵David Heinemeier Hansson2005-04-181-0/+11
| | | | | | FK errors #890 [andrew.john.peters@gmail.com] git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@1205 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
* SqlServer fixtures - CategoriesPostsDavid Heinemeier Hansson2005-04-171-1/+1
| | | | git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@1191 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
* Added support for has_and_belongs_to_many associations in eager loading ↵David Heinemeier Hansson2005-04-101-0/+10
| | | | | | #1064 [Dan Peterson] git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@1132 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
* Made eager loading work with inheritance hierarchies #1065 [Ryan Carver]David Heinemeier Hansson2005-04-101-0/+20
| | | | git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@1131 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
* Added quoting of column names for fixtures #997 [jcfischer@gmail.com]David Heinemeier Hansson2005-04-071-0/+5
| | | | git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@1110 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
* Fixed the MS SQL adapter to work with the new limit/offset approach and with ↵David Heinemeier Hansson2005-03-231-48/+35
| | | | | | binary data (still suffering from 7KB limit, though) #901 [delynnb] git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@982 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
* changes the CREATE TABLE script for the "binaries" table to use the "image" ↵David Heinemeier Hansson2005-03-201-1/+1
| | | | | | datatype. The script was previously failing to create a table (on SQL Server 2000). #834 [adelle] git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@926 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
* Added better defaults for composed_of, so statements like composed_of ↵David Heinemeier Hansson2005-03-011-0/+1
| | | | | | :time_zone, :mapping => %w( time_zone time_zone ) can be written without the mapping part (it's now assumed) git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@821 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
* Added automatic dropping/creating of test tables for running the unit tests ↵David Heinemeier Hansson2005-02-201-0/+1
| | | | | | on all databases #587 [adelle@bullet.net.au] git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@719 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
* Fixed that foreign keys named the same as the association would cause stack ↵David Heinemeier Hansson2005-01-111-1/+5
| | | | | | overflow #437 [Eric Anderson] git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@382 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
* Fixed a bug in the Ruby/MySQL that caused binary content to be escaped badly ↵David Heinemeier Hansson2005-01-011-2/+9
| | | | | | and come back mangled #405 [Tobias Luetke] git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@301 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
* Added automated optimistic locking if the field lock_version is present #384 ↵David Heinemeier Hansson2004-12-311-0/+6
| | | | | | [Michael Koziarski] git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@295 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
* Added higher_item and lower_item as public methods for acts_as_list #342 ↵David Heinemeier Hansson2004-12-191-0/+1
| | | | | | [Tobias Luetke] git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@221 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
* Set a high default salary within the validation rangeDavid Heinemeier Hansson2004-12-191-1/+1
| | | | git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@217 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
* Added Developer#salary for the type testsDavid Heinemeier Hansson2004-12-191-0/+1
| | | | git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@216 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
* Added tree mixin and unit tests for all the mixinsDavid Heinemeier Hansson2004-12-151-1/+15
| | | | git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@156 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
* InitialDavid Heinemeier Hansson2004-11-241-0/+96
git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@4 5ecf4fe2-1ee6-0310-87b1-e25e094e27de