dbeaver / dbeaver/dbeaver

Generate SQL copy paste error

Open
#41,115 1 comment 0 reactions 0 assignees View on GitHub
x:db2 z/os xf:sql editor
Dominant language
Java
Stars
51.8k
Forks
4.4k
Avg merge
3d 8h
Merged PRs (30d)
188

Description

### Description

When trying to generate a insert, from an existing result:

Image

This is the last thing that it copies:

Image

And as you can see, in the Generated SQL popup, where it shows you the full generated insert for you to copy,
that is not the end of the query:

Image

It always happens when there's values with spaces in it, like the ones we can see before the NULL values.

The actual solution is manually completing the " ' ' " that's causing the error and copy the rest of the query.

### DBeaver Version

26.0.5 and below

### Operating System

Win 11

### Database and driver

DB2 Z/OS database driver

### Steps to reproduce

1. Perform a SELECT query.
2. Select the desired result and right click and "Generate SQL -> INSERT".
3. Copy the generated SQL code
4. Check if it copies the whole code or it gets stuck in " ' ' " spaces.

### 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.