add syncinfo test for symlinks

diff --git a/schema/syncinfo.sql b/schema/syncinfo.sql
index cbdffce45ba2018b8e06ca70162bb806a5d717d0..1a76c263c9716a7cd92cde8c95d7cf5acebce9cd 100644 (file)
--- a/schema/syncinfo.sql
+++ b/schema/syncinfo.sql
@@ -78,7 +78,14 @@ PC.status not in ('installed','removing','updating')
 union
 select
 case
 union
 select
 case

-when PFI.filetype is PFC.filetype
+when PFI.filetype is not 'l'
+       and PFI.filetype is PFC.filetype
+       and PFI.mode is PFC.mode and PFI.username is PFC.username
+               and PFI.groupname is PFC.groupname and PFI.hash is PFC.hash
+       then 'noop'
+when PFI.filetype is 'l'
+       and PFI.target is PFC.target
+       and PFI.filetype is PFC.filetype

        and PFI.mode is PFC.mode and PFI.username is PFC.username
                and PFI.groupname is PFC.groupname and PFI.hash is PFC.hash
        then 'noop'
        and PFI.mode is PFC.mode and PFI.username is PFC.username
                and PFI.groupname is PFC.groupname and PFI.hash is PFC.hash
        then 'noop'