All Forums Database
svdata 1 post Joined 06/16
27 Jun 2016
Maximum row length exceeded in recursive query

    

INS INTO Definitions (ID,SID, Query_txt)
WITH RECURSIVE SimpleDef_Concat  (ID,SID, Query_txt,LVL)
AS
	     (    SELECT ID,SID,Query_txt (VARCHAR(62000)), 1
			    FROM SimpleDef2
			    WHERE tokennum = 1
			    UNION ALL
			    SELECT  a.ID,a.SID, cast(a.Query_txt as varchar(31000))  || ' OR ' || cast(b.Query_txt as varchar(31000)) ,b.LVL+1
			    FROM SimpleDef2 a INNER JOIN  SimpleDef_Concat  b
			    ON a.SID = b.SID
			   AND a.tokennum = b.lvl+1
 		)
 SEL ID,SID,  cast('('||Query_txt||')' as varchar(31000))
 FROM SimpleDef_Concat 
 QUALIFY RANK() OVER(PARTITION BY PID,SID ORDER BY LVL DESC) = 1; 		

	

Size of Query_txt in Definitions is 62000 and in SimpleDef2 is 31000

 
I am getting " 2805 Maximum row length exceeded simpledef2" error, can someone help me to overcome this.
 

You must sign in to leave a comment.