Handlersocket return type for date/time fields

Asked by Erik Jacobson on 2012-01-12

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. :(

Question information

Language:
English Edit question
Status:
Solved
For:
Percona Server Edit question
Assignee:
No assignee Edit question
Solved by:
Erik Jacobson
Solved:
2012-01-13
Last query:
2012-01-13
Last reply:
2012-01-13
Alexey Kopytov (akopytov) said : #1

This should be reported to HandlerSocket devs as a bug or a feature request. We don't do HandlerSocket development, we just bundle the plugin with Percona Server.

Erik Jacobson (kross) said : #2

My mistake, thanks!