diff options
author | Ryuta Kamizono <kamipo@gmail.com> | 2016-04-14 09:49:39 +0900 |
---|---|---|
committer | Ryuta Kamizono <kamipo@gmail.com> | 2016-04-14 14:22:16 +0900 |
commit | 28ec8c4a57197a43e4369bfbdfa92625bd592fe0 (patch) | |
tree | 5376680dc357962506b982cc9b4f6f82d2d263ab /activerecord/test/cases/scoping/named_scoping_test.rb | |
parent | 128923ca14eeae032c2ed72b043e2bbcda09ab9c (diff) | |
download | rails-28ec8c4a57197a43e4369bfbdfa92625bd592fe0.tar.gz rails-28ec8c4a57197a43e4369bfbdfa92625bd592fe0.tar.bz2 rails-28ec8c4a57197a43e4369bfbdfa92625bd592fe0.zip |
Add `quoted_time` for truncating the date part of a time column value
Context #24522.
TIME column on MariaDB doesn't ignore the date part of the string when
it coerces to time.
```
root@localhost [test] > CREATE TABLE `foos` (`id` int AUTO_INCREMENT PRIMARY KEY, `start` time(0), `finish` time(4)) ENGINE=InnoDB;
Query OK, 0 rows affected (0.02 sec)
root@localhost [test] > INSERT INTO `foos` (`start`, `finish`) VALUES ('2000-01-01 12:30:00', '2000-01-01 12:30:00.999900');
Query OK, 1 row affected, 2 warnings (0.00 sec)
Note (Code 1265): Data truncated for column 'start' at row 1
Note (Code 1265): Data truncated for column 'finish' at row 1
root@localhost [test] > SELECT `foos`.* FROM `foos`;
+----+----------+---------------+
| id | start | finish |
+----+----------+---------------+
| 1 | 12:30:00 | 12:30:00.9999 |
+----+----------+---------------+
1 row in set (0.00 sec)
root@localhost [test] > SELECT `foos`.* FROM `foos` WHERE `foos`.`start` = '2000-01-01 12:30:00' LIMIT 1;
Empty set (0.00 sec)
root@localhost [test] > SELECT `foos`.* FROM `foos` WHERE `foos`.`start` = '12:30:00' LIMIT 1;
+----+----------+---------------+
| id | start | finish |
+----+----------+---------------+
| 1 | 12:30:00 | 12:30:00.9999 |
+----+----------+---------------+
1 row in set (0.00 sec)
```
Diffstat (limited to 'activerecord/test/cases/scoping/named_scoping_test.rb')
0 files changed, 0 insertions, 0 deletions