Changeset 33121

Timestamp:

Jan 20, 2012, 11:44:06 AM (14 years ago)

Author:

Serge CHASTEL

Message:

Removed blob objects selected from mysql statements

File:

• trunk/Nebulous-Server/bin/neb-admin (modified) (2 diffs)

trunk/Nebulous-Server/bin/neb-admin

@@ -313 +313 @@
     SELECT S.*,vol_id FROM (
       -- Select objects that are in our so_id range, with two copies (and two requested copies)
-      SELECT MAX(ins_id) AS MAXins_id,MIN(ins_id) AS MINins_id,so_id,ext_id,value AS user_copies FROM
+      SELECT MAX(ins_id) AS MAXins_id,MIN(ins_id) AS MINins_id,so_id,ext_id FROM
        storage_object JOIN storage_object_xattr USING(so_id) RIGHT JOIN instance USING(so_id)
        WHERE name = 'user.copies' AND value >= 2
@@ -629 +629 @@
   SELECT S.so_id,ext_id,ins_id,uri,substr(uri,-10,5) AS class_id,vol_id,name AS vol_name,host AS vol_host,MAXins_id FROM (
     select * FROM (
-      select MAX(ins_id) AS MAXins_id, MIN(ins_id) AS MINins_id, so_id,ext_id,value AS user_copies FROM storage_object
+      select MAX(ins_id) AS MAXins_id, MIN(ins_id) AS MINins_id, so_id,ext_id FROM storage_object
         JOIN storage_object_xattr USING(so_id)
         RIGHT JOIN instance USING(so_id)