http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/729472c2/core/sql/regress/executor/TEST130 ---------------------------------------------------------------------- diff --git a/core/sql/regress/executor/TEST130 b/core/sql/regress/executor/TEST130 index 208ca5f..cb7557f 100755 --- a/core/sql/regress/executor/TEST130 +++ b/core/sql/regress/executor/TEST130 @@ -296,6 +296,8 @@ sh regrhadoop.ksh fs -copyFromLocal lob_input_d1.txt /lobs/lob_input_d1.txt; sh regrhadoop.ksh fs -copyFromLocal lob_input_e1.txt /lobs/lob_input_e1.txt; sh regrhadoop.ksh fs -copyFromLocal deep.jpg /lobs/deep.jpg; sh regrhadoop.ksh fs -copyFromLocal anoush.jpg /lobs/anoush.jpg; +-- the next one is a really long file name intended to test error message 8557 +sh regrhadoop.ksh fs -copyFromLocal lob_input_a1.txt /lobs/reallyLongDirectoryName0123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789/lob_input_a1012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789.txt; sh sleep(20); @@ -499,6 +501,9 @@ update tlob130ext set c4=stringtolob('cannot allow this') where c1=1; delete from tlob130ext where c1=1; insert into tlob130ext values(1, stringtolob('first lob'),externaltolob('hdfs:///lobs/lob_input_a1.txt'),externaltolob('hdfs:///lobs/lob_input_a1.txt')); insert into tlob130ext values(1, stringtolob('first lob'), filetolob('hdfs:///lobs/lob_input_a1.txt'),externaltolob('hdfs:///lobs/lob_input_a1.txt')); +-- the next one should see error 8557 +insert into tlob130ext values(1, stringtolob('first lob'), filetolob('hdfs:///lobs/lob_input_a1.txt'), +externaltolob('hdfs:///lobs/reallyLongDirectoryName0123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789/lob_input_a1012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789.txt')); select lobtostring(c2,50),lobtostring(c3,50),lobtostring(c4,50) from tlob130ext; update tlob130ext set c3=stringtolob('can allow this') where c1=1; @@ -576,6 +581,7 @@ sh regrhadoop.ksh fs -rm /lobs/lobinput_b1.txt sh regrhadoop.ksh fs -rm /lobs/lobinput_c1.txt sh regrhadoop.ksh fs -rm /lobs/lobinput_d1.txt sh regrhadoop.ksh fs -rm /lobs/lobinput_e1.txt +sh regrhadoop.ksh fs -rm /lobs/reallyLongDirectoryName0123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789/lob_input_a1012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789.txt; sh rm lobinput_*; sh rm deep.jpg; sh rm anoush.jpg;
http://git-wip-us.apache.org/repos/asf/incubator-trafodion/blob/729472c2/docs/messages_guide/src/asciidoc/_chapters/executor_msgs.adoc ---------------------------------------------------------------------- diff --git a/docs/messages_guide/src/asciidoc/_chapters/executor_msgs.adoc b/docs/messages_guide/src/asciidoc/_chapters/executor_msgs.adoc index 191f033..06403c7 100644 --- a/docs/messages_guide/src/asciidoc/_chapters/executor_msgs.adoc +++ b/docs/messages_guide/src/asciidoc/_chapters/executor_msgs.adoc @@ -226,6 +226,21 @@ Stream overflow; subscription rate has fallen too far behind publishing rate. *Recovery:* Reopen the statement or cursor and resume subscribing. <<< +[[SQL-8557]] +== SQL 8557 + +``` +The file name passed to externaltolob exceeds 256 bytes. +``` + +*Cause:* A DML statement attempted to execute the externaltolob function with a file name exceeding 256 bytes. + +*Effect:* The statement fails. + +*Recovery:* If the file name is incorrect, correct and rerun. If the file name is correct and is too long, rename the file so that +it is within the 256 byte limit. + +<<< [[SQL-8573]] == SQL 8573
