Skip to:

  1. Skip to Jira Navigation
  2. Skip to Side Navigation
  3. Skip to Main Content

Invalid column name Exception in Sybase ASE 15

Description

When running a diff from the command line (.bat file), I am getting "Invalid column name" exception on seemingly normal column name "prodcode".

Environment

Windows XP, Sybase ASE 15

Activity

Show:

Nathan Voxland June 12, 2013 at 6:07 PM

This should be working now in 3.0

Nathan Voxland September 12, 2011 at 5:00 AM

The main focus of 2.1 is database diff logic, including how to handle case sensitive databases. We need to handle things case insensitively when the database doesn't care (which is most of the time) but handle it correctly when it does care. How to represent that needs to be worked through.

Nathan Voxland September 10, 2011 at 5:27 AM

Sorry, meant 2.0.2. Thanks for catching that.

Chad Cornelison September 10, 2011 at 1:54 AM

Since version 2.0.1 was already released in January, Did you perhaps mean 2.0.2? (Or maybe 2.1, but hopefully the former)

Chad Cornelison September 9, 2011 at 8:27 PM

FYI: I found the source of equalsIgnoreCase.
(although I'm not sure how it should be patched)
and here is an example that will illustrate

Sample Tables

During the Diff, it tries to do the queries below.
(as part of method: isColumnAutoIncrement)

Results

Liquibase Update Failed: Invalid column name 'lowercase'.

Full code path:

JdbcSnapshotGenerator.java:357

DatabaseSnapshot.java:66

JdbcDatabaseSnapshotGenerator.java:371

Perhaps DatabaseSnapshot.java can be aware of case senstivie databases and optionally use equalsIgnoreCase?
(assuming it's even needed in the first place)

Fixed

Details

Reporter

Components

Fix versions

Affects versions

Priority

Created August 3, 2011 at 7:41 PM
Updated June 20, 2013 at 3:31 AM
Resolved June 12, 2013 at 6:07 PM