Return-Path: X-Original-To: apmail-jackrabbit-users-archive@minotaur.apache.org Delivered-To: apmail-jackrabbit-users-archive@minotaur.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id AD265D830 for ; Wed, 11 Jul 2012 18:17:19 +0000 (UTC) Received: (qmail 14306 invoked by uid 500); 11 Jul 2012 18:17:19 -0000 Delivered-To: apmail-jackrabbit-users-archive@jackrabbit.apache.org Received: (qmail 14275 invoked by uid 500); 11 Jul 2012 18:17:19 -0000 Mailing-List: contact users-help@jackrabbit.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: users@jackrabbit.apache.org Delivered-To: mailing list users@jackrabbit.apache.org Received: (qmail 14266 invoked by uid 99); 11 Jul 2012 18:17:19 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 11 Jul 2012 18:17:19 +0000 X-ASF-Spam-Status: No, hits=-0.7 required=5.0 tests=MIME_BASE64_BLANKS,RCVD_IN_DNSWL_LOW,SPF_HELO_PASS,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: domain of Carl.Furst@mlb.com designates 66.192.34.20 as permitted sender) Received: from [66.192.34.20] (HELO bleachers2.mlb.com) (66.192.34.20) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 11 Jul 2012 18:17:13 +0000 X-IronPort-AV: E=Sophos;i="4.77,569,1336363200"; d="scan'208";a="87573818" Received: from unknown (HELO BAMEXCH-HUB02.MLBAM.mlb.org) ([10.3.3.77]) by bleachers2.mlb.com with ESMTP; 11 Jul 2012 14:16:53 -0400 Received: from BAM-EXCH07.MLBAM.mlb.org ([10.3.3.66]) by BAMEXCH-HUB02.MLBAM.mlb.org ([10.3.3.77]) with mapi; Wed, 11 Jul 2012 14:16:52 -0400 From: "Furst, Carl" To: "users@jackrabbit.apache.org" Date: Wed, 11 Jul 2012 14:16:49 -0400 Subject: Re: jcr sql2 - contains() full text search not working Thread-Topic: jcr sql2 - contains() full text search not working Thread-Index: Ac1fkVg4ECZuZhkwRoaFWi02Sg9TFw== Message-ID: In-Reply-To: Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: user-agent: Microsoft-MacOutlook/14.2.2.120421 acceptlanguage: en-US Content-Type: text/plain; charset="euc-kr" MIME-Version: 1.0 Content-Transfer-Encoding: base64 U28gYWZ0ZXIgc29tZSBpbnZlc3RpZ2F0aW9uIEknbSBhdCBhIGxvc3MgYXMgdG8gd2hpY2ggY2xh c3MgdG8gdXNlIGZvcg0KdGV4dCBleHRyYWN0aW9uIChpZSB3aGF0IHRvIHNldCB0ZXh0RmlsdGVy Q2xhc3NlcyB0byBpbiB0aGUgd29ya3NwYWNlLnhtbA0KZmlsZSkuICBXaGljaCBjbGFzcyBpcyB0 aGUgZGVmYXVsdCBpbiAyLjQuMj8gVGhlIFdpa2kgSSB0aGluayBpcw0KaW5jb3JyZWN0Li4uIEl0 IHN0YXRlcw0Kb3JnLmFwYWNoZS5qYWNrcmFiYml0LmNvcmUucXVlcnkubHVjZW5lLlRleHRQbGFp blRleHRGaWx0ZXIgYXMgdGhlDQpkZWZhdWx0LCBidXQgSSBkb24ndCBzZWUgdGhhdCBjbGFzcyBp biB0aGUgc291cmNlIGNvZGUuDQoNClBvc3NpYmxlIGNhbmRpZGF0ZXMgYXJlOg0KT3JnLmFwYWNo ZS5qYWNrcmFiYml0LmNvcmUucXVlcnkubHVjZW5lLlNlYXJjaEluZGV4IChyZWd1bGFyIHNlYXJj aA0KaW5kZXhlcikNCk9yZy5hcGFjaGUuamFja3JhYmJpdC5jb3JlLnF1ZXJ5Lmx1Y2VuZS5CbG9j a2luZ1BhcnNlcg0Kb3JnLmFwYWNoZS5qYWNrcmFiYml0LmNvcmUucXVlcnkubHVjZW5lLkxhenlU ZXh0RXh0cmFjdG9yRmllbGQNCg0KQW55IHN1Z2dlc3Rpb25zPyBJJ2xsIHBsdWcgaW4gdGhlIGxh c3QgdHdvIGFuZCBzZWUgaWYgdGhpbmdzIGltcHJvdmUuDQoNCg0KDQoNClRoYW5rcywNCkNhcmwg RnVyc3QNCg0KDQoNCg0KDQpPbiA3LzExLzEyIDE6MzYgUE0sICJGdXJzdCwgQ2FybCIgPENhcmwu RnVyc3RAbWxiLmNvbT4gd3JvdGU6DQoNCj4yLjQuMiAtIFRoYW5rcyBmb3IgdGhlIHJlZmVyZW5j ZXMuLiBJJ2xsIGNoZWNrIG91dCBUaWthIGFuZCB0cnkgYSB0ZXN0Lg0KPg0KPlRoYW5rcywNCj5D YXJsIEZ1cnN0DQo+DQo+DQo+DQo+DQo+DQo+T24gNy8zLzEyIDU6MTkgQU0sICJBbGV4IFBhcnZ1 bGVzY3UiIDxhbGV4LnBhcnZ1bGVzY3VAZ21haWwuY29tPiB3cm90ZToNCj4NCj4+SGkgQ2FybCwN Cj4+DQo+PldoYXQgdmVyc2lvbiBvZiBqYWNrcmFiYml0IGFyZSB5b3Ugb24/DQo+Pg0KPj5OZXh0 LCBhcmUgeW91IHN1cmUgeW91IGhhdmUgdGhlIHRpa2EgZXh0cmFjdG9ycyBpbiB0aGUgY2xhc3Nw YXRoPyBtYXliZQ0KPj55b3UNCj4+YXJlIHNlZWluZyBzb21ldGhpbmcgYWxvbmcgdGhlIGxpbmVz IG9mIFswXS4NCj4+DQo+Pkkgd291bGQgdHJ5IHRvIGlzb2xhdGUgdGhlIHByb2JsZW0gYnkgdGFr aW5nIHRvbWNhdCBvdXQgb2YgdGhlIHNldHVwLg0KPj5CdWlsZA0KPj5hIHNpbXBsZSB0ZXN0LCBz ZWUgaG93IGl0IHdvcmtzIHRoZW4gZGVwbG95IG9uIHRvbWNhdCBhbmQgdmVyaWZ5Lg0KPj5BIGdv b2QgcGxhY2UgdG8gc3RhcnQgaXMgdGhlIHVuaXQgdGVzdCBjb2xsZWN0aW9uIGF2YWlsYWJsZSBp biBqYWNrcmFiYml0DQo+PmNvcmUgWzFdLg0KPj4NCj4+DQo+PmJlc3QsDQo+PmFsZXgNCj4+DQo+ PlswXSBodHRwczovL2lzc3Vlcy5hcGFjaGUub3JnL2ppcmEvYnJvd3NlL0pDUi0zMjg3DQo+Plsx XQ0KPj5odHRwOi8vc3ZuLmFwYWNoZS5vcmcvdmlld3ZjL2phY2tyYWJiaXQvdHJ1bmsvamFja3Jh YmJpdC1jb3JlL3NyYy90ZXN0L2phDQo+PnYNCj4+YS9vcmcvYXBhY2hlL2phY2tyYWJiaXQvY29y ZS9xdWVyeS9GdWxsdGV4dFNRTDJRdWVyeVRlc3QuamF2YT92aWV3PW1hcmt1cA0KPj4NCj4+DQo+ Pk9uIFdlZCwgSnVuIDI3LCAyMDEyIGF0IDg6MDYgUE0sIEZ1cnN0LCBDYXJsIDxDYXJsLkZ1cnN0 QG1sYi5jb20+IHdyb3RlOg0KPj4NCj4+PiBTbyBnaXZlbiB0aGUgYmVsb3cgSSB0cmllZCB0byB1 c2UNCj4+Pg0KPj4+ICdpbmNsdSonIGFuZCAnaW5jbHVkZSonIGFuZCBzdGlsbCBubyByZXN1bHRz IHNvIEknbSBnb2luZyB0byBzdGFydA0KPj4+bG9va2luZw0KPj4+IGludG8gcGVyaGFwcyBtYXli ZSBzb21lIG9mIHRoZXNlIHJlYXNvbnMgYXMgd2h5Og0KPj4+DQo+Pj4gDQo+Pj5odHRwczovL3dp a2kuYXBhY2hlLm9yZy9sdWNlbmUtamF2YS9MdWNlbmVGQVEjV2h5X2FtX0lfZ2V0dGluZ19ub19o aXRzXy4NCj4+PjINCj4+PkJBDQo+Pj4gQzhfaW5jb3JyZWN0X2hpdHMuM0YNCj4+Pg0KPj4+IE9m IGNvdXJzZSBpdCBjb3VsZCBqdXN0IGJlIHRoYXQgdGhlIHBhcnNlciBpcyBub3QgcGFyc2luZyB0 aGUgJyonLg0KPj4+DQo+Pj4gVGhhbmtzIGFnYWluLA0KPj4+DQo+Pj4NCj4+Pg0KPj4+IENhcmwg RnVyc3QNCj4+Pg0KPj4+DQo+Pj4NCj4+Pg0KPj4+DQo+Pj4gT24gNi8yNy8xMiAxOjU5IFBNLCAi RnVyc3QsIENhcmwiIDxDYXJsLkZ1cnN0QG1sYi5jb20+IHdyb3RlOg0KPj4+DQo+Pj4gPlRoYW5r cyBUb3JzdGVuLA0KPj4+ID4NCj4+PiA+U28gZXZlbiB1c2luZyBKUU9NIHdvdWxkIG5vdCBoZWxw IGhlcmUuIEknbGwgcmVhZCB1cCBtb3JlIG9uIGx1Y2luZQ0KPj4+YW5kDQo+Pj4gPmZpbmQgb3V0 IG1vcmUuIE15IG1haW4gc3R1bWJsaW5nIGJsb2NrIGhlcmUgd2FzIHdoZXJlIHRoZSBxdWVyeSB3 YXMNCj4+PmJlaW5nDQo+Pj4gPmV4ZWN1dGVkLiBXYXMgaXQgb24gdGhlIERlcmJ5IGxldmVsIG9y IHRoZSBMdWNpbmUgbGV2ZWwuLg0KPj4+ID4NCj4+PiA+VGhpcyBoYXMgY2xlYXJlZCB0aGF0IHBh cnQgb2YgaXQgdXAgZm9yIG1lIGFzIHdlbGwuDQo+Pj4gPg0KPj4+ID5UaGFua3MgYWdhaW4sDQo+ Pj4gPg0KPj4+ID5DYXJsIEZ1cnN0DQo+Pj4gPg0KPj4+ID4NCj4+PiA+DQo+Pj4gPg0KPj4+ID4N Cj4+PiA+DQo+Pj4gPk9uIDYvMjcvMTIgMTo1MCBQTSwgIlRvcnN0ZW4gU3RvbHBtYW5uIiA8c3Rv bHBtYW5uQHZlcml0LmRlPiB3cm90ZToNCj4+PiA+DQo+Pj4gPj5IaSBDYXJsLA0KPj4+ID4+DQo+ Pj4gPj5wZXIgZGVmYXVsdCB0aGUgdW5kZXJseWluZyBMdWNlbmUgaW1wbGVtZW50YXRpb24gZG9l cyBub3QgbWF0Y2gNCj4+PmxlYWRpbmcNCj4+PiA+PndpbGRjYXJkcyBmb3IgcGVyZm9ybWFuY2Ug cmVhc29ucy4gU2VlIGFsc286DQo+Pj4gPj4NCj4+PiANCj4+Pmh0dHBzOi8vd2lraS5hcGFjaGUu b3JnL2x1Y2VuZS1qYXZhL0x1Y2VuZUZBUSNXaGF0X3dpbGRjYXJkX3NlYXJjaF9zdXBwbw0KPj4+ cg0KPj4+ID4+dA0KPj4+ID4+X2lzX2F2YWlsYWJsZV9mcm9tX0x1Y2VuZS4zRg0KPj4+ID4+DQo+ Pj4gPj5TbyBqdXN0IG1hdGNoaW5nICcqJyB3aWxsIG5vdCB3b3JrLCBidXQgZWcuICdpKicgbWln aHQgZ2l2ZSB5b3UgdGhlDQo+Pj4gPj5yZXN1bHRzIHlvdSB3ZXJlIGxvb2tpbmcgZm9yLg0KPj4+ ID4+DQo+Pj4gPj5TYWRseSBlbm91Z2ggSSBkaWQgbm90IGZpbmQgYW55IHJlZmVyZW5jZSB0byB0 aGlzIGluIHRoZSBKYWNrUmFiYml0DQo+Pj4gPj5kb2N1bWVudGF0aW9uLg0KPj4+ID4+DQo+Pj4g Pj5Ub29rIG1lIHF1aXRlIGEgd2hpbGUgdG8gZmluZCB0aGF0IHRvby4NCj4+PiA+Pg0KPj4+ID4+ SG9wZSB0aGlzIGhlbHBzLA0KPj4+ID4+DQo+Pj4gPj5Ub3JzdGVuDQo+Pj4gPj4NCj4+PiA+Pk9u IDI3LjA2LjIwMTIgMTc6MTksIEZ1cnN0LCBDYXJsIHdyb3RlOg0KPj4+ID4+PiBJJ20gcHJvYmFi bHkgbWlzc2luZyBzb21ldGhpbmcgaGVyZSBidXQgZXZlcnl0aGluZyBJJ3ZlIHJlYWQgc28gZmFy DQo+Pj4gPj4+bGVhZHMNCj4+PiA+Pj4gbWUgdG8gYmVsaWV2ZSB0aGlzIHNob3VsZCB3b3JrLi4N Cj4+PiA+Pj4NCj4+PiA+Pj4gSSBoYXZlIG5vZGVzIGluIGEgcmVwb3NpdG95IG9mIHR5cGUgbnQ6 Zm9sZGVyIGFuZCBudDpmaWxlLiBudDpmaWxlDQo+Pj5oYXMNCj4+PiA+Pj5hDQo+Pj4gPj4+IGNo aWxkIG5vZGUgamNyOmNvbnRlbnQgb2YgdHlwZSBudDpyZXNvdXJjZSB3aGljaCBoYXMgYSBjaGls ZA0KPj4+cHJvcGVydHkNCj4+PiA+Pj4gY2FsbGVkIGpjcjpkYXRhDQo+Pj4gPj4+DQo+Pj4gPj4+ IFRoZXJlIGFyZSBtYW55IGNhc2VzIHdoZXJlIHRoZSBqY3I6ZGF0YSBjb2x1bW4gaGFzIHRoZSB3 b3JsZA0KPj4+J2luY2x1ZGUnDQo+Pj4gPj4+aW4NCj4+PiA+Pj4gaXQuIFRoZXkgYXJlIGpzcCBm aWxlcyBzbywgeWVzLCBJIGtub3cgdGhpcyB3b3JkIGV4aXN0cyBpbiBzZXZlcmFsDQo+Pj4gPj4+ ZmlsZXMuDQo+Pj4gPj4+DQo+Pj4gPj4+IFNvIGhlcmUncyB0aGUgc3FsIEkgdXNlOg0KPj4+ID4+ Pg0KPj4+ID4+PiBzZWxlY3QgKiBmcm9tIFtudDpyZXNvdXJjZV0gd2hlcmUgIGNvbnRhaW5zKFtq Y3I6ZGF0YV0sICdpbmNsdWRlJyk7DQo+Pj4gPj4+DQo+Pj4gPj4+IEhlcmUncyB0aGUgc3FsIHRo YXQgaXMgcmV0dXJuZWQgZnJvbSBxLmdldFN0YXRlbWVudCgpIDoNCj4+PiA+Pj4NCj4+PiA+Pj4g U0VMRUNUIFtudDpyZXNvdXJjZV0uKiBGUk9NIFtudDpyZXNvdXJjZV0gV0hFUkUNCj4+PiA+Pj4g Q09OVEFJTlMoW250OnJlc291cmNlXS5bamNyOmRhdGFdLCAnaW5jbHVkZScpOw0KPj4+ID4+Pg0K Pj4+ID4+PiBIZXJlIGlzIGEgc2FtcGxlIHRleHQgaW4gamNyOmRhdGEgdG8gc2VhcmNoIG9uLg0K Pj4+ID4+Pg0KPj4+ID4+PiA8JUAgaW5jbHVkZSBmaWxlPSIuLi4iDQo+Pj4gPj4+DQo+Pj4gPj4+ DQo+Pj4gPj4+IC4uLiBNb3JlIGpzcCBoZXJlLi4NCj4+PiA+Pj4gPCUvanNwOmluY2x1ZGUuLi4N Cj4+PiA+Pj4NCj4+PiA+Pj4gWWV0IGl0IGRvZXNuqfZ0IGZpbmQgaXQuIEkgZmVlbCBJJ20gbWlz c2luZyBzb21ldGhpbmcuLiBEbyBJIG5lZWQgdG8NCj4+PmFkZA0KPj4+ID4+PmENCj4+PiA+Pj4g InNlYXJjaGFibGUiIG1peGluIG9yIHNvbWV0aGluZz8NCj4+PiA+Pj4NCj4+PiA+Pj4gQW55IGlk ZWFzIHdoeSB0aGlzIGlzIG5vdCBiZWluZyBmb3VuZD8NCj4+PiA+Pj4NCj4+PiA+Pj4gSXQgdXNl ZCB0byBiZSB0aGF0IGFwYWNoZSBoYWQgdGhlIGNkbiBmaWxlIGZvciBqYWNrcmFiYml0IG5vZGUN Cj4+PnR5cGVzDQo+Pj4gPj4+d2FzDQo+Pj4gPj4+IHJlYWRpbHkgYXZhaWxhYmxlLiBEb2VzIGFu eW9uZSBrbm93IHdoZXJlIEkgY2FuIGZpbmQgdGhlIGNkbiBmaWxlDQo+Pj5mb3INCj4+PiA+Pj4g amFja3JhYmJpdCBub2RlIHR5cGVzPw0KPj4+ID4+Pg0KPj4+ID4+PiBqY3I6Y29udGVudCBpcyB1 bnN0cnVjdHVyZWQsIGJ1dCBJIGV4cGxpY2l0bHkgbWFrZSB0aGUgdHlwZQ0KPj4+bnQ6cmVzb3Vy Y2UNCj4+PiA+Pj4gKG90aGVyd2lzZSB0aGUgc3RhdGVtZW50IHdvdWxkIHdvdWxkIG5vdCBiZSBw YXJzZWQsIFF1ZXJ5IG9iamVjdA0KPj4+d291bGQNCj4+PiA+Pj4gdGhyb3cgYW4gZXJyb3IsIGxp a2UgInRhYmxlIG5vdCBmb3VuZCwiIHJpZ2h0PyBCZWNhdXNlIHRoZSB0eXBlIGlzDQo+Pj5hDQo+ Pj4gPj4+IHRhYmxlKS4gU28gdGhlIHR5cGUgaXMgcmlnaHQuLiBUaGUgZmllbGQgaXMgcmlnaHQu LiBUaGUgc2VhcmNoIGlzDQo+Pj5ub3QNCj4+PiA+Pj4gd29ya2luZy4NCj4+PiA+Pj4NCj4+PiA+ Pj4NCj4+PiA+Pj4gSSdtIHVzaW5nIEphY2tyYWJiaXQgd2l0aG91dCBhbnkgc3BlY2lhbCBjb25m aWd1cmF0aW9uLiBKdXN0IHRoZQ0KPj4+d2FyIGluDQo+Pj4gPj4+YQ0KPj4+ID4+PiBzaW1wbGUg dG9tY2F0IGRlcGxveW1lbnQuIFNvIGl0J3Mgc2l0dGluZyBvbiB0b3Agb2YgRGVyYnkgYW5kDQo+ Pj5MdWNpbmUuDQo+Pj4gPj4+DQo+Pj4gPj4+DQo+Pj4gPj4+IEFueSBoZWxwIHdvdWxkIGJlIGFw cHJlY2lhdGVkLg0KPj4+ID4+Pg0KPj4+ID4+PiBUaGFua3MsDQo+Pj4gPj4+DQo+Pj4gPj4+IENh cmwgRnVyc3QNCj4+PiA+Pj4NCj4+PiA+Pj4NCj4+PiA+Pj4NCj4+PiA+Pj4NCj4+PiA+Pj4NCj4+ PiA+Pj4NCj4+PiA+Pj4NCj4+PiA+Pj4gKioqKioqKioqKioqKioqKioqKioqKioqKioqKioqKioq KioqKioqKioqKioqKioqKioqKioqKioqKg0KPj4+ID4+Pg0KPj4+ID4+PiBNTEIuY29tOiBXaGVy ZSBCYXNlYmFsbCBpcyBBbHdheXMgT24NCj4+PiA+Pj4NCj4+PiA+Pg0KPj4+ID4NCj4+PiA+DQo+ Pj4gPg0KPj4+ID4NCj4+PiA+DQo+Pj4gPg0KPj4+ID4qKioqKioqKioqKioqKioqKioqKioqKioq KioqKioqKioqKioqKioqKioqKioqKioqKioqKioqKioqDQo+Pj4gPg0KPj4+ID5NTEIuY29tOiBX aGVyZSBCYXNlYmFsbCBpcyBBbHdheXMgT24NCj4+Pg0KPj4+DQo+Pj4NCj4+Pg0KPj4+DQo+Pj4N Cj4+PiAqKioqKioqKioqKioqKioqKioqKioqKioqKioqKioqKioqKioqKioqKioqKioqKioqKioq KioqKioqDQo+Pj4NCj4+PiBNTEIuY29tOiBXaGVyZSBCYXNlYmFsbCBpcyBBbHdheXMgT24NCj4+ Pg0KPg0KPg0KPg0KPg0KPg0KPg0KPioqKioqKioqKioqKioqKioqKioqKioqKioqKioqKioqKioq KioqKioqKioqKioqKioqKioqKioqKioNCj4NCj5NTEIuY29tOiBXaGVyZSBCYXNlYmFsbCBpcyBB bHdheXMgT24NCg0KCgoKCgoqKioqKioqKioqKioqKioqKioqKioqKioqKioqKioqKioqKioqKioq KioqKioqKioqKioqKioqKioqCgpNTEIuY29tOiBXaGVyZSBCYXNlYmFsbCBpcyBBbHdheXMgT24K