Re: "WITH ROLLUP" and "NOT NULL" columns
Anthony Willard wrote:
> If the column Field2 is not defined as "NOT NULL", I don't get any records with the value of "Total"
> in Field2, but do get a null value. If the column is defined as "NULL", it works fine.
You are right. This is in contradiction to the quote from the Reference Manual I gave in my previous message.
See also
http://bugs.mysql.com/bug.php?id=7894
--
felix
Please use
BBCode to format your messages in this forum.
Subject
Views
Written By
Posted
4748
November 15, 2005 12:00PM
2897
November 15, 2005 12:31PM
1935
November 17, 2005 05:41PM
Re: "WITH ROLLUP" and "NOT NULL" columns
1915
November 18, 2005 01:55AM
1866
November 18, 2005 09:07AM
1867
June 19, 2006 07:19PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.