← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/t/csv_not_null.test

  • Committer: Padraig O'Sullivan
  • Date: 2009-09-18 00:22:38 UTC
  • mto: This revision was merged to the branch mainline in revision 1139.
  • Revision ID: osullivan.padraig@gmail.com-20090918002238-zq7mui4r2yzoidz1
Extracted KeyUse into its own header file and placed it within the
drizzled::optimizer namespace.

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/t/csv_not_null.test
10
10
# Last modified:  2008-01-04
11
11
#-----------------------------------------------------------------------------
12
12
 
 
13
--source include/have_csv.inc
 
14
 
13
15
#############################################################################
14
16
# Testcase csv_not_null.1:  CREATE TEMPORARY TABLE for CSV Engine requires explicit
15
17
#                           NOT NULL for each column
42
44
CREATE TEMPORARY TABLE t1 (a int NOT NULL, b blob NOT NULL, c CHAR(20) NOT NULL, 
43
45
d VARCHAR(20) NOT NULL, e enum('foo','bar') NOT NULL,f DATE NOT NULL) 
44
46
ENGINE = CSV;
45
 
--error ER_NO_DEFAULT_FOR_FIELD
 
47
--error 1364
46
48
INSERT INTO t1 VALUES();
47
49
SELECT * FROM t1;
48
50
 
73
75
 
74
76
 
75
77
CREATE TEMPORARY TABLE t1 (a int NOT NULL, b char(10) NOT NULL) ENGINE = CSV;
76
 
--error ER_NO_DEFAULT_FOR_FIELD
 
78
--error 1364
77
79
INSERT INTO t1 VALUES();
78
80
insert into t1 values (0,"");
79
81
SELECT * FROM t1;