- Fix MDEV-5497. The city column length was wrong in the create table statements.

modified:
  storage/connect/mysql-test/connect/r/fix.result
  storage/connect/mysql-test/connect/t/fix.test

1 files changed, 28 insertions, 28 deletions

diff --git a/storage/connect/mysql-test/connect/r/fix.result b/storage/connect/mysql-test/connect/r/fix.result
index 96ba3f84a0d..a93948bb9c6 100644
--- a/storage/connect/mysql-test/connect/r/fix.result
+++ b/storage/connect/mysql-test/connect/r/fix.result
@@ -68,64 +68,64 @@ DROP TABLE t1;
 CREATE TABLE t1
 (
 name char(12) not null,
-city char(12) not null,
+city char(11) not null,
 birth date not null date_format='DD/MM/YYYY',
 hired date not null date_format='DD/MM/YYYY' flag=36
 ) ENGINE=CONNECT TABLE_TYPE=FIX FILE_NAME='boys.txt' ENDING=1;
 SELECT * FROM t1;
 name	city	birth	hired
-John	Boston     2	1986-01-05	2010-06-02
-Henry	Boston     0	1987-06-07	2008-04-01
-George	San Jose   1	1981-08-01	2010-06-02
-Sam	Chicago    2	1979-11-02	2007-10-10
-James	Dallas     1	1992-05-03	2009-12-14
-Bill	Boston     1	1986-09-01	2008-02-10
+John	Boston	1986-01-25	2010-06-02
+Henry	Boston	1987-06-07	2008-04-01
+George	San Jose	1981-08-10	2010-06-02
+Sam	Chicago	1979-11-22	2007-10-10
+James	Dallas	1992-05-13	2009-12-14
+Bill	Boston	1986-09-11	2008-02-10
 DROP TABLE t1;
 CREATE TABLE t1
 (
 name char(12) not null,
-city char(12) not null,
+city char(11) not null,
 birth date not null date_format='DD/MM/YYYY',
 hired date not null date_format='DD/MM/YYYY' flag=36
 ) ENGINE=CONNECT TABLE_TYPE=FIX FILE_NAME='boys.txt' LRECL=47 ENDING=1;
 SELECT * FROM t1;
 name	city	birth	hired
-John	Boston     2	1986-01-05	2010-06-02
-Henry	Boston     0	1987-06-07	2008-04-01
-George	San Jose   1	1981-08-01	2010-06-02
-Sam	Chicago    2	1979-11-02	2007-10-10
-James	Dallas     1	1992-05-03	2009-12-14
-Bill	Boston     1	1986-09-01	2008-02-10
+John	Boston	1986-01-25	2010-06-02
+Henry	Boston	1987-06-07	2008-04-01
+George	San Jose	1981-08-10	2010-06-02
+Sam	Chicago	1979-11-22	2007-10-10
+James	Dallas	1992-05-13	2009-12-14
+Bill	Boston	1986-09-11	2008-02-10
 DROP TABLE t1;
 CREATE TABLE t1
 (
 name char(12) not null,
-city char(12) not null,
+city char(11) not null,
 birth date not null date_format='DD/MM/YYYY',
 hired date not null date_format='DD/MM/YYYY' flag=36
 ) ENGINE=CONNECT TABLE_TYPE=FIX FILE_NAME='boyswin.txt' ENDING=2;
 SELECT * FROM t1;
 name	city	birth	hired
-John	Boston     2	1986-01-05	2010-06-02
-Henry	Boston     0	1987-06-07	2008-04-01
-George	San Jose   1	1981-08-01	2010-06-02
-Sam	Chicago    2	1979-11-02	2007-10-10
-James	Dallas     1	1992-05-03	2009-12-14
-Bill	Boston     1	1986-09-01	2008-02-10
+John	Boston	1986-01-25	2010-06-02
+Henry	Boston	1987-06-07	2008-04-01
+George	San Jose	1981-08-10	2010-06-02
+Sam	Chicago	1979-11-22	2007-10-10
+James	Dallas	1992-05-13	2009-12-14
+Bill	Boston	1986-09-11	2008-02-10
 DROP TABLE t1;
 CREATE TABLE t1
 (
 name char(12) not null,
-city char(12) not null,
+city char(11) not null,
 birth date not null date_format='DD/MM/YYYY',
 hired date not null date_format='DD/MM/YYYY' flag=36
 ) ENGINE=CONNECT TABLE_TYPE=FIX FILE_NAME='boyswin.txt' LRECL=47 ENDING=2;
 SELECT * FROM t1;
 name	city	birth	hired
-John	Boston     2	1986-01-05	2010-06-02
-Henry	Boston     0	1987-06-07	2008-04-01
-George	San Jose   1	1981-08-01	2010-06-02
-Sam	Chicago    2	1979-11-02	2007-10-10
-James	Dallas     1	1992-05-03	2009-12-14
-Bill	Boston     1	1986-09-01	2008-02-10
+John	Boston	1986-01-25	2010-06-02
+Henry	Boston	1987-06-07	2008-04-01
+George	San Jose	1981-08-10	2010-06-02
+Sam	Chicago	1979-11-22	2007-10-10
+James	Dallas	1992-05-13	2009-12-14
+Bill	Boston	1986-09-11	2008-02-10
 DROP TABLE t1;