Geometry datatype - Invalid handling of points with X1=X2, Y1=Y2 and Z1<>Z2 RRS feed

  • Question

  • Hello,

    SQLServer 2008 rejects a statement like

    INSERT INTO TEST_TAB (GEOMETRY) VALUES (geometry::parse('linestring(0 0 0, 0 0 10)'));

    by giving the error message:

    The LineString input is not valid because it does not have enough distinct points. A LineString must have at least two distinct points.

    However, as you can see, there *are* two distinct points 0 0 0 and 0 0 10, but they differ only in Z. Even if Z-handling is still a rudimentary feature of SQLServer 2008, this is a clear bug, in my eyes.

    Kind regards,


    Wednesday, December 22, 2010 12:35 PM


All replies