add_library: Reject shared libraries on platforms that do not support them

Asit Dhalrequested to merge
asit-dhal/cmake:issue-25759 into master

Add policy CMP0164 to provide compatibility.

Fixes: #25759 (closed)
Topic-rename: add_library-no-static-fallback

Edited by Brad King

Merge request reports