Comments (3)
Is this an error with the hibernate extension? Or the general liquibase formatted sql support?
from liquibase-hibernate.
This issue is a general Liquibase SQL Changeset error.
In a Liquibase SQL change set, you must start with the comment "--liquibase formatted sql". Unfortunately, this is not a well-formed comment in MySQL. The comment must be "-- liquibase formatted sql". If you add the space to the liquibase comment, liquibase does not recognize it. If you continue without the space, all MySQL lint programs (e.g. Intelli-J, etc.) mark those lines as errors, and the scripts can not be executed with MySQL Workbench or other MySQL tools.
For example:
--liquibase formatted sql
--changeset smoore:20140730 dbms:mysql failOnError:true
CREATE TABLE example
(
company_guid varchar(36) not null,
anything varchar(80),
create_ts datetime not null default now(),
lastmod_ts datetime not null default now(),
primary key( company_guid )
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--rollback DROP TABLE example;
Performing a syntax check (or execution) against MySQL returns:
13:55:22 --liquibase formatted sql
Error Code: 1064. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '--liquibase formatted sql' at line 1.
The fix would be to allow liquibase to recognize a space after the "--" in the comment. This is not related to liquibase-hibernate specifically at all.
from liquibase-hibernate.
This was addressed by CORE-1032.
https://liquibase.jira.com/browse/CORE-1032
from liquibase-hibernate.
Related Issues (20)
- Support for hibernate 6.2 HOT 15
- diffChangeLog generates always an equal modifyDataType ChangeSet HOT 1
- Duplicated add/drop index SQL statements for adding/removing unique constraints HOT 1
- is 4.23.0+ not going to support Hibernate 5? HOT 3
- Liquibase diff not working from cli
- Maven plugin 'diff' generate addUniqueConstraint on PrimaryKey column HOT 1
- Hibernate 6.3.1 breaking changes HOT 3
- Database diff not considering column length HOT 1
- Broken hyperlink in the ReadMe
- Quarkus Support with liquibase-hibernate similar to Spring Bean HOT 1
- liquibase-hibernate6-4.25.0.jar contains classes from other libraries HOT 6
- Hibernet6 Enum type DDL issue HOT 2
- Wrong column type generated with diffChangelog
- HibernateSpringBeanDatabase cannot be loaded by service loader if Spring is not on classpath HOT 1
- org.liquibase.ext:liquibase-hibernate5:4.26.0 in the Maven HOT 1
- LocalTime (TIME) is not handled the same as TIMESTAMP
- NullPointerException for jsonb Postgres column
- java.lang.NullPointerException: Cannot invoke "java.sql.ResultSet.next()" because "schemas" is null HOT 1
- Primary Key Ordering with Hibernate >6.4
- Request for minimal example for integration with Spring Boot
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from liquibase-hibernate.