aboutsummaryrefslogtreecommitdiffstats
path: root/activerecord/lib/active_record/connection_adapters
Commit message (Collapse)AuthorAgeFilesLines
* MySQL, PostgreSQL: change_column_default quotes the default value and ↵Jeremy Kemper2007-01-152-2/+2
| | | | | | doesn't lose column type information. References #3987, closes #6664. git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@5935 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
* Oracle: create_table takes a :sequence_name option to override the ↵Jeremy Kemper2007-01-153-6/+8
| | | | | | 'tablename_seq' default. Closes #7000. git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@5933 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
* MySQL: retain SSL settings on reconnect. Closes #6976.Jeremy Kemper2007-01-141-0/+1
| | | | git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@5929 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
* Oracle: correctly perform eager finds with :limit and :order. Closes #7021.Jeremy Kemper2007-01-131-10/+17
| | | | git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@5919 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
* SQLServer: handle [quoted] table names. Closes #6635.Jeremy Kemper2007-01-121-0/+1
| | | | git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@5891 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
* PostgreSQL: use a subselect to correctly perform eager finds with :limit and ↵Jeremy Kemper2007-01-122-4/+22
| | | | | | :order. Closes #4668. git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@5887 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
* Fix the Oracle adapter for serialized attributes stored in CLOBs. Closes ↵Michael Koziarski2007-01-051-0/+1
| | | | | | #6825 [mschoen, tdfowler] git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@5866 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
* Sybase adapter fixes. Closes #6926 [jsheets]Michael Koziarski2007-01-051-143/+138
| | | | git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@5839 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
* Oracle: fix connection reset failure. Closes #6846.Jeremy Kemper2006-12-201-1/+1
| | | | git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@5761 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
* If only life was that simple (it didnt help)David Heinemeier Hansson2006-12-013-0/+18
| | | | git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@5658 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
* Replace the elaborate reloading connection checking scheme, just fix the ↵David Heinemeier Hansson2006-12-013-18/+0
| | | | | | Ruby-based MySQL adapter, ye? git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@5656 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
* Only reload connections in development mode that supports (and requires ↵David Heinemeier Hansson2006-11-263-0/+18
| | | | | | that) -- in other words, only do it for SQLite (closes #6687, #6700) [DHH] git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@5637 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
* Quote ActiveSupport::Multibyte::Chars. Closes #6653.Jeremy Kemper2006-11-201-1/+2
| | | | git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@5597 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
* Test for forged '' default before it's typecast. Closes #6156.Jeremy Kemper2006-11-201-2/+3
| | | | git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@5596 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
* MySQL: detect when a NOT NULL column without a default value is misreported ↵Jeremy Kemper2006-11-201-0/+19
| | | | | | as default ''. Can't detect for string, text, and binary columns since '' is a legitimate default. Closes #6156. git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@5586 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
* Mysql::Result#all_hashes compatibility with Mysql C driver 2.6.x. Closes #6601.Jeremy Kemper2006-11-161-20/+22
| | | | git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@5533 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
* Cleanup SQLite AUTOINCREMENT: exclude sqlite_sequence table, factor out ↵Jeremy Kemper2006-11-141-2/+12
| | | | | | feature availability check. git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@5520 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
* Oracle: automatically detect the primary key. Closes #6594.Jeremy Kemper2006-11-131-4/+23
| | | | git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@5514 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
* Oracle: to increase performance, prefetch 100 rows and enable similar cursor ↵Jeremy Kemper2006-11-131-2/+6
| | | | | | sharing. Both are configurable in database.yml. Closes #6607. git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@5509 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
* Oracle: fix limited id selection for eager loading. Closes #6515.Jeremy Kemper2006-11-104-19/+53
| | | | git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@5480 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
* SQLite: use AUTOINCREMENT primary key in >= 3.1.0. Closes #6588.Jeremy Kemper2006-11-091-1/+9
| | | | git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@5477 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
* Firebird: decimal/numeric support. Closes #6408.Jeremy Kemper2006-11-071-10/+7
| | | | git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@5459 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
* SQLite: count(distinct) queries supported in >= 3.2.6, fix calculations ↵Jeremy Kemper2006-11-051-47/+32
| | | | | | workaround, remove count(distinct) query rewrite, cleanup test connection scripts. Closes #6544. git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@5426 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
* Oracle: resolve test failures, use prefetched primary key for inserts, check ↵Jeremy Kemper2006-11-017-110/+53
| | | | | | for null defaults. Factor out some common methods from all adapters. Closes #6515. git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@5384 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
* Make add_column use the options hash with the Sqlite Adapter. Closes #6464 ↵Michael Koziarski2006-10-241-1/+1
| | | | | | [obrie] git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@5353 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
* MySQL: all_hashes compatibility with old MysqlRes class. Closes #6429.Jeremy Kemper2006-10-201-4/+10
| | | | git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@5330 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
* automatically add primary key to #select_limited_ids_list order by clause ↵Rick Olson2006-10-132-0/+10
| | | | | | for databases that require order columns in the distinct statements (postgresql) [Rick] git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@5292 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
* fix select_limited_ids_list issues in postgresql, retain current behavior in ↵Rick Olson2006-10-132-1/+15
| | | | | | other adapters [Rick] git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@5291 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
* learn to clean up after myselfRick Olson2006-10-091-4/+0
| | | | git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@5266 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
* Reverted old select_limited_ids_list postgresql fix that caused issues in ↵Rick Olson2006-10-091-0/+4
| | | | | | mysql. Closes #5851 [Rick] git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@5265 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
* Fixed rename_table on SQLite tables with indexes defined (closes #5942) ↵David Heinemeier Hansson2006-10-091-6/+18
| | | | | | [brandon@opensoul.org] git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@5260 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
* Added timeout option to SQLite3 configurations to deal more gracefully with ↵David Heinemeier Hansson2006-10-091-0/+3
| | | | | | SQLite3::BusyException, now the connection can instead retry for x seconds to see if the db clears up before throwing that exception (closes #6126) [wreese@gmail.com] Added default timeout setting of 5 seconds to SQLite3 database.yml configurations [DHH] git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@5258 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
* MySQL: introduce Mysql::Result#all_hashes to support further optimization. ↵Jeremy Kemper2006-10-021-10/+41
| | | | | | Closes #5581. git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@5219 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
* SQLServer: work around bug where some unambiguous date formats are not ↵Jeremy Kemper2006-08-251-1/+2
| | | | | | correctly identified if the session language is set to german. Closes #5894. git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@4816 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
* Rollback #5819 since it's compatible with PostgreSQL 8.1 only. References #5819.Jeremy Kemper2006-08-221-1/+5
| | | | git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@4806 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
* whitespaceJeremy Kemper2006-08-191-2/+1
| | | | git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@4789 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
* PostgreSQL: simplify index introspection query. Closes #5819.Jeremy Kemper2006-08-191-5/+2
| | | | git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@4788 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
* Make indexed columns easy to extract from the index name. Oracle users ↵Jeremy Kemper2006-08-151-1/+1
| | | | | | should explicitly assign index names due to field length restrictions. git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@4768 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
* Migrations: uniquely name multicolumn indexes so you don't have to.Jeremy Kemper2006-08-151-10/+8
| | | | git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@4767 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
* PostgreSQL: autodetected sequences work correctly with multiple schemas. ↵Jeremy Kemper2006-08-091-2/+3
| | | | | | Rely on the schema search_path instead of explicitly qualifying the sequence name with its schema. Closes #5280. git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@4737 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
* Refactored select routing for SQL Server adapter (closes #5683) [tom@popdog.net]David Heinemeier Hansson2006-08-051-11/+11
| | | | git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@4671 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
* Patch sql injection vulnerability when using integer or float columns.Jamis Buck2006-07-271-1/+2
| | | | git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@4626 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
* create_table rdoc: suggest :id => false for habtm join tablesJeremy Kemper2006-07-101-2/+2
| | | | git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@4606 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
* PostgreSQL: return array fields as strings. Closes #4664.Jeremy Kemper2006-07-101-0/+2
| | | | git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@4605 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
* SQLServer: added tests to ensure all database statements are closed, ↵Jeremy Kemper2006-07-101-94/+123
| | | | | | refactored identity_insert management code to use blocks, removed update/delete rowcount code out of execute and into update/delete, changed insert to go through execute method, removed unused quoting methods, disabled pessimistic locking tests as feature is currently unsupported, fixed RakeFile to load sqlserver specific tests whether running in ado or odbc mode, fixed support for recently added decimal types, added support for limits on integer types. Closes #5670. git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@4601 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
* Oracle: BigDecimal support. Closes #5667.Jeremy Kemper2006-07-102-20/+17
| | | | git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@4600 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
* r4704@asus: jeremy | 2006-06-27 12:00:19 -0700Jeremy Kemper2006-07-0813-101/+199
| | | | | | | | | | | | | | | 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
* Firebird migrations support. Closes #5337.Jeremy Kemper2006-07-081-38/+358
| | | | git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@4594 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
* Respect type method. #5337Jeremy Kemper2006-07-081-4/+2
| | | | git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@4593 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
* PostgreSQL: correctly quote the ' in pk_and_sequence_for. Closes #5462.Jeremy Kemper2006-07-071-1/+1
| | | | git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@4580 5ecf4fe2-1ee6-0310-87b1-e25e094e27de