<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 - Firebird: migration: Auto Timestamp in HSQLDB not tranfered to firebird"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=117867">117867</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>Firebird: migration: Auto Timestamp in HSQLDB not tranfered to firebird
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>6.1.0.0.beta1+
</td>
</tr>
<tr>
<th>Hardware</th>
<td>x86-64 (AMD64)
</td>
</tr>
<tr>
<th>OS</th>
<td>Windows (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>rwestein@planet.nl
</td>
</tr></table>
<p>
<div>
<pre>Description:
If in a HSQLDB table a date field is defined to have an auto Timestamp when new
record is created (created by alter table "Table1" alter COLUMN "Date"
TIMESTAMP default now) this will not be transferred to the firebird DB
Steps to Reproduce:
1. Create a table in HSQLDB add date field
2. set 'alter table "Table1" alter COLUMN "Date" TIMESTAMP default now' to
the date field.
3. Create a new record the date should be filled automatically
4. run the migration assistant.
5. create a new record in the migrated db.
Actual Results:
Auto Timestamp setting in the date field is not converted to the firebird table
Expected Results:
Auto Timestamp should work in an migrated DB.
Reproducible: Always
User Profile Reset: No
Additional Info:
User-Agent: Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:60.0) Gecko/20100101
Firefox/60.0</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>