Can you use an alias, eg:
Select my_level as "LEVEL", my_date as "DATE" from table
-Original Message-
From: d'Orio, Pietro [mailto:pietro.do...@siag.it]
Sent: Tuesday, 4 August 2020 7:40 PM
To: rdmaili...@duif.net; andrea.a...@geo-solutions.it; Rahkonen Jukka (MML)
Cc:
GeoTools / GeoServer PMC meeting - 2020-08-04Attending
Torben Barsballe
Andrea Aime
Kevin Smith
Jukka Rahkonen
Actions from last meeting:
-
N/A
Agenda
-
Backporting JTS upgrade
-
GeoServer 2.16.5 release train manager
-
GeoPackage status update
-
Chit
On Tue, Aug 4, 2020 at 2:29 PM Ian Turton wrote:
> That is odd, especially as OraclFilterToSQL calls setSqlNameEscape("\"")
> in it's constructor. Since we currently have working Oracle CI tests I may
> have a quick go at an update,
>
Sure. If you want to run tests locally the same docker setup
That is odd, especially as OraclFilterToSQL calls setSqlNameEscape("\"") in
it's constructor. Since we currently have working Oracle CI tests I may
have a quick go at an update,
Note that encodeColumnName does include the following:
// need to quote column names with spaces in
if
Hi Ian,
the thing is, that would be the default behavior, and it has been
explicitly overridden so it does not happen.
Goes way back, it's not covered by the git history, one would have to check
in the old SVN history to
see if there is a commit about it.
Had a very quick look, 2.6.0 is the first
It should be relatively easy to modify encodeColumnName in OracleDialect to
surround reserved words with " - and possibly make use of the sqlNameEscape
value and escapeName function in FilterToSql too
Ian
On Tue, 4 Aug 2020 at 12:15, d'Orio, Pietro wrote:
> The following keywords don't make
The following keywords don't make problem:
- ID, GEOMETRY, TYPE
The query on DB is like: SELECT GEOMETRY AS GEOMETRY FROM TABLE
The following makes problem:
- LEVEL, DATE
i have to rename the view fields, but i think is a mistake that some sensible
oracle keywords works and other not…
If I