View Issue Details

IDProjectCategoryView StatusLast Update
0001765Database Workbench v6Generalpublic2021-06-08 13:34
ReporterSvein Erling Tysvær Assigned To 
PrioritynormalSeverityfeatureReproducibilityalways
Status acknowledgedResolutionopen 
Summary0001765: Feature request: Being able to see field type of output fields in SQL Editor
DescriptionI 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 InformationIdeally, 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).
TagsNo tags attached.

Activities

There are no notes attached to this issue.

Issue History

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