Adding upstream version 1:10.11.6.upstream/1%10.11.6upstream

Signed-off-by: Daniel Baumann <daniel.baumann@progress-linux.org>

1 files changed, 422 insertions, 0 deletions

diff --git a/mysql-test/main/parser_bug21114_innodb.test b/mysql-test/main/parser_bug21114_innodb.test
new file mode 100644
index 00000000..969eea2d
--- /dev/null
+++ b/mysql-test/main/parser_bug21114_innodb.test
@@ -0,0 +1,422 @@
+-- source include/have_innodb.inc
+
+let $engine_type=InnoDb;
+
+#
+# Bug#21114 (Foreign key creation fails to table with name format)
+# 
+
+# Testing with the full log for only a few functions,
+# including FORMAT for witch the bug was reported.
+
+let $verbose=1;
+
+let $FCT=abs;
+-- source include/parser_bug21114.inc
+let $FCT=field;
+-- source include/parser_bug21114.inc
+let $FCT=format;
+-- source include/parser_bug21114.inc
+
+# Ignoring the result of SHOW CREATE (this generates too much noise)
+# Tests will fail if the create table statement can not be parsed
+
+let verbose=0;
+
+let $FCT=acos;
+-- source include/parser_bug21114.inc
+let $FCT=adddate;
+-- source include/parser_bug21114.inc
+let $FCT=addtime;
+-- source include/parser_bug21114.inc
+let $FCT=aes_decrypt;
+-- source include/parser_bug21114.inc
+let $FCT=aes_encrypt;
+-- source include/parser_bug21114.inc
+let $FCT=area;
+-- source include/parser_bug21114.inc
+let $FCT=asbinary;
+-- source include/parser_bug21114.inc
+let $FCT=asin;
+-- source include/parser_bug21114.inc
+let $FCT=astext;
+-- source include/parser_bug21114.inc
+let $FCT=aswkb;
+-- source include/parser_bug21114.inc
+let $FCT=aswkt;
+-- source include/parser_bug21114.inc
+let $FCT=atan;
+-- source include/parser_bug21114.inc
+let $FCT=atan2;
+-- source include/parser_bug21114.inc
+let $FCT=benchmark;
+-- source include/parser_bug21114.inc
+let $FCT=bin;
+-- source include/parser_bug21114.inc
+let $FCT=bit_count;
+-- source include/parser_bug21114.inc
+let $FCT=bit_length;
+-- source include/parser_bug21114.inc
+let $FCT=ceil;
+-- source include/parser_bug21114.inc
+let $FCT=ceiling;
+-- source include/parser_bug21114.inc
+let $FCT=centroid;
+-- source include/parser_bug21114.inc
+let $FCT=character_length;
+-- source include/parser_bug21114.inc
+let $FCT=char_length;
+-- source include/parser_bug21114.inc
+let $FCT=coercibility;
+-- source include/parser_bug21114.inc
+let $FCT=compress;
+-- source include/parser_bug21114.inc
+let $FCT=concat;
+-- source include/parser_bug21114.inc
+let $FCT=concat_ws;
+-- source include/parser_bug21114.inc
+let $FCT=connection_id;
+-- source include/parser_bug21114.inc
+let $FCT=conv;
+-- source include/parser_bug21114.inc
+let $FCT=convert_tz;
+-- source include/parser_bug21114.inc
+let $FCT=cos;
+-- source include/parser_bug21114.inc
+let $FCT=cot;
+-- source include/parser_bug21114.inc
+let $FCT=crc32;
+-- source include/parser_bug21114.inc
+let $FCT=crosses;
+-- source include/parser_bug21114.inc
+let $FCT=datediff;
+-- source include/parser_bug21114.inc
+let $FCT=date_format;
+-- source include/parser_bug21114.inc
+let $FCT=dayname;
+-- source include/parser_bug21114.inc
+let $FCT=dayofmonth;
+-- source include/parser_bug21114.inc
+let $FCT=dayofweek;
+-- source include/parser_bug21114.inc
+let $FCT=dayofyear;
+-- source include/parser_bug21114.inc
+let $FCT=decode;
+-- source include/parser_bug21114.inc
+let $FCT=degrees;
+-- source include/parser_bug21114.inc
+let $FCT=des_decrypt;
+-- source include/parser_bug21114.inc
+let $FCT=des_encrypt;
+-- source include/parser_bug21114.inc
+let $FCT=dimension;
+-- source include/parser_bug21114.inc
+let $FCT=disjoint;
+-- source include/parser_bug21114.inc
+let $FCT=elt;
+-- source include/parser_bug21114.inc
+let $FCT=encode;
+-- source include/parser_bug21114.inc
+let $FCT=encrypt;
+-- source include/parser_bug21114.inc
+let $FCT=endpoint;
+-- source include/parser_bug21114.inc
+let $FCT=envelope;
+-- source include/parser_bug21114.inc
+let $FCT=equals;
+-- source include/parser_bug21114.inc
+let $FCT=exp;
+-- source include/parser_bug21114.inc
+let $FCT=export_set;
+-- source include/parser_bug21114.inc
+let $FCT=exteriorring;
+-- source include/parser_bug21114.inc
+let $FCT=extractvalue;
+-- source include/parser_bug21114.inc
+let $FCT=find_in_set;
+-- source include/parser_bug21114.inc
+let $FCT=floor;
+-- source include/parser_bug21114.inc
+let $FCT=found_rows;
+-- source include/parser_bug21114.inc
+let $FCT=from_days;
+-- source include/parser_bug21114.inc
+let $FCT=from_unixtime;
+-- source include/parser_bug21114.inc
+let $FCT=geomcollfromtext;
+-- source include/parser_bug21114.inc
+let $FCT=geomcollfromwkb;
+-- source include/parser_bug21114.inc
+let $FCT=geometrycollectionfromtext;
+-- source include/parser_bug21114.inc
+let $FCT=geometrycollectionfromwkb;
+-- source include/parser_bug21114.inc
+let $FCT=geometryfromtext;
+-- source include/parser_bug21114.inc
+let $FCT=geometryfromwkb;
+-- source include/parser_bug21114.inc
+let $FCT=geometryn;
+-- source include/parser_bug21114.inc
+let $FCT=geometrytype;
+-- source include/parser_bug21114.inc
+let $FCT=geomfromtext;
+-- source include/parser_bug21114.inc
+let $FCT=geomfromwkb;
+-- source include/parser_bug21114.inc
+let $FCT=get_lock;
+-- source include/parser_bug21114.inc
+let $FCT=glength;
+-- source include/parser_bug21114.inc
+let $FCT=greatest;
+-- source include/parser_bug21114.inc
+let $FCT=hex;
+-- source include/parser_bug21114.inc
+let $FCT=ifnull;
+-- source include/parser_bug21114.inc
+let $FCT=inet_aton;
+-- source include/parser_bug21114.inc
+let $FCT=inet_ntoa;
+-- source include/parser_bug21114.inc
+let $FCT=instr;
+-- source include/parser_bug21114.inc
+let $FCT=interiorringn;
+-- source include/parser_bug21114.inc
+let $FCT=intersects;
+-- source include/parser_bug21114.inc
+let $FCT=isclosed;
+-- source include/parser_bug21114.inc
+let $FCT=isempty;
+-- source include/parser_bug21114.inc
+let $FCT=isnull;
+-- source include/parser_bug21114.inc
+let $FCT=issimple;
+-- source include/parser_bug21114.inc
+let $FCT=is_free_lock;
+-- source include/parser_bug21114.inc
+let $FCT=is_used_lock;
+-- source include/parser_bug21114.inc
+let $FCT=last_day;
+-- source include/parser_bug21114.inc
+let $FCT=last_insert_id;
+-- source include/parser_bug21114.inc
+let $FCT=lcase;
+-- source include/parser_bug21114.inc
+let $FCT=least;
+-- source include/parser_bug21114.inc
+let $FCT=length;
+-- source include/parser_bug21114.inc
+let $FCT=linefromtext;
+-- source include/parser_bug21114.inc
+let $FCT=linefromwkb;
+-- source include/parser_bug21114.inc
+let $FCT=linestringfromtext;
+-- source include/parser_bug21114.inc
+let $FCT=linestringfromwkb;
+-- source include/parser_bug21114.inc
+let $FCT=ln;
+-- source include/parser_bug21114.inc
+let $FCT=load_file;
+-- source include/parser_bug21114.inc
+let $FCT=locate;
+-- source include/parser_bug21114.inc
+let $FCT=log;
+-- source include/parser_bug21114.inc
+let $FCT=log10;
+-- source include/parser_bug21114.inc
+let $FCT=log2;
+-- source include/parser_bug21114.inc
+let $FCT=lower;
+-- source include/parser_bug21114.inc
+let $FCT=lpad;
+-- source include/parser_bug21114.inc
+let $FCT=ltrim;
+-- source include/parser_bug21114.inc
+let $FCT=makedate;
+-- source include/parser_bug21114.inc
+let $FCT=maketime;
+-- source include/parser_bug21114.inc
+let $FCT=make_set;
+-- source include/parser_bug21114.inc
+let $FCT=master_pos_wait;
+-- source include/parser_bug21114.inc
+let $FCT=mbrcontains;
+-- source include/parser_bug21114.inc
+let $FCT=mbrdisjoint;
+-- source include/parser_bug21114.inc
+let $FCT=mbrequal;
+-- source include/parser_bug21114.inc
+let $FCT=mbrintersects;
+-- source include/parser_bug21114.inc
+let $FCT=mbroverlaps;
+-- source include/parser_bug21114.inc
+let $FCT=mbrtouches;
+-- source include/parser_bug21114.inc
+let $FCT=mbrwithin;
+-- source include/parser_bug21114.inc
+let $FCT=md5;
+-- source include/parser_bug21114.inc
+let $FCT=mlinefromtext;
+-- source include/parser_bug21114.inc
+let $FCT=mlinefromwkb;
+-- source include/parser_bug21114.inc
+let $FCT=monthname;
+-- source include/parser_bug21114.inc
+let $FCT=mpointfromtext;
+-- source include/parser_bug21114.inc
+let $FCT=mpointfromwkb;
+-- source include/parser_bug21114.inc
+let $FCT=mpolyfromtext;
+-- source include/parser_bug21114.inc
+let $FCT=mpolyfromwkb;
+-- source include/parser_bug21114.inc
+let $FCT=multilinestringfromtext;
+-- source include/parser_bug21114.inc
+let $FCT=multilinestringfromwkb;
+-- source include/parser_bug21114.inc
+let $FCT=multipointfromtext;
+-- source include/parser_bug21114.inc
+let $FCT=multipointfromwkb;
+-- source include/parser_bug21114.inc
+let $FCT=multipolygonfromtext;
+-- source include/parser_bug21114.inc
+let $FCT=multipolygonfromwkb;
+-- source include/parser_bug21114.inc
+let $FCT=name_const;
+-- source include/parser_bug21114.inc
+let $FCT=nullif;
+-- source include/parser_bug21114.inc
+let $FCT=numgeometries;
+-- source include/parser_bug21114.inc
+let $FCT=numinteriorrings;
+-- source include/parser_bug21114.inc
+let $FCT=numpoints;
+-- source include/parser_bug21114.inc
+let $FCT=oct;
+-- source include/parser_bug21114.inc
+let $FCT=octet_length;
+-- source include/parser_bug21114.inc
+let $FCT=ord;
+-- source include/parser_bug21114.inc
+let $FCT=overlaps;
+-- source include/parser_bug21114.inc
+let $FCT=period_add;
+-- source include/parser_bug21114.inc
+let $FCT=period_diff;
+-- source include/parser_bug21114.inc
+let $FCT=pi;
+-- source include/parser_bug21114.inc
+let $FCT=pointfromtext;
+-- source include/parser_bug21114.inc
+let $FCT=pointfromwkb;
+-- source include/parser_bug21114.inc
+let $FCT=pointn;
+-- source include/parser_bug21114.inc
+let $FCT=polyfromtext;
+-- source include/parser_bug21114.inc
+let $FCT=polyfromwkb;
+-- source include/parser_bug21114.inc
+let $FCT=polygonfromtext;
+-- source include/parser_bug21114.inc
+let $FCT=polygonfromwkb;
+-- source include/parser_bug21114.inc
+let $FCT=pow;
+-- source include/parser_bug21114.inc
+let $FCT=power;
+-- source include/parser_bug21114.inc
+let $FCT=quote;
+-- source include/parser_bug21114.inc
+let $FCT=radians;
+-- source include/parser_bug21114.inc
+let $FCT=rand;
+-- source include/parser_bug21114.inc
+let $FCT=release_lock;
+-- source include/parser_bug21114.inc
+let $FCT=reverse;
+-- source include/parser_bug21114.inc
+let $FCT=round;
+-- source include/parser_bug21114.inc
+let $FCT=row_count;
+-- source include/parser_bug21114.inc
+let $FCT=rpad;
+-- source include/parser_bug21114.inc
+let $FCT=rtrim;
+-- source include/parser_bug21114.inc
+let $FCT=sec_to_time;
+-- source include/parser_bug21114.inc
+let $FCT=session_user;
+-- source include/parser_bug21114.inc
+let $FCT=sha;
+-- source include/parser_bug21114.inc
+let $FCT=sha1;
+-- source include/parser_bug21114.inc
+let $FCT=sign;
+-- source include/parser_bug21114.inc
+let $FCT=sin;
+-- source include/parser_bug21114.inc
+let $FCT=sleep;
+-- source include/parser_bug21114.inc
+let $FCT=soundex;
+-- source include/parser_bug21114.inc
+let $FCT=space;
+-- source include/parser_bug21114.inc
+let $FCT=sqrt;
+-- source include/parser_bug21114.inc
+let $FCT=srid;
+-- source include/parser_bug21114.inc
+let $FCT=startpoint;
+-- source include/parser_bug21114.inc
+let $FCT=strcmp;
+-- source include/parser_bug21114.inc
+let $FCT=str_to_date;
+-- source include/parser_bug21114.inc
+let $FCT=subdate;
+-- source include/parser_bug21114.inc
+let $FCT=substring_index;
+-- source include/parser_bug21114.inc
+let $FCT=subtime;
+-- source include/parser_bug21114.inc
+let $FCT=system_user;
+-- source include/parser_bug21114.inc
+let $FCT=tan;
+-- source include/parser_bug21114.inc
+let $FCT=timediff;
+-- source include/parser_bug21114.inc
+let $FCT=time_format;
+-- source include/parser_bug21114.inc
+let $FCT=time_to_sec;
+-- source include/parser_bug21114.inc
+let $FCT=touches;
+-- source include/parser_bug21114.inc
+let $FCT=to_days;
+-- source include/parser_bug21114.inc
+let $FCT=ucase;
+-- source include/parser_bug21114.inc
+let $FCT=uncompress;
+-- source include/parser_bug21114.inc
+let $FCT=uncompressed_length;
+-- source include/parser_bug21114.inc
+let $FCT=unhex;
+-- source include/parser_bug21114.inc
+let $FCT=unix_timestamp;
+-- source include/parser_bug21114.inc
+let $FCT=updatexml;
+-- source include/parser_bug21114.inc
+let $FCT=upper;
+-- source include/parser_bug21114.inc
+let $FCT=uuid;
+-- source include/parser_bug21114.inc
+let $FCT=version;
+-- source include/parser_bug21114.inc
+let $FCT=weekday;
+-- source include/parser_bug21114.inc
+let $FCT=weekofyear;
+-- source include/parser_bug21114.inc
+let $FCT=within;
+-- source include/parser_bug21114.inc
+let $FCT=x;
+-- source include/parser_bug21114.inc
+let $FCT=y;
+-- source include/parser_bug21114.inc
+let $FCT=yearweek;
+-- source include/parser_bug21114.inc
+