At 0:29 +0000 3/4/03, Tim Bunce wrote:
>The docs for the MYSQL_FIELD structure here
> http://www.mysql.com/doc/en/C_API_datatypes.html
>say:
>
> char * name
> The name of the field, as a null-terminated string.
> char * table
> The name of the table containing this field, if it isn't a
> calculated field. For calculated fields, the table value is an
> empty string.
>
>But it seems that the name element contains table.field for statements
>like:
>
> SELECT table.field FROM table
>
>This is inconsistent with all other databases I've worked with.
>
>Notably it creates an ambiguity because it's not possible to tell
>if the '.' in the name field is an indentifier-separator dot, or
>a dot embedded in a field name:
>
> SELECT field AS `foo.bar` FROM table
>
>There is separate table element in the MYSQL_FIELD structure so
>including the table name in the field name is redundant.
>
>Comments?
I don't think that this has ever been true before, and if the
name field now contains the table name, I'd argue that it's
a bug that has been introduced that should be fixed.
>
>Tim.
>
>---------------------------------------------------------------------
>Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
>To request this thread, e-mail internals-thread7279@stripped
>To unsubscribe, e-mail <internals-unsubscribe@stripped>
