Description
SELECT AVG( DISTINCT datetime_field1 ) FROM simple_table WHERE ((datetime_field1 = '2007-01-09 00:00:00') AND (text_field1 >= "aVUj")) AND (datetime_field1 IS NOT NULL)
SELECT AVG( datetime_field1 ) FROM simple_table WHERE ((datetime_field1 = '2007-01-09 00:00:00') AND (text_field1 >= "aVUj")) AND (datetime_field1 IS NOT NULL)
SELECT AVG( datetime_field1 ) FROM simple_table
The above queries return null. However, when running against sql, these return date time results.
{ "datetime_field1": "2002-06-06 00:00:00", "int_field1": 5794, "longtext_field1": "eOqH", "primary_key_id": 10007, "varchar_field1": "fFiERqaZmB", "decimal_field1": 4996, "tiny_int_field1": 7, "medium_int_field1": 38, "text_field1": "FuKg", "char_field1": "A", "float_field1": 999, "double_field1": 8879 }The issue seems to be in date time only.
We can get these runs from following run with cluster run
./testrunner -i b/resources/dev-6-nodes-xdcr_n1ql_2i.ini -t rqg.test_rqg.RQGTests.test_rqg_concurrent,test_file_path=./output.txt,database=simple_table_db,skip_cleanup=True,concurreny_count=50,total_queries=500,test_file_path=b/resources/rqg/simple_table_db/query_examples/query_1000.example.txt,skip_cleanup=True
Example
Scenario :: run_query_with_primary
Reason :: the number of results do not match :: expected = 1, actual = 1
mismatch in results :: expected :: [
], actual :: []
sql_query :: SELECT AVG( DISTINCT datetime_field1 ) FROM simple_table WHERE ((datetime_field1 = '2007-01-09 00:00:00') AND (text_field1 >= "aVUj")) AND (datetime_field1 IS NOT NULL)
n1ql_query :: SELECT AVG( DISTINCT datetime_field1 ) FROM simple_table WHERE ((datetime_field1 = '2007-01-09 00:00:00') AND (text_field1 >= "aVUj")) AND (datetime_field1 IS NOT NULL)
<<<<<<<<<< TEST 358 >>>>>>>>>>>