chemistry-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From build...@apache.org
Subject svn commit: r811235 [16/42] - in /websites/staging/chemistry/trunk/content: ./ java/0.7.0/maven/chemistry-opencmis-server/chemistry-opencmis-server-inmemory/ java/0.7.0/maven/chemistry-opencmis-server/chemistry-opencmis-server-inmemory/css/ java/0.7.0/...
Date Tue, 03 Apr 2012 05:16:00 GMT
Added: websites/staging/chemistry/trunk/content/java/0.7.0/maven/chemistry-opencmis-server/chemistry-opencmis-server-inmemory/xref-test/org/apache/chemistry/opencmis/inmemory/query/EvalQueryTest.html
==============================================================================
--- websites/staging/chemistry/trunk/content/java/0.7.0/maven/chemistry-opencmis-server/chemistry-opencmis-server-inmemory/xref-test/org/apache/chemistry/opencmis/inmemory/query/EvalQueryTest.html (added)
+++ websites/staging/chemistry/trunk/content/java/0.7.0/maven/chemistry-opencmis-server/chemistry-opencmis-server-inmemory/xref-test/org/apache/chemistry/opencmis/inmemory/query/EvalQueryTest.html Tue Apr  3 05:15:55 2012
@@ -0,0 +1,882 @@
+<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
+<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
+<head>
+<meta http-equiv="content-type" content="text/html; charset=ISO-8859-1" />
+<title>EvalQueryTest xref</title>
+<link type="text/css" rel="stylesheet" href="../../../../../../stylesheet.css" />
+</head>
+<body>
+<pre>
+
+<a name="1" href="#1">1</a>   <em class="jxr_comment">/*</em>
+<a name="2" href="#2">2</a>   <em class="jxr_comment"> * Licensed to the Apache Software Foundation (ASF) under one</em>
+<a name="3" href="#3">3</a>   <em class="jxr_comment"> * or more contributor license agreements.  See the NOTICE file</em>
+<a name="4" href="#4">4</a>   <em class="jxr_comment"> * distributed with this work for additional information</em>
+<a name="5" href="#5">5</a>   <em class="jxr_comment"> * regarding copyright ownership.  The ASF licenses this file</em>
+<a name="6" href="#6">6</a>   <em class="jxr_comment"> * to you under the Apache License, Version 2.0 (the</em>
+<a name="7" href="#7">7</a>   <em class="jxr_comment"> * "License"); you may not use this file except in compliance</em>
+<a name="8" href="#8">8</a>   <em class="jxr_comment"> * with the License.  You may obtain a copy of the License at</em>
+<a name="9" href="#9">9</a>   <em class="jxr_comment"> *</em>
+<a name="10" href="#10">10</a>  <em class="jxr_comment"> * <a href="http://www.apache.org/licenses/LICENSE-2.0" target="alexandria_uri">http://www.apache.org/licenses/LICENSE-2.0</a></em>
+<a name="11" href="#11">11</a>  <em class="jxr_comment"> *</em>
+<a name="12" href="#12">12</a>  <em class="jxr_comment"> * Unless required by applicable law or agreed to in writing,</em>
+<a name="13" href="#13">13</a>  <em class="jxr_comment"> * software distributed under the License is distributed on an</em>
+<a name="14" href="#14">14</a>  <em class="jxr_comment"> * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY</em>
+<a name="15" href="#15">15</a>  <em class="jxr_comment"> * KIND, either express or implied.  See the License for the</em>
+<a name="16" href="#16">16</a>  <em class="jxr_comment"> * specific language governing permissions and limitations</em>
+<a name="17" href="#17">17</a>  <em class="jxr_comment"> * under the License.</em>
+<a name="18" href="#18">18</a>  <em class="jxr_comment"> */</em>
+<a name="19" href="#19">19</a>  <strong class="jxr_keyword">package</strong> org.apache.chemistry.opencmis.inmemory.query;
+<a name="20" href="#20">20</a>  
+<a name="21" href="#21">21</a>  <strong class="jxr_keyword">import</strong> <strong class="jxr_keyword">static</strong> org.apache.chemistry.opencmis.inmemory.UnitTestTypeSystemCreator.COMPLEX_TYPE;
+<a name="22" href="#22">22</a>  <strong class="jxr_keyword">import</strong> <strong class="jxr_keyword">static</strong> org.apache.chemistry.opencmis.inmemory.UnitTestTypeSystemCreator.PROP_ID_BOOLEAN;
+<a name="23" href="#23">23</a>  <strong class="jxr_keyword">import</strong> <strong class="jxr_keyword">static</strong> org.apache.chemistry.opencmis.inmemory.UnitTestTypeSystemCreator.PROP_ID_DATETIME;
+<a name="24" href="#24">24</a>  <strong class="jxr_keyword">import</strong> <strong class="jxr_keyword">static</strong> org.apache.chemistry.opencmis.inmemory.UnitTestTypeSystemCreator.PROP_ID_DECIMAL;
+<a name="25" href="#25">25</a>  <strong class="jxr_keyword">import</strong> <strong class="jxr_keyword">static</strong> org.apache.chemistry.opencmis.inmemory.UnitTestTypeSystemCreator.PROP_ID_INT;
+<a name="26" href="#26">26</a>  <strong class="jxr_keyword">import</strong> <strong class="jxr_keyword">static</strong> org.junit.Assert.assertEquals;
+<a name="27" href="#27">27</a>  <strong class="jxr_keyword">import</strong> <strong class="jxr_keyword">static</strong> org.junit.Assert.assertFalse;
+<a name="28" href="#28">28</a>  <strong class="jxr_keyword">import</strong> <strong class="jxr_keyword">static</strong> org.junit.Assert.assertNotNull;
+<a name="29" href="#29">29</a>  <strong class="jxr_keyword">import</strong> <strong class="jxr_keyword">static</strong> org.junit.Assert.assertTrue;
+<a name="30" href="#30">30</a>  <strong class="jxr_keyword">import</strong> <strong class="jxr_keyword">static</strong> org.junit.Assert.fail;
+<a name="31" href="#31">31</a>  
+<a name="32" href="#32">32</a>  <strong class="jxr_keyword">import</strong> org.apache.chemistry.opencmis.commons.PropertyIds;
+<a name="33" href="#33">33</a>  <strong class="jxr_keyword">import</strong> org.apache.chemistry.opencmis.commons.data.ObjectData;
+<a name="34" href="#34">34</a>  <strong class="jxr_keyword">import</strong> org.apache.chemistry.opencmis.commons.data.ObjectList;
+<a name="35" href="#35">35</a>  <strong class="jxr_keyword">import</strong> org.apache.chemistry.opencmis.commons.enums.IncludeRelationships;
+<a name="36" href="#36">36</a>  <strong class="jxr_keyword">import</strong> org.apache.chemistry.opencmis.inmemory.AbstractServiceTest;
+<a name="37" href="#37">37</a>  <strong class="jxr_keyword">import</strong> org.apache.chemistry.opencmis.inmemory.UnitTestTypeSystemCreator;
+<a name="38" href="#38">38</a>  <strong class="jxr_keyword">import</strong> org.apache.commons.logging.Log;
+<a name="39" href="#39">39</a>  <strong class="jxr_keyword">import</strong> org.apache.commons.logging.LogFactory;
+<a name="40" href="#40">40</a>  <strong class="jxr_keyword">import</strong> org.junit.After;
+<a name="41" href="#41">41</a>  <strong class="jxr_keyword">import</strong> org.junit.Before;
+<a name="42" href="#42">42</a>  <strong class="jxr_keyword">import</strong> org.junit.Test;
+<a name="43" href="#43">43</a>  
+<a name="44" href="#44">44</a>  <strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">class</strong> <a href="../../../../../../org/apache/chemistry/opencmis/inmemory/query/EvalQueryTest.html">EvalQueryTest</a> <strong class="jxr_keyword">extends</strong> <a href="../../../../../../org/apache/chemistry/opencmis/inmemory/AbstractServiceTest.html">AbstractServiceTest</a> {
+<a name="45" href="#45">45</a>  
+<a name="46" href="#46">46</a>      <strong class="jxr_keyword">private</strong> <strong class="jxr_keyword">static</strong> <strong class="jxr_keyword">final</strong> Log log = LogFactory.getLog(EvalQueryTest.<strong class="jxr_keyword">class</strong>);
+<a name="47" href="#47">47</a>      <strong class="jxr_keyword">private</strong> <a href="../../../../../../org/apache/chemistry/opencmis/inmemory/query/QueryTestDataCreator.html">QueryTestDataCreator</a> dataCreator;
+<a name="48" href="#48">48</a>  
+<a name="49" href="#49">49</a>      @Override
+<a name="50" href="#50">50</a>      @Before
+<a name="51" href="#51">51</a>      <strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">void</strong> setUp() {
+<a name="52" href="#52">52</a>  
+<a name="53" href="#53">53</a>          <em class="jxr_comment">// initialize query object with type manager</em>
+<a name="54" href="#54">54</a>          <strong class="jxr_keyword">super</strong>.setTypeCreatorClass(UnitTestTypeSystemCreator.<strong class="jxr_keyword">class</strong>.getName());
+<a name="55" href="#55">55</a>          <strong class="jxr_keyword">super</strong>.setUp();
+<a name="56" href="#56">56</a>          <em class="jxr_comment">//create test data</em>
+<a name="57" href="#57">57</a>          dataCreator = <strong class="jxr_keyword">new</strong> <a href="../../../../../../org/apache/chemistry/opencmis/inmemory/query/QueryTestDataCreator.html">QueryTestDataCreator</a>(fRepositoryId, fRootFolderId, fObjSvc, fVerSvc);
+<a name="58" href="#58">58</a>          dataCreator.createBasicTestData();
+<a name="59" href="#59">59</a>      }
+<a name="60" href="#60">60</a>  
+<a name="61" href="#61">61</a>      @Override
+<a name="62" href="#62">62</a>      @After
+<a name="63" href="#63">63</a>      <strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">void</strong> tearDown() {
+<a name="64" href="#64">64</a>          <strong class="jxr_keyword">super</strong>.tearDown();
+<a name="65" href="#65">65</a>      }
+<a name="66" href="#66">66</a>  
+<a name="67" href="#67">67</a>      @Test
+<a name="68" href="#68">68</a>      <strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">void</strong> testAll() {
+<a name="69" href="#69">69</a>          String statement = <span class="jxr_string">"SELECT * FROM cmis:document"</span>;
+<a name="70" href="#70">70</a>          ObjectList res = doQuery(statement);
+<a name="71" href="#71">71</a>          assertEquals(5, res.getObjects().size());
+<a name="72" href="#72">72</a>          assertTrue(resultContains(<span class="jxr_string">"alpha"</span>, res));
+<a name="73" href="#73">73</a>          assertFalse(resultContains(<span class="jxr_string">"jens"</span>, res));
+<a name="74" href="#74">74</a>      }
+<a name="75" href="#75">75</a>  
+<a name="76" href="#76">76</a>      <em class="jxr_comment">//////////////////////////////////////////////////////////////////////</em>
+<a name="77" href="#77">77</a>      <em class="jxr_comment">// Boolean tests</em>
+<a name="78" href="#78">78</a>  
+<a name="79" href="#79">79</a>      @Test
+<a name="80" href="#80">80</a>      <strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">void</strong> testBooleanEquals() {
+<a name="81" href="#81">81</a>          String statement = <span class="jxr_string">"SELECT * FROM "</span> + COMPLEX_TYPE + <span class="jxr_string">" WHERE "</span> + PROP_ID_BOOLEAN + <span class="jxr_string">"= true"</span>;
+<a name="82" href="#82">82</a>          ObjectList res = doQuery(statement);
+<a name="83" href="#83">83</a>          assertEquals(3, res.getObjects().size());
+<a name="84" href="#84">84</a>          assertTrue(resultContains(<span class="jxr_string">"alpha"</span>, res));
+<a name="85" href="#85">85</a>          assertTrue(resultContains(<span class="jxr_string">"gamma"</span>, res));
+<a name="86" href="#86">86</a>          assertTrue(resultContains(<span class="jxr_string">"delta"</span>, res));
+<a name="87" href="#87">87</a>      }
+<a name="88" href="#88">88</a>  
+<a name="89" href="#89">89</a>      @Test
+<a name="90" href="#90">90</a>      <strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">void</strong> testBooleanNotEquals() {
+<a name="91" href="#91">91</a>          String statement = <span class="jxr_string">"SELECT * FROM "</span> + COMPLEX_TYPE + <span class="jxr_string">" WHERE "</span> + PROP_ID_BOOLEAN + <span class="jxr_string">"= false"</span>;
+<a name="92" href="#92">92</a>          ObjectList res = doQuery(statement);
+<a name="93" href="#93">93</a>          assertEquals(2, res.getObjects().size());
+<a name="94" href="#94">94</a>          assertTrue(resultContains(<span class="jxr_string">"beta"</span>, res));
+<a name="95" href="#95">95</a>          assertTrue(resultContains(<span class="jxr_string">"epsilon"</span>, res));
+<a name="96" href="#96">96</a>      }
+<a name="97" href="#97">97</a>  
+<a name="98" href="#98">98</a>      <em class="jxr_comment">//////////////////////////////////////////////////////////////////////</em>
+<a name="99" href="#99">99</a>      <em class="jxr_comment">// Integer tests</em>
+<a name="100" href="#100">100</a> 
+<a name="101" href="#101">101</a>     @Test
+<a name="102" href="#102">102</a>     <strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">void</strong> testIntegerEquals() {
+<a name="103" href="#103">103</a>         String statement = <span class="jxr_string">"SELECT * FROM "</span> + COMPLEX_TYPE + <span class="jxr_string">" WHERE "</span> + PROP_ID_INT + <span class="jxr_string">"= 100"</span>;
+<a name="104" href="#104">104</a>         ObjectList res = doQuery(statement);
+<a name="105" href="#105">105</a>         assertEquals(1, res.getObjects().size());
+<a name="106" href="#106">106</a>         assertTrue(resultContains(<span class="jxr_string">"epsilon"</span>, res));
+<a name="107" href="#107">107</a>     }
+<a name="108" href="#108">108</a> 
+<a name="109" href="#109">109</a>     @Test
+<a name="110" href="#110">110</a>     <strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">void</strong> testIntegerNotEquals() {
+<a name="111" href="#111">111</a>         String statement = <span class="jxr_string">"SELECT * FROM "</span> + COMPLEX_TYPE + <span class="jxr_string">" WHERE "</span> + PROP_ID_INT + <span class="jxr_string">"&lt;&gt; 100"</span>;
+<a name="112" href="#112">112</a>         ObjectList res = doQuery(statement);
+<a name="113" href="#113">113</a>         assertEquals(4, res.getObjects().size());
+<a name="114" href="#114">114</a>         assertTrue(resultContains(<span class="jxr_string">"alpha"</span>, res));
+<a name="115" href="#115">115</a>         assertTrue(resultContains(<span class="jxr_string">"beta"</span>, res));
+<a name="116" href="#116">116</a>         assertTrue(resultContains(<span class="jxr_string">"gamma"</span>, res));
+<a name="117" href="#117">117</a>         assertTrue(resultContains(<span class="jxr_string">"delta"</span>, res));
+<a name="118" href="#118">118</a>     }
+<a name="119" href="#119">119</a> 
+<a name="120" href="#120">120</a>     @Test
+<a name="121" href="#121">121</a>     <strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">void</strong> testIntegerLess() {
+<a name="122" href="#122">122</a>         String statement = <span class="jxr_string">"SELECT * FROM "</span> + COMPLEX_TYPE + <span class="jxr_string">" WHERE "</span> + PROP_ID_INT + <span class="jxr_string">"&lt; 0"</span>;
+<a name="123" href="#123">123</a>         ObjectList res = doQuery(statement);
+<a name="124" href="#124">124</a>         assertEquals(2, res.getObjects().size());
+<a name="125" href="#125">125</a>         assertTrue(resultContains(<span class="jxr_string">"alpha"</span>, res));
+<a name="126" href="#126">126</a>         assertTrue(resultContains(<span class="jxr_string">"beta"</span>, res));
+<a name="127" href="#127">127</a>     }
+<a name="128" href="#128">128</a> 
+<a name="129" href="#129">129</a>     @Test
+<a name="130" href="#130">130</a>     <strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">void</strong> testIntegerLessOrEqual() {
+<a name="131" href="#131">131</a>         String statement = <span class="jxr_string">"SELECT * FROM "</span> + COMPLEX_TYPE + <span class="jxr_string">" WHERE "</span> + PROP_ID_INT + <span class="jxr_string">"&lt;= 0"</span>;
+<a name="132" href="#132">132</a>         ObjectList res = doQuery(statement);
+<a name="133" href="#133">133</a>         assertEquals(3, res.getObjects().size());
+<a name="134" href="#134">134</a>         assertTrue(resultContains(<span class="jxr_string">"alpha"</span>, res));
+<a name="135" href="#135">135</a>         assertTrue(resultContains(<span class="jxr_string">"beta"</span>, res));
+<a name="136" href="#136">136</a>         assertTrue(resultContains(<span class="jxr_string">"gamma"</span>, res));
+<a name="137" href="#137">137</a>     }
+<a name="138" href="#138">138</a> 
+<a name="139" href="#139">139</a>     @Test
+<a name="140" href="#140">140</a>     <strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">void</strong> testIntegerGreater() {
+<a name="141" href="#141">141</a>         String statement = <span class="jxr_string">"SELECT * FROM "</span> + COMPLEX_TYPE + <span class="jxr_string">" WHERE "</span> + PROP_ID_INT + <span class="jxr_string">"&gt; 0"</span>;
+<a name="142" href="#142">142</a>         ObjectList res = doQuery(statement);
+<a name="143" href="#143">143</a>         assertEquals(2, res.getObjects().size());
+<a name="144" href="#144">144</a>         assertTrue(resultContains(<span class="jxr_string">"delta"</span>, res));
+<a name="145" href="#145">145</a>         assertTrue(resultContains(<span class="jxr_string">"epsilon"</span>, res));
+<a name="146" href="#146">146</a>     }
+<a name="147" href="#147">147</a> 
+<a name="148" href="#148">148</a>     @Test
+<a name="149" href="#149">149</a>     <strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">void</strong> testIntegerGreaterOrEqual() {
+<a name="150" href="#150">150</a>         String statement = <span class="jxr_string">"SELECT * FROM "</span> + COMPLEX_TYPE + <span class="jxr_string">" WHERE "</span> + PROP_ID_INT + <span class="jxr_string">"&gt;= 0"</span>;
+<a name="151" href="#151">151</a>         ObjectList res = doQuery(statement);
+<a name="152" href="#152">152</a>         assertEquals(3, res.getObjects().size());
+<a name="153" href="#153">153</a>         assertTrue(resultContains(<span class="jxr_string">"gamma"</span>, res));
+<a name="154" href="#154">154</a>         assertTrue(resultContains(<span class="jxr_string">"delta"</span>, res));
+<a name="155" href="#155">155</a>         assertTrue(resultContains(<span class="jxr_string">"epsilon"</span>, res));
+<a name="156" href="#156">156</a>     }
+<a name="157" href="#157">157</a> 
+<a name="158" href="#158">158</a>     <em class="jxr_comment">//////////////////////////////////////////////////////////////////////</em>
+<a name="159" href="#159">159</a>     <em class="jxr_comment">// Decimal tests</em>
+<a name="160" href="#160">160</a> 
+<a name="161" href="#161">161</a>     @Test
+<a name="162" href="#162">162</a>     <strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">void</strong> testDecimalEquals() {
+<a name="163" href="#163">163</a>         String statement = <span class="jxr_string">"SELECT * FROM "</span> + COMPLEX_TYPE + <span class="jxr_string">" WHERE "</span> + PROP_ID_DECIMAL + <span class="jxr_string">"= 1.23456E-6"</span>;
+<a name="164" href="#164">164</a>         ObjectList res = doQuery(statement);
+<a name="165" href="#165">165</a>         assertEquals(1, res.getObjects().size());
+<a name="166" href="#166">166</a>         assertTrue(resultContains(<span class="jxr_string">"delta"</span>, res));
+<a name="167" href="#167">167</a>     }
+<a name="168" href="#168">168</a> 
+<a name="169" href="#169">169</a>     @Test
+<a name="170" href="#170">170</a>     <strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">void</strong> testDecimalNotEquals() {
+<a name="171" href="#171">171</a>         String statement = <span class="jxr_string">"SELECT * FROM "</span> + COMPLEX_TYPE + <span class="jxr_string">" WHERE "</span> + PROP_ID_DECIMAL + <span class="jxr_string">"&lt;&gt; 1.23456E-6"</span>;
+<a name="172" href="#172">172</a>         ObjectList res = doQuery(statement);
+<a name="173" href="#173">173</a>         assertEquals(4, res.getObjects().size());
+<a name="174" href="#174">174</a>         assertTrue(resultContains(<span class="jxr_string">"alpha"</span>, res));
+<a name="175" href="#175">175</a>         assertTrue(resultContains(<span class="jxr_string">"beta"</span>, res));
+<a name="176" href="#176">176</a>         assertTrue(resultContains(<span class="jxr_string">"gamma"</span>, res));
+<a name="177" href="#177">177</a>         assertTrue(resultContains(<span class="jxr_string">"epsilon"</span>, res));
+<a name="178" href="#178">178</a>     }
+<a name="179" href="#179">179</a> 
+<a name="180" href="#180">180</a>     @Test
+<a name="181" href="#181">181</a>     <strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">void</strong> testDecimalLess() {
+<a name="182" href="#182">182</a>         String statement = <span class="jxr_string">"SELECT * FROM "</span> + COMPLEX_TYPE + <span class="jxr_string">" WHERE "</span> + PROP_ID_DECIMAL + <span class="jxr_string">"&lt; 1.23456E-6"</span>;
+<a name="183" href="#183">183</a>         ObjectList res = doQuery(statement);
+<a name="184" href="#184">184</a>         assertEquals(2, res.getObjects().size());
+<a name="185" href="#185">185</a>         assertTrue(resultContains(<span class="jxr_string">"alpha"</span>, res));
+<a name="186" href="#186">186</a>         assertTrue(resultContains(<span class="jxr_string">"beta"</span>, res));
+<a name="187" href="#187">187</a>     }
+<a name="188" href="#188">188</a> 
+<a name="189" href="#189">189</a>     @Test
+<a name="190" href="#190">190</a>     <strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">void</strong> testDecimalLessOrEqual() {
+<a name="191" href="#191">191</a>         String statement = <span class="jxr_string">"SELECT * FROM "</span> + COMPLEX_TYPE + <span class="jxr_string">" WHERE "</span> + PROP_ID_DECIMAL + <span class="jxr_string">"&lt;= 1.23456E-6"</span>;
+<a name="192" href="#192">192</a>         ObjectList res = doQuery(statement);
+<a name="193" href="#193">193</a>         assertEquals(3, res.getObjects().size());
+<a name="194" href="#194">194</a>         assertTrue(resultContains(<span class="jxr_string">"alpha"</span>, res));
+<a name="195" href="#195">195</a>         assertTrue(resultContains(<span class="jxr_string">"beta"</span>, res));
+<a name="196" href="#196">196</a>         assertTrue(resultContains(<span class="jxr_string">"delta"</span>, res));
+<a name="197" href="#197">197</a>     }
+<a name="198" href="#198">198</a> 
+<a name="199" href="#199">199</a>     @Test
+<a name="200" href="#200">200</a>     <strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">void</strong> testDecimalGreater() {
+<a name="201" href="#201">201</a>         String statement = <span class="jxr_string">"SELECT * FROM "</span> + COMPLEX_TYPE + <span class="jxr_string">" WHERE "</span> + PROP_ID_DECIMAL + <span class="jxr_string">"&gt; 1.23456E-6"</span>;
+<a name="202" href="#202">202</a>         ObjectList res = doQuery(statement);
+<a name="203" href="#203">203</a>         assertEquals(2, res.getObjects().size());
+<a name="204" href="#204">204</a>         assertTrue(resultContains(<span class="jxr_string">"gamma"</span>, res));
+<a name="205" href="#205">205</a>         assertTrue(resultContains(<span class="jxr_string">"epsilon"</span>, res));
+<a name="206" href="#206">206</a>     }
+<a name="207" href="#207">207</a> 
+<a name="208" href="#208">208</a>     @Test
+<a name="209" href="#209">209</a>     <strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">void</strong> testDecimalGreaterOrEqual() {
+<a name="210" href="#210">210</a>         String statement = <span class="jxr_string">"SELECT * FROM "</span> + COMPLEX_TYPE + <span class="jxr_string">" WHERE "</span> + PROP_ID_DECIMAL + <span class="jxr_string">"&gt;= 1.23456E-6"</span>;
+<a name="211" href="#211">211</a>         ObjectList res = doQuery(statement);
+<a name="212" href="#212">212</a>         assertEquals(3, res.getObjects().size());
+<a name="213" href="#213">213</a>         assertTrue(resultContains(<span class="jxr_string">"gamma"</span>, res));
+<a name="214" href="#214">214</a>         assertTrue(resultContains(<span class="jxr_string">"delta"</span>, res));
+<a name="215" href="#215">215</a>         assertTrue(resultContains(<span class="jxr_string">"epsilon"</span>, res));
+<a name="216" href="#216">216</a>     }
+<a name="217" href="#217">217</a> 
+<a name="218" href="#218">218</a>     <em class="jxr_comment">//////////////////////////////////////////////////////////////////////</em>
+<a name="219" href="#219">219</a>     <em class="jxr_comment">// DateTime tests</em>
+<a name="220" href="#220">220</a> 
+<a name="221" href="#221">221</a>     @Test
+<a name="222" href="#222">222</a>     <strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">void</strong> testDateEquals() {
+<a name="223" href="#223">223</a>         String statement = <span class="jxr_string">"SELECT * FROM "</span> + COMPLEX_TYPE + <span class="jxr_string">" WHERE "</span> + PROP_ID_DATETIME + <span class="jxr_string">"= TIMESTAMP '2038-01-20T00:00:00.000Z'"</span>;
+<a name="224" href="#224">224</a>         ObjectList res = doQuery(statement);
+<a name="225" href="#225">225</a>         assertEquals(1, res.getObjects().size());
+<a name="226" href="#226">226</a>         assertTrue(resultContains(<span class="jxr_string">"delta"</span>, res));
+<a name="227" href="#227">227</a>     }
+<a name="228" href="#228">228</a> 
+<a name="229" href="#229">229</a>     @Test
+<a name="230" href="#230">230</a>     <strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">void</strong> testDateNotEquals() {
+<a name="231" href="#231">231</a>         String statement = <span class="jxr_string">"SELECT * FROM "</span> + COMPLEX_TYPE + <span class="jxr_string">" WHERE "</span> + PROP_ID_DATETIME + <span class="jxr_string">"&lt;&gt; TIMESTAMP '2038-01-20T00:00:00.000Z'"</span>;
+<a name="232" href="#232">232</a>         ObjectList res = doQuery(statement);
+<a name="233" href="#233">233</a>         assertEquals(4, res.getObjects().size());
+<a name="234" href="#234">234</a>         assertTrue(resultContains(<span class="jxr_string">"alpha"</span>, res));
+<a name="235" href="#235">235</a>         assertTrue(resultContains(<span class="jxr_string">"beta"</span>, res));
+<a name="236" href="#236">236</a>         assertTrue(resultContains(<span class="jxr_string">"gamma"</span>, res));
+<a name="237" href="#237">237</a>         assertTrue(resultContains(<span class="jxr_string">"epsilon"</span>, res));
+<a name="238" href="#238">238</a>     }
+<a name="239" href="#239">239</a> 
+<a name="240" href="#240">240</a>     @Test
+<a name="241" href="#241">241</a>     <strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">void</strong> testDateLess() {
+<a name="242" href="#242">242</a>         String statement = <span class="jxr_string">"SELECT * FROM "</span> + COMPLEX_TYPE + <span class="jxr_string">" WHERE "</span> + PROP_ID_DATETIME + <span class="jxr_string">"&lt; TIMESTAMP '2038-01-20T00:00:00.000Z'"</span>;
+<a name="243" href="#243">243</a>         ObjectList res = doQuery(statement);
+<a name="244" href="#244">244</a>         assertEquals(3, res.getObjects().size());
+<a name="245" href="#245">245</a>         assertTrue(resultContains(<span class="jxr_string">"alpha"</span>, res));
+<a name="246" href="#246">246</a>         assertTrue(resultContains(<span class="jxr_string">"beta"</span>, res));
+<a name="247" href="#247">247</a>         assertTrue(resultContains(<span class="jxr_string">"gamma"</span>, res));
+<a name="248" href="#248">248</a>     }
+<a name="249" href="#249">249</a> 
+<a name="250" href="#250">250</a>     @Test
+<a name="251" href="#251">251</a>     <strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">void</strong> testDateLessOrEquals() {
+<a name="252" href="#252">252</a>         String statement = <span class="jxr_string">"SELECT * FROM "</span> + COMPLEX_TYPE + <span class="jxr_string">" WHERE "</span> + PROP_ID_DATETIME + <span class="jxr_string">"&lt;= TIMESTAMP '2038-01-20T00:00:00.000Z'"</span>;
+<a name="253" href="#253">253</a>         ObjectList res = doQuery(statement);
+<a name="254" href="#254">254</a>         assertEquals(4, res.getObjects().size());
+<a name="255" href="#255">255</a>         assertTrue(resultContains(<span class="jxr_string">"alpha"</span>, res));
+<a name="256" href="#256">256</a>         assertTrue(resultContains(<span class="jxr_string">"beta"</span>, res));
+<a name="257" href="#257">257</a>         assertTrue(resultContains(<span class="jxr_string">"gamma"</span>, res));
+<a name="258" href="#258">258</a>         assertTrue(resultContains(<span class="jxr_string">"delta"</span>, res));
+<a name="259" href="#259">259</a>     }
+<a name="260" href="#260">260</a> 
+<a name="261" href="#261">261</a>     @Test
+<a name="262" href="#262">262</a>     <strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">void</strong> testDategreater() {
+<a name="263" href="#263">263</a>         String statement = <span class="jxr_string">"SELECT * FROM "</span> + COMPLEX_TYPE + <span class="jxr_string">" WHERE "</span> + PROP_ID_DATETIME + <span class="jxr_string">"&gt; TIMESTAMP '2038-01-20T00:00:00.000Z'"</span>;
+<a name="264" href="#264">264</a>         ObjectList res = doQuery(statement);
+<a name="265" href="#265">265</a>         assertEquals(1, res.getObjects().size());
+<a name="266" href="#266">266</a>         assertTrue(resultContains(<span class="jxr_string">"epsilon"</span>, res));
+<a name="267" href="#267">267</a>     }
+<a name="268" href="#268">268</a> 
+<a name="269" href="#269">269</a>     <em class="jxr_comment">//    @Test</em>
+<a name="270" href="#270">270</a>     <strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">void</strong> testDateGreaterOrEqual() {
+<a name="271" href="#271">271</a>         String statement = <span class="jxr_string">"SELECT * FROM "</span> + COMPLEX_TYPE + <span class="jxr_string">" WHERE "</span> + PROP_ID_DATETIME + <span class="jxr_string">"&gt;= TIMESTAMP '2038-01-20T00:00:00.000Z'"</span>;
+<a name="272" href="#272">272</a>         ObjectList res = doQuery(statement);
+<a name="273" href="#273">273</a>         assertEquals(2, res.getObjects().size());
+<a name="274" href="#274">274</a>         assertTrue(resultContains(<span class="jxr_string">"delta"</span>, res));
+<a name="275" href="#275">275</a>         assertTrue(resultContains(<span class="jxr_string">"epsilon"</span>, res));
+<a name="276" href="#276">276</a>     }
+<a name="277" href="#277">277</a> 
+<a name="278" href="#278">278</a>     <em class="jxr_comment">////////////////////////////////////////////////////////////////////</em>
+<a name="279" href="#279">279</a>     <em class="jxr_comment">// String tests</em>
+<a name="280" href="#280">280</a> 
+<a name="281" href="#281">281</a>     @Test
+<a name="282" href="#282">282</a>     <strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">void</strong> testStringEquals() {
+<a name="283" href="#283">283</a>         String statement = <span class="jxr_string">"SELECT * FROM "</span> + COMPLEX_TYPE + <span class="jxr_string">" WHERE "</span> + UnitTestTypeSystemCreator.PROP_ID_STRING + <span class="jxr_string">"= 'Alpha'"</span>;
+<a name="284" href="#284">284</a>         ObjectList res = doQuery(statement);
+<a name="285" href="#285">285</a>         assertEquals(1, res.getObjects().size());
+<a name="286" href="#286">286</a>         assertTrue(resultContains(<span class="jxr_string">"alpha"</span>, res));
+<a name="287" href="#287">287</a>     }
+<a name="288" href="#288">288</a> 
+<a name="289" href="#289">289</a>     @Test
+<a name="290" href="#290">290</a>     <strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">void</strong> testStringNotEquals() {
+<a name="291" href="#291">291</a>         String statement = <span class="jxr_string">"SELECT * FROM "</span> + COMPLEX_TYPE + <span class="jxr_string">" WHERE "</span> + UnitTestTypeSystemCreator.PROP_ID_STRING + <span class="jxr_string">"&lt;&gt; 'Gamma'"</span>;
+<a name="292" href="#292">292</a>         ObjectList res = doQuery(statement);
+<a name="293" href="#293">293</a>         assertEquals(4, res.getObjects().size());
+<a name="294" href="#294">294</a>         assertTrue(resultContains(<span class="jxr_string">"alpha"</span>, res));
+<a name="295" href="#295">295</a>         assertTrue(resultContains(<span class="jxr_string">"beta"</span>, res));
+<a name="296" href="#296">296</a>         assertTrue(resultContains(<span class="jxr_string">"delta"</span>, res));
+<a name="297" href="#297">297</a>         assertTrue(resultContains(<span class="jxr_string">"epsilon"</span>, res));
+<a name="298" href="#298">298</a>     }
+<a name="299" href="#299">299</a> 
+<a name="300" href="#300">300</a>     @Test
+<a name="301" href="#301">301</a>     <strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">void</strong> testStringLess() {
+<a name="302" href="#302">302</a>         String statement = <span class="jxr_string">"SELECT * FROM "</span> + COMPLEX_TYPE + <span class="jxr_string">" WHERE "</span> + UnitTestTypeSystemCreator.PROP_ID_STRING + <span class="jxr_string">"&lt; 'Delta'"</span>;
+<a name="303" href="#303">303</a>         ObjectList res = doQuery(statement);
+<a name="304" href="#304">304</a>         assertEquals(2, res.getObjects().size());
+<a name="305" href="#305">305</a>         assertTrue(resultContains(<span class="jxr_string">"alpha"</span>, res));
+<a name="306" href="#306">306</a>         assertTrue(resultContains(<span class="jxr_string">"beta"</span>, res));
+<a name="307" href="#307">307</a>     }
+<a name="308" href="#308">308</a> 
+<a name="309" href="#309">309</a>     @Test
+<a name="310" href="#310">310</a>     <strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">void</strong> testStringLessOrEquals() {
+<a name="311" href="#311">311</a>         String statement = <span class="jxr_string">"SELECT * FROM "</span> + COMPLEX_TYPE + <span class="jxr_string">" WHERE "</span> + UnitTestTypeSystemCreator.PROP_ID_STRING + <span class="jxr_string">"&lt;= 'Delta'"</span>;
+<a name="312" href="#312">312</a>         ObjectList res = doQuery(statement);
+<a name="313" href="#313">313</a>         assertEquals(3, res.getObjects().size());
+<a name="314" href="#314">314</a>         assertTrue(resultContains(<span class="jxr_string">"alpha"</span>, res));
+<a name="315" href="#315">315</a>         assertTrue(resultContains(<span class="jxr_string">"beta"</span>, res));
+<a name="316" href="#316">316</a>         assertTrue(resultContains(<span class="jxr_string">"delta"</span>, res));
+<a name="317" href="#317">317</a>     }
+<a name="318" href="#318">318</a> 
+<a name="319" href="#319">319</a>     @Test
+<a name="320" href="#320">320</a>     <strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">void</strong> testStringGreater() {
+<a name="321" href="#321">321</a>         String statement = <span class="jxr_string">"SELECT * FROM "</span> + COMPLEX_TYPE + <span class="jxr_string">" WHERE "</span> + UnitTestTypeSystemCreator.PROP_ID_STRING + <span class="jxr_string">"&gt; 'Delta'"</span>;
+<a name="322" href="#322">322</a>         ObjectList res = doQuery(statement);
+<a name="323" href="#323">323</a>         assertEquals(2, res.getObjects().size());
+<a name="324" href="#324">324</a>         assertTrue(resultContains(<span class="jxr_string">"gamma"</span>, res));
+<a name="325" href="#325">325</a>         assertTrue(resultContains(<span class="jxr_string">"epsilon"</span>, res));
+<a name="326" href="#326">326</a>     }
+<a name="327" href="#327">327</a> 
+<a name="328" href="#328">328</a>     @Test
+<a name="329" href="#329">329</a>     <strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">void</strong> testStringGreaterOrEquals() {
+<a name="330" href="#330">330</a>         String statement = <span class="jxr_string">"SELECT * FROM "</span> + COMPLEX_TYPE + <span class="jxr_string">" WHERE "</span> + UnitTestTypeSystemCreator.PROP_ID_STRING + <span class="jxr_string">"&gt;= 'Delta'"</span>;
+<a name="331" href="#331">331</a>         ObjectList res = doQuery(statement);
+<a name="332" href="#332">332</a>         assertEquals(3, res.getObjects().size());
+<a name="333" href="#333">333</a>         assertTrue(resultContains(<span class="jxr_string">"gamma"</span>, res));
+<a name="334" href="#334">334</a>         assertTrue(resultContains(<span class="jxr_string">"delta"</span>, res));
+<a name="335" href="#335">335</a>         assertTrue(resultContains(<span class="jxr_string">"epsilon"</span>, res));
+<a name="336" href="#336">336</a>     }
+<a name="337" href="#337">337</a> 
+<a name="338" href="#338">338</a>     <em class="jxr_comment">////////////////////////////////////////////////////////////////////</em>
+<a name="339" href="#339">339</a>     <em class="jxr_comment">// Boolean condition tests</em>
+<a name="340" href="#340">340</a> 
+<a name="341" href="#341">341</a>     @Test
+<a name="342" href="#342">342</a>     <strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">void</strong> testAnd() {
+<a name="343" href="#343">343</a>         String statement = <span class="jxr_string">"SELECT * FROM "</span> + COMPLEX_TYPE + <span class="jxr_string">" WHERE "</span> + PROP_ID_INT + <span class="jxr_string">"= 50 AND "</span> + PROP_ID_BOOLEAN + <span class="jxr_string">"= true"</span>;
+<a name="344" href="#344">344</a>         ObjectList res = doQuery(statement);
+<a name="345" href="#345">345</a>         assertEquals(1, res.getObjects().size());
+<a name="346" href="#346">346</a>         assertTrue(resultContains(<span class="jxr_string">"delta"</span>, res));
+<a name="347" href="#347">347</a> 
+<a name="348" href="#348">348</a>         statement = <span class="jxr_string">"SELECT * FROM "</span> + COMPLEX_TYPE + <span class="jxr_string">" WHERE "</span> + PROP_ID_INT + <span class="jxr_string">"= 50 AND "</span> + PROP_ID_BOOLEAN + <span class="jxr_string">"= false"</span>;
+<a name="349" href="#349">349</a>         res = doQuery(statement);
+<a name="350" href="#350">350</a>         assertEquals(0, res.getObjects().size());
+<a name="351" href="#351">351</a>     }
+<a name="352" href="#352">352</a> 
+<a name="353" href="#353">353</a>     @Test
+<a name="354" href="#354">354</a>     <strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">void</strong> testOr() {
+<a name="355" href="#355">355</a>         String statement = <span class="jxr_string">"SELECT * FROM "</span> + COMPLEX_TYPE + <span class="jxr_string">" WHERE "</span> + PROP_ID_INT + <span class="jxr_string">"= -50 OR "</span> + PROP_ID_BOOLEAN + <span class="jxr_string">"= false"</span>;
+<a name="356" href="#356">356</a>         ObjectList res = doQuery(statement);
+<a name="357" href="#357">357</a>         assertEquals(2, res.getObjects().size());
+<a name="358" href="#358">358</a>         assertTrue(resultContains(<span class="jxr_string">"beta"</span>, res));
+<a name="359" href="#359">359</a>         assertTrue(resultContains(<span class="jxr_string">"epsilon"</span>, res));
+<a name="360" href="#360">360</a>     }
+<a name="361" href="#361">361</a> 
+<a name="362" href="#362">362</a>     @Test
+<a name="363" href="#363">363</a>     <strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">void</strong> testNot() {
+<a name="364" href="#364">364</a>         String statement = <span class="jxr_string">"SELECT * FROM "</span> + COMPLEX_TYPE + <span class="jxr_string">" WHERE NOT "</span> + PROP_ID_INT + <span class="jxr_string">"= 50"</span>;
+<a name="365" href="#365">365</a>         ObjectList res = doQuery(statement);
+<a name="366" href="#366">366</a>         assertEquals(4, res.getObjects().size());
+<a name="367" href="#367">367</a>         assertTrue(resultContains(<span class="jxr_string">"alpha"</span>, res));
+<a name="368" href="#368">368</a>         assertTrue(resultContains(<span class="jxr_string">"beta"</span>, res));
+<a name="369" href="#369">369</a>         assertTrue(resultContains(<span class="jxr_string">"gamma"</span>, res));
+<a name="370" href="#370">370</a>         assertTrue(resultContains(<span class="jxr_string">"epsilon"</span>, res));
+<a name="371" href="#371">371</a>     }
+<a name="372" href="#372">372</a> 
+<a name="373" href="#373">373</a>     @Test
+<a name="374" href="#374">374</a>     <strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">void</strong> testOrderByString() {
+<a name="375" href="#375">375</a>         String statement = <span class="jxr_string">"SELECT * FROM "</span> + COMPLEX_TYPE + <span class="jxr_string">" ORDER BY "</span> + UnitTestTypeSystemCreator.PROP_ID_STRING;
+<a name="376" href="#376">376</a>         ObjectList res = doQuery(statement);
+<a name="377" href="#377">377</a>         assertEquals(5, res.getObjects().size());
+<a name="378" href="#378">378</a>         assertTrue(resultContainsAtPos(<span class="jxr_string">"alpha"</span>, 0, res));
+<a name="379" href="#379">379</a>         assertTrue(resultContainsAtPos(<span class="jxr_string">"beta"</span>, 1, res));
+<a name="380" href="#380">380</a>         assertTrue(resultContainsAtPos(<span class="jxr_string">"delta"</span>, 2, res));
+<a name="381" href="#381">381</a>         assertTrue(resultContainsAtPos(<span class="jxr_string">"epsilon"</span>, 3, res));
+<a name="382" href="#382">382</a>         assertTrue(resultContainsAtPos(<span class="jxr_string">"gamma"</span>, 4, res));
+<a name="383" href="#383">383</a> 
+<a name="384" href="#384">384</a>         statement = <span class="jxr_string">"SELECT * FROM "</span> + COMPLEX_TYPE + <span class="jxr_string">" ORDER BY "</span> + UnitTestTypeSystemCreator.PROP_ID_STRING + <span class="jxr_string">" DESC"</span>;
+<a name="385" href="#385">385</a>         res = doQuery(statement);
+<a name="386" href="#386">386</a>         assertEquals(5, res.getObjects().size());
+<a name="387" href="#387">387</a>         assertTrue(resultContainsAtPos(<span class="jxr_string">"alpha"</span>, 4, res));
+<a name="388" href="#388">388</a>         assertTrue(resultContainsAtPos(<span class="jxr_string">"beta"</span>, 3, res));
+<a name="389" href="#389">389</a>         assertTrue(resultContainsAtPos(<span class="jxr_string">"delta"</span>, 2, res));
+<a name="390" href="#390">390</a>         assertTrue(resultContainsAtPos(<span class="jxr_string">"epsilon"</span>, 1, res));
+<a name="391" href="#391">391</a>         assertTrue(resultContainsAtPos(<span class="jxr_string">"gamma"</span>, 0, res));
+<a name="392" href="#392">392</a> }
+<a name="393" href="#393">393</a> 
+<a name="394" href="#394">394</a>     @Test
+<a name="395" href="#395">395</a>     <strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">void</strong> testOrderByInteger() {
+<a name="396" href="#396">396</a>         String statement = <span class="jxr_string">"SELECT * FROM "</span> + COMPLEX_TYPE + <span class="jxr_string">" ORDER BY "</span> + PROP_ID_INT;
+<a name="397" href="#397">397</a>         ObjectList res = doQuery(statement);
+<a name="398" href="#398">398</a>         assertEquals(5, res.getObjects().size());
+<a name="399" href="#399">399</a>         assertTrue(resultContainsAtPos(<span class="jxr_string">"alpha"</span>, 0, res));
+<a name="400" href="#400">400</a>         assertTrue(resultContainsAtPos(<span class="jxr_string">"beta"</span>, 1, res));
+<a name="401" href="#401">401</a>         assertTrue(resultContainsAtPos(<span class="jxr_string">"gamma"</span>, 2, res));
+<a name="402" href="#402">402</a>         assertTrue(resultContainsAtPos(<span class="jxr_string">"delta"</span>, 3, res));
+<a name="403" href="#403">403</a>         assertTrue(resultContainsAtPos(<span class="jxr_string">"epsilon"</span>, 4, res));
+<a name="404" href="#404">404</a> 
+<a name="405" href="#405">405</a>         statement = <span class="jxr_string">"SELECT * FROM "</span> + COMPLEX_TYPE + <span class="jxr_string">" ORDER BY "</span> + PROP_ID_INT + <span class="jxr_string">" DESC"</span>;
+<a name="406" href="#406">406</a>         res = doQuery(statement);
+<a name="407" href="#407">407</a>         assertEquals(5, res.getObjects().size());
+<a name="408" href="#408">408</a>         assertTrue(resultContainsAtPos(<span class="jxr_string">"alpha"</span>, 4, res));
+<a name="409" href="#409">409</a>         assertTrue(resultContainsAtPos(<span class="jxr_string">"beta"</span>, 3, res));
+<a name="410" href="#410">410</a>         assertTrue(resultContainsAtPos(<span class="jxr_string">"gamma"</span>, 2, res));
+<a name="411" href="#411">411</a>         assertTrue(resultContainsAtPos(<span class="jxr_string">"delta"</span>, 1, res));
+<a name="412" href="#412">412</a>         assertTrue(resultContainsAtPos(<span class="jxr_string">"epsilon"</span>, 0, res));
+<a name="413" href="#413">413</a> }
+<a name="414" href="#414">414</a> 
+<a name="415" href="#415">415</a>     @Test
+<a name="416" href="#416">416</a>     <strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">void</strong> testOrderByDecimal() {
+<a name="417" href="#417">417</a>         String statement = <span class="jxr_string">"SELECT * FROM "</span> + COMPLEX_TYPE + <span class="jxr_string">" ORDER BY "</span> + PROP_ID_DECIMAL;
+<a name="418" href="#418">418</a>         ObjectList res = doQuery(statement);
+<a name="419" href="#419">419</a>         assertEquals(5, res.getObjects().size());
+<a name="420" href="#420">420</a>         assertTrue(resultContainsAtPos(<span class="jxr_string">"alpha"</span>, 0, res));
+<a name="421" href="#421">421</a>         assertTrue(resultContainsAtPos(<span class="jxr_string">"beta"</span>, 1, res));
+<a name="422" href="#422">422</a>         assertTrue(resultContainsAtPos(<span class="jxr_string">"delta"</span>, 2, res));
+<a name="423" href="#423">423</a>         assertTrue(resultContainsAtPos(<span class="jxr_string">"gamma"</span>, 3, res));
+<a name="424" href="#424">424</a>         assertTrue(resultContainsAtPos(<span class="jxr_string">"epsilon"</span>, 4, res));
+<a name="425" href="#425">425</a> 
+<a name="426" href="#426">426</a>         statement = <span class="jxr_string">"SELECT * FROM "</span> + COMPLEX_TYPE + <span class="jxr_string">" ORDER BY "</span> + PROP_ID_DECIMAL + <span class="jxr_string">" DESC"</span>;
+<a name="427" href="#427">427</a>         res = doQuery(statement);
+<a name="428" href="#428">428</a>         assertEquals(5, res.getObjects().size());
+<a name="429" href="#429">429</a>         assertTrue(resultContainsAtPos(<span class="jxr_string">"alpha"</span>, 4, res));
+<a name="430" href="#430">430</a>         assertTrue(resultContainsAtPos(<span class="jxr_string">"beta"</span>, 3, res));
+<a name="431" href="#431">431</a>         assertTrue(resultContainsAtPos(<span class="jxr_string">"delta"</span>, 2, res));
+<a name="432" href="#432">432</a>         assertTrue(resultContainsAtPos(<span class="jxr_string">"gamma"</span>, 1, res));
+<a name="433" href="#433">433</a>         assertTrue(resultContainsAtPos(<span class="jxr_string">"epsilon"</span>, 0, res));
+<a name="434" href="#434">434</a>     }
+<a name="435" href="#435">435</a> 
+<a name="436" href="#436">436</a>     @Test
+<a name="437" href="#437">437</a>     <strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">void</strong> testOrderByDate() {
+<a name="438" href="#438">438</a>         String statement = <span class="jxr_string">"SELECT * FROM "</span> + COMPLEX_TYPE + <span class="jxr_string">" ORDER BY "</span> + PROP_ID_DATETIME;
+<a name="439" href="#439">439</a>         ObjectList res = doQuery(statement);
+<a name="440" href="#440">440</a>         assertEquals(5, res.getObjects().size());
+<a name="441" href="#441">441</a>         assertTrue(resultContainsAtPos(<span class="jxr_string">"beta"</span>, 0, res));
+<a name="442" href="#442">442</a>         assertTrue(resultContainsAtPos(<span class="jxr_string">"alpha"</span>, 1, res));
+<a name="443" href="#443">443</a>         assertTrue(resultContainsAtPos(<span class="jxr_string">"gamma"</span>, 2, res));
+<a name="444" href="#444">444</a>         assertTrue(resultContainsAtPos(<span class="jxr_string">"delta"</span>, 3, res));
+<a name="445" href="#445">445</a>         assertTrue(resultContainsAtPos(<span class="jxr_string">"epsilon"</span>, 4, res));
+<a name="446" href="#446">446</a> 
+<a name="447" href="#447">447</a>         statement = <span class="jxr_string">"SELECT * FROM "</span> + COMPLEX_TYPE + <span class="jxr_string">" ORDER BY "</span> + PROP_ID_DATETIME + <span class="jxr_string">" DESC"</span>;
+<a name="448" href="#448">448</a>         res = doQuery(statement);
+<a name="449" href="#449">449</a>         assertEquals(5, res.getObjects().size());
+<a name="450" href="#450">450</a>         assertTrue(resultContainsAtPos(<span class="jxr_string">"beta"</span>, 4, res));
+<a name="451" href="#451">451</a>         assertTrue(resultContainsAtPos(<span class="jxr_string">"alpha"</span>, 3, res));
+<a name="452" href="#452">452</a>         assertTrue(resultContainsAtPos(<span class="jxr_string">"gamma"</span>, 2, res));
+<a name="453" href="#453">453</a>         assertTrue(resultContainsAtPos(<span class="jxr_string">"delta"</span>, 1, res));
+<a name="454" href="#454">454</a>         assertTrue(resultContainsAtPos(<span class="jxr_string">"epsilon"</span>, 0, res));
+<a name="455" href="#455">455</a>     }
+<a name="456" href="#456">456</a> 
+<a name="457" href="#457">457</a>     @Test
+<a name="458" href="#458">458</a>     <strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">void</strong> testOrderByBool() {
+<a name="459" href="#459">459</a>         String statement = <span class="jxr_string">"SELECT * FROM "</span> + COMPLEX_TYPE + <span class="jxr_string">" ORDER BY "</span> + PROP_ID_BOOLEAN;
+<a name="460" href="#460">460</a>         ObjectList res = doQuery(statement);
+<a name="461" href="#461">461</a>         assertEquals(5, res.getObjects().size());
+<a name="462" href="#462">462</a>         assertTrue(resultContainsAtPos(<span class="jxr_string">"beta"</span>, 0, res) || resultContainsAtPos(<span class="jxr_string">"beta"</span>, 1, res));
+<a name="463" href="#463">463</a>         assertTrue(resultContainsAtPos(<span class="jxr_string">"epsilon"</span>, 0, res) || resultContainsAtPos(<span class="jxr_string">"epsilon"</span>, 1, res));
+<a name="464" href="#464">464</a>         assertTrue(resultContainsAtPos(<span class="jxr_string">"alpha"</span>, 2, res) || resultContainsAtPos(<span class="jxr_string">"alpha"</span>, 3, res) || resultContainsAtPos(<span class="jxr_string">"alpha"</span>, 4, res));
+<a name="465" href="#465">465</a>         assertTrue(resultContainsAtPos(<span class="jxr_string">"gamma"</span>, 2, res) || resultContainsAtPos(<span class="jxr_string">"gamma"</span>, 3, res) || resultContainsAtPos(<span class="jxr_string">"gamma"</span>, 4, res));
+<a name="466" href="#466">466</a>         assertTrue(resultContainsAtPos(<span class="jxr_string">"delta"</span>, 2, res) || resultContainsAtPos(<span class="jxr_string">"delta"</span>, 3, res) || resultContainsAtPos(<span class="jxr_string">"delta"</span>, 4, res));
+<a name="467" href="#467">467</a> 
+<a name="468" href="#468">468</a>         statement = <span class="jxr_string">"SELECT * FROM "</span> + COMPLEX_TYPE + <span class="jxr_string">" ORDER BY "</span> + PROP_ID_BOOLEAN + <span class="jxr_string">" DESC"</span>;
+<a name="469" href="#469">469</a>         res = doQuery(statement);
+<a name="470" href="#470">470</a>         assertEquals(5, res.getObjects().size());
+<a name="471" href="#471">471</a>         assertTrue(resultContainsAtPos(<span class="jxr_string">"beta"</span>, 3, res) || resultContainsAtPos(<span class="jxr_string">"beta"</span>, 4, res));
+<a name="472" href="#472">472</a>         assertTrue(resultContainsAtPos(<span class="jxr_string">"epsilon"</span>, 3, res) || resultContainsAtPos(<span class="jxr_string">"epsilon"</span>, 4, res));
+<a name="473" href="#473">473</a>         assertTrue(resultContainsAtPos(<span class="jxr_string">"alpha"</span>, 2, res) || resultContainsAtPos(<span class="jxr_string">"alpha"</span>, 1, res) || resultContainsAtPos(<span class="jxr_string">"alpha"</span>, 0, res));
+<a name="474" href="#474">474</a>         assertTrue(resultContainsAtPos(<span class="jxr_string">"gamma"</span>, 2, res) || resultContainsAtPos(<span class="jxr_string">"gamma"</span>, 1, res) || resultContainsAtPos(<span class="jxr_string">"gamma"</span>, 0, res));
+<a name="475" href="#475">475</a>         assertTrue(resultContainsAtPos(<span class="jxr_string">"delta"</span>, 2, res) || resultContainsAtPos(<span class="jxr_string">"delta"</span>, 1, res) || resultContainsAtPos(<span class="jxr_string">"delta"</span>, 0, res));
+<a name="476" href="#476">476</a>     }
+<a name="477" href="#477">477</a>     
+<a name="478" href="#478">478</a>     <em class="jxr_comment">// reported JIRA issue CMIS-510</em>
+<a name="479" href="#479">479</a>     @Test
+<a name="480" href="#480">480</a>     <strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">void</strong> testOrderBySystemProperties() {
+<a name="481" href="#481">481</a>         String statement = <span class="jxr_string">"SELECT * from cmis:document ORDER BY "</span>+ PropertyIds.NAME;
+<a name="482" href="#482">482</a>         ObjectList res = doQuery(statement);
+<a name="483" href="#483">483</a>         assertEquals(5, res.getObjects().size());
+<a name="484" href="#484">484</a>         statement = <span class="jxr_string">"SELECT * from cmis:document ORDER BY "</span> + PropertyIds.CREATION_DATE + <span class="jxr_string">" ASC"</span>;
+<a name="485" href="#485">485</a>         assertEquals(5, res.getObjects().size());
+<a name="486" href="#486">486</a>         statement = <span class="jxr_string">"SELECT * from cmis:document ORDER BY "</span> + PropertyIds.LAST_MODIFICATION_DATE + <span class="jxr_string">" DESC"</span>;
+<a name="487" href="#487">487</a>         assertEquals(5, res.getObjects().size());
+<a name="488" href="#488">488</a>     }
+<a name="489" href="#489">489</a> 
+<a name="490" href="#490">490</a>     @Test
+<a name="491" href="#491">491</a>     <strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">void</strong> testIsNull() {
+<a name="492" href="#492">492</a>         dataCreator.createNullTestDocument();
+<a name="493" href="#493">493</a>         String statement = <span class="jxr_string">"SELECT * FROM "</span> + COMPLEX_TYPE + <span class="jxr_string">" WHERE "</span> + PROP_ID_INT + <span class="jxr_string">" IS NULL"</span>;
+<a name="494" href="#494">494</a>         ObjectList res = doQuery(statement);
+<a name="495" href="#495">495</a>         assertEquals(1, res.getObjects().size());
+<a name="496" href="#496">496</a>         assertTrue(resultContains(<span class="jxr_string">"nulldoc"</span>, res));
+<a name="497" href="#497">497</a>     }
+<a name="498" href="#498">498</a> 
+<a name="499" href="#499">499</a>     @Test
+<a name="500" href="#500">500</a>     <strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">void</strong> testIsNotNull() {
+<a name="501" href="#501">501</a>         dataCreator.createNullTestDocument();
+<a name="502" href="#502">502</a>         String statement = <span class="jxr_string">"SELECT * FROM "</span> + COMPLEX_TYPE + <span class="jxr_string">" WHERE "</span> + PROP_ID_INT + <span class="jxr_string">" IS NOT NULL"</span>;
+<a name="503" href="#503">503</a>         ObjectList res = doQuery(statement);
+<a name="504" href="#504">504</a>         assertEquals(5, res.getObjects().size());
+<a name="505" href="#505">505</a>         assertTrue(resultContains(<span class="jxr_string">"alpha"</span>, res));
+<a name="506" href="#506">506</a>         assertTrue(resultContains(<span class="jxr_string">"beta"</span>, res));
+<a name="507" href="#507">507</a>         assertTrue(resultContains(<span class="jxr_string">"gamma"</span>, res));
+<a name="508" href="#508">508</a>         assertTrue(resultContains(<span class="jxr_string">"delta"</span>, res));
+<a name="509" href="#509">509</a>         assertTrue(resultContains(<span class="jxr_string">"epsilon"</span>, res));
+<a name="510" href="#510">510</a>     }
+<a name="511" href="#511">511</a> 
+<a name="512" href="#512">512</a>     @Test
+<a name="513" href="#513">513</a>     <strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">void</strong> patternTest() {
+<a name="514" href="#514">514</a>         String res = InMemoryQueryProcessor.translatePattern(<span class="jxr_string">"ABC%def"</span>);
+<a name="515" href="#515">515</a>         assertEquals(<span class="jxr_string">"ABC.*def"</span>, res);
+<a name="516" href="#516">516</a>         res = InMemoryQueryProcessor.translatePattern(<span class="jxr_string">"%abc"</span>);
+<a name="517" href="#517">517</a>         assertEquals(<span class="jxr_string">".*abc"</span>, res);
+<a name="518" href="#518">518</a>         res = InMemoryQueryProcessor.translatePattern(<span class="jxr_string">"abc%"</span>);
+<a name="519" href="#519">519</a>         assertEquals(<span class="jxr_string">"abc.*"</span>, res);
+<a name="520" href="#520">520</a>         res = InMemoryQueryProcessor.translatePattern(<span class="jxr_string">"ABC&#92;&#92;%def"</span>);
+<a name="521" href="#521">521</a>         assertEquals(<span class="jxr_string">"ABC&#92;&#92;%def"</span>, res);
+<a name="522" href="#522">522</a>         res = InMemoryQueryProcessor.translatePattern(<span class="jxr_string">"&#92;&#92;%abc"</span>);
+<a name="523" href="#523">523</a>         assertEquals(<span class="jxr_string">"&#92;&#92;%abc"</span>, res);
+<a name="524" href="#524">524</a>         res = InMemoryQueryProcessor.translatePattern(<span class="jxr_string">"abc%def%ghi"</span>);
+<a name="525" href="#525">525</a>         assertEquals(<span class="jxr_string">"abc.*def.*ghi"</span>, res);
+<a name="526" href="#526">526</a>         res = InMemoryQueryProcessor.translatePattern(<span class="jxr_string">"abc%def&#92;&#92;%ghi%jkl"</span>);
+<a name="527" href="#527">527</a>         assertEquals(<span class="jxr_string">"abc.*def&#92;&#92;%ghi.*jkl"</span>, res);
+<a name="528" href="#528">528</a> 
+<a name="529" href="#529">529</a>         res = InMemoryQueryProcessor.translatePattern(<span class="jxr_string">"ABC_def"</span>);
+<a name="530" href="#530">530</a>         assertEquals(<span class="jxr_string">"ABC.def"</span>, res);
+<a name="531" href="#531">531</a>         res = InMemoryQueryProcessor.translatePattern(<span class="jxr_string">"_abc"</span>);
+<a name="532" href="#532">532</a>         assertEquals(<span class="jxr_string">".abc"</span>, res);
+<a name="533" href="#533">533</a>         res = InMemoryQueryProcessor.translatePattern(<span class="jxr_string">"abc_"</span>);
+<a name="534" href="#534">534</a>         assertEquals(<span class="jxr_string">"abc."</span>, res);
+<a name="535" href="#535">535</a>         res = InMemoryQueryProcessor.translatePattern(<span class="jxr_string">"ABC&#92;&#92;_def"</span>);
+<a name="536" href="#536">536</a>         assertEquals(<span class="jxr_string">"ABC&#92;&#92;_def"</span>, res);
+<a name="537" href="#537">537</a>         res = InMemoryQueryProcessor.translatePattern(<span class="jxr_string">"&#92;&#92;_abc"</span>);
+<a name="538" href="#538">538</a>         assertEquals(<span class="jxr_string">"&#92;&#92;_abc"</span>, res);
+<a name="539" href="#539">539</a>         res = InMemoryQueryProcessor.translatePattern(<span class="jxr_string">"abc_def_ghi"</span>);
+<a name="540" href="#540">540</a>         assertEquals(<span class="jxr_string">"abc.def.ghi"</span>, res);
+<a name="541" href="#541">541</a>         res = InMemoryQueryProcessor.translatePattern(<span class="jxr_string">"abc_def&#92;&#92;_ghi_jkl"</span>);
+<a name="542" href="#542">542</a>         assertEquals(<span class="jxr_string">"abc.def&#92;&#92;_ghi.jkl"</span>, res);
+<a name="543" href="#543">543</a>     }
+<a name="544" href="#544">544</a> 
+<a name="545" href="#545">545</a>     @Test
+<a name="546" href="#546">546</a>     <strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">void</strong> testLike() {
+<a name="547" href="#547">547</a>         dataCreator.createLikeTestDocuments(fRootFolderId);
+<a name="548" href="#548">548</a>         String statement = <span class="jxr_string">"SELECT * FROM "</span> + COMPLEX_TYPE + <span class="jxr_string">" WHERE "</span> + UnitTestTypeSystemCreator.PROP_ID_STRING + <span class="jxr_string">" LIKE 'ABC%'"</span>;
+<a name="549" href="#549">549</a>         ObjectList res = doQuery(statement);
+<a name="550" href="#550">550</a>         assertEquals(2, res.getObjects().size());
+<a name="551" href="#551">551</a>         assertTrue(resultContains(<span class="jxr_string">"likedoc1"</span>, res));
+<a name="552" href="#552">552</a>         assertTrue(resultContains(<span class="jxr_string">"likedoc2"</span>, res));
+<a name="553" href="#553">553</a> 
+<a name="554" href="#554">554</a>         statement = <span class="jxr_string">"SELECT * FROM "</span> + COMPLEX_TYPE + <span class="jxr_string">" WHERE "</span> + UnitTestTypeSystemCreator.PROP_ID_STRING + <span class="jxr_string">" LIKE '%ABC'"</span>;
+<a name="555" href="#555">555</a>         res = doQuery(statement);
+<a name="556" href="#556">556</a>         assertEquals(1, res.getObjects().size());
+<a name="557" href="#557">557</a>         assertTrue(resultContains(<span class="jxr_string">"likedoc3"</span>, res));
+<a name="558" href="#558">558</a> 
+<a name="559" href="#559">559</a>         statement = <span class="jxr_string">"SELECT * FROM "</span> + COMPLEX_TYPE + <span class="jxr_string">" WHERE "</span> + UnitTestTypeSystemCreator.PROP_ID_STRING + <span class="jxr_string">" LIKE '%ABC%'"</span>;
+<a name="560" href="#560">560</a>         res = doQuery(statement);
+<a name="561" href="#561">561</a>         assertEquals(3, res.getObjects().size());
+<a name="562" href="#562">562</a>         assertTrue(resultContains(<span class="jxr_string">"likedoc1"</span>, res));
+<a name="563" href="#563">563</a>         assertTrue(resultContains(<span class="jxr_string">"likedoc2"</span>, res));
+<a name="564" href="#564">564</a>         assertTrue(resultContains(<span class="jxr_string">"likedoc3"</span>, res));
+<a name="565" href="#565">565</a> 
+<a name="566" href="#566">566</a>         statement = <span class="jxr_string">"SELECT * FROM "</span> + COMPLEX_TYPE + <span class="jxr_string">" WHERE "</span> + UnitTestTypeSystemCreator.PROP_ID_STRING + <span class="jxr_string">" LIKE 'AB_DEF'"</span>;
+<a name="567" href="#567">567</a>         res = doQuery(statement);
+<a name="568" href="#568">568</a>         assertEquals(1, res.getObjects().size());
+<a name="569" href="#569">569</a>         assertTrue(resultContains(<span class="jxr_string">"likedoc1"</span>, res));
+<a name="570" href="#570">570</a>     }
+<a name="571" href="#571">571</a> 
+<a name="572" href="#572">572</a>     @Test
+<a name="573" href="#573">573</a>     <strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">void</strong> testNotLike() {
+<a name="574" href="#574">574</a>         dataCreator.createLikeTestDocuments(fRootFolderId);
+<a name="575" href="#575">575</a>         String statement = <span class="jxr_string">"SELECT * FROM "</span> + COMPLEX_TYPE + <span class="jxr_string">" WHERE "</span> + UnitTestTypeSystemCreator.PROP_ID_STRING + <span class="jxr_string">" NOT LIKE 'ABC%'"</span>;
+<a name="576" href="#576">576</a>         ObjectList res = doQuery(statement);
+<a name="577" href="#577">577</a>         assertEquals(6, res.getObjects().size());
+<a name="578" href="#578">578</a>         assertTrue(resultContains(<span class="jxr_string">"likedoc3"</span>, res));
+<a name="579" href="#579">579</a> 
+<a name="580" href="#580">580</a>         statement = <span class="jxr_string">"SELECT * FROM "</span> + COMPLEX_TYPE + <span class="jxr_string">" WHERE "</span> + UnitTestTypeSystemCreator.PROP_ID_STRING + <span class="jxr_string">" NOT LIKE '%a'"</span>;
+<a name="581" href="#581">581</a>         res = doQuery(statement);
+<a name="582" href="#582">582</a>         assertEquals(4, res.getObjects().size());
+<a name="583" href="#583">583</a>         assertTrue(resultContains(<span class="jxr_string">"likedoc1"</span>, res));
+<a name="584" href="#584">584</a>         assertTrue(resultContains(<span class="jxr_string">"likedoc1"</span>, res));
+<a name="585" href="#585">585</a>         assertTrue(resultContains(<span class="jxr_string">"likedoc3"</span>, res));
+<a name="586" href="#586">586</a>         assertTrue(resultContains(<span class="jxr_string">"epsilon"</span>, res));
+<a name="587" href="#587">587</a>     }
+<a name="588" href="#588">588</a> 
+<a name="589" href="#589">589</a>     @Test
+<a name="590" href="#590">590</a>     <strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">void</strong> testInFolder() {
+<a name="591" href="#591">591</a>         String statement = <span class="jxr_string">"SELECT * FROM "</span> + COMPLEX_TYPE + <span class="jxr_string">" WHERE IN_FOLDER('"</span> + fRootFolderId + <span class="jxr_string">"')"</span>;
+<a name="592" href="#592">592</a>         ObjectList res = doQuery(statement);
+<a name="593" href="#593">593</a>         assertEquals(5, res.getObjects().size());
+<a name="594" href="#594">594</a>         assertTrue(resultContains(<span class="jxr_string">"alpha"</span>, res));
+<a name="595" href="#595">595</a>         assertTrue(resultContains(<span class="jxr_string">"beta"</span>, res));
+<a name="596" href="#596">596</a>         assertTrue(resultContains(<span class="jxr_string">"gamma"</span>, res));
+<a name="597" href="#597">597</a>         assertTrue(resultContains(<span class="jxr_string">"delta"</span>, res));
+<a name="598" href="#598">598</a>         assertTrue(resultContains(<span class="jxr_string">"epsilon"</span>, res));
+<a name="599" href="#599">599</a> 
+<a name="600" href="#600">600</a>         statement = <span class="jxr_string">"SELECT * FROM "</span> + COMPLEX_TYPE + <span class="jxr_string">" WHERE IN_FOLDER('"</span> + dataCreator.getFolder1() + <span class="jxr_string">"')"</span>;
+<a name="601" href="#601">601</a>         res = doQuery(statement);
+<a name="602" href="#602">602</a>         assertEquals(0, res.getObjects().size());
+<a name="603" href="#603">603</a> 
+<a name="604" href="#604">604</a>         statement = <span class="jxr_string">"SELECT * FROM "</span> + COMPLEX_TYPE + <span class="jxr_string">" WHERE IN_FOLDER("</span> + COMPLEX_TYPE + <span class="jxr_string">", '"</span> + fRootFolderId + <span class="jxr_string">"')"</span>;
+<a name="605" href="#605">605</a>         res = doQuery(statement);
+<a name="606" href="#606">606</a>         assertEquals(5, res.getObjects().size());
+<a name="607" href="#607">607</a>         assertTrue(resultContains(<span class="jxr_string">"alpha"</span>, res));
+<a name="608" href="#608">608</a>         assertTrue(resultContains(<span class="jxr_string">"beta"</span>, res));
+<a name="609" href="#609">609</a>         assertTrue(resultContains(<span class="jxr_string">"gamma"</span>, res));
+<a name="610" href="#610">610</a>         assertTrue(resultContains(<span class="jxr_string">"delta"</span>, res));
+<a name="611" href="#611">611</a>         assertTrue(resultContains(<span class="jxr_string">"epsilon"</span>, res));
+<a name="612" href="#612">612</a> 
+<a name="613" href="#613">613</a>         statement = <span class="jxr_string">"SELECT * FROM "</span> + COMPLEX_TYPE + <span class="jxr_string">" WHERE IN_FOLDER(UnknownType, '"</span> + dataCreator.getFolder2() + <span class="jxr_string">"')"</span>;
+<a name="614" href="#614">614</a>         <strong class="jxr_keyword">try</strong> {
+<a name="615" href="#615">615</a>             res = doQuery(statement);
+<a name="616" href="#616">616</a>             fail(<span class="jxr_string">"Unknown type in folder should throw exception"</span>);
+<a name="617" href="#617">617</a>         } <strong class="jxr_keyword">catch</strong> (Exception e) {
+<a name="618" href="#618">618</a>             assertTrue(e.toString().contains(<span class="jxr_string">"is neither a type query name nor an alias"</span>));
+<a name="619" href="#619">619</a>             log.debug(<span class="jxr_string">"expected Exception: "</span> + e);
+<a name="620" href="#620">620</a>         }
+<a name="621" href="#621">621</a>     }
+<a name="622" href="#622">622</a> 
+<a name="623" href="#623">623</a>     @Test
+<a name="624" href="#624">624</a>     <strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">void</strong> testInTree() {
+<a name="625" href="#625">625</a>         dataCreator.createLikeTestDocuments(dataCreator.getFolder11());
+<a name="626" href="#626">626</a> 
+<a name="627" href="#627">627</a>         String statement = <span class="jxr_string">"SELECT * FROM "</span> + COMPLEX_TYPE + <span class="jxr_string">" WHERE IN_TREE("</span> + COMPLEX_TYPE + <span class="jxr_string">", '"</span> + dataCreator.getFolder1() + <span class="jxr_string">"')"</span>;
+<a name="628" href="#628">628</a>         ObjectList res = doQuery(statement);
+<a name="629" href="#629">629</a>         assertEquals(3, res.getObjects().size());
+<a name="630" href="#630">630</a>         assertTrue(resultContains(<span class="jxr_string">"likedoc1"</span>, res));
+<a name="631" href="#631">631</a>         assertTrue(resultContains(<span class="jxr_string">"likedoc2"</span>, res));
+<a name="632" href="#632">632</a>         assertTrue(resultContains(<span class="jxr_string">"likedoc3"</span>, res));
+<a name="633" href="#633">633</a> 
+<a name="634" href="#634">634</a>         statement = <span class="jxr_string">"SELECT * FROM "</span> + COMPLEX_TYPE + <span class="jxr_string">" WHERE IN_FOLDER('"</span> + dataCreator.getFolder1() + <span class="jxr_string">"')"</span>;
+<a name="635" href="#635">635</a>         res = doQuery(statement);
+<a name="636" href="#636">636</a>         assertEquals(0, res.getObjects().size());
+<a name="637" href="#637">637</a> 
+<a name="638" href="#638">638</a>         statement = <span class="jxr_string">"SELECT * FROM "</span> + COMPLEX_TYPE + <span class="jxr_string">" WHERE IN_TREE('"</span> + dataCreator.getFolder2() + <span class="jxr_string">"')"</span>;
+<a name="639" href="#639">639</a>         res = doQuery(statement);
+<a name="640" href="#640">640</a>         assertEquals(0, res.getObjects().size());
+<a name="641" href="#641">641</a> 
+<a name="642" href="#642">642</a>         statement = <span class="jxr_string">"SELECT * FROM "</span> + COMPLEX_TYPE + <span class="jxr_string">" WHERE IN_TREE(UnknownType, '"</span> + dataCreator.getFolder2() + <span class="jxr_string">"')"</span>;
+<a name="643" href="#643">643</a>         <strong class="jxr_keyword">try</strong> {
+<a name="644" href="#644">644</a>             res = doQuery(statement);
+<a name="645" href="#645">645</a>             fail(<span class="jxr_string">"Unknown type in folder should throw exception"</span>);
+<a name="646" href="#646">646</a>         } <strong class="jxr_keyword">catch</strong> (Exception e) {
+<a name="647" href="#647">647</a>             assertTrue(e.toString().contains(<span class="jxr_string">"is neither a type query name nor an alias"</span>));
+<a name="648" href="#648">648</a>             log.debug(<span class="jxr_string">"expected Exception: "</span> + e);
+<a name="649" href="#649">649</a>         }
+<a name="650" href="#650">650</a>     }
+<a name="651" href="#651">651</a> 
+<a name="652" href="#652">652</a>     @Test
+<a name="653" href="#653">653</a>     <strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">void</strong> testIn() {
+<a name="654" href="#654">654</a>         String statement = <span class="jxr_string">"SELECT * FROM "</span> + COMPLEX_TYPE + <span class="jxr_string">" WHERE "</span> + UnitTestTypeSystemCreator.PROP_ID_STRING + <span class="jxr_string">" IN ('Alpha', 'Beta', 'Gamma')"</span>;
+<a name="655" href="#655">655</a>         ObjectList res = doQuery(statement);
+<a name="656" href="#656">656</a>         assertEquals(3, res.getObjects().size());
+<a name="657" href="#657">657</a>         assertTrue(resultContains(<span class="jxr_string">"alpha"</span>, res));
+<a name="658" href="#658">658</a>         assertTrue(resultContains(<span class="jxr_string">"beta"</span>, res));
+<a name="659" href="#659">659</a>         assertTrue(resultContains(<span class="jxr_string">"gamma"</span>, res));
+<a name="660" href="#660">660</a> 
+<a name="661" href="#661">661</a>         statement = <span class="jxr_string">"SELECT * FROM "</span> + COMPLEX_TYPE + <span class="jxr_string">" WHERE "</span> + UnitTestTypeSystemCreator.PROP_ID_STRING + <span class="jxr_string">" IN ('Theta', 'Pi', 'Rho')"</span>;
+<a name="662" href="#662">662</a>         res = doQuery(statement);
+<a name="663" href="#663">663</a>         assertEquals(0, res.getObjects().size());
+<a name="664" href="#664">664</a>     }
+<a name="665" href="#665">665</a> 
+<a name="666" href="#666">666</a>     @Test
+<a name="667" href="#667">667</a>     <strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">void</strong> testNotIn() {
+<a name="668" href="#668">668</a>         String statement = <span class="jxr_string">"SELECT * FROM "</span> + COMPLEX_TYPE + <span class="jxr_string">" WHERE "</span> + UnitTestTypeSystemCreator.PROP_ID_STRING + <span class="jxr_string">" NOT IN ('Alpha', 'Beta', 'Gamma')"</span>;
+<a name="669" href="#669">669</a>         ObjectList res = doQuery(statement);
+<a name="670" href="#670">670</a>         assertEquals(2, res.getObjects().size());
+<a name="671" href="#671">671</a>         assertTrue(resultContains(<span class="jxr_string">"delta"</span>, res));
+<a name="672" href="#672">672</a>         assertTrue(resultContains(<span class="jxr_string">"epsilon"</span>, res));
+<a name="673" href="#673">673</a> 
+<a name="674" href="#674">674</a>         statement = <span class="jxr_string">"SELECT * FROM "</span> + COMPLEX_TYPE + <span class="jxr_string">" WHERE "</span> + UnitTestTypeSystemCreator.PROP_ID_STRING + <span class="jxr_string">" NOT IN ('Theta', 'Pi', 'Rho')"</span>;
+<a name="675" href="#675">675</a>         res = doQuery(statement);
+<a name="676" href="#676">676</a>         assertEquals(5, res.getObjects().size());
+<a name="677" href="#677">677</a>         assertTrue(resultContains(<span class="jxr_string">"alpha"</span>, res));
+<a name="678" href="#678">678</a>         assertTrue(resultContains(<span class="jxr_string">"beta"</span>, res));
+<a name="679" href="#679">679</a>         assertTrue(resultContains(<span class="jxr_string">"gamma"</span>, res));
+<a name="680" href="#680">680</a>         assertTrue(resultContains(<span class="jxr_string">"delta"</span>, res));
+<a name="681" href="#681">681</a>         assertTrue(resultContains(<span class="jxr_string">"epsilon"</span>, res));
+<a name="682" href="#682">682</a>     }
+<a name="683" href="#683">683</a> 
+<a name="684" href="#684">684</a>     @Test
+<a name="685" href="#685">685</a>     <strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">void</strong> testMultiValueInAny() {
+<a name="686" href="#686">686</a>         dataCreator.createMultiValueDocuments();
+<a name="687" href="#687">687</a> 
+<a name="688" href="#688">688</a>         String statement = <span class="jxr_string">"SELECT * FROM "</span> + COMPLEX_TYPE + <span class="jxr_string">" WHERE ANY "</span> + UnitTestTypeSystemCreator.PROP_ID_STRING_MULTI_VALUE + <span class="jxr_string">" IN ('red', 'black', 'grey')"</span>;
+<a name="689" href="#689">689</a>         ObjectList res = doQuery(statement);
+<a name="690" href="#690">690</a>         assertEquals(2, res.getObjects().size());
+<a name="691" href="#691">691</a>         assertTrue(resultContains(<span class="jxr_string">"mv-alpha"</span>, res));
+<a name="692" href="#692">692</a>         assertTrue(resultContains(<span class="jxr_string">"mv-beta"</span>, res));
+<a name="693" href="#693">693</a> 
+<a name="694" href="#694">694</a>         statement = <span class="jxr_string">"SELECT * FROM "</span> + COMPLEX_TYPE + <span class="jxr_string">" WHERE ANY "</span> + UnitTestTypeSystemCreator.PROP_ID_STRING_MULTI_VALUE + <span class="jxr_string">" IN ('green', 'black', 'grey')"</span>;
+<a name="695" href="#695">695</a>         res = doQuery(statement);
+<a name="696" href="#696">696</a>         assertEquals(1, res.getObjects().size());
+<a name="697" href="#697">697</a>         assertTrue(resultContains(<span class="jxr_string">"mv-alpha"</span>, res));
+<a name="698" href="#698">698</a> 
+<a name="699" href="#699">699</a>         statement = <span class="jxr_string">"SELECT * FROM "</span> + COMPLEX_TYPE + <span class="jxr_string">" WHERE ANY "</span> + UnitTestTypeSystemCreator.PROP_ID_STRING_MULTI_VALUE + <span class="jxr_string">" IN ('white', 'black', 'grey')"</span>;
+<a name="700" href="#700">700</a>         res = doQuery(statement);
+<a name="701" href="#701">701</a>         assertEquals(0, res.getObjects().size());
+<a name="702" href="#702">702</a>     }
+<a name="703" href="#703">703</a> 
+<a name="704" href="#704">704</a>     @Test
+<a name="705" href="#705">705</a>     <strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">void</strong> testMultiValueNotInAny() {
+<a name="706" href="#706">706</a>         dataCreator.createMultiValueDocuments();
+<a name="707" href="#707">707</a> 
+<a name="708" href="#708">708</a>         String statement = <span class="jxr_string">"SELECT * FROM "</span> + COMPLEX_TYPE + <span class="jxr_string">" WHERE ANY "</span> + UnitTestTypeSystemCreator.PROP_ID_STRING_MULTI_VALUE + <span class="jxr_string">" NOT IN ('red', 'black', 'grey')"</span>;
+<a name="709" href="#709">709</a>         ObjectList res = doQuery(statement);
+<a name="710" href="#710">710</a>         assertEquals(0, res.getObjects().size());
+<a name="711" href="#711">711</a> 
+<a name="712" href="#712">712</a>         statement = <span class="jxr_string">"SELECT * FROM "</span> + COMPLEX_TYPE + <span class="jxr_string">" WHERE ANY "</span> + UnitTestTypeSystemCreator.PROP_ID_STRING_MULTI_VALUE + <span class="jxr_string">" NOT IN ('green', 'black', 'grey')"</span>;
+<a name="713" href="#713">713</a>         res = doQuery(statement);
+<a name="714" href="#714">714</a>         assertEquals(1, res.getObjects().size());
+<a name="715" href="#715">715</a>         assertTrue(resultContains(<span class="jxr_string">"mv-beta"</span>, res));
+<a name="716" href="#716">716</a> 
+<a name="717" href="#717">717</a>         statement = <span class="jxr_string">"SELECT * FROM "</span> + COMPLEX_TYPE + <span class="jxr_string">" WHERE ANY "</span> + UnitTestTypeSystemCreator.PROP_ID_STRING_MULTI_VALUE + <span class="jxr_string">" NOT IN ('white', 'black', 'grey')"</span>;
+<a name="718" href="#718">718</a>         res = doQuery(statement);
+<a name="719" href="#719">719</a>         assertEquals(2, res.getObjects().size());
+<a name="720" href="#720">720</a>         assertTrue(resultContains(<span class="jxr_string">"mv-alpha"</span>, res));
+<a name="721" href="#721">721</a>         assertTrue(resultContains(<span class="jxr_string">"mv-beta"</span>, res));
+<a name="722" href="#722">722</a>     }
+<a name="723" href="#723">723</a> 
+<a name="724" href="#724">724</a>     @Test
+<a name="725" href="#725">725</a>     <strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">void</strong> testMultiValueEqAny() {
+<a name="726" href="#726">726</a>         dataCreator.createMultiValueDocuments();
+<a name="727" href="#727">727</a> 
+<a name="728" href="#728">728</a>         String statement = <span class="jxr_string">"SELECT * FROM "</span> + COMPLEX_TYPE + <span class="jxr_string">" WHERE 'red' = ANY "</span> + UnitTestTypeSystemCreator.PROP_ID_STRING_MULTI_VALUE ;
+<a name="729" href="#729">729</a>         ObjectList res = doQuery(statement);
+<a name="730" href="#730">730</a>         assertEquals(2, res.getObjects().size());
+<a name="731" href="#731">731</a>         assertTrue(resultContains(<span class="jxr_string">"mv-alpha"</span>, res));
+<a name="732" href="#732">732</a>         assertTrue(resultContains(<span class="jxr_string">"mv-beta"</span>, res));
+<a name="733" href="#733">733</a> 
+<a name="734" href="#734">734</a>         statement = <span class="jxr_string">"SELECT * FROM "</span> + COMPLEX_TYPE + <span class="jxr_string">" WHERE 'black' = ANY "</span> + UnitTestTypeSystemCreator.PROP_ID_STRING_MULTI_VALUE ;
+<a name="735" href="#735">735</a>         res = doQuery(statement);
+<a name="736" href="#736">736</a>         assertEquals(0, res.getObjects().size());
+<a name="737" href="#737">737</a> 
+<a name="738" href="#738">738</a>         statement = <span class="jxr_string">"SELECT * FROM "</span> + COMPLEX_TYPE + <span class="jxr_string">" WHERE 'black' = ANY "</span> + UnitTestTypeSystemCreator.PROP_ID_STRING;
+<a name="739" href="#739">739</a>         <strong class="jxr_keyword">try</strong> {
+<a name="740" href="#740">740</a>             doQuery(statement);
+<a name="741" href="#741">741</a>             fail(<span class="jxr_string">"Unknown = ANY with single value prop should throw exception"</span>);
+<a name="742" href="#742">742</a>         } <strong class="jxr_keyword">catch</strong> (Exception e) {
+<a name="743" href="#743">743</a>             assertTrue(e.toString().contains(<span class="jxr_string">"only is allowed on multi-value properties"</span>));
+<a name="744" href="#744">744</a>             log.debug(<span class="jxr_string">"expected Exception: "</span> + e);
+<a name="745" href="#745">745</a>         }
+<a name="746" href="#746">746</a>     }
+<a name="747" href="#747">747</a> 
+<a name="748" href="#748">748</a>     @Test
+<a name="749" href="#749">749</a>     <strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">void</strong> testVersionsWithQuery() {
+<a name="750" href="#750">750</a>         String id = dataCreator.createVersionedDocument();
+<a name="751" href="#751">751</a>         assertNotNull(id);
+<a name="752" href="#752">752</a>         String statement = <span class="jxr_string">"SELECT * FROM "</span> + UnitTestTypeSystemCreator.VERSIONED_TYPE;
+<a name="753" href="#753">753</a>         ObjectList res = doQueryAllVersions(statement);
+<a name="754" href="#754">754</a>         assertEquals(2, res.getObjects().size());
+<a name="755" href="#755">755</a>         assertTrue(resultContains(<span class="jxr_string">"ver123"</span>, UnitTestTypeSystemCreator.VERSION_PROPERTY_ID, res));
+<a name="756" href="#756">756</a>         assertTrue(resultContains(<span class="jxr_string">"ver456"</span>, UnitTestTypeSystemCreator.VERSION_PROPERTY_ID, res));
+<a name="757" href="#757">757</a>         assertTrue(resultContains(<span class="jxr_string">"V 1.0"</span>, PropertyIds.VERSION_LABEL, res));
+<a name="758" href="#758">758</a>         assertTrue(resultContains(<span class="jxr_string">"V 2.0"</span>, PropertyIds.VERSION_LABEL, res));
+<a name="759" href="#759">759</a> 
+<a name="760" href="#760">760</a>         res = doQuery(statement);
+<a name="761" href="#761">761</a>         assertEquals(1, res.getObjects().size());
+<a name="762" href="#762">762</a>         assertFalse(resultContains(<span class="jxr_string">"V 1.0"</span>, PropertyIds.VERSION_LABEL, res));
+<a name="763" href="#763">763</a>         assertTrue(resultContains(<span class="jxr_string">"V 2.0"</span>, PropertyIds.VERSION_LABEL, res));
+<a name="764" href="#764">764</a>     }
+<a name="765" href="#765">765</a> 
+<a name="766" href="#766">766</a>     @Test
+<a name="767" href="#767">767</a>     <strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">void</strong> testLastestVersionsWithQuery() {
+<a name="768" href="#768">768</a>         String id = dataCreator.createVersionedDocument();
+<a name="769" href="#769">769</a>         assertNotNull(id);
+<a name="770" href="#770">770</a>         String statement = <span class="jxr_string">"SELECT * FROM "</span> + UnitTestTypeSystemCreator.VERSIONED_TYPE;
+<a name="771" href="#771">771</a>         ObjectList res = doQuery(statement);
+<a name="772" href="#772">772</a>         assertEquals(1, res.getObjects().size());
+<a name="773" href="#773">773</a>         assertTrue(resultContains(<span class="jxr_string">"ver456"</span>, UnitTestTypeSystemCreator.VERSION_PROPERTY_ID, res));
+<a name="774" href="#774">774</a>         assertTrue(resultContains(<span class="jxr_string">"V 2.0"</span>, PropertyIds.VERSION_LABEL, res));
+<a name="775" href="#775">775</a> 
+<a name="776" href="#776">776</a>         res = doQuery(statement);
+<a name="777" href="#777">777</a>         assertEquals(1, res.getObjects().size());
+<a name="778" href="#778">778</a>         assertFalse(resultContains(<span class="jxr_string">"V 1.0"</span>, PropertyIds.VERSION_LABEL, res));
+<a name="779" href="#779">779</a>         assertTrue(resultContains(<span class="jxr_string">"V 2.0"</span>, PropertyIds.VERSION_LABEL, res));
+<a name="780" href="#780">780</a>     }
+<a name="781" href="#781">781</a>     
+<a name="782" href="#782">782</a>     @Test
+<a name="783" href="#783">783</a>     <strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">void</strong> testContainsWord() {
+<a name="784" href="#784">784</a>         String statement = <span class="jxr_string">"SELECT * FROM "</span> + COMPLEX_TYPE + <span class="jxr_string">" WHERE CONTAINS('cat')"</span>;
+<a name="785" href="#785">785</a>         ObjectList res = doQuery(statement);
+<a name="786" href="#786">786</a>         assertEquals(3, res.getObjects().size());
+<a name="787" href="#787">787</a>         assertTrue(resultContains(<span class="jxr_string">"alpha"</span>, res));
+<a name="788" href="#788">788</a>         assertTrue(resultContains(<span class="jxr_string">"beta"</span>, res));
+<a name="789" href="#789">789</a>         assertTrue(resultContains(<span class="jxr_string">"delta"</span>, res));
+<a name="790" href="#790">790</a>     }
+<a name="791" href="#791">791</a> 
+<a name="792" href="#792">792</a>     @Test
+<a name="793" href="#793">793</a>     <strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">void</strong> testContainsPhrase() {
+<a name="794" href="#794">794</a>         String statement = <span class="jxr_string">"SELECT * FROM "</span> + COMPLEX_TYPE + <span class="jxr_string">" WHERE CONTAINS('&#92;&#92;'Kitty Katty&#92;&#92;'')"</span>;
+<a name="795" href="#795">795</a>         ObjectList res = doQuery(statement);
+<a name="796" href="#796">796</a>         assertEquals(1, res.getObjects().size());
+<a name="797" href="#797">797</a>         assertTrue(resultContains(<span class="jxr_string">"beta"</span>, res));
+<a name="798" href="#798">798</a>     }
+<a name="799" href="#799">799</a> 
+<a name="800" href="#800">800</a>     @Test
+<a name="801" href="#801">801</a>     <strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">void</strong> testContainsNot() {
+<a name="802" href="#802">802</a>         String statement = <span class="jxr_string">"SELECT * FROM "</span> + COMPLEX_TYPE + <span class="jxr_string">" WHERE CONTAINS('-cat')"</span>;
+<a name="803" href="#803">803</a>         ObjectList res = doQuery(statement);
+<a name="804" href="#804">804</a>         assertEquals(2, res.getObjects().size());
+<a name="805" href="#805">805</a>         assertTrue(resultContains(<span class="jxr_string">"gamma"</span>, res));
+<a name="806" href="#806">806</a>         assertTrue(resultContains(<span class="jxr_string">"epsilon"</span>, res));
+<a name="807" href="#807">807</a>     }
+<a name="808" href="#808">808</a> 
+<a name="809" href="#809">809</a>     @Test
+<a name="810" href="#810">810</a>     <strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">void</strong> testContainsOr() {
+<a name="811" href="#811">811</a>         String statement = <span class="jxr_string">"SELECT * FROM "</span> + COMPLEX_TYPE + <span class="jxr_string">" WHERE CONTAINS('cat OR dog')"</span>;
+<a name="812" href="#812">812</a>         ObjectList res = doQuery(statement);
+<a name="813" href="#813">813</a>         assertEquals(4, res.getObjects().size());
+<a name="814" href="#814">814</a>         assertTrue(resultContains(<span class="jxr_string">"alpha"</span>, res));
+<a name="815" href="#815">815</a>         assertTrue(resultContains(<span class="jxr_string">"beta"</span>, res));
+<a name="816" href="#816">816</a>         assertTrue(resultContains(<span class="jxr_string">"gamma"</span>, res));
+<a name="817" href="#817">817</a>         assertTrue(resultContains(<span class="jxr_string">"delta"</span>, res));
+<a name="818" href="#818">818</a>     }
+<a name="819" href="#819">819</a> 
+<a name="820" href="#820">820</a>     @Test
+<a name="821" href="#821">821</a>     <strong class="jxr_keyword">public</strong> <strong class="jxr_keyword">void</strong> testContainsAnd() {
+<a name="822" href="#822">822</a>         String statement = <span class="jxr_string">"SELECT * FROM "</span> + COMPLEX_TYPE + <span class="jxr_string">" WHERE CONTAINS('cat dog')"</span>;
+<a name="823" href="#823">823</a>         ObjectList res = doQuery(statement);
+<a name="824" href="#824">824</a>         assertEquals(1, res.getObjects().size());
+<a name="825" href="#825">825</a>         assertTrue(resultContains(<span class="jxr_string">"delta"</span>, res));
+<a name="826" href="#826">826</a>     }
+<a name="827" href="#827">827</a> 
+<a name="828" href="#828">828</a>     <strong class="jxr_keyword">private</strong> ObjectList doQuery(String queryString) {
+<a name="829" href="#829">829</a>         log.debug(<span class="jxr_string">"\nExecuting query: "</span> + queryString);

[... 44 lines stripped ...]


Mime
View raw message