sql_log_bin

[Arindom Dam]

Hello,

Am on mysql v5.0.51a

Why am I not able to see the session variable; sql_log_bin when I do the following? ..

mysql> show session variables like 'sql%';
+-----------------+-------+
| Variable_name | Value |
+-----------------+-------+
| sql_big_selects | ON |
| sql_mode | |
| sql_notes | ON |
| sql_warnings | OFF |
+-----------------+-------+
4 rows in set (0.00 sec)

It does show up when I do this ..

mysql> select @@session.sql_log_bin;
+-----------------------+
| @@session.sql_log_bin |
+-----------------------+
| 1 |
+-----------------------+
1 row in set (0.00 sec)



Thanks.