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 a typo in a comment used for documentation. No code changes.
2018-05-09
D
.
Richard Hipp
Fix
a
t
ypo in a
c
o
m
me
n
t
use
d
for d
o
cumentation
.
No
.
.
.
commit
|
commitdiff
|
tree
2018-05-08
D
.
Richard Hipp
Correctl
y
format
the
STAT1 a
n
d STAT
4
conte
n
t
i
n the
.
.
.
commit
|
commitdiff
|
tree
2018-05-08
D
.
Richard H
i
pp
Fix a harm
l
ess compiler war
n
i
n
g
i
n
f
uzzcheck
.
Add
.
.
.
commit
|
commitdiff
|
tree
2018-05-08
D
.
Ric
h
ard Hipp
Fuzz test cases
f
or U
P
SERT
.
commit
|
commitdiff
|
tree
2018-05-07
D
.
R
ichard
H
ipp
Activate t
h
e cell-overwrite optimi
z
ation for
in
d
ex
.
.
.
commit
|
commitdiff
|
tree
2018-05-07
D
.
Richard Hipp
Improved comments on the cell-overwrite optimizatio
n
.
.
.
commit
|
commitdiff
|
tree
2018-05-07
D
.
Ric
h
a
rd Hipp
On an UPDATE,
t
ry to overwrite an
e
xisting b
t
ree cell
.
.
.
commit
|
commitdiff
|
tree
2018-05-07
D
.
Ri
c
h
ard Hipp
Fix harmles
s
c
omp
i
ler w
a
rnin
g
s
a
sso
c
ia
t
ed with the
.
.
.
commit
|
commitdiff
|
tree
2018-05-07
D
.
Richard Hipp
Fix h
a
rmless compiler
w
arnings
in the cell-overwrite
.
.
.
commit
|
commitdiff
|
tree
2018-05-07
D
.
Richard Hip
p
Backout chan
g
e [05fee1a21ea398f1e
4
d6
f
1cf3] beca
u
se
.
.
.
commit
|
commitdiff
|
tree
2018-05-05
D
.
Richard Hipp
In an ORDER BY LIMIT, make s
u
re the ORDER B
Y
expressio
n
.
.
.
commit
|
commitdiff
|
tree
2018-05-05
D
.
Richard Hipp
Fi
x
a slightly in
c
orrect co
r
r
u
pti
o
n
detectio
n
branch
.
.
.
commit
|
commitdiff
|
tree
2018-05-04
D
.
Richard Hipp
Merge enhancements from tr
u
n
k
.
commit
|
commitdiff
|
tree
2018-05-04
D
.
Ri
c
ha
r
d
H
ipp
Fix
requirements marks
.
No co
d
e
c
hanges
.
commit
|
commitdiff
|
tree
2018-05-04
D
.
Richa
r
d H
i
p
p
For t
h
e
ama
l
ga
m
atio
n
-tarbal
l
, e
n
a
b
le FTS5
a
nd JSON1
.
.
.
commit
|
commitdiff
|
tree
2018-05-04
D
.
Richard Hip
p
M
a
k
e a
separat
e
limb in the
EXPL
A
I
N QUERY
PLA
N
output
.
.
.
commit
|
commitdiff
|
tree
2018-05-03
D
.
Richard H
i
pp
In ORDER B
Y
LIMIT querie
s
, try to
eva
l
uate the ORDER
.
.
.
commit
|
commitdiff
|
tree
2018-05-03
D
.
Richard Hipp
F
i
x a branch
that has become
unr
e
a
c
hable due to recent
.
.
.
commit
|
commitdiff
|
tree
2018-05-03
D
.
Ri
c
hard H
i
pp
Improved
s
e
curity for VA
C
UUM
.
T
h
is check-in combin
e
s
.
.
.
commit
|
commitdiff
|
tree
2018-05-03
D
.
R
i
chard Hi
p
p
Overh
a
ul of
E
XPLAI
N
Q
U
ERY PLAN
.
The output is now in
.
.
.
commit
|
commitdiff
|
tree
2018-05-03
D
.
Rich
a
rd H
i
pp
O
p
timizations to the new EQP framework
.
commit
|
commitdiff
|
tree
2018-05-03
D
.
Richard
H
ip
p
Fix
v
arious
e
rror handling condi
t
ions on
t
he c
e
l
l ove
r
write
.
.
.
commit
|
commitdiff
|
tree
2018-05-03
D
.
Ri
c
hard
H
ipp
Th
e
BtCursor
.
in
f
o fi
e
lds are only valid if info
.
nSi
z
e!=0
.
commit
|
commitdiff
|
tree
2018-05-03
D
.
Richa
r
d
Hipp
Add mor
e
corr
u
ption checking
t
o the c
e
ll overwrite
.
.
.
commit
|
commitdiff
|
tree
2018-05-03
D
.
Richard Hipp
B
u
g fixes in the overwrite opti
m
i
zation
.
commit
|
commitdiff
|
tree
2018-05-03
D
.
Richa
r
d Hipp
The sq
l
ite3
B
treeInsert() routine
tries to
overwrite
.
.
.
commit
|
commitdiff
|
tree
2018-05-03
D
.
Richard Hipp
Enhance EX
P
LAIN
QUE
R
Y P
L
AN to report
the ge
n
eration
.
.
.
commit
|
commitdiff
|
tree
2018-05-02
D
.
Richard
H
ipp
Mo
r
e test
case updates
.
Tests are all
runnin
g
n
o
w
.
commit
|
commitdiff
|
tree
2018-05-02
D
.
Richard
H
ipp
Fix test c
a
ses so that they work with the new EXPLA
I
N
.
.
.
commit
|
commitdiff
|
tree
2018-05-02
D
.
Ri
c
hard Hipp
Improved EQP output
f
o
r
r
e
c
u
r
sive CTEs and
multi-value
.
.
.
commit
|
commitdiff
|
tree
2018-05-02
D
.
Richard Hipp
Prevent VACUUM from r
u
nning an
y
co
m
m
a
nds in sqli
t
e_master
.
.
.
commit
|
commitdiff
|
tree
2018-05-02
D
.
Richar
d
H
ipp
Fix a dangl
i
ng-
e
l
s
e
problem t
h
a
t
wa
s
causing
r
ec
u
rsive
.
.
.
commit
|
commitdiff
|
tree
2018-05-02
D
.
Richard H
i
p
p
I
m
pr
o
vem
e
nts to the
E
QP displ
a
y for
c
omp
o
und select
.
.
.
commit
|
commitdiff
|
tree
2018-05-02
D
.
Richard Hipp
B
eg
i
n reengi
n
eer
i
ng
the EXP
L
AIN QUE
R
Y
P
L
AN fun
c
t
i
o
n
.
.
.
commit
|
commitdiff
|
tree
2018-05-01
D
.
R
i
char
d
Hipp
The SQL
I
TE_ALLOW_S
Q
LITE_MASTER_INDEX compile-tim
e
option
.
.
.
commit
|
commitdiff
|
tree
2018-04-30
D
.
Richard Hipp
Defer l
o
ading
r
e
s
u
lt column valu
e
s int
o
registers on
.
.
.
commit
|
commitdiff
|
tree
2018-04-28
D
.
Richa
r
d Hipp
Test cas
e
s
added
f
o
r
SQLI
T
E_DBCO
N
FIG_RESET_DATABA
S
E
.
commit
|
commitdiff
|
tree
2018-04-28
D
.
Richard Hip
p
Add the SQ
L
ITE_DB
C
ONFI
G
_RESET_DATABA
S
E
control fo
r
.
.
.
commit
|
commitdiff
|
tree
2018-04-28
D
.
Richard Hipp
Add the SQLITE_DBCONFIG_RESET_D
A
TABASE
control as a
.
.
.
commit
|
commitdiff
|
tree
2018-04-28
D
.
R
i
chard Hipp
M
e
rge updates from
t
r
unk
.
commit
|
commitdiff
|
tree
2018-04-28
D
.
Richard Hipp
Prev
e
nt deep recur
s
ions on nested
C
O
L
LAT
E
ope
r
ators
.
commit
|
commitdiff
|
tree
2018-04-28
D
.
Richard Hi
p
p
F
i
x com
p
iler warnings
i
n FTS3
.
commit
|
commitdiff
|
tree
2018-04-28
D
.
R
i
char
d
Hipp
Add the "PRAGMA reset_database=ON
|
OFF" command
.
When
.
.
.
commit
|
commitdiff
|
tree
2018-04-27
D
.
Richard
H
i
p
p
E
n
h
ance the comm
e
n
ts
i
n
the
t
e
mplatevtab
.
c
implementation
.
commit
|
commitdiff
|
tree
2018-04-26
D
.
Ri
c
hard
H
ipp
The previous fi
x
for tic
k
et [
d
85fffd6ffe856092ed8da
.
.
.
commit
|
commitdiff
|
tree
2018-04-26
D
.
R
ichard Hipp
Ens
u
r
e
th
a
t
new
.
* values of an UPDA
T
E
d
o not get clobbered
.
.
.
commit
|
commitdiff
|
tree
2018-04-26
D
.
Rich
a
rd Hipp
Clarification of the beh
a
v
i
or
o
f a BEFORE U
P
DATE trigger
.
.
.
commit
|
commitdiff
|
tree
2018-04-26
D
.
Rich
a
rd Hipp
Im
p
ro
v
ed V
D
B
E comment on the OP_Par
a
m opcod
e
.
N
o subst
a
ntia
.
.
.
commit
|
commitdiff
|
tree
2018-04-25
D
.
Rich
a
rd Hipp
Add new inte
r
faces for accessing
th
e
li
s
t of SQL keywords:
commit
|
commitdiff
|
tree
2018-04-25
D
.
Ric
h
a
rd Hipp
Add the new
DO and N
O
THI
N
G k
e
ywords to
t
he
k
eyword
.
.
.
commit
|
commitdiff
|
tree
2018-04-25
D
.
Richa
r
d Hipp
Add the n
e
w SQL
I
T
E
_
S
HE
L
L_IN
I
T_PROC comp
i
l
e-tim
e
e
n
try
.
.
.
commit
|
commitdiff
|
tree
2018-04-25
D
.
Richa
r
d
H
ipp
Avoid
ma
n
y
unnecessary
c
alls to sqlit
e
3
R
eadSchema(
.
.
.
commit
|
commitdiff
|
tree
2018-04-25
D
.
R
i
ch
a
rd Hipp
A
dd an assert() to ensure tha
t
sc
h
ema mutexes are held
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
R
i
chard
H
ipp
Do not attempt to use terms from the WH
E
RE clause to
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
Richa
r
d Hipp
Up
d
ate the
expert exten
s
ion test cases to a
c
coun
t
for
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
Richard
H
ipp
All the
O
R op
t
imizat
i
o
n
to proc
e
ed e
v
en
i
f the OR
is
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
Richard Hipp
Add a
h
ype
r
li
n
k to th
e
ticket o
n
the code comment fo
r
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
Richard Hipp
Enhance the CLI to render EXPL
A
IN
Q
UERY PLAN us
i
ng
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
Richard Hipp
Fix a memo
r
y le
a
k follo
w
ing f
a
ilure to op
e
n an external
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
Richard Hipp
In EXPLA
I
N QUERY PLAN outp
u
t,
d
o
not show
an
EXECUTE
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
Richard Hipp
Fix
to check-in [ca3
4
c2dd
2
0ee071
e
]
- avoid a NU
L
L
po
i
nter
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Richard Hi
p
p
Fix a problem in s
q
l
i
te
3
ExprCompare() ass
o
ciated with
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Ri
c
hard Hipp
Fix a
f
ormatting iss
u
e in the TreeView output fo
r
bare
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Richard Hip
p
A
d
d the "
.
impo
s
ter off" varian
t
o
f
t
h
e "
.
imposter
"
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
R
i
chard Hi
p
p
The "
.
se
l
ecttra
c
e 0x2
0
00" comm
a
n
d ca
u
ses just the top
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Richard Hi
p
p
The "
.
s
ele
c
ttrace
4
" command now
s
h
ows
only a
s
ing
l
e
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
R
ichard Hi
p
p
Do not rest
o
r
e the iS
e
lectId value until after the
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Richar
d
H
ip
p
In the "
.
sel
e
cttrace"
o
u
t
put
,
include the EXPLA
I
N QUER
Y
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Richard H
i
pp
E
nsure that
t
her
e
are no bind-parameters or incor
r
e
c
t
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Richard Hipp
Fix an unreacha
b
le br
a
nc
h
associate
d
wi
t
h
stack ov
e
rflow
.
.
.
commit
|
commitdiff
|
tree
2018-04-21
D
.
Richard Hip
p
P
er
f
orma
n
ce impr
o
vements
o
n the main loo
p
o
f the LEMO
N
.
.
.
commit
|
commitdiff
|
tree
2018-04-21
D
.
Richard Hip
p
Enhanc
e
LEMON
t
o track
w
hich sym
b
ols actually carr
y
.
.
.
commit
|
commitdiff
|
tree
2018-04-21
D
.
Richard
H
ip
p
Add
t
he %extr
a
_context dir
e
c
t
ive to lemo
n
, as a
n
a
l
ternative
.
.
.
commit
|
commitdiff
|
tree
2018-04-21
D
.
Ri
c
h
a
rd Hipp
Fix
UPSERT so th
a
t
i
t
p
lays nicely
w
i
th AUTOINCREME
N
T
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Richard
H
ipp
Add th
e
-dDIRECTORY comman
d
-
l
ine
o
ption
to LEMON
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Richard H
i
pp
Fix a
harmless compiler warnin
g
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Richard Hi
p
p
A
vo
i
d the use of
state
m
ent journals
on DELETEs of a
.
.
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Richard Hipp
Avoid openi
n
g
a sta
t
ement jour
n
al on
s
i
ngle-
r
ow UPDATEs
.
.
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Richard Hipp
Fix
a
VDBE comment on upsert
.
P
r
ovi
d
e an err
o
r
m
essag
e
.
.
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Richard H
i
pp
Av
o
i
d
u
nnecessary curso
r
seeking when p
e
rform
i
ng a
n
.
.
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Ri
c
hard
H
ipp
Improved
V
DBE comment on UPSERT
code
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
R
i
c
h
a
r
d Hipp
Minor simplification of
t
he previous checkin
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
R
i
chard Hi
p
p
Avoid unne
c
essary c
u
rsor seeks
d
uring upsert processing
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
R
ichar
d
Hip
p
Enhance UPSERT so that
the UPDATE u
s
es
the
s
ame set
.
.
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
R
i
c
h
ard Hipp
Minor si
m
p
l
if
i
cation
o
f
the curso
r
allocat
i
o
n logi
c
.
.
.
commit
|
commitdiff
|
tree
2018-04-19
D
.
Richa
r
d
Hipp
Fix the hand
l
ing of "P
R
AGMA count_chang
e
s
=ON" wi
t
h
.
.
.
commit
|
commitdiff
|
tree
2018-04-19
D
.
Ric
h
ard H
i
pp
Minor simpl
i
f
i
cation to the
up
s
ert lo
g
ic
.
commit
|
commitdiff
|
tree
2018-04-19
D
.
R
ichard
H
ipp
Add the --upsert option to the wordcount test program
.
commit
|
commitdiff
|
tree
2018-04-19
D
.
Richar
d
H
ipp
Add
the ext/misc/templatevtab
.
c
template for virtual
.
.
.
commit
|
commitdiff
|
tree
2018-04-19
D
.
Richard Hip
p
Fix a
pro
b
le
m
in
th
e
new upsert implementi
o
n, disc
o
v
e
r
ed
.
.
.
commit
|
commitdiff
|
tree
2018-04-19
D
.
Rich
a
rd Hi
p
p
Fix the
t
able name
a
l
i
a
s
ing on INSERT
s
o th
a
t i
t
oc
c
urs
.
.
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richard Hipp
Avoid a
N
ULL-pointer d
e
re
f
fo
l
lowing OOM
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richard H
i
pp
Fix
a
te
s
t case
i
nside distinct
.
test
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Ri
c
ha
r
d Hipp
Impro
v
ed match
i
ng of
COLLAT
E
clauses
w
ithin th
e
ON
.
.
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richard Hipp
Fix a prob
l
em
i
n the sqlite3ExprCom
p
are() fu
n
ction
.
.
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richard Hi
p
p
Ad
d
support for P
o
stgreSQL
U
PSERT
s
ynta
x
and f
u
nct
i
o
n
a
l
ity
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Ric
h
ard Hip
p
Fix the bu
i
ld f
o
r SQLITE_OMIT_UPSERT
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richard Hipp
Add the
-
-so
r
ter
r
ef N option to t
h
e CLI
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richard Hipp
O
m
it s
o
me
code not used
w
i
t
hout SQLI
T
E_ENABLE_SORTER
_
R
EFE
R
EN
.
.
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richard Hipp
R
e
move an unused local var
i
able
.
commit
|
commitdiff
|
tree
next