mirror/mariadb
1
0
Fork 0
mirror of https://github.com/MariaDB/server.git synced 2025-01-15 19:42:28 +01:00
Code Issues Projects Releases Packages Wiki Activity Actions
mariadb/mysql-test/suite/csv/csv.result
Monty c4cad8d50c MDEV-33449 improving repair of tables 
This task is to ensure we have a clear definition and rules of how to
repair or optimize a table.

The rules are:

- REPAIR should be used with tables that are crashed and are
  unreadable (hardware issues with not readable blocks, blocks with
  'unexpected data' etc)
- OPTIMIZE table should be used to optimize the storage layout for the
  table (recover space for delete rows and optimize the index
  structure.
- ALTER TABLE table_name FORCE should be used to rebuild the .frm file
  (the table definition) and the table (with the original table row
  format). If the table is from and older MariaDB/MySQL release with a
  different storage format, it will convert the data to the new
  format. ALTER TABLE ... FORCE is used as part of mariadb-upgrade

Here follows some more background:

The 3 ways to repair a table are:
1) ALTER TABLE table_name FORCE" (not other options).
   As an alias we allow: "ALTER TABLE table_name ENGINE=original_engine"
2) "REPAIR TABLE" (without FORCE)
3) "OPTIMIZE TABLE"

All of the above commands will optimize row space usage (which means that
space will be needed to hold a temporary copy of the table) and
re-generate all indexes. They will also try to replicate the original
table definition as exact as possible.

For ALTER TABLE and "REPAIR TABLE without FORCE", the following will hold:
If the table is from an older MariaDB version and data conversion is
needed (for example for old type HASH columns, MySQL JSON type or new
TIMESTAMP format) "ALTER TABLE table_name FORCE, algorithm=COPY" will be
used.

The differences between the algorithms are
1) Will use the fastest algorithm the engine supports to do a full repair
   of the table (except if data conversions are is needed).
2) Will use the storage engine internal REPAIR facility (MyISAM, Aria).
   If the engine does not support REPAIR then
   "ALTER TABLE FORCE, ALGORITHM=COPY" will be used.
   If there was data incompatibilities (which means that FORCE was used)
   then there will be a warning after REPAIR that ALTER TABLE FORCE is
   still needed.
   The reason for this is that REPAIR may be able to go around data
   errors (wrong incompatible data, crashed or unreadable sectors) that
   ALTER TABLE cannot do.
3) Will use the storage engine internal OPTIMIZE. If engine does not
   support optimize, then "ALTER TABLE FORCE" is used.

The above will ensure that ALTER TABLE FORCE is able to
correct almost any errors in the row or index data.  In case of
corrupted blocks then REPAIR possible followed by ALTER TABLE is needed.
This is important as mariadb-upgrade executes ALTER TABLE table_name
FORCE for any table that must be re-created.

Bugs fixed with InnoDB tables when using ALTER TABLE FORCE:
- No error for INNODB_DEFAULT_ROW_FORMAT=COMPACT even if row length
  would be too wide. (Independent of innodb_strict_mode).
- Tables using symlinks will be symlinked after any of the above commands
  (Independent of the setting of --symbolic-links)

If one specifies an algorithm together with ALTER TABLE FORCE, things
will work as before (except if data conversion is required as then
the COPY algorithm is enforced).

ALTER TABLE .. OPTIMIZE ALL PARTITIONS will work as before.

Other things:
- FORCE argument added to REPAIR to allow one to first run internal
  repair to fix damaged blocks and then follow it with ALTER TABLE.
- REPAIR will not update frm_version if ha_check_for_upgrade() finds
  that table is still incompatible with current version. In this case the
  REPAIR will end with an error.
- REPAIR for storage engines that does not have native repair, like InnoDB,
  is now using ALTER TABLE FORCE.
- REPAIR csv-table USE_FRM now works.
  - It did not work before as CSV tables had extension list in wrong
    order.
- Default error messages length for %M increased from 128 to 256 to not
  cut information from REPAIR.
- Documented HA_ADMIN_XX variables related to repair.
- Added HA_ADMIN_NEEDS_DATA_CONVERSION to signal that we have to
  do data conversions when converting the table (and thus ALTER TABLE
  copy algorithm is needed).
- Fixed typo in error message (caused test changes).
2024-05-27 12:39:03 +02:00

5572 lines
61 KiB
Text
Raw Permalink Blame History

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");
call mtr.add_suppression("Table 't1' 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 'test.t2,test.t3,test.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;
connect con1,localhost,root,,;
connect con2,localhost,root,,;
connection con1;
LOCK TABLES test_concurrent_insert READ LOCAL;
connection con2;
INSERT INTO test_concurrent_insert VALUES (1);
SELECT * FROM test_concurrent_insert;
val
1
connection con1;
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;
connection default;
disconnect con1;
disconnect con2;
CREATE TABLE test_repair_table ( val integer not null ) ENGINE = CSV;
INSERT into test_repair_table values (1),(2);
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
SELECT * from test_repair_table;
val
1
2
REPAIR TABLE test_repair_table USE_FRM;
Table Op Msg_type Msg_text
test.test_repair_table repair status OK
SELECT * from test_repair_table;
val
1
2
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 <09> LATIN CAPITAL LETTER A WITH GRAVE
E0 <09> LATIN SMALL LETTER A WITH GRAVE
EE <09> LATIN SMALL LETTER I WITH CIRCUMFLEX
F7 <09> DIVISION SIGN
FE <09> LATIN SMALL LETTER THORN
FF <09> 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 ignore 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 ignore 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 ignore 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 ignore 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 ignore 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 ignore 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
Warning 1112 Table 't1' uses an extension that doesn't exist in this MariaDB version
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;
connect con1,localhost,root,,;
connection con1;
select * from t1;
ERROR HY000: File 'MYSQLD_DATADIR/test/t1.CSV' not found (Errcode: 2 "No such file or directory")
disconnect con1;
connection default;
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 IGNORE INTO t1 VALUES(0);
Warnings:
Warning 1265 Data truncated for column 'e' at row 1
INSERT IGNORE INTO t1 VALUES(3);
Warnings:
Warning 1265 Data truncated for column 'e' at row 1
INSERT IGNORE 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
#
# MDEV-5612 - my_rename() deletes files when it shouldn't
#
CREATE TABLE t1(a INT NOT NULL) ENGINE=CSV;
RENAME TABLE t1 TO t2;
SELECT * FROM t2;
a
DROP TABLE t2;
#
# MDEV-8664 - plugins.show_all_plugins --embedded fails in buildbot
#
CREATE TABLE t1(c1 TEXT NOT NULL, c2 TEXT NOT NULL) ENGINE=CSV IETF_QUOTES=yes;
INSERT INTO t1 VALUES("a\"b,c","d");
INSERT INTO t1 VALUES("d","a\"b,c");
INSERT INTO t1 VALUES(",\"a","e");
INSERT INTO t1 VALUES("e",",\"a");
INSERT INTO t1 VALUES("\"","f");
INSERT INTO t1 VALUES("f","\"");
INSERT INTO t1 VALUES(",","g");
INSERT INTO t1 VALUES("g",",");
SELECT * FROM t1;
c1 c2
a"b,c d
d a"b,c
,"a e
e ,"a
" f
f "
, g
g ,
CSV file contents:
"a""b,c","d"
"d","a""b,c"
",""a","e"
"e",",""a"
"""","f"
"f",""""
",","g"
"g",","
DROP TABLE t1;
CREATE TABLE t1(c1 TEXT NOT NULL, c2 TEXT NOT NULL) ENGINE=CSV IETF_QUOTES=yes;
Replacing t1.CSV
SELECT * FROM t1;
c1 c2
a b
a b
a"b,c d
d ,"a
a", e
e "
, f
ALTER TABLE t1 IETF_QUOTES=no;
SELECT * FROM t1;
c1 c2
a b
a b
a"b,c d
d ,"a
a", e
e "
, f
DROP TABLE t1;
Reference in a new issue View git blame Copy permalink