Skip to content

errors when submitting queries with column fields as arguments in sbox and in sdist #5

@pietroapollo

Description

@pietroapollo

I report the queries I tried (with "ra" and "dec_" as column fields) and their error messages below:

SELECT ra, dec_ FROM hosted.dabrusco2009 WHERE 1 = soverlaps(sbox(spoint(radians(0), radians(0)), spoint(radians(ra), radians(dec_))), scircle(spoint(radians(0), radians(0)), radians(1))) LIMIT 1000;
ERROR 2013 (HY000): Lost connection to MySQL server during query

SELECT ra, dec_ FROM hosted.dabrusco2009 WHERE 10 <> degrees(sdist(spoint(radians(ra), radians(dec_)), spoint(radians(0), radians(0)))) LIMIT 1000;
ERROR 1123 (HY000): Can't initialize function 'sdist'; dist() error combining MySQL sphere objects. Unsupported combination.

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type
    No fields configured for issues without a type.

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions