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 harmless compiler warning in fuzzcheck. Add new OSSFuzz test cases
2018-05-08
D
.
Rich
a
rd Hipp
F
i
x a harmle
s
s compile
r
w
a
rning in fuzzch
e
ck
.
Add
.
.
.
commit
|
commitdiff
|
tree
2018-05-08
D
.
Ri
c
hard Hipp
Fuzz test c
a
ses for U
P
SERT
.
commit
|
commitdiff
|
tree
2018-05-07
D
.
R
i
chard Hipp
Activate t
h
e
c
e
l
l-overw
r
ite
o
ptimization for index
.
.
.
commit
|
commitdiff
|
tree
2018-05-07
D
.
Ric
h
ard Hipp
Improved commen
t
s on
t
he cell-overwrite opt
i
mi
z
atio
n
.
.
.
commit
|
commitdiff
|
tree
2018-05-07
D
.
Ri
c
hard Hi
p
p
O
n an UPDATE, try
t
o over
w
rite an existi
n
g
b
t
ree cell
.
.
.
commit
|
commitdiff
|
tree
2018-05-07
D
.
Richard Hipp
Fix harmless
compile
r
w
a
r
n
ings associated with
t
h
e
.
.
.
commit
|
commitdiff
|
tree
2018-05-07
D
.
R
i
c
h
ard Hipp
Fix harmles
s
compiler warnings in the c
e
ll-overwrite
.
.
.
commit
|
commitdiff
|
tree
2018-05-07
D
.
Richard
Hipp
Backout
ch
a
ng
e
[05fee1a21ea398f1e
4
d6f1c
f
3] because
.
.
.
commit
|
commitdiff
|
tree
2018-05-05
D
.
Rich
a
rd Hipp
I
n
an
ORDER B
Y
LIM
I
T,
m
a
k
e
sure the ORDER BY expression
.
.
.
commit
|
commitdiff
|
tree
2018-05-05
D
.
Richa
r
d
Hipp
Fix a s
l
ightly i
n
co
r
rect corrup
t
ion de
t
e
ction
b
ra
n
ch
.
.
.
commit
|
commitdiff
|
tree
2018-05-04
D
.
Ri
c
har
d
Hip
p
Merge enhancement
s
from
t
runk
.
commit
|
commitdiff
|
tree
2018-05-04
D
.
Richard Hipp
Fi
x
r
e
quir
e
men
t
s
mar
k
s
.
No
c
ode changes
.
commit
|
commitdiff
|
tree
2018-05-04
D
.
R
i
chard Hipp
For
the ama
l
gamation
-
tar
b
all, enable F
T
S5
a
nd
JSON1
.
.
.
commit
|
commitdiff
|
tree
2018-05-04
D
.
Richard Hipp
Make a separate limb in th
e
EXP
L
AIN QUERY PLAN output
.
.
.
commit
|
commitdiff
|
tree
2018-05-03
D
.
Ri
c
har
d
Hipp
In ORDE
R
B
Y
LIMIT queries, try to evaluate the ORDER
.
.
.
commit
|
commitdiff
|
tree
2018-05-03
D
.
Richa
r
d
H
ipp
F
ix
a
branch that has be
c
o
me unreachable
d
ue to
recent
.
.
.
commit
|
commitdiff
|
tree
2018-05-03
D
.
Richard H
i
pp
Impro
v
ed sec
u
rity for
VACUUM
.
This check-i
n
com
b
ines
.
.
.
commit
|
commitdiff
|
tree
2018-05-03
D
.
Richard Hipp
Overhaul of EXPL
A
IN QUERY P
L
AN
.
The output is now i
n
.
.
.
commit
|
commitdiff
|
tree
2018-05-03
D
.
Richard
H
ipp
Optimization
s
t
o
t
he new EQP framework
.
commit
|
commitdiff
|
tree
2018-05-03
D
.
Richard
H
ipp
Fix
various error handling
c
onditions on the cell ov
e
rwrite
.
.
.
commit
|
commitdiff
|
tree
2018-05-03
D
.
R
ichard Hipp
The B
t
Cursor
.
info fields a
r
e only
v
alid if info
.
nSize!=0
.
commit
|
commitdiff
|
tree
2018-05-03
D
.
Richa
r
d Hipp
Add more co
r
ruption checking to
t
he ce
l
l
o
verwrite
.
.
.
commit
|
commitdiff
|
tree
2018-05-03
D
.
Richard
H
ipp
Bug f
i
xe
s
in the overwrite optimiza
t
io
n
.
commit
|
commitdiff
|
tree
2018-05-03
D
.
Ric
h
ar
d
H
ipp
T
he sqlite3BtreeInsert() routine tries to overwrite
.
.
.
commit
|
commitdiff
|
tree
2018-05-03
D
.
Richard Hipp
Enhance EXPLAIN QUERY PLAN
t
o
report the generat
i
on
.
.
.
commit
|
commitdiff
|
tree
2018-05-02
D
.
Richard Hipp
More test case upd
a
tes
.
Tests ar
e
al
l
runn
i
ng now
.
commit
|
commitdiff
|
tree
2018-05-02
D
.
R
i
chard Hipp
F
i
x test cases
so that they work
w
i
t
h the new EXPLA
I
N
.
.
.
commit
|
commitdiff
|
tree
2018-05-02
D
.
R
ichard Hipp
Improved EQP outpu
t
for recu
r
sive CTEs
a
nd multi-value
.
.
.
commit
|
commitdiff
|
tree
2018-05-02
D
.
Richar
d
Hipp
Prevent VACUUM f
r
om run
n
ing any commands in sqlit
e
_m
a
s
t
er
.
.
.
commit
|
commitdiff
|
tree
2018-05-02
D
.
Richard Hipp
F
ix a dangling-else
p
roblem that was c
a
using recu
r
s
i
ve
.
.
.
commit
|
commitdiff
|
tree
2018-05-02
D
.
Richard Hipp
Improv
e
men
t
s to the EQP display for compound select
.
.
.
commit
|
commitdiff
|
tree
2018-05-02
D
.
Richard Hipp
Begin reengineeri
n
g t
h
e EXPLAIN QUE
R
Y
P
L
AN funct
i
on
.
.
.
commit
|
commitdiff
|
tree
2018-05-01
D
.
R
i
c
h
ard
Hipp
The SQLITE_AL
L
OW_SQL
I
TE
_
MASTER_INDEX com
p
i
l
e-
t
i
m
e opti
o
n
.
.
.
commit
|
commitdiff
|
tree
2018-04-30
D
.
Richard Hipp
Defer
loading
r
esult c
o
lum
n
value
s
int
o
reg
i
ster
s
on
.
.
.
commit
|
commitdiff
|
tree
2018-04-28
D
.
Richard Hipp
Te
s
t c
a
ses
a
dded for
S
QLITE
_
D
B
CONFI
G
_RESET
_
DATABASE
.
commit
|
commitdiff
|
tree
2018-04-28
D
.
R
i
c
ha
r
d Hi
p
p
A
d
d
th
e
SQLI
T
E_DBCONF
I
G_
R
ESET_DATABASE con
t
rol for
.
.
.
commit
|
commitdiff
|
tree
2018-04-28
D
.
Ric
h
ard Hip
p
A
dd
the
S
QLITE_DBCONFIG
_
RESET
_
DATABASE co
n
t
r
ol
a
s
a
.
.
.
commit
|
commitdiff
|
tree
2018-04-28
D
.
R
i
c
hard Hipp
Merge updates from t
r
unk
.
commit
|
commitdiff
|
tree
2018-04-28
D
.
Richard
H
i
p
p
Pre
v
ent deep recursions on
n
e
sted CO
L
LATE op
e
r
a
tors
.
commit
|
commitdiff
|
tree
2018-04-28
D
.
R
i
c
h
a
rd
H
ipp
Fix compile
r
warnings in FT
S
3
.
commit
|
commitdiff
|
tree
2018-04-28
D
.
R
ichard Hipp
Ad
d
the "PRA
G
MA r
e
set_d
a
t
abase=ON|OFF" com
m
a
nd
.
When
.
.
.
commit
|
commitdiff
|
tree
2018-04-27
D
.
Ric
h
ard Hi
p
p
Enh
a
nce the comments in the t
e
mpla
t
evtab
.
c implem
e
n
tation
.
commit
|
commitdiff
|
tree
2018-04-26
D
.
Richa
r
d Hipp
The prev
i
ous fi
x
for ticke
t
[d85fffd6ffe856092ed8da
.
.
.
commit
|
commitdiff
|
tree
2018-04-26
D
.
Richard Hipp
Ensure
that new
.
* values of an UPDATE do not
get
c
l
obbered
.
.
.
commit
|
commitdiff
|
tree
2018-04-26
D
.
R
ichard Hipp
Clarificat
i
on of the behavi
o
r o
f
a BEFORE UPDATE trigger
.
.
.
commit
|
commitdiff
|
tree
2018-04-26
D
.
Ri
c
h
a
rd Hipp
Improved VDBE
comment on the OP
_
Param opc
o
de
.
No
s
ub
s
tanti
a
.
.
.
commit
|
commitdiff
|
tree
2018-04-25
D
.
Richard Hipp
A
dd
new
i
n
t
er
f
aces for
a
c
cessing t
h
e l
i
st of SQL k
e
y
w
ords:
commit
|
commitdiff
|
tree
2018-04-25
D
.
Richard Hipp
Ad
d
th
e
new
D
O and
NOTHING keywords to th
e
keyw
o
rd
.
.
.
commit
|
commitdiff
|
tree
2018-04-25
D
.
Richard Hip
p
Add the new SQLITE_
S
HELL_I
N
IT_PRO
C
c
ompile-t
i
me
e
ntry
.
.
.
commit
|
commitdiff
|
tree
2018-04-25
D
.
Richard
H
ipp
Avoid ma
n
y
unne
c
essary
calls
to
sqlite3ReadS
c
hema(
.
.
.
commit
|
commitdiff
|
tree
2018-04-25
D
.
Richard Hipp
Add an
assert() to ensure
t
hat schema
mutexes
a
re held
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
R
i
chard Hi
p
p
Do
not a
t
t
e
mpt to use terms f
r
o
m
the WHERE clause t
o
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
Richard Hi
p
p
U
p
date t
h
e
exp
e
rt e
x
t
ens
i
o
n
test cases to accou
n
t for
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
Richard H
i
pp
All the O
R
op
t
imi
z
ation to
p
r
ocee
d
ev
e
n
i
f the
OR is
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
Ric
h
ard Hipp
Add a hyperlin
k
to
t
he tick
e
t o
n
the cod
e
commen
t
for
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
Richa
r
d
Hipp
Enhance t
h
e
CLI to r
e
n
der
EXPLAI
N
QUERY
P
L
AN
u
sing
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
Richard Hipp
Fix a memory leak fo
l
lowing failure to o
p
en an external
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
R
i
c
h
ard
Hipp
In EXPLAIN Q
U
ERY P
L
AN outpu
t
, do not
s
how an
E
XECUT
E
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
Richard Hipp
Fix t
o
check-in [
c
a
3
4c2dd20ee
0
71e] - avoid a NULL pointer
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
R
ichar
d
Hipp
Fix
a p
r
obl
e
m
in
sqlite3ExprCompare() associated with
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Richard Hip
p
F
i
x a
fo
r
matting issue i
n
the TreeView o
u
tput fo
r
bare
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Richard Hipp
Add the "
.
impo
s
ter
o
ff" vari
a
n
t
of
the "
.
imposter"
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Richard Hipp
T
h
e "
.
s
e
lecttr
a
ce 0x
2
000" comm
a
nd
c
au
s
es just the top
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Richard H
i
pp
The
"
.
s
e
lecttr
a
c
e
4" command n
o
w shows
o
nl
y
a
single
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Richard Hipp
D
o
n
ot re
s
tore the iSe
l
ec
t
Id value until after the
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Richard
H
ip
p
I
n the "
.
selecttrace" ou
t
p
ut, include the EXPLAIN Q
U
ER
Y
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Richard Hipp
E
n
sure that there
a
re no bind-paramete
r
s or incorrect
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Richard Hipp
F
ix an unreachab
l
e bra
n
c
h asso
c
i
a
ted w
i
th st
a
ck o
v
erflow
.
.
.
commit
|
commitdiff
|
tree
2018-04-21
D
.
Richard
H
ipp
Perfo
r
mance
i
mprovements o
n
the
m
ain loop o
f
t
he LEMON
.
.
.
commit
|
commitdiff
|
tree
2018-04-21
D
.
Richard Hipp
Enhance LEMON to
t
rack
which symbols
actually
ca
r
ry
.
.
.
commit
|
commitdiff
|
tree
2018-04-21
D
.
Richard Hipp
Add the %extra_co
n
text
directive
t
o
lemon, as an alt
e
rnative
.
.
.
commit
|
commitdiff
|
tree
2018-04-21
D
.
Rich
a
rd Hipp
F
ix UPS
E
R
T so
t
hat it plays nicely with AUTOIN
C
REMENT
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Richard Hipp
Add the
-dDI
R
ECTOR
Y
com
m
and-line op
t
i
o
n
to LEMON
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Richard
H
ipp
Fix a harmle
s
s compil
e
r
warn
i
n
g
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Richa
r
d
H
ipp
Avoid the use of stat
e
men
t
j
ournals on DE
L
ETEs of a
.
.
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Ri
c
hard Hipp
A
v
oi
d
opening
a
statement
jo
u
rn
a
l on
s
i
ngle-
r
ow UPDATEs
.
.
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
R
ichard Hipp
Fix a VDBE comment on u
p
sert
.
Pro
v
id
e
an error message
.
.
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Ric
h
ard
Hipp
A
v
o
i
d
unnec
e
ssary cu
r
sor seeking when
performing an
.
.
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Richard
H
ipp
Improved VDBE comment on UPSERT c
o
de
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Richard Hipp
Minor
s
implificati
o
n of the pr
e
vious checkin
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Richard
H
ipp
Av
o
id
u
nnecessary cursor seeks
d
uri
n
g up
s
ert processing
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
R
ichard Hipp
Enha
n
ce UPSERT so that t
h
e UPDA
T
E u
s
e
s th
e
same set
.
.
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Richard
H
ipp
M
i
nor
simpl
i
ficatio
n
of
the curso
r
all
o
catio
n
lo
g
ic
.
.
.
commit
|
commitdiff
|
tree
2018-04-19
D
.
Richa
r
d Hipp
Fix the hand
l
ing of
"
PRAGMA
c
ou
n
t_changes=ON" with
.
.
.
commit
|
commitdiff
|
tree
2018-04-19
D
.
R
i
c
h
ard Hipp
Mi
n
o
r
simplificatio
n
to t
h
e
u
p
sert logic
.
commit
|
commitdiff
|
tree
2018-04-19
D
.
Richard Hipp
Add the --
u
psert o
p
tion to the wordc
o
unt
t
est prog
r
am
.
commit
|
commitdiff
|
tree
2018-04-19
D
.
Richard Hipp
Add the e
x
t/mis
c
/tem
p
latevtab
.
c tem
p
late for vir
t
ual
.
.
.
commit
|
commitdiff
|
tree
2018-04-19
D
.
Rich
a
rd Hi
p
p
Fix a
pro
b
l
e
m in the ne
w
upsert implemen
t
i
o
n
, discovered
.
.
.
commit
|
commitdiff
|
tree
2018-04-19
D
.
Richard Hip
p
Fix t
h
e table name a
l
ias
i
ng on INSERT so
t
hat it
occurs
.
.
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Ri
c
hard Hipp
Avoid a
N
ULL
-
poi
n
ter deref foll
o
wi
n
g
O
O
M
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Ri
c
hard Hipp
F
ix a tes
t
case inside distinc
t
.
test
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richard Hipp
Improved
m
a
tching of
COLLA
T
E
clauses within the ON
.
.
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
R
i
chard Hipp
Fix a pr
o
b
lem in the s
q
lite3Expr
C
o
m
par
e
() functio
n
.
.
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richar
d
Hipp
Add
support for
PostgreSQL UPSERT syntax and functiona
l
ity
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Ri
c
hard Hipp
Fix
t
he
build
for S
Q
LI
T
E_OMI
T
_UPSE
R
T
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richard Hipp
Add the
-
-s
o
rterref
N
option to
the
C
L
I
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richa
r
d Hipp
Omit so
m
e code
n
o
t
used wit
h
out SQLITE_EN
A
BLE_SORTER_REFER
E
N
.
.
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Ri
c
hard Hipp
Remove
an unused local var
i
able
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richa
r
d
H
ipp
Enhan
c
e AL
T
E
R TABLE ADD COLUM
N
to sup
p
ort "D
E
FAULT
.
.
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richard Hipp
Add ch
e
cks to the CLI th
a
t issue a w
a
rning if SQ
L
it
e
.
.
.
commit
|
commitdiff
|
tree
next