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
Minor simplification of the cursor allocation logic for update.
2018-04-20
D
.
Richard Hipp
Minor
s
implifi
c
ation of the cursor allocation l
o
g
i
c
.
.
.
commit
|
commitdiff
|
tree
2018-04-19
D
.
Richard
H
i
pp
Fix the h
a
n
dling of "PRAGMA count_cha
n
ges=ON" with
.
.
.
commit
|
commitdiff
|
tree
2018-04-19
D
.
Richard
Hipp
Minor simplification to the upse
r
t logic
.
commit
|
commitdiff
|
tree
2018-04-19
D
.
Richard Hipp
Add t
h
e --upsert option to the wordcount
t
est program
.
commit
|
commitdiff
|
tree
2018-04-19
D
.
R
ichard Hipp
Add t
h
e
e
xt/misc/temp
l
at
e
vtab
.
c
temp
l
ate for v
i
rtual
.
.
.
commit
|
commitdiff
|
tree
2018-04-19
D
.
R
ichard Hipp
Fix
a
problem in the new upsert
imple
m
e
ntion, discovered
.
.
.
commit
|
commitdiff
|
tree
2018-04-19
D
.
Richard Hipp
F
ix the
t
a
ble name aliasing on INSERT so that it o
c
c
urs
.
.
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richard Hip
p
A
void a NULL-pointer deref
f
oll
o
wing
O
OM
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
R
i
c
ha
r
d Hi
p
p
Fix a te
s
t case inside distinct
.
test
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Rich
a
rd Hipp
Im
p
rov
e
d matching o
f
C
O
LLATE c
l
auses within
t
he O
N
.
.
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
R
ichard Hi
p
p
Fix a
p
roblem in t
h
e sqlite3Ex
p
rCompare() function
.
.
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richar
d
Hipp
Add supp
o
rt for PostgreS
Q
L UPSERT syntax
an
d
functio
n
ality
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
R
i
chard Hipp
Fix the
b
uild f
o
r S
Q
LITE_
O
MI
T
_
UPSERT
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richard Hipp
Add
t
he --sorterre
f
N o
p
tio
n
t
o the CLI
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richard Hipp
Omit s
o
me c
o
de n
o
t use
d
without SQLITE_EN
A
BLE
_
SORTER_R
E
FEREN
.
.
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richard
H
ipp
Re
m
ove an
u
nused loca
l
varia
b
le
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Ric
h
ard Hipp
Enhance ALTER TABL
E
ADD COLUMN to support "
D
EFAULT
.
.
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richard Hipp
A
dd checks to the C
L
I
t
h
at issue a warning if SQLite
.
.
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richard Hipp
Add new testcase() ma
c
ros and fix
a b
u
g that
was re
v
ealed
.
.
.
commit
|
commitdiff
|
tree
2018-04-17
D
.
Richard
Hipp
Remove unreach
a
ble br
a
nches
.
100%
MC/
D
C in TH3 now
.
commit
|
commitdiff
|
tree
2018-04-17
D
.
Richard H
i
pp
A
dded
a
comment on
the assert() added to the previ
o
u
s
.
.
.
commit
|
commitdiff
|
tree
2018-04-17
D
.
Ri
c
h
ar
d
Hi
p
p
Fixes t
o
t
h
e l
o
gic for con
s
tr
a
int check re
o
r
d
ering
.
.
.
commit
|
commitdiff
|
tree
2018-04-17
D
.
Richard H
i
pp
During PRAGM
A
vdbe_a
d
doptrac
e
=
O
N, show ca
l
ls to sq
l
i
te3VdbeR
.
.
.
commit
|
commitdiff
|
tree
2018-04-17
D
.
Richard Hipp
TK
_
REG
I
STE
R
expr
e
ss
i
ons nod
e
s are pro
b
ably not constant
.
.
.
commit
|
commitdiff
|
tree
2018-04-17
D
.
Richard Hipp
Simplification to
t
h
e upsert lo
g
ic
.
commit
|
commitdiff
|
tree
2018-04-17
D
.
Richard Hipp
New
test cas
e
s fo
r
upsert
.
commit
|
commitdiff
|
tree
2018-04-16
D
.
R
ichard Hipp
Merge t
h
e Lemon enhancement from tr
u
nk
,
resulting
i
n
.
.
.
commit
|
commitdiff
|
tree
2018-04-16
D
.
R
i
c
h
ard Hipp
Lemon e
n
hancements: (1) Do not allocate spa
c
e for
.
.
.
commit
|
commitdiff
|
tree
2018-04-16
D
.
Richard Hipp
Remove the
M
y
S
Q
L upsert s
y
ntax
.
As an o
p
t
ion
a
l
al
i
a
s
.
.
.
commit
|
commitdiff
|
tree
2018-04-16
D
.
Richard Hipp
Add support for the "
e
xclu
d
ed
.
*" names in the UPD
A
T
E
.
.
.
commit
|
commitdiff
|
tree
2018-04-16
D
.
R
i
c
h
ard
H
ipp
Merge changes from trunk
.
commit
|
commitdiff
|
tree
2018-04-16
D
.
Rich
a
rd Hipp
I
ncreas
e
the version number to 3
.
24
.
0
commit
|
commitdiff
|
tree
2018-04-16
D
.
Ric
h
ard Hipp
Reduce the
size o
f
t
he Na
m
eCo
n
t
e
x
t
object
by gro
u
ping
.
.
.
commit
|
commitdiff
|
tree
2018-04-14
D
.
Richar
d
H
i
pp
G
e
t
upsert wor
k
ing
on
WITHOUT ROWID tab
l
e
s
.
commit
|
commitdiff
|
tree
2018-04-14
D
.
Ri
c
har
d
Hi
p
p
M
a
ke sure constraint checks occur in the
corre
c
t
or
d
er
.
.
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
Richard
Hipp
First c
u
t at logic to perform DO U
P
DAT
E
for ro
w
id
tables
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
Rich
a
rd
Hipp
A
d
d
i
nfrastructur
e
for doing
an U
P
DATE a
s
part
o
f a
n
.
.
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
R
i
c
hard H
i
pp
Merge
t
he
preupda
t
e hook change
from trunk
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
Richard H
i
p
p
Remove an
always-true
b
ran
c
h from th
e
preupdate hook
.
.
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
Richard H
i
pp
Get the ON CONFLI
C
T
DO NOTHING form of upsert w
o
r
king
.
.
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
R
ichard H
i
pp
G
et the
conflict
-
ta
r
get cl
a
use parsing working c
o
r
r
e
ctly
.
.
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
Richard Hipp
Improved confli
c
t
-t
a
r
g
e
t
m
a
tc
h
i
n
g logic
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
Richa
r
d Hipp
Back of
f
of the ex
t
ended upsert syntax that all
o
ws
.
.
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
Richa
r
d
Hipp
Begin adding
upsert
logic
.
T
h
is is an
i
ncrem
e
ntal
.
.
.
commit
|
commitdiff
|
tree
2018-04-12
D
.
Richar
d
Hipp
Break ou
t
t
he upse
r
t
co
d
e in
t
o a s
e
parate source fil
e
.
commit
|
commitdiff
|
tree
2018-04-12
D
.
Richard H
i
pp
Fix anothe
r
typo
in a comment
.
commit
|
commitdiff
|
tree
2018-04-12
D
.
Richard Hi
p
p
S
im
p
l
e
comment clarif
i
catio
n
.
No code
o
r
lo
g
ic changes
.
commit
|
commitdiff
|
tree
2018-04-12
D
.
Richar
d
Hip
p
E
x
te
n
d the upsert syn
t
ax to allow a WHERE
c
lause on
.
.
.
commit
|
commitdiff
|
tree
2018-04-12
D
.
Richard Hipp
U
pd
a
te
the
ups
e
rt parsing so that it a
c
c
epts c
o
nflic
t
.
.
.
commit
|
commitdiff
|
tree
2018-04-12
D
.
R
i
chard Hipp
Add t
h
e Upsert obj
e
ct for ho
l
ding upsert cla
u
se informatio
n
.
commit
|
commitdiff
|
tree
2018-04-12
D
.
Richard Hipp
M
er
g
e changes from trunk
.
commit
|
commitdiff
|
tree
2018-04-11
D
.
Ri
c
hard H
i
p
p
Hel
p
th
e
p
a
rser
r
un faster
by avoiding the "explain
.
.
.
commit
|
commitdiff
|
tree
2018-04-11
D
.
R
icha
r
d
Hipp
P
r
o
h
ibit bound p
a
rameters in the arg
u
men
t
s
to t
a
ble
.
.
.
commit
|
commitdiff
|
tree
2018-04-10
D
.
Richard Hipp
Version 3
.
2
3
.
1
commit
|
commitdiff
|
tree
2018-04-10
D
.
R
icha
r
d Hipp
I
n
crease the version n
u
mber to 3
.
23
.
1
.
commit
|
commitdiff
|
tree
2018-04-10
D
.
Richard Hipp
Remove an u
n
n
e
c
essary SQLIT
E
_UNT
E
STABL
E
c
ompile-time
.
.
.
commit
|
commitdiff
|
tree
2018-04-10
D
.
Richa
r
d Hipp
U
p
d
ate
the
t
op-le
v
el READ
M
E
.
md file to point to th
e
.
.
.
commit
|
commitdiff
|
tree
2018-04-10
D
.
Richard Hipp
Update the top-l
e
v
e
l R
E
ADME
.
md
f
ile to poi
n
t to
the
.
.
.
commit
|
commitdiff
|
tree
2018-04-09
D
.
Richard Hipp
Minor ch
a
n
ges
to
t
he input
grammar resulting in a faste
r
.
.
.
commit
|
commitdiff
|
tree
2018-04-09
D
.
Richard
Hipp
Enhance t
h
e
query planner so th
a
t it detects when the
.
.
.
commit
|
commitdiff
|
tree
2018-04-09
D
.
Ric
h
ard
H
i
pp
Impr
o
vements to "
.
where
t
race" output
.
commit
|
commitdiff
|
tree
2018-04-09
D
.
Richar
d
Hipp
Fix a (harmless) signed integer ov
e
rflo
w
warning
.
commit
|
commitdiff
|
tree
2018-04-07
D
.
Richard Hip
p
M
o
r
e c
o
mp
l
ete parsing of U
P
SERT,
i
ncl
u
ding
UPSERT within
.
.
.
commit
|
commitdiff
|
tree
2018-04-06
D
.
R
i
c
h
ard Hipp
Demons
t
rati
o
n of
h
ow the parser can be augmented
t
o
.
.
.
commit
|
commitdiff
|
tree
2018-04-06
D
.
Richard Hipp
Enhan
c
e
L
EM
O
N to show precen
d
en
c
e
o
f s
y
m
b
o
l
s a
n
d all
.
.
.
commit
|
commitdiff
|
tree
2018-04-05
D
.
Richard
H
ipp
Fix the sqli
t
e3W
h
ereTrac
e
mechanism so that
i
t
compiles
.
.
.
commit
|
commitdiff
|
tree
2018-04-03
D
.
Richard
Hipp
F
i
x an e
r
ror messa
g
e in speedte
s
t1
.
c
a
nd
make the
.
.
.
commit
|
commitdiff
|
tree
2018-04-03
D
.
Ric
h
ard Hipp
Fix
the ge
n
era
t
e_series virtual table
so that it c
o
r
r
e
ctl
y
.
.
.
commit
|
commitdiff
|
tree
2018-04-03
D
.
Richard Hipp
Change the LEFT JOIN stre
n
gth re
d
uction optimi
z
ation
.
.
.
commit
|
commitdiff
|
tree
2018-04-02
D
.
Richard Hipp
Versio
n
3
.
2
3
.
0
commit
|
commitdiff
|
tree
2018-04-02
D
.
R
ic
h
a
r
d
H
i
pp
Better
s
olu
t
ion to the LIK
E
proble
m
from the previous
.
.
.
commit
|
commitdiff
|
tree
2018-03-31
D
.
Richard Hi
p
p
F
i
x a logic error discovere
d
by OSSFuzz that can
cause
.
.
.
commit
|
commitdiff
|
tree
2018-03-30
D
.
Ric
h
ard Hipp
F
i
x a bug in th
e
s
pellfix extension causing it to compute
.
.
.
commit
|
commitdiff
|
tree
2018-03-30
D
.
Ri
c
h
ard Hi
p
p
Fix an off-by-one erro
r
i
n the d
i
st3
a
lgor
i
thm of
the
.
.
.
commit
|
commitdiff
|
tree
2018-03-29
D
.
Richard Hipp
Modify t
h
e
s
q
l
ite3OsFileControl() inter
f
ace to detect
.
.
.
commit
|
commitdiff
|
tree
2018-03-28
D
.
R
i
chard
H
ipp
F
i
x a harmless co
m
pi
l
er war
n
ing
i
n
the kvtest
.
exe program
.
commit
|
commitdiff
|
tree
2018-03-28
D
.
R
ich
a
rd Hipp
Fix a h
a
rml
e
ss compiler war
n
ing
.
commit
|
commitdiff
|
tree
2018-03-28
D
.
Richard Hipp
Remove t
a
b
characters
.
No logical change
s
to code
.
commit
|
commitdiff
|
tree
2018-03-28
D
.
Richard Hipp
M
inor com
m
e
n
t change
s
.
commit
|
commitdiff
|
tree
2018-03-27
D
.
Richard Hipp
Fix a typo in
the READM
E
f
ile for ICU
.
No
c
ode change
s
.
commit
|
commitdiff
|
tree
2018-03-27
D
.
R
ichard Hipp
The pu
s
h-down optimization was bein
g
too aggressi
v
e
.
.
.
commit
|
commitdiff
|
tree
2018-03-27
D
.
Richar
d
Hipp
Provide
t
he a
b
ili
t
y for the
V
FS to
d
o a blocking wait
.
.
.
commit
|
commitdiff
|
tree
2018-03-26
D
.
Richard Hipp
Do not inje
c
t OO
M
errors on SQLITE_FCNTL_
L
OCK_TI
M
EOUT
.
.
.
commit
|
commitdiff
|
tree
2018-03-26
D
.
Richard Hipp
Avoid a race condi
t
ion that might cau
s
e a b
u
s
y
_timeout
.
.
.
commit
|
commitdiff
|
tree
2018-03-26
D
.
R
ichar
d
H
i
p
p
Add infrastru
c
ture t
o
sup
p
or
t
for us
i
ng F_SETLKW with
.
.
.
commit
|
commitdiff
|
tree
2018-03-26
D
.
Richard Hipp
Refactor some interna
l
objec
t
element names used by
.
.
.
commit
|
commitdiff
|
tree
2018-03-24
D
.
Ric
h
ar
d
Hipp
Add tes
t
case() m
a
cros and improve
c
ommen
t
s in the LEFT
.
.
.
commit
|
commitdiff
|
tree
2018-03-24
D
.
Richard Hi
p
p
Yet
a
nother fa
u
lt
i
n the sq
l
ite3E
x
prImpli
e
sNotNull
.
.
.
commit
|
commitdiff
|
tree
2018-03-24
D
.
Richard Hipp
Bug fix in the LEFT J
O
IN strength reduction optimization of
commit
|
commitdiff
|
tree
2018-03-24
D
.
Richard Hipp
Prep
e
nd linkage macro
s
to the
s
qli
t
e
3rebaser int
e
rfaces
.
commit
|
commitdiff
|
tree
2018-03-23
D
.
Ric
h
a
r
d Hipp
Fix
t
he -rea
d
only optio
n
on the CLI so that
i
t actually
.
.
.
commit
|
commitdiff
|
tree
2018-03-23
D
.
Richard Hipp
Fix typo in a comme
n
t
u
sed for d
o
cumentat
i
on
.
No changes
.
.
.
commit
|
commitdiff
|
tree
2018-03-23
D
.
Richard Hip
p
Fix an error in
th
e
CLI in
t
h
e
p
revious (
[
0249d9aecf69948
.
.
.
commit
|
commitdiff
|
tree
2018-03-23
D
.
Richard Hipp
Fix the ANALY
Z
E command so that it will process tables
.
.
.
commit
|
commitdiff
|
tree
2018-03-22
D
.
Ri
c
hard Hipp
Add the left join str
e
n
gt
h
re
d
uction optimization
.
.
.
.
commit
|
commitdiff
|
tree
2018-03-22
D
.
Richard
Hipp
Ad
d
th
e
--valid-sql opti
o
n t
o
the op
t
fuzz test program
.
commit
|
commitdiff
|
tree
2018-03-21
D
.
R
ichard Hipp
Get t
h
e
optf
u
z
z
p
r
ogram working
.
commit
|
commitdiff
|
tree
2018-03-21
D
.
Richar
d
H
i
p
p
Ad
d
th
e
optfuzz
.
c program
f
or verifying
t
he query planner
.
.
.
commit
|
commitdiff
|
tree
2018-03-21
D
.
R
i
char
d
Hipp
R
e
l
ax LE
F
T
-JOIN restrictions on the p
u
s
h
-
dow
n
op
t
imization
.
commit
|
commitdiff
|
tree
2018-03-20
D
.
Ric
h
ard Hipp
D
o
a more thorou
g
h job of cleaning traces of the strength
.
.
.
commit
|
commitdiff
|
tree
next