Kbase P10279: Table creation fails when timestamp field has default value
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
27/01/2003 |
|
Status: Unverified
FACT(s) (Environment):
Progress 9.1D
SYMPTOM(s):
Using SQL92
Loading the output of the SQLSCHEMA utility into SQL Explorer
The SQL contains timestamp fields with default values
The SQL fails to run with a syntax error regarding the default value for the timestamp field
CAUSE:
Bug# 20020903-016
CAUSE:
The SQLSCHEMA utility is not quoting default values for the time, date, and timestamp datatypes
FIX:
Upgrade to 9.1D Service Pack 2 (9.1D02)