String default value not retrieved when using views

[budiljak]

String default value not retrieved when using views

[aidanharan]

Hi @budiljak, this issue has been fixed by #1126 and is in release v7.0.5.0

[budiljak]

Thanks for your efforts! :-)

[budiljak]

Hi @aidanharan,

unfortunately it seems like there's new bugs when retrieving the default values. If the default for a datetime column is added by a constraint statement the default is falsely retrieved as "1970-1-1 00:00:00".

The error occurs if the NULL-Default is added like this:

ALTER TABLE [dbo].[XXX] ADD CONSTRAINT [DEFULT_FOR_TEST] DEFAULT (NULL) FOR [test];

And: I have one string column without any default for which the default is retrieved as "0".

:-(

[aidanharan]

Hi @budiljak, would you be able to open a new issue about the date issue and include a script to reproduce it? I had a look and wasn't able to recreate it.