Changeset 2483

Timestamp:

Aug 3, 2006, 8:35:49 AM (17 years ago)

Author:

Nicklas Nordborg

Message:

Fixes #309: count spots in bioassayset

File:

• trunk/src/core/net/sf/basedb/core/BioAssaySet.java (modified) (2 diffs)

trunk/src/core/net/sf/basedb/core/BioAssaySet.java

@@ -990 +990 @@
     query.join(
       new DynamicJoin(
-        getVirtualDb(), JoinType.INNER, VirtualTable.POSITION,
+        getVirtualDb(), JoinType.LEFT, VirtualTable.POSITION,
         VirtualColumn.CUBE, VirtualColumn.POSITION
       )
@@ -1009 +1009 @@
       SELECT COUNT(*) AS spotCount, COUNT(DISTINCT pos.reporter_id) AS reporterCount
       FROM Dynamic#PerSpot spt
-      JOIN Dynamic#PerPosition pos spt.cube = pos.cube AND spt.position = pos.position
+      LEFT JOIN Dynamic#PerPosition pos spt.cube = pos.cube AND spt.position = pos.position
       WHERE spt.cube = ? AND spt.layer = ?
     */