bug in SQL query generated by server side advancedCriteria

[claudiobosticco]

SmartClient Version: v13.0p_2025-01-25/Enterprise Deployment (built 2025-01-25)

Hi, I just noticed that in the latest 13.0, a server-side criteria constructed like this:

 DSRequest dsRequest = new DSRequest("SC_REPORT_ATTIVITA", DataSource.OP_FETCH, rpcManager);
        dsRequest.setAdvancedCriteria(new AdvancedCriteria(DefaultOperators.And, new Criterion[]{
                new SimpleCriterion("ID_ATTIVITA_FK", DefaultOperators.Equals, DataTools.buildList(1,2)),
                new SimpleCriterion("TIPO_MANIFESTAZIONE", DefaultOperators.Equals, DataTools.buildList("foo", "bar"))
        }));
        DSResponse dsResponse = dsRequest.execute();

produces an incorrect query:

SELECT SC_REPORT_ATTIVITA.ID_REC,
       SC_REPORT_ATTIVITA.ID_ATTIVITA_FK,
       SC_REPORT_ATTIVITA.TIPO_MANIFESTAZIONE
FROM DBJAS.SC_REPORT_ATTIVITA
WHERE ('0' = '1' AND
       (SC_REPORT_ATTIVITA.TIPO_MANIFESTAZIONE = '[foo, bar]' AND SC_REPORT_ATTIVITA.TIPO_MANIFESTAZIONE IS NOT NULL))

[Blama]

Hi claudiobosticco,
why are you using Equals with a list?
Shouldn’t it be the InSet then?

Best regards
Blama

[claudiobosticco]

Hello Blama, this was previously working, and in the SQL it became (field = 1 OR field = 2), and it's still working like this if the criteria comes from the client, while in 13.1 now I see it's automatically generated with a in clause