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
Make a separate limb in the EXPLAIN QUERY PLAN output for the various lines
2018-05-04
D
.
Richard Hipp
M
a
ke
a
separate
l
im
b
in
t
he EXP
L
AIN QUERY PLAN
out
p
ut
.
.
.
commit
|
commitdiff
|
tree
2018-05-03
D
.
Richa
r
d
H
ipp
In ORDER
B
Y
LIMI
T
que
r
ies,
t
ry to ev
a
luate the ORDER
.
.
.
commit
|
commitdiff
|
tree
2018-05-03
D
.
Rich
a
rd
Hipp
Fix a
b
r
a
nch that has become unreachable due to r
e
cent
.
.
.
commit
|
commitdiff
|
tree
2018-05-03
D
.
R
i
ch
a
rd Hipp
Imp
r
o
ved s
e
cu
r
i
ty for VACUUM
.
Thi
s
check-in combines
.
.
.
commit
|
commitdiff
|
tree
2018-05-03
D
.
R
icha
r
d
H
ipp
Ove
r
h
a
u
l of EXPLAIN
Q
UERY PLAN
.
The
outp
u
t is now in
.
.
.
commit
|
commitdiff
|
tree
2018-05-03
D
.
Richar
d
Hipp
Opt
i
mizations to the new EQP fra
m
ework
.
commit
|
commitdiff
|
tree
2018-05-03
D
.
Richard Hipp
Enhance EXPLAI
N
QUERY PLAN to rep
o
rt the ge
n
e
rat
i
on
.
.
.
commit
|
commitdiff
|
tree
2018-05-02
D
.
Rich
a
rd H
i
p
p
M
ore test case upd
a
tes
.
Tests are all r
u
n
n
ing
n
ow
.
commit
|
commitdiff
|
tree
2018-05-02
D
.
Richa
r
d Hipp
Fix test
case
s
so t
h
at
they wo
r
k w
i
th the new EX
P
LAIN
.
.
.
commit
|
commitdiff
|
tree
2018-05-02
D
.
Richard Hipp
Improved EQP output for recurs
i
v
e
CTEs
and
m
ulti-value
.
.
.
commit
|
commitdiff
|
tree
2018-05-02
D
.
Richard Hipp
P
revent VAC
U
UM from
run
n
ing any command
s
in sqli
t
e_master
.
.
.
commit
|
commitdiff
|
tree
2018-05-02
D
.
Richard Hipp
Fi
x
a dangl
i
ng-else p
r
oblem
t
hat was
causing re
c
ursive
.
.
.
commit
|
commitdiff
|
tree
2018-05-02
D
.
Richard Hipp
Improve
m
ents to the EQP
d
isp
l
ay
f
or compou
n
d select
.
.
.
commit
|
commitdiff
|
tree
2018-05-02
D
.
R
i
ch
a
rd Hipp
B
e
gin
reengine
e
ring the EXPLAI
N
QUERY PLAN function
.
.
.
commit
|
commitdiff
|
tree
2018-05-01
D
.
R
i
chard Hi
p
p
The SQLITE
_
ALLOW_SQ
L
I
TE_M
A
STER_INDEX compile-time opti
o
n
.
.
.
commit
|
commitdiff
|
tree
2018-04-30
D
.
Richard Hip
p
D
e
fer
l
oa
d
i
n
g re
s
ul
t
column values into
r
egiste
r
s on
.
.
.
commit
|
commitdiff
|
tree
2018-04-28
D
.
Ri
c
hard Hipp
Test cases a
d
ded for SQLITE_DBCONFIG
_
RESET_DATABASE
.
commit
|
commitdiff
|
tree
2018-04-28
D
.
R
i
chard
Hipp
Add th
e
S
Q
LITE_DBCONFI
G
_
R
ESE
T
_DATAB
A
SE control for
.
.
.
commit
|
commitdiff
|
tree
2018-04-28
D
.
R
ichar
d
Hipp
Add
th
e
SQLITE_DBCONFIG_RESET_DATABASE control as a
.
.
.
commit
|
commitdiff
|
tree
2018-04-28
D
.
Richard
H
i
p
p
Merge
u
pdates
from
t
ru
n
k
.
commit
|
commitdiff
|
tree
2018-04-28
D
.
Ric
h
ard Hipp
Pre
v
ent deep recur
s
ions on nested COLLATE operato
r
s
.
commit
|
commitdiff
|
tree
2018-04-28
D
.
R
i
c
h
ard Hipp
Fix c
o
mpiler
w
a
rnings in FTS3
.
commit
|
commitdiff
|
tree
2018-04-28
D
.
R
ichard Hipp
Add t
h
e "PRAGMA reset_d
a
t
abase=ON|OFF"
command
.
When
.
.
.
commit
|
commitdiff
|
tree
2018-04-27
D
.
Richard Hipp
Enhanc
e
the
com
m
ents
i
n the t
e
mpla
t
evtab
.
c im
p
lementation
.
commit
|
commitdiff
|
tree
2018-04-26
D
.
Richard Hip
p
The previous fix for
t
icket [d85fffd6ffe856092
e
d8da
.
.
.
commit
|
commitdiff
|
tree
2018-04-26
D
.
Richard Hipp
En
s
u
r
e
that new
.
* va
l
ues of an
UPD
A
TE do no
t
get clobbered
.
.
.
commit
|
commitdiff
|
tree
2018-04-26
D
.
Ric
h
ard Hi
p
p
C
l
arifica
t
ion of
the behavio
r
o
f
a BEFOR
E
UP
D
AT
E
trigger
.
.
.
commit
|
commitdiff
|
tree
2018-04-26
D
.
R
i
chard
H
ipp
Improved V
D
B
E
comment
o
n the
OP
_
Param o
p
code
.
No su
b
stan
t
ia
.
.
.
commit
|
commitdiff
|
tree
2018-04-25
D
.
Richard Hipp
Add
new interfaces for ac
c
e
ssing t
h
e lis
t
of SQL keywords:
commit
|
commitdiff
|
tree
2018-04-25
D
.
Rich
a
rd Hipp
Ad
d
th
e
new DO a
n
d N
O
T
H
ING
k
eywords
t
o
the keyword
.
.
.
commit
|
commitdiff
|
tree
2018-04-25
D
.
Richard Hipp
Add the new SQLITE_SHELL_INI
T
_P
R
OC c
o
m
p
ile-time entry
.
.
.
commit
|
commitdiff
|
tree
2018-04-25
D
.
Richa
r
d
Hipp
Avoid
m
any unnec
e
ssary calls to sqlit
e
3R
e
a
dSchema(
.
.
.
commit
|
commitdiff
|
tree
2018-04-25
D
.
Richar
d
Hipp
Add an assert() t
o
ensu
r
e
t
hat sc
h
ema mut
e
xes are held
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
Richard Hipp
Do not a
t
tempt to
u
s
e
terms from the WHERE clause to
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
Richard Hipp
Up
d
ate
t
he
e
x
pert extens
i
o
n
test cases to account for
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
Richard
H
i
p
p
A
l
l the OR optimiz
a
tion to proceed
even if the O
R
i
s
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
Rich
a
rd Hipp
Add a hyp
e
rlink to the ticket
o
n
the
c
ode c
o
mment fo
r
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
R
ichard Hipp
E
nhance
t
he CLI to re
n
der EXP
L
A
IN
QUERY PLAN usin
g
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
R
i
c
h
ard Hipp
Fix a mem
o
ry l
e
ak following failure to open an ext
e
rnal
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
Richard Hipp
In EXPLAIN QUERY PLAN output, do
not show an EXECUTE
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
Ri
c
hard Hipp
F
i
x to chec
k
-in [c
a
34c2dd
2
0e
e
0
71e
]
- avoid a NU
L
L pointer
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Richard Hipp
Fix a prob
l
e
m in sq
l
i
te3E
x
prCompare() as
s
o
c
i
ated wit
h
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Richard Hip
p
F
i
x a formatting issue in the TreeVie
w
output for b
a
r
e
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
R
i
chard Hipp
Add the
"
.
impos
t
er off" varia
n
t of the "
.
impo
s
ter"
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Richard Hipp
The "
.
s
electtrace 0x2000" comma
n
d causes just th
e
to
p
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Richard Hipp
T
he "
.
selecttrac
e
4
" comm
a
nd now
s
hows only a sing
l
e
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Ri
c
hard Hipp
Do
n
ot restore th
e
iSelectId
v
alue unt
i
l
a
f
ter the
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
R
i
c
h
ar
d
H
ipp
In the "
.
s
e
lecttrac
e
" o
u
tput, include th
e
EXPLAIN QUE
R
Y
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Richard Hipp
Ensu
r
e
t
h
a
t
t
here are no b
i
nd-paramet
e
r
s
or i
n
correct
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
R
i
chard
Hi
p
p
Fix an unr
e
a
c
hable branch
associated w
i
th
st
a
c
k
ov
e
rflow
.
.
.
commit
|
commitdiff
|
tree
2018-04-21
D
.
Richard
Hi
p
p
Pe
r
formance i
m
pr
o
vements on
t
he mai
n
loop o
f
the LEM
O
N
.
.
.
commit
|
commitdiff
|
tree
2018-04-21
D
.
Rich
a
rd Hipp
Enhance L
E
M
O
N to trac
k
which symbols actually car
r
y
.
.
.
commit
|
commitdiff
|
tree
2018-04-21
D
.
Richard Hipp
Add th
e
%extra_cont
e
xt directive
t
o lemon, as
a
n alternati
v
e
.
.
.
commit
|
commitdiff
|
tree
2018-04-21
D
.
Ri
c
hard Hi
p
p
Fix UPSERT so that it plays nicely with AUTOINCREMENT
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Richard Hi
p
p
Add the -dDI
R
ECTORY
command-line op
t
i
on t
o
L
EM
O
N
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
R
ichar
d
Hip
p
Fix a
h
a
rmles
s
compi
l
er warning
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
R
i
cha
r
d Hipp
A
vo
i
d the use o
f
sta
t
ement journ
a
ls on DELETEs of
a
.
.
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
R
ichard Hipp
Av
o
id
o
pening
a statement journal
o
n
single-row UPDATEs
.
.
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Richard Hipp
Fi
x
a VDBE comme
n
t
o
n upser
t
.
Provide an error mes
s
age
.
.
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Richard
Hipp
Avoid unnecessary cursor seeking when performing an
.
.
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Richard Hipp
Impr
o
ved V
D
BE co
m
men
t
on UPSER
T
code
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Richard Hipp
Minor simp
l
ifica
t
i
o
n
o
f the
p
revi
o
u
s c
h
eckin
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Ri
c
hard Hipp
Avoid unnecessary
c
ursor se
e
ks
d
uri
n
g upsert pro
c
es
s
ing
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Richard Hipp
Enhance UPS
E
RT so that t
h
e UPDATE use
s
the same
s
et
.
.
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Richard Hipp
Mi
n
or simplifica
t
ion of
the cursor allocation logic
.
.
.
commit
|
commitdiff
|
tree
2018-04-19
D
.
R
i
chard Hipp
Fi
x
the
handling of "PRAGMA count_changes=ON" wi
t
h
.
.
.
commit
|
commitdiff
|
tree
2018-04-19
D
.
Richard
H
ipp
Minor simplification to
t
he u
p
s
ert lo
g
ic
.
commit
|
commitdiff
|
tree
2018-04-19
D
.
Richard Hipp
Add t
h
e --
u
psert option to the wordcount test
p
r
ogram
.
commit
|
commitdiff
|
tree
2018-04-19
D
.
Richa
r
d Hipp
Add the ext/misc/temp
l
atevtab
.
c template
f
or
virtua
l
.
.
.
commit
|
commitdiff
|
tree
2018-04-19
D
.
Richard Hipp
Fix a prob
l
e
m
in the new upsert
i
mplementio
n
,
di
s
co
v
ered
.
.
.
commit
|
commitdiff
|
tree
2018-04-19
D
.
Richard Hipp
Fix
the table name aliasin
g
on
I
NSE
R
T so that
i
t
occurs
.
.
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
R
i
c
hard Hipp
A
v
o
i
d
a NU
L
L-po
i
nter deref following OOM
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
R
i
chard Hipp
Fix a tes
t
case insi
d
e distinct
.
test
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richard Hipp
I
m
proved matching of COLL
A
TE claus
e
s
withi
n
the
ON
.
.
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richard Hipp
Fix a
problem in the sql
i
te3ExprComp
a
re
(
) funct
i
o
n
.
.
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richard Hipp
Add support
for
P
ostgreSQL UPSERT syntax and functionality
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richard
Hipp
Fix the build
for S
Q
LITE_OMIT_UP
S
E
RT
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richard Hipp
A
dd the
-
-
s
or
t
er
r
ef N option to
t
he CLI
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Ri
c
hard
Hipp
Omit some cod
e
not used wit
h
out SQLITE_ENABLE
_
SORT
E
R_REFE
R
EN
.
.
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richard Hi
p
p
Remov
e
an unuse
d
local
varia
b
le
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Ric
h
ard Hip
p
E
nhance ALTER TABLE A
D
D COLUMN to
suppo
r
t "D
E
FAULT
.
.
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richard Hipp
Add checks to t
h
e CLI th
a
t
issue a wa
r
ni
n
g if SQL
i
te
.
.
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
R
i
chard
Hip
p
Add
n
ew testcas
e
() macr
o
s and fix a bug
t
h
a
t was revealed
.
.
.
commit
|
commitdiff
|
tree
2018-04-17
D
.
Richard Hipp
Remove unreachabl
e
branch
e
s
.
100
%
MC/DC in TH3
n
o
w
.
commit
|
commitdiff
|
tree
2018-04-17
D
.
Ric
h
ard Hipp
A
dded
a
comm
e
n
t
o
n
the a
s
sert()
added
to the pre
v
ious
.
.
.
commit
|
commitdiff
|
tree
2018-04-17
D
.
Rich
a
rd
Hip
p
F
ixes to the log
i
c
f
or constraint
c
heck re
o
rdering
.
.
.
commit
|
commitdiff
|
tree
2018-04-17
D
.
Ric
h
a
r
d Hipp
Dur
i
ng PRAGMA vdbe
_
addopt
r
ace=
O
N
,
s
h
ow call
s
to
s
q
li
t
e
3VdbeR
.
.
.
commit
|
commitdiff
|
tree
2018-04-17
D
.
Richard
H
i
p
p
TK_R
E
G
I
STER expr
e
ssions nodes are
p
robab
l
y
n
ot co
n
stant
.
.
.
commit
|
commitdiff
|
tree
2018-04-17
D
.
Richard Hipp
Simplific
a
tion t
o
the upsert l
o
gic
.
commit
|
commitdiff
|
tree
2018-04-17
D
.
Richard Hipp
New
test ca
s
es for up
s
e
r
t
.
commit
|
commitdiff
|
tree
2018-04-16
D
.
Rich
a
rd Hipp
Mer
g
e the
L
emon enhancement from trunk,
r
e
s
ul
t
ing in
.
.
.
commit
|
commitdiff
|
tree
2018-04-16
D
.
Richard H
i
pp
L
emon e
n
hancem
e
nts: (1) Do not allocate
s
p
a
ce for
.
.
.
commit
|
commitdiff
|
tree
2018-04-16
D
.
Richard Hipp
R
e
mo
v
e the
M
y
S
QL upsert synta
x
.
As an optiona
l
al
i
as
.
.
.
commit
|
commitdiff
|
tree
2018-04-16
D
.
R
ich
a
rd Hipp
Add support
for th
e
"
excluded
.
*" names in
t
he UPDA
T
E
.
.
.
commit
|
commitdiff
|
tree
2018-04-16
D
.
Richard Hipp
Merge changes fro
m
trunk
.
commit
|
commitdiff
|
tree
2018-04-16
D
.
Richar
d
Hi
p
p
Increase the version nu
m
be
r
to 3
.
24
.
0
commit
|
commitdiff
|
tree
2018-04-16
D
.
Richard Hipp
Reduce t
h
e size of the NameC
o
ntext object by groupi
n
g
.
.
.
commit
|
commitdiff
|
tree
2018-04-14
D
.
Richard Hipp
Get upsert working on WITHOUT
R
O
W
ID tables
.
commit
|
commitdiff
|
tree
2018-04-14
D
.
Richard Hipp
Make sure constraint checks
occur
i
n th
e
correct
order
.
.
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
R
ichard
H
ipp
First cut at logic to perform DO UPD
A
TE for rowid tables
.
commit
|
commitdiff
|
tree
next