ambiguous column name 'id'

[alensiljak]

Hi! Thanks a lot for this fantastic library. The most of my time on converting a rather simple project was spent on trying out, hitting walls, and rewriting the DAL code.
Hopefully, the remaining issues can be clarified or polished relatively painlessly.

I have an inner join on a select statement involving two tables, both of which have the id field (obviously). When the query is executed, the error message in the title is thrown.

In all the code examples I see that only the column names are listed, without the table name. Is there a way to require the columns to be output as "table_name.id" instead of just "id"?

I'm using rusqlite as the underlying provider.

Cheers

[alensiljak]

Actually, using double quotes won't work as that returns the quoted string as the column value.

[ikrivosheev]

@alensiljak hey! Can you show your code?)

[alensiljak]

Hi! Sure, this is the place where I was generating the Select statement using the query builder. Below is the workaround SQL with manual modification.

[Sytten]

Do this

fn get_security_columns() -> Vec<(SecurityIden, SecurityIden)> {
    vec![
        (SecurityIden::Table, SecurityIden::Id),
        ...
    ]
}

[alensiljak]

Fantastic! Please ignore my previous (deleted) comments. I'm too tired and had it written differently. Porting this project has been too much fun and I've had very little sleep in the past days. :D

That works! Fantastic tip. Worth having a prominent place in the docs for the Joins.

[billy1624]

Thanks! @Sytten

[alensiljak]

A working solution