<html>
    <head>
      <base href="https://bugs.documentfoundation.org/">
    </head>
    <body><table border="1" cellspacing="0" cellpadding="8">
        <tr>
          <th>Bug ID</th>
          <td><a class="bz_bug_link 
          bz_status_UNCONFIRMED "
   title="UNCONFIRMED - Base crashes upon entering certain SQL commands"
   href="https://bugs.documentfoundation.org/show_bug.cgi?id=127271">127271</a>
          </td>
        </tr>

        <tr>
          <th>Summary</th>
          <td>Base crashes upon entering certain SQL commands
          </td>
        </tr>

        <tr>
          <th>Product</th>
          <td>LibreOffice
          </td>
        </tr>

        <tr>
          <th>Version</th>
          <td>6.3.0.4 release
          </td>
        </tr>

        <tr>
          <th>Hardware</th>
          <td>x86-64 (AMD64)
          </td>
        </tr>

        <tr>
          <th>OS</th>
          <td>Windows (All)
          </td>
        </tr>

        <tr>
          <th>Status</th>
          <td>UNCONFIRMED
          </td>
        </tr>

        <tr>
          <th>Severity</th>
          <td>normal
          </td>
        </tr>

        <tr>
          <th>Priority</th>
          <td>medium
          </td>
        </tr>

        <tr>
          <th>Component</th>
          <td>Base
          </td>
        </tr>

        <tr>
          <th>Assignee</th>
          <td>libreoffice-bugs@lists.freedesktop.org
          </td>
        </tr>

        <tr>
          <th>Reporter</th>
          <td>fabianofreitas@gmx.com
          </td>
        </tr></table>
      <p>
        <div>
        <pre>Created <span class=""><a href="http://bugs.documentfoundation.org/attachment.cgi?id=153802" name="attach_153802" title="Base crash">attachment 153802</a> <a href="http://bugs.documentfoundation.org/attachment.cgi?id=153802&action=edit" title="Base crash">[details]</a></span>
Base crash

When I enter some SQL statements like:

SELECT PRODUCTID FROM TBLSOURCE EXCEPT SELECT PRODUCTID FROM TBLPRODUCTS

The Base application crashes instantly. The screenshots are attached.

I'm using HSQLDB version 2.5.0 in split-mode. However, when I run simpler
statements like this one:


SELECT PRODUCTID FROM TBLSOURCE WHERE PRODUCTID = 10

it works OK.


Note that in LibreOffice version 6.2.6.2 (x86) this issue *doesn't* occur at
all. All SQL commands that I'm used to running always work flawlessly.


The issue is in:

Version: 6.3.0.4 (x86)
Build ID: 057fc023c990d676a43019934386b85b21a9ee99
CPU threads: 4; OS: Windows 6.3; UI render: default; VCL: win; 
Locale: pt-BR (pt_BR); UI-Language: en-US
Calc: CL</pre>
        </div>
      </p>


      <hr>
      <span>You are receiving this mail because:</span>

      <ul>
          <li>You are the assignee for the bug.</li>
      </ul>
    </body>
</html>