Project

General

Profile

Bug #2602

host scoped_search error by compute_resource or domain when using postgresql

Added by Joseph Magen about 6 years ago. Updated about 6 years ago.

Status:
Closed
Priority:
Normal
Assignee:
Category:
Database
Target version:
Difficulty:
Triaged:
No
Bugzilla link:
Pull request:
Team Backlog:
Fixed in Releases:
Found in Releases:

Associated revisions

Revision 93ce3a18 (diff)
Added by Joseph Magen about 6 years ago

fixes #2602 - scoped_search error when using postgresql

Revision 9196926e (diff)
Added by Joseph Magen about 6 years ago

fixes #2602 - scoped_search error when using postgresql
(cherry picked from commit 93ce3a18eea3bd04b09dc7b55a5c513f973736f5)

History

#1 Updated by Joseph Magen about 6 years ago

Domain Load (0.3ms) SELECT DISTINCT "domains".name FROM "domains" ORDER BY LOWER LIMIT 20
PG::Error: ERROR: for SELECT DISTINCT, ORDER BY expressions must appear in select list
LINE 1: ... DISTINCT "domains".name FROM "domains" ORDER BY LOWER(doma...

#2 Updated by Joseph Magen about 6 years ago

  • Status changed from Assigned to Ready For Testing

#3 Updated by Dominic Cleal about 6 years ago

  • Category set to Database

#4 Updated by Joseph Magen about 6 years ago

  • Status changed from Ready For Testing to Closed
  • % Done changed from 0 to 100

Also available in: Atom PDF