【遇到的问题:问题现象及影响】相同的SQL在v4.0.16上执行正常,在v5.1.2上报语法错误
SELECT * from ((SELECT vin,veh_series_no,veh_variable_model_no,current_version,vehicle_purpose,vehicle_status,current_vehicle_version_status FROM xx_version WHERE veh_series_no=‘xx’ and current_version in (‘4.2.1-1.7.114’) and is_delete = 0 and current_vehicle_version_status in (“1”)) as a JOIN (SELECT row_number() over (PARTITION by vin order by event_time desc) as number,vin,event_type,target_version,event_time,error_type,error_reason,message_id FROM xx_upgrade_status WHERE current_version in (‘4.2.1-1.7.114’) and is_delete = 0 ) as b ON a.vin = b.vin and b.number = 1 );
SELECT
*
FROM
(SELECT
vin,
veh_series_no,
veh_variable_model_no,
current_version,
vehicle_purpose,
vehicle_status,
current_vehicle_version_status
FROM
xx_version
WHERE veh_series_no = ‘xx’
AND current_version IN ('4 .2.1-1.7.114 ')
AND is_delete = 0
AND current_vehicle_version_status IN (‘1’)) AS a
JOIN
(SELECT
row_number () over (
PARTITION BY vin
ORDER BY event_time DESC
) AS number,
vin,
event_type,
target_version,
event_time,
error_type,
error_reason,
message_id
FROM
xx_upgrade_status
WHERE current_version IN (‘4 .2.1-1.7.114’)
AND is_delete = 0) AS b
ON a.vin = b.vin
AND b.number = 1
;
这样查试试还报错吗?