SQL Server: DB migration script for 10.7.0 fails
Description
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
Incorrect syntax near 'latest'.
SQL
update [_version_psys_asset] [latest]
left join [_version_psys_asset] [older] on [older].id = latest.id and [older]._version_number > latest._version_number and ( [older]._version_is_draft is null or [older]._version_is_draft = '0' )
set [latest]._version_is_latest = '1'
where [older].id is null
and ( [latest]._version_is_draft is null or [latest]._version_is_draft = '0' )
DatabaseName Microsoft SQL Server
DatabaseVersion 13.00.4001
DriverName Microsoft JDBC Driver 4.0 for SQL Server
DriverVersion 4.0.2206.100
Datasource preside
Stacktrace The Error Occurred in
C:\Users\ChrisDawes\.CommandBox\server\61990A7F266508801D2DCF1EAB331A7A-PresideNew\lucee-4.5.3.020\components\org\lucee\cfml\Base.cfc: line 163
161: !---><cfqueryparam attributecollection="#item#"><!---
162: !---></cfif></cfloop>
163: </cfquery>
164:
165: <cfset result.setResult(q)>