<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 - Primary key should default to auto-value when type is integer"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=108057">108057</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>Primary key should default to auto-value when type is integer
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>5.3.3.2 release
</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>enhancement
</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>BridgeportContractor@gmail.com
</td>
</tr></table>
<p>
<div>
<pre>Created <span class=""><a href="http://bugs.documentfoundation.org/attachment.cgi?id=133516" name="attach_133516" title="Screen shot">attachment 133516</a> <a href="http://bugs.documentfoundation.org/attachment.cgi?id=133516&action=edit" title="Screen shot">[details]</a></span>
Screen shot
(Preface: Now that I have Base doing some of the hard things I had hoped it
would do, I plan to submit a number of simple bug/improvement reports and this
is the first. My hope is to take some of the rough edges off for new Base
users. There are some little things that could easily be improved I think.
I'm going to start with the most basic things that could be improved, that
unnecessarily make Base hard to use for the new user.)
1) When creating a new database, and selecting either HSQLDB 1.8 or FireBird,
and then when a new table is created in design mode, and an ID field is created
as the first field, and set to Integer, and then set as the Primary Key, I
think the AutoValue should be automatically set to Yes.
Steps to create this:
Open LibreOffice and from the menu select:
File
New
Database
Create Table In Design View...
Set Field Name to "ID" | Set Field Type to "Integer"
Right click on green arrow left of ID and select "Primary Key"
Result below is AutoValue remains set to "No".
I think AutoValue should be Yes.
While an experienced person might want to insert their own primary key values,
the new user almost surely will want to just have the ID come up working.
But even as an experienced user with 40 years of database experience, I find
that having to set this to Yes, each and every time I create a simple database
for testing purposes is just frustrating and one more unnecessarily click.
We've been building computers to help do our work for us. I think this is
something the software can do to save a step almost all of the time.
It is rare indeed that I have a table that I don't use an AutoValue ID on these
days. In the over 100 tables I now use with base I can only think of 2 or 3
that I use where the primary key is not AutoValue. So yes, it's possible to
have a valid database with AutoValue off. The one I can think of right now is
a small table I have of months, where the ID is the month number. But in all
of the other 100+ tables I have the ID is set to AutoValue=Yes.
Thanks for your consideration of this.</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>