From Newsgroup: comp.databases.mysql

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.)


--- Synchronet 3.21d-Linux NewsLink 1.2

From Newsgroup: comp.databases.mysql

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
--- Synchronet 3.21d-Linux NewsLink 1.2

From Newsgroup: comp.databases.mysql

In article <name-20200317175735@ram.dialup.fu-berlin.de>,
Stefan Ram <ram@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: tony@softins.co.uk - http://www.softins.co.uk
Play: tony@mountifield.org - http://tony.mountifield.org
--- Synchronet 3.21d-Linux NewsLink 1.2

From Newsgroup: comp.databases.mysql

tony@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.)


--- Synchronet 3.21d-Linux NewsLink 1.2

From Newsgroup: comp.databases.mysql

On 17/03/2020 19.54, Stefan Ram wrote:

tony@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
--- Synchronet 3.21d-Linux NewsLink 1.2

From Newsgroup: comp.databases.mysql

On 3/18/2020 2:52 AM, J.O. Aho wrote:

On 17/03/2020 19.54, Stefan Ram wrote:

tony@mountifield.org (Tony Mountifield) writes:

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

-a-a Thanks for answering, but I don't need to /do/ anything.
-a-a I'd just like to /know/ the answers to my two questions.
-a-a Why? For teaching purposes. (But knowing why I need the
-a-a 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.

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 ess@ansi.org. I just did.







--- Synchronet 3.21d-Linux NewsLink 1.2

From Newsgroup: comp.databases.mysql

According to DFS <nospam@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 ess@ansi.org. I just did.

ANSI funds itself by selling copies of standards so I wouldn't waste my time. --
Regards,
John Levine, johnl@taugh.com, Primary Perpetrator of "The Internet for Dummies",
Please consider the environment before reading this e-mail. https://jl.ly
--- Synchronet 3.21d-Linux NewsLink 1.2

From Newsgroup: comp.databases.mysql

On 9/8/2021 5:01 PM, John Levine wrote:

According to DFS <nospam@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 ess@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.


--- Synchronet 3.21d-Linux NewsLink 1.2

From Newsgroup: comp.databases.mysql

According to DFS <nospam@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.
--
Regards,
John Levine, johnl@taugh.com, Primary Perpetrator of "The Internet for Dummies",
Please consider the environment before reading this e-mail. https://jl.ly
--- Synchronet 3.21d-Linux NewsLink 1.2