View Issue Details

IDProjectCategoryView StatusLast Update
0002128CaseTalk ModelerGeneration (SQL, XML, etc)public2022-01-10 20:40
ReporterBCP Software Assigned ToBCP Software  
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

BCP Software

BCP Software

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.
BCP Software

BCP Software

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