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
Improved comments on the cell-overwrite optimization code.
2018-05-07
D
.
Ric
h
ard H
i
pp
Improved comments on the cell-overwrite optimizatio
n
.
.
.
commit
|
commitdiff
|
tree
2018-05-07
D
.
Ric
h
a
r
d
H
ipp
On an UPDATE, try to overwrite an exi
s
ti
n
g b
t
ree
cell
.
.
.
commit
|
commitdiff
|
tree
2018-05-07
D
.
Richard Hipp
Fix
harml
e
ss compiler warnings a
s
socia
t
ed with the
.
.
.
commit
|
commitdiff
|
tree
2018-05-07
D
.
Richard
Hipp
Fi
x
harmles
s
com
p
iler warnin
g
s in
the cell-overwrite
.
.
.
commit
|
commitdiff
|
tree
2018-05-07
D
.
R
i
c
h
ard Hipp
Backout change [05fee1a21ea39
8
f1e4d6f1cf3] because
.
.
.
commit
|
commitdiff
|
tree
2018-05-05
D
.
Richa
r
d
H
ipp
In an ORDER BY LIMIT, ma
k
e sure the ORDER B
Y
expression
.
.
.
commit
|
commitdiff
|
tree
2018-05-05
D
.
Richard Hipp
Fix a slightly incorrect cor
r
u
p
ti
o
n
d
etectio
n
branc
h
.
.
.
commit
|
commitdiff
|
tree
2018-05-04
D
.
Richard Hipp
Merge enhance
m
ents f
r
om trunk
.
commit
|
commitdiff
|
tree
2018-05-04
D
.
Richard Hipp
Fix
requi
r
ements ma
r
ks
.
N
o
c
o
de changes
.
commit
|
commitdiff
|
tree
2018-05-04
D
.
R
i
c
h
a
r
d Hipp
For the amalgamation-tarb
a
ll, en
a
ble
FTS5
a
nd
JSON1
.
.
.
commit
|
commitdiff
|
tree
2018-05-04
D
.
Richard
H
i
p
p
Make a
separate
limb in the EXPLAIN QUERY PLAN outpu
t
.
.
.
commit
|
commitdiff
|
tree
2018-05-03
D
.
Richa
r
d Hipp
I
n ORDER BY LIMIT qu
e
ries, try to ev
a
luat
e
t
he ORDER
.
.
.
commit
|
commitdiff
|
tree
2018-05-03
D
.
Ri
c
ha
r
d
Hipp
F
ix
a b
r
anch
t
hat has become
u
nrea
c
habl
e
du
e
to recent
.
.
.
commit
|
commitdiff
|
tree
2018-05-03
D
.
Richard Hipp
I
mp
r
o
v
e
d
securi
t
y fo
r
V
A
C
UUM
.
This check-in
combines
.
.
.
commit
|
commitdiff
|
tree
2018-05-03
D
.
Richa
r
d Hipp
Overhaul of EX
P
LAIN
Q
UERY PL
A
N
.
T
he output is now in
.
.
.
commit
|
commitdiff
|
tree
2018-05-03
D
.
Richard
Hipp
Optimiz
a
tio
n
s
to
t
h
e n
e
w E
Q
P framework
.
commit
|
commitdiff
|
tree
2018-05-03
D
.
Richard Hipp
Fix various error han
d
l
ing conditions on the c
e
ll overwrite
.
.
.
commit
|
commitdiff
|
tree
2018-05-03
D
.
Richard Hipp
The BtCursor
.
info fields are only
v
a
l
i
d
i
f
info
.
n
S
ize!=0
.
commit
|
commitdiff
|
tree
2018-05-03
D
.
Ri
c
hard Hipp
A
d
d more corruption check
i
n
g
to
the cell ov
e
rwrite
.
.
.
commit
|
commitdiff
|
tree
2018-05-03
D
.
R
icha
r
d Hipp
Bug fix
e
s in the ove
r
write optimization
.
commit
|
commitdiff
|
tree
2018-05-03
D
.
Richard Hipp
The sql
i
te3
B
t
re
e
Ins
e
rt() routine tries to o
v
erwrit
e
.
.
.
commit
|
commitdiff
|
tree
2018-05-03
D
.
R
i
c
h
a
r
d Hipp
Enhance EXPLAI
N
Q
UERY PLAN to report
the generatio
n
.
.
.
commit
|
commitdiff
|
tree
2018-05-02
D
.
Richard Hipp
Mor
e
t
est case updates
.
Test
s
a
re
a
ll runni
n
g now
.
commit
|
commitdiff
|
tree
2018-05-02
D
.
Ri
c
hard Hipp
Fix test cases so that
t
h
e
y work with t
h
e
n
ew EXPLAIN
.
.
.
commit
|
commitdiff
|
tree
2018-05-02
D
.
Richard Hipp
Improved EQP output
f
o
r
r
e
cu
r
si
v
e CTEs and m
u
l
ti-
v
alue
.
.
.
commit
|
commitdiff
|
tree
2018-05-02
D
.
Richard Hi
p
p
Prevent VA
C
UUM from r
u
n
ning any commands in sq
l
i
te_
m
as
t
er
.
.
.
commit
|
commitdiff
|
tree
2018-05-02
D
.
Richard Hipp
Fix
a dangling-
e
l
se pro
b
le
m
that was causi
n
g r
e
cursive
.
.
.
commit
|
commitdiff
|
tree
2018-05-02
D
.
Richard Hipp
I
m
p
r
o
ve
m
ents
t
o
t
he
E
QP
d
isplay for com
p
ound select
.
.
.
commit
|
commitdiff
|
tree
2018-05-02
D
.
Richard Hipp
Beg
i
n r
e
engin
e
e
r
ing
t
he
E
XPLAIN QUERY PLAN f
u
nction
.
.
.
commit
|
commitdiff
|
tree
2018-05-01
D
.
Richa
r
d Hipp
The
SQL
I
TE_
A
LLOW_SQLIT
E
_MASTER_
I
N
DEX compile-time o
p
t
ion
.
.
.
commit
|
commitdiff
|
tree
2018-04-30
D
.
Richa
r
d Hipp
Def
e
r
l
oa
d
i
ng r
e
sult column
values into re
g
ist
e
rs
on
.
.
.
commit
|
commitdiff
|
tree
2018-04-28
D
.
Richard Hipp
Test cases add
e
d f
o
r
SQLITE_DBCO
N
FIG_RESET_DA
T
ABASE
.
commit
|
commitdiff
|
tree
2018-04-28
D
.
Richard Hipp
Add
t
he
SQLI
T
E
_DB
C
ONFIG_RESE
T
_DATABASE control
f
o
r
.
.
.
commit
|
commitdiff
|
tree
2018-04-28
D
.
Richard Hipp
Add the SQLITE_DBC
O
NFIG_RES
E
T_
D
ATABASE co
n
trol as
a
.
.
.
commit
|
commitdiff
|
tree
2018-04-28
D
.
R
i
ch
a
rd Hipp
Merge
updates
fro
m
trunk
.
commit
|
commitdiff
|
tree
2018-04-28
D
.
R
ichard H
i
pp
Prevent deep
recursio
n
s on n
e
sted
COLLATE op
e
rators
.
commit
|
commitdiff
|
tree
2018-04-28
D
.
Richard
H
i
pp
Fix com
p
ile
r
warnings in F
T
S3
.
commit
|
commitdiff
|
tree
2018-04-28
D
.
Richard Hipp
Add
t
he "
P
R
AGMA
r
eset_dat
a
base=ON|OFF" com
m
and
.
When
.
.
.
commit
|
commitdiff
|
tree
2018-04-27
D
.
Richard Hip
p
Enhance the comments i
n
the templatevtab
.
c
i
mplementation
.
commit
|
commitdiff
|
tree
2018-04-26
D
.
Richard Hipp
The previous fix for ticket [d85fffd6ffe856092ed8da
.
.
.
commit
|
commitdiff
|
tree
2018-04-26
D
.
Richard H
i
pp
Ens
u
re that new
.
* valu
e
s of an UPDA
T
E
d
o not
g
et
c
lo
b
bered
.
.
.
commit
|
commitdiff
|
tree
2018-04-26
D
.
Ri
c
hard Hipp
C
larificat
i
on of
the behavior of a BEFORE UPDATE trig
g
er
.
.
.
commit
|
commitdiff
|
tree
2018-04-26
D
.
Richard Hip
p
Improved VDBE
comment on the OP_Par
a
m opcode
.
No substantia
.
.
.
commit
|
commitdiff
|
tree
2018-04-25
D
.
Ri
c
hard Hipp
A
d
d n
e
w inte
r
f
aces
f
or accessing
t
he
list o
f
S
Q
L keywords
:
commit
|
commitdiff
|
tree
2018-04-25
D
.
Ri
c
hard H
i
pp
Add the new DO and NOTH
I
NG keyw
o
rds t
o
the keywo
r
d
.
.
.
commit
|
commitdiff
|
tree
2018-04-25
D
.
Rich
a
rd Hi
p
p
Add the
n
ew
S
QLITE_S
H
ELL_INIT
_
PROC
c
ompile-t
i
me e
n
try
.
.
.
commit
|
commitdiff
|
tree
2018-04-25
D
.
Ri
c
ha
r
d Hi
p
p
Avoid many u
n
n
e
cessary cal
l
s to sql
i
te3ReadSchema(
.
.
.
commit
|
commitdiff
|
tree
2018-04-25
D
.
Richard Hipp
Add an assert() to ens
u
re
t
h
a
t s
c
h
e
m
a
mutexes ar
e
hel
d
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
Richar
d
Hipp
Do not
a
ttempt to us
e
terms from the
W
HERE clause to
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
Richard Hipp
Update the
e
x
p
e
r
t
e
xtension test
c
ases t
o
account for
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
Richard Hipp
All the OR optimization to proceed even if th
e
OR
i
s
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
R
i
chard Hipp
Add a hy
p
erlink to
the
t
icke
t
on the cod
e
c
omment
for
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
Richard
H
ipp
Enhance t
h
e C
L
I to render EXPLAIN QUE
R
Y PLA
N
usin
g
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
Richa
r
d Hi
p
p
Fi
x
a memory leak following fail
u
re to
o
pen an e
x
ternal
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
Richard
H
ipp
In EXPLAIN QU
E
RY
PLAN output, do not show an EXE
C
UTE
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
Ri
c
hard Hipp
Fix
t
o
chec
k
-in [ca34c2dd20
e
e
07
1
e] -
avoid a NULL point
e
r
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Richard Hipp
Fix a prob
l
em
i
n sqlite3Ex
p
rCompare() associate
d
with
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Richard Hipp
F
i
x a
f
o
r
m
atting
i
s
sue in the TreeView
outp
u
t for bare
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Richard
H
ipp
Add the "
.
imposter off" variant of the "
.
impo
s
ter"
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Richard
H
i
pp
The "
.
s
ele
c
t
trace 0x2000" comman
d
caus
e
s ju
s
t the top
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Richard Hipp
The
"
.
sele
c
ttrace 4" command now shows only a
s
ingle
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
R
ichar
d
Hipp
Do
n
ot
r
est
o
re
t
he iSe
l
ectId value until after the
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Richa
r
d Hipp
In the "
.
sel
e
ctt
r
ace" output, inclu
d
e the EXPLAIN QUE
R
Y
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Ri
c
ha
r
d Hipp
Ensure tha
t
there ar
e
no
bind-param
e
ters or incor
r
ect
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Ric
h
a
rd Hip
p
Fix an u
n
reacha
b
le
b
ranch ass
o
cia
t
ed wit
h
stack overf
l
ow
.
.
.
commit
|
commitdiff
|
tree
2018-04-21
D
.
R
i
chard Hipp
Performance im
p
ro
v
emen
t
s o
n
t
he
main loop of the LEMON
.
.
.
commit
|
commitdiff
|
tree
2018-04-21
D
.
Richard H
i
p
p
En
h
ance LEM
O
N
to
t
rac
k
which sy
m
bols a
c
t
u
ally carry
.
.
.
commit
|
commitdiff
|
tree
2018-04-21
D
.
Ric
h
ard Hipp
Add the %extra_con
t
ex
t
directi
v
e
to lemon, as an al
t
ernative
.
.
.
commit
|
commitdiff
|
tree
2018-04-21
D
.
Richard Hipp
Fix UPSERT so
th
a
t it plays ni
c
ely
w
ith AUTOINC
R
EMENT
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Richard Hip
p
Add the -dDIREC
T
O
RY c
o
mmand-line option to LE
M
O
N
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Richard H
i
p
p
F
ix a harmless co
m
piler wa
r
ning
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Richard Hip
p
Av
o
i
d the
use of st
a
temen
t
jour
n
a
ls on
D
ELETEs of a
.
.
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
R
i
chard Hipp
A
void opening
a
stat
e
men
t
j
o
urnal on si
n
gle
-
r
o
w UPDATEs
.
.
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
R
ichar
d
Hipp
Fix a VD
B
E
comment
o
n
u
psert
.
Prov
i
de an error message
.
.
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Richard H
i
pp
Avoid unnecessary
c
ursor
seeking w
h
en perfor
m
ing an
.
.
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
R
ichard Hi
p
p
Improved VDBE comm
e
nt on UPSERT co
d
e
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Richard
H
ipp
Min
o
r
s
imp
l
ifica
t
io
n
of the previous checkin
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Richard Hipp
Avoi
d
unnec
e
ssary cur
s
or seeks during upsert
p
rocessing
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Rich
a
rd Hipp
Enhance UPSERT so that the UPD
A
TE uses the
same
s
et
.
.
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Richa
r
d H
i
pp
M
inor simpli
f
icati
o
n of the
c
ursor allocation l
o
gic
.
.
.
commit
|
commitdiff
|
tree
2018-04-19
D
.
Richard Hipp
F
ix the handling of
"
PRAGMA count_chang
e
s=O
N
" with
.
.
.
commit
|
commitdiff
|
tree
2018-04-19
D
.
Richard Hipp
Minor simplifi
c
ation to the upsert logic
.
commit
|
commitdiff
|
tree
2018-04-19
D
.
Richard
H
ipp
A
dd t
h
e --upsert
option
t
o
t
h
e
wordcou
n
t test program
.
commit
|
commitdiff
|
tree
2018-04-19
D
.
R
ichard Hipp
Add the ext/misc
/
templa
t
evtab
.
c templa
t
e for virtual
.
.
.
commit
|
commitdiff
|
tree
2018-04-19
D
.
Richa
r
d Hipp
Fix a problem in the new upsert implem
e
nt
i
on, di
s
covered
.
.
.
commit
|
commitdiff
|
tree
2018-04-19
D
.
Richard Hipp
F
i
x t
h
e
t
able n
a
m
e
ali
a
si
n
g on I
N
S
E
RT
s
o t
h
at it occur
s
.
.
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
R
i
chard
H
ipp
Avo
i
d a NULL-poin
t
e
r
dere
f
f
o
l
lowin
g
OO
M
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richard Hipp
Fix a
test case inside distinct
.
test
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Ric
h
ard Hipp
Improve
d
matchi
n
g of COLLATE cla
u
ses within the
O
N
.
.
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richard
H
i
pp
Fix a pr
o
blem in
t
h
e sqlite3Exp
r
Compare() fu
n
ction
.
.
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richard H
i
pp
Add support for Pos
t
greSQL
U
PSERT syntax
and functi
o
nality
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
R
ichard Hip
p
Fix
the build
f
o
r S
Q
LITE_OMIT_UPSERT
commit
|
commitdiff
|
tree
2018-04-18
D
.
R
i
c
hard Hipp
Add
t
he
--sort
e
r
r
ef N option to
th
e
CLI
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richard Hipp
O
m
it some co
d
e
not u
s
e
d with
o
ut SQLI
T
E_ENAB
L
E_SORTER_REFEREN
.
.
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richard Hipp
R
e
move an u
n
used lo
c
al
v
ariable
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
R
i
c
hard Hi
p
p
E
n
han
c
e AL
T
ER TABLE
ADD COLUMN to support "D
E
FAULT
.
.
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Ric
h
a
rd
Hipp
Add c
h
ecks t
o
th
e
CLI t
h
at
i
ssue a warning if SQLi
t
e
.
.
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richar
d
Hipp
Add new testcase() ma
c
r
os
a
nd fix a
b
u
g
tha
t
was re
v
ealed
.
.
.
commit
|
commitdiff
|
tree
2018-04-17
D
.
Richard Hipp
Re
m
ove unreachable bra
n
ches
.
1
0
0% MC/
D
C in T
H
3 now
.
commit
|
commitdiff
|
tree
2018-04-17
D
.
Richard Hipp
Added a comment o
n
the
assert(
)
ad
d
ed to t
h
e
pre
v
i
o
us
.
.
.
commit
|
commitdiff
|
tree
next