Opened 16 years ago
Closed 16 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 16 years ago by
Milestone: | BASE 2.4 → BASE 2.3.1 |
---|
comment:2 Changed 16 years ago by
Status: | new → assigned |
---|
comment:3 Changed 16 years ago by
Resolution: | → fixed |
---|---|
Status: | assigned → closed |
Note: See
TracTickets for help on using
tickets.
(In [3446]) Fixes #581