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
Improved error messages. Limit the number of auxiliary columns to 100.
2018-05-18
D
.
Richard Hipp
Imp
r
ove
d
er
r
or messages
.
Limit the
number of auxil
i
ary
.
.
.
commit
|
commitdiff
|
tree
2018-05-16
D
.
Rich
a
rd
Hipp
F
ix an issue wi
t
h rt
r
ee
c
heck()
and auxiliary data columns
.
commit
|
commitdiff
|
tree
2018-05-16
D
.
Rich
a
rd Hipp
Do not allow auxiliar
y
column
s
in the rtree to inter
f
e
re
.
.
.
commit
|
commitdiff
|
tree
2018-05-16
D
.
Ri
c
hard Hipp
Fix the O
O
M i
s
sue
m
en
t
i
o
ned in the prev
i
o
u
s check
-
in
.
commit
|
commitdiff
|
tree
2018-05-16
D
.
R
ic
h
ard Hipp
I
n
i
t
ial
i
mplementation of the a
b
i
l
i
ty to
h
ave
auxiliary
.
.
.
commit
|
commitdiff
|
tree
2018-05-16
D
.
Richard Hipp
E
n
hance the sqlite3_str_new() inter
f
ace so that it
.
.
.
commit
|
commitdiff
|
tree
2018-05-16
D
.
Richard Hip
p
Correct
output f
o
r the f
u
llk
e
y
c
olum
n
of json_each
.
.
.
commit
|
commitdiff
|
tree
2018-05-14
D
.
Richard Hipp
Make m
o
re aggressive use
o
f
automatic inde
x
es wh
e
n
.
.
.
commit
|
commitdiff
|
tree
2018-05-14
D
.
Ric
h
ard Hipp
C
o
nvert the schema creat
i
on
l
ogic in the rtree extension
.
.
.
commit
|
commitdiff
|
tree
2018-05-14
D
.
Richard H
i
pp
Exp
o
rt the deduceDatab
a
seType() fu
n
ctio
n
the shell
.
.
.
commit
|
commitdiff
|
tree
2018-05-14
D
.
Richard Hipp
A
d
d t
h
e
-
-
ap
p
end
o
ption to
t
he
"
.
b
a
ckup
"
comman
d
in
.
.
.
commit
|
commitdiff
|
tree
2018-05-12
D
.
Richard Hipp
In the CLI, a
l
low comment lines that beg
i
n with
'
#
.
.
.
commit
|
commitdiff
|
tree
2018-05-11
D
.
Richard
H
i
pp
I
n the CLI, return non-zero i
f
there ar
e
errors
on
.
.
.
commit
|
commitdiff
|
tree
2018-05-11
D
.
R
i
c
h
ard Hi
p
p
F
i
x a t
y
po in the help
message fro
m
the "
.
sha
3
s
um"
.
.
.
commit
|
commitdiff
|
tree
2018-05-11
D
.
R
i
c
h
ard Hipp
Make sure th
e
o
pen_db
(
) routine
in the CLI
d
oe
s
not
.
.
.
commit
|
commitdiff
|
tree
2018-05-09
D
.
Richard Hi
p
p
Add 1
4
new interf
a
ces to t
h
e l
o
adable extension me
c
hanis
m
.
commit
|
commitdiff
|
tree
2018-05-09
D
.
R
i
c
hard H
i
pp
Fi
x
min
o
r p
r
oblems with the sqlite
3
_str int
e
rf
a
ce
.
commit
|
commitdiff
|
tree
2018-05-09
D
.
Richard Hipp
Mak
e
th
e
interna
l
dynamic
s
tring interface available
.
.
.
commit
|
commitdiff
|
tree
2018-05-09
D
.
R
ichard
Hipp
Fix a typo in a
comment
used
f
or
d
ocumentat
i
on
.
No
.
.
.
commit
|
commitdiff
|
tree
2018-05-08
D
.
Richard Hipp
Corre
c
t
l
y
format the STAT1
a
nd S
T
AT
4
con
t
ent in the
.
.
.
commit
|
commitdiff
|
tree
2018-05-08
D
.
Ri
c
hard Hipp
Fix a har
m
l
e
ss compiler
w
arning in
fuzzcheck
.
Add
.
.
.
commit
|
commitdiff
|
tree
2018-05-08
D
.
Ri
c
hard Hipp
Fuzz test c
a
s
e
s
f
o
r
UPSERT
.
commit
|
commitdiff
|
tree
2018-05-07
D
.
Richard Hipp
Activat
e
the c
e
ll-overwrite optimization for index
.
.
.
commit
|
commitdiff
|
tree
2018-05-07
D
.
Ric
h
ard Hip
p
Improved
c
omments on
t
he
c
e
ll-overwr
i
te optim
i
zation
.
.
.
commit
|
commitdiff
|
tree
2018-05-07
D
.
Richard Hipp
On an UPDATE,
t
r
y
to overwrite an
e
x
i
s
ting
b
tree cell
.
.
.
commit
|
commitdiff
|
tree
2018-05-07
D
.
Richard Hipp
Fix harmless co
m
pi
l
er war
n
i
ngs associated with the
.
.
.
commit
|
commitdiff
|
tree
2018-05-07
D
.
Richard Hipp
F
ix
harmless comp
i
ler
w
a
r
nings in
the cell-overwrite
.
.
.
commit
|
commitdiff
|
tree
2018-05-07
D
.
Richard Hip
p
Backout change [05fee1a21e
a
3
9
8f
1
e4d6f1c
f
3] because
.
.
.
commit
|
commitdiff
|
tree
2018-05-05
D
.
Ric
h
ard
H
ipp
In an ORDER B
Y
LIMIT,
m
ake su
r
e
the OR
D
ER BY exp
r
ession
.
.
.
commit
|
commitdiff
|
tree
2018-05-05
D
.
Richard Hipp
Fix a slightly incorrect corrupt
i
on detect
i
o
n
br
a
nch
.
.
.
commit
|
commitdiff
|
tree
2018-05-04
D
.
Richard Hip
p
Merge enhancements from tr
u
nk
.
commit
|
commitdiff
|
tree
2018-05-04
D
.
Richard Hipp
F
ix
r
e
quirements marks
.
No
c
o
d
e changes
.
commit
|
commitdiff
|
tree
2018-05-04
D
.
Richard Hipp
For the ama
l
gamat
i
on
-
tarb
a
ll, e
n
able FTS5 and
JSO
N
1
.
.
.
commit
|
commitdiff
|
tree
2018-05-04
D
.
Richard Hi
p
p
Mak
e
a
s
epa
r
ate limb
i
n t
h
e EXPLAIN QUERY PLAN out
p
ut
.
.
.
commit
|
commitdiff
|
tree
2018-05-03
D
.
R
ic
h
ard Hipp
I
n
ORD
E
R
BY LIMIT qu
e
ri
e
s, try t
o
evaluat
e
the ORDER
.
.
.
commit
|
commitdiff
|
tree
2018-05-03
D
.
Richard Hipp
Fix a
b
ranch that has be
c
o
me un
r
eachab
l
e due to recent
.
.
.
commit
|
commitdiff
|
tree
2018-05-03
D
.
R
i
c
h
a
rd Hip
p
Improved
s
ec
u
rity f
o
r VACUUM
.
This check-in co
m
bine
s
.
.
.
commit
|
commitdiff
|
tree
2018-05-03
D
.
Ri
c
hard H
i
pp
O
verhaul of EXPLAIN
Q
UERY P
L
AN
.
T
he
o
ut
p
ut is now in
.
.
.
commit
|
commitdiff
|
tree
2018-05-03
D
.
Ri
c
hard Hi
p
p
Optimizations to the new EQP framework
.
commit
|
commitdiff
|
tree
2018-05-03
D
.
Richard Hipp
Fix
vari
o
us error handling conditions on t
h
e cell ov
e
rwri
t
e
.
.
.
commit
|
commitdiff
|
tree
2018-05-03
D
.
R
ichard Hipp
T
he
BtCurso
r
.
i
nfo fi
e
lds are on
l
y valid if info
.
nSiz
e
!=
0
.
commit
|
commitdiff
|
tree
2018-05-03
D
.
Richard Hipp
Add
mor
e
corruption ch
e
cking to t
h
e cell overwrite
.
.
.
commit
|
commitdiff
|
tree
2018-05-03
D
.
Richa
r
d Hipp
Bug fixe
s
in
t
h
e
overwrite opti
m
ization
.
commit
|
commitdiff
|
tree
2018-05-03
D
.
Richard Hipp
T
h
e sqlite3B
t
reeInsert() routine t
r
ies to
overwrite
.
.
.
commit
|
commitdiff
|
tree
2018-05-03
D
.
Richa
r
d Hipp
E
n
hance EXPLAIN QUER
Y
PLAN to r
e
port
the gen
e
ration
.
.
.
commit
|
commitdiff
|
tree
2018-05-02
D
.
Richard Hipp
Mo
r
e test
c
ase update
s
.
Tests ar
e
all r
u
n
ning
n
ow
.
commit
|
commitdiff
|
tree
2018-05-02
D
.
Richard Hipp
F
i
x test cases so t
h
at they work with the new
EXPLAIN
.
.
.
commit
|
commitdiff
|
tree
2018-05-02
D
.
Richard
H
ipp
Improved EQP output
f
or recursive CTEs and multi-va
l
ue
.
.
.
commit
|
commitdiff
|
tree
2018-05-02
D
.
Richard Hipp
Pre
v
e
n
t VACUUM from runn
i
ng a
n
y com
m
ands in sq
l
ite_master
.
.
.
commit
|
commitdiff
|
tree
2018-05-02
D
.
Richa
r
d
Hipp
Fix a
d
angling-else p
r
oble
m
that
w
as causing recursive
.
.
.
commit
|
commitdiff
|
tree
2018-05-02
D
.
Richar
d
H
ipp
Improvements to the EQP
dis
p
lay
f
or comp
o
und select
.
.
.
commit
|
commitdiff
|
tree
2018-05-02
D
.
Ric
h
ar
d
Hipp
Begin reengineering the EXPLAIN
Q
UERY
P
LAN
func
t
ion
.
.
.
commit
|
commitdiff
|
tree
2018-05-01
D
.
Richard Hipp
The SQ
L
ITE_ALLO
W
_SQL
I
TE_
M
ASTER_INDEX comp
i
le-time op
t
i
on
.
.
.
commit
|
commitdiff
|
tree
2018-04-30
D
.
Ric
h
ard
H
ipp
Defer loadin
g
res
u
lt column values into registers
on
.
.
.
commit
|
commitdiff
|
tree
2018-04-28
D
.
R
ichard
H
i
p
p
T
e
st cases
a
d
ded for
S
QLITE
_
DBCONFIG_R
E
S
ET_DATABASE
.
commit
|
commitdiff
|
tree
2018-04-28
D
.
Ric
h
ard Hip
p
Add the SQLI
T
E_DBCONFIG
_
RESET_DA
T
ABASE con
t
rol for
.
.
.
commit
|
commitdiff
|
tree
2018-04-28
D
.
Richard
H
ipp
Ad
d
the SQLITE_DBCONFIG_RES
E
T_DATABASE c
o
ntrol as a
.
.
.
commit
|
commitdiff
|
tree
2018-04-28
D
.
Richard
Hipp
Merge updates from trunk
.
commit
|
commitdiff
|
tree
2018-04-28
D
.
Ric
h
ard H
i
pp
Prevent deep recursions on nested
COLLATE o
p
e
rat
o
rs
.
commit
|
commitdiff
|
tree
2018-04-28
D
.
R
ichard
H
i
p
p
Fix co
m
piler war
n
ings in FTS3
.
commit
|
commitdiff
|
tree
2018-04-28
D
.
R
i
chard H
i
pp
Add the
"PRA
G
MA reset_
d
atabase
=
ON|OFF"
command
.
When
.
.
.
commit
|
commitdiff
|
tree
2018-04-27
D
.
Rich
a
rd Hip
p
Enhance the comments
i
n the templatevtab
.
c
i
m
p
l
em
e
ntation
.
commit
|
commitdiff
|
tree
2018-04-26
D
.
Ric
h
ard Hipp
The previo
u
s f
i
x for
t
icket [d85ff
f
d
6ffe856092ed
8
da
.
.
.
commit
|
commitdiff
|
tree
2018-04-26
D
.
Rich
a
r
d H
i
p
p
E
n
s
u
r
e
t
hat new
.
*
v
alues of a
n
U
P
DATE
do not get clobbered
.
.
.
commit
|
commitdiff
|
tree
2018-04-26
D
.
Rich
a
rd
Hipp
Clarification of the
b
ehavior of a BEFORE
UPDATE t
r
i
g
ge
r
.
.
.
commit
|
commitdiff
|
tree
2018-04-26
D
.
Richard Hipp
Im
p
roved VDBE commen
t
on the OP_Para
m
opcode
.
No s
u
bsta
n
t
ia
.
.
.
commit
|
commitdiff
|
tree
2018-04-25
D
.
Richard Hipp
Add new in
t
erfaces for a
c
ces
s
ing
the li
s
t
of SQL ke
y
words:
commit
|
commitdiff
|
tree
2018-04-25
D
.
Richard Hipp
Add the new DO a
n
d NO
T
HING keywords
t
o the k
e
yword
.
.
.
commit
|
commitdiff
|
tree
2018-04-25
D
.
Richard Hipp
Add the new SQ
L
ITE_SHELL_I
N
I
T
_PROC
c
ompile-time entry
.
.
.
commit
|
commitdiff
|
tree
2018-04-25
D
.
Richar
d
Hipp
A
v
oid many unne
c
essary calls to sqlit
e
3R
e
a
d
Schema(
.
.
.
commit
|
commitdiff
|
tree
2018-04-25
D
.
Richard Hipp
Add a
n
assert() to ensure th
a
t schema mutexes are held
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
Richa
r
d
H
ip
p
Do not attempt to use terms from the WHERE clause to
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
Rich
a
rd
H
ipp
Update the expert
e
xtension test
c
ase
s
to ac
c
o
unt for
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
Richard Hipp
All the OR opti
m
ization to proceed even if the OR is
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
Richard Hip
p
Ad
d
a
h
yperlink to the
ticke
t
on the code comment for
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
Richa
r
d Hipp
Enhance
t
he
C
LI
to render EXPLA
I
N QUERY
PLAN using
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
R
ich
a
rd Hipp
Fix a
memory
l
eak fol
l
owing failure to open a
n
ex
t
ernal
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
R
i
c
hard Hi
p
p
In EX
P
LAIN QUERY PLAN outpu
t
, do not sho
w
an EXECUTE
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
Ri
c
hard Hipp
Fix
to check-
i
n [ca34
c
2
d
d20ee071e] -
avoi
d
a NULL point
e
r
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
R
ich
a
r
d
Hipp
F
ix a pro
b
lem in
s
qlite3ExprCompa
r
e() associat
e
d
w
i
t
h
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Richard Hipp
Fix a
f
ormatti
n
g issue in the Tr
e
e
View output fo
r
bare
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Richard Hipp
Add
the "
.
imposte
r
off" varia
n
t of the
"
.
impo
s
ter
"
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
R
i
cha
r
d
Hi
p
p
The "
.
selecttrace
0x200
0
"
com
m
and
c
au
s
e
s
j
ust
the top
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
R
i
ch
a
rd Hipp
The
"
.
selecttrace 4" command now shows only a sing
l
e
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Richard H
i
pp
Do no
t
restore the iSelectId value
u
ntil after the
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Richard Hipp
In the
"
.
se
l
ecttrace" output, include the EXPLAIN QU
E
RY
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Rich
a
rd Hipp
E
n
s
ure that the
r
e are no bind-parame
t
ers or
i
nc
o
rrect
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Richard Hipp
Fix an unreach
a
b
l
e br
a
nch ass
o
ciate
d
with stack o
v
er
f
low
.
.
.
commit
|
commitdiff
|
tree
2018-04-21
D
.
Richard Hipp
Pe
r
formance improvements on the main lo
o
p of the L
E
MON
.
.
.
commit
|
commitdiff
|
tree
2018-04-21
D
.
Richard H
i
p
p
Enha
n
ce LEMON to track whic
h
symbol
s
actuall
y
carry
.
.
.
commit
|
commitdiff
|
tree
2018-04-21
D
.
Ri
c
hard Hipp
Add the %extra_con
t
ext direc
t
ive
t
o
lemon, as an alter
n
ative
.
.
.
commit
|
commitdiff
|
tree
2018-04-21
D
.
Richar
d
Hipp
F
ix UPS
E
RT so that
i
t
p
lays nic
e
l
y
with AUTOIN
C
REMEN
T
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Richard Hip
p
Add the -dDIRECTORY command-li
n
e option to LE
M
ON
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
R
ichard Hipp
Fix
a harm
l
ess com
p
iler warning
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Richard Hi
p
p
A
voi
d
t
h
e
u
se of statement journals on DELETEs of a
.
.
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Ri
c
hard Hipp
Avoid opening a sta
t
ement journa
l
on single-row UPDATEs
.
.
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Richa
r
d Hipp
F
ix
a
VDBE
com
m
ent
o
n upsert
.
P
ro
v
i
d
e an erro
r
me
s
sage
.
.
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Richa
r
d Hipp
Av
o
id unnecessary
c
ur
s
or seeking w
h
en pe
r
forming an
.
.
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Rich
a
rd
H
ipp
I
m
prov
e
d
VD
B
E com
m
ent on
UPSERT co
d
e
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Richard Hi
p
p
Minor
s
i
m
p
lificatio
n
of th
e
previous
c
hec
k
in
.
commit
|
commitdiff
|
tree
next