Android Room Windows功能未识别
我使用的是API 31，带有v2.4.2和sqlite v3.32.2的API 31，该v3.32.2应该支持窗口功能。但是这样的简单查询
select *, row_number() over(order by id) from mytable
会在上产生以下错误（
<compound operator>, FROM, GROUP, LIMIT, ORDER, WHERE, comma or semicolon expected, got '('
这是怎么回事？
I'm using API 31 with Room v2.4.2 and SQLite v3.32.2 which is supposed to support window functions. But a simple query like this
select *, row_number() over(order by id) from mytable
produces the following error at over(
<compound operator>, FROM, GROUP, LIMIT, ORDER, WHERE, comma or semicolon expected, got '('
What's wrong with that?
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论