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
The previous fix for ticket [d85fffd6ffe856092ed8da] in check-in
2018-04-26
D
.
Richard Hipp
T
he
pre
v
iou
s
fix for ticket [d8
5
ff
f
d6ffe85609
2
ed8da
.
.
.
commit
|
commitdiff
|
tree
2018-04-26
D
.
Richa
r
d Hipp
E
n
s
u
re that n
e
w
.
*
v
alues of an UPDA
T
E do
not get clobbered
.
.
.
commit
|
commitdiff
|
tree
2018-04-26
D
.
Ric
h
ard Hip
p
Clarif
i
cation
of the
behav
i
or of a BEFORE
U
PDATE trigger
.
.
.
commit
|
commitdiff
|
tree
2018-04-26
D
.
Richard Hipp
I
mproved VDBE co
m
m
ent
o
n
the OP_P
a
r
a
m opcode
.
No substantia
.
.
.
commit
|
commitdiff
|
tree
2018-04-25
D
.
Ric
h
ard Hipp
Add n
e
w
in
t
erfaces f
o
r a
c
ce
s
sing the
l
ist of SQL key
w
ords:
commit
|
commitdiff
|
tree
2018-04-25
D
.
Richard Hip
p
Ad
d
the new DO and NOTH
I
NG
k
eywords to the k
e
yword
.
.
.
commit
|
commitdiff
|
tree
2018-04-25
D
.
Richard Hipp
Add the new SQLITE_
S
HELL
_
IN
I
T_PROC compile-
t
im
e
entry
.
.
.
commit
|
commitdiff
|
tree
2018-04-25
D
.
Richard Hipp
Avoid many unneces
s
ary
c
a
lls to sq
l
i
t
e
3
R
eadSchema
(
.
.
.
commit
|
commitdiff
|
tree
2018-04-25
D
.
Richard
H
i
p
p
Ad
d
a
n
ass
e
r
t
(
)
to
e
nsure
t
hat schema mu
t
exes are he
l
d
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
R
i
c
hard H
i
p
p
Do not a
t
tempt to use terms from the WHERE clause t
o
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
Richard
H
ipp
Upd
a
te th
e
expe
r
t extension te
s
t cases to acco
u
n
t for
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
Richard Hipp
All th
e
O
R opt
i
mization t
o
proceed even if th
e
OR i
s
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
Richard H
i
pp
Add a h
y
perlink t
o
the ticket
o
n the
code c
o
mment for
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
Richa
r
d Hipp
Enhance the CLI to render EXPLAIN
QUERY PLAN using
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
Richard Hipp
Fix a memory leak followi
n
g failure to open an external
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
Richar
d
Hipp
In
E
XPLAIN QUERY PLAN out
p
ut, do not sho
w
an EXECUTE
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
R
i
chard Hipp
Fix to check-i
n
[
ca34c2dd2
0
ee0
7
1e] - av
o
id a NU
L
L point
e
r
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Richard H
i
pp
Fix
a prob
l
em in s
q
lite3ExprCompare
(
) assoc
i
ated
w
ith
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
R
i
cha
r
d H
i
pp
Fix a formatti
n
g issue in the TreeView out
p
ut for
bar
e
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Ric
h
ar
d
Hipp
Add the "
.
imposter off" v
a
riant of the
"
.
imposter
"
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Richard
Hipp
The "
.
se
l
ecttrace 0x2000" com
m
a
n
d c
a
u
s
es just th
e
top
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Richard Hipp
T
h
e
"
.
selecttrace
4
" command now sh
o
ws only a sin
g
l
e
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Richard
H
ipp
Do not restore the i
S
e
lectId value until
after the
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Ri
c
hard H
i
pp
In th
e
"
.
selecttrac
e
" output, inclu
d
e the EXPLAIN QUERY
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Rich
a
rd Hipp
Ensure that there ar
e
no bi
n
d-parameters
or incorrect
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Ric
h
a
r
d
Hipp
Fix
a
n unreachable branch associa
t
e
d
w
ith st
a
ck ov
e
rfl
o
w
.
.
.
commit
|
commitdiff
|
tree
2018-04-21
D
.
Richard Hipp
P
e
rformance
i
mpro
v
em
e
nt
s
on the
main loop
of
t
he LEMON
.
.
.
commit
|
commitdiff
|
tree
2018-04-21
D
.
Richard Hipp
E
n
h
ance LEMON
t
o
t
r
a
ck whic
h
symb
o
ls actually carry
.
.
.
commit
|
commitdiff
|
tree
2018-04-21
D
.
Richard Hipp
A
dd t
h
e %extra
_
contex
t
d
irective to le
m
on, as an alternative
.
.
.
commit
|
commitdiff
|
tree
2018-04-21
D
.
Richard Hipp
Fix UPSERT
s
o
that it
p
lays nice
l
y w
i
th AUTOINCREMENT
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Richard Hipp
Add the -dD
I
RECTORY co
m
m
an
d
-line option to LEMO
N
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Richard Hipp
Fix a harmless compil
e
r
warni
n
g
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Richard Hipp
Avoid the use o
f
stateme
n
t jou
r
nals on DELETEs of
a
.
.
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Richard Hipp
Avoid opening
a
stat
e
ment
journal on single-row UPDATEs
.
.
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Rich
a
rd Hipp
Fix a VDBE comment on up
s
ert
.
Provide an
e
rror
messag
e
.
.
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Richa
r
d Hipp
Avoid unnecessary cu
r
sor seeking wh
e
n
perform
i
n
g
an
.
.
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Richard
Hipp
I
m
pr
o
ved VDBE comm
e
nt on UP
S
ERT code
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Rich
a
r
d
Hip
p
Minor sim
p
l
i
fication of
t
he pre
v
i
o
u
s
chec
k
in
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Ric
h
ard
Hip
p
Avoid u
n
necessa
r
y cursor seeks during upser
t
processing
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Ric
h
ard Hipp
Enhance UP
S
ERT s
o
that the U
P
DATE u
s
es the same set
.
.
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Richard Hipp
Minor
s
impli
f
icatio
n
of
t
he cursor
a
llo
c
ation logic
.
.
.
commit
|
commitdiff
|
tree
2018-04-19
D
.
Richard H
i
pp
Fix
t
he handling of "
P
RAGMA count_chang
e
s=ON"
with
.
.
.
commit
|
commitdiff
|
tree
2018-04-19
D
.
R
icha
r
d
Hipp
Minor simpl
i
fication to
t
h
e
u
psert logic
.
commit
|
commitdiff
|
tree
2018-04-19
D
.
Richard Hipp
Ad
d
the -
-
u
p
s
ert
o
pt
i
on
t
o
the wordcount test program
.
commit
|
commitdiff
|
tree
2018-04-19
D
.
Richard
Hipp
Add the ext/misc/templatevtab
.
c templ
a
t
e
for virtual
.
.
.
commit
|
commitdiff
|
tree
2018-04-19
D
.
Richard Hipp
Fix a problem
i
n the new u
p
sert implemention, discovered
.
.
.
commit
|
commitdiff
|
tree
2018-04-19
D
.
Richard Hipp
Fix the tab
l
e name aliasing
on INSERT so that it occ
u
r
s
.
.
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
R
i
chard Hipp
Avoid a NUL
L
-pointer deref f
o
llowing OOM
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richard Hipp
F
i
x a test
c
ase inside d
i
s
tin
c
t
.
test
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Ri
c
ha
r
d Hipp
Improved
match
i
n
g of
COLLATE cl
a
uses within the ON
.
.
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richard Hip
p
Fix a problem
in
t
he
sq
l
ite
3
Exp
r
C
o
mpar
e
() function
.
.
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Rich
a
rd
Hipp
A
d
d
s
uppo
r
t fo
r
Po
s
tgr
e
S
QL UP
S
E
RT sy
n
ta
x
a
n
d function
a
l
ity
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richard Hipp
Fix the
buil
d
for SQL
I
T
E
_OMIT_UPSERT
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richard Hipp
Add
the
--sorter
r
e
f
N option
t
o the CLI
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richard H
i
pp
O
m
it
s
ome code not used wi
t
hout SQL
I
TE_ENABLE_SORTER_REFEREN
.
.
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
R
i
chard Hipp
Remov
e
an unused local
variab
l
e
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Rich
a
rd H
i
pp
Enhance ALTE
R
TAB
L
E ADD COLU
M
N t
o
sup
p
ort
"
DEFAULT
.
.
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richard Hipp
Ad
d
ch
e
cks to
the CLI that issue a warnin
g
i
f SQLite
.
.
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richa
r
d
Hip
p
Add new test
c
ase
(
) macros
a
nd fix a bug that was revealed
.
.
.
commit
|
commitdiff
|
tree
2018-04-17
D
.
Ric
h
ard Hipp
Remove unreachabl
e
branches
.
10
0
% MC/DC i
n
TH3 now
.
commit
|
commitdiff
|
tree
2018-04-17
D
.
R
i
chard Hipp
Adde
d
a comment o
n
t
he assert()
a
dded to the p
r
evious
.
.
.
commit
|
commitdiff
|
tree
2018-04-17
D
.
Richard Hip
p
Fi
x
es to the l
o
gic f
o
r constrain
t
che
c
k reorderin
g
.
.
.
commit
|
commitdiff
|
tree
2018-04-17
D
.
Rich
a
rd
H
ipp
During PRAGM
A
v
dbe_a
d
doptrace=ON, s
h
ow calls to sqlite3Vdb
e
R
.
.
.
commit
|
commitdiff
|
tree
2018-04-17
D
.
Richard
H
ipp
TK_REGISTER e
x
pressions nodes
a
re
probab
l
y no
t
constant
.
.
.
commit
|
commitdiff
|
tree
2018-04-17
D
.
Richard Hip
p
S
i
mplification to the upsert logic
.
commit
|
commitdiff
|
tree
2018-04-17
D
.
Richard
Hip
p
N
ew te
s
t cases f
o
r
up
s
ert
.
commit
|
commitdiff
|
tree
2018-04-16
D
.
Richard
H
ipp
Mer
g
e the Lemon
enh
a
ncement from trunk,
resulting i
n
.
.
.
commit
|
commitdiff
|
tree
2018-04-16
D
.
Richa
r
d Hi
p
p
Lemon enhancements: (1) Do not allocate s
p
a
c
e for
.
.
.
commit
|
commitdiff
|
tree
2018-04-16
D
.
R
i
chard Hipp
Remove the MySQL upsert syntax
.
As an opt
i
on
a
l
a
lias
.
.
.
commit
|
commitdiff
|
tree
2018-04-16
D
.
Richard Hip
p
Add support for
t
he
"ex
c
lu
d
ed
.
*" n
a
m
e
s in t
h
e UP
D
ATE
.
.
.
commit
|
commitdiff
|
tree
2018-04-16
D
.
R
i
chard Hip
p
Me
r
ge changes fr
o
m trunk
.
commit
|
commitdiff
|
tree
2018-04-16
D
.
Richard
H
ipp
Increa
s
e
the version
n
u
mber to 3
.
24
.
0
commit
|
commitdiff
|
tree
2018-04-16
D
.
Richard Hipp
Red
u
ce the size
o
f t
h
e NameContext
object by grouping
.
.
.
commit
|
commitdiff
|
tree
2018-04-14
D
.
Richard Hipp
Get
u
p
sert working on WI
T
H
O
U
T RO
W
ID tables
.
commit
|
commitdiff
|
tree
2018-04-14
D
.
Richard Hipp
Make sur
e
constraint checks o
c
cur in th
e
correct order
.
.
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
Richard Hipp
F
ir
s
t cut at logic to
perform DO
U
PDATE for rowid
t
a
bles
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
Richard Hipp
Add inf
r
a
s
truc
t
ure for doing a
n
UPDATE as
p
art of an
.
.
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
R
i
chard Hip
p
M
erge the preupdat
e
hook change fr
o
m trunk
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
Richard Hipp
Re
m
o
ve a
n
al
w
ays-true branch from
t
he
preupdate h
o
o
k
.
.
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
Richa
r
d
H
i
p
p
Get the ON CONFLICT DO N
O
THING form of upsert work
i
ng
.
.
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
Ric
h
ard H
i
p
p
Get
the
c
onflict-target clause parsin
g
wor
k
ing correctly
.
.
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
Richard H
i
pp
I
mpro
v
ed
confl
i
c
t
-target
m
atching log
i
c
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
Richa
r
d Hipp
Back off of the extended upsert syntax that allows
.
.
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
Richard Hipp
Begi
n
add
i
ng upsert
l
ogic
.
Th
i
s is an
i
nc
r
emental
.
.
.
commit
|
commitdiff
|
tree
2018-04-12
D
.
Ri
c
hard
H
ipp
Break out the upser
t
code into a separate
s
o
urce f
i
le
.
commit
|
commitdiff
|
tree
2018-04-12
D
.
Richard Hipp
Fix anothe
r
typo
i
n a comment
.
commit
|
commitdiff
|
tree
2018-04-12
D
.
Richar
d
Hipp
Simpl
e
c
omme
n
t
c
larification
.
No code or log
i
c changes
.
commit
|
commitdiff
|
tree
2018-04-12
D
.
R
i
chard Hipp
Extend the
upsert
s
yntax
to allow a W
H
ERE clause on
.
.
.
commit
|
commitdiff
|
tree
2018-04-12
D
.
Ric
h
ard Hipp
U
p
date the upsert parsing so that it
accepts conflict
.
.
.
commit
|
commitdiff
|
tree
2018-04-12
D
.
Richard Hipp
Ad
d
th
e
Ups
e
rt obje
c
t for ho
l
ding upse
r
t clause inf
o
rm
a
tion
.
commit
|
commitdiff
|
tree
2018-04-12
D
.
Ri
c
hard Hipp
Merge changes fr
o
m trunk
.
commit
|
commitdiff
|
tree
2018-04-11
D
.
Richard Hipp
H
e
l
p
the parser run f
a
ste
r
by avoidi
n
g the "explain
.
.
.
commit
|
commitdiff
|
tree
2018-04-11
D
.
Richard Hipp
P
ro
h
ibit bound pa
r
ame
t
ers in the
arguments to table
.
.
.
commit
|
commitdiff
|
tree
2018-04-10
D
.
Richard Hi
p
p
V
ersion
3
.
23
.
1
commit
|
commitdiff
|
tree
2018-04-10
D
.
Richa
r
d Hipp
Increase the version
n
u
mber to 3
.
23
.
1
.
commit
|
commitdiff
|
tree
2018-04-10
D
.
Richard H
i
p
p
R
e
mov
e
an unne
c
essary
S
QL
I
TE_UNTESTABLE c
o
m
p
ile-time
.
.
.
commit
|
commitdiff
|
tree
2018-04-10
D
.
Ric
h
ard
Hipp
Update
the top-l
e
vel
README
.
md f
i
le to point
to the
.
.
.
commit
|
commitdiff
|
tree
2018-04-10
D
.
Richard H
i
pp
Update the
t
op-level README
.
md
file to point to
the
.
.
.
commit
|
commitdiff
|
tree
2018-04-09
D
.
Richard
H
ipp
Minor changes to
t
he input gra
m
mar resulti
n
g in a fas
t
er
.
.
.
commit
|
commitdiff
|
tree
2018-04-09
D
.
Rich
a
rd
H
ipp
Enhance the
q
uer
y
pl
a
nner
s
o that it detects when th
e
.
.
.
commit
|
commitdiff
|
tree
next