An error occurred when querying the database by pagination from Oracle 11g database
- Dominant language
- Java
- Stars
- 2k
- Forks
- 990
- Avg merge
- 1d 8h
- Merged PRs (30d)
- 5
Description
apache-drill version: 1.22.0
oracle version: 11g
The query will return an error when the SQL statement contains `limit`.
```log
org.apache.drill.common.exceptions.UserRemoteException: DATA_READ ERROR: The JDBC storage plugin failed while trying setup the SQL query.
Sql: SELECT *
FROM "APEX_030200"."WWV_FLOWS"
FETCH NEXT 10 ROWS ONLY
Fragment: 0:0
```
storage plugin:
```json
{
"type": "jdbc",
"driver": "oracle.jdbc.OracleDriver",
"url": "jdbc:oracle:thin:@//xxx.xxx.xxx.xxx:1521/orcl",
"username": "xxx",
"password": "xxx",
"authMode": "SHARED_USER",
"writerBatchSize": 10000,
"enabled": true
}
```
Contributor guide
No contributing guide indexed for this repository
Assessment
This issue has not been assessed yet.