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
Improved
e
r
ro
r
m
e
s
s
a
g
e
s
.
Limit the
n
u
m
ber of auxiliar
y
.
.
.
commit
|
commitdiff
|
tree
2018-05-16
D
.
Richard H
i
pp
Fix an issue w
i
th rtreecheck(
)
and au
x
il
i
ary
data c
o
lumns
.
commit
|
commitdiff
|
tree
2018-05-16
D
.
Rich
a
rd Hi
p
p
Do n
o
t allow
a
uxiliary
columns in t
h
e
rtree to in
t
erfere
.
.
.
commit
|
commitdiff
|
tree
2018-05-16
D
.
Richard Hipp
Fix
the
OOM iss
u
e mentioned in
the previ
o
us check-in
.
commit
|
commitdiff
|
tree
2018-05-16
D
.
Richard
H
ip
p
Initial implementatio
n
of th
e
ability to have aux
i
liary
.
.
.
commit
|
commitdiff
|
tree
2018-05-16
D
.
Richard Hipp
E
n
hance the sqlite3_str_new()
i
n
terface so t
h
at i
t
.
.
.
commit
|
commitdiff
|
tree
2018-05-16
D
.
R
ichard Hipp
Correct outpu
t
for the fu
l
lke
y
col
u
mn of js
o
n_each
.
.
.
commit
|
commitdiff
|
tree
2018-05-14
D
.
R
ichard Hipp
Make mo
r
e aggr
e
ssi
v
e use of automatic in
d
exes when
.
.
.
commit
|
commitdiff
|
tree
2018-05-14
D
.
R
ichard
H
ipp
Conv
e
rt the sche
m
a
c
reation l
o
gic in the rtree extension
.
.
.
commit
|
commitdiff
|
tree
2018-05-14
D
.
Richard Hipp
Export the deduceDatab
a
seTyp
e
() funct
i
on t
h
e s
h
ell
.
.
.
commit
|
commitdiff
|
tree
2018-05-14
D
.
Ri
c
h
a
rd Hi
p
p
Add the --appe
n
d option to the "
.
ba
c
kup" command in
.
.
.
commit
|
commitdiff
|
tree
2018-05-12
D
.
Rich
a
rd Hipp
I
n
the
C
LI, allow comm
e
nt line
s
that begin with
'
#
.
.
.
commit
|
commitdiff
|
tree
2018-05-11
D
.
Richa
r
d
Hipp
In the CLI, return non
-
zero
i
f there are erro
r
s o
n
.
.
.
commit
|
commitdiff
|
tree
2018-05-11
D
.
R
i
chard
H
i
pp
Fix a typo
i
n the help message from the "
.
sha3sum"
.
.
.
commit
|
commitdiff
|
tree
2018-05-11
D
.
Richard
Hipp
Make sure the open
_
db() routine in
th
e
CLI doe
s
not
.
.
.
commit
|
commitdiff
|
tree
2018-05-09
D
.
Richard Hipp
Add 14 new interfaces to the
l
oadable extension
m
e
chanism
.
commit
|
commitdiff
|
tree
2018-05-09
D
.
Ric
h
a
rd
Hipp
Fix minor probl
e
ms w
i
t
h
the sqlite
3
_str interface
.
commit
|
commitdiff
|
tree
2018-05-09
D
.
Richard H
i
pp
Make the inter
n
al dynamic string i
n
te
r
f
a
ce ava
i
lable
.
.
.
commit
|
commitdiff
|
tree
2018-05-09
D
.
Richard Hipp
F
i
x a typo i
n
a com
m
ent
u
s
e
d fo
r
documentation
.
No
.
.
.
commit
|
commitdiff
|
tree
2018-05-08
D
.
Richard H
i
pp
Corre
c
tl
y
f
o
rmat
the STAT1 and STAT
4
conte
n
t in the
.
.
.
commit
|
commitdiff
|
tree
2018-05-08
D
.
R
ichard Hipp
F
ix a
h
a
r
mless co
m
piler wa
r
ning in f
u
z
z
c
heck
.
Add
.
.
.
commit
|
commitdiff
|
tree
2018-05-08
D
.
Rich
a
rd Hi
p
p
Fuzz
t
est cases for UPSER
T
.
commit
|
commitdiff
|
tree
2018-05-07
D
.
Richard Hipp
A
c
tivate the cell-overwrite optimization
f
or
index
.
.
.
commit
|
commitdiff
|
tree
2018-05-07
D
.
Ric
h
ard Hipp
Improve
d
comments on t
h
e cell-over
w
rite optimiza
t
i
o
n
.
.
.
commit
|
commitdiff
|
tree
2018-05-07
D
.
Richa
r
d Hipp
On an U
P
DA
T
E, try to overwr
i
te an existing btree ce
l
l
.
.
.
commit
|
commitdiff
|
tree
2018-05-07
D
.
Richard Hipp
Fix
h
armles
s
c
o
mpiler w
a
rnings associate
d
with th
e
.
.
.
commit
|
commitdiff
|
tree
2018-05-07
D
.
Richard Hipp
Fix harm
l
es
s
compiler w
a
rnin
g
s
i
n t
h
e cell-overwrite
.
.
.
commit
|
commitdiff
|
tree
2018-05-07
D
.
Richard
H
ipp
Ba
c
k
o
ut
change [0
5
f
ee
1
a2
1
ea398f1e4d6f1cf3] becau
s
e
.
.
.
commit
|
commitdiff
|
tree
2018-05-05
D
.
Richard Hipp
In an
ORDER BY LIMIT, ma
k
e sure the
O
R
DER BY expr
e
ssion
.
.
.
commit
|
commitdiff
|
tree
2018-05-05
D
.
Richard
H
i
p
p
Fix a slightly
i
nc
o
r
r
e
ct corr
u
pt
i
on detection branch
.
.
.
commit
|
commitdiff
|
tree
2018-05-04
D
.
Richa
r
d
Hipp
Merge
e
n
hanceme
n
ts from trunk
.
commit
|
commitdiff
|
tree
2018-05-04
D
.
Ric
h
a
rd Hipp
Fix re
q
uirements
mar
k
s
.
No code changes
.
commit
|
commitdiff
|
tree
2018-05-04
D
.
Rich
a
r
d
Hip
p
F
o
r
t
he amal
g
a
mation-tarball, enable F
T
S5 and
J
S
ON1
.
.
.
commit
|
commitdiff
|
tree
2018-05-04
D
.
Ric
h
ard Hipp
Make a separate limb in the EXPLAIN QUERY PLAN output
.
.
.
commit
|
commitdiff
|
tree
2018-05-03
D
.
Richard Hi
p
p
In
O
R
D
E
R B
Y
LIMIT querie
s
,
tr
y
t
o
e
v
alua
t
e
t
he ORDER
.
.
.
commit
|
commitdiff
|
tree
2018-05-03
D
.
Richa
r
d Hipp
Fix a b
r
anch th
a
t has become
u
nrea
c
hable
d
ue to
r
ecen
t
.
.
.
commit
|
commitdiff
|
tree
2018-05-03
D
.
R
i
chard Hipp
Im
p
r
ov
e
d security fo
r
V
AC
U
UM
.
This check-in combines
.
.
.
commit
|
commitdiff
|
tree
2018-05-03
D
.
R
ichard H
i
p
p
O
v
erhaul of EXPLAI
N
Q
UERY PLAN
.
The output
i
s
now
in
.
.
.
commit
|
commitdiff
|
tree
2018-05-03
D
.
Ric
h
ard Hipp
Opti
m
izations to the new
EQ
P
framewor
k
.
commit
|
commitdiff
|
tree
2018-05-03
D
.
Richar
d
Hip
p
F
ix
various error handlin
g
cond
i
tio
n
s
on the cell overwrite
.
.
.
commit
|
commitdiff
|
tree
2018-05-03
D
.
R
ichard Hi
p
p
The BtCu
r
sor
.
i
n
fo field
s
ar
e
only
v
a
l
i
d
i
f i
n
fo
.
nSize!=0
.
commit
|
commitdiff
|
tree
2018-05-03
D
.
Richard Hipp
Add mor
e
corrupt
i
on ch
e
cking to
t
he cell overw
r
ite
.
.
.
commit
|
commitdiff
|
tree
2018-05-03
D
.
Richar
d
Hipp
Bug f
i
xes in the overwrit
e
optimization
.
commit
|
commitdiff
|
tree
2018-05-03
D
.
Richard Hipp
The sqlite3BtreeInsert() ro
u
tine
t
ri
e
s
t
o overwrite
.
.
.
commit
|
commitdiff
|
tree
2018-05-03
D
.
R
i
chard Hipp
Enhance EXPLAIN QU
E
RY PLAN to report the ge
n
er
a
tion
.
.
.
commit
|
commitdiff
|
tree
2018-05-02
D
.
Ric
h
ard Hipp
More
t
est case u
p
dates
.
Test
s
are
a
l
l running now
.
commit
|
commitdiff
|
tree
2018-05-02
D
.
Richard Hip
p
Fi
x
test cases s
o
that they wor
k
with t
h
e
n
ew EX
P
LAIN
.
.
.
commit
|
commitdiff
|
tree
2018-05-02
D
.
R
i
chard H
i
pp
I
mproved
E
QP output
for recu
r
sive CTEs and multi
-
valu
e
.
.
.
commit
|
commitdiff
|
tree
2018-05-02
D
.
Richard Hipp
Prevent VACUUM fr
o
m running an
y
commands
i
n sqlite_ma
s
ter
.
.
.
commit
|
commitdiff
|
tree
2018-05-02
D
.
Richar
d
Hipp
F
ix a
d
angling-else problem that was causing
r
ecursiv
e
.
.
.
commit
|
commitdiff
|
tree
2018-05-02
D
.
Ri
c
hard Hipp
Imp
r
o
vem
e
n
t
s to
the E
Q
P display
f
o
r
compound select
.
.
.
commit
|
commitdiff
|
tree
2018-05-02
D
.
Richard Hipp
B
e
g
in reengineer
i
ng
t
h
e
EX
P
LAI
N
QUERY PLAN fun
c
tion
.
.
.
commit
|
commitdiff
|
tree
2018-05-01
D
.
Richard Hi
p
p
The SQLITE_ALLOW_SQLITE_MA
S
TER_IND
E
X compile-t
i
me
option
.
.
.
commit
|
commitdiff
|
tree
2018-04-30
D
.
Rich
a
rd H
i
pp
Defer l
o
a
d
in
g
re
s
u
lt co
l
umn values into re
g
is
t
ers on
.
.
.
commit
|
commitdiff
|
tree
2018-04-28
D
.
Richard Hipp
Test c
a
ses added for SQLITE
_
DBCONFIG_RESET_DATABASE
.
commit
|
commitdiff
|
tree
2018-04-28
D
.
R
i
chard Hipp
Add the SQLITE
_
DBCONFIG_R
E
SET_DATABASE cont
r
o
l fo
r
.
.
.
commit
|
commitdiff
|
tree
2018-04-28
D
.
Richard Hip
p
Add
t
he SQLITE_
D
BC
O
NFIG_RES
E
T
_DATABASE
control as
a
.
.
.
commit
|
commitdiff
|
tree
2018-04-28
D
.
Rich
a
rd H
i
p
p
Mer
g
e updates from trunk
.
commit
|
commitdiff
|
tree
2018-04-28
D
.
Richard Hipp
Prevent
deep
r
ecursions on nested COLLATE
o
perators
.
commit
|
commitdiff
|
tree
2018-04-28
D
.
Richard
H
ipp
Fix compiler warni
n
gs
i
n FTS3
.
commit
|
commitdiff
|
tree
2018-04-28
D
.
Rich
a
rd
Hipp
Add
the "PRA
G
MA reset_database=ON|OFF"
c
ommand
.
When
.
.
.
commit
|
commitdiff
|
tree
2018-04-27
D
.
Richard Hipp
En
h
ance t
h
e comments in the templatevtab
.
c implementation
.
commit
|
commitdiff
|
tree
2018-04-26
D
.
Richard Hipp
The previous fix f
o
r ticket [
d
85fffd6ffe856092ed
8
da
.
.
.
commit
|
commitdiff
|
tree
2018-04-26
D
.
Richard Hipp
Ensure th
a
t new
.
* va
l
ues
o
f an
UPDAT
E
do not get clob
b
er
e
d
.
.
.
commit
|
commitdiff
|
tree
2018-04-26
D
.
R
i
c
hard Hipp
Clarifica
t
ion of the beh
a
v
ior of a
BE
F
ORE UP
D
A
TE trigger
.
.
.
commit
|
commitdiff
|
tree
2018-04-26
D
.
Ri
c
hard Hipp
Improved VDBE comment on th
e
OP_P
a
ram o
p
code
.
No sub
s
tantia
.
.
.
commit
|
commitdiff
|
tree
2018-04-25
D
.
Richard Hipp
Add new interfaces for accessing the list
of SQL key
w
ords:
commit
|
commitdiff
|
tree
2018-04-25
D
.
R
ichard Hipp
Add the new
D
O
and NOTHING keywords to the keyw
o
rd
.
.
.
commit
|
commitdiff
|
tree
2018-04-25
D
.
Richar
d
Hipp
Ad
d
the new
S
QLITE_
S
HELL_INIT_PROC co
m
pile-time
e
ntry
.
.
.
commit
|
commitdiff
|
tree
2018-04-25
D
.
Ri
c
hard H
i
pp
Avoid
many unnecessary calls
t
o sqlite3Read
S
che
m
a(
.
.
.
commit
|
commitdiff
|
tree
2018-04-25
D
.
R
ich
a
rd Hipp
Add an assert() to
e
ns
u
re that
s
c
h
ema mutex
e
s are h
e
l
d
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
Richard Hipp
D
o
not attempt to use terms from the WH
E
RE clause to
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
Richard Hipp
Update the expe
r
t extension test cases to
a
cc
o
unt for
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
Richa
r
d H
i
pp
All
the OR
op
t
imization t
o
proc
e
e
d even
if th
e
O
R is
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
Richard Hipp
Add
a
hyp
e
rlink t
o
t
he
t
icket
o
n the code
com
m
ent
f
or
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
Rich
a
rd Hip
p
Enhanc
e
th
e
CLI to r
e
n
d
er
EXPL
A
IN QUERY PLAN using
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
Ric
h
ard Hipp
Fix a memory leak follo
w
ing fa
i
lure to open
an e
x
ternal
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
Richard H
i
pp
In E
X
PLAIN QUERY PLAN o
u
tput, do not show an EXECUTE
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
R
ichard Hipp
Fix to check-in [ca34c2dd20
e
e
071e]
-
avoid a NULL poi
n
t
e
r
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Richard Hipp
Fi
x
a
pro
b
l
em in
sqlite3ExprCompare()
associated with
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
R
ichard Hipp
Fix a
form
a
ttin
g
issue in the Tr
e
eV
i
ew output fo
r
b
ar
e
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Richard Hipp
Add the
"
.
i
m
poster off" variant of th
e
"
.
imposter"
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Ric
h
ard Hipp
The "
.
selecttrace
0
x2000" com
m
and causes just
t
he top
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Richard Hipp
The "
.
selec
t
t
race 4" co
m
mand now
shows only a s
i
ngle
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Richard H
i
pp
Do not restore the iSe
l
ect
I
d value until
a
fter the
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Richard Hipp
I
n
the "
.
selecttra
c
e"
output, i
n
clu
d
e the
E
XPLAIN QUERY
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
R
ic
h
ard Hipp
Ensure that there are no bind-parameters or incorrect
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Rich
a
r
d
H
ipp
Fix an u
n
reachabl
e
branch asso
c
iate
d
with s
t
a
c
k overf
l
ow
.
.
.
commit
|
commitdiff
|
tree
2018-04-21
D
.
R
i
char
d
Hipp
Perfo
r
m
ance improvem
e
nts on th
e
main l
o
o
p of the LEMON
.
.
.
commit
|
commitdiff
|
tree
2018-04-21
D
.
Richard Hipp
Enhance LEMO
N
to track w
h
ich symbols actually car
r
y
.
.
.
commit
|
commitdiff
|
tree
2018-04-21
D
.
Richard Hipp
A
d
d the
%
ext
r
a_co
n
text direct
i
ve to lemon, as
a
n alternative
.
.
.
commit
|
commitdiff
|
tree
2018-04-21
D
.
Richard Hipp
Fix
UPS
E
RT so t
h
a
t
i
t
plays ni
c
ely with
A
UTO
I
NC
R
EMENT
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Richard
Hipp
A
d
d t
h
e -dDIRECTORY
c
ommand-line optio
n
to LEMON
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Richard H
i
p
p
F
ix a harmless compiler warn
i
ng
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Ri
c
h
a
rd Hipp
Avoid
t
he use
o
f
statement journal
s
on DELETEs of a
.
.
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Richard Hipp
Av
o
id
o
pening
a
statement
journa
l
on single-ro
w
U
PDATEs
.
.
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Richard Hipp
Fix a VD
B
E comment on u
p
sert
.
Provide an
error message
.
.
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Richa
r
d Hip
p
Avoid unnecessa
r
y cu
r
sor s
e
eking whe
n
performin
g
an
.
.
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Richard
Hipp
I
mproved VDBE
c
o
mment
on UPSERT cod
e
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
R
ic
h
ard Hip
p
Min
o
r simpl
i
fication
o
f the
p
re
v
ious checkin
.
commit
|
commitdiff
|
tree
next