[前][次][番号順一覧][スレッド一覧]

mysql:5761

From: Kazutaka KAMIYA <Kazutaka KAMIYA <kzkamiya@xxxxxxxxxx>>
Date: Tue, 9 Jul 2002 17:35:14 +0900
Subject: [mysql 05761] Timestamp のバグ?

はじめまして、神谷と申します。
簡単なSQLでテストしてみたのですが、
Timestampが勝ってに現在日時に変更するのですが、
これはバグでしょうか?

よろしくお願いします。

mysql> create table bug1 (id int(9) not null, calendar1 timestamp, flag 
int(1));
Query OK, 0 rows affected (0.01 sec)

mysql> select * from bug1;
+----+----------------+------+
| id | calendar1      | flag |
+----+----------------+------+
|  1 | 20000101000000 |    0 |
+----+----------------+------+
1 row in set (0.00 sec)

mysql> update bug1 set flag = 1;
Query OK, 1 row affected (0.00 sec)
Rows matched: 1  Changed: 1  Warnings: 0

mysql> select * from bug1;
+----+----------------+------+
| id | calendar1      | flag |
+----+----------------+------+
|  1 | 20020709172403 |    1 |
+----+----------------+------+
1 row in set (0.00 sec)

mysql> status
--------------
./mysql  Ver 11.16 Distrib 3.23.49, for apple-darwin5.3 (powerpc)

Connection id:          8
Current database:       calendar
Current user:           test@localhost
Current pager:          stdout
Using outfile:          ''
Server version:         3.23.49
Protocol version:       10
Connection:             Localhost via UNIX socket
Client characterset:    sjis
Server characterset:    sjis
UNIX socket:            /tmp/mysql.sock
Uptime:                 35 min 46 sec

Threads: 1  Questions: 51  Slow queries: 0  Opens: 10  Flush tables: 1  
Open tables: 4 Queries per second avg: 0.024
--------------

************************************
Kazutaka KAMIYA
kzkamiya@xxxxxxxxxx
http://www.amtec.co.jp


[前][次][番号順一覧][スレッド一覧]

->    5761 2002-07-09 17:35 [Kazutaka KAMIYA <kzk] Timestamp のバグ?                      
      5762 2002-07-09 17:43 ┗[Kengo Jinno <kengo@x]                                       
      5763 2002-07-09 17:58  ┣[Kazutaka KAMIYA <kzk]                                     
      5774 2002-07-10 09:34  ┗["Shirai,Kaoru" <shir]                                     
      5775 2002-07-11 08:59   ┗[Kazutaka KAMIYA <kzk]