#716 (ok 4.0) Set auto_increment column to 0

closed-fixed
Marc Delisle
1
2013-05-09
2012-01-28
Eric Krona
No

Set auto_increment column to 0 when selecting any of the insert options in the submit_type dropdown.

Solution for feature req ID: 3480477
https://sourceforge.net/tracker/?func=detail&aid=3480477&group_id=23067&atid=377411

Discussion

  • Marc Delisle
    Marc Delisle
    2012-01-29

    Thanks for your patch.

    It works well when editing; however, when inserting, there is one unpleasant effect: I enter a primary key value, then change the selector to "insert as new row and ignore errors" and I lose the value I typed.

     
  • Marc Delisle
    Marc Delisle
    2012-01-29

    • status: open --> pending
     
  • Eric Krona
    Eric Krona
    2012-01-29

    • status: pending --> open
     
  • Eric Krona
    Eric Krona
    2012-01-29

    Added new patch, the one names 0002(!) is the latest one, try that instead.

     
  • Marc Delisle
    Marc Delisle
    2012-01-30

    • assigned_to: nobody --> lem9
     
  • Marc Delisle
    Marc Delisle
    2012-01-30

    Merged, thanks. See my commit 7b5c5f902eb1f0f0a17d5193459727c1abb7fa77 for minor code cleanup.

    Also, it does not work in the "with selected... change" dialog so it could be improved.

     
  • Marc Delisle
    Marc Delisle
    2012-01-30

    • priority: 5 --> 1
    • summary: Set auto_increment column to 0 --> (ok 3.6.0) Set auto_increment column to 0
    • status: open --> open-accepted
     
  • Eric Krona
    Eric Krona
    2012-02-04

    See latest patch, with_selected_auto_increment_auto_0_20120204_v2.patch which makes it work with the "with-selected...change"-dialog. A bit better and cleaner code as well.

     
  • Marc Delisle
    Marc Delisle
    2012-02-08

    Eric,
    with latest patch applied on current master, I have this problem
    1. browse a table
    2. click on edit for a row
    3. choose "insert as new row": the PK is not set to 0

     
  • Marc Delisle
    Marc Delisle
    2012-02-13

    • summary: (ok 3.6.0) Set auto_increment column to 0 --> (ok 4.0.0) Set auto_increment column to 0
     
  • Marc Delisle
    Marc Delisle
    2012-02-13

    • summary: (ok 4.0.0) Set auto_increment column to 0 --> (ok 4.0) Set auto_increment column to 0
     
  • Michal Čihař
    Michal Čihař
    2013-05-09

    • Status: open-accepted --> closed-fixed