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
Add the SQLITE_DBCONFIG_RESET_DATABASE control as a replacement for
2018-04-28
D
.
Ric
h
ard Hi
p
p
Add t
h
e S
Q
LITE_DB
C
O
N
FIG_RE
S
ET_DATABASE control as a
.
.
.
commit
|
commitdiff
|
tree
2018-04-28
D
.
Richard Hipp
Merge upda
t
es from tru
n
k
.
commit
|
commitdiff
|
tree
2018-04-28
D
.
Richard Hipp
Prevent
d
e
ep re
c
ursions
o
n n
e
sted CO
L
LA
T
E operato
r
s
.
commit
|
commitdiff
|
tree
2018-04-28
D
.
Richard
H
ipp
F
i
x compiler war
n
ings i
n
FTS3
.
commit
|
commitdiff
|
tree
2018-04-28
D
.
Ric
h
ard Hipp
Add the "PRA
G
MA
r
eset_da
t
abase=ON|OFF" command
.
Whe
n
.
.
.
commit
|
commitdiff
|
tree
2018-04-27
D
.
Richard Hipp
E
n
h
a
nce the co
m
m
en
t
s in th
e
templatevtab
.
c
implementa
t
ion
.
commit
|
commitdiff
|
tree
2018-04-26
D
.
Ri
c
hard Hipp
The previous
fix for ti
c
ke
t
[d85fffd6
f
fe856092
e
d8da
.
.
.
commit
|
commitdiff
|
tree
2018-04-26
D
.
R
i
chard Hipp
Ensure
that ne
w
.
* values of an
U
P
DATE do
n
o
t g
e
t clobbered
.
.
.
commit
|
commitdiff
|
tree
2018-04-26
D
.
Richard Hipp
Clarificat
i
on of the
beh
a
vior
of a BEFO
R
E UPDATE trigger
.
.
.
commit
|
commitdiff
|
tree
2018-04-26
D
.
Richard Hipp
Improv
e
d
V
DBE comment
on the OP
_
Pa
r
am opcode
.
No
s
u
b
stantia
.
.
.
commit
|
commitdiff
|
tree
2018-04-25
D
.
R
i
c
h
ar
d
Hipp
Add new interfaces for acces
s
in
g
the list of SQ
L
keywords:
commit
|
commitdiff
|
tree
2018-04-25
D
.
Richard Hipp
Add t
h
e
new DO and
NOTHING k
e
y
words
t
o the
keyword
.
.
.
commit
|
commitdiff
|
tree
2018-04-25
D
.
Richard Hip
p
Add t
h
e
n
ew SQLITE_SHELL_INIT_PROC compi
l
e-ti
m
e
e
ntry
.
.
.
commit
|
commitdiff
|
tree
2018-04-25
D
.
Richard Hipp
Avoid ma
n
y unnecessar
y
calls to sqlite3
R
e
a
dSchema(
.
.
.
commit
|
commitdiff
|
tree
2018-04-25
D
.
Ri
c
hard Hipp
Add
an a
s
se
r
t()
t
o e
n
sure that schema mutexes are
h
el
d
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
Richard Hipp
Do not attem
p
t to
use ter
m
s f
r
om
t
he WHERE
clause to
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
R
icha
r
d H
i
pp
Update the expert extension
t
est cases
to account
f
or
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
Richard
Hi
p
p
All the O
R
optimization to proceed
e
ven if the OR
is
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
Ri
c
hard Hipp
Add a hyperlink t
o
th
e
t
ic
k
et
on the code comment for
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
Richard Hipp
Enhanc
e
the CLI to render EXPLAIN QUERY PLAN usi
n
g
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
Richard Hipp
Fix a mem
o
ry leak fol
l
owing failur
e
to open an
external
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
R
ichard Hipp
I
n
EXPLAIN QUERY PLAN output, d
o
n
ot show
a
n EXECUTE
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
Rich
a
rd Hip
p
Fix to check-in
[c
a
34c2dd20
e
e071e] - avoid a NULL pointer
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Richard
H
ip
p
Fix a p
r
ob
l
em in sqlite3ExprCo
m
pare() ass
o
ci
a
ted with
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Richard Hipp
Fix
a
formatting iss
u
e in the
T
reeV
i
ew ou
t
p
u
t for bare
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Ric
h
ard Hi
p
p
Add the "
.
i
mpost
e
r off" variant of the "
.
impos
t
er"
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Richard Hipp
The "
.
selecttr
a
ce
0
x2000" com
m
a
n
d cau
s
es just the top
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Richard Hipp
The "
.
s
elec
t
trace
4" com
m
and now shows only a
s
ingle
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Richard H
i
pp
Do
n
o
t restore th
e
iSele
c
tId value unt
i
l afte
r
t
h
e
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Ri
c
har
d
H
i
p
p
I
n
the "
.
selecttrac
e
" ou
t
put
,
include the EXPLAIN Q
U
ERY
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
R
i
chard Hip
p
E
n
s
u
r
e that there are
n
o bind-param
e
t
e
r
s
or incorrect
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Richard Hipp
Fix an unre
a
chable branch a
s
soci
a
ted wit
h
sta
c
k overflow
.
.
.
commit
|
commitdiff
|
tree
2018-04-21
D
.
Richard Hipp
Perform
a
nce improvem
e
n
t
s on the main loo
p
of
the LE
M
ON
.
.
.
commit
|
commitdiff
|
tree
2018-04-21
D
.
Ri
c
hard
H
ipp
Enhance LEMON
to track
w
h
i
ch s
y
mbols actually carry
.
.
.
commit
|
commitdiff
|
tree
2018-04-21
D
.
Richard Hipp
Add
t
he
%
extra_context dire
c
tive
t
o lemon,
as an alternative
.
.
.
commit
|
commitdiff
|
tree
2018-04-21
D
.
Richard
Hipp
F
i
x UPS
E
RT so
t
h
at it pla
y
s nicely with AUTOINCREMENT
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Richa
r
d Hipp
Add
t
he
-dDIRECTORY command-line
o
p
ti
o
n
to LEMON
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Richard Hipp
Fix a harmless comp
i
ler
w
a
rnin
g
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Richard Hipp
Av
o
id the
use of statement
jo
u
rnals on DELETEs
of a
.
.
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Ri
c
hard Hipp
Avoid opening a state
m
ent journal on single-row UPDATEs
.
.
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Richard Hipp
Fix a
V
DB
E
comment on ups
e
rt
.
Provide
a
n error me
s
s
age
.
.
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Richard Hipp
Avoid u
n
necessary cursor s
e
e
king when
p
erforming an
.
.
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
R
ichard Hipp
I
m
pr
o
v
e
d VDBE comment on UP
S
ERT
c
ode
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Richard Hi
p
p
Mi
n
or s
i
mpli
f
i
cat
i
o
n
of the previous che
c
kin
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Ric
h
ard H
i
p
p
A
void unnecessary
cursor se
e
ks during upsert
proces
s
ing
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Ric
h
ard Hipp
Enhance UPSERT so that th
e
UPDATE u
s
es the same set
.
.
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Richard
Hipp
Mino
r
simpl
i
fica
t
ion
o
f the
c
ursor allocation
l
ogic
.
.
.
commit
|
commitdiff
|
tree
2018-04-19
D
.
R
ichard
H
ipp
Fix
the handling of "P
R
AGMA count_changes=ON"
with
.
.
.
commit
|
commitdiff
|
tree
2018-04-19
D
.
Richard Hipp
Minor simp
l
i
f
ic
a
tion
t
o the upsert log
i
c
.
commit
|
commitdiff
|
tree
2018-04-19
D
.
Richa
r
d
H
ipp
Add the --upsert option
t
o the
wor
d
co
u
nt test pro
g
ram
.
commit
|
commitdiff
|
tree
2018-04-19
D
.
Richard Hipp
Add
the ext/misc/templatev
t
ab
.
c
t
e
m
pla
t
e
f
or virtual
.
.
.
commit
|
commitdiff
|
tree
2018-04-19
D
.
Richard Hipp
Fix a problem in the ne
w
upsert impleme
n
tion, discovered
.
.
.
commit
|
commitdiff
|
tree
2018-04-19
D
.
R
ichard Hipp
Fix the table nam
e
aliasing
o
n INSERT so that
i
t occurs
.
.
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richard
H
ipp
Avoid a NU
L
L
-pointer
d
e
r
ef
following OO
M
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richard
H
i
pp
Fix a te
s
t case
i
nside dis
t
i
n
c
t
.
test
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richard
Hipp
I
m
prov
e
d matching of COLLATE clauses within the
O
N
.
.
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richard Hipp
Fix a
p
roblem in the sq
l
ite
3
ExprCompare(
)
functi
o
n
.
.
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richa
r
d
H
i
p
p
A
d
d
sup
p
o
rt for P
o
stgreSQL
UPSE
R
T syntax and fu
n
ctionalit
y
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
R
ichard
Hipp
Fix the build for SQLITE_OMIT_U
P
SER
T
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richard Hipp
Ad
d
t
h
e
--s
o
rterref N option t
o
the CLI
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Ri
c
hard Hipp
Omit some c
o
de not used without
S
QLITE_EN
A
BLE_SORTER_REF
E
REN
.
.
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richard Hipp
Remove an unused loca
l
variable
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
R
ichard Hi
p
p
Enhan
c
e ALTER TABL
E
A
D
D
C
O
LUMN to su
p
port "DEFAU
L
T
.
.
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
R
ichard Hipp
Add ch
e
cks to the CLI that issue a warning if SQLite
.
.
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richard
H
ipp
Add ne
w
testcase() macr
o
s and fix a bug that was revealed
.
.
.
commit
|
commitdiff
|
tree
2018-04-17
D
.
Richard
H
ipp
Re
m
ove unreac
h
able branches
.
1
0
0% MC/D
C
in
T
H
3
n
o
w
.
commit
|
commitdiff
|
tree
2018-04-17
D
.
Ric
h
ard Hipp
Ad
d
ed a co
m
ment on the assert()
added to the previ
o
us
.
.
.
commit
|
commitdiff
|
tree
2018-04-17
D
.
Richard Hi
p
p
Fixes to t
h
e logic
f
or co
n
straint check
reorderin
g
.
.
.
commit
|
commitdiff
|
tree
2018-04-17
D
.
Richa
r
d Hipp
Du
r
ing PRAGMA vdbe_addop
t
r
a
c
e=ON,
s
how calls to sq
l
ite3Vdbe
R
.
.
.
commit
|
commitdiff
|
tree
2018-04-17
D
.
Rich
a
rd Hipp
TK_REGIST
E
R
expressions nod
e
s
a
re pro
b
ably not constant
.
.
.
commit
|
commitdiff
|
tree
2018-04-17
D
.
Ri
c
hard Hi
p
p
S
impl
i
fic
a
t
ion to the upsert logi
c
.
commit
|
commitdiff
|
tree
2018-04-17
D
.
R
ichar
d
Hipp
New test cases for upse
r
t
.
commit
|
commitdiff
|
tree
2018-04-16
D
.
Ri
c
hard Hipp
Me
r
ge the L
e
mo
n
enhancement fr
o
m trunk,
resulting in
.
.
.
commit
|
commitdiff
|
tree
2018-04-16
D
.
Richard H
i
pp
L
e
mon
enhancements: (1) Do no
t
allocate space for
.
.
.
commit
|
commitdiff
|
tree
2018-04-16
D
.
Richard
H
ipp
R
em
o
ve the My
S
Q
L upsert
synta
x
.
As a
n
option
a
l
a
lias
.
.
.
commit
|
commitdiff
|
tree
2018-04-16
D
.
Ric
h
ard Hipp
Ad
d
supp
o
rt for the "exc
l
u
ded
.
*"
names in the UPDATE
.
.
.
commit
|
commitdiff
|
tree
2018-04-16
D
.
Ri
c
hard Hipp
Merg
e
changes
f
rom trunk
.
commit
|
commitdiff
|
tree
2018-04-16
D
.
Ri
c
hard Hipp
Incre
a
se the
v
ersion numb
e
r to
3
.
24
.
0
commit
|
commitdiff
|
tree
2018-04-16
D
.
Richard Hipp
Redu
c
e the size of
t
he NameContext
obj
e
ct b
y
grouping
.
.
.
commit
|
commitdiff
|
tree
2018-04-14
D
.
Rich
a
r
d
Hip
p
G
e
t up
s
ert working on WITHOUT ROW
I
D tables
.
commit
|
commitdiff
|
tree
2018-04-14
D
.
Richard Hip
p
Make sure const
r
ain
t
ch
e
cks
o
c
c
ur in the corr
e
ct order
.
.
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
Richard H
i
p
p
First cut at logic to perform
D
O UPDATE
fo
r
rowi
d
tables
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
Richard Hipp
Add i
n
f
r
a
str
u
cture for d
o
ing
a
n UPD
A
TE as part
o
f an
.
.
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
Rich
a
rd Hipp
Merge the preupdate h
o
ok chan
g
e
from trunk
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
Richard Hipp
Rem
o
ve an alwa
y
s-true branch from the preupd
a
te hook
.
.
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
Richard Hipp
G
et the
O
N
CON
F
LI
C
T DO N
O
THIN
G
f
orm
o
f upsert working
.
.
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
Richard Hipp
G
e
t
the conflict-t
a
rge
t
c
l
au
s
e par
s
ing w
o
rk
i
n
g correctly
.
.
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
Ric
h
ard Hipp
Improved conflict-
t
arget matching log
i
c
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
Richa
r
d
H
i
p
p
Back
off of the extended upsert syntax
that
a
llows
.
.
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
Richard Hipp
Begin adding upsert logic
.
Thi
s
is an increme
n
tal
.
.
.
commit
|
commitdiff
|
tree
2018-04-12
D
.
Ric
h
ard Hipp
Break out
t
he ups
e
rt co
d
e
i
n
to a separa
t
e source file
.
commit
|
commitdiff
|
tree
2018-04-12
D
.
R
i
chard Hip
p
Fix ano
t
her
t
ypo in a comment
.
commit
|
commitdiff
|
tree
2018-04-12
D
.
Ric
h
ard Hipp
Simple comment clarificat
i
on
.
No
c
ode
o
r logic cha
n
ges
.
commit
|
commitdiff
|
tree
2018-04-12
D
.
R
ichard Hi
p
p
E
x
tend
t
he upsert synta
x
to
allow a
W
HERE
c
lause on
.
.
.
commit
|
commitdiff
|
tree
2018-04-12
D
.
Richard
Hi
p
p
Update th
e
u
pser
t
parsing
so that it acce
p
ts conflict
.
.
.
commit
|
commitdiff
|
tree
2018-04-12
D
.
R
i
chard Hipp
Add the Upsert
o
bject for holding ups
e
rt clause inform
a
tion
.
commit
|
commitdiff
|
tree
2018-04-12
D
.
Richard Hipp
Merge changes
from trunk
.
commit
|
commitdiff
|
tree
2018-04-11
D
.
Richa
r
d Hi
p
p
H
el
p
t
h
e pa
r
s
er
run
f
ast
e
r by
avoiding the
"ex
p
l
a
in
.
.
.
commit
|
commitdiff
|
tree
2018-04-11
D
.
R
icha
r
d Hipp
P
rohibit bound parameters
i
n
the argu
m
en
t
s to tab
l
e
.
.
.
commit
|
commitdiff
|
tree
2018-04-10
D
.
Richard Hipp
Version 3
.
23
.
1
commit
|
commitdiff
|
tree
next