src/dbfs/core.c
changeset 30 d8fabd347a8e
parent 29 5de62ca9a5aa
child 31 7804cd7b5cd5
--- a/src/dbfs/core.c	Thu Oct 16 22:04:53 2008 +0300
+++ b/src/dbfs/core.c	Thu Oct 16 22:56:29 2008 +0300
@@ -57,10 +57,10 @@
     // query and params
     const char *sql = 
         "SELECT"
-        " inodes.ino, inodes.type, inodes.mode, inodes.size, count(*)"
+        " inodes.ino, inodes.type, inodes.mode, dbfs_lo_size(data), count(*)"
         " FROM file_tree INNER JOIN inodes ON (file_tree.inode = inodes.ino)"
         " WHERE file_tree.parent = $1::int4 AND file_tree.name = $2::varchar"
-        " GROUP BY inodes.ino, inodes.type, inodes.mode, inodes.size";
+        " GROUP BY inodes.ino, inodes.type, inodes.mode, data";
     
     static struct evsql_query_params params = EVSQL_PARAMS(EVSQL_FMT_BINARY) {
         EVSQL_PARAM ( UINT32 ),
@@ -130,10 +130,10 @@
 
     const char *sql =
         "SELECT"
-        " inodes.type, inodes.mode, inodes.size, count(*)"
+        " inodes.type, inodes.mode, dbfs_lo_size(data), count(*)"
         " FROM inodes"
         " WHERE inodes.ino = $1::int4"
-        " GROUP BY inodes.type, inodes.mode, inodes.size";
+        " GROUP BY inodes.type, inodes.mode, data";
 
     static struct evsql_query_params params = EVSQL_PARAMS(EVSQL_FMT_BINARY) {
         EVSQL_PARAM ( UINT32 ),