microsoft/azuredatastudio-postgresql

No results returned when selecting a timestamptz

awr opened this issue · 3 comments

awr commented

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

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

Much better, thanks!

nasc17 commented

Much better, thanks!

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