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 previous fix for ti
c
ket [d85fffd6f
f
e8560
9
2e
d
8da
.
.
.
commit
|
commitdiff
|
tree
2018-04-26
D
.
Richard
Hi
p
p
Ensure
t
hat
n
e
w
.
* values of an
U
PDAT
E
do
not ge
t
clobbe
r
ed
.
.
.
commit
|
commitdiff
|
tree
2018-04-26
D
.
Richard Hipp
Clarifi
c
ation
of the behavior of a BEFORE UP
D
ATE trigger
.
.
.
commit
|
commitdiff
|
tree
2018-04-26
D
.
Richard Hipp
Impr
o
ved VD
B
E comme
n
t
on
the OP_Para
m
opcode
.
No subst
a
ntia
.
.
.
commit
|
commitdiff
|
tree
2018-04-25
D
.
Richard Hip
p
A
d
d n
e
w
interfaces fo
r
accessing the list of SQL
k
ey
w
ords:
commit
|
commitdiff
|
tree
2018-04-25
D
.
Richard Hipp
Ad
d
t
he
n
ew DO and NO
T
H
ING ke
y
words to the
k
eyword
.
.
.
commit
|
commitdiff
|
tree
2018-04-25
D
.
Richard Hipp
Add the n
e
w
S
Q
L
I
T
E_SHELL_INIT_
P
ROC
com
p
i
le-ti
m
e entry
.
.
.
commit
|
commitdiff
|
tree
2018-04-25
D
.
Richa
r
d
H
ipp
Avo
i
d
ma
n
y unnec
e
ssa
r
y calls to sqlite3ReadSchema(
.
.
.
commit
|
commitdiff
|
tree
2018-04-25
D
.
R
ich
a
rd Hipp
Ad
d
an assert() to ensure
t
hat schema
mutexes are held
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
Richard Hipp
Do
n
o
t
attempt
to
use
t
e
r
ms from the W
H
ERE cl
a
use to
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
R
i
chard Hipp
Update the expert
exte
n
sion test cases to account for
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
Ri
c
h
a
r
d
H
i
pp
All the OR optimization
t
o
proc
e
ed even i
f
the OR
is
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
Richard Hipp
Add a hyperlink
t
o
t
h
e ticket
on the code comment for
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
Ric
h
a
rd H
i
pp
E
nhance the C
L
I to
r
ender EXPLAIN QUERY PLAN using
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
R
i
chard Hipp
Fix a memory l
e
ak following
fa
i
lu
r
e to open an
e
x
ternal
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
Richar
d
Hipp
In
EXPLAIN QUERY
PLAN output, do not
show an EXECUTE
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
Rich
a
r
d
Hip
p
Fix to check-in
[ca
3
4c2dd20ee071e] - avoid
a
NULL p
o
inter
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Ric
h
ard Hipp
Fix a problem in sqlite3E
x
prComp
a
re(
)
associated with
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Richard Hipp
Fi
x
a forma
t
t
i
ng issue in
t
he
T
r
e
e
Vi
e
w o
u
t
put for ba
r
e
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Richard Hipp
Add the "
.
i
m
p
oster
off" vari
a
nt of the "
.
impo
s
te
r
"
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Ri
c
hard Hipp
The
"
.
sel
e
cttrace
0
x2000" command c
a
u
ses
j
u
st the top
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
R
i
c
h
ard Hipp
The
"
.
sele
c
ttrace 4
"
c
o
mm
a
n
d
n
o
w show
s
only a
single
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Ric
h
ard
Hipp
Do not restore the i
S
electId value until after the
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Richa
r
d
Hipp
In the "
.
s
electtrace
"
out
p
ut, i
n
clude the EXPLAIN QUERY
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Richard Hipp
Ensure that th
e
re a
r
e no bind-
p
arameters or i
n
cor
r
ect
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Rich
a
rd Hipp
Fix
an unreachable branch assoc
i
ated with stack ov
e
r
flow
.
.
.
commit
|
commitdiff
|
tree
2018-04-21
D
.
Rich
a
rd Hipp
Performance impro
v
e
m
ents on the main loop o
f
the LEMON
.
.
.
commit
|
commitdiff
|
tree
2018-04-21
D
.
R
i
ch
a
rd Hipp
Enhance LEMON to tra
c
k which s
y
mbo
l
s
actuall
y
ca
r
ry
.
.
.
commit
|
commitdiff
|
tree
2018-04-21
D
.
Richard Hipp
Ad
d
the %extra_context directiv
e
t
o lem
o
n, as an al
t
er
n
a
t
ive
.
.
.
commit
|
commitdiff
|
tree
2018-04-21
D
.
R
i
c
h
ard
H
i
pp
Fix UPS
E
R
T so th
a
t it plays nicely with AU
T
OINCREMENT
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Richar
d
Hipp
Add
the -dDIRECTORY com
m
and-
l
ine
o
ption
t
o LEMON
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Richar
d
Hipp
Fi
x
a
harm
l
e
s
s compiler warning
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Richard Hipp
Avoid
the use
of s
t
atement j
o
urnals on
D
ELETEs of
a
.
.
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Rich
a
rd Hipp
Avoi
d
openin
g
a state
m
e
n
t journal
o
n single-row
U
P
DATE
s
.
.
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Richard Hipp
Fi
x
a VDB
E
comment on upsert
.
P
r
o
vide an e
r
ror message
.
.
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Richard Hipp
Avoid unnecessary cursor seeking when performing an
.
.
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Rich
a
rd Hipp
Improved V
D
BE comment on UPSERT code
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Richard Hi
p
p
Minor simp
l
ifica
t
io
n
of th
e
previ
o
us checkin
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Ri
c
h
a
rd
H
i
p
p
Avoid unnecess
a
ry
cursor see
k
s during upsert p
r
ocessing
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Richa
r
d H
i
p
p
Enhance
UPSERT so that the
U
P
D
ATE uses the same se
t
.
.
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Richar
d
Hi
p
p
M
i
nor
simp
l
ificat
i
on
o
f the cursor allocation log
i
c
.
.
.
commit
|
commitdiff
|
tree
2018-04-19
D
.
Richard Hi
p
p
Fix the handlin
g
of "PRAGMA count_changes=O
N
" with
.
.
.
commit
|
commitdiff
|
tree
2018-04-19
D
.
Ri
c
hard H
i
pp
Minor s
i
mpli
f
ication to the upsert logic
.
commit
|
commitdiff
|
tree
2018-04-19
D
.
R
i
chard
Hipp
Add the --upsert opti
o
n to the wordcount test program
.
commit
|
commitdiff
|
tree
2018-04-19
D
.
Richard Hipp
Add t
h
e
ext/
m
isc/tem
p
latevtab
.
c
templa
t
e for virtual
.
.
.
commit
|
commitdiff
|
tree
2018-04-19
D
.
Richard Hipp
Fix a problem in t
h
e new
u
psert im
p
lementi
o
n, discovere
d
.
.
.
commit
|
commitdiff
|
tree
2018-04-19
D
.
Richard Hipp
Fi
x
th
e
table name alias
i
ng o
n
INSERT so tha
t
i
t occurs
.
.
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
R
ichard Hipp
Avoid a NUL
L
-po
i
nte
r
deref fo
l
lowing OOM
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
R
i
chard Hipp
Fix a
test case insi
d
e di
s
ti
n
ct
.
test
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richard
H
ipp
I
mproved matchin
g
of COLL
A
TE clauses within the ON
.
.
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richa
r
d Hipp
Fix a pro
b
lem in the sqlite3ExprCompare() f
u
nct
i
on
.
.
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richard H
i
p
p
Add su
p
port f
o
r Postg
r
e
S
QL UPSERT syntax and functionality
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Ric
h
ard Hip
p
F
ix th
e
build for SQLITE_OM
I
T_UPSERT
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richard Hipp
Add the
--sorterref N option to
the
CLI
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
R
ichard H
i
pp
Omit some code not used withou
t
SQLIT
E
_ENABLE_SORT
E
R_REFEREN
.
.
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Rich
a
rd Hipp
R
emove an unused local varia
b
le
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richar
d
Hip
p
Enha
n
ce ALTER T
A
BLE ADD C
O
LUMN to suppo
r
t "DE
F
AULT
.
.
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richard Hipp
Add checks to the CLI that issue
a warning
i
f
S
Q
Li
t
e
.
.
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richa
r
d
Hi
p
p
Add new t
e
stcas
e
() macros and fix a bug t
h
at was re
v
e
aled
.
.
.
commit
|
commitdiff
|
tree
2018-04-17
D
.
Ric
h
ard
H
ipp
Remove unreachab
l
e
br
a
nches
.
100% MC/D
C
in T
H
3 now
.
commit
|
commitdiff
|
tree
2018-04-17
D
.
Rich
a
r
d
Hipp
Added
a comment on the assert() added t
o
t
he previo
u
s
.
.
.
commit
|
commitdiff
|
tree
2018-04-17
D
.
Ric
h
ard Hipp
Fixes to the logic for c
o
nstrai
n
t chec
k
reordering
.
.
.
commit
|
commitdiff
|
tree
2018-04-17
D
.
R
i
c
hard
H
i
pp
Du
r
in
g
PRAGMA vdbe_
a
dd
o
ptrace=ON, show calls to sqlite3VdbeR
.
.
.
commit
|
commitdiff
|
tree
2018-04-17
D
.
Richard Hip
p
TK_REGISTER exp
r
essions nod
e
s
are prob
a
bly n
o
t constant
.
.
.
commit
|
commitdiff
|
tree
2018-04-17
D
.
R
ichard Hipp
Simplif
i
cation to
th
e
upser
t
l
o
gic
.
commit
|
commitdiff
|
tree
2018-04-17
D
.
Richard Hipp
New test ca
s
es for upsert
.
commit
|
commitdiff
|
tree
2018-04-16
D
.
R
ichard
H
i
pp
Merge the Lemon enhance
m
ent
from trunk
,
res
u
ltin
g
i
n
.
.
.
commit
|
commitdiff
|
tree
2018-04-16
D
.
Ri
c
hard Hip
p
Lemon en
h
a
n
c
ements:
(1) Do not
allocate space f
o
r
.
.
.
commit
|
commitdiff
|
tree
2018-04-16
D
.
Richard Hi
p
p
Re
m
ove
the My
S
QL upse
r
t syntax
.
As an optional alias
.
.
.
commit
|
commitdiff
|
tree
2018-04-16
D
.
R
ichard Hip
p
Add support
for the
"
excl
u
d
e
d
.
*
"
names i
n
t
h
e UPD
A
TE
.
.
.
commit
|
commitdiff
|
tree
2018-04-16
D
.
Richard Hi
p
p
Merge change
s
f
r
om trunk
.
commit
|
commitdiff
|
tree
2018-04-16
D
.
Richard
Hipp
In
c
re
a
se
t
he vers
i
on numbe
r
t
o
3
.
24
.
0
commit
|
commitdiff
|
tree
2018-04-16
D
.
Richard Hipp
Re
d
uce t
h
e s
i
z
e
of t
h
e Nam
e
Context
o
bject
b
y grouping
.
.
.
commit
|
commitdiff
|
tree
2018-04-14
D
.
R
i
c
hard Hipp
G
et ups
e
rt working on WIT
H
O
UT ROWID
tables
.
commit
|
commitdiff
|
tree
2018-04-14
D
.
R
ich
a
rd Hipp
M
a
ke su
r
e co
n
straint checks occur
i
n th
e
correct
o
rd
e
r
.
.
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
Richard
Hipp
First cut
a
t
l
ogic to perform
DO UPDATE for r
o
w
i
d
t
ables
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
Richard Hipp
Ad
d
infrastructure
f
or doing an UPDATE as part of an
.
.
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
Richa
r
d Hipp
Merge the preupdate hook
c
hange fr
o
m
t
ru
n
k
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
R
ich
a
r
d Hip
p
R
em
o
ve an
always-true
b
ran
c
h from the
preupdate hook
.
.
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
R
i
c
h
ard Hi
p
p
Get the ON
C
ONFLICT DO NOTHING form
o
f upsert
working
.
.
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
Richard Hipp
Get the co
n
flict
-
target
c
lause parsing working correct
l
y
.
.
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
Richar
d
Hipp
Improved conflict-ta
r
get ma
t
chin
g
logic
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
Richard
H
ipp
B
ack off of the
e
xtended upsert syntax that
a
llo
w
s
.
.
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
Richard Hipp
Be
g
in adding upsert logic
.
This is an incremental
.
.
.
commit
|
commitdiff
|
tree
2018-04-12
D
.
Richard Hipp
Break out the up
s
ert code into a
s
epara
t
e s
o
urce file
.
commit
|
commitdiff
|
tree
2018-04-12
D
.
Richard Hipp
Fix anot
h
er typo i
n
a comment
.
commit
|
commitdiff
|
tree
2018-04-12
D
.
Ri
c
hard Hipp
Simple com
m
ent clarif
i
c
a
tion
.
N
o code or
logi
c
c
h
a
nges
.
commit
|
commitdiff
|
tree
2018-04-12
D
.
Ri
c
h
a
r
d Hipp
Exten
d
t
he
upsert syntax
t
o al
l
ow a WHERE clause on
.
.
.
commit
|
commitdiff
|
tree
2018-04-12
D
.
Richard Hi
p
p
Update the upsert
p
arsing so
that
i
t
accepts conflict
.
.
.
commit
|
commitdiff
|
tree
2018-04-12
D
.
Richard Hipp
Add
t
he Upsert object for holding u
p
sert clause information
.
commit
|
commitdiff
|
tree
2018-04-12
D
.
Richard Hip
p
Merge cha
n
ges from trunk
.
commit
|
commitdiff
|
tree
2018-04-11
D
.
Richard Hipp
Help the
parse
r
run faster by avoidin
g
the "expla
i
n
.
.
.
commit
|
commitdiff
|
tree
2018-04-11
D
.
Richard
H
ipp
P
r
ohibit bou
n
d parameters in the
arguments to table
.
.
.
commit
|
commitdiff
|
tree
2018-04-10
D
.
Richard
Hip
p
Versio
n
3
.
23
.
1
commit
|
commitdiff
|
tree
2018-04-10
D
.
Richard Hi
p
p
I
n
creas
e
the version number
to
3
.
23
.
1
.
commit
|
commitdiff
|
tree
2018-04-10
D
.
Richard Hipp
Remove an unneces
s
ary SQLIT
E
_UNTESTA
B
LE compile-time
.
.
.
commit
|
commitdiff
|
tree
2018-04-10
D
.
Ri
c
hard Hipp
Upd
a
te the top-level README
.
md
f
i
l
e
t
o point to
the
.
.
.
commit
|
commitdiff
|
tree
2018-04-10
D
.
Richard Hipp
Update
the
t
op-l
e
vel README
.
md f
i
l
e to
p
oint
t
o
the
.
.
.
commit
|
commitdiff
|
tree
2018-04-09
D
.
Richard Hip
p
Minor ch
a
n
g
es to the
i
n
put grammar resulting in a fas
t
er
.
.
.
commit
|
commitdiff
|
tree
2018-04-09
D
.
Ri
c
hard Hipp
Enha
n
c
e
th
e
query planner so that it detects when the
.
.
.
commit
|
commitdiff
|
tree
next