am 04.04.2005 02:14:25 von Gokhan Demir

Content-Type: text/plain;
Content-Transfer-Encoding: 7bit

I am trying to force some resultset metadata for nullable columns in a
unioned select statement. What I try to do is cast the null to an
appropriate datatype (DATE in my example). (I think) The selects run ok
without the union or union all statements. However, this is better to be
confirmed officially by MySQL.

select convert(null,DATE) as dt

union all

select convert("2005-01-01 12:12:12", DATE) as dt;


select {fn convert(null,DATE)} as dt

union all

select {fn convert("2005-01-01 12:12:12", DATE)} as dt;

will cause the server crash.

Version 4.1.10a, Linux x86, originally distributed binaries.

[root@miranda ~]# uname -a

Linux miranda.lan 2.6.10-1.741_FC3 #1 Thu Jan 13 16:38:22 EST 2005 i686 i686
i386 GNU/Linux


Gokhan Demir


Re: union

am 04.04.2005 04:02:51 von miguel solorzano

At 21:14 3/4/2005, Gokhan Demir wrote:
Dear Mr Demir,

Thank you for to report for us this bug, however it is already reported in=
Bug Report Database as:


and according its status this issue was already fixed in our BK
source, so the fix will be present in the next release.


Miguel Angel Sol=F3rzano
S=E3o Paulo - Brazil

MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe: http://lists.mysql.com/bugs?unsub=3Dgcdmb-bugs@m.gmane.org