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 -type SQLite {Data Source=:memory:;}]
sql execute $db {
CREATE TABLE Country(
Id,
Code,
Title,
ShortTitle,
ModifiedOn,
ModifiedBy
);
CREATE TABLE Mid(
Id,
CountryCode
);
CREATE TABLE ProgrammingMapView(
Mid,
ProductId
);
INSERT INTO Country (
Id, Code, Title, ShortTitle, ModifiedOn, ModifiedBy)
VALUES (
1, 'US', 'United States of America', 'United States',
'2014-01-01', 'Joe'
);
INSERT INTO ProgrammingMapView (Mid, ProductId) VALUES (1, 87);
INSERT INTO Mid (Id, CountryCode) VALUES (1, 'US');
SELECT "Country"."Id", "Country"."Code", "Country"."Title",
"Country"."ShortTitle", "Country"."ModifiedOn",
"Country"."ModifiedBy"
FROM "Country"
INNER JOIN "ProgrammingMapView"
ON ("Mid"."Id" = "ProgrammingMapView"."Mid")
INNER JOIN "Mid"
ON ("Country"."Code" = "Mid"."CountryCode")
WHERE ("ProgrammingMapView"."ProductId" = 87)
ORDER BY "Country"."Title" ASC;
}
parray rows
The above uses the EagleShell from the Externals directory in the
source tree. Here, the final line of output from the above script
is:
rows(names) = Id Code Title ShortTitle ModifiedOn ModifiedBy
Underneath, this ends up using the exact same IDataRecord.GetName
method.
Do you have any further information on this issue that might be
useful?
--
Joe Mistachkin
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
