repo.or.cz
/
sqlite.git
/
search
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
log
|
graphiclog1
|
graphiclog2
|
commit
|
commitdiff
|
tree
|
refs
|
edit
|
fork
first
·
prev
·
next
Fix an issue with rtreecheck() and auxiliary data columns.
2018-05-16
D
.
Richard Hipp
Fi
x
an is
s
ue with rt
r
eecheck() and au
x
ilia
r
y data columns
.
commit
|
commitdiff
|
tree
2018-05-16
D
.
Richard Hipp
Do n
o
t a
l
low auxiliary
columns in the rtree
t
o interfere
.
.
.
commit
|
commitdiff
|
tree
2018-05-16
D
.
Ri
c
hard Hipp
Fix the OOM issue mentio
n
ed in the pre
v
io
u
s check-in
.
commit
|
commitdiff
|
tree
2018-05-16
D
.
Ri
c
hard H
i
p
p
Initial impl
e
m
e
ntation of
t
he abil
i
t
y
to have
auxiliary
.
.
.
commit
|
commitdiff
|
tree
2018-05-16
D
.
Richard H
i
pp
Enhanc
e
the sqlite3_s
t
r_
n
ew()
i
nterface so that it
.
.
.
commit
|
commitdiff
|
tree
2018-05-16
D
.
R
i
ch
a
rd Hip
p
Correct output for
the fullkey colum
n
o
f
json_each
.
.
.
commit
|
commitdiff
|
tree
2018-05-14
D
.
R
i
chard Hipp
Make more a
g
gressi
v
e use
of automatic ind
e
xes whe
n
.
.
.
commit
|
commitdiff
|
tree
2018-05-14
D
.
Richard Hipp
Convert the sc
h
e
ma creation logi
c
in the rtree extension
.
.
.
commit
|
commitdiff
|
tree
2018-05-14
D
.
Ric
h
ar
d
Hipp
Export
t
he dedu
c
e
D
atabaseType() function
t
h
e
she
l
l
.
.
.
commit
|
commitdiff
|
tree
2018-05-14
D
.
R
i
chard Hipp
Add the -
-
append
option to the
"
.
back
u
p"
command in
.
.
.
commit
|
commitdiff
|
tree
2018-05-12
D
.
Richard Hipp
In the CLI,
a
llow comm
e
n
t line
s
that begin with '#
.
.
.
commit
|
commitdiff
|
tree
2018-05-11
D
.
Richard H
i
pp
In th
e
CLI, return
n
on-zero i
f
there ar
e
errors on
.
.
.
commit
|
commitdiff
|
tree
2018-05-11
D
.
Richar
d
Hi
p
p
Fi
x
a
typo
i
n the help message from
t
he "
.
s
h
a
3sum"
.
.
.
commit
|
commitdiff
|
tree
2018-05-11
D
.
Richard Hipp
Make sure
t
he op
e
n_db
(
) ro
u
tine in the CLI does
not
.
.
.
commit
|
commitdiff
|
tree
2018-05-09
D
.
Richard Hi
p
p
Add 14
n
ew inter
f
a
ces to
t
he loa
d
able extension mechanism
.
commit
|
commitdiff
|
tree
2018-05-09
D
.
Rich
a
rd Hipp
Fix minor problems with
t
he sqlite3_str
interface
.
commit
|
commitdiff
|
tree
2018-05-09
D
.
Richar
d
Hipp
Make the internal dyn
a
mic
string interface available
.
.
.
commit
|
commitdiff
|
tree
2018-05-09
D
.
Ri
c
hard Hipp
Fix a t
y
po
in a comment used for
d
oc
u
men
t
ation
.
No
.
.
.
commit
|
commitdiff
|
tree
2018-05-08
D
.
Richard Hipp
Corr
e
ct
l
y format
the STAT1 and STAT4 con
t
e
n
t
in the
.
.
.
commit
|
commitdiff
|
tree
2018-05-08
D
.
R
ichard Hipp
Fix a harm
l
ess
compiler warning in fuzzch
e
ck
.
Add
.
.
.
commit
|
commitdiff
|
tree
2018-05-08
D
.
Rich
a
rd Hipp
F
u
zz
test cases fo
r
UP
S
ERT
.
commit
|
commitdiff
|
tree
2018-05-07
D
.
Ri
c
hard Hip
p
Activate the
ce
l
l-overw
r
ite optimization for index
.
.
.
commit
|
commitdiff
|
tree
2018-05-07
D
.
Richard Hipp
Impro
v
ed comments on the cel
l
-overwr
i
te o
p
timization
.
.
.
commit
|
commitdiff
|
tree
2018-05-07
D
.
Rich
a
r
d
Hipp
On an UPDATE, try
to overwrite an existing btr
e
e
c
ell
.
.
.
commit
|
commitdiff
|
tree
2018-05-07
D
.
Richard Hipp
F
i
x harm
l
ess compil
e
r warnings a
s
sociated w
i
th th
e
.
.
.
commit
|
commitdiff
|
tree
2018-05-07
D
.
R
ichard Hipp
Fix
h
armless com
p
i
ler warnings
i
n
t
he
c
ell-overwrit
e
.
.
.
commit
|
commitdiff
|
tree
2018-05-07
D
.
R
ichard Hipp
Ba
c
kou
t
cha
n
ge
[
0
5
f
ee1a21ea398f1e4d
6
f1cf3] bec
a
u
s
e
.
.
.
commit
|
commitdiff
|
tree
2018-05-05
D
.
Richard Hipp
In a
n
ORD
E
R BY
LIMIT, make sure the O
R
DE
R
B
Y
e
x
pression
.
.
.
commit
|
commitdiff
|
tree
2018-05-05
D
.
Richard Hi
p
p
Fix a slightly
in
c
orrect
c
o
r
ruption d
e
tect
i
on branch
.
.
.
commit
|
commitdiff
|
tree
2018-05-04
D
.
R
i
c
h
ard
Hi
p
p
Merge enhan
c
eme
n
ts fro
m
tr
u
nk
.
commit
|
commitdiff
|
tree
2018-05-04
D
.
R
ichard Hipp
Fi
x
req
u
irem
e
nts
m
arks
.
No code
c
hang
e
s
.
commit
|
commitdiff
|
tree
2018-05-04
D
.
Ri
c
hard Hi
p
p
For th
e
amalga
m
atio
n
-
t
a
rba
l
l, e
n
abl
e
FTS5 and JSON1
.
.
.
commit
|
commitdiff
|
tree
2018-05-04
D
.
R
ichard Hip
p
Make a separate l
i
m
b in the EXPLAIN QUERY PLAN o
u
tput
.
.
.
commit
|
commitdiff
|
tree
2018-05-03
D
.
Richa
r
d
Hipp
In ORDER BY LIMIT queries, try to evalu
a
te the ORDER
.
.
.
commit
|
commitdiff
|
tree
2018-05-03
D
.
R
i
c
hard Hipp
F
ix
a b
r
a
n
c
h
that has become un
r
eachab
l
e due to re
c
en
t
.
.
.
commit
|
commitdiff
|
tree
2018-05-03
D
.
Rich
a
rd
H
ipp
I
m
proved
security
for
V
ACUUM
.
Th
i
s
c
h
eck-in combines
.
.
.
commit
|
commitdiff
|
tree
2018-05-03
D
.
R
ichar
d
Hipp
Overhaul of EX
P
L
A
IN QUERY PLAN
.
Th
e
outp
u
t
is
n
ow in
.
.
.
commit
|
commitdiff
|
tree
2018-05-03
D
.
R
ic
h
ard Hipp
O
p
timizations to th
e
n
ew EQP framewor
k
.
commit
|
commitdiff
|
tree
2018-05-03
D
.
R
i
c
hard Hipp
F
i
x var
i
ous error ha
n
d
ling conditions on the cell overwrite
.
.
.
commit
|
commitdiff
|
tree
2018-05-03
D
.
Richa
r
d H
i
pp
The BtCu
r
sor
.
info fields
a
re onl
y
v
a
lid if
i
nfo
.
nSiz
e
!=0
.
commit
|
commitdiff
|
tree
2018-05-03
D
.
Richard Hi
p
p
A
d
d
more cor
r
up
t
ion checking to the c
e
ll ove
r
write
.
.
.
commit
|
commitdiff
|
tree
2018-05-03
D
.
Ric
h
ard
Hi
p
p
Bug fixes in the ov
e
rwrite optimiz
a
tion
.
commit
|
commitdiff
|
tree
2018-05-03
D
.
Ri
c
hard
H
ipp
T
he s
q
l
ite3
B
t
r
eeIns
e
r
t()
r
o
ut
i
ne
t
ries to
o
verwrite
.
.
.
commit
|
commitdiff
|
tree
2018-05-03
D
.
R
icha
r
d Hipp
E
n
ha
n
ce EXPLAIN QUERY PLAN t
o
r
e
port the generatio
n
.
.
.
commit
|
commitdiff
|
tree
2018-05-02
D
.
R
i
chard Hipp
More test
case updates
.
T
e
sts
are all run
n
ing
now
.
commit
|
commitdiff
|
tree
2018-05-02
D
.
Richard Hipp
Fix test case
s
so
that they wor
k
with t
h
e
n
ew EXPLAIN
.
.
.
commit
|
commitdiff
|
tree
2018-05-02
D
.
Richard Hipp
I
mprov
e
d
EQ
P
output
f
or recursive CTEs a
n
d multi-v
a
lue
.
.
.
commit
|
commitdiff
|
tree
2018-05-02
D
.
R
ichard Hip
p
Preve
n
t VACUUM from r
u
n
n
ing any commands in
sqlite_ma
s
ter
.
.
.
commit
|
commitdiff
|
tree
2018-05-02
D
.
Richard Hipp
Fix a dangling-e
l
se problem that was ca
u
sing recur
s
ive
.
.
.
commit
|
commitdiff
|
tree
2018-05-02
D
.
Rich
a
rd Hipp
Improvemen
t
s to the E
Q
P display for com
p
ound select
.
.
.
commit
|
commitdiff
|
tree
2018-05-02
D
.
R
icha
r
d Hi
p
p
B
e
gin reengineering the EXPLAIN QUERY PLAN fu
n
ction
.
.
.
commit
|
commitdiff
|
tree
2018-05-01
D
.
Rich
a
rd Hipp
The S
Q
LITE_
A
LLO
W
_SQ
L
I
TE_M
A
STER_INDEX compile-time
o
ption
.
.
.
commit
|
commitdiff
|
tree
2018-04-30
D
.
Richard Hipp
Defer lo
a
ding r
e
sult colum
n
values into re
g
is
t
ers on
.
.
.
commit
|
commitdiff
|
tree
2018-04-28
D
.
Richard H
i
pp
Test case
s
add
e
d f
o
r SQLITE_DBCONFIG_RESET_D
A
TABASE
.
commit
|
commitdiff
|
tree
2018-04-28
D
.
R
i
chard Hipp
Add the SQLITE_DBCON
F
IG_RESE
T
_
DATABASE control for
.
.
.
commit
|
commitdiff
|
tree
2018-04-28
D
.
Rich
a
rd Hipp
Add the
SQLITE_DBCON
F
IG_RES
E
T_DATABASE c
o
n
t
rol as a
.
.
.
commit
|
commitdiff
|
tree
2018-04-28
D
.
Richard Hipp
Merge updates from tru
n
k
.
commit
|
commitdiff
|
tree
2018-04-28
D
.
Richard Hipp
Preven
t
deep recursions on nested COLLATE oper
a
tors
.
commit
|
commitdiff
|
tree
2018-04-28
D
.
Richard H
i
pp
Fix
c
ompiler
warnings in FTS3
.
commit
|
commitdiff
|
tree
2018-04-28
D
.
Richard Hipp
A
d
d the "PRAG
M
A reset_
d
atab
a
se=ON
|
OFF" c
o
mmand
.
When
.
.
.
commit
|
commitdiff
|
tree
2018-04-27
D
.
Richard Hipp
Enhance the comme
n
ts in th
e
t
emplat
e
vta
b
.
c
implementation
.
commit
|
commitdiff
|
tree
2018-04-26
D
.
Ric
h
ard Hi
p
p
The previous f
i
x for ti
c
ket [d85fffd6f
f
e8560
9
2ed8d
a
.
.
.
commit
|
commitdiff
|
tree
2018-04-26
D
.
R
i
chard
Hi
p
p
E
n
sure that ne
w
.
*
values
o
f an UP
D
ATE do not get cl
o
bbere
d
.
.
.
commit
|
commitdiff
|
tree
2018-04-26
D
.
Richard Hipp
Clarif
i
catio
n
of the behavior of a BEFORE UPDA
T
E
t
r
igger
.
.
.
commit
|
commitdiff
|
tree
2018-04-26
D
.
Richard Hipp
Im
p
roved VDBE com
m
e
n
t
on the OP_Param opcode
.
No su
b
stantia
.
.
.
commit
|
commitdiff
|
tree
2018-04-25
D
.
R
i
c
hard
H
i
p
p
Add new interf
a
c
e
s
fo
r
accessi
n
g
the list of
S
QL k
e
ywo
r
ds:
commit
|
commitdiff
|
tree
2018-04-25
D
.
Rich
a
rd Hi
p
p
A
d
d
th
e
new DO an
d
NOTHING ke
y
wor
d
s
t
o
the keyword
.
.
.
commit
|
commitdiff
|
tree
2018-04-25
D
.
Richard
Hi
p
p
Add the
new SQLITE_SHELL_INIT_PROC compile-
t
ime e
n
try
.
.
.
commit
|
commitdiff
|
tree
2018-04-25
D
.
R
i
chard Hipp
Avoid many unnece
s
sary calls to sqlite3ReadSchema(
.
.
.
commit
|
commitdiff
|
tree
2018-04-25
D
.
R
ichard H
i
pp
Add an
a
ssert() to ensure that schema mutex
e
s
a
re
h
el
d
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
Richa
r
d
Hipp
Do not attempt to use ter
m
s
f
rom
t
he
WHERE clause to
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
Richard Hipp
Update the expert
e
xtension test cases to ac
c
oun
t
for
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
Richard Hipp
All the OR
o
p
t
imization to proceed e
v
en
if the OR is
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
Ric
h
ar
d
H
i
pp
Add a hyperlink to the
t
ic
k
et on
the c
o
de
c
omment for
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
Richard H
i
pp
Enhance the CLI to
rend
e
r EXPLAIN
Q
UERY PLAN using
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
Ric
h
ard Hipp
F
i
x a memory leak follow
i
n
g
fai
l
u
re to open an external
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
Rich
a
rd Hipp
In EXPLAIN QUERY
P
LAN outpu
t
, do n
o
t sh
o
w an EXECUTE
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
Ri
c
ha
r
d Hipp
Fix
t
o
check-in [
c
a34
c
2dd2
0
ee0
7
1
e] - av
o
i
d
a NULL pointer
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Ri
c
hard Hipp
Fix a
p
roblem in sqlite3E
x
p
r
Com
p
are() associated with
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Richa
r
d Hip
p
Fix
a form
a
tting
i
ssue in the Tree
V
iew output for bare
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Richard Hipp
Add t
h
e "
.
impo
s
ter o
f
f" variant of the "
.
imposter"
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
R
i
c
hard Hipp
The "
.
selec
t
trace 0x200
0
" command
caus
e
s just the
top
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Richa
r
d H
i
pp
T
h
e
"
.
sele
c
ttrace 4" command n
o
w shows only a single
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Richard Hipp
Do not
r
estore the iSelec
t
Id
va
l
ue until after the
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Richard Hipp
In the "
.
sel
e
cttrace"
output, include the EXPLAIN QUE
R
Y
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Richard Hipp
Ensure th
a
t there are n
o
b
i
nd-pa
r
ameters o
r
inc
o
rr
e
c
t
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Richard Hipp
Fix an unreachable branch
associated with st
a
ck overflow
.
.
.
commit
|
commitdiff
|
tree
2018-04-21
D
.
Ric
h
a
r
d Hipp
Pe
r
fo
r
mance improvements on
t
he main loop
of th
e
LEMO
N
.
.
.
commit
|
commitdiff
|
tree
2018-04-21
D
.
R
i
chard Hipp
Enhance
L
E
M
ON to track whi
c
h symbols actua
l
ly ca
r
ry
.
.
.
commit
|
commitdiff
|
tree
2018-04-21
D
.
R
ichard Hipp
Add th
e
%ext
r
a_cont
e
xt di
r
e
ct
i
ve to lemon,
as
a
n alternative
.
.
.
commit
|
commitdiff
|
tree
2018-04-21
D
.
Richar
d
Hipp
Fix UPSERT so that it
play
s
nicel
y
with AUTOINCREM
E
NT
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Richard Hipp
Ad
d
the -dD
I
RECT
O
RY command-lin
e
option t
o
LEMON
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
R
i
chard
H
ipp
Fix
a
harmle
s
s compiler warning
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
R
i
c
h
ard Hip
p
Avoi
d
the
u
s
e
of s
t
atement jou
r
n
als o
n
DEL
E
T
Es of
a
.
.
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Richa
r
d H
i
pp
A
void opening
a
s
t
a
tem
e
n
t
journal on single-row UPDA
T
Es
.
.
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
R
ichard
Hipp
Fix a VDBE
c
omment on upsert
.
Pro
v
ide an erro
r
messag
e
.
.
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Ric
h
ard Hi
p
p
Avoid u
n
necessary curso
r
seek
i
ng whe
n
per
f
orming
a
n
.
.
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Richar
d
H
ipp
I
mproved VDBE comment
o
n UPSERT code
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Richard Hipp
Minor sim
p
lification
of
t
he previo
u
s check
i
n
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Richard H
i
pp
Avoi
d
unne
c
essary cursor se
e
k
s durin
g
upsert proce
s
sing
.
commit
|
commitdiff
|
tree
next