← Back to branch summary

~ubuntu-branches/ubuntu/lucid/mysql-dfsg-5.1/lucid-security

« back to all changes in this revision

Viewing changes to mysql-test/suite/engines/funcs/t/in_set_null_boundary_error.test

  • Committer: Package Import Robot
  • Author(s): Marc Deslauriers
  • Date: 2012-02-22 22:33:55 UTC
  • mto: (1.2.1) (37.1.1 lucid-security)
  • mto: This revision was merged to the branch mainline in revision 36.
  • Revision ID: package-import@ubuntu.com-20120222223355-ku1tb4r70osci6v2
Tags: upstream-5.1.61
Import upstream version 5.1.61

Show diffs side-by-side

added added

removed removed

Lines of Context:
mysql-test/suite/engines/funcs/t/in_set_null_boundary_error.test
 
1
SET SQL_MODE="TRADITIONAL,ANSI";
 
2
--disable_warnings
 
3
DROP TABLE IF EXISTS t7;
 
4
--enable_warnings
 
5
CREATE TABLE t7(c1 SET('a','abcdefghijabcdefghijabcdefghijabcdefghijabcdefghij') NULL);
 
6
INSERT INTO t7(c1) VALUES(NULL);
 
7
INSERT INTO t7(c1) VALUES('');
 
8
INSERT INTO t7(c1) VALUES('a');
 
9
INSERT INTO t7(c1) VALUES('abcdefghijabcdefghijabcdefghijabcdefghijabcdefghij');
 
10
--error 1265
 
11
INSERT INTO t7(c1) VALUES('abcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghij');
 
12
INSERT INTO t7(c1) VALUES('a,abcdefghijabcdefghijabcdefghijabcdefghijabcdefghij');
 
13
SELECT * FROM t7;
 
14
SELECT COUNT(c1) AS null_rows FROM t7 WHERE c1 IS NULL;
 
15
DROP TABLE t7;
 
16