Trick question?

Why does running this gives 'Cannot parse query' error? And how to fix it?

SELECT 

 GeomMakePoint(VectorMakeX2(mfd_id,mfd_id)) as geom

FROM

 [mfd_root]

It took longer than nice time to figure this out.

This forum's syntax highlighting gives more hints than query window inside M9

If you delete 'as geom' the query runs fine --> the geom field gets auto field name 'result'.

If you replace 'as geom' with 'as a' the query runs fine too.

My understanding : 'geom' is kind of reserved name in your initial query, thus throwing an error ?

Using a double quote around geom , thus like ... as "geom" ... runs fine too !

you can use AS [geom], so that you'll have a field name called geom.

And Rivo, yes, sadly you are correct the lack of syntax highlighting in M9 is a real bummer, especially after all this time...