Fails comparing a partition function with a null boundary

breno

I'm seeing an error where SQL Compare can't compare a database with a partition function with a null boundary.

It's pretty easy to reliably reproduce:

1)run this against a database
create partition function test_pf (date) as range LEFT for values(cast(NULL as date))

2) try to compare with another database

You get the error:

Value cannot be null.
Parameter name: value

Anu D

Hi Breno,

Thanks for your post!

I have logged a support ticket and will email you shortly!