<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 - LO base with Firebird: WARNING, when adding a field to a table of type BLOB"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=137801">137801</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>LO base with Firebird: WARNING, when adding a field to a table of type BLOB
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>7.1.0.0.alpha0+ Master
</td>
</tr>
<tr>
<th>Hardware</th>
<td>All
</td>
</tr>
<tr>
<th>OS</th>
<td>Linux (All)
</td>
</tr>
<tr>
<th>Status</th>
<td>UNCONFIRMED
</td>
</tr>
<tr>
<th>Severity</th>
<td>minor
</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>rich.libre@demattio.co.at
</td>
</tr></table>
<p>
<div>
<pre>Description:
in design mode: adding a field (no matter of what type) to a table with a BLOB
field produces a WARNING about the existing BLOB field.
It is possible to initially create the table with the BLOB field in design
mode.
Steps to Reproduce:
1. create a simple table with some fields (I took two)
and save the table and the database
2. add a BLOB field and save the table and the database again
(in my testcase it was the third field "f3")
3. add another field, no matter of what type (in my case it was field "f4")
~~~~~~~~~~~~~~~~~~~~~~~~~~~+
--> the warning comes about the THIRD field, not the newly added one!
keep in mind: I did not try to change the datatype although the error message
below is saying this.
Actual Results:
Error code: 1
firebird_sdbc error:
*unsuccessful metadata update
*ALTER TABLE Table1 failed
*Cannot change datatype for column f3. Changing datatype is not supported for
BLOB or ARRAY columns.
caused by
'ALTER TABLE "Table1" ALTER COLUMN "f3" TYPE BLOB'
/tinderbox/buildslave/source/libo-master/connectivity/source/drivers/firebird/Util.cxx:68
Expected Results:
no warning
Reproducible: Always
User Profile Reset: No
Additional Info:
reproduced also on LO 7.0.3.1
<a href="https://gerrit.libreoffice.org/gitweb?p=core.git;a=log;h=d7547858d014d4cf69878db179d326fc3483e082">https://gerrit.libreoffice.org/gitweb?p=core.git;a=log;h=d7547858d014d4cf69878db179d326fc3483e082</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>