[Geoserver-devel] [jira] (GEOS-6098) Creation of SQL-View Layer fails due to comment in the last line

Thu, 17 Oct 2013 01:18:07 -0700

Issue Type: Bug Bug
Affects Versions: 2.4.0
Assignee: Andrea Aime
Created: 17/Oct/13 3:15 AM
Description:

I'm trying to create a Layer from a costum SQL-Statement.

This fails due to a comment in the last line.

Example:

select
the_geom,
some_info,
id
from locations
--where id = 1

The Geoserver tries to determine the columns of the query by adding some SQL which makes it fail:

select * from (select
the_geom,
some_info,
id
from locations
--where id = 1) as "vtable" where 1 = 0

To fix this, you'll probably just need to add a newline to the query, before adding the ') as "vtable" where 1 = 0'
Environment: Windows 7 Professional x64 running Geoserver, Windows Server 2012 running MSSQL 2012
Project: GeoServer
Priority: Critical Critical
Reporter: Niki Hammerschmidt
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira 
------------------------------------------------------------------------------
October Webinars: Code for Performance
Free Intel webinars can help you accelerate application performance.
Explore tips for MPI, OpenMP, advanced profiling, and more. Get the most from 
the latest Intel processors and coprocessors. See abstracts and register >
http://pubads.g.doubleclick.net/gampad/clk?id=60135031&iu=/4140/ostg.clktrk
_______________________________________________
Geoserver-devel mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geoserver-devel

Reply via email to