You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@trafodion.apache.org by "Atanu Mishra (JIRA)" <ji...@apache.org> on 2015/08/14 01:20:48 UTC
[jira] [Closed] (TRAFODION-129) LP Bug: 1243975 - DELETE fails to
find records with VARCHAR column in the predicate
[ https://issues.apache.org/jira/browse/TRAFODION-129?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Atanu Mishra closed TRAFODION-129.
----------------------------------
Resolution: Fixed
Assignee: (was: Anoop Sharma)
Fix Version/s: 1.0 (pre-incubation)
> LP Bug: 1243975 - DELETE fails to find records with VARCHAR column in the predicate
> -----------------------------------------------------------------------------------
>
> Key: TRAFODION-129
> URL: https://issues.apache.org/jira/browse/TRAFODION-129
> Project: Apache Trafodion
> Issue Type: Bug
> Components: sql-general
> Reporter: Weishiun Tsai
> Priority: Critical
> Fix For: 1.0 (pre-incubation)
>
>
> The DELETE statement fails to find records with a VARCHAR column in the predicate while the SELECT statement finds them just fine with the same predicate, as shown in the following example:
> >>set schema seabase.phoenix;
> --- SQL operation complete.
> >>CREATE TABLE test_table (row1 varchar(128) not null, col1 integer, CONSTRAINT
> pk PRIMARY KEY (row1));
> --- SQL operation complete.
> >>UPSERT INTO test_table(row1, col1) VALUES('row1', 2);
> --- 1 row(s) inserted.
> >>SELECT * FROM test_table WHERE row1='row1';
> ROW1
> COL1
> --------------------------------------------------------------------------------
> ------------------------------------------------ -----------
> row1
> 2
> --- 1 row(s) selected.
> >>DELETE FROM test_table WHERE row1='row1';
> --- 0 row(s) deleted.
> >>SELECT * FROM test_table;
> ROW1
> COL1
> --------------------------------------------------------------------------------
> ------------------------------------------------ -----------
> row1
> 2
> --- 1 row(s) selected.
> >>
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)