These queries succeeded in 4.7.0-1431.
|
Job failed:
|
http://qa.sc.couchbase.com/job/cen006-n1ql-vset02-03-rqg-fields-only-simple-table-primary-secondary-tests/
|
|
Queries showing different results:
|
sql_query :: SELECT primary_key_id , varchar_field1 FROM simple_table WHERE ((bool_field1 AND (varchar_field1 NOT LIKE '%acXEUFebsK') AND (primary_key_id NOT LIKE '%549%'))) AND ((NOT (NOT ((varchar_field1 IS NOT NULL) AND ((char_field1 <= "N") OR (char_field1 IS NULL)))) AND decimal_field1 != 5121)) ORDER BY char_field1
|
n1ql_query :: SELECT primary_key_id , varchar_field1 FROM simple_table_db_7540_simple_table WHERE ((bool_field1 AND (varchar_field1 NOT LIKE '%acXEUFebsK') AND (primary_key_id NOT LIKE '%549%'))) AND ((NOT (NOT ((varchar_field1 IS NOT NULL) AND ((char_field1 <= "N") OR (char_field1 IS NULL)))) AND decimal_field1 != 5121)) ORDER BY char_field1
|
|
|
sql_query :: SELECT * FROM simple_table WHERE ((NOT (decimal_field1 = 5121) AND NOT (varchar_field1 LIKE "acXEUFebsK") AND bool_field1 = true)) AND ((bool_field1 != false AND NOT (int_field1 > 4814))) ORDER BY varchar_field1
|
n1ql_query :: SELECT * FROM simple_table_db_7540_simple_table WHERE ((NOT (decimal_field1 = 5121) AND NOT (varchar_field1 LIKE "acXEUFebsK") AND bool_field1 = true)) AND ((bool_field1 != false AND NOT (int_field1 > 4814))) ORDER BY varchar_field1
|
|
sql_query :: SELECT * FROM simple_table WHERE ((NOT ((char_field1 < "N") AND (char_field1 < "N")) AND decimal_field1 IS NOT NULL)) AND ((bool_field1 AND int_field1 < 4814)) ORDER BY int_field1
|
n1ql_query :: SELECT * FROM simple_table_db_7540_simple_table WHERE ((NOT ((char_field1 < "N") AND (char_field1 < "N")) AND decimal_field1 IS NOT NULL)) AND ((bool_field1 AND int_field1 < 4814)) ORDER BY int_field1
|
|
sql_query :: SELECT int_field1 , decimal_field1 , primary_key_id , bool_field1 FROM simple_table WHERE ((char_field1 != "N" AND int_field1 BETWEEN 2 and 9994)) AND ((decimal_field1 >= 5121 AND char_field1 > "N" AND bool_field1))
|
n1ql_query :: SELECT int_field1 , decimal_field1 , primary_key_id , bool_field1 FROM simple_table_db_7540_simple_table WHERE ((char_field1 != "N" AND int_field1 BETWEEN 2 and 9994)) AND ((decimal_field1 >= 5121 AND char_field1 > "N" AND bool_field1))
|
|
Command to run the test:
|
./testrunner -i local.ini -t rqg.test_rqg.RQGTests.test_rqg_concurrent_new,test_file_path=b/resources/rqg/simple_table_db/query_tests_using_templates/query_50000_fields.txt.zip,database=simple_table_db,reset_database=True,concurreny_count=${concurreny_count},index_quota_percent=30,password=password,use_mysql=True,replicas=0,create_secondary_indexes=True,run_query_with_primary=True,record_failure=False,total_queries=1000,skip_cleanup=True,gsi_type=forestdb
|
|
Replace local.ini with your own ini file.
|
Example local.ini:
|
[global]
|
port:8091
|
username:root
|
password:couchbase
|
index_port:9102
|
|
[servers]
|
1:SERVER_1
|
|
[SERVER_1]
|
ip:172.23.105.209
|
services=n1ql,kv,index
|
|
|
[membase]
|
rest_username:Administrator
|
rest_password:password
|
|
[tuq_client]
|
goroot:/root/n1ql/go
|
sherlock_path=/opt/couchbase/bin
|
|
Above command will also generate the dataset for you.
|
Major