MySQL Forums
Forum List  »  InnoDB

Advanced Search
New Topic

Re: Subquery in SELECT statement returns wrong(?) data type
Posted by: Rick James
Date: September 20, 2014 11:24PM

There are a number of anomalies.

In older versions, BIT was equated to TINYINT (perhaps UNSIGNED).

In expressions, SUM(), etc, all sizes of integers become BIGINT; FLOAT becomes DOUBLE.

GROUP_CONCAT, IF, etc, sometimes yield BINARY.

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
Subquery in SELECT statement returns wrong(?) data type
2401
Roman Ovseitsev
September 19, 2014 11:57PM
Re: Subquery in SELECT statement returns wrong(?) data type
873
Rick James
September 20, 2014 11:24PM


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.