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
Add the SQLITE_DBCONFIG_RESET_DATABASE control as a replacement for
2018-04-28
D
.
Ri
c
h
ard Hipp
A
dd the
S
QLITE_DBCONFIG_RESET_DATABASE
c
o
n
trol as
a
.
.
.
commit
|
commitdiff
|
tree
2018-04-28
D
.
Richar
d
H
i
p
p
Merge
u
p
dates f
r
om trunk
.
commit
|
commitdiff
|
tree
2018-04-28
D
.
Richard
H
ipp
Pre
v
ent
d
eep recursio
n
s o
n
n
e
sted C
O
LLATE o
p
era
t
ors
.
commit
|
commitdiff
|
tree
2018-04-28
D
.
Richard Hipp
Fix compiler warn
i
ngs in FT
S
3
.
commit
|
commitdiff
|
tree
2018-04-28
D
.
Richard
H
ip
p
Add the "PR
A
GMA
reset_d
a
tab
a
s
e=ON|OFF
"
com
m
and
.
When
.
.
.
commit
|
commitdiff
|
tree
2018-04-27
D
.
R
ichard Hipp
E
nhance the commen
t
s in the templatev
t
ab
.
c imp
l
ementation
.
commit
|
commitdiff
|
tree
2018-04-26
D
.
Richard Hipp
The previou
s
fix for ticket
[
d
8
5fffd6ffe856092ed8
d
a
.
.
.
commit
|
commitdiff
|
tree
2018-04-26
D
.
R
i
chard Hipp
En
s
u
re that new
.
* values of an UPDATE do not
g
et
clobbered
.
.
.
commit
|
commitdiff
|
tree
2018-04-26
D
.
Richard Hip
p
Clarification of
t
he b
e
havi
o
r of
a BEFORE UPDA
T
E
t
rigger
.
.
.
commit
|
commitdiff
|
tree
2018-04-26
D
.
Richard Hipp
Improved VDBE comment on
t
h
e
OP
_
Para
m
opco
d
e
.
No substantia
.
.
.
commit
|
commitdiff
|
tree
2018-04-25
D
.
Richard Hip
p
Add new interfaces fo
r
a
c
cessing the list
o
f
SQL keywor
d
s:
commit
|
commitdiff
|
tree
2018-04-25
D
.
Richard
H
i
pp
Add the new DO and
NOTHING keywords to the k
e
ywo
r
d
.
.
.
commit
|
commitdiff
|
tree
2018-04-25
D
.
Richard Hip
p
Add the new SQLITE_SHELL_INIT_PROC compi
l
e
-time e
n
try
.
.
.
commit
|
commitdiff
|
tree
2018-04-25
D
.
Richard Hipp
Avoid many unnecess
a
ry calls to sqlite3ReadSchema(
.
.
.
commit
|
commitdiff
|
tree
2018-04-25
D
.
Richard Hipp
Add an ass
e
r
t
() t
o
e
nsure that schema mutexes are
h
eld
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
Richard Hi
p
p
Do not attempt to use
terms fr
o
m
the WH
E
RE clause to
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
Richard Hipp
Update the exp
e
rt extension test
cases to
a
c
c
ount for
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
Ric
h
a
rd H
i
p
p
All the OR
optimizatio
n
to
proceed e
v
en if the OR
is
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
Ric
h
ard Hipp
Add a hyp
e
rlink t
o
the ticket
on
t
he code c
o
m
m
ent
for
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
Richa
r
d Hipp
Enh
a
n
c
e t
h
e
CLI to render EXPLAIN QUERY PLAN using
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
R
i
ch
a
r
d
Hipp
Fix
a
memory leak follow
i
ng failure to open an external
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
Richard H
i
pp
In
E
XPLAIN QUERY PLAN output,
do not show an EX
E
C
U
TE
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
Richard Hipp
F
ix
t
o
check-in [
c
a34c2dd20ee071e] -
avo
i
d a NULL pointer
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
R
i
cha
r
d Hipp
Fix
a
probl
e
m in sq
l
ite3Exp
r
Compa
r
e(
)
assoc
i
ated with
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
R
ichard Hipp
Fix a f
o
rma
t
t
ing iss
u
e
in the
TreeView
output for bare
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Richa
r
d
H
ipp
Add the "
.
impo
s
ter
o
f
f" variant o
f
t
he "
.
imp
o
s
ter"
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Richa
r
d Hipp
T
h
e "
.
selec
t
t
r
ace 0x2000" command cause
s
just the top
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Ri
c
h
a
rd Hipp
T
he "
.
s
electtrace 4" co
m
m
and now
sh
o
ws only
a
sing
l
e
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Ric
h
a
rd Hi
p
p
Do not restore the iSelectId value un
t
il afte
r
the
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Richard
H
i
pp
In
t
he "
.
sele
c
ttrace" out
p
ut, i
n
cl
u
d
e
the EXPLA
I
N Q
U
ERY
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Ric
h
ard
Hipp
Ensure that ther
e
a
r
e no bind-
p
aram
e
ters or
i
ncor
r
ect
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Richard H
i
pp
Fix
an unreach
a
ble
b
r
anc
h
as
s
ociated with
s
t
ack overflow
.
.
.
commit
|
commitdiff
|
tree
2018-04-21
D
.
Richard Hipp
Perf
o
rmance improvements on th
e
mai
n
loop of the
L
EM
O
N
.
.
.
commit
|
commitdiff
|
tree
2018-04-21
D
.
Richard Hi
p
p
Enhance LEMON to trac
k
which
symbols actually carry
.
.
.
commit
|
commitdiff
|
tree
2018-04-21
D
.
Richard H
i
pp
Add the %extra_context directive to lemon
,
as
a
n alte
r
native
.
.
.
commit
|
commitdiff
|
tree
2018-04-21
D
.
Richard H
i
pp
Fix UPSERT s
o
that it
p
lays nicely with AU
T
OINCREMENT
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
R
ichard H
i
pp
A
dd the
-dD
I
R
ECTORY
command-line op
t
ion to
LEMON
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Richard
Hi
p
p
F
ix a h
a
r
m
less compiler war
n
ing
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Rich
a
rd Hip
p
Avoi
d
the u
s
e of statement j
o
urnals on DE
L
E
TEs of
a
.
.
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Richard Hi
p
p
Av
o
id opening a state
m
ent journal on single-ro
w
UPDATEs
.
.
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Richard Hipp
Fix
a VD
B
E
c
omme
n
t on upsert
.
Pr
o
vide an
e
r
ror
messag
e
.
.
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
R
i
chard H
i
pp
Avoi
d
u
n
n
ecessary
c
ursor
seeki
n
g when perfo
r
mi
n
g an
.
.
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Richard Hipp
I
m
proved VDB
E
com
m
ent on UPSERT code
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Richard Hipp
Minor s
i
m
p
lifica
t
ion of the
p
r
eviou
s
checkin
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Richard
H
i
p
p
Avoid unn
e
cessary cursor
seeks during upser
t
p
r
ocessin
g
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
R
ichard Hipp
E
nhance UPSERT
so that t
h
e UP
D
ATE us
e
s the same set
.
.
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Richard Hipp
M
i
no
r
simplification of the cursor
al
l
ocation logi
c
.
.
.
commit
|
commitdiff
|
tree
2018-04-19
D
.
Richard Hi
p
p
Fix the
h
an
d
l
in
g
of "PRAGM
A
count
_
changes=O
N
"
w
ith
.
.
.
commit
|
commitdiff
|
tree
2018-04-19
D
.
Richard Hipp
Mi
n
o
r simplification
t
o the upsert logic
.
commit
|
commitdiff
|
tree
2018-04-19
D
.
Richard Hipp
Add the --
u
psert opt
i
on to the
w
ordcount tes
t
program
.
commit
|
commitdiff
|
tree
2018-04-19
D
.
Ri
c
hard Hipp
Add the ex
t
/m
i
sc/
t
emplat
e
vtab
.
c tem
p
late for virtual
.
.
.
commit
|
commitdiff
|
tree
2018-04-19
D
.
Ric
h
a
r
d Hipp
Fi
x
a pr
o
b
lem i
n
the new upsert implemen
t
ion, discovered
.
.
.
commit
|
commitdiff
|
tree
2018-04-19
D
.
Richard Hi
p
p
F
i
x the ta
b
le n
a
me alia
s
ing on IN
S
ERT so
t
hat it occurs
.
.
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richard Hipp
Avoid a NULL-poin
t
er
d
eref
foll
o
wing O
O
M
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richa
r
d
H
ipp
Fix a test cas
e
inside distinct
.
test
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
R
ichard Hipp
Impro
v
ed matc
h
i
n
g of
COLLAT
E
clau
s
es
within the ON
.
.
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Rich
a
rd Hipp
Fix a pr
o
blem in the sq
l
ite
3
Ex
p
rCompare() function
.
.
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Ri
c
hard Hipp
A
d
d support for Pos
t
greSQL UPSERT synta
x
an
d
functionality
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
R
icha
r
d
Hip
p
Fi
x
the build for
S
Q
LITE_OMIT_UPSERT
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richa
r
d Hipp
Add th
e
--sorterref N option to the
C
LI
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Ric
h
ard Hipp
Omit
so
m
e
code not used
w
ith
o
ut SQ
L
ITE_ENABLE_
S
ORTER_RE
F
ERE
N
.
.
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richard Hipp
Remove an unused
local
v
ariable
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
R
i
chard Hipp
En
h
ance ALTER TABLE A
D
D COLUMN to supp
o
r
t "DE
F
A
U
L
T
.
.
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richard Hipp
Add chec
k
s to the CLI that issu
e
a warning if
S
Q
Lit
e
.
.
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richa
r
d Hi
p
p
Add new testcase() macros and fi
x
a bug tha
t
was reveal
e
d
.
.
.
commit
|
commitdiff
|
tree
2018-04-17
D
.
Richard Hipp
Remove unrea
c
hable branches
.
100%
MC/DC
i
n TH3 now
.
commit
|
commitdiff
|
tree
2018-04-17
D
.
Richard Hipp
Adde
d
a comment on t
h
e asser
t
() a
d
ded to the
previous
.
.
.
commit
|
commitdiff
|
tree
2018-04-17
D
.
Ri
c
hard Hip
p
Fixes to t
h
e l
o
gic for constraint
c
heck reorderi
n
g
.
.
.
commit
|
commitdiff
|
tree
2018-04-17
D
.
Ric
h
a
r
d H
i
pp
Durin
g
PRAGM
A
vdb
e
_
addoptrace=ON, show
c
alls to sqlite3VdbeR
.
.
.
commit
|
commitdiff
|
tree
2018-04-17
D
.
R
ichard Hipp
TK_REGISTER expressions nodes are pr
o
b
a
bly
n
ot c
o
nstant
.
.
.
commit
|
commitdiff
|
tree
2018-04-17
D
.
Richar
d
H
i
pp
S
implifi
c
at
i
on to the upsert logic
.
commit
|
commitdiff
|
tree
2018-04-17
D
.
Rich
a
rd Hipp
New test c
a
ses for upsert
.
commit
|
commitdiff
|
tree
2018-04-16
D
.
Rich
a
rd
H
ipp
Merge t
h
e Le
m
on enhancement from trunk, resulting in
.
.
.
commit
|
commitdiff
|
tree
2018-04-16
D
.
R
i
chard Hipp
Lemon en
h
ancements: (1) Do n
o
t
allocate space for
.
.
.
commit
|
commitdiff
|
tree
2018-04-16
D
.
Richard Hipp
Remove the
M
ySQL
upse
r
t syntax
.
As an optional
a
l
i
a
s
.
.
.
commit
|
commitdiff
|
tree
2018-04-16
D
.
Richard Hipp
Add
support for the "excluded
.
*"
names in the UP
D
AT
E
.
.
.
commit
|
commitdiff
|
tree
2018-04-16
D
.
R
ichard Hipp
Merge cha
n
ges f
r
om trunk
.
commit
|
commitdiff
|
tree
2018-04-16
D
.
Richard Hipp
I
n
creas
e
th
e
version nu
m
ber to 3
.
24
.
0
commit
|
commitdiff
|
tree
2018-04-16
D
.
Ric
h
ard Hipp
Reduce the size of t
h
e Name
C
o
n
text ob
j
ect by grouping
.
.
.
commit
|
commitdiff
|
tree
2018-04-14
D
.
Richard
Hipp
Get upsert w
o
rking on
WITHOUT ROWI
D
t
ables
.
commit
|
commitdiff
|
tree
2018-04-14
D
.
Richard
H
ipp
Make sure co
n
s
t
ra
i
nt che
c
ks
o
c
cur
in the correct or
d
er
.
.
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
Richard Hipp
Fi
r
st cut at l
o
gi
c
to
p
erform DO
U
P
DATE for rowid tables
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
Richard Hipp
Add infrastructure for do
i
ng an U
P
DA
T
E as part of an
.
.
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
Rich
a
r
d
Hipp
Merge the p
r
eup
d
ate
hook change from trunk
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
Ri
c
har
d
Hip
p
Re
m
o
ve an alw
a
y
s
-true branch from
the pr
e
update h
o
ok
.
.
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
Ri
c
hard Hipp
Get
the ON CONFLICT
DO NOT
H
ING form of upsert working
.
.
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
Richa
r
d H
i
pp
Get the conflict-target
claus
e
parsing w
o
rking correctly
.
.
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
Richar
d
H
ipp
Improved conflict
-
t
arg
e
t mat
c
hing logic
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
Rich
a
rd Hipp
Bac
k
off o
f
the extended upsert
s
yntax t
h
at allows
.
.
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
Richard Hipp
Begin adding ups
e
rt log
i
c
.
Th
i
s is an incr
e
mental
.
.
.
commit
|
commitdiff
|
tree
2018-04-12
D
.
R
ichard Hipp
Break out th
e
upsert code into
a
separat
e
source file
.
commit
|
commitdiff
|
tree
2018-04-12
D
.
Richar
d
H
ipp
F
ix another typo
in a comment
.
commit
|
commitdiff
|
tree
2018-04-12
D
.
Richa
r
d Hipp
S
imple comment clarificat
i
on
.
N
o
code or l
o
g
i
c
chang
e
s
.
commit
|
commitdiff
|
tree
2018-04-12
D
.
Rich
a
rd Hip
p
E
x
tend the upser
t
syntax to allow a WHERE clause o
n
.
.
.
commit
|
commitdiff
|
tree
2018-04-12
D
.
Ric
h
ard Hipp
U
p
d
ate the
u
psert pars
i
ng so that it accept
s
c
o
n
f
li
c
t
.
.
.
commit
|
commitdiff
|
tree
2018-04-12
D
.
Richa
r
d Hipp
Add the Upsert object
for holdi
n
g upse
r
t clause
informat
i
on
.
commit
|
commitdiff
|
tree
2018-04-12
D
.
Richard Hipp
Merge changes from trunk
.
commit
|
commitdiff
|
tree
2018-04-11
D
.
Richard
Hipp
H
e
lp the
p
arser r
u
n faster by avo
i
d
i
n
g
the "expl
a
in
.
.
.
commit
|
commitdiff
|
tree
2018-04-11
D
.
Richard H
i
pp
Prohibit bound parameters in the arguments
to table
.
.
.
commit
|
commitdiff
|
tree
2018-04-10
D
.
Richard Hipp
Version
3
.
2
3
.
1
commit
|
commitdiff
|
tree
next