diff options
Diffstat (limited to 'mysql-test/main/parser_bug21114_innodb.result')
-rw-r--r-- | mysql-test/main/parser_bug21114_innodb.result | 867 |
1 files changed, 867 insertions, 0 deletions
diff --git a/mysql-test/main/parser_bug21114_innodb.result b/mysql-test/main/parser_bug21114_innodb.result new file mode 100644 index 00000000..8c592f2d --- /dev/null +++ b/mysql-test/main/parser_bug21114_innodb.result @@ -0,0 +1,867 @@ +drop table if exists abs; +drop table if exists bug21114_child; +SHOW CREATE TABLE abs; +Table Create Table +abs CREATE TABLE `abs` ( + `col1` int(11) NOT NULL, + `col2` int(11) NOT NULL, + `col3` varchar(10) DEFAULT NULL, + PRIMARY KEY (`col1`,`col2`) +) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci +SHOW CREATE TABLE bug21114_child; +Table Create Table +bug21114_child CREATE TABLE `bug21114_child` ( + `pk` int(11) NOT NULL, + `fk_col1` int(11) NOT NULL, + `fk_col2` int(11) NOT NULL, + `fk_col3` int(11) NOT NULL, + `fk_col4` int(11) NOT NULL, + KEY `fk_fct` (`fk_col1`,`fk_col2`), + KEY `fk_fct_space` (`fk_col3`,`fk_col4`), + CONSTRAINT `fk_fct` FOREIGN KEY (`fk_col1`, `fk_col2`) REFERENCES `abs` (`col1`, `col2`), + CONSTRAINT `fk_fct_space` FOREIGN KEY (`fk_col3`, `fk_col4`) REFERENCES `abs` (`col1`, `col2`) +) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci +DROP TABLE bug21114_child; +DROP TABLE abs; +drop table if exists field; +drop table if exists bug21114_child; +SHOW CREATE TABLE field; +Table Create Table +field CREATE TABLE `field` ( + `col1` int(11) NOT NULL, + `col2` int(11) NOT NULL, + `col3` varchar(10) DEFAULT NULL, + PRIMARY KEY (`col1`,`col2`) +) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci +SHOW CREATE TABLE bug21114_child; +Table Create Table +bug21114_child CREATE TABLE `bug21114_child` ( + `pk` int(11) NOT NULL, + `fk_col1` int(11) NOT NULL, + `fk_col2` int(11) NOT NULL, + `fk_col3` int(11) NOT NULL, + `fk_col4` int(11) NOT NULL, + KEY `fk_fct` (`fk_col1`,`fk_col2`), + KEY `fk_fct_space` (`fk_col3`,`fk_col4`), + CONSTRAINT `fk_fct` FOREIGN KEY (`fk_col1`, `fk_col2`) REFERENCES `field` (`col1`, `col2`), + CONSTRAINT `fk_fct_space` FOREIGN KEY (`fk_col3`, `fk_col4`) REFERENCES `field` (`col1`, `col2`) +) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci +DROP TABLE bug21114_child; +DROP TABLE field; +drop table if exists format; +drop table if exists bug21114_child; +SHOW CREATE TABLE format; +Table Create Table +format CREATE TABLE `format` ( + `col1` int(11) NOT NULL, + `col2` int(11) NOT NULL, + `col3` varchar(10) DEFAULT NULL, + PRIMARY KEY (`col1`,`col2`) +) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci +SHOW CREATE TABLE bug21114_child; +Table Create Table +bug21114_child CREATE TABLE `bug21114_child` ( + `pk` int(11) NOT NULL, + `fk_col1` int(11) NOT NULL, + `fk_col2` int(11) NOT NULL, + `fk_col3` int(11) NOT NULL, + `fk_col4` int(11) NOT NULL, + KEY `fk_fct` (`fk_col1`,`fk_col2`), + KEY `fk_fct_space` (`fk_col3`,`fk_col4`), + CONSTRAINT `fk_fct` FOREIGN KEY (`fk_col1`, `fk_col2`) REFERENCES `format` (`col1`, `col2`), + CONSTRAINT `fk_fct_space` FOREIGN KEY (`fk_col3`, `fk_col4`) REFERENCES `format` (`col1`, `col2`) +) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci +DROP TABLE bug21114_child; +DROP TABLE format; +drop table if exists acos; +drop table if exists bug21114_child; +DROP TABLE bug21114_child; +DROP TABLE acos; +drop table if exists adddate; +drop table if exists bug21114_child; +DROP TABLE bug21114_child; +DROP TABLE adddate; +drop table if exists addtime; +drop table if exists bug21114_child; +DROP TABLE bug21114_child; +DROP TABLE addtime; +drop table if exists aes_decrypt; +drop table if exists bug21114_child; +DROP TABLE bug21114_child; +DROP TABLE aes_decrypt; +drop table if exists aes_encrypt; +drop table if exists bug21114_child; +DROP TABLE bug21114_child; +DROP TABLE aes_encrypt; +drop table if exists area; +drop table if exists bug21114_child; +DROP TABLE bug21114_child; +DROP TABLE area; +drop table if exists asbinary; +drop table if exists bug21114_child; +DROP TABLE bug21114_child; +DROP TABLE asbinary; +drop table if exists asin; +drop table if exists bug21114_child; +DROP TABLE bug21114_child; +DROP TABLE asin; +drop table if exists astext; +drop table if exists bug21114_child; +DROP TABLE bug21114_child; +DROP TABLE astext; +drop table if exists aswkb; +drop table if exists bug21114_child; +DROP TABLE bug21114_child; +DROP TABLE aswkb; +drop table if exists aswkt; +drop table if exists bug21114_child; +DROP TABLE bug21114_child; +DROP TABLE aswkt; +drop table if exists atan; +drop table if exists bug21114_child; +DROP TABLE bug21114_child; +DROP TABLE atan; +drop table if exists atan2; +drop table if exists bug21114_child; +DROP TABLE bug21114_child; +DROP TABLE atan2; +drop table if exists benchmark; +drop table if exists bug21114_child; +DROP TABLE bug21114_child; +DROP TABLE benchmark; +drop table if exists bin; +drop table if exists bug21114_child; +DROP TABLE bug21114_child; +DROP TABLE bin; +drop table if exists bit_count; +drop table if exists bug21114_child; +DROP TABLE bug21114_child; +DROP TABLE bit_count; +drop table if exists bit_length; +drop table if exists bug21114_child; +DROP TABLE bug21114_child; +DROP TABLE bit_length; +drop table if exists ceil; +drop table if exists bug21114_child; +DROP TABLE bug21114_child; +DROP TABLE ceil; +drop table if exists ceiling; +drop table if exists bug21114_child; +DROP TABLE bug21114_child; +DROP TABLE ceiling; +drop table if exists centroid; +drop table if exists bug21114_child; +DROP TABLE bug21114_child; +DROP TABLE centroid; +drop table if exists character_length; +drop table if exists bug21114_child; +DROP TABLE bug21114_child; +DROP TABLE character_length; +drop table if exists char_length; +drop table if exists bug21114_child; +DROP TABLE bug21114_child; +DROP TABLE char_length; +drop table if exists coercibility; +drop table if exists bug21114_child; +DROP TABLE bug21114_child; +DROP TABLE coercibility; +drop table if exists compress; +drop table if exists bug21114_child; +DROP TABLE bug21114_child; +DROP TABLE compress; +drop table if exists concat; +drop table if exists bug21114_child; +DROP TABLE bug21114_child; +DROP TABLE concat; +drop table if exists concat_ws; +drop table if exists bug21114_child; +DROP TABLE bug21114_child; +DROP TABLE concat_ws; +drop table if exists connection_id; +drop table if exists bug21114_child; +DROP TABLE bug21114_child; +DROP TABLE connection_id; +drop table if exists conv; +drop table if exists bug21114_child; +DROP TABLE bug21114_child; +DROP TABLE conv; +drop table if exists convert_tz; +drop table if exists bug21114_child; +DROP TABLE bug21114_child; +DROP TABLE convert_tz; +drop table if exists cos; +drop table if exists bug21114_child; +DROP TABLE bug21114_child; +DROP TABLE cos; +drop table if exists cot; +drop table if exists bug21114_child; +DROP TABLE bug21114_child; +DROP TABLE cot; +drop table if exists crc32; +drop table if exists bug21114_child; +DROP TABLE bug21114_child; +DROP TABLE crc32; +drop table if exists crosses; +drop table if exists bug21114_child; +DROP TABLE bug21114_child; +DROP TABLE crosses; +drop table if exists datediff; +drop table if exists bug21114_child; +DROP TABLE bug21114_child; +DROP TABLE datediff; +drop table if exists date_format; +drop table if exists bug21114_child; +DROP TABLE bug21114_child; +DROP TABLE date_format; +drop table if exists dayname; +drop table if exists bug21114_child; +DROP TABLE bug21114_child; +DROP TABLE dayname; +drop table if exists dayofmonth; +drop table if exists bug21114_child; +DROP TABLE bug21114_child; +DROP TABLE dayofmonth; +drop table if exists dayofweek; +drop table if exists bug21114_child; +DROP TABLE bug21114_child; +DROP TABLE dayofweek; +drop table if exists dayofyear; +drop table if exists bug21114_child; +DROP TABLE bug21114_child; +DROP TABLE dayofyear; +drop table if exists decode; +drop table if exists bug21114_child; +DROP TABLE bug21114_child; +DROP TABLE decode; +drop table if exists degrees; +drop table if exists bug21114_child; +DROP TABLE bug21114_child; +DROP TABLE degrees; +drop table if exists des_decrypt; +drop table if exists bug21114_child; +DROP TABLE bug21114_child; +DROP TABLE des_decrypt; +drop table if exists des_encrypt; +drop table if exists bug21114_child; +DROP TABLE bug21114_child; +DROP TABLE des_encrypt; +drop table if exists dimension; +drop table if exists bug21114_child; +DROP TABLE bug21114_child; +DROP TABLE dimension; +drop table if exists disjoint; +drop table if exists bug21114_child; +DROP TABLE bug21114_child; +DROP TABLE disjoint; +drop table if exists elt; +drop table if exists bug21114_child; +DROP TABLE bug21114_child; +DROP TABLE elt; +drop table if exists encode; +drop table if exists bug21114_child; +DROP TABLE bug21114_child; +DROP TABLE encode; +drop table if exists encrypt; +drop table if exists bug21114_child; +DROP TABLE bug21114_child; +DROP TABLE encrypt; +drop table if exists endpoint; +drop table if exists bug21114_child; +DROP TABLE bug21114_child; +DROP TABLE endpoint; +drop table if exists envelope; +drop table if exists bug21114_child; +DROP TABLE bug21114_child; +DROP TABLE envelope; +drop table if exists equals; +drop table if exists bug21114_child; +DROP TABLE bug21114_child; +DROP TABLE equals; +drop table if exists exp; +drop table if exists bug21114_child; +DROP TABLE bug21114_child; +DROP TABLE exp; +drop table if exists export_set; +drop table if exists bug21114_child; +DROP TABLE bug21114_child; +DROP TABLE export_set; +drop table if exists exteriorring; +drop table if exists bug21114_child; +DROP TABLE bug21114_child; +DROP TABLE exteriorring; +drop table if exists extractvalue; +drop table if exists bug21114_child; +DROP TABLE bug21114_child; +DROP TABLE extractvalue; +drop table if exists find_in_set; +drop table if exists bug21114_child; +DROP TABLE bug21114_child; +DROP TABLE find_in_set; +drop table if exists floor; +drop table if exists bug21114_child; +DROP TABLE bug21114_child; +DROP TABLE floor; +drop table if exists found_rows; +drop table if exists bug21114_child; +DROP TABLE bug21114_child; +DROP TABLE found_rows; +drop table if exists from_days; +drop table if exists bug21114_child; +DROP TABLE bug21114_child; +DROP TABLE from_days; +drop table if exists from_unixtime; +drop table if exists bug21114_child; +DROP TABLE bug21114_child; +DROP TABLE from_unixtime; +drop table if exists geomcollfromtext; +drop table if exists bug21114_child; +DROP TABLE bug21114_child; +DROP TABLE geomcollfromtext; +drop table if exists geomcollfromwkb; +drop table if exists bug21114_child; +DROP TABLE bug21114_child; +DROP TABLE geomcollfromwkb; +drop table if exists geometrycollectionfromtext; +drop table if exists bug21114_child; +DROP TABLE bug21114_child; +DROP TABLE geometrycollectionfromtext; +drop table if exists geometrycollectionfromwkb; +drop table if exists bug21114_child; +DROP TABLE bug21114_child; +DROP TABLE geometrycollectionfromwkb; +drop table if exists geometryfromtext; +drop table if exists bug21114_child; +DROP TABLE bug21114_child; +DROP TABLE geometryfromtext; +drop table if exists geometryfromwkb; +drop table if exists bug21114_child; +DROP TABLE bug21114_child; +DROP TABLE geometryfromwkb; +drop table if exists geometryn; +drop table if exists bug21114_child; +DROP TABLE bug21114_child; +DROP TABLE geometryn; +drop table if exists geometrytype; +drop table if exists bug21114_child; +DROP TABLE bug21114_child; +DROP TABLE geometrytype; +drop table if exists geomfromtext; +drop table if exists bug21114_child; +DROP TABLE bug21114_child; +DROP TABLE geomfromtext; +drop table if exists geomfromwkb; +drop table if exists bug21114_child; +DROP TABLE bug21114_child; +DROP TABLE geomfromwkb; +drop table if exists get_lock; +drop table if exists bug21114_child; +DROP TABLE bug21114_child; +DROP TABLE get_lock; +drop table if exists glength; +drop table if exists bug21114_child; +DROP TABLE bug21114_child; +DROP TABLE glength; +drop table if exists greatest; +drop table if exists bug21114_child; +DROP TABLE bug21114_child; +DROP TABLE greatest; +drop table if exists hex; +drop table if exists bug21114_child; +DROP TABLE bug21114_child; +DROP TABLE hex; +drop table if exists ifnull; +drop table if exists bug21114_child; +DROP TABLE bug21114_child; +DROP TABLE ifnull; +drop table if exists inet_aton; +drop table if exists bug21114_child; +DROP TABLE bug21114_child; +DROP TABLE inet_aton; +drop table if exists inet_ntoa; +drop table if exists bug21114_child; +DROP TABLE bug21114_child; +DROP TABLE inet_ntoa; +drop table if exists instr; +drop table if exists bug21114_child; +DROP TABLE bug21114_child; +DROP TABLE instr; +drop table if exists interiorringn; +drop table if exists bug21114_child; +DROP TABLE bug21114_child; +DROP TABLE interiorringn; +drop table if exists intersects; +drop table if exists bug21114_child; +DROP TABLE bug21114_child; +DROP TABLE intersects; +drop table if exists isclosed; +drop table if exists bug21114_child; +DROP TABLE bug21114_child; +DROP TABLE isclosed; +drop table if exists isempty; +drop table if exists bug21114_child; +DROP TABLE bug21114_child; +DROP TABLE isempty; +drop table if exists isnull; +drop table if exists bug21114_child; +DROP TABLE bug21114_child; +DROP TABLE isnull; +drop table if exists issimple; +drop table if exists bug21114_child; +DROP TABLE bug21114_child; +DROP TABLE issimple; +drop table if exists is_free_lock; +drop table if exists bug21114_child; +DROP TABLE bug21114_child; +DROP TABLE is_free_lock; +drop table if exists is_used_lock; +drop table if exists bug21114_child; +DROP TABLE bug21114_child; +DROP TABLE is_used_lock; +drop table if exists last_day; +drop table if exists bug21114_child; +DROP TABLE bug21114_child; +DROP TABLE last_day; +drop table if exists last_insert_id; +drop table if exists bug21114_child; +DROP TABLE bug21114_child; +DROP TABLE last_insert_id; +drop table if exists lcase; +drop table if exists bug21114_child; +DROP TABLE bug21114_child; +DROP TABLE lcase; +drop table if exists least; +drop table if exists bug21114_child; +DROP TABLE bug21114_child; +DROP TABLE least; +drop table if exists length; +drop table if exists bug21114_child; +DROP TABLE bug21114_child; +DROP TABLE length; +drop table if exists linefromtext; +drop table if exists bug21114_child; +DROP TABLE bug21114_child; +DROP TABLE linefromtext; +drop table if exists linefromwkb; +drop table if exists bug21114_child; +DROP TABLE bug21114_child; +DROP TABLE linefromwkb; +drop table if exists linestringfromtext; +drop table if exists bug21114_child; +DROP TABLE bug21114_child; +DROP TABLE linestringfromtext; +drop table if exists linestringfromwkb; +drop table if exists bug21114_child; +DROP TABLE bug21114_child; +DROP TABLE linestringfromwkb; +drop table if exists ln; +drop table if exists bug21114_child; +DROP TABLE bug21114_child; +DROP TABLE ln; +drop table if exists load_file; +drop table if exists bug21114_child; +DROP TABLE bug21114_child; +DROP TABLE load_file; +drop table if exists locate; +drop table if exists bug21114_child; +DROP TABLE bug21114_child; +DROP TABLE locate; +drop table if exists log; +drop table if exists bug21114_child; +DROP TABLE bug21114_child; +DROP TABLE log; +drop table if exists log10; +drop table if exists bug21114_child; +DROP TABLE bug21114_child; +DROP TABLE log10; +drop table if exists log2; +drop table if exists bug21114_child; +DROP TABLE bug21114_child; +DROP TABLE log2; +drop table if exists lower; +drop table if exists bug21114_child; +DROP TABLE bug21114_child; +DROP TABLE lower; +drop table if exists lpad; +drop table if exists bug21114_child; +DROP TABLE bug21114_child; +DROP TABLE lpad; +drop table if exists ltrim; +drop table if exists bug21114_child; +DROP TABLE bug21114_child; +DROP TABLE ltrim; +drop table if exists makedate; +drop table if exists bug21114_child; +DROP TABLE bug21114_child; +DROP TABLE makedate; +drop table if exists maketime; +drop table if exists bug21114_child; +DROP TABLE bug21114_child; +DROP TABLE maketime; +drop table if exists make_set; +drop table if exists bug21114_child; +DROP TABLE bug21114_child; +DROP TABLE make_set; +drop table if exists master_pos_wait; +drop table if exists bug21114_child; +DROP TABLE bug21114_child; +DROP TABLE master_pos_wait; +drop table if exists mbrcontains; +drop table if exists bug21114_child; +DROP TABLE bug21114_child; +DROP TABLE mbrcontains; +drop table if exists mbrdisjoint; +drop table if exists bug21114_child; +DROP TABLE bug21114_child; +DROP TABLE mbrdisjoint; +drop table if exists mbrequal; +drop table if exists bug21114_child; +DROP TABLE bug21114_child; +DROP TABLE mbrequal; +drop table if exists mbrintersects; +drop table if exists bug21114_child; +DROP TABLE bug21114_child; +DROP TABLE mbrintersects; +drop table if exists mbroverlaps; +drop table if exists bug21114_child; +DROP TABLE bug21114_child; +DROP TABLE mbroverlaps; +drop table if exists mbrtouches; +drop table if exists bug21114_child; +DROP TABLE bug21114_child; +DROP TABLE mbrtouches; +drop table if exists mbrwithin; +drop table if exists bug21114_child; +DROP TABLE bug21114_child; +DROP TABLE mbrwithin; +drop table if exists md5; +drop table if exists bug21114_child; +DROP TABLE bug21114_child; +DROP TABLE md5; +drop table if exists mlinefromtext; +drop table if exists bug21114_child; +DROP TABLE bug21114_child; +DROP TABLE mlinefromtext; +drop table if exists mlinefromwkb; +drop table if exists bug21114_child; +DROP TABLE bug21114_child; +DROP TABLE mlinefromwkb; +drop table if exists monthname; +drop table if exists bug21114_child; +DROP TABLE bug21114_child; +DROP TABLE monthname; +drop table if exists mpointfromtext; +drop table if exists bug21114_child; +DROP TABLE bug21114_child; +DROP TABLE mpointfromtext; +drop table if exists mpointfromwkb; +drop table if exists bug21114_child; +DROP TABLE bug21114_child; +DROP TABLE mpointfromwkb; +drop table if exists mpolyfromtext; +drop table if exists bug21114_child; +DROP TABLE bug21114_child; +DROP TABLE mpolyfromtext; +drop table if exists mpolyfromwkb; +drop table if exists bug21114_child; +DROP TABLE bug21114_child; +DROP TABLE mpolyfromwkb; +drop table if exists multilinestringfromtext; +drop table if exists bug21114_child; +DROP TABLE bug21114_child; +DROP TABLE multilinestringfromtext; +drop table if exists multilinestringfromwkb; +drop table if exists bug21114_child; +DROP TABLE bug21114_child; +DROP TABLE multilinestringfromwkb; +drop table if exists multipointfromtext; +drop table if exists bug21114_child; +DROP TABLE bug21114_child; +DROP TABLE multipointfromtext; +drop table if exists multipointfromwkb; +drop table if exists bug21114_child; +DROP TABLE bug21114_child; +DROP TABLE multipointfromwkb; +drop table if exists multipolygonfromtext; +drop table if exists bug21114_child; +DROP TABLE bug21114_child; +DROP TABLE multipolygonfromtext; +drop table if exists multipolygonfromwkb; +drop table if exists bug21114_child; +DROP TABLE bug21114_child; +DROP TABLE multipolygonfromwkb; +drop table if exists name_const; +drop table if exists bug21114_child; +DROP TABLE bug21114_child; +DROP TABLE name_const; +drop table if exists nullif; +drop table if exists bug21114_child; +DROP TABLE bug21114_child; +DROP TABLE nullif; +drop table if exists numgeometries; +drop table if exists bug21114_child; +DROP TABLE bug21114_child; +DROP TABLE numgeometries; +drop table if exists numinteriorrings; +drop table if exists bug21114_child; +DROP TABLE bug21114_child; +DROP TABLE numinteriorrings; +drop table if exists numpoints; +drop table if exists bug21114_child; +DROP TABLE bug21114_child; +DROP TABLE numpoints; +drop table if exists oct; +drop table if exists bug21114_child; +DROP TABLE bug21114_child; +DROP TABLE oct; +drop table if exists octet_length; +drop table if exists bug21114_child; +DROP TABLE bug21114_child; +DROP TABLE octet_length; +drop table if exists ord; +drop table if exists bug21114_child; +DROP TABLE bug21114_child; +DROP TABLE ord; +drop table if exists overlaps; +drop table if exists bug21114_child; +DROP TABLE bug21114_child; +DROP TABLE overlaps; +drop table if exists period_add; +drop table if exists bug21114_child; +DROP TABLE bug21114_child; +DROP TABLE period_add; +drop table if exists period_diff; +drop table if exists bug21114_child; +DROP TABLE bug21114_child; +DROP TABLE period_diff; +drop table if exists pi; +drop table if exists bug21114_child; +DROP TABLE bug21114_child; +DROP TABLE pi; +drop table if exists pointfromtext; +drop table if exists bug21114_child; +DROP TABLE bug21114_child; +DROP TABLE pointfromtext; +drop table if exists pointfromwkb; +drop table if exists bug21114_child; +DROP TABLE bug21114_child; +DROP TABLE pointfromwkb; +drop table if exists pointn; +drop table if exists bug21114_child; +DROP TABLE bug21114_child; +DROP TABLE pointn; +drop table if exists polyfromtext; +drop table if exists bug21114_child; +DROP TABLE bug21114_child; +DROP TABLE polyfromtext; +drop table if exists polyfromwkb; +drop table if exists bug21114_child; +DROP TABLE bug21114_child; +DROP TABLE polyfromwkb; +drop table if exists polygonfromtext; +drop table if exists bug21114_child; +DROP TABLE bug21114_child; +DROP TABLE polygonfromtext; +drop table if exists polygonfromwkb; +drop table if exists bug21114_child; +DROP TABLE bug21114_child; +DROP TABLE polygonfromwkb; +drop table if exists pow; +drop table if exists bug21114_child; +DROP TABLE bug21114_child; +DROP TABLE pow; +drop table if exists power; +drop table if exists bug21114_child; +DROP TABLE bug21114_child; +DROP TABLE power; +drop table if exists quote; +drop table if exists bug21114_child; +DROP TABLE bug21114_child; +DROP TABLE quote; +drop table if exists radians; +drop table if exists bug21114_child; +DROP TABLE bug21114_child; +DROP TABLE radians; +drop table if exists rand; +drop table if exists bug21114_child; +DROP TABLE bug21114_child; +DROP TABLE rand; +drop table if exists release_lock; +drop table if exists bug21114_child; +DROP TABLE bug21114_child; +DROP TABLE release_lock; +drop table if exists reverse; +drop table if exists bug21114_child; +DROP TABLE bug21114_child; +DROP TABLE reverse; +drop table if exists round; +drop table if exists bug21114_child; +DROP TABLE bug21114_child; +DROP TABLE round; +drop table if exists row_count; +drop table if exists bug21114_child; +DROP TABLE bug21114_child; +DROP TABLE row_count; +drop table if exists rpad; +drop table if exists bug21114_child; +DROP TABLE bug21114_child; +DROP TABLE rpad; +drop table if exists rtrim; +drop table if exists bug21114_child; +DROP TABLE bug21114_child; +DROP TABLE rtrim; +drop table if exists sec_to_time; +drop table if exists bug21114_child; +DROP TABLE bug21114_child; +DROP TABLE sec_to_time; +drop table if exists session_user; +drop table if exists bug21114_child; +DROP TABLE bug21114_child; +DROP TABLE session_user; +drop table if exists sha; +drop table if exists bug21114_child; +DROP TABLE bug21114_child; +DROP TABLE sha; +drop table if exists sha1; +drop table if exists bug21114_child; +DROP TABLE bug21114_child; +DROP TABLE sha1; +drop table if exists sign; +drop table if exists bug21114_child; +DROP TABLE bug21114_child; +DROP TABLE sign; +drop table if exists sin; +drop table if exists bug21114_child; +DROP TABLE bug21114_child; +DROP TABLE sin; +drop table if exists sleep; +drop table if exists bug21114_child; +DROP TABLE bug21114_child; +DROP TABLE sleep; +drop table if exists soundex; +drop table if exists bug21114_child; +DROP TABLE bug21114_child; +DROP TABLE soundex; +drop table if exists space; +drop table if exists bug21114_child; +DROP TABLE bug21114_child; +DROP TABLE space; +drop table if exists sqrt; +drop table if exists bug21114_child; +DROP TABLE bug21114_child; +DROP TABLE sqrt; +drop table if exists srid; +drop table if exists bug21114_child; +DROP TABLE bug21114_child; +DROP TABLE srid; +drop table if exists startpoint; +drop table if exists bug21114_child; +DROP TABLE bug21114_child; +DROP TABLE startpoint; +drop table if exists strcmp; +drop table if exists bug21114_child; +DROP TABLE bug21114_child; +DROP TABLE strcmp; +drop table if exists str_to_date; +drop table if exists bug21114_child; +DROP TABLE bug21114_child; +DROP TABLE str_to_date; +drop table if exists subdate; +drop table if exists bug21114_child; +DROP TABLE bug21114_child; +DROP TABLE subdate; +drop table if exists substring_index; +drop table if exists bug21114_child; +DROP TABLE bug21114_child; +DROP TABLE substring_index; +drop table if exists subtime; +drop table if exists bug21114_child; +DROP TABLE bug21114_child; +DROP TABLE subtime; +drop table if exists system_user; +drop table if exists bug21114_child; +DROP TABLE bug21114_child; +DROP TABLE system_user; +drop table if exists tan; +drop table if exists bug21114_child; +DROP TABLE bug21114_child; +DROP TABLE tan; +drop table if exists timediff; +drop table if exists bug21114_child; +DROP TABLE bug21114_child; +DROP TABLE timediff; +drop table if exists time_format; +drop table if exists bug21114_child; +DROP TABLE bug21114_child; +DROP TABLE time_format; +drop table if exists time_to_sec; +drop table if exists bug21114_child; +DROP TABLE bug21114_child; +DROP TABLE time_to_sec; +drop table if exists touches; +drop table if exists bug21114_child; +DROP TABLE bug21114_child; +DROP TABLE touches; +drop table if exists to_days; +drop table if exists bug21114_child; +DROP TABLE bug21114_child; +DROP TABLE to_days; +drop table if exists ucase; +drop table if exists bug21114_child; +DROP TABLE bug21114_child; +DROP TABLE ucase; +drop table if exists uncompress; +drop table if exists bug21114_child; +DROP TABLE bug21114_child; +DROP TABLE uncompress; +drop table if exists uncompressed_length; +drop table if exists bug21114_child; +DROP TABLE bug21114_child; +DROP TABLE uncompressed_length; +drop table if exists unhex; +drop table if exists bug21114_child; +DROP TABLE bug21114_child; +DROP TABLE unhex; +drop table if exists unix_timestamp; +drop table if exists bug21114_child; +DROP TABLE bug21114_child; +DROP TABLE unix_timestamp; +drop table if exists updatexml; +drop table if exists bug21114_child; +DROP TABLE bug21114_child; +DROP TABLE updatexml; +drop table if exists upper; +drop table if exists bug21114_child; +DROP TABLE bug21114_child; +DROP TABLE upper; +drop table if exists uuid; +drop table if exists bug21114_child; +DROP TABLE bug21114_child; +DROP TABLE uuid; +drop table if exists version; +drop table if exists bug21114_child; +DROP TABLE bug21114_child; +DROP TABLE version; +drop table if exists weekday; +drop table if exists bug21114_child; +DROP TABLE bug21114_child; +DROP TABLE weekday; +drop table if exists weekofyear; +drop table if exists bug21114_child; +DROP TABLE bug21114_child; +DROP TABLE weekofyear; +drop table if exists within; +drop table if exists bug21114_child; +DROP TABLE bug21114_child; +DROP TABLE within; +drop table if exists x; +drop table if exists bug21114_child; +DROP TABLE bug21114_child; +DROP TABLE x; +drop table if exists y; +drop table if exists bug21114_child; +DROP TABLE bug21114_child; +DROP TABLE y; +drop table if exists yearweek; +drop table if exists bug21114_child; +DROP TABLE bug21114_child; +DROP TABLE yearweek; |