dropColumn布尔变量时，liquibase迁移失败(liquibase migration failed while dropColumn boolean variable)

 我正在使用Liquibase来链接数据库（H2）的变更，最近我遇到了删除不必要的列迁移异常： Caused by: org.h2.jdbc.JdbcSQLException: View "ALTER TABLE PUBLIC.CE_SOME_TABLE DROP COLUMN some_column" is invalid: "Column ""SOME_TABLE .SOME_COLUMN"" not found [42122-190]"; SQL statement: ALTER TABLE PUBLIC.CE_SOME_TABLE DROP COLUMN some_column[90109-190] Caused by: org.h2.jdbc.JdbcSQLException: View "ALTER TABLE PUBLIC.CE_SOME_TABLE DROP COLUMN some_column" is invalid: "Column ""SOME_TABLE .SOME_COLUMN"" not found [42122-190]"; SQL statement: ALTER TABLE PUBLIC.CE_SOME_TABLE DROP COLUMN some_column[90109-190] 
 
 我已经尝试了以下内容： 
 
 
 
 要检查我的数据库是否真的找到这样的列： 
 
 
 select column_name from information_schema.columns where table_name='ce_some_table'; 
 
 它显示该列名称沿该表格中的其他列存在 
 
 
 
 试图在liquibase中写入SQL语句： 
 
 
 <sql>ALTER TABLE ce_some_table DROP COLUMN some_column;</sql> 
 
 没有做这项工作 
 
 
 
 试图重命名变量（以为数据库元数据已兑现）： 
 <renameColumn catalogName="some_catalog" columnDataType="boolean" newColumnName="some_column2" oldColumnName="some_column" remarks="A Boolean" schemaName="public" tableName="CE_SOME_TABLE"/> 
 
 
 
 然后删除更新的列： 
 
<dropColumn tableName="CE_SOME_TABLE" columnName="some_column2"/>
 
 也没有工作 
 
 
 
 试图从其他表中删除其他表的布尔列（其他表中有+20） - 没有工作 
 
 
 试图放弃其他数据类型的列 - 它的工作（但不是与布尔） 
 
 
 任何我可以尝试的建议？ 
 
 我已经检查过大小写敏感性和一切匹配，但也许我没有看到它在所有表格中都有的东西 
 
 提前感谢您的建议或指出原因 
 
 更新：在删除some_column后，在同一chainSet中，我修改了具有some_column变量的VIEW表 

I am using Liquibase for chaining Data Base (H2) alterations and recently I faced removal of unnecessary column migration exception: Caused by: org.h2.jdbc.JdbcSQLException: View "ALTER TABLE PUBLIC.CE_SOME_TABLE DROP COLUMN some_column" is invalid: "Column ""SOME_TABLE .SOME_COLUMN"" not found [42122-190]"; SQL statement: ALTER TABLE PUBLIC.CE_SOME_TABLE DROP COLUMN some_column[90109-190]
 
I have tried the following:
 
 
 
To check if my DB really find such column: 
 
 
select column_name from information_schema.columns where table_name='ce_some_table';
 
It shows that such column name exists along the other columns in that table
 
 
 
Tried to write SQL statement in liquibase: 
 
 
<sql>ALTER TABLE ce_some_table DROP COLUMN some_column;</sql>
 
Did not do the job
 
 
 
Tried to rename variable (thought DB metadata was cashed): 
 
<renameColumn catalogName="some_catalog" columnDataType="boolean" newColumnName="some_column2" oldColumnName="some_column" remarks="A Boolean" schemaName="public" tableName="CE_SOME_TABLE"/>
 
 
And then to drop the renewed column:
 
<dropColumn tableName="CE_SOME_TABLE" columnName="some_column2"/>
 
Also have not worked
 
 
 
Have tried to drop other boolean columns from other tables (have +20 of other tables) - did not worked
 
 
Have tried to drop other data type columns - it worked (but not with boolean)
 
 
Any advices I could try next?
 
I have checked case sensitivity and everything matches but maybe I do not see something as it accours in all tables
 
Thank you in advance for your advises or pinpointing the reason
 
UPDATE: In the same chainSet after dropping the some_column I modify VIEW table which had some_column variable

原文：https://stackoverflow.com/questions/50285904