Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

MySQL POINT type creates trap on SELECT #55

Closed
iachievedit opened this issue Sep 22, 2016 · 1 comment

Comments

Projects
None yet
2 participants
@iachievedit
Copy link

commented Sep 22, 2016

Using 1.0.0 I executed try mysql.execute("CREATE TABLE locations (location POINT)") to create a table with a column of type POINT. I then noticed that running SELECT * FROM locations was throwing an exception with outputBind("") as the error.

As a working example I posted a Swift application here: https://github.com/iachievedit/point

The issue is easily reproducible with Vapor 1.0.0/MySQL 5.7. The upshot is that vapor/mysql cannot retrieve POINT data from the MySQL database (although it has no issue inserting it).

Also, in the same application running SELECT AsText(location) FROM locations fails with:

[MySQL] Unsupported type: unknown.
[["AsText(location)": Node.Node.null]]
@BrettRToomey

This comment has been minimized.

Copy link
Contributor

commented May 3, 2017

Closing due to inactivity. Please feel free to reopen.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
You can’t perform that action at this time.