--source include/have_innodb.inc CREATE TABLE t2 ( col_int INT(4) UNSIGNED NOT NULL DEFAULT 0 /*!100303 INVISIBLE */, col_bit BIT(30) NULL, col_year YEAR NOT NULL DEFAULT '1970', vcol_char CHAR(12) AS (col_char) /*!50701 STORED */ /*!100000 PERSISTENT */, col_dec DECIMAL(39,0) NULL, vcol_int BIGINT(56) AS (col_int) VIRTUAL /*!100303 INVISIBLE */, col_blob BLOB NULL, vcol_enum SET('','a','b','c','d','e','f','foo','bar') AS (col_enum) /*!50701 STORED */ /*!100000 PERSISTENT */, vcol_blob LONGBLOB AS (col_blob) /*!50701 STORED */ /*!100000 PERSISTENT */, col_timestamp TIMESTAMP(5) NOT NULL DEFAULT '1971-01-01 00:00:00', vcol_dec DECIMAL(30,21) ZEROFILL AS (col_dec) /*!50701 STORED */ /*!100000 PERSISTENT */, col_time TIME(1) NULL, vcol_year YEAR AS (col_year) /*!50701 STORED */ /*!100000 PERSISTENT */ /*!100303 INVISIBLE */, vcol_datetime DATETIME(6) AS (col_datetime) /*!50701 STORED */ /*!100000 PERSISTENT */ /*!100303 INVISIBLE */, col_date DATE NULL /*!100303 INVISIBLE */, col_datetime DATETIME NOT NULL DEFAULT '1900-01-01 00:00:00', col_char CHAR(162) NULL, col_varchar VARBINARY(834) NOT NULL DEFAULT '' /*!100302 */, pk SERIAL, vcol_timestamp TIMESTAMP(5) AS (col_timestamp) /*!50701 STORED */ /*!100000 PERSISTENT */, vcol_bit BIT(35) AS (col_bit) /*!50701 STORED */ /*!100000 PERSISTENT */ /*!100303 INVISIBLE */, vcol_date DATE AS (col_date) VIRTUAL, col_enum SET('','a','b','c','d','e','f','foo','bar') NOT NULL DEFAULT '', PRIMARY KEY(pk) ) ENGINE=InnoDB /* QNO 14 CON_ID 10 */; CREATE VIEW view_t2 AS SELECT * FROM t2 /* QNO 15 CON_ID 10 */; ALTER TABLE t2 ADD INDEX(vcol_date,col_date,vcol_year,col_bit) /* QNO 16 CON_ID 10 */; INSERT IGNORE INTO t2 (col_int,col_bit,col_year,col_dec,col_blob,col_timestamp,col_time,col_date,col_datetime,col_char,col_varchar,col_enum) VALUES (1,b'10100000000111010011111',1977,0.338790893554688,'eky','2014-10-14 17:31:08.046973',NULL,'2015-04-14','2016-10-18 02:03:50.007589','k','yjgbpm','') /* QNO 23 CON_ID 10 */; CREATE TABLE t9 ( col_blob TEXT NOT NULL DEFAULT '' /*!100302 */, vcol_bit BIT(25) AS (col_bit) /*!50701 STORED */ /*!100000 PERSISTENT */, col_varchar VARBINARY(2732) NULL /*!100302 */, vcol_timestamp TIMESTAMP(2) AS (col_timestamp) VIRTUAL, col_char BINARY(100) NOT NULL DEFAULT '', col_time TIME(6) NULL, col_date DATE NOT NULL DEFAULT '1900-01-01', col_datetime DATETIME(6) NULL, vcol_int INT(27) ZEROFILL AS (col_int) /*!50701 STORED */ /*!100000 PERSISTENT */, vcol_datetime DATETIME(4) AS (col_datetime) /*!50701 STORED */ /*!100000 PERSISTENT */, vcol_year YEAR AS (col_year) /*!50701 STORED */ /*!100000 PERSISTENT */, vcol_dec DECIMAL(65,30) ZEROFILL AS (col_dec) /*!50701 STORED */ /*!100000 PERSISTENT */, col_bit BIT(30) NOT NULL DEFAULT 0, col_int TINYINT(35) UNSIGNED ZEROFILL NULL, pk SERIAL, vcol_blob TINYBLOB AS (col_blob) VIRTUAL, col_year YEAR NULL, vcol_enum ENUM('','a','b','c','d','e','f','foo','bar') AS (col_enum) VIRTUAL, vcol_date DATE AS (col_date) VIRTUAL, col_enum ENUM('','a','b','c','d','e','f','foo','bar') NOT NULL DEFAULT '', col_dec DECIMAL(56,0) ZEROFILL NOT NULL DEFAULT 0 /*!100303 INVISIBLE */, col_timestamp TIMESTAMP(6) NULL, PRIMARY KEY(pk) ) ENGINE=InnoDB /* QNO 89 CON_ID 10 */; #CREATE VIEW view_t9 AS SELECT * FROM t9 /* QNO 90 CON_ID 10 */; --let $con11_id= SELECT CONNECTION_ID() AS con11 CREATE TABLE table300_innodb_int_autoinc ( col_char_255_utf8_fulltext_key_default_null char(255) CHARACTER SET utf8 default null, col_varchar_355_utf8_fulltext_key varchar(355) CHARACTER SET utf8, col_char_255_latin1_fulltext_key_default_null char(255) CHARACTER SET latin1 default null, col_varchar_255_latin1_fulltext_key varchar(255) CHARACTER SET latin1, col_varchar_355_utf8_fulltext_key_not_null varchar(355) CHARACTER SET utf8 not null, col_varchar_255_utf8_fulltext_key_not_null varchar(255) CHARACTER SET utf8 not null, col_varchar_255_utf8_fulltext_key varchar(255) CHARACTER SET utf8, pk integer auto_increment, col_char_255_latin1_fulltext_key char(255) CHARACTER SET latin1, col_varchar_355_latin1_fulltext_key varchar(355) CHARACTER SET latin1, col_varchar_355_latin1_fulltext_key_not_null varchar(355) CHARACTER SET latin1 not null, col_varchar_255_latin1_fulltext_key_default_null varchar(255) CHARACTER SET latin1 default null, col_char_255_utf8_fulltext_key char(255) CHARACTER SET utf8, col_varchar_255_latin1_fulltext_key_not_null varchar(255) CHARACTER SET latin1 not null, col_varchar_255_utf8_fulltext_key_default_null varchar(255) CHARACTER SET utf8 default null, col_char_255_latin1_fulltext_key_not_null char(255) CHARACTER SET latin1 not null, col_varchar_355_utf8_fulltext_key_default_null varchar(355) CHARACTER SET utf8 default null, col_varchar_355_latin1_fulltext_key_default_null varchar(355) CHARACTER SET latin1 default null, col_char_255_utf8_fulltext_key_not_null char(255) CHARACTER SET utf8 not null, primary key (pk), fulltext key (col_char_255_utf8_fulltext_key_not_null )) ENGINE=innodb /* QNO 123 CON_ID 11 */; INSERT /*! IGNORE */ INTO table300_innodb_int_autoinc VALUES ('attention', 'developmental', 'dedicate', 'use', 'wherever', 'immediate', 'ear', NULL, 'shooting', 'surveillance', 'merit', 'slope', 'usually', 'soften', 'comfortable', 'structure', 'evaluation', 'organ', 'edition') , ('rib', 'array', 'herb', 'banker', 'wildlife', 'give', 'allegedly', NULL, 'workout', 'isolate', 'suck', 'recruit', 'snap', 'timing', 'troop', 'costume', 'repair', 'historian', 'electrical') , ('delicate', 'ambitious', 'bitter', 'grow', 'peasant', 'number', 'being', NULL, 'wine', 'charm', 'dust', 'undergo', 'within', 'reporting', 'divine', 'central', 'voting', 'adolescent', 'maybe') , ('coffee', 'library', 'psychological', 'single', 'sneak', 'introduction', 'speed', NULL, 'occupy', 'actually', 'one-third', 'native', 'word', 'golf', 'book', 'automatically', 'repair', 'cheat', 'adjust') , ('enhance', 'guest', 'easy', 'depending', 'selection', 'yet', 'spread', NULL, 'legally', 'mean', 'coordinator', 'character', 'relatively', 'though', 'trend', 'life', 'correctly', 'pig', 'basement') , ('substantially', 'especially', 'computer', 'greatest', 'transform', 'equality', 'sick', NULL, 'label', 'undertake', 'frontier', 'chunk', 'sympathy', 'educator', 'yard', 'rest', 'conviction', 'explore', 'specialize') , ('share', 'grant', 'seemingly', 'fixed', 'respect', 'management', 'service', NULL, 'idea', 'depression', 'timber', 'capture', 'arrive', 'spiritual', 'credit', 'absolutely', 'incorporate', 'system', 'dried') , ('vital', 'swear', 'coordinator', 'political', 'how', 'construction', 'regular', NULL, 'century', 'bet', 'alley', 'yield', 'wrap', 'radical', 'athletic', 'grace', 'owner', 'emergency', 'negotiate') , ('output', 'cholesterol', 'shirt', 'leg', 'flexibility', 'broken', 'sack', NULL, 'beef', 'pizza', 'fame', 'twice', 'master', 'liquid', 'beauty', 'challenge', 'confront', 'dna', 'spanish') , ('slave', 'ecosystem', 'ironically', 'venture', 'graduation', 'jazz', 'aside', NULL, 'surgeon', 'incident', 'love', 'liability', 'oral', 'journal', 'grain', 'dissolve', 'invest', 'evil', 'all') , ('alone', 'notice', 'safely', 'talent', 'emphasis', 'acid', 'transport', NULL, 'player', 'darkness', 'relevant', 'patch', 'conclude', 'attract', 'meantime', 'ethical', 'strike', 'loyal', 'parental') , ('screw', 'appeal', 'sometimes', 'religious', 'complicated', 'totally', 'breathe', NULL, 'teacher', 'rope', 'relax', 'violate', 'marketplace', 'unhappy', 'classroom', 'stadium', 'store', 'life', 'finally') , ('another', 'extension', 'transit', 'equal', 'idea', 'virtual', 'experienced', NULL, 'restrict', 'creative', 'clearly', 'cease', 'plastic', 'presentation', 'burn', 'counselor', 'universal', 'enough', 'ambassador') , ('tournament', 'specifically', 'fight', 'christian', 'innovation', 'as', 'hey', NULL, 'perspective', 'used', 'branch', 'prosecution', 'publicity', 'invade', 'before', 'vanish', 'reservation', 'twist', 'realm') , ('composition', 'slight', 'premium', 'rally', 'threshold', 'construction', 'frustrate', NULL, 'world', 'thus', 'everything', 'within', 'directly', 'man', 'height', 'amendment', 'queen', 'father', 'throat') , ('accomplish', 'closet', 'construct', 'shoe', 'short', 'her', 'anywhere', NULL, 'syndrome', 'her', 'bite', 'miss', 'interfere', 'touchdown', 'life', 'capital', 'closed', 'coach', 'cop') , ('satisfaction', 'acid', 'butterfly', 'fortune', 'analyst', 'factor', 'brother', NULL, 'village', 'fragment', 'find', 'protest', 'disc', 'absolutely', 'success', 'jeans', 'pillow', 'boot', 'imagine') , ('person', 'smooth', 'popularity', 'facilitate', 'enact', 'weed', 'sidewalk', NULL, 'vary', 'carbon', 'poet', 'committee', 'satisfaction', 'jar', 'traffic', 'remaining', 'doorway', 'nose', 'deeply') , ('appoint', 'excitement', 'capital', 'would', 'can', 'inventory', 'frequent', NULL, 'conflict', 'hello', 'population', 'hug', 'evening', 'horse', 'institutional', 'exciting', 'vary', 'cheek', 'hostage') , ('tall', 'ridge', 'bear', 'enforcement', 'cease', 'touch', 'accommodate', NULL, 'likewise', 'drown', 'suspect', 'metal', 'bankruptcy', 'student', 'bare', 'surely', 'suburban', 'afternoon', 'offer') , ('gather', 'dig', 'year', 'used', 'likely', 'supportive', 'belt', NULL, 'person', 'amount', 'hormone', 'researcher', 'press', 'diabetes', 'follow', 'leap', 'technician', 'now', 'badly') , ('independence', 'burning', 'person', 'ie', 'stomach', 'telephone', 'harsh', NULL, 'cost', 'commander', 'fair', 'layer', 'kick', 'blond', 'nightmare', 'inquiry', 'examine', 'collector', 'button') , ('scene', 'ceremony', 'volunteer', 'halfway', 'epidemic', 'daily', 'reporter', NULL, 'persuade', 'nasty', 'foreign', 'skill', 'manage', 'relief', 'fortune', 'severe', 'clerk', 'list', 'clip') , ('crime', 'boil', 'proof', 'running', 'implementation', 'play', 'reward', NULL, 'prefer', 'fabric', 'context', 'bias', 'choose', 'tourism', 'headline', 'rebuild', 'claim', 'appeal', 'bowl') , ('decision', 'class', 'court', 'ms', 'affair', 'royal', 'swear', NULL, 'aggressive', 'implementation', 'romantic', 'door', 'storm', 'scope', 'use', 'highlight', 'back', 'psychological', 'gut') , ('coordinate', 'could', 'obtain', 'sing', 'emission', 'decision', 'holiday', NULL, 'korean', 'origin', 'dramatic', 'race', 'host', 'willingness', 'leave', 'barrier', 'fill', 'casino', 'call') , ('to', 'tool', 'on', 'pencil', 'cat', 'current', 'stock', NULL, 'wind', 'well', 'conclude', 'package', 'twist', 'assistant', 'knee', 'decorate', 'retire', 'what', 'overcome') , ('spring', 'ultimate', 'fighting', 'rain', 'meeting', 'help', 'playoff', NULL, 'skilled', 'teaching', 'defend', 'miracle', 'child', 'glove', 'district', 'classify', 'sacrifice', 'awareness', 'radical') , ('wish', 'huge', 'portray', 'patent', 'discovery', 'check', 'substance', NULL, 'machine', 'radiation', 'minister', 'timber', 'obstacle', 'risky', 'function', 'gender', 'direction', 'ago', 'priest') , ('bare', 'hardware', 'policy', 'maybe', 'early', 'continuous', 'criticism', NULL, 'main', 'recording', 'guy', 'expectation', 'trunk', 'anyone', 'general', 'duck', 'dominant', 'managing', 'enthusiasm') , ('uncertain', 'identity', 'clinical', 'stone', 'grab', 'small', 'compare', NULL, 'detail', 'suburban', 'ski', 'assistant', 'comedy', 'array', 'japanese', 'brave', 'strength', 'salary', 'railroad') , ('dominant', 'out', 'television', 'vessel', 'discourse', 'glory', 'behave', NULL, 'deal', 'rely', 'document', 'creative', 'loose', 'region', 'cultural', 'claim', 'direct', 'slot', 'official') , ('attract', 'availability', 'garage', 'chief', 'healthy', 'consume', 'dream', NULL, 'remember', 'struggle', 'clock', 'frown', 'encounter', 'badly', 'mouth', 'fur', 'massive', 'wonder', 'engage') , ('offer', 'adequate', 'display', 'great', 'timber', 'bus', 'comprise', NULL, 'context', 'attach', 'table', 'nothing', 'assign', 'insurance', 'tire', 'network', 'grasp', 'jaw', 'sensitive') , ('weak', 'float', 'schedule', 'coordinator', 'conscience', 'territory', 'prior', NULL, 'israeli', 'journal', 'upstairs', 'statute', 'exam', 'debris', 'activity', 'agency', 'which', 'frown', 'dismiss') , ('loop', 'seal', 'canadian', 'psychological', 'preparation', 'freely', 'charge', NULL, 'cholesterol', 'slavery', 'option', 'tender', 'isolate', 'start', 'others', 'terror', 'feeling', 'declare', 'determine') , ('average', 'interest', 'retail', 'sophisticated', 'frame', 'denial', 'awful', NULL, 'rest', 'adjustment', 'between', 'winter', 'soul', 'age', 'engage', 'opera', 'aesthetic', 'hunger', 'dumb') , ('gentleman', 'intent', 'forehead', 'abortion', 'federal', 'music', 'resort', NULL, 'many', 'divorce', 'direct', 'organic', 'campaign', 'perfectly', 'designer', 'lab', 'fill', 'pack', 'unable') , ('gather', 'likely', 'draft', 'merchant', 'ever', 'steel', 'scientific', NULL, 'loyalty', 'cultural', 'recession', 'bother', 'moderate', 'innocent', 'kitchen', 'offense', 'would', 'guide', 'traffic') , ('legitimate', 'ritual', 'back', 'figure', 'diet', 'that', 'keep', NULL, 'racism', 'come', 'sunny', 'limitation', 'english', 'loose', 'large', 'rib', 'touchdown', 'wrap', 'diversity') , ('effectiveness', 'hit', 'we', 'outcome', 'encourage', 'suspend', 'sense', NULL, 'himself', 'exclusive', 'corporation', 'supply', 'reaction', 'queen', 'gather', 'conservative', 'american', 'killer', 'theater') , ('one-third', 'electronic', 'cup', 'bare', 'assert', 'kind', 'work', NULL, 'port', 'row', 'businessman', 'lesson', 'girlfriend', 'corporate', 'party', 'alleged', 'admit', 'rely', 'trip') , ('anonymous', 'spite', 'withdraw', 'upon', 'branch', 'crazy', 'numerous', NULL, 'neighboring', 'limitation', 'however', 'prominent', 'foot', 'extremely', 'bite', 'vacation', 'rough', 'season', 'law') , ('removal', 'shoot', 'beneath', 'backyard', 'pretty', 'fame', 'terrorism', NULL, 'explain', 'mixed', 'encounter', 'slot', 'responsible', 'philosophy', 'active', 'classify', 'wealthy', 'death', 'guy') , ('evolution', 'legal', 'insert', 'fortunately', 'anger', 'autonomy', 'scandal', NULL, 'parade', 'voice', 'along', 'starter', 'sexually', 'weigh', 'independent', 'trust', 'classic', 'mark', 'bullet') , ('every', 'secondary', 'missionary', 'productivity', 'either', 'technician', 'follow', NULL, 'at', 'withdraw', 'vacation', 'guest', 'farm', 'spray', 'doctor', 'array', 'pie', 'surgery', 'coalition') , ('planet', 'trial', 'survey', 'permanent', 'provider', 'frequently', 'tighten', NULL, 'specify', 'asset', 'inspection', 'extent', 'judge', 'light', 'equip', 'either', 'stranger', 'string', 'recall') , ('presence', 'array', 'fail', 'rank', 'dancing', 'ambition', 'channel', NULL, 'mysterious', 'inside', 'hence', 'process', 'outcome', 'limit', 'extended', 'prevent', 'after', 'parent', 'he') , ('theater', 'dangerous', 'user', 'length', 'musical', 'cage', 'short', NULL, 'shortly', 'active', 'difference', 'period', 'mission', 'radiation', 'frown', 'author', 'longtime', 'controversy', 'god') , ('patient', 'daughter', 'found', 'officially', 'huh', 'normal', 'compensation', NULL, 'black', 'magnetic', 'deeply', 'freeze', 'fund', 'refuge', 'secure', 'tell', 'killing', 'family', 'add') /* QNO 128 CON_ID 11 */; SET SQL_MODE= '' /* QNO 161 CON_ID 17 */; DROP TABLE t9; INSERT INTO t2 ( col_datetime ) VALUES ( 'habit' ) /* QNO 777 CON_ID 17 */; INSERT INTO t2 ( col_datetime ) VALUES ( 'beef' ) /* QNO 782 CON_ID 17 */; INSERT INTO view_t2 ( col_datetime ) VALUES ( 'nominee' ) /* QNO 809 CON_ID 17 */; ALTER TABLE t2 ADD SYSTEM VERSIONING /* QNO 1075 CON_ID 16 */; INSERT INTO view_t2 ( col_char ) VALUES ( 'dining' ) /* QNO 848 CON_ID 17 */; INSERT INTO view_t2 ( col_year ) VALUES ( 'carrier' ) /* QNO 1000 CON_ID 19 */; INSERT INTO view_t2 ( col_time ) VALUES ( 'detective' ) /* QNO 756 CON_ID 18 */; INSERT INTO view_t2 ( col_varchar ) VALUES ( 'celebrity' ) /* QNO 762 CON_ID 18 */; INSERT INTO view_t2 ( col_blob ) VALUES ( 'wheel' ) /* QNO 1137 CON_ID 16 */; INSERT INTO view_t2 ( vcol_char ) VALUES ( 'blind' ) /* QNO 1131 CON_ID 19 */; INSERT INTO t2 ( col_varchar ) VALUES ( 'reward' ) /* QNO 1208 CON_ID 19 */; ALTER TABLE table300_innodb_int_autoinc ADD COLUMN IF NOT EXISTS ( tcol7 YEAR, scol8 BLOB NOT NULL ) /* QNO 1255 CON_ID 19 */; INSERT INTO t2 ( col_dec ) VALUES ( 'wave' ) /* QNO 1057 CON_ID 20 */; INSERT INTO view_t2 ( vcol_dec ) VALUES ( 'uncertainty' ) /* QNO 957 CON_ID 18 */; INSERT INTO view_t2 ( col_time ) VALUES ( 'partial' ) /* QNO 1059 CON_ID 18 */; INSERT INTO t2 () VALUES (),() /* QNO 1149 CON_ID 21 */; INSERT INTO t2 ( col_time ) VALUES ( 'dealer' ) /* QNO 1292 CON_ID 19 */; INSERT INTO t2 ( col_char ) VALUES ( 'hero' ) /* QNO 1395 CON_ID 19 */; INSERT INTO view_t2 ( vcol_date ) VALUES ( 'properly' ) /* QNO 1374 CON_ID 21 */; INSERT INTO view_t2 ( vcol_char ) VALUES ( 'passage' ) /* QNO 1489 CON_ID 16 */; ALTER IGNORE TABLE t2 RENAME TO t9 /* QNO 1412 CON_ID 21 */; INSERT INTO t9 ( vcol_enum ) VALUES ( 'privacy' ) /* QNO 1667 CON_ID 19 */; INSERT INTO t9 ( col_datetime ) VALUES ( 'relative' ) /* QNO 1751 CON_ID 16 */; INSERT INTO t9 ( col_char ) VALUES ( 'glove' ) /* QNO 1909 CON_ID 19 */; INSERT INTO t9 ( vcol_date ) VALUES ( 'elephant' ) /* QNO 1575 CON_ID 18 */; SELECT * FROM t9 INTO OUTFILE 'load_t9' /* QNO 1934 CON_ID 19 */; TRUNCATE TABLE t9 /* QNO 2217 CON_ID 19 */; CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `view_t9` AS select `t9`.`col_blob` AS `col_blob`,`t9`.`vcol_bit` AS `vcol_bit`,`t9`.`col_varchar` AS `col_varchar`,`t9`.`vcol_timestamp` AS `vcol_timestamp`,`t9`.`col_char` AS `col_char`,`t9`.`col_time` AS `col_time`,`t9`.`col_date` AS `col_date`,`t9`.`col_datetime` AS `col_datetime`,`t9`.`vcol_int` AS `vcol_int`,`t9`.`vcol_datetime` AS `vcol_datetime`,`t9`.`vcol_year` AS `vcol_year`,`t9`.`vcol_dec` AS `vcol_dec`,`t9`.`col_bit` AS `col_bit`,`t9`.`col_int` AS `col_int`,`t9`.`pk` AS `pk`,`t9`.`vcol_blob` AS `vcol_blob`,`t9`.`col_year` AS `col_year`,`t9`.`vcol_enum` AS `vcol_enum`,`t9`.`vcol_date` AS `vcol_date`,`t9`.`col_enum` AS `col_enum`,`t9`.`col_timestamp` AS `col_timestamp` from `t9`; INSERT INTO view_t9 SELECT * FROM table300_innodb_int_autoinc /* QNO 2235 CON_ID 19 */; SET SQL_MODE= DEFAULT /* QNO 1945 CON_ID 17 */; --error 1406 LOAD DATA INFILE 'load_t9' REPLACE INTO TABLE t9; SELECT DISTINCT table_schema, table_name FROM information_schema.columns;