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
.
Ri
c
hard
Hipp
The
previou
s
fix for ticket
[
d
8
5
f
f
f
d6ffe856092ed8
d
a
.
.
.
commit
|
commitdiff
|
tree
2018-04-26
D
.
R
ich
a
r
d
H
ipp
Ensure that
n
ew
.
*
v
a
lues of an UPDATE do
n
ot get clobbered
.
.
.
commit
|
commitdiff
|
tree
2018-04-26
D
.
Ric
h
ard Hipp
Clarificat
i
o
n
of the behavior of a BEF
O
RE UP
D
ATE tri
g
ger
.
.
.
commit
|
commitdiff
|
tree
2018-04-26
D
.
R
i
chard Hipp
Improved VDBE comment
o
n the OP_Param o
p
code
.
No
s
ubstantia
.
.
.
commit
|
commitdiff
|
tree
2018-04-25
D
.
Richard Hipp
Add ne
w
interf
a
ces f
o
r accessing the list o
f
SQL keywords:
commit
|
commitdiff
|
tree
2018-04-25
D
.
Ri
c
hard Hipp
Add
t
he
n
ew DO and N
O
THING keywo
r
ds to the keyword
.
.
.
commit
|
commitdiff
|
tree
2018-04-25
D
.
Ri
c
hard Hip
p
Ad
d
the new SQLITE_SHELL_INI
T
_PR
O
C compile-time
e
ntry
.
.
.
commit
|
commitdiff
|
tree
2018-04-25
D
.
Richar
d
Hipp
Avo
i
d m
a
ny unnece
s
sary calls to sqli
t
e3R
e
adSchema(
.
.
.
commit
|
commitdiff
|
tree
2018-04-25
D
.
Richar
d
Hipp
Add a
n
asser
t
(
)
to
ensure that sche
m
a mutexes are he
l
d
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
Ri
c
h
a
r
d H
i
pp
Do
n
ot attempt to
use t
e
r
ms from the WHERE
c
lause to
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
Ri
c
hard Hipp
U
p
d
a
te the
expert extension te
s
t
ca
s
es
to account for
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
Richard Hipp
All
t
he OR op
t
imization to proceed
even if t
h
e OR is
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
Richard Hipp
Add a
h
y
p
erlink
to the ticket on
th
e
code co
m
ment
f
or
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
Richa
r
d
H
ipp
E
n
h
ance the CL
I
t
o render EXPLAIN
Q
UE
R
Y PLAN using
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
Richar
d
H
ipp
Fix
a
memo
r
y le
a
k f
o
llowing fai
l
ure to open an externa
l
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
Richard Hipp
In EXPLAIN
QUE
R
Y PLA
N
out
p
ut, do not show
a
n
EXECUTE
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
Richard
Hipp
Fix to chec
k
-in [ca
3
4
c
2dd2
0
ee071e] - avoid
a
NULL
p
ointer
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Ri
c
ha
r
d Hipp
Fix a
pro
b
lem in sq
l
ite3ExprC
o
mpare() associated wi
t
h
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Richard
Hip
p
F
ix a
formatting is
s
ue in
t
he TreeVi
e
w outp
u
t for
b
are
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Richard Hi
p
p
Add the "
.
i
m
poster off"
v
ar
i
a
nt of the "
.
imp
o
ster"
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Richard Hip
p
The "
.
s
el
e
c
t
t
r
ace
0x2000"
command causes just the top
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Richard Hipp
The "
.
s
electtr
a
ce 4" com
m
and no
w
sho
w
s only
a
single
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Ric
h
ard Hipp
Do not resto
r
e the iSel
e
ctId value until
a
f
ter the
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Ri
c
hard
H
ipp
In
t
he "
.
s
e
l
ecttrace"
out
p
ut
,
include the EXPLAIN QUERY
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
R
i
chard Hipp
E
n
sure that there are no
b
i
n
d
-
parameters or inc
o
rrect
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Rich
a
rd Hipp
Fix an unreachab
l
e
b
ranch
associated with s
t
ack
o
v
e
rflow
.
.
.
commit
|
commitdiff
|
tree
2018-04-21
D
.
Richard Hipp
Performa
n
ce
i
mprovem
e
n
ts o
n
the main loop of
t
h
e LEMON
.
.
.
commit
|
commitdiff
|
tree
2018-04-21
D
.
Richard
H
ipp
Enhance
L
EMON to tr
a
ck which symbols actually carry
.
.
.
commit
|
commitdiff
|
tree
2018-04-21
D
.
Richard Hipp
Add the %extra_context dire
c
tive to
l
emon, a
s
an altern
a
tive
.
.
.
commit
|
commitdiff
|
tree
2018-04-21
D
.
Ric
h
ar
d
Hipp
Fix UPSE
R
T so
t
hat
i
t plays nicely
w
i
t
h AUTOINCREMENT
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
R
i
chard Hipp
Add the -dDIRECTOR
Y
command-line op
t
ion to LEMON
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Richard Hipp
Fix a harmless compil
e
r war
n
ing
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
R
i
chard Hipp
Avo
i
d
t
he use of s
t
atement jo
u
rnals
o
n DELETEs of a
.
.
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Rich
a
rd Hip
p
A
v
o
id o
p
ening a state
m
ent
journal o
n
single-row UPDATEs
.
.
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Richard Hipp
Fix a VDBE comment
on ups
e
rt
.
Provide an erro
r
message
.
.
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Richar
d
Hipp
Av
o
id u
n
necessary curso
r
seeki
n
g
when
performing an
.
.
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Richard
H
i
pp
Improved VDBE comme
n
t
on U
P
S
E
R
T
code
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Richa
r
d
H
i
pp
Minor s
i
mplificati
o
n
o
f
the
prev
i
ous checkin
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Richard Hipp
Avoid u
n
nece
s
sary curso
r
s
eeks during upsert
p
rocessing
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
R
ichard Hipp
E
n
hance UP
S
ERT s
o
t
h
at the UPDATE
u
ses
t
he
s
a
me se
t
.
.
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Ri
c
hard H
i
pp
Minor sim
p
lification of the cur
s
or a
l
loca
t
i
o
n
lo
g
ic
.
.
.
commit
|
commitdiff
|
tree
2018-04-19
D
.
Richard Hipp
Fix the handli
n
g of "PRAGMA
count_chan
g
e
s=ON" with
.
.
.
commit
|
commitdiff
|
tree
2018-04-19
D
.
Ric
h
ard Hipp
Minor simplifi
c
ation to the upse
r
t
l
ogic
.
commit
|
commitdiff
|
tree
2018-04-19
D
.
Richard
Hip
p
Add the --upsert o
p
ti
o
n to the word
c
ount test
pr
o
g
r
am
.
commit
|
commitdiff
|
tree
2018-04-19
D
.
Rich
a
rd Hipp
A
d
d th
e
ex
t
/mi
s
c/templatevtab
.
c templ
a
te for
v
irtual
.
.
.
commit
|
commitdiff
|
tree
2018-04-19
D
.
Richard Hipp
Fix
a
problem in
the new upsert implemention, d
i
s
c
o
v
ered
.
.
.
commit
|
commitdiff
|
tree
2018-04-19
D
.
Richard Hipp
Fix the t
a
ble
n
am
e
aliasi
n
g
on INS
E
R
T
so that i
t
occurs
.
.
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richard Hipp
Avoid a NULL-point
e
r de
r
e
f
fol
l
owing OO
M
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richa
r
d Hipp
Fix a test case insi
d
e distinc
t
.
t
e
st
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Ri
c
ha
r
d Hipp
Imp
r
oved matching of COLLATE clauses within
the ON
.
.
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richard Hipp
Fix a problem i
n
the
s
qlite3E
x
prCompare() function
.
.
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richard Hipp
Add support for PostgreSQL UPSERT syntax
a
nd fu
n
c
t
ionality
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richard
Hipp
Fix the
buil
d
for SQLITE_OMIT_
U
PSERT
commit
|
commitdiff
|
tree
2018-04-18
D
.
Rich
a
rd Hipp
Add the --
s
orterref N o
p
tion t
o
th
e
CLI
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richard Hipp
Omit some code not use
d
w
i
thout SQL
I
T
E
_ENABLE_SO
R
TER_REFEREN
.
.
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richard Hipp
Remove an unused local
v
ari
a
ble
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
R
i
chard H
i
pp
Enhance ALTER
T
ABLE ADD COL
U
M
N
to support
"
D
EFAULT
.
.
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
R
i
c
hard Hi
p
p
Add ch
e
ck
s
to the CLI that i
s
sue a warning
i
f
SQLite
.
.
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richard
H
ipp
Add new
testca
s
e() macro
s
and fix a bug that wa
s
r
ev
e
aled
.
.
.
commit
|
commitdiff
|
tree
2018-04-17
D
.
Ri
c
hard Hip
p
R
e
m
ove unreachable
b
ranche
s
.
100% M
C
/DC
i
n
T
H3 now
.
commit
|
commitdiff
|
tree
2018-04-17
D
.
Ri
c
hard Hipp
Adde
d
a
comment on the assert() a
d
ded
to the previous
.
.
.
commit
|
commitdiff
|
tree
2018-04-17
D
.
R
ichard H
i
pp
Fix
e
s to the logic
f
or cons
t
rai
n
t check reordering
.
.
.
commit
|
commitdiff
|
tree
2018-04-17
D
.
R
i
chard Hipp
Duri
n
g PRAGMA v
d
be
_
addoptra
c
e=O
N
, show calls to sqlite3VdbeR
.
.
.
commit
|
commitdiff
|
tree
2018-04-17
D
.
Richard
H
ipp
TK_RE
G
IS
T
E
R
e
x
p
r
e
ssi
o
n
s
nodes are pro
b
a
b
ly not
constant
.
.
.
commit
|
commitdiff
|
tree
2018-04-17
D
.
Richa
r
d Hi
p
p
Simplification t
o
the upsert logic
.
commit
|
commitdiff
|
tree
2018-04-17
D
.
R
i
c
hard Hipp
New t
e
st cases for upsert
.
commit
|
commitdiff
|
tree
2018-04-16
D
.
R
i
cha
r
d Hipp
M
e
rge the Le
m
on
e
nhanceme
n
t from trunk, resulti
n
g i
n
.
.
.
commit
|
commitdiff
|
tree
2018-04-16
D
.
Rich
a
rd
Hipp
Lemo
n
enhancements:
(
1) Do
n
ot
allocate spa
c
e for
.
.
.
commit
|
commitdiff
|
tree
2018-04-16
D
.
Richa
r
d Hip
p
R
em
o
ve
t
he MySQ
L
up
s
ert synt
a
x
.
As an optional alia
s
.
.
.
commit
|
commitdiff
|
tree
2018-04-16
D
.
Richard Hipp
A
dd support for
the
"
excluded
.
*" n
a
mes in the
UPDATE
.
.
.
commit
|
commitdiff
|
tree
2018-04-16
D
.
Richard Hipp
Merge c
h
ange
s
from trunk
.
commit
|
commitdiff
|
tree
2018-04-16
D
.
Richard Hip
p
Increa
s
e the version number to 3
.
24
.
0
commit
|
commitdiff
|
tree
2018-04-16
D
.
Richard
Hi
p
p
R
e
d
u
ce t
h
e siz
e
o
f the NameContext ob
j
e
c
t
b
y g
r
ouping
.
.
.
commit
|
commitdiff
|
tree
2018-04-14
D
.
Ric
h
ard Hi
p
p
Get
u
psert working
o
n W
I
THOUT ROWI
D
tables
.
commit
|
commitdiff
|
tree
2018-04-14
D
.
R
i
chard
H
ipp
Make s
u
re co
n
s
t
raint che
c
ks occur
in the
c
orrect order
.
.
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
Richar
d
H
i
pp
First cut
a
t
logic to perform DO UPDATE for rowid ta
b
les
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
Richard Hipp
Add i
n
f
rastructure
f
or doing an UPDATE as
par
t
of an
.
.
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
Ric
h
ard H
i
pp
Merge
the preupdate hook chang
e
from trunk
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
R
ichard Hipp
Remo
v
e an always-tru
e
bra
n
c
h
from
t
he pre
u
pdate
hoo
k
.
.
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
Richard Hipp
Get the ON CONFL
I
C
T
DO
N
OTHING form of upsert worki
n
g
.
.
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
R
ic
h
a
r
d Hipp
Get the
conflict-tar
g
et c
l
au
s
e
p
a
r
sing wo
r
king correctly
.
.
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
Richard Hipp
I
m
proved conflic
t
-t
a
rget m
a
tch
i
ng logic
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
Richard Hipp
Back o
f
f of the extended upser
t
syntax that
al
l
ows
.
.
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
Rich
a
r
d Hipp
Begin adding upse
r
t lo
g
ic
.
Th
i
s is an incremental
.
.
.
commit
|
commitdiff
|
tree
2018-04-12
D
.
Richard
Hipp
Brea
k
out t
h
e
upsert code into a
separate source
f
ile
.
commit
|
commitdiff
|
tree
2018-04-12
D
.
Richar
d
Hip
p
F
ix another typo in a comment
.
commit
|
commitdiff
|
tree
2018-04-12
D
.
R
i
c
har
d
H
i
pp
Simple com
m
ent cla
r
ifica
t
ion
.
No
c
ode or logic changes
.
commit
|
commitdiff
|
tree
2018-04-12
D
.
Richard Hipp
Extend the
up
s
ert syntax to allow
a
WHERE c
l
ause on
.
.
.
commit
|
commitdiff
|
tree
2018-04-12
D
.
R
ichard Hipp
Update
t
he upsert parsing so that it accepts
c
onflict
.
.
.
commit
|
commitdiff
|
tree
2018-04-12
D
.
Richard Hipp
Add the
U
psert object for h
o
lding upsert
clause i
n
formation
.
commit
|
commitdiff
|
tree
2018-04-12
D
.
Rich
a
rd
Hipp
M
e
rge changes from trun
k
.
commit
|
commitdiff
|
tree
2018-04-11
D
.
R
i
c
hard Hip
p
H
e
l
p the par
s
er run faster by avoid
i
n
g
the "ex
p
lain
.
.
.
commit
|
commitdiff
|
tree
2018-04-11
D
.
Richard Hipp
Pro
h
i
bit bound parameter
s
i
n
the argu
m
ents to t
a
ble
.
.
.
commit
|
commitdiff
|
tree
2018-04-10
D
.
Richard Hipp
Version 3
.
23
.
1
commit
|
commitdiff
|
tree
2018-04-10
D
.
Richard
H
ipp
Increase the ver
s
ion
number to 3
.
23
.
1
.
commit
|
commitdiff
|
tree
2018-04-10
D
.
Richard H
i
pp
Remo
v
e an unnecessary SQLITE_UNTE
S
TABLE
c
o
m
pile-time
.
.
.
commit
|
commitdiff
|
tree
2018-04-10
D
.
Richard Hipp
U
p
d
ate the top-level
R
EADME
.
md file to point
to
t
he
.
.
.
commit
|
commitdiff
|
tree
2018-04-10
D
.
Richa
r
d Hipp
Update the top-level README
.
md file t
o
poin
t
to t
h
e
.
.
.
commit
|
commitdiff
|
tree
2018-04-09
D
.
Richard Hipp
Minor changes t
o
the
in
p
ut grammar
resulting in a faster
.
.
.
commit
|
commitdiff
|
tree
2018-04-09
D
.
Ric
h
a
rd Hi
p
p
Enhance the q
u
ery planner s
o
that it
d
etects when the
.
.
.
commit
|
commitdiff
|
tree
next