blob: 0476a36f90ffdbcb4ae8d7d362f08750cb1af5fe (
plain)
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
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
|
# 2022-01-20
#
# The author disclaims copyright to this source code. In place of
# a legal notice, here is a blessing:
#
# May you do good and not evil.
# May you find forgiveness for yourself and forgive others.
# May you share freely, never taking more than you give.
#
#***********************************************************************
#
# This file implements tests for sqlite3_vtab_rhs_value() interface.
#
set testdir [file dirname $argv0]
source $testdir/tester.tcl
set testprefix vtabrhs1
ifcapable !vtab {
finish_test
return
}
load_static_extension db qpvtab
# EVIDENCE-OF: R-60223-49197 When the sqlite3_vtab_rhs_value(P,J,V)
# interface is invoked from within the xBestIndex method of a virtual
# table implementation, with P being a copy of the sqlite3_index_info
# object pointer passed into xBestIndex and J being a 0-based index into
# P->aConstraint[], then this routine attempts to set *V to the value
# of the right-hand operand of that constraint if the right-hand operand
# is known.
#
do_execsql_test 1.1 {
SELECT rhs FROM qpvtab
WHERE cn='a'
AND a=12345
} {12345}
do_execsql_test 1.2 {
SELECT rhs FROM qpvtab
WHERE cn='a'
AND a<>4.5
} {4.5}
do_execsql_test 1.3 {
SELECT rhs FROM qpvtab
WHERE cn='a'
AND 'quokka' < a
} {'quokka'}
do_execsql_test 1.4 {
SELECT rhs FROM qpvtab
WHERE cn='a'
AND a IS NULL
} {{}}
do_execsql_test 1.5 {
SELECT rhs FROM qpvtab
WHERE cn='a'
AND a GLOB x'0123'
} {x'0123'}
# EVIDENCE-OF: R-37799-62852 If the right-hand operand is not known,
# then *V is set to a NULL pointer.
#
do_execsql_test 2.1 {
SELECT typeof(rhs) FROM qpvtab WHERE cn='a' AND a=format('abc');
} {null}
do_execsql_test 2.2 {
SELECT typeof(rhs) FROM qpvtab WHERE cn='a' AND a=?2
} {null}
# EVIDENCE-OF: R-14553-25174 When xBestIndex returns, the sqlite3_value
# object returned by sqlite3_vtab_rhs_value() is automatically
# deallocated.
#
# Where this not the case, the following "finish_test" statement would
# report a memory leak.
#
finish_test
|
