hankinsoft / SQLPro

SQLPro bug & features tracking.
104 stars 27 forks source link

Geo point looks incorrect #952

Closed gpolyansky closed 7 months ago

gpolyansky commented 9 months ago

Describe the bug Postgres databases support POINT data type. But this type of data displaying like "0101000020E6100000A0755E0921CE42403DEA7C2CFCE04B40"

To Reproduce Steps to reproduce the behavior:

  1. Go to view database
  2. Click on any table, that has geo point data type
  3. Look at the data

Expected behavior For example, DBeaver presenting that data type like this:

image

and displaying map with this point.

Screenshots

image

Environment details (please complete the following information):

hankinsoft commented 9 months ago

Hmmm, I'm not able to reproduce this. I've run the following code:

CREATE TABLE locations (
    id SERIAL PRIMARY KEY,
    name VARCHAR(100),
    coordinates POINT
);

INSERT INTO locations (name, coordinates) VALUES
('Location1', POINT(40.7128, -74.0060)),
('Location2', POINT(51.5074, -0.1278));

SELECT * FROM locations;

And I receive point's as expected:

Screenshot 2024-01-05 at 8 39 09 AM

Would you be able to provide any sort of sample statements to recreate the issue?

hankinsoft commented 7 months ago

Closed due to no response.