Graphical Query Builder bug

Поиск
Список
Период
Сортировка
От Bartosz Dmytrak
Тема Graphical Query Builder bug
Дата
Msg-id CAD8_UcZQFyejv8uQc=LHGcERo2X26jd8xOqS3tNVDeK+EBV93Q@mail.gmail.com
обсуждение исходный текст
Ответы Re: Graphical Query Builder bug
Список pgadmin-support
Дерево обсуждения
Hi All
Today I decided to build a query using Query Builder functionality of pgAdmin, so I switched to Graphical Query Builder tab and did some clicking  Few seconds later I received something like this:

SELECT 
  jpga_servergroups.groupid, 
  jpga_servergroups.groupname, 
  jpga_servergroups.caption
FROM 
  "MyShema".jpga_servergroups
WHERE 
  jpga_servergroups.rolid = 1
ORDER BY
  jpga_servergroups.groupname ASC;

What was fine. Then I noticed there is a long table name before each column, so I decided to add alias for a table. I switched again to GQB, I added alias and problem appeared. SQL generated was like this one:

SELECT 
  s.groupid, 
  s.groupname, 
  s.caption
FROM 
  "MyShema".jpga_servergroups s
WHERE 
  jpga_servergroups.rolid = 1
ORDER BY
  s.groupname ASC;

WHERE condition wasn't updated, so it is not a correct statement.

env:
pgAdmin III 1.16.0
Mandriva Linux 64 bit


regards,
Bartek

В списке pgadmin-support по дате отправления: