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
.
Ric
h
ard Hipp
Add the SQL
I
T
E
_DBCONFIG_R
E
S
ET_DA
T
ABASE
c
ontrol as a
.
.
.
commit
|
commitdiff
|
tree
2018-04-28
D
.
Richard
H
i
p
p
Merge
updates fr
o
m trunk
.
commit
|
commitdiff
|
tree
2018-04-28
D
.
Rich
a
rd Hip
p
Pr
e
vent deep recursions on nested COLLATE o
p
erato
r
s
.
commit
|
commitdiff
|
tree
2018-04-28
D
.
R
ic
h
a
r
d Hi
p
p
F
i
x compiler war
n
ing
s
in FTS3
.
commit
|
commitdiff
|
tree
2018-04-28
D
.
Richard
H
ipp
Add th
e
"PRAGMA re
s
et_d
a
t
a
bas
e
=ON|OFF" command
.
When
.
.
.
commit
|
commitdiff
|
tree
2018-04-27
D
.
Ri
c
ha
r
d Hipp
Enhance the
comments in t
h
e tem
p
latevtab
.
c
implemen
t
ation
.
commit
|
commitdiff
|
tree
2018-04-26
D
.
Richa
r
d Hipp
The previous
f
ix for
ticket [d85fffd6ffe8560
9
2ed8da
.
.
.
commit
|
commitdiff
|
tree
2018-04-26
D
.
Richard Hi
p
p
Ensure that new
.
* va
l
ues of an UPDATE do n
o
t
get clobbere
d
.
.
.
commit
|
commitdiff
|
tree
2018-04-26
D
.
Richa
r
d Hipp
Clarification of
the behavior of a B
E
FORE UPDATE tr
i
gger
.
.
.
commit
|
commitdiff
|
tree
2018-04-26
D
.
Richard H
i
pp
Impro
v
ed VDBE commen
t
o
n the OP_Param o
p
code
.
No
s
ubs
t
antia
.
.
.
commit
|
commitdiff
|
tree
2018-04-25
D
.
Ri
c
hard H
i
pp
Add new inter
f
aces for accessing the l
i
s
t of SQL keywords:
commit
|
commitdiff
|
tree
2018-04-25
D
.
R
i
chard
H
ipp
Add the new
DO and NOTHING
keywo
r
ds
t
o the keyword
.
.
.
commit
|
commitdiff
|
tree
2018-04-25
D
.
Ric
h
ard
H
ipp
Add the n
e
w S
Q
LITE_
S
HELL_I
N
IT_PR
O
C compile-
t
ime entry
.
.
.
commit
|
commitdiff
|
tree
2018-04-25
D
.
R
ichard Hi
p
p
Avoi
d
many unnecessary calls to sq
l
i
t
e
3
Rea
d
Schema(
.
.
.
commit
|
commitdiff
|
tree
2018-04-25
D
.
Richard Hipp
Add an
asse
r
t
(
) t
o
e
n
sure that schema mut
e
x
e
s
ar
e
hel
d
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
Richard Hipp
Do not attempt t
o
us
e
terms f
r
o
m
the WH
E
RE clause to
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
Richard Hi
p
p
Update the expert ex
t
ensio
n
t
est case
s
to accoun
t
for
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
R
i
c
h
a
r
d
Hi
p
p
All th
e
OR opt
i
mi
z
a
ti
o
n
t
o proceed even if the
O
R is
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
Richard
Hipp
Add a
hyp
e
r
l
ink to the ticket on the c
o
de com
m
en
t
for
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
Rich
a
rd H
i
p
p
En
h
a
n
ce the
CLI to render EXPLAIN QUE
R
Y PLAN using
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
Richard Hipp
Fix a
memory leak fol
l
ow
i
ng failure to open
an exter
n
al
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
Rich
a
rd Hipp
In
EXP
L
AIN QU
E
RY PLAN
out
p
ut, do not sh
o
w
a
n EXECUTE
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
Richard Hipp
Fix to che
c
k-in [ca34c2dd20ee071e] - avoid
a NUL
L
pointer
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Richard Hipp
Fix
a problem in sqli
t
e
3ExprComp
a
re() a
s
s
o
ciated with
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Rich
a
rd
Hipp
Fix a formatting issue
i
n the TreeV
i
ew output for bare
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Ric
h
ard
H
ipp
Add the "
.
imp
o
ster
off" vari
a
nt of
t
he "
.
im
p
oster"
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
R
i
chard Hipp
The "
.
s
elect
t
race
0
x2000
"
command
cau
s
es just th
e
top
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Richard
Hipp
The "
.
selecttrace 4
"
command no
w
s
hows
only a sin
g
le
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Richard Hipp
Do no
t
restore
the iSelectId value
unt
i
l a
f
te
r
the
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Ric
h
a
r
d Hipp
In
t
he "
.
selecttra
c
e" output
,
inclu
d
e the EXPLAIN QUERY
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Richard Hipp
Ensure that
t
her
e
are no
b
i
n
d
-paramet
e
rs o
r
incorrect
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Richard Hip
p
Fix a
n
unreachable branch asso
c
i
a
t
ed with
s
tack
overflow
.
.
.
commit
|
commitdiff
|
tree
2018-04-21
D
.
Richard Hi
p
p
Performance imp
r
ovement
s
on
t
he main loop of
t
h
e
LE
M
O
N
.
.
.
commit
|
commitdiff
|
tree
2018-04-21
D
.
R
i
chard Hip
p
Enh
a
nce LEMON to
track
which symbols actually carry
.
.
.
commit
|
commitdiff
|
tree
2018-04-21
D
.
Richard Hipp
Add the %
e
xtr
a
_c
o
n
t
ext dir
e
cti
v
e to lemo
n
, as an alternative
.
.
.
commit
|
commitdiff
|
tree
2018-04-21
D
.
Richard Hipp
Fix UPS
E
RT so
t
hat it
p
lay
s
ni
c
e
l
y w
i
th AUTOINCRE
M
ENT
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
R
ichard Hipp
Add
t
he -dDIRECTORY c
o
m
m
a
n
d-line option
t
o
L
EMON
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Ri
c
hard Hip
p
Fix
a
harmless compiler warning
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Richard Hi
p
p
Avoid the u
s
e of
s
tat
e
ment journals on DE
L
ETEs of a
.
.
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Rich
a
rd
H
ipp
Avoid
o
p
ening
a st
a
te
m
ent journ
a
l on sin
g
le-row UPDATEs
.
.
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Richard Hipp
F
i
x a VDBE comment
o
n upsert
.
Provide a
n
error me
s
sage
.
.
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Richa
r
d Hipp
Avoid unn
e
ces
s
ary cur
s
or se
e
king whe
n
performing a
n
.
.
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Ri
c
h
a
rd
Hi
p
p
I
m
proved VDBE
c
ommen
t
on UPSERT code
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Richar
d
Hipp
M
i
nor simplificati
o
n of the pr
e
vious c
h
eckin
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Richard Hipp
Avo
i
d
u
nnecessary curso
r
seeks d
u
ri
n
g upsert p
r
ocessing
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Richar
d
Hip
p
Enha
n
ce UPSERT s
o
th
a
t the
UPDATE use
s
the same set
.
.
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Ric
h
ard Hipp
M
i
nor
simplificatio
n
of t
h
e cursor al
l
ocation log
i
c
.
.
.
commit
|
commitdiff
|
tree
2018-04-19
D
.
Richa
r
d Hipp
Fix the han
d
li
n
g of
"PRAGMA count_changes=ON" wit
h
.
.
.
commit
|
commitdiff
|
tree
2018-04-19
D
.
Richard Hipp
Mi
n
or
sim
p
lifi
c
ation to the upsert logic
.
commit
|
commitdiff
|
tree
2018-04-19
D
.
R
ichar
d
Hipp
Add the --upsert option to the wordcount test program
.
commit
|
commitdiff
|
tree
2018-04-19
D
.
Rich
a
rd Hipp
A
d
d the ext/misc/
t
empl
a
t
e
vtab
.
c
t
e
m
p
late for
v
ir
t
ua
l
.
.
.
commit
|
commitdiff
|
tree
2018-04-19
D
.
Richard
Hi
p
p
Fix
a
pr
o
b
lem in
the n
e
w upsert
implement
i
o
n
,
discovered
.
.
.
commit
|
commitdiff
|
tree
2018-04-19
D
.
Richa
r
d
H
ipp
Fix the table name aliasing on INSERT
so that it occurs
.
.
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Ri
c
h
ard
H
ipp
A
v
o
id a
NULL-pointer deref
following OOM
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Ric
h
a
rd H
i
pp
Fix a test cas
e
i
nside distinct
.
test
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
R
ichard Hipp
Improved
matc
h
ing of
COL
L
ATE clauses within the
O
N
.
.
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
R
i
chard
H
i
pp
Fix a p
r
obl
e
m
in the sqlit
e
3Ex
p
rCompa
r
e() funct
i
on
.
.
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Ric
h
ard Hipp
A
d
d support fo
r
PostgreSQL UPSERT syntax and functionality
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richard Hipp
F
ix the build
f
or SQ
L
ITE
_
OM
I
T_UPSERT
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richard
H
ip
p
Add the --sorter
r
e
f N opti
o
n
t
o
the CLI
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
R
i
cha
r
d
H
ipp
O
m
it s
o
me
code not used without
SQLITE_ENABLE_SORTER_R
E
FEREN
.
.
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
R
i
chard Hip
p
Re
m
o
v
e an
u
nused l
o
cal
v
a
riable
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richar
d
Hipp
Enhance A
L
TER TABLE ADD COLUMN to support "DEFAULT
.
.
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richard Hipp
Add checks to
t
he CL
I
that
issue a
warn
i
ng if SQLite
.
.
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richard Hipp
Add
n
ew
t
estcase() macros and fix a
b
u
g t
h
at
w
as reve
a
led
.
.
.
commit
|
commitdiff
|
tree
2018-04-17
D
.
Richard Hipp
Remove unreacha
b
le branches
.
100%
M
C/DC in TH3 now
.
commit
|
commitdiff
|
tree
2018-04-17
D
.
R
i
chard
H
ipp
A
d
ded
a comment on the a
s
sert() added to the pr
e
vious
.
.
.
commit
|
commitdiff
|
tree
2018-04-17
D
.
R
i
chard Hipp
Fixes
t
o t
h
e
logic for c
o
nstra
i
nt c
h
e
c
k
r
eordering
.
.
.
commit
|
commitdiff
|
tree
2018-04-17
D
.
Richard Hipp
Dur
i
ng PRAGMA
v
dbe_addoptrace=ON, sho
w
c
alls to sqlite3
V
db
e
R
.
.
.
commit
|
commitdiff
|
tree
2018-04-17
D
.
Richard Hi
p
p
TK_RE
G
ISTER express
i
o
n
s nodes are pro
b
a
bly not co
n
stant
.
.
.
commit
|
commitdiff
|
tree
2018-04-17
D
.
Richa
r
d
Hip
p
Simp
l
i
fication to the ups
e
rt lo
g
ic
.
commit
|
commitdiff
|
tree
2018-04-17
D
.
R
i
chard
H
i
p
p
New
t
est cases
f
or
u
psert
.
commit
|
commitdiff
|
tree
2018-04-16
D
.
Ric
h
ard Hipp
Merge the Lemon enhancement
f
rom
t
run
k
,
resulting in
.
.
.
commit
|
commitdiff
|
tree
2018-04-16
D
.
Richard H
i
pp
Lemon enhancemen
t
s
: (1) Do not allocate s
p
ace fo
r
.
.
.
commit
|
commitdiff
|
tree
2018-04-16
D
.
Richard
H
ipp
Remo
v
e th
e
M
ySQL upsert syntax
.
As an optional alias
.
.
.
commit
|
commitdiff
|
tree
2018-04-16
D
.
Ric
h
ard Hipp
Add sup
p
o
r
t for the "ex
c
lude
d
.
*" names in the UPDATE
.
.
.
commit
|
commitdiff
|
tree
2018-04-16
D
.
Ri
c
har
d
H
ipp
Merge ch
a
nges from trunk
.
commit
|
commitdiff
|
tree
2018-04-16
D
.
R
i
chard Hipp
Increase the ver
s
ion number to 3
.
2
4
.
0
commit
|
commitdiff
|
tree
2018-04-16
D
.
Ri
c
h
a
rd Hipp
Reduce the si
z
e
o
f the NameContext object by
grouping
.
.
.
commit
|
commitdiff
|
tree
2018-04-14
D
.
R
ich
a
r
d
Hipp
G
et upsert wo
r
king on WI
T
HOUT RO
W
ID
tables
.
commit
|
commitdiff
|
tree
2018-04-14
D
.
Rich
a
rd Hipp
Mak
e
s
ure constrai
n
t
c
hecks occur in t
h
e c
o
rrect order
.
.
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
R
ichard Hip
p
First cut at logi
c
to perform DO UPDATE for rowi
d
tab
l
es
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
Ri
c
hard Hipp
Add inf
r
a
s
t
ructure fo
r
doing
an UPDATE a
s
part
of
a
n
.
.
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
R
i
chard Hi
p
p
Merge the pre
u
p
date hook change from
t
runk
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
Richard
H
ipp
Remove an alw
a
ys-true branch f
r
om the preupdate hook
.
.
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
Richard Hi
p
p
Get the ON
CO
N
F
L
ICT D
O
NOTHI
N
G form o
f
upsert wor
k
ing
.
.
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
Richard Hi
p
p
G
et the conflict-target clause parsin
g
w
o
r
k
ing co
r
r
e
ctl
y
.
.
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
Richard Hip
p
I
m
proved c
o
nflic
t
-targ
e
t match
i
ng logic
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
R
i
chard Hi
p
p
Back
off of the exten
d
ed
u
pse
r
t synt
a
x that allo
w
s
.
.
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
Ric
h
ar
d
H
i
pp
Begin a
d
ding up
s
e
r
t logic
.
This is
a
n increme
n
t
a
l
.
.
.
commit
|
commitdiff
|
tree
2018-04-12
D
.
Richard H
i
pp
Bre
a
k out the upsert cod
e
into a sep
a
rate source
file
.
commit
|
commitdiff
|
tree
2018-04-12
D
.
Ric
h
a
rd Hipp
Fix another typo in
a
comment
.
commit
|
commitdiff
|
tree
2018-04-12
D
.
Richar
d
H
i
p
p
Simple comment clarifica
t
ion
.
No code or l
o
gic
c
hanges
.
commit
|
commitdiff
|
tree
2018-04-12
D
.
Richard Hip
p
E
x
tend the upsert syntax to
a
l
l
ow
a WH
E
R
E
clause on
.
.
.
commit
|
commitdiff
|
tree
2018-04-12
D
.
R
i
char
d
H
ipp
U
p
date
t
he upsert par
s
ing so that it accepts c
o
nflic
t
.
.
.
commit
|
commitdiff
|
tree
2018-04-12
D
.
Richard Hipp
Ad
d
the U
p
ser
t
object for
holdi
n
g upsert clause infor
m
ation
.
commit
|
commitdiff
|
tree
2018-04-12
D
.
Ric
h
ard Hipp
Mer
g
e
changes fr
o
m trunk
.
commit
|
commitdiff
|
tree
2018-04-11
D
.
Richard H
i
p
p
Help
the parser
r
un
fas
t
er by avoiding the "explain
.
.
.
commit
|
commitdiff
|
tree
2018-04-11
D
.
Richard Hipp
Pro
h
ibit b
o
u
nd parameters in th
e
arguments to table
.
.
.
commit
|
commitdiff
|
tree
2018-04-10
D
.
Richard Hi
p
p
Versi
o
n 3
.
23
.
1
commit
|
commitdiff
|
tree
next