DA with uniDAC (8.4.3) on PostgreSQL 13.3 views AutoSQL problem

Data Abstract
1

Hi,

I use the DA version 10.0.0.1511 (last in this moment) and I noticed this anomaly.

In my PG schema I use many views. In DASchemaModeler if I use AutoSQL the fields mapping not work. In client side the datatable is correctly open with correct number of record but many fields are without values.

If (server side) I change from AutoSQL to SQL all work fine. I attach screenhots

With AutoSQL mapping (server side)

image
image1162×891 62.3 KB

Preview data

image
image1162×891 53.6 KB

Client side:

image
image1139×363 12.9 KB

As you can see the number of records is correct but the fields are empty (not all)

If on the server side instead I set the statment type to SQL everything works correctly (client side I don’t change anything)

image

Client side now work fine

image
image1146×363 15.2 KB

2

Hi,

I think, I need your testcase for reproducing this issue locally.
can you drop email to support@ with DDL script, pls?
DDL script should create table and fill some data so I can test AutoSQL and SQL modes.

3

Hi EvgenyK

Yes. I create scripts and send them to you.

Thank you very much!

4

Hi EvgenyK

I just sent in email the requested scripts.

Thank you very much