summaryrefslogtreecommitdiff
path: root/mysql-test/r/analyse.result
diff options
context:
space:
mode:
authorunknown <joreland@mysql.com>2005-01-12 11:24:46 +0100
committerunknown <joreland@mysql.com>2005-01-12 11:24:46 +0100
commit40649e92f77b75a41fb3097bc4813c80783ba3a8 (patch)
tree1f0b9b0d34e656749bbdb72b8f4306485974c23d /mysql-test/r/analyse.result
parentdd3cfa8d887bab5d7555a7ca9d1b072897b79dcd (diff)
parented6c9afd6d81789fba09e2aa017e1c02968bdf18 (diff)
downloadmariadb-git-40649e92f77b75a41fb3097bc4813c80783ba3a8.tar.gz
Merge mysql.com:/home/jonas/src/mysql-4.1
into mysql.com:/home/jonas/src/mysql-5.0 libmysql_r/Makefile.am: Auto merged mysql-test/r/analyse.result: Auto merged sql/sql_analyse.cc: Auto merged
Diffstat (limited to 'mysql-test/r/analyse.result')
-rw-r--r--mysql-test/r/analyse.result6
1 files changed, 6 insertions, 0 deletions
diff --git a/mysql-test/r/analyse.result b/mysql-test/r/analyse.result
index 063b7d2d2e9..d4128fb1bcc 100644
--- a/mysql-test/r/analyse.result
+++ b/mysql-test/r/analyse.result
@@ -96,3 +96,9 @@ select * from t2;
Field_name Min_value Max_value Min_length Max_length Empties_or_zeros Nulls Avg_value_or_avg_length Std Optimal_fieldtype
test.t1.a 1 2 1 1 0 0 1.5000 0.5000 ENUM('1','2') NOT NULL
drop table t1,t2;
+create table t1 (v varchar(128));
+insert into t1 values ('abc'),('abc\'def\\hij\"klm\0opq'),('\''),('\"'),('\\'),('a\0'),('b\''),('c\"'),('d\\'),('\'b'),('\"c'),('\\d'),('a\0\0\0b'),('a\'\'\'\'b'),('a\"\"\"\"b'),('a\\\\\\\\b'),('\'\0\\\"'),('\'\''),('\"\"'),('\\\\'),('The\ZEnd');
+select * from t1 procedure analyse();
+Field_name Min_value Max_value Min_length Max_length Empties_or_zeros Nulls Avg_value_or_avg_length Std Optimal_fieldtype
+test.t1.v " \\ 1 19 0 0 3.7619 NULL ENUM('"','""','"c','\'\0\\"','\'','\'\'','\'b','a\0\0\0b','a\0','a""""b','a\'\'\'\'b','abc','abc\'def\\hij"klm\0opq','a\\\\\\\\b','b\'','c"','d\\','The\ZEnd','\\','\\d','\\\\') NOT NULL
+drop table t1;