Opened 14 years ago

Closed 14 years ago

#581 closed defect (fixed)

DataCube.countSpotMappings should use SelectedExpression for it's order by clause

Reported by: Nicklas Nordborg Owned by: Nicklas Nordborg
Priority: trivial Milestone: BASE 2.3.1
Component: core Version:
Keywords: Cc:

Description

The current code generates this:

SELECT COUNT(*) AS `mapCount` FROM `base2_dynamic`.`D320RawParents` `rawmap`
WHERE `rawmap`.`cube` = 3 GROUP BY `rawmap`.`column`, `rawmap`.`position`
ORDER BY COUNT(*) DESC

MySQL 4 is having trouble with the COUNT(*) in the order by. It should be replaced with

ORDER BY `mapCount`

instead. The best way is to create a SelectedExpression? object from the count variable that is currently put into the order by clasue.

For more info about this problem see: http://sourceforge.net/mailarchive/message.php?msg_id=5.0.2.1.2.20070423141430.00c1cfe8%40pop.rennes.inra.fr

Change History (3)

comment:1 Changed 14 years ago by Nicklas Nordborg

Milestone: BASE 2.4BASE 2.3.1

comment:2 Changed 14 years ago by Nicklas Nordborg

Status: newassigned

comment:3 Changed 14 years ago by Nicklas Nordborg

Resolution: fixed
Status: assignedclosed

(In [3446]) Fixes #581

Note: See TracTickets for help on using tickets.