<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 - Editing: Firebird: Table editor erroneously wants to change CLOB field to a BLOB field during alter table"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=121553">121553</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>Editing: Firebird: Table editor erroneously wants to change CLOB field to a BLOB field during alter table
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>6.2.0.0.beta1+
</td>
</tr>
<tr>
<th>Hardware</th>
<td>All
</td>
</tr>
<tr>
<th>OS</th>
<td>All
</td>
</tr>
<tr>
<th>Status</th>
<td>UNCONFIRMED
</td>
</tr>
<tr>
<th>Severity</th>
<td>normal
</td>
</tr>
<tr>
<th>Priority</th>
<td>high
</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>drewjensen.inbox@gmail.com
</td>
</tr></table>
<p>
<div>
<pre>Created <span class=""><a href="http://bugs.documentfoundation.org/attachment.cgi?id=146837" name="attach_146837" title="Test file">attachment 146837</a> <a href="http://bugs.documentfoundation.org/attachment.cgi?id=146837&action=edit" title="Test file">[details]</a></span>
Test file
The Firbird support in Base added CLOB to the list recently.
Using the table editor to create a CLOB field in a table works initially.
However if you attempt to alter the table structure subsequently by adding a
new column then during the ALTER TABLE process the CLOB field is first
erroneously reported as needing to be dropped and added to the back of the
table columns, but will change the type of field from CLOB to BLOB.
Steps to reproduce:
1 - download and open the attached test file.
2 - Open the table TABLE2 with the Table Editor
3 - Add a new column after Notes of any name and type
4 - Click on save changes.
Result:
User is prompted (see second attachment for screen shot) that the Notes field
can not be changed (OK) and instead should it be dropped and appended with new
format.
This is because what the application really wants to do is change the column
type to BLOB (a type that was supported with older versions of LO/Firebird when
it did not support CLOB), so if you the user answers yes it does just that
(which looses any data currently in the column for all records) and the user is
now unable to edit, insert, etc any data in the changed field. If the user is
sharp and answers no there is no harm.
Expected result:
The application adds the new column silently.
Setting this to priority 'High' because of the data loss potential.</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>