ASF GitHub Bot commented on IGNITE-3448:

GitHub user AMashenkov opened a pull request:


    IGNITE-3448: Wrong count returned by count distinct and similar queries.


You can merge this pull request into a Git repository by running:

    $ git pull https://github.com/gridgain/apache-ignite ignite-3448

Alternatively you can review and apply these changes as the patch at:


To close this pull request, make a commit to your master/trunk branch
with (at least) the following in the commit message:

    This closes #1171
commit 6b8020d3ffef55039d0afa55ed5925d9fdb914d2
Author: Sergi Vladykin <se...@vladykin.com>
Date:   2016-07-13T17:19:25Z

    ignite-3254 - fixed
    (cherry picked from commit 4d2be72)

commit 11c7e8fe53461f84924e5c29893865191f236c8c
Author: Anton Vinogradov <a...@apache.org>
Date:   2016-07-20T08:31:14Z

    Documentation fix

commit 9b55658749d0e2a869bbb3614034d8aa1f0e95c1
Author: vozerov-gridgain <voze...@gridgain.com>
Date:   2016-07-20T11:14:50Z

    IGNITE-3405: IGFS: Restricted path modes interleaving, so that now only 
DUAL -> PRIMARY and DUAL -> PROXY paths are possible.

commit 6c5218f4d67c8e247f59dbe8deb58b51db2954a2
Author: vozerov-gridgain <voze...@gridgain.com>
Date:   2016-07-20T11:15:11Z

    Merge remote-tracking branch 'upstream/gridgain-7.6.2' into gridgain-7.6.2

commit 0f1a0ccdbfc44658ee76024fc06ca39d81efc0a8
Author: Denis Magda <dma...@gridgain.com>
Date:   2016-07-22T11:19:03Z

    IGNITE-3505: BinaryObject keys can't be reused because of partition caching.

commit ce53491daa67639397582ab8ba53e15195af9cdb
Author: Pavel Tupitsyn <ptupit...@apache.org>
Date:   2016-07-22T12:13:42Z

    IGNITE-3512: .NET: Fixed a bug in BinaryBuilder causing type name to be 

commit 7fb03c7ca0e4f64ff1629404f0b34d3d7a6e2bf1
Author: Alexandre Boudnik <alexandre_boud...@epam.com>
Date:   2016-07-22T15:40:47Z

     IGNITE-3389 metadata result set throws NPE when closed - fixed

commit 3aaef96a5d2754613c8f7d24ff3045c258fad7d3
Author: Andrey Novikov <anovi...@gridgain.com>
Date:   2016-07-22T11:03:50Z

    IGNITE-3446 Visor CMD: improve usability for batch mode.
    (cherry picked from commit 71ef652)

commit c075ab33254b7178c6e6b0a7b16801e787189ced
Author: vozerov-gridgain <voze...@gridgain.com>
Date:   2016-07-25T05:54:05Z

    IGNITE-3530: IGFS: Added missing "setTimes" method to 

commit 9ecccc7c559342fcc6b67457f7456d6af2c084d8
Author: Alexandre Boudnik <alexandre_boud...@epam.com>
Date:   2016-07-22T15:40:47Z

     IGNITE-3389 metadata result set throws NPE when closed - fixed

commit fd50502a95f23c5a664c0e5e43f42a9709a0eef8
Author: Andrey Novikov <anovi...@apache.org>
Date:   2016-07-25T10:53:41Z

    Merge branches 'gridgain-7.6.2' and 'ignite-1.6.3' of 
https://github.com/gridgain/apache-ignite into ignite-1.6.3

commit 6917ec403816416a6cbc7eb0a5a3696b692059e0
Author: Pavel Tupitsyn <ptupit...@apache.org>
Date:   2016-07-25T13:12:51Z

    IGNITE-3504 .NET: Fix IBinaryObjectBuilder setter methods

commit ac31334b1072a810bc7f8e0e782ec6e84a9edd66
Author: dkarachentsev <dkarachent...@gridgain.com>
Date:   2016-07-26T09:54:32Z

    IGNITE-3569 - Set copyOnRead property to FALSE for marshaller cache.

commit 14e33530de4a17f35f6aa665676c36db598937ef
Author: EdShangGG <eshangar...@gridgain.com>
Date:   2016-07-26T09:46:05Z

    IGNITE-3476 Node started within SpringCacheManager does not inject Spring 
    (cherry picked from commit a39770a)

commit f3e4f78fc96c98f4376ff86ab3e76ba54d6b09a4
Author: sboikov <sboi...@gridgain.com>
Date:   2016-07-26T12:48:36Z

    Print debug information on 'waitForRent' timeout.
    (cherry picked from commit 7cf26d9)

commit 9d07e3e7a34d1cbe67a9656630bc6215cd213f0a
Author: sboikov <sboi...@gridgain.com>
Date:   2016-07-27T06:19:12Z

    ignite-3300 Fixed issue with partition value changing stored in 
    (cherry picked from commit a441bb9)

commit 4979c870735698dc51ce2c0db350a0f35c9b8b0e
Author: Andrey Novikov <anovi...@apache.org>
Date:   2016-07-27T09:12:39Z

    Collector task do not honor node filters for caches and IGFS.

commit 7b3d1963cb7240ce3f59f5c9f81965bf5730bad0
Author: Alexey Kuznetsov <akuznet...@apache.org>
Date:   2016-07-29T09:03:20Z

    Fixed compatibility.

commit 4f27a47b81314b2eb52a5bc5b1d938bb586ae2aa
Author: EdShangGG <eshangar...@gridgain.com>
Date:   2016-08-01T17:25:54Z

    IGNITE-3513 Cleanup worker is placed in the Thread's waiting queue using 
Thread.sleep method

commit ae23dab0af8caaccd3db1dca8e435b57b8844a31
Author: Alexey Kuznetsov <akuznet...@apache.org>
Date:   2016-08-03T10:10:03Z

    Visor: scan cache with filter.

commit a90d05b30f39da001156fdd4053790f8cd352406
Author: Valentin Kulichenko <valentin.luliche...@gmail.com>
Date:   2016-08-04T05:00:15Z

    IGNITE-3408 - Provided basic implementation of AddressResolver

commit d945a5dd89b01f05a59e2b02fb86c1007736aff9
Author: Ignite Teamcity <ign...@apache.org>
Date:   2016-08-04T15:37:37Z

    version changed to: 1.6.4

commit 00f47d78216db5de75dda2a1b5fef2c1e65d9871
Author: Valentin Kulichenko <valentin.luliche...@gmail.com>
Date:   2016-08-06T01:04:01Z

    IGNITE-3634 - SpringCacheManager should support null values

commit 018001011daff723d120834da7b4f57bad7f8f71
Author: tledkov-gridgain <tled...@gridgain.com>
Date:   2016-05-27T12:16:27Z

    IGNITE-2310 Lock cache partition for affinityRun/affinityCall execution

commit b9d9d84f4fcaf7f025b480769b612fc63b5082f4
Author: vozerov-gridgain <voze...@gridgain.com>
Date:   2016-08-09T11:04:47Z

    IGNITE-3659: Added special test suite to handle ignored tests.

commit e23aba4b060a9dfbee20384550a49274a479ac00
Author: vozerov-gridgain <voze...@gridgain.com>
Date:   2016-08-09T11:05:17Z

    Merge remote-tracking branch 'upstream/ignite-1.6.5' into ignite-1.6.5

commit d1a3904c8c8ed4a6cf750a2caa4e2e06cc471698
Author: tledkov-gridgain <tled...@gridgain.com>
Date:   2016-08-09T13:23:34Z

    IGNITE-2310 Lock cache partition for affinityRun/affinityCall execution -  
add javadoc for test

commit e1262b2f2f4fb57fa8a75f6008f9e005ad07b5df
Author: Valentin Kulichenko <valentin.luliche...@gmail.com>
Date:   2016-08-09T22:56:49Z

    Fixed copy constructor in ConnectorConfiguration

commit 151dfa7878d7d013cd93fac9d627bbdeb1ef8e18
Author: vozerov-gridgain <voze...@gridgain.com>
Date:   2016-08-10T06:48:29Z

    Revert "version changed to: 1.6.4"
    This reverts commit d945a5dd89b01f05a59e2b02fb86c1007736aff9.

commit ff3e00caa892a7399622711b620fcb4dcfbbfb56
Author: nikolay_tikhonov <ntikho...@gridgain.com>
Date:   2016-08-10T13:21:52Z

    IGNITE-3272 Fixed "Memory consumption in ContinuousQueryHandler". This 
close #930.


> Wrong count returned by count distinct and similar queries.
> -----------------------------------------------------------
>                 Key: IGNITE-3448
>                 URL: https://issues.apache.org/jira/browse/IGNITE-3448
>             Project: Ignite
>          Issue Type: Bug
>          Components: SQL
>    Affects Versions: 1.7
>            Reporter: Alexei Scherbakov
>            Assignee: Andrew Mashenkov
>             Fix For: 1.8
> Partitioned cache is deployed on 3 nodes.
> The code below outputs incorrect counts: 
> 14
> 14
> {code}
>        IgniteCache<Integer, Value> cache = grid(0).cache(null);
>         cache.put(0, new Value("v1"));
>         cache.put(3, new Value("v1"));
>         cache.put(5, new Value("v1"));
>         cache.put(9, new Value("v1"));
>         cache.put(1, new Value("v3"));
>         cache.put(15, new Value("v3"));
>         cache.put(8, new Value("v3"));
>         cache.put(2, new Value("v5"));
>         cache.put(12, new Value("v5"));
>         cache.put(4, new Value("v2"));
>         cache.put(6, new Value("v2"));
>         cache.put(7, new Value("v6"));
>         cache.put(10, new Value("v7"));
>         cache.put(11, new Value("v8"));
>         cache.put(13, new Value("v4"));
>         cache.put(14, new Value("v4"));
>         QueryCursor<List<?>> qry = cache.query(new SqlFieldsQuery("select 
> count(distinct str) from Value"));
>         for (List<?> objects : qry)
>             System.out.println(objects.get(0));
>         qry = cache.query(new SqlFieldsQuery("select count(*) from (select 1 
> from Value group by str)"));
>         for (List<?> objects : qry)
>             System.out.println(objects.get(0));
> {code}

This message was sent by Atlassian JIRA

Reply via email to