Details
-
Bug
-
Resolution: Fixed
-
Test Blocker
-
4.5.0
-
4.5.0-2441
-
Untriaged
-
Yes
Description
Queries reporting mismatches:
sql_query :: SELECT * FROM simple_table WHERE NOT ( ( ( int_field1 <= ( 5109 / 4 ) ) ) OR ( ( NOT ( ( int_field1 != 5109 ) ) ) AND ( ( ( char_field1 NOT BETWEEN "A" and "Z" ) ) AND ( ( NOT ( NOT ( NOT ( ( datetime_field1 IN ( '1999-01-05 00:00:00' , '1999-01-14 00:00:00' , '1999-01-18 00:00:00' , '1999-01-24 00:00:00' , '1999-02-01 00:00:00' ) ) ) ) ) ) OR ( ( NOT ( ( ( ( int_field1 IS NOT NULL ) OR ( int_field1 IS NULL ) ) AND ( decimal_field1 BETWEEN 12 and 9999 ) ) ) ) AND ( ( int_field1 IS NOT NULL ) ) ) ) ) ) )
n1ql_query :: SELECT * FROM simple_table WHERE NOT ( ( ( int_field1 <= ( 5109 / 4 ) ) ) OR ( ( NOT ( ( int_field1 != 5109 ) ) ) AND ( ( ( char_field1 NOT BETWEEN "A" and "Z" ) ) AND ( ( NOT ( NOT ( NOT ( ( MILLIS( MILLIS_TO_STR( MILLIS( datetime_field1 ) ) ) IN [ MILLIS( MILLIS_TO_STR( MILLIS( '1999-01-05 00:00:00' ) ) ) ,MILLIS( MILLIS_TO_STR( MILLIS( '1999-01-14 00:00:00' ) ) ) ,MILLIS( MILLIS_TO_STR( MILLIS( '1999-01-18 00:00:00' ) ) ) ,MILLIS( MILLIS_TO_STR( MILLIS( '1999-01-24 00:00:00' ) ) ) ,MILLIS( MILLIS_TO_STR( MILLIS( '1999-02-01 00:00:00' ) ) ) ] ) ) ) ) ) OR ( ( NOT ( ( ( ( int_field1 IS NOT NULL ) OR ( int_field1 IS NULL ) ) AND ( decimal_field1 BETWEEN 12 and 9999 ) ) ) ) AND ( ( int_field1 IS NOT NULL ) ) ) ) ) ) )
<<<<<<<<<< TEST 2978 >>>>>>>>>>>
keyword_list :: [' <= ', ' = ', ' > ', 'AND', 'BETWEEN', 'FALSE', 'IN', 'KEY', 'NOT', 'ON', 'OR']
run_result ::
____________________________________________________
Scenario :: run_query_without_index_hint
Reason :: Results are incorrect.Actual num 0. Expected num: 498.:: mismatch in results :: expected :: [
,
{u'primary_key_id': u'944', u'varchar_field1': u'WQZkKaAyje', u'bool_field1': True, u'int_field1': 1059, u'char_field1': u'A'},
{u'primary_key_id': u'221', u'varchar_field1': u'PXysCneJiY', u'bool_field1': True, u'int_field1': 1087, u'char_field1': u'A'},
{u'primary_key_id': u'874', u'varchar_field1': u'EjRFbwAUfq', u'bool_field1': True, u'int_field1': 1422, u'char_field1': u'A'},
{u'primary_key_id': u'292', u'varchar_field1': u'lpSisQAJPk', u'bool_field1': True, u'int_field1': 2330, u'char_field1': u'A'}], actual :: []
sql_query :: SELECT int_field1 , primary_key_id , varchar_field1 , char_field1 , bool_field1 FROM simple_table WHERE ( ( bool_field1 != false ) ) AND ( NOT ( NOT ( ( ( ( ( datetime_field1 > '2007-01-05 00:00:00' + INTERVAL 1 month ) ) AND ( ( ( bool_field1 ) ) AND ( ( ( char_field1 IN ( "A" , "B" , "C" , "D" , "E" ) ) ) OR ( NOT ( ( varchar_field1 = "ZFRpIdxpOc" ) ) ) ) ) ) OR ( ( ( varchar_field1 <= REPLACE( "ZFRpIdxpOc" , "b" , "c" ) ) AND ( varchar_field1 != SUBSTR( "ZFRpIdxpOc", 1 ) ) ) ) ) OR ( ( ( ( int_field1 BETWEEN 2 and 9984 ) ) OR ( ( bool_field1 = false ) ) ) OR ( ( decimal_field1 != 4629 ) ) ) ) ) )
n1ql_query :: SELECT int_field1 , primary_key_id , varchar_field1 , char_field1 , bool_field1 FROM simple_table WHERE ( ( bool_field1 != false ) ) AND ( NOT ( NOT ( ( ( ( ( datetime_field1 > DATE_ADD_STR('2007-01-05 00:00:00',1,'month') ) ) AND ( ( ( bool_field1 ) ) AND ( ( ( char_field1 IN [ "A" , "B" , "C" , "D" , "E" ] ) ) OR ( NOT ( ( varchar_field1 = "ZFRpIdxpOc" ) ) ) ) ) ) OR ( ( ( varchar_field1 <= REPLACE( "ZFRpIdxpOc" , "b" , "c" ) ) AND ( varchar_field1 != SUBSTR( "ZFRpIdxpOc", 0 ) ) ) ) ) OR ( ( ( ( int_field1 BETWEEN 2 and 9984 ) ) OR ( ( bool_field1 = false ) ) ) OR ( ( decimal_field1 != 4629 ) ) ) ) ) )
<<<<<<<<<< TEST 7489 >>>>>>>>>>>
keyword_list :: [' < ', ' <= ', ' = ', ' >= ', 'AND', 'BETWEEN', 'IN', 'IS', 'KEY', 'NOT', 'NULL', 'ON', 'OR', 'TO']
run_result ::
____________________________________________________
Scenario :: run_query_without_index_hint
Reason :: Results are incorrect.Actual num 0. Expected num: 1.:: mismatch in results :: expected :: [
], actual :: []
sql_query :: SELECT int_field1 , decimal_field1 , primary_key_id , varchar_field1 , char_field1 FROM simple_table WHERE ( ( ( ( ( ( datetime_field1 >= '2007-01-05 00:00:00' + INTERVAL 1 second ) AND ( datetime_field1 < '2007-01-05 00:00:00' - INTERVAL 1 month ) ) AND ( datetime_field1 >= '2007-01-05 00:00:00' + INTERVAL 1 month ) ) ) AND ( ( char_field1 = REPLACE( "N" , "c" , "a" ) ) ) ) AND ( NOT ( ( int_field1 = POWER( 5109 , 2 ) ) ) ) ) AND ( NOT ( ( ( int_field1 BETWEEN 2 and 9984 ) ) OR ( ( datetime_field1 >= '2007-01-05 00:00:00' + INTERVAL 1 minute ) ) ) ) OR ( NOT ( NOT ( ( ( ( int_field1 IS NULL ) AND ( ( decimal_field1 >= ( 4629 % 7 ) ) OR ( int_field1 <= TRUNCATE( 1000 * LN( 5109 ), 0 ) ) ) ) OR ( decimal_field1 = 4629 ) ) ) ) ) AND ( ( int_field1 BETWEEN 2 and 9984 ) )
n1ql_query :: SELECT int_field1 , decimal_field1 , primary_key_id , varchar_field1 , char_field1 FROM simple_table WHERE ( ( ( ( ( ( MILLIS( STR_TO_UTC( datetime_field1 ) ) >= MILLIS( STR_TO_UTC( DATE_ADD_STR('2007-01-05 00:00:00',1,'second') ) ) ) AND ( MILLIS( STR_TO_UTC( datetime_field1 ) ) < MILLIS( STR_TO_UTC( DATE_ADD_STR('2007-01-05 00:00:00',-1,'month') ) ) ) ) AND ( MILLIS( STR_TO_UTC( datetime_field1 ) ) >= MILLIS( STR_TO_UTC( DATE_ADD_STR('2007-01-05 00:00:00',1,'month') ) ) ) ) ) AND ( ( char_field1 = REPLACE( "N" , "c" , "a" ) ) ) ) AND ( NOT ( ( int_field1 = POWER( 5109 , 2 ) ) ) ) ) AND ( NOT ( ( ( int_field1 BETWEEN 2 and 9984 ) ) OR ( ( MILLIS( STR_TO_UTC( datetime_field1 ) ) >= MILLIS( STR_TO_UTC( DATE_ADD_STR('2007-01-05 00:00:00',1,'minute') ) ) ) ) ) ) OR ( NOT ( NOT ( ( ( ( int_field1 IS NULL ) AND ( ( decimal_field1 >= ( 4629 % 7 ) ) OR ( int_field1 <= TRUNC( 1000 * LN( 5109 ), 0 ) ) ) ) OR ( decimal_field1 = 4629 ) ) ) ) ) AND ( ( int_field1 BETWEEN 2 and 9984 ) )
<<<<<<<<<< TEST 7407 >>>>>>>>>>>
keyword_list :: [' < ', ' <= ', ' = ', 'AND', 'IN', 'KEY', 'NOT', 'OR']
run_result ::
____________________________________________________
Scenario :: run_query_without_index_hint
Reason :: Results are incorrect.Actual num 0. Expected num: 254.:: mismatch in results :: expected :: [
,
{u'primary_key_id': u'505', u'varchar_field1': u'tVrvWaRmHO', u'int_field1': 14, u'bool_field1': False},
{u'primary_key_id': u'844', u'varchar_field1': u'uISgHjMLll', u'int_field1': 14, u'bool_field1': False},
{u'primary_key_id': u'473', u'varchar_field1': u'HhpWoQUWan', u'int_field1': 16, u'bool_field1': False},
{u'primary_key_id': u'739', u'varchar_field1': u'wpOypQNzAA', u'int_field1': 38, u'bool_field1': False}], actual :: []
sql_query :: SELECT int_field1 , primary_key_id , varchar_field1 , bool_field1 FROM simple_table WHERE NOT ( NOT ( ( ( ( int_field1 = ( 5109 / 4 ) ) OR ( ( ( int_field1 < ( 5109 - ROUND(PI()) ) ) OR ( NOT (int_field1 <= POWER( 5109 , 2 )) ) ) AND ( decimal_field1 <= POWER( 4629 , 2 ) ) ) ) ) AND ( ( NOT ( bool_field1 ) ) ) ) )
n1ql_query :: SELECT int_field1 , primary_key_id , varchar_field1 , bool_field1 FROM simple_table WHERE NOT ( NOT ( ( ( ( int_field1 = ( 5109 / 4 ) ) OR ( ( ( int_field1 < ( 5109 - ROUND(PI()) ) ) OR ( NOT (int_field1 <= POWER( 5109 , 2 )) ) ) AND ( decimal_field1 <= POWER( 4629 , 2 ) ) ) ) ) AND ( ( NOT ( bool_field1 ) ) ) ) )
<<<<<<<<<< TEST 4432 >>>>>>>>>>>
keyword_list :: [' < ', ' <= ', ' = ', ' >= ', 'AND', 'BETWEEN', 'IN', 'IS', 'KEY', 'NOT', 'NULL', 'OR']
run_result ::
____________________________________________________
Scenario :: run_query_without_index_hint
Reason :: Results are incorrect.Actual num 0. Expected num: 496.:: mismatch in results :: expected :: [
,
{u'primary_key_id': u'11', u'decimal_field1': 69, u'int_field1': 6562},
{u'primary_key_id': u'414', u'decimal_field1': 91, u'int_field1': 9324},
{u'primary_key_id': u'195', u'decimal_field1': 104, u'int_field1': 5382},
{u'primary_key_id': u'532', u'decimal_field1': 154, u'int_field1': 5501}], actual :: []
sql_query :: SELECT int_field1 , decimal_field1 , primary_key_id FROM simple_table WHERE ( NOT ( ( ( ( decimal_field1 IS NOT NULL ) OR ( int_field1 != POWER( 5109 , 2 ) ) ) AND ( ( ( int_field1 <= 5109 ) AND ( ( ( int_field1 < POWER( 5109 , 2 ) ) OR ( decimal_field1 = 4629 ) ) OR ( ( int_field1 >= POWER( 5109 , 2 ) ) AND ( decimal_field1 IN ( 12 , 19 , 41 , 44 , 53 ) ) ) ) ) AND ( decimal_field1 BETWEEN 12 and 9999 ) ) ) ) ) AND ( ( decimal_field1 IS NOT NULL ) )
n1ql_query :: SELECT int_field1 , decimal_field1 , primary_key_id FROM simple_table WHERE ( NOT ( ( ( ( decimal_field1 IS NOT NULL ) OR ( int_field1 != POWER( 5109 , 2 ) ) ) AND ( ( ( int_field1 <= 5109 ) AND ( ( ( int_field1 < POWER( 5109 , 2 ) ) OR ( decimal_field1 = 4629 ) ) OR ( ( int_field1 >= POWER( 5109 , 2 ) ) AND ( decimal_field1 IN [ 12 , 19 , 41 , 44 , 53 ] ) ) ) ) AND ( decimal_field1 BETWEEN 12 and 9999 ) ) ) ) ) AND ( ( decimal_field1 IS NOT NULL ) )
<<<<<<<<<< TEST 5530 >>>>>>>>>>>
keyword_list :: [' = ', ' >= ', 'AND', 'IN', 'IS', 'NOT', 'TRUE']
run_result ::
____________________________________________________
Scenario :: run_query_without_index_hint
Reason :: Results are incorrect.Actual num 0. Expected num: 211.:: mismatch in results :: expected :: [
,
{u'datetime_field1': '1999-05-09 00:00:00', u'int_field1': 6106, u'primary_key_id': u'422', u'varchar_field1': u'VyICHqqoPp', u'decimal_field1': 4925, u'char_field1': u'A', u'bool_field1': True},
{u'datetime_field1': '1999-10-01 00:00:00', u'int_field1': 5645, u'primary_key_id': u'175', u'varchar_field1': u'lMBTBRvlvy', u'decimal_field1': 8245, u'char_field1': u'A', u'bool_field1': True},
{u'datetime_field1': '2000-10-13 00:00:00', u'int_field1': 5486, u'primary_key_id': u'433', u'varchar_field1': u'zYGNchrJTr', u'decimal_field1': 3242, u'char_field1': u'A', u'bool_field1': True},
{u'datetime_field1': '2001-08-28 00:00:00', u'int_field1': 2807, u'primary_key_id': u'859', u'varchar_field1': u'HzoOAqmiPV', u'decimal_field1': 1241, u'char_field1': u'A', u'bool_field1': True}], actual :: []
sql_query :: SELECT * FROM simple_table WHERE NOT ( NOT ( ( NOT ( ( ( datetime_field1 >= '2007-01-05 00:00:00' - INTERVAL 1 year ) ) AND ( ( bool_field1 ) ) ) ) AND ( ( ( bool_field1 = true ) ) AND ( ( int_field1 != 5109 ) ) ) ) )
n1ql_query :: SELECT * FROM simple_table WHERE NOT ( NOT ( ( NOT ( ( ( MILLIS( datetime_field1 ) >= MILLIS( DATE_ADD_STR('2007-01-05 00:00:00',-1,'year') ) ) ) AND ( ( bool_field1 ) ) ) ) AND ( ( ( bool_field1 = true ) ) AND ( ( int_field1 != 5109 ) ) ) ) )
<<<<<<<<<< TEST 7535 >>>>>>>>>>>
keyword_list :: [' < ', ' >= ', 'AND', 'BETWEEN', 'FALSE', 'IN', 'IS', 'KEY', 'NOT', 'OR', 'TO']
run_result ::
____________________________________________________
Scenario :: run_query_without_index_hint
Reason :: Results are incorrect.Actual num 0. Expected num: 502.:: mismatch in results :: expected :: [
,
{u'primary_key_id': u'982', u'varchar_field1': u'JGgrXqUmsI', u'int_field1': 216, u'char_field1': u'A'},
{u'primary_key_id': u'742', u'varchar_field1': u'iyzLGXrFIb', u'int_field1': 516, u'char_field1': u'A'},
{u'primary_key_id': u'147', u'varchar_field1': u'nZbEnIzUOw', u'int_field1': 1475, u'char_field1': u'A'},
{u'primary_key_id': u'741', u'varchar_field1': u'kkdFnYZqVK', u'int_field1': 1542, u'char_field1': u'A'}], actual :: []
sql_query :: SELECT int_field1 , primary_key_id , varchar_field1 , char_field1 FROM simple_table WHERE NOT ( NOT ( ( ( ( decimal_field1 < POWER( 4629 , 2 ) ) ) OR ( ( ( ( datetime_field1 NOT BETWEEN '1999-01-05 00:00:00' and '2014-12-28 00:00:00' ) OR ( datetime_field1 >= '2007-01-05 00:00:00' - INTERVAL 1 year ) ) ) OR ( ( bool_field1 != false ) ) ) ) AND ( ( NOT ( bool_field1 ) ) ) ) )
n1ql_query :: SELECT int_field1 , primary_key_id , varchar_field1 , char_field1 FROM simple_table WHERE NOT ( NOT ( ( ( ( decimal_field1 < POWER( 4629 , 2 ) ) ) OR ( ( ( ( MILLIS( STR_TO_UTC( datetime_field1 ) ) NOT BETWEEN MILLIS( STR_TO_UTC( '1999-01-05 00:00:00' ) ) and MILLIS( STR_TO_UTC( '2014-12-28 00:00:00' ) ) ) OR ( MILLIS( STR_TO_UTC( datetime_field1 ) ) >= MILLIS( STR_TO_UTC( DATE_ADD_STR('2007-01-05 00:00:00',-1,'year') ) ) ) ) ) OR ( ( bool_field1 != false ) ) ) ) AND ( ( NOT ( bool_field1 ) ) ) ) )