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
Add the ext/misc/templatevtab.c template for virtual tables. This is a
2018-04-19
D
.
Richard Hipp
Add the
ext/misc/templat
e
vtab
.
c
templa
t
e for
virtual
.
.
.
commit
|
commitdiff
|
tree
2018-04-19
D
.
Richard Hipp
Fi
x
a pro
b
l
e
m
in the new upsert
impl
e
ment
i
on,
discovered
.
.
.
commit
|
commitdiff
|
tree
2018-04-19
D
.
Richard Hipp
Fix the table name
a
lias
i
ng on INSERT so
t
hat
it oc
c
urs
.
.
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
R
i
c
har
d
Hipp
Avoid a NULL-pointe
r
deref f
o
l
l
owing
O
OM
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richa
r
d
H
ipp
Fix a test case
insid
e
distinc
t
.
test
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
R
i
chard Hipp
Improved
m
at
c
hing of COLL
A
TE cl
a
u
ses
w
i
thin
the ON
.
.
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richard Hipp
Fi
x
a pr
o
blem in the sqlite3
E
x
p
rCompare() function
.
.
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Ri
c
ha
r
d Hipp
Add support for PostgreS
Q
L UPSER
T
synta
x
a
n
d fun
c
t
i
onal
i
t
y
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
R
ichard Hipp
Fi
x
the build for SQLITE_OM
I
T
_
UPSERT
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richa
r
d
H
i
pp
Add the -
-
s
o
rterref N option
to the CLI
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richard
H
i
p
p
O
mit some code not use
d
without S
Q
LITE_ENABL
E
_SORTER_
R
EFEREN
.
.
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
R
i
c
hard Hipp
Remove an unu
s
ed local vari
a
ble
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
R
i
chard Hipp
Enhance ALTER TABLE ADD C
O
LUMN
to support "
D
EFAULT
.
.
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richard Hi
p
p
Add checks to the CLI that iss
u
e a wa
r
nin
g
if SQLite
.
.
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richar
d
Hip
p
Add ne
w
t
estcas
e
() mac
r
os and fix a bug tha
t
wa
s
r
e
v
e
a
led
.
.
.
commit
|
commitdiff
|
tree
2018-04-17
D
.
Richard Hip
p
R
e
m
o
ve
u
n
r
eachab
l
e branches
.
100% MC/DC in
T
H3 now
.
commit
|
commitdiff
|
tree
2018-04-17
D
.
Richard
Hipp
Ad
d
e
d
a comment
on th
e
assert() add
e
d to t
h
e p
r
evious
.
.
.
commit
|
commitdiff
|
tree
2018-04-17
D
.
Ric
h
a
rd Hipp
Fixes to the logic for constraint check
r
eordering
.
.
.
commit
|
commitdiff
|
tree
2018-04-17
D
.
Richard Hipp
Dur
i
ng PRAGM
A
v
d
be_addoptrace=ON, sho
w
c
a
l
l
s to sqlite3VdbeR
.
.
.
commit
|
commitdiff
|
tree
2018-04-17
D
.
Richard
Hipp
TK_RE
G
I
S
TER
expressio
n
s
no
d
es a
r
e probably
n
ot constant
.
.
.
commit
|
commitdiff
|
tree
2018-04-17
D
.
Richard Hipp
Simplification
to t
h
e upse
r
t
l
ogic
.
commit
|
commitdiff
|
tree
2018-04-17
D
.
Richard
Hipp
N
e
w test cases for upsert
.
commit
|
commitdiff
|
tree
2018-04-16
D
.
Richard Hipp
Mer
g
e
t
he
L
emo
n
enhance
m
ent from trunk, res
u
l
ting in
.
.
.
commit
|
commitdiff
|
tree
2018-04-16
D
.
R
i
ch
a
rd Hip
p
Lemon
e
nhancements: (1)
D
o no
t
a
lloca
t
e space for
.
.
.
commit
|
commitdiff
|
tree
2018-04-16
D
.
R
i
chard Hipp
Remove the M
y
S
Q
L
u
psert syntax
.
As an optional alias
.
.
.
commit
|
commitdiff
|
tree
2018-04-16
D
.
Richard Hipp
Ad
d
s
upport for the "excluded
.
*" names
i
n the UPD
A
TE
.
.
.
commit
|
commitdiff
|
tree
2018-04-16
D
.
Richard Hipp
Merge cha
n
ges fr
o
m trunk
.
commit
|
commitdiff
|
tree
2018-04-16
D
.
Rich
a
rd
Hipp
Increase the version number to 3
.
24
.
0
commit
|
commitdiff
|
tree
2018-04-16
D
.
Richard Hipp
Reduce t
h
e size of the NameCo
n
text
object by
g
r
o
u
ping
.
.
.
commit
|
commitdiff
|
tree
2018-04-14
D
.
Richard H
i
pp
Get ups
e
rt work
i
ng on
WITH
O
UT
R
OWID tab
l
e
s
.
commit
|
commitdiff
|
tree
2018-04-14
D
.
Ri
c
h
ard Hipp
M
ake
sure constraint
checks oc
c
ur in t
h
e correct
o
rder
.
.
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
Ri
c
hard Hipp
First cut at logic to
p
erfo
r
m DO UPD
A
TE
for
rowid tables
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
Richard Hipp
Ad
d
i
nfrastruc
t
ur
e
for doing an U
P
DAT
E
as
par
t
of an
.
.
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
R
ichar
d
Hipp
Merge the preupdate h
o
ok change
f
r
o
m t
r
unk
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
Richard Hipp
Remove an alway
s
-true
b
r
a
n
c
h
from the preupdat
e
h
ook
.
.
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
Richard Hipp
Get the O
N
C
O
NFLICT DO NOTHI
N
G form of upsert
w
o
rking
.
.
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
R
i
cha
r
d
H
i
pp
Get the conflict-target clause
p
a
rsing working c
o
rrectly
.
.
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
Richard
H
ipp
I
m
p
r
o
ved conflict
-
tar
g
e
t matching logic
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
Richard Hipp
Back off of th
e
extende
d
u
p
sert syntax th
a
t all
o
ws
.
.
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
Ri
c
hard H
i
pp
Begin addin
g
upsert log
i
c
.
This is an incre
m
ental
.
.
.
commit
|
commitdiff
|
tree
2018-04-12
D
.
Rich
a
rd Hipp
Break out th
e
ups
e
rt cod
e
into a separa
t
e sou
r
c
e file
.
commit
|
commitdiff
|
tree
2018-04-12
D
.
Ric
h
ard Hipp
Fix anot
h
er
t
y
p
o in a comment
.
commit
|
commitdiff
|
tree
2018-04-12
D
.
Richard Hip
p
Simp
l
e
c
omment clarific
a
t
i
on
.
No co
d
e or l
o
gic c
h
anges
.
commit
|
commitdiff
|
tree
2018-04-12
D
.
Rich
a
rd H
i
pp
Ext
e
nd
t
h
e
u
p
sert syntax t
o
allow a WHERE clause
o
n
.
.
.
commit
|
commitdiff
|
tree
2018-04-12
D
.
Richard Hipp
Upd
a
te the ups
e
rt
p
arsing so
t
hat it ac
c
epts
c
onflict
.
.
.
commit
|
commitdiff
|
tree
2018-04-12
D
.
Richard Hipp
Add
t
he Upser
t
ob
j
e
ct for holdin
g
upse
r
t c
l
a
u
se
i
nfo
r
mati
o
n
.
commit
|
commitdiff
|
tree
2018-04-12
D
.
R
i
ch
a
rd
Hipp
Merge
c
h
anges
f
rom trunk
.
commit
|
commitdiff
|
tree
2018-04-11
D
.
R
i
ch
a
rd Hipp
Help th
e
parser run faste
r
by avoiding
the "
e
xplain
.
.
.
commit
|
commitdiff
|
tree
2018-04-11
D
.
Richard Hipp
P
roh
i
bit bo
u
nd param
e
t
e
r
s in the
a
rg
u
ments to ta
b
le
.
.
.
commit
|
commitdiff
|
tree
2018-04-10
D
.
Richar
d
H
ipp
Version 3
.
23
.
1
commit
|
commitdiff
|
tree
2018-04-10
D
.
Ri
c
hard Hip
p
Increase the version
n
u
m
b
er
t
o
3
.
23
.
1
.
commit
|
commitdiff
|
tree
2018-04-10
D
.
Richard
Hip
p
Remove an
u
n
necessa
r
y SQ
L
I
T
E_UNTESTAB
L
E compile-time
.
.
.
commit
|
commitdiff
|
tree
2018-04-10
D
.
Richard Hipp
Update t
h
e t
o
p-level README
.
md
f
ile to point to the
.
.
.
commit
|
commitdiff
|
tree
2018-04-10
D
.
Richar
d
H
ipp
Update the top-level README
.
md
f
ile
t
o p
o
int to t
h
e
.
.
.
commit
|
commitdiff
|
tree
2018-04-09
D
.
R
i
chard Hipp
Minor changes to
t
he input gra
m
mar resulti
n
g
i
n a fast
e
r
.
.
.
commit
|
commitdiff
|
tree
2018-04-09
D
.
R
ichard
H
i
p
p
Enhance
the
query planner so that it d
e
te
c
ts
when the
.
.
.
commit
|
commitdiff
|
tree
2018-04-09
D
.
Richard Hipp
Improve
m
ents
t
o
"
.
whe
r
etrace" output
.
commit
|
commitdiff
|
tree
2018-04-09
D
.
Ri
c
hard
H
ipp
Fix a (harmless) signed integer overflow warning
.
commit
|
commitdiff
|
tree
2018-04-07
D
.
Ric
h
ard Hipp
More co
m
p
l
ete parsi
n
g of UPSER
T
, including UPSERT within
.
.
.
commit
|
commitdiff
|
tree
2018-04-06
D
.
R
i
chard H
i
pp
Demonstrat
i
on o
f
how the parser can
b
e a
u
gm
e
nted to
.
.
.
commit
|
commitdiff
|
tree
2018-04-06
D
.
Richard Hipp
Enhance
LEMON t
o
show precendence of s
y
mbols
a
nd
a
ll
.
.
.
commit
|
commitdiff
|
tree
2018-04-05
D
.
Richard Hipp
Fix
t
he sqlite3
W
hereTrace mech
a
ni
s
m so that it c
o
mp
i
les
.
.
.
commit
|
commitdiff
|
tree
2018-04-03
D
.
Rich
a
rd Hi
p
p
Fix a
n
e
r
ro
r
messag
e
in
speedte
s
t1
.
c a
n
d make the
.
.
.
commit
|
commitdiff
|
tree
2018-04-03
D
.
R
ichard H
i
pp
F
ix
the ge
n
er
a
te_series virtua
l
t
abl
e
so t
h
at it corre
c
tly
.
.
.
commit
|
commitdiff
|
tree
2018-04-03
D
.
Richard Hipp
Change
t
he LEF
T
JO
I
N strength reduction opt
i
mization
.
.
.
commit
|
commitdiff
|
tree
2018-04-02
D
.
Rich
a
rd
H
ipp
Version 3
.
2
3
.
0
commit
|
commitdiff
|
tree
2018-04-02
D
.
R
i
c
hard Hipp
Better so
l
ution t
o
t
he LIKE
prob
l
em fro
m
the previou
s
.
.
.
commit
|
commitdiff
|
tree
2018-03-31
D
.
Richard Hipp
Fix a logi
c
er
r
or di
s
c
o
vered by OSS
F
uzz that can cause
.
.
.
commit
|
commitdiff
|
tree
2018-03-30
D
.
Richard Hipp
Fix a bug
i
n the spellfi
x
extensio
n
causing it to co
m
pute
.
.
.
commit
|
commitdiff
|
tree
2018-03-30
D
.
Richard Hipp
Fix an off-by-one err
o
r i
n
the di
s
t3 algorithm of the
.
.
.
commit
|
commitdiff
|
tree
2018-03-29
D
.
Richard Hipp
Modify
the sqlite
3
OsFileContro
l
()
i
nt
e
rface to d
e
tect
.
.
.
commit
|
commitdiff
|
tree
2018-03-28
D
.
Ric
h
ard Hi
p
p
F
i
x
a harm
l
es
s
compiler warning in the kvtest
.
exe pr
o
gram
.
commit
|
commitdiff
|
tree
2018-03-28
D
.
Richard Hipp
Fi
x
a h
a
rmless
c
omp
i
ler warning
.
commit
|
commitdiff
|
tree
2018-03-28
D
.
Richard
Hipp
Remo
v
e tab cha
r
ac
t
ers
.
No logical changes to code
.
commit
|
commitdiff
|
tree
2018-03-28
D
.
Rich
a
r
d
Hipp
Minor comment ch
a
nges
.
commit
|
commitdiff
|
tree
2018-03-27
D
.
Richa
r
d Hipp
Fix a typo in
the READ
M
E file
for
ICU
.
No code changes
.
commit
|
commitdiff
|
tree
2018-03-27
D
.
Richa
r
d
Hipp
The pus
h
-down
optimi
z
atio
n
was
b
eing too aggressive
.
.
.
commit
|
commitdiff
|
tree
2018-03-27
D
.
Richard
Hip
p
Provi
d
e the
a
bility for the V
F
S to do a bl
o
c
k
ing wait
.
.
.
commit
|
commitdiff
|
tree
2018-03-26
D
.
Ri
c
h
a
rd Hipp
Do not inject
O
OM errors o
n
SQL
I
TE_FCNTL_LOCK_TIMEOUT
.
.
.
commit
|
commitdiff
|
tree
2018-03-26
D
.
Richard Hipp
Av
o
i
d
a race condition that might cause a busy_timeout
.
.
.
commit
|
commitdiff
|
tree
2018-03-26
D
.
Richard Hipp
A
dd infras
t
ructure
t
o support for
using F_
S
ETLKW with
.
.
.
commit
|
commitdiff
|
tree
2018-03-26
D
.
Richard Hipp
R
e
factor so
m
e in
t
e
r
nal object element names used by
.
.
.
commit
|
commitdiff
|
tree
2018-03-24
D
.
Ric
h
ard Hipp
Add te
s
tcase()
macros and
i
mp
r
o
v
e
comments in the LEFT
.
.
.
commit
|
commitdiff
|
tree
2018-03-24
D
.
Ri
c
har
d
H
i
pp
Yet anot
h
er fau
l
t in the sqlite3ExprI
m
pl
i
esNotNul
l
.
.
.
commit
|
commitdiff
|
tree
2018-03-24
D
.
Richard H
i
p
p
Bug f
i
x in the LEFT
J
OIN strength
reductio
n
optimization of
commit
|
commitdiff
|
tree
2018-03-24
D
.
Richard Hipp
Prepend l
i
nkage
m
a
cros to the sqlite3re
b
aser interfaces
.
commit
|
commitdiff
|
tree
2018-03-23
D
.
Richa
r
d Hipp
Fix
t
h
e -rea
d
only
o
pt
i
on on the CLI so tha
t
it actually
.
.
.
commit
|
commitdiff
|
tree
2018-03-23
D
.
Richa
r
d Hipp
Fi
x
typo
in a
comment use
d
for
d
o
cumentation
.
No change
s
.
.
.
commit
|
commitdiff
|
tree
2018-03-23
D
.
Richard
Hipp
Fix an er
r
or
i
n
t
h
e CLI
i
n
the previous
(
[0249d9aecf69948
.
.
.
commit
|
commitdiff
|
tree
2018-03-23
D
.
Rich
a
rd Hi
p
p
Fix the ANALYZE
c
omm
a
nd
s
o that it will proc
e
ss
tables
.
.
.
commit
|
commitdiff
|
tree
2018-03-22
D
.
Richard H
i
pp
Add the lef
t
join s
t
rength red
u
ction optimiz
a
t
io
n
.
.
.
.
commit
|
commitdiff
|
tree
2018-03-22
D
.
Richard
H
i
pp
Add the --valid-sql option to
the optf
u
zz te
s
t p
r
ogram
.
commit
|
commitdiff
|
tree
2018-03-21
D
.
Ri
c
ha
r
d
H
ipp
Get the opt
f
uz
z
program working
.
commit
|
commitdiff
|
tree
2018-03-21
D
.
Richard Hip
p
Add the optfuzz
.
c p
r
o
g
r
am for verifyin
g
the
query planner
.
.
.
commit
|
commitdiff
|
tree
2018-03-21
D
.
R
ichard H
i
pp
Relax LEFT-JO
I
N restr
i
ctions
o
n the pu
s
h
-down optimization
.
commit
|
commitdiff
|
tree
2018-03-20
D
.
Richard Hipp
D
o a more
t
horough job
o
f c
l
eaning t
r
a
ces
of the
strengt
h
.
.
.
commit
|
commitdiff
|
tree
2018-03-20
D
.
Ric
h
ard Hipp
If
t
erms o
f
t
h
e WH
E
R
E
c
lau
s
e require that the
r
ig
h
t
.
.
.
commit
|
commitdiff
|
tree
2018-03-20
D
.
R
i
chard H
i
pp
F
ix incorrect t
e
stca
s
e labels on two cas
e
s in join5
.
.
.
commit
|
commitdiff
|
tree
2018-03-20
D
.
R
ichard Hi
p
p
Improvemen
t
s
to th
e
HA
V
ING-to-WHERE optimization
.
.
.
.
commit
|
commitdiff
|
tree
2018-03-20
D
.
Richard
Hi
p
p
A
void unnecessar
y
write to t
h
e sqlite
_
sequence table
.
.
.
commit
|
commitdiff
|
tree
next