Message Title

the problem with

 
                                                                SELECT id, name, extract(year from birthDate), birthDate FROM Person

 
                                                                Person

having an attribute named

 
                                                                year

So you have two options, one is to rename the

 
                                                                Person#year

into by example

 
                                                                yearOfBirth

the other is to change the query

 
                                                                SELECT id, name, extract(year from birthDate), birthDate FROM Person"

 
                                                                SELECT id, name, year(birthDate), birthDate FROM Person"

and it should work.

Get JIRA notifications on your phone! Download the JIRA Cloud app here.

This message was sent by Atlassian JIRA