apache / apache/drill

An error occurred when querying the database by pagination from Oracle 11g database

Open
#2,993 0 comments 0 reactions 0 assignees View on GitHub
bug
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.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.