diff options
| author | Chetna Sharma <chetnasharma1726@gmail.com> | 2016-07-25 18:17:18 +0530 |
|---|---|---|
| committer | Chetna Sharma <chetnasharma1726@gmail.com> | 2016-07-25 18:40:31 +0530 |
| commit | a9dabd6939f99148750854b09bbb0eeeaed21d51 (patch) | |
| tree | 9f2b6b5b6c5bc9e8f5d038d1a2b34bccae765726 /guides/source/active_record_querying.md | |
| parent | 7ebef567ce30d848dd8f9374fd70699fd91acb29 (diff) | |
| download | rails-a9dabd6939f99148750854b09bbb0eeeaed21d51.tar.gz rails-a9dabd6939f99148750854b09bbb0eeeaed21d51.tar.bz2 rails-a9dabd6939f99148750854b09bbb0eeeaed21d51.zip | |
[ci skip] Add documentation for error using select with order
Diffstat (limited to 'guides/source/active_record_querying.md')
| -rw-r--r-- | guides/source/active_record_querying.md | 1 |
1 files changed, 1 insertions, 0 deletions
diff --git a/guides/source/active_record_querying.md b/guides/source/active_record_querying.md index 90f200133b..8ffd0d033d 100644 --- a/guides/source/active_record_querying.md +++ b/guides/source/active_record_querying.md @@ -601,6 +601,7 @@ If you want to call `order` multiple times, subsequent orders will be appended t Client.order("orders_count ASC").order("created_at DESC") # SELECT * FROM clients ORDER BY orders_count ASC, created_at DESC ``` +WARNING: If you are using **MySQL 5.7.5** and above, then on selecting fields from a result set using methods like `select`, `pluck` and `ids`; the `order` method will raise an `ActiveRecord::StatementInvalid` exception unless the field(s) used in `order` clause are included in the select list. See the next section for selecting fields from the result set. Selecting Specific Fields ------------------------- |