1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
|
/*
* $Id: dsv-constcols.sql,v 1.1 2007/08/09 03:28:35 unsaved Exp $
*
* Tests setting column values with *DSV_CONST_COLS
*/
/** This is the default on UNIX.
* Our *.dsv test files are stored as binaries, so this is required
* to run tests on Windows: */
* *DSV_ROW_DELIM = \n
* *DSV_CONST_COLS= d = 2007-05-14 0:00:00 | a = 139
CREATE TABLE t (i INT, a INT, d DATE);
\m dsv-constcols.dsv
SELECT COUNT(*) FROM t WHERE a = 139 AND d = '2007-05-14';
/* The d const value will override the .dsv-specified values. */
*if (*? != 2)
\q Import using constants for int and date columns failed
*end if
DELETE from t;
* *DSV_CONST_COLS=
\m dsv-constcols.dsv
SELECT COUNT(*) FROM t WHERE a IS null AND d IS null;
*if (*? != 1)
\q Failed to reset CONST_COLS behavior (1)
*end if
SELECT COUNT(*) FROM t WHERE a IS null AND d = '2006-12-11';
*if (*? != 1)
\q Failed to reset CONST_COLS behavior (2)
*end if
|
