Re: [sqlite] Bug in sqlite3.exe?

2013-09-24 Thread Keith Medcalf
SQLite Database > Subject: Re: [sqlite] Bug in sqlite3.exe? > > On Tue, Sep 24, 2013 at 12:35 PM, Staffan Tylen > <staffan.ty...@gmail.com>wrote: > > > SQLite version 3.7.16.2 2013-04-12 11:52:43 > > Enter ".help" for instructions > > Enter S

Re: [sqlite] Bug in sqlite3.exe?

2013-09-24 Thread Igor Tandetnik
On 9/24/2013 12:49 PM, John Drescher wrote: On Tue, Sep 24, 2013 at 12:35 PM, Staffan Tylen wrote: SQLite version 3.7.16.2 2013-04-12 11:52:43 Enter ".help" for instructions Enter SQL statements terminated with a ";" sqlite> .tables CityCountry

Re: [sqlite] Bug in sqlite3.exe?

2013-09-24 Thread Staffan Tylen
Many who solved this, thank you all. Staffan On Tue, Sep 24, 2013 at 7:11 PM, Yuriy Kaminskiy wrote: > Staffan Tylen wrote: > > On Tue, Sep 24, 2013 at 6:50 PM, Simon Slavin > wrote: > > > >> On 24 Sep 2013, at 5:35pm, Staffan Tylen

Re: [sqlite] Bug in sqlite3.exe?

2013-09-24 Thread Yuriy Kaminskiy
Staffan Tylen wrote: > On Tue, Sep 24, 2013 at 6:50 PM, Simon Slavin wrote: > >> On 24 Sep 2013, at 5:35pm, Staffan Tylen wrote: >> >>> sqlite> .tables >>> CityCountry Languages >>> Country Country

Re: [sqlite] Bug in sqlite3.exe?

2013-09-24 Thread Dan Kennedy
On 09/24/2013 11:53 PM, Staffan Tylen wrote: Well, it's not my database I'm looking at. What puzzles me is that Country Languages works but Country Official Languages doesn't, so could there be a parsing problem? It's because the AS keyword is optional. These two are equivalent: SELECT

Re: [sqlite] Bug in sqlite3.exe?

2013-09-24 Thread John Drescher
On Tue, Sep 24, 2013 at 12:53 PM, Staffan Tylen wrote: > Well, it's not my database I'm looking at. What puzzles me is that Country > Languages works but Country Official Languages doesn't, so could there be a > parsing problem? > > I think I see what is happening.. when

Re: [sqlite] Bug in sqlite3.exe?

2013-09-24 Thread Richard Hipp
On Tue, Sep 24, 2013 at 12:35 PM, Staffan Tylen wrote: > SQLite version 3.7.16.2 2013-04-12 11:52:43 > Enter ".help" for instructions > Enter SQL statements terminated with a ";" > sqlite> .tables > CityCountry Languages > Country

Re: [sqlite] Bug in sqlite3.exe?

2013-09-24 Thread Staffan Tylen
Well, it's not my database I'm looking at. What puzzles me is that Country Languages works but Country Official Languages doesn't, so could there be a parsing problem? I agree, the names should be quoted ... On Tue, Sep 24, 2013 at 6:50 PM, Simon Slavin wrote: > > On 24

Re: [sqlite] Bug in sqlite3.exe?

2013-09-24 Thread John Drescher
On Tue, Sep 24, 2013 at 12:35 PM, Staffan Tylen wrote: > SQLite version 3.7.16.2 2013-04-12 11:52:43 > Enter ".help" for instructions > Enter SQL statements terminated with a ";" > sqlite> .tables > CityCountry Languages > Country

Re: [sqlite] Bug in sqlite3.exe?

2013-09-24 Thread Simon Slavin
On 24 Sep 2013, at 5:35pm, Staffan Tylen wrote: > sqlite> .tables > CityCountry Languages > Country Country Official Languages > Country CapitalsCountryLanguage Either don't use spaces in your token names (table

Re: [sqlite] Bug in sqlite3.exe?

2013-09-24 Thread John Drescher
On Tue, Sep 24, 2013 at 12:35 PM, Staffan Tylen wrote: > SQLite version 3.7.16.2 2013-04-12 11:52:43 > Enter ".help" for instructions > Enter SQL statements terminated with a ";" > sqlite> .tables > CityCountry Languages > Country

[sqlite] Bug in sqlite3.exe?

2013-09-24 Thread Staffan Tylen
SQLite version 3.7.16.2 2013-04-12 11:52:43 Enter ".help" for instructions Enter SQL statements terminated with a ";" sqlite> .tables CityCountry Languages Country Country Official Languages Country CapitalsCountryLanguage sqlite> select

[sqlite] Bug? Shell (sqlite3.exe) exits after ".read"-ing a file that contains two errors

2012-05-23 Thread K. Frank
Hello List! I see unexpected behavior using sqlite3's .read command. The basic problem is illustrated by the following test file: C:\>type test2.sql -- two errors, sqlite3 exits select count(*) from no_table_a; select count(*) from no_table_b; C:\> Here's the result of running