~ubuntu-branches/ubuntu/maverick/mysql-5.1/maverick-proposed

« back to all changes in this revision

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

  • Committer: Package Import Robot
  • Author(s): Marc Deslauriers
  • Date: 2012-02-22 14:16:05 UTC
  • mto: This revision was merged to the branch mainline in revision 20.
  • Revision ID: package-import@ubuntu.com-20120222141605-nxlu9yzc6attylc2
Tags: upstream-5.1.61
ImportĀ upstreamĀ versionĀ 5.1.61

Show diffs side-by-side

added added

removed removed

Lines of Context:
19
19
SELECT * FROM t1;
20
20
a       b       c       d       e       f
21
21
0                               foo     0000-00-00
 
22
INSERT INTO t1 VALUES(default,default,default,default,default,default);
22
23
SELECT * FROM t1;
23
24
a       b       c       d       e       f
24
25
0                               foo     0000-00-00
 
26
0                               foo     0000-00-00
25
27
INSERT INTO t1 VALUES(0,'abc','def','ghi','bar','1999-12-31');
26
28
SELECT * FROM t1;
27
29
a       b       c       d       e       f
28
30
0                               foo     0000-00-00
 
31
0                               foo     0000-00-00
29
32
0       abc     def     ghi     bar     1999-12-31
30
33
# === insert failures ===
31
34
INSERT INTO t1 VALUES(NULL,'ab','a','b','foo','2007-01-01');