Project:
View Revisions: Issue #33964 | [ Back to Issue ] | ||
Summary | 0033964: Default value is not dropped when column definition changes | ||
Revision | 2016-09-13 12:37 by gorkaion | ||
Steps To Reproduce | 1 Create a date column not null with sysdate as default value and on create default value. 2 Check that it is properly created in the database. 3 Modify the xml definition to set is as required false and remove the default and onCreateDefault values. 4 Update the database and check that the required and onCreateDefault values are properly updated but the default value is still "now()". 5 Modify the xml definition and set the default value to null. 6 Update the database again and check that the default value is still "now()" |
||
Revision | 2016-09-13 12:35 by gorkaion | ||
Steps To Reproduce | 1 Create a date column not null with sysdate as default value and on create default value. 2 Check that it is properly created in the database. 3 Modify the xml definition to set is as required false and remove the onCreate and onCreateDefault values. 4 Update the database and check that the required and onCreateDefault values are properly updated but the default value is still "now()". 5 Modify the xml definition and set the default value to null. 6 Update the database again and check that the default value is still "now()" |
Copyright © 2000 - 2009 MantisBT Group |