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
Improvements to integer/float comparisons on architectures that lack a
2018-04-20
D
.
Richar
d
Hipp
M
i
nor
simplifi
c
ation of the prev
i
ous check
i
n
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Richard Hipp
Avoid unnecess
a
r
y
cursor
s
eeks dur
i
ng upsert p
r
oces
s
ing
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Richard Hipp
E
nha
n
ce UPSERT so
that the UPDATE
uses
th
e
same se
t
.
.
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
R
ic
h
ar
d
Hi
p
p
Minor simplif
i
cation of
the cursor alloc
a
tion logic
.
.
.
commit
|
commitdiff
|
tree
2018-04-19
D
.
R
i
chard Hipp
Fix the handling of "P
R
AGMA count_changes=ON" with
.
.
.
commit
|
commitdiff
|
tree
2018-04-19
D
.
Ri
c
h
a
r
d
H
i
pp
Minor simplif
i
cation to
t
h
e ups
e
r
t
logic
.
commit
|
commitdiff
|
tree
2018-04-19
D
.
Richard
Hi
p
p
Add
the
-
-upse
r
t
option to the wordcoun
t
test
pr
o
g
ram
.
commit
|
commitdiff
|
tree
2018-04-19
D
.
Richard
Hipp
Add
th
e
ext/misc/te
m
platevtab
.
c template for
v
irtual
.
.
.
commit
|
commitdiff
|
tree
2018-04-19
D
.
Richard Hipp
Fix a
problem in the
ne
w
ups
e
r
t
i
m
pl
e
mention, discove
r
ed
.
.
.
commit
|
commitdiff
|
tree
2018-04-19
D
.
Richard Hipp
Fix th
e
table
name alia
s
ing on INSER
T
so that it occurs
.
.
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richard
Hipp
A
v
oid a NULL-poin
t
e
r deref following OOM
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Ric
h
ard Hipp
F
i
x
a
test case inside distinct
.
te
s
t
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richard Hipp
Impr
o
ved matching of COLLATE clauses withi
n
the ON
.
.
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
R
i
chard Hipp
Fix a prob
l
em in the sqlite3ExprCo
m
pare() function
.
.
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Rich
a
rd Hipp
Ad
d
sup
p
o
r
t for
P
ostgreSQL UPSERT s
y
ntax and fun
c
t
i
on
a
lit
y
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richard Hip
p
Fix the build fo
r
SQLITE_OMIT_
U
PSERT
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richard
H
i
p
p
Add the --sorter
r
ef N option
t
o the CLI
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Rich
a
rd Hi
p
p
Omi
t
some code not
used without SQ
L
ITE_EN
A
BLE
_
SORTER_REFERE
N
.
.
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
R
ichard Hipp
Remove an unused l
o
cal vari
a
b
l
e
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
R
i
cha
r
d Hip
p
Enhan
c
e ALTER TABLE A
D
D COLUMN to s
u
pp
o
rt "DEFAU
L
T
.
.
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Ri
c
h
a
rd Hi
p
p
Add c
h
e
c
ks to the CLI tha
t
issue a
w
a
rnin
g
if SQLite
.
.
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
R
i
c
h
a
r
d Hi
p
p
Add new testcas
e
()
m
acros
a
nd
fix a b
u
g that
w
as rev
e
aled
.
.
.
commit
|
commitdiff
|
tree
2018-04-17
D
.
R
ic
h
ard Hipp
R
e
move unrea
c
hable branches
.
100%
M
C/DC in TH3 now
.
commit
|
commitdiff
|
tree
2018-04-17
D
.
Richard Hipp
Ad
d
ed a comm
e
nt o
n
the assert
(
)
a
dd
e
d to the previ
o
us
.
.
.
commit
|
commitdiff
|
tree
2018-04-17
D
.
R
i
ch
a
rd Hipp
Fixes to the logic f
o
r c
o
n
straint che
c
k
reordering
.
.
.
commit
|
commitdiff
|
tree
2018-04-17
D
.
Ric
h
ard Hipp
Duri
n
g
P
RA
G
MA
v
dbe_a
d
doptra
c
e=ON, s
h
o
w
calls to s
q
lite3Vdb
e
R
.
.
.
commit
|
commitdiff
|
tree
2018-04-17
D
.
Richard Hi
p
p
TK_REGIS
T
ER expr
e
s
sions nodes are p
r
obably not
constant
.
.
.
commit
|
commitdiff
|
tree
2018-04-17
D
.
R
ichard Hipp
Simplific
a
tion to the upsert logic
.
commit
|
commitdiff
|
tree
2018-04-17
D
.
Ric
h
ard Hipp
New test cases for upse
r
t
.
commit
|
commitdiff
|
tree
2018-04-16
D
.
Richa
r
d Hipp
Mer
g
e
the L
e
mon
e
nhancem
e
nt fro
m
trunk, resul
t
ing in
.
.
.
commit
|
commitdiff
|
tree
2018-04-16
D
.
R
i
chard Hipp
Lemon enhancements: (1) Do not allocate s
p
ace f
o
r
.
.
.
commit
|
commitdiff
|
tree
2018-04-16
D
.
Richard Hipp
Remove the MySQL upser
t
syntax
.
As an
o
ptio
n
al alias
.
.
.
commit
|
commitdiff
|
tree
2018-04-16
D
.
Richard Hipp
Add support for the "ex
c
luded
.
*" nam
e
s in the U
P
DATE
.
.
.
commit
|
commitdiff
|
tree
2018-04-16
D
.
R
i
ch
a
rd H
i
pp
Merge changes fr
o
m trunk
.
commit
|
commitdiff
|
tree
2018-04-16
D
.
Richa
r
d
H
ipp
Incre
a
s
e the version numb
e
r to
3
.
24
.
0
commit
|
commitdiff
|
tree
2018-04-16
D
.
Richard Hip
p
Red
u
ce
t
h
e
s
ize of the NameContext object by g
r
oupin
g
.
.
.
commit
|
commitdiff
|
tree
2018-04-14
D
.
Richard Hipp
Get upsert
w
o
rking
on WITHOU
T
R
O
W
I
D tables
.
commit
|
commitdiff
|
tree
2018-04-14
D
.
Richard
Hi
p
p
Make sur
e
cons
t
r
a
in
t
checks occur in the corre
c
t
orde
r
.
.
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
Richar
d
Hipp
Firs
t
cut a
t
logic
to perform DO UPDATE for rowid
t
a
bles
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
Richard Hipp
Add infrastructure for doing an UPDA
T
E as part of an
.
.
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
Richard Hi
p
p
M
erge the preupdate hook cha
n
ge from trunk
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
Richard Hipp
Remove
a
n
a
l
ways-true
branch
f
rom t
h
e preu
p
date hook
.
.
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
R
i
cha
r
d Hipp
Get
t
he ON CONF
L
ICT
D
O NOTH
I
NG form
of upsert working
.
.
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
Richard Hip
p
Get
th
e
c
onflict-targe
t
cla
u
se
parsing work
i
ng correctly
.
.
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
Richard
H
ipp
Improve
d
confl
i
c
t
-
target matching
l
ogic
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
Richar
d
Hipp
Back off of
t
he e
x
tend
e
d upse
r
t
synta
x
that al
l
ows
.
.
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
Richard Hip
p
Begin
adding upsert logic
.
T
his is an
i
ncreme
n
tal
.
.
.
commit
|
commitdiff
|
tree
2018-04-12
D
.
R
i
c
ha
r
d Hipp
Break out th
e
upsert co
d
e into
a separat
e
sou
r
ce file
.
commit
|
commitdiff
|
tree
2018-04-12
D
.
Richard Hipp
Fix
another
t
ypo in a comment
.
commit
|
commitdiff
|
tree
2018-04-12
D
.
R
i
chard H
i
p
p
Simp
l
e comment clarif
i
cation
.
No code
o
r
log
i
c changes
.
commit
|
commitdiff
|
tree
2018-04-12
D
.
Ric
h
ard Hipp
Extend the upsert synt
a
x to all
o
w
a
W
HER
E
c
l
aus
e
on
.
.
.
commit
|
commitdiff
|
tree
2018-04-12
D
.
Rich
a
rd
Hipp
Update the upsert parsing
s
o that i
t
accepts conflict
.
.
.
commit
|
commitdiff
|
tree
2018-04-12
D
.
Richard Hipp
Add the Upsert obje
c
t for ho
l
ding upsert cl
a
use information
.
commit
|
commitdiff
|
tree
2018-04-12
D
.
Ric
h
a
rd Hipp
Me
r
ge changes from trunk
.
commit
|
commitdiff
|
tree
2018-04-11
D
.
R
ichard
Hipp
Help t
h
e
parser r
u
n
faster by avoiding the "expla
i
n
.
.
.
commit
|
commitdiff
|
tree
2018-04-11
D
.
Richard
H
ipp
Prohi
b
it bou
n
d paramete
r
s in the arg
u
ments to
t
a
ble
.
.
.
commit
|
commitdiff
|
tree
2018-04-10
D
.
Richard Hipp
V
e
r
s
ion 3
.
23
.
1
commit
|
commitdiff
|
tree
2018-04-10
D
.
Richard Hipp
Incr
e
a
se the versi
o
n num
b
er to 3
.
2
3
.
1
.
commit
|
commitdiff
|
tree
2018-04-10
D
.
Rich
a
rd Hipp
Remove an unneces
s
ary
SQLIT
E
_UNTESTABLE c
o
m
pi
l
e-ti
m
e
.
.
.
commit
|
commitdiff
|
tree
2018-04-10
D
.
Richard Hipp
Update the top-level READM
E
.
md fi
l
e to poi
n
t to the
.
.
.
commit
|
commitdiff
|
tree
2018-04-10
D
.
Richard Hipp
Update the top-level READM
E
.
md file to point to the
.
.
.
commit
|
commitdiff
|
tree
2018-04-09
D
.
Richard Hipp
Minor changes to
t
h
e input gramma
r
r
esulting
in a
f
aster
.
.
.
commit
|
commitdiff
|
tree
2018-04-09
D
.
Richard Hi
p
p
Enhance the
que
r
y planner s
o
that it det
e
cts when t
h
e
.
.
.
commit
|
commitdiff
|
tree
2018-04-09
D
.
Richard Hipp
Improvements
t
o "
.
wheretr
a
ce" outp
u
t
.
commit
|
commitdiff
|
tree
2018-04-09
D
.
Richard Hipp
Fix a (harm
l
es
s
) signed inte
g
er ov
e
rflow warn
i
n
g
.
commit
|
commitdiff
|
tree
2018-04-07
D
.
Richa
r
d Hipp
More compl
e
te parsing of U
P
SERT,
including UPSERT
within
.
.
.
commit
|
commitdiff
|
tree
2018-04-06
D
.
R
i
chard Hipp
Demonstr
a
tion o
f
how
t
h
e
p
arse
r
can be augmented to
.
.
.
commit
|
commitdiff
|
tree
2018-04-06
D
.
Ric
h
ard Hipp
Enha
n
ce
LEMON to
sho
w
precendence
o
f
s
y
m
b
ols and
a
ll
.
.
.
commit
|
commitdiff
|
tree
2018-04-05
D
.
Richard Hipp
Fix
t
he sqlite3
W
he
r
eTrace mechanism so that
i
t
compiles
.
.
.
commit
|
commitdiff
|
tree
2018-04-03
D
.
Richard Hipp
Fix an
error
message in speedtest1
.
c and
make
t
h
e
.
.
.
commit
|
commitdiff
|
tree
2018-04-03
D
.
Richard Hip
p
Fix the gen
e
rate_series vi
r
t
ual table
s
o that it correctly
.
.
.
commit
|
commitdiff
|
tree
2018-04-03
D
.
Richard Hipp
Ch
a
nge the LEFT
J
OIN stre
n
gth reduction optimization
.
.
.
commit
|
commitdiff
|
tree
2018-04-02
D
.
Richard Hipp
Version
3
.
23
.
0
commit
|
commitdiff
|
tree
2018-04-02
D
.
Ri
c
hard Hipp
B
e
tter solution to the LIKE probl
e
m
fr
o
m the
p
reviou
s
.
.
.
commit
|
commitdiff
|
tree
2018-03-31
D
.
Richard
H
i
p
p
Fix
a
l
o
gic er
r
or dis
c
overe
d
by OSSFuz
z
t
hat c
a
n ca
u
se
.
.
.
commit
|
commitdiff
|
tree
2018-03-30
D
.
R
i
chard
H
i
pp
Fix a bug
in the spel
l
fi
x
extens
i
on causing it to compute
.
.
.
commit
|
commitdiff
|
tree
2018-03-30
D
.
Richard Hipp
Fix an
o
f
f-by-one er
r
or in the
d
ist3 alg
o
ri
t
h
m
of
t
he
.
.
.
commit
|
commitdiff
|
tree
2018-03-29
D
.
Ri
c
ha
r
d Hipp
Modify the sqlite
3
OsFi
l
eCont
r
ol(
)
i
nt
e
rface
to det
e
c
t
.
.
.
commit
|
commitdiff
|
tree
2018-03-28
D
.
Richard Hip
p
Fix a
h
arm
l
ess compile
r
w
a
rning in t
h
e kvtest
.
exe pro
g
r
a
m
.
commit
|
commitdiff
|
tree
2018-03-28
D
.
R
i
chard
H
i
pp
F
i
x a harmless
compi
l
er war
n
ing
.
commit
|
commitdiff
|
tree
2018-03-28
D
.
Richard Hip
p
Remove tab characters
.
No logic
a
l
c
han
g
es to code
.
commit
|
commitdiff
|
tree
2018-03-28
D
.
Richa
r
d
Hip
p
M
inor
comm
e
n
t
changes
.
commit
|
commitdiff
|
tree
2018-03-27
D
.
Richard Hipp
Fi
x
a ty
p
o in
t
he README
f
i
le
f
or ICU
.
No code
changes
.
commit
|
commitdiff
|
tree
2018-03-27
D
.
R
ich
a
rd
H
ipp
T
h
e pus
h
-down o
p
timization wa
s
being too
a
ggr
e
ssive
.
.
.
commit
|
commitdiff
|
tree
2018-03-27
D
.
R
ichard Hipp
Provid
e
t
he ability fo
r
the VF
S
to
do a bl
o
ck
i
ng wa
i
t
.
.
.
commit
|
commitdiff
|
tree
2018-03-26
D
.
Richard Hipp
Do not inject OOM errors on SQLITE_FCNTL_
L
OCK_TIMEOUT
.
.
.
commit
|
commitdiff
|
tree
2018-03-26
D
.
Richard Hip
p
A
v
oid
a
race conditi
o
n
that might
c
ause a busy_tim
e
out
.
.
.
commit
|
commitdiff
|
tree
2018-03-26
D
.
Richard
H
i
pp
Add infras
t
ructure to suppo
r
t for
u
sing F_SETLKW with
.
.
.
commit
|
commitdiff
|
tree
2018-03-26
D
.
Richard
Hipp
R
efactor s
o
me inte
r
n
a
l
object element na
m
es us
e
d
b
y
.
.
.
commit
|
commitdiff
|
tree
2018-03-24
D
.
Ri
c
har
d
Hi
p
p
Add
testcase() macros an
d
imp
r
ove commen
t
s in the LEFT
.
.
.
commit
|
commitdiff
|
tree
2018-03-24
D
.
Richar
d
Hip
p
Yet a
n
other fault
i
n the
s
qlite3ExprI
m
p
l
ies
N
o
tNull
.
.
.
commit
|
commitdiff
|
tree
2018-03-24
D
.
Richard H
i
pp
Bu
g
fix in the LEFT JOIN
s
treng
t
h re
d
uc
t
ion optimization of
commit
|
commitdiff
|
tree
2018-03-24
D
.
R
i
chard Hipp
P
repen
d
linkage m
a
c
ros to th
e
sqlite3rebase
r
interfa
c
e
s
.
commit
|
commitdiff
|
tree
2018-03-23
D
.
Richard Hipp
Fix the -readon
l
y option
o
n the CL
I
so that
it actually
.
.
.
commit
|
commitdiff
|
tree
2018-03-23
D
.
Richard Hipp
Fix
typ
o
i
n
a c
o
mment use
d
for doc
u
mentation
.
No change
s
.
.
.
commit
|
commitdiff
|
tree
2018-03-23
D
.
Richard Hipp
Fix an
e
rror in the
CLI in the previ
o
us ([0249
d
9aecf6994
8
.
.
.
commit
|
commitdiff
|
tree
2018-03-23
D
.
Ric
h
ard Hipp
Fix the ANALYZE command so that it will process tables
.
.
.
commit
|
commitdiff
|
tree
2018-03-22
D
.
Richard
Hip
p
Add th
e
left
joi
n
s
tr
e
ng
t
h
red
u
ction optimization
.
.
.
.
commit
|
commitdiff
|
tree
2018-03-22
D
.
Richard
H
ip
p
A
d
d t
h
e --valid-sq
l
optio
n
to t
h
e optfuzz test program
.
commit
|
commitdiff
|
tree
2018-03-21
D
.
Richard Hipp
Ge
t
the optfuzz program working
.
commit
|
commitdiff
|
tree
next