Materialised view
craftzneko opened this issue · 1 comments
craftzneko commented
Type: Bug
Unable to script to create on an existing materialised view. My view should look like this
CREATE MATERIALIZED VIEW ictsignal_lastscanperdevice AS
SELECT main.*
FROM ictsignal_production.ictsignal AS main
INNER JOIN (
SELECT computername, MAX(datecreated) AS max_datecreated
FROM ictsignal_production.ictsignal
GROUP BY computername
) AS subquery ON main.computername = subquery.computername AND main.datecreated = subquery.max_datecreated;
but i get an error
Extension version: 0.6.0
Azure Data Studio version: azuredatastudio 1.48.0 (4970733324ef8254b7c22a5dc55af7f8a1dea93f, 2024-02-27T00:05:08.293Z)
OS version: Windows_NT x64 10.0.19045
Restricted Mode: No
Preview Features: Enabled
Modes:
System Info
Item | Value |
---|---|
CPUs | 11th Gen Intel(R) Core(TM) i7-11800H @ 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.73GB (46.72GB free) |
Process Argv | |
Screen Reader | no |
VM | 0% |
craftzneko commented
any update on this, i cant really use this plugin for my needs as i cant seem to see my views