https://bugs.documentfoundation.org/show_bug.cgi?id=157826
Mike Kaganski <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Ever confirmed|0 |1 Status|UNCONFIRMED |NEW --- Comment #1 from Mike Kaganski <[email protected]> --- Repro using Version: 7.6.2.1 (X86_64) / LibreOffice Community Build ID: 56f7684011345957bbf33a7ee678afaf4d2ba333 CPU threads: 12; OS: Windows 10.0 Build 19045; UI render: default; VCL: win Locale: ru-RU (ru_RU); UI: en-US Calc: CL threaded and also using current master; both on Windows 10 Home. A. Install and run MariaDB Server 1. Download a release of MariaDB Server (Windows x86_64) ZIP file from https://mariadb.org/mariadb/all-releases/. Either 11.1.2, or 11.0.3 would do. 2. Unpack the ZIP file into a directory. 3. Start cmd.exe. 4. Execute '<unpack_directory>\bin\mariadb-install-db.exe'; wait for its completion. 5. Execute '<unpack_directory>\bin\mysqld.exe --console'; let it run. B. Create a database and a table 6. Start another cmd.exe. 7. Execute '<unpack_directory>\bin\mysql.exe -h localhost -u root', to start MariaDB shell 8. Execute 'create database tdf_bug;' 9. Execute 'use tdf_bug;' 10. Execute 'create table bug_table (val int);' 11. Execute 'insert into bug_table values (0), (1), (2), (3);' C. Reproduce the bug 12. Create a new Base Database. 13. Select 'Connect to an existing database' -> 'MySQL/MariaDB'; click [Next]. 14. 'Connect directly (using MariaDB C connector)'; click [Next]. 15. Database name: 'tdf_bug'; Server: 'localhost'; port: unchanged (3306); click [Next]. 16. User name: 'root'; keep 'Password required' unchecked; test connection; click [Next]. 17. It is not required to register it to see the bug; Open the database for editing; click [Finish]. 18. Save the ODB file. 19. In the Tables view, collapse the 'sys' list, and expand the 'tdf_bug' list. 20. Double-click 'bug_table'. => The opened table shows the four rows, but all values in the val column are 0. D. Check that the correct data is returned by executing SQL directly. 21. Close the table. 22. Tools->SQL; Command to execute: 'select * from bug_table'; check 'Show output of "select" statements'; press 'Execute'. => Status: '1: Command successfully executed.'; Output: 0, 1, 2, 3, It doesn't matter if you create a primary key or not (the steps avoid that, to have the simplest table possible). -- You are receiving this mail because: You are the assignee for the bug.
