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 harmless compiler warnings in the cell-overwrite logic.
2018-05-07
D
.
R
i
c
hard Hipp
Fix h
a
rmless compiler warnings
i
n the
c
ell-overwrite
.
.
.
commit
|
commitdiff
|
tree
2018-05-04
D
.
R
i
char
d
Hipp
Merge enhancements from trunk
.
commit
|
commitdiff
|
tree
2018-05-04
D
.
R
ichar
d
Hipp
Fi
x
r
equirements
m
a
rks
.
No code changes
.
commit
|
commitdiff
|
tree
2018-05-04
D
.
R
ichard
H
ipp
For
t
h
e
amalgamatio
n
-tarball, enable
FTS5 and JSON1
.
.
.
commit
|
commitdiff
|
tree
2018-05-04
D
.
Richard
Hipp
Ma
k
e
a
s
e
parate
l
imb in
the E
X
P
LAI
N
QUERY PLAN ou
t
p
u
t
.
.
.
commit
|
commitdiff
|
tree
2018-05-03
D
.
R
i
chard H
i
pp
In OR
D
ER B
Y
L
I
MIT queries, try
to evaluate the ORDER
.
.
.
commit
|
commitdiff
|
tree
2018-05-03
D
.
R
i
cha
r
d Hipp
Fix a branch that has bec
o
me unreachable due to recent
.
.
.
commit
|
commitdiff
|
tree
2018-05-03
D
.
Rich
a
r
d
H
i
p
p
Impr
o
ve
d
securit
y
for VACUUM
.
Thi
s
check-in combines
.
.
.
commit
|
commitdiff
|
tree
2018-05-03
D
.
Rich
a
r
d
Hipp
Ov
e
rhaul of
EXPLA
I
N
Q
U
ERY
PLAN
.
The output is now
in
.
.
.
commit
|
commitdiff
|
tree
2018-05-03
D
.
R
i
ch
a
rd H
i
pp
Optimizatio
n
s
to
t
he
new EQP fr
a
m
ewor
k
.
commit
|
commitdiff
|
tree
2018-05-03
D
.
Richard Hipp
Fi
x
v
arious e
r
ror handling conditions on the cell overwrite
.
.
.
commit
|
commitdiff
|
tree
2018-05-03
D
.
Richard
H
i
pp
The B
t
Curs
o
r
.
info fields are on
l
y va
l
i
d
if
i
nfo
.
nSize!
=
0
.
commit
|
commitdiff
|
tree
2018-05-03
D
.
Richard
H
ipp
Add more corru
p
tion checking t
o
the cell ove
r
write
.
.
.
commit
|
commitdiff
|
tree
2018-05-03
D
.
Richard
Hipp
Bug fixes in the overwrite optimizatio
n
.
commit
|
commitdiff
|
tree
2018-05-03
D
.
Richa
r
d Hipp
The sqlit
e
3BtreeInsert() routine tries to overwrite
.
.
.
commit
|
commitdiff
|
tree
2018-05-03
D
.
R
ichard Hipp
Enhance EXPLAIN QUERY
P
LAN to rep
o
rt the generation
.
.
.
commit
|
commitdiff
|
tree
2018-05-02
D
.
Ri
c
hard Hipp
Mor
e
test case updates
.
T
e
sts
are all running n
o
w
.
commit
|
commitdiff
|
tree
2018-05-02
D
.
Richard Hipp
Fix test cases so
that they work with
the new EXPLAIN
.
.
.
commit
|
commitdiff
|
tree
2018-05-02
D
.
R
i
char
d
Hipp
Improved EQP
o
utput
f
o
r recursiv
e
CTEs a
n
d
multi-value
.
.
.
commit
|
commitdiff
|
tree
2018-05-02
D
.
R
ichard
H
ipp
P
revent VAC
U
UM fro
m
running any commands in sqlite
_
m
a
s
te
r
.
.
.
commit
|
commitdiff
|
tree
2018-05-02
D
.
Richard Hipp
Fix a dangli
n
g-
e
lse p
r
oblem that w
a
s causin
g
recu
r
sive
.
.
.
commit
|
commitdiff
|
tree
2018-05-02
D
.
Richard Hi
p
p
Improvements to the EQP display for c
o
m
pound se
l
ect
.
.
.
commit
|
commitdiff
|
tree
2018-05-02
D
.
Richard Hipp
Begin reeng
i
n
e
e
r
i
ng the EXP
L
AIN QU
E
RY PLAN
f
unction
.
.
.
commit
|
commitdiff
|
tree
2018-05-01
D
.
Richard Hipp
The S
Q
LITE_ALLOW
_
S
QLITE
_
M
A
S
TER_INDEX compile-time
o
p
t
ion
.
.
.
commit
|
commitdiff
|
tree
2018-04-30
D
.
Rich
a
rd Hipp
Def
e
r loading resul
t
column values into registers on
.
.
.
commit
|
commitdiff
|
tree
2018-04-28
D
.
R
ichard Hipp
Test
cases added for SQLITE_DB
C
ONFIG
_
RESET_DATABASE
.
commit
|
commitdiff
|
tree
2018-04-28
D
.
Richard Hipp
Ad
d
the SQLITE_DBCONFI
G
_RESET_D
A
TABASE control for
.
.
.
commit
|
commitdiff
|
tree
2018-04-28
D
.
R
i
c
h
a
r
d Hi
p
p
Add the SQLITE_DBC
O
NFIG_
R
ESET_DATAB
A
SE con
t
r
ol as a
.
.
.
commit
|
commitdiff
|
tree
2018-04-28
D
.
Ric
h
ard Hipp
M
e
rge upd
a
tes from tru
n
k
.
commit
|
commitdiff
|
tree
2018-04-28
D
.
R
i
char
d
Hipp
Prevent deep recursi
o
ns on
nested
C
OLLATE op
e
rators
.
commit
|
commitdiff
|
tree
2018-04-28
D
.
Richard Hipp
Fi
x
comp
i
l
er warnings in FTS3
.
commit
|
commitdiff
|
tree
2018-04-28
D
.
Richa
r
d Hipp
A
d
d the "PRAGMA reset_database=ON|O
F
F" command
.
When
.
.
.
commit
|
commitdiff
|
tree
2018-04-27
D
.
Richard Hip
p
Enhance the comm
e
nts in the templatevtab
.
c implementation
.
commit
|
commitdiff
|
tree
2018-04-26
D
.
Richa
r
d Hipp
The previo
u
s fix f
o
r
t
icket [d
8
5fffd6ffe85
6
092ed8da
.
.
.
commit
|
commitdiff
|
tree
2018-04-26
D
.
Ri
c
ha
r
d Hipp
Ensure
t
hat
new
.
* values of
an UPDA
T
E
do
no
t
get clobbere
d
.
.
.
commit
|
commitdiff
|
tree
2018-04-26
D
.
Ric
h
ard H
i
pp
Clarifica
t
i
on
of the beh
a
vior
of a B
E
FORE
UPD
A
T
E
trigger
.
.
.
commit
|
commitdiff
|
tree
2018-04-26
D
.
Richard Hipp
Imp
r
ove
d
VDBE comment on the OP_Param opcode
.
No sub
s
t
antia
.
.
.
commit
|
commitdiff
|
tree
2018-04-25
D
.
Rich
a
rd Hipp
Add
n
ew
i
nterfaces for acces
s
ing th
e
lis
t
of
SQL key
w
ords:
commit
|
commitdiff
|
tree
2018-04-25
D
.
Richard
Hi
p
p
Add the new DO and NOTHIN
G
keywords to the
k
eyword
.
.
.
commit
|
commitdiff
|
tree
2018-04-25
D
.
R
i
c
hard
H
ipp
Add the
n
ew SQLITE
_
SHELL_INI
T
_PROC co
m
pile-time
e
ntr
y
.
.
.
commit
|
commitdiff
|
tree
2018-04-25
D
.
Richard Hip
p
Avoid many unnecessar
y
call
s
t
o sqlit
e
3Rea
d
Sc
h
ema(
.
.
.
commit
|
commitdiff
|
tree
2018-04-25
D
.
Rich
a
rd Hipp
Add an asse
r
t() to en
s
ure that schema mutexes ar
e
held
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
Richard
H
i
pp
Do not a
t
te
m
pt to use t
e
rms from the WHERE
clause to
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
Richard Hipp
Update
t
h
e
e
x
p
ert
e
xtension test
cases to
a
ccount f
o
r
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
R
i
chard Hipp
Al
l
the OR o
p
timiza
t
ion to pro
c
e
e
d ev
e
n if the OR is
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
R
i
chard Hipp
Add a hyperl
i
nk to th
e
tic
k
e
t
on the c
o
de c
o
mme
n
t for
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
Richar
d
Hipp
E
n
hance
t
he CLI
t
o r
e
n
der
E
X
PLAIN Q
U
ERY PLAN using
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
Ri
c
ha
r
d Hipp
Fix a memory le
a
k f
o
llow
i
ng failure to
open an exter
n
a
l
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
R
ichard Hipp
In EX
P
LA
I
N
QUERY PLAN output, do
not show an EXECUTE
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
Richa
r
d Hipp
Fix to
ch
e
ck-
i
n [c
a
34c2dd20ee071e] - avoid a NULL point
e
r
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
R
ichard Hipp
Fix a problem in
s
qli
t
e3Ex
p
rCompare()
associated wit
h
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
R
ichard Hi
p
p
F
ix a formatting issue in the TreeV
i
ew out
p
u
t
for
b
are
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
R
i
chard Hipp
Add the "
.
imposter of
f
"
v
a
riant of the "
.
imposte
r
"
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Ric
h
ard Hipp
The "
.
selecttrace 0x2000" command ca
u
ses
j
us
t
the top
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
R
i
chard H
i
pp
The "
.
selecttrace 4" command now shows only a singl
e
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Richa
r
d Hipp
Do not
r
est
o
re the
iSelectId valu
e
until afte
r
the
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
R
ichard
Hipp
I
n the "
.
selecttrace" ou
t
put, include the EXPLAIN QUERY
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Richard Hipp
Ensure that
there
are no bind-pa
r
amete
r
s
or inco
r
re
c
t
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Richa
r
d Hipp
F
i
x an unreach
a
ble bran
c
h
a
ssociated w
i
th stack
o
verflow
.
.
.
commit
|
commitdiff
|
tree
2018-04-21
D
.
Rich
a
rd Hipp
Performa
n
ce improve
m
ents on the main loop of the LEMO
N
.
.
.
commit
|
commitdiff
|
tree
2018-04-21
D
.
R
ichar
d
Hipp
E
nhance
LEMON t
o
trac
k
whic
h
symbol
s
actual
l
y c
a
rry
.
.
.
commit
|
commitdiff
|
tree
2018-04-21
D
.
Richa
r
d Hipp
Add the %extra_
c
ontext directive
to lemon,
a
s
a
n
al
t
ernati
v
e
.
.
.
commit
|
commitdiff
|
tree
2018-04-21
D
.
Ri
c
h
a
r
d
H
i
pp
Fix UP
S
ERT so t
h
at i
t
plays n
i
cely with AUTOINCREM
E
NT
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
R
i
ch
a
r
d Hip
p
Add the -dDIREC
T
ORY c
o
mmand-
l
ine option to LEMO
N
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Richard Hipp
Fix a harmless
c
omp
i
l
e
r warning
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Richard
H
ipp
A
v
oid th
e
u
se of statemen
t
journals
o
n DE
L
ETEs of a
.
.
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Ric
h
ard
H
ipp
A
v
oid opening a s
t
atement jou
r
na
l
on s
i
ngle-ro
w
U
P
DATEs
.
.
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Richard Hipp
Fix a VDB
E
comment on
u
p
s
er
t
.
Provide an error messa
g
e
.
.
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Richard Hi
p
p
Avoid unn
e
cessary cursor
seeking whe
n
pe
r
forming an
.
.
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Richard Hipp
Im
p
roved
V
D
B
E
comment on UPSERT code
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Richard Hip
p
M
in
o
r simp
l
i
ficati
o
n o
f
the previou
s
ch
e
cki
n
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Ric
h
ard Hipp
Avoid unnecessary cursor seeks during u
p
sert
p
r
ocess
i
ng
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Ri
c
ha
r
d Hipp
Enhance UPSERT so t
h
at the UPD
A
TE uses th
e
same set
.
.
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Richard H
i
pp
Minor sim
p
l
i
f
icat
i
on of the cur
s
or allocation
log
i
c
.
.
.
commit
|
commitdiff
|
tree
2018-04-19
D
.
Ri
c
hard H
i
pp
Fix the handli
n
g
of
"PRAGMA count_
c
hange
s
=ON" with
.
.
.
commit
|
commitdiff
|
tree
2018-04-19
D
.
Richard Hip
p
Min
o
r simplification to the upsert
l
ogic
.
commit
|
commitdiff
|
tree
2018-04-19
D
.
R
i
chard Hipp
Add
t
he --up
s
e
r
t option to
the
w
o
rdcount tes
t
p
rog
r
am
.
commit
|
commitdiff
|
tree
2018-04-19
D
.
Rich
a
rd Hi
p
p
Add the e
x
t/misc/tem
p
lat
e
v
tab
.
c te
m
pl
a
t
e for virtu
a
l
.
.
.
commit
|
commitdiff
|
tree
2018-04-19
D
.
Richard Hipp
Fix a probl
e
m
i
n the new upsert implemention
,
discov
e
r
ed
.
.
.
commit
|
commitdiff
|
tree
2018-04-19
D
.
Richar
d
Hipp
Fix the table name al
i
as
i
ng
on
I
NSERT so that it occurs
.
.
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Ric
h
ar
d
Hipp
Avoid a NULL-point
e
r der
e
f follo
w
ing OOM
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
R
i
c
h
a
r
d
H
ipp
Fix a test ca
s
e
inside distinct
.
t
e
s
t
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richar
d
Hipp
Improved matchin
g
of COLLATE
clause
s
w
ithin the ON
.
.
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richard Hi
p
p
F
ix a pro
b
lem in the sqlite3E
x
prCom
p
a
r
e() function
.
.
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richard Hip
p
Add support for P
o
stgreSQL UPS
E
RT syntax and fu
n
ctionality
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richard Hipp
Fix the
b
uild for SQLITE_OMIT
_
UPSE
R
T
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richard Hipp
Add the --sort
e
rref N option to th
e
CLI
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richard Hipp
Omit
s
ome
c
ode no
t
use
d
without
S
Q
LI
T
E_ENABLE_SORTER_REFEREN
.
.
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
R
i
c
hard Hipp
Remove an unu
s
ed lo
c
al variable
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richa
r
d Hipp
Enhance ALTER
TABLE A
D
D COLU
M
N t
o
s
up
p
ort "DEFAULT
.
.
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
R
i
chard H
i
pp
A
d
d
checks to th
e
C
LI
that issue a wa
r
ning if
SQLite
.
.
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Ric
h
ard H
i
pp
Add
new tes
t
case(
)
m
a
c
ros and
f
ix a
b
ug that was revealed
.
.
.
commit
|
commitdiff
|
tree
2018-04-17
D
.
R
ichard Hipp
Remove u
n
reachable bra
n
ches
.
100%
MC/DC in TH3
n
ow
.
commit
|
commitdiff
|
tree
2018-04-17
D
.
Richard Hipp
Adde
d
a c
o
m
m
ent
o
n the
as
s
er
t
() ad
d
ed to the previous
.
.
.
commit
|
commitdiff
|
tree
2018-04-17
D
.
R
i
ch
a
rd
H
ipp
Fixes t
o
t
h
e logi
c
f
o
r constrai
n
t check
r
eordering
.
.
.
commit
|
commitdiff
|
tree
2018-04-17
D
.
R
i
chard
H
ipp
During PR
A
GMA v
d
be_addoptrace=ON, show
c
a
lls to sq
l
i
t
e3VdbeR
.
.
.
commit
|
commitdiff
|
tree
2018-04-17
D
.
Ric
h
ard Hipp
TK_REGISTER expressions nodes are proba
b
ly not con
s
tant
.
.
.
commit
|
commitdiff
|
tree
2018-04-17
D
.
Ri
c
ha
r
d Hipp
S
i
mplificat
i
on to the upsert logi
c
.
commit
|
commitdiff
|
tree
2018-04-17
D
.
Richar
d
Hipp
Ne
w
test cases
for
u
psert
.
commit
|
commitdiff
|
tree
2018-04-16
D
.
Richa
r
d
Hipp
Merge the Le
m
on enhancement from trunk, re
s
ulting
i
n
.
.
.
commit
|
commitdiff
|
tree
next