| WARNING: Comparing a bigint and a double may result in a loss of precision. |
| WARNING: Comparing a bigint and a double may result in a loss of precision. |
| PREHOOK: query: -- SORT_QUERY_RESULTS |
| |
| SELECT STDDEV_SAMP(csmallint), |
| (STDDEV_SAMP(csmallint) - 10.175), |
| STDDEV_POP(ctinyint), |
| (STDDEV_SAMP(csmallint) * (STDDEV_SAMP(csmallint) - 10.175)), |
| (-(STDDEV_POP(ctinyint))), |
| (STDDEV_SAMP(csmallint) % 79.553), |
| (-((STDDEV_SAMP(csmallint) * (STDDEV_SAMP(csmallint) - 10.175)))), |
| STDDEV_SAMP(cfloat), |
| (-(STDDEV_SAMP(csmallint))), |
| SUM(cfloat), |
| ((-((STDDEV_SAMP(csmallint) * (STDDEV_SAMP(csmallint) - 10.175)))) / (STDDEV_SAMP(csmallint) - 10.175)), |
| (-((STDDEV_SAMP(csmallint) - 10.175))), |
| AVG(cint), |
| (-3728 - STDDEV_SAMP(csmallint)), |
| STDDEV_POP(cint), |
| (AVG(cint) / STDDEV_SAMP(cfloat)) |
| FROM alltypesorc |
| WHERE (((cint <= cfloat) |
| AND ((79.553 != cbigint) |
| AND (ctimestamp2 = -29071))) |
| OR ((cbigint > cdouble) |
| AND ((79.553 <= csmallint) |
| AND (ctimestamp1 > ctimestamp2)))) |
| PREHOOK: type: QUERY |
| PREHOOK: Input: default@alltypesorc |
| #### A masked pattern was here #### |
| POSTHOOK: query: -- SORT_QUERY_RESULTS |
| |
| SELECT STDDEV_SAMP(csmallint), |
| (STDDEV_SAMP(csmallint) - 10.175), |
| STDDEV_POP(ctinyint), |
| (STDDEV_SAMP(csmallint) * (STDDEV_SAMP(csmallint) - 10.175)), |
| (-(STDDEV_POP(ctinyint))), |
| (STDDEV_SAMP(csmallint) % 79.553), |
| (-((STDDEV_SAMP(csmallint) * (STDDEV_SAMP(csmallint) - 10.175)))), |
| STDDEV_SAMP(cfloat), |
| (-(STDDEV_SAMP(csmallint))), |
| SUM(cfloat), |
| ((-((STDDEV_SAMP(csmallint) * (STDDEV_SAMP(csmallint) - 10.175)))) / (STDDEV_SAMP(csmallint) - 10.175)), |
| (-((STDDEV_SAMP(csmallint) - 10.175))), |
| AVG(cint), |
| (-3728 - STDDEV_SAMP(csmallint)), |
| STDDEV_POP(cint), |
| (AVG(cint) / STDDEV_SAMP(cfloat)) |
| FROM alltypesorc |
| WHERE (((cint <= cfloat) |
| AND ((79.553 != cbigint) |
| AND (ctimestamp2 = -29071))) |
| OR ((cbigint > cdouble) |
| AND ((79.553 <= csmallint) |
| AND (ctimestamp1 > ctimestamp2)))) |
| POSTHOOK: type: QUERY |
| POSTHOOK: Input: default@alltypesorc |
| #### A masked pattern was here #### |
| 0.0 -10.175 34.287285216637066 -0.0 -34.287285216637066 0.0 0.0 34.34690095515641 -0.0 197.89499950408936 -0.0 10.175 NULL -3728.0 NULL NULL |