Changeset: ac8de4f3dfb2 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/ac8de4f3dfb2
Added Files:
sql/test/BugTracker-2021/Tests/merge-table-join.Bug-7172.test
Modified Files:
sql/test/BugTracker-2021/Tests/All
Branch: Jul2021
Log Message:
Added test for bug #7172 It has already been fixed, but I leave the test here
diffs (truncated from 476 to 300 lines):
diff --git a/sql/test/BugTracker-2021/Tests/All
b/sql/test/BugTracker-2021/Tests/All
--- a/sql/test/BugTracker-2021/Tests/All
+++ b/sql/test/BugTracker-2021/Tests/All
@@ -26,3 +26,4 @@ distinct-union.Bug-7148
HAVE_LIBPY3?python-aggregates-empty.Bug-7158
remote-join-idxs.Bug-7165
shutdown-force.Bug-7167
+merge-table-join.Bug-7172
diff --git a/sql/test/BugTracker-2021/Tests/merge-table-join.Bug-7172.test
b/sql/test/BugTracker-2021/Tests/merge-table-join.Bug-7172.test
new file mode 100644
--- /dev/null
+++ b/sql/test/BugTracker-2021/Tests/merge-table-join.Bug-7172.test
@@ -0,0 +1,463 @@
+statement ok
+START TRANSACTION
+
+statement ok
+CREATE SCHEMA "dw_hospital"
+
+statement ok
+CREATE SEQUENCE "dw_hospital"."seq_36397" AS INTEGER
+
+statement ok
+CREATE SEQUENCE "dw_hospital"."seq_36422" AS INTEGER
+
+statement ok
+CREATE SEQUENCE "dw_hospital"."seq_45337" AS INTEGER
+
+statement ok
+CREATE SEQUENCE "dw_hospital"."seq_45407" AS INTEGER
+
+statement ok
+SET SCHEMA "dw_hospital"
+
+statement ok
+CREATE TABLE "dw_hospital"."bri_classi_gruppi_movimenti" (
+ "classe_movimento_id" INTEGER NOT NULL,
+ "gruppo_classe_movimento_id" INTEGER NOT NULL,
+ "last_batch_id" INTEGER NOT NULL DEFAULT '0',
+ "last_updated" TIMESTAMP NOT NULL DEFAULT
current_timestamp(),
+ CONSTRAINT "PK_bri_classi_gruppi_movimenti" PRIMARY KEY
("classe_movimento_id", "gruppo_classe_movimento_id")
+)
+
+statement ok
+CREATE TABLE "dw_hospital"."dim_classi_movimenti" (
+ "id" INTEGER NOT NULL,
+ "codice" VARCHAR(16) NOT NULL,
+ "descrizione" VARCHAR(256) NOT NULL,
+ "tipo_centro" VARCHAR(16) NOT NULL,
+ "tipo_movimentazione" VARCHAR(16) NOT NULL,
+ "tipo_caricamento" VARCHAR(16) NOT NULL,
+ "uso_ribaltamento" VARCHAR(16) NOT NULL,
+ "version" INTEGER NOT NULL,
+ "valid_from" DATE,
+ "valid_to" DATE,
+ "last_batch_id" INTEGER NOT NULL DEFAULT '0',
+ "last_updated" TIMESTAMP NOT NULL DEFAULT
current_timestamp(),
+ CONSTRAINT "PK_dim_classi_movimenti" PRIMARY KEY ("id")
+)
+
+statement ok
+CREATE TABLE "dw_hospital"."dim_periodi" (
+ "id" INTEGER NOT NULL,
+ "language_code" VARCHAR(2) NOT NULL,
+ "country_code" VARCHAR(2) NOT NULL,
+ "month_abbreviation" VARCHAR(3) NOT NULL,
+ "month_name" VARCHAR(12) NOT NULL,
+ "quarter_name" VARCHAR(8) NOT NULL,
+ "year_quarter" VARCHAR(13) NOT NULL,
+ "year_month_abbreviation" VARCHAR(8) NOT NULL,
+ "year2" VARCHAR(2) NOT NULL,
+ "year4" INTEGER NOT NULL,
+ "month_number" INTEGER NOT NULL,
+ "quarter_number" INTEGER NOT NULL,
+ "year_month_number" VARCHAR(8) NOT NULL,
+ "last_batch_id" INTEGER NOT NULL DEFAULT '0',
+ "last_updated" TIMESTAMP NOT NULL DEFAULT
current_timestamp(),
+ CONSTRAINT "PK_dim_periodi" PRIMARY KEY ("id"),
+ CONSTRAINT "IDX_dim_periodi" UNIQUE ("year4", "month_number")
+)
+
+statement ok
+create view "dw_hospital"."v_dim_classi_movimenti" as
+ select
+ "dim_classi_movimenti"."id" as "id",
+ "dim_classi_movimenti"."codice" as "codice",
+ "dim_classi_movimenti"."descrizione" as "descrizione",
+ "dim_classi_movimenti"."codice" || ' - ' ||
"dim_classi_movimenti"."descrizione" as "codice_descrizione",
+ "dim_classi_movimenti"."tipo_centro" as "tipo_centro",
+ "dim_classi_movimenti"."tipo_movimentazione" as "tipo_movimentazione",
+ "dim_classi_movimenti"."tipo_caricamento" as "tipo_caricamento",
+ "dim_classi_movimenti"."uso_ribaltamento" as "uso_ribaltamento",
+ "dim_classi_movimenti"."version" as "version",
+ "dim_classi_movimenti"."valid_from" as "valid_from",
+ "dim_classi_movimenti"."valid_to" as "valid_to",
+ "dim_classi_movimenti"."last_batch_id" as "last_batch_id",
+ "dim_classi_movimenti"."last_updated" as "last_updated"
+ from
+ "dw_hospital"."dim_classi_movimenti"
+
+
+statement ok
+CREATE TABLE "dw_hospital"."facts_costi_2017" (
+ "id" INTEGER NOT NULL DEFAULT next value for
"dw_hospital"."seq_36397",
+ "id_movimento_aggregato" INTEGER NOT NULL,
+ "periodo_id" INTEGER NOT NULL,
+ "centro_id" INTEGER NOT NULL,
+ "tipo_centro_id" INTEGER NOT NULL,
+ "area_id" INTEGER NOT NULL,
+ "fattore_id" INTEGER NOT NULL,
+ "gestione_fattore_id" INTEGER NOT NULL,
+ "tipo_fattore_id" INTEGER NOT NULL,
+ "classe_movimento_id" INTEGER NOT NULL,
+ "applicativo_id" INTEGER NOT NULL,
+ "progetto_id" INTEGER NOT NULL,
+ "valore" DECIMAL(19,4) NOT NULL,
+ "quantita" DECIMAL(19,4) NOT NULL,
+ "last_batch_id" INTEGER NOT NULL,
+ "archive" INTEGER NOT NULL,
+ "last_updated" TIMESTAMP NOT NULL DEFAULT
current_timestamp(),
+ CONSTRAINT "PK_facts_costi_2017" PRIMARY KEY ("id")
+)
+
+statement ok
+CREATE TABLE "dw_hospital"."facts_costi_2018" (
+ "id" INTEGER NOT NULL DEFAULT next value for
"dw_hospital"."seq_36422",
+ "id_movimento_aggregato" INTEGER NOT NULL,
+ "periodo_id" INTEGER NOT NULL,
+ "centro_id" INTEGER NOT NULL,
+ "tipo_centro_id" INTEGER NOT NULL,
+ "area_id" INTEGER NOT NULL,
+ "fattore_id" INTEGER NOT NULL,
+ "gestione_fattore_id" INTEGER NOT NULL,
+ "tipo_fattore_id" INTEGER NOT NULL,
+ "classe_movimento_id" INTEGER NOT NULL,
+ "applicativo_id" INTEGER NOT NULL,
+ "progetto_id" INTEGER NOT NULL,
+ "valore" DECIMAL(19,4) NOT NULL,
+ "quantita" DECIMAL(19,4) NOT NULL,
+ "last_batch_id" INTEGER NOT NULL,
+ "archive" INTEGER NOT NULL,
+ "last_updated" TIMESTAMP NOT NULL DEFAULT
current_timestamp(),
+ CONSTRAINT "PK_facts_costi_2018" PRIMARY KEY ("id")
+)
+
+statement ok
+CREATE TABLE "dw_hospital"."facts_costi_2019" (
+ "id" INTEGER NOT NULL DEFAULT next value for
"dw_hospital"."seq_45407",
+ "id_movimento_aggregato" INTEGER NOT NULL,
+ "periodo_id" INTEGER NOT NULL,
+ "centro_id" INTEGER NOT NULL,
+ "tipo_centro_id" INTEGER NOT NULL,
+ "area_id" INTEGER NOT NULL,
+ "fattore_id" INTEGER NOT NULL,
+ "gestione_fattore_id" INTEGER NOT NULL,
+ "tipo_fattore_id" INTEGER NOT NULL,
+ "classe_movimento_id" INTEGER NOT NULL,
+ "applicativo_id" INTEGER NOT NULL,
+ "progetto_id" INTEGER NOT NULL,
+ "valore" DECIMAL(19,4) NOT NULL,
+ "quantita" DECIMAL(19,4) NOT NULL,
+ "last_batch_id" INTEGER NOT NULL,
+ "archive" INTEGER NOT NULL,
+ "last_updated" TIMESTAMP NOT NULL DEFAULT
current_timestamp(),
+ CONSTRAINT "PK_facts_costi_2019" PRIMARY KEY ("id")
+)
+
+statement ok
+CREATE MERGE TABLE "dw_hospital"."facts_costi" (
+ "id" INTEGER NOT NULL DEFAULT next value for
"dw_hospital"."seq_45337",
+ "id_movimento_aggregato" INTEGER NOT NULL,
+ "periodo_id" INTEGER NOT NULL,
+ "centro_id" INTEGER NOT NULL,
+ "tipo_centro_id" INTEGER NOT NULL,
+ "area_id" INTEGER NOT NULL,
+ "fattore_id" INTEGER NOT NULL,
+ "gestione_fattore_id" INTEGER NOT NULL,
+ "tipo_fattore_id" INTEGER NOT NULL,
+ "classe_movimento_id" INTEGER NOT NULL,
+ "applicativo_id" INTEGER NOT NULL,
+ "progetto_id" INTEGER NOT NULL,
+ "valore" DECIMAL(19,4) NOT NULL,
+ "quantita" DECIMAL(19,4) NOT NULL,
+ "last_batch_id" INTEGER NOT NULL,
+ "archive" INTEGER NOT NULL,
+ "last_updated" TIMESTAMP NOT NULL DEFAULT
current_timestamp(),
+ CONSTRAINT "PK_facts_costi" PRIMARY KEY ("id")
+)
+
+statement ok
+ALTER TABLE "dw_hospital"."facts_costi" ADD TABLE
"dw_hospital"."facts_costi_2017"
+
+statement ok
+ALTER TABLE "dw_hospital"."facts_costi" ADD TABLE
"dw_hospital"."facts_costi_2018"
+
+statement ok
+ALTER TABLE "dw_hospital"."facts_costi" ADD TABLE
"dw_hospital"."facts_costi_2019"
+
+statement ok
+SET SCHEMA "sys"
+
+statement ok rowcount 1
+INSERT INTO "dw_hospital"."bri_classi_gruppi_movimenti"
(classe_movimento_id,gruppo_classe_movimento_id,last_batch_id,last_updated)
VALUES (1,7,3829,'2019-07-18 16:05:31.0')
+
+statement ok rowcount 1
+INSERT INTO "dw_hospital"."bri_classi_gruppi_movimenti"
(classe_movimento_id,gruppo_classe_movimento_id,last_batch_id,last_updated)
VALUES (4,7,3829,'2019-07-18 16:05:31.0')
+
+statement ok rowcount 1
+INSERT INTO "dw_hospital"."bri_classi_gruppi_movimenti"
(classe_movimento_id,gruppo_classe_movimento_id,last_batch_id,last_updated)
VALUES (7,7,3829,'2019-07-18 16:05:31.0')
+
+statement ok rowcount 1
+INSERT INTO "dw_hospital"."bri_classi_gruppi_movimenti"
(classe_movimento_id,gruppo_classe_movimento_id,last_batch_id,last_updated)
VALUES (20,7,3829,'2019-07-18 16:05:31.0')
+
+statement ok rowcount 1
+INSERT INTO "dw_hospital"."bri_classi_gruppi_movimenti"
(classe_movimento_id,gruppo_classe_movimento_id,last_batch_id,last_updated)
VALUES (21,7,3829,'2019-07-18 16:05:31.0')
+
+statement ok rowcount 1
+INSERT INTO "dw_hospital"."bri_classi_gruppi_movimenti"
(classe_movimento_id,gruppo_classe_movimento_id,last_batch_id,last_updated)
VALUES (24,7,3829,'2019-07-18 16:05:31.0')
+
+statement ok rowcount 1
+INSERT INTO "dw_hospital"."bri_classi_gruppi_movimenti"
(classe_movimento_id,gruppo_classe_movimento_id,last_batch_id,last_updated)
VALUES (25,7,3829,'2019-07-18 16:05:31.0')
+
+statement ok rowcount 1
+INSERT INTO "dw_hospital"."dim_classi_movimenti"
(id,codice,descrizione,tipo_centro,tipo_movimentazione,tipo_caricamento,uso_ribaltamento,version,valid_from,valid_to,last_batch_id,last_updated)
VALUES (0,'ND','Non Disponibile','Non Disponibile','Non Disponibile','Non
Disponibile','Non Disponibile',1,'1900-01-01','2199-12-31',840,'2019-07-18
09:48:06.0')
+
+statement ok rowcount 1
+INSERT INTO "dw_hospital"."dim_classi_movimenti"
(id,codice,descrizione,tipo_centro,tipo_movimentazione,tipo_caricamento,uso_ribaltamento,version,valid_from,valid_to,last_batch_id,last_updated)
VALUES (1,'1','Movimenti da
Contabilita','Centro','Multi-periodo','Automatico','No',1,'1900-01-01','2200-01-01',842,'2019-07-18
09:48:06.0')
+
+statement ok rowcount 1
+INSERT INTO "dw_hospital"."dim_classi_movimenti"
(id,codice,descrizione,tipo_centro,tipo_movimentazione,tipo_caricamento,uso_ribaltamento,version,valid_from,valid_to,last_batch_id,last_updated)
VALUES (4,'11','Competenza pers l.g.','Centro','Periodo
Singolo','Automatico','No',1,'1900-01-01','2200-01-01',842,'2019-07-18
09:48:06.0')
+
+statement ok rowcount 1
+INSERT INTO "dw_hospital"."dim_classi_movimenti"
(id,codice,descrizione,tipo_centro,tipo_movimentazione,tipo_caricamento,uso_ribaltamento,version,valid_from,valid_to,last_batch_id,last_updated)
VALUES (7,'1103','Consuntivo con budget','Gruppo','Non Definito','Non
Definito','Si',1,'1900-01-01','2200-01-01',842,'2019-07-18 09:48:06.0')
+
+statement ok rowcount 1
+INSERT INTO "dw_hospital"."dim_classi_movimenti"
(id,codice,descrizione,tipo_centro,tipo_movimentazione,tipo_caricamento,uso_ribaltamento,version,valid_from,valid_to,last_batch_id,last_updated)
VALUES (20,'2','Movimenti da
Magazzino','Centro','Multi-periodo','Automatico','No',1,'1900-01-01','2200-01-01',842,'2019-07-18
09:48:06.0')
+
+statement ok rowcount 1
+INSERT INTO "dw_hospital"."dim_classi_movimenti"
(id,codice,descrizione,tipo_centro,tipo_movimentazione,tipo_caricamento,uso_ribaltamento,version,valid_from,valid_to,last_batch_id,last_updated)
VALUES (21,'20','Attivita','Centro','Periodo
Singolo','Automatico','No',1,'1900-01-01','2200-01-01',842,'2019-07-18
09:48:06.0')
+
+statement ok rowcount 1
+INSERT INTO "dw_hospital"."dim_classi_movimenti"
(id,codice,descrizione,tipo_centro,tipo_movimentazione,tipo_caricamento,uso_ribaltamento,version,valid_from,valid_to,last_batch_id,last_updated)
VALUES (24,'38','Ribaltamenti utenze','Centro','Periodo
Singolo','Automatico','Si',1,'1900-01-01','2200-01-01',842,'2019-07-18
09:48:06.0')
+
+statement ok rowcount 1
+INSERT INTO "dw_hospital"."dim_periodi"
(id,language_code,country_code,month_abbreviation,month_name,quarter_name,year_quarter,year_month_abbreviation,year2,year4,month_number,quarter_number,year_month_number,last_batch_id,last_updated)
VALUES (1,'it','IT','ND','Non
definita','ND','ND','ND','ND',0,0,0,'ND',0,'2012-05-25 16:11:06.0')
+
+statement ok rowcount 1
+INSERT INTO "dw_hospital"."dim_periodi"
(id,language_code,country_code,month_abbreviation,month_name,quarter_name,year_quarter,year_month_abbreviation,year2,year4,month_number,quarter_number,year_month_number,last_batch_id,last_updated)
VALUES (201701,'it','IT','gen','gennaio','I Trim','2017-I
Trim','2017-gen','17',2017,1,1,'2017-01',110,'2012-05-25 16:13:07.0')
+
+statement ok rowcount 1
+INSERT INTO "dw_hospital"."dim_periodi"
(id,language_code,country_code,month_abbreviation,month_name,quarter_name,year_quarter,year_month_abbreviation,year2,year4,month_number,quarter_number,year_month_number,last_batch_id,last_updated)
VALUES (201702,'it','IT','feb','febbraio','I Trim','2017-I
Trim','2017-feb','17',2017,2,1,'2017-02',110,'2012-05-25 16:13:07.0')
+
+statement ok rowcount 1
+INSERT INTO "dw_hospital"."dim_periodi"
(id,language_code,country_code,month_abbreviation,month_name,quarter_name,year_quarter,year_month_abbreviation,year2,year4,month_number,quarter_number,year_month_number,last_batch_id,last_updated)
VALUES (201703,'it','IT','mar','marzo','I Trim','2017-I
Trim','2017-mar','17',2017,3,1,'2017-03',110,'2012-05-25 16:13:07.0')
+
+statement ok rowcount 1
+INSERT INTO "dw_hospital"."dim_periodi"
(id,language_code,country_code,month_abbreviation,month_name,quarter_name,year_quarter,year_month_abbreviation,year2,year4,month_number,quarter_number,year_month_number,last_batch_id,last_updated)
VALUES (201704,'it','IT','apr','aprile','II Trim','2017-II
Trim','2017-apr','17',2017,4,2,'2017-04',110,'2012-05-25 16:13:07.0')
+
+statement ok rowcount 1
+INSERT INTO "dw_hospital"."dim_periodi"
(id,language_code,country_code,month_abbreviation,month_name,quarter_name,year_quarter,year_month_abbreviation,year2,year4,month_number,quarter_number,year_month_number,last_batch_id,last_updated)
VALUES (201705,'it','IT','mag','maggio','II Trim','2017-II
Trim','2017-mag','17',2017,5,2,'2017-05',110,'2012-05-25 16:13:07.0')
+
+statement ok rowcount 1
+INSERT INTO "dw_hospital"."dim_periodi"
(id,language_code,country_code,month_abbreviation,month_name,quarter_name,year_quarter,year_month_abbreviation,year2,year4,month_number,quarter_number,year_month_number,last_batch_id,last_updated)
VALUES (201706,'it','IT','giu','giugno','II Trim','2017-II
Trim','2017-giu','17',2017,6,2,'2017-06',110,'2012-05-25 16:13:07.0')
+
+statement ok rowcount 1
+INSERT INTO "dw_hospital"."dim_periodi"
(id,language_code,country_code,month_abbreviation,month_name,quarter_name,year_quarter,year_month_abbreviation,year2,year4,month_number,quarter_number,year_month_number,last_batch_id,last_updated)
VALUES (201707,'it','IT','lug','luglio','III Trim','2017-III
Trim','2017-lug','17',2017,7,3,'2017-07',110,'2013-02-14 12:31:23.0')
+
+statement ok rowcount 1
+INSERT INTO "dw_hospital"."dim_periodi"
(id,language_code,country_code,month_abbreviation,month_name,quarter_name,year_quarter,year_month_abbreviation,year2,year4,month_number,quarter_number,year_month_number,last_batch_id,last_updated)
VALUES (201708,'it','IT','ago','agosto','III Trim','2017-III
Trim','2017-ago','17',2017,8,3,'2017-08',110,'2013-02-14 12:31:23.0')
+
+statement ok rowcount 1
+INSERT INTO "dw_hospital"."dim_periodi"
(id,language_code,country_code,month_abbreviation,month_name,quarter_name,year_quarter,year_month_abbreviation,year2,year4,month_number,quarter_number,year_month_number,last_batch_id,last_updated)
VALUES (201709,'it','IT','set','settembre','III Trim','2017-III
Trim','2017-set','17',2017,9,3,'2017-09',110,'2013-02-14 12:31:24.0')
+
+statement ok rowcount 1
+INSERT INTO "dw_hospital"."dim_periodi"
(id,language_code,country_code,month_abbreviation,month_name,quarter_name,year_quarter,year_month_abbreviation,year2,year4,month_number,quarter_number,year_month_number,last_batch_id,last_updated)
VALUES (201710,'it','IT','ott','ottobre','IV Trim','2017-IV
Trim','2017-ott','17',2017,10,4,'2017-10',110,'2012-05-25 16:13:07.0')
+
+statement ok rowcount 1
+INSERT INTO "dw_hospital"."dim_periodi"
(id,language_code,country_code,month_abbreviation,month_name,quarter_name,year_quarter,year_month_abbreviation,year2,year4,month_number,quarter_number,year_month_number,last_batch_id,last_updated)
VALUES (201711,'it','IT','nov','novembre','IV Trim','2017-IV
Trim','2017-nov','17',2017,11,4,'2017-11',110,'2012-05-25 16:13:07.0')
+
+statement ok rowcount 1
+INSERT INTO "dw_hospital"."dim_periodi"
(id,language_code,country_code,month_abbreviation,month_name,quarter_name,year_quarter,year_month_abbreviation,year2,year4,month_number,quarter_number,year_month_number,last_batch_id,last_updated)
VALUES (201712,'it','IT','dic','dicembre','IV Trim','2017-IV
Trim','2017-dic','17',2017,12,4,'2017-12',110,'2012-05-25 16:13:07.0')
+
+statement ok rowcount 1
+INSERT INTO "dw_hospital"."dim_periodi"
(id,language_code,country_code,month_abbreviation,month_name,quarter_name,year_quarter,year_month_abbreviation,year2,year4,month_number,quarter_number,year_month_number,last_batch_id,last_updated)
VALUES (201801,'it','IT','gen','gennaio','I Trim','2018-I
Trim','2018-gen','18',2018,1,1,'2018-01',110,'2012-05-25 16:13:07.0')
+
+statement ok rowcount 1
+INSERT INTO "dw_hospital"."dim_periodi"
(id,language_code,country_code,month_abbreviation,month_name,quarter_name,year_quarter,year_month_abbreviation,year2,year4,month_number,quarter_number,year_month_number,last_batch_id,last_updated)
VALUES (201802,'it','IT','feb','febbraio','I Trim','2018-I
Trim','2018-feb','18',2018,2,1,'2018-02',110,'2012-05-25 16:13:07.0')
+
+statement ok rowcount 1
+INSERT INTO "dw_hospital"."dim_periodi"
(id,language_code,country_code,month_abbreviation,month_name,quarter_name,year_quarter,year_month_abbreviation,year2,year4,month_number,quarter_number,year_month_number,last_batch_id,last_updated)
VALUES (201803,'it','IT','mar','marzo','I Trim','2018-I
Trim','2018-mar','18',2018,3,1,'2018-03',110,'2012-05-25 16:13:07.0')
+
+statement ok rowcount 1
+INSERT INTO "dw_hospital"."dim_periodi"
(id,language_code,country_code,month_abbreviation,month_name,quarter_name,year_quarter,year_month_abbreviation,year2,year4,month_number,quarter_number,year_month_number,last_batch_id,last_updated)
VALUES (201804,'it','IT','apr','aprile','II Trim','2018-II
Trim','2018-apr','18',2018,4,2,'2018-04',110,'2012-05-25 16:13:07.0')
+
+statement ok rowcount 1
+INSERT INTO "dw_hospital"."dim_periodi"
(id,language_code,country_code,month_abbreviation,month_name,quarter_name,year_quarter,year_month_abbreviation,year2,year4,month_number,quarter_number,year_month_number,last_batch_id,last_updated)
VALUES (201805,'it','IT','mag','maggio','II Trim','2018-II
Trim','2018-mag','18',2018,5,2,'2018-05',110,'2012-05-25 16:13:07.0')
+
+statement ok rowcount 1
+INSERT INTO "dw_hospital"."dim_periodi"
(id,language_code,country_code,month_abbreviation,month_name,quarter_name,year_quarter,year_month_abbreviation,year2,year4,month_number,quarter_number,year_month_number,last_batch_id,last_updated)
VALUES (201806,'it','IT','giu','giugno','II Trim','2018-II
Trim','2018-giu','18',2018,6,2,'2018-06',110,'2012-05-25 16:13:07.0')
+
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
