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
Do not attempt to use terms from the WHERE clause to drive indexes on the
2018-04-24
D
.
Richard Hipp
Do not a
t
t
e
mp
t
to
us
e
terms
f
rom the WHERE c
l
ause to
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
Richa
r
d Hipp
Update the expert
exte
n
sion tes
t
ca
s
es
to acco
u
nt for
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
Rich
a
rd Hi
p
p
All
t
h
e
O
R optimizati
o
n
to proceed even if
t
he
O
R
i
s
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
Ri
c
h
a
r
d Hipp
A
d
d a hyperlink to the ti
c
ket o
n
the code comment for
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
R
i
chard Hipp
Enh
a
nce the CLI to render EXP
L
AIN QUERY PLA
N
using
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
Rich
a
r
d Hipp
Fix a memory
le
a
k
following f
a
i
l
ure to open an
e
xternal
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
R
i
c
h
ar
d
Hipp
In E
X
PLAIN QUERY PLAN output, do not s
h
o
w
an EXECUTE
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
Richard Hipp
Fi
x
to check-in [ca34c2dd20ee071e] - avoid
a NULL
pointer
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Ri
c
hard
H
ipp
Fix
a
problem in sqlite3ExprCom
p
a
r
e() ass
o
ciated
w
ith
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Richard Hipp
Fix a forma
t
t
i
ng issue
i
n
the Tre
e
V
i
ew output fo
r
bare
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Richa
r
d
Hipp
Ad
d
t
h
e "
.
imposter o
f
f" variant of the "
.
imp
o
ster"
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Richard Hipp
The "
.
selecttrace 0x2000" command ca
u
ses
just the top
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Richar
d
Hipp
The "
.
selecttrace 4" command now show
s
only
a single
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Richard Hipp
D
o not restore the
i
SelectId value
u
ntil a
f
t
e
r the
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Richa
r
d Hipp
In th
e
"
.
se
l
ecttrace" outp
u
t, incl
u
de the EXPLAIN Q
U
ERY
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
R
ichard Hip
p
En
s
ure that
there are no
b
ind-pa
r
ameters or inco
r
rect
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Rich
a
r
d
Hip
p
Fix
a
n
unreachable
branc
h
associate
d
with
s
t
a
c
k
overflow
.
.
.
commit
|
commitdiff
|
tree
2018-04-21
D
.
R
i
chard H
i
pp
Performa
n
ce impr
o
vement
s
on the main loo
p
of the LEM
O
N
.
.
.
commit
|
commitdiff
|
tree
2018-04-21
D
.
Richard Hipp
Enhance
L
EMON to track
w
h
i
ch sy
m
bols actually carry
.
.
.
commit
|
commitdiff
|
tree
2018-04-21
D
.
Richard Hipp
A
dd the %extra_contex
t
directive to lemon,
a
s an al
t
erna
t
ive
.
.
.
commit
|
commitdiff
|
tree
2018-04-21
D
.
Richard Hipp
Fix
U
PSERT so
that
i
t plays nice
l
y with
A
UTOINCREMENT
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Richa
r
d
H
ipp
Add the -dDIRECTORY co
m
mand-l
i
ne o
p
tion to LEMON
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Richard
Hipp
F
i
x a harmless compiler
w
ar
n
ing
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Richard Hipp
A
v
oid the u
s
e of sta
t
eme
n
t journals on DEL
E
TEs of a
.
.
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
R
i
chard Hi
p
p
Avoid
ope
n
ing
a statement
journal o
n
single-ro
w
UPDATEs
.
.
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Richa
r
d
H
i
p
p
Fix a V
D
B
E
comme
n
t on
u
psert
.
Provide an erro
r
mes
s
a
g
e
.
.
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Richa
r
d Hi
p
p
Avoid
unnece
s
sar
y
cursor seeking wh
e
n perfor
m
i
n
g
a
n
.
.
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
R
ichard Hipp
Improved VDBE com
m
e
n
t o
n
U
P
SERT code
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Richard Hipp
Min
o
r simplificat
i
o
n of t
h
e
p
rev
i
ou
s
checkin
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Rich
a
rd Hipp
A
v
o
id unne
c
essary cursor seeks during u
p
s
e
rt
p
roc
e
ssing
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Richard Hipp
Enhance UPSERT so tha
t
the U
P
DATE u
s
es the same set
.
.
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
R
ich
a
rd
Hipp
Minor simplificatio
n
of the
c
ursor a
l
location logic
.
.
.
commit
|
commitdiff
|
tree
2018-04-19
D
.
Richard Hipp
Fix
t
he
ha
n
d
l
ing of "PRAGM
A
count_changes=ON"
with
.
.
.
commit
|
commitdiff
|
tree
2018-04-19
D
.
Richard Hipp
Minor simplific
a
t
ion t
o
the ups
e
rt logic
.
commit
|
commitdiff
|
tree
2018-04-19
D
.
R
ichard Hipp
Add t
h
e --upsert option
t
o
the wordcount test program
.
commit
|
commitdiff
|
tree
2018-04-19
D
.
Richard Hip
p
Add
the
ext/misc/templatevtab
.
c template
f
or v
i
r
tual
.
.
.
commit
|
commitdiff
|
tree
2018-04-19
D
.
Richard Hipp
Fix
a
problem
i
n
the new upsert implemention, d
i
scover
e
d
.
.
.
commit
|
commitdiff
|
tree
2018-04-19
D
.
Richard Hipp
Fix the table name al
i
asing on INSERT so tha
t
it occurs
.
.
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richard
H
ip
p
Av
o
id a NULL-point
e
r deref fo
l
low
i
ng
OOM
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
R
ichard Hipp
Fi
x
a
t
est cas
e
i
n
s
ide distin
c
t
.
te
s
t
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richa
r
d Hipp
Improv
e
d matching of COLLATE clauses wi
t
hin the ON
.
.
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richar
d
Hipp
Fix
a pr
o
blem in
t
he sq
l
ite3ExprC
o
mpare() funct
i
o
n
.
.
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richard H
i
pp
A
dd sup
p
ort for P
o
stgreSQL UPS
E
RT syntax and
f
unctionality
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richard Hipp
Fi
x
the
b
uild for S
Q
LITE_OMIT_UPSERT
commit
|
commitdiff
|
tree
2018-04-18
D
.
R
icha
r
d
Hipp
Add
t
he
--s
o
r
terref N o
p
t
io
n
to
the CLI
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richard Hipp
O
m
it some code not used without SQLITE_ENABLE_
S
O
RTE
R
_REFE
R
E
N
.
.
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richar
d
H
i
p
p
Remov
e
an unused local variable
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richard
Hipp
Enhance AL
T
E
R
T
ABLE ADD
COLUMN to support "DEFAULT
.
.
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richa
r
d Hipp
Add chec
k
s
t
o the CLI th
a
t issue a warning if S
Q
Lite
.
.
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Rich
a
rd Hipp
Ad
d
new testcase() m
a
c
ros and
fi
x
a bug th
a
t wa
s
revealed
.
.
.
commit
|
commitdiff
|
tree
2018-04-17
D
.
Rich
a
rd Hipp
R
e
move unreac
h
a
ble branc
h
es
.
10
0
% MC/DC in TH3 now
.
commit
|
commitdiff
|
tree
2018-04-17
D
.
Richard
H
ipp
A
d
de
d
a
comment on the
a
ssert
(
) added to the
pre
v
i
o
us
.
.
.
commit
|
commitdiff
|
tree
2018-04-17
D
.
Richard Hipp
F
i
xes
t
o the logic for co
n
straint c
h
eck reordering
.
.
.
commit
|
commitdiff
|
tree
2018-04-17
D
.
Richard Hipp
During PRAGMA vdb
e
_ad
d
o
p
t
r
ace
=
O
N
, show calls to sqlite3VdbeR
.
.
.
commit
|
commitdiff
|
tree
2018-04-17
D
.
R
ic
h
ard
Hipp
T
K_REGI
S
T
E
R
expres
s
ions nodes
a
re pr
o
bably not constant
.
.
.
commit
|
commitdiff
|
tree
2018-04-17
D
.
Richard Hipp
Simplification to th
e
upsert log
i
c
.
commit
|
commitdiff
|
tree
2018-04-17
D
.
R
ichar
d
Hipp
New
test cases for upser
t
.
commit
|
commitdiff
|
tree
2018-04-16
D
.
Richard Hip
p
Mer
g
e
t
he Lemon enhancement f
r
om
t
runk, result
i
ng in
.
.
.
commit
|
commitdiff
|
tree
2018-04-16
D
.
Richa
r
d Hipp
Lem
o
n en
h
ancemen
t
s: (1) Do no
t
allocate
space for
.
.
.
commit
|
commitdiff
|
tree
2018-04-16
D
.
Richar
d
H
ipp
Remove the MySQL upsert syntax
.
As an optional alias
.
.
.
commit
|
commitdiff
|
tree
2018-04-16
D
.
Richard H
i
pp
Add support for
t
he "excluded
.
*" names
in the UPDATE
.
.
.
commit
|
commitdiff
|
tree
2018-04-16
D
.
Rich
a
rd Hipp
Merge chan
g
es
f
rom trunk
.
commit
|
commitdiff
|
tree
2018-04-16
D
.
Richar
d
Hi
p
p
Increase
t
he versi
o
n
number to 3
.
24
.
0
commit
|
commitdiff
|
tree
2018-04-16
D
.
R
i
chard Hi
p
p
R
e
duc
e
t
h
e
size
o
f the
N
ameContext
object
by grou
p
ing
.
.
.
commit
|
commitdiff
|
tree
2018-04-14
D
.
Ri
c
hard Hipp
Get upsert working on WI
T
HOUT ROW
I
D tables
.
commit
|
commitdiff
|
tree
2018-04-14
D
.
Ric
h
a
r
d
Hipp
Ma
k
e sure constraint checks
o
ccur in t
h
e
cor
r
ect or
d
e
r
.
.
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
Rich
a
rd Hip
p
First c
u
t a
t
log
i
c to perform DO
U
PDA
T
E
f
or row
i
d
t
ables
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
Richard Hipp
A
d
d infrastructure for doin
g
an UPDATE as part
of an
.
.
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
R
ichard Hipp
M
e
rge the pr
e
update h
o
o
k change fro
m
t
r
u
nk
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
R
i
cha
r
d
Hipp
Rem
o
ve an a
l
ways-true branch from the preup
d
ate hook
.
.
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
Richard Hip
p
Get the
ON CONF
L
ICT DO
N
OTHING form of upsert wo
r
k
i
ng
.
.
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
Richard Hipp
Get
t
h
e
conflict-targ
e
t cla
u
se pa
r
sing
workin
g
cor
r
e
c
tly
.
.
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
Rich
a
rd Hipp
I
m
pr
o
ve
d
conflict-tar
g
e
t
matching
l
o
g
ic
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
R
ichard Hipp
Back off of the extended upsert syn
t
ax that allows
.
.
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
R
i
char
d
Hipp
B
e
gi
n
adding upsert
logic
.
This is an
i
n
crementa
l
.
.
.
commit
|
commitdiff
|
tree
2018-04-12
D
.
Richard Hipp
Break out the upsert code
into a separate source f
i
le
.
commit
|
commitdiff
|
tree
2018-04-12
D
.
R
ic
h
ard Hipp
Fix a
n
other typo in a comm
e
nt
.
commit
|
commitdiff
|
tree
2018-04-12
D
.
Richar
d
Hipp
Simp
l
e
comment clarification
.
No c
o
d
e
or logic
c
hanges
.
commit
|
commitdiff
|
tree
2018-04-12
D
.
Richard Hipp
Extend the upsert syn
t
ax to allow
a
WHER
E
clause on
.
.
.
commit
|
commitdiff
|
tree
2018-04-12
D
.
Richard Hip
p
Up
d
ate the upsert par
s
ing so th
a
t
it accepts confl
i
c
t
.
.
.
commit
|
commitdiff
|
tree
2018-04-12
D
.
R
ic
h
ard Hipp
A
dd the Ups
e
rt obj
e
ct for hold
i
ng upsert clau
s
e information
.
commit
|
commitdiff
|
tree
2018-04-12
D
.
R
ichard Hipp
Merge changes f
r
om trunk
.
commit
|
commitdiff
|
tree
2018-04-11
D
.
Rich
a
rd Hipp
Help the parser run fas
t
er by a
v
o
iding the
"
explain
.
.
.
commit
|
commitdiff
|
tree
2018-04-11
D
.
R
ichard Hipp
P
r
ohibit bound p
a
rameters
i
n the arg
u
ment
s
to table
.
.
.
commit
|
commitdiff
|
tree
2018-04-10
D
.
Rich
a
r
d
Hipp
V
e
rsion 3
.
23
.
1
commit
|
commitdiff
|
tree
2018-04-10
D
.
R
ich
a
rd Hipp
Increase
the version
number to
3
.
23
.
1
.
commit
|
commitdiff
|
tree
2018-04-10
D
.
R
ichard Hi
p
p
Remo
v
e
a
n
u
nnecessary S
Q
LITE_UNTESTAB
L
E com
p
ile-time
.
.
.
commit
|
commitdiff
|
tree
2018-04-10
D
.
Richard Hipp
U
p
date t
h
e to
p
-level
R
E
ADME
.
md
f
i
le to p
o
int t
o
the
.
.
.
commit
|
commitdiff
|
tree
2018-04-10
D
.
Richard
Hipp
Update th
e
top-level README
.
md file to po
i
nt to
th
e
.
.
.
commit
|
commitdiff
|
tree
2018-04-09
D
.
Richard Hipp
Minor c
h
an
g
es to the input
g
r
ammar
r
e
s
u
ltin
g
i
n a fas
t
er
.
.
.
commit
|
commitdiff
|
tree
2018-04-09
D
.
Richard Hipp
E
nh
a
n
ce the query plan
n
er so that it
d
etects w
h
e
n the
.
.
.
commit
|
commitdiff
|
tree
2018-04-09
D
.
Richard
H
ipp
Improvements to "
.
wheret
r
ace" output
.
commit
|
commitdiff
|
tree
2018-04-09
D
.
Richar
d
H
ipp
Fix a (har
m
less) signed i
n
t
e
g
er overflow
w
arnin
g
.
commit
|
commitdiff
|
tree
2018-04-07
D
.
Richard H
i
pp
More com
p
le
t
e parsi
n
g of UPSER
T
,
i
n
cluding UPSERT
w
i
t
hin
.
.
.
commit
|
commitdiff
|
tree
2018-04-06
D
.
Ri
c
hard
H
i
pp
Demon
s
trati
o
n
o
f
how the parser can be
a
u
g
mented to
.
.
.
commit
|
commitdiff
|
tree
2018-04-06
D
.
Richard Hipp
Enhance LEMON to
s
how precendence o
f
symbol
s
and
a
l
l
.
.
.
commit
|
commitdiff
|
tree
2018-04-05
D
.
Richard
Hipp
Fix the s
q
lite3WhereTr
a
ce mechanism so tha
t
i
t compil
e
s
.
.
.
commit
|
commitdiff
|
tree
2018-04-03
D
.
R
ichard Hipp
Fix an
error message in speedtest1
.
c a
n
d
m
a
k
e
the
.
.
.
commit
|
commitdiff
|
tree
2018-04-03
D
.
Richard Hi
p
p
F
i
x
t
h
e
g
en
e
rate_s
e
ries virtual table so tha
t
it correctly
.
.
.
commit
|
commitdiff
|
tree
2018-04-03
D
.
Richard Hipp
Change
t
he LEF
T
J
O
I
N strength
r
edu
c
tio
n
o
p
t
im
i
zati
o
n
.
.
.
commit
|
commitdiff
|
tree
next