You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@ignite.apache.org by "Ignite TC Bot (Jira)" <ji...@apache.org> on 2022/09/29 06:00:00 UTC

[jira] [Commented] (IGNITE-17027) Incorrect result of the DML delete operation, in some environment

    [ https://issues.apache.org/jira/browse/IGNITE-17027?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17610811#comment-17610811 ] 

Ignite TC Bot commented on IGNITE-17027:
----------------------------------------

{panel:title=Branch: [pull/10274/head] Base: [master] : No blockers found!|borderStyle=dashed|borderColor=#ccc|titleBGColor=#D6F7C1}{panel}
{panel:title=Branch: [pull/10274/head] Base: [master] : New Tests (2)|borderStyle=dashed|borderColor=#ccc|titleBGColor=#D6F7C1}
{color:#00008b}Queries 3{color} [[tests 1|https://ci2.ignite.apache.org/viewLog.html?buildId=6632835]]
* {color:#013220}IgniteBinaryCacheQueryTestSuite3: IndexColumnTypeMismatchTest.testIndexColTypeMismatch - PASSED{color}

{color:#00008b}Queries 3 (lazy=true){color} [[tests 1|https://ci2.ignite.apache.org/viewLog.html?buildId=6632836]]
* {color:#013220}IgniteBinaryCacheQueryLazyTestSuite3: IndexColumnTypeMismatchTest.testIndexColTypeMismatch - PASSED{color}

{panel}
[TeamCity *--&gt; Run :: All* Results|https://ci2.ignite.apache.org/viewLog.html?buildId=6632861&amp;buildTypeId=IgniteTests24Java8_RunAll]

>  Incorrect result of the DML delete operation, in some environment
> ------------------------------------------------------------------
>
>                 Key: IGNITE-17027
>                 URL: https://issues.apache.org/jira/browse/IGNITE-17027
>             Project: Ignite
>          Issue Type: Bug
>          Components: sql
>            Reporter: Luchnikov Alexander
>            Assignee: Aleksey Plekhanov
>            Priority: Minor
>              Labels: ise
>         Attachments: IndexSetArgsAndCastTest.patch
>
>          Time Spent: 10m
>  Remaining Estimate: 0h
>
> Description of the case, in some environment, the DML operation does not delete all data (this DML delete operation is an example). To reproduce the problem, you must:
> # Create a table with a varchar field.
> # Create an index on the given field.
> # Fill the table with data, use int as the value.
> # Delete data by specifying in the DML operation, as a condition, an indexed value, without String.valueOf(intValue)
> The reproducer( [^IndexSetArgsAndCastTest.patch] ) shows this behavior in indexOnAutocastOff() test.
> The result of all tests should be the same, specifically in this example (DML delete) - the number of entries in the cache, according to the result of each test, should be equal to zero.



--
This message was sent by Atlassian Jira
(v8.20.10#820010)