Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Repeated column names cause visualization issues in DB Manager #38976

Closed
pcav opened this issue Sep 23, 2020 · 4 comments · Fixed by #38981
Closed

Repeated column names cause visualization issues in DB Manager #38976

pcav opened this issue Sep 23, 2020 · 4 comments · Fixed by #38981
Assignees
@elpaso
Labels
Bug Either a bug report, or a bug fix. Let's hope for the latter! DB Manager Relating to the DB Manager core plugin Regression Something which used to work, but doesn't anymore

Comments

@pcav
Copy link
Member

pcav commented Sep 23, 2020

In QGIS 3.10 the following query returns correct results:

SELECT a.id, b.id, ST_Distance(a.geom, b.geom)
  FROM punti a, fiumi b

whereas in 3.14 distance is not displayed.

SELECT ST_Distance(a.geom, b.geom)
  FROM punti a, fiumi b

returns correct results in both.
@pcav pcav added DB Manager Relating to the DB Manager core plugin Bug Either a bug report, or a bug fix. Let's hope for the latter! Regression Something which used to work, but doesn't anymore labels Sep 23, 2020
@elpaso elpaso self-assigned this Sep 23, 2020
@elpaso
Copy link
Contributor

elpaso commented Sep 23, 2020

Can you specify what issues are we looking at?

@elpaso
Copy link
Contributor

elpaso commented Sep 23, 2020

is it a missing column or an empty cell?

@elpaso
Copy link
Contributor

elpaso commented Sep 23, 2020

Nevermind, I can see the issue. This is actually hard to fix with the new API I'll see what I can do.

elpaso added a commit to elpaso/QGIS that referenced this issue Sep 23, 2020
@elpaso
PG: accept duplicated fields for query layers
dd64c6d 
Fixes qgis#38976
@elpaso elpaso mentioned this issue Sep 23, 2020
Merged
@pcav
Copy link
Member Author

pcav commented Sep 23, 2020

Sorry I was too fast. Thanks for the fix! Can this be backported, or it will go in 3.16?
Cheers.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@elpaso elpaso

Labels
Bug Either a bug report, or a bug fix. Let's hope for the latter! DB Manager Relating to the DB Manager core plugin Regression Something which used to work, but doesn't anymore
Projects
None yet
Milestone
No milestone
Development

Successfully merging a pull request may close this issue.

Bugfix gh38975 and other db manager issues elpaso/QGIS
2 participants
@elpaso @pcav