× Heads up!

Aqua Data Studio / nhilam

Follow
IDE for Relational Databases
×
Diksha Kushwah
Diksha.kushwah(*) reported 2014-11-05T04:51:05Z  · tomconrad last modified 2018-03-16T20:37:03Z

SQLSERVER 2014: Exception is thrown on Debug Function in Debugger.


Dev
Kin-Hong Wong
kin-hong
QA
Niels Gron
NielsGron
Priority Low
Complexity Unknown
Component Editor - Debugger for SQL Server
Version Future - PM
Version: 16.0.0-dev-21
Build #: 40865
Build Date: 2014-Oct-31 04:37:46 PM
 
Operating Environment: Windows 7 (6.1, amd64) / Cp1252 / en / US / Oracle Corporation 1.7.0_60-b19
Memory: Max=704,643,072;  Total=390,594,560;  Free=324,656,296;  CPUs=8
 
Description:
 
1. Connect Sql Server 2014
2. Create a Function using following script:
 
   CREATE TABLE [dbo].[TrackingItem]  ( 
[Id]       int IDENTITY(1,1) NOT NULL,
[Issued]   date NOT NULL,
[Category] int NOT NULL 
)
    GO
   CREATE FUNCTION [dbo].[TrackingItemsModified](@minId int)
   RETURNS @trackingItems TABLE (
   Id       int      NOT NULL,
   Issued   date     NOT NULL,
   Category int      NOT NULL,
   Modified datetime NULL
   ) 
   AS
    BEGIN
   INSERT INTO @trackingItems (Id, Issued, Category)
   SELECT ti.Id, ti.Issued, ti.Category 
   FROM   TrackingItem ti
   WHERE  ti.Id >= @minId; 
   
   UPDATE @trackingItems
   SET Category = Category + 1,
       Modified = GETDATE()
   WHERE Category%2 = 0;
  
   RETURN;
    END;
    GO
 
3. Right click on Function TrackingItemsModified and click on Debug in Function Debugger.
4. Click on Execute in Debugger 
   Following Exception is thrown:
   
   java.lang.NullPointerException
at com.aquafold.debugger.mssql.impl.Iꉴꁪꁻꑢ.a(Unknown Source)
at com.aquafold.debugger.mssql.impl.fꂎꁹᚠꊎ new.a(Unknown Source)
at \\...\\ .\\हिñçêČάй語简�?한\\.Iꌥꄘꒊꎡ return.dm(Unknown Source)
at \\...\\ .\\हिñçêČάй語简�?한\\.aꀷꊤꎍꌗ.a(Unknown Source)
at \\...\\ .\\हिñçêČάй語简�?한\\.Iꌥꄘꒊꎡ return.run(Unknown Source)
   
   java.lang.IllegalArgumentException
at com.aquafold.debugger.mssql.impl.fꂎꁹᚠꊎ new.i(Unknown Source)
at com.aquafold.debugger.mssql.impl.fꂎꁹᚠꊎ new.a(Unknown Source)
at \\...\\ .\\हिñçêČάй語简�?한\\.Iꌥꄘꒊꎡ return.bS(Unknown Source)
at \\...\\ .\\हिñçêČάй語简�?한\\.Iꌥꄘꒊꎡ return.run(Unknown Source)
 
1 attachment
  •  
  •  
  • 2 shares
  •  
All Comments (8) Change History
Sort 

Issue #12659
Reopened
Incomplete
 
 
Completion
No due date
No fixed build
No time estimate

About AquaClusters Privacy Policy Support Version - 19.0.2-4 AquaFold, Inc Copyright © 2007-2017