dbeaver / dbeaver/dbeaver

Strange warning using TIMESTAMPDIFF

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

Description

### Description

**MY INFORMATIONS**
- DBeaver Community Edition 25.1.5 (but also 25.0 version)
- Windows 10
- MySQL 8.0.43

When I prepare the following query:
```
SELECT dataora, created,
TIMESTAMPDIFF(MINUTE, dataora, created) AS minuti
FROM tracce;
```
DBeaver reports a warning, because it considers "MINUTE" a column name, while it is a keyword of the TIMESTAMPDIFF().

Image

-----
Nothing serious, the query works normally, but it's strange that it's reported as an error.

### DBeaver Version

Community Edition 25.1.5

### Operating System

Windows 10

### Database and driver

Database: MySQL 8.0.43
Driver: MySQL

### Steps to reproduce

1. write che SQL code:
```
SELECT dataora, created,
TIMESTAMPDIFF(MINUTE, dataora, created) AS minuti
FROM tracce;
```
2. see the warning

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