]> git.sur5r.net Git - bacula/bacula/commit
projects / bacula / bacula / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: a1be568) | patch
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)
commit67fb40049e5d11e1c2f1375d2b32fcf37af3583e
tree9c3400e88cef5cf3a8f9328e465d2448c1db05batree | snapshot
parenta1be568d254e022a85a40c8f0bf65ec9c000f497commit | diff
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 diff | blob | history
Cloned from http://git.bacula.org/bacula