Add column: Error executing SQL not supported. FIXME!!: near "not": syntax error

General Discussion
1

Hi

 

I am trying to add a column. But I get an error like this:

 

SEVERE 23-04-13 00:30:liquibase: Change Set C:/Users/liquibase/changelog/db.changelog
-1.0.xml::2::jf failed. Error: Error executing SQL not supported. FIXME!!: near
“not”: syntax error
liquibase.exception.DatabaseException: Error executing SQL not supported. FIXME!
!: near “not”: syntax error

 

 

My changelog file looks like:

 

<?xml version="1.0" encoding="UTF-8"?>

<databaseChangeLog
  xmlns="http://www.liquibase.org/xml/ns/dbchangelog"
  xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  xsi:schemaLocation="http://www.liquibase.org/xml/ns/dbchangelog
         http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-2.0.xsd">
 
 
 
       
   
 

 

 

Here is the error log:

 

INFO 23-04-13 00:30:liquibase: Successfully acquired change log lock
INFO 23-04-13 00:30:liquibase: Reading from DATABASECHANGELOG
INFO 23-04-13 00:30:liquibase: Reading from DATABASECHANGELOG
SEVERE 23-04-13 00:30:liquibase: Change Set C:/Users/liquibase/changelog/db.changelog
-1.0.xml::2::jf failed.  Error: Error executing SQL not supported. FIXME!!: near
 “not”: syntax error
liquibase.exception.DatabaseException: Error executing SQL not supported. FIXME!
!: near “not”: syntax error
        at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:62)
        at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:104)
        at liquibase.database.AbstractDatabase.execute(AbstractDatabase.java:109
1)
        at liquibase.database.AbstractDatabase.executeStatements(AbstractDatabas
e.java:1075)
        at liquibase.changelog.ChangeSet.execute(ChangeSet.java:317)
        at liquibase.changelog.visitor.UpdateVisitor.visit(UpdateVisitor.java:27
)
        at liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:58)
        at liquibase.Liquibase.update(Liquibase.java:114)
        at module.dbmaintain.liquibase.Changelog.updateChangelog(Changelog.java:
32)
        at _jsp._test._updatedb__jsp._jspService(_updatedb__jsp.java:36)
        at com.caucho.jsp.JavaPage.service(JavaPage.java:61)
        at com.caucho.jsp.Page.pageservice(Page.java:578)
        at com.caucho.server.dispatch.PageFilterChain.doFilter(PageFilterChain.j
ava:195)
        at com.caucho.server.webapp.WebAppFilterChain.doFilter(WebAppFilterChain
.java:187)
        at com.caucho.server.dispatch.ServletInvocation.service(ServletInvocatio
n.java:265)
        at com.caucho.server.http.HttpRequest.handleRequest(HttpRequest.java:273
)
        at com.caucho.server.port.TcpConnection.run(TcpConnection.java:682)
        at com.caucho.util.ThreadPool$Item.runTasks(ThreadPool.java:743)
        at com.caucho.util.ThreadPool$Item.run(ThreadPool.java:662)
        at java.lang.Thread.run(Thread.java:662)
Caused by: java.sql.SQLException: near “not”: syntax error
        at org.sqlite.DB.throwex(DB.java:288)
        at org.sqlite.NestedDB.prepare(NestedDB.java:115)
        at org.sqlite.DB.prepare(DB.java:114)
        at org.sqlite.Stmt.execute(Stmt.java:82)
        at liquibase.executor.jvm.JdbcExecutor$1ExecuteStatementCallback.doInSta
tement(JdbcExecutor.java:92)
        at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:55)
        … 19 more
INFO 23-04-13 00:30:liquibase: Successfully released change log lock
INFO 23-04-13 00:30:liquibase: Successfully released change log lock

 

2

More info:

 

I am using sqlite.

 

It works fine when I am using the SQL element:

ALTER TABLE ticket ADD name varchar(150)