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
Improvements to the EQP display for compound select statements.
2018-05-02
D
.
Ri
c
hard Hipp
Impr
o
vement
s
to the EQP display for
compound select
.
.
.
commit
|
commitdiff
|
tree
2018-05-02
D
.
Richard Hipp
Begin
reengineering th
e
EXP
L
AIN QUERY P
L
A
N
function
.
.
.
commit
|
commitdiff
|
tree
2018-05-01
D
.
Ri
c
hard Hipp
The
SQLITE_ALLOW_SQLITE_MASTER
_
INDEX
c
o
m
p
ile-tim
e
option
.
.
.
commit
|
commitdiff
|
tree
2018-04-28
D
.
R
i
chard Hipp
Test cases add
e
d fo
r
SQLIT
E
_
D
BCONFIG_RESET_DAT
A
BASE
.
commit
|
commitdiff
|
tree
2018-04-28
D
.
Richard
H
i
p
p
Add the SQLITE_DBCON
F
IG_RESET_DATA
B
ASE control for
.
.
.
commit
|
commitdiff
|
tree
2018-04-28
D
.
Richard H
i
pp
Add t
h
e SQLITE
_
DBCONFIG_RESE
T
_DATAB
A
SE con
t
rol as a
.
.
.
commit
|
commitdiff
|
tree
2018-04-28
D
.
Richard Hipp
Me
r
ge u
p
dat
e
s from tr
u
n
k
.
commit
|
commitdiff
|
tree
2018-04-28
D
.
Rich
a
rd Hipp
Pr
e
v
e
nt deep recu
r
s
i
ons on nested COLLA
T
E op
e
rators
.
commit
|
commitdiff
|
tree
2018-04-28
D
.
Richard
H
i
p
p
Fi
x
compiler warn
i
n
gs in FTS3
.
commit
|
commitdiff
|
tree
2018-04-28
D
.
Richa
r
d H
i
pp
Add the "PRAGMA r
e
set_database=ON|O
F
F" co
m
m
a
nd
.
When
.
.
.
commit
|
commitdiff
|
tree
2018-04-27
D
.
Ri
c
hard Hipp
Enhance
the comm
e
nts in
t
he
templatevtab
.
c implementation
.
commit
|
commitdiff
|
tree
2018-04-26
D
.
Richard H
i
pp
T
h
e
p
revious fix for ticket [d85fffd6ffe
8
56092ed8
d
a
.
.
.
commit
|
commitdiff
|
tree
2018-04-26
D
.
R
i
chard Hipp
En
s
ure tha
t
new
.
* values of
an UPDATE do not
get clobbered
.
.
.
commit
|
commitdiff
|
tree
2018-04-26
D
.
R
ichard Hipp
Cl
a
rification of the
b
ehavior
o
f
a BE
F
O
R
E U
P
DATE trigge
r
.
.
.
commit
|
commitdiff
|
tree
2018-04-26
D
.
Richard Hipp
Improved VD
B
E comment on the
O
P_
P
aram opcode
.
No subst
a
n
tia
.
.
.
commit
|
commitdiff
|
tree
2018-04-25
D
.
Richa
r
d
Hipp
A
d
d new interfa
c
es for acces
s
ing the
l
ist of SQL k
e
ywords:
commit
|
commitdiff
|
tree
2018-04-25
D
.
R
i
chard Hipp
Add t
h
e
n
ew
D
O
and NOTH
I
NG ke
y
words t
o
the keyword
.
.
.
commit
|
commitdiff
|
tree
2018-04-25
D
.
Richar
d
Hipp
A
dd
the new SQLITE_S
H
EL
L
_INIT_PROC
c
ompile
-
time entry
.
.
.
commit
|
commitdiff
|
tree
2018-04-25
D
.
Richard Hi
p
p
Av
o
id m
a
ny unneces
s
ary
calls to sqli
t
e3R
e
adSchema(
.
.
.
commit
|
commitdiff
|
tree
2018-04-25
D
.
R
ichard Hipp
A
dd a
n
assert()
t
o
ens
u
re that
s
chema mut
e
xes are he
l
d
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
Richard Hipp
Do not attempt
t
o
u
se terms f
r
om the W
H
ERE
clause to
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
Richard Hi
p
p
Update the
expert
exten
s
io
n
te
s
t case
s
to accou
n
t
f
or
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
Richard
H
i
pp
All
the OR optimiza
t
i
o
n t
o
proceed eve
n
if the O
R
is
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
Richard Hipp
Add a
h
y
p
erlink
t
o the
ticket on the code
comment for
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
Richard Hi
p
p
Enhance
the CLI to rende
r
EXPLAIN QUERY PLAN using
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
Ric
h
ard
Hipp
F
ix a memory
leak following failu
r
e to open an external
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
Richard H
i
pp
In EXPLAIN QUE
R
Y PLAN output, do not s
h
o
w
an
E
X
E
C
UTE
.
.
.
commit
|
commitdiff
|
tree
2018-04-24
D
.
Richard H
i
pp
Fix
t
o
c
h
eck-in [ca34c2dd2
0
ee
0
71e]
-
avoid
a NULL po
i
nter
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Richar
d
H
ipp
Fix a problem in sqlite3Exp
r
Compa
r
e(
)
asso
c
iate
d
with
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Richa
r
d Hipp
Fi
x
a forma
t
ting issue in the Tre
e
View output for
b
are
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Richard Hipp
Add th
e
"
.
impos
t
er off" va
r
i
a
nt of
the "
.
imposter"
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
R
i
c
hard Hip
p
T
h
e "
.
selec
t
t
r
ace 0x2000"
com
m
an
d
cau
s
es ju
s
t the top
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
R
ichard Hipp
The "
.
select
t
race
4
" c
o
mmand now shows
o
n
ly a
single
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Richard Hipp
Do not restore
t
he iSelectId value u
n
t
i
l afte
r
the
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Ric
h
ard Hipp
In t
h
e "
.
selecttrace
"
outpu
t
, i
n
clude the EXPLAIN
QUERY
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Rich
a
rd Hipp
Ensure
t
hat
t
here
a
r
e no bind-parameters
or incorrect
.
.
.
commit
|
commitdiff
|
tree
2018-04-23
D
.
Richard Hipp
Fix
a
n u
n
reachable branch associated
with sta
c
k
o
verflow
.
.
.
commit
|
commitdiff
|
tree
2018-04-21
D
.
Richard Hipp
Perfo
r
ma
n
ce
im
p
r
ovements on th
e
ma
i
n loop o
f
the LEMON
.
.
.
commit
|
commitdiff
|
tree
2018-04-21
D
.
Richa
r
d Hipp
Enhance
LEMON to trac
k
which symbol
s
actual
l
y
carry
.
.
.
commit
|
commitdiff
|
tree
2018-04-21
D
.
Richard Hipp
A
dd
t
h
e %extra
_
co
n
text d
i
rective to lemon
,
as an
alternative
.
.
.
commit
|
commitdiff
|
tree
2018-04-21
D
.
Richard Hipp
Fix
U
PSERT so tha
t
it
p
la
y
s nic
e
ly wit
h
AU
T
OI
N
CREMENT
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Richard H
i
pp
Add the -dDIREC
T
ORY command-line option
to LEMON
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Richard Hipp
Fix a harmless comp
i
l
er
w
arni
n
g
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Ri
c
hard Hipp
Avoid
the use of stat
e
ment journals on
D
E
LETEs of
a
.
.
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Richard
Hipp
A
void op
e
ning
a
s
tatement jou
r
nal
o
n
single-
r
o
w U
P
DA
T
Es
.
.
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Ric
h
ard Hipp
Fix a VDBE commen
t
on
upse
r
t
.
Provide an
e
rror mes
s
ag
e
.
.
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Richard Hi
p
p
Avoid unnecessar
y
cursor seeking when performing a
n
.
.
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Richard Hipp
I
mproved
VDBE comment
on UPSERT co
d
e
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Ri
c
hard Hipp
Minor simplification of
t
he pre
v
i
o
u
s
checki
n
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
R
i
c
hard Hipp
Avoid unneces
s
ary c
u
r
sor seek
s
during upsert processing
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Richard Hipp
Enhance
U
PSERT so t
h
at the UPDA
T
E u
s
es t
h
e same set
.
.
.
commit
|
commitdiff
|
tree
2018-04-20
D
.
Richard Hip
p
Minor
s
implificat
i
on of the
c
urso
r
allocation
logic
.
.
.
commit
|
commitdiff
|
tree
2018-04-19
D
.
R
i
chard Hipp
Fix the
handling of "PRAGMA count_cha
n
ges
=
ON" with
.
.
.
commit
|
commitdiff
|
tree
2018-04-19
D
.
R
i
cha
r
d Hipp
Minor simplifica
t
ion to the u
p
sert l
o
g
i
c
.
commit
|
commitdiff
|
tree
2018-04-19
D
.
R
ichard Hipp
Add
t
h
e
--upsert
o
ption to
t
he wordcount test program
.
commit
|
commitdiff
|
tree
2018-04-19
D
.
Richard Hipp
Add the ext/misc/templ
a
tevtab
.
c
template for virtual
.
.
.
commit
|
commitdiff
|
tree
2018-04-19
D
.
Rich
a
rd Hip
p
Fix
a
proble
m
in
the new upser
t
i
mplemention, di
s
cove
r
ed
.
.
.
commit
|
commitdiff
|
tree
2018-04-19
D
.
Richard Hipp
Fix the table name alia
s
i
ng
o
n INSE
R
T so tha
t
it occurs
.
.
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richa
r
d Hip
p
Avoid a NULL-p
o
inter
d
e
ref
f
ollowing OOM
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Ric
h
ard Hipp
Fix a test case inside disti
n
ct
.
tes
t
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richard Hip
p
Im
p
roved matc
h
ing of
COLLATE clauses within the ON
.
.
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richard
Hipp
Fix a prob
l
em i
n
the s
q
l
i
t
e3ExprCompare()
func
t
ion
.
.
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Ric
h
ar
d
Hipp
Add suppo
r
t f
o
r
P
ostgre
S
QL UP
S
E
R
T syntax and functionality
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richard Hipp
Fix the b
u
ild for S
Q
LITE_OMIT_UPSERT
commit
|
commitdiff
|
tree
2018-04-18
D
.
R
ichard Hipp
A
dd the --s
o
rte
r
re
f
N option to
t
h
e CLI
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richard
Hipp
O
m
it
s
ome co
d
e not
u
s
e
d w
i
tho
u
t SQLITE
_
E
N
A
B
LE_SORTER_REFEREN
.
.
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richa
r
d Hip
p
Remove
an unused local v
a
riable
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
R
ich
a
r
d
H
i
pp
Enhance ALTER TABLE ADD COLUM
N
to
s
upport
"
DEFAUL
T
.
.
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richard Hipp
A
dd checks to t
h
e C
L
I
t
hat issue a
w
arning if
SQLite
.
.
.
commit
|
commitdiff
|
tree
2018-04-18
D
.
Richard Hip
p
Add new testc
a
se()
macro
s
and fi
x
a
bug that w
a
s revealed
.
.
.
commit
|
commitdiff
|
tree
2018-04-17
D
.
Richard Hipp
Remo
v
e unreachable branches
.
100% MC/DC in TH3 now
.
commit
|
commitdiff
|
tree
2018-04-17
D
.
Richa
r
d
Hipp
Adde
d
a co
m
men
t
on the a
s
sert(
)
added to the prev
i
o
us
.
.
.
commit
|
commitdiff
|
tree
2018-04-17
D
.
Richard H
i
pp
Fixes to the logic for
c
o
nstraint
c
heck
r
eor
d
e
r
i
ng
.
.
.
commit
|
commitdiff
|
tree
2018-04-17
D
.
Ric
h
a
r
d
H
ipp
During PRAGMA vdbe_addoptrace=O
N
, show
c
all
s
to sqli
t
e3VdbeR
.
.
.
commit
|
commitdiff
|
tree
2018-04-17
D
.
R
i
char
d
Hipp
TK_REGISTER expre
s
sion
s
nodes are probab
l
y not co
n
sta
n
t
.
.
.
commit
|
commitdiff
|
tree
2018-04-17
D
.
Richard Hipp
Simplifi
c
a
t
io
n
to the u
p
s
e
rt lo
g
i
c
.
commit
|
commitdiff
|
tree
2018-04-17
D
.
R
i
chard Hipp
New
t
est
cases fo
r
upsert
.
commit
|
commitdiff
|
tree
2018-04-16
D
.
Richard Hipp
Merge the L
e
mon enhanc
e
m
e
nt from t
r
u
nk
,
resulting
in
.
.
.
commit
|
commitdiff
|
tree
2018-04-16
D
.
Richard Hip
p
Lem
o
n enhanc
e
me
n
t
s: (
1
)
D
o not al
l
ocate
s
pace for
.
.
.
commit
|
commitdiff
|
tree
2018-04-16
D
.
Richa
r
d Hipp
R
emove the MySQ
L
upsert syntax
.
As an opt
i
onal alias
.
.
.
commit
|
commitdiff
|
tree
2018-04-16
D
.
Ri
c
hard Hi
p
p
Add su
p
port for the "e
x
cluded
.
*" names in th
e
UPDAT
E
.
.
.
commit
|
commitdiff
|
tree
2018-04-16
D
.
R
icha
r
d H
i
pp
Mer
g
e c
h
a
n
g
e
s from trunk
.
commit
|
commitdiff
|
tree
2018-04-16
D
.
Rich
a
rd Hipp
Increase the version n
u
mb
e
r to 3
.
24
.
0
commit
|
commitdiff
|
tree
2018-04-16
D
.
Ri
c
hard H
i
pp
Reduce the size of the NameContext obje
c
t by group
i
ng
.
.
.
commit
|
commitdiff
|
tree
2018-04-14
D
.
Richard
H
ipp
Get upsert workin
g
on W
I
TH
O
UT RO
W
ID tables
.
commit
|
commitdiff
|
tree
2018-04-14
D
.
Richard
H
ipp
Make sure co
n
s
traint checks occur i
n
the correct order
.
.
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
Ric
h
ard Hipp
First cut at logic to
p
erform
DO UPDATE
f
or
r
owid tables
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
Ric
h
ar
d
Hipp
A
d
d infrastructure
f
or doing an UPDA
T
E as part of an
.
.
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
Rich
a
rd Hipp
Merge th
e
preupdate hook
change from trunk
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
R
i
chard
H
ipp
Remo
v
e
an always-tr
u
e branch from the preupdate
hook
.
.
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
Richard
H
ip
p
Get
t
he ON CONFLI
C
T
DO NOTHING f
o
rm of upsert w
o
rk
i
ng
.
.
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
Rich
a
rd
Hipp
Get the
conflict-
t
a
r
get clause pars
i
n
g working correctly
.
.
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
Richard Hipp
Improved conflict-ta
r
get matching logic
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
Richard Hip
p
Bac
k
off of the exten
d
ed upsert synt
a
x
t
h
at
allows
.
.
.
commit
|
commitdiff
|
tree
2018-04-13
D
.
Richard
H
ipp
Be
g
in
adding upsert lo
g
i
c
.
This is an incremental
.
.
.
commit
|
commitdiff
|
tree
2018-04-12
D
.
Richard Hip
p
Break out t
h
e u
p
sert code into a
sepa
r
ate
sour
c
e
file
.
commit
|
commitdiff
|
tree
2018-04-12
D
.
Richar
d
Hi
p
p
F
ix another ty
p
o in a com
m
ent
.
commit
|
commitdiff
|
tree
2018-04-12
D
.
Rich
a
r
d Hipp
Simple comment
clari
f
i
c
ation
.
No code or logic changes
.
commit
|
commitdiff
|
tree
2018-04-12
D
.
Rich
a
rd H
i
pp
Extend the
u
psert
synta
x
to allow
a WHERE
c
l
a
use o
n
.
.
.
commit
|
commitdiff
|
tree
2018-04-12
D
.
Richard Hipp
Update the upsert par
s
ing so
that
i
t accepts conflict
.
.
.
commit
|
commitdiff
|
tree
next