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 requirements marks. No code changes.
2018-05-04
D
.
Richard Hipp
Fix requirem
e
n
t
s mark
s
.
N
o code changes
.
commit
|
commitdiff
|
tree
2018-05-04
D
.
Richard Hipp
For th
e
am
a
lga
m
ation-tarball, enabl
e
F
TS5 and JSON1
.
.
.
commit
|
commitdiff
|
tree
2018-05-04
D
.
Richard H
i
pp
Make a sep
a
rate lim
b
in the EXPLAIN QUERY PLAN output
.
.
.
commit
|
commitdiff
|
tree
2018-05-03
D
.
Richard Hi
p
p
I
n ORDER BY LIMIT q
u
eries, try
to evaluate the ORDER
.
.
.
commit
|
commitdiff
|
tree
2018-05-03
D
.
Ric
h
ard Hipp
F
i
x
a branch that has become unre
a
chable due to re
c
e
n
t
.
.
.
commit
|
commitdiff
|
tree
2018-05-03
D
.
Ri
c
har
d
Hipp
Improve
d
security for
V
ACUUM
.
This check
-
in combines
.
.
.
commit
|
commitdiff
|
tree
2018-05-03
D
.
Richard Hipp
Overhaul
o
f EXPLAIN Q
U
ERY
PLA
N
.
The output is now in
.
.
.
commit
|
commitdiff
|
tree
2018-05-03
D
.
Richard Hipp
Optimizations to the new EQP
f
ra
m
ewo
r
k
.
commit
|
commitdiff
|
tree
2018-05-03
D
.
R
i
chard
Hipp
Enhance EXPLAIN QUERY PL
A
N to repor
t
the
g
eneration
.
.
.
commit
|
commitdiff
|
tree
2018-05-02
D
.
Richard Hipp
Mor
e
t
e
s
t case updates
.
Tests are all running now
.
commit
|
commitdiff
|
tree
2018-05-02
D
.
Ric
h
ard Hipp
Fix
test cases so that
t
h
e
y work wi
t
h
t
he new EXPLAIN
.
.
.
commit
|
commitdiff
|
tree
2018-05-02
D
.
Ric
h
ard
H
ipp
Impr
o
ved EQP output for recursiv
e
CT
E
s and multi-value
.
.
.
commit
|
commitdiff
|
tree
2018-05-02
D
.
Richard H
i
pp
Prevent
V
ACUUM
f
rom
r
un
n
i
ng any commands
in sqlite
_
maste
r
.
.
.
commit
|
commitdiff
|
tree
2018-05-02
D
.
R
i
chard
Hi
p
p
Fix a dangling-else problem th
a
t w
a
s c
a
u
s
ing
recursive
.
.
.
commit
|
commitdiff
|
tree
2018-05-02
D
.
Ric
h
ard Hi
p
p
Im
p
rovements to the EQ
P
d
i
splay for
c
ompound sele
c
t
.
.
.
commit
|
commitdiff
|
tree
2018-05-02
D
.
R
ic
h
a
r
d Hipp
Begin reengineering the EXPLAIN QU
E
R
Y
PLAN function
.
.
.
commit
|
commitdiff
|
tree
2018-05-01
D
.
R
i
chard Hip
p
The SQLITE_ALLO
W
_
SQLI
T
E
_
MAST
E
R_INDEX compi
l
e-tim
e
o
p
t
i
on
.
.
.
commit
|
commitdiff
|
tree
2018-04-30
D
.
Richard H
i
pp
Defer load
i
ng result column
v
a
lues into register
s
on
.
.
.
commit
|
commitdiff
|
tree
2018-04-28
D
.
Richard H
i
pp
Test cases added
f
o
r
SQLITE_DB
C
ONF
I
G_RESET_DAT
A
B
A
SE
.
commit
|
commitdiff
|
tree
2018-04-28
D
.
R
ichard Hipp
Add the
SQLITE_DBCONF
I
G_RESET
_
DATABASE cont
r
ol for
.
.
.
commit
|
commitdiff
|
tree
2018-04-28
D
.
R
ichard Hipp
Add th
e
SQL
I
TE_DBCONFIG_RESET_DA
T
A
B
ASE control as a
.
.
.
commit
|
commitdiff
|
tree
2018-04-28
D
.
Richard Hipp
Merge
updates from trunk
.
commit
|
commitdiff
|
tree
2018-04-28
D
.
R
ichard Hip
p
Pr
e
vent
d
eep recurs
i
ons on nested COLLATE opera
t
o
r
s
.
commit
|
commitdiff
|
tree
2018-04-28
D
.
Richard
Hipp
Fix compiler warnings in FTS3
.
commit
|
commitdiff
|
tree
2018-04-28
D
.
Richard Hipp
Add
the
"
P
RAGMA reset_
d
atabase=ON|OFF" comman
d
.
Wh
e
n
.
.
.
commit
|
commitdiff
|
tree
2018-04-27
D
.
Richard Hipp
Enhance
the
c
o
mments in the templatevtab
.
c implementation
.
commit
|
commitdiff
|
tree
2018-04-26
D
.
R
i
chard Hip
p
The previous fi
x
for ticket [d85fffd6ffe
8
5
6
092ed8da
.
.
.
commit
|
commitdiff
|
tree
2018-04-26
D
.
Richard
Hipp
Ensure that
new
.
*
v
alues of an UPDATE do n
o
t get clobbered
.
.
.
commit
|
commitdiff
|
tree
2018-04-26
D
.
R
ichard Hipp
Clarification of the behavior of a BEF
O
RE
U
P
D
ATE trigger
.
.
.
commit
|
commitdiff
|
tree
2018-04-26
D
.
Richard H
i
p
p
Improved
V
D
BE c
o
mment on the
OP_P
a
ram o
p
code
.
No subs
t
antia
.
.
.
commit
|
commitdiff
|
tree
2018-04-25
D
.
R
i
ch
a
rd Hipp
Add new interface
s
f
o
r
a
cce
s
sin
g
the list
o
f SQL ke
y
w
o
rds:
commit
|
commitdiff
|
tree
2018-04-25
D
.
Richard Hipp
Add the new DO an
d
NOTHING
keywords
t
o the keywo
r
d
.
.
.
commit
|
commitdiff
|
tree
2018-04-25
D
.
Richard Hipp
Ad
d
the n
e
w
S
QLI
T
E
_
S
HELL_INIT_PROC compile-t
i
me en
t
ry
.
.
.
commit
|
commitdiff
|
tree
2018-04-25
D
.
Ric
h
ard
Hipp
Av
o
i
d many unnecessary calls to sqlite3Re
a
dSchema(
.
.
.
commit
|
commitdiff
|
tree
2018-04-25
D
.
R
i
chard Hipp
Add an assert() to ensure t
h
at schem
a
mutexes are held
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
Ri
c
hard Hipp
D
o
not attempt to us
e
terms from the WHER
E
clause
t
o
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
Richard
Hipp
U
p
date th
e
expert
e
xtension test cases to account for
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
Richard Hipp
All the OR opti
m
i
z
atio
n
to pro
c
eed
e
ven if the OR is
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
Richa
r
d H
i
pp
A
d
d
a hype
r
lin
k
to
t
he ticket on the
c
ode
c
omm
e
nt
fo
r
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
Richard Hipp
Enhance
t
h
e CLI to render
E
XP
L
AIN QUERY
P
L
AN using
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
Richard Hipp
Fix
a
me
m
o
ry leak following fa
i
lu
r
e
to
o
pe
n
an e
x
ternal
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
Richard Hipp
In EXPL
A
IN QUERY PLAN output
,
d
o no
t
s
h
ow
a
n
E
XECUTE
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
Richard Hipp
Fix
t
o
check-in [ca34c2dd20ee071e] - avoid a NULL p
o
i
n
ter
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
R
i
chard Hipp
Fix a
p
roblem
i
n sqlite3ExprCompare() associ
a
ted with
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Richard Hipp
Fix a forma
t
ting issue i
n
t
h
e Tr
e
eVie
w
output for bare
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Richard Hi
p
p
Add the "
.
i
mposter off
"
variant
o
f the "
.
i
m
p
o
ste
r
"
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
R
ichard Hipp
The "
.
s
elec
t
trace 0
x
2000" command causes just
t
he top
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Richard Hipp
The
"
.
se
l
ecttrace 4" command now sh
o
ws only a single
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Richard
H
ipp
Do not restore the i
S
electId
value until af
t
er
t
he
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Richard
H
ipp
In th
e
"
.
select
t
race" output,
include the EXPLAIN QUERY
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Richard
H
ipp
Ensure
t
hat t
h
e
re a
r
e
n
o
bind-parameters o
r
incorrect
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Richard Hipp
Fix an unreachable branch asso
c
iated with stac
k
ov
e
r
f
l
ow
.
.
.
commit
|
commitdiff
|
tree
2018-04-21
D
.
Richard Hipp
P
e
r
f
orman
c
e
improvements on
t
he m
a
in loop
o
f
t
he LEMON
.
.
.
commit
|
commitdiff
|
tree
2018-04-21
D
.
Richard Hipp
E
n
h
a
nce LEMON to track whic
h
symbols ac
t
u
a
lly carry
.
.
.
commit
|
commitdiff
|
tree
2018-04-21
D
.
R
ichard Hipp
Add t
h
e %extra_con
t
ext direc
t
ive to lemon, as an alte
r
n
a
t
i
ve
.
.
.
commit
|
commitdiff
|
tree
2018-04-21
D
.
Richard Hipp
Fix UPS
E
RT so tha
t
it plays ni
c
ely with AUTO
I
NCR
E
M
E
N
T
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Richard Hipp
Add th
e
-
dDIRECTORY command-line option
to LE
M
ON
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
R
i
c
h
ard Hip
p
Fix a ha
r
mless
compi
l
er w
a
rni
n
g
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Richard Hipp
A
void the use
o
f stateme
n
t journals
on DELET
E
s of a
.
.
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Ric
h
ard H
i
pp
Avoi
d
opening a statement
j
o
urnal on si
n
gle-row UPDATE
s
.
.
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Rich
a
rd Hipp
Fix a VDBE com
m
ent on upsert
.
Provide
a
n er
r
o
r message
.
.
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Ri
c
h
ar
d
Hip
p
A
v
oid un
n
ecessary cu
r
sor se
e
king whe
n
performing an
.
.
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
R
ichard Hipp
Improv
e
d VDBE
comment on UPSER
T
c
ode
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
R
i
chard
H
ipp
M
inor simplifi
c
a
ti
o
n of the
p
r
evious checkin
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Richar
d
Hipp
Avoid unnecessary
c
u
r
sor seeks during up
s
ert processing
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Richard Hipp
Enhanc
e
UPSERT so that the UPDATE uses the same set
.
.
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Richar
d
Hip
p
Min
o
r simplification of t
h
e curs
o
r a
l
location l
o
gic
.
.
.
commit
|
commitdiff
|
tree
2018-04-19
D
.
R
icha
r
d Hipp
Fix the ha
n
dling of "PRAGMA
count_c
h
a
n
ge
s
=O
N
"
w
i
t
h
.
.
.
commit
|
commitdiff
|
tree
2018-04-19
D
.
Richa
r
d H
i
pp
Minor
s
im
p
lif
i
cati
o
n to the
upsert lo
g
i
c
.
commit
|
commitdiff
|
tree
2018-04-19
D
.
Richard Hipp
Add the
-
-
u
p
sert option to
the wordc
o
un
t
te
s
t
program
.
commit
|
commitdiff
|
tree
2018-04-19
D
.
Richar
d
Hipp
Add the ext/misc/templ
a
tevt
a
b
.
c
t
emplate for v
i
rtual
.
.
.
commit
|
commitdiff
|
tree
2018-04-19
D
.
Richar
d
Hipp
Fix a probl
e
m in the new u
p
ser
t
implemention, discover
e
d
.
.
.
commit
|
commitdiff
|
tree
2018-04-19
D
.
Richard
H
ipp
Fix
t
he
t
a
b
le name aliasing on IN
S
E
R
T so th
a
t it occurs
.
.
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richard
H
ipp
Avoid
a
NULL
-
p
o
inter der
e
f
following OOM
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Ric
h
ard Hi
p
p
Fi
x
a test case inside
d
i
s
tinct
.
test
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richard Hipp
Im
p
roved matchi
n
g of COL
L
ATE
clauses withi
n
the ON
.
.
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richard Hipp
F
ix
a
problem in the sqlit
e
3ExprCompa
r
e() function
.
.
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richard H
i
pp
A
dd support for PostgreSQL UPSER
T
syntax and functionality
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richard Hipp
Fix the build for S
Q
LITE_OMIT
_
UPSERT
commit
|
commitdiff
|
tree
2018-04-18
D
.
R
i
c
hard Hipp
Add the --sor
t
erref N option
to
the CLI
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Rich
a
rd Hipp
Omit
some
code n
o
t used
without SQLITE_E
N
ABLE_SORTER_
R
EFEREN
.
.
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richard H
i
pp
Remove an unused local
v
ariable
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richard Hipp
Enhanc
e
A
L
T
ER
T
ABLE
A
DD
COLUMN to suppo
r
t
"
D
E
FAULT
.
.
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richard Hipp
Add
check
s
t
o
the C
L
I th
a
t issue a w
a
rning if
SQLite
.
.
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Ri
c
hard Hipp
A
d
d
n
ew
t
e
stc
a
se() macros and fix
a
bug th
a
t was
r
evealed
.
.
.
commit
|
commitdiff
|
tree
2018-04-17
D
.
Richa
r
d
H
ipp
Remo
v
e
u
n
r
eachab
l
e
branches
.
100% MC/DC in TH3 now
.
commit
|
commitdiff
|
tree
2018-04-17
D
.
Ric
h
a
rd Hipp
Added a c
o
mment on
t
h
e
assert()
added to the previous
.
.
.
commit
|
commitdiff
|
tree
2018-04-17
D
.
Richard Hipp
F
ixes to the logic for constraint check reord
e
r
i
ng
.
.
.
commit
|
commitdiff
|
tree
2018-04-17
D
.
Ric
h
ar
d
Hip
p
During PRAGMA vdbe_add
o
ptrace=
O
N, show ca
l
ls
to sqlite
3
VdbeR
.
.
.
commit
|
commitdiff
|
tree
2018-04-17
D
.
Ric
h
a
rd
Hipp
T
K
_REGI
S
TER expressions nod
e
s a
r
e pr
o
bably
not constant
.
.
.
commit
|
commitdiff
|
tree
2018-04-17
D
.
Ri
c
h
ar
d
H
ipp
S
imp
l
ification to the upsert logic
.
commit
|
commitdiff
|
tree
2018-04-17
D
.
Richard Hip
p
New t
e
st cases
f
or up
s
ert
.
commit
|
commitdiff
|
tree
2018-04-16
D
.
Richard Hipp
Merge the Lemo
n
e
nhancement fr
o
m tr
u
nk, result
i
ng
i
n
.
.
.
commit
|
commitdiff
|
tree
2018-04-16
D
.
Ric
h
ard Hipp
Lemon enhancements: (1) D
o
no
t
allocat
e
space for
.
.
.
commit
|
commitdiff
|
tree
2018-04-16
D
.
Richa
r
d Hip
p
Remove the
MyS
Q
L upsert syn
t
ax
.
As
an
o
ptional
a
lias
.
.
.
commit
|
commitdiff
|
tree
2018-04-16
D
.
Richard
Hipp
Add su
p
port for th
e
"ex
c
luded
.
*" names in
the U
P
DATE
.
.
.
commit
|
commitdiff
|
tree
2018-04-16
D
.
Richard Hipp
M
er
g
e
chan
g
es from trunk
.
commit
|
commitdiff
|
tree
2018-04-16
D
.
Richard Hipp
Incr
e
as
e
the versio
n
n
umber t
o
3
.
2
4
.
0
commit
|
commitdiff
|
tree
2018-04-16
D
.
Richar
d
Hipp
Red
u
ce the s
i
z
e of
t
h
e
Nam
e
Context object by group
i
n
g
.
.
.
commit
|
commitdiff
|
tree
2018-04-14
D
.
Rich
a
rd Hipp
G
e
t
ups
e
rt
w
orki
n
g on WI
T
HOUT ROWID tables
.
commit
|
commitdiff
|
tree
next