Return-Path: <user-return-5678-archive-asf-public=cust-asf.ponee.io@ignite.apache.org>
X-Original-To: archive-asf-public-internal@cust-asf2.ponee.io
Delivered-To: archive-asf-public-internal@cust-asf2.ponee.io
Received: from cust-asf.ponee.io (cust-asf.ponee.io [163.172.22.183])
	by cust-asf2.ponee.io (Postfix) with ESMTP id DF615200B36
	for <archive-asf-public-internal@cust-asf2.ponee.io>; Wed,  6 Jul 2016 18:59:38 +0200 (CEST)
Received: by cust-asf.ponee.io (Postfix)
	id DDCAC160A64; Wed,  6 Jul 2016 16:59:38 +0000 (UTC)
Delivered-To: archive-asf-public@cust-asf.ponee.io
Received: from mail.apache.org (hermes.apache.org [140.211.11.3])
	by cust-asf.ponee.io (Postfix) with SMTP id 3E36A160A55
	for <archive-asf-public@cust-asf.ponee.io>; Wed,  6 Jul 2016 18:59:37 +0200 (CEST)
Received: (qmail 67401 invoked by uid 500); 6 Jul 2016 16:59:36 -0000
Mailing-List: contact user-help@ignite.apache.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:user-help@ignite.apache.org>
List-Unsubscribe: <mailto:user-unsubscribe@ignite.apache.org>
List-Post: <mailto:user@ignite.apache.org>
List-Id: <user.ignite.apache.org>
Reply-To: user@ignite.apache.org
Delivered-To: mailing list user@ignite.apache.org
Received: (qmail 67391 invoked by uid 99); 6 Jul 2016 16:59:36 -0000
Received: from pnap-us-west-generic-nat.apache.org (HELO spamd3-us-west.apache.org) (209.188.14.142)
    by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 06 Jul 2016 16:59:36 +0000
Received: from localhost (localhost [127.0.0.1])
	by spamd3-us-west.apache.org (ASF Mail Server at spamd3-us-west.apache.org) with ESMTP id CACA7180481
	for <user@ignite.apache.org>; Wed,  6 Jul 2016 16:59:35 +0000 (UTC)
X-Virus-Scanned: Debian amavisd-new at spamd3-us-west.apache.org
X-Spam-Flag: NO
X-Spam-Score: 2.398
X-Spam-Level: **
X-Spam-Status: No, score=2.398 tagged_above=-999 required=6.31
	tests=[DKIM_SIGNED=0.1, DKIM_VALID=-0.1, DKIM_VALID_AU=-0.1,
	HTML_MESSAGE=2, KAM_LINEPADDING=1.2, RCVD_IN_DNSWL_LOW=-0.7,
	RCVD_IN_MSPIKE_H2=-0.001, SPF_PASS=-0.001] autolearn=disabled
Authentication-Results: spamd3-us-west.apache.org (amavisd-new);
	dkim=pass (2048-bit key) header.d=gmail.com
Received: from mx2-lw-eu.apache.org ([10.40.0.8])
	by localhost (spamd3-us-west.apache.org [10.40.0.10]) (amavisd-new, port 10024)
	with ESMTP id Ug52x3mjrl3J for <user@ignite.apache.org>;
	Wed,  6 Jul 2016 16:59:31 +0000 (UTC)
Received: from mail-qk0-f175.google.com (mail-qk0-f175.google.com [209.85.220.175])
	by mx2-lw-eu.apache.org (ASF Mail Server at mx2-lw-eu.apache.org) with ESMTPS id CCEA55F343
	for <user@ignite.apache.org>; Wed,  6 Jul 2016 16:59:30 +0000 (UTC)
Received: by mail-qk0-f175.google.com with SMTP id e3so118641644qkd.0
        for <user@ignite.apache.org>; Wed, 06 Jul 2016 09:59:30 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=gmail.com; s=20120113;
        h=mime-version:in-reply-to:references:from:date:message-id:subject:to;
        bh=6rHIoqGZAmCOXK/MoXZ4P9xIB5rSXyicZyU9IeP3Fpo=;
        b=uq4RJrGlP0TJw47W0oGVjcYCXs3p+E4V9Enx1VJWa+emHSnCmYBF0I4o5iLkry6QYe
         quKyLlVv+hJNVYLtzlCRjd0DYYd5MxnaUpf3+MBCUWxRc6NlNyc0w81x+PrZDGddbLKg
         kdRfjWny584BwMZtiIt+vNQ+27ijSIAcypUAr22wcjsh4tbAaXwW5mXW1HdOBgYwroUd
         mbpRaXWJPBXpyoPFWSIfsaUc6WV5w2PIYkibOf2HjHdJuxIhcTt8IszU+SQfxPXgaR+l
         CbXrJ/APTCDjtT6akLMWg9URDzyXNuwWzCz0XaSLtZCOt2Q68Z1Ddllwq6oA0jU6zl6v
         GlpQ==
X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=1e100.net; s=20130820;
        h=x-gm-message-state:mime-version:in-reply-to:references:from:date
         :message-id:subject:to;
        bh=6rHIoqGZAmCOXK/MoXZ4P9xIB5rSXyicZyU9IeP3Fpo=;
        b=myQXR4wdAI1cjWamCz/7vikaoEcOvpqHhrpRFAOobhkikhNxi4oGXmkhymoAwezBnF
         Eoqsjlq/Sa2Tfgect686D/w7IJFgBt9XYGI8TBFrFzNboYSOaoOd/F7HrHfhpaQN24o+
         E9uZd5YIVQ6FYuLHk2LS+OQOCCNAMi/Aj3WTIL9IUrfAf65pnU3RLtQFUFHy2fjGGRVU
         RTyzARPLwP+UzgJGGPW2JZYk/6AXFgMpCyBw0OcsWE+Qslx7hb2NjFdNVLK41GrH5skR
         IIyN4RgOGrfCUEPIdFA/fMbjCjyWb9HAi+ae78nfo5Zu9V0X87FioClv/8DXbrFLApQ+
         I81w==
X-Gm-Message-State: ALyK8tIjPTmJqSHTo69ky3QWCdg20R0wcDBxKVU92LPLrLTKuEGSGrB5WCSg8VeQ0otMD+5hYbTEA55Io6dzcg==
X-Received: by 10.55.188.198 with SMTP id m189mr30397763qkf.205.1467824369802;
 Wed, 06 Jul 2016 09:59:29 -0700 (PDT)
MIME-Version: 1.0
Received: by 10.140.37.72 with HTTP; Wed, 6 Jul 2016 09:59:29 -0700 (PDT)
In-Reply-To: <A523DFF035BBAE4D9EA7A3961C3308BC48038B15@nkgeml513-mbx.china.huawei.com>
References: <A523DFF035BBAE4D9EA7A3961C3308BC4803818A@nkgeml513-mbx.china.huawei.com>
 <CAMegbcLfGjN12bz2Qy_LCEowxESOUr+F69JQgArcN8TQQYra4g@mail.gmail.com> <A523DFF035BBAE4D9EA7A3961C3308BC48038B15@nkgeml513-mbx.china.huawei.com>
From: Alexei Scherbakov <alexey.scherbakoff@gmail.com>
Date: Wed, 6 Jul 2016 19:59:29 +0300
Message-ID: <CAMegbcKUzZqMEg0vOMkr=B0Qm_G6RPK-S__5CqfCZF6YS_yp3A@mail.gmail.com>
Subject: =?UTF-8?Q?Re=3A_=E7=AD=94=E5=A4=8D=3A_ignite_group_indexing_not_work_problem?=
To: user <user@ignite.apache.org>
Content-Type: multipart/alternative; boundary=94eb2c048d2427a49f0536fa7e41
archived-at: Wed, 06 Jul 2016 16:59:39 -0000

--94eb2c048d2427a49f0536fa7e41
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

Hi, Kevin.

Have you defined other composite indexes including objid, fieldnum fields ?
If yes, try to disable them and check if query picks up correct index.


2016-07-05 15:45 GMT+03:00 Zhengqingzheng <zhengqingzheng@huawei.com>:

> Hi Alexei,
>
> Indexing not work again. This time I print the query plan:
>
>
>
> [SELECT
>
>     GUID AS __C0
>
> FROM "com.huawei.soa.ignite.model.IgniteMetaIndex_Cache".IGNITEMETAINDEX
>
>     /*
> "com.huawei.soa.ignite.model.IgniteMetaIndex_Cache"."objId_fieldNum_numVa=
lue":
> OBJID =3D ?1
>
>         AND FIELDNUM =3D ?2
>
>      */
>
> WHERE (STRINGVALUE =3D ?3)
>
>     AND ((OBJID =3D ?1)
>
>     AND (FIELDNUM =3D ?2))], [SELECT
>
>     __C0 AS GUID
>
> FROM PUBLIC.__T0
>
> /* "com.huawei.soa.ignite.model.IgniteMetaIndex_Cache"."merge_scan" */]
>
>
>
> It seems that the group index is broken, as I can see only objId and
> fieldnum are used to check the index, however, I defined three columns:
> objid, fieldnum and stringvalue
>
> And the order is incorrect.
>
> My query is :
>
> String qryStr =3D " explain select guid from IgniteMetaIndex where  objid=
=3D?
> and fieldnum=3D? and stringvalue=3D? ";
>
> =E2=80=A6
>
> fieldQry.setArgs( "a1162", 7 ,"18835473249");
>
>
>
> hope you can help me.
>
>
>
>
>
> Best regards,
>
> Kevin
>
> *=E5=8F=91=E4=BB=B6=E4=BA=BA:* Alexei Scherbakov [mailto:alexey.scherbako=
ff@gmail.com]
> *=E5=8F=91=E9=80=81=E6=97=B6=E9=97=B4:* 2016=E5=B9=B46=E6=9C=8829=E6=97=
=A5 0:30
> *=E6=94=B6=E4=BB=B6=E4=BA=BA:* user
> *=E4=B8=BB=E9=A2=98:* Re: ignite group indexing not work problem
>
>
>
> Hi,
>
>
>
> I've tried the provided sample and found what instead of using
> oId_fNum_num index H2 engine prefers oId_fNum_date,
>
> thus preventing condition on num field to use index.
>
>
>
> I think it's incorrect behavior.
>
>
>
> Could you disable oId_fNum_date, execute the query again and provide me
> with the query plan and execution time ?
>
>
>
> You can get query plan from build-in H2 console. Read more about how to
> setup console here [1]
>
>
>
> [1] https://apacheignite.readme.io/docs/sql-queries#using-h2-debug-consol=
e
>
>
>
>
>
>
>
>
>
> 2016-06-28 6:08 GMT+03:00 Zhengqingzheng <zhengqingzheng@huawei.com>:
>
> Hi there,
>
> My  ignite in-memory sql query is very slow. Anyone can help me to figure
> out what was wrong?
>
>
>
> I am using group indexing to speed up in-memory sql queries. I notice tha=
t
> my sql query took 2274ms (data set size: 10Million, return result:1).
>
>
>
> My query is executed as:
>
> String qryStr =3D "select * from UniqueField where oid=3D ? and fnum=3D ?=
 and
> num=3D ?";
>
>
>
>         String oId=3D"a343";
>
>         int fNum =3D 3;
>
>         BigDecimal num =3D new BigDecimal("510020000982136");
>
>
>
>         IgniteCache cache =3D
> igniteMetaUtils.getIgniteCache(IgniteMetaCacheType.UNIQUE_INDEX);  // to
> get selected cache ,which has been created in some other place
>
>
>
>         SqlQuery qry =3D new SqlQuery(UniqueField.class, qryStr);
>
>         qry.setArgs(objId,fieldNum, numVal);
>
> long start =3D System.currentTimeMillis();
>
> List result=3D cache.query(qry).getAll();
>
> long end =3D System.currentTimeMillis();
>
>         System.out.println("Time used in query :"+ (end-start)+"ms");
>
>
>
> And the result shows: Time used in query :2274ms
>
>
>
> I have set group indexes, and the model is defined as:
>
> import java.io.Serializable;
>
> import java.math.BigDecimal;
>
> import java.util.Date;
>
>
>
> import org.apache.ignite.cache.query.annotations.QuerySqlField;
>
>
>
> public class UniqueField implements Serializable
>
> {
>
>
>
>     @QuerySqlField
>
>     private String orgId;
>
>
>
>     @QuerySqlField(
>
>             orderedGroups=3D{
>
>             @QuerySqlField.Group(
>
>                     name=3D"oId_fNum_ msg ", order=3D1, descending =3D tr=
ue),
>
>             @QuerySqlField.Group(
>
>                     name=3D"oId_fNum_ num ", order=3D1, descending =3D
> true),
>
>             @QuerySqlField.Group(
>
>                     name=3D"oId_fNum_ date ", order=3D1, descending =3D t=
rue)
>
>
>
> })
>
> private String oId;
>
>
>
>     @QuerySqlField(index=3Dtrue)
>
>     private String gId;
>
>
>
>      @QuerySqlField(
>
>             orderedGroups=3D{
>
>             @QuerySqlField.Group(
>
>                     name=3D"oId_fNum_ msg ", order=3D2, descending =3D tr=
ue),
>
>             @QuerySqlField.Group(
>
>                     name=3D"oId_fNum_ num ", order=3D2, descending =3D
> true),
>
>             @QuerySqlField.Group(
>
>                     name=3D"oId_fNum_ date ", order=3D2, descending =3D t=
rue)
>
>
>
> })
>
>     private int fNum;
>
>
>
>     @QuerySqlField(index=3Dtrue, @QuerySqlField.Group(
>
>                     name=3D"oId_fNum_ msg ", order=3D3, descending =3D tr=
ue)})
>
>     private String msg;
>
>
>
>     @QuerySqlField(index=3Dtrue, @QuerySqlField.Group(
>
>                     name=3D"oId_fNum_ num ", order=3D3, descending =3D tr=
ue)})
>
>     private BigDecimal num;
>
>
>
>     @QuerySqlField(index=3Dtrue, @QuerySqlField.Group(
>
>                     name=3D"oId_fNum_ date ", order=3D3, descending =3D t=
rue)})
>
>     private Date date;
>
>
>
>     public UniqueField(){};
>
>
>
>     public UniqueField(
>
>             String orgId,
>
>             String oId,
>
>             String gId,
>
>             int fNum,
>
>             String msg,
>
>             BigDecimal num,
>
>             Date date
>
>             ){
>
>         this.orgId=3DorgId;
>
>         this.oId=3DoId;
>
>         this.gId =3D gId;
>
>         this.fNum =3D fNum;
>
>         this.msg =3D msg;
>
>         this.num =3D num;
>
>         this.date =3D date;
>
>     }
>
>
>
>     public String getOrgId()
>
>     {
>
>         return orgId;
>
>     }
>
>
>
>     public void setOrgId(String orgId)
>
>     {
>
>         this.orgId =3D orgId;
>
>     }
>
>
>
>     public String getOId()
>
>     {
>
>         return oId;
>
>     }
>
>
>
>     public void setOId(String oId)
>
>     {
>
>         this.oId =3D oId;
>
>     }
>
>
>
>     public String getGid()
>
>     {
>
>         return gId;
>
>     }
>
>
>
>     public void setGuid(String gId)
>
>     {
>
>         this.gId =3D gId;
>
>     }
>
>
>
>     public int getFNum()
>
>     {
>
>         return fNum;
>
>     }
>
>
>
>     public void setFNum(int fNum)
>
>     {
>
>         this.fNum =3D fNum;
>
>     }
>
>
>
>     public String getMsg()
>
>     {
>
>         return msg;
>
>     }
>
>
>
>     public void setMsg(String msg)
>
>     {
>
>         this.msg =3D msg;
>
>     }
>
>
>
>     public BigDecimal getNum()
>
>     {
>
>         return num;
>
>     }
>
>
>
>     public void setNum(BigDecimal num)
>
>     {
>
>         this.num =3D num;
>
>     }
>
>
>
>     public Date getDate()
>
>     {
>
>         return date;
>
>     }
>
>
>
>     public void setDate(Date date)
>
>     {
>
>         this.date =3D date;
>
>     }
>
>
>
> }
>
>
>
>
>
>
>
>
>
>
>
>
>
> --
>
>
> Best regards,
>
> Alexei Scherbakov
>



--=20

Best regards,
Alexei Scherbakov

--94eb2c048d2427a49f0536fa7e41
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr">Hi, Kevin.<div><br></div><div>Have you defined other compo=
site indexes including=C2=A0objid, fieldnum fields ?</div><div>If yes, try =
to disable them and check if query picks up correct index.</div><div><br></=
div><div class=3D"gmail_extra"><br><div class=3D"gmail_quote">2016-07-05 15=
:45 GMT+03:00 Zhengqingzheng <span dir=3D"ltr">&lt;<a href=3D"mailto:zhengq=
ingzheng@huawei.com" target=3D"_blank">zhengqingzheng@huawei.com</a>&gt;</s=
pan>:<br><blockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8e=
x;border-left-width:1px;border-left-style:solid;border-left-color:rgb(204,2=
04,204);padding-left:1ex">





<div lang=3D"ZH-CN" link=3D"blue" vlink=3D"purple">
<div>
<p class=3D"MsoNormal"><span lang=3D"EN-US" style=3D"font-size:10.5pt;font-=
family:Calibri,sans-serif;color:rgb(31,73,125)">Hi Alexei,
<u></u><u></u></span></p>
<p class=3D"MsoNormal"><span lang=3D"EN-US" style=3D"font-size:10.5pt;font-=
family:Calibri,sans-serif;color:rgb(31,73,125)">Indexing not work again. Th=
is time I print the query plan:<u></u><u></u></span></p>
<p class=3D"MsoNormal"><span lang=3D"EN-US" style=3D"font-size:10.5pt;font-=
family:Calibri,sans-serif;color:rgb(31,73,125)"><u></u>=C2=A0<u></u></span>=
</p>
<p class=3D"MsoNormal"><span lang=3D"EN-US" style=3D"font-size:10.5pt;font-=
family:Calibri,sans-serif;color:rgb(31,73,125)">[SELECT<u></u><u></u></span=
></p>
<p class=3D"MsoNormal"><span lang=3D"EN-US" style=3D"font-size:10.5pt;font-=
family:Calibri,sans-serif;color:rgb(31,73,125)">=C2=A0=C2=A0=C2=A0 GUID AS =
__C0<u></u><u></u></span></p>
<p class=3D"MsoNormal"><span lang=3D"EN-US" style=3D"font-size:10.5pt;font-=
family:Calibri,sans-serif;color:rgb(31,73,125)">FROM &quot;com.huawei.soa.i=
gnite.model.IgniteMetaIndex_Cache&quot;.IGNITEMETAINDEX<u></u><u></u></span=
></p>
<p class=3D"MsoNormal"><span lang=3D"EN-US" style=3D"font-size:10.5pt;font-=
family:Calibri,sans-serif;color:rgb(31,73,125)">=C2=A0 =C2=A0=C2=A0/* &quot=
;com.huawei.soa.ignite.model.IgniteMetaIndex_Cache&quot;.&quot;objId_fieldN=
um_numValue&quot;: OBJID =3D ?1<u></u><u></u></span></p>
<p class=3D"MsoNormal"><span lang=3D"EN-US" style=3D"font-size:10.5pt;font-=
family:Calibri,sans-serif;color:rgb(31,73,125)">=C2=A0=C2=A0=C2=A0=C2=A0=C2=
=A0=C2=A0=C2=A0 AND FIELDNUM =3D ?2<u></u><u></u></span></p>
<p class=3D"MsoNormal"><span lang=3D"EN-US" style=3D"font-size:10.5pt;font-=
family:Calibri,sans-serif;color:rgb(31,73,125)">=C2=A0=C2=A0=C2=A0=C2=A0 */=
<u></u><u></u></span></p>
<p class=3D"MsoNormal"><span lang=3D"EN-US" style=3D"font-size:10.5pt;font-=
family:Calibri,sans-serif;color:rgb(31,73,125)">WHERE (STRINGVALUE =3D ?3)<=
u></u><u></u></span></p>
<p class=3D"MsoNormal"><span lang=3D"EN-US" style=3D"font-size:10.5pt;font-=
family:Calibri,sans-serif;color:rgb(31,73,125)">=C2=A0=C2=A0=C2=A0 AND ((OB=
JID =3D ?1)<u></u><u></u></span></p>
<p class=3D"MsoNormal"><span lang=3D"EN-US" style=3D"font-size:10.5pt;font-=
family:Calibri,sans-serif;color:rgb(31,73,125)">=C2=A0=C2=A0=C2=A0 AND (FIE=
LDNUM =3D ?2))], [SELECT<u></u><u></u></span></p>
<p class=3D"MsoNormal"><span lang=3D"EN-US" style=3D"font-size:10.5pt;font-=
family:Calibri,sans-serif;color:rgb(31,73,125)">=C2=A0=C2=A0=C2=A0 __C0 AS =
GUID<u></u><u></u></span></p>
<p class=3D"MsoNormal"><span lang=3D"EN-US" style=3D"font-size:10.5pt;font-=
family:Calibri,sans-serif;color:rgb(31,73,125)">FROM PUBLIC.__T0<u></u><u><=
/u></span></p>
<p class=3D"MsoNormal" style=3D"text-indent:9pt"><span lang=3D"EN-US" style=
=3D"font-size:10.5pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">/=
* &quot;com.huawei.soa.ignite.model.IgniteMetaIndex_Cache&quot;.&quot;merge=
_scan&quot; */]<u></u><u></u></span></p>
<p class=3D"MsoNormal" style=3D"text-indent:9pt"><span lang=3D"EN-US" style=
=3D"font-size:10.5pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)"><=
u></u>=C2=A0<u></u></span></p>
<p class=3D"MsoNormal" style=3D"text-indent:9pt"><span lang=3D"EN-US" style=
=3D"font-size:10.5pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">I=
t seems that the group index is broken, as I can see only objId and fieldnu=
m are used to check the index, however, I
 defined three columns: objid, fieldnum and stringvalue<u></u><u></u></span=
></p>
<p class=3D"MsoNormal" style=3D"text-indent:9pt"><span lang=3D"EN-US" style=
=3D"font-size:10.5pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">A=
nd the order is incorrect.<u></u><u></u></span></p>
<p class=3D"MsoNormal" style=3D"text-indent:9pt"><span lang=3D"EN-US" style=
=3D"font-size:10.5pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)">M=
y query is :<u></u><u></u></span></p>
<p class=3D"MsoNormal" style=3D"text-autospace:none"><span lang=3D"EN-US" s=
tyle=3D"font-size:14pt;font-family:Consolas;color:black">String qryStr =3D
</span><span lang=3D"EN-US" style=3D"font-size:14pt;font-family:Consolas;co=
lor:rgb(42,0,255)">&quot; explain select guid from IgniteMetaIndex where=C2=
=A0 objid=3D? and fieldnum=3D? and stringvalue=3D? &quot;</span><span lang=
=3D"EN-US" style=3D"font-size:14pt;font-family:Consolas;color:black">;</spa=
n><span lang=3D"EN-US" style=3D"font-size:14pt;font-family:Consolas"><u></u=
><u></u></span></p>
<p class=3D"MsoNormal"><span lang=3D"EN-US" style=3D"font-size:14pt;font-fa=
mily:Consolas;color:black">=E2=80=A6<u></u><u></u></span></p>
<p class=3D"MsoNormal"><span lang=3D"EN-US" style=3D"font-size:14pt;font-fa=
mily:Consolas;color:black">fieldQry.setArgs( &quot;a1162&quot;, 7 ,&quot;18=
835473249&quot;);=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0
</span><span lang=3D"EN-US" style=3D"font-size:10.5pt;font-family:Calibri,s=
ans-serif;color:rgb(31,73,125)"><u></u><u></u></span></p>
<p class=3D"MsoNormal" style=3D"text-indent:9pt"><span lang=3D"EN-US" style=
=3D"font-size:10.5pt;font-family:Calibri,sans-serif;color:rgb(31,73,125)"><=
u></u>=C2=A0<u></u></span></p>
<p class=3D"MsoNormal"><span lang=3D"EN-US" style=3D"font-size:10.5pt;font-=
family:Calibri,sans-serif;color:rgb(31,73,125)">hope you can help me.<u></u=
><u></u></span></p>
<p class=3D"MsoNormal"><span lang=3D"EN-US" style=3D"font-size:10.5pt;font-=
family:Calibri,sans-serif;color:rgb(31,73,125)"><u></u>=C2=A0<u></u></span>=
</p>
<p class=3D"MsoNormal"><span lang=3D"EN-US" style=3D"font-size:10.5pt;font-=
family:Calibri,sans-serif;color:rgb(31,73,125)"><u></u>=C2=A0<u></u></span>=
</p>
<p class=3D"MsoNormal"><span lang=3D"EN-US" style=3D"font-size:10.5pt;font-=
family:Calibri,sans-serif;color:rgb(31,73,125)">Best regards,<u></u><u></u>=
</span></p><span>
<p class=3D"MsoNormal"><span lang=3D"EN-US" style=3D"font-size:10.5pt;font-=
family:Calibri,sans-serif;color:rgb(31,73,125)">Kevin<u></u><u></u></span><=
/p>
<div style=3D"border-style:solid none none;border-top-width:1pt;border-top-=
color:rgb(181,196,223);padding:3pt 0cm 0cm">
<p class=3D"MsoNormal"><b><span style=3D"font-size:10pt">=E5=8F=91=E4=BB=B6=
=E4=BA=BA<span lang=3D"EN-US">:</span></span></b><span lang=3D"EN-US" style=
=3D"font-size:10pt"> Alexei Scherbakov [mailto:<a href=3D"mailto:alexey.sch=
erbakoff@gmail.com" target=3D"_blank">alexey.scherbakoff@gmail.com</a>]
<br>
</span><b><span style=3D"font-size:10pt">=E5=8F=91=E9=80=81=E6=97=B6=E9=97=
=B4<span lang=3D"EN-US">:</span></span></b><span lang=3D"EN-US" style=3D"fo=
nt-size:10pt"> 2016</span><span style=3D"font-size:10pt">=E5=B9=B4<span lan=
g=3D"EN-US">6</span>=E6=9C=88<span lang=3D"EN-US">29</span>=E6=97=A5<span l=
ang=3D"EN-US"> 0:30<br>
</span><b>=E6=94=B6=E4=BB=B6=E4=BA=BA<span lang=3D"EN-US">:</span></b><span=
 lang=3D"EN-US"> user<br>
</span><b>=E4=B8=BB=E9=A2=98<span lang=3D"EN-US">:</span></b><span lang=3D"=
EN-US"> Re: ignite group indexing not work problem<u></u><u></u></span></sp=
an></p>
</div>
<p class=3D"MsoNormal"><span lang=3D"EN-US"><u></u>=C2=A0<u></u></span></p>
</span><div>
<p class=3D"MsoNormal"><span lang=3D"EN-US">Hi,<u></u><u></u></span></p><di=
v><div>
<div>
<p class=3D"MsoNormal"><span lang=3D"EN-US"><u></u>=C2=A0<u></u></span></p>
</div>
<p class=3D"MsoNormal"><span lang=3D"EN-US">I&#39;ve tried the provided sam=
ple and found what instead of using oId_fNum_num index H2 engine prefers=C2=
=A0oId_fNum_date,<u></u><u></u></span></p>
<div>
<p class=3D"MsoNormal"><span lang=3D"EN-US">thus preventing condition on nu=
m field to use index.<u></u><u></u></span></p>
</div>
<div>
<p class=3D"MsoNormal"><span lang=3D"EN-US"><u></u>=C2=A0<u></u></span></p>
</div>
<div>
<p class=3D"MsoNormal"><span lang=3D"EN-US">I think it&#39;s incorrect beha=
vior.<u></u><u></u></span></p>
</div>
<div>
<p class=3D"MsoNormal"><span lang=3D"EN-US"><u></u>=C2=A0<u></u></span></p>
</div>
<div>
<p class=3D"MsoNormal"><span lang=3D"EN-US">Could you disable=C2=A0oId_fNum=
_date, execute the query again and provide me with the query plan and execu=
tion time ?<u></u><u></u></span></p>
</div>
<div>
<p class=3D"MsoNormal"><span lang=3D"EN-US"><u></u>=C2=A0<u></u></span></p>
</div>
<div>
<p class=3D"MsoNormal"><span lang=3D"EN-US">You can get query plan from bui=
ld-in H2 console. Read more about how to setup console here [1]<u></u><u></=
u></span></p>
</div>
<div>
<p class=3D"MsoNormal"><span lang=3D"EN-US"><u></u>=C2=A0<u></u></span></p>
</div>
<div>
<p class=3D"MsoNormal"><span lang=3D"EN-US">[1]=C2=A0<a href=3D"https://apa=
cheignite.readme.io/docs/sql-queries#using-h2-debug-console" target=3D"_bla=
nk">https://apacheignite.readme.io/docs/sql-queries#using-h2-debug-console<=
/a><u></u><u></u></span></p>
<div>
<div>
<p class=3D"MsoNormal"><span lang=3D"EN-US"><u></u>=C2=A0<u></u></span></p>
<div>
<p class=3D"MsoNormal"><span lang=3D"EN-US"><u></u>=C2=A0<u></u></span></p>
</div>
<div>
<p class=3D"MsoNormal"><span lang=3D"EN-US"><u></u>=C2=A0<u></u></span></p>
</div>
</div>
</div>
</div>
</div></div></div><div><div>
<div>
<p class=3D"MsoNormal"><span lang=3D"EN-US"><u></u>=C2=A0<u></u></span></p>
<div>
<p class=3D"MsoNormal"><span lang=3D"EN-US">2016-06-28 6:08 GMT+03:00 Zheng=
qingzheng &lt;<a href=3D"mailto:zhengqingzheng@huawei.com" target=3D"_blank=
">zhengqingzheng@huawei.com</a>&gt;:<u></u><u></u></span></p>
<div>
<div>
<p class=3D"MsoNormal"><span lang=3D"EN-US">Hi there,
<u></u><u></u></span></p>
<p class=3D"MsoNormal"><span lang=3D"EN-US">My =C2=A0ignite in-memory sql q=
uery is very slow. Anyone can help me to figure out what was wrong?<u></u><=
u></u></span></p>
<p class=3D"MsoNormal"><span lang=3D"EN-US">=C2=A0<u></u><u></u></span></p>
<p class=3D"MsoNormal"><span lang=3D"EN-US">I am using group indexing to sp=
eed up in-memory sql queries. I notice that my sql query took 2274ms (data =
set size: 10Million, return result:1).
<u></u><u></u></span></p>
<p class=3D"MsoNormal"><span lang=3D"EN-US">=C2=A0<u></u><u></u></span></p>
<p class=3D"MsoNormal"><span lang=3D"EN-US">My query is executed as:<u></u>=
<u></u></span></p>
<p class=3D"MsoNormal" style=3D"margin-left:21pt;text-indent:21pt">
<span lang=3D"EN-US">String qryStr =3D &quot;select * from <span style=3D"c=
olor:rgb(31,73,125)">UniqueField
</span>where oid=3D ? and fnum=3D ? and num=3D ?&quot;;<u></u><u></u></span=
></p>
<p class=3D"MsoNormal"><span lang=3D"EN-US">=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=
=C2=A0=C2=A0
<u></u><u></u></span></p>
<p class=3D"MsoNormal"><span lang=3D"EN-US">=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=
=C2=A0=C2=A0=C2=A0String oId=3D&quot;a343&quot;;<u></u><u></u></span></p>
<p class=3D"MsoNormal"><span lang=3D"EN-US">=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=
=C2=A0=C2=A0 int fNum =3D 3;<u></u><u></u></span></p>
<p class=3D"MsoNormal"><span lang=3D"EN-US">=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=
=C2=A0=C2=A0 BigDecimal num =3D new BigDecimal(&quot;510020000982136&quot;)=
;<u></u><u></u></span></p>
<p class=3D"MsoNormal"><span lang=3D"EN-US">=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=
=C2=A0=C2=A0
<u></u><u></u></span></p>
<p class=3D"MsoNormal"><span lang=3D"EN-US">=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=
=C2=A0=C2=A0=C2=A0IgniteCache cache =3D igniteMetaUtils.getIgniteCache(Igni=
teMetaCacheType.UNIQUE_INDEX);=C2=A0 // to get selected cache ,which has be=
en created in some other
 place<u></u><u></u></span></p>
<p class=3D"MsoNormal"><span lang=3D"EN-US">=C2=A0=C2=A0=C2=A0
<u></u><u></u></span></p>
<p class=3D"MsoNormal"><span lang=3D"EN-US">=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=
=C2=A0=C2=A0=C2=A0SqlQuery qry =3D new SqlQuery(<span style=3D"color:rgb(31=
,73,125)">UniqueField</span>.class, qryStr);<u></u><u></u></span></p>
<p class=3D"MsoNormal"><span lang=3D"EN-US">=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=
=C2=A0=C2=A0 qry.setArgs(objId,fieldNum, numVal);<u></u><u></u></span></p>
<p class=3D"MsoNormal" style=3D"margin-left:21pt;text-indent:21pt">
<span lang=3D"EN-US">long start =3D System.currentTimeMillis();<u></u><u></=
u></span></p>
<p class=3D"MsoNormal" style=3D"margin-left:21pt;text-indent:21pt">
<span lang=3D"EN-US">List result=3D cache.query(qry).getAll();<u></u><u></u=
></span></p>
<p class=3D"MsoNormal" style=3D"margin-left:21pt;text-indent:21pt">
<span lang=3D"EN-US">long end =3D System.currentTimeMillis();<u></u><u></u>=
</span></p>
<p class=3D"MsoNormal"><span lang=3D"EN-US">=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=
=C2=A0=C2=A0 System.out.println(&quot;Time used in query :&quot;+ (end-star=
t)+&quot;ms&quot;);<u></u><u></u></span></p>
<p class=3D"MsoNormal"><span lang=3D"EN-US">=C2=A0<u></u><u></u></span></p>
<p class=3D"MsoNormal"><span lang=3D"EN-US">And the result shows: Time used=
 in query :2274ms<u></u><u></u></span></p>
<p class=3D"MsoNormal"><span lang=3D"EN-US">=C2=A0<u></u><u></u></span></p>
<p class=3D"MsoNormal"><span lang=3D"EN-US">I have set group indexes, and t=
he model is defined as:<u></u><u></u></span></p>
<p class=3D"MsoNormal"><span lang=3D"EN-US" style=3D"color:rgb(31,73,125)">=
import java.io.Serializable;</span><span lang=3D"EN-US"><u></u><u></u></spa=
n></p>
<p class=3D"MsoNormal"><span lang=3D"EN-US" style=3D"color:rgb(31,73,125)">=
import java.math.BigDecimal;</span><span lang=3D"EN-US"><u></u><u></u></spa=
n></p>
<p class=3D"MsoNormal"><span lang=3D"EN-US" style=3D"color:rgb(31,73,125)">=
import java.util.Date;</span><span lang=3D"EN-US"><u></u><u></u></span></p>
<p class=3D"MsoNormal"><span lang=3D"EN-US" style=3D"color:rgb(31,73,125)">=
=C2=A0</span><span lang=3D"EN-US"><u></u><u></u></span></p>
<p class=3D"MsoNormal"><span lang=3D"EN-US" style=3D"color:rgb(31,73,125)">=
import org.apache.ignite.cache.query.annotations.QuerySqlField;</span><span=
 lang=3D"EN-US"><u></u><u></u></span></p>
<p class=3D"MsoNormal"><span lang=3D"EN-US" style=3D"color:rgb(31,73,125)">=
=C2=A0</span><span lang=3D"EN-US"><u></u><u></u></span></p>
<p class=3D"MsoNormal"><span lang=3D"EN-US" style=3D"color:rgb(31,73,125)">=
public class UniqueField implements Serializable</span><span lang=3D"EN-US"=
><u></u><u></u></span></p>
<p class=3D"MsoNormal"><span lang=3D"EN-US" style=3D"color:rgb(31,73,125)">=
{</span><span lang=3D"EN-US"><u></u><u></u></span></p>
<p class=3D"MsoNormal"><span lang=3D"EN-US" style=3D"color:rgb(31,73,125)">=
=C2=A0=C2=A0
</span><span lang=3D"EN-US"><u></u><u></u></span></p>
<p class=3D"MsoNormal"><span lang=3D"EN-US" style=3D"color:rgb(31,73,125)">=
=C2=A0=C2=A0=C2=A0=C2=A0@QuerySqlField</span><span lang=3D"EN-US"><u></u><u=
></u></span></p>
<p class=3D"MsoNormal"><span lang=3D"EN-US" style=3D"color:rgb(31,73,125)">=
=C2=A0=C2=A0=C2=A0 private String orgId;</span><span lang=3D"EN-US"><u></u>=
<u></u></span></p>
<p class=3D"MsoNormal"><span lang=3D"EN-US" style=3D"color:rgb(31,73,125)">=
=C2=A0=C2=A0=C2=A0
</span><span lang=3D"EN-US"><u></u><u></u></span></p>
<p class=3D"MsoNormal"><span lang=3D"EN-US" style=3D"color:rgb(31,73,125)">=
=C2=A0=C2=A0=C2=A0=C2=A0@QuerySqlField(</span><span lang=3D"EN-US"><u></u><=
u></u></span></p>
<p class=3D"MsoNormal"><span lang=3D"EN-US" style=3D"color:rgb(31,73,125)">=
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 orderedG=
roups=3D{</span><span lang=3D"EN-US"><u></u><u></u></span></p>
<p class=3D"MsoNormal"><span lang=3D"EN-US" style=3D"color:rgb(31,73,125)">=
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 @QuerySq=
lField.Group(</span><span lang=3D"EN-US"><u></u><u></u></span></p>
<p class=3D"MsoNormal"><span lang=3D"EN-US" style=3D"color:rgb(31,73,125)">=
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=
=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 name=3D&quot;oId_fNum_ msg &quot;, =
order=3D1, descending =3D true),</span><span lang=3D"EN-US"><u></u><u></u><=
/span></p>
<p class=3D"MsoNormal"><span lang=3D"EN-US" style=3D"color:rgb(31,73,125)">=
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 @QuerySq=
lField.Group(</span><span lang=3D"EN-US"><u></u><u></u></span></p>
<p class=3D"MsoNormal"><span lang=3D"EN-US" style=3D"color:rgb(31,73,125)">=
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=
=A0=C2=A0=C2=A0=C2=A0 =C2=A0=C2=A0=C2=A0name=3D&quot;oId_fNum_ num &quot;, =
order=3D1, descending =3D true),=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0
</span><span lang=3D"EN-US"><u></u><u></u></span></p>
<p class=3D"MsoNormal"><span lang=3D"EN-US" style=3D"color:rgb(31,73,125)">=
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0@Qu=
erySqlField.Group(</span><span lang=3D"EN-US"><u></u><u></u></span></p>
<p class=3D"MsoNormal"><span lang=3D"EN-US" style=3D"color:rgb(31,73,125)">=
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=
=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 name=3D&quot;oId_fNum_ date &quot;,=
 order=3D1, descending =3D true)</span><span lang=3D"EN-US"><u></u><u></u><=
/span></p>
<p class=3D"MsoNormal"><span lang=3D"EN-US" style=3D"color:rgb(31,73,125)">=
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0
</span><span lang=3D"EN-US"><u></u><u></u></span></p>
<p class=3D"MsoNormal" style=3D"text-indent:21pt">
<span lang=3D"EN-US" style=3D"color:rgb(31,73,125)">})=C2=A0=C2=A0=C2=A0 </=
span><span lang=3D"EN-US"><u></u><u></u></span></p>
<p class=3D"MsoNormal" style=3D"text-indent:21pt">
<span lang=3D"EN-US" style=3D"color:rgb(31,73,125)">private String oId;</sp=
an><span lang=3D"EN-US"><u></u><u></u></span></p>
<p class=3D"MsoNormal"><span lang=3D"EN-US" style=3D"color:rgb(31,73,125)">=
=C2=A0=C2=A0=C2=A0
</span><span lang=3D"EN-US"><u></u><u></u></span></p>
<p class=3D"MsoNormal"><span lang=3D"EN-US" style=3D"color:rgb(31,73,125)">=
=C2=A0=C2=A0=C2=A0=C2=A0@QuerySqlField(index=3Dtrue)</span><span lang=3D"EN=
-US"><u></u><u></u></span></p>
<p class=3D"MsoNormal"><span lang=3D"EN-US" style=3D"color:rgb(31,73,125)">=
=C2=A0=C2=A0=C2=A0 private String gId;</span><span lang=3D"EN-US"><u></u><u=
></u></span></p>
<p class=3D"MsoNormal"><span lang=3D"EN-US" style=3D"color:rgb(31,73,125)">=
=C2=A0</span><span lang=3D"EN-US"><u></u><u></u></span></p>
<p class=3D"MsoNormal"><span lang=3D"EN-US" style=3D"color:rgb(31,73,125)">=
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0@QuerySqlField(</span><span lang=3D"EN-US"><u=
></u><u></u></span></p>
<p class=3D"MsoNormal"><span lang=3D"EN-US" style=3D"color:rgb(31,73,125)">=
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 orderedG=
roups=3D{</span><span lang=3D"EN-US"><u></u><u></u></span></p>
<p class=3D"MsoNormal"><span lang=3D"EN-US" style=3D"color:rgb(31,73,125)">=
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 @QuerySq=
lField.Group(</span><span lang=3D"EN-US"><u></u><u></u></span></p>
<p class=3D"MsoNormal"><span lang=3D"EN-US" style=3D"color:rgb(31,73,125)">=
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=
=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 name=3D&quot;oId_fNum_ msg &quot;, =
order=3D2, descending =3D true),</span><span lang=3D"EN-US"><u></u><u></u><=
/span></p>
<p class=3D"MsoNormal"><span lang=3D"EN-US" style=3D"color:rgb(31,73,125)">=
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 @QuerySq=
lField.Group(</span><span lang=3D"EN-US"><u></u><u></u></span></p>
<p class=3D"MsoNormal"><span lang=3D"EN-US" style=3D"color:rgb(31,73,125)">=
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=
=A0=C2=A0=C2=A0=C2=A0 =C2=A0=C2=A0=C2=A0name=3D&quot;oId_fNum_ num &quot;, =
order=3D2, descending =3D true),=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0
</span><span lang=3D"EN-US"><u></u><u></u></span></p>
<p class=3D"MsoNormal"><span lang=3D"EN-US" style=3D"color:rgb(31,73,125)">=
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0@Qu=
erySqlField.Group(</span><span lang=3D"EN-US"><u></u><u></u></span></p>
<p class=3D"MsoNormal"><span lang=3D"EN-US" style=3D"color:rgb(31,73,125)">=
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=
=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 name=3D&quot;oId_fNum_ date &quot;,=
 order=3D2, descending =3D true)</span><span lang=3D"EN-US"><u></u><u></u><=
/span></p>
<p class=3D"MsoNormal"><span lang=3D"EN-US" style=3D"color:rgb(31,73,125)">=
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0
</span><span lang=3D"EN-US"><u></u><u></u></span></p>
<p class=3D"MsoNormal" style=3D"text-indent:21pt">
<span lang=3D"EN-US" style=3D"color:rgb(31,73,125)">})=C2=A0=C2=A0=C2=A0 </=
span><span lang=3D"EN-US"><u></u><u></u></span></p>
<p class=3D"MsoNormal"><span lang=3D"EN-US" style=3D"color:rgb(31,73,125)">=
=C2=A0=C2=A0=C2=A0 private int fNum;</span><span lang=3D"EN-US"><u></u><u><=
/u></span></p>
<p class=3D"MsoNormal"><span lang=3D"EN-US" style=3D"color:rgb(31,73,125)">=
=C2=A0=C2=A0=C2=A0
</span><span lang=3D"EN-US"><u></u><u></u></span></p>
<p class=3D"MsoNormal"><span lang=3D"EN-US" style=3D"color:rgb(31,73,125)">=
=C2=A0=C2=A0=C2=A0=C2=A0@QuerySqlField(index=3Dtrue, @QuerySqlField.Group(<=
/span><span lang=3D"EN-US"><u></u><u></u></span></p>
<p class=3D"MsoNormal"><span lang=3D"EN-US" style=3D"color:rgb(31,73,125)">=
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=
=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 name=3D&quot;oId_fNum_ msg &quot;, =
order=3D3, descending =3D true)})</span><span lang=3D"EN-US"><u></u><u></u>=
</span></p>
<p class=3D"MsoNormal"><span lang=3D"EN-US" style=3D"color:rgb(31,73,125)">=
=C2=A0=C2=A0=C2=A0 private String msg;</span><span lang=3D"EN-US"><u></u><u=
></u></span></p>
<p class=3D"MsoNormal"><span lang=3D"EN-US" style=3D"color:rgb(31,73,125)">=
=C2=A0=C2=A0=C2=A0
</span><span lang=3D"EN-US"><u></u><u></u></span></p>
<p class=3D"MsoNormal"><span lang=3D"EN-US" style=3D"color:rgb(31,73,125)">=
=C2=A0=C2=A0=C2=A0=C2=A0@QuerySqlField(index=3Dtrue, @QuerySqlField.Group(<=
/span><span lang=3D"EN-US"><u></u><u></u></span></p>
<p class=3D"MsoNormal"><span lang=3D"EN-US" style=3D"color:rgb(31,73,125)">=
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=
=A0=C2=A0=C2=A0=C2=A0 =C2=A0=C2=A0=C2=A0name=3D&quot;oId_fNum_ num &quot;, =
order=3D3, descending =3D true)})</span><span lang=3D"EN-US"><u></u><u></u>=
</span></p>
<p class=3D"MsoNormal"><span lang=3D"EN-US" style=3D"color:rgb(31,73,125)">=
=C2=A0=C2=A0=C2=A0 private BigDecimal num;</span><span lang=3D"EN-US"><u></=
u><u></u></span></p>
<p class=3D"MsoNormal"><span lang=3D"EN-US" style=3D"color:rgb(31,73,125)">=
=C2=A0=C2=A0=C2=A0
</span><span lang=3D"EN-US"><u></u><u></u></span></p>
<p class=3D"MsoNormal"><span lang=3D"EN-US" style=3D"color:rgb(31,73,125)">=
=C2=A0=C2=A0=C2=A0=C2=A0@QuerySqlField(index=3Dtrue, @QuerySqlField.Group(<=
/span><span lang=3D"EN-US"><u></u><u></u></span></p>
<p class=3D"MsoNormal"><span lang=3D"EN-US" style=3D"color:rgb(31,73,125)">=
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=
=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 name=3D&quot;oId_fNum_ date &quot;,=
 order=3D3, descending =3D true)})</span><span lang=3D"EN-US"><u></u><u></u=
></span></p>
<p class=3D"MsoNormal"><span lang=3D"EN-US" style=3D"color:rgb(31,73,125)">=
=C2=A0=C2=A0=C2=A0 private Date date;</span><span lang=3D"EN-US"><u></u><u>=
</u></span></p>
<p class=3D"MsoNormal"><span lang=3D"EN-US" style=3D"color:rgb(31,73,125)">=
=C2=A0=C2=A0=C2=A0
</span><span lang=3D"EN-US"><u></u><u></u></span></p>
<p class=3D"MsoNormal"><span lang=3D"EN-US" style=3D"color:rgb(31,73,125)">=
=C2=A0=C2=A0=C2=A0=C2=A0public UniqueField(){};</span><span lang=3D"EN-US">=
<u></u><u></u></span></p>
<p class=3D"MsoNormal"><span lang=3D"EN-US" style=3D"color:rgb(31,73,125)">=
=C2=A0=C2=A0=C2=A0
</span><span lang=3D"EN-US"><u></u><u></u></span></p>
<p class=3D"MsoNormal"><span lang=3D"EN-US" style=3D"color:rgb(31,73,125)">=
=C2=A0=C2=A0=C2=A0=C2=A0public UniqueField(</span><span lang=3D"EN-US"><u><=
/u><u></u></span></p>
<p class=3D"MsoNormal"><span lang=3D"EN-US" style=3D"color:rgb(31,73,125)">=
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 String o=
rgId,</span><span lang=3D"EN-US"><u></u><u></u></span></p>
<p class=3D"MsoNormal"><span lang=3D"EN-US" style=3D"color:rgb(31,73,125)">=
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 String o=
Id,</span><span lang=3D"EN-US"><u></u><u></u></span></p>
<p class=3D"MsoNormal"><span lang=3D"EN-US" style=3D"color:rgb(31,73,125)">=
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 String g=
Id,</span><span lang=3D"EN-US"><u></u><u></u></span></p>
<p class=3D"MsoNormal"><span lang=3D"EN-US" style=3D"color:rgb(31,73,125)">=
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 int fNum=
,</span><span lang=3D"EN-US"><u></u><u></u></span></p>
<p class=3D"MsoNormal"><span lang=3D"EN-US" style=3D"color:rgb(31,73,125)">=
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 String m=
sg,</span><span lang=3D"EN-US"><u></u><u></u></span></p>
<p class=3D"MsoNormal"><span lang=3D"EN-US" style=3D"color:rgb(31,73,125)">=
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 BigDecim=
al num,</span><span lang=3D"EN-US"><u></u><u></u></span></p>
<p class=3D"MsoNormal"><span lang=3D"EN-US" style=3D"color:rgb(31,73,125)">=
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 Date dat=
e</span><span lang=3D"EN-US"><u></u><u></u></span></p>
<p class=3D"MsoNormal"><span lang=3D"EN-US" style=3D"color:rgb(31,73,125)">=
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 ){</span=
><span lang=3D"EN-US"><u></u><u></u></span></p>
<p class=3D"MsoNormal"><span lang=3D"EN-US" style=3D"color:rgb(31,73,125)">=
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 this.orgId=3DorgId;</span><span =
lang=3D"EN-US"><u></u><u></u></span></p>
<p class=3D"MsoNormal"><span lang=3D"EN-US" style=3D"color:rgb(31,73,125)">=
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 this.oId=3DoId;</span><span lang=
=3D"EN-US"><u></u><u></u></span></p>
<p class=3D"MsoNormal"><span lang=3D"EN-US" style=3D"color:rgb(31,73,125)">=
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 this.gId =3D gId;</span><span la=
ng=3D"EN-US"><u></u><u></u></span></p>
<p class=3D"MsoNormal"><span lang=3D"EN-US" style=3D"color:rgb(31,73,125)">=
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 this.fNum =3D fNum;</span><span =
lang=3D"EN-US"><u></u><u></u></span></p>
<p class=3D"MsoNormal"><span lang=3D"EN-US" style=3D"color:rgb(31,73,125)">=
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 this.msg =3D msg;</span><span la=
ng=3D"EN-US"><u></u><u></u></span></p>
<p class=3D"MsoNormal"><span lang=3D"EN-US" style=3D"color:rgb(31,73,125)">=
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 this.num =3D num;</span><span la=
ng=3D"EN-US"><u></u><u></u></span></p>
<p class=3D"MsoNormal"><span lang=3D"EN-US" style=3D"color:rgb(31,73,125)">=
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 this.date =3D date;=C2=A0=C2=A0=
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0
</span><span lang=3D"EN-US"><u></u><u></u></span></p>
<p class=3D"MsoNormal"><span lang=3D"EN-US" style=3D"color:rgb(31,73,125)">=
=C2=A0=C2=A0=C2=A0=C2=A0}</span><span lang=3D"EN-US"><u></u><u></u></span><=
/p>
<p class=3D"MsoNormal"><span lang=3D"EN-US" style=3D"color:rgb(31,73,125)">=
=C2=A0=C2=A0=C2=A0
</span><span lang=3D"EN-US"><u></u><u></u></span></p>
<p class=3D"MsoNormal"><span lang=3D"EN-US" style=3D"color:rgb(31,73,125)">=
=C2=A0=C2=A0=C2=A0=C2=A0public String getOrgId()</span><span lang=3D"EN-US"=
><u></u><u></u></span></p>
<p class=3D"MsoNormal"><span lang=3D"EN-US" style=3D"color:rgb(31,73,125)">=
=C2=A0=C2=A0=C2=A0 {</span><span lang=3D"EN-US"><u></u><u></u></span></p>
<p class=3D"MsoNormal"><span lang=3D"EN-US" style=3D"color:rgb(31,73,125)">=
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 return orgId;</span><span lang=
=3D"EN-US"><u></u><u></u></span></p>
<p class=3D"MsoNormal"><span lang=3D"EN-US" style=3D"color:rgb(31,73,125)">=
=C2=A0=C2=A0=C2=A0 }</span><span lang=3D"EN-US"><u></u><u></u></span></p>
<p class=3D"MsoNormal"><span lang=3D"EN-US" style=3D"color:rgb(31,73,125)">=
=C2=A0</span><span lang=3D"EN-US"><u></u><u></u></span></p>
<p class=3D"MsoNormal"><span lang=3D"EN-US" style=3D"color:rgb(31,73,125)">=
=C2=A0=C2=A0=C2=A0 public void setOrgId(String orgId)</span><span lang=3D"E=
N-US"><u></u><u></u></span></p>
<p class=3D"MsoNormal"><span lang=3D"EN-US" style=3D"color:rgb(31,73,125)">=
=C2=A0=C2=A0=C2=A0 {</span><span lang=3D"EN-US"><u></u><u></u></span></p>
<p class=3D"MsoNormal"><span lang=3D"EN-US" style=3D"color:rgb(31,73,125)">=
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 this.orgId =3D orgId;</span><spa=
n lang=3D"EN-US"><u></u><u></u></span></p>
<p class=3D"MsoNormal"><span lang=3D"EN-US" style=3D"color:rgb(31,73,125)">=
=C2=A0=C2=A0=C2=A0 }</span><span lang=3D"EN-US"><u></u><u></u></span></p>
<p class=3D"MsoNormal"><span lang=3D"EN-US" style=3D"color:rgb(31,73,125)">=
=C2=A0</span><span lang=3D"EN-US"><u></u><u></u></span></p>
<p class=3D"MsoNormal"><span lang=3D"EN-US" style=3D"color:rgb(31,73,125)">=
=C2=A0=C2=A0=C2=A0 public String getOId()</span><span lang=3D"EN-US"><u></u=
><u></u></span></p>
<p class=3D"MsoNormal"><span lang=3D"EN-US" style=3D"color:rgb(31,73,125)">=
=C2=A0=C2=A0=C2=A0 {</span><span lang=3D"EN-US"><u></u><u></u></span></p>
<p class=3D"MsoNormal"><span lang=3D"EN-US" style=3D"color:rgb(31,73,125)">=
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 return oId;</span><span lang=3D"=
EN-US"><u></u><u></u></span></p>
<p class=3D"MsoNormal"><span lang=3D"EN-US" style=3D"color:rgb(31,73,125)">=
=C2=A0=C2=A0=C2=A0 }</span><span lang=3D"EN-US"><u></u><u></u></span></p>
<p class=3D"MsoNormal"><span lang=3D"EN-US" style=3D"color:rgb(31,73,125)">=
=C2=A0</span><span lang=3D"EN-US"><u></u><u></u></span></p>
<p class=3D"MsoNormal"><span lang=3D"EN-US" style=3D"color:rgb(31,73,125)">=
=C2=A0=C2=A0=C2=A0 public void setOId(String oId)</span><span lang=3D"EN-US=
"><u></u><u></u></span></p>
<p class=3D"MsoNormal"><span lang=3D"EN-US" style=3D"color:rgb(31,73,125)">=
=C2=A0=C2=A0=C2=A0 {</span><span lang=3D"EN-US"><u></u><u></u></span></p>
<p class=3D"MsoNormal"><span lang=3D"EN-US" style=3D"color:rgb(31,73,125)">=
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 this.oId =3D oId;</span><span la=
ng=3D"EN-US"><u></u><u></u></span></p>
<p class=3D"MsoNormal"><span lang=3D"EN-US" style=3D"color:rgb(31,73,125)">=
=C2=A0=C2=A0=C2=A0 }</span><span lang=3D"EN-US"><u></u><u></u></span></p>
<p class=3D"MsoNormal"><span lang=3D"EN-US" style=3D"color:rgb(31,73,125)">=
=C2=A0</span><span lang=3D"EN-US"><u></u><u></u></span></p>
<p class=3D"MsoNormal"><span lang=3D"EN-US" style=3D"color:rgb(31,73,125)">=
=C2=A0=C2=A0=C2=A0 public String getGid()</span><span lang=3D"EN-US"><u></u=
><u></u></span></p>
<p class=3D"MsoNormal"><span lang=3D"EN-US" style=3D"color:rgb(31,73,125)">=
=C2=A0=C2=A0=C2=A0 {</span><span lang=3D"EN-US"><u></u><u></u></span></p>
<p class=3D"MsoNormal"><span lang=3D"EN-US" style=3D"color:rgb(31,73,125)">=
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 return gId;</span><span lang=3D"=
EN-US"><u></u><u></u></span></p>
<p class=3D"MsoNormal"><span lang=3D"EN-US" style=3D"color:rgb(31,73,125)">=
=C2=A0=C2=A0=C2=A0 }</span><span lang=3D"EN-US"><u></u><u></u></span></p>
<p class=3D"MsoNormal"><span lang=3D"EN-US" style=3D"color:rgb(31,73,125)">=
=C2=A0</span><span lang=3D"EN-US"><u></u><u></u></span></p>
<p class=3D"MsoNormal"><span lang=3D"EN-US" style=3D"color:rgb(31,73,125)">=
=C2=A0=C2=A0=C2=A0 public void setGuid(String gId)</span><span lang=3D"EN-U=
S"><u></u><u></u></span></p>
<p class=3D"MsoNormal"><span lang=3D"EN-US" style=3D"color:rgb(31,73,125)">=
=C2=A0=C2=A0=C2=A0 {</span><span lang=3D"EN-US"><u></u><u></u></span></p>
<p class=3D"MsoNormal"><span lang=3D"EN-US" style=3D"color:rgb(31,73,125)">=
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 this.gId =3D gId;</span><span la=
ng=3D"EN-US"><u></u><u></u></span></p>
<p class=3D"MsoNormal"><span lang=3D"EN-US" style=3D"color:rgb(31,73,125)">=
=C2=A0=C2=A0=C2=A0 }</span><span lang=3D"EN-US"><u></u><u></u></span></p>
<p class=3D"MsoNormal"><span lang=3D"EN-US" style=3D"color:rgb(31,73,125)">=
=C2=A0</span><span lang=3D"EN-US"><u></u><u></u></span></p>
<p class=3D"MsoNormal"><span lang=3D"EN-US" style=3D"color:rgb(31,73,125)">=
=C2=A0=C2=A0=C2=A0 public int getFNum()</span><span lang=3D"EN-US"><u></u><=
u></u></span></p>
<p class=3D"MsoNormal"><span lang=3D"EN-US" style=3D"color:rgb(31,73,125)">=
=C2=A0=C2=A0=C2=A0 {</span><span lang=3D"EN-US"><u></u><u></u></span></p>
<p class=3D"MsoNormal"><span lang=3D"EN-US" style=3D"color:rgb(31,73,125)">=
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 return fNum;</span><span lang=3D=
"EN-US"><u></u><u></u></span></p>
<p class=3D"MsoNormal"><span lang=3D"EN-US" style=3D"color:rgb(31,73,125)">=
=C2=A0=C2=A0=C2=A0 }</span><span lang=3D"EN-US"><u></u><u></u></span></p>
<p class=3D"MsoNormal"><span lang=3D"EN-US" style=3D"color:rgb(31,73,125)">=
=C2=A0</span><span lang=3D"EN-US"><u></u><u></u></span></p>
<p class=3D"MsoNormal"><span lang=3D"EN-US" style=3D"color:rgb(31,73,125)">=
=C2=A0=C2=A0=C2=A0 public void setFNum(int fNum)</span><span lang=3D"EN-US"=
><u></u><u></u></span></p>
<p class=3D"MsoNormal"><span lang=3D"EN-US" style=3D"color:rgb(31,73,125)">=
=C2=A0=C2=A0=C2=A0 {</span><span lang=3D"EN-US"><u></u><u></u></span></p>
<p class=3D"MsoNormal"><span lang=3D"EN-US" style=3D"color:rgb(31,73,125)">=
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 this.fNum =3D fNum;</span><span =
lang=3D"EN-US"><u></u><u></u></span></p>
<p class=3D"MsoNormal"><span lang=3D"EN-US" style=3D"color:rgb(31,73,125)">=
=C2=A0=C2=A0=C2=A0 }</span><span lang=3D"EN-US"><u></u><u></u></span></p>
<p class=3D"MsoNormal"><span lang=3D"EN-US" style=3D"color:rgb(31,73,125)">=
=C2=A0</span><span lang=3D"EN-US"><u></u><u></u></span></p>
<p class=3D"MsoNormal"><span lang=3D"EN-US" style=3D"color:rgb(31,73,125)">=
=C2=A0=C2=A0=C2=A0 public String getMsg()</span><span lang=3D"EN-US"><u></u=
><u></u></span></p>
<p class=3D"MsoNormal"><span lang=3D"EN-US" style=3D"color:rgb(31,73,125)">=
=C2=A0=C2=A0=C2=A0 {</span><span lang=3D"EN-US"><u></u><u></u></span></p>
<p class=3D"MsoNormal"><span lang=3D"EN-US" style=3D"color:rgb(31,73,125)">=
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 return msg;</span><span lang=3D"=
EN-US"><u></u><u></u></span></p>
<p class=3D"MsoNormal"><span lang=3D"EN-US" style=3D"color:rgb(31,73,125)">=
=C2=A0=C2=A0=C2=A0 }</span><span lang=3D"EN-US"><u></u><u></u></span></p>
<p class=3D"MsoNormal"><span lang=3D"EN-US" style=3D"color:rgb(31,73,125)">=
=C2=A0</span><span lang=3D"EN-US"><u></u><u></u></span></p>
<p class=3D"MsoNormal"><span lang=3D"EN-US" style=3D"color:rgb(31,73,125)">=
=C2=A0=C2=A0=C2=A0 public void setMsg(String msg)</span><span lang=3D"EN-US=
"><u></u><u></u></span></p>
<p class=3D"MsoNormal"><span lang=3D"EN-US" style=3D"color:rgb(31,73,125)">=
=C2=A0=C2=A0=C2=A0 {</span><span lang=3D"EN-US"><u></u><u></u></span></p>
<p class=3D"MsoNormal"><span lang=3D"EN-US" style=3D"color:rgb(31,73,125)">=
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 this.msg =3D msg;</span><span la=
ng=3D"EN-US"><u></u><u></u></span></p>
<p class=3D"MsoNormal"><span lang=3D"EN-US" style=3D"color:rgb(31,73,125)">=
=C2=A0=C2=A0=C2=A0 }</span><span lang=3D"EN-US"><u></u><u></u></span></p>
<p class=3D"MsoNormal"><span lang=3D"EN-US" style=3D"color:rgb(31,73,125)">=
=C2=A0</span><span lang=3D"EN-US"><u></u><u></u></span></p>
<p class=3D"MsoNormal"><span lang=3D"EN-US" style=3D"color:rgb(31,73,125)">=
=C2=A0=C2=A0=C2=A0 public BigDecimal getNum()</span><span lang=3D"EN-US"><u=
></u><u></u></span></p>
<p class=3D"MsoNormal"><span lang=3D"EN-US" style=3D"color:rgb(31,73,125)">=
=C2=A0=C2=A0=C2=A0 {</span><span lang=3D"EN-US"><u></u><u></u></span></p>
<p class=3D"MsoNormal"><span lang=3D"EN-US" style=3D"color:rgb(31,73,125)">=
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 return num;</span><span lang=3D"=
EN-US"><u></u><u></u></span></p>
<p class=3D"MsoNormal"><span lang=3D"EN-US" style=3D"color:rgb(31,73,125)">=
=C2=A0=C2=A0=C2=A0 }</span><span lang=3D"EN-US"><u></u><u></u></span></p>
<p class=3D"MsoNormal"><span lang=3D"EN-US" style=3D"color:rgb(31,73,125)">=
=C2=A0</span><span lang=3D"EN-US"><u></u><u></u></span></p>
<p class=3D"MsoNormal"><span lang=3D"EN-US" style=3D"color:rgb(31,73,125)">=
=C2=A0=C2=A0=C2=A0 public void setNum(BigDecimal num)</span><span lang=3D"E=
N-US"><u></u><u></u></span></p>
<p class=3D"MsoNormal"><span lang=3D"EN-US" style=3D"color:rgb(31,73,125)">=
=C2=A0=C2=A0=C2=A0 {</span><span lang=3D"EN-US"><u></u><u></u></span></p>
<p class=3D"MsoNormal"><span lang=3D"EN-US" style=3D"color:rgb(31,73,125)">=
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 this.num =3D num;</span><span la=
ng=3D"EN-US"><u></u><u></u></span></p>
<p class=3D"MsoNormal"><span lang=3D"EN-US" style=3D"color:rgb(31,73,125)">=
=C2=A0=C2=A0=C2=A0 }</span><span lang=3D"EN-US"><u></u><u></u></span></p>
<p class=3D"MsoNormal"><span lang=3D"EN-US" style=3D"color:rgb(31,73,125)">=
=C2=A0</span><span lang=3D"EN-US"><u></u><u></u></span></p>
<p class=3D"MsoNormal"><span lang=3D"EN-US" style=3D"color:rgb(31,73,125)">=
=C2=A0=C2=A0=C2=A0 public Date getDate()</span><span lang=3D"EN-US"><u></u>=
<u></u></span></p>
<p class=3D"MsoNormal"><span lang=3D"EN-US" style=3D"color:rgb(31,73,125)">=
=C2=A0=C2=A0=C2=A0 {</span><span lang=3D"EN-US"><u></u><u></u></span></p>
<p class=3D"MsoNormal"><span lang=3D"EN-US" style=3D"color:rgb(31,73,125)">=
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 return date;</span><span lang=3D=
"EN-US"><u></u><u></u></span></p>
<p class=3D"MsoNormal"><span lang=3D"EN-US" style=3D"color:rgb(31,73,125)">=
=C2=A0=C2=A0=C2=A0 }</span><span lang=3D"EN-US"><u></u><u></u></span></p>
<p class=3D"MsoNormal"><span lang=3D"EN-US" style=3D"color:rgb(31,73,125)">=
=C2=A0</span><span lang=3D"EN-US"><u></u><u></u></span></p>
<p class=3D"MsoNormal"><span lang=3D"EN-US" style=3D"color:rgb(31,73,125)">=
=C2=A0=C2=A0=C2=A0 public void setDate(Date date)</span><span lang=3D"EN-US=
"><u></u><u></u></span></p>
<p class=3D"MsoNormal"><span lang=3D"EN-US" style=3D"color:rgb(31,73,125)">=
=C2=A0=C2=A0=C2=A0 {</span><span lang=3D"EN-US"><u></u><u></u></span></p>
<p class=3D"MsoNormal"><span lang=3D"EN-US" style=3D"color:rgb(31,73,125)">=
=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 this.date =3D date;</span><span =
lang=3D"EN-US"><u></u><u></u></span></p>
<p class=3D"MsoNormal"><span lang=3D"EN-US" style=3D"color:rgb(31,73,125)">=
=C2=A0=C2=A0=C2=A0 }</span><span lang=3D"EN-US"><u></u><u></u></span></p>
<p class=3D"MsoNormal"><span lang=3D"EN-US" style=3D"color:rgb(31,73,125)">=
=C2=A0</span><span lang=3D"EN-US"><u></u><u></u></span></p>
<p class=3D"MsoNormal"><span lang=3D"EN-US" style=3D"color:rgb(31,73,125)">=
}</span><span lang=3D"EN-US"><u></u><u></u></span></p>
<p class=3D"MsoNormal"><span lang=3D"EN-US" style=3D"color:rgb(31,73,125)">=
=C2=A0</span><span lang=3D"EN-US"><u></u><u></u></span></p>
<p class=3D"MsoNormal"><span lang=3D"EN-US">=C2=A0<u></u><u></u></span></p>
<p class=3D"MsoNormal"><span lang=3D"EN-US">=C2=A0<u></u><u></u></span></p>
<p class=3D"MsoNormal"><span lang=3D"EN-US">=C2=A0<u></u><u></u></span></p>
</div>
</div>
</div>
<p class=3D"MsoNormal"><span lang=3D"EN-US"><br>
<br clear=3D"all">
<u></u><u></u></span></p>
<div>
<p class=3D"MsoNormal"><span lang=3D"EN-US"><u></u>=C2=A0<u></u></span></p>
</div>
<p class=3D"MsoNormal"><span lang=3D"EN-US">-- <u></u><u></u></span></p>
<div>
<div>
<div>
<div>
<div>
<div>
<p class=3D"MsoNormal"><span lang=3D"EN-US"><br>
Best regards,<u></u><u></u></span></p>
</div>
<div>
<p class=3D"MsoNormal"><span lang=3D"EN-US">Alexei Scherbakov<u></u><u></u>=
</span></p>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div></div></div>
</div>

</blockquote></div><br><br clear=3D"all"><div><br></div>-- <br><div data-sm=
artmail=3D"gmail_signature"><div dir=3D"ltr"><div><div dir=3D"ltr"><div dir=
=3D"ltr"></div><div><div dir=3D"ltr"><br>Best regards,<br></div><div>Alexei=
 Scherbakov<br></div></div></div></div></div></div>
</div></div>

--94eb2c048d2427a49f0536fa7e41--