public void SameColumnName()
{
using (var conn = OpenConnection())
{
conn.ExecuteNonQuery("CREATE TEMP TABLE data1 (foo INTEGER); CREATE TEMP TABLE data2 (foo INTEGER)");
using (var cmd = new NpgsqlCommand("SELECT data1.foo,data2.foo FROM data1,data2", conn))
using (var reader = cmd.ExecuteReader(CommandBehavior.SchemaOnly | CommandBehavior.KeyInfo))
{
var columns = reader.GetColumnSchema();
Assert.That(columns[0].ColumnName, Is.EqualTo("foo"));
Assert.That(columns[0].BaseTableName, Is.EqualTo("data1"));
Assert.That(columns[1].ColumnName, Is.EqualTo("foo"));
Assert.That(columns[1].BaseTableName, Is.EqualTo("data2"));
}
}
}