[問題] sqlite的bug?

作者: cert889 (展翅高飛)   2017-10-22 08:18:06
Hi, all
我在使用sqlite的Max和Min時,發生奇怪的問題如下:
SQLite version 3.20.1 2017-08-24 16:21:36
Enter ".help" for usage hints.
sqlite> SELECT Max(close) FROM Daily WHERE rowid<=62;
.97
sqlite> SELECT Min(close) FROM Daily WHERE rowid<=62;
1.03
sqlite> SELECT Max(close) FROM Daily WHERE rowid<=61;
.97
sqlite> SELECT Min(close) FROM Daily WHERE rowid<=61;
.76
如上所示,rowid<=61時,可以正常取Max和Min值
但rowid<=62時,Min值居然大於Max值??
請問有人知道rowid=62時,發生了什麼事嗎?....囧>

Links booklink

Contact Us: admin [ a t ] ucptt.com