Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Revisions: Issue #33964 All Revisions ] 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
Powered by Mantis Bugtracker