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:18:03 UTC
[jira] [Created] (TRAFODION-751) LP Bug: 1391641 - unload WITH
DELIMITER 255 returns ERROR[15001]
Alice Chen created TRAFODION-751:
------------------------------------
Summary: LP Bug: 1391641 - unload WITH DELIMITER 255 returns ERROR[15001]
Key: TRAFODION-751
URL: https://issues.apache.org/jira/browse/TRAFODION-751
Project: Apache Trafodion
Issue Type: Bug
Components: sql-exe
Reporter: Julie Thai
As per documentation, delimiter and record_separator valid ascii value ranges from 1 to 255.
SQL>unload with purgedata from target delimiter 255
into '/bulkload/QA_unload_tests/loc_part' select * from tbl_part;
UTIL_OUTPUT
--------------------------------------------------------------------------------------------------------------------------------
Task: UNLOAD Status: Started
Task: EMPTY TARGET Status: Started
Task: EMPTY TARGET Status: Ended ET: 00:00:00.007
Task: EXTRACT Status: Started
*** ERROR[15001] A syntax error occurred at or before:
UNLOAD EXTRACT WITH DELIMITER 4294967295 TO '/bulkload/QA_unload_tests/loc_
^ (42 characters from start of SQL statement) [2014-11-11 12:23:57]
To reproduce in trafci, issue:
unload with purgedata from target delimiter 255 into '/bulkload/mytest' select * from <tblname>;
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)