dbeaver / dbeaver/dbeaver

The `Use SQL to limit fetch size` is not working for Databend

Open
#23,129 4 comments 0 reactions 0 assignees View on GitHub
enhancement xf:sql
Dominant language
Java
Stars
51.8k
Forks
4.4k
Avg merge
3d 8h
Merged PRs (30d)
188

Description

### Description

Hi team,

I'm using DBeaver Community Edition 24.0.0 and trying to use a custom [Databend JDBC driver](https://repo1.maven.org/maven2/com/databend/databend-jdbc/0.1.9/).

All works fine except that the `Use SQL to limit fetch size` checkbox seems not working.

as the screenshots shows, the LIMIT clause is not attached to the query automatically.

image
image

And I tested with a internal MySQL driver and it turned out the LIMIT clause is attached to the query automatically, so I assume that this is something wrong with the custom driver.

can someone kindly show me how this LIMIT clause is attached automatically and how I can improve the custom driver to implement that?

thank you.

### DBeaver Version

Community Edition 24.0.0

### Operating System

macOS Sonoma Version 14.1.1 Apple M1 Max Chip

### Database and driver

Database: Databend https://www.databend.com/

driver: https://repo1.maven.org/maven2/com/databend/databend-jdbc/0.1.9/

### Steps to reproduce

_No response_

### Additional context

_No response_

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.