I have a query:
FAC_TYPE IN ('SHARED LANE', 'PAVED SHOULDER', 'BICYCLE LANE', 'SEPARATED BICYCLE LANE', 'BICYCLE BOULEVARD') And (NAME = '' Or NAME IS NULL) And UPDATED = 'YES'
(sorry I can't figure out, using the Syntax Highlighter, how to change the bold or color of the part I want highlighted)
The important part is I not only have NULL values, but blank ones that are only found using the NAME = ''. The issue is if I cut and past my code into the SQL it works fine, however if I save this query for future use and re-load it, the '' is removed each time (NAME = ) and the query fails until I manually have to add the quotes back in.
Here's what it looks like when loading it back up:
FAC_TYPE <SPAN class="operator token">IN</SPAN> <SPAN class="punctuation token">(</SPAN><SPAN class="string token">'SHARED LANE'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'PAVED SHOULDER'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'BICYCLE LANE'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'SEPARATED BICYCLE LANE'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'BICYCLE BOULEVARD'</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="operator token">And</SPAN> <SPAN class="punctuation token">(</SPAN>NAME <SPAN class="operator token">=</SPAN> <SPAN class="operator token">Or</SPAN> NAME <SPAN class="operator token">IS</SPAN> <SPAN class="token boolean">NULL</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="operator token">And</SPAN> UPDATED <SPAN class="operator token">=</SPAN> <SPAN class="string token">'YES'</SPAN><SPAN class="line-numbers-rows"><SPAN></SPAN></SPAN>
Where NAME = shows up with out the ''.
Anyway to fix this when saving queries or is this just a bug?
