[Libreoffice-bugs] [Bug 108057] New: Primary key should default to auto-value when type is integer

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=108057

            Bug ID: 108057
           Summary: Primary key should default to auto-value when type is
                    integer
           Product: LibreOffice
           Version: 5.3.3.2 release
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: enhancement
          Priority: medium
         Component: Base
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: BridgeportContractor at gmail.com

Created attachment 133516
  --> https://bugs.documentfoundation.org/attachment.cgi?id=133516&action=edit
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.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20170524/d57d7b7d/attachment-0001.html>