Hsqldb: Duplicate Column Name, Unsupported Internal Operation: Type, Invalid Character For Cast

I am beginning with HSQLDB, but I hit this issue and can't figure out what's going on: CREATE TEXT TABLE ozizkaindata ( jobName VARCHAR(255) NOT NULL, buildNumber VARCHAR(255)

Solution 1:

All right, this was easy. I forgot to ignore the first line of my imported text data with a comment, so it was invalid syntax. What a shame :)