List:Commits« Previous MessageNext Message »
From:Ole John Aske Date:November 12 2010 8:14am
Subject:bzr commit into mysql-5.1-telco-7.0-spj-scan-vs-scan branch
(ole.john.aske:3362)
View as plain text  
#At file:///net/fimafeng09/export/home/tmp/oleja/mysql/mysql-5.1-telco-7.0-spj-scan-scan/ based on revid:ole.john.aske@stripped

 3362 Ole John Aske	2010-11-12
      spj-svs: Extended RQG grammer to provide better testcoverage of subqueries:
      
      - Reeneabled in <subquery> which was disabled for some reason ....?
      - Extended in <subquery> to also cover char expressions.
      - Defined 'quantified comparison predicate' (ALL, ANY subquery)

    modified:
      storage/ndb/test/rqg/spj_test.yy
=== modified file 'storage/ndb/test/rqg/spj_test.yy'
--- a/storage/ndb/test/rqg/spj_test.yy	2010-10-11 12:16:22 +0000
+++ b/storage/ndb/test/rqg/spj_test.yy	2010-11-12 08:14:52 +0000
@@ -543,13 +543,29 @@ corresponding_spec:
 #########################################
 
 int_scalar_subquery:
+   int_subquery_1row
+ ;
+
+char_scalar_subquery:
+   char_subquery_1row
+ ;
+
+int_table_subquery:
+   int_subquery_1row
+ ;
+
+char_table_subquery:
+   char_subquery_1row
+ ;
+
+int_subquery_1row:
    subqry_enter
    (SELECT lookahead_for_table_alias
     distinct straight_join select_option int_select_item table_expr)
    subqry_leave
  ;
 
-char_scalar_subquery:
+char_subquery_1row:
    subqry_enter
    (SELECT lookahead_for_table_alias
     distinct straight_join select_option char_select_item table_expr)
@@ -649,15 +665,23 @@ other_predicate:
  | value_expr IS not NULL
  | int_value_expr not BETWEEN int_value_expr AND int_value_expr
  | char_value_expr not LIKE {"'%".$prng->string(3)."%'"}
- | int_value_expr not IN (number_list)
-#| int_value_expr not IN int_scalar_subquery
  | EXISTS table_subquery
+ | int_value_expr not IN (number_list)
+ | int_value_expr not IN int_table_subquery
+ | char_value_expr not IN char_table_subquery
+ | int_value_expr comparison_operator quantifier int_table_subquery
+ | char_value_expr comparison_operator quantifier char_table_subquery
+#| UNIQUE table_subquery              # MySql unsupported
  ;
 
 number_list:
    _digit | number_list, _digit
  ;
 
+quantifier:
+   ALL | ANY
+ ;
+
 ################################################################################
 # We use the total_order_by rule when using the LIMIT operator to ensure that  #
 # we have a consistent result set - server1 and server2 should not differ      #


Attachment: [text/bzr-bundle] bzr/ole.john.aske@oracle.com-20101112081452-5ppx53wnkgglxz9c.bundle
Thread
bzr commit into mysql-5.1-telco-7.0-spj-scan-vs-scan branch(ole.john.aske:3362) Ole John Aske12 Nov