dbeaver / dbeaver/dbeaver

Copy as SQL (MS-SQL) only sometimes correctly escapes DateTimeOffset

Open
#41,867 2 comments 0 reactions 0 assignees View on GitHub
wait for response x:mssql xf:data xqa:need-testing
Dominant language
Java
Stars
51.8k
Forks
4.4k
Avg merge
3d 13h
Merged PRs (30d)
183

Description

### Description

When a row or multiple columns are selected, Advanced Copy -> Copy as SQL incorrectly forgets to escape DateTimeOffset cells

### DBeaver Version

Community 26.1.1.202606211757

### Operating System

Win 11

### Database and driver

Microsoft JDBC Driver for SQL Server (MSSQL)

### Steps to reproduce

Have a table with a DateTimeOffset cell in it.

If you right click a single cell and Advanced Copy -> Copy as SQL it seems to be valid.

If you select an entire row, or the entire view, and then Advanced Copy -> Copy as SQL you get almost exactly the same output, but the DateTimeOffsets aren't quote-escaped.

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