shangyanwen

bug: select * from t1,(...) and select * from (...),t1，The test results are inconsistent

1

### Describe the problem ``` create table t1 (a int not null auto_increment primary key)engine=stonedb; insert into t1 values (); insert into t1 values (); insert into t1 values ();...

### Describe the problem ``` CREATE TABLE t1 (sku int PRIMARY KEY, pr int)engine=stonedb; CREATE TABLE t2 (sku int PRIMARY KEY, sppr int, name varchar(255))engine=stonedb; INSERT INTO t1 VALUES (10,...

### Describe the problem ``` CREATE TABLE `abcÿdef` (i int)engine=tianmu; INSERT INTO `abcÿdef` VALUES (1); INSERT INTO abcÿdef VALUES (2); SELECT * FROM `abcÿdef`; SELECT * FROM abcÿdef; ##The error...

bug: SELECT * FROM t1 WHERE (a=a AND a=a) OR b > 2;No data can be queried

2

### Describe the problem ``` CREATE TABLE t1 (a INT NOT NULL, b INT)engine=stonedb; INSERT INTO t1 VALUES (1, 1); SELECT * FROM t1 WHERE (a=a AND a=a) OR b...

bug: Table not created, prompt Table 't2' already exists

6

### Describe the problem ``` 1、create database syw_mtr; 2、use syw_mtr; 3、CREATE TABLE t1 (f1 VARCHAR(255) CHARACTER SET utf8)engine=stonedb; 4、CREATE TABLE t2 AS SELECT LEFT(f1,171) AS f2 FROM t1 UNION SELECT...

bug: The result that is null is not queried

2

### Describe the problem ``` CREATE TABLE `A` ( `pk` int(11) NOT NULL AUTO_INCREMENT, `date_key` date NOT NULL, `date_nokey` date NOT NULL, `datetime_key` datetime NOT NULL, `int_nokey` int(11) NOT NULL,...

### Describe the problem ``` CREATE TABLE t1 ( ID_with_null int NULL, ID_better int NOT NULL, INDEX idx1 (ID_with_null), INDEX idx2 (ID_better) )engine=stonedb; INSERT INTO t2 VALUES (1,1), (2,1), (null,3),...

website(stonedb): StoneDB open source community plus search capabilities.

1

**Is your feature request related to a problem? Please describe.** ``` The Stonedb open source site has no search, and finding articles is a hassle ``` **Describe the solution you'd...

bug: LEFT JOIN...ON....，The query result data is incomplete

2

### Describe the problem ``` CREATE TABLE t1 (name varchar(255))engine=stonedb; CREATE TABLE t2 (name varchar(255), n int, KEY (name(3)))engine=stonedb; INSERT INTO t1 VALUES ('ccc'), ('bb'), ('cc '), ('aa '), ('aa');...

### Describe the problem ``` create table t1(f1 int, f2 date)engine=stonedb; insert into t1 values(1,'2005-01-01'),(2,'2005-09-01'),(3,'2005-09-30'),(4,'2005-10-01'),(5,'2005-12-30'); select * from t1 where f2 select * from t1 where f2