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
h
e
prev
i
ous f
i
x for ticket [d8
5
fffd6ffe856092ed8da
.
.
.
commit
|
commitdiff
|
tree
2018-04-26
D
.
Rich
a
rd Hipp
Ens
u
re that ne
w
.
* values of
a
n U
P
DATE do
n
ot get clobbered
.
.
.
commit
|
commitdiff
|
tree
2018-04-26
D
.
R
ichard Hipp
C
l
a
r
ifi
c
a
t
ion of th
e
beh
a
vio
r
o
f
a BEFORE UPDATE trig
g
er
.
.
.
commit
|
commitdiff
|
tree
2018-04-26
D
.
R
ichard Hipp
Improved V
D
BE comment
on the OP_Par
a
m
op
c
ode
.
No subs
t
antia
.
.
.
commit
|
commitdiff
|
tree
2018-04-25
D
.
Richard Hip
p
Add new int
e
r
f
ace
s
fo
r
acc
e
s
s
ing the l
i
st of SQ
L
k
eywords:
commit
|
commitdiff
|
tree
2018-04-25
D
.
Richard
H
ip
p
Add the new
D
O
a
nd
N
OTHING keyw
o
r
ds t
o
the
k
eyword
.
.
.
commit
|
commitdiff
|
tree
2018-04-25
D
.
R
ichard Hipp
A
d
d
t
he new
S
QLITE_SHELL_INIT_PROC compi
l
e
-
time entr
y
.
.
.
commit
|
commitdiff
|
tree
2018-04-25
D
.
Richard
H
ipp
Avoid
m
any
unn
e
c
essary cal
l
s to s
q
lite3ReadSche
m
a
(
.
.
.
commit
|
commitdiff
|
tree
2018-04-25
D
.
Ri
c
hard
Hipp
Add an a
s
se
r
t()
t
o en
s
ure tha
t
schema mutexes are held
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
Richard Hipp
D
o
not atte
m
pt
to use t
e
r
ms fro
m
the WH
E
RE clause t
o
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
R
i
cha
r
d
Hipp
Update the expert
ext
e
nsion tes
t
c
a
s
es
t
o accou
n
t for
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
Richard Hipp
All t
h
e
OR optimizatio
n
to proceed eve
n
if the OR is
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
Richard Hi
p
p
Ad
d
a h
y
p
e
rli
n
k to the ticket on the c
o
de comment
for
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
R
i
cha
r
d Hipp
Enhance
t
h
e CLI to render EXP
L
AIN Q
U
ERY PLAN
u
sing
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
Richard
Hipp
Fix a memory leak following fail
u
re to open an
ex
t
ernal
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
R
i
c
h
a
rd Hi
p
p
In EXPLAIN Q
U
ER
Y
PLAN out
p
u
t
, d
o
no
t
sh
o
w
an EXECUT
E
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
R
i
chard Hipp
F
i
x
to check-in [ca34c2dd20ee071e] - avoid
a
NULL pointer
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Richa
r
d H
i
pp
Fi
x
a problem in sqlite3E
x
prCo
m
pare() a
s
sociated with
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
R
ichard Hipp
Fix a formatting issue in the T
r
eeView ou
t
put for b
a
re
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Richard H
i
p
p
A
d
d the "
.
imposte
r
off"
variant of t
h
e "
.
i
mposter"
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Richard H
i
pp
The "
.
selecttrace 0x20
0
0" command causes just the top
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Richard Hipp
T
h
e "
.
sel
e
cttrace
4
" command now shows only a single
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
R
i
chard
Hip
p
D
o
n
ot
r
estore
the iSelectId value
until af
t
er the
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Richard Hipp
In the "
.
selecttrace"
o
utput, includ
e
the
EXPLAIN QUER
Y
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Richard
Hipp
E
nsure that ther
e
are n
o
b
ind-
p
a
rameters or incorrect
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Ric
h
ard Hipp
Fix an unreachable branch associat
e
d with stac
k
overflow
.
.
.
commit
|
commitdiff
|
tree
2018-04-21
D
.
Richard Hipp
Performance improvements on the
main l
o
o
p
of the LEMON
.
.
.
commit
|
commitdiff
|
tree
2018-04-21
D
.
Richard Hipp
Enhance LEMON to track which sym
b
o
l
s act
u
ally carry
.
.
.
commit
|
commitdiff
|
tree
2018-04-21
D
.
Ric
h
ard Hipp
Add the %extra
_
contex
t
d
irecti
v
e to l
e
m
o
n
, as an
alternat
i
ve
.
.
.
commit
|
commitdiff
|
tree
2018-04-21
D
.
Richard Hipp
Fix U
P
SERT so th
a
t it p
l
ays nicely with AUTOINCRE
M
ENT
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
R
ich
a
rd Hipp
A
dd
the -
d
D
I
REC
T
ORY command-line option to
L
EM
O
N
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Richard
H
ipp
Fi
x
a
harmless compiler warnin
g
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Richard Hipp
A
v
oid t
h
e use
o
f statement
j
ournals
o
n DELETEs of
a
.
.
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Richard Hipp
Avoid opening
a
stat
e
ment
journal on
s
i
ngl
e
-row
UP
D
ATEs
.
.
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Richard
H
ipp
Fix a V
D
B
E
commen
t
on upsert
.
Pro
v
i
d
e
an error messa
g
e
.
.
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Richard Hipp
Avo
i
d unnecessary cursor seeking
when
performing an
.
.
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Richard Hipp
Improved VD
B
E comm
e
n
t
on
U
PSER
T
code
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
R
i
c
hard Hipp
M
inor s
i
m
plifi
c
ation of the prev
i
ous
c
hec
k
in
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Richard Hipp
Av
o
id
unnece
s
sar
y
cursor se
e
ks du
r
ing upsert proce
s
s
i
ng
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Richard Hipp
Enhance UPSERT s
o
t
h
a
t the
U
PDA
T
E
u
ses
t
h
e
same set
.
.
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
R
i
c
h
a
r
d Hipp
Minor sim
p
lif
i
cat
i
on of the cursor allocation l
o
gic
.
.
.
commit
|
commitdiff
|
tree
2018-04-19
D
.
Richard
H
ipp
Fix the h
a
ndlin
g
of
"PRAGMA cou
n
t_changes=ON" w
i
th
.
.
.
commit
|
commitdiff
|
tree
2018-04-19
D
.
R
i
ch
a
rd Hi
p
p
Minor si
m
pl
i
fi
c
ation to
the upsert
log
i
c
.
commit
|
commitdiff
|
tree
2018-04-19
D
.
Ric
h
ard Hipp
Ad
d
the -
-
upsert o
p
t
i
on t
o
t
h
e wordcou
n
t test pro
g
ram
.
commit
|
commitdiff
|
tree
2018-04-19
D
.
R
ichard Hipp
Ad
d
th
e
ex
t
/misc/templatevtab
.
c te
m
plate
f
o
r vi
r
tual
.
.
.
commit
|
commitdiff
|
tree
2018-04-19
D
.
R
ic
h
ard
H
i
p
p
Fix a problem in the
new
u
psert imp
l
em
e
ntion, discovered
.
.
.
commit
|
commitdiff
|
tree
2018-04-19
D
.
Richard
Hipp
F
i
x the
ta
b
le
name al
i
a
s
ing on INSERT so
that it occur
s
.
.
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richar
d
Hi
p
p
Avo
i
d a NULL-pointer deref
following OOM
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Rich
a
r
d
Hipp
Fix a test c
a
se i
n
side dis
t
inct
.
test
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richard Hipp
Improved matching
of CO
L
LATE c
l
auses with
i
n t
h
e ON
.
.
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richa
r
d Hipp
Fix a
problem in
t
h
e sqlite3E
x
p
rCompare() function
.
.
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richard Hipp
Add support for Po
s
tg
r
eS
Q
L UPSERT syntax and functi
o
n
ali
t
y
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richard Hipp
Fix the
b
uild for SQ
L
ITE_OMI
T
_UPSE
R
T
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richard Hipp
Add
t
he
-
-s
o
rterref N option to the
CLI
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richard H
i
p
p
Om
i
t
some code
n
o
t
used without SQLIT
E
_ENABLE_SORTER_RE
F
EREN
.
.
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richard H
i
pp
Remove an unus
e
d local vari
a
ble
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richard
Hipp
E
nhance ALTER
TABLE ADD COLUMN to support "DEFAULT
.
.
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richard Hipp
A
d
d ch
e
c
ks to the CLI that issu
e
a warning
i
f SQLite
.
.
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
R
i
chard Hipp
Add
n
ew
t
estcase() macros a
n
d fix a bug that was reveal
e
d
.
.
.
commit
|
commitdiff
|
tree
2018-04-17
D
.
Ric
h
a
r
d Hipp
Remo
v
e un
r
eachab
l
e branch
e
s
.
100% MC/DC in TH3 n
o
w
.
commit
|
commitdiff
|
tree
2018-04-17
D
.
Richar
d
Hipp
Added a comment on the asser
t
() added to t
h
e previous
.
.
.
commit
|
commitdiff
|
tree
2018-04-17
D
.
Richar
d
Hipp
Fix
e
s to
t
he
l
og
i
c for const
r
aint
c
heck reordering
.
.
.
commit
|
commitdiff
|
tree
2018-04-17
D
.
Richard Hipp
During PRAGMA vdbe_addoptrace=ON, sho
w
calls to sqlite3Vd
b
eR
.
.
.
commit
|
commitdiff
|
tree
2018-04-17
D
.
Richard
H
i
p
p
TK_REGISTER e
x
pressions
n
odes are
probably not constant
.
.
.
commit
|
commitdiff
|
tree
2018-04-17
D
.
Richard Hip
p
Simplification to
t
h
e
upsert logic
.
commit
|
commitdiff
|
tree
2018-04-17
D
.
Richard
H
ip
p
New test cases for upse
r
t
.
commit
|
commitdiff
|
tree
2018-04-16
D
.
Richard H
i
pp
M
e
rge the Le
m
on enhancement
f
rom trunk
,
resulting in
.
.
.
commit
|
commitdiff
|
tree
2018-04-16
D
.
Richard H
i
pp
Lemon enhancements: (1) Do not allocate space for
.
.
.
commit
|
commitdiff
|
tree
2018-04-16
D
.
Richa
r
d Hipp
Remov
e
the MySQL upsert synta
x
.
As an optiona
l
alias
.
.
.
commit
|
commitdiff
|
tree
2018-04-16
D
.
Rich
a
rd Hip
p
Add
s
uppo
r
t fo
r
the "excluded
.
*" names in the UPDATE
.
.
.
commit
|
commitdiff
|
tree
2018-04-16
D
.
Richar
d
Hipp
Merge chan
g
es from trunk
.
commit
|
commitdiff
|
tree
2018-04-16
D
.
Richard Hi
p
p
Increas
e
the
v
e
rsion num
b
er to 3
.
24
.
0
commit
|
commitdiff
|
tree
2018-04-16
D
.
Richard Hi
p
p
R
edu
c
e the siz
e
of t
h
e
NameContext object by gr
o
u
ping
.
.
.
commit
|
commitdiff
|
tree
2018-04-14
D
.
Richard Hipp
Get upsert working
o
n WITH
O
UT ROWID table
s
.
commit
|
commitdiff
|
tree
2018-04-14
D
.
Richard
Hi
p
p
Make sure constraint checks occur
i
n
the cor
r
ect order
.
.
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
Rich
a
rd
H
ipp
First cut
a
t logic to
p
erform DO
UPDAT
E
for
r
owid
t
a
bles
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
Richar
d
Hipp
Add
i
n
fr
a
struct
u
re f
o
r doing a
n
U
PDATE as part of an
.
.
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
Ric
h
ard
Hipp
Merge the preupdate
hook change fro
m
trunk
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
R
ich
a
rd Hi
p
p
R
e
move an always-true branch f
r
om the
preupdate hook
.
.
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
Richard Hip
p
Get
t
h
e ON CONFL
I
CT DO NOT
H
ING f
o
rm of upsert working
.
.
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
R
i
cha
r
d Hip
p
G
e
t th
e
conflict-tar
g
et c
l
au
s
e par
s
ing working
c
o
rr
e
ctly
.
.
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
R
ichard H
i
pp
Improve
d
c
onflict-target ma
t
c
h
ing logic
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
Richard Hip
p
Back off of the extended
upsert syntax that allows
.
.
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
Richar
d
Hipp
Begin add
i
n
g
u
psert logic
.
This is an increm
e
ntal
.
.
.
commit
|
commitdiff
|
tree
2018-04-12
D
.
Rich
a
rd
Hipp
Bre
a
k out th
e
upsert code
i
nt
o
a sepa
r
at
e
source file
.
commit
|
commitdiff
|
tree
2018-04-12
D
.
Ri
c
hard Hipp
Fix anot
h
er
t
y
po in a comme
n
t
.
commit
|
commitdiff
|
tree
2018-04-12
D
.
Richa
r
d Hi
p
p
Simple commen
t
clarification
.
No code or logic
c
h
anges
.
commit
|
commitdiff
|
tree
2018-04-12
D
.
Richard Hipp
Exten
d
the
upsert syntax
t
o allow a WHE
R
E
c
lau
s
e o
n
.
.
.
commit
|
commitdiff
|
tree
2018-04-12
D
.
Rich
a
rd Hip
p
Upd
a
te t
h
e up
s
ert
parsing so tha
t
it accepts
c
onfl
i
c
t
.
.
.
commit
|
commitdiff
|
tree
2018-04-12
D
.
Ric
h
ard Hipp
Add the Upsert object for
ho
l
ding upsert clause informatio
n
.
commit
|
commitdiff
|
tree
2018-04-12
D
.
R
i
c
hard Hipp
Merge changes
f
ro
m
t
r
unk
.
commit
|
commitdiff
|
tree
2018-04-11
D
.
Richard Hipp
Help th
e
parser r
u
n faster by avoiding the "explain
.
.
.
commit
|
commitdiff
|
tree
2018-04-11
D
.
Ri
c
hard Hipp
Proh
i
bit bound paramete
r
s in the ar
g
uments to table
.
.
.
commit
|
commitdiff
|
tree
2018-04-10
D
.
Richard Hip
p
Version
3
.
23
.
1
commit
|
commitdiff
|
tree
2018-04-10
D
.
Richard Hipp
I
n
crea
s
e t
h
e version number to 3
.
23
.
1
.
commit
|
commitdiff
|
tree
2018-04-10
D
.
Richard Hipp
Remove
a
n
u
nnece
s
s
a
ry
SQLITE_UNTES
T
ABLE c
o
mpile-time
.
.
.
commit
|
commitdiff
|
tree
2018-04-10
D
.
Richa
r
d H
i
pp
Update the
t
op-level
README
.
m
d
fil
e
t
o
point to t
h
e
.
.
.
commit
|
commitdiff
|
tree
2018-04-10
D
.
R
i
chard Hi
p
p
Up
d
ate the top
-
l
evel README
.
md
file to point to
the
.
.
.
commit
|
commitdiff
|
tree
2018-04-09
D
.
Richard Hipp
Mi
n
or changes to the input
gr
a
mmar res
u
lting
i
n
a
f
aster
.
.
.
commit
|
commitdiff
|
tree
2018-04-09
D
.
Richard
H
ipp
En
h
ance t
h
e q
u
ery
planner so that it detects when the
.
.
.
commit
|
commitdiff
|
tree
next