5
# test for increment/decrement
8
push @INC, "../common/";
15
my $dbh = hstest::init_testdb();
16
my $table = 'hstesttbl';
19
"create table $table (k varchar(30) primary key, v varchar(30) not null) " .
25
my $sth = $dbh->prepare("insert into $table values (?,?)");
26
for (my $i = 0; $i < $tablesize; ++$i) {
29
$sth->execute($k, $v);
33
my $hs = hstest::get_hs_connection(undef, 9999);
34
my $dbname = $hstest::conf{dbname};
35
$hs->open_index(1, $dbname, $table, '', 'k,v');
36
$hs->open_index(2, $dbname, $table, '', 'v');
40
[ 1, '=', [ 'k5' ], 1, 0 ],
41
[ 1, '=', [ 'k6' ], 1, 0 ],
42
[ 1, '=', [ 'k7' ], 1, 0 ],
43
[ 1, '=', [ 'k8' ], 1, 0 ],
49
[ 2, '=', [ 'k5' ], 1, 0, '+', [ 3 ] ],
50
[ 2, '=', [ 'k6' ], 1, 0, '+', [ 12 ] ],
51
[ 2, '=', [ 'k7' ], 1, 0, '+', [ -11 ] ],
52
[ 2, '=', [ 'k8' ], 1, 0, '+', [ -15 ] ],
57
[ 1, '=', [ 'k5' ], 1, 0 ],
58
[ 1, '=', [ 'k6' ], 1, 0 ],
59
[ 1, '=', [ 'k7' ], 1, 0 ],
60
[ 1, '=', [ 'k8' ], 1, 0 ],
66
[ 2, '=', [ 'k5' ], 1, 0, '-', [ 2 ] ],
67
[ 2, '=', [ 'k6' ], 1, 0, '-', [ 24 ] ],
68
[ 2, '=', [ 'k7' ], 1, 0, '-', [ 80 ] ],
69
[ 2, '=', [ 'k8' ], 1, 0, '-', [ -80 ] ],
75
[ 1, '=', [ 'k5' ], 1, 0 ],
76
[ 1, '=', [ 'k6' ], 1, 0 ],
77
[ 1, '=', [ 'k7' ], 1, 0 ],
78
[ 1, '=', [ 'k8' ], 1, 0 ],
84
[ 2, '=', [ 'k5' ], 1, 0, '+?', [ 1 ] ],
85
[ 2, '=', [ 'k5' ], 1, 0, '+?', [ 1 ] ],
86
[ 2, '=', [ 'k5' ], 1, 0, '+?', [ 1 ] ],
87
[ 2, '=', [ 'k5' ], 1, 0, '+?', [ 1 ] ],
88
[ 2, '=', [ 'k5' ], 1, 0, '+?', [ 1 ] ],
89
[ 2, '=', [ 'k5' ], 1, 0, '+?', [ 1 ] ],
90
[ 2, '=', [ 'k5' ], 1, 0, '+?', [ 1 ] ],
91
[ 2, '=', [ 'k5' ], 1, 0, '+?', [ 1 ] ],
92
[ 2, '=', [ 'k5' ], 1, 0, '+?', [ 1 ] ],
97
[ 1, '=', [ 'k5' ], 1, 0 ],
102
my $mess = shift(@_);
104
my $mres = $hs->execute_multi(\@_);
105
for my $res (@$mres) {
106
for my $fld (@$res) {