Skip to content

MSSQL Geometry Point no longer working after 0.2.25 #6189

@Steffion

Description

@Steffion

Issue type:

[ ] question
[x] bug report
[ ] feature request
[ ] documentation issue

Database system/driver:

[ ] cordova
[ ] mongodb
[x] mssql
[ ] mysql / mariadb
[ ] oracle
[ ] postgres
[ ] cockroachdb
[ ] sqlite
[ ] sqljs
[ ] react-native
[ ] expo

TypeORM version:

[x] latest
[ ] @next
[x] 0.2.25 (or put your version here)

Steps to reproduce or a small repository showing the problem:

As the title says, the POINT entry in a MSSQL database with the Geometry column type is no longer working as of 0.2.25.

See logging between version as result:

0.2.25
INSERT INTO "barrack"("code", "location", "name") OUTPUT INSERTED."id" INTO @OutputTable VALUES (@0, geography::STGeomFromText(@1, 0), @2);

0.2.24
INSERT INTO "barrack"("code", "location", "name") OUTPUT INSERTED."id" INTO @OutputTable VALUES (@0, @1, @2);

Please notice the weirdly formatted SQL Query with parameters.
A fix would be great! Thanks for your support in advance.

Metadata

Metadata

Assignees

No one assigned

    Labels

    bugdriver: mssqlregressionworked in previous version and doesn't work in current

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions