|
1548.4.60
by Zimin
add rnd_pos test case and some fix in filesystem to make it work. |
1 |
#
|
2 |
# borrowed from embbedded innodb test suite |
|
3 |
#
|
|
4 |
||
5 |
--disable_warnings
|
|
6 |
DROP TABLE IF EXISTS t1; |
|
7 |
--enable_warnings
|
|
8 |
||
|
2088.9.10
by patrick crews
Updates to filesystem_engine and transaction_log tests to allow dbqp + test-run.pl to live together and execute all tests |
9 |
--replace_result $DRIZZLETEST_VARDIR VARDIR
|
10 |
eval CREATE TABLE t1 ( |
|
|
1548.4.60
by Zimin
add rnd_pos test case and some fix in filesystem to make it work. |
11 |
aufnr VARCHAR(12) NOT NULL DEFAULT '', |
12 |
plnfl VARCHAR(6) NOT NULL DEFAULT '', |
|
13 |
vornr VARCHAR(4) NOT NULL DEFAULT '', |
|
14 |
xstatus_vor INT NOT NULL DEFAULT '0' |
|
|
2088.9.10
by patrick crews
Updates to filesystem_engine and transaction_log tests to allow dbqp + test-run.pl to live together and execute all tests |
15 |
) ENGINE=FILESYSTEM,FILE="$DRIZZLETEST_VARDIR/filesystem_ln/rnd_pos.data"; |
|
1548.4.60
by Zimin
add rnd_pos test case and some fix in filesystem to make it work. |
16 |
|
17 |
DELETE FROM t1; |
|
18 |
||
19 |
INSERT INTO t1 VALUES ('40004712','000001','0010',9); |
|
20 |
INSERT INTO t1 VALUES ('40004712','000001','0020',0); |
|
21 |
||
22 |
UPDATE t1 SET t1.xstatus_vor = Greatest(t1.xstatus_vor,1) WHERE t1.aufnr = |
|
23 |
"40004712" AND t1.plnfl = "000001" AND t1.vornr > "0010" ORDER BY t1.vornr |
|
24 |
ASC LIMIT 1; |
|
25 |
||
26 |
SELECT * FROM t1; |
|
27 |
||
28 |
DELETE FROM t1; |
|
29 |
DROP TABLE t1; |