Hi there,
As title, just curious whether have plan for later version, for example
3.4.x?
Thanks,
Halton.
-
To unsubscribe, send email to [EMAIL PROTECTED]
--- Aladdin Lampé <[EMAIL PROTECTED]> wrote:
> In other terms, which built-in functions can I safely remove (or rename)
> without getting
> internal errors?
> I hope I can remove or rename all of them without compilation or execution
> errors... What do you
> think?
It depends on your use.
Some
Hi sqlite-users!
In other terms, which built-in functions can I safely remove (or rename)
without getting internal errors?
I hope I can remove or rename all of them without compilation or execution
errors... What do you think?
Thanks a lot!
Here's the list! ;-)
min FUNCTION
max FUNCTION
To answer my own question:
The magic is in either
SQLITE_CASE_SENSITIVE_LIKE
compile time option or
CASE_SENSITIVE_LIKE pragma.
I have seen this before, but it just didn't stick in my small memory
bank.
Mark
> -Original Message-
> From: Evans, Mark (Tandem)
> Sent: Monday,
Hi all,
In a virtual table context, I expected a statement such as
select * from t where x like 'abc%'
to pass a constraint for the LIKE clause to xBestIndex method of virtual
table module but it doesn't get such a constraint. I expected
SQLITE_INDEX_CONSTRAINT_MATCH. Do I have to do
Hi Valerio,
On Mon, 5 Nov 2007 18:51:20 +0100, "Valerio Bontempi"
<[EMAIL PROTECTED]> wrote:
>Hi All,
>
>I'm new in your mailing list.
>I need to use sqlite and not sqlite3 because of php still support only the
>first version.
>I read that sqlite3 support table renaming with common sql syntax
Ken <[EMAIL PROTECTED]> writes:
> 1. (*) text/plain
>
> Per your wiki link:
>
> Q) How can the strict affinity mode be used which is claimed to exist on
> http://www.sqlite.org/datatype3.html A) This has not been implemented as of
> version 3.3.13.
Yes I read that (I referenced
Igor Tandetnik
> select rowid, A, B, C
> from t
> where A||B||C in
> ( select A||B||C
> from t
> group by A, B, C
> having count(*)>1
> );
Wouldn't that mistakenly consider a record ('xy', 'z', 'w') to be
duplicate of ('x', 'yz', 'w') ?
Igor Tandetnik
Due the fact that, in this case, the
I'm new to this forum and something of a novice in SQL, but I'm not sure
that any of the queries presented have met the criteria requested, or at
least not in the simplest manner possible. Consider the following
table:
CREATE TABLE t1(f1, f2, f3);
INSERT INTO "t1" VALUES('x','y','z');
INSERT
If I have data as follows, they wont show up when I try to search for
them.=20 [[[ ]]]=20
[EMAIL PROTECTED]&*=20
()_+|{}:=14<>?=20
-=3D\[];',./=20
@@@ %%%=20
### ^^^=20
___---=20
Ho_mer=20
[EMAIL PROTECTED]&*()_+|`{}:=14<>?-=3D\[];=12,./=20
_Storage-Room=20
@ # $=20
_ - +=20
% ^ &=20
On 05/11/2007, Igor Tandetnik <[EMAIL PROTECTED]> wrote:
> Simon Davies
> wrote:
> > I use:
> >
> > select rowid, A, B, C
> > from t
> > where A||B||C in
> > ( select A||B||C
> > from t
> > group by A, B, C
> > having count(*)>1
> > );
>
> Wouldn't that mistakenly consider a record ('xy', 'z',
Simon Davies
wrote:
I use:
select rowid, A, B, C
from t
where A||B||C in
( select A||B||C
from t
group by A, B, C
having count(*)>1
);
Wouldn't that mistakenly consider a record ('xy', 'z', 'w') to be
duplicate of ('x', 'yz', 'w') ?
Igor Tandetnik
Hi All,
I'm new in your mailing list.
I need to use sqlite and not sqlite3 because of php still support only the
first version.
I read that sqlite3 support table renaming with common sql syntax
alter table table1 rename to table2
but, although it works fine on sqlite3, it doesn't work on sqlite
On 05/11/2007, A.J.Millan <[EMAIL PROTECTED]> wrote:
> I All:
>
> Suppose a table:
>
> CREATE TABLE 'myTable' (
> A INTEGER NOT NULL,
> B INTEGER NOT NULL,
> C INTEGER);
>
> Do is there some query to return if there are some duplicate files and/or
> who are they?
>
> Consider duplicate file if
Per your wiki link:
Q) How can the strict affinity mode be used which is claimed to exist on
http://www.sqlite.org/datatype3.html A) This has not been implemented as of
version 3.3.13.
Jarl Friis <[EMAIL PROTECTED]> wrote: "Trevor Talbot" writes:
> On 11/4/07, Ken wrote:
>
> He's
A.J.Millan <[EMAIL PROTECTED]> wrote:
The proposed solution seem list all rows in the table. Perhaps miss
some
thing in between myTable t1 and myTable t2?
Right. Add another condition:
and t1.rowid != t2.rowid
Igor Tandetnik
Igor:
The proposed solution seem list all rows in the table. Perhaps miss some
thing in between myTable t1 and myTable t2?
Gerry:
Yours solution does not list any at all. It is likely that there are not
duplicated entrys (at least must not happen that.).
Thanks for yours input.
Igor Tandetnik wrote:
A.J.Millan <[EMAIL PROTECTED]> wrote:
Suppose a table:
CREATE TABLE 'myTable' (
A INTEGER NOT NULL,
B INTEGER NOT NULL,
C INTEGER);
Do is there some query to return if there are some duplicate files
and/or who are they?
Consider duplicate file if there are two or more
After further research, I realize that suggestion 2 below is not
necessary.
I had not realized that SQLite core supports default value declarations
in call
to sqlite3_declare_vtab(). So by defining any default values when
defining
virtual table columns, one knows in xUpdate callback for INSERT
A.J.Millan <[EMAIL PROTECTED]> wrote:
Suppose a table:
CREATE TABLE 'myTable' (
A INTEGER NOT NULL,
B INTEGER NOT NULL,
C INTEGER);
Do is there some query to return if there are some duplicate files
and/or
who are they?
Consider duplicate file if there are two or more rows with the same
I All:
Suppose a table:
CREATE TABLE 'myTable' (
A INTEGER NOT NULL,
B INTEGER NOT NULL,
C INTEGER);
Do is there some query to return if there are some duplicate files and/or
who are they?
Consider duplicate file if there are two or more rows with the same values.
I.E:
two or more with
"Trevor Talbot" <[EMAIL PROTECTED]> writes:
> On 11/4/07, Ken <[EMAIL PROTECTED]> wrote:
>
> He's referring to section 6 of http://www.sqlite.org/datatype3.html
> which says otherwise.
Yes, section 6: mentioning "strict affinity" mode and "no affinity"
mode. Unfortunately there was no tag, so I
22 matches
Mail list logo