shangyanwen

bug: datetime SELECT statement did not query the test result

3

### Describe the problem ``` CREATE TABLE t1(a DATETIME NOT NULL, b VARCHAR(20) NOT NULL)engine=stonedb; INSERT INTO t1 VALUES('2001-01-01', '2001-01-01'); SELECT * FROM t1 WHERE a='2001-01-01 00:00:00' AND a=b AND...

bug: SELECT name, LENGTH(name), n FROM t2 WHERE name='cc '; The query result data is incomplete

3

### 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');...

bug: pecified key was too long; max key length is 255 bytes(innodb does not report errors)

1

### Describe the problem ``` create table t1 ( a varchar(112) charset utf8 collate utf8_bin not null, primary key (a) ) select 'test' as a ; ERROR 1071 (42000): Specified...

bug: Field "a$1、$b、c$" insert value, no query result

3

### Describe the problem ``` 1、create database mysqltest; 2、create table mysqltest.$test1 (a$1 int, $b int, c$ int)engine=stonedb; 3、insert into mysqltest.$test1 values (1,2,3); 4、select a$1, $b, c$ from mysqltest.$test1; Empty set...

bug: incorrect result set.select…data>=xx，Incorrect test results were obtained

2

### 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 >= '2005-09-31' order by f2; ##The error results are...

### Describe the problem ``` create table t1 (a char(1))engine=stonedb; create table t2 (a char(1))engine=stonedb; insert into t1 values ('a'),('b'),('c'); insert into t2 values ('b'),('c'),('d'); select a from t1 natural...

### Describe the problem ``` SET @@SQL_MODE='NO_BACKSLASH_ESCAPES'; SHOW LOCAL VARIABLES LIKE 'SQL_MODE'; CREATE TABLE BUG_12595(a varchar(100))engine=stonedb; INSERT INTO BUG_12595 VALUES ('hakan%'), ('hakank'), ("ha%an"); SELECT * FROM BUG_12595 WHERE a LIKE...

### Describe the problem ``` SET @OLD_SQL_MODE12595=@@SQL_MODE, @@SQL_MODE=''; SHOW LOCAL VARIABLES LIKE 'SQL_MODE'; CREATE TABLE BUG_12595(a varchar(100))engine=stonedb; INSERT INTO BUG_12595 VALUES ('hakan%'), ('hakank'), ("ha%an"); SELECT * FROM BUG_12595 WHERE a...

### Describe the problem ``` SET @OLD_SQL_MODE12595=@@SQL_MODE, @@SQL_MODE=''; SHOW LOCAL VARIABLES LIKE 'SQL_MODE'; CREATE TABLE BUG_12595(a varchar(100))engine=stonedb; INSERT INTO BUG_12595 VALUES ('hakan%'), ('hakank'), ("ha%an"); SELECT * FROM BUG_12595 WHERE a...

bug: explain select straight_join DISTINCT.......The key and rows in the test result is incorrect

1

### Describe the problem ``` CREATE TABLE t1(a int, b int, c int, KEY b(b), KEY c(c))engine=stonedb; insert into t1 values (1,0,0),(2,0,0); CREATE TABLE t2 (a int, b varchar(2), c...