Menu

#2122 (ok 2.8.2) Invalid default value

2.8.0.2
fixed
1
2013-06-11
2006-04-25
No

Using PHP5 & MySQL 5.0.20. I've noticed several times
I'll be updating a field and it will give me an invalid
default value error. This seems easy to produce, and
it seems to be a PMA bug. To test:

Create any table.
Add a field of any type: Specify 'null' and Default
Value 'NULL'.
Save field.
Modify Field: Change 'null' to 'not null' and delete
the Default Value.
-> Error occurs.

Not null w/ no default should be perfectly legal, so
there's no reason for the error. The problem seems to
be PMA not correctly understanding the desire to remove
the default value.

Discussion

  • Marc Delisle

    Marc Delisle - 2006-05-15
    • assigned_to: nobody --> lem9
     
  • Marc Delisle

    Marc Delisle - 2006-05-15
    • priority: 5 --> 1
    • summary: Invalid default value --> (ok 2.8.2) Invalid default value
    • status: open --> open-fixed
     
  • Marc Delisle

    Marc Delisle - 2006-05-15

    Logged In: YES
    user_id=210714

    fixed for 2.8.2

     
  • Marc Delisle

    Marc Delisle - 2006-06-30
    • status: open-fixed --> closed-fixed
     
  • Michal Čihař

    Michal Čihař - 2013-06-11
    • Status: closed-fixed --> fixed
     
MongoDB Logo MongoDB