-
Notifications
You must be signed in to change notification settings - Fork 35
Open
Labels
Description
Repro:
SELECT CAST ($492050157978986.2129 AS MONEY) AS [p_0_0]
FROM ([dbo].[table_6] AS [alias_0_0] CROSS JOIN [dbo].[table_4] AS [alias_0_1])
WHERE (NOT (SYSDATETIME() IN (SELECT @Var39 AS [p_1_0]
FROM ([dbo].[table_0] AS [alias_1_0] CROSS JOIN ([dbo].[table_6] AS [alias_1_1]
LEFT OUTER JOIN
([dbo].[table_6] AS [alias_1_2]
INNER JOIN
([dbo].[table_5] AS [alias_1_3] CROSS APPLY ([dbo].[table_6] AS [alias_1_4]
RIGHT OUTER JOIN
[dbo].[table_3] AS [alias_1_5]
ON [alias_1_4].[c_19] = CAST ('[-6.464173E+08,1.040823E+07,1.699169E+08]' AS VECTOR (3, Float32))))
ON [alias_1_2].[c_14] = [alias_1_3].[c_13])
ON [alias_1_1].[c_1] = CONVERT (VECTOR (77), '[-7.230808E+08,4.075427E+08,-1.216283E+08,-9.161707E+07,3.298855E+08,2.264913E+08,-9.4111E+08,8.265246E+08,1.342222E+08,-6.471138E+08,-6.940996E+08,-5.930632E+08,-1.853538E+09,-1.571979E+09,1.63078E+08,8.592864E+07,2.572119E+07,9.529895E+08,2.900251E+07,-5.767558E+08,6.301898E+08,9.36951E+08,-3.829958E+08,2.488992E+08,7.392102E+08,5.837073E+08,1.452421E+09,-4.219692E+08,-5.819439E+08,8.14561E+08,2.851766E+07,-4.578374E+08,-1.260522E+09,6.394105E+07,1.237774E+09,-8.365898E+08,-4.144185E+08,2.068745E+08,-1.549236E+09,3.180168E+07,1.029454E+09,-1.428088E+09,-1.450559E+08,-1.632218E+09,1.001876E+09,1.158953E+09,-8.605122E+08,-1.150775E+08,1.150118E+09,-2.22875E+08,-1.127701E+09,-8.509304E+08,-7.406524E+07,1.460463E+08,1.007424E+09,1.413609E+08,-2.927279E+08,-4.817469E+08,-1.329902E+08,-3.161025E+08,6.014888E+08,-2.194472E+08,2.076541E+07,-2.938853E+08,2.81831E+08,1.054828E+08,-8.81412E+08,-8.568048E+08,1.373432E+09,7.546982E+07,-7.286022E+07,-2.322962E+08,2.755762E+08,-8.762522E+08,6.65824E+07,5.134078E+08,-3.239848E+07]'))))
OR (CONVERT (BIGINT, CONVERT (INT, 8)) >= @Var57)
OR (@Var40 <= @Var9)))If you replace VECTOR(3, Float32) with just VECTOR(3), it works.