HandlerSocket-Plugin-for-MySQL icon indicating copy to clipboard operation
HandlerSocket-Plugin-for-MySQL copied to clipboard

Return type for date/time fields

Open Azhrarn opened this issue 13 years ago • 0 comments

I know Handlersocket is all about keeping things simple in the name of speed, hence not doing fancy sorting on indexes and the like. But when dealing with datetime and other timestamp related fields, it seems to return and compare on the english string value rather then epoch time.

This seems counter intuitive for the plugin to be doing a conversion here in a way that makes filtering impossible, or does innodb not actually store time fields in a sane sortable way like epoch?

If a patch were made so we could do comparisons on time fields, I wouldn't have to do things like run normal SQL queries to generate an IN() list for filtering on other columns. :(

Azhrarn avatar Jan 13 '12 19:01 Azhrarn