I have many SQLExecutor transformers and for any reason they use to lost the geometries.
The visual preview nor the data inspector show any geometry, only a “There is no geometry in this view” message.
When they should save the results in the next FeatureWriter (in a postgis database) only the alphanumeric fields are correctly writed, but the geom field is fill with nulls.
When I execute the same sql sentence in QGis or pgAdmin I get the geom field with the correct geometries.
I'm not be able to find the fix for this issue.
Any idea will be appreciated. Thanks in advance.