File: dsv-rejects.sql

package info (click to toggle)
hsqldb1.8.0 1.8.0.10%2Bdfsg-10
  • links: PTS
  • area: main
  • in suites: buster
  • size: 13,432 kB
  • sloc: java: 75,802; xml: 11,392; sql: 1,556; sh: 847; makefile: 57
file content (21 lines) | stat: -rw-r--r-- 584 bytes parent folder | download | duplicates (10) 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
 
/*
 * $Id: dsv-rejects.sql,v 1.1 2007/08/09 03:28:36 unsaved Exp $
 *
 * Tests proper rejection of bad DSV input records
 */

/** 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

CREATE TABLE t (i INT, r REAL, d DATE, t TIMESTAMP, v VARCHAR, b BOOLEAN);

* *DSV_REJECT_REPORT = ${java.io.tmpdir}/sqltoolutst-${user.name}.html
\m dsv-rejects.dsv

SELECT COUNT(*) FROM t;

*if (*? != 2)
    \q Should have imported 2 good DSV records, but imported *{?}
*end if