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
For the amalgamation-tarball, enable FTS5 and JSON1 by default and
2018-05-04
D
.
Richard Hipp
For the
a
malga
m
a
t
i
on-tar
b
all, enable
F
TS5
a
nd JSON1
.
.
.
commit
|
commitdiff
|
tree
2018-05-04
D
.
R
ichard
Hipp
Mak
e
a separate limb in th
e
EX
P
L
AIN QUERY
P
LAN
out
p
ut
.
.
.
commit
|
commitdiff
|
tree
2018-05-03
D
.
R
i
chard Hipp
In ORDER BY LIMIT queries, try t
o
evalua
t
e the ORDER
.
.
.
commit
|
commitdiff
|
tree
2018-05-03
D
.
Richard H
i
pp
Fix a branch that has
b
ecome unreachabl
e
due to recent
.
.
.
commit
|
commitdiff
|
tree
2018-05-03
D
.
Richard Hip
p
Improved secu
r
ity for
V
ACUU
M
.
This check-in com
b
in
e
s
.
.
.
commit
|
commitdiff
|
tree
2018-05-03
D
.
Richard H
i
pp
Overh
a
ul of EXPLAIN Q
U
E
R
Y
PL
A
N
.
The o
u
tput i
s
now
i
n
.
.
.
commit
|
commitdiff
|
tree
2018-05-03
D
.
Richard
H
ipp
Optimizations to the n
e
w
EQP fram
e
wo
r
k
.
commit
|
commitdiff
|
tree
2018-05-03
D
.
Rich
a
rd Hipp
E
n
h
a
n
ce EXPLA
I
N QUER
Y
PLAN
to rep
o
r
t the generati
o
n
.
.
.
commit
|
commitdiff
|
tree
2018-05-02
D
.
R
icha
r
d Hipp
M
or
e
test case updates
.
Te
s
t
s are all running now
.
commit
|
commitdiff
|
tree
2018-05-02
D
.
Richard Hipp
Fix test case
s
so that they work with
t
he new EX
P
LAIN
.
.
.
commit
|
commitdiff
|
tree
2018-05-02
D
.
R
i
c
ha
r
d
H
ipp
Impr
o
ved EQP out
p
u
t
for recursive CTEs and multi-val
u
e
.
.
.
commit
|
commitdiff
|
tree
2018-05-02
D
.
R
ichar
d
H
ipp
Prevent
V
ACUUM
f
rom runn
i
ng
a
n
y co
m
mands in sqlite_master
.
.
.
commit
|
commitdiff
|
tree
2018-05-02
D
.
Richard Hipp
F
i
x a dangling-else probl
e
m that wa
s
caus
i
n
g recursi
v
e
.
.
.
commit
|
commitdiff
|
tree
2018-05-02
D
.
Richar
d
Hipp
Improvements to the EQP
display
fo
r
co
m
pound s
e
l
ect
.
.
.
commit
|
commitdiff
|
tree
2018-05-02
D
.
R
i
chard Hipp
Begin reengine
e
ring the E
X
PLAIN QUERY
P
LAN function
.
.
.
commit
|
commitdiff
|
tree
2018-05-01
D
.
R
icha
r
d
H
ipp
The SQLITE_ALLOW_SQLITE_MASTER_INDEX compile-
t
ime op
t
ion
.
.
.
commit
|
commitdiff
|
tree
2018-04-30
D
.
R
i
cha
r
d Hipp
Defer loading
result column values i
n
to registers on
.
.
.
commit
|
commitdiff
|
tree
2018-04-28
D
.
Richard Hipp
Test case
s
add
e
d fo
r
S
Q
LITE_DBCONFIG_RES
E
T_DATAB
A
S
E
.
commit
|
commitdiff
|
tree
2018-04-28
D
.
Richard Hip
p
A
dd the SQ
L
ITE_DB
C
ON
F
IG_RESET_D
A
TABASE
c
o
ntrol for
.
.
.
commit
|
commitdiff
|
tree
2018-04-28
D
.
Ric
h
ard Hipp
Add
t
he
SQLITE_DBCONFIG_RES
E
T_D
A
TABASE
c
ontrol
a
s
a
.
.
.
commit
|
commitdiff
|
tree
2018-04-28
D
.
Rich
a
rd Hip
p
Merge
u
pdat
e
s f
r
om trunk
.
commit
|
commitdiff
|
tree
2018-04-28
D
.
Richard Hipp
Preve
n
t
d
eep
r
e
c
ur
s
ions
on
nested COLLATE ope
r
ato
r
s
.
commit
|
commitdiff
|
tree
2018-04-28
D
.
Richard
Hipp
Fix compile
r
warn
i
ngs in FTS3
.
commit
|
commitdiff
|
tree
2018-04-28
D
.
Richard Hipp
Add t
h
e "PRAG
M
A reset_database=ON|OFF"
c
om
m
and
.
When
.
.
.
commit
|
commitdiff
|
tree
2018-04-27
D
.
R
i
ch
a
rd
H
ipp
Enhance the comments in th
e
templatevtab
.
c imp
l
ementation
.
commit
|
commitdiff
|
tree
2018-04-26
D
.
Richard Hipp
Th
e
previous fix for ti
c
ket
[d85fffd6
f
fe85609
2
ed8da
.
.
.
commit
|
commitdiff
|
tree
2018-04-26
D
.
Richard
Hipp
E
n
sure th
a
t ne
w
.
*
v
a
l
ues of
a
n
U
PDATE do not
g
e
t
c
lobbered
.
.
.
commit
|
commitdiff
|
tree
2018-04-26
D
.
Richard
H
i
p
p
Clarifi
c
a
tion of the
b
eha
v
ior of a BEFORE
UPDA
T
E trigg
e
r
.
.
.
commit
|
commitdiff
|
tree
2018-04-26
D
.
Richa
r
d Hi
p
p
Impr
o
ved VDBE c
o
m
m
ent
on the OP_Param opcode
.
N
o
s
ubstantia
.
.
.
commit
|
commitdiff
|
tree
2018-04-25
D
.
Richa
r
d Hi
p
p
Add new interfaces for acces
s
i
n
g the li
s
t
of SQL key
w
ord
s
:
commit
|
commitdiff
|
tree
2018-04-25
D
.
Ri
c
h
ard H
i
pp
Add the new DO a
n
d N
O
T
HING keywords to th
e
k
eyword
.
.
.
commit
|
commitdiff
|
tree
2018-04-25
D
.
Richard
H
ipp
Add the new
S
QLIT
E
_
SHELL_INIT_PROC compil
e
-
t
ime entry
.
.
.
commit
|
commitdiff
|
tree
2018-04-25
D
.
R
ichard
H
ipp
Avoid many
unnecessary c
a
l
l
s to sqlit
e
3ReadSchem
a
(
.
.
.
commit
|
commitdiff
|
tree
2018-04-25
D
.
Rich
a
rd Hipp
A
d
d an
a
s
s
ert() to ensure that
sc
h
ema mutex
e
s are
held
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
Ri
c
hard Hipp
Do
n
ot
attempt t
o
use term
s
from the WHERE clause t
o
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
Ri
c
hard
Hipp
Up
d
ate the
exp
e
rt ex
t
e
n
s
ion test cases to account fo
r
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
R
ichard Hipp
All the OR optimization to proceed ev
e
n if t
h
e OR
is
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
Richard Hipp
Add a hyp
e
rli
n
k
t
o
th
e
tic
k
et on the cod
e
com
m
e
nt fo
r
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
Richar
d
Hi
p
p
Enhanc
e
the CLI to render
E
XPL
A
IN QUERY P
L
AN using
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
Rich
a
rd Hipp
Fix
a
memory lea
k
fo
l
lowing failure to open an e
x
ternal
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
Richard Hip
p
In E
X
PLAIN QUERY PLAN output,
d
o n
o
t show an EXEC
U
TE
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
Ric
h
ard Hipp
Fix to
c
heck-in
[ca34c2dd20ee071e] - avoid
a NULL p
o
inte
r
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Ric
h
ard
H
ipp
Fix a probl
e
m i
n
sqli
t
e
3
ExprCompare(
)
a
s
so
c
i
a
ted with
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Rich
a
rd Hipp
F
ix a formatting issue in the Tree
V
iew output
f
or bare
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Richard Hipp
Add the "
.
im
p
oster off" varia
n
t
o
f
the "
.
imposter"
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Richard H
i
pp
The "
.
s
e
lecttrace 0x2000" command causes just
th
e
t
op
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Ri
c
hard Hip
p
The "
.
s
electtra
c
e 4" comm
a
nd now shows only a single
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Ri
c
hard Hipp
D
o
no
t
rest
o
re the iSelectId value
until after the
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Richard H
i
pp
In the "
.
selecttrace" outp
u
t, include the EXPLAIN QUERY
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Richa
r
d Hipp
Ensure t
h
at there ar
e
n
o bind-parameters
or incorrect
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Richar
d
Hipp
Fix an unreachable
branch ass
o
ciated wit
h
sta
c
k
overflow
.
.
.
commit
|
commitdiff
|
tree
2018-04-21
D
.
Richard Hipp
Performance
i
m
p
r
ov
e
ments on
t
h
e
main loop
of the
LEMO
N
.
.
.
commit
|
commitdiff
|
tree
2018-04-21
D
.
Richard Hipp
Enhance L
E
MO
N
to track
w
hich symbo
l
s
a
ctu
a
lly
c
arry
.
.
.
commit
|
commitdiff
|
tree
2018-04-21
D
.
Richard Hipp
Add
the %extra_cont
e
xt directive to
le
m
on
,
as an a
l
ternat
i
ve
.
.
.
commit
|
commitdiff
|
tree
2018-04-21
D
.
Richa
r
d H
i
pp
F
i
x
U
PSE
R
T
so th
a
t
i
t pla
y
s n
i
cely wi
t
h AUTOINCRE
M
ENT
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Richard Hipp
Add the -dDIRECTOR
Y
c
ommand
-
line option to LEMO
N
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Richard Hipp
Fix
a
h
ar
m
less compile
r
warning
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Richard Hipp
Avoid the use of st
a
temen
t
j
o
urnals on DELET
E
s of a
.
.
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Richard Hipp
Avoi
d
o
p
ening a state
m
ent jo
u
rn
a
l
o
n
sin
g
le-
r
ow
UPDATEs
.
.
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Richard Hipp
Fix
a VDBE c
o
mment on upsert
.
Provide an error me
s
sage
.
.
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Richard Hipp
A
v
oid unne
c
essary
cursor
s
e
e
king when performi
n
g an
.
.
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Richard Hipp
Im
p
roved VD
B
E
comment on UPSERT code
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
R
i
chard Hip
p
Minor simplific
a
t
ion of the
p
r
e
vious che
c
kin
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Richard Hipp
A
vo
i
d unn
e
ce
s
s
a
ry cursor seeks d
u
ring upsert
proce
s
sin
g
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Richard Hipp
E
n
hance U
P
SERT so t
h
at
the
UP
D
ATE uses the
s
ame set
.
.
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
R
i
chard Hipp
Minor simplificati
o
n of th
e
c
ursor alloca
t
ion logic
.
.
.
commit
|
commitdiff
|
tree
2018-04-19
D
.
Richard Hipp
Fix the h
a
ndling of "PRAGMA count_changes=ON"
w
it
h
.
.
.
commit
|
commitdiff
|
tree
2018-04-19
D
.
Richard Hipp
Minor
s
imp
l
if
i
cation to the upse
r
t
logic
.
commit
|
commitdiff
|
tree
2018-04-19
D
.
Richard Hip
p
A
d
d
t
he --
u
p
sert opti
o
n to the wordcount
test p
r
o
gram
.
commit
|
commitdiff
|
tree
2018-04-19
D
.
Richar
d
Hi
p
p
Add the ext
/
misc/templatevtab
.
c
t
e
mplate for vi
r
t
ua
l
.
.
.
commit
|
commitdiff
|
tree
2018-04-19
D
.
Richard Hipp
Fix a p
r
oblem in the new
upsert imple
m
ention, discovered
.
.
.
commit
|
commitdiff
|
tree
2018-04-19
D
.
Richard H
i
pp
Fix th
e
table nam
e
alias
i
ng o
n
I
NSE
R
T so that it occur
s
.
.
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
R
icha
r
d Hipp
A
voi
d
a NULL
-
p
o
inter deref
following OOM
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richard Hipp
Fix a test case inside di
s
tinct
.
test
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richard Hipp
Im
p
roved matc
h
ing of COLLATE clause
s
within the ON
.
.
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
R
i
chard Hipp
Fix a pr
o
blem in the sqlite3ExprCom
p
a
re() function
.
.
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richard H
i
pp
Add
s
u
pport for
PostgreSQL UP
S
ERT syntax a
n
d functi
o
nality
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richard H
i
pp
Fix th
e
build for SQLITE_OMIT_UPSERT
commit
|
commitdiff
|
tree
2018-04-18
D
.
Ri
c
har
d
Hipp
A
dd the
-
-sorterref N op
t
ion to
t
he CLI
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richar
d
Hipp
Omit some code
not u
s
ed wit
h
o
ut SQLITE
_
ENABLE
_
SORTER_REFEREN
.
.
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
R
ichard Hipp
Re
m
ove an unused
local variable
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
R
ichard Hipp
Enhance
A
LTER TABL
E
ADD C
O
LUMN
t
o
s
upport
"
D
EFA
U
L
T
.
.
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richard Hipp
Add che
c
ks to
t
he CL
I
t
hat issue a warning if
S
QLit
e
.
.
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Ri
c
hard
H
ipp
A
dd
n
ew test
c
a
se(
)
m
a
cros and fix
a
bug that was
r
eve
a
led
.
.
.
commit
|
commitdiff
|
tree
2018-04-17
D
.
Richard Hipp
Remove unreachable branches
.
100% MC/DC in TH3
now
.
commit
|
commitdiff
|
tree
2018-04-17
D
.
Ric
h
ard H
i
pp
Added a co
m
ment on t
h
e as
s
ert(
)
added to the previou
s
.
.
.
commit
|
commitdiff
|
tree
2018-04-17
D
.
Richard Hipp
Fixes to the logic for constraint check re
o
rdering
.
.
.
commit
|
commitdiff
|
tree
2018-04-17
D
.
Richard Hipp
During PRAG
M
A
vd
b
e_addoptrace=ON, show calls to
sqlit
e
3VdbeR
.
.
.
commit
|
commitdiff
|
tree
2018-04-17
D
.
Richar
d
Hipp
TK_REG
I
STER expression
s
nodes are probably not c
o
nsta
n
t
.
.
.
commit
|
commitdiff
|
tree
2018-04-17
D
.
Richard Hipp
Simplificatio
n
to
t
he ups
e
r
t logic
.
commit
|
commitdiff
|
tree
2018-04-17
D
.
R
i
ch
a
rd Hipp
New test cases
f
or upsert
.
commit
|
commitdiff
|
tree
2018-04-16
D
.
R
ichard
H
ipp
Me
r
ge the Lemon
enhancement from
trun
k
, res
u
lti
n
g in
.
.
.
commit
|
commitdiff
|
tree
2018-04-16
D
.
Ric
h
ard
H
ipp
L
emon enhancements
:
(1) Do
not allocate spac
e
for
.
.
.
commit
|
commitdiff
|
tree
2018-04-16
D
.
R
ichard Hipp
R
e
move th
e
MySQL upsert syntax
.
A
s an optional al
i
a
s
.
.
.
commit
|
commitdiff
|
tree
2018-04-16
D
.
Richar
d
H
i
pp
Add s
u
pport
f
or the "e
x
cluded
.
*"
n
ames in
t
h
e UPDAT
E
.
.
.
commit
|
commitdiff
|
tree
2018-04-16
D
.
Ri
c
hard H
i
p
p
Merge c
h
anges from trunk
.
commit
|
commitdiff
|
tree
2018-04-16
D
.
Ric
h
a
r
d
H
i
p
p
In
c
r
ease
the ver
s
i
on n
u
mber to 3
.
24
.
0
commit
|
commitdiff
|
tree
2018-04-16
D
.
Ric
h
ard
H
i
pp
Reduce the siz
e
of the
NameC
o
nt
e
x
t
object by grou
p
i
n
g
.
.
.
commit
|
commitdiff
|
tree
2018-04-14
D
.
Richard Hipp
G
et upser
t
wor
k
ing
o
n
WITHOUT ROWID tables
.
commit
|
commitdiff
|
tree
2018-04-14
D
.
Richard Hipp
Make sure con
s
traint checks occur in the cor
r
e
c
t ord
e
r
.
.
.
commit
|
commitdiff
|
tree
next