sqlgg icon indicating copy to clipboard operation
sqlgg copied to clipboard

detect ambiguous columns

Open cyberhuman opened this issue 5 years ago • 0 comments

This is accepted by sqlgg:

create table foo ( id integer primary key );
create table bar ( id integer primary key );
select * from foo join bar on foo.id = bar.id order by id;

but fails in run time (mysql) with:

ERROR 1052 (23000): Column 'id' in order clause is ambiguous

cyberhuman avatar Apr 24 '20 01:04 cyberhuman