<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 EDITING Crash on SQL select command or double click on table with non null float field - mysql native connector (mariadb)"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=131712">131712</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>Base EDITING Crash on SQL select command or double click on table with non null float field - mysql native connector (mariadb)
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>6.3.2.2 release
</td>
</tr>
<tr>
<th>Hardware</th>
<td>x86-64 (AMD64)
</td>
</tr>
<tr>
<th>OS</th>
<td>Mac OS X (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>ps@chiltern.org.uk
</td>
</tr></table>
<p>
<div>
<pre>Description:
I have an Libre office Base database file which connects to mariadb on remote
server using mysql (direct) connector.
Most functionality works fine, but there is one table which if I do any of the
following will crash the whole of libreoffice without any recovery facilitate
(straight to OS 'this program as crash - what would you like to do' prompt.
1) Double click on table in table list
2) Right on table and click 'open'
3) Run any SQL select query on that table
Apon reopening Libreoffice it offers you chance to restore, but if you click
start it crashes libreoffice again.
However I can do any of the above on other tables without issue. If I truncate
said table I can do any of the above with out issue. If I make the values the
two float fields 'null' for all rows, I can do any of the above without issue.
Steps to Reproduce:
1.Connect Base to remote mariadb database using mysql (direct) connector
2.create a table with integer key & a float field
3.Open this table by double click on it
4.Create a new entery by adding 1 in the int primary key field.
5.click save on both edit table window and the main database window
6.try to enter a 1 into float field for the entry you've created.
Actual Results:
The 1 is saved to the database ( which you can confirm by connecting to mariadb
via command line, but libreoffice crashes
Expected Results:
Libreoffice shouldn't crash
Reproducible: Always
User Profile Reset: No
Additional Info:
I think this is a bug in the mysql (direct) connector.
I install Libreoffice via brew and the connector came with it, but internet
implies on some distribution is might be an extension.
I also found this which implied it has recently become part of core
libreoffice, hence why I'm posting bug here:
<a href="https://wastack.wordpress.com/2019/02/07/the-new-mysql-driver-in-libreoffice/">https://wastack.wordpress.com/2019/02/07/the-new-mysql-driver-in-libreoffice/</a></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>