MSSQL No column name was specified for column 1 of 'original_statement'

Description

I discovered problems with preside 10.12.3 and MSSQL databases.

Main problem:
generated SQL crashes on MSSQL

is_catch_all = true vs = 1
column name required for 1

correct syntax might be:

My scribble solution is to change two lines in the PresideObjectService and DataExportService.
orig:
selectFields = [ "1" ]
changed:
selectFields = [ "1 as 'any' " ]

Environment

local development
Windows 10
MSSQL Server Express 2016
Lucee@5.3.3+62
Preside 10.12.3

Assignee

Unassigned

Reporter

Philipp Schult-Heidkamp

Labels

None

Accepted

Yes

Fix versions

Affects versions

Priority

Medium
Configure