Skip to content

Empty result with max unsigned int value #1531

Closed
@shiyuhang0

Description

@shiyuhang0

Issue description

Empty result.

Example code

  1. Insert into mysql
CREATE DATABASE test;

CREATE TABLE test.t(
    t_int_unsigned       INT UNSIGNED
);

insert into test.t values (4294967295);

Query with go-sql-driver master. Here we use commit 0004702

	db, err := sql.Open("mysql", "root@tcp(127.0.0.1:3306)/test")
	if err != nil {
		println(err)
		return
	}
	defer db.Close()

	rows, err := db.Query("select * from test.t")
	if err != nil {
		println(err)
		return
	}
	if !rows.Next() {
		println("no rows")
		return
	}
	var v int64
	err = rows.Scan(&v)
	if err != nil {
		println(err)
	}
	println(v)

This code output no rows

Configuration

Driver version (or git SHA): 0004702

Go version: run go version in your console

Server version: E.g. MySQL 5.6, MariaDB 10.0.20

Server OS: E.g. Debian 8.1 (Jessie), Windows 10

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions