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
New test cases for upsert.
2018-04-17
D
.
Richar
d
Hip
p
New test cases for up
s
ert
.
commit
|
commitdiff
|
tree
2018-04-16
D
.
Richard Hipp
M
erge the Le
m
o
n
enh
a
n
ce
m
e
n
t from trunk,
r
esulting in
.
.
.
commit
|
commitdiff
|
tree
2018-04-16
D
.
Richard Hipp
Lemon enhancements
:
(
1
) Do
n
ot alloc
a
t
e sp
a
ce for
.
.
.
commit
|
commitdiff
|
tree
2018-04-16
D
.
Richard Hi
p
p
Remove the M
y
SQL
u
psert sy
n
tax
.
A
s
an o
p
tional alias
.
.
.
commit
|
commitdiff
|
tree
2018-04-16
D
.
Ri
c
ha
r
d Hi
p
p
Add support f
o
r the "excluded
.
*"
name
s
in the
U
P
DATE
.
.
.
commit
|
commitdiff
|
tree
2018-04-16
D
.
Richard Hipp
Me
r
ge changes from
trunk
.
commit
|
commitdiff
|
tree
2018-04-16
D
.
Rich
a
rd H
i
pp
Increase the versio
n
n
um
b
er to 3
.
24
.
0
commit
|
commitdiff
|
tree
2018-04-16
D
.
Richard Hipp
Reduce the
size of the NameContext obj
e
ct by grou
p
ing
.
.
.
commit
|
commitdiff
|
tree
2018-04-14
D
.
Ri
c
h
ard Hipp
Get up
s
ert wo
r
kin
g
on WITHOUT R
O
WID tables
.
commit
|
commitdiff
|
tree
2018-04-14
D
.
Richar
d
Hipp
Make
sure constrain
t
checks
oc
c
u
r in the correct ord
e
r
.
.
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
R
ichard Hipp
First cut at logic
to perform DO UPDATE for
r
owid t
a
bles
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
R
ichard
H
ip
p
Add infrastructure for doing a
n
UPDATE a
s
part of an
.
.
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
Richard
Hipp
M
e
rge the preupda
t
e
h
oo
k
change f
r
om trunk
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
Richard Hipp
Remove an a
l
w
ays-tr
u
e branch
f
r
om
the
p
r
e
update hook
.
.
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
Richard Hipp
Get t
h
e ON CONFLICT DO NOTHING
f
orm of upsert
wo
r
king
.
.
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
Richard
H
i
p
p
G
et the
con
f
li
c
t-target cl
a
use parsing w
o
rking correctl
y
.
.
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
Ri
c
h
ard Hipp
Impro
v
ed c
o
nf
l
ict-tar
g
et matchin
g
l
ogic
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
Richard Hipp
Ba
c
k of
f
of the ext
e
nde
d
upse
r
t syntax that allows
.
.
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
Ric
h
ard Hi
p
p
Be
g
in adding upsert
l
ogic
.
This is
an
incremental
.
.
.
commit
|
commitdiff
|
tree
2018-04-12
D
.
Richard Hipp
Break out the
u
p
ser
t
code into a
s
eparate source file
.
commit
|
commitdiff
|
tree
2018-04-12
D
.
Richard
H
i
p
p
Fix anoth
e
r typo in a comment
.
commit
|
commitdiff
|
tree
2018-04-12
D
.
Richard Hipp
Simp
l
e comment
c
la
r
ification
.
No
c
o
de or logic ch
a
nge
s
.
commit
|
commitdiff
|
tree
2018-04-12
D
.
Ri
c
hard Hipp
Ext
e
nd the
u
psert
s
yn
t
ax
to allow
a
WHERE clause
on
.
.
.
commit
|
commitdiff
|
tree
2018-04-12
D
.
R
i
chard
Hipp
Updat
e
the ups
e
rt par
s
i
ng so
t
h
at
i
t accepts
c
onflict
.
.
.
commit
|
commitdiff
|
tree
2018-04-12
D
.
R
ichard
Hipp
Add
t
he Upsert o
b
ject for holding ups
e
r
t c
l
ause information
.
commit
|
commitdiff
|
tree
2018-04-12
D
.
Ric
h
ar
d
Hipp
Merge changes from trunk
.
commit
|
commitdiff
|
tree
2018-04-11
D
.
Richard
H
i
p
p
Help the
parser
run faster by
avoiding the "explain
.
.
.
commit
|
commitdiff
|
tree
2018-04-11
D
.
Richard H
i
pp
Prohibit bound para
m
et
e
rs in t
h
e a
r
guments to t
a
ble
.
.
.
commit
|
commitdiff
|
tree
2018-04-10
D
.
Richard Hipp
V
ersion 3
.
23
.
1
commit
|
commitdiff
|
tree
2018-04-10
D
.
Richard Hipp
Increase
the version
n
u
mber
t
o
3
.
23
.
1
.
commit
|
commitdiff
|
tree
2018-04-10
D
.
Richa
r
d Hipp
Remove an unne
c
es
s
ary SQLITE_
U
N
T
ESTABLE compile-
t
ime
.
.
.
commit
|
commitdiff
|
tree
2018-04-10
D
.
Richard
H
ipp
Upda
t
e t
h
e
t
op-
l
e
v
e
l
README
.
md file to
p
oint to the
.
.
.
commit
|
commitdiff
|
tree
2018-04-10
D
.
Ric
h
ard Hipp
Update the
top-level README
.
md file to point
t
o the
.
.
.
commit
|
commitdiff
|
tree
2018-04-09
D
.
Richard H
i
pp
M
i
nor chang
e
s to the input gr
a
mma
r
result
i
n
g
i
n a faster
.
.
.
commit
|
commitdiff
|
tree
2018-04-09
D
.
Richard
H
ip
p
Enhance the
query planner so th
a
t it d
e
tects when the
.
.
.
commit
|
commitdiff
|
tree
2018-04-09
D
.
Richar
d
H
i
p
p
Impro
v
em
e
nts to "
.
wheretrace" output
.
commit
|
commitdiff
|
tree
2018-04-09
D
.
Ri
c
h
ard Hipp
Fix a (harml
e
ss) si
g
ned integer overflow warni
n
g
.
commit
|
commitdiff
|
tree
2018-04-07
D
.
Richard Hipp
More c
o
mpl
e
t
e
pars
i
ng
o
f UPSER
T
, including UPSERT within
.
.
.
commit
|
commitdiff
|
tree
2018-04-06
D
.
Ric
h
ard H
i
p
p
Demonst
r
ation
o
f
how the p
a
rser c
a
n
be au
g
me
n
ted to
.
.
.
commit
|
commitdiff
|
tree
2018-04-06
D
.
Richard Hipp
Enhance LEMON
t
o show precenden
c
e
of sy
m
bols and a
l
l
.
.
.
commit
|
commitdiff
|
tree
2018-04-05
D
.
Richard Hipp
Fix the sqlite3WhereTrace
m
echanism so that it co
m
piles
.
.
.
commit
|
commitdiff
|
tree
2018-04-03
D
.
Ric
h
ard
Hipp
Fix
a
n error mes
s
age i
n
s
p
e
e
dt
e
st1
.
c and make the
.
.
.
commit
|
commitdiff
|
tree
2018-04-03
D
.
Richard H
i
p
p
Fix the g
e
nera
t
e_series virtual table so t
h
a
t
it correct
l
y
.
.
.
commit
|
commitdiff
|
tree
2018-04-03
D
.
Ric
h
a
r
d
H
i
pp
Ch
a
n
g
e the LEFT JOIN stren
g
th redu
c
t
i
on optimizatio
n
.
.
.
commit
|
commitdiff
|
tree
2018-04-02
D
.
Rich
a
rd Hipp
Version 3
.
23
.
0
commit
|
commitdiff
|
tree
2018-04-02
D
.
R
ichar
d
Hipp
B
e
tter solut
i
on to the LIKE
problem
f
r
o
m
the previo
u
s
.
.
.
commit
|
commitdiff
|
tree
2018-03-31
D
.
Rich
a
rd Hi
p
p
Fix a log
i
c error discove
r
ed by
O
SSFu
z
z
th
a
t can cause
.
.
.
commit
|
commitdiff
|
tree
2018-03-30
D
.
Ri
c
hard H
i
pp
F
ix a bu
g
in the spell
f
ix e
x
tension causing it to comput
e
.
.
.
commit
|
commitdiff
|
tree
2018-03-30
D
.
Richard Hipp
Fix an o
f
f-by-one erro
r
in the dist3 alg
o
rithm of
the
.
.
.
commit
|
commitdiff
|
tree
2018-03-29
D
.
R
i
chard Hipp
Modi
f
y
t
he sqli
t
e
3OsFileCont
r
ol()
interface to detect
.
.
.
commit
|
commitdiff
|
tree
2018-03-28
D
.
Richard
Hipp
F
ix a
harmless compiler w
a
rnin
g
in the
k
vtest
.
exe pro
g
ram
.
commit
|
commitdiff
|
tree
2018-03-28
D
.
Ric
h
ard Hipp
Fix
a
ha
r
mless compiler warnin
g
.
commit
|
commitdiff
|
tree
2018-03-28
D
.
Ric
h
ar
d
Hipp
Remov
e
tab chara
c
ters
.
No
logic
a
l chang
e
s to
c
ode
.
commit
|
commitdiff
|
tree
2018-03-28
D
.
Richard Hipp
Mi
n
or comment changes
.
commit
|
commitdiff
|
tree
2018-03-27
D
.
R
ichard Hipp
Fi
x
a
t
ypo in the REA
D
ME file for I
C
U
.
No code chang
e
s
.
commit
|
commitdiff
|
tree
2018-03-27
D
.
R
i
c
hard Hipp
The push-down op
t
imization was being too
a
ggressive
.
.
.
commit
|
commitdiff
|
tree
2018-03-27
D
.
Ric
h
ard Hi
p
p
Provid
e
the abi
l
i
t
y for the
V
FS to
d
o a blocking wait
.
.
.
commit
|
commitdiff
|
tree
2018-03-26
D
.
Richard Hipp
Do not i
n
ject
O
OM errors on SQLITE_FCNTL_L
O
CK_TIM
E
OUT
.
.
.
commit
|
commitdiff
|
tree
2018-03-26
D
.
Ri
c
h
a
r
d
H
ip
p
Avoid a
rac
e
condition that might c
a
use a busy_ti
m
eo
u
t
.
.
.
commit
|
commitdiff
|
tree
2018-03-26
D
.
Richard Hipp
Add i
n
f
r
a
s
tructure to support for usin
g
F_SETLKW with
.
.
.
commit
|
commitdiff
|
tree
2018-03-26
D
.
Ri
c
hard H
i
pp
Refacto
r
s
ome inte
r
nal object
element names used
b
y
.
.
.
commit
|
commitdiff
|
tree
2018-03-24
D
.
R
ichard Hipp
Add testcase() m
a
cros and improv
e
comments in the LEFT
.
.
.
commit
|
commitdiff
|
tree
2018-03-24
D
.
Richar
d
H
i
pp
Yet another fault in t
h
e
sqlite3Ex
p
rImpliesNotNull
.
.
.
commit
|
commitdiff
|
tree
2018-03-24
D
.
R
i
chard Hipp
B
ug fix i
n
the LEFT JO
I
N stre
n
gth reduction optimiz
a
ti
o
n
of
commit
|
commitdiff
|
tree
2018-03-24
D
.
Richard Hipp
P
repend
l
inkage ma
c
ro
s
to
the sqlite
3
rebaser int
e
rfaces
.
commit
|
commitdiff
|
tree
2018-03-23
D
.
Richa
r
d Hip
p
F
i
x t
h
e -read
o
nly
option on the CLI
s
o that
it actually
.
.
.
commit
|
commitdiff
|
tree
2018-03-23
D
.
Richard
Hipp
F
i
x
t
ypo in a comment u
s
ed for
d
ocume
n
ta
t
i
on
.
No cha
n
ges
.
.
.
commit
|
commitdiff
|
tree
2018-03-23
D
.
Richard Hipp
Fix an error in the CLI in the previ
o
us
(
[024
9
d9ae
c
f699
4
8
.
.
.
commit
|
commitdiff
|
tree
2018-03-23
D
.
R
i
c
hard Hipp
Fix the ANA
L
Y
ZE co
m
mand
s
o that it w
i
l
l
pro
c
ess
t
ables
.
.
.
commit
|
commitdiff
|
tree
2018-03-22
D
.
Rich
a
rd Hipp
Add the l
e
ft join strength reduction optim
i
zation
.
.
.
.
commit
|
commitdiff
|
tree
2018-03-22
D
.
Richard
H
ip
p
A
dd the
--
v
a
l
id-sql option to th
e
optfuzz test p
r
ogram
.
commit
|
commitdiff
|
tree
2018-03-21
D
.
Richard Hipp
G
et
the optfuzz program working
.
commit
|
commitdiff
|
tree
2018-03-21
D
.
Richard Hipp
Add the
o
p
t
fuzz
.
c
pr
o
gram for verifying the query
planner
.
.
.
commit
|
commitdiff
|
tree
2018-03-21
D
.
Ric
h
ard Hipp
Relax
LEFT-JOI
N
restrict
i
o
ns on
t
he push-dow
n
op
t
imization
.
commit
|
commitdiff
|
tree
2018-03-20
D
.
Richa
r
d H
i
pp
Do
a
mo
r
e
t
hor
o
u
g
h jo
b
of cleani
n
g
t
ra
c
es
o
f th
e
strength
.
.
.
commit
|
commitdiff
|
tree
2018-03-20
D
.
Richar
d
Hipp
If ter
m
s o
f
the WHERE clause req
u
ire that the
r
i
g
h
t
.
.
.
commit
|
commitdiff
|
tree
2018-03-20
D
.
Richard Hipp
Fix i
n
correc
t
tes
t
c
a
se labels on
two cases
i
n join5
.
.
.
commit
|
commitdiff
|
tree
2018-03-20
D
.
Richard Hipp
Improvements
to the HAVING-to-
W
HERE optimization
.
.
.
.
commit
|
commitdiff
|
tree
2018-03-20
D
.
R
i
cha
r
d
Hipp
Avoid unnecessary write to the sql
i
te_se
q
uence table
.
.
.
commit
|
commitdiff
|
tree
2018-03-20
D
.
Rich
a
rd Hipp
A
d
d t
h
e ability to disab
l
e t
h
e push-down optimiza
t
ion
.
.
.
commit
|
commitdiff
|
tree
2018-03-20
D
.
Richard Hipp
Remove a debugging sta
t
emen
t
accide
n
tly lef
t
in
commit
|
commitdiff
|
tree
2018-03-20
D
.
Ri
c
ha
r
d Hipp
In t
h
e CLI, avoid ext
r
a
.
selecttr
a
ce and
.
wheretrace
.
.
.
commit
|
commitdiff
|
tree
2018-03-20
D
.
Ri
c
hard H
i
pp
Closer re
a
ding of the
s
q
lite3_db_
c
on
f
ig
(
) documen
t
ation
.
.
.
commit
|
commitdiff
|
tree
2018-03-20
D
.
Ri
c
hard Hipp
F
ix a min
o
r forma
t
ting issue on the
s
qlite3_db_config
.
.
.
commit
|
commitdiff
|
tree
2018-03-20
D
.
Ri
c
hard Hipp
Add
the ab
i
l
ity to di
s
abl
e
the push
-
down optim
i
zation
.
.
.
commit
|
commitdiff
|
tree
2018-03-19
D
.
Ric
h
ard Hipp
Minor improvements to "
.
selecttr
a
c
e"
.
No
changes
to
.
.
.
commit
|
commitdiff
|
tree
2018-03-19
D
.
Richard Hi
p
p
Enhance
t
he
c
o
mman
d
-line completion extension t
o
return
.
.
.
commit
|
commitdiff
|
tree
2018-03-19
D
.
Richard Hi
p
p
In the compil
e
_options prag
m
a, sho
w
t
h
e actual value
.
.
.
commit
|
commitdiff
|
tree
2018-03-19
D
.
Richard Hipp
Improved "
.
s
e
l
ecttr
a
ce" output fo
r
m
atting
.
No c
h
a
n
ge
s
.
.
.
commit
|
commitdiff
|
tree
2018-03-17
D
.
Ric
h
a
r
d Hipp
Do not use
s
q
l
ite3
_
column_decltype() in the CLI if
.
.
.
commit
|
commitdiff
|
tree
2018-03-16
D
.
R
ichard
H
ipp
D
e
tect corruption
i
n the form of
the s
q
lite_se
q
uence
.
.
.
commit
|
commitdiff
|
tree
2018-03-16
D
.
Richard Hipp
Detect databases who
s
e sche
m
a is corrupted
using a
.
.
.
commit
|
commitdiff
|
tree
2018-03-16
D
.
Richard
H
ipp
B
e
t
t
e
r
err
o
r
m
essage
text wh
e
n
the
schem
a
i
s corrup
t
ed
.
.
.
commit
|
commitdiff
|
tree
2018-03-16
D
.
Ri
c
ha
r
d
Hipp
Avoid writi
n
g
the sq
l
ite_sequ
e
nce
table when it
h
as
.
.
.
commit
|
commitdiff
|
tree
2018-03-15
D
.
Ri
c
hard Hipp
F
ix a typo
in a comment use
d
to generate
docu
m
entation
.
.
.
commit
|
commitdiff
|
tree
2018-03-15
D
.
Richard Hipp
Fix an issue w
i
th t
h
e
fsdi
r
() table-valu
e
d
f
unction
.
.
.
commit
|
commitdiff
|
tree
2018-03-14
D
.
Richard Hipp
Add the SQL
I
T
E_D
B
ST
A
TUS_CACHE_SPIL
L
option t
o
sq
l
ite3_db
_
s
t
a
.
.
.
commit
|
commitdiff
|
tree
2018-03-14
D
.
Richard
Hip
p
Disable one of the test c
a
se
s
from
check-in [21ecbce1378f
3
cc
.
.
.
commit
|
commitdiff
|
tree
2018-03-14
D
.
Richar
d
Hipp
Add
the SQL
I
TE_DBS
T
ATUS_CACHE_SP
I
LL option to sqlite
3
_d
b
_sta
.
.
.
commit
|
commitdiff
|
tree
2018-03-10
D
.
Richard Hipp
F
i
x the second callback
argument to the
"
profile" response
.
.
.
commit
|
commitdiff
|
tree
next