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
Fix a VDBE comment on upsert. Provide an error message when upsert detects
2018-04-20
D
.
Richard Hip
p
Fix a VDBE
c
omment on upsert
.
Provide an er
r
or message
.
.
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Rich
a
rd
Hipp
Avoid
u
nnecessary curso
r
seek
i
n
g
when performin
g
an
.
.
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Richard Hi
p
p
I
m
proved VDBE comment on
U
PSERT c
o
de
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
R
i
cha
r
d H
i
p
p
Mino
r
si
m
p
l
ification of
the previo
u
s
che
c
kin
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Richard Hip
p
A
void unnecessary cursor see
k
s
dur
i
ng upse
r
t proce
s
sing
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Rich
a
rd Hipp
Enhance UPSERT s
o
that the
U
P
DATE uses th
e
same set
.
.
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Richard
H
ipp
Minor simplification
o
f th
e
cursor alloca
t
i
o
n logic
.
.
.
commit
|
commitdiff
|
tree
2018-04-19
D
.
Richard Hipp
Fix the h
a
ndling of "PRAGMA count_changes=ON"
with
.
.
.
commit
|
commitdiff
|
tree
2018-04-19
D
.
Richard Hip
p
Minor simplific
a
tion
to the upsert log
i
c
.
commit
|
commitdiff
|
tree
2018-04-19
D
.
Ric
h
ard
H
i
pp
Add the
-
-u
p
sert option
to
t
h
e
wordcount test program
.
commit
|
commitdiff
|
tree
2018-04-19
D
.
Richard
H
ipp
A
dd the ext/mi
s
c/
t
empl
a
t
evta
b
.
c tem
p
late for virtu
a
l
.
.
.
commit
|
commitdiff
|
tree
2018-04-19
D
.
Richar
d
Hipp
F
i
x a problem in
the new upsert implemention,
dis
c
overed
.
.
.
commit
|
commitdiff
|
tree
2018-04-19
D
.
R
i
chard Hipp
F
i
x the t
a
ble
name alias
i
ng
o
n
INSERT so t
h
at i
t
occurs
.
.
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
R
i
chard Hipp
Avo
i
d
a N
U
LL-pointer deref
f
ol
l
owing OOM
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richard
Hi
p
p
F
ix a test c
a
s
e
i
n
side distinct
.
test
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richard Hipp
I
mpr
o
ve
d
matching of CO
L
LATE cl
a
u
s
es
w
ithin
t
he ON
.
.
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richard Hipp
Fix a
p
ro
b
l
em
in the sqlite3ExprCompare() fu
n
ction
.
.
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richard Hipp
A
dd
s
upport for Post
g
r
eSQL
UPSERT syn
t
ax
a
nd functionality
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richard Hi
p
p
Fi
x
the build
f
or SQL
I
TE_OMIT_UPSERT
commit
|
commitdiff
|
tree
2018-04-18
D
.
Ri
c
hard
H
i
pp
Add the --s
o
r
terref N opt
i
on to the CLI
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richard Hipp
Omit som
e
code no
t
used wi
t
hout SQ
L
IT
E
_E
N
ABLE_SORTER_R
E
FEREN
.
.
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
R
i
c
h
a
rd Hipp
Remove an unused
l
ocal v
a
r
iable
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Ric
h
ard Hip
p
Enh
a
nce A
L
TER T
A
B
LE
A
DD COLUMN to support "DEFA
U
LT
.
.
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
R
i
ch
a
rd
Hipp
A
d
d checks to
t
h
e CL
I
that
i
ssue a war
n
i
n
g
if SQLite
.
.
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richard Hipp
Add new testcas
e
() macros and fix a
b
ug that was reveal
e
d
.
.
.
commit
|
commitdiff
|
tree
2018-04-17
D
.
R
i
ch
a
rd Hip
p
Remove unreachable branches
.
10
0
%
MC/
D
C in TH3 now
.
commit
|
commitdiff
|
tree
2018-04-17
D
.
R
ichard Hipp
Added a co
m
ment
o
n the asser
t
() added to the
previous
.
.
.
commit
|
commitdiff
|
tree
2018-04-17
D
.
Rich
a
r
d H
i
pp
Fix
e
s to
t
he logic
for constraint chec
k
r
e
ordering
.
.
.
commit
|
commitdiff
|
tree
2018-04-17
D
.
R
i
chard H
i
pp
During PRAGMA vd
b
e_addo
p
t
race=ON, show calls t
o
sqli
t
e3Vdbe
R
.
.
.
commit
|
commitdiff
|
tree
2018-04-17
D
.
Ri
c
hard
H
ipp
TK_RE
G
ISTER expressions
n
odes are probably not const
a
nt
.
.
.
commit
|
commitdiff
|
tree
2018-04-17
D
.
Richa
r
d Hipp
Si
m
p
l
ification to the upsert logic
.
commit
|
commitdiff
|
tree
2018-04-17
D
.
R
ichard Hipp
New test c
a
ses for upsert
.
commit
|
commitdiff
|
tree
2018-04-16
D
.
Ri
c
hard Hipp
Merge the Le
m
on
e
nhanceme
n
t fr
o
m trunk,
r
esu
l
tin
g
in
.
.
.
commit
|
commitdiff
|
tree
2018-04-16
D
.
Richard Hipp
Lemo
n
enhancements:
(1) Do not al
l
ocate spac
e
for
.
.
.
commit
|
commitdiff
|
tree
2018-04-16
D
.
Richard Hipp
Remov
e
the MySQL ups
e
rt syn
t
ax
.
As an optiona
l
alias
.
.
.
commit
|
commitdiff
|
tree
2018-04-16
D
.
Richard
Hipp
A
d
d support for the "exc
l
u
d
ed
.
*" names in the UPDATE
.
.
.
commit
|
commitdiff
|
tree
2018-04-16
D
.
Ri
c
hard Hipp
Me
r
ge changes from trunk
.
commit
|
commitdiff
|
tree
2018-04-16
D
.
R
i
chard Hipp
Increase the version
n
umber to 3
.
24
.
0
commit
|
commitdiff
|
tree
2018-04-16
D
.
Richard Hipp
Reduce
the size of
t
he NameContext object by grou
p
ing
.
.
.
commit
|
commitdiff
|
tree
2018-04-14
D
.
Richar
d
Hipp
Ge
t
u
psert wor
k
ing on WITHOUT ROWID ta
b
les
.
commit
|
commitdiff
|
tree
2018-04-14
D
.
Richar
d
Hipp
Make sure
c
o
n
s
traint
che
c
k
s
occur in the correct order
.
.
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
Richard Hipp
Fi
r
st c
u
t
a
t
logic t
o
perform DO UPDATE for rowid tables
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
Richard Hipp
Add inf
r
astructur
e
f
o
r doing an UPDATE
as part of an
.
.
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
Rich
a
rd Hipp
Me
r
g
e the pr
e
u
pdate
hook c
h
a
n
ge
from trunk
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
Richard Hipp
Remove a
n
alway
s
-t
r
ue branch from th
e
preupdate hook
.
.
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
Ri
c
ha
r
d
Hipp
Get the O
N
C
ONFLICT DO NOTHING form o
f
ups
e
r
t
working
.
.
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
Richard Hi
p
p
Get the conflic
t
-target clause parsing working
c
orre
c
tly
.
.
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
Richard
Hipp
Impr
o
v
ed
confli
c
t-ta
r
get
m
a
t
c
h
ing logic
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
Richa
r
d Hipp
Back off of the
e
xtended upsert syntax that
allows
.
.
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
Rich
a
rd H
i
p
p
Begin ad
d
ing upser
t
logic
.
This is a
n
incremen
t
al
.
.
.
commit
|
commitdiff
|
tree
2018-04-12
D
.
Richar
d
Hipp
Break
out the upsert code
i
n
to
a separate sou
r
ce file
.
commit
|
commitdiff
|
tree
2018-04-12
D
.
Richard
Hipp
Fi
x
another
t
ypo in a comme
n
t
.
commit
|
commitdiff
|
tree
2018-04-12
D
.
Rich
a
rd
H
ipp
Simple comment
c
l
a
rification
.
No cod
e
or logic changes
.
commit
|
commitdiff
|
tree
2018-04-12
D
.
Richar
d
Hipp
Exte
n
d the upse
r
t syntax to allow a WHERE
clause on
.
.
.
commit
|
commitdiff
|
tree
2018-04-12
D
.
R
ichard
H
ipp
Upd
a
t
e
the upsert parsing so that it accept
s
co
n
flict
.
.
.
commit
|
commitdiff
|
tree
2018-04-12
D
.
R
ichard Hipp
A
d
d the Upsert object for holding upsert clause
in
f
or
m
ati
o
n
.
commit
|
commitdiff
|
tree
2018-04-12
D
.
Richa
r
d Hipp
Merge changes f
r
om tru
n
k
.
commit
|
commitdiff
|
tree
2018-04-11
D
.
Richard
H
ip
p
Help the parser run faster by avoi
d
i
n
g the "explain
.
.
.
commit
|
commitdiff
|
tree
2018-04-11
D
.
Ri
c
hard Hipp
Prohibit bound
p
aramete
r
s in the a
r
guments
t
o
t
able
.
.
.
commit
|
commitdiff
|
tree
2018-04-10
D
.
R
icha
r
d
Hipp
Version 3
.
23
.
1
commit
|
commitdiff
|
tree
2018-04-10
D
.
Richa
r
d Hipp
Increas
e
th
e
versio
n
number to 3
.
23
.
1
.
commit
|
commitdiff
|
tree
2018-04-10
D
.
R
ichard Hipp
Remove an
u
nn
e
cessary
SQLI
T
E_UNTESTABLE
compile-time
.
.
.
commit
|
commitdiff
|
tree
2018-04-10
D
.
Richard
H
i
pp
Update
the top-level
R
EADM
E
.
md file
to point to the
.
.
.
commit
|
commitdiff
|
tree
2018-04-10
D
.
Richard Hipp
Upd
a
te
th
e
top-level README
.
md file to point to the
.
.
.
commit
|
commitdiff
|
tree
2018-04-09
D
.
R
ich
a
rd
H
ipp
M
i
nor chan
g
e
s
to t
h
e input
g
r
ammar resulting in a faster
.
.
.
commit
|
commitdiff
|
tree
2018-04-09
D
.
Richard Hi
p
p
Enhance the
query
planner
s
o that it de
t
ec
t
s when th
e
.
.
.
commit
|
commitdiff
|
tree
2018-04-09
D
.
Rich
a
rd
H
ip
p
I
m
provements
t
o
"
.
wh
e
retra
c
e" o
u
tput
.
commit
|
commitdiff
|
tree
2018-04-09
D
.
Richard Hipp
Fix
a
(harmless) signed integer overflow wa
r
n
i
n
g
.
commit
|
commitdiff
|
tree
2018-04-07
D
.
R
i
chard Hip
p
More comp
l
ete parsi
n
g of
UPSERT, inclu
d
in
g
UPS
E
RT wi
t
hin
.
.
.
commit
|
commitdiff
|
tree
2018-04-06
D
.
Richard Hipp
Dem
o
nstration of how
t
he parse
r
c
a
n be
a
u
gmented to
.
.
.
commit
|
commitdiff
|
tree
2018-04-06
D
.
Rich
a
rd Hipp
Enhance LEM
O
N to
s
ho
w
precen
d
ence of sy
m
bols and al
l
.
.
.
commit
|
commitdiff
|
tree
2018-04-05
D
.
Richard Hipp
Fix the sqlite3WhereTrace mechanism so tha
t
it compi
l
e
s
.
.
.
commit
|
commitdiff
|
tree
2018-04-03
D
.
Ri
c
hard H
i
pp
Fix
an error
message in
speedtest1
.
c a
n
d make the
.
.
.
commit
|
commitdiff
|
tree
2018-04-03
D
.
Richar
d
Hi
p
p
Fi
x
the gen
e
rate_s
e
ries virtual t
a
ble
so
t
h
a
t it cor
r
ectly
.
.
.
commit
|
commitdiff
|
tree
2018-04-03
D
.
R
ichard Hipp
Change the LEFT J
O
I
N strength redu
c
tion optimization
.
.
.
commit
|
commitdiff
|
tree
2018-04-02
D
.
Richard Hipp
Version
3
.
23
.
0
commit
|
commitdiff
|
tree
2018-04-02
D
.
Richard Hipp
Better solution
t
o the LIKE
p
roblem from
t
he p
r
evious
.
.
.
commit
|
commitdiff
|
tree
2018-03-31
D
.
Richard
H
ipp
Fix a logic
error disco
v
ered by OSSFuzz that can cause
.
.
.
commit
|
commitdiff
|
tree
2018-03-30
D
.
Ric
h
a
rd Hipp
Fix a bug in the spell
f
ix extension ca
u
sing it
to co
m
p
u
te
.
.
.
commit
|
commitdiff
|
tree
2018-03-30
D
.
Richard Hipp
Fix a
n
o
f
f-b
y
-o
n
e error in the
d
ist3 algorith
m
of t
h
e
.
.
.
commit
|
commitdiff
|
tree
2018-03-29
D
.
Rich
a
rd Hi
p
p
Modify the sqlite3OsFileCo
n
tr
o
l
(
)
i
nterface to detect
.
.
.
commit
|
commitdiff
|
tree
2018-03-28
D
.
Richard H
i
pp
Fix a harmless co
m
piler warning in the kvtest
.
exe
p
rogram
.
commit
|
commitdiff
|
tree
2018-03-28
D
.
Richard Hipp
Fix
a harmless com
p
iler warning
.
commit
|
commitdiff
|
tree
2018-03-28
D
.
Richard Hipp
Rem
o
ve ta
b
characters
.
N
o
l
o
gical cha
n
ges to code
.
commit
|
commitdiff
|
tree
2018-03-28
D
.
Richard
H
ipp
Min
o
r
c
o
mment
c
hanges
.
commit
|
commitdiff
|
tree
2018-03-27
D
.
R
ichard Hipp
F
i
x a typo
i
n the README file for
I
CU
.
No code changes
.
commit
|
commitdiff
|
tree
2018-03-27
D
.
Ric
h
ard Hipp
The push
-
down
optimization was being too aggres
s
ive
.
.
.
commit
|
commitdiff
|
tree
2018-03-27
D
.
Richa
r
d
Hip
p
Pr
o
vide the ability
f
or t
h
e VFS to do a blo
c
k
ing wait
.
.
.
commit
|
commitdiff
|
tree
2018-03-26
D
.
Rich
a
rd
H
ipp
Do
n
ot i
n
ject
OOM errors on SQLI
T
E
_FCN
T
L
_
LOCK_TIMEOUT
.
.
.
commit
|
commitdiff
|
tree
2018-03-26
D
.
Richard Hipp
Avo
i
d
a r
a
ce co
n
dition that
might cause a busy_timeo
u
t
.
.
.
commit
|
commitdiff
|
tree
2018-03-26
D
.
Rich
a
rd
Hi
p
p
Add
infrast
r
ucture to supp
o
rt
f
or using F_SETLK
W
w
i
t
h
.
.
.
commit
|
commitdiff
|
tree
2018-03-26
D
.
Richard Hipp
Refactor so
m
e internal ob
j
ec
t
element n
a
m
e
s
used
b
y
.
.
.
commit
|
commitdiff
|
tree
2018-03-24
D
.
Ric
h
ard Hipp
Add testcase() mac
r
os and
i
mprove comment
s
in t
h
e LEFT
.
.
.
commit
|
commitdiff
|
tree
2018-03-24
D
.
R
i
chard Hipp
Yet another fau
l
t in the
sqlite3E
x
prImp
l
iesNotNull
.
.
.
commit
|
commitdiff
|
tree
2018-03-24
D
.
Richard Hip
p
Bug f
i
x in
the
LEFT JOIN strength reductio
n
optimizatio
n
of
commit
|
commitdiff
|
tree
2018-03-24
D
.
Ri
c
h
ard
H
ipp
P
rep
e
nd linkage macros
to the sqli
t
e3
r
eb
a
ser interfaces
.
commit
|
commitdiff
|
tree
2018-03-23
D
.
Ri
c
h
ard Hipp
Fix the -readonly option on
the
C
LI
s
o that i
t
a
c
tually
.
.
.
commit
|
commitdiff
|
tree
2018-03-23
D
.
Richard Hipp
Fix t
y
po in a commen
t
used
f
or
d
o
c
ument
a
t
i
on
.
No chan
g
e
s
.
.
.
commit
|
commitdiff
|
tree
2018-03-23
D
.
Ri
c
h
a
rd Hipp
Fix an erro
r
in the CLI in the previ
o
us
(
[0249
d
9aecf69948
.
.
.
commit
|
commitdiff
|
tree
2018-03-23
D
.
Ri
c
ha
r
d
H
ip
p
Fix
t
he ANALYZE command so that
it will process tables
.
.
.
commit
|
commitdiff
|
tree
next