CONCAT function issue

[michael.renaud]

Hi

CONCAT function seems not working with CUBA while it works with native JPA while documentation adverts otherwise.

See tests and results below. I tried also with 2 parameters (JPA 1 compliance) instead of 3 with no luck.

Or there is a syntactic trick I’m missing (?).

    @Test
    void cubaConcat3() {
        var resultCuba = dataManager.load(SupplierReceipt.class).view(View.MINIMAL)
                .query("select e from ibusy2_SupplierReceipt e " +
                        "where concat(e.supplierOrder.number,'-',e.ordinalNumber) in ('24050023-1')")
                .list();
        dump(resultCuba);
    }

    @Test
    void cubaConcat2() {
        var resultCuba = dataManager.load(SupplierReceipt.class).view(View.MINIMAL)
                .query("select e from ibusy2_SupplierReceipt e " +
                        "where concat(e.supplierOrder.number,e.ordinalNumber) in ('240500231')")
                .list();
        dump(resultCuba);
    }

    @Test
    void nativeJPAConcat3() {
        var queryExecutor = AppBeans.getPrototype(QueryExecutor.class);
        queryExecutor.setUseNativeJPA(true);
        var resultNativeJPA = queryExecutor.prepareRun("select e from ibusy2_SupplierReceipt e " +
                        "where concat(e.supplierOrder.number,'-',e.ordinalNumber) in ('24050023-1')",null)
                        .execute();
        dump(resultNativeJPA);
    }

CUBA 7.2

Regards,
Michael