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 VDBE comment on the OP_Param opcode. No substantial changes.
2018-04-26
D
.
Ric
h
ar
d
Hipp
Improved VDBE comme
n
t on the
O
P_Param
o
p
code
.
No
substa
n
tia
.
.
.
commit
|
commitdiff
|
tree
2018-04-25
D
.
Richard Hip
p
Add new
i
nterfaces for accessing the
l
is
t
of SQL keyword
s
:
commit
|
commitdiff
|
tree
2018-04-25
D
.
R
ichard Hipp
Add the new DO and NOTHING
k
eywords to th
e
keywo
r
d
.
.
.
commit
|
commitdiff
|
tree
2018-04-25
D
.
Richa
r
d Hipp
Add
t
h
e
n
e
w SQLI
T
E_SHELL_
I
NIT_
P
ROC compi
l
e-tim
e
entry
.
.
.
commit
|
commitdiff
|
tree
2018-04-25
D
.
Richard Hipp
Avoid many
un
n
ec
e
s
s
ary calls to sql
i
t
e3ReadSc
h
ema(
.
.
.
commit
|
commitdiff
|
tree
2018-04-25
D
.
Richar
d
H
i
p
p
Add an a
s
sert() to e
n
sure that sc
h
ema mute
x
es
ar
e
hel
d
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
Richar
d
Hipp
Do not
a
t
tempt
t
o u
s
e terms
from th
e
W
H
E
RE cl
a
u
s
e to
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
Richard Hipp
Update
the
e
xpert extensio
n
test cases to account for
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
Richard Hipp
All
t
he
OR optimization to
pr
o
ceed even if the OR is
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
Richard Hi
p
p
Add a hyperlink to the
t
icke
t
on
the code com
m
ent for
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
Richard
H
ipp
Enhan
c
e the
C
LI to render EX
P
LAIN QUE
R
Y PLAN
u
s
i
ng
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
Richard Hipp
F
ix
a memory leak f
o
llowing failure
t
o open an
ext
e
rna
l
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
Rich
a
rd Hipp
In EX
P
LAIN QUERY PL
A
N output, do
not
s
how an EXECUTE
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
Ric
h
ard Hipp
Fix to check-
i
n [ca34
c
2
dd20ee071e] -
a
voi
d
a NULL pointer
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Richard H
i
pp
Fix a
problem in sqlite3ExprCompare
(
) associated with
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
R
ichard Hipp
F
i
x
a
f
o
r
matting issue in the Tree
V
iew
outp
u
t f
o
r
bare
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Ri
c
hard Hipp
Add the "
.
im
p
ost
e
r o
f
f"
v
ariant of the
"
.
imposter"
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Richard
Hipp
The
"
.
select
t
ra
c
e
0
x2000" command causes just the top
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Rich
a
rd Hipp
Th
e
"
.
selecttrace 4" command now
shows onl
y
a singl
e
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
R
ichard Hipp
Do not restore the iSelectI
d
value until after
t
he
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Richard
H
i
pp
In
t
h
e
"
.
selecttrace" output, include th
e
EXPLAIN QUERY
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Ri
c
hard Hipp
Ens
u
re th
a
t
there
are
no bind-parameters or
i
ncorrect
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Richard
H
ip
p
Fix an
unreachable bran
c
h
a
ssociated with stack overflow
.
.
.
commit
|
commitdiff
|
tree
2018-04-21
D
.
R
ichar
d
Hipp
Per
f
ormanc
e
i
m
p
r
ovements on the main
l
oop of the LEMON
.
.
.
commit
|
commitdiff
|
tree
2018-04-21
D
.
Ri
c
hard Hip
p
En
h
ance LEMON to track which
s
y
mbols actuall
y
carry
.
.
.
commit
|
commitdiff
|
tree
2018-04-21
D
.
Richa
r
d
Hipp
Add
the %extra_co
n
text
d
irective to lemon, as a
n
alterna
t
ive
.
.
.
commit
|
commitdiff
|
tree
2018-04-21
D
.
Ri
c
har
d
Hipp
Fix UPSERT so t
h
at i
t
plays nicel
y
with A
U
T
O
I
NCREMENT
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
R
i
chard Hipp
Add the -
d
D
I
RECTORY
c
ommand-line
o
p
t
ion to LEMON
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Rich
a
r
d Hipp
Fix
a
harmless compiler warning
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
R
i
cha
r
d Hi
p
p
Avoid th
e
use of state
m
en
t
j
ournals
o
n DELETEs of a
.
.
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
R
ichard H
i
pp
Avoid open
i
ng
a st
a
tement journal on single-row UPDATEs
.
.
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Richard Hip
p
Fix a VDBE commen
t
o
n
upsert
.
Provide an error message
.
.
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
R
ichard Hipp
A
v
oid
u
nnecessary
cursor seeking
w
hen performing
an
.
.
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
R
ichard Hipp
Improved VDBE comment on
UPS
E
RT code
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Richard Hi
p
p
Minor
s
implifica
t
ion
o
f
the previous checkin
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Richar
d
Hip
p
Avoid unnecess
a
ry cursor s
e
eks during upser
t
process
i
n
g
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Ric
h
ard
H
i
pp
En
h
an
c
e U
P
SER
T
so th
a
t the
UPDATE uses
th
e
s
ame set
.
.
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Ric
h
a
r
d
Hipp
Minor simpli
f
ic
a
tion of the cu
r
sor allocation logic
.
.
.
commit
|
commitdiff
|
tree
2018-04-19
D
.
Ri
c
hard H
i
pp
Fix the
h
andling of "PRAGMA count_
c
hang
e
s=ON" with
.
.
.
commit
|
commitdiff
|
tree
2018-04-19
D
.
Richard Hipp
Minor simplific
a
tion
to the upser
t
l
o
g
i
c
.
commit
|
commitdiff
|
tree
2018-04-19
D
.
Ric
h
ard Hipp
Add th
e
--upse
r
t
option t
o
the wo
r
dcount test
p
rogram
.
commit
|
commitdiff
|
tree
2018-04-19
D
.
Richard Hipp
Add
t
h
e ext/misc/tem
p
latevtab
.
c tem
p
late for virtual
.
.
.
commit
|
commitdiff
|
tree
2018-04-19
D
.
Richard Hi
p
p
Fix
a
problem in the
n
ew upsert implemention, discovered
.
.
.
commit
|
commitdiff
|
tree
2018-04-19
D
.
Richar
d
Hipp
Fix
the
t
abl
e
name al
i
asing on
INSERT
so tha
t
i
t
oc
c
ur
s
.
.
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richard
Hipp
A
v
oid a NULL-po
i
nt
e
r
d
eref following O
O
M
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Ric
h
ard Hipp
Fix a tes
t
c
a
se inside
d
i
stinct
.
test
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richard Hipp
Impr
o
v
ed matchin
g
of COLLAT
E
c
lauses within the O
N
.
.
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Rich
a
rd Hipp
F
i
x a probl
e
m
in the
sqlite3E
x
pr
C
ompare()
function
.
.
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richard H
i
pp
Ad
d
support for P
o
st
g
reSQL UPSERT syntax and functionality
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richar
d
H
i
pp
F
ix the b
u
ild for S
Q
LIT
E
_OMIT_UPSERT
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richa
r
d Hi
p
p
A
dd t
h
e --sorterref N option to the CLI
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richar
d
Hi
p
p
O
mit some code not
used
witho
u
t SQLITE_
E
N
ABLE_SO
R
TER_REFEREN
.
.
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richa
r
d
Hipp
Remove an unused local va
r
iab
l
e
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richard Hipp
E
n
hance AL
T
ER TABLE
ADD COL
U
MN to support "D
E
FAULT
.
.
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richard Hipp
A
d
d
c
h
ecks
t
o
the CLI that iss
u
e
a warni
n
g if SQLite
.
.
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Ri
c
h
a
r
d Hipp
Add new testcase
(
)
macros
and fix a
b
ug that was re
v
ealed
.
.
.
commit
|
commitdiff
|
tree
2018-04-17
D
.
Ri
c
har
d
H
ip
p
R
e
m
o
v
e u
n
reachable
branches
.
1
0
0% MC/D
C
in TH3 now
.
commit
|
commitdiff
|
tree
2018-04-17
D
.
Richard
Hipp
Added a comm
e
nt
o
n the assert() added to the
p
revious
.
.
.
commit
|
commitdiff
|
tree
2018-04-17
D
.
R
i
c
hard H
i
pp
Fixes to the
l
og
i
c for constraint check reordering
.
.
.
commit
|
commitdiff
|
tree
2018-04-17
D
.
Richard Hipp
During
P
RAGMA v
d
be_addoptrace=ON, show calls to sqli
t
e3VdbeR
.
.
.
commit
|
commitdiff
|
tree
2018-04-17
D
.
Richard Hipp
TK_REGISTER
ex
p
ressions nodes are probably no
t
const
a
nt
.
.
.
commit
|
commitdiff
|
tree
2018-04-17
D
.
Richard H
i
pp
S
i
mp
l
i
f
i
cation to the upsert log
i
c
.
commit
|
commitdiff
|
tree
2018-04-17
D
.
Ric
h
a
r
d Hipp
New tes
t
cases f
o
r upsert
.
commit
|
commitdiff
|
tree
2018-04-16
D
.
R
ichard Hipp
Merge the Lemon
e
nhancement fro
m
tru
n
k
, resulting in
.
.
.
commit
|
commitdiff
|
tree
2018-04-16
D
.
Richard
H
ipp
Le
m
on enhance
m
ents:
(1) Do not allocate space for
.
.
.
commit
|
commitdiff
|
tree
2018-04-16
D
.
Rich
a
rd Hipp
Remove the MySQL ups
e
rt sy
n
tax
.
A
s an optional al
i
as
.
.
.
commit
|
commitdiff
|
tree
2018-04-16
D
.
Richard Hipp
Add su
p
port for
t
h
e "ex
c
luded
.
*
" names in the UPD
A
TE
.
.
.
commit
|
commitdiff
|
tree
2018-04-16
D
.
R
i
chard Hipp
Merge chang
e
s from tr
u
nk
.
commit
|
commitdiff
|
tree
2018-04-16
D
.
Richard Hipp
Increase
the version n
u
mbe
r
to
3
.
24
.
0
commit
|
commitdiff
|
tree
2018-04-16
D
.
Richard Hipp
Re
d
uc
e
the size
of
the Na
m
e
C
ontext object
b
y gr
o
uping
.
.
.
commit
|
commitdiff
|
tree
2018-04-14
D
.
Ri
c
hard
Hipp
Get upsert workin
g
o
n WITHO
U
T ROWID tabl
e
s
.
commit
|
commitdiff
|
tree
2018-04-14
D
.
R
i
chard Hipp
Mak
e
sure constra
i
n
t
c
h
e
cks occur in
t
he correct o
r
der
.
.
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
Ri
c
h
a
rd Hipp
First cut at logic to pe
r
form DO U
P
DATE
f
or rowi
d
tables
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
Richard Hipp
Ad
d
infra
s
tructure
f
or doing an UPDAT
E
as
part of
an
.
.
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
Richard
Hipp
Merg
e
the pre
u
pdat
e
hoo
k
change from trunk
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
Richard Hipp
Remove an alway
s
-
t
r
ue branch f
r
o
m the preupdate hook
.
.
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
Richa
r
d Hipp
Get the O
N
CONF
L
ICT
DO NOTHING f
o
rm
o
f upsert working
.
.
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
Richard Hip
p
Ge
t
the con
f
lict-target
c
lause pa
r
sing
w
ork
i
ng c
o
r
r
ectly
.
.
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
Ric
h
ard Hipp
Improved co
n
flict-tar
g
e
t ma
t
ching log
i
c
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
R
i
c
hard Hipp
Ba
c
k off
o
f the extended
u
psert sy
n
tax tha
t
allows
.
.
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
R
i
chard H
i
pp
B
e
g
i
n
a
d
ding upsert logic
.
This is an increm
e
ntal
.
.
.
commit
|
commitdiff
|
tree
2018-04-12
D
.
R
ichard Hipp
Br
e
ak out the upsert
c
ode
into a separat
e
source file
.
commit
|
commitdiff
|
tree
2018-04-12
D
.
Richar
d
H
ipp
Fix another ty
p
o in
a
comment
.
commit
|
commitdiff
|
tree
2018-04-12
D
.
Richard Hipp
Si
m
p
le comment cla
r
ificatio
n
.
No code or lo
g
ic
c
hanges
.
commit
|
commitdiff
|
tree
2018-04-12
D
.
Rich
a
r
d
Hip
p
Ext
e
nd the u
p
sert
s
ynt
a
x to allow a WHERE clause on
.
.
.
commit
|
commitdiff
|
tree
2018-04-12
D
.
Richard Hipp
Update t
h
e upser
t
parsing so that it accepts confl
i
ct
.
.
.
commit
|
commitdiff
|
tree
2018-04-12
D
.
Richard Hi
p
p
Add
t
he Upser
t
object fo
r
ho
l
ding ups
e
rt cl
a
u
se in
f
o
r
mation
.
commit
|
commitdiff
|
tree
2018-04-12
D
.
Ric
h
ard Hipp
Merge
chan
g
es from trunk
.
commit
|
commitdiff
|
tree
2018-04-11
D
.
Richard H
i
pp
Help th
e
par
s
er run fa
s
ter
b
y avoiding the "expla
i
n
.
.
.
commit
|
commitdiff
|
tree
2018-04-11
D
.
R
i
chard Hipp
Prohibit bo
u
nd parameters in the arguments to table
.
.
.
commit
|
commitdiff
|
tree
2018-04-10
D
.
Ric
h
a
r
d Hipp
V
e
rsion 3
.
2
3
.
1
commit
|
commitdiff
|
tree
2018-04-10
D
.
R
icha
r
d H
i
pp
Increase the
version n
u
mber to 3
.
2
3
.
1
.
commit
|
commitdiff
|
tree
2018-04-10
D
.
R
i
c
h
ard Hipp
Remove an unnecessary
SQ
L
I
T
E_U
N
T
E
S
T
A
BLE
c
o
m
pile-
t
im
e
.
.
.
commit
|
commitdiff
|
tree
2018-04-10
D
.
Richard H
i
pp
U
p
date the top-le
v
el R
E
ADME
.
md
f
ile to point to the
.
.
.
commit
|
commitdiff
|
tree
2018-04-10
D
.
Richard Hipp
Up
d
at
e
the
t
op-level RE
A
D
ME
.
md file to poi
n
t to
t
he
.
.
.
commit
|
commitdiff
|
tree
2018-04-09
D
.
Richard Hipp
M
i
nor changes to the
i
np
u
t grammar result
i
ng in a
fast
e
r
.
.
.
commit
|
commitdiff
|
tree
2018-04-09
D
.
Ri
c
hard Hipp
Enhance the query planner so t
h
at i
t
d
etects
w
hen
the
.
.
.
commit
|
commitdiff
|
tree
2018-04-09
D
.
Richa
r
d Hipp
Improvements to "
.
w
h
eretrace" output
.
commit
|
commitdiff
|
tree
2018-04-09
D
.
Ric
h
a
rd Hipp
Fix a (ha
r
m
less
)
signed
i
n
t
eger
overf
l
ow
w
arning
.
commit
|
commitdiff
|
tree
2018-04-07
D
.
Ric
h
a
rd Hipp
More comple
t
e parsin
g
of
U
PS
E
RT, inclu
d
ing
U
PSERT within
.
.
.
commit
|
commitdiff
|
tree
next