https://sourceforge.net/p/squirrel-sql/bugs/1535/2025-09-11T19:18:48.560000ZRecent changes to 1535: Browse Content of MS SQL Server table with dash in the name2025-09-11T19:18:48.560000Z2025-09-11T19:18:48.560000ZGerd Wagnerhttps://sourceforge.net/u/gerdwagner/https://sourceforge.netdeb27a5af04c7ac39286fee0283711b976ad3a7e

<div class="markdown_content"><p>Please try the following: Go to menu File --&gt; Global Preference --&gt; tab "SQL Scripts" --&gt; Switch on "Use double quotes (") for qualifying".</p></div>

2025-09-09T14:10:09.448000Z2025-09-09T14:10:09.448000ZBram Bogaerthttps://sourceforge.net/u/brambogaert/https://sourceforge.net3939375160aeed613bae52da5fef049a952b80c1

<div class="markdown_content"><p>In MS SQL Server, when a tablename contains a dash (e.g. Orders-DATABASECHANGELOG), this should be "escaped" using square brackets.</p> <p>An example for a simple select that works (with schema name and table name):</p> <div class="codehilite"><pre><span></span><code><span class="k">SELECT</span><span class="w"> </span><span class="nf">count</span><span class="p">(</span><span class="o">*</span><span class="p">)</span> <span class="k">FROM</span><span class="w"> </span><span class="o">[</span><span class="n">Orders</span><span class="o">]</span><span class="p">.</span><span class="o">[</span><span class="n">Orders-DATABASECHANGELOG</span><span class="o">]</span> </code></pre></div> <p>When browsing in the "Objects" tree in SQuirrel SQL, the tab "Content" will fail with following error logging:<br/> Error occurred during task execution: | java.lang.IllegalStateException: Failed any way to execute content SQL. See former warning log entries for details.</p> <p>The reason is that the above escaping with square brackets is not performed.</p> <p>In the log file I get:</p> <div class="codehilite"><pre><span></span><code><span class="mf">2025</span><span class="o">-</span><span class="mf">09</span><span class="o">-</span><span class="mf">07</span><span class="w"> </span><span class="mf">10</span><span class="p">:</span><span class="mf">02</span><span class="p">:</span><span class="mf">16</span><span class="p">:</span><span class="mf">492</span><span class="w"> </span><span class="err">[</span><span class="n">pool</span><span class="o">-</span><span class="mf">1</span><span class="o">-</span><span class="n">thread</span><span class="o">-</span><span class="mf">1</span><span class="err">]</span><span class="w"> </span><span class="n">WARN</span><span class="w"> </span><span class="n">net</span><span class="mf">.</span><span class="n">sourceforge</span><span class="mf">.</span><span class="n">squirrel_sql</span><span class="mf">.</span><span class="n">client</span><span class="mf">.</span><span class="n">session</span><span class="mf">.</span><span class="n">mainpanel</span><span class="mf">.</span><span class="n">objecttree</span><span class="mf">.</span><span class="nb">tab</span><span class="n">s</span><span class="mf">.</span><span class="nb">tab</span><span class="n">le</span><span class="mf">.</span><span class="kr">Cont</span><span class="n">entsTab</span><span class="w"> </span><span class="o">-</span><span class="w"> </span><span class="n">Failed</span><span class="w"> </span><span class="kr">to</span><span class="w"> </span><span class="n">execute</span><span class="w"> </span><span class="kr">cont</span><span class="n">ent</span><span class="w"> </span><span class="n">SQL</span><span class="p">:</span><span class="w"> </span><span class="n">select</span><span class="w"> </span><span class="o">*</span><span class="w"> </span><span class="n">from</span><span class="w"> </span><span class="n">TST_DB</span><span class="mf">.</span><span class="ow">Or</span><span class="n">ders</span><span class="mf">.</span><span class="ow">Or</span><span class="n">ders</span><span class="o">-</span><span class="kd">DATA</span><span class="n">BASECHANGELOG</span><span class="w"> </span><span class="n">tbl</span> <span class="n">com</span><span class="mf">.</span><span class="n">microsoft</span><span class="mf">.</span><span class="n">sqlserver</span><span class="mf">.</span><span class="n">jdbc</span><span class="mf">.</span><span class="n">SQLServerException</span><span class="p">:</span><span class="w"> </span><span class="n">Incorrect</span><span class="w"> </span><span class="n">syntax</span><span class="w"> </span><span class="n">near</span><span class="w"> </span><span class="err">'</span><span class="o">-</span><span class="err">'</span><span class="mf">.</span> <span class="w"> </span><span class="n">at</span><span class="w"> </span><span class="n">com</span><span class="mf">.</span><span class="n">microsoft</span><span class="mf">.</span><span class="n">sqlserver</span><span class="mf">.</span><span class="n">jdbc</span><span class="mf">.</span><span class="n">SQLServerException</span><span class="mf">.</span><span class="n">makeFromDatabaseError</span><span class="p">(</span><span class="n">SQLServerException</span><span class="mf">.</span><span class="n">java</span><span class="p">:</span><span class="mf">270</span><span class="p">)</span> <span class="w"> </span><span class="n">at</span><span class="w"> </span><span class="n">com</span><span class="mf">.</span><span class="n">microsoft</span><span class="mf">.</span><span class="n">sqlserver</span><span class="mf">.</span><span class="n">jdbc</span><span class="mf">.</span><span class="n">SQLServerStatement</span><span class="mf">.</span><span class="kr">getNext</span><span class="n">Result</span><span class="p">(</span><span class="n">SQLServerStatement</span><span class="mf">.</span><span class="n">java</span><span class="p">:</span><span class="mf">1735</span><span class="p">)</span> <span class="w"> </span><span class="n">at</span><span class="w"> </span><span class="n">com</span><span class="mf">.</span><span class="n">microsoft</span><span class="mf">.</span><span class="n">sqlserver</span><span class="mf">.</span><span class="n">jdbc</span><span class="mf">.</span><span class="n">SQLServerStatement</span><span class="mf">.</span><span class="n">doExecuteStatement</span><span class="p">(</span><span class="n">SQLServerStatement</span><span class="mf">.</span><span class="n">java</span><span class="p">:</span><span class="mf">929</span><span class="p">)</span> <span class="w"> </span><span class="n">at</span><span class="w"> </span><span class="n">com</span><span class="mf">.</span><span class="n">microsoft</span><span class="mf">.</span><span class="n">sqlserver</span><span class="mf">.</span><span class="n">jdbc</span><span class="mf">.</span><span class="n">SQLServerStatement$StmtExecCmd</span><span class="mf">.</span><span class="n">doExecute</span><span class="p">(</span><span class="n">SQLServerStatement</span><span class="mf">.</span><span class="n">java</span><span class="p">:</span><span class="mf">823</span><span class="p">)</span> <span class="w"> </span><span class="n">at</span><span class="w"> </span><span class="n">com</span><span class="mf">.</span><span class="n">microsoft</span><span class="mf">.</span><span class="n">sqlserver</span><span class="mf">.</span><span class="n">jdbc</span><span class="mf">.</span><span class="n">TDSCommand</span><span class="mf">.</span><span class="n">execute</span><span class="p">(</span><span class="n">IOBuffer</span><span class="mf">.</span><span class="n">java</span><span class="p">:</span><span class="mf">7745</span><span class="p">)</span> <span class="w"> </span><span class="n">at</span><span class="w"> </span><span class="n">com</span><span class="mf">.</span><span class="n">microsoft</span><span class="mf">.</span><span class="n">sqlserver</span><span class="mf">.</span><span class="n">jdbc</span><span class="mf">.</span><span class="n">SQLServerConnection</span><span class="mf">.</span><span class="n">executeCommand</span><span class="p">(</span><span class="n">SQLServerConnection</span><span class="mf">.</span><span class="n">java</span><span class="p">:</span><span class="mf">4391</span><span class="p">)</span> <span class="w"> </span><span class="n">at</span><span class="w"> </span><span class="n">com</span><span class="mf">.</span><span class="n">microsoft</span><span class="mf">.</span><span class="n">sqlserver</span><span class="mf">.</span><span class="n">jdbc</span><span class="mf">.</span><span class="n">SQLServerStatement</span><span class="mf">.</span><span class="n">executeCommand</span><span class="p">(</span><span class="n">SQLServerStatement</span><span class="mf">.</span><span class="n">java</span><span class="p">:</span><span class="mf">276</span><span class="p">)</span> <span class="w"> </span><span class="n">at</span><span class="w"> </span><span class="n">com</span><span class="mf">.</span><span class="n">microsoft</span><span class="mf">.</span><span class="n">sqlserver</span><span class="mf">.</span><span class="n">jdbc</span><span class="mf">.</span><span class="n">SQLServerStatement</span><span class="mf">.</span><span class="n">executeStatement</span><span class="p">(</span><span class="n">SQLServerStatement</span><span class="mf">.</span><span class="n">java</span><span class="p">:</span><span class="mf">246</span><span class="p">)</span> <span class="w"> </span><span class="n">at</span><span class="w"> </span><span class="n">com</span><span class="mf">.</span><span class="n">microsoft</span><span class="mf">.</span><span class="n">sqlserver</span><span class="mf">.</span><span class="n">jdbc</span><span class="mf">.</span><span class="n">SQLServerStatement</span><span class="mf">.</span><span class="n">executeQuery</span><span class="p">(</span><span class="n">SQLServerStatement</span><span class="mf">.</span><span class="n">java</span><span class="p">:</span><span class="mf">745</span><span class="p">)</span> <span class="w"> </span><span class="n">at</span><span class="w"> </span><span class="n">net</span><span class="mf">.</span><span class="n">sourceforge</span><span class="mf">.</span><span class="n">squirrel_sql</span><span class="mf">.</span><span class="n">client</span><span class="mf">.</span><span class="n">session</span><span class="mf">.</span><span class="n">mainpanel</span><span class="mf">.</span><span class="n">objecttree</span><span class="mf">.</span><span class="nb">tab</span><span class="n">s</span><span class="mf">.</span><span class="nb">tab</span><span class="n">le</span><span class="mf">.</span><span class="kr">Cont</span><span class="n">entsTab</span><span class="mf">.</span><span class="n">createResultSet</span><span class="p">(</span><span class="kr">Cont</span><span class="n">entsTab</span><span class="mf">.</span><span class="n">java</span><span class="p">:</span><span class="mf">352</span><span class="p">)</span> <span class="w"> </span><span class="n">at</span><span class="w"> </span><span class="n">net</span><span class="mf">.</span><span class="n">sourceforge</span><span class="mf">.</span><span class="n">squirrel_sql</span><span class="mf">.</span><span class="n">client</span><span class="mf">.</span><span class="n">session</span><span class="mf">.</span><span class="n">mainpanel</span><span class="mf">.</span><span class="n">objecttree</span><span class="mf">.</span><span class="nb">tab</span><span class="n">s</span><span class="mf">.</span><span class="nb">tab</span><span class="n">le</span><span class="mf">.</span><span class="kr">Cont</span><span class="n">entsTab</span><span class="mf">.</span><span class="n">createDataSet</span><span class="p">(</span><span class="kr">Cont</span><span class="n">entsTab</span><span class="mf">.</span><span class="n">java</span><span class="p">:</span><span class="mf">251</span><span class="p">)</span> <span class="w"> </span><span class="n">at</span><span class="w"> </span><span class="n">net</span><span class="mf">.</span><span class="n">sourceforge</span><span class="mf">.</span><span class="n">squirrel_sql</span><span class="mf">.</span><span class="n">client</span><span class="mf">.</span><span class="n">session</span><span class="mf">.</span><span class="n">mainpanel</span><span class="mf">.</span><span class="n">objecttree</span><span class="mf">.</span><span class="nb">tab</span><span class="n">s</span><span class="mf">.</span><span class="n">BaseDataSetTab</span><span class="mf">.</span><span class="n">lambda$refreshComponent$</span><span class="mf">0</span><span class="p">(</span><span class="n">BaseDataSetTab</span><span class="mf">.</span><span class="n">java</span><span class="p">:</span><span class="mf">127</span><span class="p">)</span> <span class="w"> </span><span class="n">at</span><span class="w"> </span><span class="n">net</span><span class="mf">.</span><span class="n">sourceforge</span><span class="mf">.</span><span class="n">squirrel_sql</span><span class="mf">.</span><span class="n">fw</span><span class="mf">.</span><span class="n">util</span><span class="mf">.</span><span class="n">TaskExecuter</span><span class="mf">.</span><span class="kr">run</span><span class="p">(</span><span class="n">TaskExecuter</span><span class="mf">.</span><span class="n">java</span><span class="p">:</span><span class="mf">82</span><span class="p">)</span> <span class="w"> </span><span class="n">at</span><span class="w"> </span><span class="n">java</span><span class="mf">.</span><span class="n">base</span><span class="o">/</span><span class="n">java</span><span class="mf">.</span><span class="n">lang</span><span class="mf">.</span><span class="n">Thread</span><span class="mf">.</span><span class="kr">run</span><span class="p">(</span><span class="n">Thread</span><span class="mf">.</span><span class="n">java</span><span class="p">:</span><span class="mf">1583</span><span class="p">)</span> <span class="mf">2025</span><span class="o">-</span><span class="mf">09</span><span class="o">-</span><span class="mf">07</span><span class="w"> </span><span class="mf">10</span><span class="p">:</span><span class="mf">02</span><span class="p">:</span><span class="mf">16</span><span class="p">:</span><span class="mf">492</span><span class="w"> </span><span class="err">[</span><span class="n">pool</span><span class="o">-</span><span class="mf">1</span><span class="o">-</span><span class="n">thread</span><span class="o">-</span><span class="mf">1</span><span class="err">]</span><span class="w"> </span><span class="n">ERROR</span><span class="w"> </span><span class="n">net</span><span class="mf">.</span><span class="n">sourceforge</span><span class="mf">.</span><span class="n">squirrel_sql</span><span class="mf">.</span><span class="n">fw</span><span class="mf">.</span><span class="n">util</span><span class="mf">.</span><span class="n">TaskThreadPool</span><span class="w"> </span><span class="o">-</span><span class="w"> </span><span class="n">Error</span> <span class="n">java</span><span class="mf">.</span><span class="n">lang</span><span class="mf">.</span><span class="n">IllegalStateException</span><span class="p">:</span><span class="w"> </span><span class="n">Failed</span><span class="w"> </span><span class="n">any</span><span class="w"> </span><span class="n">way</span><span class="w"> </span><span class="kr">to</span><span class="w"> </span><span class="n">execute</span><span class="w"> </span><span class="kr">cont</span><span class="n">ent</span><span class="w"> </span><span class="n">SQL</span><span class="mf">.</span><span class="w"> </span><span class="n">See</span><span class="w"> </span><span class="kr">for</span><span class="n">mer</span><span class="w"> </span><span class="n">warning</span><span class="w"> </span><span class="nb">log</span><span class="w"> </span><span class="n">entries</span><span class="w"> </span><span class="kr">for</span><span class="w"> </span><span class="n">details</span><span class="mf">.</span> <span class="w"> </span><span class="n">at</span><span class="w"> </span><span class="n">net</span><span class="mf">.</span><span class="n">sourceforge</span><span class="mf">.</span><span class="n">squirrel_sql</span><span class="mf">.</span><span class="n">client</span><span class="mf">.</span><span class="n">session</span><span class="mf">.</span><span class="n">mainpanel</span><span class="mf">.</span><span class="n">objecttree</span><span class="mf">.</span><span class="nb">tab</span><span class="n">s</span><span class="mf">.</span><span class="nb">tab</span><span class="n">le</span><span class="mf">.</span><span class="kr">Cont</span><span class="n">entsTab</span><span class="mf">.</span><span class="n">createDataSet</span><span class="p">(</span><span class="kr">Cont</span><span class="n">entsTab</span><span class="mf">.</span><span class="n">java</span><span class="p">:</span><span class="mf">255</span><span class="p">)</span> <span class="w"> </span><span class="n">at</span><span class="w"> </span><span class="n">net</span><span class="mf">.</span><span class="n">sourceforge</span><span class="mf">.</span><span class="n">squirrel_sql</span><span class="mf">.</span><span class="n">client</span><span class="mf">.</span><span class="n">session</span><span class="mf">.</span><span class="n">mainpanel</span><span class="mf">.</span><span class="n">objecttree</span><span class="mf">.</span><span class="nb">tab</span><span class="n">s</span><span class="mf">.</span><span class="n">BaseDataSetTab</span><span class="mf">.</span><span class="n">lambda$refreshComponent$</span><span class="mf">0</span><span class="p">(</span><span class="n">BaseDataSetTab</span><span class="mf">.</span><span class="n">java</span><span class="p">:</span><span class="mf">127</span><span class="p">)</span> <span class="w"> </span><span class="n">at</span><span class="w"> </span><span class="n">net</span><span class="mf">.</span><span class="n">sourceforge</span><span class="mf">.</span><span class="n">squirrel_sql</span><span class="mf">.</span><span class="n">fw</span><span class="mf">.</span><span class="n">util</span><span class="mf">.</span><span class="n">TaskExecuter</span><span class="mf">.</span><span class="kr">run</span><span class="p">(</span><span class="n">TaskExecuter</span><span class="mf">.</span><span class="n">java</span><span class="p">:</span><span class="mf">82</span><span class="p">)</span> <span class="w"> </span><span class="n">at</span><span class="w"> </span><span class="n">java</span><span class="mf">.</span><span class="n">base</span><span class="o">/</span><span class="n">java</span><span class="mf">.</span><span class="n">lang</span><span class="mf">.</span><span class="n">Thread</span><span class="mf">.</span><span class="kr">run</span><span class="p">(</span><span class="n">Thread</span><span class="mf">.</span><span class="n">java</span><span class="p">:</span><span class="mf">1583</span><span class="p">)</span> </code></pre></div> </div>