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 minor problems with the sqlite3_str interface.
2018-05-09
D
.
Ric
h
ard Hipp
Fix minor
problems w
i
th the
sqlite3_str interfa
c
e
.
commit
|
commitdiff
|
tree
2018-05-09
D
.
Ri
c
hard Hipp
Make
t
he internal
d
yn
a
mic string interface avail
a
ble
.
.
.
commit
|
commitdiff
|
tree
2018-05-09
D
.
Richard
Hipp
Fix a typ
o
in a co
m
ment used for documentation
.
No
.
.
.
commit
|
commitdiff
|
tree
2018-05-08
D
.
Richard Hipp
Co
r
rectly format the STAT1 and ST
A
T
4
content in the
.
.
.
commit
|
commitdiff
|
tree
2018-05-08
D
.
R
i
chard Hipp
Fix a
harmle
s
s compil
e
r wa
r
ni
n
g
in fuzzcheck
.
A
dd
.
.
.
commit
|
commitdiff
|
tree
2018-05-08
D
.
R
i
chard Hipp
Fuzz test case
s
fo
r
UPSERT
.
commit
|
commitdiff
|
tree
2018-05-07
D
.
Richa
r
d
H
ipp
A
c
tiva
t
e t
h
e cell-overwrite
op
t
i
m
ization f
o
r
index
.
.
.
commit
|
commitdiff
|
tree
2018-05-07
D
.
Richard Hipp
Impro
v
ed comments on th
e
c
el
l
-ove
r
write optim
i
zat
i
on
.
.
.
commit
|
commitdiff
|
tree
2018-05-07
D
.
Richard Hipp
On an UPDATE, try to over
w
rite an exis
t
in
g
btree c
e
ll
.
.
.
commit
|
commitdiff
|
tree
2018-05-07
D
.
Richard
H
ipp
F
i
x har
m
less compiler
w
arnings associated with
the
.
.
.
commit
|
commitdiff
|
tree
2018-05-07
D
.
Richard Hipp
Fix har
m
less compi
l
e
r warn
i
ngs in the
cell-overwrite
.
.
.
commit
|
commitdiff
|
tree
2018-05-07
D
.
Ric
h
ard Hi
p
p
Back
o
ut change
[
0
5
fee1a21ea398f1e4d6f1cf3] b
e
cause
.
.
.
commit
|
commitdiff
|
tree
2018-05-05
D
.
Ri
c
har
d
Hipp
I
n an ORDER
B
Y LIMIT,
m
ake
sure
the ORDER BY
e
xpress
i
on
.
.
.
commit
|
commitdiff
|
tree
2018-05-05
D
.
R
ichard Hipp
F
i
x
a
slightly inc
o
rrect cor
r
uption d
e
tect
i
on branch
.
.
.
commit
|
commitdiff
|
tree
2018-05-04
D
.
Richard Hipp
Me
r
ge enh
a
nc
e
ments from trunk
.
commit
|
commitdiff
|
tree
2018-05-04
D
.
R
i
chard Hipp
Fix requi
r
e
ments marks
.
No code
c
h
anges
.
commit
|
commitdiff
|
tree
2018-05-04
D
.
Ric
h
ard
H
ipp
For
t
h
e amalgam
a
tion-ta
r
ball,
enable FTS5 an
d
J
S
ON1
.
.
.
commit
|
commitdiff
|
tree
2018-05-04
D
.
Ri
c
h
a
rd H
i
pp
Make a se
p
arate l
i
mb in the EXP
L
A
IN
Q
UE
R
Y
PLAN out
p
ut
.
.
.
commit
|
commitdiff
|
tree
2018-05-03
D
.
Richard
Hipp
I
n
O
R
D
E
R
BY
L
IMIT queries, t
r
y to evaluate the ORDER
.
.
.
commit
|
commitdiff
|
tree
2018-05-03
D
.
Richard Hipp
Fix a br
a
nch that ha
s
b
e
c
ome unreachable
d
ue to recent
.
.
.
commit
|
commitdiff
|
tree
2018-05-03
D
.
Ric
h
ard Hipp
Improved
security
f
or VACUU
M
.
T
his check
-
in c
o
mbines
.
.
.
commit
|
commitdiff
|
tree
2018-05-03
D
.
Rich
a
r
d Hipp
Overhaul of EXPLAIN QU
E
R
Y
P
LAN
.
Th
e
o
u
tput is n
o
w
in
.
.
.
commit
|
commitdiff
|
tree
2018-05-03
D
.
Rich
a
rd H
i
p
p
Optimizat
i
ons to
t
h
e new EQP framework
.
commit
|
commitdiff
|
tree
2018-05-03
D
.
R
i
chard Hipp
Fix various
e
rror ha
n
dling
conditions on
t
h
e
cell
o
verwrit
e
.
.
.
commit
|
commitdiff
|
tree
2018-05-03
D
.
Richard Hip
p
Th
e
BtCurs
o
r
.
inf
o
f
i
e
lds are on
l
y valid if info
.
nSize!=0
.
commit
|
commitdiff
|
tree
2018-05-03
D
.
Richard Hipp
Add mo
r
e corruption check
i
ng to
t
h
e
cell overwrite
.
.
.
commit
|
commitdiff
|
tree
2018-05-03
D
.
Richard H
i
pp
Bug fixes in the
overwri
t
e optimizatio
n
.
commit
|
commitdiff
|
tree
2018-05-03
D
.
Ric
h
ard Hipp
The sqli
t
e3BtreeI
n
sert() routine tries
t
o overwrite
.
.
.
commit
|
commitdiff
|
tree
2018-05-03
D
.
R
ichard Hipp
Enhance EXPLAIN
QUERY P
L
AN to report t
h
e generation
.
.
.
commit
|
commitdiff
|
tree
2018-05-02
D
.
Richard Hipp
Mo
r
e test ca
s
e
u
p
dates
.
Tests are a
l
l runnin
g
no
w
.
commit
|
commitdiff
|
tree
2018-05-02
D
.
Rich
a
rd Hipp
Fix test ca
s
es so tha
t
t
h
e
y
work
with t
h
e new EXPLAIN
.
.
.
commit
|
commitdiff
|
tree
2018-05-02
D
.
Richa
r
d Hipp
Imp
r
ove
d
EQ
P
output for
r
e
c
ursive CTEs an
d
m
ulti-value
.
.
.
commit
|
commitdiff
|
tree
2018-05-02
D
.
Richard
H
ipp
Prev
e
nt VACU
U
M f
r
o
m
r
unning any comm
a
nd
s
i
n sqlite_mas
t
er
.
.
.
commit
|
commitdiff
|
tree
2018-05-02
D
.
Ri
c
hard
Hipp
F
i
x a
d
angling-else pro
b
le
m
t
h
at was causing recursive
.
.
.
commit
|
commitdiff
|
tree
2018-05-02
D
.
Richard
H
ipp
Improv
e
ments to t
h
e EQP display for compou
n
d
s
elec
t
.
.
.
commit
|
commitdiff
|
tree
2018-05-02
D
.
Richard Hipp
Beg
i
n r
e
engineering the EXPL
A
IN QUERY
PLAN functi
o
n
.
.
.
commit
|
commitdiff
|
tree
2018-05-01
D
.
Richard H
i
pp
The SQLITE_ALLOW_SQLITE_MASTER
_
INDEX compil
e
-time option
.
.
.
commit
|
commitdiff
|
tree
2018-04-30
D
.
R
i
chard Hipp
Defer load
i
ng resul
t
colum
n
values into registers
o
n
.
.
.
commit
|
commitdiff
|
tree
2018-04-28
D
.
R
ichard H
i
pp
T
est cases ad
d
ed for SQLIT
E
_
D
BCON
F
IG_
R
ESET_
D
ATABASE
.
commit
|
commitdiff
|
tree
2018-04-28
D
.
Richard Hi
p
p
Add the SQLI
T
E_DBCONFIG_RESET_DATABASE control for
.
.
.
commit
|
commitdiff
|
tree
2018-04-28
D
.
R
i
chard Hipp
Add the S
Q
LITE_DB
C
ONFIG
_
R
ESET
_
DAT
A
BASE c
o
n
t
rol as a
.
.
.
commit
|
commitdiff
|
tree
2018-04-28
D
.
Richard H
i
pp
Merge upda
t
e
s from
t
runk
.
commit
|
commitdiff
|
tree
2018-04-28
D
.
Rich
a
rd H
i
pp
P
r
event dee
p
recursi
o
ns
on n
e
s
ted COLLATE op
e
r
a
tors
.
commit
|
commitdiff
|
tree
2018-04-28
D
.
Richard Hipp
Fix comp
i
l
er
w
a
rning
s
in FTS3
.
commit
|
commitdiff
|
tree
2018-04-28
D
.
Richar
d
Hipp
Add
t
he "P
R
AGMA r
e
set_data
b
ase=ON
|
OFF"
command
.
When
.
.
.
commit
|
commitdiff
|
tree
2018-04-27
D
.
Richard Hipp
Enhance the co
m
m
e
nts in the
t
e
m
p
latevtab
.
c
im
p
lem
e
ntat
i
on
.
commit
|
commitdiff
|
tree
2018-04-26
D
.
Richa
r
d Hipp
T
h
e previous fix for ticket [d85fffd6ffe856092
e
d8da
.
.
.
commit
|
commitdiff
|
tree
2018-04-26
D
.
Rich
a
rd Hipp
Ensu
r
e that new
.
*
v
alue
s
o
f an
U
P
D
ATE do n
o
t get cl
o
b
b
ered
.
.
.
commit
|
commitdiff
|
tree
2018-04-26
D
.
Richard Hipp
Clari
f
ica
t
io
n
o
f
t
he behavior of a
B
EFORE UP
D
ATE tr
i
gger
.
.
.
commit
|
commitdiff
|
tree
2018-04-26
D
.
Richard
Hipp
Improved VDBE comment on the OP_Pa
r
am o
p
co
d
e
.
No
s
ubstantia
.
.
.
commit
|
commitdiff
|
tree
2018-04-25
D
.
R
i
cha
r
d Hipp
Add
n
ew i
n
terfaces for acce
s
sing the
l
ist of
SQL keywords:
commit
|
commitdiff
|
tree
2018-04-25
D
.
Richard Hipp
A
dd the new DO a
n
d NO
T
HIN
G
keywords
to the keyword
.
.
.
commit
|
commitdiff
|
tree
2018-04-25
D
.
Ri
c
hard Hipp
Add the
n
ew SQLITE_SH
E
LL_INIT_PROC c
o
mp
i
le-
t
i
m
e
entry
.
.
.
commit
|
commitdiff
|
tree
2018-04-25
D
.
Richard Hipp
Avoid
many unnecessary
calls
to
sq
l
i
t
e3ReadSchema(
.
.
.
commit
|
commitdiff
|
tree
2018-04-25
D
.
Richard
Hipp
Add an assert()
t
o
ensure t
h
at schema
mut
e
xes are h
e
ld
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
Richa
r
d
H
ipp
D
o not
a
ttempt t
o
u
s
e ter
m
s from the WHERE c
l
ause to
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
Ric
h
ard Hipp
Upda
t
e
t
he expert ext
e
ns
i
on test
ca
s
es
t
o
a
c
count f
o
r
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
Richard Hipp
All
the
O
R
opt
i
mization to proc
e
ed even if t
h
e OR is
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
R
i
chard Hipp
Add a hyperlink to the ticket on the code co
m
ment
for
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
R
ichard Hipp
Enhan
c
e
the
C
L
I
t
o render
EXPLAIN QUERY PLAN using
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
Richa
r
d
Hipp
Fix a memory l
e
ak followin
g
f
a
ilu
r
e to
o
pen an external
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
Richard Hipp
In
EXPLAI
N
QUERY PLAN
o
u
t
p
ut, do not show an EXECUTE
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
Richard
Hipp
Fix to check-in [ca34c2dd20ee0
7
1e] - avoid a NULL pointer
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Richard Hipp
Fix a problem
i
n
sql
i
te3ExprCompare() associated wi
t
h
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Richard Hipp
Fix a f
o
r
m
a
tting i
s
sue in
t
he TreeView output
f
or bar
e
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Richa
r
d Hipp
Add
t
he "
.
im
p
oster off"
v
ariant of t
h
e "
.
i
mpos
t
er"
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
R
ichard Hipp
The "
.
sel
e
c
t
trace 0x2000" com
m
and causes just
th
e
top
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Richard Hipp
T
h
e "
.
selecttrace 4" command
n
o
w
shows
o
nly a s
i
ngle
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Richard Hipp
Do not resto
r
e the iSel
e
c
tId value un
t
il af
t
er th
e
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Richard Hipp
In the "
.
selec
t
trace" outpu
t
, include
t
h
e
EXPLAIN Q
U
ERY
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Richard Hipp
Ensure th
a
t th
e
r
e
are no bind-parameters
o
r
incorre
c
t
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Richard
H
i
pp
Fix
a
n
unr
e
achable branch assoc
i
ated with sta
c
k overflow
.
.
.
commit
|
commitdiff
|
tree
2018-04-21
D
.
Richard Hipp
P
e
rformance
i
mpro
v
e
m
e
nts on
t
he main l
o
op of the LEMON
.
.
.
commit
|
commitdiff
|
tree
2018-04-21
D
.
R
i
chard Hipp
Enhance
LEMON to tr
a
ck which
symbols actua
l
l
y
carry
.
.
.
commit
|
commitdiff
|
tree
2018-04-21
D
.
Richard
Hipp
Ad
d
the %extra_conte
x
t
directive to lemon, as an alter
n
ative
.
.
.
commit
|
commitdiff
|
tree
2018-04-21
D
.
Ri
c
har
d
Hipp
F
i
x UP
S
ERT so that it
plays
n
icely with
A
UTO
I
N
C
R
EMENT
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Rich
a
r
d
Hipp
Add the -dDIRECTOR
Y
command
-
li
n
e
option
to LEMON
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
R
i
char
d
Hipp
Fi
x
a
harmle
s
s
comp
i
le
r
w
arning
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Richard Hipp
Av
o
id the
u
se of sta
t
eme
n
t journals on DELETEs
o
f a
.
.
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Richard Hi
p
p
Avoid op
e
ning a statemen
t
journ
a
l on
s
ingle-row UPDATEs
.
.
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Rich
a
rd
H
i
pp
Fi
x
a VDBE
comment
o
n upser
t
.
Provide
an
e
r
ror m
e
ssag
e
.
.
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
R
i
c
ha
r
d
H
i
p
p
Avoid unnecessary
c
ursor se
e
k
ing when performin
g
an
.
.
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Richard
H
i
pp
Improv
e
d VDBE comment on UPSERT
code
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Richard Hipp
Minor
s
impl
i
fication o
f
the previo
u
s ch
e
cki
n
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Richard Hi
p
p
Avoid unnecessary cursor seeks d
u
ring upsert proc
e
s
sing
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Ric
h
ard Hi
p
p
E
nhance
U
P
SERT
s
o
that
the UPDATE
u
s
es t
h
e
s
ame set
.
.
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
R
i
chard
H
i
p
p
Minor
simplificati
o
n of t
h
e
cursor allocati
o
n logic
.
.
.
commit
|
commitdiff
|
tree
2018-04-19
D
.
Richard Hipp
F
ix the handling
o
f
"PRAGMA
count_changes
=
ON" with
.
.
.
commit
|
commitdiff
|
tree
2018-04-19
D
.
Ric
h
ard Hip
p
Minor simplificat
i
o
n
t
o the upsert logic
.
commit
|
commitdiff
|
tree
2018-04-19
D
.
Ric
h
a
r
d
H
ipp
Add
the --upsert opti
o
n to the
w
ordcou
n
t te
s
t program
.
commit
|
commitdiff
|
tree
2018-04-19
D
.
Richard
H
ipp
Add the ext/mis
c
/
t
emplatev
t
a
b
.
c template
f
o
r
vi
r
tual
.
.
.
commit
|
commitdiff
|
tree
2018-04-19
D
.
Richard
Hipp
Fix a p
r
oblem
i
n t
h
e new upsert imp
l
e
m
ention,
discovered
.
.
.
commit
|
commitdiff
|
tree
2018-04-19
D
.
Ric
h
ard Hipp
F
i
x
the ta
b
le name al
i
asing on
I
NSERT
so
t
h
a
t
it occurs
.
.
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
R
i
cha
r
d Hipp
Avoid a NULL-poi
n
ter deref fol
l
owing OOM
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richar
d
Hi
p
p
Fix
a
test case inside disti
n
ct
.
test
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richard Hipp
Improved mat
c
hing
o
f
C
OL
L
ATE
c
laus
e
s within the ON
.
.
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richar
d
Hipp
F
ix a
problem in the s
q
lite3ExprCompa
r
e(
)
fun
c
ti
o
n
.
.
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
R
ichard Hipp
A
d
d supp
o
rt for P
o
stgreSQL
UPSERT s
y
ntax and functiona
l
ity
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richard H
i
p
p
Fix the build f
o
r
SQLITE_OMIT_UPSERT
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richard H
i
pp
Add the
-
-sorterref N
o
ption to th
e
CLI
.
commit
|
commitdiff
|
tree
next