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 the handling of "PRAGMA count_changes=ON" with UPSERT. Also improved
2018-04-19
D
.
Richard H
i
pp
Fix the handling of "PRAG
M
A coun
t
_changes=ON" wit
h
.
.
.
commit
|
commitdiff
|
tree
2018-04-19
D
.
Richard Hipp
Min
o
r
s
impl
i
fi
c
at
i
on t
o
the up
s
ert logic
.
commit
|
commitdiff
|
tree
2018-04-19
D
.
Richard Hipp
Ad
d
t
he --ups
e
rt optio
n
t
o
the w
o
rdcou
n
t
test pro
g
r
a
m
.
commit
|
commitdiff
|
tree
2018-04-19
D
.
R
ichard Hipp
Add the ext/mi
s
c/template
v
tab
.
c t
e
mpla
t
e for vi
r
tual
.
.
.
commit
|
commitdiff
|
tree
2018-04-19
D
.
Richa
r
d
Hipp
Fix a prob
l
em i
n
the new u
p
sert implemention
,
di
s
covere
d
.
.
.
commit
|
commitdiff
|
tree
2018-04-19
D
.
Richard Hi
p
p
F
i
x the tab
l
e name aliasing on INSERT
s
o
that it occurs
.
.
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richard Hipp
Avoi
d
a
N
ULL-
p
ointer deref f
o
llowing OOM
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
R
ichard Hi
p
p
F
i
x
a test case inside
d
istinct
.
test
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richard Hipp
Im
p
roved matching of C
O
LLATE clauses within the ON
.
.
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richard
Hip
p
Fix a pro
b
lem in
t
h
e sqlite
3
ExprCom
p
are() functio
n
.
.
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richard Hipp
A
dd support for Pos
t
gr
e
SQL UPSERT syntax and functionality
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
R
i
c
hard Hipp
F
i
x th
e
bu
i
ld for SQLITE_OMIT_UPSER
T
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richard Hipp
Add the --sorterref N option
t
o the
CLI
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
R
i
c
h
ar
d
Hip
p
Omit some
co
d
e not
u
sed without SQLITE_E
N
A
B
LE_
S
ORTE
R
_
R
E
FEREN
.
.
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
R
ichard Hipp
Remove
a
n unuse
d
loc
a
l variable
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richard H
i
pp
Enhance
A
LTER TABLE
A
DD COL
U
MN to support "DEFAU
L
T
.
.
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richard Hipp
Add checks t
o
t
h
e CLI
that i
s
sue a warning if SQLite
.
.
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richar
d
Hipp
Add new testca
s
e() m
a
cros and fi
x
a bug
t
hat
was
r
evealed
.
.
.
commit
|
commitdiff
|
tree
2018-04-17
D
.
Richard Hipp
Remove
u
n
reacha
b
le
branches
.
100% MC
/
DC
i
n
TH3
n
o
w
.
commit
|
commitdiff
|
tree
2018-04-17
D
.
R
ichard Hip
p
Added a co
m
ment on the a
s
sert()
a
dd
e
d
to the previ
o
us
.
.
.
commit
|
commitdiff
|
tree
2018-04-17
D
.
Richa
r
d
H
i
p
p
Fixes to the logi
c
f
o
r
constraint check
r
eord
e
ring
.
.
.
commit
|
commitdiff
|
tree
2018-04-17
D
.
Richard Hipp
During PRAGMA vdbe_a
d
d
o
ptrace=ON, show calls to sqlite
3
Vdb
e
R
.
.
.
commit
|
commitdiff
|
tree
2018-04-17
D
.
Richard
Hipp
T
K
_
REGIS
T
ER expressions nodes are
probably not constant
.
.
.
commit
|
commitdiff
|
tree
2018-04-17
D
.
Richard Hipp
Simpl
i
f
icat
i
on to
t
h
e upse
r
t logi
c
.
commit
|
commitdiff
|
tree
2018-04-17
D
.
Richard Hi
p
p
New test
case
s
f
or upsert
.
commit
|
commitdiff
|
tree
2018-04-16
D
.
Richard Hip
p
Merge th
e
L
emon en
h
a
n
cement from
trunk, resulting
i
n
.
.
.
commit
|
commitdiff
|
tree
2018-04-16
D
.
Richa
r
d
Hipp
Lemon enhancements:
(1) Do not alloca
t
e space for
.
.
.
commit
|
commitdiff
|
tree
2018-04-16
D
.
Richard Hip
p
Rem
o
ve the MySQL
u
psert syntax
.
As
an optional al
i
as
.
.
.
commit
|
commitdiff
|
tree
2018-04-16
D
.
R
ichard Hipp
Add support for the "e
x
cluded
.
*" names in t
h
e
UPDATE
.
.
.
commit
|
commitdiff
|
tree
2018-04-16
D
.
Richard
H
i
p
p
Mer
g
e changes from trunk
.
commit
|
commitdiff
|
tree
2018-04-16
D
.
Richa
r
d
H
i
pp
Increase the ve
r
sion number to 3
.
2
4
.
0
commit
|
commitdiff
|
tree
2018-04-16
D
.
Richard Hipp
Red
u
c
e
the si
z
e of the Name
C
ontext object by
g
ro
u
ping
.
.
.
commit
|
commitdiff
|
tree
2018-04-14
D
.
Ri
c
h
a
rd Hi
p
p
Ge
t
upsert working on
W
I
THOUT
ROWID tables
.
commit
|
commitdiff
|
tree
2018-04-14
D
.
Richard Hipp
Make sure constraint checks occur
i
n
t
he
correct order
.
.
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
Richard Hipp
F
i
rst
c
ut at logic
to p
e
r
f
or
m
DO UPDA
T
E f
o
r
row
i
d
t
ables
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
Richar
d
Hipp
Add in
f
rastructu
r
e for doing an UPD
A
TE as part of
an
.
.
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
Richa
r
d Hipp
Merge
t
h
e
preupdat
e
hook change from
t
runk
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
R
i
ch
a
rd H
i
pp
Rem
o
ve an always
-
true branch
f
rom the preupdate hoo
k
.
.
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
Rich
a
rd H
i
pp
Get the O
N
C
O
NFLICT DO NOTHING form o
f
upsert working
.
.
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
Richard Hipp
G
et the conf
l
ict-tar
g
et clause parsing working c
o
rrectly
.
.
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
Richard Hi
p
p
Imp
r
ove
d
conflict-targ
e
t matc
h
ing
l
o
g
ic
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
Richard H
i
pp
Ba
c
k
o
ff of
the e
x
tended upsert syntax
t
hat
a
llows
.
.
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
Richard Hipp
Begin addi
n
g upsert logic
.
Th
i
s is
an
i
nc
r
e
m
ental
.
.
.
commit
|
commitdiff
|
tree
2018-04-12
D
.
Richa
r
d
Hipp
Break out the ups
e
rt cod
e
into a separate
s
o
u
rce file
.
commit
|
commitdiff
|
tree
2018-04-12
D
.
Ric
h
a
r
d
H
ipp
Fi
x
another typo in a comment
.
commit
|
commitdiff
|
tree
2018-04-12
D
.
Richard Hipp
Simple
comm
e
nt
clarification
.
N
o code or logic c
h
ang
e
s
.
commit
|
commitdiff
|
tree
2018-04-12
D
.
Richard Hipp
Extend the upsert syntax to a
l
low
a
WHERE clause
o
n
.
.
.
commit
|
commitdiff
|
tree
2018-04-12
D
.
Richa
r
d Hipp
U
pda
t
e the upsert parsing
so that it ac
c
epts confl
i
ct
.
.
.
commit
|
commitdiff
|
tree
2018-04-12
D
.
Ri
c
har
d
Hipp
A
d
d the Upsert object for holding
u
psert c
l
aus
e
inform
a
tion
.
commit
|
commitdiff
|
tree
2018-04-12
D
.
Richard Hipp
Merg
e
changes fr
o
m t
r
unk
.
commit
|
commitdiff
|
tree
2018-04-11
D
.
Richard Hipp
Help
the
p
a
rser run fast
e
r b
y
avoiding the "explain
.
.
.
commit
|
commitdiff
|
tree
2018-04-11
D
.
Rich
a
rd H
i
p
p
Prohi
b
it
bou
n
d parameter
s
in the argumen
t
s to ta
b
l
e
.
.
.
commit
|
commitdiff
|
tree
2018-04-10
D
.
Ric
h
ard Hipp
Version 3
.
2
3
.
1
commit
|
commitdiff
|
tree
2018-04-10
D
.
Richard Hipp
Increase the
version number
to 3
.
2
3
.
1
.
commit
|
commitdiff
|
tree
2018-04-10
D
.
Rich
a
rd Hipp
Remove an unnecessary SQLITE_UNTE
S
TA
B
LE co
m
pile-t
i
m
e
.
.
.
commit
|
commitdiff
|
tree
2018-04-10
D
.
R
ichard
Hi
p
p
U
p
date the
t
op-leve
l
R
E
ADME
.
md file to point
t
o the
.
.
.
commit
|
commitdiff
|
tree
2018-04-10
D
.
Ric
h
ard H
i
pp
Up
d
ate the top-
l
evel README
.
md file to point to t
h
e
.
.
.
commit
|
commitdiff
|
tree
2018-04-09
D
.
Ric
h
ard
Hi
p
p
Minor changes to th
e
input gramm
a
r
resultin
g
in
a
fa
s
ter
.
.
.
commit
|
commitdiff
|
tree
2018-04-09
D
.
Richard Hi
p
p
Enhance the qu
e
ry
planner so that it de
t
ect
s
whe
n
the
.
.
.
commit
|
commitdiff
|
tree
2018-04-09
D
.
R
i
chard Hipp
I
m
provem
e
nts
to "
.
wheret
r
a
c
e" output
.
commit
|
commitdiff
|
tree
2018-04-09
D
.
Richard H
i
pp
F
i
x a (ha
r
mless) signed integer
overflow warning
.
commit
|
commitdiff
|
tree
2018-04-07
D
.
Ric
h
ard
Hipp
More comp
l
ete
p
arsing of UPSERT, i
n
c
l
uding UPSERT
within
.
.
.
commit
|
commitdiff
|
tree
2018-04-06
D
.
Richard Hipp
Demonstration of ho
w
t
h
e p
a
rs
e
r ca
n
be augmented t
o
.
.
.
commit
|
commitdiff
|
tree
2018-04-06
D
.
Rich
a
rd Hipp
Enhance LEMON to s
h
ow precendence o
f
s
ymbols
and
a
ll
.
.
.
commit
|
commitdiff
|
tree
2018-04-05
D
.
R
i
c
har
d
Hipp
Fix the sqlite3WhereTrace mechanism so that
i
t
compile
s
.
.
.
commit
|
commitdiff
|
tree
2018-04-03
D
.
Richard Hip
p
F
i
x
an error message
i
n
s
peedt
e
st1
.
c and ma
k
e t
h
e
.
.
.
commit
|
commitdiff
|
tree
2018-04-03
D
.
Richard
H
ipp
Fix the genera
t
e_s
e
ries
v
irtual table so tha
t
it c
o
rrectly
.
.
.
commit
|
commitdiff
|
tree
2018-04-03
D
.
R
i
cha
r
d Hipp
Ch
a
nge th
e
LEFT
JOIN strength reduction optimization
.
.
.
commit
|
commitdiff
|
tree
2018-04-02
D
.
Richa
r
d Hip
p
Version 3
.
23
.
0
commit
|
commitdiff
|
tree
2018-04-02
D
.
Richar
d
Hipp
B
e
tte
r
solution to the LIKE problem from the pre
v
ious
.
.
.
commit
|
commitdiff
|
tree
2018-03-31
D
.
Richard Hip
p
Fix
a logic e
r
ror discovered
b
y OS
S
Fuzz that
can cause
.
.
.
commit
|
commitdiff
|
tree
2018-03-30
D
.
Richard H
i
pp
Fix a bug in
t
he
sp
e
llfix exte
n
sion causi
n
g it to
c
ompute
.
.
.
commit
|
commitdiff
|
tree
2018-03-30
D
.
Richard
Hi
p
p
Fix an off-by-o
n
e
e
rror in the dist3 algorithm of the
.
.
.
commit
|
commitdiff
|
tree
2018-03-29
D
.
Richard Hi
p
p
Modify the sql
i
te3OsFileCo
n
tro
l
() interfa
c
e to detec
t
.
.
.
commit
|
commitdiff
|
tree
2018-03-28
D
.
Richa
r
d
Hipp
Fix
a
h
armless compiler warning
i
n
t
h
e
kvtest
.
ex
e
p
r
o
gr
a
m
.
commit
|
commitdiff
|
tree
2018-03-28
D
.
Richard Hipp
Fi
x
a
harmless
com
p
iler
warning
.
commit
|
commitdiff
|
tree
2018-03-28
D
.
Richard
H
i
p
p
Remove tab c
h
aracters
.
No l
o
gic
a
l
c
hanges to
c
ode
.
commit
|
commitdiff
|
tree
2018-03-28
D
.
Richard
Hipp
Mino
r
c
o
mment ch
a
nges
.
commit
|
commitdiff
|
tree
2018-03-27
D
.
Richard Hipp
Fix a typo in t
h
e RE
A
DME file for ICU
.
No code changes
.
commit
|
commitdiff
|
tree
2018-03-27
D
.
Rich
a
rd
H
i
p
p
The push-down
o
ptimiz
a
tion was being too aggressive
.
.
.
commit
|
commitdiff
|
tree
2018-03-27
D
.
Richard Hipp
Provi
d
e the ability for t
h
e VFS t
o
do a bloc
k
ing wait
.
.
.
commit
|
commitdiff
|
tree
2018-03-26
D
.
Richa
r
d Hipp
Do not inject OOM e
r
ro
r
s on SQ
L
ITE_FCNTL_LOCK_TIMEOUT
.
.
.
commit
|
commitdiff
|
tree
2018-03-26
D
.
Richard Hipp
Avoid a race condition that might
c
ause a bus
y
_t
i
m
eout
.
.
.
commit
|
commitdiff
|
tree
2018-03-26
D
.
Richard Hipp
Add infra
s
truct
u
r
e to s
u
p
p
ort for
using F_SETLKW with
.
.
.
commit
|
commitdiff
|
tree
2018-03-26
D
.
Ric
h
ard Hipp
Refactor s
o
m
e i
n
ternal o
b
ject eleme
n
t
names us
e
d
by
.
.
.
commit
|
commitdiff
|
tree
2018-03-24
D
.
Richard Hipp
Add
t
e
stcase() macros
and
improve comments in t
h
e LEFT
.
.
.
commit
|
commitdiff
|
tree
2018-03-24
D
.
Richard Hipp
Ye
t
anoth
e
r fau
l
t in
t
he sq
l
ite3ExprIm
p
lies
N
otNull
.
.
.
commit
|
commitdiff
|
tree
2018-03-24
D
.
Richard H
i
pp
Bug fix in
t
he LE
F
T J
O
IN st
r
ength reduction optimizatio
n
o
f
commit
|
commitdiff
|
tree
2018-03-24
D
.
Richard Hipp
P
r
epend linkage macros to the sqlite3rebaser interfaces
.
commit
|
commitdiff
|
tree
2018-03-23
D
.
Ri
c
ha
r
d Hip
p
Fix th
e
-rea
d
only option on the CLI so that it a
c
tually
.
.
.
commit
|
commitdiff
|
tree
2018-03-23
D
.
Richard Hip
p
Fix typo in a
commen
t
used fo
r
d
o
cumentation
.
No changes
.
.
.
commit
|
commitdiff
|
tree
2018-03-23
D
.
Rich
a
rd Hipp
Fix an e
r
ror i
n
t
he
CLI i
n
t
he previo
u
s
([0249d9aecf
6
9948
.
.
.
commit
|
commitdiff
|
tree
2018-03-23
D
.
Ric
h
a
r
d
Hipp
Fix
t
he AN
A
LYZE com
m
a
nd so that it will process tables
.
.
.
commit
|
commitdiff
|
tree
2018-03-22
D
.
Rich
a
rd Hipp
A
dd the
l
eft join strength
r
educt
i
on op
t
imizat
i
on
.
.
.
.
commit
|
commitdiff
|
tree
2018-03-22
D
.
Richard Hipp
A
dd
t
he
-
-
valid-sql opti
o
n to the o
p
tfuzz te
s
t
p
rogram
.
commit
|
commitdiff
|
tree
2018-03-21
D
.
Richard Hip
p
Get the o
p
tfuzz program working
.
commit
|
commitdiff
|
tree
2018-03-21
D
.
Richar
d
Hip
p
Ad
d
t
h
e
o
ptfuzz
.
c program for v
e
ri
f
ying the que
r
y planner
.
.
.
commit
|
commitdiff
|
tree
2018-03-21
D
.
Richard Hipp
Relax LE
F
T-JOIN restrictions on th
e
p
ush
-
d
own o
p
timization
.
commit
|
commitdiff
|
tree
2018-03-20
D
.
R
ichard Hipp
Do a more thorough job of cl
e
aning traces
of
t
he s
t
rength
.
.
.
commit
|
commitdiff
|
tree
2018-03-20
D
.
Ric
h
ard
H
ipp
If
t
erms of the
WHERE clause require tha
t
the right
.
.
.
commit
|
commitdiff
|
tree
next