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
Version 3.23.0
2018-04-02
D
.
Richard Hipp
Versi
o
n 3
.
23
.
0
commit
|
commitdiff
|
tree
2018-04-02
D
.
Rich
a
r
d Hipp
Bette
r
s
o
lutio
n
t
o
t
he LIKE probl
e
m
f
rom the previous
.
.
.
commit
|
commitdiff
|
tree
2018-03-31
D
.
R
i
chard
Hipp
F
ix a logi
c
error discovered by
O
SSFu
z
z t
h
at can cause
.
.
.
commit
|
commitdiff
|
tree
2018-03-30
D
.
Richard Hipp
Fix a bug in the spellf
i
x exten
s
io
n
causing
i
t
t
o
compute
.
.
.
commit
|
commitdiff
|
tree
2018-03-30
D
.
Richard Hipp
Fix an o
f
f-b
y
-one error in th
e
dist
3
algor
i
thm of t
h
e
.
.
.
commit
|
commitdiff
|
tree
2018-03-29
D
.
R
i
chard
H
ipp
M
o
dify th
e
sqlite3Os
F
ileControl() interfa
c
e
to detect
.
.
.
commit
|
commitdiff
|
tree
2018-03-28
D
.
Richa
r
d
H
ipp
Fix a harm
l
ess
c
ompiler wa
r
nin
g
in the kvte
s
t
.
e
x
e program
.
commit
|
commitdiff
|
tree
2018-03-28
D
.
R
ic
h
ard Hipp
Fix a
harmless
c
o
m
p
i
ler warnin
g
.
commit
|
commitdiff
|
tree
2018-03-28
D
.
Richard
Hipp
Rem
o
v
e
tab char
a
c
t
ers
.
No
lo
g
ical change
s
t
o code
.
commit
|
commitdiff
|
tree
2018-03-28
D
.
Richa
r
d Hipp
Minor comment chan
g
e
s
.
commit
|
commitdiff
|
tree
2018-03-27
D
.
Richard
H
ipp
F
ix a typo in
the RE
A
DME file for
I
C
U
.
No code changes
.
commit
|
commitdiff
|
tree
2018-03-27
D
.
Rich
a
rd Hipp
The push-do
w
n op
t
imizat
i
on was being too a
g
gressive
.
.
.
commit
|
commitdiff
|
tree
2018-03-27
D
.
Richard Hipp
Provide the ab
i
li
t
y for the VFS
to do a blocking
w
a
i
t
.
.
.
commit
|
commitdiff
|
tree
2018-03-26
D
.
R
icha
r
d
H
i
pp
Do no
t
inj
e
c
t
OOM errors
o
n SQLITE_
F
C
NTL_LOCK_TIMEOUT
.
.
.
commit
|
commitdiff
|
tree
2018-03-26
D
.
Rich
a
rd Hipp
Avoid a
r
ace con
d
ition that mi
g
ht cause
a
busy_timeout
.
.
.
commit
|
commitdiff
|
tree
2018-03-26
D
.
Rich
a
r
d Hipp
A
d
d infrast
r
uct
u
r
e
t
o
support for usi
n
g F_SETLKW wi
t
h
.
.
.
commit
|
commitdiff
|
tree
2018-03-26
D
.
Richard Hip
p
R
e
factor some internal object
element names
use
d
by
.
.
.
commit
|
commitdiff
|
tree
2018-03-24
D
.
Richard Hi
p
p
Add testcase(
)
macros and impr
o
ve com
m
ents in the LEFT
.
.
.
commit
|
commitdiff
|
tree
2018-03-24
D
.
Richard
H
ipp
Y
et another fault
in
the sqlite3Ex
p
r
I
mpliesNo
t
Null
.
.
.
commit
|
commitdiff
|
tree
2018-03-24
D
.
Richard H
i
pp
Bug fi
x
in the LEFT JOIN
s
t
ren
g
th r
e
ducti
o
n optimization o
f
commit
|
commitdiff
|
tree
2018-03-24
D
.
Ri
c
hard
Hipp
Pr
e
pend l
i
nkage m
a
cros to the sqlite3reba
s
er inter
f
ace
s
.
commit
|
commitdiff
|
tree
2018-03-23
D
.
Ri
c
hard H
i
p
p
Fix the
-
readonly optio
n
on the CLI
s
o
that
i
t
actually
.
.
.
commit
|
commitdiff
|
tree
2018-03-23
D
.
Richard Hipp
Fix typo in a
c
omment u
s
ed
f
or documentatio
n
.
No ch
a
ng
e
s
.
.
.
commit
|
commitdiff
|
tree
2018-03-23
D
.
Richar
d
H
i
pp
F
i
x an err
o
r
in
the CL
I
in the previous ([02
4
9d9ae
c
f69948
.
.
.
commit
|
commitdiff
|
tree
2018-03-23
D
.
Richard Hi
p
p
Fix
t
he ANALY
Z
E com
m
and
s
o
that i
t
will process tables
.
.
.
commit
|
commitdiff
|
tree
2018-03-22
D
.
Rich
a
rd Hipp
Add the left
join st
r
ength
r
eduction optimization
.
.
.
.
commit
|
commitdiff
|
tree
2018-03-22
D
.
Richard Hipp
Add the --val
i
d-sql opt
i
on t
o
th
e
o
p
tfuzz test pr
o
gram
.
commit
|
commitdiff
|
tree
2018-03-21
D
.
Richard Hipp
Get the optfuzz program
working
.
commit
|
commitdiff
|
tree
2018-03-21
D
.
Richar
d
H
ipp
Add the optfuzz
.
c pro
g
ram f
o
r v
e
rifyin
g
the query
planner
.
.
.
commit
|
commitdiff
|
tree
2018-03-21
D
.
Richard
Hipp
Relax LEF
T
-JOIN restriction
s
on th
e
push-d
o
wn
o
ptimization
.
commit
|
commitdiff
|
tree
2018-03-20
D
.
R
i
chard Hipp
Do a more tho
r
ough job of
cleaning traces of th
e
strength
.
.
.
commit
|
commitdiff
|
tree
2018-03-20
D
.
Richard Hipp
If te
r
m
s
o
f
the WHERE clause require that the right
.
.
.
commit
|
commitdiff
|
tree
2018-03-20
D
.
Ric
h
ard
Hipp
F
ix incorrect te
s
t
case labels on two cases in joi
n
5
.
.
.
commit
|
commitdiff
|
tree
2018-03-20
D
.
R
i
chard Hipp
Improve
m
ents to the HAVING-to-WHERE optimiz
a
tion
.
.
.
.
commit
|
commitdiff
|
tree
2018-03-20
D
.
Richard Hipp
A
voi
d
unnecessary w
r
ite to
t
h
e
sqlite_sequence
table
.
.
.
commit
|
commitdiff
|
tree
2018-03-20
D
.
Ri
c
hard Hipp
A
d
d th
e
ab
i
lity to
d
isa
b
le the push-down op
t
imizat
i
on
.
.
.
commit
|
commitdiff
|
tree
2018-03-20
D
.
Richard Hipp
Remove a debuggi
n
g st
a
temen
t
a
c
c
idently
left
in
commit
|
commitdiff
|
tree
2018-03-20
D
.
Ric
h
ard Hipp
In the CLI, avoid extra
.
selecttrac
e
and
.
wheretrace
.
.
.
commit
|
commitdiff
|
tree
2018-03-20
D
.
Richard Hipp
C
lose
r
r
eading of
t
h
e sq
l
i
te3_db_c
o
n
f
ig() documentati
o
n
.
.
.
commit
|
commitdiff
|
tree
2018-03-20
D
.
R
i
c
hard Hipp
Fix
a m
i
nor fo
r
m
atting issue
on the sqlit
e
3_
d
b
_
config
.
.
.
commit
|
commitdiff
|
tree
2018-03-20
D
.
R
i
chard Hipp
Add the
a
bi
l
ity to di
s
able the push-down
optim
i
zation
.
.
.
commit
|
commitdiff
|
tree
2018-03-19
D
.
Richard
H
i
pp
Minor improvements to "
.
selecttrace"
.
No changes to
.
.
.
commit
|
commitdiff
|
tree
2018-03-19
D
.
R
i
cha
r
d Hipp
E
nhance the co
m
man
d
-line completion e
x
tens
i
on to return
.
.
.
commit
|
commitdiff
|
tree
2018-03-19
D
.
Richard Hip
p
In the com
p
i
l
e
_opti
o
ns prag
m
a,
s
how the actu
a
l value
.
.
.
commit
|
commitdiff
|
tree
2018-03-19
D
.
Richard Hipp
Improved
"
.
selecttrace" output
forma
t
ting
.
No changes
.
.
.
commit
|
commitdiff
|
tree
2018-03-17
D
.
Richard
Hipp
D
o
not use
s
qlite3_colum
n
_de
c
lty
p
e()
in
the CLI if
.
.
.
commit
|
commitdiff
|
tree
2018-03-16
D
.
R
ichard Hipp
Dete
c
t
corruption
i
n the form of the sqlite
_
se
q
u
ence
.
.
.
commit
|
commitdiff
|
tree
2018-03-16
D
.
Richard Hipp
De
t
ect da
t
abases who
s
e
schema is corrupte
d
using a
.
.
.
commit
|
commitdiff
|
tree
2018-03-16
D
.
Richard Hipp
Better error messag
e
text
w
hen the sch
e
m
a
is corru
p
ted
.
.
.
commit
|
commitdiff
|
tree
2018-03-16
D
.
Richard Hipp
Avoid writi
n
g
th
e
sqli
t
e_sequ
e
nce
t
a
b
le when i
t
has
.
.
.
commit
|
commitdiff
|
tree
2018-03-15
D
.
Richar
d
H
i
p
p
Fix a typo
i
n
a
commen
t
u
sed to ge
n
erate documenta
t
ion
.
.
.
commit
|
commitdiff
|
tree
2018-03-15
D
.
Richard
H
i
p
p
Fix
an
issue wit
h
the fsdir() table-valu
e
d
fun
c
tion
.
.
.
commit
|
commitdiff
|
tree
2018-03-14
D
.
Ric
h
ard Hipp
Add the SQ
L
ITE_DBSTATUS_CACHE_S
P
ILL option to sqlite3_db
_
sta
.
.
.
commit
|
commitdiff
|
tree
2018-03-14
D
.
R
ich
a
rd Hipp
D
i
s
a
b
le one
of the
te
s
t ca
s
es f
r
om
c
he
c
k-in [21ecbce1378f3cc
.
.
.
commit
|
commitdiff
|
tree
2018-03-14
D
.
Richard Hi
p
p
A
d
d
the SQL
I
TE_DBSTATUS_CACHE_SPILL option to
s
q
li
t
e3_db_sta
.
.
.
commit
|
commitdiff
|
tree
2018-03-10
D
.
Richa
r
d Hipp
F
ix
the
s
econd
c
al
l
back argume
n
t to the "profile" response
.
.
.
commit
|
commitdiff
|
tree
2018-03-10
D
.
Ri
c
h
a
r
d Hipp
Add support
f
or
I
NSERT OR REPLACE
a
nd INSERT O
R
IGNORE
.
.
.
commit
|
commitdiff
|
tree
2018-03-10
D
.
Richar
d
Hipp
Improved err
o
r messages from
the zipfi
l
e
e
x
ten
s
ion
.
commit
|
commitdiff
|
tree
2018-03-10
D
.
Ric
h
a
rd
Hip
p
Avoid harmless le
f
t-shifts
of nega
t
ive num
b
ers in th
e
.
.
.
commit
|
commitdiff
|
tree
2018-03-10
D
.
R
i
c
hard H
i
pp
Fix
t
he zip
f
i
l
e
extension so that
it is a
b
le
to
creat
e
.
.
.
commit
|
commitdiff
|
tree
2018-03-09
D
.
Richar
d
Hipp
Fi
x
t
h
e
.
a
r
chive command in t
h
e CL
I
so that it
a
ctually
.
.
.
commit
|
commitdiff
|
tree
2018-03-09
D
.
Richard Hip
p
Enhance
the "
.
ar" command in the CLI so
t
h
at it i
s
.
.
.
commit
|
commitdiff
|
tree
2018-03-09
D
.
Richard
Hipp
Setting "
.
s
tats 2" in the CLI caus
e
s
column metadata
.
.
.
commit
|
commitdiff
|
tree
2018-03-09
D
.
Richard Hipp
S
i
mp
l
ification to the sh
e
ll_
e
xec()
m
echan
i
sm in the
.
.
.
commit
|
commitdiff
|
tree
2018-03-09
D
.
Rich
a
rd Hipp
F
ix a test case in
z
ipfile
f
ault
.
test so that it only
.
.
.
commit
|
commitdiff
|
tree
2018-03-09
D
.
R
i
chard
H
ipp
Attempt to fix a
h
a
rmless
c
o
m
p
iler warning from Clang
.
commit
|
commitdiff
|
tree
2018-03-08
D
.
R
i
chard Hipp
Add
the --ap
p
e
nd and --zip option
s
of the CLI to the
.
.
.
commit
|
commitdiff
|
tree
2018-03-08
D
.
Richard Hipp
Updates to doc
u
mentatio
n
o
n
sqlite3_serialize()
a
nd
.
.
.
commit
|
commitdiff
|
tree
2018-03-07
D
.
Richard Hip
p
Add the session
f
uzz test prog
r
a
m
and data obtain
e
d
.
.
.
commit
|
commitdiff
|
tree
2018-03-07
D
.
Richard Hipp
Add the sqli
t
e3_seriali
z
e() and sqlite3_deserialize
.
.
.
commit
|
commitdiff
|
tree
2018-03-07
D
.
Ric
h
a
r
d Hipp
Mar
k
a
n unreach
a
ble branch using NEVE
R
(
)
.
commit
|
commitdiff
|
tree
2018-03-06
D
.
Rich
a
r
d Hipp
Improv
e
d docu
m
entatio
n
for sqlit
e
3_serialize()
a
nd
.
.
.
commit
|
commitdiff
|
tree
2018-03-06
D
.
Rich
a
rd
H
i
pp
Ha
n
dle some boundary cases in me
m
db ass
o
ciated with
.
.
.
commit
|
commitdiff
|
tree
2018-03-06
D
.
Ri
c
hard
H
ipp
Simplificat
i
o
ns to the memdb
V
FS
.
commit
|
commitdiff
|
tree
2018-03-06
D
.
Richard Hipp
Improvem
e
nts to
the
memdb VFS
.
commit
|
commitdiff
|
tree
2018-03-06
D
.
Richard Hi
p
p
Merge the wa
l
Iterat
o
r
Init() fix fro
m
trunk
.
commit
|
commitdiff
|
tree
2018-03-05
D
.
Rich
a
rd H
i
pp
Fix
w
alIterator
I
nit(
)
s
o tha
t
it al
w
ays leaves the
.
.
.
commit
|
commitdiff
|
tree
2018-03-05
D
.
R
ichard Hipp
Me
r
g
e the sess
i
on
f
ix from trun
k
.
commit
|
commitdiff
|
tree
2018-03-05
D
.
Richar
d
Hipp
I
mproved
comm
a
nd-line help for the -A option
o
n the
.
.
.
commit
|
commitdiff
|
tree
2018-03-05
D
.
Ri
c
h
ard Hipp
A new
w
a
y
of doin
g
ar
c
hive commands on
t
h
e
c
omma
n
d
.
.
.
commit
|
commitdiff
|
tree
2018-03-05
D
.
Ri
c
hard H
i
p
p
In th
e
C
LI,
a
d
d a
new command-lin
e
o
pt
i
o
n "--a
r
chive
.
.
.
commit
|
commitdiff
|
tree
2018-03-05
D
.
Richa
r
d Hipp
Merge session f
i
xes fr
o
m
t
r
unk
.
commit
|
commitdiff
|
tree
2018-03-01
D
.
Richard
H
i
p
p
Allow the zSche
m
a argument to sql
i
te3_serialize() to
.
.
.
commit
|
commitdiff
|
tree
2018-03-01
D
.
Richard H
i
pp
Merge
th
e
latest enhancements
f
rom trunk
.
commit
|
commitdiff
|
tree
2018-02-28
D
.
Richard
Hipp
Enhance the
sess
i
ons
d
o
cumentation
to show the methods
.
.
.
commit
|
commitdiff
|
tree
2018-02-28
D
.
Ric
h
ard Hipp
Use <pre> around code snippets in the document
a
tio
n
.
.
.
commit
|
commitdiff
|
tree
2018-02-28
D
.
Richard Hipp
Fi
x
a
potential N
U
LL poin
t
er de
r
ef follo
w
ing OOM in
.
.
.
commit
|
commitdiff
|
tree
2018-02-27
D
.
Richard H
i
pp
Add
s
u
p
p
o
rt for TRUE a
n
d FALSE keywor
d
s and for op
e
rators
.
.
.
commit
|
commitdiff
|
tree
2018-02-27
D
.
Richard Hipp
C
lean up
co
m
m
ents and variable nam
e
s prior to merge
.
commit
|
commitdiff
|
tree
2018-02-27
D
.
R
ichard Hipp
Remove
an un
n
ece
s
sary decision
.
commit
|
commitdiff
|
tree
2018-02-26
D
.
Richard Hip
p
Code
s
impli
f
icat
i
o
n
s
.
New test cases
.
commit
|
commitdiff
|
tree
2018-02-26
D
.
Richard
Hipp
G
et the
"DEFAUL
T
true
"
and "DEFAU
L
T false" phr
a
ses
.
.
.
commit
|
commitdiff
|
tree
2018-02-26
D
.
R
i
ch
a
rd
Hipp
E
n
hance
TreeView
s
o that it can disp
l
ay the
n
ew IS
.
.
.
commit
|
commitdiff
|
tree
2018-02-26
D
.
Ric
h
ard
Hipp
Refact
o
r for correct NULL handling in the
I
S TR
U
E,
.
.
.
commit
|
commitdiff
|
tree
2018-02-26
D
.
Rich
a
rd H
i
pp
M
e
r
g
e th
e
fix for
d
eter
m
inin
g
t
ruth of f
l
oat
i
ng point
.
.
.
commit
|
commitdiff
|
tree
2018-02-26
D
.
Richard
Hipp
A
lways i
n
terpr
e
t non-zero
f
lo
a
ting-point
v
al
u
es as
.
.
.
commit
|
commitdiff
|
tree
2018-02-26
D
.
R
i
ch
a
rd Hipp
Experimental impl
e
mentation of IS
T
RUE
and IS FA
L
SE
.
.
.
commit
|
commitdiff
|
tree
2018-02-22
D
.
Richard Hipp
For the "SQLite arch
i
ve" link
in the README
.
md
f
ile
.
.
.
commit
|
commitdiff
|
tree
2018-02-22
D
.
Ri
c
hard Hipp
Up
d
ates to the READM
E
.
md
f
ile
.
Mentio
n
the a
b
i
lity
.
.
.
commit
|
commitdiff
|
tree
2018-02-21
D
.
Richard H
i
pp
Remove an unreachable branch i
n
the
w
alIndexPage(
)
.
.
.
commit
|
commitdiff
|
tree
next