Wednesday, 15 February 2012

java - MYSQL giving different output on Windows 7 And Linux for same query -


I have installed MySQL on Windows 7 and Red Hat Linux.

Windows 7 MySQL version 5.6.15 and Red Hat Linux MySQL version 5.1.12

I have the table wf_params with the schema below 

  field type collation tap key default additional privilege comment -------------- ------------ -------- ------- ------ --- --- ------- -------------- ---------- ---------------- ----- --------- ID big thing (20) (zero) Select a PRI (zero) auto_decussion, insert Make, update, reference name varchar (100) utf8_unicode_ci Yes (zero) Choose, insert, update Select, LookupId bigint (20) (NULL) Yes (zero) Select Insert, Update, References ExternalAuthId bigint (20) (NULL) Yes (NULL) Select, Insert, Update, Reference LastSync varchar ( 50) Select utf8_unicode_ci Yes (NULL), select Insert, Update, Refer TaskType varchar (50) utf8_general_ci Yes (NULL), Insert, Update, References

It contains data: 

  Functioned functions of ID type type type operator value Pvt Group IDEfault ------ ---------- -------- - ---------- ------ ------- - --------------- ----------- ------ 1 2 Trigger Labels String Ilsad Unorad, Strong (Noula) 1 2 1 Trigger Album Name String Ecclesito Timeline Photos (NULL) 1 3 2 Action Email String Elslato (Null) (NULL) 0 4 7 Trigger Machine List String (NULL) 0

When I run the following following: