Skip to content

bug: insert different values, but result set is the same #1369

@davidshiz

Description

@davidshiz

Have you read the Contributing Guidelines on issues?

Please confirm if bug report does NOT exists already ?

  • I confirm there is no existing issue for this

Describe the problem

mysql> CREATE TABLE t1 (   id bigint(20) NOT NULL,   PRIMARY KEY (id) );
Query OK, 0 rows affected (0.01 sec)

mysql> INSERT INTO t1 VALUES(1234),(97716021308405775),(97716021308405770),(97716021308405780);
Query OK, 4 rows affected (0.00 sec)
Records: 4  Duplicates: 0  Warnings: 0

mysql> select * from t1;
+-------------------+
| id                |
+-------------------+
|              1234 |
| 97716021308405776 |
| 97716021308405776 |
| 97716021308405776 |
+-------------------+
4 rows in set (0.00 sec)

Expected behavior

mysql> select * from t1;
+-------------------+
| id                |
+-------------------+
|              1234 |
| 97716021308405770 |
| 97716021308405775 |
| 97716021308405780 |
+-------------------+
4 rows in set (0.00 sec)

How To Reproduce

CREATE TABLE t1 (   id bigint(20) NOT NULL,   PRIMARY KEY (id) );
INSERT INTO t1 VALUES(1234),(97716021308405775),(97716021308405770),(97716021308405780);

Environment

root@ub01:/stonedb57/install/bin# ./mysqld --version
./mysqld  Ver 5.7.36-StoneDB-v1.0.2 for Linux on x86_64 (build-)
build information as follow:
        Repository address: https://github.com/stoneatom/stonedb.git:stonedb-5.7-dev
        Branch name: stonedb-5.7-dev
        Last commit ID: d66a3ca70
        Last commit time: Date:   Wed Mar 8 10:28:54 2023 +0800
        Build time: Date: Wed Mar  8 11:35:35 CST 2023

Are you interested in submitting a PR to solve the problem?

  • Yes, I will!

Metadata

Metadata

Assignees

Labels

A-bugSomething isn't working

Type

No type

Projects

Status

Done

Relationships

None yet

Development

No branches or pull requests

Issue actions