dolt icon indicating copy to clipboard operation
dolt copied to clipboard

Log warnings on ambiguous name qualification and resolution

Open fulghum opened this issue 2 years ago • 1 comments

In certain cases, MySQL allows ambiguity in referenced names and will register a warning for the query instead of throwing an error. GMS should follow this same behavior for consistency.

An example from MySQL's SELECT Reference Documentation:

If the HAVING clause refers to a column that is ambiguous, a warning occurs. In the following statement, col2 is ambiguous because it is used as both an alias and a column name: SELECT COUNT(col1) AS col2 FROM t GROUP BY col2 HAVING col2 = 2;

fulghum avatar Sep 26 '22 20:09 fulghum

As of 1.35.9 we've fixed the ambiguity but do not log the warning here.

max-hoffman avatar Apr 15 '24 23:04 max-hoffman