Bug #23439 mysql is broken in ansi mode
Submitted: 18 Oct 2006 17:54 Modified: 18 Oct 2006 18:45
Reporter: [ name withheld ] Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Server Severity:S2 (Serious)
Version:5.0.26 OS:
Assigned to: CPU Architecture:Any

[18 Oct 2006 17:54] [ name withheld ] 
Description:
--------------------- Mysql == MyShit ---------------------------
Why is mysql myshit ? Because no matter how, no matter when, no matter
what version, mysql always has an insane amount of bugs.

Here's a snippet from /etc/my.cnf
# The MySQL server
[mysqld]
sql-mode    = ANSI,TRADITIONAL,NO_ENGINE_SUBSTITUTION
....

Let's see what happens, shall we ?

Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 4 to server version: 5.0.26-standard-log
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> use test;
Database changed
mysql>  create table sessionmaster ( 
	session_id      varchar(50) primary key,  
	created         timestamp not null, 
	accessed        timestamp not null, 
	is_expired  	bool default 0, 
	username        varchar(255) );

Query OK, 0 rows affected (0.15 sec)

mysql>  create INDEX IDX_sessionmaster_1 ON sessionmaster(username);

ERROR 1067 (42000): Invalid default value for 'accessed'
-----------------------------------------------------------------------

Fuck mysql. I've been using it since 3.x and now I've given up on it,
entirely.

How to repeat:
see above

Suggested fix:
none
[18 Oct 2006 18:45] Sveta Smirnova 
Please do not submit the same bug more than once. An existing bug report already describes this very problem. Even if you feel that your issue is somewhat different, the resolution is likely
to be the same. Because of this, we hope you add your comments to the original bug instead.

Thank you for your interest in MySQL.
[18 Oct 2006 21:30] Timothy Smith 
This bug is duplicate of bug #18834.