From: mar <mar>
Date: Thu, 11 Mar 1993 18:17:50 +0000 (+0000)
Subject: incorrect query to check if nfsphys was in use
X-Git-Tag: release77~200
X-Git-Url: http://andersk.mit.edu/gitweb/moira.git/commitdiff_plain/7934a9b58420025e0cde63d97015689917574308

incorrect query to check if nfsphys was in use
---

diff --git a/server/qsupport.dc b/server/qsupport.dc
index cf85811f..e7a4e641 100644
--- a/server/qsupport.dc
+++ b/server/qsupport.dc
@@ -987,7 +987,7 @@ setup_dnfp(q, argv, cl)
 
     id = *(int *)argv[0];
     dir = argv[1];
-    EXEC SQL REPEATED SELECT label INTO :cnt FROM filesys fs, nfsphys np
+    EXEC SQL REPEATED SELECT fs.tid INTO :cnt FROM filesys fs, nfsphys np
       WHERE fs.mach_id = :id AND fs.phys_id = np.nfsphys_id
 	AND np.mach_id = :id AND np.dir = :dir;
     if (cnt > 0)