Skip to content

problems with '.' in column names #10

@seralf

Description

@seralf

Hi

Using something like:

<#TableMapping> rr:sqlQuery """
SELECT T.first
FROM TableName AS T
;
""" .

and then

rr:predicateObjectMap [
    rr:predicate mae:arc_num ;
    rr:objectMap [ rr:column "T.first" ]
] ;

I obtain the error:

Exception in thread "main" es.upm.fi.oeg.morph.execute.RelationalQueryException: Invalid query: Incorrect syntax near '.'.

NOTE that there is a simple workaround, as the error disappears when using column aliases, but it can be annoying if one has to use the '*' syntax, for example

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions