You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@trafodion.apache.org by "ASF GitHub Bot (JIRA)" <ji...@apache.org> on 2018/06/07 08:13:00 UTC
[jira] [Commented] (TRAFODION-3099) Prepare execute fails to handle
N'', _iso88591'', _utf8'' for a nchar column
[ https://issues.apache.org/jira/browse/TRAFODION-3099?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16504389#comment-16504389 ]
ASF GitHub Bot commented on TRAFODION-3099:
-------------------------------------------
GitHub user gdgy opened a pull request:
https://github.com/apache/trafodion/pull/1595
TRAFODION-3099
You can merge this pull request into a Git repository by running:
$ git pull https://github.com/gdgy/trafodion TRAFODION-3099
Alternatively you can review and apply these changes as the patch at:
https://github.com/apache/trafodion/pull/1595.patch
To close this pull request, make a commit to your master/trunk branch
with (at least) the following in the commit message:
This closes #1595
----
commit 3bec830f9933a5a647afbc0f278e7dd39f8c0c34
Author: shaoyong.li <li...@...>
Date: 2018-06-07T08:08:57Z
TRAFODION-3099
----
> Prepare execute fails to handle N'<string>', _iso88591'<string>', _utf8'<string>' for a nchar column
> ----------------------------------------------------------------------------------------------------
>
> Key: TRAFODION-3099
> URL: https://issues.apache.org/jira/browse/TRAFODION-3099
> Project: Apache Trafodion
> Issue Type: Bug
> Reporter: shaoyong.li
> Assignee: shaoyong.li
> Priority: Major
>
> As shown below, for a nchar column c1 with a value of N'ABCD' in the table t, a direct select from t with predicates c1=N'ABCD', c1='ABCD', c1=_iso88591'ABCD', and c1=_utf8'ABCD' all are able to find the match. However, with a prepared query xx executed using a parameter ? in sqlci and trafci operator have failed.
> From sqlci:
> >>drop table if exists t;
>
> --- SQL operation complete.
> >>create table t (c1 nchar(10));
>
> --- SQL operation complete.
> >>insert into t values (N'ABCD');
>
> --- 1 row(s) inserted.
> >>select * from t;
>
> C1
> --------------------
>
> ABCD
>
> --- 1 row(s) selected.
> >>select * from t where c1=N'ABCD';
>
> C1
> --------------------
>
> ABCD
>
> --- 1 row(s) selected.
> >>select * from t where c1='ABCD';
>
> C1
> --------------------
>
> ABCD
>
> --- 1 row(s) selected.
> >>select * from t where c1=_iso88591'ABCD';
>
> C1
> --------------------
>
> ABCD
>
> --- 1 row(s) selected.
> >>select * from t where c1=_utf8'ABCD';
>
> C1
> --------------------
>
> ABCD
>
> --- 1 row(s) selected.
> >>
> >>prepare xx from select * from t where c1=?;
>
> --- SQL command prepared.
> >>execute xx using N'ABCD';
>
> --- 0 row(s) selected.
> >>execute xx using 'ABCD';
>
> C1
> --------------------
>
> ABCD
>
> --- 1 row(s) selected.
> >>execute xx using _iso88591'ABCD';
>
> C1
> --------------------
>
> ABCD
>
> --- 1 row(s) selected.
> >>execute xx using _utf8'ABCD';
>
> C1
> --------------------
>
> ABCD
>
> --- 1 row(s) selected.
>
> From trafci:
>
> trafci sees even more failures:
>
> $ trafci
>
> Welcome to EsgynDB Command Interface
> Copyright (c) 2015-2018 Esgyn Corporation
>
> User Name: db__root
> Host Name/IP Address: localhost:23400
>
> Connected to EsgynDB Advanced
>
> SQL>obey mytest.sql;
>
> SQL>drop table if exists t;
>
> --- SQL operation complete.
>
> SQL>create table t (c1 nchar(10));
>
> --- SQL operation complete.
>
> SQL>insert into t values (N'ABCD');
>
> --- 1 row(s) inserted.
>
> SQL>select * from t;
>
> C1
> --------------------
> ABCD
>
> --- 1 row(s) selected.
>
> SQL>select * from t where c1=N'ABCD';
>
> C1
> --------------------
> ABCD
>
> --- 1 row(s) selected.
>
> SQL>select * from t where c1='ABCD';
>
> C1
> --------------------
> ABCD
>
> --- 1 row(s) selected.
>
> SQL>select * from t where c1=_iso88591'ABCD';
>
> C1
> --------------------
> ABCD
>
> --- 1 row(s) selected.
>
> SQL>select * from t where c1=_utf8'ABCD';
>
> C1
> --------------------
> ABCD
>
> --- 1 row(s) selected.
>
> SQL>prepare xx from select * from t where c1=?;
>
> --- SQL command prepared.
>
> SQL>execute xx using N'ABCD';
>
> --- 0 row(s) selected.
>
> SQL>execute xx using 'ABCD';
>
> C1
> --------------------
> ABCD
>
> --- 1 row(s) selected.
>
> SQL>execute xx using _iso88591'ABCD';
>
> *** ERROR[29183] Invalid Parameter Value: CHAR input data is longer than the length for column: 0
>
> SQL>execute xx using _utf8'ABCD';
>
> *** ERROR[29183] Invalid Parameter Value: CHAR input data is longer than the length for column: 0
>
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)