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
p
r
evious
f
i
x
for ti
c
ket [d85fffd6ffe856092ed8da
.
.
.
commit
|
commitdiff
|
tree
2018-04-26
D
.
Richard Hipp
Ensure that new
.
*
values of
a
n UPDATE do not get clo
b
b
e
re
d
.
.
.
commit
|
commitdiff
|
tree
2018-04-26
D
.
Richard H
i
pp
Cla
r
i
fi
c
ation of the behavior o
f
a BEFORE UPDATE trigger
.
.
.
commit
|
commitdiff
|
tree
2018-04-26
D
.
Richard Hipp
Improved VDBE co
m
ment o
n
the OP_P
a
ra
m
o
pcode
.
No subs
t
antia
.
.
.
commit
|
commitdiff
|
tree
2018-04-25
D
.
Richard
Hipp
Add new interf
a
ces for accessing the l
i
st
of S
Q
L ke
y
words:
commit
|
commitdiff
|
tree
2018-04-25
D
.
Richard Hipp
Add t
h
e
n
e
w DO
and NOTHING k
e
yw
o
rds to the keyword
.
.
.
commit
|
commitdiff
|
tree
2018-04-25
D
.
Richard
Hipp
A
d
d the new SQLITE_SHELL_INIT_PROC compile
-
time entry
.
.
.
commit
|
commitdiff
|
tree
2018-04-25
D
.
Richa
r
d
Hipp
Avoid many unnecessary calls
t
o sqlite3ReadSchema(
.
.
.
commit
|
commitdiff
|
tree
2018-04-25
D
.
Richard
Hipp
Add an
assert(
)
to
e
nsure that schem
a
mutexes
are held
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
Ric
h
ard Hipp
Do not
at
t
empt to use terms from the WHERE clau
s
e
t
o
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
Richard Hipp
Update the e
x
pert
e
xtension test cases to account fo
r
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
R
i
char
d
Hip
p
A
ll th
e
OR opt
i
mizati
o
n to proceed
e
ve
n
i
f the
O
R is
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
Richard Hipp
Add a hy
p
erlink to the
t
i
c
ket on
the code comment for
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
R
i
chard
H
i
pp
Enhance the CLI
t
o
render EX
P
LAIN QUERY PLAN
u
sing
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
R
i
ch
a
rd
H
ipp
Fix a memory lea
k
f
o
llow
i
ng fail
u
re to open an extern
a
l
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
Richard Hipp
In EXPLAIN QUERY PLAN output, do not show an EXECUTE
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
Rich
a
rd
H
ipp
Fix
t
o
c
he
c
k-in [ca
3
4
c
2dd20ee0
7
1e
]
- avoid a NULL pointer
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Richar
d
Hipp
Fix
a
problem in
sqlit
e
3ExprC
o
mpare() associated with
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
R
i
c
h
ard Hipp
Fix
a form
a
tting issue in the
T
reeVi
e
w out
p
ut for
b
ar
e
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
R
i
c
hard
H
ipp
Add the
"
.
imp
o
ster off" varia
n
t of the "
.
imposter"
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
R
i
char
d
Hipp
The "
.
sele
c
ttrace 0x2000" command causes just
the top
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
R
i
chard
H
ipp
T
he "
.
selecttrace
4" command
now shows only a single
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Ri
c
h
ard Hipp
Do not res
t
or
e
the iSelectId va
l
ue unt
i
l af
t
er
the
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
R
i
chard Hipp
In the
"
.
selecttrace" output,
i
nclude
the EXPLAIN QUE
R
Y
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
R
i
chard Hipp
Ensure
that th
e
re
are no bind-p
a
r
ameters o
r
incorrect
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Richa
r
d Hipp
Fix an unr
e
acha
b
le branch associated
wi
t
h s
t
a
c
k overfl
o
w
.
.
.
commit
|
commitdiff
|
tree
2018-04-21
D
.
Ric
h
ard Hipp
Performanc
e
improvement
s
on the
m
ain loop of the LEMON
.
.
.
commit
|
commitdiff
|
tree
2018-04-21
D
.
Richard Hipp
Enh
a
nce LEMON to track which symbols actuall
y
carry
.
.
.
commit
|
commitdiff
|
tree
2018-04-21
D
.
Richard
H
i
p
p
A
d
d the %extra_co
n
text directive to lem
o
n, as an alternative
.
.
.
commit
|
commitdiff
|
tree
2018-04-21
D
.
Richard Hipp
Fix
UPSERT so
that it p
l
ays
n
icely with AUTOINCREMENT
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Richa
r
d Hipp
Add
the -dDIREC
T
ORY com
m
and-line
o
pti
o
n to LEMON
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Ric
h
ard Hipp
Fix a
h
arm
l
e
s
s compil
e
r warni
n
g
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
R
i
cha
r
d Hipp
Avoid the use of statement jour
n
als on DEL
E
TEs of a
.
.
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Rich
a
rd Hipp
Avoid openi
n
g
a
stat
e
men
t
j
o
urnal
o
n sin
g
le-row
UPDAT
E
s
.
.
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
R
i
chard
Hipp
Fix a VDBE c
o
mme
n
t o
n
upse
r
t
.
P
rovide an error
message
.
.
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Ric
h
ard
Hipp
Avoid unnecessa
r
y
cu
r
sor seeking when performing an
.
.
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Richard Hi
p
p
I
mpr
o
ved
V
DBE comment on UPSERT code
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Richard Hip
p
M
i
nor
si
m
p
l
ific
a
tio
n
of the
p
revious checkin
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
R
i
chard Hipp
A
void u
n
necessa
r
y cursor seeks
during upsert processing
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Richard Hipp
Enhance UPSERT so that the UPDATE uses the same set
.
.
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Richard Hipp
M
inor
s
implifi
c
ati
o
n of the cursor
alloc
a
t
ion logic
.
.
.
commit
|
commitdiff
|
tree
2018-04-19
D
.
R
i
c
h
ard Hipp
F
ix t
h
e hand
l
ing of "PRAGMA
c
ount_changes=ON" with
.
.
.
commit
|
commitdiff
|
tree
2018-04-19
D
.
Ri
c
har
d
H
ipp
Minor si
m
plificat
i
on to t
h
e upser
t
logic
.
commit
|
commitdiff
|
tree
2018-04-19
D
.
R
i
chard
H
ipp
A
d
d the
--upsert option to the
w
ordcount tes
t
p
ro
g
ram
.
commit
|
commitdiff
|
tree
2018-04-19
D
.
Richa
r
d Hipp
Add the
ext/misc/templatevta
b
.
c template for vir
t
ual
.
.
.
commit
|
commitdiff
|
tree
2018-04-19
D
.
Richard
H
ipp
Fix a p
r
oblem in
t
he new u
p
se
r
t imp
l
emention, discovered
.
.
.
commit
|
commitdiff
|
tree
2018-04-19
D
.
Richard Hipp
Fix the table
n
ame ali
a
si
n
g on INSERT so that it occurs
.
.
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richard Hipp
Avoi
d
a
N
U
L
L
-
pointer
d
eref following OOM
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richard H
i
pp
Fix a test
case inside
d
istinct
.
test
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richard
Hipp
Improved m
a
tching o
f
COLLATE
c
lauses within the
ON
.
.
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Rich
a
rd H
i
pp
Fix a pro
b
lem in the sql
i
te3ExprCo
m
pa
r
e() f
u
nction
.
.
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
R
i
chard H
i
pp
Add
s
u
pport for
P
ostgreSQL UPSE
R
T s
y
ntax
a
nd f
u
nctionality
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Ric
h
a
rd Hipp
Fi
x
the buil
d
for SQ
L
ITE_OMIT_UPSERT
commit
|
commitdiff
|
tree
2018-04-18
D
.
R
i
c
h
ard Hipp
Add th
e
--sorterref N opt
i
o
n
to the CLI
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Rich
a
rd Hip
p
Omit some code not used withou
t
SQLIT
E
_ENABLE_SORTE
R
_REFEREN
.
.
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richard Hipp
Remove an unused local variabl
e
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richard Hipp
En
h
a
nc
e
ALTER TA
B
L
E
A
DD COLUMN to suppo
r
t "DEFAULT
.
.
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richar
d
Hipp
A
dd checks t
o
th
e
C
LI
that issue a warn
i
ng i
f
SQLite
.
.
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richard Hipp
Add ne
w
testc
a
se
(
)
macros
and fix a bug that was
r
evealed
.
.
.
commit
|
commitdiff
|
tree
2018-04-17
D
.
Richard
H
ipp
R
em
o
ve u
n
reacha
b
le
branches
.
100% MC/D
C
i
n
T
H3
now
.
commit
|
commitdiff
|
tree
2018-04-17
D
.
R
i
chard Hipp
Add
e
d a comment on t
h
e
assert() add
e
d
to t
h
e prev
i
ous
.
.
.
commit
|
commitdiff
|
tree
2018-04-17
D
.
Richar
d
Hipp
Fixes to
the
l
ogic f
o
r constra
i
nt che
c
k reor
d
ering
.
.
.
commit
|
commitdiff
|
tree
2018-04-17
D
.
Ric
h
ard Hipp
Dur
i
ng PRAGMA vd
b
e_addoptrace=ON, sho
w
calls to sqlite3VdbeR
.
.
.
commit
|
commitdiff
|
tree
2018-04-17
D
.
Ri
c
hard
H
ipp
TK_REGIST
E
R expressions nodes are
probably not cons
t
ant
.
.
.
commit
|
commitdiff
|
tree
2018-04-17
D
.
Richard
Hip
p
S
i
mpli
f
icat
i
on to
the u
p
sert
logic
.
commit
|
commitdiff
|
tree
2018-04-17
D
.
Richard
Hipp
N
e
w test cases for upsert
.
commit
|
commitdiff
|
tree
2018-04-16
D
.
Ric
h
ard Hipp
Merge th
e
Lem
o
n enhance
m
en
t
f
r
om trunk, r
e
sulting in
.
.
.
commit
|
commitdiff
|
tree
2018-04-16
D
.
Richa
r
d
Hipp
Lem
o
n
enhan
c
ements:
(1) Do
not allocat
e
space for
.
.
.
commit
|
commitdiff
|
tree
2018-04-16
D
.
Richard
Hipp
R
emove the MyS
Q
L
u
pse
r
t syntax
.
As
an optional alias
.
.
.
commit
|
commitdiff
|
tree
2018-04-16
D
.
R
i
chard Hipp
Add supp
o
rt fo
r
th
e
"ex
c
l
u
ded
.
*" names in the UPDATE
.
.
.
commit
|
commitdiff
|
tree
2018-04-16
D
.
Richard
Hipp
M
e
rge ch
a
nges from
t
r
u
nk
.
commit
|
commitdiff
|
tree
2018-04-16
D
.
Richard Hi
p
p
Increas
e
t
h
e version nu
m
ber to 3
.
24
.
0
commit
|
commitdiff
|
tree
2018-04-16
D
.
Richard Hipp
Reduce the size of the NameCon
t
ext objec
t
by gr
o
up
i
ng
.
.
.
commit
|
commitdiff
|
tree
2018-04-14
D
.
Richard Hipp
Get upsert
wor
k
ing on
WITHOUT RO
W
ID t
a
ble
s
.
commit
|
commitdiff
|
tree
2018-04-14
D
.
Richard
Hipp
Make sur
e
co
n
str
a
int checks
o
c
c
u
r
i
n the correct
or
d
e
r
.
.
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
Rich
a
rd Hipp
Fi
r
st
cut at logic to perform DO UPDA
T
E fo
r
ro
w
id tables
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
R
i
chard Hipp
Add infrastructure fo
r
d
o
ing
a
n UPDATE as part of an
.
.
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
Ri
c
hard Hipp
Merge the preupdate hook change
f
rom
t
runk
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
R
i
ch
a
rd
H
ipp
R
emo
v
e a
n
always-true branch from the preupd
a
te ho
o
k
.
.
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
Richard Hipp
Get t
h
e
ON CONFLI
C
T
DO NOTH
I
NG form of upsert w
o
rking
.
.
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
Richard
H
ipp
Get
the confl
i
ct
-
t
a
rget claus
e
p
a
rsing
working
corre
c
tly
.
.
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
Richard Hipp
Im
p
roved
conflict-target ma
t
ching logic
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
Ric
h
a
r
d Hip
p
Back off of the
e
xtende
d
upsert
s
yntax t
h
at allows
.
.
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
R
i
chard Hipp
B
e
gin add
i
ng upsert logic
.
This i
s
an incremental
.
.
.
commit
|
commitdiff
|
tree
2018-04-12
D
.
Ri
c
hard Hipp
B
r
eak out the up
s
e
r
t
code into
a
separate source fil
e
.
commit
|
commitdiff
|
tree
2018-04-12
D
.
Rich
a
rd Hipp
Fix anoth
e
r typo in
a comment
.
commit
|
commitdiff
|
tree
2018-04-12
D
.
Richard Hipp
S
i
mple
commen
t
cla
r
ification
.
No
c
ode or logic changes
.
commit
|
commitdiff
|
tree
2018-04-12
D
.
Richard Hip
p
E
xt
e
nd the up
s
ert
s
ynt
a
x
t
o
a
llow a WHERE clause on
.
.
.
commit
|
commitdiff
|
tree
2018-04-12
D
.
R
i
chard
Hipp
Up
d
ate the
u
pser
t
parsing so
t
hat
it ac
c
epts conflict
.
.
.
commit
|
commitdiff
|
tree
2018-04-12
D
.
Ric
h
ar
d
H
i
pp
Ad
d
t
he Upsert objec
t
for holding upsert c
l
a
use informati
o
n
.
commit
|
commitdiff
|
tree
2018-04-12
D
.
R
i
char
d
Hipp
Merge
c
hanges
f
rom trunk
.
commit
|
commitdiff
|
tree
2018-04-11
D
.
Richard Hipp
H
e
l
p
t
he pa
r
ser run
f
a
s
t
e
r by a
v
oid
i
n
g
the "e
x
plain
.
.
.
commit
|
commitdiff
|
tree
2018-04-11
D
.
Richard Hipp
Prohibit
bou
n
d parameters in th
e
arguments to table
.
.
.
commit
|
commitdiff
|
tree
2018-04-10
D
.
Richard Hi
p
p
Versio
n
3
.
23
.
1
commit
|
commitdiff
|
tree
2018-04-10
D
.
Richard Hipp
In
c
re
a
s
e the version number to 3
.
23
.
1
.
commit
|
commitdiff
|
tree
2018-04-10
D
.
R
ichard Hip
p
R
e
move an un
n
eces
s
ary SQ
L
ITE_UNTES
T
A
BL
E
comp
i
le
-
time
.
.
.
commit
|
commitdiff
|
tree
2018-04-10
D
.
Richard Hi
p
p
U
p
date the
t
op-level
R
EA
D
ME
.
md file to
p
oi
n
t to the
.
.
.
commit
|
commitdiff
|
tree
2018-04-10
D
.
R
i
chard
Hipp
Up
d
ate the top-
l
e
vel
R
E
ADME
.
m
d file
to poi
n
t to the
.
.
.
commit
|
commitdiff
|
tree
2018-04-09
D
.
R
icha
r
d Hipp
Minor changes to the in
p
ut
g
rammar resulting in a f
a
ster
.
.
.
commit
|
commitdiff
|
tree
2018-04-09
D
.
Richard H
i
pp
Enhance the q
u
ery planner so that it
d
ete
c
ts when
t
he
.
.
.
commit
|
commitdiff
|
tree
next