Menu

#2196 (ok 2.9) sql error in generated order by queries

Latest_Git
fixed
1
2013-06-11
2006-07-18
No

when executing this query:

SELECT `customer_status`. *,
COUNT( `customer`.`id` ) AS `customer`
FROM `customer_status` AS `customer_status`
LEFT JOIN `kunden` AS `customer`
ON `customer_status`.`id` = `customer`.`status_id`
GROUP BY `customer_status`.`id`

an invalid SQL is generated by phpMyAdmin:

SELECT `customer_status`. * , COUNT( `customer`.`id` )
AS `customer`
FROM `customer_status` AS `customer_status`
LEFT JOIN `kunden` AS `customer` ON
`customer_status`.`id` = `customer`.`status_id`
GROUP BY `customer_status`.`id`
ORDER BY.`customer` ASC
LIMIT 0 , 30

Discussion

  • Sebastian Mendel

    • priority: 5 --> 1
    • assigned_to: nobody --> cybot_tm
    • summary: syntax error when clicking on collumn header to order --> (ok 2.9) sql error in generated order by queries
    • status: open --> open-fixed
     
  • Marc Delisle

    Marc Delisle - 2006-09-20
    • status: open-fixed --> closed-fixed
     
  • Michal Čihař

    Michal Čihař - 2013-06-11
    • Status: closed-fixed --> fixed
     
MongoDB Logo MongoDB