haitaoguan
haitaoguan
### Describe the problem mysql> show create table t_user_innodb\G *************************** 1. row *************************** Table: t_user_innodb Create Table: CREATE TABLE `t_user_innodb` ( `id` int(11) NOT NULL AUTO_INCREMENT, `first_name` varchar(10) NOT NULL,...
mysql> show engines; +--------------------+---------+----------------------------------------------------------------+--------------+------+------------+ | Engine | Support | Comment | Transactions | XA | Savepoints | +--------------------+---------+----------------------------------------------------------------+--------------+------+------------+ | CSV | YES | CSV storage engine | NO | NO...
### Describe the problem When you use a function on a field, performance is affected.The trace.log displays the message "Unoptimized expression near 'substr'". ``` ###Abnormal mysql> select sum(se) from jrk_all_bak...
### Describe the problem If the parameter tianmu_ini_allowmysqlquerypath equal to 1,executing the following SQL causes the instance to crash. SELECT FIND_TOP_USID(C.USID) AS SUSID, C2.CORPNAME AS SCORPNAME, C2.BNAME, C.USID, C.CORPNAME, C.IBUSINESSID,...
### Have you read the Contributing Guidelines on issues? - [X] I have read the [Contributing Guidelines on issues](https://github.com/stoneatom/stonedb/blob/stonedb-5.7-dev/CONTRIBUTING.md). ### Please confirm if bug report does NOT exists already ?...
### Have you read the Contributing Guidelines on issues? - [X] I have read the [Contributing Guidelines on issues](https://github.com/stoneatom/stonedb/blob/stonedb-5.7-dev/CONTRIBUTING.md). ### Please confirm if bug report does NOT exists already ?...
```sql ###sql_text select a.* FROM c_acct a LEFT JOIN (SELECT b.account_id, b.fiscal_date, b.balance FROM (SELECT account_id, max(fiscal_date) fiscal_date FROM c_day WHERE deleted_flag = '0' GROUP BY account_id) a JOIN c_day...
### Have you read the Contributing Guidelines on issues? - [X] I have read the [Contributing Guidelines on issues](https://github.com/stoneatom/stonedb/blob/stonedb-5.7-dev/CONTRIBUTING.md). ### Please confirm if bug report does NOT exists already ?...
### Have you read the Contributing Guidelines on issues? - [X] I have read the [Contributing Guidelines on issues](https://github.com/stoneatom/stonedb/blob/stonedb-5.7-dev/CONTRIBUTING.md). ### Please confirm if bug report does NOT exists already ?...
### Have you read the Contributing Guidelines on issues? - [X] I have read the [Contributing Guidelines on issues](https://github.com/stoneatom/stonedb/blob/stonedb-5.7-dev/CONTRIBUTING.md). ### Please confirm if bug report does NOT exists already ?...