[Bug]: Can't create table with a bool column #1530
Description
Is there an existing issue for the same bug?
- I have checked the existing issues.
Version or Commit ID
v0.2.1
Other environment information
No response
Actual behavior and How to reproduce it
import infinity
from infinity.common import ConflictType, LOCAL_HOST
try:
# Open a local directory to store the data
infinity_instance = infinity.connect("/var/infinity")
# connect to server with 127.0.0.1
# infinity_instance = infinity.connect(infinity.common.LOCAL_HOST)
# 'default_db' is the default database
db_instance = infinity_instance.get_database("default_db")
# Drop my_table if it already exists
db_instance.drop_table("primitive_table", infinity.common.ConflictType.Ignore)
# Create a table with four primitive columns:
table_instance = db_instance.create_table("primitive_table", {
"c1": {"type": "int8", "default": 0},
"c2": {"type": "int16", "default": 0},
"c3": {"type": "int", "default": 0},
"c4": {"type": "int32", "default": 0}, # Same as int
"c5": {"type": "integer", "default": 0}, # Same as int
"c6": {"type": "int64", "default": 0},
"c7": {"type": "varchar"},
"c8": {"type": "float", "default": 1.0},
"c9": {"type": "float32", "default": 1.0}, # Same as float
"c10": {"type": "double", "default": 1.0},
"c11": {"type": "float64", "default": 1.0}, # Same as double
"c12": {"type": "bool", "default": False},
})
table_instance.insert({"c1": 1, "c7": "Tom"})
infinity_instance.disconnect()
except Exception as e:
print(str(e))
Expected behavior
No response
Additional information
Got: (<ErrorCode.NOT_SUPPORTED: 3032>, 'Attempt to cast from BigInt to Boolean@src/function/cast/integer_cast.cppm:79')