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
|
#
# borrowed from embbedded innodb test suite
#
--disable_warnings
DROP TABLE IF EXISTS t1;
--enable_warnings
--replace_result $DRIZZLETEST_VARDIR VARDIR
eval CREATE TABLE t1 (
aufnr VARCHAR(12) NOT NULL DEFAULT '',
plnfl VARCHAR(6) NOT NULL DEFAULT '',
vornr VARCHAR(4) NOT NULL DEFAULT '',
xstatus_vor INT NOT NULL DEFAULT '0'
) ENGINE=FILESYSTEM,FILE="$DRIZZLETEST_VARDIR/filesystem_ln/rnd_pos.data";
DELETE FROM t1;
INSERT INTO t1 VALUES ('40004712','000001','0010',9);
INSERT INTO t1 VALUES ('40004712','000001','0020',0);
UPDATE t1 SET t1.xstatus_vor = Greatest(t1.xstatus_vor,1) WHERE t1.aufnr =
"40004712" AND t1.plnfl = "000001" AND t1.vornr > "0010" ORDER BY t1.vornr
ASC LIMIT 1;
SELECT * FROM t1;
DELETE FROM t1;
DROP TABLE t1;
|