aboutsummaryrefslogtreecommitdiffstats
path: root/activerecord/lib/active_record/connection_adapters/mysql_adapter.rb
Commit message (Collapse)AuthorAgeFilesLines
* Make the mysql schema dumper roundtrip the limits of text/blob columns. ↵Michael Koziarski2008-03-021-0/+17
| | | | | | Closes #7424 [will.bryant] git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@8969 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
* MySQL: memoize column and table name quoting to reduce garbageJeremy Kemper2008-02-031-7/+8
| | | | git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@8794 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
* MySQL: omit text/blob defaults from the schema instead of using an empty ↵Jeremy Kemper2008-01-301-1/+1
| | | | | | string. Closes #10963. git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@8757 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
* Foxy fixtures. Adapter#disable_referential_integrity. Closes #9981.Jeremy Kemper2007-10-261-0/+12
| | | | git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@8036 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
* Remove superfluous code and quote table name. References #9971 [jkit, nzkoz]Michael Koziarski2007-10-251-2/+1
| | | | git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@8015 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
* Make sure that the Schema Dumper supports non-standard primary keys with ↵Michael Koziarski2007-10-251-0/+10
| | | | | | MySQL. Closes #9971 [RubyRedRick] git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@8012 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
* Ensure that mysql quotes table names with database names correctly. Closes ↵Rick Olson2007-10-201-1/+1
| | | | | | #9911 [crayz] git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@7980 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
* Quote table names. Defaults to column quoting. Closes #4593.Jeremy Kemper2007-10-161-12/+20
| | | | git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@7932 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
* MySQL: fix change_column on not-null columns that don't accept dfeault ↵Jeremy Kemper2007-10-081-2/+2
| | | | | | values of ''. Closes #6663. git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@7790 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
* Use fast date/time parsing by default. Closes #9811.Jeremy Kemper2007-10-071-29/+0
| | | | git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@7780 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
* Reinstate failsafe date/time parsing rescues. Head off some obvious failures ↵Jeremy Kemper2007-10-071-18/+16
| | | | | | like year == 0 or nil. git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@7771 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
* MySQL: speedup date/time parsing.Jeremy Kemper2007-10-071-0/+30
| | | | git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@7769 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
* Ruby 1.9 compat for instance method check in Mysql adapter.Jeremy Kemper2007-09-291-1/+2
| | | | git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@7688 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
* MySQL: change_column raises if the table or column doesn't exist.Jeremy Kemper2007-09-281-1/+5
| | | | git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@7665 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
* Stress that you should really install the C-based MySQL library when running ↵David Heinemeier Hansson2007-09-201-0/+5
| | | | | | on the pure Ruby one (closes #9507) git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@7521 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
* Speed up and simplify query caching.Jeremy Kemper2007-09-171-4/+4
| | | | git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@7498 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
* connection.select_rows 'sql' returns an array (rows) of arrays (field ↵Jeremy Kemper2007-09-161-0/+9
| | | | | | values). Closes #2329. git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@7497 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
* Work around mysql limitations for defaults on text columns with not null. ↵Michael Koziarski2007-09-041-0/+1
| | | | | | Closes #9324 [caio] git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@7405 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
* MySQL: fix show_variable. Closes #8448.Jeremy Kemper2007-06-201-1/+2
| | | | git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@7071 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
* SQLite, MySQL, PostgreSQL, Oracle: quote column names in column migration ↵Jeremy Kemper2007-05-291-3/+3
| | | | | | SQL statements. Closes #8466. git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@6889 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
* MySQL: create_database takes :charset and :collation options. Charset ↵Jeremy Kemper2007-05-261-9/+35
| | | | | | defaults to utf8. References #8448. git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@6848 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
* Add documentation for :encoding option to mysql adapter. Closes #8219 [marclove]Marcel Molina2007-05-061-0/+1
| | | | git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@6678 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
* MySQL: blob and text columns may not have defaults in 5.x. Update fixtures ↵Jeremy Kemper2007-01-281-4/+10
| | | | | | schema for strict mode. Closes #6695. git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@6074 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
* MySQL: SET SQL_AUTO_IS_NULL=0 so 'where id is null' doesn't select the last ↵Jeremy Kemper2007-01-281-0/+4
| | | | | | inserted id. Closes #6778. git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@6064 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
* Nodoc the irrelevant (from 1.2)David Heinemeier Hansson2007-01-261-3/+3
| | | | git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@6044 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
* change_column accepts :default => nil. Closes #6956.Jeremy Kemper2007-01-151-2/+2
| | | | git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@5937 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
* MySQL, PostgreSQL: change_column_default quotes the default value and ↵Jeremy Kemper2007-01-151-1/+1
| | | | | | 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
* 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
* 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
* Oracle: resolve test failures, use prefetched primary key for inserts, check ↵Jeremy Kemper2006-11-011-13/+1
| | | | | | 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
* 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
* 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
* r4704@asus: jeremy | 2006-06-27 12:00:19 -0700Jeremy Kemper2006-07-081-1/+4
| | | | | | | | | | | | | | | 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
* Preserve MySQL boolean column defaults when changing a column in a ↵Marcel Molina2006-05-141-1/+3
| | | | | | migration. Closes #5015. [pdcawley@bofh.org.uk] git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@4340 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
* Properly quote index names in migrations (closes #4764) [John Long]Rick Olson2006-04-201-1/+0
| | | | git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@4239 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
* Only string_to_binary if the column respondsDavid Heinemeier Hansson2006-03-261-1/+1
| | | | git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@4040 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
* Fixed that MySQL enums should always be returned as strings (closes #3501) [DHH]David Heinemeier Hansson2006-03-251-0/+1
| | | | git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@4028 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
* Added connection#current_database that'll return of the current database ↵David Heinemeier Hansson2006-03-181-0/+3
| | | | | | (only works in MySQL, SQL Server, and Oracle so far -- please help implement for the rest of the adapters) (closes #3663) [Tom ward] git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@3911 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
* Make all tinyint(1) variants act like boolean in mysql (tinyint(1) unsigned, ↵Jamis Buck2006-03-171-1/+1
| | | | | | etc.) git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@3902 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
* Stop the MySQL adapter crashing when views are present. (closes #3782) ↵David Heinemeier Hansson2006-03-161-1/+16
| | | | | | [Jonathan Viney] git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@3886 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
* ActiveRecord::Base.remove_connection explicitly closes database connections ↵Jeremy Kemper2006-02-261-1/+5
| | | | | | and doesn't corrupt the connection cache. Introducing the disconnect! instance method for the PostgreSQL, MySQL, and SQL Server adapters; implementations for the others are welcome. References #3591. git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@3674 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
* Escape database name in MySQL adapter when creating and dropping databases. ↵Marcel Molina2006-01-131-2/+2
| | | | | | Closes #3409. git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@3403 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
* MySQL: allow encoding option for mysql.rb driver.Jeremy Kemper2005-12-131-5/+1
| | | | git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@3293 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
* MySQL: ensure that @config is set.Jeremy Kemper2005-12-091-3/+2
| | | | git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@3264 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
* MySQL: more robust test for nullified result hashes. References #3124.Jeremy Kemper2005-12-081-8/+2
| | | | git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@3246 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
* MySQL: work around ruby-mysql/mysql-ruby inconsistency with mysql.stat. ↵Jeremy Kemper2005-12-031-7/+9
| | | | | | Eliminate usage of mysql.ping because it doesn't guarantee reconnect. Explicitly close and reopen the connection instead. References #428. git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@3216 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
* MySQL: active? compatibility with the pure-Ruby driver. References #428.Jeremy Kemper2005-11-281-1/+5
| | | | git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@3194 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
* MySQL, PostgreSQL: reconnect! also reconfigures the connection. Otherwise, ↵Jeremy Kemper2005-11-221-15/+19
| | | | | | the connection 'loses' its settings if it times out and is reconnected. Closes #2978. git-svn-id: http://svn-commit.rubyonrails.org/rails/trunk@3165 5ecf4fe2-1ee6-0310-87b1-e25e094e27de
generated by cgit v1.2.3 (git 2.25.1) at 2024-07-16 13:02:54 +0000