Changeset: 105543abb655 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/105543abb655
Modified Files:
        clients/Tests/MAL-signatures-hge.test
        clients/Tests/MAL-signatures.test
        sql/benchmarks/moa/Tests/one.test
        sql/test/rel-optimizers/Tests/join-merge-remote-replica-plan.test
        sql/test/xquery/Tests/create.test
Branch: less_explain_info
Log Message:

Revert some erroneous changes to test output


diffs (211 lines):

diff --git a/clients/Tests/MAL-signatures-hge.test 
b/clients/Tests/MAL-signatures-hge.test
--- a/clients/Tests/MAL-signatures-hge.test
+++ b/clients/Tests/MAL-signatures-hge.test
@@ -3817,7 +3817,7 @@ bat
 info
 command bat.info(X_0:bat[:any_1]) (X_1:bat[:str], X_2:bat[:str])
 BKCinfo
-Produce a table containing information about a BAT in [attribute,value] 
format. @It contains all details of the BAT record. 
+Produce a table containing information about a BAT in [attribute,value] 
format. @It contains all properties of the BAT record. 
 bat
 intersectcand
 command bat.intersectcand(X_0:bat[:oid], X_1:bat[:oid]):bat[:oid]
@@ -48012,7 +48012,7 @@ mdb
 setDebug
 pattern mdb.setDebug(X_0:str):int
 MDBsetDebugStr
-Set the kernel debugging bit-set and return its previous value.@The recognized 
options are: threads, memory, details,@io, transactions, modules, algorithms, 
estimates.
+Set the kernel debugging bit-set and return its previous value.@The recognized 
options are: threads, memory, properties,@io, transactions, modules, 
algorithms, estimates.
 mdb
 setVMsize
 pattern mdb.setVMsize(X_0:lng):lng
@@ -49012,7 +49012,7 @@ optimizer
 mitosis
 pattern optimizer.mitosis(X_0:str, X_1:str):str
 OPTwrapper
-Modify the explain show details to exploit parallel processing on multiple 
cores
+Modify the plan to exploit parallel processing on multiple cores
 optimizer
 multiplex
 pattern optimizer.multiplex():str
@@ -49057,7 +49057,7 @@ optimizer
 profiler
 pattern optimizer.profiler(X_0:str, X_1:str):str
 OPTwrapper
-Collect details for the profiler
+Collect properties for the profiler
 optimizer
 projectionpath
 pattern optimizer.projectionpath():str
diff --git a/clients/Tests/MAL-signatures.test 
b/clients/Tests/MAL-signatures.test
--- a/clients/Tests/MAL-signatures.test
+++ b/clients/Tests/MAL-signatures.test
@@ -3252,7 +3252,7 @@ bat
 info
 command bat.info(X_0:bat[:any_1]) (X_1:bat[:str], X_2:bat[:str])
 BKCinfo
-Produce a table containing information about a BAT in [attribute,value] 
format. @It contains all details of the BAT record. 
+Produce a table containing information about a BAT in [attribute,value] 
format. @It contains all properties of the BAT record. 
 bat
 intersectcand
 command bat.intersectcand(X_0:bat[:oid], X_1:bat[:oid]):bat[:oid]
@@ -36492,7 +36492,7 @@ mdb
 setDebug
 pattern mdb.setDebug(X_0:str):int
 MDBsetDebugStr
-Set the kernel debugging bit-set and return its previous value.@The recognized 
options are: threads, memory, details,@io, transactions, modules, algorithms, 
estimates.
+Set the kernel debugging bit-set and return its previous value.@The recognized 
options are: threads, memory, properties,@io, transactions, modules, 
algorithms, estimates.
 mdb
 setVMsize
 pattern mdb.setVMsize(X_0:lng):lng
@@ -37492,7 +37492,7 @@ optimizer
 mitosis
 pattern optimizer.mitosis(X_0:str, X_1:str):str
 OPTwrapper
-Modify the explain show details to exploit parallel processing on multiple 
cores
+Modify the plan to exploit parallel processing on multiple cores
 optimizer
 multiplex
 pattern optimizer.multiplex():str
@@ -37537,7 +37537,7 @@ optimizer
 profiler
 pattern optimizer.profiler(X_0:str, X_1:str):str
 OPTwrapper
-Collect details for the profiler
+Collect properties for the profiler
 optimizer
 projectionpath
 pattern optimizer.projectionpath():str
diff --git a/sql/benchmarks/moa/Tests/one.test 
b/sql/benchmarks/moa/Tests/one.test
--- a/sql/benchmarks/moa/Tests/one.test
+++ b/sql/benchmarks/moa/Tests/one.test
@@ -12605,7 +12605,7 @@ 1057    "8.1"   "Tired of being the golden bo
 1080   "6.4"   "The main character (John Travolta) observes a strange light on 
his birthdayat a bar.  The following days he becomes very intellegent and puts 
theintellegence to good use in his community.  When word gets around hebecomes 
known as a freak and everyone wants to figure out why thishappened to a car 
mechanic.  The government also wants to get theirhands on it to put it to other 
uses."        1
 1104   "5.7"   "Baby George got into a plane crash in a jungle, stayed alive 
and wasadopted by a wise ape. Ursula Stanhope, US noble woman is saved 
fromdeath on safari by grown-up George, and he takes her to jungle to livewith 
him. He slowly learns a rules of human relationships, whileUrsula\'s lover Lyle 
is looking for her and the one who took her. Afterthey are found, Ursula takes 
George to the USA."  1
 1129   "6.9"   "It hadn\'t even been a year since a plantation owner named 
Louishad lost his wife, and now he had lost his will to live. Avampire named 
Lestat takes a liking to Louis and offers him thechance to become a creature of 
the night: a vampire. Louisaccepts, and Lestat drains Louis\' mortal blood and 
then replacesit with his own turning Louis into a vampire. Louis must learnfrom 
Lestat the ways of the vampire."        1
-1154   "5.5"   "Three ex-wives, dumped for newer models, determine to get 
their revenge.They had helped their husbands become financially successful, so 
theycleverly explain show details to hurt their exes in their pockets. Justice 
is sweet andfun with plenty of great on-liners and physical gags."     1
+1154   "5.5"   "Three ex-wives, dumped for newer models, determine to get 
their revenge.They had helped their husbands become financially successful, so 
theycleverly plan to hurt their exes in their pockets. Justice is sweet andfun 
with plenty of great on-liners and physical gags."     1
 1179   "5.1"   "We follow a bunch of high school kids through a period in 
theirpuberty. Their lives mainly consist of watching the girls in theshower and 
making life a living hell for their teachers and foreach other. The movie is 
packed with practical jokes andeccentric characters, like Pee Wee with the 
short dick (which hemeasures every morning) who met up for sex with the 
school""mattress"" Wendy already wearing a rubber, or the fat teachingbitch 
Beulah Balbricker who is determined on making life a livinghell for the boys. 
The name ""Porky\'s"" is the name of a stripteasebar the boys get thrown out of 
and humiliated in in the beginningof the movie. They have their minds set on 
revenge, but that\'snot easy as the owner\'s brother is sheriff. Only by 
forgettingtheir internal differences can they defeat Porky and his gang."    1
 1203   "5.3"   "Phil Beddoe is an easy-going trucker and a great 
fist-fighter.With two friends - Orville, who promotes prize-fights for him,and 
Clyde, the orang-utan he won on a bet - he roams the SanFernando Valley in 
search ofcold beer, country music and the occasional punch-up. But he isfloored 
himself by a dainty little country and western singer, whogives him the slip 
when she realises he\'s getting too serious. Phil,Clyde and Orville set off in 
pursuit, pestered by bikers."   1
 1227   "7.4"   "Ted Kramer is a career man for whom his work comes before his 
family. Hiswife Joanna cannot take this anymore, so she decides to leave him. 
Tedis now faced with the tasks of housekeeping and taking care of himselfand 
their young son Billy. When he has learned to adjust his life tothese new 
responsibilities, Joanna resurfaces and wants Billy back. Tedhowever refuses to 
give him up, so they go to court to fight for thecustody of their son."     1
@@ -12628,7 +12628,7 @@ 1630    "7.3"   "Loosely based upon the story
 1658   "7.2"   "When lawyer Robert Clayton Dean meets an old pal accidentally, 
he does notknow the trouble that is going to hit him. His pal, being 
pursuedbadly, slips him a disc without Robert reckoning - before being 
killed.Soon, Robert is believed to have something that others want - but 
what?Later, he stumbles across a setup that would render him the mainsuspect of 
a gruesome murder, hadn\'t he dropped by. Being shown severalbugs by Brill, a 
trustable contact of the victim, Robert learns quicklyabout the fire he\'s 
playing with - and decides to win instead of givingup. The murder case of a 
staged suicide by a U.S. congressman may causesome heads to roll, if the disc 
containing the proof can be found intime and delivered to its destination - by 
the right party, that is."       1
 1682   "7.7"   "Lara inspires lechery in Komarovsky (her mother\'s lover who 
is a master atsurviving whoever runs Russia) and can\'t compete with passion 
for therevolution of the man she marries, Pasha.  Her true love is Zhivago 
whoalso loves his wife.  Lara is the one who inspires poetry.  The storyis 
narrated by Zhivago\'s half brother Yevgraf, who has made his careerin the 
Soviet Army.  At the beginning of the film he is about to meet ayoung woman he 
believes may be the long lost daughter of Lara andZhivago."  1
 1707   "6.0"   "Julius and Vincent Benedict are the results of an experiment 
that wouldallow for the perfect child.  Julius was planned and grows to 
athleticproportions.  Vincent is an accident and is somewhat smaller instature. 
Vincent is placed in an orphanage while Julius is taken to asouth seas island 
and raised by philosophers.  Vincent becomes theultimate low life and is about 
to be killed by loan sharks when Juliusdiscovers that he has a brother and 
begins looking for him."  1
-1732   "8.7"   "McMurphy thinks he can get out of doing work while in prison 
by pretendingto be mad.   His explain show details backfires when he is sent to 
a mental asylum. He tries to liven the place up a bit by playing card games 
andbasketball with his fellow inmates, but the head nurse is after him atevery 
turn.   After he organised a party, one of the inmates commitssuicide and 
things start to go badly wrong."     1
+1732   "8.7"   "McMurphy thinks he can get out of doing work while in prison 
by pretendingto be mad.   His plan backfires when he is sent to a mental 
asylum. He tries to liven the place up a bit by playing card games 
andbasketball with his fellow inmates, but the head nurse is after him atevery 
turn.   After he organised a party, one of the inmates commitssuicide and 
things start to go badly wrong."     1
 1757   "5.3"   "Five years after the events of the first film, the 
Ghostbusters have beenplagued by lawsuits and court orders, and their 
once-lucrative businessis bankrupt. However, when Dana begins to have ghost 
problems again,the boys come out of retirement only to be promptly arrested. 
TheGhostbusters discover that New York is once again headed forsupernatural 
doom, with a river of ectoplasmic slime bubbling beneaththe city and an ancient 
sorcerer attempting to possess Dana\'s baby andbe born anew. Can the 
Ghostbusters quell the negative emotions feedingthe otherworldly threat and 
stop the world from being slimed?"      1
 1782   "7.2"   "Travolta plays an undercover agent who takes the 
physicalappearance of an assumed dead terrorist (Cage). The terrorist wasonly 
in a coma, and he takes the form of Travolta."  1
 1808   "7.3"   "After proving himself on the field of battle in the French and 
Indian War, Benjamin Martin wants nothing more to do with such things, 
preferring the simple life of a farmer. But when his son Gabriel enlists in the 
army to defend their new nation, America, against the British, Benjamin 
reluctantly returns to his old life to protect his son, now serving under his 
command, and his family from British tyranny. "    1
@@ -12663,7 +12663,7 @@ 2519    "6.7"   "Mitch is a middle aged big-c
 2544   "7.0"   "A new Disc Jockey is shipped from Crete to Vietnam to bring 
humor to ArmedForces Radio.  He turns the studio on it\'s ear and becomes 
wildlypopular with the troops but runs afoul of the middle management whothink 
he isn\'t G.I. enough.  While he is off the air, he tries to meetVietnamese 
especially girls, and begins to have brushes with the realwar that never 
appears on the radio."       1
 2569   "6.5"   "Armand Goldman owns a popular drag nightclub in South Miami 
Beach. Hislong-time lover Albert stars there as Starina. ""Their"" son 
Val(actually Armand\'s by his one heterosexual fling, twenty years before)comes 
home to announce his engagement to Barbara Keely, daughter ofKevin Keely, US 
Senator, and vice president of the Committee for MoralOrder. The Senator and 
family descend upon South Beach to meet Val andhis father and ""mother..."" and 
what ensues is comic chaos."      1
 2594   "6.8"   "Based on the popular 70\'s TV show, three cute chicks work for 
the mysterious""Charlie"". They are the female \'James Bonds\'\' of our time. 
They get toblow stuff up, kick the cr*p out of people, and wear really 
tightclothing, all whilst trying to retrieve stolen software and balance inhigh 
heels."    1
-2619   "6.5"   "Megalomaniac media mogul, Elliot Carver (<A 
HREF=""/Name?Pryce,+Jonathan"">Jonathan Pryce</A>), onlyneeds broadcasting 
rights in China to complete his globalcommunications empire.  The Chinese, 
however, are proving stubborn sohe hatches a diabolical explain show details to 
thwart the Chinese by the simple meansof starting a war between them and the 
British.  When a British warship is sunk in Chinese waters and its deadly 
payload stolen, JamesBond (<A HREF=""/Name?Brosnan,+Pierce"">Pierce 
Brosnan</A>) embarks on a dangerous mission againstthe clock to discover the 
truth.  The Chinese also want to know what ishappening and dispatch their own 
agent, Wai Lin (<A HREF=""/Name?Yeoh,+Michelle"">Michelle Yeoh</A>),who proves 
to be a match for James Bond!"  1
+2619   "6.5"   "Megalomaniac media mogul, Elliot Carver (<A 
HREF=""/Name?Pryce,+Jonathan"">Jonathan Pryce</A>), onlyneeds broadcasting 
rights in China to complete his globalcommunications empire.  The Chinese, 
however, are proving stubborn sohe hatches a diabolical plan to thwart the 
Chinese by the simple meansof starting a war between them and the British.  
When a British warship is sunk in Chinese waters and its deadly payload stolen, 
JamesBond (<A HREF=""/Name?Brosnan,+Pierce"">Pierce Brosnan</A>) embarks on a 
dangerous mission againstthe clock to discover the truth.  The Chinese also 
want to know what ishappening and dispatch their own agent, Wai Lin (<A 
HREF=""/Name?Yeoh,+Michelle"">Michelle Yeoh</A>),who proves to be a match for 
James Bond!"  1
 2643   "6.2"   "Harry and Lloyd are two brainless losers who try to return a 
suitcase fullof money to its pretty owner. After a journey full of accidents 
theyarrive in snowy Aspen, Colorado and try to find her. But will theysucceed?" 
     1
 2668   "7.6"   "Erin Brockovich is an unemployed single mother desperate find 
a job but ishaving no luck.  This losing streak even extends to a failed 
lawsuitagainst a doctor in a car accident she was in.  With no alternative,she 
successfully browbeats her lawyer to give her a job in compensationfor the 
loss.  While no one takes her seriously with her trashy clothesand earthy 
manners, that soon changes when she begins to investigate asuspicious real 
estate case involving the Pacific Gas  and  Electric Co..What she discovers is 
that the company is trying to quietly to buy landthat was contaminated by 
hexavalent chromium, a deadly toxic waste thatthe company is improperly and 
illegally dumping and in turn poisoningthe residents in the area.  As she digs 
deeper, Erin finds herselfleading point in a series of events that would 
involve her lawfirm inone of the biggest class action lawsuits in American 
history against amulti-billion dollar corporation."      1
 2692   "7.8"   "In this movie, Jim Carrey is Truman, a man whose life is a 
fake one... Theplace he lives is in fact a big studio with hidden cameras 
everywhere,and all his friends and people around him, are actors who play 
theirroles in the most popular tv-series in the world: The Truman Show.Truman 
thinks that he is an ordinary man with an ordinary life and hasno idea about 
how he is exploited. Until one day... he finds outeverything. Will he react?"   
     1
@@ -12702,7 +12702,7 @@ 3486    "6.5"   "Three film students travel t
 3507   "6.7"   "Hongkong, the last night of British rulership. Detective 
Inspector Lee,close friend to Consul Han Solon, manages to prevent precious 
pieces ofChina\'s history being smuggled out of the country. Two years later 
-Consul Han is living in Los Angeles with his family - Crime Lord Juntaotakes 
revenge on him by abducting his young daughter Soo Yung. Han doesnot trust the 
FBI to do a good job and has Lee flown in from Hongkongto assist them. But the 
FBI officials do not want any help from outsideand officially request help from 
LAPD, who are glad to get rid ofDetective James Carter for a while, a 
big-mouthed work-alone cop whojust can\'t be cool enough. His assignment is to 
keep Lee as far awayfrom trouble as possible. But Carter and Lee don\'t like 
being put asidein that way and start working the case on their own."   1
 3532   "7.4"   "Defence lawyers, Kaffee (maverick) and Galloway (dutiful) are 
assigned thecase of defending two US soldiers, accused of murdering a 
fellowsoldier who was deemed to have \'broken the code\'. Kaffee and 
Gallowaysoon run into a brick wall (Jessup), who sees himself as a 
military\'untouchable.\' The accused claim they were obeying orders 
(Jessup\'s),and that the death was an accident."       1
 3557   "5.6"   "Capt. John Smith leads a rag-tag band of English sailors  and  
soldiers to theNew World to plunder its riches for England (or, more precisely, 
forGovernor Ratcliffe, who comes along for the ride).  Meanwhile, in this""New 
World,"" Chief Powhatan has pledged his daughter, Pocahontas, to bemarried to 
the village\'s greatest warrior. Pocahontas, however, hasother ideas.  She has 
seen a vision of a spinning arrow, a vision shebelieves tells her change is 
coming.  Her life does indeed change whenthe English ship lands near her 
village. Between Ratcliffe, whobelieves the ""savages"" are hiding the gold he 
expected to be plentiful,and Powhatan, who believes these pale newcomers will 
destroy theirland, Smith and Pocahontas have a difficult time preventing 
all-outwar, and saving their love for each other."       1
-3584   "7.4"   "Faber College has one frat house so disreputable it will take 
anyone. Ithas a second one full of white, anglo-saxon, rich young men who are 
sosanctimonious no one can stand them except Dean Wormer.  The deanenlists the 
help of the second frat to get the boys of Delta House offcampus.  This film 
gives high-jinks and fooling around a bad name.  PThe dean\'s explain show 
details comes into play just before the homecoming parade toend all parades for 
all time."  1
+3584   "7.4"   "Faber College has one frat house so disreputable it will take 
anyone. Ithas a second one full of white, anglo-saxon, rich young men who are 
sosanctimonious no one can stand them except Dean Wormer.  The deanenlists the 
help of the second frat to get the boys of Delta House offcampus.  This film 
gives high-jinks and fooling around a bad name.  PThe dean\'s plan comes into 
play just before the homecoming parade toend all parades for all time."  1
 3609   "7.5"   "Disney animation inspired by Rudyard Kiplings ""Mowgli"" 
story. Mowgli is aboy who has been raised by wolves in the Indian jungle. When 
the wolveshear that the fierce tiger, Shere Kahn, is nearby, they decide to 
sendMowgli to a local ""man tribe"". On his way to the village, Mowgli 
meetsmany animal characters in this musical tale. When Shere Kahn learns 
ofMowgli\'s presence, he tracks him down." 1
 3633   "6.4"   "Tony is an uneducated Brooklyn teenager.  The highlight of his 
week isgoing to the local disco, where he is the king of the dancefloor. 
Tonymeets Stephanie at the disco and they agree to dance together in 
acompetition.  Stephanie resists Tony\'s attempts to romance her, as sheaspires 
to greater things; she is moving across the river to Manhattan.Gradually, Tony 
also becomes disillusioned with the life he is leadingand he and Stephanie 
decide to help one another to start afresh."    1
 3658   "5.4"   "Dr. John Dolittle has the world in his hands: A beautiful 
wifeat his side, two adorable daughters and a career that could notgo better. 
One night, he nearly runs over a dog with his car. Thedog yells ""bonehead"" 
and disappears. From then on, his childhoodability is back: To communicate with 
animals. Unfortunately, theword of Dolittle\'s ability is spreading quickly. 
Soon, manyanimals from rat to horse flock to his place to get medicaladvice. 
But his colleagues suspect he\'s going mad, and as theclinic Dolittle used to 
work for is about to being taken over fora huge amount of money, many decisions 
have to be made. Believehim? Put him into a mental institution? Sell the 
clinic? But alsohis family is close to breaking apart. Until a circus tiger 
fallsseriously ill." 1
@@ -12736,7 +12736,7 @@ 4361    "5.6"   "Three bachelor friends - arc
 4386   "7.6"   "The movie is about the life of Tarzan.  Tarzan was a small 
orphan who wasraised by an ape named Kala since he was a child.  He 
believedthat this was his family, but on an expedition Jane Porter is rescuedby 
Tarzan.  He then finds out that he\'s human.  Now Tarzan must makethe decision 
as to which family he should belong to..."       1
 4427   "8.5"   "In the near future, a computer hacker named Neo (Keanu Reeves) 
discoversthat all life on Earth may be nothing more than an elaborate 
facadecreated by a malevolent cyber-intelligence, for the purpose ofplacating 
us while our life essence is ""farmed"" to fuel the Matrix\'scampaign of 
domination in the ""real"" world. He joins like-minded Rebelwarriors Morpheus 
(Laurence Fishburne) and Trinity (Carrie Ann Moss) intheir struggle to 
overthrow the Matrix."        1
 4453   "7.5"   "Based on the true story of the ill-fated 13th Apollo mission 
bound for themoon. Astronauts Lovell, Haise and Swigert were scheduled to fly 
Apollo14, but are moved up to 13. It\'s 1970, and America have alreadyachieved 
their lunar landing goal, so there\'s little interest in this""routine"" 
flight.. until that is, things go very wrong, and prospectsof a safe return 
fade."  1
-4503   "6.5"   "The President of the USA goes to Moscow and gives a stirring 
speechoutlining the USA\'s new ""Zero-tolerance"" policy with respect 
toterrorism.  On the flight home, terrorists take over Air Force One 
(thePresident\'s official plane) and take the passengers (including his wifeand 
daughter) hostage.  The terrorists explain show details to execute one 
hostageevery half-hour unless/until their demands are met.  However, 
thePresident is a former Medal of Honor winner, so the terrorists may bein for 
a surprise..."      1
+4503   "6.5"   "The President of the USA goes to Moscow and gives a stirring 
speechoutlining the USA\'s new ""Zero-tolerance"" policy with respect 
toterrorism.  On the flight home, terrorists take over Air Force One 
(thePresident\'s official plane) and take the passengers (including his wifeand 
daughter) hostage.  The terrorists plan to execute one hostageevery half-hour 
unless/until their demands are met.  However, thePresident is a former Medal of 
Honor winner, so the terrorists may bein for a surprise..."      1
 4527   "4.6"   "The McAllister family go on a holiday to Florida. 
KevinMcAllister gets separated from his family, and manages to get himselfonto 
a plane to New York instead. There, he checks into the best hotelwith his 
father\'s credit card, and sets out to enjoy himself.Unfortunately, the 
burgulars he had foiled before were in New Yorkafter being released from jail, 
and had plans to rob the biggesttoyshop in New York on Christmas Eve. Kevin 
discovers their plan, andsets out to foil their plots again, while the 
burgulars set out tofinish off what they had not done before - the killing of 
the bratKevin."     1
 4551   "6.5"   "New York reporter Sue travels to Australia to meet and 
interview Michael JCrocodile Dundee, a man who runs a safari business and has 
justsurvived an attacked by a crocodile. After spending a few days touringthe 
safari park, Sue invites Mick to come back with her to visit NewYork. How would 
the clash of cultures and different life style affectthe Aussie bushman? How do 
things turn out when Sue falls for hischarms?"      1
 4576   "6.8"   "Nick Marshall, Playboy and Hot Shot in advertising, thinks 
he\'s God\'s giftto women. After a little accident, he discovers that he is 
suddenlyable to hear what women really think. First, Nick is prettydisappointed 
when he discovers that his beloved macho behaviour doesnot exactly contribute 
to being desired. Then, his upcoming dreamposition in the company is being 
given to a new team member: Darcy, notonly a woman, but a man-eating one, also 
is a very talented ad expert.So, Nick decides to sabotage his new boss by 
reading her thoughts andselling her ideas as his own. Unfortunately, love gets 
in his way."   1
@@ -12760,10 +12760,10 @@ 4999  "8.1"   "Scarlett is a woman who can 
 5024   "5.8"   "Due to a shuttle\'s unfortunate demise in outer space, NASA 
becomes aware ofa doomsday asteroid that is on a collision course with Earth. 
It seemsthat the only way to knock it off course is to drill into its 
surfaceand detonate a nuclear weapon.  But as NASA\'s under-funded 
yetresourceful team train the world\'s best drillers for the job, thesocial 
order of the world begins to break down as the informationreaches the public 
and hysteria results.  As high-ranking officialsplay politics with the effort, 
the drilling team all faces deeppersonal issues which may jeopardize 
humanity\'s last chance..."    1
 5049   "7.9"   "Beatty\'s novelization of a real case of possession that 
happened in aWashington Suburb (Mt. Ranier, MD) puts Regan, an adolescent 
girl,Living with her mother in Georgetown in Washington, into a more andmore 
difficult situation.  She exhibits strange symptoms, includinglevitation and 
great strength.  When all medical possibilities areexhausted, her mother is 
sent to a priest who is also a psychiatrist.He becomes convinced that Regan is 
possessed and he and a second priestexperienced in exorcism try to drive the 
spirit from Regan before shedies.  Very graphic for it\'s time."  1
 5073   "7.9"   "Nearly 10 years have passed since Sarah Connor was targeted 
for terminationby a cyborg from the future.   Now her son, John, the future 
leader ofthe resistance, is the target for a newer, more deadly terminator. 
Once again, the resistance has managed to send a protector back toattempt to 
save John and his mother Sarah."      1
-5098   "6.5"   "Dr. Evil uses a device he calls a ""Time Machine"" to travel 
back to 1969 andremove Austin Powers\' mojo. The sexually wounded swinger must 
travelback in time and, with the help of agent Felicity Shagwell, recover 
hisvitality.  Meanwhile, Dr. Evil\'s personal life runs amok as hediscovers 
love, continues to shun his son and develops a closerelationship with himself. 
Well, actually, a clone 1/8 his size whom hedubs ""Mini-Me"".  The always 
time-baffled Dr. Evil begins his explain show details toput a gigantic cannon 
on the moon, thus turning it into a device calledeither ""The Death Star"" or 
""Alan Parson\'s Project,"" depending on whichname is available."       1
+5098   "6.5"   "Dr. Evil uses a device he calls a ""Time Machine"" to travel 
back to 1969 andremove Austin Powers\' mojo. The sexually wounded swinger must 
travelback in time and, with the help of agent Felicity Shagwell, recover 
hisvitality.  Meanwhile, Dr. Evil\'s personal life runs amok as hediscovers 
love, continues to shun his son and develops a closerelationship with himself. 
Well, actually, a clone 1/8 his size whom hedubs ""Mini-Me"".  The always 
time-baffled Dr. Evil begins his plan toput a gigantic cannon on the moon, thus 
turning it into a device calledeither ""The Death Star"" or ""Alan Parson\'s 
Project,"" depending on whichname is available."       1
 5124   "7.7"   "After FedEx systems engineer Chuck Noland is ripped out of his 
hasty lifeby the clock in a plane crash, he finds himself alone on the shores 
ofa tropical island. First, frustration gets to him and then he realizeshow 
little his chances are to ever get back to civilisation. Four yearslater, Chuck 
has learned very well how to survive on his own: mendinghis dental health, 
catching fish with a spear, predicting the weatherwith a selfmade calendar. A 
photograph of his girlfriend Kelly has kepthis hopes alive all these years. 
Finally, Chuck takes the opportunityto take off for home: He sets off on a 
wooden raft with a sail that haswashed ashore."       1
 5148   "7.8"   "Marty McFly is your average, slacker teenager, who is friendly 
with a wackyinventor named Doc Brown.  When Doc creates a time machine out of 
aDeLorean car, Marty is accidentally transported into the year 1955.There, he 
stumbles upon a younger version of his parents, disrupts themeeting, and must 
get the two together so that they would get marriedand have him!"     1
-5173   "6.2"   "IMF agent Ethan Hunt has been sent on a mission to retrieve 
and destroy thesupply of a genetically created disease called \'Chimera\'. His 
missionis made impossible due to the fact that he is not the only person 
aftersamples of the disease. He must also contest with a gang ofinternational 
terrorist headed by a turned bad former IMF agent who hasalready managed to 
steal the cure called \'Bellerophon\' and now need\'Chimera\' to complete their 
grand explain show details of infecting the whole world. Inorder to infiltrate 
and locate the terrorist group he relies on thehelp of an international thief 
Nyah of whom he quickly develops a loveinterest. Time is not only running out 
for Agent Hunt to find anddestroy \'Chimera\' before the terrorists get their 
hands on it, but hemust also find \'Bellerophon\' so as to save his love 
interest who hasalready become infected by the disease from a terrible and 
rapid death."       1
+5173   "6.2"   "IMF agent Ethan Hunt has been sent on a mission to retrieve 
and destroy thesupply of a genetically created disease called \'Chimera\'. His 
missionis made impossible due to the fact that he is not the only person 
aftersamples of the disease. He must also contest with a gang ofinternational 
terrorist headed by a turned bad former IMF agent who hasalready managed to 
steal the cure called \'Bellerophon\' and now need\'Chimera\' to complete their 
grand plan of infecting the whole world. Inorder to infiltrate and locate the 
terrorist group he relies on thehelp of an international thief Nyah of whom he 
quickly develops a loveinterest. Time is not only running out for Agent Hunt to 
find anddestroy \'Chimera\' before the terrorists get their hands on it, but 
hemust also find \'Bellerophon\' so as to save his love interest who hasalready 
become infected by the disease from a terrible and rapid death."       1
 5198   "8.5"   "In World War II, it is found that 3 soldiers who have been 
killed arebrothers. The mother will be receiving three death notices on the 
sameday. The army discovers that there were actually four brothers. Amission is 
deployed to find Private James Ryan and send him home." 1
 5222   "7.5"   "Aladdin is a street-urchin who lives in a large and busy town 
long ago withhis faithful monkey friend Abu.  When Princess Jasmine gets tired 
ofbeing forced to remain in the palace that overlooks the city, shesneaks out 
to the marketplace, where she accidentally meets Aladdin.Under the  orders of 
the evil Jafar (the sultan\'s advisor), Aladdin isthrown in jail and becomes 
caught up in Jafar\'s plot to rule the landwith the aid of a mysterious lamp.  
Legend has it that only a personwho is a ""diamond in the rough"" can retrieve 
the lamp from the Cave ofWonders.  Aladdin might fight that description, but 
that\'s not enoughto marry the princess, who must (by law) marry a prince."   1
 5248   "6.7"   "Sam and Molly are a very happy couple and deeply in love. 
Walking back totheir new apartment after a night out at the theatre, they 
encounter athief in a dark alley, and Sam is murdered. He finds himself trapped 
asa ghost and realises that his death was no accident. He must warn Mollyabout 
the danger that she is in. But as a ghost he can not be seen orheard by the 
living, and so he tries to communicate with Molly throughOda Mae Brown, a 
psychic who didn\'t even realise that her powers werereal."   1
@@ -12781,7 +12781,7 @@ 5523    "8.2"   "The peaceful community of Am
 5548   "6.1"   "In this film, Macaulay Culkin is an eight years old boy that 
is left athome by his parents, when they leave with the rest of the family 
forChristmas holidays to Paris. At first he seems to enjoy living alone,but 
after a while he understands that things aren\'t so easy. Especiallywhen two 
robbers deside to break in a particular house. HIS house! Ishe able to defend 
his home?"      1
 5572   "8.6"   "Darth Vader is helping the Empire crush the 
rebelliondetermined to end the Empire\'s domination of the universe.   The 
rebelsare based on Hoth, and when troops arrive to wipe them out, Han Soloand 
Princess Leia flee to Cloud City.   Luke Skywalker, in a bid tostrengthen his 
knowledge of the force, finds Yoda, one of the finestJedis ever. Will they be 
able to get back together and halt the Empiresprogress ?"     1
 5597   "8.5"   "Malcom Crowe is a child psychologist who receives an award on 
the samenight that he is visited by a very unhappy ex-patient. After 
thisencounter, Crowe takes on the task of curing a young boy with the sameills 
as the ex-patient. This boy ""sees dead people"". Crowe spends a lotof time 
with the boy (Cole) much to the dismay of his wife. Cole\'s mom isat her wit\'s 
end with what to do about her son\'s increasing problems.Crowe is the boy\'s 
only hope." 1
-5621   "6.0"   "On July 2nd, communications systems worldwide are sent into 
chaos by astrange atmospheric interference. It is soon learned by the 
militarythat a number of enormous objects are on a collision course with 
Earth.At first thought to be meteors, they are later revealed to be 
giganticspacecraft, piloted by a mysterious alien species. After attempts 
tocommunicate with the aliens go nowhere, David Levinson, an ex-scientistturned 
cable technician, discovers that the aliens are going to attackmajor points 
around the globe in less than a day. On July 3rd, thealiens all but obliterate 
New York, Los Angeles, and Washington. Thesurvivors set out in convoys towards 
Area 51, a strange governmenttesting ground where it is rumored the military 
has a captured alienspacecraft of their own. The survivors devise a explain 
show details to fight backagainst the enslaving aliens, and July 4th becomes 
the day humanitywill fight for its freedom. July 4th is their Independence 
Day..."    1
+5621   "6.0"   "On July 2nd, communications systems worldwide are sent into 
chaos by astrange atmospheric interference. It is soon learned by the 
militarythat a number of enormous objects are on a collision course with 
Earth.At first thought to be meteors, they are later revealed to be 
giganticspacecraft, piloted by a mysterious alien species. After attempts 
tocommunicate with the aliens go nowhere, David Levinson, an ex-scientistturned 
cable technician, discovers that the aliens are going to attackmajor points 
around the globe in less than a day. On July 3rd, thealiens all but obliterate 
New York, Los Angeles, and Washington. Thesurvivors set out in convoys towards 
Area 51, a strange governmenttesting ground where it is rumored the military 
has a captured alienspacecraft of their own. The survivors devise a plan to 
fight backagainst the enslaving aliens, and July 4th becomes the day 
humanitywill fight for its freedom. July 4th is their Independence Day..."    1
 5647   "8.0"   "Darth Vader and the Empire are building a new, indestructible 
Death Star. Meanwhile, Han Solo has been imprisoned, and Luke Skywalker has 
sentR2D2 and C3PO to try and free him.   Princess Leia - disguised as abounty 
hunter - and Chewbacca go along as well.   The final battletakes place on the 
moon of Endor, with its natural inhabitants, theEwoks, lending a hand to the 
rebels.   Will Darth Vader and the darkside overcome the rebels and take over 
the universe ?"       1
 5672   "7.5"   "A young lion prince is born in Africa, thus making his uncle 
Scarthe second in line to the throne. Scar plots with the hyenas to killKing 
Mufasa and Prince Simba, thus making himself King. The King iskilled and Simba 
is led to believe by Scar that it was his fault, andso flees the kingdom in 
shame. After years of exile he is persuaded toreturn home to overthrow the 
usurper and claim the kingdom as his ownthus completing the ""Circle of 
Life""."       1
 5698   "7.8"   "The story follows the life of low I.Q. Forrest Gump (Tom 
Hanks)and his meeting with the love of his life Jenny. The filmchronicles his 
accidental experiences with some of the mostimportant people and events in 
America from the late 1950\'sthrough the 1970\'s including a meeting with Elvis 
Presley, JFK,Lyndon Johnson, Richard Nixon, fighting in Vietnam, etc. 
Theproblem is, he\'s too stupid to realize the significance of hisactions. 
Forrest becomes representative of the baby boomergeneration having walked 
through life blindly."    1
diff --git a/sql/test/rel-optimizers/Tests/join-merge-remote-replica-plan.test 
b/sql/test/rel-optimizers/Tests/join-merge-remote-replica-plan.test
--- a/sql/test/rel-optimizers/Tests/join-merge-remote-replica-plan.test
+++ b/sql/test/rel-optimizers/Tests/join-merge-remote-replica-plan.test
@@ -55,9 +55,9 @@ alter table members_rpl add table member
 statement ok
 select * from foo_p1
 
-# check that the explain show details is executing the join of the remote part 
of the
+# check that the plan is executing the join of the remote part of the
 # merge table with the remote part of the replica and then transfers the
-# result in the master node (hint: the remote explain show details is wrapped 
around a
+# result in the master node (hint: the remote plan is wrapped around a
 # 'table' returning relational operator)
 
 query T nosort
diff --git a/sql/test/xquery/Tests/create.test 
b/sql/test/xquery/Tests/create.test
--- a/sql/test/xquery/Tests/create.test
+++ b/sql/test/xquery/Tests/create.test
@@ -24108,7 +24108,7 @@ 24015,0,10,3,," "
 23996,19,9,1,11,""
 24016,0,9,3,," "
 24018,0,10,3,," "
-24020,0,11,3,," illustrious with body palace frowning got does details town 
swallowed valued credulity demand un"
+24020,0,11,3,," illustrious with body palace frowning got does properties town 
swallowed valued credulity demand un"
 24022,0,12,3,," everlastingly wrestle "
 24021,1,11,1,22,""
 24023,0,11,3,," eastern revolt cake humour self buy rise wary diana gush some 
capable "
@@ -34592,7 +34592,7 @@ 34496,0,7,3,," octavius spotless massy s
 34498,0,8,3,," moreover promises "
 34497,1,7,1,22,""
 34499,0,7,3,," accept morn power such oph abide sees "
-34501,0,8,3,," thick quarter message conduct outrage jephthah taken bade 
imports votarist details pain wax "
+34501,0,8,3,," thick quarter message conduct outrage jephthah taken bade 
imports votarist properties pain wax "
 34500,1,7,1,22,""
 34502,0,7,3,," devise fellow bal thwarted damn sot plough experienc forges 
stand borrow lent hugh promotion just i"
 34477,25,6,1,12,""
@@ -104912,7 +104912,7 @@ 104813,1,5,1,66,""
 104815,0,5,3,," "
 104817,0,6,3,," "
 104819,0,7,3,," amorous east dreadful heavenly roof bate might egg athwart eld 
books alas bark hatches beams dishon"
-104821,0,8,3,," details miscall shalt fashion shepherd "
+104821,0,8,3,," properties miscall shalt fashion shepherd "
 104820,1,7,1,23,""
 104822,0,7,3,," fell excus conceive sheet unworthy head round cassius "
 104824,0,8,3,," quart pillow stay moody delivers songs "
@@ -143363,7 +143363,7 @@ 143266,0,6,3,," "
 143268,0,7,3,," ope run urine led month aught wanting settled government 
spoken forsworn deceived nest even trot ro"
 143270,0,8,3,," mistake dispensation guilty "
 143269,1,7,1,13,""
-143271,0,7,3,," prompts thimbles wets strive gave forbids store details salt 
cleopatra goose agamemnon mowbray "
+143271,0,7,3,," prompts thimbles wets strive gave forbids store properties 
salt cleopatra goose agamemnon mowbray "
 143273,0,8,3,," ludlow pawn woman having twigs future "
 143275,0,9,3,," delight valour supposition raging "
 143274,1,8,1,13,""
@@ -152976,7 +152976,7 @@ 152883,0,10,3,," "
 152885,0,11,3,," fret forest conjure base drunken affray urs jealous buildeth 
chides husband closet unprovided profe"
 152887,0,12,3,," innocents nine cowards condemn grieving envious conduct 
outrage jephthah taken "
 152886,1,11,1,22,""
-152888,0,11,3,," details norfolk usurer reign sunder memorial devise virtue 
bal thwarted damn look envious experi"
+152888,0,11,3,," properties norfolk usurer reign sunder memorial devise virtue 
bal thwarted damn look envious experi"
 152890,0,12,3,," just importun heart "
 152889,1,11,1,23,""
 152891,0,11,3,," courtesy shent blind  "
_______________________________________________
checkin-list mailing list -- [email protected]
To unsubscribe send an email to [email protected]

Reply via email to