You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@trafodion.apache.org by "Alice Chen (JIRA)" <ji...@apache.org> on 2015/07/22 20:15:18 UTC
[jira] [Created] (TRAFODION-234) LP Bug: 1310779 - Single quote is
not allowed in the column heading string
Alice Chen created TRAFODION-234:
------------------------------------
Summary: LP Bug: 1310779 - Single quote is not allowed in the column heading string
Key: TRAFODION-234
URL: https://issues.apache.org/jira/browse/TRAFODION-234
Project: Apache Trafodion
Issue Type: Bug
Components: sql-exe
Reporter: Weishiun Tsai
Assignee: Anoop Sharma
On Seaquest, a single quote can be used as part of the column heading string by specifying 2 single quotes together. The SQL reference manual for Trafodion still has the following description:
'string'
is a series of any input characters enclosed in single quotes. A single quote within a string is
represented by two single quotes (''). A string can have a length of zero if you specify two
single quotes ('') without a space in between.
But as shown here on the 1st part of the output, Trafodion does not take such a column heading. The 2nd part of the output shows the Seaquest behavior.
============================================================
On Trafodion:
>>create table t (a int not null not droppable primary key heading 'A''B');
*** ERROR[15005] Unmatched quote in input (unterminated string):
insert into TRAFODION."_MD_".COLUMNS values (30432030613442144, 'A', 0, 'U ', 132, 4, 0, 0, 0, 0, 'N', 0, 0, '_unknown_', 1, ' ', 'A'B', '#1', '1');
*** ERROR[8822] The statement was not prepared.
--- SQL operation failed with errors.
============================================================
On Seauest:
>>create table t (a int not null not droppable primary key heading 'A''B');
--- SQL operation complete.
>>invoke t;
-- Definition of table NEO.USR.T
-- Definition current Mon Apr 21 19:10:40 2014
(
A INT NO DEFAULT HEADING 'A''B' NOT NULL NOT
DROPPABLE
)
--- SQL operation complete.
>>insert into t values (1);
--- 1 row(s) inserted.
>>select * from t;
A'B
-----------
1
--- 1 row(s) selected.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)