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 even try star-schema detection if the join has fewer than 5 tables,
25 hours ago
D
.
Richard Hipp
D
o
not
e
v
en try star-schema dete
c
tion if the join ha
s
.
.
.
commit
|
commitdiff
|
tree
26 hours ago
D
.
Richard Hipp
Document the O
P
_
E
xpl
a
in op
c
o
de
.
Add the
W
h
ereLoop
.
.
.
commit
|
commitdiff
|
tree
2 days ago
D
.
Richa
r
d Hip
p
Ensure that the
s
econd pass call to whe
r
e
Path
S
o
l
v
e
r
.
.
.
commit
|
commitdiff
|
tree
3 days ago
D
.
Ric
h
ard Hi
p
p
Rem
o
ve an unused pa
r
a
m
e
t
e
r
from
fts5Co
n
figParseSpecial
.
.
.
commit
|
commitdiff
|
tree
3 days ago
D
.
Ric
h
ard Hi
p
p
Use a heuristic of artifically lowering the cost of
.
.
.
commit
|
commitdiff
|
tree
3 days ago
D
.
R
i
c
hard H
i
pp
Change a
n
a
s
s
ert() (incorrectl
y
) added by the
p
reviou
s
.
.
.
commit
|
commitdiff
|
tree
3 days ago
D
.
Richard Hipp
Small performance enha
n
cemen
t
i
n
wherePathSolver()
commit
|
commitdiff
|
tree
3 days ago
D
.
Richard Hipp
Improvem
e
nts
to com
m
e
n
ts
and
d
ebu
g
ging output
.
commit
|
commitdiff
|
tree
3 days ago
D
.
R
i
chard Hipp
Re
m
ember the amount of
the heuristic co
s
t
adj
u
s
tment
.
.
.
commit
|
commitdiff
|
tree
3 days ago
D
.
Richard Hip
p
Fix ty
p
o
s
in th
e
star-schem
a
test cases
.
commit
|
commitdiff
|
tree
3 days ago
D
.
Richa
r
d Hipp
Use a heur
i
s
t
ic
i
n
t
h
e query planner to
h
elp
it better
.
.
.
commit
|
commitdiff
|
tree
3 days ago
D
.
Richard Hipp
F
ix a
couple of
assert() statements so
t
hat they cannot
.
.
.
commit
|
commitdiff
|
tree
3 days ago
D
.
Richard
H
i
pp
Tweaks to the query planner so tha
t
i
t is better
a
ble
.
.
.
commit
|
commitdiff
|
tree
4 days ago
D
.
Richard Hipp
Increas
e
the number of pa
r
allel p
a
ths in the que
r
y
.
.
.
commit
|
commitdiff
|
tree
4 days ago
D
.
R
i
chard Hipp
Documentation typo
fi
x
.
[forum:/f
o
r
umpost/
7
72d6688f5
.
.
.
commit
|
commitdiff
|
tree
4 days ago
D
.
Richard H
i
pp
I
mprove the automatic-index decis
i
on such
that
no att
e
m
pt
.
.
.
commit
|
commitdiff
|
tree
4 days ago
D
.
Richar
d
Hipp
Query planner tun
i
ng
:
Inc
r
ease the
m
axi
m
um n
u
mber
.
.
.
commit
|
commitdiff
|
tree
4 days ago
D
.
Rich
a
r
d Hipp
A
void creating an
a
utomatic index on
a column tha
t
.
.
.
commit
|
commitdiff
|
tree
4 days ago
D
.
R
ichard
H
i
pp
The
p
reviou
s
check-in was
a
little two aggre
s
siv
e
about
.
.
.
commit
|
commitdiff
|
tree
4 days ago
D
.
Richard Hipp
F
i
x
t
y
po in comment
u
sed to generate parts
o
f t
h
e documentation
.
commit
|
commitdiff
|
tree
5 days ago
D
.
R
ic
h
a
rd
Hipp
Very
s
mall performance
i
ncrease an
d
size reduction
.
.
.
commit
|
commitdiff
|
tree
5 days ago
D
.
Richard Hipp
For c
o
mpati
b
ility with Post
g
reSQL, when ri
g
ht-h
a
nd
.
.
.
commit
|
commitdiff
|
tree
5 days ago
D
.
Richard
H
ipp
Add n
e
w assert()
s
tatements to hel
p
out a static a
n
alyzer
.
.
.
commit
|
commitdiff
|
tree
6 days ago
D
.
R
ichard Hipp
Ensur
e
t
h
a
t sqlite3ViewGetColumn
N
ames() returns
non
.
.
.
commit
|
commitdiff
|
tree
7 days ago
D
.
Richard Hipp
Ensure that quer
i
es
like "SELECT func(a) FR
O
M tab GROUP
.
.
.
commit
|
commitdiff
|
tree
7 days ago
D
.
Richard Hipp
When
omitting result columns for the
vector-IN
o
pt
i
mization
.
.
.
commit
|
commitdiff
|
tree
8 days ago
D
.
Richard Hipp
Add
the stm
t
rand() e
x
tension
funct
i
o
n for
u
se in
testing
.
commit
|
commitdiff
|
tree
8 days ago
D
.
Richar
d
Hip
p
Fi
x
the
window-function group_concat() so that it ret
u
rns
.
.
.
commit
|
commitdiff
|
tree
9 days ago
D
.
Ric
h
ard Hipp
M
e
rge various enhancements t
h
at were be
i
ng hel
d
o
n
.
.
.
commit
|
commitdiff
|
tree
9 days ago
D
.
Ric
h
ard Hipp
Increase the version number to 3
.
47
.
0 to be
g
in the
.
.
.
commit
|
commitdiff
|
tree
9 days ago
D
.
R
ichard Hipp
Ve
r
s
i
on 3
.
46
.
0
commit
|
commitdiff
|
tree
11 days ago
D
.
Richard Hipp
Fix harmless compiler warn
i
ngs
.
commit
|
commitdiff
|
tree
11 days ago
D
.
Rich
a
rd Hipp
F
i
x the -> and -
>
> o
p
erators so that when
the RHS
is
.
.
.
commit
|
commitdiff
|
tree
11 days ago
D
.
Richar
d
Hipp
Omit
a
capi3 test
f
ro
m
20
0
7 that depe
n
ds upon und
e
fined
.
.
.
commit
|
commitdiff
|
tree
11 days ago
D
.
Rich
a
rd Hipp
I
m
provem
e
nts to the docume
n
tation of sqli
t
e3_vtab_dis
t
inct
.
.
.
commit
|
commitdiff
|
tree
12 days ago
D
.
Richard Hipp
Improvements
to the sq
l
ite3_vta
b
_d
i
stinct
(
) documen
t
ation
.
commit
|
commitdiff
|
tree
13 days ago
D
.
Richard Hip
p
Fix the
d
e
fi
n
ition
o
f sqlite3_vtab_distinc
t
() such
.
.
.
commit
|
commitdiff
|
tree
2024-05-17
D
.
Richard Hipp
I
mprovemen
t
s to a VDB
E
comment
.
No changes to anythi
n
g
.
.
.
commit
|
commitdiff
|
tree
2024-05-16
D
.
Ri
c
hard Hip
p
The sql
i
te3_
d
ec
l
are_
v
tab()
i
nterface s
h
ould return
.
.
.
commit
|
commitdiff
|
tree
2024-05-16
D
.
Richard Hip
p
Fix
a
ca
s
e where
a
n error in the
ORDER BY c
l
au
s
e
of
.
.
.
commit
|
commitdiff
|
tree
2024-05-15
D
.
Rich
a
r
d
Hipp
B
ack out the
ass
e
rt() fixe
s
from
[a9443dbfbe25e588
.
.
.
commit
|
commitdiff
|
tree
2024-05-12
D
.
Richard
H
i
p
p
Optimiz
a
tion in the i
m
ple
m
enta
t
ion o
f
OP_Ope
n
Read and
.
.
.
commit
|
commitdiff
|
tree
2024-05-10
D
.
R
i
chard H
i
pp
Fix
a
ggregate function processing
to correctly deal
.
.
.
commit
|
commitdiff
|
tree
2024-05-10
D
.
Richard Hipp
The
s
q
l
i
t
e3
F
a
u
ltSim
(
300) e
r
ro
r
from [1e8863909ac369
e
5
.
.
.
commit
|
commitdiff
|
tree
2024-05-10
D
.
Richar
d
Hi
p
p
Improvements to the "
.
testctrl
f
ault
_
in
s
tall" command
.
.
.
commit
|
commitdiff
|
tree
2024-05-10
D
.
R
i
c
har
d
Hi
p
p
Add
a
n sql
i
te3FaultS
i
m(300) call to
t
he sqlite
3
ParserAddC
l
ea
.
.
.
commit
|
commitdiff
|
tree
2024-05-08
D
.
Richard Hipp
Allow arbitrary expressi
o
ns as
t
he second arg
u
ment
.
.
.
commit
|
commitdiff
|
tree
2024-05-08
D
.
Richard Hipp
Fix a hyperlin
k
t
ypo in
sess
i
on d
o
cumentation
.
commit
|
commitdiff
|
tree
2024-05-06
D
.
R
i
c
har
d
Hip
p
Omit redun
d
ant
u
nar
y
+ operators from th
e
AST
.
commit
|
commitdiff
|
tree
2024-05-06
D
.
Richard
Hipp
A
vo
i
d unne
c
e
ssary recursion in sqlite
3
ExprDeleteNN
.
.
.
commit
|
commitdiff
|
tree
2024-05-05
D
.
Richard Hi
p
p
Add comment to the
test/lemon-test01
.
y
f
i
l
e indicating
.
.
.
commit
|
commitdiff
|
tree
2024-05-04
D
.
Richard Hipp
Assume tha
t
an
SQL fun
c
tion is
able to return
a subtype
.
.
.
commit
|
commitdiff
|
tree
2024-05-04
D
.
Richard Hip
p
Assume that a function is able to return
a
subtype
.
.
.
commit
|
commitdiff
|
tree
2024-05-04
D
.
R
ichard Hipp
Functions
th
a
t pass through the
s
qlite3_value of one
.
.
.
commit
|
commitdiff
|
tree
2024-05-03
D
.
Richar
d
Hipp
Th
e
coal
e
sce(), if
n
ul
l
(), an
d
iif() funct
i
ons
p
ass
.
.
.
commit
|
commitdiff
|
tree
2024-05-02
D
.
Richard
H
ipp
Fix
t
he CREA
T
E TA
B
LE
p
erforma
n
ce issue described
by
commit
|
commitdiff
|
tree
2024-05-02
D
.
Rich
a
rd H
i
pp
Add a
t
est case to th
e
fix to
P
RA
G
MA i
n
tegrity_che
c
k
.
.
.
commit
|
commitdiff
|
tree
2024-05-02
D
.
Richa
r
d Hipp
D
o
not accept a string
that
l
o
oks like a number used
.
.
.
commit
|
commitdiff
|
tree
2024-05-02
D
.
Rich
a
rd
Hipp
O
m
i
t the OP_S
q
lExec to "P
R
AGMA integri
t
y_che
c
k" added
.
.
.
commit
|
commitdiff
|
tree
2024-04-26
D
.
R
icha
r
d Hipp
Fix
i
ssues in [/info/1e227ad9f41322
7
f|LIMIT/OFFSET
.
.
.
commit
|
commitdiff
|
tree
2024-04-26
D
.
Richar
d
Hipp
F
ur
t
her fixes and improvem
e
nts
to the generate_
s
erie
s
.
.
.
commit
|
commitdiff
|
tree
2024-04-26
D
.
Ri
c
hard Hipp
Use hex
flag masks
rathe
r
than d
e
cimals in ext
/
misc
.
.
.
commit
|
commitdiff
|
tree
2024-04-26
D
.
Richard H
i
pp
F
i
x h
a
ndling of L
I
M
IT a
n
d OFFSET i
n
virtual tables
.
.
.
commit
|
commitdiff
|
tree
2024-04-26
D
.
Richard H
i
pp
Enha
n
ce the generated
_
s
eries() table-val
u
ed-
f
unction
.
.
.
commit
|
commitdiff
|
tree
2024-04-26
D
.
Richard Hipp
Fi
x
the T
r
eeVie
w
display of a
LI
M
IT clause
o
n a compound
.
.
.
commit
|
commitdiff
|
tree
2024-04-25
D
.
Richard
Hipp
I
mpro
v
ement to the way that affinity is determined
.
.
.
commit
|
commitdiff
|
tree
2024-04-25
D
.
Ri
c
hard Hipp
Further improvement
s
to the compu
t
ation of
a
f
fi
n
ity
.
.
.
commit
|
commitdiff
|
tree
2024-04-25
D
.
Richard Hipp
Back o
u
t the
previous
c
hange
o
n this
bra
n
ch
.
In its
.
.
.
commit
|
commitdiff
|
tree
2024-04-24
D
.
Ri
c
hard Hipp
An exp
e
rimental min
o
r
tweak t
o
the
way affini
t
i
e
s are
.
.
.
commit
|
commitdiff
|
tree
2024-04-24
D
.
Richar
d
Hipp
If a RE
T
URNIN
G
clause
c
o
ntains a
s
ubquery that re
f
erences
.
.
.
commit
|
commitdiff
|
tree
2024-04-24
D
.
Richard Hipp
Add com
m
e
n
ts linking the assert() add
e
d i
n
[cef4d9e3
b
a5
8
6735
.
.
.
commit
|
commitdiff
|
tree
2024-04-24
D
.
Richard Hi
p
p
E
n
sure that
t
emporary SrcItem objects created b
y
trigger
.
.
.
commit
|
commitdiff
|
tree
2024-04-23
D
.
Richard Hipp
Fix a pr
o
blem with vector IN o
p
era
t
o
r
s used
wit
h
an
.
.
.
commit
|
commitdiff
|
tree
2024-04-22
D
.
Richard H
i
pp
E
x
tra robustness in
the code th
a
t
c
ause
s
cur
s
o
r
s
to
.
.
.
commit
|
commitdiff
|
tree
2024-04-22
D
.
Richard Hipp
C
ontinuati
o
n
of
t
h
e fix at [8c0f69e0e4ae
0
a44]:
I
f a
.
.
.
commit
|
commitdiff
|
tree
2024-04-21
D
.
Richa
r
d H
i
pp
Fix an inden
t
at
i
on problem in debugging
routine
sqli
t
e
3
S
how
S
.
.
.
commit
|
commitdiff
|
tree
2024-04-18
D
.
R
i
char
d
Hipp
Cor
r
ect handling o
f
O
U
T
ER JOIN when on
o
r t
h
e oth
e
r
.
.
.
commit
|
commitdiff
|
tree
2024-04-15
D
.
Richard Hipp
The fi
r
st asser
t
() added in [0e
b
c
6
54
8
1f4a3
e
79] is n
o
t
.
.
.
commit
|
commitdiff
|
tree
2024-04-12
D
.
Richard Hipp
If a b
u
ild
fails in testrunner
.
tcl,
do not attempt
.
.
.
commit
|
commitdiff
|
tree
2024-04-12
D
.
R
ic
h
ard Hipp
Fi
x
es and new
t
e
s
t
s logic t
o
ensure
that
t
h
e
btree
.
.
.
commit
|
commitdiff
|
tree
2024-04-12
D
.
R
i
c
hard Hip
p
Add
a
sse
r
t
(
)
st
a
tements to help ve
r
i
f
y
the ov
e
rflow
.
.
.
commit
|
commitdiff
|
tree
2024-04-12
D
.
Richard Hipp
N
e
w
assert(
)
s
tateme
n
ts t
o
verify the
c
or
r
ectness of
.
.
.
commit
|
commitdiff
|
tree
2024-04-12
D
.
Richard Hipp
Tes
t
ca
s
e f
o
r
t
he fix in
the previous check-i
n
.
commit
|
commitdiff
|
tree
2024-04-12
D
.
R
i
chard Hipp
Ma
r
k the BTr
e
e
c
el
l
o
verflow cache as inv
a
lid whenev
e
r
.
.
.
commit
|
commitdiff
|
tree
2024-04-09
D
.
R
ichard Hip
p
The read-only CHECK
-
con
s
train
t
opt
i
mization of [
3
4ddf02d3
d
21
.
.
.
commit
|
commitdiff
|
tree
2024-04-08
D
.
Ri
c
hard Hipp
Enhan
c
e the WHERE-clause push-down optimization so
.
.
.
commit
|
commitdiff
|
tree
2024-04-08
D
.
Richard Hipp
Fi
x
a harmless
compiler
warni
n
g in the ICU extension
.
.
.
commit
|
commitdiff
|
tree
2024-04-08
D
.
Richard Hi
p
p
En
h
anc
e
m
e
nts to th
e
fuzzer invariant c
h
ecker to
t
urn
.
.
.
commit
|
commitdiff
|
tree
2024-04-07
D
.
Richard Hipp
Merge trunk testing enhancements into the pu
s
h
down
.
.
.
commit
|
commitdiff
|
tree
2024-04-07
D
.
Richard Hip
p
Omit
a
ll row
i
d-in
-
v
i
ew restrictions from the fuzzinvarian
t
.
.
.
commit
|
commitdiff
|
tree
2024-04-07
D
.
Rich
a
r
d Hip
p
If SQL
I
T
E
_A
L
LO
W
_ROWID_
I
N
_VIEW is set
t
o
2,
t
hen a
l
l
.
.
.
commit
|
commitdiff
|
tree
2024-04-07
D
.
Richard H
i
pp
Merge
trunk enha
n
cement
s
into the
p
u
s
h
d
own-subquery
.
.
.
commit
|
commitdiff
|
tree
2024-04-07
D
.
R
i
chard
H
ipp
Add comments to
n
o
te the
name abiguity bet
w
e
en the
.
.
.
commit
|
commitdiff
|
tree
2024-04-06
D
.
Richard Hip
p
Do not
a
ll
o
w changes to sqlite
3
Expr
I
sTab
l
eCon
s
tant
.
.
.
commit
|
commitdiff
|
tree
2024-04-06
D
.
Ri
c
hard Hipp
Merge testi
n
g logi
c
f
ixes on
t
runk i
n
t
o the pushdow
n
.
.
.
commit
|
commitdiff
|
tree
2024-04-06
D
.
Rich
a
rd H
i
pp
Impro
v
ements
t
o the accurancy
of the
f
uzzinvar
i
ants
.
.
.
commit
|
commitdiff
|
tree
2024-04-06
D
.
Richard Hipp
Ge
n
eralize pu
s
hdo
w
n to allow any uncorr
e
lated
s
ubquery
.
.
.
commit
|
commitdiff
|
tree
2024-04-05
D
.
Ric
h
ard Hipp
Experimental en
h
ancement i
n
which e
x
pres
s
ions of the
.
.
.
commit
|
commitdiff
|
tree
2024-04-05
D
.
Ri
c
hard Hipp
Ch
e
ck
-
i
n
[a9
6
57c87c53
c
1
922] is
w
r
ong: the IndexedExpr
.
.
.
commit
|
commitdiff
|
tree
2024-04-05
D
.
Richard Hipp
W
h
en compiling
w
ith SQLITE_ALLO
W
_ROWID_IN_VIEW, if
.
.
.
commit
|
commitdiff
|
tree
next