Bug or Feature in MySQL v5.0

Bug or Feature in MySQL v5.0

am 01.02.2010 23:47:37 von Chuck Savage

--000e0cd719f29c2cdc047e91c5a4
Content-Type: text/plain; charset=ISO-8859-1

Before I go reporting this, I'd like to confirm this is a bug.

I have a table, with a field 'timestamp' and of type 'timestamp', without
any trigger code the timestamp changes automatically if I change any field
values. Bug or Feature?

In addition it doesn't set it automatically on an insert.
--
Chuck Savage
http://SeaRisen.com

--000e0cd719f29c2cdc047e91c5a4--

Re: Bug or Feature in MySQL v5.0

am 02.02.2010 04:41:22 von Eric Bergen

The first timestamp has magic properties by default. See:
http://dev.mysql.com/doc/refman/5.0/en/timestamp.html

On Mon, Feb 1, 2010 at 2:47 PM, Chuck Savage wrote:
> Before I go reporting this, I'd like to confirm this is a bug.
>
> I have a table, with a field 'timestamp' and of type 'timestamp', without
> any trigger code the timestamp changes automatically if I change any fiel=
d
> values. =A0Bug or Feature?
>
> In addition it doesn't set it automatically on an insert.
> --
> Chuck Savage
> http://SeaRisen.com
>



--=20
Eric Bergen
eric.bergen@gmail.com
http://www.ebergen.net

--
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe: http://lists.mysql.com/bugs?unsub=3Dgcdmb-bugs@m.gmane.org

Re: Bug or Feature in MySQL v5.0

am 02.02.2010 07:38:06 von Chuck Savage

--000e0cd48496367ae5047e9858d2
Content-Type: text/plain; charset=ISO-8859-1

Thanks for the replies everyone. I learn something every day.

--
Chuck Savage
http://SeaRisen.com

--000e0cd48496367ae5047e9858d2--