Bug: When querying the tinyint(1) type field in mysql, the query result returns a bool value, but the actual data type is a numeric type.

[happyJonychen]

Chat2DB Version

1.0.7

Describe the bug

Problem Description

ddl of table

CREATE TABLE `test` (
  `id` int(11) NOT NULL,
  `test` tinyint(1) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4

data in table

Check for phrases

select * from test

Chat2DB results of the

Solution suggestions

method one

In mysql, by default, the display length of the tinyint type is 1 (signed), which defaults to representing a Boolean value. You can link out the splicing parameters in mysql.

tinyInt1isBit=false

method two

Use the get method according to the field data type. Not all use rs.getObject. For example, for tinyint type, use rs.getInt to get the normal value. The corresponding code position:

Chat2DB/chat2db-server/chat2db-spi/src/main/java/ai/chat2db/spi/jdbc/DefaultValueHandler.java

Line 20 in feaf137

Object obj = rs.getObject(index);