randgen team mailing list archive

[Saikumar <791783@xxxxxxxxxxxxxxxxxx>]

Noticed a similar issue with ExecuteAsUpdateDelete
/* GenTest::Transform::ExecuteAsInsert
Select */ DROP TABLE IF EXISTS transforms.insert_
select_28983; CREATE TABLE transforms.insert_
select_28983 

The $rewritten_query  in test.pm may require a  regex correction.

-- 
You received this bug notification because you are a member of Random
Query Generator Team, which is subscribed to Random Query Generator.
https://bugs.launchpad.net/bugs/791783

Title:
  MTR testcase creation fails due to a regex in test.Pm

Status in SQL Generator for testing SQL servers (MySQL, JavaDB, PostgreSQL):
  New

Bug description:
  MTR testcases containing the following code (using standard optimizer
  grammars) are created:

  SELECT
  (
  SELECT MIN
  ( SUBQUERY1_t1.col_int_key )
  FROM t3 AS SUBQUERY1_t1 STRAIGHT_JOIN
  ( t2 AS SUBQUERY1_t2 JOIN t1 AS SUBQUERY1_t3 ON SUBQUERY1_t3.col_int_key = SUBQUERY1_t2.pk )
  ON SUBQUERY1_t3.col_varchar_key = SUBQUERY1_t2.col_varchar_key
  WHERE SUBQUERY1_t2.col_varchar_key <> table1.col_varchar_nokey )
  FROM t1 AS table1
  RIGHT JOIN
  (
  SELECT *
  FROM t3 )
  AS table2 JOIN t1 AS table3 ON table3.col_varchar_key = table2.col_varchar_key ON table3.col_varchar_nokey = table2.col_varchar_key 

  This fails with:

  1630: FUNCTION test.MIN does not exist. Check the 'Function Name
  Parsing and Resolution' section in the Reference Manual

  Changing this:

  SELECT MIN
  ( SUBQUERY1_t1.col_int_key )

  to:

  SELECT MIN(SUBQUERY1_t1.col_int_key)

  Resolves the issue.

To manage notifications about this bug go to:
https://bugs.launchpad.net/randgen/+bug/791783/+subscriptions