You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@kylin.apache.org by Billy Liu <bi...@apache.org> on 2017/11/18 06:08:04 UTC

Re: kylin2.2.0 jdbc bug

Could you show the jdbc code snippet, and more related log for this call?

2017-11-13 22:13 GMT+08:00 我们 <29...@qq.com>:

> 1、rest api run correctly
> SELECT b.outid, SUM(b.opfare) AS sums
> FROM m_rec_consume_copy b
> LEFT JOIN OWN_ORG_STUDENT_TYPE t ON b.OUTID = t.OUTID
> WHERE 1=1 AND b.class_code IN ('1681115542','1681115561','
> 1681115562','1681115571','1681115572','1681115581','
> 1681115582','1681115591','1681115592','1681115593','
> 1681115594','1681115611','1681115612','1681115631','
> 1681115951','1681115961','1681115971','1681115981','1681115991') AND
> t.SCHOLARSHIP=1
> GROUP BY b.outid
> ORDER BY sums
> LIMIT 10 OFFSET 2
>
>
>
>
>
>
>
> 2、jdbc api is error
> SELECT b.outid, SUM(b.opfare) AS sums
> FROM m_rec_consume_copy b
> LEFT JOIN OWN_ORG_STUDENT_TYPE t ON b.OUTID = t.OUTID
> WHERE 1=1 AND b.class_code IN ('1681115542','1681115561','
> 1681115562','1681115571','1681115572','1681115581','
> 1681115582','1681115591','1681115592','1681115593','
> 1681115594','1681115611','1681115612','1681115631','
> 1681115951','1681115961','1681115971','1681115981','1681115991') AND
> t.SCHOLARSHIP=1
> GROUP BY b.outid
> ORDER BY sums
> LIMIT ? OFFSET ?