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.

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

Improve intertable update queries #762

Closed
janrich opened this Issue May 19, 2014 · 1 comment

Comments

Projects
None yet
2 participants
@janrich

janrich commented May 19, 2014

The following update query compiles but it does not pick up the table names:

SQLUpdateClause query = update(address).set(
            address.regionId, new SQLSubQuery().from(region)
                    .where(address.geom.within(region.geom))
                    .unique(region.id));

the query gives:

update public.address
set region_id = (select id
from public.region region
where ST_Within(geom, geom))

It should be something like:

update address
set region_id = (select id
from region
where ST_Within(address.geom, geom))

@timowest timowest added this to the 3.3.4 milestone May 19, 2014

@timowest timowest added the fixed label May 19, 2014

@timowest

This comment has been minimized.

Show comment
Hide comment
@timowest

timowest May 20, 2014

Member

Released in 3.3.4

Member

timowest commented May 20, 2014

Released in 3.3.4

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