bzr commit into mysql-6.0 branch (Matthias.Leich:2827) Bug#38427

[Matthias Leich]

#At file:///work2/6.0/mysql-6.0-bugteam-A/

 2827 Matthias Leich	2008-10-02 [merge]
      Merge 5.1 -> 6.0 of fix for Bug#38427
      "Data too long" in some configurations, tests "<ENGINE>_func_view" fail
modified:
  mysql-test/suite/funcs_1/views/func_view.inc

=== modified file 'mysql-test/suite/funcs_1/views/func_view.inc'
--- a/mysql-test/suite/funcs_1/views/func_view.inc	2008-06-18 17:23:55 +0000
+++ b/mysql-test/suite/funcs_1/views/func_view.inc	2008-10-02 12:12:08 +0000
@@ -158,10 +158,16 @@ DROP VIEW  IF EXISTS v1;
 
 --disable_query_log
 # Storage for the SELECTs to be used for the VIEW definition
+# Attention: my_select must be no too small because a statement like
+#    SELECT LOAD_FILE(< file in MYSQLTEST_VARDIR >)
+#    AS my_col,
+#    id FROM t1_values';
+#    might be a very long
+# Bug#38427 "Data too long" ... tests "<ENGINE>_func_view" fail
 CREATE TABLE t1_selects
 (
    id BIGINT AUTO_INCREMENT,
-   my_select VARCHAR(200) NOT NULL,
+   my_select VARCHAR(1000) NOT NULL,
    disable_result ENUM('Yes','No') NOT NULL default 'No',
    PRIMARY KEY(id),
    UNIQUE (my_select)