• R
    Should keep quoting behaivor of a time column value in sqlite3 adapter · 73af7945
    Ryuta Kamizono 提交于
    Follow up to #24542.
    
    In MySQL and PostgreSQL, a time column value is saved as ignored the
    date part of it. But in SQLite3, a time column value is saved as a string.
    
    We should keep previous quoting behavior in sqlite3 adapter.
    
    ```
    sqlite> CREATE TABLE "foos" ("id" INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, "start" time(0), "finish" time(4));
    sqlite> INSERT INTO "foos" ("start", "finish") VALUES ('2000-01-01 12:30:00', '2000-01-01 12:30:00.999900');
    sqlite> SELECT "foos".* FROM "foos";
    1|2000-01-01 12:30:00|2000-01-01 12:30:00.999900
    sqlite> SELECT  "foos".* FROM "foos" WHERE "foos"."start" = '2000-01-01 12:30:00' LIMIT 1;
    1|2000-01-01 12:30:00|2000-01-01 12:30:00.999900
    sqlite> SELECT  "foos".* FROM "foos" WHERE "foos"."start" = '12:30:00' LIMIT 1;
    sqlite>
    ```
    73af7945
quoting_test.rb 2.6 KB