[DM-38954] Query generation logic bug in spatial query with HTM constraint - Jira

XML

Word

Printable

Details

Type: Bug
Status: Done
Resolution: Done
Fix Version/s: None
Component/s: daf_butler
Labels:
- gen3-middleware

Story Points:
1
Epic Link:
s23b-drp-emergent
Team:
Data Release Production
Urgent?:
No

Description

While poking around to try to come up with some test data for ~~DM-38592~~, I attempted this query:

butler.registry.queryDataIds(

    ["tract", "patch", "visit", "detector", "htm7"],

    skymap="hsc_rings_v1",

    instrument="HSC",

    where="htm7 IN (htm_ids)",

    bind={"htm_ids": [231828, 231829]},

).expanded()

and got this:

ProgrammingError: (psycopg2.errors.DuplicateAlias) table name "patch_skypix_overlap" specified more than once

Attachments

Activity

Ascending order - Click to sort in descending order

Hide

Permalink

Jim Bosch added a comment - 02/May/23 3:27 AM

Andy Salnikov, here's one more small review request, for SQL-generation bugfix in the query system:

https://github.com/lsst/daf_butler/pull/834

It's basically a guard against joining in the same subquery multiple times.

Show

Jim Bosch added a comment - 02/May/23 3:27 AM Andy Salnikov , here's one more small review request, for SQL-generation bugfix in the query system: https://github.com/lsst/daf_butler/pull/834 It's basically a guard against joining in the same subquery multiple times.

Hide

Permalink

Andy Salnikov added a comment - 02/May/23 4:54 PM

Looks good.

Show

Andy Salnikov added a comment - 02/May/23 4:54 PM Looks good.

People

Assignee:: Jim Bosch

Reporter:: Jim Bosch

Reviewers:: Andy Salnikov

Watchers:: Andy Salnikov, Jim Bosch

Votes:: 0 Vote for this issue

Watchers:: 2 Start watching this issue

Dates

Created:: 29/Apr/23 5:15 PM

Updated:: 30/Jun/23 7:29 PM

Resolved:: 03/May/23 1:44 AM

Jenkins

No builds found.

Data Management