shangyanwen

### Describe the problem ``` create table t1 (a integer, b integer, index(a), index(b))engine=stonedb; create table t2 (c integer, d integer, index(c), index(d))engine=stonedb; insert into t1 values (1,2), (2,2), (3,2),...

### Describe the problem ``` create table t3(s varchar(10) not null primary key)engine=stonedb; insert into t3 values ('one '), ('two\t'); select * from t3 where s = 'one'; (note:No result...

**Describe the problem** CVE-2016-3477: Vulnerability in the MySQL Server Component in MySQL Database Server **Expected behavior** 1、Install MySQL revision as required by security patch update from April 2016/2018/2020 or later...

question: create table t4 select * from t3; It is not supported at present, when can it be supported

1

## General Question #Describe the problem ``` 1、create table t3(a int,b char(20))engine=stonedb; 2、insert into t3(b) values("hello"),("my"),("world"); 3、create table t4 select * from t3; ERROR 6 (HY000): The query includes syntax...

bug: incorrect result set.Check that ON DUPLICATE KEY UPDATE，A query result error occurs

2

### Describe the problem ``` CREATE TABLE t1(a1 INTEGER PRIMARY KEY, b1 INTEGER)engine=tianmu; CREATE TABLE t2(a2 INTEGER PRIMARY KEY, b2 INTEGER)engine=tianmu; CREATE VIEW v AS SELECT * FROM t1 JOIN...

bug: insert ... select distinct,The correct test result was not detected

1

### Describe the problem ``` create table t1 (email varchar(50))engine=tianmu; insert into t1 values ('[email protected]'),('[email protected]'),('[email protected]'),('[email protected]'),('[email protected]'); create table t2(id int not null auto_increment primary key, t2 varchar(50), unique(t2))engine=tianmu; insert into t2...

bug: create table `#mysql50#q.q` ，The table is not found after being created successfully

1

### Describe the problem ``` mysql> create database `b`; mysql> use `b`; mysql> create table `#mysql50#q.q` (f1 int primary key) engine=tianmu; Query OK, 0 rows affected (0.01 sec) mysql> show...

### Describe the problem ``` 1、Mysql InnoDB is the main, StonedB is the slave node 2、Use the INSERT of the sysbench script to insert 10 tables with 80,000 rows each...

feature: incorrect result set.INSERT INTO t1 (a) VALUES(x'FFA5A4ABACA9');The query result is empty

9

### Describe the problem ``` CREATE TABLE t1 ( id INT AUTO_INCREMENT PRIMARY KEY, a VARCHAR(100) CHARACTER SET ARMSCII8 )engine=tianmu; INSERT INTO t1 (a) VALUES(x'616263AC646566'); INSERT INTO t1 (a) VALUES(x'FFA5A4ABACA9');...

bug: incorrect result set.DATE_ADD( '1992-01-01',INTERVAL '1 1:1:1' DAY_SECOND)，The tianmu query result is empty

2

### Describe the problem ```sql USE test; CREATE TABLE `lineitem_i342` ( `l_orderkey` int(11) NOT NULL, `l_partkey` int(11) NOT NULL, `l_suppkey` int(11) NOT NULL, `l_linenumber` int(11) NOT NULL, `l_quantity` decimal(15,2) NOT...