no data after valid query with community version of dbeaver

[selster1]

Description

I just uninstalled dbeaver, downloaded and installed the latest community version, and restarted my machine. I have a valid query

and i can view the data using the dbeaver gui

but the normal
select * from scratch;
returns no data

which seems surprising???
Thanks selster

DBeaver Version

community edition, just downloaded and installed

Operating System

wind 10

Database and driver

No response

Steps to reproduce

see above with pictures

Additional context

see above

[selster1]

but the above is inside of a function that had not been compiled. One might have thought that a select * from scratch2; -- that is selected and running the code from inside the function as in I am editing this function or trying a part of it-- should not have been a problem, since the scratch2 exists on the HD. Nevertheless, when I run select * from scratch2; outside of the function, it works.

[ged-yuko]

but the normal select * from scratch; returns no data

which seems surprising???

As far as i can see on this screenshot, there is no * character between the SELECT and FROM keywords.
You didn't specify the database you are using these queries with, but Postgre handles this.
For me it seems obvious that having no columns specified for selection, the result will be empty.

Here are some screenshots from DBFiddle:

• SELECT * FROM table gives data result

• SELECT FROM table gives empty result

Everything looks correct. Asking to select something - gives something in result. Asking to select nothing - gives nothing in result.

[selster1]

sorry sorry youre correct
Steve