File: dsv-prepare.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 (18 lines) | stat: -rw-r--r-- 365 bytes parent folder | download | duplicates (10) 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
 
/*
 * $Id: dsv-prepare.sql,v 1.1 2007/08/09 03:28:36 unsaved Exp $
 *
 * Tests PL 'prepare' command
 */

CREATE TABLE t (i INT, a INT, b INT, c INT);

* N = 4567
* prepare N

INSERT INTO t(i, a, b, c) VALUES (1, ?, 8, 9);

SELECT count(*) FROM t WHERE i = 1 AND a = 4567 AND b= 8 AND c = 9;

*if (*? != 1)
    \q PL prepare command failed
*end if