Multiple inserts inside single changeset only insert last record in mariaDB

Description

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 <changeSet id="T1" author="a"> <createTable tableName="test1"> <column name="c1" type="varchar(100)" /> </createTable> </changeSet> <changeSet id="T2" author="a"> <insert tableName="test1"> <column name="c1" value="test1" /> </insert> <insert tableName="test1"> <column name="c1" value="test2" /> </insert> <insert tableName="test1"> <column name="c1" value="test3" /> </insert> </changeSet>

Result mariaDB

1 2 3 4 5 6 7 8 select * from test1 ; +-------+ | c1 | +-------+ | test3 | +-------+ 1 row in set (0.000 sec)

Result Oracle

1 2 3 4 5 6 7 select * from test1 ; C1 ---------------------------------------------------------------------------------------------------- test1 test2 test3
1

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 - ********************************************************************* -- Update Database Script -- ********************************************************************* -- Change Log: src/main/resources/master.xml -- Ran at: 8/6/19 3:01 PM -- Against: root@jdbc:mariadb://xxxx:3306/Liquibase_mmprodat_nueva -- Liquibase version: 3.5.3 -- ********************************************************************* -- Create Database Lock Table CREATE TABLE DATABASECHANGELOGLOCK (ID INT NOT NULL, LOCKED BIT(1) NOT NULL, LOCKGRANTED datetime NULL, LOCKEDBY VARCHAR(255) NULL, CONSTRAINT PK_DATABASECHANGELOGLOCK PRIMARY KEY (ID)); -- Initialize Database Lock Table DELETE FROM DATABASECHANGELOGLOCK; INSERT INTO DATABASECHANGELOGLOCK (ID, LOCKED) VALUES (1, 0); -- Lock Database UPDATE DATABASECHANGELOGLOCK SET LOCKED = 1, LOCKEDBY = '192.168.47.1 (192.168.47.1)', LOCKGRANTED = '2019-08-06 15:01:21.092' WHERE ID = 1 AND LOCKED = 0; -- Create Database Change Log Table CREATE TABLE DATABASECHANGELOG (ID VARCHAR(255) NOT NULL, AUTHOR VARCHAR(255) NOT NULL, FILENAME VARCHAR(255) NOT NULL, DATEEXECUTED datetime NOT NULL, ORDEREXECUTED INT NOT NULL, EXECTYPE VARCHAR(10) NOT NULL, MD5SUM VARCHAR(35) NULL, DESCRIPTION VARCHAR(255) NULL, COMMENTS VARCHAR(255) NULL, TAG VARCHAR(255) NULL, LIQUIBASE VARCHAR(20) NULL, CONTEXTS VARCHAR(255) NULL, LABELS VARCHAR(255) NULL, DEPLOYMENT_ID VARCHAR(10) NULL); -- Changeset src/main/resources/MMProDat_import.xml::T1::e CREATE TABLE test1 (c1 VARCHAR(100) NULL); INSERT INTO DATABASECHANGELOG (ID, AUTHOR, FILENAME, DATEEXECUTED, ORDEREXECUTED, MD5SUM, DESCRIPTION, COMMENTS, EXECTYPE, CONTEXTS, LABELS, LIQUIBASE, DEPLOYMENT_ID) VALUES ('T1', 'e', 'src/main/resources/MMProDat_import.xml', NOW(), 1, '7:a2fde9da3b5e5fcfb5261b6a64a24bfd', 'createTable tableName=test1', '', 'EXECUTED', NULL, NULL, '3.5.3', '5114482462'); -- Changeset src/main/resources/MMProDat_import.xml::T2::e INSERT INTO test1 (c1) VALUES ('test1'); INSERT INTO test1 (c1) VALUES ('test2'); INSERT INTO test1 (c1) VALUES ('test3'); INSERT INTO DATABASECHANGELOG (ID, AUTHOR, FILENAME, DATEEXECUTED, ORDEREXECUTED, MD5SUM, DESCRIPTION, COMMENTS, EXECTYPE, CONTEXTS, LABELS, LIQUIBASE, DEPLOYMENT_ID) VALUES ('T2', 'e', 'src/main/resources/MMProDat_import.xml', NOW(), 2, '7:8b4873199014546d09c920e89e407a89', 'insert tableName=test1; insert tableName=test1; insert tableName=test1', '', 'EXECUTED', NULL, NULL, '3.5.3', '5114482462');

 

Environment

Server version: 10.4.6-MariaDB MariaDB Server

Status

Assignee

Unassigned

Reporter

Emiliano Sacchi

Labels

None

Affects versions

3.5.0
3.5.3
3.6.3
3.7.0

Priority

Major
Configure