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
.
Ric
h
ard Hipp
Mak
e
a s
e
parate li
m
b
i
n t
h
e EXP
L
A
I
N Q
U
ERY
P
LAN output
.
.
.
commit
|
commitdiff
|
tree
2018-05-03
D
.
Richard Hi
p
p
In ORDER
B
Y LIMIT queries, try
to ev
a
l
ua
t
e the ORDER
.
.
.
commit
|
commitdiff
|
tree
2018-05-03
D
.
Richard Hipp
F
i
x a
b
ranch
that has become
u
nre
a
c
h
able due to recent
.
.
.
commit
|
commitdiff
|
tree
2018-05-03
D
.
Richard Hipp
Improved s
e
curity for VACU
U
M
.
This check-in combine
s
.
.
.
commit
|
commitdiff
|
tree
2018-05-03
D
.
Ric
h
a
rd
H
i
pp
Over
h
au
l
of
E
XPLAIN QUERY PLAN
.
T
h
e ou
t
pu
t
is now
in
.
.
.
commit
|
commitdiff
|
tree
2018-05-03
D
.
Ric
h
ard Hipp
Optimizations to the
n
ew EQP framework
.
commit
|
commitdiff
|
tree
2018-05-03
D
.
Richard Hi
p
p
E
n
h
an
c
e E
X
P
L
AIN QU
E
RY PLAN to
report t
h
e generation
.
.
.
commit
|
commitdiff
|
tree
2018-05-02
D
.
Richard
Hipp
M
o
r
e test cas
e
updates
.
Te
s
ts
are al
l
run
n
ing
n
o
w
.
commit
|
commitdiff
|
tree
2018-05-02
D
.
Richard H
i
pp
Fix test cases so
t
hat they work
with the new EXPLAIN
.
.
.
commit
|
commitdiff
|
tree
2018-05-02
D
.
Richard Hipp
I
m
p
rov
e
d EQP outpu
t
for recursive CTEs and m
u
lti-value
.
.
.
commit
|
commitdiff
|
tree
2018-05-02
D
.
Ric
h
a
r
d
H
ipp
Prevent
V
ACUUM from running any
c
o
mmands in sqlite_master
.
.
.
commit
|
commitdiff
|
tree
2018-05-02
D
.
Richard Hipp
Fix a d
a
ng
l
ing-else problem that was ca
u
s
i
ng recursive
.
.
.
commit
|
commitdiff
|
tree
2018-05-02
D
.
Richar
d
Hip
p
Im
p
r
o
vements to the EQP displ
a
y for com
p
ound selec
t
.
.
.
commit
|
commitdiff
|
tree
2018-05-02
D
.
R
i
chard
Hip
p
B
egin reengine
e
ri
n
g the EX
P
LAIN
Q
UERY PLAN function
.
.
.
commit
|
commitdiff
|
tree
2018-05-01
D
.
Richard
Hipp
The SQLITE_A
L
LO
W
_SQLITE_M
A
S
T
ER_INDEX com
p
ile-time option
.
.
.
commit
|
commitdiff
|
tree
2018-04-30
D
.
Ric
h
ard Hipp
Defer
l
oading result
c
ol
u
mn value
s
into registers
on
.
.
.
commit
|
commitdiff
|
tree
2018-04-28
D
.
Richard
H
ipp
T
e
st
cases add
e
d
f
o
r SQLIT
E
_DBCONFIG_RE
S
ET_DA
T
AB
A
SE
.
commit
|
commitdiff
|
tree
2018-04-28
D
.
Richard Hipp
Add
t
he SQLIT
E
_DB
C
ON
F
IG_RESET_DAT
A
BASE c
o
ntrol for
.
.
.
commit
|
commitdiff
|
tree
2018-04-28
D
.
Richard Hip
p
Add the
SQLITE_DB
C
ONF
I
G_RESET
_
DATA
B
ASE contr
o
l as a
.
.
.
commit
|
commitdiff
|
tree
2018-04-28
D
.
Richard Hipp
Merge updates from trunk
.
commit
|
commitdiff
|
tree
2018-04-28
D
.
Richard Hi
p
p
Prevent deep
recursions on nested C
O
L
LATE operators
.
commit
|
commitdiff
|
tree
2018-04-28
D
.
Ri
c
hard Hipp
Fix
com
p
iler warni
n
gs in FTS3
.
commit
|
commitdiff
|
tree
2018-04-28
D
.
Richard H
i
pp
Add the
"PRAGMA res
e
t
_
database=ON|OFF" c
o
mmand
.
When
.
.
.
commit
|
commitdiff
|
tree
2018-04-27
D
.
Richar
d
Hipp
Enhance
t
h
e
c
omments
i
n
the te
m
platevtab
.
c
i
mpl
e
mentation
.
commit
|
commitdiff
|
tree
2018-04-26
D
.
Richard H
i
p
p
The pr
e
vious
fix for ticket [d85fffd6ffe856
0
92
e
d8da
.
.
.
commit
|
commitdiff
|
tree
2018-04-26
D
.
R
i
ch
a
rd Hipp
Ensure that new
.
* valu
e
s o
f
an U
P
D
A
TE do
n
ot ge
t
clobb
e
red
.
.
.
commit
|
commitdiff
|
tree
2018-04-26
D
.
Richard Hipp
Clarificat
i
o
n of
th
e
b
e
havior of a BE
F
ORE UPDATE
trigger
.
.
.
commit
|
commitdiff
|
tree
2018-04-26
D
.
Richard Hipp
Improved VDB
E
comment on the OP_Param
o
p
code
.
No s
u
bstan
t
ia
.
.
.
commit
|
commitdiff
|
tree
2018-04-25
D
.
Richard Hipp
Add new inter
f
aces f
o
r ac
c
essin
g
the list of SQL keywords:
commit
|
commitdiff
|
tree
2018-04-25
D
.
Richard Hipp
Add
the
n
ew DO and NOTHING keywo
r
d
s
t
o
the keywor
d
.
.
.
commit
|
commitdiff
|
tree
2018-04-25
D
.
Richard Hipp
A
dd the
n
ew SQLITE_S
H
ELL_INIT_
P
ROC compile-time entr
y
.
.
.
commit
|
commitdiff
|
tree
2018-04-25
D
.
Richard Hip
p
Avoid many unn
e
ces
s
a
ry calls to sqlite3
R
ead
S
che
m
a(
.
.
.
commit
|
commitdiff
|
tree
2018-04-25
D
.
Richard
H
ipp
Add
a
n asser
t
() to ensure th
a
t
schem
a
mutexes ar
e
h
e
ld
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
Richard Hipp
Do not
attem
p
t to
use terms from the
WHERE cla
u
se to
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
Richard Hipp
U
p
dat
e
the expe
r
t extension
test cases to acco
u
n
t
for
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
Ric
h
ard Hipp
A
l
l the OR optimiza
t
i
on to proceed even if
the
OR
i
s
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
Richard
Hipp
A
dd a hyperlink
t
o the ticket o
n
the c
o
de
c
o
mment for
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
Rich
a
r
d
Hipp
E
n
hance th
e
CLI to render EXPL
A
I
N
QUERY PLAN using
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
Richa
r
d Hi
p
p
Fi
x
a memory l
e
ak
following failure
t
o open an e
x
t
e
rnal
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
R
i
c
h
ard Hipp
I
n
EXPL
A
I
N QUERY PLAN output, do not show an EXECUT
E
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
Richa
r
d Hipp
Fix to
c
heck-
i
n
[ca34c
2
dd20ee071e] - av
o
id
a NULL
poi
n
ter
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
R
i
chard Hipp
Fix a problem in sqlite3E
x
p
r
Compar
e
() associated
with
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Richard
H
ipp
Fix a for
m
a
t
t
ing issu
e
in the
TreeView output fo
r
bar
e
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Rich
a
r
d Hipp
Add the "
.
i
m
p
os
t
er off" variant of
t
he
"
.
i
mposter"
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Richard Hipp
The "
.
s
e
lecttrace
0x2000" command
c
auses just
t
h
e top
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Richard H
i
p
p
The "
.
selecttrace
4
" c
o
mmand n
o
w s
h
ows o
n
ly
a
sin
g
l
e
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Ri
c
hard Hipp
Do not restore the
iSelectId
v
alue un
t
il a
f
ter
t
he
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Ri
c
ha
r
d Hi
p
p
I
n
the "
.
sel
e
c
tt
r
ace" output, include the EXPLAIN QUERY
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Ric
h
ard Hipp
Ensure th
a
t there
a
re no bind-parameters
or inco
r
r
ect
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Richard Hipp
Fix an unrea
c
ha
b
le b
r
an
c
h ass
o
ciated
w
i
t
h stack overfl
o
w
.
.
.
commit
|
commitdiff
|
tree
2018-04-21
D
.
Rich
a
rd Hipp
Performance improv
e
ments on the mai
n
l
o
op of the LEMON
.
.
.
commit
|
commitdiff
|
tree
2018-04-21
D
.
R
ichard Hi
p
p
Enh
a
nce LEMON to track which symbols actually carry
.
.
.
commit
|
commitdiff
|
tree
2018-04-21
D
.
Ri
c
hard Hipp
Add the %extra_context
d
i
r
ective to
lemon
,
a
s
an
alter
n
ative
.
.
.
commit
|
commitdiff
|
tree
2018-04-21
D
.
Richard Hipp
Fix U
P
SERT
s
o that it plays
nicely with AUTOINCREMENT
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Richard Hipp
A
dd the -
d
DI
R
ECTORY c
o
m
m
and-line o
p
tion to LEMON
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
R
ichard Hipp
Fix a ha
r
mless compiler w
a
r
n
ing
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Richard Hipp
Avoid the
u
se of
st
a
teme
n
t jour
n
als
on DELETE
s
of a
.
.
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Ric
h
a
rd Hipp
Avoid op
e
n
i
ng a
statemen
t
journa
l
on single-row UPDATEs
.
.
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
R
i
chard
H
i
pp
Fix a VDBE comment
o
n upsert
.
Provid
e
an
erro
r
message
.
.
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
R
i
char
d
Hipp
Avoid unnecessary cursor seeking when p
e
rforming an
.
.
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
R
ichard
Hipp
Improved V
D
BE comment
o
n UPSERT code
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Richard
H
ipp
Minor simplification of the previous checkin
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Richard Hipp
Av
o
id unnecessary
c
u
r
sor see
k
s during u
p
sert processing
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Ric
h
ard
H
ipp
Enhance UPSERT s
o
th
a
t the U
P
DATE use
s
the s
a
me set
.
.
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Richard Hi
p
p
Minor simplification of the curso
r
alloca
t
ion logi
c
.
.
.
commit
|
commitdiff
|
tree
2018-04-19
D
.
Richard Hipp
Fix the handlin
g
of "P
R
AGMA
c
ount_c
h
anges=ON" with
.
.
.
commit
|
commitdiff
|
tree
2018-04-19
D
.
Richard Hipp
Minor
s
implificatio
n
to the
u
ps
e
r
t
logic
.
commit
|
commitdiff
|
tree
2018-04-19
D
.
Richar
d
Hipp
Add the
-
-upse
r
t option
t
o
the word
c
ou
n
t
tes
t
prog
r
a
m
.
commit
|
commitdiff
|
tree
2018-04-19
D
.
Ri
c
hard H
i
p
p
Ad
d
the e
x
t
/
misc/templ
a
tevtab
.
c templ
a
te
f
or virtua
l
.
.
.
commit
|
commitdiff
|
tree
2018-04-19
D
.
Richard Hipp
Fix a probl
e
m i
n
the new upsert implementio
n
,
discovered
.
.
.
commit
|
commitdiff
|
tree
2018-04-19
D
.
Richard H
i
p
p
Fix the
t
able
name aliasing on INSERT so tha
t
it
occurs
.
.
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Ric
h
ard Hipp
Avoi
d
a NULL-pointer d
e
ref follo
w
ing OOM
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richard Hipp
Fix a test cas
e
in
s
ide
distinct
.
test
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Ric
h
ard Hipp
Impro
v
ed matching
o
f
C
O
L
L
ATE cl
a
uses within the ON
.
.
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Ric
h
ard Hipp
Fix a problem in the sqlite3ExprCompare() function
.
.
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
R
i
chard Hipp
Add
s
uppor
t
for Postgr
e
SQL UPSER
T
synta
x
and fu
n
ctionalit
y
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richard H
i
pp
F
i
x
the
b
uil
d
f
o
r SQL
I
T
E
_OMIT_UPSERT
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richard Hipp
Add
t
he --sorterref N optio
n
to the CLI
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richard Hipp
Omit
som
e
code not u
s
ed w
i
tho
u
t SQLITE_E
N
ABLE
_
SORTE
R
_REF
E
REN
.
.
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richard Hipp
Remove
a
n unused lo
c
a
l
variable
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richar
d
Hipp
Enhance ALTER TABLE A
D
D COLUMN to support "
D
EFAULT
.
.
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richar
d
Hipp
Add check
s
t
o
the CL
I
t
hat issue a warnin
g
if S
Q
Lite
.
.
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
R
i
chard Hipp
Add new te
s
tcase() m
a
cros
and
f
ix a bug that was revealed
.
.
.
commit
|
commitdiff
|
tree
2018-04-17
D
.
Richard Hipp
Remove unreachable
b
ranches
.
100% MC/D
C
i
n
T
H3
n
ow
.
commit
|
commitdiff
|
tree
2018-04-17
D
.
Richard Hipp
Added
a
comment on the
a
ssert() added to the previous
.
.
.
commit
|
commitdiff
|
tree
2018-04-17
D
.
R
i
chard Hipp
Fix
e
s
t
o the logic
f
or cons
t
r
a
int check reordering
.
.
.
commit
|
commitdiff
|
tree
2018-04-17
D
.
Ri
c
ha
r
d Hipp
Duri
n
g PRAGMA
v
dbe
_
addo
p
t
race=ON, show calls to sqlite3V
d
beR
.
.
.
commit
|
commitdiff
|
tree
2018-04-17
D
.
Richard
H
ipp
TK_R
E
GISTER expressions nodes are probably not constant
.
.
.
commit
|
commitdiff
|
tree
2018-04-17
D
.
Richard Hip
p
Sim
p
lificat
i
o
n to the upse
r
t
l
ogic
.
commit
|
commitdiff
|
tree
2018-04-17
D
.
R
i
c
h
ard Hipp
New test cas
e
s for upser
t
.
commit
|
commitdiff
|
tree
2018-04-16
D
.
Richard Hipp
M
erge the L
e
mon enhancement from trun
k
,
r
e
sulting in
.
.
.
commit
|
commitdiff
|
tree
2018-04-16
D
.
Ri
c
h
ard Hipp
Lemon
enhancement
s
: (1) Do no
t
allocate space f
o
r
.
.
.
commit
|
commitdiff
|
tree
2018-04-16
D
.
Ri
c
ha
r
d
H
i
p
p
Remove the MySQL upser
t
syntax
.
A
s
an optional
alias
.
.
.
commit
|
commitdiff
|
tree
2018-04-16
D
.
R
icha
r
d Hip
p
A
d
d
support f
o
r t
h
e "ex
c
l
u
ded
.
*" na
m
es
in the UPDATE
.
.
.
commit
|
commitdiff
|
tree
2018-04-16
D
.
Richar
d
Hi
p
p
Mer
g
e chan
g
es from
t
r
un
k
.
commit
|
commitdiff
|
tree
2018-04-16
D
.
Richard Hipp
Incre
a
se the ver
s
ion numb
e
r to
3
.
24
.
0
commit
|
commitdiff
|
tree
2018-04-16
D
.
Richard Hipp
Reduce
the size of
the NameCon
t
e
xt object
by gro
u
pin
g
.
.
.
commit
|
commitdiff
|
tree
2018-04-14
D
.
Richard
H
i
pp
Get upsert wor
k
ing
o
n WITHO
U
T R
O
WID
t
ables
.
commit
|
commitdiff
|
tree
2018-04-14
D
.
Richa
r
d Hipp
Make sure constra
i
nt check
s
occur in
t
he correct order
.
.
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
R
i
c
h
a
r
d Hi
p
p
F
irst cut at logic to p
e
r
form DO
U
P
D
ATE f
o
r row
i
d ta
b
les
.
commit
|
commitdiff
|
tree
next