strongduanmu commented on issue #26028:
URL:
https://github.com/apache/shardingsphere/issues/26028#issuecomment-1574700244
Test result:
```
mysql> SELECT * FROM (SELECT id, user_id, order_id, (SELECT password FROM
t_user LIMIT 1) FROM t_encrypt) temp;
+----+---------+----------------------------------+---------------------------------------+
| id | user_id | order_id | (SELECT password FROM
t_user LIMIT 1) |
+----+---------+----------------------------------+---------------------------------------+
| 1 | 123 | 289dff07669d7a23de0ef88d2f7129e7 | sdasdas
|
| 2 | 222 | 310dcbbf4cce62f762a2aaa148d556bd | sdasdas
|
+----+---------+----------------------------------+---------------------------------------+
2 rows in set (1 min 42.43 sec)
mysql> SELECT * FROM (SELECT id, user_id, order_id, (SELECT password FROM
t_user LIMIT 1) password FROM t_encrypt) temp;
+----+---------+----------------------------------+----------+
| id | user_id | order_id | password |
+----+---------+----------------------------------+----------+
| 1 | 123 | 289dff07669d7a23de0ef88d2f7129e7 | sdasdas |
| 2 | 222 | 310dcbbf4cce62f762a2aaa148d556bd | sdasdas |
+----+---------+----------------------------------+----------+
2 rows in set (5.28 sec)
```
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
