← Back to branch summary

~mdcallag/+junk/5.1-map

« back to all changes in this revision

Viewing changes to mysql-test/r/errors.result

  • Committer: msvensson at pilot
  • Date: 2007-04-24 09:11:45 UTC
  • mfrom: (2469.1.106)
  • Revision ID: sp1r-msvensson@pilot.blaudden-20070424091145-10463
Merge pilot.blaudden:/home/msvensson/mysql/my51-m-mysql_upgrade
into  pilot.blaudden:/home/msvensson/mysql/mysql-5.1-maint

Show diffs side-by-side

added added

removed removed

Lines of Context:
mysql-test/r/errors.result
28
28
set sql_mode='traditional';
29
29
create table t1 (a varchar(66000));
30
30
ERROR 42000: Column length too big for column 'a' (max = 65535); use BLOB or TEXT instead
 
31
set sql_mode=default;
 
32
CREATE TABLE t1 (a INT);
 
33
SELECT a FROM t1 WHERE a IN(1, (SELECT IF(1=0,1,2/0)));
 
34
a
 
35
INSERT INTO t1 VALUES(1);
 
36
SELECT a FROM t1 WHERE a IN(1, (SELECT IF(1=0,1,2/0)));
 
37
a
 
38
1
 
39
INSERT INTO t1 VALUES(2),(3);
 
40
SELECT a FROM t1 WHERE a IN(1, (SELECT IF(1=0,1,2/0)));
 
41
a
 
42
1
 
43
DROP TABLE t1;