Details
-
Type:
Bug
-
Status: Invalid
-
Resolution: Done
-
Fix Version/s: None
-
Component/s: Qserv
-
Labels:
-
Epic Link:
-
Sprint:DB_W16_12
-
Team:Data Access and Database
Description
sql> select * from DeepForcedSource where qserv_areaSpec_box(0.4,0.9,0.6,1.1) LIMIT 3000
[2015-02-10 16:12:14] [42S02][1051] Unknown table 'result_4492663598'
[2015-02-10 16:12:14] [Proxy][4120] Error during execution:
-1 Ref=1 Resource(/chk/LSST/7140): 20150210-16:12:01, Error merging result, 1470, [1064] You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'QST_1_.,0.4,0.9,0.6,1.1)=1 LIMIT 3 (-1)
qserv_area_spec is deprecated. The proposed/supported alternative, direct use of scisql_s2PtIn*, already works correctly for well-formulated queries on any sort of table.