Select query of pgr_dijkstra() 's cost column cause error #2950
Description
Problem
Select query of pgr_dijkstra() cause error.
To Reproduce
drop table if exists kari;
create table if not exists kari(
id integer,
source integer,
target integer,
geom geometry(LineString, 4326),
cost float,
reverse_cost float,
multiplier float default 1.0,
capacity float default 1.0,
reverse_capacity float default 1.0
);
insert into kari (id, geom, cost, reverse_cost, source, target) values
(1, 'linestring(0 0, 4 4)', 4.0, 4.0, 1, 2),
(2, 'linestring(4 4, 6 6)', 2.0, 2.0, 2, 3)
;
select *
from pgr_dijkstra('select id, source, target, cost * multiplier, reverse_cost, capacity, reverse_capacity from kari', 1, 3)
;
drop table if exists kari;
Column 'cost' not Found
HINT: select id, source, target, cost * multiplier, reverse_cost, capacity, reverse_capacity from kari
CONTEXT: SQL関数"pgr_dijkstra"の行番号 1
Expectation
cost * multiplier as cost not lead to error.
Sample Data
Platform/versions
SELECT version();
SELECT postgis_full_version();
SELECT pgr_version();
- PostgreSQL 17.5 on x86_64-windows, compiled by msvc-19.43.34808, 64-bit
- POSTGIS="3.5.3 3.5.3" [EXTENSION] PGSQL="170" GEOS="3.13.1-CAPI-1.19.2" PROJ="8.2.1 NETWORK_ENABLED=OFF URL_ENDPOINT= USER_WRITABLE_DIRECTORY=C:\WINDOWS\ServiceProfiles\NetworkService\AppData\Local/proj" (compiled against PROJ 8.2.1) LIBXML="2.12.5" LIBJSON="0.12" LIBPROTOBUF="1.2.1" WAGYU="0.5.0 (Internal)"
- 3.8.0
Sorry for not goot at English and sql. It may not be bug but my mistake.