Icon View Incident Report

Serious Serious
Reported By: Juergen Sawatzki
Reported On: 7/22/2008
For: Version 2.01 Build 1
# 2701 EXTRACT Function Not Working for TIME Values

I have the following table with a default value. If I run an insert command nothing happens. It is not, as I expect the number of minutes.

EXECUTE IMMEDIATE 'CREATE TABLE "test"
(
"test" VARCHAR(20) COLLATE "ANSI_CI" 
DEFAULT cast(extract(minute from CURRENT_TIME(UTC)) as varchar(2))

)
VERSION 1
UNENCRYPTED
INDEX PAGE SIZE 4096
BLOB BLOCK SIZE 512
MAX ROW BUFFER SIZE 32768
MAX INDEX BUFFER SIZE 65536
MAX BLOB BUFFER SIZE 32768';



Resolution Resolution
Fixed Problem on 7/23/2008 in version 2.01 build 2


Products Affected Products Affected
ElevateDB Additional Software and Utilities
ElevateDB DAC Client-Server
ElevateDB DAC Client-Server with Source
ElevateDB DAC Standard
ElevateDB DAC Standard with Source
ElevateDB DAC Trial
ElevateDB VCL Client-Server
ElevateDB VCL Client-Server with Source
ElevateDB VCL Standard
ElevateDB VCL Standard with Source
ElevateDB VCL Trial

Image