Uploaded image for project: 'Couchbase Server'
  1. Couchbase Server
  2. MB-24068

[RQG Dynamic Indexing] Joins are failing with dynamic indexing

    XMLWordPrintable

Details

    • Bug
    • Resolution: Duplicate
    • Major
    • 5.0.0
    • 5.0.0
    • query
    • 5.0.0-2652
    • Untriaged
    • No

    Description

      Job which fails:
      cen006-n1ql-vset02-04-rqg-joins-DynamicIndexing-primary-secondary-tests

      Test which fails:
      ./testrunner -i ${resource_tuq} -p gsi_type=${gsi_type} -t rqg.test_rqg.RQGTests.test_rqg_concurrent,test_file_path=b/resources/rqg/multiple_table_db/query_test_using_templates/queries_joins_50000.txt.zip,database=multiple_table_db,reset_database=True,concurreny_count=10,index_quota_percent=30,record_failure=False,password=password,use_mysql=True,replicas=0,total_queries=${total_queries},failure_record_path=/tmp,skip_cleanup=${skip_cleanup},subquery=False,dynamic_indexing=True,create_primary_index=False

      Example queries which fail:
      SELECT t_5.primary_key_id , t_5.varchar_field1 , t_5.char_field1 FROM multiple_table_db_759_simple_table_4 t_2 INNER JOIN multiple_table_db_759_simple_table_3 t_5 ON KEYS [ t_2.primary_key_id ] LEFT JOIN multiple_table_db_759_simple_table_1 t_3 ON KEYS [ t_5.primary_key_id ] LEFT JOIN multiple_table_db_759_simple_table_2 t_1 ON KEYS [ t_2.primary_key_id ] INNER JOIN multiple_table_db_759_simple_table_10 t_4 ON KEYS [ t_5.primary_key_id ] WHERE ((t_3.int_field1 != 4952 AND NOT ((t_1.varchar_field1 > "aXXHYjxnbA") AND (t_3.varchar_field1 NOT LIKE "aFNWltxSmQ")) AND t_1.bool_field1 != true)) AND (t_5.primary_key_id LIKE '%549%') OR (t_4.int_field1 = 5269) AND ((t_1.bool_field1 = true AND t_3.decimal_field1 = 5234))

      SELECT t_3.int_field1 , t_1.primary_key_id , t_3.bool_field1 FROM multiple_table_db_759_simple_table_10 t_4 LEFT JOIN multiple_table_db_759_simple_table_3 t_5 ON KEYS [ t_4.primary_key_id ] INNER JOIN multiple_table_db_759_simple_table_1 t_3 ON KEYS [ t_5.primary_key_id ] INNER JOIN multiple_table_db_759_simple_table_4 t_2 ON KEYS [ t_5.primary_key_id ] INNER JOIN multiple_table_db_759_simple_table_2 t_1 ON KEYS [ t_4.primary_key_id ] LEFT JOIN multiple_table_db_759_simple_table_4 t_2lXDfgOMuaI ON KEYS [ t_1.primary_key_id ] WHERE (((t_4.int_field1 IS NULL) OR (NOT (t_1.int_field1 != 4898)) AND t_1.primary_key_id < "549" AND NOT (t_4.bool_field1))) OR (t_5.decimal_field1 > 4991)

      SELECT t_3.primary_key_id , t_3.varchar_field1 , t_3.char_field1 FROM multiple_table_db_759_simple_table_4 t_2 INNER JOIN multiple_table_db_759_simple_table_10 t_4 ON KEYS [ t_2.primary_key_id ] INNER JOIN multiple_table_db_759_simple_table_1 t_3 ON KEYS [ t_4.primary_key_id ] WHERE ((t_2.int_field1 = 4922 AND t_4.varchar_field1 NOT BETWEEN "AANcgcCryL" and "zsaHmIdUWW" AND t_2.bool_field1)) AND (t_3.char_field1 IN [ "A" , "B" , "C" , "D" , "E" ]) OR ((t_2.char_field1 NOT BETWEEN "A" and "Z" AND t_4.int_field1 IS NULL)) AND ((t_3.varchar_field1 < "aFNWltxSmQ" AND t_2.decimal_field1 <= 4974))

      SELECT t_3.int_field1 , t_3.primary_key_id , t_3.bool_field1 FROM multiple_table_db_759_simple_table_2 t_1 LEFT JOIN multiple_table_db_759_simple_table_1 t_3 ON KEYS [ t_1.primary_key_id ] WHERE NOT (NOT ((t_3.bool_field1 != false OR t_3.int_field1 BETWEEN 1 and 9998)))

      SELECT t_1.int_field1 , t_1.primary_key_id , t_1.varchar_field1 , t_1.bool_field1 FROM multiple_table_db_759_simple_table_10 t_4 INNER JOIN multiple_table_db_759_simple_table_2 t_1 ON KEYS [ t_4.primary_key_id ] WHERE NOT ((t_4.varchar_field1 < "ZoZPyPmsmP") AND (((t_4.char_field1 < "N") AND ((t_4.varchar_field1 >= "ZoZPyPmsmP") AND (t_4.varchar_field1 = "ZoZPyPmsmP"))) AND (t_4.varchar_field1 >= "ZoZPyPmsmP")))

      Attachments

        Issue Links

          No reviews matched the request. Check your Options in the drop-down menu of this sections header.

          Activity

            People

              keshav Keshav Murthy
              Prerna.Manaktala Prerna Manaktala (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Gerrit Reviews

                  There are no open Gerrit changes

                  PagerDuty