1***@qq.com
1***@qq.com
  • 发布:2020-02-15 13:51
  • 更新:2023-02-23 10:04
  • 阅读:594

plus.sqlite取出Long的类型的数据被截取。

分类:Native.js

plus.sqlite无法取出Long的类型,项目有13位时间戳,类似1580914527123,这样的
然后select * from message就不行了出来的结果 就是类似以下的结果:

912321
9823233
-342232

数据是内置再数据库内的,为了进一步定位问题执行以下sql语句

SELECT id/10 as a, id/100 as b, id/1000 as c, datetime(id/1000, 'unixepoch', 'localtime') as dt from message

01:38:48.766 {"a":158000000,"b":15800000,"c":1580000,"dt":"1970-01-19 14:53:20"} at common/rj-lib/db.js:240
01:38:48.796 {"a":1580548650,"b":158054865,"c":15805486,"dt":"1970-07-03 06:24:46"} at common/rj-lib/db.js:240
01:38:48.826 {"a":-1374382677,"b":1580548650,"c":158054865,"dt":"1975-01-04 16:07:45"} at common/rj-lib/db.js:240
01:38:48.854 {"a":-858924872,"b":-1374382676,"c":1580548650,"dt":"2020-02-01 17:17:30"} at common/rj-lib/db.js:240
01:38:48.884 {"a":-858924872,"b":-1374382676,"c":1580548650,"dt":"2020-02-01 17:17:30"} at common/rj-lib/db.js:240
01:38:48.914 {"a":-858924871,"b":-1374382676,"c":1580548650,"dt":"2020-02-01 17:17:30"} at common/rj-lib/db.js:240
01:38:48.944 {"a":-858924871,"b":-1374382676,"c":1580548650,"dt":"2020-02-01 17:17:30"} at common/rj-lib/db.js:240
01:38:48.944 {"a":-858924870,"b":-1374382676,"c":1580548650,"dt":"2020-02-01 17:17:30"} at common/rj-lib/db.js:240
01:38:48.969 {"a":-858924870,"b":-1374382676,"c":1580548650,"dt":"2020-02-01 17:17:30"} at common/rj-lib/db.js:240
01:38:48.991 {"a":-822337252,"b":-1370723914,"c":1580914527,"dt":"2020-02-05 22:55:27"} at common/rj-lib/db.js:240

由上可见当sqlite的integeer类型,大于10位就无法取出,如果取出长度是10位就没问题,11,12,13都不行,

请小编帮解决下问题

以上只在安卓上测试

2020-02-15 13:51 负责人:无 分享
已邀请:
freewolf

freewolf

同问帮顶

国环地标

国环地标

一样的问题 希望官方给出解释

要回复问题请先登录注册