FullOrderByPushDown
Enables pushing `ORDER BY` to the server for supported columns, including problematic datetime columns. For these columns, milliseconds are trimmed to align with the server's behavior. Note: When this property is enabled, millisecond precision is lost for problematic datetime columns, even if the query does not include an ORDER BY clause.
データ型
bool
デフォルト値
false
解説
Default: false – `ORDER BY` is not applied server-side for problematic datetime columns, as the server only supports ordering up to the second (ignoring milliseconds), which can cause inaccurate sorting.
When set to true, the driver applies `ORDER BY` on the server for these problematic datetime columns, trimming milliseconds to align with the server's second-level precision. As a result, millisecond precision is lost in these columns regardless of whether the query specifies an ORDER BY clause.