https://dev.e-taxonomy.eu/redmine/
https://dev.e-taxonomy.eu/redmine/redmine/favicon.ico?1469191485
2017-09-25T11:44:36Z
EDIT Project Management
EDIT - bug #6495: Fix null titleCache for E+M import
https://dev.e-taxonomy.eu/redmine/issues/6495?journal_id=32360
2017-09-25T11:44:36Z
Andreas Müller
<ul><li><strong>Subject</strong> changed from <i>Fix null titleCache for CoL E+M import</i> to <i>Fix null titleCache for E+M import</i></li></ul>
EDIT - bug #6495: Fix null titleCache for E+M import
https://dev.e-taxonomy.eu/redmine/issues/6495?journal_id=35446
2018-03-12T15:21:04Z
Andreas Müller
<ul><li><strong>Status</strong> changed from <i>New</i> to <i>Worksforme</i></li></ul><p>This issue seems to be fixed in new imports</p>
<p>Tested with</p>
<pre><code class="sql syntaxhl"><span class="k">SELECT</span> <span class="o">*</span>
<span class="k">FROM</span> <span class="n">Reference</span> <span class="k">ref</span>
<span class="k">WHERE</span> <span class="k">ref</span><span class="p">.</span><span class="n">protectedTitleCache</span> <span class="o">=</span> <span class="k">true</span> <span class="k">AND</span> <span class="p">(</span><span class="n">LTRIM</span><span class="p">(</span><span class="n">titleCache</span><span class="p">)</span> <span class="o">=</span> <span class="s1">''</span> <span class="k">OR</span> <span class="n">titleCache</span> <span class="k">is</span> <span class="k">NULL</span><span class="p">)</span>
</code></pre>
<p>Even </p>
<pre><code class="sql syntaxhl"><span class="k">SELECT</span> <span class="o">*</span>
<span class="k">FROM</span> <span class="n">Reference</span> <span class="k">ref</span>
<span class="k">WHERE</span> <span class="n">titleCache</span> <span class="k">IS</span> <span class="k">NULL</span> <span class="k">OR</span> <span class="n">LTRIM</span><span class="p">(</span><span class="n">titleCache</span><span class="p">)</span> <span class="o">=</span> <span class="s1">''</span>
</code></pre>
<p>returns no record.</p>