Re: twice the same column name

7 views
Skip to first unread message

Luuk

unread,
Mar 17, 2020, 1:36:01 PM3/17/20
to
On 17-3-2020 18:21, Stefan Ram wrote:
> Sorry, can't find a better newsgroup!
>
> Does ISO SQL forbid Views with the same column name
> twice anywhere? As in
>
> CREATE VIEW V AS SELECT C,C FROM T;
>
> . If so, where does ISQ SQL forbid this? TIA!
>
> (MySQL does clearly forbid this.)
>
>

https://bugs.mysql.com/bug.php?id=15443
Bug description: Views: can't create view, error 'Duplicate column'
Bug Status: Not a bug



--
Luuk

Tony Mountifield

unread,
Mar 17, 2020, 2:31:50 PM3/17/20
to
In article <name-2020...@ram.dialup.fu-berlin.de>,
Stefan Ram <r...@zedat.fu-berlin.de> wrote:
> Sorry, can't find a better newsgroup!
>
> Does ISO SQL forbid Views with the same column name
> twice anywhere? As in
>
> CREATE VIEW V AS SELECT C,C FROM T;
>
> . If so, where does ISQ SQL forbid this? TIA!
>
> (MySQL does clearly forbid this.)

I certainly doesn't make sense: would V.C refer to the first or the second instance?

You could do:

CREATE VIEW V AS SELECT C, C AS C2 FROM T;

And then access V.C and V.C2.

I suppose the question is: why to you need to do this?

Cheers
Tony
--
Tony Mountifield
Work: to...@softins.co.uk - http://www.softins.co.uk
Play: to...@mountifield.org - http://tony.mountifield.org

J.O. Aho

unread,
Mar 18, 2020, 2:52:11 AM3/18/20
to
On 17/03/2020 19.54, Stefan Ram wrote:
> to...@mountifield.org (Tony Mountifield) writes:
>> I suppose the question is: why to you need to do this?
>
> Thanks for answering, but I don't need to /do/ anything.
> I'd just like to /know/ the answers to my two questions.
> Why? For teaching purposes. (But knowing why I need the
> answers will not help answering the questions I'm afraid.)

I would guess it may be mentioned in an ANSI documentation, maybe in one
of those linked on this page:
https://www.ansi.org/news_publications/news_story?menuid=7&articleid=753a952d-1244-415b-bb92-0010750bb8cd

Just have your creditcard ready, as they seems to want 200+ USD for one
document.

--

//Aho

DFS

unread,
Sep 8, 2021, 4:44:57 PMSep 8
to
If you're a member. $250 if not.

I just chatted with someone at ansi.org and said your pdf prices were
too high and she said 'sorry you feel that way' and then asked 'Is there
anything else we may assist you with today?'.

You can complain at e...@ansi.org. I just did.







John Levine

unread,
Sep 8, 2021, 5:01:58 PMSep 8
to
According to DFS <nos...@dfs.com>:
>> I would guess it may be mentioned in an ANSI documentation, maybe in one
>> of those linked on this page:
>> https://www.ansi.org/news_publications/news_story?menuid=7&articleid=753a952d-1244-415b-bb92-0010750bb8cd
>>
>> Just have your creditcard ready, as they seems to want 200+ USD for one
>> document.
>
>If you're a member. $250 if not.
>
>I just chatted with someone at ansi.org and said your pdf prices were
>too high and she said 'sorry you feel that way' and then asked 'Is there
>anything else we may assist you with today?'.
>
>You can complain at e...@ansi.org. I just did.

ANSI funds itself by selling copies of standards so I wouldn't waste my time.

--
Regards,
John Levine, jo...@taugh.com, Primary Perpetrator of "The Internet for Dummies",
Please consider the environment before reading this e-mail. https://jl.ly

DFS

unread,
Sep 9, 2021, 10:36:47 AMSep 9
to
On 9/8/2021 5:01 PM, John Levine wrote:
> According to DFS <nos...@dfs.com>:
>>> I would guess it may be mentioned in an ANSI documentation, maybe in one
>>> of those linked on this page:
>>> https://www.ansi.org/news_publications/news_story?menuid=7&articleid=753a952d-1244-415b-bb92-0010750bb8cd
>>>
>>> Just have your creditcard ready, as they seems to want 200+ USD for one
>>> document.
>>
>> If you're a member. $250 if not.
>>
>> I just chatted with someone at ansi.org and said your pdf prices were
>> too high and she said 'sorry you feel that way' and then asked 'Is there
>> anything else we may assist you with today?'.
>>
>> You can complain at e...@ansi.org. I just did.
>
> ANSI funds itself by selling copies of standards so I wouldn't waste my time.


What does ANSI.org do to justify such exorbitant prices? Nothing as far
as I can tell.

Most if not all the standards writers are employed in occupations where
they develop the expertise to write the standards. So they're already paid.

The 14-part SQL document would cost a non-member ~$3500. It's ridiculous.


John Levine

unread,
Sep 9, 2021, 9:12:48 PMSep 9
to
According to DFS <nos...@dfs.com>:
>> ANSI funds itself by selling copies of standards so I wouldn't waste my time.
>
>What does ANSI.org do to justify such exorbitant prices? Nothing as far
>as I can tell.
>
>Most if not all the standards writers are employed in occupations where
>they develop the expertise to write the standards. So they're already paid.

There is a lot of clerical and editorial work involved. BTDT.

The IETF gives away its standards for free, but only because the Internet
Society makes enough from .ORG to give it a $6 million/year subsidy.
Reply all
Reply to author
Forward
0 new messages