Skip to content

Parser error when using VECTOR type with a second param #161

@daschall

Description

@daschall

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.

Metadata

Metadata

Assignees

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions