search

microsoft / azuredatastudio-postgresql

azuredatastudio-postgresql is an extension for Azure Data Studio that enables you to work with PostgreSQL databases
Other
193 stars 36 forks source link

No results returned when selecting a timestamptz #486

Closed awr closed 7 months ago

awr commented 7 months ago

Type: Bug

with a postgres table such as the following 

CREATE TABLE IF NOT EXISTS api."Users"
(
    "UserId" bigint NOT NULL GENERATED BY DEFAULT AS IDENTITY ( INCREMENT 1 MINVALUE 1 MAXVALUE 9223372036854775807 CACHE 1 ),
    "CreateDate" timestamp with time zone NOT NULL,
    "DeleteDate" timestamp with time zone NOT NULL DEFAULT '-infinity'::timestamp with time zone
)

Doing a select fails when including the column that has the default. So the following query fails:

select  "UserId", "CreateDate", "DeleteDate"
from api."Users"
LIMIT 1000

No results, and in the messages, and in the results I see is image

When I do not include the column with the default, it works fine and I get results. Query is:

select  "UserId", "CreateDate"
from api."Users"
LIMIT 1000

Azure Data Studio version: azuredatastudio 1.47.0 (c7c2b2f21505562d21972d4c135119d00806db4f, 2023-11-07T17:17:45.669Z) OS version: Windows_NT x64 10.0.22631 Restricted Mode: No Preview Features: Enabled Modes:

System Info |Item|Value| |---|---| |CPUs|Intel(R) Core(TM) i7-10875H CPU @ 2.30GHz (16 x 2304)| |GPU Status|2d_canvas: enabled
canvas_oop_rasterization: enabled_on
direct_rendering_display_compositor: disabled_off_ok
gpu_compositing: enabled
multiple_raster_threads: enabled_on
opengl: enabled_on
rasterization: enabled
raw_draw: disabled_off_ok
video_decode: enabled
video_encode: enabled
vulkan: disabled_off
webgl: enabled
webgl2: enabled
webgpu: enabled| |Load (avg)|undefined| |Memory (System)|63.75GB (31.40GB free)| |Process Argv|| |Screen Reader|no| |VM|0%|
Extensions (5) Extension|Author (truncated)|Version ---|---|--- copilot|Git|1.95.239 azuredatastudio-postgresql|Mic|0.5.0 query-history|Mic|0.5.3 azdata-sanddance|msr|4.1.1 vscodeintellicode|Vis|1.2.1
nasc17 commented 7 months ago

Hi @awr we currently have an insiders release out now that you can test against to see if issue is present with our newer updates: https://github.com/microsoft/azuredatastudio-postgresql/releases/tag/v0.5.1-insiders

awr commented 7 months ago

Much better, thanks!

nasc17 commented 7 months ago

Much better, thanks!

Thank you for the quick verification. We should have an updated stable release out by the end of this week