You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
mysql> show create table aa;
+-------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Table | Create Table |
+-------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| AA | CREATE TABLE `AA` (
`col_decimal_not_null` decimal(10,0) NOT NULL,
`pk` int(11) NOT NULL AUTO_INCREMENT,
`col_varchar_10` varchar(10) DEFAULT NULL,
`col_datetime` datetime DEFAULT NULL,
`col_decimal` decimal(10,0) DEFAULT NULL,
`col_varchar_10_not_null` varchar(10) NOT NULL,
`col_datetime_not_null` datetime NOT NULL,
`col_int` int(11) DEFAULT NULL,
`col_int_not_null` int(11) NOT NULL,
PRIMARY KEY (`pk`) /*T![clustered_index] CLUSTERED */
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin AUTO_INCREMENT=2000001 |
+-------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
mysql> SELECT SUM( OUTR . col2 ) AS X FROM (SELECT INNR . `pk` + 1 as col1, INNR . `col_datetime` as col2 FROM AA AS INNR) AS OUTR2 INNER JOIN (SELECT INNR . `col_int` + 1 as col1, INNR . `col_varchar_10` as col2 FROM AA AS INNR) AS OUTR ON OUTR2.col1 = OUTR.col1 GROUP
BY OUTR . col2, OUTR2 . col1;
ERROR 1105 (HY000): DB::Exception: Illegal type String of argument for aggregate function sum
Seems the last sql will hangs forever unless I kill the tidb connection in another tidb session.
The text was updated successfully, but these errors were encountered:
Seems the last sql will hangs forever unless I kill the tidb connection in another tidb session.
The text was updated successfully, but these errors were encountered: