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
.
R
i
chard Hipp
The previous fix fo
r
ticket [d85ff
f
d6ffe856
0
92ed8
d
a
.
.
.
commit
|
commitdiff
|
tree
2018-04-26
D
.
Richar
d
Hipp
E
nsure that new
.
* values
of an UPDATE do not
get clobb
e
red
.
.
.
commit
|
commitdiff
|
tree
2018-04-26
D
.
Richa
r
d Hipp
Clarif
i
cation of the beha
v
i
o
r o
f
a BEFO
R
E UPDATE trigger
.
.
.
commit
|
commitdiff
|
tree
2018-04-26
D
.
Ri
c
har
d
Hipp
Improved VDBE comment on
t
he
OP_Par
a
m
opcode
.
No substan
t
ia
.
.
.
commit
|
commitdiff
|
tree
2018-04-25
D
.
Richard Hipp
Add new inte
r
f
a
ces for a
c
cessing the
l
i
st of SQL keyword
s
:
commit
|
commitdiff
|
tree
2018-04-25
D
.
R
ichard Hipp
Add the ne
w
DO and
NOTHING key
w
o
rd
s
to
t
he ke
y
word
.
.
.
commit
|
commitdiff
|
tree
2018-04-25
D
.
R
i
cha
r
d
H
ipp
Add the
n
ew
SQLI
T
E
_SHELL_INIT
_
PROC compile-t
i
me
e
n
t
ry
.
.
.
commit
|
commitdiff
|
tree
2018-04-25
D
.
Richard
Hipp
Avoid
m
a
n
y unn
e
c
e
s
s
a
ry calls to
s
q
lite3ReadSc
h
em
a
(
.
.
.
commit
|
commitdiff
|
tree
2018-04-25
D
.
Richard Hipp
Add an asse
r
t() to ensure that schema mu
t
exe
s
are he
l
d
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
Richard
H
ipp
Do not attempt to use terms fro
m
the
W
H
E
R
E clause to
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
Richa
r
d Hip
p
Update the exp
e
r
t
extension test
cases to
a
ccount for
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
Ri
c
hard
Hipp
All the OR opti
m
ization t
o
p
r
o
c
eed even if the OR is
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
Richard Hipp
Add a hyperlink to the
t
icket o
n
the code comment for
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
Richard
H
ipp
E
n
h
a
nce the CLI to ren
d
er
E
XPLAIN QUERY PLAN using
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
Richard
H
i
p
p
Fix a memory leak following fa
i
lure
t
o open a
n
external
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
Richard Hipp
In
E
XP
L
A
I
N QUERY PLAN output, do n
o
t
s
how an EXECU
T
E
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
Richa
r
d Hipp
Fix to check
-
in [c
a
34c
2
dd20ee071
e
] - avoid a NULL pointer
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
R
ichar
d
Hipp
Fix a proble
m
in sqlite3ExprCom
p
ar
e
() associated
wit
h
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Richard H
i
p
p
Fix a
formatting issue in the T
r
eeView output
f
o
r bare
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Richard H
i
pp
Add t
h
e "
.
i
m
poster off
"
variant
of the "
.
imp
o
st
e
r"
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Richard Hipp
The "
.
s
electtrace 0x2000" c
o
mm
a
nd causes just the top
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Ric
h
ard Hipp
The "
.
s
electtrace 4
"
command now
shows
o
nly a single
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Richa
r
d Hi
p
p
Do not restore
the iSelec
t
Id v
a
lue u
n
til a
f
ter the
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Richard H
i
pp
In t
h
e "
.
s
e
lecttr
a
c
e" output, include the
E
XPLAIN QUERY
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Richard Hi
p
p
Ensure t
h
at there are no bind-para
m
ete
r
s or
inc
o
rrect
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Richard Hip
p
Fix an
u
n
reachabl
e
branch as
s
ociated with stac
k
o
v
erflow
.
.
.
commit
|
commitdiff
|
tree
2018-04-21
D
.
R
i
chard Hipp
Perform
a
n
c
e
i
mprovem
e
n
t
s on
t
he m
a
in loop of the LEMON
.
.
.
commit
|
commitdiff
|
tree
2018-04-21
D
.
Richard Hipp
Enhance LEMON to track which
s
ymbols actua
l
ly
c
arry
.
.
.
commit
|
commitdiff
|
tree
2018-04-21
D
.
R
i
chard Hipp
A
dd
t
h
e
%
e
xtra_c
o
ntex
t
directive to lemon, as a
n
alternati
v
e
.
.
.
commit
|
commitdiff
|
tree
2018-04-21
D
.
Ri
c
hard Hi
p
p
Fi
x
UPSERT
s
o
that it pl
a
ys nicely
with AUTOI
N
CREMENT
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Richard Hipp
A
d
d the -dDI
R
E
CT
O
RY c
o
mmand-line option to LEM
O
N
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Ri
c
h
ar
d
Hip
p
Fix
a har
m
l
e
s
s comp
i
ler wa
r
ning
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Richard Hi
p
p
Avo
i
d the use of statement journals o
n
DE
L
E
TEs of a
.
.
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Richard Hipp
Avoid ope
n
in
g
a
state
m
ent jour
n
al on single-row UPDATEs
.
.
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Richard
H
i
pp
Fi
x
a V
D
BE comment on upsert
.
Provide
a
n error mes
s
age
.
.
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Rich
a
r
d Hipp
Avoid
unnecessary
cursor
s
eeking when performing an
.
.
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Richard Hip
p
Improve
d
VDBE c
o
mment on UPSERT code
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Ric
h
ard
H
ipp
Minor
s
i
mplific
a
tion
o
f the
p
revious
checki
n
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
R
i
chard Hip
p
A
void unn
e
c
essary cursor seek
s
during
u
ps
e
r
t processing
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Richard H
i
pp
E
n
hance UPSERT so that the UPDATE uses
the same
set
.
.
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Ri
c
ha
r
d Hipp
Minor simplification o
f
the cursor alloca
t
ion logic
.
.
.
commit
|
commitdiff
|
tree
2018-04-19
D
.
Ric
h
ard Hi
p
p
Fix the
h
andling of
"PRAG
M
A count_changes=ON"
with
.
.
.
commit
|
commitdiff
|
tree
2018-04-19
D
.
Richard Hipp
M
inor s
i
mplificati
o
n
to the ups
e
rt logic
.
commit
|
commitdiff
|
tree
2018-04-19
D
.
Richard Hipp
Add
t
he --upsert option
t
o
t
he
w
ordcoun
t
test p
r
ogram
.
commit
|
commitdiff
|
tree
2018-04-19
D
.
Richard
Hipp
Add the ext/misc/te
m
platev
t
ab
.
c
t
emplate
f
o
r v
i
rt
u
al
.
.
.
commit
|
commitdiff
|
tree
2018-04-19
D
.
Richard
Hip
p
F
i
x a probl
e
m
i
n the new upsert implemention, disco
v
ered
.
.
.
commit
|
commitdiff
|
tree
2018-04-19
D
.
Richard Hipp
Fi
x
the
t
able nam
e
a
liasing on
I
N
S
ERT so that it occurs
.
.
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richard Hipp
Avoid a NU
L
L-p
o
inter deref
f
o
llowi
n
g O
O
M
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
R
i
chard Hipp
F
ix a test case inside distin
c
t
.
te
s
t
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richard Hipp
Improved mat
c
hin
g
o
f
COLLATE clauses
w
i
th
i
n the ON
.
.
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richar
d
Hipp
Fix a problem in the
s
qlite
3
Ex
p
rCompare
(
)
fu
n
ction
.
.
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richa
r
d
H
ipp
Ad
d
sup
p
ort for Pos
t
gr
e
SQL UP
S
ERT syntax a
n
d functio
n
alit
y
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Rich
a
rd Hipp
F
i
x
the build f
o
r
SQLITE_OMIT_UPSE
R
T
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richard Hipp
A
dd the --sorterref
N op
t
ion
to the CLI
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richar
d
Hi
p
p
O
m
i
t
s
ome
c
ode not used witho
u
t
SQLITE_ENABLE
_
SORTER_R
E
F
E
REN
.
.
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Rich
a
rd Hipp
Remove an unused l
o
cal varia
b
le
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
R
ichard Hipp
E
n
hance ALTER TA
B
L
E ADD COLUMN to
s
upport "DEFAULT
.
.
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Ric
h
ard Hipp
A
d
d
ch
e
cks to the CLI that issue a warni
n
g
if
SQLite
.
.
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
R
ichard Hipp
Add new
te
s
tcase()
m
a
c
ros and
f
ix a bug that wa
s
revealed
.
.
.
commit
|
commitdiff
|
tree
2018-04-17
D
.
R
i
chard
H
i
p
p
Remo
v
e
un
r
e
a
chable bra
n
c
h
es
.
100% MC/DC in TH3
now
.
commit
|
commitdiff
|
tree
2018-04-17
D
.
Rich
a
rd Hipp
Adde
d
a
c
o
mment on
the asser
t
() added
t
o the
pr
e
v
i
ous
.
.
.
commit
|
commitdiff
|
tree
2018-04-17
D
.
Richard Hipp
Fixe
s
t
o the logic for
constra
i
nt
ch
e
ck
reordering
.
.
.
commit
|
commitdiff
|
tree
2018-04-17
D
.
R
i
c
h
ard Hipp
During PRAG
M
A vdbe_add
o
ptrace=ON,
s
how calls
t
o
s
q
lite3Vdb
e
R
.
.
.
commit
|
commitdiff
|
tree
2018-04-17
D
.
Richard
Hipp
TK
_
REGISTER expressions nodes a
r
e proba
b
ly not c
o
nst
a
nt
.
.
.
commit
|
commitdiff
|
tree
2018-04-17
D
.
Rich
a
rd
Hipp
Simp
l
ification to the
u
psert
l
ogic
.
commit
|
commitdiff
|
tree
2018-04-17
D
.
Richa
r
d Hipp
New test cases for upsert
.
commit
|
commitdiff
|
tree
2018-04-16
D
.
Richard Hipp
Merge
the Lemo
n
enhanc
e
men
t
fr
o
m t
r
unk,
r
esulting in
.
.
.
commit
|
commitdiff
|
tree
2018-04-16
D
.
Richard Hipp
Lemon enh
a
ncem
e
n
t
s: (1) Do not all
o
cate
space f
o
r
.
.
.
commit
|
commitdiff
|
tree
2018-04-16
D
.
Richard
H
ipp
Remove th
e
MySQL upsert syntax
.
As
an
optional
alias
.
.
.
commit
|
commitdiff
|
tree
2018-04-16
D
.
Richar
d
Hipp
A
d
d support
for
the
"exclud
e
d
.
*" names in the
UPD
A
TE
.
.
.
commit
|
commitdiff
|
tree
2018-04-16
D
.
Ri
c
har
d
Hipp
Merge c
h
anges from trunk
.
commit
|
commitdiff
|
tree
2018-04-16
D
.
Ric
h
ard H
i
pp
Inc
r
ease the version numb
e
r
t
o
3
.
24
.
0
commit
|
commitdiff
|
tree
2018-04-16
D
.
R
i
chard Hip
p
Reduce the size of
t
he NameContext object by gr
o
uping
.
.
.
commit
|
commitdiff
|
tree
2018-04-14
D
.
R
i
chard Hipp
Get
upser
t
working on WITHOUT
R
O
WID tables
.
commit
|
commitdiff
|
tree
2018-04-14
D
.
Ri
c
hard Hipp
M
a
ke sure constraint checks occur in the correct
o
rder
.
.
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
Richard Hip
p
First c
u
t at logic to perform DO UP
D
ATE
for
r
owid
t
abl
e
s
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
Richard Hipp
Ad
d
infrastru
c
ture for doing an
UPDATE as part of an
.
.
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
R
i
c
ha
r
d Hipp
M
e
rge the preup
d
ate hook chan
g
e
f
r
om t
r
u
n
k
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
Richard Hi
p
p
Remov
e
an alwa
y
s-t
r
ue branc
h
fro
m
the preupdate
h
ook
.
.
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
R
i
c
h
ard Hipp
Get the ON CO
N
FLICT D
O
NOTHING form of
u
psert working
.
.
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
Richard Hi
p
p
Get th
e
c
o
n
f
lict-target cla
u
se parsing w
o
rking
c
or
r
ect
l
y
.
.
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
Richard Hipp
Imp
r
oved co
n
flict
-
t
a
r
g
et
matching logic
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
R
ichar
d
Hipp
Back off
of the extended u
p
sert synta
x
t
h
at al
l
o
ws
.
.
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
Richar
d
Hipp
Begin adding upsert l
o
gic
.
This
i
s an i
n
creme
n
t
al
.
.
.
commit
|
commitdiff
|
tree
2018-04-12
D
.
Ric
h
ard Hipp
Break ou
t
the upsert c
o
de int
o
a separate sou
r
ce file
.
commit
|
commitdiff
|
tree
2018-04-12
D
.
R
i
c
hard
H
ipp
Fix anoth
e
r typo in a c
o
mment
.
commit
|
commitdiff
|
tree
2018-04-12
D
.
R
ichard H
i
p
p
Simple
c
omment clarific
a
tion
.
No c
o
de or logic changes
.
commit
|
commitdiff
|
tree
2018-04-12
D
.
Richa
r
d H
i
pp
Extend
the upser
t
s
yntax to all
o
w a
WHERE cla
u
se on
.
.
.
commit
|
commitdiff
|
tree
2018-04-12
D
.
Richard Hipp
Update the upsert parsing so that it a
c
cept
s
c
onf
l
ict
.
.
.
commit
|
commitdiff
|
tree
2018-04-12
D
.
Richard H
i
pp
Add
t
he Ups
e
r
t
o
bject fo
r
holding up
s
ert
c
lause information
.
commit
|
commitdiff
|
tree
2018-04-12
D
.
R
i
chard H
i
pp
Merge changes from trunk
.
commit
|
commitdiff
|
tree
2018-04-11
D
.
Richard Hipp
Help the parser r
u
n faster
by avoiding
t
he "explain
.
.
.
commit
|
commitdiff
|
tree
2018-04-11
D
.
Richard Hipp
P
r
ohibit bound pa
r
ameters
in the arguments t
o
table
.
.
.
commit
|
commitdiff
|
tree
2018-04-10
D
.
R
i
chard Hipp
Versio
n
3
.
23
.
1
commit
|
commitdiff
|
tree
2018-04-10
D
.
Richard Hipp
Increa
s
e the version number to 3
.
23
.
1
.
commit
|
commitdiff
|
tree
2018-04-10
D
.
Richa
r
d Hipp
Remo
v
e an unne
c
essary
S
QLITE_
U
NTE
S
TABLE compile
-
tim
e
.
.
.
commit
|
commitdiff
|
tree
2018-04-10
D
.
Richar
d
Hi
p
p
U
pdate the top-le
v
el README
.
md fil
e
to poin
t
to
the
.
.
.
commit
|
commitdiff
|
tree
2018-04-10
D
.
Rich
a
r
d
Hipp
Update the top-level README
.
md f
i
le t
o
p
o
int to the
.
.
.
commit
|
commitdiff
|
tree
2018-04-09
D
.
Richard Hipp
Minor changes t
o
t
he
i
nput gr
a
m
m
ar resulting in
a
fa
s
t
e
r
.
.
.
commit
|
commitdiff
|
tree
2018-04-09
D
.
Richa
r
d
Hip
p
Enhance
t
h
e query pla
n
ner so that it
d
e
tects
w
hen the
.
.
.
commit
|
commitdiff
|
tree
next