cayenne-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Lon Varscsak <lon.varsc...@gmail.com>
Subject Re: Another regression in 4.2
Date Thu, 02 May 2019 18:26:53 GMT
You're the best!

On Thu, May 2, 2019 at 6:46 AM Nikita Timofeev <ntimofeev@objectstyle.com>
wrote:

> Hi Lon,
>
> I've fixed this [1]. Select translator incorrectly translated
> Expressions in some cases.
> Thanks for reporting.
>
> [1] https://issues.apache.org/jira/browse/CAY-2575
>
> On Thu, May 2, 2019 at 4:11 AM Lon Varscsak <lon.varscsak@gmail.com>
> wrote:
> >
> > Hey again :)
> >
> > I have a situation where the query created is missing an "AND" resulting
> in
> > invalid sql.  Here is the sql that's generated:
> >
> > SELECT DISTINCT t0.allow_backorder, t0.allow_multiples, t0.business_unit,
> > t0.buy_amount, t0.customer_choice, t0.end_date, t0.get_amount, t0.hidden,
> > t0.internal_notes, t0.key_code_required, t0.manufacturer_fulfillment,
> > t0.offer_name, t0.priority, t0.promo_id, t0.promo_type, t0.start_date
> FROM
> > marketing.dbo.promotion_master t0 JOIN
> > marketing.dbo.promotion_key_code_detail t1 ON t0.promo_id = t1.promo_id
> > WHERE ( ( t0.business_unit = ? ) AND ( t0.start_date <= ? ) AND (
> > t0.end_date > ? ) AND ( t0.key_code_required = ? ) AND t0.promo_type IN (
> > ?) ) ( t1.key_code = ? ) [bind: 1->business_unit:'SP',
> > 2->start_date:2019-05-01T17:57:19.123333333,
> > 3->end_date:2019-05-01T17:57:19.123333333, 4->key_code_required:'true',
> > 5->promo_type:'BUY ANY GET Y', 6->key_code:'EDLP10']
> >
> > Here is the sql it should generate:
> >
> > SELECT DISTINCT t0.allow_backorder, t0.allow_multiples, t0.business_unit,
> > t0.buy_amount, t0.customer_choice, t0.end_date, t0.get_amount, t0.hidden,
> > t0.internal_notes, t0.key_code_required, t0.manufacturer_fulfillment,
> > t0.offer_name, t0.priority, t0.promo_id, t0.promo_type, t0.start_date
> FROM
> > marketing.dbo.promotion_master t0 JOIN
> > marketing.dbo.promotion_key_code_detail t1 ON t0.promo_id = t1.promo_id
> > WHERE ( ( t0.business_unit = ? ) AND ( t0.start_date <= ? ) AND (
> > t0.end_date > ? ) AND ( t0.key_code_required = ? ) AND t0.promo_type IN (
> > ?) ) *AND* ( t1.key_code = ? ) [bind: 1->business_unit:'SP',
> > 2->start_date:2019-05-01T17:57:19.123333333,
> > 3->end_date:2019-05-01T17:57:19.123333333, 4->key_code_required:'true',
> > 5->promo_type:'BUY ANY GET Y', 6->key_code:'EDLP10']
> >
> > Thoughts?
> >
> > Thanks,
> >
> > Lon
>
>
>
> --
> Best regards,
> Nikita Timofeev
>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message