[Libreoffice-bugs] [Bug 121654] New: New table created by SQL code is not displayed in tables until file is reopened

bugzilla-daemon at bugs.documentfoundation.org bugzilla-daemon at bugs.documentfoundation.org
Fri Nov 23 09:17:33 UTC 2018


https://bugs.documentfoundation.org/show_bug.cgi?id=121654

            Bug ID: 121654
           Summary: New table created by SQL code is not displayed in
                    tables until file is reopened
           Product: LibreOffice
           Version: 6.1.3.2 release
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Base
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: evgeny at kuznetsov.md

Description:
A new table created via SQL instruction (Tools -> SQL...) is not shown in
Tables until database is closed and reloaded again.

Reproduced on:
LibreOffice 6.1.3.2 running on Debian 9 (package version 6.1.3-1~bpo9+2)
64-bit.
LibreOffice 5.3.7.2 running on Windows Vista 32-bit.

Steps to Reproduce:
1. Start LibreOffice Base.
2. Click "Next" without altering anything (creating new HSQLDB).
3. Click "Finish" without altering anything.
4. Use arbitrary filename (i.e. "test.odb") to save.
5. Use Menu: Tools -> SQL...
6. Enter command: CREATE TABLE "test" ("field1" INTEGER, "field2" VARCHAR(5))
7. Click "Execute".
8. Click "Close".
9. Click on "Tables" in the left panel.

Actual Results:
No tables are listed.

Expected Results:
A table named "test" is listed and can be accessed.


Reproducible: Always


User Profile Reset: Yes


OpenGL enabled: Yes

Additional Info:
Closing LibreOffice Base and reopening the file created on Step 4 leads to
expected behaviour.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20181123/687e0615/attachment.html>


More information about the Libreoffice-bugs mailing list