orgjkiss.dbeaver.model.exec.DBCException: newPosition > limit: (1664549542 > 1949)at
Nobody has claimed this yet.
- Dominant language
- C
- Stars
- 25.1k
- Forks
- 5k
- Avg merge
- 4d 59m
- Merged PRs (30d)
- 7
Description
表中数据量很少，查询时只有时间条件
升级到3.0.7.1版本
select *
from operation_log
where
operator_time between '2023-07-17‘ and now()
order by
operator_time desc
limit 10
只使用limit 单参数时返回错误
orgjkiss.dbeaver.model.exec.DBCException: newPosition > limit: (1664549542 > 1949)at org,jkiss.dbeaver.ui.editorssql.execute.SQLQueryJob.extractData(SOLQueryJob
使用limit 10,9 返回记录异常
降级到3.0.5.1 版本后后查询正常
Contributor guide
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
Research direction
Start by reproducing the reported SQL query with the time condition and LIMIT 10 on TDengine 3.0.7.1, then compare its behavior with 3.0.5.1. Investigate the DBeaver SQLQueryJob extraction path associated with the reported DBCException and verify whether single-argument and two-argument LIMIT queries return correct records without the newPosition error.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- sql
- Domain
- databases
- Issue type
- Bug
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Activity status
- Stale
- Clarity
- Needs clarification
- Newbie friendliness
- 25/100