Re: [sqlite] Possible bug in System.Data.Sqlite.Core (ADO.Net)

' Subject: Re: [sqlite] Possible bug in System.Data.Sqlite.Core (ADO.Net) Zachary Yates wrote: > > create view ProgrammingMapView as > select > p.Id ProductId > , pt.Id ProtocolId > , m.Id Mid > from Mid m > join MidProduct mprod on (mp

Re: [sqlite] Possible bug in System.Data.Sqlite.Core (ADO.Net)

Zachary Yates wrote: > > create view ProgrammingMapView as > select > p.Id ProductId > , pt.Id ProtocolId > , m.Id Mid > from Mid m > join MidProduct mprod on (mprod.RegisteredMid = m.Id) > join Product p on (p.Id = mprod.ProductId) >

Re: [sqlite] Possible bug in System.Data.Sqlite.Core (ADO.Net)

[mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Joe Mistachkin Sent: Thursday, August 28, 2014 10:07 AM To: 'General Discussion of SQLite Database' Subject: Re: [sqlite] Possible bug in System.Data.Sqlite.Core (ADO.Net) Clemens Ladisch wrote: > > Your query did not involve the query fla

Re: [sqlite] Possible bug in System.Data.Sqlite.Core (ADO.Net)

Clemens Ladisch wrote: > > Your query did not involve the query flattener. Try this: > I used the query as originally reported. However, as others have stated, without AS clauses, the column names are not well-defined. In this case, the IDataRecord.GetName method of the SQLiteDataReader class

Re: [sqlite] Possible bug in System.Data.Sqlite.Core (ADO.Net)

Joe Mistachkin wrote: > I'm unable to replicate this issue Your query did not involve the query flattener. Try this: select "t".x from (select x from (select 1 x)) t; Regards, Clemens ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] Possible bug in System.Data.Sqlite.Core (ADO.Net)

Zachary Yates wrote: > > There's a lot more detail to this question posted at: > http://stackoverflow.com/questions/25534898/trouble-with-sqlexpressiont-join -and-column-names > I'm unable to replicate this issue using System.Data.SQLite. Here is what I've tried so far: set db [sql open

Re: [sqlite] Possible bug in System.Data.Sqlite.Core (ADO.Net)

Simon Slavin wrote: > you're free to consider this a peculiarity of the ADO driver. It's a peculiarity of SQLite itself (introduced in 5526e0aa3c). > It might be easily fixable. But it's not a bug. The comment "Dequote column names generated by the query flattener" shows that combined

Re: [sqlite] Possible bug in System.Data.Sqlite.Core (ADO.Net)

> Yes, you're free to consider this a peculiarity of the ADO driver. It might be easily fixable. But it's not a bug. I respectfully disagree with that. GetName() is supposed to return a _Column_ Name, not a _Table_ Name. Even more, it is supposed to return a Value to identify a Column, so

Re: [sqlite] Possible bug in System.Data.Sqlite.Core (ADO.Net)

On 28 Aug 2014, at 12:47am, Zachary Yates wrote: > That's not actually the issue. When I run the query using the SQLite console > or via another driver, (for example using 0xDBE + Xerial), the column names > are returned exactly as they are specified in the query. >

Re: [sqlite] Possible bug in System.Data.Sqlite.Core (ADO.Net)

] Possible bug in System.Data.Sqlite.Core (ADO.Net) On 27 Aug 2014, at 8:30pm, Zachary Yates <zachary.ya...@orolia.com> wrote: > When I use SQLiteCommand.ExecuteReader(), the IDataReader.GetName(i) method > returns only the table name, in my case "Country". Y

Re: [sqlite] Possible bug in System.Data.Sqlite.Core (ADO.Net)

On 27 Aug 2014, at 8:30pm, Zachary Yates wrote: > When I use SQLiteCommand.ExecuteReader(), the IDataReader.GetName(i) method > returns only the table name, in my case "Country". You do not provide your own names for the columns returned. Therefore SQLite is free

[sqlite] Possible bug in System.Data.Sqlite.Core (ADO.Net)

Hello, >From what I can tell, this is the place to ask about a bug in the ADO.Net >driver for SQLite. If it's not, my apologies. I've run into an issue while using System.Data.Sqlite.Core v 1.0.93.0 to execute select queries like the following: SELECT "Country"."Id", "Country"."Code",