0001765: Feature request: Being able to see field type of output fields in SQL Editor

ID	Project	Category	View Status	Date Submitted	Last Update

0001765	Database Workbench v6	General	public	2020-03-10 12:05	2021-06-08 13:34

Reporter	Svein Erling Tysvær	Assigned To
Priority	normal	Severity	feature	Reproducibility	always
Status	acknowledged	Resolution	open

Summary	0001765: Feature request: Being able to see field type of output fields in SQL Editor
Description	I had a query (simplified): SELECT MyDate FROM MyTable UNION SELECT '01.01.2020' FROM RDB$DATABASE (the local shortdate format is dd.mm.yyyy) and noticed this query returned varying formats, e.g. 2019-02-12 01.01.2020 It was my fault and very simple to fix: SELECT MyDate FROM MyTable UNION SELECT CAST( '01.01.2020' AS DATE ) FROM RDB$DATABASE but it also made me desire to be able to see the format of output fields (so that I could have noticed that the output field was (probably) (VAR)CHAR and not DATE before executing the query).
Additional Information	Ideally, I would like to be able to see the fields as they would have been in a CREATE TABLE statement (obviously without any table name since output datasets aren't named).
Tags	No tags attached.

Date Modified	Username	Field	Change
2020-03-10 12:05	Svein Erling Tysvær	New Issue
2020-03-16 11:08	Martijn Tonies	Status	new => acknowledged
2021-06-08 13:34	Martijn Tonies	Project	Database Workbench v5 => Database Workbench v6