ALameLlama
commented
1 year ago to replicate
CREATE TABLE example_table (
id INT NOT NULL AUTO_INCREMENT,
varchar_column VARCHAR(255),
char_column CHAR(10),
text_column TEXT,
longtext_column LONGTEXT,
int_column INT,
smallint_column SMALLINT,
bigint_column BIGINT,
float_column FLOAT,
double_column DOUBLE,
decimal_column DECIMAL(10, 2),
date_column DATE,
time_column TIME,
datetime_column DATETIME,
timestamp_column TIMESTAMP,
boolean_column BOOLEAN,
enum_column ENUM('Option1', 'Option2', 'Option3'),
set_column
SET('Value1', 'Value2', 'Value3'),
binary_column BINARY(16),
varbinary_column VARBINARY(255),
blob_column BLOB,
json_column JSON,
spatial_column GEOMETRY,
PRIMARY KEY (id)
);
INSERT INTO
example_table (
varchar_column,
char_column,
text_column,
longtext_column,
int_column,
smallint_column,
bigint_column,
float_column,
double_column,
decimal_column,
date_column,
time_column,
datetime_column,
timestamp_column,
boolean_column,
enum_column,
set_column,
binary_column,
varbinary_column,
blob_column,
json_column,
spatial_column
)
VALUES
(
'Hello',
'ABC',
'This is a text',
'This is a long text',
42,
10,
1234567890,
3.14,
123.456,
99.99,
'2023-10-26',
'13:45:00',
'2023-10-26 13:45:00',
NOW(),
TRUE,
'Option2',
'Value1,Value3',
0x01A5,
0x010203,
'This is a BLOB',
'{"key": "value"}',
POINT(1, 2)
);You can see most of them are unknown, longtext is geometry and also breaks in the normal data view and ENUM seems to be the only one that works
sonswift
huyphams
Which driver are you using and version of it (Ex: PostgreSQL 10.0): MariaDB Server 11.2
Which TablePlus build number are you using (the number on the welcome screen, Ex: build 81): Build 240
The steps to reproduce this issue: I noticed this when provisioning homestead using mariaDB and connecting to the database base, I've also recreated this spinning up a docker container.
most of the types will returned unknown but some will return other types like geometry instead of long text and erroring out