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
.
R
ichard Hipp
I
mpr
o
ved er
r
o
r messages
.
Limit the
number
of auxi
l
iary
.
.
.
commit
|
commitdiff
|
tree
2018-05-16
D
.
R
i
c
hard H
i
pp
Fix an
i
ssue
w
i
t
h r
t
reechec
k
()
a
nd auxilia
r
y data columns
.
commit
|
commitdiff
|
tree
2018-05-16
D
.
Richard H
i
pp
Do not allow auxiliar
y
c
o
lumns in
the rtr
e
e to interf
e
re
.
.
.
commit
|
commitdiff
|
tree
2018-05-16
D
.
Richard Hipp
Fix
t
h
e OOM i
s
sue me
n
t
ioned in the previous chec
k
-
in
.
commit
|
commitdiff
|
tree
2018-05-16
D
.
Richard Hipp
Initial impl
e
m
entation
of the ability
to have
a
uxiliary
.
.
.
commit
|
commitdiff
|
tree
2018-05-16
D
.
Richar
d
Hipp
Enhance the sqlite3_str_new() i
n
terface so
t
h
at it
.
.
.
commit
|
commitdiff
|
tree
2018-05-16
D
.
Richa
r
d Hipp
Correct output
f
o
r the fullkey co
l
umn of
json_e
a
ch
.
.
.
commit
|
commitdiff
|
tree
2018-05-14
D
.
R
ichard
H
ipp
M
ake
m
ore aggressive use
of autom
a
tic indexes when
.
.
.
commit
|
commitdiff
|
tree
2018-05-14
D
.
Richard Hipp
Convert the schema creation logic in the
rtree ex
t
ensi
o
n
.
.
.
commit
|
commitdiff
|
tree
2018-05-14
D
.
Ri
c
ha
r
d Hipp
Ex
p
ort the deduceData
b
a
s
e
T
ype() function th
e
shell
.
.
.
commit
|
commitdiff
|
tree
2018-05-14
D
.
Richa
r
d H
i
p
p
Add
t
he --a
p
pend option to the
"
.
backu
p
" command in
.
.
.
commit
|
commitdiff
|
tree
2018-05-12
D
.
Ri
c
h
ard Hipp
In
t
he C
L
I, allow comment lin
e
s that
begin with '#
.
.
.
commit
|
commitdiff
|
tree
2018-05-11
D
.
Ric
h
ard H
i
pp
In the CLI, retur
n
no
n
-z
e
r
o if ther
e
are
e
rrors on
.
.
.
commit
|
commitdiff
|
tree
2018-05-11
D
.
Rich
a
rd Hipp
F
ix a typ
o
i
n the help message from the "
.
sha3s
u
m"
.
.
.
commit
|
commitdiff
|
tree
2018-05-11
D
.
R
ichard Hip
p
Make sure the open_db() rou
t
ine in the CLI does n
o
t
.
.
.
commit
|
commitdiff
|
tree
2018-05-09
D
.
Richard Hipp
Add 14 new
interfac
e
s to t
h
e loadab
l
e e
x
tension mechanis
m
.
commit
|
commitdiff
|
tree
2018-05-09
D
.
Richar
d
Hi
p
p
Fix mi
n
o
r
pro
b
l
ems with the sq
l
ite3
_
str int
e
rfac
e
.
commit
|
commitdiff
|
tree
2018-05-09
D
.
Rich
a
r
d Hipp
Make
the int
e
rn
a
l dynamic string
i
nter
f
a
ce a
v
ailable
.
.
.
commit
|
commitdiff
|
tree
2018-05-09
D
.
Ri
c
hard Hipp
F
i
x a
typo
i
n
a
comment used for docu
m
e
n
tat
i
o
n
.
No
.
.
.
commit
|
commitdiff
|
tree
2018-05-08
D
.
Richa
r
d
Hipp
C
o
rrectly for
m
at t
h
e STAT1
and
S
T
A
T
4
co
n
tent in the
.
.
.
commit
|
commitdiff
|
tree
2018-05-08
D
.
Richar
d
Hipp
Fix a harmless
c
ompiler
war
n
ing in fuz
z
ch
e
c
k
.
A
dd
.
.
.
commit
|
commitdiff
|
tree
2018-05-08
D
.
Rich
a
rd Hipp
Fuzz test
c
a
ses for U
P
SERT
.
commit
|
commitdiff
|
tree
2018-05-07
D
.
Richard Hip
p
Activate t
h
e cell-overwrite
o
p
timiz
a
tion
for in
d
ex
.
.
.
commit
|
commitdiff
|
tree
2018-05-07
D
.
Richard Hip
p
Impr
o
ved comm
e
nts on th
e
ce
l
l-overwrite op
t
imi
z
ation
.
.
.
commit
|
commitdiff
|
tree
2018-05-07
D
.
Richard Hipp
O
n an UPDATE, t
r
y
to overwrit
e
a
n
ex
i
sting btree cell
.
.
.
commit
|
commitdiff
|
tree
2018-05-07
D
.
Richard Hipp
Fix
h
ar
m
l
ess
compiler warnings associate
d
with the
.
.
.
commit
|
commitdiff
|
tree
2018-05-07
D
.
Richard Hipp
F
ix harmless compiler warnings
i
n the cel
l
-overwr
i
te
.
.
.
commit
|
commitdiff
|
tree
2018-05-07
D
.
Richard Hipp
Bac
k
out change [
0
5fee1a21ea398f1e4d6f1cf3] because
.
.
.
commit
|
commitdiff
|
tree
2018-05-05
D
.
Richard Hipp
In an
O
R
D
ER BY LI
M
IT, make
sure the OR
D
ER
BY ex
p
res
s
ion
.
.
.
commit
|
commitdiff
|
tree
2018-05-05
D
.
Richard Hipp
Fix a slightly
i
ncorr
e
ct corruption
detection bran
c
h
.
.
.
commit
|
commitdiff
|
tree
2018-05-04
D
.
Ric
h
ard
Hip
p
Merge enhancements
f
rom trunk
.
commit
|
commitdiff
|
tree
2018-05-04
D
.
Richa
r
d Hipp
Fix requireme
n
t
s
m
arks
.
No
c
ode changes
.
commit
|
commitdiff
|
tree
2018-05-04
D
.
Richa
r
d
Hipp
For
t
h
e amal
g
amat
i
o
n-tarball, enable FTS5 and JSON1
.
.
.
commit
|
commitdiff
|
tree
2018-05-04
D
.
Richard H
i
p
p
M
ake a separate l
i
mb
i
n
the EXPLA
I
N
Q
U
E
R
Y
PLAN outp
u
t
.
.
.
commit
|
commitdiff
|
tree
2018-05-03
D
.
Rich
a
rd Hip
p
In ORDER B
Y
LIMIT queries,
t
r
y to
evaluate the ORDER
.
.
.
commit
|
commitdiff
|
tree
2018-05-03
D
.
Richard Hipp
Fix a
b
ranch
th
a
t
has beco
m
e
unre
a
c
ha
b
le due
t
o
r
e
c
ent
.
.
.
commit
|
commitdiff
|
tree
2018-05-03
D
.
Richar
d
Hipp
Im
p
r
ove
d
security for V
A
CUUM
.
This check-in combines
.
.
.
commit
|
commitdiff
|
tree
2018-05-03
D
.
Richard
H
ipp
O
verhau
l
of EXPL
A
IN Q
U
E
R
Y
P
LAN
.
The ou
t
put is now in
.
.
.
commit
|
commitdiff
|
tree
2018-05-03
D
.
Richard Hipp
Op
t
im
i
zations t
o
the new EQP framework
.
commit
|
commitdiff
|
tree
2018-05-03
D
.
Richard Hipp
F
ix various error h
a
ndling
co
n
dit
i
ons on the cell overwrite
.
.
.
commit
|
commitdiff
|
tree
2018-05-03
D
.
Richard Hip
p
The BtCursor
.
info f
i
elds are o
n
ly
v
alid if info
.
nSize!=
0
.
commit
|
commitdiff
|
tree
2018-05-03
D
.
Ri
c
ha
r
d H
i
pp
Add more corruption checki
n
g to t
h
e cell
o
verwrite
.
.
.
commit
|
commitdiff
|
tree
2018-05-03
D
.
Richar
d
H
ipp
Bug fi
x
es in
t
h
e overwrite
optimization
.
commit
|
commitdiff
|
tree
2018-05-03
D
.
R
i
chard
H
ipp
The sqlite3BtreeInsert() rou
t
ine tries to overwrite
.
.
.
commit
|
commitdiff
|
tree
2018-05-03
D
.
Richard Hipp
E
n
hance EXPLAIN
Q
UERY PL
A
N to report the gene
r
ati
o
n
.
.
.
commit
|
commitdiff
|
tree
2018-05-02
D
.
Richar
d
Hipp
Mor
e
test case updates
.
Tes
t
s are a
l
l
running now
.
commit
|
commitdiff
|
tree
2018-05-02
D
.
Richard H
i
p
p
Fix
tes
t
cases so
that they work with
t
he new EXPLAI
N
.
.
.
commit
|
commitdiff
|
tree
2018-05-02
D
.
Richa
r
d Hipp
Improv
e
d EQP output for recursive
CTEs
a
nd multi-value
.
.
.
commit
|
commitdiff
|
tree
2018-05-02
D
.
R
ichard Hi
p
p
Prevent VA
C
U
UM fro
m
running any co
m
mands in sqlite_
m
a
ster
.
.
.
commit
|
commitdiff
|
tree
2018-05-02
D
.
Richard Hipp
F
i
x a dangli
n
g
-
else problem
that was
c
aus
i
n
g
recursive
.
.
.
commit
|
commitdiff
|
tree
2018-05-02
D
.
Richard Hipp
I
m
p
r
ovements to the EQP di
s
pla
y
fo
r
com
p
ound sele
c
t
.
.
.
commit
|
commitdiff
|
tree
2018-05-02
D
.
Richard Hipp
Begin
r
eengineering the EX
P
L
AIN Q
U
E
RY PLAN f
u
nction
.
.
.
commit
|
commitdiff
|
tree
2018-05-01
D
.
R
ichard Hipp
The SQLITE_
A
LLOW_
S
Q
L
I
TE_MASTER_I
N
DEX compile-time opti
o
n
.
.
.
commit
|
commitdiff
|
tree
2018-04-30
D
.
Richard Hipp
De
f
e
r
l
o
a
ding
r
esult
column v
a
lues i
n
t
o registers on
.
.
.
commit
|
commitdiff
|
tree
2018-04-28
D
.
Richard Hipp
Tes
t
ca
s
e
s a
d
d
e
d
f
or SQLIT
E
_D
B
CONFIG
_
RESET_DATA
B
ASE
.
commit
|
commitdiff
|
tree
2018-04-28
D
.
R
ichard Hip
p
Add th
e
SQLIT
E
_D
B
CONFIG_R
E
S
E
T_DATABASE con
t
rol for
.
.
.
commit
|
commitdiff
|
tree
2018-04-28
D
.
Richard Hipp
Add th
e
SQLITE_DBC
O
NF
I
G_RE
S
ET_
D
ATABAS
E
contro
l
as a
.
.
.
commit
|
commitdiff
|
tree
2018-04-28
D
.
Ric
h
a
rd Hipp
Merge
u
pda
t
es from trunk
.
commit
|
commitdiff
|
tree
2018-04-28
D
.
Rich
a
r
d
Hi
p
p
P
revent
d
eep recursions on nested COLL
A
TE
operators
.
commit
|
commitdiff
|
tree
2018-04-28
D
.
Richard Hi
p
p
Fix com
p
il
e
r warnings in FTS3
.
commit
|
commitdiff
|
tree
2018-04-28
D
.
Rich
a
rd Hipp
Add the "PRAGMA rese
t
_database
=
ON|OFF" co
m
mand
.
When
.
.
.
commit
|
commitdiff
|
tree
2018-04-27
D
.
Ric
h
ard
H
i
pp
Enhance the comments in the te
m
platevtab
.
c i
m
plementation
.
commit
|
commitdiff
|
tree
2018-04-26
D
.
Richard H
i
pp
The pr
e
vious fix for
t
icket [d85fffd6ffe856092ed8da
.
.
.
commit
|
commitdiff
|
tree
2018-04-26
D
.
Richard Hipp
Ensu
r
e that new
.
* v
a
l
u
es
of an
UPDATE do not get clo
b
bere
d
.
.
.
commit
|
commitdiff
|
tree
2018-04-26
D
.
Richard Hipp
Clarification of the behavio
r
o
f
a
BEFORE
UPDATE trigger
.
.
.
commit
|
commitdiff
|
tree
2018-04-26
D
.
Rich
a
rd Hipp
Impr
o
ved
VDBE c
o
m
ment
on t
h
e OP_Para
m
o
p
code
.
No substantia
.
.
.
commit
|
commitdiff
|
tree
2018-04-25
D
.
Rich
a
rd
H
i
pp
Add
n
e
w
interfaces f
o
r a
c
c
e
ssin
g
the list of SQL
keyw
o
rds:
commit
|
commitdiff
|
tree
2018-04-25
D
.
Richard Hi
p
p
Add the new DO and
NOTHING keywords to the keyword
.
.
.
commit
|
commitdiff
|
tree
2018-04-25
D
.
R
ichard
H
ipp
Add the new
SQLITE_SHELL
_
INIT_PROC compile-time entry
.
.
.
commit
|
commitdiff
|
tree
2018-04-25
D
.
Richard Hip
p
Avoid m
a
ny unnecessary ca
l
ls to sqlite3
R
eadSchema(
.
.
.
commit
|
commitdiff
|
tree
2018-04-25
D
.
Ric
h
ard Hipp
Add an asse
r
t() to
e
nsure that schema mutexes are h
e
ld
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
Richa
r
d Hip
p
Do
n
ot atte
m
pt
t
o use terms from the
W
HERE
c
lause to
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
Richard Hipp
Update th
e
expert e
x
tension test cases to account for
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
Rich
a
rd Hipp
All
the OR optimiza
t
ion
t
o
pro
c
eed
e
ve
n
if
t
he OR is
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
Richard Hipp
Add
a hyperlink to the tic
k
e
t on
the code comm
e
nt
for
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
R
i
c
h
ard Hipp
E
nhance the CL
I
to
ren
d
er EXPLAIN
Q
UERY PLAN
usin
g
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
Richard H
i
pp
Fix
a
memor
y
leak
f
ollowing failure
to o
p
e
n
a
n
e
xternal
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
Richard Hi
p
p
In EX
P
L
A
IN QUE
R
Y PLAN output, do not show an EXECUTE
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
Rich
a
rd Hipp
F
i
x to
check-i
n
[ca34c2dd20ee071
e
] -
avoid a NULL pointer
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Richard Hipp
Fix a problem in sqlite3Ex
p
r
Compare
(
) associated with
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Ri
c
hard Hipp
F
i
x a formatting issu
e
i
n the TreeView ou
t
put for
bare
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Richard Hipp
A
d
d the
"
.
im
p
oster off" vari
a
nt of
the
"
.
im
p
oster"
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Richard Hipp
The "
.
s
electtr
a
ce 0x2000" command
causes just
t
he to
p
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Ri
c
hard Hipp
The "
.
se
l
ecttr
a
c
e
4" command now sh
o
ws only a single
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
R
ichard Hipp
Do not restore the iSelectId value
until
after the
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Richa
r
d
Hip
p
In th
e
"
.
selecttrace" output, inclu
d
e the EXPLA
I
N QUERY
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Rich
a
rd Hipp
E
n
sure t
h
at th
e
re
are
n
o bind-
p
arame
t
ers or
i
ncorrect
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Richard Hipp
F
ix a
n
unreach
a
ble branch
a
ssociat
e
d
w
ith s
t
ack overflow
.
.
.
commit
|
commitdiff
|
tree
2018-04-21
D
.
Rich
a
rd Hip
p
Perfo
r
mance
i
mprovements on
the m
a
in loop of t
h
e LE
M
ON
.
.
.
commit
|
commitdiff
|
tree
2018-04-21
D
.
R
i
chard H
i
p
p
Enhance LEMON
t
o
track whi
c
h
symbols actuall
y
carry
.
.
.
commit
|
commitdiff
|
tree
2018-04-21
D
.
Richard Hipp
Add th
e
%extra_co
n
t
e
x
t directive to
lemon
,
a
s
an alternative
.
.
.
commit
|
commitdiff
|
tree
2018-04-21
D
.
Rich
a
rd Hip
p
Fix UPSERT so tha
t
it
p
l
ays nicel
y
with AUTOINC
R
EMENT
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
R
ichard Hipp
A
d
d
the -dDIRECTORY command-line
o
ption
to LEMON
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Richa
r
d
H
ipp
Fix a harmles
s
c
ompil
e
r
warn
i
ng
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Richard Hipp
A
void t
h
e
u
s
e of st
a
tement jou
r
na
l
s
o
n
DELETEs
o
f
a
.
.
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
R
i
chard Hipp
Avoid open
i
ng
a sta
t
ement j
o
urnal on s
i
ngle-r
o
w
U
PDA
T
Es
.
.
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
R
i
c
hard Hipp
F
i
x a VDBE
comment on upsert
.
P
r
ovide an error
message
.
.
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Richard Hip
p
A
v
o
id unnecess
a
ry cursor seek
i
ng whe
n
p
e
rforming an
.
.
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
R
ichard Hipp
Improved VDBE c
o
m
ment on UPSERT code
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Ri
c
hard Hipp
Minor simplif
i
cation o
f
the previous checkin
.
commit
|
commitdiff
|
tree
next