Stefan created IGNITE-11563: ------------------------------- Summary: DELETE WHERE does not work in prepared statements Key: IGNITE-11563 URL: https://issues.apache.org/jira/browse/IGNITE-11563 Project: Ignite Issue Type: Bug Components: sql Affects Versions: 2.7 Reporter: Stefan
With SQL I cannot delete a row using a prepared statement. The following statement is simply ignored: {{DELETE}} {{FROM}} {{AnyTable }}{{WHERE}} {{id = ?}} This happens with JDBC-Thin and with ODBC so I suspect that the cluster gets the correct data but handles it wrong. By adding an always-true-condition it works as expected: {{DELETE}} {{FROM}} {{AnyTable }}{{WHERE}} {{id = id }}{{AND}} {{id = ?}} I tested with a very simple table that was created with: {{CREATE TABLE testtable (}} {{ "ID" NUMBER(19,0),}} {{ "VALUE" VARCHAR2(255 CHAR),}} {{ PRIMARY KEY (ID)}} {{) WITH "template=replicated,cache_name=testtable"}} {{}} -- This message was sent by Atlassian JIRA (v7.6.3#76005)