M
marian.edu
Guest
Thomas, it's amazing how we can twist our mind to explain everything regardless how odd it is... if you try hard enough any bug can be packed as a feature 
A null is a valid value, a null equal null (damn, even javascript say so) hence having two records with the same value should not be possible in a unique index but this will probably never change to keep the backward compatibility in place. There might be some counting on this 'feature', aka they just screw their data without knowing but hey as long as you don't know it, it won't hurt you Marian Edu Acorn IT www.acorn-it.com www.akera.io +40 740 036 212
Continue reading...
A null is a valid value, a null equal null (damn, even javascript say so) hence having two records with the same value should not be possible in a unique index but this will probably never change to keep the backward compatibility in place. There might be some counting on this 'feature', aka they just screw their data without knowing but hey as long as you don't know it, it won't hurt you Marian Edu Acorn IT www.acorn-it.com www.akera.io +40 740 036 212Continue reading...