No column was specified for column 22 of 'dbvrcnt'

[manztihagi]

Description

When changing the result count on red circle then click the blue circle (* see on picture), the error showing.

Detail error on picture.

DBeaver Version

Community Edition Version 24.0.4.202405051837

Operating System

Windows 10 - 22H2

Database and driver

Database name: EBWEB2
Database server: SQL Server 14

Steps to reproduce

1. Connect to database => success
2. Querying data => success
3. Change Result-set fetch size (box *see on picture above) to 2500
4. Click Calculate total row count button ==> error shown

Additional context

No response

[manztihagi]

Additional information
@MashaKorax .. even I typing directly on Result-set fetch size box and tap enter, the message shown same error.
But, if I change the Result-set fetch size box then click Execute SQL query, the error are gone and result was shown as per query result.

[MashaKorax]

Hello @manztihagi . It is working fine for me. What am I doing wrong?

REC-20240514093557.mp4

[manztihagi]

@MashaKorax .. I found the error that generated.

On my query statement that having one return field calculation doesn't have any alias name at column 22.

My Query:
select .... , ISNULL(TotalGR, 0), ISNULL(TotalRemaining, 0) As TotalRemaining
From table_name

At another tools that this statement was able to return without any error even re-generate or setting the result-set.
Hopeful the dbeaver also having this feature.