MySQL stream fetch is broken
Open
can't reproduce
x:mysql
xf:data
- Dominant language
- Java
- Stars
- 51.8k
- Forks
- 4.4k
- Avg merge
- 3d 13h
- Merged PRs (30d)
- 183
Description
### Description
Big table data export doesn't work (fails with outofmemory or protocol failure).
Currently we use QueryTransformerFetchAll which sets fetch size to -1 . But it seems to be broken in the new driver or something else is broken on our side.
Workaround: set driver property `useCursorFetch` to TRUE.
Docs: https://dev.mysql.com/doc/connector-j/en/connector-j-reference-implementation-notes.html
### DBeaver Version
24.1
### Operating System
_No response_
### Database and driver
MySQL 8+
### Steps to reproduce
Try to export big table (like 100 million rows) into any file format.
### Additional context
_No response_
Contributor guide
Assessment
This issue has not been assessed yet.