Regression on datetime fields with sub-second precision?

[neverhoodboy]

I'm on by_star version 4.0.1.

Suppose I have a datetime field with microsecond precision:

create_table :table_xs do |t|
  t.datetime "field_a", precision: 6
end

The following method call

TableX.by_day(Date.today, field: field_a) # Today is 2023-02-26.

will generate a query like this (suppose I'm at UTC+00:00 timezone):

SELECT `table_xs`.* FROM `table_xs` WHERE (field_a >= '2023-02-26 00:00:00' AND field_a <= '2023-02-26 23:59:59')

which is problematic because records with field_a between 2023-02-26 23:59:59.000000 and 2023-02-26 23:59:59.999999 will not be included in the query result. (Yes, the excluded range starts from 2023-02-26 23:59:59.000000, not 2023-02-26 23:59:59.000001.)

by_star version 3.0.0 handled sub-second precision datetime fields correctly. The same method call as above would generate the following query:

SELECT `table_xs`.* FROM `table_xs` WHERE (field_a >= '2023-02-26 00:00:00.000000' AND field_a <= '2023-02-26 23:59:59.999999')