Skip to main content
Database Administrators

Return to Question

Bumped by Community user
added 32 characters in body
Source Link
mustaccio
mustaccio
  • 26.9k
  • 24
  • 58
  • 74

I am trying to migrate from oracleOracle to mariadbMariaDB. At the moment, we are facing an issue with the following oracleOracle code.

 SELECT id,MK, pid,AFI 
   FROM M A 
  WHERE **LEVELLEVEL <= 2**2 -- limiting iterations here
  START WITH pid = 1 
CONNECT BY Pid = PRIOR id;

We have used recursive common expression table but we are unable to restrict the number of iterations to 2  (LEVEL <= 2LEVEL <= 2). We don't want to set the system variables like cte_max_recursion_depth. Please help us to solve the issuecte_max_recursion_depth. How else can we limit recursion depth?

I am trying to migrate from oracle to mariadb. At the moment, we are facing an issue with the following oracle code.

 SELECT id,MK, pid,AFI 
   FROM M A 
  WHERE **LEVEL <= 2** 
  START WITH pid = 1 
CONNECT BY Pid = PRIOR id;

We have used recursive common expression table but we are unable to restrict the number of iterations to 2(LEVEL <= 2). We don't want to set the system variables like cte_max_recursion_depth. Please help us to solve the issue.

I am trying to migrate from Oracle to MariaDB. At the moment, we are facing an issue with the following Oracle code.

 SELECT id,MK, pid,AFI 
   FROM M A 
  WHERE LEVEL <= 2 -- limiting iterations here
  START WITH pid = 1 
CONNECT BY Pid = PRIOR id;

We have used recursive common expression table but we are unable to restrict the number of iterations to 2  (LEVEL <= 2). We don't want to set the system variables like cte_max_recursion_depth. How else can we limit recursion depth?

added 32 characters in body
Source Link
Kondybas
Kondybas
  • 4.6k
  • 17
  • 14

I am trying to migrate from oracle to mariadb. At the moment, we are facing an issue with the following oracle code.

 SELECT id,MK, pid,AFI 
   FROM M A 
  WHERE **LEVEL <= 2** 
  START WITH pid = 1  
CONNECT BY Pid = PRIOR id;

We have used recursive common expression table but we are unable to restrict the number of iterations to 2(LEVEL <= 2). We don't want to set the system variables like cte_max_recursion_depth. Please help us to solve the issue.

I am trying to migrate from oracle to mariadb. At the moment, we are facing an issue with the following oracle code.

SELECT id,MK, pid,AFI FROM M A WHERE **LEVEL <= 2** START WITH pid = 1 CONNECT BY Pid = PRIOR id;

We have used recursive common expression table but we are unable to restrict the number of iterations to 2(LEVEL <= 2). We don't want to set the system variables like cte_max_recursion_depth. Please help us to solve the issue.

I am trying to migrate from oracle to mariadb. At the moment, we are facing an issue with the following oracle code.

 SELECT id,MK, pid,AFI 
   FROM M A 
  WHERE **LEVEL <= 2** 
  START WITH pid = 1  
CONNECT BY Pid = PRIOR id;

We have used recursive common expression table but we are unable to restrict the number of iterations to 2(LEVEL <= 2). We don't want to set the system variables like cte_max_recursion_depth. Please help us to solve the issue.

Source Link
Saivishnu S R
Saivishnu S R
  • 51
  • 1
  • 9

Limiting Common Table Recursion

I am trying to migrate from oracle to mariadb. At the moment, we are facing an issue with the following oracle code.

SELECT id,MK, pid,AFI FROM M A WHERE **LEVEL <= 2** START WITH pid = 1 CONNECT BY Pid = PRIOR id;

We have used recursive common expression table but we are unable to restrict the number of iterations to 2(LEVEL <= 2). We don't want to set the system variables like cte_max_recursion_depth. Please help us to solve the issue.