From: Remco de B. <rem...@gm...> - 2013-10-28 08:54:28
|
Hi Justin, Are you aware that the like comparator is not supposed to work with properties of type Text? From the SMW documentation<http://semantic-mediawiki.org/wiki/Help:Selecting_pages#Like.2C_not_like>: "The comparators ~ and !~ work only for properties of datatype String<http://semantic-mediawiki.org/wiki/Help:Type_String> and Page <http://semantic-mediawiki.org/wiki/Help:Type_Page>." Regards, Remco On Sun, Oct 27, 2013 at 4:49 AM, Justin M <d3...@sa...> wrote: > Not sure if there is a better way to do this, or if it's just a bug I could > use some help with. > > > > I'm trying to do a simple ask query like this: > > > > {{#ask: [[TextProperty::~*Some text*]] > > | ?Something > > | format=table > > }} > > > > My TextProperty goes over the 72 character length listed in > SMW_DIHandler_String.php, so the end of the text gets changed in o_hash, > and > the full text is registered in o_blob. The Problem I'm having, is #ask > only > seems to be matching on text in the o_hash column. If I change the 72 > character limit to something like 200 characters, the ask function matches > just fine. I figure there's probably a better solution or fix than that > though? If not, then would it hurt performance changing it to a > varchar(400) with 400 character limit on o_hash, or is it just a disk space > thing? I'm about to import 14 million pages, and I'm worried about > performance as is, let alone making it worse. > > > > Thanks! > > > ------------------------------------------------------------------------------ > October Webinars: Code for Performance > Free Intel webinars can help you accelerate application performance. > Explore tips for MPI, OpenMP, advanced profiling, and more. Get the most > from > the latest Intel processors and coprocessors. See abstracts and register > > http://pubads.g.doubleclick.net/gampad/clk?id=60135991&iu=/4140/ostg.clktrk > _______________________________________________ > Semediawiki-user mailing list > Sem...@li... > https://lists.sourceforge.net/lists/listinfo/semediawiki-user > |