AryaWu/sqlite

1 2# 2007 October 153#4# The author disclaims copyright to this source code.  In place of5# a legal notice, here is a blessing:6#7#    May you do good and not evil.8#    May you find forgiveness for yourself and forgive others.9#    May you share freely, never taking more than you give.10#11#*************************************************************************12#13# $Id: fts3near.test,v 1.3 2009/01/02 17:33:46 danielk1977 Exp $14#15 16set testdir [file dirname $argv0]17source $testdir/tester.tcl18 19# If SQLITE_ENABLE_FTS3 is defined, omit this file.20ifcapable !fts3 {21  finish_test22  return23}24 25db eval {26  CREATE VIRTUAL TABLE t1 USING fts3(content);27  INSERT INTO t1(content) VALUES('one three four five');28  INSERT INTO t1(content) VALUES('two three four five');29  INSERT INTO t1(content) VALUES('one two three four five');30}31 32do_test fts3near-1.1 {33  execsql {SELECT docid FROM t1 WHERE content MATCH 'one NEAR/0 three'}34} {1}35do_test fts3near-1.2 {36  execsql {SELECT docid FROM t1 WHERE content MATCH 'one NEAR/1 two'}37} {3}38do_test fts3near-1.3 {39  execsql {SELECT docid FROM t1 WHERE content MATCH 'one NEAR/1 three'}40} {1 3}41do_test fts3near-1.4 {42  execsql {SELECT docid FROM t1 WHERE content MATCH 'three NEAR/1 one'}43} {1 3}44do_test fts3near-1.5 {45  execsql {SELECT docid FROM t1 WHERE content MATCH '"one two" NEAR/1 five'}46} {}47do_test fts3near-1.6 {48  execsql {SELECT docid FROM t1 WHERE content MATCH '"one two" NEAR/2 five'}49} {3}50do_test fts3near-1.7 {51  execsql {SELECT docid FROM t1 WHERE content MATCH 'one NEAR four'}52} {1 3}53do_test fts3near-1.8 {54  execsql {SELECT docid FROM t1 WHERE content MATCH 'four NEAR three'}55} {1 2 3}56do_test fts3near-1.9 {57  execsql {SELECT docid FROM t1 WHERE content MATCH '"four five" NEAR/0 three'}58} {1 2 3}59do_test fts3near-1.10 {60  execsql {SELECT docid FROM t1 WHERE content MATCH '"four five" NEAR/2 one'}61} {1 3}62do_test fts3near-1.11 {63  execsql {SELECT docid FROM t1 WHERE content MATCH '"four five" NEAR/1 one'}64} {1}65do_test fts3near-1.12 {66  execsql {SELECT docid FROM t1 WHERE content MATCH 'five NEAR/1 "two three"'}67} {2 3} 68do_test fts3near-1.13 {69  execsql {SELECT docid FROM t1 WHERE content MATCH 'one NEAR five'}70} {1 3} 71 72do_test fts3near-1.14 {73  execsql {SELECT docid FROM t1 WHERE content MATCH 'four NEAR four'}74} {} 75do_test fts3near-1.15 {76  execsql {SELECT docid FROM t1 WHERE content MATCH 'one NEAR two NEAR one'}77} {3} 78 79do_test fts3near-1.16 {80  execsql {81    SELECT docid FROM t1 WHERE content MATCH '"one three" NEAR/0 "four five"'82  }83} {1} 84do_test fts3near-1.17 {85  execsql {86    SELECT docid FROM t1 WHERE content MATCH '"four five" NEAR/0 "one three"'87  }88} {1} 89 90 91# Output format of the offsets() function:92#93#     <column number> <term number> <starting offset> <number of bytes>94#95db eval {96  INSERT INTO t1(content) VALUES('A X B C D A B');97}98do_test fts3near-2.1 {99  execsql {100    SELECT offsets(t1) FROM t1 WHERE content MATCH 'A NEAR/0 B'101  }102} {{0 0 10 1 0 1 12 1}}103do_test fts3near-2.2 {104  execsql {105    SELECT offsets(t1) FROM t1 WHERE content MATCH 'B NEAR/0 A'106  }107} {{0 1 10 1 0 0 12 1}}108do_test fts3near-2.3 {109  execsql {110    SELECT offsets(t1) FROM t1 WHERE content MATCH '"C D" NEAR/0 A'111  }112} {{0 0 6 1 0 1 8 1 0 2 10 1}}113do_test fts3near-2.4 {114  execsql {115    SELECT offsets(t1) FROM t1 WHERE content MATCH 'A NEAR/0 "C D"'116  }117} {{0 1 6 1 0 2 8 1 0 0 10 1}}118do_test fts3near-2.5 {119  execsql {120    SELECT offsets(t1) FROM t1 WHERE content MATCH 'A NEAR A'121  }122} {{0 0 0 1 0 1 0 1 0 0 10 1 0 1 10 1}}123do_test fts3near-2.6 {124  execsql {125    INSERT INTO t1 VALUES('A A A');126    SELECT offsets(t1) FROM t1 WHERE content MATCH 'A NEAR/2 A';127  }128} [list [list 0 0 0 1   0 1 0 1   0 0 2 1   0 1 2 1   0 0 4 1   0 1 4 1]]129do_test fts3near-2.7 {130  execsql {131    DELETE FROM t1;132    INSERT INTO t1 VALUES('A A A A');133    SELECT offsets(t1) FROM t1 WHERE content MATCH 'A NEAR A NEAR A';134  }135} [list [list \136    0 0 0 1   0 1 0 1   0 2 0 1   0 0 2 1   \137    0 1 2 1   0 2 2 1   0 0 4 1   0 1 4 1   \138    0 2 4 1   0 0 6 1   0 1 6 1   0 2 6 1   \139]]140 141db eval {142  DELETE FROM t1;143  INSERT INTO t1(content) VALUES(144    'one two three two four six three six nine four eight twelve'145  );146}147 148do_test fts3near-3.1 {149  execsql {SELECT offsets(t1) FROM t1 WHERE content MATCH 'three NEAR/1 one'}150} {{0 1 0 3 0 0 8 5}}151do_test fts3near-3.2 {152  execsql {SELECT offsets(t1) FROM t1 WHERE content MATCH 'one NEAR/1 three'}153} {{0 0 0 3 0 1 8 5}}154do_test fts3near-3.3 {155  execsql {SELECT offsets(t1) FROM t1 WHERE content MATCH 'three NEAR/1 two'}156} {{0 1 4 3 0 0 8 5 0 1 14 3}}157do_test fts3near-3.4 {158  execsql {SELECT offsets(t1) FROM t1 WHERE content MATCH 'three NEAR/2 two'}159} {{0 1 4 3 0 0 8 5 0 1 14 3 0 0 27 5}}160do_test fts3near-3.5 {161  execsql {SELECT offsets(t1) FROM t1 WHERE content MATCH 'two NEAR/2 three'}162} {{0 0 4 3 0 1 8 5 0 0 14 3 0 1 27 5}}163do_test fts3near-3.6 {164  execsql {165    SELECT offsets(t1) FROM t1 WHERE content MATCH 'three NEAR/0 "two four"'166  }167} {{0 0 8 5 0 1 14 3 0 2 18 4}}168do_test fts3near-3.7 {169  execsql {170    SELECT offsets(t1) FROM t1 WHERE content MATCH '"two four" NEAR/0 three'}171} {{0 2 8 5 0 0 14 3 0 1 18 4}}172 173db eval {174  INSERT INTO t1(content) VALUES('175    This specification defines Cascading Style Sheets, level 2 (CSS2). CSS2 is a style sheet language that allows authors and users to attach style (e.g., fonts, spacing, and aural cues) to structured documents (e.g., HTML documents and XML applications). By separating the presentation style of documents from the content of documents, CSS2 simplifies Web authoring and site maintenance.176 177    CSS2 builds on CSS1 (see [CSS1]) and, with very few exceptions, all valid CSS1 style sheets are valid CSS2 style sheets. CSS2 supports media-specific style sheets so that authors may tailor the presentation of their documents to visual browsers, aural devices, printers, braille devices, handheld devices, etc. This specification also supports content positioning, downloadable fonts, table layout, features for internationalization, automatic counters and numbering, and some properties related to user interface.178  ') 179}180do_test fts3near-4.1 {181  execsql {182    SELECT snippet(t1) FROM t1 WHERE content MATCH 'specification NEAR supports'183  }184} {{<b>...</b>braille devices, handheld devices, etc. This <b>specification</b> also <b>supports</b> content positioning, downloadable fonts, table layout<b>...</b>}}185 186do_test fts3near-5.1 {187  execsql {188    SELECT docid FROM t1 WHERE content MATCH 'specification attach'189  }190} {2}191do_test fts3near-5.2 {192  execsql {193    SELECT docid FROM t1 WHERE content MATCH 'specification NEAR attach'194  }195} {}196do_test fts3near-5.3 {197  execsql {198    SELECT docid FROM t1 WHERE content MATCH 'specification NEAR/18 attach'199  }200} {}201do_test fts3near-5.4 {202  execsql {203    SELECT docid FROM t1 WHERE content MATCH 'specification NEAR/19 attach'204  }205} {2}206do_test fts3near-5.5 {207  execsql {208    SELECT docid FROM t1 WHERE content MATCH 'specification NEAR/000018 attach'209  }210} {}211do_test fts3near-5.6 {212  execsql {213    SELECT docid FROM t1 WHERE content MATCH 'specification NEAR/000019 attach'214  }215} {2}216 217db eval {218  INSERT INTO t1 VALUES('219      abbrev aberrations abjurations aboding abr abscesses absolutistic220      abstention abuses acanthuses acceptance acclaimers accomplish221      accoutring accusation acetonic acid acolytes acquitting acrylonitrile222      actives acyclic addicted adenoid adjacently adjusting admissible223      adoption adulated advantaging advertisers aedes aerogramme aetiology224      affiliative afforest afterclap agamogenesis aggrade agings agonize225      agron ailurophile airfreight airspeed alarmists alchemizing226      alexandrines alien aliped all allergenic allocator allowances almost227      alphabetizes altho alvine amaurosis ambles ameliorate amicability amnio228      amour ampicillin amusement anadromous analogues anarchy anchormen229      anecdota aneurin angst animating anlage announcements anodized230      answerable antemeridian anthracene antiabortionist anticlimaxes231      antifriction antimitotic antiphon antiques antithetic anviled232      apatosaurus aphrodisia apodal aposiopesis apparatus appendectomies233      applications appraisingly appropriate apteryx arabinose234      arboricultural archdeaconates archipelago ardently arguers armadillo235      arnicas arrayed arrowy arthroscope artisans ascensive ashier236      aspersorium assail assentor assignees assonants astereognosis237      astringency astutest atheistical atomize attachment attenuates238      attrahent audibility augite auricle auteurists autobus autolysis239      autosome avenge avidest aw awl ayes babirusa backbeats backgrounder240      backseat backswings baddie bagnios baked balefuller ballista balmily241      bandbox bandylegged bankruptcy baptism barbering bargain barneys242      barracuda barterer bashes bassists bathers batterer bavardage243      beachfront beanstalk beauteous become bedim bedtimes beermats begat244      begun belabors bellarmine belongings bending benthos bereavements245      besieger bestialized betide bevels biases bicarbonates bidentate bigger246      bile billow bine biodynamics biomedicine biotites birding bisection247      bitingly bkg blackheads blaeberry blanking blatherer bleeper blindage248      blithefulness blockish bloodstreams bloused blubbing bluestocking249      blurted boatbill bobtailed boffo bold boltrope bondservant bonks250      bookbinding bookworm booting borating boscages botchers bougainvillea251      bounty bowlegged boyhood bracketed brainstorm brandishes252      braunschweigers brazilin breakneck breathlessness brewage bridesmaids253      brighter brisker broader brokerages bronziest browband brunets bryology254      bucking budlike bugleweed bulkily bulling bummer bunglers bureau burgs255      burrito bushfire buss butlery buttressing bylines cabdriver cached256      cadaverousnesses cafeterias cakewalk calcifies calendula callboy calms257      calyptra camisoles camps candelabrum caned cannolis canoodling cantors258      cape caponize capsuling caracoled carbolics carcase carditis caretakers259      carnallite carousel carrageenan cartels carves cashbook castanets260      casuistry catalyzer catchers categorizations cathexis caucuses261      causeway cavetto cede cella cementite centenary centrals ceramics ceria262      cervixes chafferer chalcopyrites chamfers change chaotically263      characteristically charivari chases chatterer cheats cheeks chef264      chemurgy chetah chickaree chigoes chillies chinning chirp chive265      chloroforms chokebore choplogic chorioids chromatic chronically266      chubbiest chunder chutzpah cimetidine cinque circulated circumscribe267      cirrose citrin claddagh clamorousness clapperboards classicalism268      clauses cleanse clemency clicker clinchers cliquiest clods closeting269      cloudscape clucking cnidarian coalfish coatrack coca cockfights coddled270      coeducation coexistence cognitively coiffed colatitude collage271      collections collinear colonelcy colorimetric columelliform combos272      comforters commence commercialist commit commorancy communized compar273      compendiously complainers compliance composition comprised comradery274      concelebrants concerted conciliation concourses condensate275      condonations confab confessionals confirmed conforming congeal276      congregant conjectured conjurers connoisseurs conscripting277      conservator consolable conspired constricting consuls contagious278      contemporaneity contesters continuities contractors contrarian279      contrive convalescents convents convexly convulsed cooncan coparcenary280      coprolite copyreader cordially corklike cornflour coroner corralling281      corrigible corsages cosies cosmonauts costumer cottontails counselings282      counterclaim counterpane countertenors courageously couth coveting283      coworker cozier cracklings crampon crappies craved cream credenzas284      crematoriums cresol cricoid crinkle criterion crocodile crore crossover285      crowded cruelest crunch cruzeiros cryptomeria cubism cuesta culprit286      cumquat cupped curdle curly cursoring curvy customized cutting cyclamens287      cylindrical cytaster dachshund daikon damages damselfly dangling288      darkest databanks dauphine dazzling deadpanned deathday debauchers289      debunking decameter decedents decibel decisions declinations290      decomposition decoratively decretive deduct deescalated defecating291      deferentially definiendum defluxion defrocks degrade deice dekaliters292      deli delinquencies deludedly demarcates demineralizers demodulating293      demonstrabilities demurred deniabilities denouncement denudation294      departure deplorable deposing depredatory deputizes derivational295      desalinization descriptors desexes desisted despising destitute296      detectability determiner detoxifying devalued devilries devotions297      dextrous diagenesis dialling diaphoresis diazonium dickeys diddums298      differencing dig dignified dildo dimetric dineric dinosaurs diplodocus299      directer dirty disagrees disassembler disburses disclosures300      disconcerts discountability discrete disembarrass disenthrone301      disgruntled dishpans disintegrators dislodged disobedient302      dispassionate dispiritednesses dispraised disqualifying303      dissatisfying dissidence dissolvers distich distracting distrusts304      ditto diverse divineness dizzily dockyard dodgers doggish doited dom305      dominium doohickey doozie dorsum doubleheaders dourer downbeats306      downshifted doyennes draftsman dramatic drawling dredge drifter307      drivelines droopier drowsed drunkards dubiosities duding dulcifying308      dumpcart duodecillion durable duteous dyed dysgenic eagles earplugs309      earwitness ebonite echoers economical ectothermous edibility educates310      effected effigies eggbeaters egresses ejaculates elasticize elector311      electrodynamometer electrophorus elem eligibly eloped emaciating312      embarcaderos embezzlers embosses embryectomy emfs emotionalizing313      empiricist emu enamels enchained encoded encrusts endeavored endogamous314      endothelioma energizes engager engrosses enl enologist enrolls ensphere315      enters entirety entrap entryways envies eosinophil epicentral316      epigrammatized episodic epochs equestrian equitably erect ernes317      errorless escalated eschatology espaliers essonite estop eternity318      ethnologically eudemonics euphonious euthenist evangelizations319      eventuality evilest evulsion examinee exceptionably exciter320      excremental execrably exemplars exhalant exhorter exocrine exothermic321      expected expends explainable exploratory expostulatory expunges322      extends externals extorts extrapolative extrorse eyebolt eyra323      facetiously factor faeries fairings fallacies falsities fancifulness324      fantasticalness farmhouse fascinate fatalistically fattener fave325      fearlessly featly federates feints fellowman fencers ferny326      fertilenesses feta feudality fibers fictionalize fiefs fightback327      filefish filmier finaglers fingerboards finochio firefly firmament328      fishmeal fitted fjords flagitiousnesses flamen flaps flatfooting329      flauntier fleapit fleshes flickertail flints floaty floorboards330      floristic flow fluffily fluorescein flutes flyspecks foetal folderols331      followable foolhardier footlockers foppish forceless foredo foreknows332      foreseeing foretaste forgather forlorn formidableness fortalice333      forwarding founding foxhunting fragmentarily frangipani fray freeform334      freezable freshening fridges frilliest frizzed frontbench frottages335      fruitcake fryable fugleman fulminated functionalists fungoid furfuran336      furtive fussy fwd gadolinium galabias gallinaceous galvanism gamers337      gangland gaoling garganey garrisoning gasp gate gauger gayety geed338      geminately generalissimos genii gentled geochronology geomorphic339      geriatricians gesellschaft ghat gibbeting giggles gimps girdlers340      glabella glaive glassfuls gleefully glistered globetrotted glorifier341      gloving glutathione glyptodont goaled gobsmacked goggliest golliwog342      goobers gooseberries gormandizer gouramis grabbier gradually grampuses343      grandmothers granulated graptolite gratuitously gravitates greaten344      greenmailer greys grills grippers groan gropingly grounding groveling345      grueled grunter guardroom guggle guineas gummed gunnysacks gushingly346      gutturals gynecoid gyrostabilizer habitudes haemophilia hailer hairs347      halest hallow halters hamsters handhelds handsaw hangup haranguer348      hardheartedness harlotry harps hashing hated hauntingly hayrack349      headcases headphone headword heartbreakers heaters hebephrenia350      hedonist heightening heliozoan helots hemelytron hemorrhagic hent351      herbicides hereunto heroines heteroclitics heterotrophs hexers352      hidebound hies hightails hindmost hippopotomonstrosesquipedalian353      histologist hittable hobbledehoys hogans holdings holocrine homegirls354      homesteader homogeneousness homopolar honeys hoodwinks hoovered355      horizontally horridness horseshoers hospitalization hotdogging houri356      housemate howitzers huffier humanist humid humors huntress husbandmen357      hyaenas hydride hydrokinetics hydroponically hygrothermograph358      hyperbolically hypersensitiveness hypnogogic hypodermically359      hypothermia iatrochemistry ichthyological idealist ideograms idling360      igniting illegal illuminatingly ilmenite imbibing immateriality361      immigrating immortalizes immures imparts impeder imperfection362      impersonated implant implying imposition imprecating imprimis363      improvising impv inanenesses inaugurate incapably incentivize364      incineration incloses incomparableness inconsequential incorporate365      incrementing incumbered indecorous indentation indicative indignities366      indistinguishably indoors indulges ineducation inerrable367      inexperienced infants infestations infirmnesses inflicting368      infracostal ingathered ingressions inheritances iniquity369      injuriousnesses innervated inoculates inquisitionist insectile370      insiders insolate inspirers instatement instr insulates intactness371      intellects intensifies intercalations intercontinental interferon372      interlarded intermarrying internalizing interpersonally373      interrelatednesses intersperse interviewees intolerance374      intransigents introducing intubates invades inventing inveterate375      invocate iodides irenicism ironsmith irreducibly irresistibility376      irriguous isobarisms isometrically issuable itineracies jackdaws377      jaggery jangling javelins jeeringly jeremiad jeweler jigsawing jitter378      jocosity jokester jot jowls judicative juicy jungly jurists juxtaposed379      kalpa karstify keddah kendo kermesses keynote kibbutznik kidnaper380      kilogram kindred kingpins kissers klatch kneads knobbed knowingest381      kookaburras kruller labefaction labyrinths lacquer laddered lagoons382      lambency laminates lancinate landscapist lankiness lapse larked lasso383      laterite laudableness laundrywomen lawgiver laypersons leafhoppers384      leapfrogs leaven leeches legated legislature leitmotifs lenients385      leprous letterheads levelling lexicographically liberalists386      librettist licorice lifesaving lightheadedly likelier limekiln limped387      lines linkers lipoma liquidator listeners litharge litmus388      liverishnesses loamier lobeline locative locutionary loggier loiterer389      longevity loomed loping lotion louts lowboys luaus lucrativeness lulus390      lumpier lungi lush luthern lymphangial lythraceous machinists maculate391      maggot magnetochemistry maharani maimers majored malaprops malignants392      maloti mammary manchineel manfully manicotti manipulativenesses393      mansards manufactories maraschino margin markdown marooning marshland394      mascaraing massaging masticate matchmark matings mattes mausoleum395      mayflies mealworm meataxe medevaced medievalist meetings megavitamin396      melded melodramatic memorableness mendaciousnesses mensurable397      mercenaries mere meronymous mesmerizes mestee metallurgical398      metastasize meterages meticulosity mewed microbe microcrystalline399      micromanager microsporophyll midiron miffed milder militiamen400      millesimal milometer mincing mingily minims minstrelsy mires401      misanthropic miscalculate miscomprehended misdefines misery mishears402      misled mispickel misrepresent misspending mistranslate miswriting403      mixologists mobilizers moderators modulate mojo mollies momentum monde404      monied monocles monographs monophyletic monotonousness moocher405      moorages morality morion mortally moseyed motherly motorboat mouldering406      mousers moveables mucky mudslides mulatto multicellularity407      multipartite multivalences mundanities murkiest mushed muskiness408      mutability mutisms mycelia myosotis mythicist nacred namable napkin409      narghile nastiness nattering nauseations nearliest necessitate410      necrophobia neg negotiators neologizes nephrotomy netiquette411      neurophysiology newbie newspaper niccolite nielsbohriums nightlong412      nincompoops nitpicked nix noddling nomadize nonadhesive noncandidates413      nonconducting nondigestible nones nongreasy nonjoinder nonoccurrence414      nonporousness nonrestrictive nonstaining nonuniform nooses northwards415      nostalgic notepaper nourishment noyades nuclides numberless numskulls416      nutmegged nymphaea oatmeal obis objurgators oblivious obsequiousness417      obsoletism obtruding occlusions ocher octettes odeums offcuts418      officiation ogival oilstone olestras omikron oncogenesis onsetting419      oomphs openly ophthalmoscope opposites optimum orangutans420      orchestrations ordn organophosphates origin ornithosis orthognathous421      oscillatory ossuaries ostracized ounce outbreaks outearning outgrows422      outlived outpoints outrunning outspends outwearing overabound423      overbalance overcautious overcrowds overdubbing overexpanding424      overgraze overindustrialize overlearning overoptimism overproducing425      overripe overshadowing overspreading overstuff overtones overwind ow426      oxidizing pacer packs paganish painstakingly palate palette pally427      palsying pandemic panhandled pantheism papaws papped parading428      parallelize paranoia parasitically pardners parietal parodied pars429      participator partridgeberry passerines password pastors430      paterfamiliases patination patrolman paunch pawnshops peacekeeper431      peatbog peculator pedestrianism peduncles pegboard pellucidnesses432      pendency penitentiary penstock pentylenetetrazol peptidase perched433      perennial performing perigynous peripheralize perjurer permissively434      perpetuals persistency perspicuously perturbingly pesky petcock435      petrologists pfennige pharmacies phenformin philanderers436      philosophically phonecards phosgenes photocomposer photogenic photons437      phototype phylloid physiotherapeutics picadores pickup pieces pigging438      pilaster pillion pimples pinioned pinpricks pipers pirogi pit439      pitifullest pizza placental plainly planing plasmin platforming440      playacts playwrights plectra pleurisy plopped plug plumule plussed441      poaches poetasters pointless polarize policyholder polkaed442      polyadelphous polygraphing polyphonous pomace ponderers pooch poplar443      porcelains portableness portly positioning postage posthumously444      postponed potages potholed poulard powdering practised pranksters445      preadapt preassigning precentors precipitous preconditions predefined446      predictors preengage prefers prehumans premedical prenotification447      preplanning prepuberty presbytery presentation presidia prestissimo448      preterites prevailer prewarmed priding primitively principalships449      prisage privileged probed prochurch proctoscope products proficients450      prognathism prohibiting proletarianisms prominence promulgates451      proofreading property proportions prorate proselytize prosthesis452      proteins prototypic provenances provitamin prudish pseudonymities453      psychoanalysts psychoneuroses psychrometer publishable pufferies454      pullet pulses punchy punkins purchased purities pursers pushover455      putridity pylons pyrogenous pzazz quadricepses quaff qualmish quarriers456      quasilinear queerness questionnaires quieten quintals quislings quoits457      rabidness racketeers radiative radioisotope radiotherapists ragingly458      rainband rakishness rampagers rands raped rare raspy ratiocinator459      rattlebrain ravening razz reactivation readoption realm reapportioning460      reasoning reattempts rebidding rebuts recapitulatory receptiveness461      recipes reckonings recognizee recommendatory reconciled reconnoiters462      recontaminated recoupments recruits recumbently redact redefine463      redheaded redistributable redraw redwing reeled reenlistment reexports464      refiles reflate reflowing refortified refried refuses regelate465      registrant regretting rehabilitative reigning reinduced reinstalled466      reinvesting rejoining relations relegates religiosities reluctivity467      remastered reminisce remodifying remounted rends renovate reordered468      repartee repel rephrase replicate repossessing reprint reprogramed469      repugnantly requiter rescheduling resegregate resettled residually470      resold resourcefulness respondent restating restrainedly resubmission471      resurveyed retaliating retiarius retorsion retreated retrofitting472      returning revanchism reverberated reverted revitalization473      revolutionize rewind rhapsodizing rhizogenic rhythms ricketinesses474      ridicule righteous rilles rinks rippliest ritualize riyals roast rockery475      roguish romanizations rookiest roquelaure rotation rotundity rounder476      routinizing rubberize rubricated ruefully ruining rummaged runic477      russets ruttish sackers sacrosanctly safeguarding said salaciousness478      salinity salsas salutatorians sampan sandbag saned santonin479      saprophagous sarnies satem saturant savaged sawbucks scablike scalp480      scant scared scatter schedulers schizophrenics schnauzers schoolmarms481      scintillae scleroses scoped scotched scram scratchiness screwball482      scripting scrubwomen scrutinizing scumbled scuttled seals seasickness483      seccos secretions secularizing seditiousnesses seeking segregators484      seize selfish semeiology seminarian semitropical sensate sensors485      sentimo septicemic sequentially serener serine serums486      sesquicentennials seventeen sexiest sforzandos shadowing shallot487      shampooing sharking shearer sheered shelters shifter shiner shipper488      shitted shoaled shofroth shorebirds shortsightedly showboated shrank489      shrines shucking shuttlecocks sickeningly sideling sidewise sigil490      signifiers siliceous silty simony simulative singled sinkings sirrah491      situps skateboarder sketchpad skim skirmished skulkers skywalk slander492      slating sleaziest sleepyheads slicking slink slitting slot slub493      slumlords smallest smattered smilier smokers smriti snailfish snatch494      snides snitching snooze snowblowers snub soapboxing socialite sockeyes495      softest sold solicitings solleret sombreros somnolencies sons sopor496      sorites soubrette soupspoon southpaw spaces spandex sparkers spatially497      speccing specking spectroscopists speedsters spermatics sphincter498      spiffied spindlings spirals spitball splayfeet splitter spokeswomen499      spooled sportily spousals sprightliness sprogs spurner squalene500      squattered squelches squirms stablish staggerings stalactitic stamp501      stands starflower starwort stations stayed steamroll steeplebush502      stemmatics stepfathers stereos steroid sticks stillage stinker503      stirringly stockpiling stomaching stopcock stormers strabismuses504      strainer strappado strawberries streetwise striae strikeouts strives505      stroppiest stubbed study stunting style suavity subchloride subdeb506      subfields subjoin sublittoral subnotebooks subprograms subside507      substantial subtenants subtreasuries succeeding sucked sufferers508      sugarier sulfaguanidine sulphating summerhouse sunbonnets sunned509      superagency supercontinent superheroes supernatural superscribing510      superthin supplest suppositive surcease surfs surprise survey511      suspiration svelte swamplands swashes sweatshop swellhead swindling512      switching sworn syllabuses sympathetics synchrocyclotron syndic513      synonymously syringed tablatures tabulation tackling taiga takas talker514      tamarisks tangential tans taproom tarpapers taskmaster tattiest515      tautologically taxied teacup tearjerkers technocracies teepee516      telegenic telephony telexed temperaments temptress tenderizing tensed517      tenuring tergal terned terror testatrices tetherball textile thatched518      their theorem thereof thermometers thewy thimerosal thirsty519      thoroughwort threateningly thrived through thumbnails thwacks520      ticketing tie til timekeepers timorousness tinkers tippers tisane521      titrating toastmaster toff toking tomb tongs toolmakings topes topple522      torose tortilla totalizing touchlines tousling townsmen trachea523      tradeable tragedienne traitorous trances transcendentalists524      transferrable tranship translating transmogrifying transportable525      transvestism traumatize treachery treed trenail tressing tribeswoman526      trichromatism triennials trikes trims triplicate tristich trivializes527      trombonist trots trouts trued trunnion tryster tubes tulle tundras turban528      turgescence turnround tutelar tweedinesses twill twit tympanum typists529      tzarists ulcered ultramodern umbles unaccountability unamended530      unassertivenesses unbanned unblocked unbundled uncertified unclaimed531      uncoated unconcerns unconvinced uncrossing undefined underbodice532      underemphasize undergrowth underpayment undershirts understudy533      underwritten undissolved unearthed unentered unexpended unfeeling534      unforeseen unfussy unhair unhinges unifilar unimproved uninvitingly535      universalization unknowns unlimbering unman unmet unnaturalness536      unornament unperturbed unprecedentedly unproportionate unread537      unreflecting unreproducible unripe unsatisfying unseaworthiness538      unsharable unsociable unstacking unsubtly untactfully untied untruest539      unveils unwilled unyokes upheave upraised upstart upwind urethrae540      urtexts usurers uvula vacillators vailed validation valvule vanities541      varia variously vassaled vav veggies velours venerator ventrals542      verbalizes verification vernacularized verticality vestigially via543      vicariously victoriousness viewpoint villainies vines violoncellist544      virtual viscus vital vitrify viviparous vocalizers voidable volleys545      volutes vouches vulcanology wackos waggery wainwrights waling wallowing546      wanking wardroom warmup wartiest washwoman watchman watermarks waverer547      wayzgoose weariest weatherstripped weediness weevil welcomed548      wentletrap whackers wheatworm whelp whf whinged whirl whistles whithers549      wholesomeness whosoever widows wikiup willowier windburned windsail550      wingspread winterkilled wisecracking witchgrass witling wobbliest551      womanliness woodcut woodworking woozy working worldwide worthiest552      wrappings wretched writhe wynd xylophone yardarm yea yelped yippee yoni553      yuks zealotry zigzagger zitherists zoologists zygosis');554}555 556do_test fts3near-6.1 {557  execsql {558    SELECT docid FROM t1 WHERE content MATCH 'abbrev zygosis'559  }560} {3}561do_test fts3near-6.2 {562  execsql {563    SELECT docid FROM t1 WHERE content MATCH 'abbrev NEAR zygosis'564  }565} {}566do_test fts3near-6.3 {567  execsql {568    SELECT docid FROM t1 WHERE content MATCH 'abbrev NEAR/100 zygosis'569  }570} {}571do_test fts3near-6.4 {572  execsql {573    SELECT docid FROM t1 WHERE content MATCH 'abbrev NEAR/1000 zygosis'574  }575} {}576do_test fts3near-6.5 {577  execsql {578    SELECT docid FROM t1 WHERE content MATCH 'abbrev NEAR/10000 zygosis'579  }580} {3}581 582# Ticket 38b1ae018f.583#584do_execsql_test fts3near-7.1 {585  CREATE VIRTUAL TABLE x USING fts4(y,z);586  INSERT INTO x VALUES('aaa bbb ccc ddd', 'bbb ddd aaa ccc');587  SELECT * FROM x where y MATCH 'bbb NEAR/6 aaa';588} {{aaa bbb ccc ddd} {bbb ddd aaa ccc}}589 590do_execsql_test fts3near-7.2 {591  CREATE VIRTUAL TABLE t2 USING fts4(a, b);592  INSERT INTO t2 VALUES('A B C', 'A D E');593  SELECT * FROM t2 where t2 MATCH 'a:A NEAR E'594} {}595 596 597finish_test598