Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Not a Bug
-
1.0.9
-
None
-
centos6.8
Description
first time:
MariaDB [saas]> select xiaoshuA,mingziA,date_format(riqiA, '%Y-%m-%d %H:%i:%s') riqiA,zhengshuA from saas.u1_default_wooieuqbgs_8 limit 0, 1000;
.....
| 2.040000000000000 | 7 | 0000-00-00 00:00:00 | 607 |
| 2.860000000000000 | 1 | 2016-10-30 00:00:00 | 322 |
| 2.070000000000000 | 2 | 0000-00-00 00:00:00 | 583 |
| 2.810000000000000 | 3 | 0000-00-00 00:00:00 | 202 |
| 2.010000000000000 | 4 | 0000-00-00 00:00:00 | 274 |
| 2.560000000000000 | 5 | 0000-00-00 00:00:00 | 705 |
| 2.250000000000000 | 6 | 0000-00-00 00:00:00 | 618 |
--------------------------------------------------------+
second time:
MariaDB [saas]> select xiaoshuA,mingziA,date_format(riqiA, '%Y-%m-%d %H:%i:%s') riqiA,zhengshuA from saas.u1_default_wooieuqbgs_8 limit 0, 1000;
....
| 2.400000000000000 | 48 | 0000-00-00 00:00:00 | 762 |
| 2.550000000000000 | 49 | 0000-00-00 00:00:00 | 707 |
| 2.130000000000000 | 50 | 0000-00-00 00:00:00 | 816 |
| 2.620000000000000 | 52 | 2013-10-22 00:00:00 | 791 |
| 2.100000000000000 | 54 | 0000-00-00 00:00:00 | 234 |
| 2.100000000000000 | 54 | 2014-10-31 00:00:00 | 442 |
--------------------------------------------------------+
third time:
.....
| 2.040000000000000 | 7 | 0000-00-00 00:00:00 | 607 |
| 2.860000000000000 | 1 | 2016-10-30 00:00:00 | 322 |
| 2.070000000000000 | 2 | 0000-00-00 00:00:00 | 583 |
| 2.810000000000000 | 3 | 0000-00-00 00:00:00 | 202 |
| 2.010000000000000 | 4 | 0000-00-00 00:00:00 | 274 |
| 2.560000000000000 | 5 | 0000-00-00 00:00:00 | 705 |
| 2.250000000000000 | 6 | 0000-00-00 00:00:00 | 618 |
--------------------------------------------------------+
why the result is diffrent when I execute the same sql too many times ?
bty, sometimes,the result is the same.sometimes,result is diffrent.