Create table GUI, for an Identity column, when the "Identity Cache" attribute value is set to "no", our create table script incorrectly generate the attribute as "CACHE NO". Instead, it should be "NO CACHE".
Fix:
-- If user enters a non-numeric number or enters a number < 2, we will generate the attribute as "NO CACHE"
Issue has been fixed as so...
If cache is set to a non numeric value, "NO CACHE" is generated
if cache is set to a numeric value < 2, "NO CACHE" is generated
if cache is set to a numeric value >= 2, "CACHE <value>" is generated
if cache is set to null or blank, "" is generated <<-- this will use default value of CACHE 20 by server
Revision: 30905
Issue #8182 |
Closed |
Fixed |
Resolved |
Completion |
No due date |
No fixed build |
No time estimate |
Issue has been fixed as so...
If cache is set to a non numeric value, "NO CACHE" is generated
if cache is set to a numeric value < 2, "NO CACHE" is generated
if cache is set to a numeric value >= 2, "CACHE <value>" is generated
if cache is set to null or blank, "" is generated <<-- this will use default value of CACHE 20 by server
Revision: 30905