Skip to content

Ошибка в psql `F64(1.0) cannot be represented as a value of type Int8` при SELECT

repro:

$ psql postgres://admin:qazWSX123@192.168.101.166:5002?sslmode=disable
psql (16.3, сервер 15.0)
Введите "help", чтобы получить справку.

admin=> create table clients (id integer not null, name string not null, primary key (id));
create table courses (id integer not null, name string, date string, primary key (id));
create table registration (id integer not null, client_id integer, course_id integer, primary key (id));
CREATE TABLE
CREATE TABLE
CREATE TABLE

admin=> insert into clients values (1, 'Woody');
insert into clients values (2, 'Buzz');
insert into clients values (3, 'Bo');
INSERT 0 1
INSERT 0 1
INSERT 0 1

admin=> select * from clients;
ERROR:  feature is not supported: F64(1.0) cannot be represented as a value of type Int8
admin=> 

Воспроизводится в версиях picodata:

  • 24.6.1-0-ge1d07a14
  • 24.7.0-40-geb4d9e1c
  • 24.7.0-85-gac21074d

более ранние не тестировал

Также пробовал psql версий:

  • 15.9
  • 16.3
To upload designs, you'll need to enable LFS and have an admin enable hashed storage. More information