<html>
    <head>
      <base href="https://bugs.documentfoundation.org/">
    </head>
    <body><span class="vcard"><a class="email" href="mailto:serval2412@yahoo.fr" title="Julien Nabet <serval2412@yahoo.fr>"> <span class="fn">Julien Nabet</span></a>
</span> changed
          <a class="bz_bug_link 
          bz_status_NEW "
   title="NEW - FIREBIRD: Impossible to create an autovalue key when inserting a new table"
   href="https://bugs.documentfoundation.org/show_bug.cgi?id=130345">bug 130345</a>
          <br>
             <table border="1" cellspacing="0" cellpadding="8">
          <tr>
            <th>What</th>
            <th>Removed</th>
            <th>Added</th>
          </tr>

         <tr>
           <td style="text-align:right;">Ever confirmed</td>
           <td>
                
           </td>
           <td>1
           </td>
         </tr>

         <tr>
           <td style="text-align:right;">Status</td>
           <td>UNCONFIRMED
           </td>
           <td>NEW
           </td>
         </tr></table>
      <p>
        <div>
            <b><a class="bz_bug_link 
          bz_status_NEW "
   title="NEW - FIREBIRD: Impossible to create an autovalue key when inserting a new table"
   href="https://bugs.documentfoundation.org/show_bug.cgi?id=130345#c4">Comment # 4</a>
              on <a class="bz_bug_link 
          bz_status_NEW "
   title="NEW - FIREBIRD: Impossible to create an autovalue key when inserting a new table"
   href="https://bugs.documentfoundation.org/show_bug.cgi?id=130345">bug 130345</a>
              from <span class="vcard"><a class="email" href="mailto:serval2412@yahoo.fr" title="Julien Nabet <serval2412@yahoo.fr>"> <span class="fn">Julien Nabet</span></a>
</span></b>
        <pre>According to
<a href="https://opengrok.libreoffice.org/xref/core/connectivity/source/drivers/firebird/Table.cxx?r=80aec8ef#191">https://opengrok.libreoffice.org/xref/core/connectivity/source/drivers/firebird/Table.cxx?r=80aec8ef#191</a>
    188     if (bIsAutoIncrementChanged)
    189     {
    190        ::dbtools::throwSQLException(
    191             "Changing autoincrement property of existing column is not
supported",
    192             ::dbtools::StandardSQLState::FUNCTION_NOT_SUPPORTED,
    193             *this);
    194 
    195     }

It's not supported yet.

More details here about autoincrement field support in the different versions
of Firebird:
<a href="https://stackoverflow.com/questions/34553826/easiest-way-to-create-an-auto-increment-field-in-firebird-database">https://stackoverflow.com/questions/34553826/easiest-way-to-create-an-auto-increment-field-in-firebird-database</a>

(BTW Mark Rotteveel works on "Jaybird" the JDBC connector to Firebird)

Remark: for the moment, LO includes Firebird 3.0.0 package where there's 3.0.5.
I had tried to upgrade it but there were some pb with MacOs part, I abandoned
it.
If someone wants to give it a try or perhaps we prefer waiting for Firebird
4.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>