Research for ruby 2.6 infinite range in ActiveRecord range
> User.where(id: (1..))
SELECT "users".* FROM "users" WHERE "users"."id" BETWEEN $1 AND $2 LIMIT $3 [["id", 1], ["id", nil], ["LIMIT", 11]]
=> #<ActiveRecord::Relation []>
posgre_development=# SELECT * FROM users WHERE users.id BETWEEN 0 AND NULL;
id | created_at | updated_at
----+------------+------------
(0 rows)
> User.where(id: (1..))
User Load (0.2ms) SELECT "users".* FROM "users" WHERE "users"."id" BETWEEN ? AND ? LIMIT ? [["id", 1], ["id", nil], ["LIMIT", 11]]
=> #<ActiveRecord::Relation []>
sqlite> SELECT * FROM users WHERE users.id BETWEEN 0 AND 1;
1|2019-01-09 16:19:13.215559|2019-01-09 16:19:13.215559
sqlite> SELECT * FROM users WHERE users.id BETWEEN 0 AND NULL;
sqlite>
result is null
> User.where(id: (1..))
User Load (17.5ms) SELECT `users`.* FROM `users` WHERE `users`.`id` BETWEEN 1 AND NULL LIMIT 11
=> #<ActiveRecord::Relation []>
mysql> SELECT `users`.* FROM `users` WHERE `users`.`id` BETWEEN 0 AND NULL;
Empty set (0.00 sec)
SELECT * FROM USERS WHERE USERS.ID BETWEEN 1 AND NULL;
no rows selected