maria-developers team mailing list archive

[Kristian Nielsen <knielsen@xxxxxxxxxxxxxxx>]

Henrik Ingo <henrik.ingo@xxxxxxxxxxxxx> writes:

> Where else would @@TIMESTAMP be modified? Can a user do that from SQL?

Yes (or @TIMESTAMP at least)..

    mysql> set TIMESTAMP=100;
    Query OK, 0 rows affected (0.00 sec)

    mysql> select now();
    +---------------------+
    | now()               |
    +---------------------+
    | 1970-01-01 01:01:40 | 
    +---------------------+
    1 row in set (0.00 sec)

    mysql> show full processlist;
    +----+------+-----------+------+---------+------------+-------+-----------------------+
    | Id | User | Host      | db   | Command | Time       | State | Info                  |
    +----+------+-----------+------+---------+------------+-------+-----------------------+
    | 15 | root | localhost | test | Query   | 1253605187 | NULL  | show full processlist | 
    +----+------+-----------+------+---------+------------+-------+-----------------------+
    1 row in set (0.00 sec)

> (If so, why???)

Loading mysqlbinlog output, testing, ... and confusing
SHOW FULL PROCESSLIST :-)

Thanks,

 - Kristian.