View Issue Details

IDProjectCategoryView StatusLast Update
0001923CaseTalk ModelerGeneration (SQL, XML, etc)public2022-01-10 20:40
ReporterMarco Wobben Assigned ToMarco Wobben  
PrioritynormalSeveritytweakReproducibilitysometimes
Status closedResolutionfixed 
Target Version9.5.1Fixed in Version9.4.4 
Summary0001923: Create View uses first known column name
DescriptionThe create view uses the first known column name in a source table to cast all others. When a union is build, using multiple columns in the same source table this gets confusing. A common column name should then be used instead.
Additional InformationExample:

  CREATE VIEW Pressure AS
  SELECT
    Diastolic_Pressure -- Diastolic Pressure/Pressure
  FROM Checkup
  UNION
  SELECT
    Systolic_Pressure AS Diastolic_Pressure -- Systolic Pressure/Pressure
  FROM Checkup;
TagsNo tags attached.
CaseTalk Editionunknown

Activities

Marco Wobben

Marco Wobben

2022-01-10 20:40

administrator   ~0003635

Closing automatically, stayed too long in resolved state. Feel free to re-open with additional information if you think the issue is not resolved.

Issue History

Date Modified Username Field Change
2018-11-08 12:23 Marco Wobben New Issue
2018-11-08 12:23 Marco Wobben Status new => assigned
2018-11-08 12:23 Marco Wobben Assigned To => Marco Wobben
2018-11-08 12:24 Marco Wobben Additional Information Updated
2018-11-08 12:24 Marco Wobben Additional Information Updated
2018-11-14 23:24 Marco Wobben Status assigned => resolved
2018-11-14 23:24 Marco Wobben Resolution open => fixed
2018-11-14 23:24 Marco Wobben Fixed in Version => 9.4.4
2022-01-10 20:40 Marco Wobben Note Added: 0003635
2022-01-10 20:40 Marco Wobben Status resolved => closed