下表包含我在Android上的SQLite数据库:
>>>>> Dumping cursor android.database.sqlite.SQLiteCursor@9f3d273
0 {
id=1543948972569
relationItemID=-1
degree=-1
}
1 {
id=-1
relationItemID=1543948972569
degree=1
}
2 {
id=1543948972569
relationItemID=1543948978808
degree=1
}
3 {
id=1543948978808
relationItemID=1543948972569
degree=-1
}
<<<<<
SQLite查询
SELECT id FROM itemsHierarchy
WHERE id = 1543948972569 AND degree BETWEEN 0 AND -128
返回一个空光标,即使它应该找到第一个条目的id
。但是如果我使用'<'它的工作原理与下面的"0和-128之间"不同。
SELECT id FROM itemsHierarchy WHERE id = 1543948972569 AND degree < 0;
是我做错了什么,还是SQLite的问题?
应该是-
SELECT id
FROM itemsHierarchy
WHERE id = 1543948972569
AND degree BETWEEN -128 AND 0