Jeff McKenna

Thanks @atlight I can reproduce with your test (on Windows with PHP 7.2.27 with MS4W 4.0.3). To be honest I am not sure how other mapscripts handle this case, but...

And I should say that when I first read your example my brain said 'shouldn't it generate an error if the classitem is not found?'. But maybe I am not...

@andrei-varnavskiy I have not verified this, but pull requests are warmly welcomed here :)

@inkr-xx I can't reproduce your issue. Here is a clip of my layer: ``` DATA "wkb_geometry FROM ( SELECT * FROM province WHERE name_e = 'Nova Scotia') as foo USING...

Same successful results with multiline SQL on Ubuntu (PostgreSQL 14.0, PostGIS 3.1.4, MapServer 7.7.0-dev)

@inkr-xx can you create a small zip archive to reproduce your problem? (containing custom dump, mapfile) I can then test your data snippet on my servers with Postgres.

@inkr-xx can you create a small zip archive to reproduce your problem? (containing custom dump, mapfile) I can then test your data snippet on my servers with Postgres.

@stephanesaurel also, if you create a sample test package, zip it, and attach here (as instructed in the text that you deleted when you filed this ticket) I can test...

> > TABLE ""Gestion"."V_ZonesProduitsAOC"" That syntax looks odd, not intuitive to users. What happens when you specify the schema as part of your CONNECTION, such as schema=Gestion and re-try your...

@stephanesaurel I'm going to keep asking here, can you please create a data snippet and zip that with a small mapfile? I should have no problem importing your data from...