# Czar dies when parser throws exception

XMLWordPrintable

## Details

• Type: Bug
• Status: Invalid
• Resolution: Done
• Fix Version/s: None
• Component/s:
• Labels:
None
• Story Points:
6
• Sprint:
DB_W16_10, DB_W16_11, DB_W16_12, DB_W16_01
• Team:
Data Access and Database

## Description

Running a query that mistakenly uses scisql_s2PtInBox instead of qserv_s2PtInBox

 select objectId, coord_ra, coord_dec  from smm_bremerton.deepCoadd_forced_src  where scisql_s2PtInBox(coord_ra, coord_dec, 320.05, 0.457, 320.06, 0.46)

kills czar, the error message in czar log file is:

 ERROR ccontrol.UserQueryFactory (build/ccontrol/UserQueryFactory.cc:117)  - Invalid query: ParseException:Parse error(ANTLR):unexpected token: scisql_s2PtInBox:

We need to change the code so that a random query does not kill czar. This story involves fixing czar so that it does not die when parser chokes on the syntax.

## Activity

Hide
Jacek Becla added a comment -

I tried to reproduce the problem and I could not, so I am going to close this. But while playing with that, I noticed a different issue, which I'll cover in a new story.

Show
Jacek Becla added a comment - I tried to reproduce the problem and I could not, so I am going to close this. But while playing with that, I noticed a different issue, which I'll cover in a new story.

## People

• Assignee:
Fabrice Jammes
Reporter:
Fritz Mueller
Watchers:
Jacek Becla