Joomla! Issue Tracker | Joomla! CMS #6135 - PostgreSQL

Closed
24 Feb 2015
Medium
Build: staging
Easy Test
# 6135
Diff
alikon:patch-4

Success

Success The Travis CI build passed Details

User tests: Successful: Unsuccessful:

alikon
21 Feb 2015

Steps to reproduce the issue

In the administration side add a new article item
look on the left to the categories list

Expected result

the categories are ordered

Actual result

the categories are not ordered

System information

PostgreSQL 9.3.5
Joomla 3.4.0.rc

Additional comments

the old query

SELECT DISTINCT a.id AS value, a.title AS text, a.level, a.published

  FROM (
SELECT DISTINCT id,title,level,published,parent_id,extension,lft,rgt

  FROM d7jwf_categories

  WHERE (extension = 'com_content') 
  AND published IN (0,1)

  ORDER BY lft ASC) AS a

  LEFT JOIN `d7jwf_categories` AS b 
  ON a.lft > b.lft 
  AND a.rgt < b.rgt

the new one

SELECT DISTINCT a.id AS value, a.title AS text, a.level, a.published, a.lft

  FROM (
SELECT id,title,level,published,parent_id,extension,lft,rgt

  FROM d7jwf_categories

  WHERE (extension = 'com_content') 
  AND published IN (0,1)) AS a

  LEFT JOIN `d7jwf_categories` AS b 
  ON a.lft > b.lft 
  AND a.rgt < b.rgt

  ORDER BY a.lft ASC

6397c74 21 Feb 2015

PostgreSQL - categories are not ordered

alikon - open - 21 Feb 2015