Some small but usefull changes implemented, as per user request:
get latest version here : http://www.singular.gr/sqlite/
Mike Cariotoglou
Disclaimer Notice: This communication may be confidential. If you are not an
intended recipient please note that any form of distribution, copying or use of
Just an idea :
Parameters bound via sql_bind... *should* have affinity, since they are
manifestly typed.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Quoting from the documentation on Type Affinity:
"
SQLite may attempt to convert values between the numeric storage classes
(INTEGER and REAL) and TEXT before performing a comparison. Whether or
not any conversions are attempted before the comparison takes place
depends on the nominal affinity
ite Database
> Subject: Re: [sqlite] Bug when uUsing Parameters with views
>
> 2009/12/15 Cariotoglou Mike <m...@singular.gr>:
> > I checked in the bug database, and this does not seem to have been
> > reported, and IMHO it is definitely a bug.
> > workarounds e
IST.artistid
> group by artistname having count(ITEM_ARTIST.artistid) =
> @desireditemcount
>
> Regards
> Tim Romano
>
> Cariotoglou Mike wrote:
> > I thought of that, and the answer is NO.
> > actually, since my post, I did a little investigation :
> > it
h a subselect?
Does this work for you?
select * from (
select t1.*,
(select count(*) from song_artist t2 where t1.artist_id=t2.artist_id) as CNT
from artists
) where CNT=:PARAM
-- Darren Duncan
Cariotoglou Mike wrote:
> I don't know if this has come up before, is so please point me t
I don't know if this has come up before, is so please point me to the
right direction :)
I believe that using parameterized queries with views does not work
as expected.
consider this (more or less self-explanatory) schema:
create table artists(artist_id)
create table songs(song_id)
create
just to throw in my two bits:
I have done a lot of work with trees in SQL, and IMHO, the best method BY FAR
is the one described in the link below (mysql article), mainly due to its
capability to handle siblings and descendants.
for example, the self-join, parent_node method described elsewhere
Cariotoglou Mike wrote:
> Has anybody had experience using Borland's free compiler (bcc32) to
> build the sqlite dll ?
We use bcc32 to create an .obj which is linked into our Delphi
application. No issues here and we've been using it for three years on
a project deployed to several h
Has anybody had experience using Borland's free compiler (bcc32) to
build the sqlite dll ?
I gave it a try, and was surprised to see that I got a file that is 100k
smaller than the usual MS visual studio dll I build.
I assume this is due to a different size of the run-time library, so
what I am
Discussion of SQLite Database
Subject: [sqlite] Sqlite3Explorer Sqlite Report Designer
Dear Cariotoglou Mike,
Are you in vaccation? I am attaching the previous emails that I have send.
If you are trying or planning to work on the same please inform, so that I
can hope that some thing is going
h a simple report deisgner and
viewer. Also my company is not willing to puchase any product for just
reporting, since our programs are supplied freely along with some of our
products. So an extra cost is not feasible.
A SIMPLE DISIGNER/VIEWER FOR WINDOWS USERS
- Original Message -----
From: &q
I am the author of sqlite3Explorer. Sorry I did not answer you previous
post, reason is I did not motice it... :(
I don't think what you want is feasible. the reason is this: the Dll
expects a "dataset" which sqlite3Explorer builds internally, and the
report engine takes it from there (Design,
well, since you asked, BNF is indeed more difficult to read, BUT it is
machine-readable, which means validation tools and parsers can be built.
so, if you did have the BNF grammar *available* (as opposed to part of
the web documentation), I personally would be happier.
Hi all, and DRH :
I am the author of sqlite3Explorer, a windows Gui management tool. One
of the users of this program has contacted me wrt to supporting
encrypted databases. in the past, Sqlite3Explorer has supported
encrypted databases (version 2 of sqlite), even though I do not own a
copy of
well, first of all you must have a typo, since the sql you show will
return 14170, not 0.69 or anything like it.
however, one thing springs out:
Total * 100 + 100 is wrong IMHO, unless you are looking for CEILING
functionallity.
"round" would need : total * 100 +50 (which rounds to nearest
ersion, but still no drag n drop support
> for opening database files :( ....
>
> Regards,
> Miha
>
> "Cariotoglou Mike" <[EMAIL PROTECTED]> wrote on 29.11.2007 9:09:59:
> >New version with a lot of enhancements to the user interface, also
> >update
New version with a lot of enhancements to the user interface, also
updated to be compatible with
the latest sqlite dll.
information, change list and download here :
http://www.singular.gr/sqlite
(New features are described in the link near the top).
Documentation, such as it is, is out of
DRH : do you mind if I usurp the favicon.ico from the sqlite site, to
use in my application ?
thanks, mike
-
To unsubscribe, send email to [EMAIL PROTECTED]
/26/2007 1:56 AM
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] sqlite3Explorer
Joe Wilson wrote:
> --- Cariotoglou Mike <[EMAIL PROTECTED]> wrote:
>
>> I wish I could "make it for Unix", but it uses a lot of windows-specific
>> things, plus it is don
no, a mistake. the address IS :
mikecar at singular dot gr (mike will also work)
thanks for pointing out the header problem. I was hoping the mailing list was
"hiding" this info, obviously not
An unencrypted address was plainly visible in the message headers
("From" and "X-Return-Path").
ooops mail obfuscation was wrong! it is actually :
mike atsign singular dot gr (I used ampersand in the original post which was
wrong. well, english is not my native lang...)
-
To unsubscribe, send email to [EMAIL
you can't ?! I overdid it, then :)
I wish I could "make it for Unix", but it uses a lot of windows-specific
things, plus it is done in Delphi, and since
Kylix is practically dead, wlll...
From: Joe Wilson [mailto:[EMAIL PROTECTED]
Sent: Sat 11/24/2007 7:00
Hi. I am the author of the Sqlite3Explorer GUI front end. I have been inactive
on this tool for some time now,
frankly because I initially created it to cover my own needs, and I havent had
any new needs lately :)
In any case, since I see that people still use it, and some even like it, I am
I am having problems building 3.4.2 from the amalgamated source,using
Microsoft Visual Studio 2005
(this is the first time I am trying to use
the amalgamated source). I get the following errors:
Error 1 error C2133: 'sqlite3UpperToLower' : unknown size
Error 37 error C2133:
> > Seems that there is a problem on unique key fields when null
> > values are allowed
> >
> > CREATE TABLE z (
> > id VARCHAR(32) NOT NULL,
> > f1 VARCHAR(32) NOT NULL,
> > f2 VARCHAR(20),
> > PRIMARY KEY (id)
> > );
> > CREATE UNIQUE INDEX z_I1 ON z (f1, f2)
> >
> > insert into z values
suppose you have a text file that contains :
Myname,yourname hisname
Myname,yourname hisname
Myname,yourname hisname
Myname,yourname hisname
Myname,yourname hisname
Myname,yourname hisname
Myname,yourname hisname
notice that this is an irregular format, because the first column
delimiter
Robert, I re-verified using your option set, and I still get the same problem.
there is clearly something wrong here,
and it is not easy to track down. I wonder if you could help me with this.
Shall we take this off-line, so that we dont clutter the list, and report back
when done ? I would
>
> Thoughts? Would making recursive triggers an error rather
> than just silently ignoring them break anybody's code?
even if it does, it should. otherwise, people may assume that the
functionality exists,and rely on it.
> I'm also looking at making DELETE triggers recursive. I can
> do
I am not sure how this would work. in order for a trigger to "See"
another database, somebody (obviously not the trigger) must ATTACH the
database first. is there an automatic ATTACH capability that I am not
aware of ? if not, specifying triggers than span databases is looking
for trouble IMHO. as
all you need is an OLEDB or ODBC wrapper for sqlite, and there are some around,
check the wiki.
once you install one, your sqlite is accesible from ADO, just like any other
database (almost)
From: John Latimer [mailto:[EMAIL PROTECTED]
Sent: Mon 30-Jan-06 12:06
one idea. run an EXPLAIN fist, and then analyze the query plan. it will
tell you if there are more than one tables,
and maybe you can get info about aggregate functions and such. of
course, there is a cost to this...
> -Original Message-
> From: Will Leshner [mailto:[EMAIL PROTECTED]
>
I see again that you all miss the point. I DO know how to handle floating
point. My point is :
a. a lot of people will make the error indicated. I am sure that they are poor
programmers. I am also sure (judging from some of the questions posted in this
list), that there is a lot of them...
as you may remember, some time ago I raised an issue with floating point
accuracy, and how this may affect sqlite.
I now have a concrete example, which actually happened in an
installation, and helps to demonstrate the severity of the issue:
try this code:
create table test(f double);
insert
sqlite3Explorer does that
From: John Stanton [mailto:[EMAIL PROTECTED]
Sent: Wed 07-Dec-05 8:00 AM
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] how can I import CSV file into SQLite quickly
Someone somwhere must have a simple Perl script which does what
Hi all. I would like to propose an enchancement in sqlite. I am not sure
whether the issue
has come up before, if it has, and has been shot down, pls let me know.
The concept of in-memory database would be greatly enhanced if there was a
mechanism to
serialize the internal cache to/from a
> Sent: Thursday, November 03, 2005 7:53 PM
> To: sqlite-users@sqlite.org
> Subject: RE: [sqlite] Request for comment: Proposed SQLite API changes
>
>
> Cariotoglou Mike said:
>
> > a crappy .H file. these people (c programmers) live in wasteland, I
> > rea
since you work in D7, as I do, you already have namespaces (in the form
of units), so this was never an issue, even if you wanted to have two
versions of the same code built-in. as to why, well, consider a database
managent tool that has to open both 2.x and 3.x databases, and the only
tool to
ok, the sqlite_Schema thing can (and has) been wrapped. however, the
error code issue is there, I believe that we have agreed in the past
that it was bad design, but it could not be changed because of
compatibility issues. I,for one, am willing to comb my code and re-code
for this, so yes, please
FYI, I tried the same script on windows xp2 sqlite 3.2.7, and it worked
fine also
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, November 01, 2005 7:13 PM
> To: sqlite-users@sqlite.org
> Subject: Re: [sqlite] Page size problem
>
> "Anton
as a matter of fact, I have also noticed that using the vaccum command
from the command-line interface does bring this error up sometimes.
however, since I use the graphical UI most of the time (being its
author:) I don't use the command line interface that much.
I suspect it has nothing to do
>
> Interesting tool. Are sources available for porting to other
> OSes? I would like to try on FC4.
> --
> G. Roderick Singleton <[EMAIL PROTECTED]> PATH tech
>
unfortunately not, as it uses a lot of commercial components. plus, it
is Delphi :)
s@sqlite.org
> Subject: Re: [sqlite] ANN: Sqlite3Explorer version 2.0 released
>
> Cariotoglou Mike wrote:
>
> >this is a major release, with a lot of changes. please see
> the readme
> >at www.singular.gr/sqlite.
> >Pls read the whole page carefully, as support
this is a major release, with a lot of changes. please see the readme at
www.singular.gr/sqlite.
Pls read the whole page carefully, as support for datatypes is now a lot
more powerful, but slightly different than
the previous versions.
Report users : you will need to download an extra dll, it is
hi. I am the author of this program. I have not seen what you mentioned, but in
any case, I am about to release a
new major release 2.0 in a few days, which has been tested with 3.2.7 and does
not seem to have any problems.
From: Huanghongdong [mailto:[EMAIL
ng point fields, and
> a feature request
>
> On 9/20/05, Cariotoglou Mike <[EMAIL PROTECTED]> wrote:
> >
> > There is an issue with floating point fields, which exists in every
> > database I have dealt with, and of course exists in sqlite as well,
> > all versions.
>
sqlite] Problem with floating point fields, and
> a feature request
>
> On 9/20/05, Cariotoglou Mike <[EMAIL PROTECTED]> wrote:
> >
> > There is an issue with floating point fields, which exists in every
> > database I have dealt with, and of course exists in sqlite as wel
collating sequences do not apply to floating point comparisons, do they
?
> -Original Message-
> From: Dan Kennedy [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, September 20, 2005 5:12 PM
> To: sqlite-users@sqlite.org
> Subject: Re: [sqlite] Problem with floating point fields, and
> a
There is an issue with floating point fields, which exists in every
database I have dealt with, and of course exists in sqlite as well, all
versions.
Essentially, the issue is this:
"When are two floating point values considered equal ?"
Why is this an issue ?
Floating point values are some
> > Mike,
> >
> > 3.2.6 compiles fine in Visual Studio 7 (.NET 2003). I can
> give it a
> > go in my copy of Visual Studio 6 if you like...
> >
> > Steve
> >
> > -Original Message-
> > From: Cariotoglou Mike [mailto:[EMAIL PROTECTED]
&
You are correct. I just run a test on 3.2.6 release, and it does handle
joins incorrectly. I cant get the files from cvs, so I am not sure
whether the fix also
Handles the reverse situation:
Select *
>From T1 left join t2 on (t1.ref=t2.id) and (t2.kind=1)
Ie if there is a join term that
it is definitely possible.
how have you defined the data type in the CREATE statement ?
how did the data was inserted in the table initially ?
have you enabled the "use datatypes" option ?
dump the contents of the table with the "datatypes" disabled, so you see
raw data. are they really
I tried to compile 3.2.6 locally, using visual c 6, as I do with all
sqlite releases. this version introduces a couple of changes that do not
compile:
os_win.c(482) : error C2065: 'INVALID_SET_FILE_POINTER' : undeclared
identifier
vdbeapi.c(237) : error C2520: conversion from unsigned __int64 to
when a sqlite3_Step call fails, say on a unique key violation of an
INSERT statement,
the returned error code is SQLITE_ERROR, which is documented.
calling sqlite3_errcode at this point, however, also gives the same
error, which is not.
the correct error, which is SQLITE_CONSTRAINT, is only
There is one other thing, though. Allthough the sql standard is
(insert your favorite 4-letter word), and although I personally hate
nulls, I try to write applications where the sql is as portable as it
can be. So, in the name of portability, you should follow the sql
standard.
Minor fix to work around a bug in pragma empty_result_callbacks, which
makes Explorer incompatible with the ANALYZE command
> -Original Message-
> From: Miha Vrhovnik [mailto:[EMAIL PROTECTED]
> Sent: Monday, September 05, 2005 7:14 PM
> To: sqlite-users@sqlite.org
> Subject: RE: [sqlite] bug in sqlite 3.2.5 compilation and ANALYZE
>
> "Cariotoglou Mike" <[EMAIL PROTECTED]> je o
I hope that this restriction is not enforced on windows, ever! I have an
application that will be completely broken by this:
it is an application server, that serves multiple clients, pools db
connections, and hands them out on demand, protecting the pool with a number of
mechanisms that have
y unlikely that all ANALYZE executions fail.
>
> --Ned.
> http://nedbatchelder.com
>
> -Original Message-
> From: Cariotoglou Mike [mailto:[EMAIL PROTECTED]
> Sent: Monday, 05 September, 2005 5:46 AM
> To: sqlite-users@sqlite.org
> Subject: [sqlite] bug in sqlite
I tried the ANALYZE statement with sqlite 3.2.5 in dll form, (both the
pre-compiled version downloaded from the site, AND a local compilation).
in both
cases, the statement fails with an ACCESS VIOLATION. however, the same
statement, when run from the pre-compiled sqlite3.exe, works.
further,
good to know...
> -Original Message-
> From: Dennis Jenkins [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, July 27, 2005 4:26 PM
> To: sqlite-users@sqlite.org
> Subject: Re: [sqlite] ANN: sqlite3Explorer V 1.7
>
> Dennis Jenkins wrote:
>
> > Cariotogl
*. new feature : support for encrypted databases (WITH the licenced
version of sqlite)
http://www.singular.gr/sqlite/
which gives me the opportunity to repear my oft-ignored reply :)
what you say is true, provided the OS is geared towards multiple
processes. which is not true for windows, but is true for *ix, as400 and
other environments. if you need, say, a server that handles 500
sessions, and attempt to do
which version of the dll are you using ? do you have REFERENCES
declarations ? can you send me a sample of the data ?
> -Original Message-
> From: Hugh Gibson [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, June 22, 2005 4:22 PM
> To: sqlite-users@sqlite.org
> Subject: Re: [sqlite] ANN:
Could you please let me know what the problem was ? I am the author of
sqlite3Explorer, and perhaps I could fix it.
> -Original Message-
> From: Downey, Shawn [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, May 17, 2005 11:45 PM
> To: sqlite-users@sqlite.org
> Subject: RE: [sqlite]
new version 1.4, adds support for date formats, when storing dates as
text.
to support the format -MM-DD HH:MM:SS, all you need to do is change
the date separator to "-",
and change the time format (remove the .zzz)
do NOT change the separator used in the actual date format, the "/" you
see
Will fix and let you know
> -Original Message-
> From: Brad Schick [mailto:[EMAIL PROTECTED]
> Sent: Saturday, April 30, 2005 9:31 PM
> To: sqlite-users@sqlite.org
> Subject: [sqlite] SqliteExplorer and ISO8601 dates
>
> Is it possible to get SqliteExplorer to parse textual dates in
Imho, naming scheme should be like this:
1. column names as returned from sqlite3_column_name should always be a
single word,
NOT qualified by origin.
So, all below should return "field1" as column name.
If there is a column alias in the select, the *alias* should be returned
as the single word.
Just a thought. If transactions speed up the access, try this:
Begin exclusive
Select
Select ...
Select ...
Commit
Ie use a transaction around READS.
This may acquire the lock once, and give you the same performance as
inserts.
> -Original Message-
> From: William Hachfeld
Adds a simple report generator.
It is a limitation of sqliteExplorer.
> -Original Message-
> From: jack wu [mailto:[EMAIL PROTECTED]
> Sent: Thursday, April 07, 2005 7:05 PM
> To: sqlite-users@sqlite.org
> Subject: [sqlite] what is the difference between TEXT and
> BLOB data type?
>
>
> other than encoded and not
o ;-). I have
> just made a
> > database application with these that runs on both Linux and Windows
> > using SQLite3.
> >
> > Leif
> >
> >
> > Cariotoglou Mike wrote:
> >
> > >[EMAIL PROTECTED] it seems the new controls I us
I found the offending call and removed it. it was *not* in the
devExpress code, but the visual query builder code. as a result, table
captions are no longer "nice"... pls download again.
> -Original Message-
> From: Serge Liber [mailto:[EMAIL PROTECTED]
> Sent: Monday, April 04, 2005
[EMAIL PROTECTED] it seems the new controls I used require this function, which
only
exists in win2k+. sorry for this, I think I will rebuild *without* the
devexpress controls, for more genral purpose use..
> -Original Message-
> From: Serge Liber [mailto:[EMAIL PROTECTED]
> Sent:
y chance for a Linux version ? Or a web version ?
>
>Greetings,
>
> Leif
>
>
> Cariotoglou Mike wrote:
>
> >New version is out. Since the problem with size limits was
> not lifted
> >from contrib, I created a home site for the program. You
New version is out. Since the problem with size limits was not lifted
from contrib, I created a home site for the program. You will now be
able to get latest version from
http://www.singular.gr/sqlite
Latest is 1.1 , 24/3/2005 (ignore the typo in the date)
Regards,mike
This may be an issue with the odbc driver. In the meanwhile, you could
try importing with the gui tool, sqlite3explorer
(www.sqlite.org/contrib). Afaik, it should import access ok.
> -Original Message-
> From: RAY BORROR [mailto:[EMAIL PROTECTED]
> Sent: Monday, March 28, 2005 9:54 AM
>
If you are working with delphi, I could have a solution for you.
> -Original Message-
> From: Jay [mailto:[EMAIL PROTECTED]
> Sent: Saturday, March 26, 2005 3:41 AM
> To: sqlite-users@sqlite.org; Win a 2
> Subject: Re: [sqlite] RegEx w/ sqlite, yet?
>
>
> > Hello sqlite-users,
> >
>
it is already UPX'ed AND zipped. still...
From: Eugene Wee [mailto:[EMAIL PROTECTED]
Sent: Fri 3/25/2005 6:24 AM
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] Contrib uploads
Hi,
have you considered using UPX to reduce the executable filesize?
Pragma table_info(tablename). For God's name, do read the documentation,
somebody spent good time to write it!
> -Original Message-
> From: Gerry Snyder [mailto:[EMAIL PROTECTED]
> Sent: Friday, March 25, 2005 1:19 AM
> To: sqlite-users@sqlite.org
> Subject: Re: [sqlite] getting table
sqlite] Contrib uploads
>
> On Thu, 2005-03-24 at 11:24 +0200, Cariotoglou Mike wrote:
> > I tried to upload a new version of sqlite3Explorer, and I
> got back the
> > error:
> > "Too much POST data".
>
> How big of an upload are we talking about?
> --
> D. Richard Hipp <[EMAIL PROTECTED]>
>
>
>
as a suggestion to the list, this issue should be answered only by those
that disagree, else we will get 2k messages saying why not..
>From a quick look at sqlite analyzer, I would say the following :
1. it is not free
2. it has better looks than sqlite3Explorer
3. it cannot update tables using an editable grid approach
4. it does not have a visual query builder
5. I am not sure it has ADO import/export capabilities
The only way is to query one of the exported functions (sqlite3_version
or something like this). I agree, however, that it would be nice to have
a
version resource in the DLL. Also, If somebody would take the trouble to
do it, I would very much appreciate it if a proper MsVC project file ,
with
Sure, an API for returning result set info would be fine, and more convenient
than these pragmas, which for one thing are stateful, and thus hell for wrapper
writers, which need to assume that only the *wrapper* may set these pragmas.
Also, in order to avoid API explosion, I feel that a single
I have opened a ticket (#1147) for the full_column_names issue, which is back
in 3.1.3. pls check it out.
also, I noticed the following :
when selecting from a view, and duplicate column names exist, there is an
attempt to de-dupe them, by adding a sequence number, like this:
ID ID:1 ID:2
The fact is, the pragmas regarding column names now seem completely
broken, as they do absolutely nothing. Was this by design, or a new bug
?
-Original Message-
From: D. Richard Hipp [mailto:[EMAIL PROTECTED]
Sent: Sunday, February 27, 2005 1:08 AM
To: sqlite-users@sqlite.org
Subject:
> At 11:20 AM -0700 2/18/05, Robert Simpson wrote:
> >PRAGMA real_column_names=0|1
YES, PLEASE. I also need this, as I am writing an OLEDB provider
I agree. I have done similar work for GIS data. Unless you absolutely
need access to inidvidual x,y data at the *sql* level, it is much better
to use memory storage for these. And, if you plan to do operations like
point-in-polygon, which I am sure you will, you need access to all the
points at
It has been my experience that, when two processes have the same db
open, and one of them does a VACUUM, and the other tries to update,
The database gets corrupted. Not easy to simulate, but has happened at
least twice, in fact it has been the only way I managed to corrupt a
database.
Comments,
out of curiocity, can you give a try to my delphi wrappers?
http://www.sqlite.org/contrib
(not Tdataset replacement, though, but they should be quite fast for this
reason. also try the "serverCursor" setting, which allows you to step thorugh
the result set one at a time, meaning there is no
Sqlite parser DOES parse foreign key constraints. Try this:
create table t1(
id integer,
id1 integer,
id2 integer,
id3 integer,
foreign key (id1,id2) references anotherTable(id,id1),
foreign key (id3) references somethingElse(id)
);
pragma foreign_key_list(t1);
However, this does not mean that
Indeed. Searching the source, this has never been implemented.
>
> Hrm. In that case, perhaps I should say "The documentation
> is broken":
>
> [ http://www.sqlite.org/lang.html#createtable ]
>
> The DEFAULT constraint specifies a default value to use when
> doing an INSERT. The
No, your USER locale must be in hebrew. Is it ? What os are you using ?
Would you mind mailing me the mdb file ?
Also, if you put UTF in the db, sqliteexploirer may gag. But do try it.
> -Original Message-
> From: Ofer Chesler [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, January 18, 2005
Hi. I am the author of this program. I regret to say that this version is
NOT unicode-enabled, so, handling non-ascii data is a bit tricky, but
possible.
1. Since any string read from the MDB (be it ansii or unicode) will be
converted to ANSI (which means 8-bit characters), you can only handle
This bug is a beauty: text column comparison in joins may follow NUMERIC
rules, even if
the column(s) have text affinity!
consider this case. Tables A,B are a typical one-to-many relation, where B
has N records
for each A, and one field (key) relates them.
CREATE TABLE a(
key VARCHAR(2),
I can verify this :
Select "columnName" from someTable gives columns with quoted names !
("ColumnName") instead of ColumnName
This *feels* like a bug
> -Original Message-
> From: red forks [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, December 22, 2004 6:07 AM
> To: [EMAIL PROTECTED]
> -Original Message-
> From: D. Richard Hipp [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, November 02, 2004 4:49 PM
> To: [EMAIL PROTECTED]
> Subject: Re: [sqlite] Join function in select statement
>
>
> CARIOTOGLOU MIKE wrote:
> > Why not provide some extra
mailto:[EMAIL PROTECTED]
> Sent: Tuesday, November 02, 2004 3:44 PM
> To: [EMAIL PROTECTED]
> Subject: Re: [sqlite] Join function in select statement
>
>
> CARIOTOGLOU MIKE wrote:
> > write a user-defined function in your hosting code. the
> only problem is,
I have uploaded the new version of sqlite3Explorer, which fixes a bug with
the schema treeview.
1 - 100 of 111 matches
Mail list logo
