View Issue Details

Jump to NotesJump to History
IDProjectCategoryView StatusDate SubmittedLast Update
0002128CaseTalk ModelerGeneration (SQL, XML, etc)public2019-04-25 09:362022-01-10 20:40
ReporterMarco Wobben Assigned ToMarco Wobben  
PrioritynormalSeveritytweakReproducibilitysometimes
Status closedResolutionfixed 
Target Version9.5.3Fixed in Version9.5.3 
Summary0002128: Denodo Load script
DescriptionThere are a few minor issues with the load script for Denodo.
1) The scripts generated using TO_TIME are missing a comma.
2) The load script does not have a separete folder definition.
3) The unload script removes the tuples, but Denodo does not support it.
Steps To Reproduce1)

INSERT INTO t_Tijdstip
  (time, minute_of_the_day)
VALUES
  (TO_TIME('HH:mm:ss' '08:00:00'), 480)

---
There should be a comma after the time format 'HH:mm:ss'
TagsNo tags attached.
CaseTalk Editionunknown

Activities

Marco Wobben

Marco Wobben

2019-04-25 10:17

administrator   ~0001425

1) TO_TIME now has a separation comma.
2) The INSERT statement does not support Folder specifications. The Materialized View however is created in the Examples folder.
3) Unload script has been removed from generator.
Marco Wobben

Marco Wobben

2022-01-10 20:40

administrator   ~0003790

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
2019-04-25 09:36 Marco Wobben New Issue
2019-04-25 09:36 Marco Wobben Status new => assigned
2019-04-25 09:36 Marco Wobben Assigned To => Marco Wobben
2019-04-25 09:38 Marco Wobben Summary Denodo TO_TIME syntax error => Denodo Load script
2019-04-25 09:38 Marco Wobben Description Updated
2019-04-25 09:38 Marco Wobben Steps to Reproduce Updated
2019-04-25 10:17 Marco Wobben Status assigned => resolved
2019-04-25 10:17 Marco Wobben Resolution open => fixed
2019-04-25 10:17 Marco Wobben Fixed in Version => 9.5.3
2019-04-25 10:17 Marco Wobben Note Added: 0001425
2022-01-10 20:40 Marco Wobben Note Added: 0003790
2022-01-10 20:40 Marco Wobben Status resolved => closed