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
Fix UPSERT so that it plays nicely with AUTOINCREMENT.
2018-03-24
D
.
Richard Hip
p
Pre
p
end
linkage macros to the sql
i
t
e3rebaser interfa
c
es
.
commit
|
commitdiff
|
tree
2018-03-23
D
.
R
ichard
Hipp
Fix the -
r
ead
o
nl
y
option on the CLI so tha
t
it ac
t
uall
y
.
.
.
commit
|
commitdiff
|
tree
2018-03-23
D
.
Richard Hip
p
Fix typo in
a
co
m
me
n
t
u
s
ed for docum
e
ntation
.
No ch
a
nges
.
.
.
commit
|
commitdiff
|
tree
2018-03-23
D
.
Richard Hi
p
p
Fi
x
an error in the CLI in
t
he pre
v
ious ([0249d9aecf699
4
8
.
.
.
commit
|
commitdiff
|
tree
2018-03-23
D
.
Ric
h
ard Hipp
F
ix the ANALYZ
E
command
s
o that it
w
ill process tables
.
.
.
commit
|
commitdiff
|
tree
2018-03-22
D
.
Richar
d
Hi
p
p
Add the left join stre
n
gth red
u
ction optimization
.
.
.
.
commit
|
commitdiff
|
tree
2018-03-22
D
.
Ri
c
hard Hip
p
A
dd t
h
e --valid-sql
o
ption t
o
th
e
optfuzz test
program
.
commit
|
commitdiff
|
tree
2018-03-21
D
.
Richa
r
d Hipp
Get
t
he o
p
tf
u
zz program wo
r
king
.
commit
|
commitdiff
|
tree
2018-03-21
D
.
R
i
c
h
a
rd Hipp
Add th
e
optfuzz
.
c program f
o
r
verifying the que
r
y planne
r
.
.
.
commit
|
commitdiff
|
tree
2018-03-21
D
.
Richard Hipp
R
e
lax LEFT-JOIN restrict
i
ons on
the push-do
w
n
optimiz
a
t
ion
.
commit
|
commitdiff
|
tree
2018-03-20
D
.
Richard H
i
pp
Do a more thorough jo
b
of cleaning
t
races of the strength
.
.
.
commit
|
commitdiff
|
tree
2018-03-20
D
.
Richa
r
d
H
i
p
p
If
t
erms of the WHERE
c
l
au
s
e require tha
t
the
right
.
.
.
commit
|
commitdiff
|
tree
2018-03-20
D
.
Richard H
i
pp
Fix
i
ncorrect testca
s
e
l
abels on two cases in join5
.
.
.
commit
|
commitdiff
|
tree
2018-03-20
D
.
Richa
r
d Hipp
I
mpro
v
ements
to th
e
HAV
I
NG-to-
W
HERE optimization
.
.
.
.
commit
|
commitdiff
|
tree
2018-03-20
D
.
Richard Hipp
Avoid unneces
s
ary write to
t
he sqlit
e
_seq
u
e
n
c
e
table
.
.
.
commit
|
commitdiff
|
tree
2018-03-20
D
.
Richard Hipp
A
dd the abi
l
i
t
y to dis
a
ble the push-down optimizatio
n
.
.
.
commit
|
commitdiff
|
tree
2018-03-20
D
.
Richard Hipp
Remove a debugg
i
ng statem
e
nt acc
i
dently le
f
t in
commit
|
commitdiff
|
tree
2018-03-20
D
.
Richard Hipp
I
n
the C
L
I, av
o
id e
x
t
ra
.
selecttrace and
.
where
t
rac
e
.
.
.
commit
|
commitdiff
|
tree
2018-03-20
D
.
Richard
Hipp
Closer reading of t
h
e sqlite3_db_config() doc
u
mentat
i
on
.
.
.
commit
|
commitdiff
|
tree
2018-03-20
D
.
R
i
c
h
ard Hipp
F
i
x a minor formatti
n
g issue on the sqlite3_db_config
.
.
.
commit
|
commitdiff
|
tree
2018-03-20
D
.
Richard
Hipp
Add t
h
e abilit
y
to di
s
a
b
le
t
h
e push-dow
n
optimization
.
.
.
commit
|
commitdiff
|
tree
2018-03-19
D
.
Richard
Hipp
Minor i
m
prov
e
ments t
o
"
.
selecttrace"
.
No changes to
.
.
.
commit
|
commitdiff
|
tree
2018-03-19
D
.
Ric
h
ard Hipp
Enhance
t
he command-line completion e
x
t
e
n
s
ion to re
t
u
r
n
.
.
.
commit
|
commitdiff
|
tree
2018-03-19
D
.
Richard Hipp
In the co
m
p
ile_options pragma, show the
a
ctual value
.
.
.
commit
|
commitdiff
|
tree
2018-03-19
D
.
Richard Hipp
I
mp
r
oved
"
.
selecttrac
e
" outpu
t
forma
t
ting
.
No ch
a
n
g
es
.
.
.
commit
|
commitdiff
|
tree
2018-03-17
D
.
Richard Hip
p
Do
n
ot use sq
l
ite3_co
l
umn_de
c
ltyp
e
() in
t
he CLI if
.
.
.
commit
|
commitdiff
|
tree
2018-03-16
D
.
Richard Hipp
Det
e
ct corr
u
ption
in the form
of the sqlite_sequenc
e
.
.
.
commit
|
commitdiff
|
tree
2018-03-16
D
.
Ric
h
ard
H
i
pp
Detect da
t
abases whose schema is cor
r
upt
e
d using a
.
.
.
commit
|
commitdiff
|
tree
2018-03-16
D
.
Richa
r
d Hipp
Better erro
r
mes
s
age text when the schema is corrupted
.
.
.
commit
|
commitdiff
|
tree
2018-03-16
D
.
Ric
h
ard Hipp
Av
o
id writing th
e
sqlite_se
q
u
ence t
a
ble when it has
.
.
.
commit
|
commitdiff
|
tree
2018-03-15
D
.
R
i
chard
H
ipp
Fix a typo
i
n a comment used
t
o generate documen
t
ati
o
n
.
.
.
commit
|
commitdiff
|
tree
2018-03-15
D
.
Richard
Hipp
Fix a
n
iss
u
e
wi
t
h the fs
d
ir() table
-
valued funct
i
on
.
.
.
commit
|
commitdiff
|
tree
2018-03-14
D
.
Richard Hipp
A
dd the SQLI
T
E
_
DBSTATU
S
_CACHE_SPILL option to sqlite3_db_sta
.
.
.
commit
|
commitdiff
|
tree
2018-03-14
D
.
Richar
d
H
ipp
D
i
sable one
of t
h
e test cases from ch
e
ck-in [21ecbce1378f3cc
.
.
.
commit
|
commitdiff
|
tree
2018-03-14
D
.
R
ichar
d
Hipp
A
dd th
e
S
QLITE_DBS
T
AT
U
S_CACHE_
S
PILL
option to sq
l
i
t
e3_db_sta
.
.
.
commit
|
commitdiff
|
tree
2018-03-10
D
.
Rich
a
rd Hipp
F
ix the s
e
cond call
b
ac
k
ar
g
ument to
t
h
e
"profile" r
e
sponse
.
.
.
commit
|
commitdiff
|
tree
2018-03-10
D
.
Ri
c
hard Hipp
Add support for IN
S
ER
T
OR
REPLAC
E
and
I
NSERT
OR I
G
NORE
.
.
.
commit
|
commitdiff
|
tree
2018-03-10
D
.
Ri
c
hard H
i
pp
Improved er
r
or messages f
r
om
t
h
e
zipfile extension
.
commit
|
commitdiff
|
tree
2018-03-10
D
.
Rich
a
rd Hipp
Av
o
id h
a
r
m
less left-s
h
ifts
o
f negative
n
um
b
ers in th
e
.
.
.
commit
|
commitdiff
|
tree
2018-03-10
D
.
Richard
H
ipp
Fix
the z
i
pfile extensi
o
n
so
t
hat it is able to cre
a
te
.
.
.
commit
|
commitdiff
|
tree
2018-03-09
D
.
Rich
a
rd Hipp
F
ix the
.
arch
i
v
e
c
ommand
in th
e
CLI so that it actually
.
.
.
commit
|
commitdiff
|
tree
2018-03-09
D
.
R
i
c
h
a
rd Hipp
E
n
hance the "
.
ar" command in the CLI so
t
hat it is
.
.
.
commit
|
commitdiff
|
tree
2018-03-09
D
.
Rich
a
r
d Hipp
S
etting "
.
s
t
ats 2" in the CLI cau
s
es co
l
umn metadata
.
.
.
commit
|
commitdiff
|
tree
2018-03-09
D
.
Richard Hipp
S
i
mplification to
th
e
shell_ex
e
c
(
) mechan
i
sm in the
.
.
.
commit
|
commitdiff
|
tree
2018-03-09
D
.
R
ichar
d
Hipp
Fix a
t
est case
i
n z
i
pfil
e
fault
.
test so tha
t
i
t
o
nly
.
.
.
commit
|
commitdiff
|
tree
2018-03-09
D
.
R
i
c
h
ard Hipp
Attempt to fix a harmless
com
p
iler
warn
i
ng fro
m
Clang
.
commit
|
commitdiff
|
tree
2018-03-08
D
.
Richa
r
d H
i
pp
Ad
d
the --appen
d
and --zip opt
i
ons of the CLI to
t
he
.
.
.
commit
|
commitdiff
|
tree
2018-03-08
D
.
Richard Hipp
Updates to do
c
umentat
i
on on sqlite3_se
r
ializ
e
()
a
n
d
.
.
.
commit
|
commitdiff
|
tree
2018-03-07
D
.
Ri
c
hard Hipp
Add
t
he sessionfuzz test program
and data obtaine
d
.
.
.
commit
|
commitdiff
|
tree
2018-03-07
D
.
Richard Hipp
A
d
d the
s
qlite3_s
e
rialize() and sqlite3_deseriali
z
e
.
.
.
commit
|
commitdiff
|
tree
2018-03-07
D
.
Richard Hipp
Mark an unreachable branch using NEVER()
.
commit
|
commitdiff
|
tree
2018-03-06
D
.
R
ich
a
rd Hipp
Improved documentation for sqlite3_seri
a
l
i
ze() and
.
.
.
commit
|
commitdiff
|
tree
2018-03-06
D
.
Richard H
i
p
p
Handle so
m
e boundary cases in memdb associa
t
ed wi
t
h
.
.
.
commit
|
commitdiff
|
tree
2018-03-06
D
.
Richard Hipp
Simplifications to t
h
e m
e
mdb VFS
.
commit
|
commitdiff
|
tree
2018-03-06
D
.
R
ich
a
r
d
Hipp
Imp
r
ove
m
ents to
t
he m
e
mdb VFS
.
commit
|
commitdiff
|
tree
2018-03-06
D
.
Ric
h
ard
Hipp
Merge the walItera
t
orInit() fi
x
from trunk
.
commit
|
commitdiff
|
tree
2018-03-05
D
.
Richard Hipp
Fix w
a
l
IteratorInit(
)
so tha
t
i
t alwa
y
s leaves t
h
e
.
.
.
commit
|
commitdiff
|
tree
2018-03-05
D
.
Richa
r
d Hipp
Me
r
ge the session
f
ix
f
rom trunk
.
commit
|
commitdiff
|
tree
2018-03-05
D
.
Ric
h
ard Hipp
Impr
o
v
ed co
m
ma
n
d-line help for t
h
e -A op
t
ion on th
e
.
.
.
commit
|
commitdiff
|
tree
2018-03-05
D
.
Richard
H
i
pp
A new w
a
y of do
i
ng
ar
c
hive comma
n
ds on th
e
c
ommand
.
.
.
commit
|
commitdiff
|
tree
2018-03-05
D
.
Richa
r
d Hipp
In the C
L
I, add a new command-line optio
n
"--archive
.
.
.
commit
|
commitdiff
|
tree
2018-03-05
D
.
Richard Hipp
M
er
g
e session f
i
x
e
s from trunk
.
commit
|
commitdiff
|
tree
2018-03-01
D
.
Richa
r
d Hipp
A
llow the zSchema ar
g
ument to sql
i
te
3
_seria
l
ize(
)
to
.
.
.
commit
|
commitdiff
|
tree
2018-03-01
D
.
R
i
chard
Hipp
Merge t
h
e latest enhancements from trunk
.
commit
|
commitdiff
|
tree
2018-02-28
D
.
Ric
h
ard Hipp
En
h
ance
the sessions documentation to show the
methods
.
.
.
commit
|
commitdiff
|
tree
2018-02-28
D
.
Richard Hipp
Use
<pre> around code snip
p
ets
in the documenta
t
ion
.
.
.
commit
|
commitdiff
|
tree
2018-02-28
D
.
Richard Hipp
F
ix a potential NULL pointer
d
eref follo
w
ing
O
OM in
.
.
.
commit
|
commitdiff
|
tree
2018-02-27
D
.
Richard H
i
pp
A
dd support for TRU
E
and FALSE keyw
o
rds
and for operators
.
.
.
commit
|
commitdiff
|
tree
2018-02-27
D
.
R
ichard
H
i
p
p
Clean up comme
n
ts and variable names pri
o
r to merge
.
commit
|
commitdiff
|
tree
2018-02-27
D
.
Richa
r
d H
i
pp
Re
m
ove
an unnece
s
sary decision
.
commit
|
commitdiff
|
tree
2018-02-26
D
.
Richard Hi
p
p
Code simplificat
i
ons
.
New tes
t
ca
s
es
.
commit
|
commitdiff
|
tree
2018-02-26
D
.
R
i
chard Hipp
G
et the "DEFAULT t
r
ue" and "D
E
FAULT false
"
phr
a
ses
.
.
.
commit
|
commitdiff
|
tree
2018-02-26
D
.
Richard Hipp
E
n
han
c
e TreeView
s
o that i
t
can di
s
play the new
IS
.
.
.
commit
|
commitdiff
|
tree
2018-02-26
D
.
Richard Hipp
R
efactor
for co
r
re
c
t NULL
h
a
n
dling in t
h
e IS TR
U
E
,
.
.
.
commit
|
commitdiff
|
tree
2018-02-26
D
.
R
i
chard Hipp
Merge the
fix for determining
t
ruth of floating
p
oint
.
.
.
commit
|
commitdiff
|
tree
2018-02-26
D
.
Richar
d
Hipp
Always i
n
terpre
t
no
n
-z
e
ro f
l
oatin
g
-poin
t
value
s
as
.
.
.
commit
|
commitdiff
|
tree
2018-02-26
D
.
Richard Hipp
Exper
i
me
n
tal implement
a
tion of IS TRU
E
and I
S
FALSE
.
.
.
commit
|
commitdiff
|
tree
2018-02-22
D
.
Richard Hipp
F
o
r the
"
S
Q
Lite a
r
chi
v
e" link
in the README
.
md fi
l
e
.
.
.
commit
|
commitdiff
|
tree
2018-02-22
D
.
Richard Hip
p
Upda
t
es
t
o the README
.
md file
.
M
ention t
h
e ability
.
.
.
commit
|
commitdiff
|
tree
2018-02-21
D
.
R
ichard
H
ip
p
R
e
move an unreachable br
a
nch in
the wal
I
ndexPage()
.
.
.
commit
|
commitdiff
|
tree
2018-02-21
D
.
Rich
a
r
d Hipp
S
mall performance improvement i
n
sqlti
e
3WalFi
n
dF
r
ame()
.
commit
|
commitdiff
|
tree
2018-02-21
D
.
Richard
Hipp
Remove an
unnecessary memset()
.
commit
|
commitdiff
|
tree
2018-02-20
D
.
R
i
chard H
i
pp
Make the w
a
lI
n
dex
P
age() ro
u
tine
a
bout 3x
faster
b
y
.
.
.
commit
|
commitdiff
|
tree
2018-02-20
D
.
Richard Hipp
In the
speed-check
.
sh script,
make
WAL mode
t
he default
.
.
.
commit
|
commitdiff
|
tree
2018-02-20
D
.
Richard
Hi
p
p
Rem
o
ve a superfluous "#if
1
"
.
No logic changes
.
commit
|
commitdiff
|
tree
2018-02-20
D
.
Richard Hipp
Optimi
z
e calls to sqli
t
e3_mprin
t
f
(
"%z
.
.
.
"
)
so that
.
.
.
commit
|
commitdiff
|
tree
2018-02-20
D
.
Richard Hip
p
R
e
move a lot o
f
the
t
e
xt describ
i
ng
ext
e
nded format
.
.
.
commit
|
commitdiff
|
tree
2018-02-19
D
.
Richar
d
H
i
p
p
Enh
a
nc
e
the s
t
ring formatter (used by p
r
intf()) so
.
.
.
commit
|
commitdiff
|
tree
2018-02-19
D
.
R
ichar
d
Hipp
Printing
a value of 0
using %c termin
a
tes the st
r
i
ng
.
commit
|
commitdiff
|
tree
2018-02-19
D
.
Ric
h
ard Hipp
Mo
r
e test
cases
for unicode h
a
n
d
ling in pri
n
tf
.
commit
|
commitdiff
|
tree
2018-02-19
D
.
R
i
chard Hipp
Test cases and
a
bug
f
ix
o
n
the
new
unicode hand
l
i
n
g
.
.
.
commit
|
commitdiff
|
tree
2018-02-19
D
.
Richard Hipp
Fix the %c substitu
t
io
n
in prin
t
f
(
) so that i
t
wor
k
s
.
.
.
commit
|
commitdiff
|
tree
2018-02-19
D
.
Richard Hipp
Make
the alt
e
rnate-form-
2
f
l
ag (
"
!") cha
n
ge t
h
e meaning
.
.
.
commit
|
commitdiff
|
tree
2018-02-19
D
.
R
i
chard
Hipp
In th
e
print
f
(
) library, measure wid
t
h and precision
.
.
.
commit
|
commitdiff
|
tree
2018-02-19
D
.
Richa
r
d
Hipp
On
l
y try
t
o use the
geteuid() inte
r
f
a
ce on unix if
.
.
.
commit
|
commitdiff
|
tree
2018-02-19
D
.
Ric
h
ard H
i
pp
Fix an assert so
that
it com
p
ares two CellInfo obj
e
cts
.
.
.
commit
|
commitdiff
|
tree
2018-02-18
D
.
Richard
H
i
p
p
Fix a memor
y
le
a
k in the process
i
n
g
of neste
d
r
o
w values
.
.
.
commit
|
commitdiff
|
tree
2018-02-15
D
.
R
i
chard
Hipp
Do not allow paramet
e
rs
or schema references ins
i
de
.
.
.
commit
|
commitdiff
|
tree
2018-02-15
D
.
Richar
d
Hipp
Improve p
e
rforma
n
ce of edi
t
dist3()
by keeping the cos
t
s
.
.
.
commit
|
commitdiff
|
tree
2018-02-15
D
.
Richard Hipp
Red
u
c
e the
n
umb
e
r of calls to
s
trncmp() required t
o
.
.
.
commit
|
commitdiff
|
tree
next