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