From d47deebb58804e2323d3861d0cf4d68f5cfea04f Mon Sep 17 00:00:00 2001
From: "monty@mysql.com" <>
Date: Sun, 14 Dec 2003 06:39:52 +0200
Subject: Extend max_allowed_packet to 2G in mysql and mysqldump (Bug #2105)
 Don't dump data for MRG_ISAM or MRG_MYISAM tables. (Bug #1846) Ensure that
 'lower_case_table_names' is always set on case insensitive file systems. (Bug
 #1812) One can now configure MySQL as windows service as a normal user. (Bug
 #1802) Database names is now compared with lower case in ON clause when
 lower_case_table_names is set. (Bug #1736) IGNORE ... LINES option didn't
 work when used with fixed length rows. (Bug #1704) Change INSERT DELAYED ...
 SELECT... to INSERT .... SELECT (Bug #1983) Safety fix for service 'mysql
 start' (Bug #1815)

---
 mysql-test/r/loaddata.result | 18 ++++++++++++++++++
 1 file changed, 18 insertions(+)

(limited to 'mysql-test/r/loaddata.result')

diff --git a/mysql-test/r/loaddata.result b/mysql-test/r/loaddata.result
index 0b7925de1c5..1730d7b5c25 100644
--- a/mysql-test/r/loaddata.result
+++ b/mysql-test/r/loaddata.result
@@ -26,3 +26,21 @@ Field 3,'Field 4|
 |Field 5' ,'Field 6|	NULL
 |Field 6|	| 'Field 7'|
 drop table t1;
+create table t1 (a int, b char(10));
+load data infile '../../std_data/loaddata3.dat' into table t1 fields terminated by '' enclosed by '' ignore 1 lines;
+select * from t1;
+a	b
+1	row 1
+2	row 2
+0	1234567890
+3	row 3
+0	1234567890
+truncate table t1;
+load data infile '../../std_data/loaddata4.dat' into table t1 fields terminated by '' enclosed by '' lines terminated by '' ignore 1 lines;
+select * from t1;
+a	b
+1	row 1
+2	row 2
+3	row 3
+0	
+drop table t1;
-- 
cgit v1.2.1