]> git.sur5r.net Git - bacula/bacula/commit
Not all databases allow you to refer to field in an "AS field" clause.
authorDan Langille <dan@langille.org>
Sat, 17 Jul 2004 15:49:39 +0000 (15:49 +0000)
committerDan Langille <dan@langille.org>
Sat, 17 Jul 2004 15:49:39 +0000 (15:49 +0000)
commitca9ea37e41de8befed7bf8a1bbc5637ae7e53de0
tree6a5a81ea2bb00d8129bf73292dc72c939c1e80d5
parent83f5a579a76610313ac77e8875edee8f55c33daa
Not all databases allow you to refer to field in an "AS field" clause.
So use count(*) instead of the field name in selects.

Use DISTINCT intead of GROUP BY, because that's what we really want
because this won't work on non-MySQL.

git-svn-id: https://bacula.svn.sourceforge.net/svnroot/bacula/trunk@1478 91ce42f0-d328-0410-95d8-f526ca767f89
bacula/src/tools/dbcheck.c