将sql转换为h2数据库的sql

Question

如何利用h2数据库将sql转换成受话人？

alter table examination_order_details
    add column is_duplicated boolean default false;

alter table medical_certificate
    add column is_reissued boolean default false;

alter table medical_certificate
    add column correction boolean default false;


alter table medical_certificate
    add column harmful_factors character varying[];

alter table examination_order_details
    add column sd_position_id integer;

alter table examination_order_details_history
    add column sd_position_id integer;

alter table examination_order_details
    add constraint examination_order_details_sd_position_id_fkey
        foreign key (sd_position_id) references positions (id);

UPDATE public.examinations
    SET is_valid = false
    WHERE name_examination LIKE '%-23%'

create table dictionary_harmful_factors
(
    id                       integer primary key generated always as identity,
    name                     varchar not null,
    printable_on_certificate boolean default false
);


insert into dictionary_harmful_factors (name, printable_on_certificate)
VALUES ('praca na wysokości', true),
       ('praca w torach czynnych', true),
       ('praca przy monitorze ekranowym powyżej 4h', false),
       ('kierowanie sam. osobowym do 3,5 t', true),
       ('kierowanie sam. osobowym do 3,5 t z przewozem osób', true),
       ('akcja zima', false);

Answer 1

1. character varying[]需要替换为更符合SQL标准的character varying array (它不是完全兼容的，但H2也不需要varchar数据的长度)，需要用符合标准的integer generated always as identity primary key.

替换。