call mtr.add_suppression("Table 'test_repair_table2' is marked as crashed and should be repaired"); call mtr.add_suppression("Table 'test_repair_table4' is marked as crashed and should be repaired"); drop table if exists t1,t2,t3,t4; CREATE TABLE t1 ( Period smallint(4) unsigned zerofill DEFAULT '0000' NOT NULL, Varor_period smallint(4) unsigned DEFAULT '0' NOT NULL ) ENGINE = CSV; INSERT INTO t1 VALUES (9410,9412); select period from t1; period 9410 select * from t1; Period Varor_period 9410 9412 select t1.* from t1; Period Varor_period 9410 9412 CREATE TABLE t2 ( auto int not null, fld1 int(6) unsigned zerofill DEFAULT '000000' NOT NULL, companynr tinyint(2) unsigned zerofill DEFAULT '00' NOT NULL, fld3 char(30) DEFAULT '' NOT NULL, fld4 char(35) DEFAULT '' NOT NULL, fld5 char(35) DEFAULT '' NOT NULL, fld6 char(4) DEFAULT '' NOT NULL ) ENGINE = CSV; select t2.fld3 from t2 where companynr = 58 and fld3 like "%imaginable%"; fld3 imaginable select fld3 from t2 where fld3 like "%cultivation" ; fld3 cultivation select t2.fld3,companynr from t2 where companynr = 57+1 order by fld3; fld3 companynr concoct 58 druggists 58 engrossing 58 Eurydice 58 exclaimers 58 ferociousness 58 hopelessness 58 Huey 58 imaginable 58 judges 58 merging 58 ostrich 58 peering 58 Phelps 58 presumes 58 Ruth 58 sentences 58 Shylock 58 straggled 58 synergy 58 thanking 58 tying 58 unlocks 58 select fld3,companynr from t2 where companynr = 58 order by fld3; fld3 companynr concoct 58 druggists 58 engrossing 58 Eurydice 58 exclaimers 58 ferociousness 58 hopelessness 58 Huey 58 imaginable 58 judges 58 merging 58 ostrich 58 peering 58 Phelps 58 presumes 58 Ruth 58 sentences 58 Shylock 58 straggled 58 synergy 58 thanking 58 tying 58 unlocks 58 select fld3 from t2 order by fld3 desc limit 10; fld3 youthfulness yelped Wotan workers Witt witchcraft Winsett Willy willed wildcats select fld3 from t2 order by fld3 desc limit 5; fld3 youthfulness yelped Wotan workers Witt select fld3 from t2 order by fld3 desc limit 5,5; fld3 witchcraft Winsett Willy willed wildcats UPDATE t2 SET fld3="foo" WHERE fld3="b%"; select fld3 from t2; fld3 Omaha breaking Romans intercepted bewilderingly astound admonishing sumac flanking combed subjective scatterbrain Eulerian dubbed Kane overlay perturb goblins annihilates Wotan snatching concludes laterally yelped grazing Baird celery misunderstander handgun foldout mystic succumbed Nabisco fingerings aging afield ammonium boat intelligibility Augustine teethe dreaded scholastics audiology wallet parters eschew quitter neat Steinberg jarring tinily balled persist attainments fanatic measures rightfulness capably impulsive starlet terminators untying announces featherweight pessimist daughter decliner lawgiver stated readable attrition cascade motors interrogate pests stairway dopers testicle Parsifal leavings postulation squeaking contrasted leftover whiteners erases Punjab Merritt Quixotism sweetish dogging scornfully bellow bills cupboard sureties puddings tapestry fetters bivalves incurring Adolph pithed emergency Miles trimmings tragedies skulking flint flopping relaxing offload suites lists animized multilayer standardizes Judas vacuuming dentally humanness inch Weissmuller irresponsibly luckily culled medical bloodbath subschema animals Micronesia repetitions Antares ventilate pityingly interdependent Graves neonatal scribbled chafe honoring realtor elite funereal abrogating sorters Conley lectured Abraham Hawaii cage hushes Simla reporters Dutchman descendants groupings dissociate coexist Beebe Taoism Connally fetched checkpoints rusting galling obliterates traitor resumes analyzable terminator gritty firearm minima Selfridge disable witchcraft betroth Manhattanize imprint peeked swelling interrelationships riser Gandhian peacock bee kanji dental scarf chasm insolence syndicate alike imperial convulsion railway validate normalizes comprehensive chewing denizen schemer chronicle Kline Anatole partridges brunch recruited dimensions Chicana announced praised employing linear quagmire western relishing serving scheduling lore eventful arteriole disentangle cured Fenton avoidable drains detectably husky impelling undoes evened squeezes destroyer rudeness beaner boorish Everhart encompass mushrooms Alison externally pellagra cult creek Huffman Majorca governing gadfly reassigned intentness craziness psychic squabbled burlesque capped extracted DiMaggio exclamation subdirectory fangs buyer pithing transistorizing nonbiodegradable dislocate monochromatic batting postcondition catalog Remus devices bike qualify detained commended civilize Elmhurst anesthetizing deaf Brigham title coarse combinations grayness innumerable Caroline fatty eastbound inexperienced hoarder scotch passport strategic gated flog Pipestone Dar Corcoran flyers competitions suppliers skips institutes troop connective denies polka observations askers homeless Anna subdirectories decaying outwitting Harpy crazed suffocate provers technically Franklinizations considered tinnily uninterruptedly whistled automate gutting surreptitious Choctaw cooks millivolt counterpoise Gothicism feminine metaphysically sanding contributorily receivers adjourn straggled druggists thanking ostrich hopelessness Eurydice excitation presumes imaginable concoct peering Phelps ferociousness sentences unlocks engrossing Ruth tying exclaimers synergy Huey merging judges Shylock Miltonism hen honeybee towers dilutes numerals democracy Ibero- invalids behavior accruing relics rackets Fischbein phony cross cleanup conspirator label university cleansed ballgown starlet aqueous portrayal despising distort palmed faced silverware assessor spiders artificially reminiscence Mexican obnoxious fragile apprehensible births garages panty anteater displacement drovers patenting far shrieks aligning pragmatism fevers reexamines occupancies sweats modulators demand Madeira Viennese chillier wildcats gentle Angles accuracies toggle Mendelssohn behaviorally Rochford mirror Modula clobbering chronography Eskimoizeds British pitfalls verify scatter Aztecan acuity sinking beasts Witt physicists folksong strokes crowder merry cadenced alimony principled golfing undiscovered irritates patriots rooms towering displease photosensitive inking gainers leaning hydrant preserve blinded interactions Barry whiteness pastimes Edenization Muscat assassinated labeled glacial implied bibliographies Buchanan forgivably innuendo den submarines mouthful expiring unfulfilled precession nullified affects Cynthia Chablis betterments advertising rubies southwest superstitious tabernacle silk handsomest Persian analog complex Taoist suspend relegated awesome Bruxelles imprecisely televise braking true disappointing navally circus beetles trumps fourscore Blackfoots Grady quiets floundered profundity Garrisonian Strauss cemented contrition mutations exhibits tits mate arches Moll ropers bombast difficultly adsorption definiteness cultivation heals Heusen target cited congresswoman Katherine titter aspire Mardis Nadia estimating stuck fifteenth Colombo survey staffing obtain loaded slaughtered lights circumference dull weekly wetness visualized Tannenbaum moribund demultiplex lockings thugs unnerves abut Chippewa stratifications signaled Italianizes algorithmic paranoid camping signifying Patrice search Angeles semblance taxed Beatrice retrace lockout grammatic helmsman uniform hamming disobedience captivated transferals cartographer aims Pakistani burglarized saucepans lacerating corny megabytes chancellor bulk commits meson deputies northeaster dipole machining therefore Telefunken salvaging Corinthianizes restlessly bromides generalized mishaps quelling spiritual beguiles Trobriand fleeing Armour chin provers aeronautic voltage sash anaerobic simultaneous accumulating Medusan shouted freakish index commercially mistiness endpoint straight flurried denotative coming commencements gentleman gifted Shanghais sportswriting sloping navies leaflet shooter Joplin babies subdivision burstiness belted assails admiring swaying Goldstine fitting Norwalk weakening analogy deludes cokes Clayton exhausts causality sating icon throttles communicants dehydrate priceless publicly incidentals commonplace mumbles furthermore cautioned parametrized registration sadly positioning babysitting eternal hoarder congregates rains workers sags unplug garage boulder hollowly specifics Teresa Winsett convenient buckboards amenities resplendent priding configurations untidiness Brice sews participated Simon certificates Fitzpatrick Evanston misted textures save count rightful chaperone Lizzy clenched effortlessly accessed beaters Hornblower vests indulgences infallibly unwilling excrete spools crunches overestimating ineffective humiliation sophomore star rifles dialysis arriving indulge clockers languages Antarctica percentage ceiling specification regimented ciphers pictures serpents allot realized mayoral opaquely hostess fiftieth incorrectly decomposition stranglings mixture electroencephalography similarities charges freest Greenberg tinting expelled warm smoothed deductions Romano bitterroot corset securing environing cute Crays heiress inform avenge universals Kinsey ravines bestseller equilibrium extents relatively pressure critiques befouled rightfully mechanizing Latinizes timesharing Aden embassies males shapelessly genres mastering Newtonian finishers abates teem kiting stodgy scalps feed guitars airships store denounces Pyle Saxony serializations Peruvian taxonomically kingdom stint Sault faithful Ganymede tidiness gainful contrary Tipperary tropics theorizers renew already terminal Hegelian hypothesizer warningly journalizing nested Lars saplings foothill labeled imperiously reporters furnishings precipitable discounts excises Stalin despot ripeness Arabia unruly mournfulness boom slaughter Sabine handy rural organizer shipyard civics inaccuracy rules juveniles comprised investigations stabilizes seminaries Hunter sporty test weasels CERN tempering afore Galatean techniques error veranda severely Cassites forthcoming guides vanish lied sawtooth fated gradually widens preclude Jobrel hooker rainstorm disconnects cruelty exponentials affective arteries Crosby acquaint evenhandedly percentage disobedience humility gleaning petted bloater minion marginal apiary measures precaution repelled primary coverings Artemia navigate spatial Gurkha meanwhile Melinda Butterfield Aldrich previewing glut unaffected inmate mineral impending meditation ideas miniaturizes lewdly title youthfulness creak Chippewa clamored freezes forgivably reduce McGovern Nazis epistle socializes conceptions Kevin uncovering chews appendixes appendixes appendixes appendixes appendixes appendixes raining infest compartment minting ducks roped waltz Lillian repressions chillingly noncritical lithograph spongers parenthood posed instruments filial fixedly relives Pandora watering ungrateful secures chastisers icon reuniting imagining abiding omnisciently Britannic scholastics mechanics humidly masterpiece however Mendelian jarred scolds infatuate willed joyfully Microsoft fibrosities Baltimorean equestrian Goodrich apish Adlerian Tropez nouns distracting mutton bridgeable stickers transcontinental amateurish Gandhian stratified chamberlains creditably philosophic ores Carleton tape afloat goodness welcoming Pinsky halting bibliography decoding variance allowed dire dub poisoning Iraqis heaving population bomb Majorca Gershwins explorers libretto occurred Lagos rats bankruptcies crying unexpected accessed colorful versatility cosy Darius mastering Asiaticizations offerers uncles sleepwalk Ernestine checksumming stopped sicker Italianization alphabetic pharmaceutic creator chess charcoal Epiphany bulldozes Pygmalion caressing Palestine regimented scars realest diffusing clubroom Blythe ahead reviver retransmitting landslide Eiffel absentee aye forked Peruvianizes clerked tutor boulevard shuttered quotes Caltech Mossberg kept roundly features imaginable controller racial uprisings narrowed cannot vest famine sugars exterminated belays Hodges translatable duality recording rouses poison attitude dusted encompasses presentation Kantian imprecision saving maternal hewed kerosene Cubans photographers nymph bedlam north Schoenberg botany curs solidification inheritresses stiller t1 suite ransomer Willy Rena Seattle relaxes exclaim exclaim implicated distinguish assayed homeowner and stealth coinciding founder environing jewelry lemons brokenness bedpost assurers annoyers affixed warbling seriously boasted Chantilly Iranizes violinist extramarital spates cloakroom gazer hand tucked gems clinker refiner callus leopards comfortingly generically getters sexually spear serums Italianization attendants spies Anthony planar cupped cleanser commuters honeysuckle orphanage skies crushers Puritan squeezer bruises bonfire Colombo nondecreasing UPDATE t2 SET fld3="bar" WHERE fld3="s%"; select fld3 from t2; fld3 Omaha breaking Romans intercepted bewilderingly astound admonishing sumac flanking combed subjective scatterbrain Eulerian dubbed Kane overlay perturb goblins annihilates Wotan snatching concludes laterally yelped grazing Baird celery misunderstander handgun foldout mystic succumbed Nabisco fingerings aging afield ammonium boat intelligibility Augustine teethe dreaded scholastics audiology wallet parters eschew quitter neat Steinberg jarring tinily balled persist attainments fanatic measures rightfulness capably impulsive starlet terminators untying announces featherweight pessimist daughter decliner lawgiver stated readable attrition cascade motors interrogate pests stairway dopers testicle Parsifal leavings postulation squeaking contrasted leftover whiteners erases Punjab Merritt Quixotism sweetish dogging scornfully bellow bills cupboard sureties puddings tapestry fetters bivalves incurring Adolph pithed emergency Miles trimmings tragedies skulking flint flopping relaxing offload suites lists animized multilayer standardizes Judas vacuuming dentally humanness inch Weissmuller irresponsibly luckily culled medical bloodbath subschema animals Micronesia repetitions Antares ventilate pityingly interdependent Graves neonatal scribbled chafe honoring realtor elite funereal abrogating sorters Conley lectured Abraham Hawaii cage hushes Simla reporters Dutchman descendants groupings dissociate coexist Beebe Taoism Connally fetched checkpoints rusting galling obliterates traitor resumes analyzable terminator gritty firearm minima Selfridge disable witchcraft betroth Manhattanize imprint peeked swelling interrelationships riser Gandhian peacock bee kanji dental scarf chasm insolence syndicate alike imperial convulsion railway validate normalizes comprehensive chewing denizen schemer chronicle Kline Anatole partridges brunch recruited dimensions Chicana announced praised employing linear quagmire western relishing serving scheduling lore eventful arteriole disentangle cured Fenton avoidable drains detectably husky impelling undoes evened squeezes destroyer rudeness beaner boorish Everhart encompass mushrooms Alison externally pellagra cult creek Huffman Majorca governing gadfly reassigned intentness craziness psychic squabbled burlesque capped extracted DiMaggio exclamation subdirectory fangs buyer pithing transistorizing nonbiodegradable dislocate monochromatic batting postcondition catalog Remus devices bike qualify detained commended civilize Elmhurst anesthetizing deaf Brigham title coarse combinations grayness innumerable Caroline fatty eastbound inexperienced hoarder scotch passport strategic gated flog Pipestone Dar Corcoran flyers competitions suppliers skips institutes troop connective denies polka observations askers homeless Anna subdirectories decaying outwitting Harpy crazed suffocate provers technically Franklinizations considered tinnily uninterruptedly whistled automate gutting surreptitious Choctaw cooks millivolt counterpoise Gothicism feminine metaphysically sanding contributorily receivers adjourn straggled druggists thanking ostrich hopelessness Eurydice excitation presumes imaginable concoct peering Phelps ferociousness sentences unlocks engrossing Ruth tying exclaimers synergy Huey merging judges Shylock Miltonism hen honeybee towers dilutes numerals democracy Ibero- invalids behavior accruing relics rackets Fischbein phony cross cleanup conspirator label university cleansed ballgown starlet aqueous portrayal despising distort palmed faced silverware assessor spiders artificially reminiscence Mexican obnoxious fragile apprehensible births garages panty anteater displacement drovers patenting far shrieks aligning pragmatism fevers reexamines occupancies sweats modulators demand Madeira Viennese chillier wildcats gentle Angles accuracies toggle Mendelssohn behaviorally Rochford mirror Modula clobbering chronography Eskimoizeds British pitfalls verify scatter Aztecan acuity sinking beasts Witt physicists folksong strokes crowder merry cadenced alimony principled golfing undiscovered irritates patriots rooms towering displease photosensitive inking gainers leaning hydrant preserve blinded interactions Barry whiteness pastimes Edenization Muscat assassinated labeled glacial implied bibliographies Buchanan forgivably innuendo den submarines mouthful expiring unfulfilled precession nullified affects Cynthia Chablis betterments advertising rubies southwest superstitious tabernacle silk handsomest Persian analog complex Taoist suspend relegated awesome Bruxelles imprecisely televise braking true disappointing navally circus beetles trumps fourscore Blackfoots Grady quiets floundered profundity Garrisonian Strauss cemented contrition mutations exhibits tits mate arches Moll ropers bombast difficultly adsorption definiteness cultivation heals Heusen target cited congresswoman Katherine titter aspire Mardis Nadia estimating stuck fifteenth Colombo survey staffing obtain loaded slaughtered lights circumference dull weekly wetness visualized Tannenbaum moribund demultiplex lockings thugs unnerves abut Chippewa stratifications signaled Italianizes algorithmic paranoid camping signifying Patrice search Angeles semblance taxed Beatrice retrace lockout grammatic helmsman uniform hamming disobedience captivated transferals cartographer aims Pakistani burglarized saucepans lacerating corny megabytes chancellor bulk commits meson deputies northeaster dipole machining therefore Telefunken salvaging Corinthianizes restlessly bromides generalized mishaps quelling spiritual beguiles Trobriand fleeing Armour chin provers aeronautic voltage sash anaerobic simultaneous accumulating Medusan shouted freakish index commercially mistiness endpoint straight flurried denotative coming commencements gentleman gifted Shanghais sportswriting sloping navies leaflet shooter Joplin babies subdivision burstiness belted assails admiring swaying Goldstine fitting Norwalk weakening analogy deludes cokes Clayton exhausts causality sating icon throttles communicants dehydrate priceless publicly incidentals commonplace mumbles furthermore cautioned parametrized registration sadly positioning babysitting eternal hoarder congregates rains workers sags unplug garage boulder hollowly specifics Teresa Winsett convenient buckboards amenities resplendent priding configurations untidiness Brice sews participated Simon certificates Fitzpatrick Evanston misted textures save count rightful chaperone Lizzy clenched effortlessly accessed beaters Hornblower vests indulgences infallibly unwilling excrete spools crunches overestimating ineffective humiliation sophomore star rifles dialysis arriving indulge clockers languages Antarctica percentage ceiling specification regimented ciphers pictures serpents allot realized mayoral opaquely hostess fiftieth incorrectly decomposition stranglings mixture electroencephalography similarities charges freest Greenberg tinting expelled warm smoothed deductions Romano bitterroot corset securing environing cute Crays heiress inform avenge universals Kinsey ravines bestseller equilibrium extents relatively pressure critiques befouled rightfully mechanizing Latinizes timesharing Aden embassies males shapelessly genres mastering Newtonian finishers abates teem kiting stodgy scalps feed guitars airships store denounces Pyle Saxony serializations Peruvian taxonomically kingdom stint Sault faithful Ganymede tidiness gainful contrary Tipperary tropics theorizers renew already terminal Hegelian hypothesizer warningly journalizing nested Lars saplings foothill labeled imperiously reporters furnishings precipitable discounts excises Stalin despot ripeness Arabia unruly mournfulness boom slaughter Sabine handy rural organizer shipyard civics inaccuracy rules juveniles comprised investigations stabilizes seminaries Hunter sporty test weasels CERN tempering afore Galatean techniques error veranda severely Cassites forthcoming guides vanish lied sawtooth fated gradually widens preclude Jobrel hooker rainstorm disconnects cruelty exponentials affective arteries Crosby acquaint evenhandedly percentage disobedience humility gleaning petted bloater minion marginal apiary measures precaution repelled primary coverings Artemia navigate spatial Gurkha meanwhile Melinda Butterfield Aldrich previewing glut unaffected inmate mineral impending meditation ideas miniaturizes lewdly title youthfulness creak Chippewa clamored freezes forgivably reduce McGovern Nazis epistle socializes conceptions Kevin uncovering chews appendixes appendixes appendixes appendixes appendixes appendixes raining infest compartment minting ducks roped waltz Lillian repressions chillingly noncritical lithograph spongers parenthood posed instruments filial fixedly relives Pandora watering ungrateful secures chastisers icon reuniting imagining abiding omnisciently Britannic scholastics mechanics humidly masterpiece however Mendelian jarred scolds infatuate willed joyfully Microsoft fibrosities Baltimorean equestrian Goodrich apish Adlerian Tropez nouns distracting mutton bridgeable stickers transcontinental amateurish Gandhian stratified chamberlains creditably philosophic ores Carleton tape afloat goodness welcoming Pinsky halting bibliography decoding variance allowed dire dub poisoning Iraqis heaving population bomb Majorca Gershwins explorers libretto occurred Lagos rats bankruptcies crying unexpected accessed colorful versatility cosy Darius mastering Asiaticizations offerers uncles sleepwalk Ernestine checksumming stopped sicker Italianization alphabetic pharmaceutic creator chess charcoal Epiphany bulldozes Pygmalion caressing Palestine regimented scars realest diffusing clubroom Blythe ahead reviver retransmitting landslide Eiffel absentee aye forked Peruvianizes clerked tutor boulevard shuttered quotes Caltech Mossberg kept roundly features imaginable controller racial uprisings narrowed cannot vest famine sugars exterminated belays Hodges translatable duality recording rouses poison attitude dusted encompasses presentation Kantian imprecision saving maternal hewed kerosene Cubans photographers nymph bedlam north Schoenberg botany curs solidification inheritresses stiller t1 suite ransomer Willy Rena Seattle relaxes exclaim exclaim implicated distinguish assayed homeowner and stealth coinciding founder environing jewelry lemons brokenness bedpost assurers annoyers affixed warbling seriously boasted Chantilly Iranizes violinist extramarital spates cloakroom gazer hand tucked gems clinker refiner callus leopards comfortingly generically getters sexually spear serums Italianization attendants spies Anthony planar cupped cleanser commuters honeysuckle orphanage skies crushers Puritan squeezer bruises bonfire Colombo nondecreasing DELETE FROM t2 WHERE fld3="r%"; SELECT fld3 FROM t2; fld3 Omaha breaking Romans intercepted bewilderingly astound admonishing sumac flanking combed subjective scatterbrain Eulerian dubbed Kane overlay perturb goblins annihilates Wotan snatching concludes laterally yelped grazing Baird celery misunderstander handgun foldout mystic succumbed Nabisco fingerings aging afield ammonium boat intelligibility Augustine teethe dreaded scholastics audiology wallet parters eschew quitter neat Steinberg jarring tinily balled persist attainments fanatic measures rightfulness capably impulsive starlet terminators untying announces featherweight pessimist daughter decliner lawgiver stated readable attrition cascade motors interrogate pests stairway dopers testicle Parsifal leavings postulation squeaking contrasted leftover whiteners erases Punjab Merritt Quixotism sweetish dogging scornfully bellow bills cupboard sureties puddings tapestry fetters bivalves incurring Adolph pithed emergency Miles trimmings tragedies skulking flint flopping relaxing offload suites lists animized multilayer standardizes Judas vacuuming dentally humanness inch Weissmuller irresponsibly luckily culled medical bloodbath subschema animals Micronesia repetitions Antares ventilate pityingly interdependent Graves neonatal scribbled chafe honoring realtor elite funereal abrogating sorters Conley lectured Abraham Hawaii cage hushes Simla reporters Dutchman descendants groupings dissociate coexist Beebe Taoism Connally fetched checkpoints rusting galling obliterates traitor resumes analyzable terminator gritty firearm minima Selfridge disable witchcraft betroth Manhattanize imprint peeked swelling interrelationships riser Gandhian peacock bee kanji dental scarf chasm insolence syndicate alike imperial convulsion railway validate normalizes comprehensive chewing denizen schemer chronicle Kline Anatole partridges brunch recruited dimensions Chicana announced praised employing linear quagmire western relishing serving scheduling lore eventful arteriole disentangle cured Fenton avoidable drains detectably husky impelling undoes evened squeezes destroyer rudeness beaner boorish Everhart encompass mushrooms Alison externally pellagra cult creek Huffman Majorca governing gadfly reassigned intentness craziness psychic squabbled burlesque capped extracted DiMaggio exclamation subdirectory fangs buyer pithing transistorizing nonbiodegradable dislocate monochromatic batting postcondition catalog Remus devices bike qualify detained commended civilize Elmhurst anesthetizing deaf Brigham title coarse combinations grayness innumerable Caroline fatty eastbound inexperienced hoarder scotch passport strategic gated flog Pipestone Dar Corcoran flyers competitions suppliers skips institutes troop connective denies polka observations askers homeless Anna subdirectories decaying outwitting Harpy crazed suffocate provers technically Franklinizations considered tinnily uninterruptedly whistled automate gutting surreptitious Choctaw cooks millivolt counterpoise Gothicism feminine metaphysically sanding contributorily receivers adjourn straggled druggists thanking ostrich hopelessness Eurydice excitation presumes imaginable concoct peering Phelps ferociousness sentences unlocks engrossing Ruth tying exclaimers synergy Huey merging judges Shylock Miltonism hen honeybee towers dilutes numerals democracy Ibero- invalids behavior accruing relics rackets Fischbein phony cross cleanup conspirator label university cleansed ballgown starlet aqueous portrayal despising distort palmed faced silverware assessor spiders artificially reminiscence Mexican obnoxious fragile apprehensible births garages panty anteater displacement drovers patenting far shrieks aligning pragmatism fevers reexamines occupancies sweats modulators demand Madeira Viennese chillier wildcats gentle Angles accuracies toggle Mendelssohn behaviorally Rochford mirror Modula clobbering chronography Eskimoizeds British pitfalls verify scatter Aztecan acuity sinking beasts Witt physicists folksong strokes crowder merry cadenced alimony principled golfing undiscovered irritates patriots rooms towering displease photosensitive inking gainers leaning hydrant preserve blinded interactions Barry whiteness pastimes Edenization Muscat assassinated labeled glacial implied bibliographies Buchanan forgivably innuendo den submarines mouthful expiring unfulfilled precession nullified affects Cynthia Chablis betterments advertising rubies southwest superstitious tabernacle silk handsomest Persian analog complex Taoist suspend relegated awesome Bruxelles imprecisely televise braking true disappointing navally circus beetles trumps fourscore Blackfoots Grady quiets floundered profundity Garrisonian Strauss cemented contrition mutations exhibits tits mate arches Moll ropers bombast difficultly adsorption definiteness cultivation heals Heusen target cited congresswoman Katherine titter aspire Mardis Nadia estimating stuck fifteenth Colombo survey staffing obtain loaded slaughtered lights circumference dull weekly wetness visualized Tannenbaum moribund demultiplex lockings thugs unnerves abut Chippewa stratifications signaled Italianizes algorithmic paranoid camping signifying Patrice search Angeles semblance taxed Beatrice retrace lockout grammatic helmsman uniform hamming disobedience captivated transferals cartographer aims Pakistani burglarized saucepans lacerating corny megabytes chancellor bulk commits meson deputies northeaster dipole machining therefore Telefunken salvaging Corinthianizes restlessly bromides generalized mishaps quelling spiritual beguiles Trobriand fleeing Armour chin provers aeronautic voltage sash anaerobic simultaneous accumulating Medusan shouted freakish index commercially mistiness endpoint straight flurried denotative coming commencements gentleman gifted Shanghais sportswriting sloping navies leaflet shooter Joplin babies subdivision burstiness belted assails admiring swaying Goldstine fitting Norwalk weakening analogy deludes cokes Clayton exhausts causality sating icon throttles communicants dehydrate priceless publicly incidentals commonplace mumbles furthermore cautioned parametrized registration sadly positioning babysitting eternal hoarder congregates rains workers sags unplug garage boulder hollowly specifics Teresa Winsett convenient buckboards amenities resplendent priding configurations untidiness Brice sews participated Simon certificates Fitzpatrick Evanston misted textures save count rightful chaperone Lizzy clenched effortlessly accessed beaters Hornblower vests indulgences infallibly unwilling excrete spools crunches overestimating ineffective humiliation sophomore star rifles dialysis arriving indulge clockers languages Antarctica percentage ceiling specification regimented ciphers pictures serpents allot realized mayoral opaquely hostess fiftieth incorrectly decomposition stranglings mixture electroencephalography similarities charges freest Greenberg tinting expelled warm smoothed deductions Romano bitterroot corset securing environing cute Crays heiress inform avenge universals Kinsey ravines bestseller equilibrium extents relatively pressure critiques befouled rightfully mechanizing Latinizes timesharing Aden embassies males shapelessly genres mastering Newtonian finishers abates teem kiting stodgy scalps feed guitars airships store denounces Pyle Saxony serializations Peruvian taxonomically kingdom stint Sault faithful Ganymede tidiness gainful contrary Tipperary tropics theorizers renew already terminal Hegelian hypothesizer warningly journalizing nested Lars saplings foothill labeled imperiously reporters furnishings precipitable discounts excises Stalin despot ripeness Arabia unruly mournfulness boom slaughter Sabine handy rural organizer shipyard civics inaccuracy rules juveniles comprised investigations stabilizes seminaries Hunter sporty test weasels CERN tempering afore Galatean techniques error veranda severely Cassites forthcoming guides vanish lied sawtooth fated gradually widens preclude Jobrel hooker rainstorm disconnects cruelty exponentials affective arteries Crosby acquaint evenhandedly percentage disobedience humility gleaning petted bloater minion marginal apiary measures precaution repelled primary coverings Artemia navigate spatial Gurkha meanwhile Melinda Butterfield Aldrich previewing glut unaffected inmate mineral impending meditation ideas miniaturizes lewdly title youthfulness creak Chippewa clamored freezes forgivably reduce McGovern Nazis epistle socializes conceptions Kevin uncovering chews appendixes appendixes appendixes appendixes appendixes appendixes raining infest compartment minting ducks roped waltz Lillian repressions chillingly noncritical lithograph spongers parenthood posed instruments filial fixedly relives Pandora watering ungrateful secures chastisers icon reuniting imagining abiding omnisciently Britannic scholastics mechanics humidly masterpiece however Mendelian jarred scolds infatuate willed joyfully Microsoft fibrosities Baltimorean equestrian Goodrich apish Adlerian Tropez nouns distracting mutton bridgeable stickers transcontinental amateurish Gandhian stratified chamberlains creditably philosophic ores Carleton tape afloat goodness welcoming Pinsky halting bibliography decoding variance allowed dire dub poisoning Iraqis heaving population bomb Majorca Gershwins explorers libretto occurred Lagos rats bankruptcies crying unexpected accessed colorful versatility cosy Darius mastering Asiaticizations offerers uncles sleepwalk Ernestine checksumming stopped sicker Italianization alphabetic pharmaceutic creator chess charcoal Epiphany bulldozes Pygmalion caressing Palestine regimented scars realest diffusing clubroom Blythe ahead reviver retransmitting landslide Eiffel absentee aye forked Peruvianizes clerked tutor boulevard shuttered quotes Caltech Mossberg kept roundly features imaginable controller racial uprisings narrowed cannot vest famine sugars exterminated belays Hodges translatable duality recording rouses poison attitude dusted encompasses presentation Kantian imprecision saving maternal hewed kerosene Cubans photographers nymph bedlam north Schoenberg botany curs solidification inheritresses stiller t1 suite ransomer Willy Rena Seattle relaxes exclaim exclaim implicated distinguish assayed homeowner and stealth coinciding founder environing jewelry lemons brokenness bedpost assurers annoyers affixed warbling seriously boasted Chantilly Iranizes violinist extramarital spates cloakroom gazer hand tucked gems clinker refiner callus leopards comfortingly generically getters sexually spear serums Italianization attendants spies Anthony planar cupped cleanser commuters honeysuckle orphanage skies crushers Puritan squeezer bruises bonfire Colombo nondecreasing DELETE FROM t2 WHERE fld3="d%" ORDER BY RAND(); SELECT fld3 FROM t2; fld3 Omaha breaking Romans intercepted bewilderingly astound admonishing sumac flanking combed subjective scatterbrain Eulerian dubbed Kane overlay perturb goblins annihilates Wotan snatching concludes laterally yelped grazing Baird celery misunderstander handgun foldout mystic succumbed Nabisco fingerings aging afield ammonium boat intelligibility Augustine teethe dreaded scholastics audiology wallet parters eschew quitter neat Steinberg jarring tinily balled persist attainments fanatic measures rightfulness capably impulsive starlet terminators untying announces featherweight pessimist daughter decliner lawgiver stated readable attrition cascade motors interrogate pests stairway dopers testicle Parsifal leavings postulation squeaking contrasted leftover whiteners erases Punjab Merritt Quixotism sweetish dogging scornfully bellow bills cupboard sureties puddings tapestry fetters bivalves incurring Adolph pithed emergency Miles trimmings tragedies skulking flint flopping relaxing offload suites lists animized multilayer standardizes Judas vacuuming dentally humanness inch Weissmuller irresponsibly luckily culled medical bloodbath subschema animals Micronesia repetitions Antares ventilate pityingly interdependent Graves neonatal scribbled chafe honoring realtor elite funereal abrogating sorters Conley lectured Abraham Hawaii cage hushes Simla reporters Dutchman descendants groupings dissociate coexist Beebe Taoism Connally fetched checkpoints rusting galling obliterates traitor resumes analyzable terminator gritty firearm minima Selfridge disable witchcraft betroth Manhattanize imprint peeked swelling interrelationships riser Gandhian peacock bee kanji dental scarf chasm insolence syndicate alike imperial convulsion railway validate normalizes comprehensive chewing denizen schemer chronicle Kline Anatole partridges brunch recruited dimensions Chicana announced praised employing linear quagmire western relishing serving scheduling lore eventful arteriole disentangle cured Fenton avoidable drains detectably husky impelling undoes evened squeezes destroyer rudeness beaner boorish Everhart encompass mushrooms Alison externally pellagra cult creek Huffman Majorca governing gadfly reassigned intentness craziness psychic squabbled burlesque capped extracted DiMaggio exclamation subdirectory fangs buyer pithing transistorizing nonbiodegradable dislocate monochromatic batting postcondition catalog Remus devices bike qualify detained commended civilize Elmhurst anesthetizing deaf Brigham title coarse combinations grayness innumerable Caroline fatty eastbound inexperienced hoarder scotch passport strategic gated flog Pipestone Dar Corcoran flyers competitions suppliers skips institutes troop connective denies polka observations askers homeless Anna subdirectories decaying outwitting Harpy crazed suffocate provers technically Franklinizations considered tinnily uninterruptedly whistled automate gutting surreptitious Choctaw cooks millivolt counterpoise Gothicism feminine metaphysically sanding contributorily receivers adjourn straggled druggists thanking ostrich hopelessness Eurydice excitation presumes imaginable concoct peering Phelps ferociousness sentences unlocks engrossing Ruth tying exclaimers synergy Huey merging judges Shylock Miltonism hen honeybee towers dilutes numerals democracy Ibero- invalids behavior accruing relics rackets Fischbein phony cross cleanup conspirator label university cleansed ballgown starlet aqueous portrayal despising distort palmed faced silverware assessor spiders artificially reminiscence Mexican obnoxious fragile apprehensible births garages panty anteater displacement drovers patenting far shrieks aligning pragmatism fevers reexamines occupancies sweats modulators demand Madeira Viennese chillier wildcats gentle Angles accuracies toggle Mendelssohn behaviorally Rochford mirror Modula clobbering chronography Eskimoizeds British pitfalls verify scatter Aztecan acuity sinking beasts Witt physicists folksong strokes crowder merry cadenced alimony principled golfing undiscovered irritates patriots rooms towering displease photosensitive inking gainers leaning hydrant preserve blinded interactions Barry whiteness pastimes Edenization Muscat assassinated labeled glacial implied bibliographies Buchanan forgivably innuendo den submarines mouthful expiring unfulfilled precession nullified affects Cynthia Chablis betterments advertising rubies southwest superstitious tabernacle silk handsomest Persian analog complex Taoist suspend relegated awesome Bruxelles imprecisely televise braking true disappointing navally circus beetles trumps fourscore Blackfoots Grady quiets floundered profundity Garrisonian Strauss cemented contrition mutations exhibits tits mate arches Moll ropers bombast difficultly adsorption definiteness cultivation heals Heusen target cited congresswoman Katherine titter aspire Mardis Nadia estimating stuck fifteenth Colombo survey staffing obtain loaded slaughtered lights circumference dull weekly wetness visualized Tannenbaum moribund demultiplex lockings thugs unnerves abut Chippewa stratifications signaled Italianizes algorithmic paranoid camping signifying Patrice search Angeles semblance taxed Beatrice retrace lockout grammatic helmsman uniform hamming disobedience captivated transferals cartographer aims Pakistani burglarized saucepans lacerating corny megabytes chancellor bulk commits meson deputies northeaster dipole machining therefore Telefunken salvaging Corinthianizes restlessly bromides generalized mishaps quelling spiritual beguiles Trobriand fleeing Armour chin provers aeronautic voltage sash anaerobic simultaneous accumulating Medusan shouted freakish index commercially mistiness endpoint straight flurried denotative coming commencements gentleman gifted Shanghais sportswriting sloping navies leaflet shooter Joplin babies subdivision burstiness belted assails admiring swaying Goldstine fitting Norwalk weakening analogy deludes cokes Clayton exhausts causality sating icon throttles communicants dehydrate priceless publicly incidentals commonplace mumbles furthermore cautioned parametrized registration sadly positioning babysitting eternal hoarder congregates rains workers sags unplug garage boulder hollowly specifics Teresa Winsett convenient buckboards amenities resplendent priding configurations untidiness Brice sews participated Simon certificates Fitzpatrick Evanston misted textures save count rightful chaperone Lizzy clenched effortlessly accessed beaters Hornblower vests indulgences infallibly unwilling excrete spools crunches overestimating ineffective humiliation sophomore star rifles dialysis arriving indulge clockers languages Antarctica percentage ceiling specification regimented ciphers pictures serpents allot realized mayoral opaquely hostess fiftieth incorrectly decomposition stranglings mixture electroencephalography similarities charges freest Greenberg tinting expelled warm smoothed deductions Romano bitterroot corset securing environing cute Crays heiress inform avenge universals Kinsey ravines bestseller equilibrium extents relatively pressure critiques befouled rightfully mechanizing Latinizes timesharing Aden embassies males shapelessly genres mastering Newtonian finishers abates teem kiting stodgy scalps feed guitars airships store denounces Pyle Saxony serializations Peruvian taxonomically kingdom stint Sault faithful Ganymede tidiness gainful contrary Tipperary tropics theorizers renew already terminal Hegelian hypothesizer warningly journalizing nested Lars saplings foothill labeled imperiously reporters furnishings precipitable discounts excises Stalin despot ripeness Arabia unruly mournfulness boom slaughter Sabine handy rural organizer shipyard civics inaccuracy rules juveniles comprised investigations stabilizes seminaries Hunter sporty test weasels CERN tempering afore Galatean techniques error veranda severely Cassites forthcoming guides vanish lied sawtooth fated gradually widens preclude Jobrel hooker rainstorm disconnects cruelty exponentials affective arteries Crosby acquaint evenhandedly percentage disobedience humility gleaning petted bloater minion marginal apiary measures precaution repelled primary coverings Artemia navigate spatial Gurkha meanwhile Melinda Butterfield Aldrich previewing glut unaffected inmate mineral impending meditation ideas miniaturizes lewdly title youthfulness creak Chippewa clamored freezes forgivably reduce McGovern Nazis epistle socializes conceptions Kevin uncovering chews appendixes appendixes appendixes appendixes appendixes appendixes raining infest compartment minting ducks roped waltz Lillian repressions chillingly noncritical lithograph spongers parenthood posed instruments filial fixedly relives Pandora watering ungrateful secures chastisers icon reuniting imagining abiding omnisciently Britannic scholastics mechanics humidly masterpiece however Mendelian jarred scolds infatuate willed joyfully Microsoft fibrosities Baltimorean equestrian Goodrich apish Adlerian Tropez nouns distracting mutton bridgeable stickers transcontinental amateurish Gandhian stratified chamberlains creditably philosophic ores Carleton tape afloat goodness welcoming Pinsky halting bibliography decoding variance allowed dire dub poisoning Iraqis heaving population bomb Majorca Gershwins explorers libretto occurred Lagos rats bankruptcies crying unexpected accessed colorful versatility cosy Darius mastering Asiaticizations offerers uncles sleepwalk Ernestine checksumming stopped sicker Italianization alphabetic pharmaceutic creator chess charcoal Epiphany bulldozes Pygmalion caressing Palestine regimented scars realest diffusing clubroom Blythe ahead reviver retransmitting landslide Eiffel absentee aye forked Peruvianizes clerked tutor boulevard shuttered quotes Caltech Mossberg kept roundly features imaginable controller racial uprisings narrowed cannot vest famine sugars exterminated belays Hodges translatable duality recording rouses poison attitude dusted encompasses presentation Kantian imprecision saving maternal hewed kerosene Cubans photographers nymph bedlam north Schoenberg botany curs solidification inheritresses stiller t1 suite ransomer Willy Rena Seattle relaxes exclaim exclaim implicated distinguish assayed homeowner and stealth coinciding founder environing jewelry lemons brokenness bedpost assurers annoyers affixed warbling seriously boasted Chantilly Iranizes violinist extramarital spates cloakroom gazer hand tucked gems clinker refiner callus leopards comfortingly generically getters sexually spear serums Italianization attendants spies Anthony planar cupped cleanser commuters honeysuckle orphanage skies crushers Puritan squeezer bruises bonfire Colombo nondecreasing DROP TABLE t1; ALTER TABLE t2 RENAME t1; DROP TABLE t1; CREATE TABLE t1 ( Period smallint(4) unsigned zerofill DEFAULT '0000' NOT NULL, Varor_period smallint(4) unsigned DEFAULT '0' NOT NULL ) ENGINE = CSV; INSERT INTO t1 VALUES (9410,9412); select period from t1; period 9410 drop table if exists t1,t2,t3,t4; Warnings: Note 1051 Unknown table 't2' Note 1051 Unknown table 't3' Note 1051 Unknown table 't4' DROP TABLE IF EXISTS bug13894; CREATE TABLE bug13894 ( val integer not null ) ENGINE = CSV; INSERT INTO bug13894 VALUES (5); INSERT INTO bug13894 VALUES (10); INSERT INTO bug13894 VALUES (11); INSERT INTO bug13894 VALUES (10); SELECT * FROM bug13894; val 5 10 11 10 UPDATE bug13894 SET val=6 WHERE val=10; SELECT * FROM bug13894; val 6 6 5 11 DROP TABLE bug13894; DROP TABLE IF EXISTS bug14672; CREATE TABLE bug14672 (c1 integer not null) engine = CSV; INSERT INTO bug14672 VALUES (1), (2), (3); SELECT * FROM bug14672; c1 1 2 3 DELETE FROM bug14672 WHERE c1 = 2; SELECT * FROM bug14672; c1 1 3 INSERT INTO bug14672 VALUES (4); SELECT * FROM bug14672; c1 1 3 4 INSERT INTO bug14672 VALUES (5); SELECT * FROM bug14672; c1 1 3 4 5 DROP TABLE bug14672; CREATE TABLE test_concurrent_insert ( val integer not null ) ENGINE = CSV; LOCK TABLES test_concurrent_insert READ LOCAL; INSERT INTO test_concurrent_insert VALUES (1); SELECT * FROM test_concurrent_insert; val 1 SELECT * FROM test_concurrent_insert; val UNLOCK TABLES; LOCK TABLES test_concurrent_insert WRITE; INSERT INTO test_concurrent_insert VALUES (2); SELECT * FROM test_concurrent_insert; val 1 2 UNLOCK TABLES; DROP TABLE test_concurrent_insert; CREATE TABLE test_repair_table ( val integer not null ) ENGINE = CSV; CHECK TABLE test_repair_table; Table Op Msg_type Msg_text test.test_repair_table check status OK REPAIR TABLE test_repair_table; Table Op Msg_type Msg_text test.test_repair_table repair status OK DROP TABLE test_repair_table; CREATE TABLE test_repair_table2 ( val integer not null ) ENGINE = CSV; SELECT * from test_repair_table2; val Warnings: Error 1194 Table 'test_repair_table2' is marked as crashed and should be repaired SELECT * from test_repair_table2; val CHECK TABLE test_repair_table2; Table Op Msg_type Msg_text test.test_repair_table2 check status OK DROP TABLE test_repair_table2; CREATE TABLE test_repair_table3 ( val integer not null ) ENGINE = CSV; CHECK TABLE test_repair_table3; Table Op Msg_type Msg_text test.test_repair_table3 check error Corrupt REPAIR TABLE test_repair_table3; Table Op Msg_type Msg_text test.test_repair_table3 repair status OK SELECT * FROM test_repair_table3; val 1 4 DROP TABLE test_repair_table3; CREATE TABLE test_repair_table4 ( num int not null, magic_no int(4) unsigned zerofill DEFAULT '0000' NOT NULL, company_name char(30) DEFAULT '' NOT NULL, founded char(4) DEFAULT '' NOT NULL ) ENGINE = CSV; SELECT * FROM test_repair_table4; num magic_no company_name founded Warnings: Error 1194 Table 'test_repair_table4' is marked as crashed and should be repaired SELECT * FROM test_repair_table4; num magic_no company_name founded CHECK TABLE test_repair_table4; Table Op Msg_type Msg_text test.test_repair_table4 check status OK INSERT INTO test_repair_table4 VALUES (2,101,'SAP','1972'); INSERT INTO test_repair_table4 VALUES (1,101,'Microsoft','1978'); INSERT INTO test_repair_table4 VALUES (2,101,'MySQL','1995'); SELECT * FROM test_repair_table4; num magic_no company_name founded 2 0101 SAP 1972 1 0101 Microsoft 1978 2 0101 MySQL 1995 CHECK TABLE test_repair_table4; Table Op Msg_type Msg_text test.test_repair_table4 check status OK REPAIR TABLE test_repair_table4; Table Op Msg_type Msg_text test.test_repair_table4 repair status OK SELECT * FROM test_repair_table4; num magic_no company_name founded 2 0101 SAP 1972 1 0101 Microsoft 1978 2 0101 MySQL 1995 CHECK TABLE test_repair_table4; Table Op Msg_type Msg_text test.test_repair_table4 check status OK REPAIR TABLE test_repair_table4; Table Op Msg_type Msg_text test.test_repair_table4 repair status OK SELECT * FROM test_repair_table4; num magic_no company_name founded 2 0101 SAP 1972 1 0101 Microsoft 1978 2 0101 MySQL 1995 DROP TABLE test_repair_table4; CREATE TABLE test_repair_table5 ( num int not null, magic_no int(4) unsigned zerofill DEFAULT '0000' NOT NULL, company_name char(30) DEFAULT '' NOT NULL, founded char(4) DEFAULT '' NOT NULL ) ENGINE = CSV; CHECK TABLE test_repair_table5; Table Op Msg_type Msg_text test.test_repair_table5 check error Corrupt REPAIR TABLE test_repair_table5; Table Op Msg_type Msg_text test.test_repair_table5 repair status OK SELECT * FROM test_repair_table5; num magic_no company_name founded INSERT INTO test_repair_table5 VALUES (1, 102, "CORRECT", 1876); SELECT * FROM test_repair_table5; num magic_no company_name founded 1 0102 CORRECT 1876 FLUSH TABLES; CHECK TABLE test_repair_table5; Table Op Msg_type Msg_text test.test_repair_table5 check error Corrupt REPAIR TABLE test_repair_table5; Table Op Msg_type Msg_text test.test_repair_table5 repair status OK SELECT * FROM test_repair_table5; num magic_no company_name founded 1 0102 CORRECT 1876 INSERT INTO test_repair_table5 VALUES (1, 102, "CORRECT2", 1876); SELECT * FROM test_repair_table5; num magic_no company_name founded 1 0102 CORRECT 1876 1 0102 CORRECT2 1876 FLUSH TABLES; CHECK TABLE test_repair_table5; Table Op Msg_type Msg_text test.test_repair_table5 check error Corrupt REPAIR TABLE test_repair_table5; Table Op Msg_type Msg_text test.test_repair_table5 repair status OK SELECT * FROM test_repair_table5; num magic_no company_name founded 1 0102 CORRECT 1876 1 0102 CORRECT2 1876 DROP TABLE test_repair_table5; create table t1 (a int not null) engine=csv; insert t1 values (1); delete from t1; affected rows: 1 delete from t1; affected rows: 0 insert t1 values (1),(2); delete from t1; affected rows: 2 insert t1 values (1),(2),(3); flush tables; delete from t1; affected rows: 3 insert t1 values (1),(2),(3),(4); flush tables; select count(*) from t1; count(*) 4 delete from t1; affected rows: 4 insert t1 values (1),(2),(3),(4),(5); truncate table t1; affected rows: 0 drop table t1; create table t1 (v varchar(32) not null) engine=csv; insert into t1 values ('def'),('abc'),('hij'),('3r4f'); select * from t1; v def abc hij 3r4f alter table t1 change v v2 varchar(32) not null; select * from t1; v2 def abc hij 3r4f alter table t1 change v2 v varchar(64) not null; select * from t1; v def abc hij 3r4f update t1 set v = 'lmn' where v = 'hij'; select * from t1; v lmn def abc 3r4f alter table t1 add i int not null first; select * from t1; i v 0 lmn 0 def 0 abc 0 3r4f update t1 set i=3 where v = 'abc'; select * from t1; i v 3 abc 0 lmn 0 def 0 3r4f alter table t1 change i i bigint not null; select * from t1; i v 3 abc 0 lmn 0 def 0 3r4f select * from t1 where i between 2 and 4 and v in ('def','3r4f','abc'); i v 3 abc drop table t1; create table bug15205 (val int(11) not null) engine=csv; create table bug15205_2 (val int(11) not null) engine=csv; select * from bug15205; ERROR HY000: Can't get stat of './test/bug15205.CSV' (Errcode: 2 "No such file or directory") select * from bug15205_2; val select * from bug15205; val drop table bug15205; drop table bug15205_2; set names latin1; create table t1 ( c varchar(1) not null, name varchar(64) not null ) character set latin1 engine=csv; insert into t1 values (0xC0,'LATIN CAPITAL LETTER A WITH GRAVE'); insert into t1 values (0xE0,'LATIN SMALL LETTER A WITH GRAVE'); insert into t1 values (0xEE,'LATIN SMALL LETTER I WITH CIRCUMFLEX'); insert into t1 values (0xFE,'LATIN SMALL LETTER THORN'); insert into t1 values (0xF7,'DIVISION SIGN'); insert into t1 values (0xFF,'LATIN SMALL LETTER Y WITH DIAERESIS'); select hex(c), c, name from t1 order by 1; hex(c) c name C0 À LATIN CAPITAL LETTER A WITH GRAVE E0 à LATIN SMALL LETTER A WITH GRAVE EE î LATIN SMALL LETTER I WITH CIRCUMFLEX F7 ÷ DIVISION SIGN FE þ LATIN SMALL LETTER THORN FF ÿ LATIN SMALL LETTER Y WITH DIAERESIS drop table t1; End of 5.0 tests create table bug22080_1 (id int not null,string varchar(64) not null) Engine=CSV; create table bug22080_2 (id int not null,string varchar(64) not null) Engine=CSV; create table bug22080_3 (id int not null,string varchar(64) not null) Engine=CSV; insert into bug22080_1 values(1,'string'); insert into bug22080_1 values(2,'string'); insert into bug22080_1 values(3,'string'); check table bug22080_2; Table Op Msg_type Msg_text test.bug22080_2 check error Corrupt check table bug22080_3; Table Op Msg_type Msg_text test.bug22080_3 check error Corrupt drop tables bug22080_1,bug22080_2,bug22080_3; create table float_test (id float not null,string varchar(64) not null) Engine=CSV; insert into float_test values(1.0,'string'); insert into float_test values(2.23,'serg.g'); insert into float_test values(0.03,'string'); insert into float_test values(0.19,'string'); insert into float_test values(.67,'string'); insert into float_test values(9.67,'string'); select * from float_test; id string 1 string 2.23 serg.g 0.03 string 0.19 string 0.67 string 9.67 string drop table float_test; CREATE TABLE `bug21328` ( `col1` int(11) NOT NULL, `col2` int(11) NOT NULL, `col3` int(11) NOT NULL ) ENGINE=CSV; insert into bug21328 values (1,0,0); alter table bug21328 engine=myisam; drop table bug21328; create table t1(a blob not null, b int not null) engine=csv; insert into t1 values('a', 1); flush tables; update t1 set b=2; select * from t1; a b a 2 drop table t1; create table t1(a int not null) engine=csv; insert into t1 values(-1), (-123.34), (2), (-23); select * from t1; a -1 -123 2 -23 check table t1; Table Op Msg_type Msg_text test.t1 check status OK drop table t1; create table t1(a int not null, b int not null) engine=csv; repair table t1; Table Op Msg_type Msg_text test.t1 repair Warning Data truncated for column 'a' at row 5 test.t1 repair status OK check table t1; Table Op Msg_type Msg_text test.t1 check status OK select * from t1; a b 1 0 -200 1 -1 -1 -1 -100 check table t1; Table Op Msg_type Msg_text test.t1 check status OK drop table t1; create table t1(a int not null) engine=csv; insert into t1 values (0), (1), (2); delete from t1 limit 2; check table t1; Table Op Msg_type Msg_text test.t1 check status OK select * from t1; a 2 delete from t1; check table t1; Table Op Msg_type Msg_text test.t1 check status OK select * from t1; a drop table t1; create table t1(a datetime not null) engine=csv; insert into t1 values(); Warnings: Warning 1364 Field 'a' doesn't have a default value select * from t1; a 0000-00-00 00:00:00 drop table t1; create table t1(a set('foo','bar') not null) engine=csv; insert into t1 values(); Warnings: Warning 1364 Field 'a' doesn't have a default value select * from t1; a drop table t1; create table t1(a varchar(32) not null) engine=csv; insert into t1 values(); Warnings: Warning 1364 Field 'a' doesn't have a default value select * from t1; a drop table t1; create table t1(a int not null) engine=csv; insert into t1 values(); Warnings: Warning 1364 Field 'a' doesn't have a default value select * from t1; a 0 drop table t1; create table t1(a blob not null) engine=csv; insert into t1 values(); Warnings: Warning 1364 Field 'a' doesn't have a default value select * from t1; a drop table t1; create table t1(a bit(1) not null) engine=csv; insert into t1 values(); Warnings: Warning 1364 Field 'a' doesn't have a default value select BIN(a) from t1; BIN(a) 0 drop table t1; create table t1(a enum('foo','bar') default null) engine=csv; ERROR 42000: The storage engine for the table doesn't support nullable columns create table t1(a enum('foo','bar') default 'foo') engine=csv; ERROR 42000: The storage engine for the table doesn't support nullable columns create table t1(a enum('foo','bar') default 'foo' not null) engine=csv; insert into t1 values(); select * from t1; a foo drop table t1; CREATE TABLE t1(a INT) ENGINE=CSV; ERROR 42000: The storage engine for the table doesn't support nullable columns SHOW WARNINGS; Level Code Message Error 1178 The storage engine for the table doesn't support nullable columns Error 1005 Can't create table 'test.t1' (errno: 138 "Unsupported extension used for table") create table t1 (c1 tinyblob not null) engine=csv; insert into t1 values("This"); update t1 set c1="That" where c1="This"; affected rows: 1 info: Rows matched: 1 Changed: 1 Warnings: 0 select * from t1; c1 That drop table t1; create table t1 (a int not null) engine=csv; lock tables t1 read; select * from t1; ERROR HY000: File 'MYSQLD_DATADIR/test/t1.CSV' not found (Errcode: 2 "No such file or directory") unlock tables; drop table t1; CREATE TABLE t1 (e enum('foo','bar') NOT NULL) ENGINE = CSV; INSERT INTO t1 VALUES(); INSERT INTO t1 VALUES(default); INSERT INTO t1 VALUES(0); Warnings: Warning 1265 Data truncated for column 'e' at row 1 INSERT INTO t1 VALUES(3); Warnings: Warning 1265 Data truncated for column 'e' at row 1 INSERT INTO t1 VALUES(-1); Warnings: Warning 1265 Data truncated for column 'e' at row 1 SELECT * FROM t1; e foo foo DROP TABLE t1; CREATE TABLE t1 ( b TEXT NOT NULL ) ENGINE=MYISAM; INSERT INTO t1 VALUES ('x'),('y'); CREATE TABLE t2 ( a VARCHAR(1) NOT NULL ) ENGINE=CSV; INSERT INTO t2 VALUES ('r'),('t'); SELECT * FROM t2 ORDER BY a; a r t SELECT * FROM t1 LEFT JOIN t2 ON ( b = a ); b a x NULL y NULL drop table t1,t2; # # Test for the following cases # 1) integers and strings enclosed in quotes # 2) integers and strings not enclosed in quotes # 3) \X characters with quotes # 4) \X characters outside quotes # CREATE TABLE t1(c1 INT NOT NULL, c2 VARCHAR(50) NOT NULL) ENGINE=csv; # remove the already existing .CSV file if any # create the .CSV file that contains the hard-coded data used in # testing 1,"integer sans quotes" 1,string sans quotes 1,quotes"in between" strings "1",Integer with quote and string with no quote 1,"escape sequence \n \" \\ \r \a within quotes" 1,escape sequence \n \" \\ \r \a without quotes # select from the table in which the data has been filled in using # the hard-coded .CSV file SELECT * FROM t1; c1 c2 1 integer sans quotes 1 string sans quotes 1 quotes"in between" strings 1 Integer with quote and string with no quote 1 escape sequence " \ \a within quotes 1 escape sequence " \ \a without quotes DROP TABLE t1; # Test for the case when a field begins with a quote, but does not end in a # quote. # Note: This results in an error. CREATE TABLE t1(c1 INT NOT NULL, c2 VARCHAR(50) NOT NULL) ENGINE=csv; # remove the already existing .CSV file if any # create the .CSV file that contains the hard-coded data used in # testing 1,"string only at the beginning quotes # select from the table in which the data has been filled in using # the hard-coded .CSV file SELECT * FROM t1; ERROR HY000: Table 't1' is marked as crashed and should be repaired DROP TABLE t1; # Test for the case when a field ends with a quote, but does not begin in a # quote. # Note: This results in an error. CREATE TABLE t1(c1 INT NOT NULL, c2 VARCHAR(50) NOT NULL) ENGINE=csv; # remove the already existing .CSV file if any # create the .CSV file that contains the hard-coded data used in # testing 1,string with only ending quotes" # select from the table in which the data has been filled in using # the hard-coded .CSV file SELECT * FROM t1; ERROR HY000: Table 't1' is marked as crashed and should be repaired DROP TABLE t1; End of 5.1 tests