Skip to content

[JDBC-V2] Spatial data returned as double[] #2577

@chernser

Description

@chernser

Description

Spatial data like Point should be returned in the format recognizable as geometry data. This works on V1 JDBC but newer JDBC version returns Point as Double[].

Example query:

select 
	cast(arrayJoin([(4.837388, 52.38795),
			(4.951513, 52.354582),
			(4.961987, 52.371763),
			(4.870017, 52.334932),
			(4.89813, 52.357238),
			(4.852437, 52.370315),
			(4.901712, 52.369567),
			(4.874112, 52.339823),
			(4.856942, 52.339122),
			(4.870253, 52.360353)]
			)
		as Point) as Point

Relates: dbeaver/dbeaver#39111

Metadata

Metadata

Assignees

No one assigned

    Labels

    Type

    No type

    Projects

    No projects

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions