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 harmless compiler warnings in the cell-overwrite logic.
2018-05-07
D
.
R
i
cha
r
d H
i
p
p
F
ix harmless compiler w
a
rnings in the cell-o
v
erw
r
ite
.
.
.
commit
|
commitdiff
|
tree
2018-05-04
D
.
Richard Hipp
M
erge enha
n
c
e
ments from tru
n
k
.
commit
|
commitdiff
|
tree
2018-05-04
D
.
R
ic
h
a
rd
Hipp
Fix requiremen
t
s
m
arks
.
No code
changes
.
commit
|
commitdiff
|
tree
2018-05-04
D
.
Richard Hi
p
p
For the amalgamation-
t
arball, enable FTS5 and JSON
1
.
.
.
commit
|
commitdiff
|
tree
2018-05-04
D
.
Richard Hipp
Make a sepa
r
ate limb
i
n the
E
XP
L
AIN
Q
U
E
RY
P
LAN
o
utput
.
.
.
commit
|
commitdiff
|
tree
2018-05-03
D
.
Ric
h
ard Hipp
In ORDER BY LIMIT queries,
try to
e
valu
a
te
t
h
e ORDER
.
.
.
commit
|
commitdiff
|
tree
2018-05-03
D
.
Rich
a
rd Hipp
Fix a branch that
h
as
b
ecome unreachable du
e
to recent
.
.
.
commit
|
commitdiff
|
tree
2018-05-03
D
.
Richa
r
d Hi
p
p
Improved security for VACUUM
.
This ch
e
ck-in
c
ombin
e
s
.
.
.
commit
|
commitdiff
|
tree
2018-05-03
D
.
Richard Hipp
Overhaul of EXPLA
I
N QUE
R
Y P
L
AN
.
Th
e
o
u
t
p
u
t
is no
w
in
.
.
.
commit
|
commitdiff
|
tree
2018-05-03
D
.
R
i
chard Hipp
Optimization
s
to the new EQP framework
.
commit
|
commitdiff
|
tree
2018-05-03
D
.
Ric
h
ard H
i
pp
Fix v
a
rious error
h
a
n
d
lin
g
con
d
itions on
the c
e
ll ov
e
rwrit
e
.
.
.
commit
|
commitdiff
|
tree
2018-05-03
D
.
Rich
a
rd Hipp
The BtCursor
.
info fi
e
lds are only v
a
lid if i
n
fo
.
n
Si
z
e!=0
.
commit
|
commitdiff
|
tree
2018-05-03
D
.
Richar
d
Hipp
Add more co
r
rupti
o
n checking to the cell ov
e
rw
r
i
t
e
.
.
.
commit
|
commitdiff
|
tree
2018-05-03
D
.
Richa
r
d Hipp
Bug
fixes in the overwrite
opt
i
miz
a
t
i
on
.
commit
|
commitdiff
|
tree
2018-05-03
D
.
Richard H
i
pp
The s
q
lite3BtreeInsert()
r
outine
t
ries to overw
r
i
te
.
.
.
commit
|
commitdiff
|
tree
2018-05-03
D
.
Rich
a
rd Hipp
Enhance EXPLAIN QUERY PLAN
to report the generat
i
on
.
.
.
commit
|
commitdiff
|
tree
2018-05-02
D
.
Ric
h
ard Hipp
More test
case updates
.
Tests are all runnin
g
now
.
commit
|
commitdiff
|
tree
2018-05-02
D
.
Richard Hipp
Fix test cases s
o
that they work with the new EXPLAIN
.
.
.
commit
|
commitdiff
|
tree
2018-05-02
D
.
Ric
h
ard H
i
pp
Improved
E
QP output for
recursive CTEs an
d
multi-value
.
.
.
commit
|
commitdiff
|
tree
2018-05-02
D
.
Richard Hipp
Pr
e
vent
VACUUM
from
running any com
m
ands in sqlite_mast
e
r
.
.
.
commit
|
commitdiff
|
tree
2018-05-02
D
.
Richard Hipp
Fi
x
a dangling
-
el
s
e prob
l
em that w
a
s
c
ausi
n
g
recursiv
e
.
.
.
commit
|
commitdiff
|
tree
2018-05-02
D
.
R
i
cha
r
d Hi
p
p
Imp
r
ovements to
th
e
EQP d
i
s
pla
y
for comp
o
und select
.
.
.
commit
|
commitdiff
|
tree
2018-05-02
D
.
R
i
chard Hipp
Begin ree
n
gineeri
n
g t
h
e EXPLAIN QUERY PLAN funct
i
on
.
.
.
commit
|
commitdiff
|
tree
2018-05-01
D
.
Richard Hipp
The SQLITE_A
L
LOW_SQLITE_MAST
E
R_I
N
DEX c
o
m
p
ile-tim
e
opt
i
on
.
.
.
commit
|
commitdiff
|
tree
2018-04-30
D
.
Richard Hipp
Defer loading result
c
o
lumn
v
a
l
u
es
into r
e
gisters on
.
.
.
commit
|
commitdiff
|
tree
2018-04-28
D
.
Ri
c
hard H
i
pp
Test ca
s
e
s
added for
SQ
L
ITE_DBC
O
NFIG_RESET_
D
AT
A
BASE
.
commit
|
commitdiff
|
tree
2018-04-28
D
.
Richard Hipp
A
dd the SQLIT
E
_
D
B
C
ONFIG_
R
ESET_DAT
A
BA
S
E cont
r
ol f
o
r
.
.
.
commit
|
commitdiff
|
tree
2018-04-28
D
.
R
i
chard Hipp
A
d
d the
S
QLITE
_
DBCONFIG_RESET_DATABASE control as
a
.
.
.
commit
|
commitdiff
|
tree
2018-04-28
D
.
Ri
c
ha
r
d H
i
p
p
Merge upda
t
es from trunk
.
commit
|
commitdiff
|
tree
2018-04-28
D
.
R
i
chard Hipp
Prevent deep r
e
cursions on neste
d
COL
L
ATE operato
r
s
.
commit
|
commitdiff
|
tree
2018-04-28
D
.
Ri
c
hard
H
ipp
Fix compi
l
er warning
s
in FTS3
.
commit
|
commitdiff
|
tree
2018-04-28
D
.
Richard Hipp
A
d
d the "
P
RAGMA reset_d
a
tab
a
se=ON|O
F
F" command
.
W
h
e
n
.
.
.
commit
|
commitdiff
|
tree
2018-04-27
D
.
R
i
ch
a
rd Hipp
Enhanc
e
the comments in
t
he templatevtab
.
c implem
e
n
tation
.
commit
|
commitdiff
|
tree
2018-04-26
D
.
Ri
c
hard Hipp
The
previous
f
ix for ticket [d85fffd
6
ffe8
5
6092ed8da
.
.
.
commit
|
commitdiff
|
tree
2018-04-26
D
.
Ric
h
ard Hipp
E
ns
u
re that new
.
* v
a
l
ues of an UPDATE
d
o not g
e
t clobbered
.
.
.
commit
|
commitdiff
|
tree
2018-04-26
D
.
Richard Hi
p
p
Clarification of
t
h
e behavior of a BEFO
R
E
UP
D
A
TE tr
i
gger
.
.
.
commit
|
commitdiff
|
tree
2018-04-26
D
.
Ric
h
ard H
i
pp
Improved
VDBE
comment on the OP_Param opcode
.
No subst
a
ntia
.
.
.
commit
|
commitdiff
|
tree
2018-04-25
D
.
Richard Hi
p
p
Add new interfaces for acc
e
s
s
i
ng the li
s
t of SQL keywords:
commit
|
commitdiff
|
tree
2018-04-25
D
.
Richard
Hipp
A
dd the new DO and
N
O
T
HI
N
G
key
w
ords to
t
he keyword
.
.
.
commit
|
commitdiff
|
tree
2018-04-25
D
.
Rich
a
rd Hipp
Add
t
he new
S
QLITE
_
SH
E
LL_INIT_PROC com
p
ile-
t
ime entry
.
.
.
commit
|
commitdiff
|
tree
2018-04-25
D
.
R
i
chard Hipp
Avoid
ma
n
y
unnecessa
r
y calls to sql
i
te3Rea
d
Sche
m
a(
.
.
.
commit
|
commitdiff
|
tree
2018-04-25
D
.
Richard Hipp
Add an ass
e
r
t() to e
n
sure
t
hat sche
m
a mutex
e
s are held
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
Richard Hipp
Do
not att
e
m
pt t
o
u
s
e terms
from
t
h
e W
H
ERE clau
s
e to
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
Richard Hipp
Update the e
x
pert extension t
e
st cases to acco
u
nt fo
r
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
R
ichard Hipp
All the OR optimiza
t
i
o
n to
p
roc
e
ed e
v
en if
the
OR is
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
Richard Hipp
Add a hyper
l
i
nk to
th
e
t
i
cket on the code comment for
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
Rich
a
r
d Hipp
E
n
hance the CLI
to re
n
der EXPLAIN QUERY P
L
AN usin
g
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
R
ichard Hipp
Fix a memory l
e
ak fo
l
lowing failur
e
to open
an e
x
t
e
rnal
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
Richard Hip
p
In EXPLAIN QUERY PLAN o
u
tp
u
t, do
n
o
t
s
how an EXECUTE
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
Richard Hipp
Fix
t
o
ch
e
ck-in [ca34c2
d
d
20
e
e071e] - avoid
a
NU
L
L pointer
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
R
i
chard Hipp
Fix a proble
m
in sqlite3Exp
r
C
o
m
p
are() as
s
ociated with
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Richard Hipp
Fix a fo
r
matt
i
n
g
is
s
ue in the
T
ree
V
iew output fo
r
bare
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Richard Hi
p
p
A
dd
th
e
"
.
imp
o
ster
o
ff" variant of the "
.
i
m
p
o
s
t
er"
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Richa
r
d Hip
p
The "
.
selecttrace 0
x
2
000" command ca
u
ses j
u
st the top
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Ric
h
ard
Hi
p
p
T
h
e "
.
s
e
l
e
c
ttrace
4" command now
shows
only
a
single
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Richard
Hi
p
p
Do no
t
re
s
tore
t
he iS
e
l
ect
I
d value until after the
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Richard
Hipp
In
t
h
e "
.
sele
c
ttrac
e
" out
p
ut, include the EXPL
A
IN QUER
Y
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Richard Hipp
E
n
sure that there are no b
i
n
d
-
parameters
or
i
ncorr
e
ct
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Richard Hipp
Fix a
n
u
nreachable branch associ
a
ted with stack overfl
o
w
.
.
.
commit
|
commitdiff
|
tree
2018-04-21
D
.
R
i
chard Hipp
P
erformance imp
r
o
vemen
t
s on the mai
n
loop of the LEMON
.
.
.
commit
|
commitdiff
|
tree
2018-04-21
D
.
R
i
c
hard H
i
pp
Enh
a
nce LEMON to t
r
ack
w
hich symbols actually carr
y
.
.
.
commit
|
commitdiff
|
tree
2018-04-21
D
.
Richard Hi
p
p
A
d
d
the %ex
t
ra_co
n
text directive
t
o lem
o
n, as an alt
e
rnative
.
.
.
commit
|
commitdiff
|
tree
2018-04-21
D
.
Ric
h
ard Hipp
Fix UPS
E
R
T so
t
hat
i
t plays ni
c
el
y
wit
h
AUTOINCREMENT
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Ric
h
ard Hip
p
Add the -dDIRECTO
R
Y command-
l
i
ne o
p
tion to LEMON
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Richard
Hipp
Fix a harmless compiler warning
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Richa
r
d Hip
p
Avoid the
use of stateme
n
t j
o
u
rnals on
D
ELETEs
o
f
a
.
.
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Richar
d
Hipp
Avoid openi
n
g
a
stat
e
ment j
o
urnal on singl
e
-r
o
w
UPDATEs
.
.
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Richar
d
Hipp
Fi
x
a
VDB
E
com
m
ent on ups
e
r
t
.
Provide an e
r
ror me
s
sage
.
.
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Ri
c
hard Hip
p
Avo
i
d
u
nnecessary cursor se
e
ki
n
g
w
hen
p
e
r
forming an
.
.
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
R
i
char
d
H
ipp
Improved VDBE comment on UPS
E
RT code
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Richard Hipp
Minor simplification of the previous chec
k
in
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Ric
h
ar
d
Hipp
Avoid unnecessary cur
s
or seeks during upsert processing
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Richard
H
ipp
Enhance UPSE
R
T
so
t
hat the UPD
A
TE uses the sam
e
set
.
.
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
R
i
chard Hipp
Mino
r
sim
p
lificat
i
on of the cu
r
s
o
r allocation logic
.
.
.
commit
|
commitdiff
|
tree
2018-04-19
D
.
Ri
c
hard Hipp
Fi
x
the handling
o
f "PRAGMA count_cha
n
ges=ON
"
with
.
.
.
commit
|
commitdiff
|
tree
2018-04-19
D
.
Richard H
i
pp
Minor simpl
i
fic
a
tion to the
u
psert logi
c
.
commit
|
commitdiff
|
tree
2018-04-19
D
.
Richa
r
d
Hipp
A
d
d
t
he --ups
e
rt
o
p
tion
to th
e
w
o
rdcount
t
e
s
t
program
.
commit
|
commitdiff
|
tree
2018-04-19
D
.
Ri
c
hard Hipp
A
dd the ext/
m
i
s
c/templatevtab
.
c
template for virtu
a
l
.
.
.
commit
|
commitdiff
|
tree
2018-04-19
D
.
R
i
chard
H
ipp
Fix a problem in t
h
e new
u
psert impleme
n
tion
,
disco
v
ered
.
.
.
commit
|
commitdiff
|
tree
2018-04-19
D
.
Richard
H
ipp
Fix the tabl
e
name alias
i
ng on INSE
R
T so that it o
c
cur
s
.
.
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Ri
c
hard
Hipp
Avoid a NULL-pointer d
e
ref following O
O
M
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
R
ichard Hipp
Fix a t
e
st case inside
d
i
stinct
.
test
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richard Hip
p
Impro
v
e
d
mat
c
hing of COLLATE clause
s
within
t
he ON
.
.
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richar
d
Hipp
Fix a problem
i
n
the sql
i
t
e3E
x
p
r
C
o
m
par
e
() fu
n
ction
.
.
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richard Hipp
Add suppo
r
t f
o
r PostgreSQL UPSERT
s
y
n
tax and functiona
l
ity
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richard Hipp
Fix th
e
build
fo
r
SQLITE_OMIT_UPSERT
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richard Hipp
Add the --sorterre
f
N option
t
o the CLI
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richard Hipp
Omit some cod
e
not us
e
d
wi
t
h
ou
t
SQLITE_E
N
ABLE_S
O
RTER_REF
E
REN
.
.
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
R
ic
h
ard
Hipp
Remove an u
n
u
s
ed local v
a
r
iable
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Rich
a
rd Hipp
Enh
a
nce
A
LT
E
R TABLE ADD COLUMN to s
u
pport "
D
EFAULT
.
.
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Rich
a
rd Hipp
Add checks to the
C
LI that issue a warning if SQLi
t
e
.
.
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richard
H
i
pp
Add new testcase() mac
r
os a
n
d fix a bug
t
hat was re
v
e
aled
.
.
.
commit
|
commitdiff
|
tree
2018-04-17
D
.
R
ichard H
i
pp
Remove u
n
reachable branches
.
100% MC/DC
i
n TH3
n
o
w
.
commit
|
commitdiff
|
tree
2018-04-17
D
.
Ri
c
h
a
rd H
i
pp
Added a comment on
t
he assert() ad
d
ed to
the pre
v
ious
.
.
.
commit
|
commitdiff
|
tree
2018-04-17
D
.
R
i
char
d
Hipp
Fixes to the logic f
o
r
c
onstraint
check reorderi
n
g
.
.
.
commit
|
commitdiff
|
tree
2018-04-17
D
.
Richa
r
d H
i
pp
Dur
i
n
g
PRA
G
MA
v
dbe_addoptrace=O
N
, sh
o
w call
s
to sqlit
e
3VdbeR
.
.
.
commit
|
commitdiff
|
tree
2018-04-17
D
.
R
i
chard Hipp
TK_
R
E
G
ISTER
e
xp
r
essi
o
n
s n
o
des ar
e
p
roba
b
ly not co
n
stant
.
.
.
commit
|
commitdiff
|
tree
2018-04-17
D
.
Richar
d
Hipp
Si
m
plific
a
ti
o
n to the upsert logic
.
commit
|
commitdiff
|
tree
2018-04-17
D
.
Richard
Hipp
N
e
w t
e
st case
s
for ups
e
rt
.
commit
|
commitdiff
|
tree
2018-04-16
D
.
Richard
H
ipp
M
e
rge the Le
m
o
n
enhance
m
en
t
from
t
runk, re
s
ult
i
ng in
.
.
.
commit
|
commitdiff
|
tree
next