What are the challenges you face when working across database platforms? Take the survey
Options

MI003 Unqualified column name

If I have a statement that contains a column with a geography point used in a calculation, I get a false MI003 warning.

This should be able to reproduce it:

SELECT (geography::Point(a.latitude, a.longitude, 4326).STDistance(b.geo) / 1609.34) AS miles
FROM (VALUES(43.7136263, -82.0375272)) AS a(latitude,longitude)
CROSS JOIN (SELECT geography::Point(42.7136263, -83.0375272, 4326) AS geo) AS b
ORDER BY miles;
Tagged:

Best Answer

  • Options
    Tianjiao_LiTianjiao_Li Posts: 684 Rose Gold 5
    Hi @JoshRoss

    Thanks for your patience with this issue.

    I'm pleased to let you know this bug has been fixed in the latest version (9.0.7.3692 - January 17th 2018).

    Can you please upgrade and test again?

    Thanks.
    Kind regards

    Tianjiao Li | Redgate Software
    Have you visited our Help Center?

Answers

Sign In or Register to comment.