database/mariadb-columnstore-engine
1
0
Fork 0
mirror of https://github.com/mariadb-corporation/mariadb-columnstore-engine.git synced 2025-10-31 18:30:33 +03:00
Code Activity
Files
disable-gcc-toolset-build
mariadb-columnstore-engine/mysql-test/columnstore/devregression/r/mcs7082_regression_bug3475.result
Daniel Lee 4c9d6e39ac Dlee mtr restructure (#2494) 
* Restructured test suites and added autopilot and extended suites

* Updated autopilot with correct branch - develop

* Moved setup test case to a 'setup' directory, for consistency

* Fixed a path issue

* Updated some tests cases to keep up with development

Co-authored-by: root <root@rocky8.localdomain>
2022-08-09 21:20:56 +03:00

2090 lines
113 KiB
Plaintext
Raw Permalink Blame History

USE tpch1;
select COUNT(0) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
COUNT(0)
11
select SUM(0) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
SUM(0)
0
select AVG(0) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
AVG(0)
0.0000
select MIN(0) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
MIN(0)
0
select MAX(0) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
MAX(0)
0
select COUNT(DISTINCT 0) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
COUNT(DISTINCT 0)
1
select SUM(DISTINCT 0) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
SUM(DISTINCT 0)
0
select AVG(DISTINCT 0) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
AVG(DISTINCT 0)
0.0000
select STDDEV_POP(0) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
STDDEV_POP(0)
0.0000
select STDDEV_SAMP(0) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
STDDEV_SAMP(0)
0.0000
select VAR_POP(0) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
VAR_POP(0)
0.0000
select VAR_SAMP(0) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
VAR_SAMP(0)
0.0000
select COUNT(0) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
COUNT(0)
0
select SUM(0) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
SUM(0)
NULL
select AVG(0) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
AVG(0)
NULL
select MIN(0) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
MIN(0)
NULL
select MAX(0) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
MAX(0)
NULL
select COUNT(DISTINCT 0) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
COUNT(DISTINCT 0)
0
select SUM(DISTINCT 0) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
SUM(DISTINCT 0)
NULL
select AVG(DISTINCT 0) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
AVG(DISTINCT 0)
NULL
select STDDEV_POP(0) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
STDDEV_POP(0)
NULL
select STDDEV_SAMP(0) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
STDDEV_SAMP(0)
NULL
select VAR_POP(0) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
VAR_POP(0)
NULL
select VAR_SAMP(0) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
VAR_SAMP(0)
NULL
select COUNT(2) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
COUNT(2)
11
select SUM(2) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
SUM(2)
22
select AVG(2) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
AVG(2)
2.0000
select MIN(2) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
MIN(2)
2
select MAX(2) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
MAX(2)
2
select COUNT(DISTINCT 2) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
COUNT(DISTINCT 2)
1
select SUM(DISTINCT 2) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
SUM(DISTINCT 2)
2
select AVG(DISTINCT 2) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
AVG(DISTINCT 2)
2.0000
select STDDEV_POP(2) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
STDDEV_POP(2)
0.0000
select STDDEV_SAMP(2) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
STDDEV_SAMP(2)
0.0000
select VAR_POP(2) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
VAR_POP(2)
0.0000
select VAR_SAMP(2) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
VAR_SAMP(2)
0.0000
select COUNT(2) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
COUNT(2)
0
select SUM(2) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
SUM(2)
NULL
select AVG(2) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
AVG(2)
NULL
select MIN(2) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
MIN(2)
NULL
select MAX(2) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
MAX(2)
NULL
select COUNT(DISTINCT 2) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
COUNT(DISTINCT 2)
0
select SUM(DISTINCT 2) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
SUM(DISTINCT 2)
NULL
select AVG(DISTINCT 2) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
AVG(DISTINCT 2)
NULL
select STDDEV_POP(2) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
STDDEV_POP(2)
NULL
select STDDEV_SAMP(2) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
STDDEV_SAMP(2)
NULL
select VAR_POP(2) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
VAR_POP(2)
NULL
select VAR_SAMP(2) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
VAR_SAMP(2)
NULL
select COUNT(8.9) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
COUNT(8.9)
11
select SUM(8.9) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
SUM(8.9)
97.9
select AVG(8.9) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
AVG(8.9)
8.90000
select MIN(8.9) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
MIN(8.9)
8.9
select MAX(8.9) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
MAX(8.9)
8.9
select COUNT(DISTINCT 8.9) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
COUNT(DISTINCT 8.9)
1
select SUM(DISTINCT 8.9) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
SUM(DISTINCT 8.9)
8.9
select AVG(DISTINCT 8.9) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
AVG(DISTINCT 8.9)
8.90000
select STDDEV_POP(8.9) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
STDDEV_POP(8.9)
0.00000
select STDDEV_SAMP(8.9) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
STDDEV_SAMP(8.9)
0.00000
select VAR_POP(8.9) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
VAR_POP(8.9)
0.00000
select VAR_SAMP(8.9) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
VAR_SAMP(8.9)
0.00000
select COUNT(8.9) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
COUNT(8.9)
0
select SUM(8.9) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
SUM(8.9)
NULL
select AVG(8.9) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
AVG(8.9)
NULL
select MIN(8.9) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
MIN(8.9)
NULL
select MAX(8.9) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
MAX(8.9)
NULL
select COUNT(DISTINCT 8.9) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
COUNT(DISTINCT 8.9)
0
select SUM(DISTINCT 8.9) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
SUM(DISTINCT 8.9)
NULL
select AVG(DISTINCT 8.9) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
AVG(DISTINCT 8.9)
NULL
select STDDEV_POP(8.9) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
STDDEV_POP(8.9)
NULL
select STDDEV_SAMP(8.9) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
STDDEV_SAMP(8.9)
NULL
select VAR_POP(8.9) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
VAR_POP(8.9)
NULL
select VAR_SAMP(8.9) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
VAR_SAMP(8.9)
NULL
select COUNT('8.9') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
COUNT('8.9')
11
select SUM('8.9') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
SUM('8.9')
97.9
select AVG('8.9') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
AVG('8.9')
8.9
select MIN('8.9') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
MIN('8.9')
8.9
select MAX('8.9') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
MAX('8.9')
8.9
select COUNT(DISTINCT '8.9') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
COUNT(DISTINCT '8.9')
1
select SUM(DISTINCT '8.9') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
SUM(DISTINCT '8.9')
8.9
select AVG(DISTINCT '8.9') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
AVG(DISTINCT '8.9')
8.9
select STDDEV_POP('8.9') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
STDDEV_POP('8.9')
0
select STDDEV_SAMP('8.9') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
STDDEV_SAMP('8.9')
0
select VAR_POP('8.9') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
VAR_POP('8.9')
0
select VAR_SAMP('8.9') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
VAR_SAMP('8.9')
0
select COUNT('8.9') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
COUNT('8.9')
0
select SUM('8.9') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
SUM('8.9')
NULL
select AVG('8.9') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
AVG('8.9')
NULL
select MIN('8.9') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
MIN('8.9')
NULL
select MAX('8.9') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
MAX('8.9')
NULL
select COUNT(DISTINCT '8.9') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
COUNT(DISTINCT '8.9')
0
select SUM(DISTINCT '8.9') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
SUM(DISTINCT '8.9')
NULL
select AVG(DISTINCT '8.9') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
AVG(DISTINCT '8.9')
NULL
select STDDEV_POP('8.9') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
STDDEV_POP('8.9')
NULL
select STDDEV_SAMP('8.9') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
STDDEV_SAMP('8.9')
NULL
select VAR_POP('8.9') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
VAR_POP('8.9')
NULL
select VAR_SAMP('8.9') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
VAR_SAMP('8.9')
NULL
select COUNT('a') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
COUNT('a')
11
select SUM('a') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
SUM('a')
0
select AVG('a') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
AVG('a')
0
select MIN('a') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
MIN('a')
a
select MAX('a') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
MAX('a')
a
select COUNT(DISTINCT 'a') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
COUNT(DISTINCT 'a')
1
select SUM(DISTINCT 'a') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
SUM(DISTINCT 'a')
0
select AVG(DISTINCT 'a') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
AVG(DISTINCT 'a')
0
select STDDEV_POP('a') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
STDDEV_POP('a')
0
select STDDEV_SAMP('a') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
STDDEV_SAMP('a')
0
select VAR_POP('a') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
VAR_POP('a')
0
select VAR_SAMP('a') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
VAR_SAMP('a')
0
select COUNT('a') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
COUNT('a')
0
select SUM('a') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
SUM('a')
NULL
select AVG('a') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
AVG('a')
NULL
select MIN('a') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
MIN('a')
NULL
select MAX('a') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
MAX('a')
NULL
select COUNT(DISTINCT 'a') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
COUNT(DISTINCT 'a')
0
select SUM(DISTINCT 'a') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
SUM(DISTINCT 'a')
NULL
select AVG(DISTINCT 'a') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
AVG(DISTINCT 'a')
NULL
select STDDEV_POP('a') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
STDDEV_POP('a')
NULL
select STDDEV_SAMP('a') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
STDDEV_SAMP('a')
NULL
select VAR_POP('a') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
VAR_POP('a')
NULL
select VAR_SAMP('a') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
VAR_SAMP('a')
NULL
select COUNT('2011-04-08') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
COUNT('2011-04-08')
11
select SUM('2011-04-08') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
SUM('2011-04-08')
22121
select AVG('2011-04-08') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
AVG('2011-04-08')
2011
select MIN('2011-04-08') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
MIN('2011-04-08')
2011-04-08
select MAX('2011-04-08') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
MAX('2011-04-08')
2011-04-08
select COUNT(DISTINCT '2011-04-08') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
COUNT(DISTINCT '2011-04-08')
1
select SUM(DISTINCT '2011-04-08') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
SUM(DISTINCT '2011-04-08')
2011
select AVG(DISTINCT '2011-04-08') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
AVG(DISTINCT '2011-04-08')
2011
select STDDEV_POP('2011-04-08') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
STDDEV_POP('2011-04-08')
0
select STDDEV_SAMP('2011-04-08') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
STDDEV_SAMP('2011-04-08')
0
select VAR_POP('2011-04-08') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
VAR_POP('2011-04-08')
0
select VAR_SAMP('2011-04-08') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
VAR_SAMP('2011-04-08')
0
select COUNT('2011-04-08') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
COUNT('2011-04-08')
0
select SUM('2011-04-08') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
SUM('2011-04-08')
NULL
select AVG('2011-04-08') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
AVG('2011-04-08')
NULL
select MIN('2011-04-08') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
MIN('2011-04-08')
NULL
select MAX('2011-04-08') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
MAX('2011-04-08')
NULL
select COUNT(DISTINCT '2011-04-08') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
COUNT(DISTINCT '2011-04-08')
0
select SUM(DISTINCT '2011-04-08') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
SUM(DISTINCT '2011-04-08')
NULL
select AVG(DISTINCT '2011-04-08') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
AVG(DISTINCT '2011-04-08')
NULL
select STDDEV_POP('2011-04-08') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
STDDEV_POP('2011-04-08')
NULL
select STDDEV_SAMP('2011-04-08') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
STDDEV_SAMP('2011-04-08')
NULL
select VAR_POP('2011-04-08') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
VAR_POP('2011-04-08')
NULL
select VAR_SAMP('2011-04-08') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
VAR_SAMP('2011-04-08')
NULL
select COUNT('2011-04-08 12:34:56') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
COUNT('2011-04-08 12:34:56')
11
select SUM('2011-04-08 12:34:56') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
SUM('2011-04-08 12:34:56')
22121
select AVG('2011-04-08 12:34:56') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
AVG('2011-04-08 12:34:56')
2011
select MIN('2011-04-08 12:34:56') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
MIN('2011-04-08 12:34:56')
2011-04-08 12:34:56
select MAX('2011-04-08 12:34:56') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
MAX('2011-04-08 12:34:56')
2011-04-08 12:34:56
select COUNT(DISTINCT '2011-04-08 12:34:56') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
COUNT(DISTINCT '2011-04-08 12:34:56')
1
select SUM(DISTINCT '2011-04-08 12:34:56') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
SUM(DISTINCT '2011-04-08 12:34:56')
2011
select AVG(DISTINCT '2011-04-08 12:34:56') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
AVG(DISTINCT '2011-04-08 12:34:56')
2011
select STDDEV_POP('2011-04-08 12:34:56') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
STDDEV_POP('2011-04-08 12:34:56')
0
select STDDEV_SAMP('2011-04-08 12:34:56') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
STDDEV_SAMP('2011-04-08 12:34:56')
0
select VAR_POP('2011-04-08 12:34:56') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
VAR_POP('2011-04-08 12:34:56')
0
select VAR_SAMP('2011-04-08 12:34:56') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
VAR_SAMP('2011-04-08 12:34:56')
0
select COUNT('2011-04-08 12:34:56') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
COUNT('2011-04-08 12:34:56')
0
select SUM('2011-04-08 12:34:56') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
SUM('2011-04-08 12:34:56')
NULL
select AVG('2011-04-08 12:34:56') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
AVG('2011-04-08 12:34:56')
NULL
select MIN('2011-04-08 12:34:56') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
MIN('2011-04-08 12:34:56')
NULL
select MAX('2011-04-08 12:34:56') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
MAX('2011-04-08 12:34:56')
NULL
select COUNT(DISTINCT '2011-04-08 12:34:56') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
COUNT(DISTINCT '2011-04-08 12:34:56')
0
select SUM(DISTINCT '2011-04-08 12:34:56') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
SUM(DISTINCT '2011-04-08 12:34:56')
NULL
select AVG(DISTINCT '2011-04-08 12:34:56') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
AVG(DISTINCT '2011-04-08 12:34:56')
NULL
select STDDEV_POP('2011-04-08 12:34:56') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
STDDEV_POP('2011-04-08 12:34:56')
NULL
select STDDEV_SAMP('2011-04-08 12:34:56') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
STDDEV_SAMP('2011-04-08 12:34:56')
NULL
select VAR_POP('2011-04-08 12:34:56') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
VAR_POP('2011-04-08 12:34:56')
NULL
select VAR_SAMP('2011-04-08 12:34:56') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
VAR_SAMP('2011-04-08 12:34:56')
NULL
select COUNT(null) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
COUNT(null)
0
select SUM(null) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
SUM(null)
NULL
select AVG(null) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
AVG(null)
NULL
select MIN(null) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
MIN(null)
NULL
select MAX(null) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
MAX(null)
NULL
select COUNT(DISTINCT null) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
COUNT(DISTINCT null)
0
select SUM(DISTINCT null) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
SUM(DISTINCT null)
NULL
select AVG(DISTINCT null) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
AVG(DISTINCT null)
NULL
select STDDEV_POP(null) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
STDDEV_POP(null)
NULL
select STDDEV_SAMP(null) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
STDDEV_SAMP(null)
NULL
select VAR_POP(null) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
VAR_POP(null)
NULL
select VAR_SAMP(null) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
VAR_SAMP(null)
NULL
select COUNT(null) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
COUNT(null)
0
select SUM(null) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
SUM(null)
NULL
select AVG(null) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
AVG(null)
NULL
select MIN(null) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
MIN(null)
NULL
select MAX(null) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
MAX(null)
NULL
select COUNT(DISTINCT null) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
COUNT(DISTINCT null)
0
select SUM(DISTINCT null) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
SUM(DISTINCT null)
NULL
select AVG(DISTINCT null) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
AVG(DISTINCT null)
NULL
select STDDEV_POP(null) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
STDDEV_POP(null)
NULL
select STDDEV_SAMP(null) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
STDDEV_SAMP(null)
NULL
select VAR_POP(null) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
VAR_POP(null)
NULL
select VAR_SAMP(null) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
VAR_SAMP(null)
NULL
select max(t1.cinteger), COUNT(2) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
max(t1.cinteger) COUNT(2)
7483647 11
select max(t1.cinteger), SUM(2) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
max(t1.cinteger) SUM(2)
7483647 22
select max(t1.cinteger), AVG(2) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
max(t1.cinteger) AVG(2)
7483647 2.0000
select max(t1.cinteger), MIN(2) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
max(t1.cinteger) MIN(2)
7483647 2
select max(t1.cinteger), MAX(2) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
max(t1.cinteger) MAX(2)
7483647 2
select max(t1.cinteger), COUNT(DISTINCT 2) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
max(t1.cinteger) COUNT(DISTINCT 2)
7483647 1
select max(t1.cinteger), SUM(DISTINCT 2) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
max(t1.cinteger) SUM(DISTINCT 2)
7483647 2
select max(t1.cinteger), AVG(DISTINCT 2) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
max(t1.cinteger) AVG(DISTINCT 2)
7483647 2.0000
select max(t1.cinteger), STDDEV_POP(2) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
max(t1.cinteger) STDDEV_POP(2)
7483647 0.0000
select max(t1.cinteger), STDDEV_SAMP(2) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
max(t1.cinteger) STDDEV_SAMP(2)
7483647 0.0000
select max(t1.cinteger), VAR_POP(2) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
max(t1.cinteger) VAR_POP(2)
7483647 0.0000
select max(t1.cinteger), VAR_SAMP(2) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
max(t1.cinteger) VAR_SAMP(2)
7483647 0.0000
select max(t1.cinteger), COUNT(2) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
max(t1.cinteger) COUNT(2)
NULL 0
select max(t1.cinteger), SUM(2) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
max(t1.cinteger) SUM(2)
NULL NULL
select max(t1.cinteger), AVG(2) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
max(t1.cinteger) AVG(2)
NULL NULL
select max(t1.cinteger), MIN(2) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
max(t1.cinteger) MIN(2)
NULL NULL
select max(t1.cinteger), MAX(2) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
max(t1.cinteger) MAX(2)
NULL NULL
select max(t1.cinteger), COUNT(DISTINCT 2) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
max(t1.cinteger) COUNT(DISTINCT 2)
NULL 0
select max(t1.cinteger), SUM(DISTINCT 2) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
max(t1.cinteger) SUM(DISTINCT 2)
NULL NULL
select max(t1.cinteger), AVG(DISTINCT 2) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
max(t1.cinteger) AVG(DISTINCT 2)
NULL NULL
select max(t1.cinteger), STDDEV_POP(2) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
max(t1.cinteger) STDDEV_POP(2)
NULL NULL
select max(t1.cinteger), STDDEV_SAMP(2) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
max(t1.cinteger) STDDEV_SAMP(2)
NULL NULL
select max(t1.cinteger), VAR_POP(2) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
max(t1.cinteger) VAR_POP(2)
NULL NULL
select max(t1.cinteger), VAR_SAMP(2) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
max(t1.cinteger) VAR_SAMP(2)
NULL NULL
select max(t1.cinteger), COUNT(8.9) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
max(t1.cinteger) COUNT(8.9)
7483647 11
select max(t1.cinteger), SUM(8.9) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
max(t1.cinteger) SUM(8.9)
7483647 97.9
select max(t1.cinteger), AVG(8.9) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
max(t1.cinteger) AVG(8.9)
7483647 8.90000
select max(t1.cinteger), MIN(8.9) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
max(t1.cinteger) MIN(8.9)
7483647 8.9
select max(t1.cinteger), MAX(8.9) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
max(t1.cinteger) MAX(8.9)
7483647 8.9
select max(t1.cinteger), COUNT(DISTINCT 8.9) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
max(t1.cinteger) COUNT(DISTINCT 8.9)
7483647 1
select max(t1.cinteger), SUM(DISTINCT 8.9) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
max(t1.cinteger) SUM(DISTINCT 8.9)
7483647 8.9
select max(t1.cinteger), AVG(DISTINCT 8.9) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
max(t1.cinteger) AVG(DISTINCT 8.9)
7483647 8.90000
select max(t1.cinteger), STDDEV_POP(8.9) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
max(t1.cinteger) STDDEV_POP(8.9)
7483647 0.00000
select max(t1.cinteger), STDDEV_SAMP(8.9) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
max(t1.cinteger) STDDEV_SAMP(8.9)
7483647 0.00000
select max(t1.cinteger), VAR_POP(8.9) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
max(t1.cinteger) VAR_POP(8.9)
7483647 0.00000
select max(t1.cinteger), VAR_SAMP(8.9) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
max(t1.cinteger) VAR_SAMP(8.9)
7483647 0.00000
select max(t1.cinteger), COUNT(8.9) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
max(t1.cinteger) COUNT(8.9)
NULL 0
select max(t1.cinteger), SUM(8.9) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
max(t1.cinteger) SUM(8.9)
NULL NULL
select max(t1.cinteger), AVG(8.9) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
max(t1.cinteger) AVG(8.9)
NULL NULL
select max(t1.cinteger), MIN(8.9) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
max(t1.cinteger) MIN(8.9)
NULL NULL
select max(t1.cinteger), MAX(8.9) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
max(t1.cinteger) MAX(8.9)
NULL NULL
select max(t1.cinteger), COUNT(DISTINCT 8.9) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
max(t1.cinteger) COUNT(DISTINCT 8.9)
NULL 0
select max(t1.cinteger), SUM(DISTINCT 8.9) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
max(t1.cinteger) SUM(DISTINCT 8.9)
NULL NULL
select max(t1.cinteger), AVG(DISTINCT 8.9) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
max(t1.cinteger) AVG(DISTINCT 8.9)
NULL NULL
select max(t1.cinteger), STDDEV_POP(8.9) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
max(t1.cinteger) STDDEV_POP(8.9)
NULL NULL
select max(t1.cinteger), STDDEV_SAMP(8.9) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
max(t1.cinteger) STDDEV_SAMP(8.9)
NULL NULL
select max(t1.cinteger), VAR_POP(8.9) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
max(t1.cinteger) VAR_POP(8.9)
NULL NULL
select max(t1.cinteger), VAR_SAMP(8.9) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
max(t1.cinteger) VAR_SAMP(8.9)
NULL NULL
select max(t1.cinteger), COUNT('8.9') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
max(t1.cinteger) COUNT('8.9')
7483647 11
select max(t1.cinteger), SUM('8.9') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
max(t1.cinteger) SUM('8.9')
7483647 97.9
select max(t1.cinteger), AVG('8.9') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
max(t1.cinteger) AVG('8.9')
7483647 8.9
select max(t1.cinteger), MIN('8.9') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
max(t1.cinteger) MIN('8.9')
7483647 8.9
select max(t1.cinteger), MAX('8.9') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
max(t1.cinteger) MAX('8.9')
7483647 8.9
select max(t1.cinteger), COUNT(DISTINCT '8.9') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
max(t1.cinteger) COUNT(DISTINCT '8.9')
7483647 1
select max(t1.cinteger), SUM(DISTINCT '8.9') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
max(t1.cinteger) SUM(DISTINCT '8.9')
7483647 8.9
select max(t1.cinteger), AVG(DISTINCT '8.9') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
max(t1.cinteger) AVG(DISTINCT '8.9')
7483647 8.9
select max(t1.cinteger), STDDEV_POP('8.9') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
max(t1.cinteger) STDDEV_POP('8.9')
7483647 0
select max(t1.cinteger), STDDEV_SAMP('8.9') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
max(t1.cinteger) STDDEV_SAMP('8.9')
7483647 0
select max(t1.cinteger), VAR_POP('8.9') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
max(t1.cinteger) VAR_POP('8.9')
7483647 0
select max(t1.cinteger), VAR_SAMP('8.9') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
max(t1.cinteger) VAR_SAMP('8.9')
7483647 0
select max(t1.cinteger), COUNT('8.9') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
max(t1.cinteger) COUNT('8.9')
NULL 0
select max(t1.cinteger), SUM('8.9') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
max(t1.cinteger) SUM('8.9')
NULL NULL
select max(t1.cinteger), AVG('8.9') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
max(t1.cinteger) AVG('8.9')
NULL NULL
select max(t1.cinteger), MIN('8.9') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
max(t1.cinteger) MIN('8.9')
NULL NULL
select max(t1.cinteger), MAX('8.9') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
max(t1.cinteger) MAX('8.9')
NULL NULL
select max(t1.cinteger), COUNT(DISTINCT '8.9') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
max(t1.cinteger) COUNT(DISTINCT '8.9')
NULL 0
select max(t1.cinteger), SUM(DISTINCT '8.9') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
max(t1.cinteger) SUM(DISTINCT '8.9')
NULL NULL
select max(t1.cinteger), AVG(DISTINCT '8.9') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
max(t1.cinteger) AVG(DISTINCT '8.9')
NULL NULL
select max(t1.cinteger), STDDEV_POP('8.9') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
max(t1.cinteger) STDDEV_POP('8.9')
NULL NULL
select max(t1.cinteger), STDDEV_SAMP('8.9') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
max(t1.cinteger) STDDEV_SAMP('8.9')
NULL NULL
select max(t1.cinteger), VAR_POP('8.9') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
max(t1.cinteger) VAR_POP('8.9')
NULL NULL
select max(t1.cinteger), VAR_SAMP('8.9') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
max(t1.cinteger) VAR_SAMP('8.9')
NULL NULL
select max(t1.cinteger), COUNT('a') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
max(t1.cinteger) COUNT('a')
7483647 11
select max(t1.cinteger), SUM('a') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
max(t1.cinteger) SUM('a')
7483647 0
select max(t1.cinteger), AVG('a') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
max(t1.cinteger) AVG('a')
7483647 0
select max(t1.cinteger), MIN('a') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
max(t1.cinteger) MIN('a')
7483647 a
select max(t1.cinteger), MAX('a') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
max(t1.cinteger) MAX('a')
7483647 a
select max(t1.cinteger), COUNT(DISTINCT 'a') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
max(t1.cinteger) COUNT(DISTINCT 'a')
7483647 1
select max(t1.cinteger), SUM(DISTINCT 'a') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
max(t1.cinteger) SUM(DISTINCT 'a')
7483647 0
select max(t1.cinteger), AVG(DISTINCT 'a') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
max(t1.cinteger) AVG(DISTINCT 'a')
7483647 0
select max(t1.cinteger), STDDEV_POP('a') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
max(t1.cinteger) STDDEV_POP('a')
7483647 0
select max(t1.cinteger), STDDEV_SAMP('a') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
max(t1.cinteger) STDDEV_SAMP('a')
7483647 0
select max(t1.cinteger), VAR_POP('a') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
max(t1.cinteger) VAR_POP('a')
7483647 0
select max(t1.cinteger), VAR_SAMP('a') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
max(t1.cinteger) VAR_SAMP('a')
7483647 0
select max(t1.cinteger), COUNT('a') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
max(t1.cinteger) COUNT('a')
NULL 0
select max(t1.cinteger), SUM('a') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
max(t1.cinteger) SUM('a')
NULL NULL
select max(t1.cinteger), AVG('a') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
max(t1.cinteger) AVG('a')
NULL NULL
select max(t1.cinteger), MIN('a') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
max(t1.cinteger) MIN('a')
NULL NULL
select max(t1.cinteger), MAX('a') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
max(t1.cinteger) MAX('a')
NULL NULL
select max(t1.cinteger), COUNT(DISTINCT 'a') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
max(t1.cinteger) COUNT(DISTINCT 'a')
NULL 0
select max(t1.cinteger), SUM(DISTINCT 'a') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
max(t1.cinteger) SUM(DISTINCT 'a')
NULL NULL
select max(t1.cinteger), AVG(DISTINCT 'a') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
max(t1.cinteger) AVG(DISTINCT 'a')
NULL NULL
select max(t1.cinteger), STDDEV_POP('a') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
max(t1.cinteger) STDDEV_POP('a')
NULL NULL
select max(t1.cinteger), STDDEV_SAMP('a') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
max(t1.cinteger) STDDEV_SAMP('a')
NULL NULL
select max(t1.cinteger), VAR_POP('a') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
max(t1.cinteger) VAR_POP('a')
NULL NULL
select max(t1.cinteger), VAR_SAMP('a') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
max(t1.cinteger) VAR_SAMP('a')
NULL NULL
select max(t1.cinteger), COUNT('2011-04-08') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
max(t1.cinteger) COUNT('2011-04-08')
7483647 11
select max(t1.cinteger), SUM('2011-04-08') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
max(t1.cinteger) SUM('2011-04-08')
7483647 22121
select max(t1.cinteger), AVG('2011-04-08') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
max(t1.cinteger) AVG('2011-04-08')
7483647 2011
select max(t1.cinteger), MIN('2011-04-08') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
max(t1.cinteger) MIN('2011-04-08')
7483647 2011-04-08
select max(t1.cinteger), MAX('2011-04-08') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
max(t1.cinteger) MAX('2011-04-08')
7483647 2011-04-08
select max(t1.cinteger), COUNT(DISTINCT '2011-04-08') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
max(t1.cinteger) COUNT(DISTINCT '2011-04-08')
7483647 1
select max(t1.cinteger), SUM(DISTINCT '2011-04-08') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
max(t1.cinteger) SUM(DISTINCT '2011-04-08')
7483647 2011
select max(t1.cinteger), AVG(DISTINCT '2011-04-08') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
max(t1.cinteger) AVG(DISTINCT '2011-04-08')
7483647 2011
select max(t1.cinteger), STDDEV_POP('2011-04-08') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
max(t1.cinteger) STDDEV_POP('2011-04-08')
7483647 0
select max(t1.cinteger), STDDEV_SAMP('2011-04-08') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
max(t1.cinteger) STDDEV_SAMP('2011-04-08')
7483647 0
select max(t1.cinteger), VAR_POP('2011-04-08') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
max(t1.cinteger) VAR_POP('2011-04-08')
7483647 0
select max(t1.cinteger), VAR_SAMP('2011-04-08') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
max(t1.cinteger) VAR_SAMP('2011-04-08')
7483647 0
select max(t1.cinteger), COUNT('2011-04-08') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
max(t1.cinteger) COUNT('2011-04-08')
NULL 0
select max(t1.cinteger), SUM('2011-04-08') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
max(t1.cinteger) SUM('2011-04-08')
NULL NULL
select max(t1.cinteger), AVG('2011-04-08') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
max(t1.cinteger) AVG('2011-04-08')
NULL NULL
select max(t1.cinteger), MIN('2011-04-08') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
max(t1.cinteger) MIN('2011-04-08')
NULL NULL
select max(t1.cinteger), MAX('2011-04-08') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
max(t1.cinteger) MAX('2011-04-08')
NULL NULL
select max(t1.cinteger), COUNT(DISTINCT '2011-04-08') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
max(t1.cinteger) COUNT(DISTINCT '2011-04-08')
NULL 0
select max(t1.cinteger), SUM(DISTINCT '2011-04-08') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
max(t1.cinteger) SUM(DISTINCT '2011-04-08')
NULL NULL
select max(t1.cinteger), AVG(DISTINCT '2011-04-08') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
max(t1.cinteger) AVG(DISTINCT '2011-04-08')
NULL NULL
select max(t1.cinteger), STDDEV_POP('2011-04-08') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
max(t1.cinteger) STDDEV_POP('2011-04-08')
NULL NULL
select max(t1.cinteger), STDDEV_SAMP('2011-04-08') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
max(t1.cinteger) STDDEV_SAMP('2011-04-08')
NULL NULL
select max(t1.cinteger), VAR_POP('2011-04-08') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
max(t1.cinteger) VAR_POP('2011-04-08')
NULL NULL
select max(t1.cinteger), VAR_SAMP('2011-04-08') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
max(t1.cinteger) VAR_SAMP('2011-04-08')
NULL NULL
select max(t1.cinteger), COUNT('2011-04-08 12:34:56') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
max(t1.cinteger) COUNT('2011-04-08 12:34:56')
7483647 11
select max(t1.cinteger), SUM('2011-04-08 12:34:56') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
max(t1.cinteger) SUM('2011-04-08 12:34:56')
7483647 22121
select max(t1.cinteger), AVG('2011-04-08 12:34:56') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
max(t1.cinteger) AVG('2011-04-08 12:34:56')
7483647 2011
select max(t1.cinteger), MIN('2011-04-08 12:34:56') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
max(t1.cinteger) MIN('2011-04-08 12:34:56')
7483647 2011-04-08 12:34:56
select max(t1.cinteger), MAX('2011-04-08 12:34:56') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
max(t1.cinteger) MAX('2011-04-08 12:34:56')
7483647 2011-04-08 12:34:56
select max(t1.cinteger), COUNT(DISTINCT '2011-04-08 12:34:56') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
max(t1.cinteger) COUNT(DISTINCT '2011-04-08 12:34:56')
7483647 1
select max(t1.cinteger), SUM(DISTINCT '2011-04-08 12:34:56') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
max(t1.cinteger) SUM(DISTINCT '2011-04-08 12:34:56')
7483647 2011
select max(t1.cinteger), AVG(DISTINCT '2011-04-08 12:34:56') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
max(t1.cinteger) AVG(DISTINCT '2011-04-08 12:34:56')
7483647 2011
select max(t1.cinteger), STDDEV_POP('2011-04-08 12:34:56') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
max(t1.cinteger) STDDEV_POP('2011-04-08 12:34:56')
7483647 0
select max(t1.cinteger), STDDEV_SAMP('2011-04-08 12:34:56') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
max(t1.cinteger) STDDEV_SAMP('2011-04-08 12:34:56')
7483647 0
select max(t1.cinteger), VAR_POP('2011-04-08 12:34:56') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
max(t1.cinteger) VAR_POP('2011-04-08 12:34:56')
7483647 0
select max(t1.cinteger), VAR_SAMP('2011-04-08 12:34:56') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
max(t1.cinteger) VAR_SAMP('2011-04-08 12:34:56')
7483647 0
select max(t1.cinteger), COUNT('2011-04-08 12:34:56') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
max(t1.cinteger) COUNT('2011-04-08 12:34:56')
NULL 0
select max(t1.cinteger), SUM('2011-04-08 12:34:56') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
max(t1.cinteger) SUM('2011-04-08 12:34:56')
NULL NULL
select max(t1.cinteger), AVG('2011-04-08 12:34:56') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
max(t1.cinteger) AVG('2011-04-08 12:34:56')
NULL NULL
select max(t1.cinteger), MIN('2011-04-08 12:34:56') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
max(t1.cinteger) MIN('2011-04-08 12:34:56')
NULL NULL
select max(t1.cinteger), MAX('2011-04-08 12:34:56') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
max(t1.cinteger) MAX('2011-04-08 12:34:56')
NULL NULL
select max(t1.cinteger), COUNT(DISTINCT '2011-04-08 12:34:56') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
max(t1.cinteger) COUNT(DISTINCT '2011-04-08 12:34:56')
NULL 0
select max(t1.cinteger), SUM(DISTINCT '2011-04-08 12:34:56') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
max(t1.cinteger) SUM(DISTINCT '2011-04-08 12:34:56')
NULL NULL
select max(t1.cinteger), AVG(DISTINCT '2011-04-08 12:34:56') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
max(t1.cinteger) AVG(DISTINCT '2011-04-08 12:34:56')
NULL NULL
select max(t1.cinteger), STDDEV_POP('2011-04-08 12:34:56') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
max(t1.cinteger) STDDEV_POP('2011-04-08 12:34:56')
NULL NULL
select max(t1.cinteger), STDDEV_SAMP('2011-04-08 12:34:56') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
max(t1.cinteger) STDDEV_SAMP('2011-04-08 12:34:56')
NULL NULL
select max(t1.cinteger), VAR_POP('2011-04-08 12:34:56') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
max(t1.cinteger) VAR_POP('2011-04-08 12:34:56')
NULL NULL
select max(t1.cinteger), VAR_SAMP('2011-04-08 12:34:56') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
max(t1.cinteger) VAR_SAMP('2011-04-08 12:34:56')
NULL NULL
select max(t1.cinteger), COUNT(null) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
max(t1.cinteger) COUNT(null)
7483647 0
select max(t1.cinteger), SUM(null) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
max(t1.cinteger) SUM(null)
7483647 NULL
select max(t1.cinteger), AVG(null) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
max(t1.cinteger) AVG(null)
7483647 NULL
select max(t1.cinteger), MIN(null) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
max(t1.cinteger) MIN(null)
7483647 NULL
select max(t1.cinteger), MAX(null) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
max(t1.cinteger) MAX(null)
7483647 NULL
select max(t1.cinteger), COUNT(DISTINCT null) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
max(t1.cinteger) COUNT(DISTINCT null)
7483647 0
select max(t1.cinteger), SUM(DISTINCT null) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
max(t1.cinteger) SUM(DISTINCT null)
7483647 NULL
select max(t1.cinteger), AVG(DISTINCT null) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
max(t1.cinteger) AVG(DISTINCT null)
7483647 NULL
select max(t1.cinteger), STDDEV_POP(null) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
max(t1.cinteger) STDDEV_POP(null)
7483647 NULL
select max(t1.cinteger), STDDEV_SAMP(null) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
max(t1.cinteger) STDDEV_SAMP(null)
7483647 NULL
select max(t1.cinteger), VAR_POP(null) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
max(t1.cinteger) VAR_POP(null)
7483647 NULL
select max(t1.cinteger), VAR_SAMP(null) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
max(t1.cinteger) VAR_SAMP(null)
7483647 NULL
select max(t1.cinteger), COUNT(null) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
max(t1.cinteger) COUNT(null)
NULL 0
select max(t1.cinteger), SUM(null) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
max(t1.cinteger) SUM(null)
NULL NULL
select max(t1.cinteger), AVG(null) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
max(t1.cinteger) AVG(null)
NULL NULL
select max(t1.cinteger), MIN(null) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
max(t1.cinteger) MIN(null)
NULL NULL
select max(t1.cinteger), MAX(null) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
max(t1.cinteger) MAX(null)
NULL NULL
select max(t1.cinteger), COUNT(DISTINCT null) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
max(t1.cinteger) COUNT(DISTINCT null)
NULL 0
select max(t1.cinteger), SUM(DISTINCT null) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
max(t1.cinteger) SUM(DISTINCT null)
NULL NULL
select max(t1.cinteger), AVG(DISTINCT null) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
max(t1.cinteger) AVG(DISTINCT null)
NULL NULL
select max(t1.cinteger), STDDEV_POP(null) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
max(t1.cinteger) STDDEV_POP(null)
NULL NULL
select max(t1.cinteger), STDDEV_SAMP(null) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
max(t1.cinteger) STDDEV_SAMP(null)
NULL NULL
select max(t1.cinteger), VAR_POP(null) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
max(t1.cinteger) VAR_POP(null)
NULL NULL
select max(t1.cinteger), VAR_SAMP(null) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
max(t1.cinteger) VAR_SAMP(null)
NULL NULL
select max(distinct t1.cinteger), COUNT(2) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
max(distinct t1.cinteger) COUNT(2)
7483647 11
select max(distinct t1.cinteger), SUM(2) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
max(distinct t1.cinteger) SUM(2)
7483647 22
select max(distinct t1.cinteger), AVG(2) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
max(distinct t1.cinteger) AVG(2)
7483647 2.0000
select max(distinct t1.cinteger), MIN(2) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
max(distinct t1.cinteger) MIN(2)
7483647 2
select max(distinct t1.cinteger), MAX(2) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
max(distinct t1.cinteger) MAX(2)
7483647 2
select max(distinct t1.cinteger), COUNT(DISTINCT 2) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
max(distinct t1.cinteger) COUNT(DISTINCT 2)
7483647 1
select max(distinct t1.cinteger), SUM(DISTINCT 2) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
max(distinct t1.cinteger) SUM(DISTINCT 2)
7483647 2
select max(distinct t1.cinteger), AVG(DISTINCT 2) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
max(distinct t1.cinteger) AVG(DISTINCT 2)
7483647 2.0000
select max(distinct t1.cinteger), STDDEV_POP(2) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
max(distinct t1.cinteger) STDDEV_POP(2)
7483647 0.0000
select max(distinct t1.cinteger), STDDEV_SAMP(2) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
max(distinct t1.cinteger) STDDEV_SAMP(2)
7483647 0.0000
select max(distinct t1.cinteger), VAR_POP(2) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
max(distinct t1.cinteger) VAR_POP(2)
7483647 0.0000
select max(distinct t1.cinteger), VAR_SAMP(2) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
max(distinct t1.cinteger) VAR_SAMP(2)
7483647 0.0000
select max(distinct t1.cinteger), COUNT(2) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
max(distinct t1.cinteger) COUNT(2)
NULL 0
select max(distinct t1.cinteger), SUM(2) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
max(distinct t1.cinteger) SUM(2)
NULL NULL
select max(distinct t1.cinteger), AVG(2) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
max(distinct t1.cinteger) AVG(2)
NULL NULL
select max(distinct t1.cinteger), MIN(2) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
max(distinct t1.cinteger) MIN(2)
NULL NULL
select max(distinct t1.cinteger), MAX(2) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
max(distinct t1.cinteger) MAX(2)
NULL NULL
select max(distinct t1.cinteger), COUNT(DISTINCT 2) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
max(distinct t1.cinteger) COUNT(DISTINCT 2)
NULL 0
select max(distinct t1.cinteger), SUM(DISTINCT 2) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
max(distinct t1.cinteger) SUM(DISTINCT 2)
NULL NULL
select max(distinct t1.cinteger), AVG(DISTINCT 2) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
max(distinct t1.cinteger) AVG(DISTINCT 2)
NULL NULL
select max(distinct t1.cinteger), STDDEV_POP(2) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
max(distinct t1.cinteger) STDDEV_POP(2)
NULL NULL
select max(distinct t1.cinteger), STDDEV_SAMP(2) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
max(distinct t1.cinteger) STDDEV_SAMP(2)
NULL NULL
select max(distinct t1.cinteger), VAR_POP(2) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
max(distinct t1.cinteger) VAR_POP(2)
NULL NULL
select max(distinct t1.cinteger), VAR_SAMP(2) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
max(distinct t1.cinteger) VAR_SAMP(2)
NULL NULL
select max(distinct t1.cinteger), COUNT(8.9) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
max(distinct t1.cinteger) COUNT(8.9)
7483647 11
select max(distinct t1.cinteger), SUM(8.9) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
max(distinct t1.cinteger) SUM(8.9)
7483647 97.9
select max(distinct t1.cinteger), AVG(8.9) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
max(distinct t1.cinteger) AVG(8.9)
7483647 8.90000
select max(distinct t1.cinteger), MIN(8.9) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
max(distinct t1.cinteger) MIN(8.9)
7483647 8.9
select max(distinct t1.cinteger), MAX(8.9) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
max(distinct t1.cinteger) MAX(8.9)
7483647 8.9
select max(distinct t1.cinteger), COUNT(DISTINCT 8.9) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
max(distinct t1.cinteger) COUNT(DISTINCT 8.9)
7483647 1
select max(distinct t1.cinteger), SUM(DISTINCT 8.9) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
max(distinct t1.cinteger) SUM(DISTINCT 8.9)
7483647 8.9
select max(distinct t1.cinteger), AVG(DISTINCT 8.9) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
max(distinct t1.cinteger) AVG(DISTINCT 8.9)
7483647 8.90000
select max(distinct t1.cinteger), STDDEV_POP(8.9) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
max(distinct t1.cinteger) STDDEV_POP(8.9)
7483647 0.00000
select max(distinct t1.cinteger), STDDEV_SAMP(8.9) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
max(distinct t1.cinteger) STDDEV_SAMP(8.9)
7483647 0.00000
select max(distinct t1.cinteger), VAR_POP(8.9) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
max(distinct t1.cinteger) VAR_POP(8.9)
7483647 0.00000
select max(distinct t1.cinteger), VAR_SAMP(8.9) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
max(distinct t1.cinteger) VAR_SAMP(8.9)
7483647 0.00000
select max(distinct t1.cinteger), COUNT(8.9) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
max(distinct t1.cinteger) COUNT(8.9)
NULL 0
select max(distinct t1.cinteger), SUM(8.9) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
max(distinct t1.cinteger) SUM(8.9)
NULL NULL
select max(distinct t1.cinteger), AVG(8.9) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
max(distinct t1.cinteger) AVG(8.9)
NULL NULL
select max(distinct t1.cinteger), MIN(8.9) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
max(distinct t1.cinteger) MIN(8.9)
NULL NULL
select max(distinct t1.cinteger), MAX(8.9) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
max(distinct t1.cinteger) MAX(8.9)
NULL NULL
select max(distinct t1.cinteger), COUNT(DISTINCT 8.9) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
max(distinct t1.cinteger) COUNT(DISTINCT 8.9)
NULL 0
select max(distinct t1.cinteger), SUM(DISTINCT 8.9) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
max(distinct t1.cinteger) SUM(DISTINCT 8.9)
NULL NULL
select max(distinct t1.cinteger), AVG(DISTINCT 8.9) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
max(distinct t1.cinteger) AVG(DISTINCT 8.9)
NULL NULL
select max(distinct t1.cinteger), STDDEV_POP(8.9) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
max(distinct t1.cinteger) STDDEV_POP(8.9)
NULL NULL
select max(distinct t1.cinteger), STDDEV_SAMP(8.9) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
max(distinct t1.cinteger) STDDEV_SAMP(8.9)
NULL NULL
select max(distinct t1.cinteger), VAR_POP(8.9) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
max(distinct t1.cinteger) VAR_POP(8.9)
NULL NULL
select max(distinct t1.cinteger), VAR_SAMP(8.9) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
max(distinct t1.cinteger) VAR_SAMP(8.9)
NULL NULL
select max(distinct t1.cinteger), COUNT('8.9') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
max(distinct t1.cinteger) COUNT('8.9')
7483647 11
select max(distinct t1.cinteger), SUM('8.9') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
max(distinct t1.cinteger) SUM('8.9')
7483647 97.9
select max(distinct t1.cinteger), AVG('8.9') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
max(distinct t1.cinteger) AVG('8.9')
7483647 8.9
select max(distinct t1.cinteger), MIN('8.9') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
max(distinct t1.cinteger) MIN('8.9')
7483647 8.9
select max(distinct t1.cinteger), MAX('8.9') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
max(distinct t1.cinteger) MAX('8.9')
7483647 8.9
select max(distinct t1.cinteger), COUNT(DISTINCT '8.9') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
max(distinct t1.cinteger) COUNT(DISTINCT '8.9')
7483647 1
select max(distinct t1.cinteger), SUM(DISTINCT '8.9') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
max(distinct t1.cinteger) SUM(DISTINCT '8.9')
7483647 8.9
select max(distinct t1.cinteger), AVG(DISTINCT '8.9') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
max(distinct t1.cinteger) AVG(DISTINCT '8.9')
7483647 8.9
select max(distinct t1.cinteger), STDDEV_POP('8.9') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
max(distinct t1.cinteger) STDDEV_POP('8.9')
7483647 0
select max(distinct t1.cinteger), STDDEV_SAMP('8.9') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
max(distinct t1.cinteger) STDDEV_SAMP('8.9')
7483647 0
select max(distinct t1.cinteger), VAR_POP('8.9') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
max(distinct t1.cinteger) VAR_POP('8.9')
7483647 0
select max(distinct t1.cinteger), VAR_SAMP('8.9') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
max(distinct t1.cinteger) VAR_SAMP('8.9')
7483647 0
select max(distinct t1.cinteger), COUNT('8.9') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
max(distinct t1.cinteger) COUNT('8.9')
NULL 0
select max(distinct t1.cinteger), SUM('8.9') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
max(distinct t1.cinteger) SUM('8.9')
NULL NULL
select max(distinct t1.cinteger), AVG('8.9') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
max(distinct t1.cinteger) AVG('8.9')
NULL NULL
select max(distinct t1.cinteger), MIN('8.9') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
max(distinct t1.cinteger) MIN('8.9')
NULL NULL
select max(distinct t1.cinteger), MAX('8.9') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
max(distinct t1.cinteger) MAX('8.9')
NULL NULL
select max(distinct t1.cinteger), COUNT(DISTINCT '8.9') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
max(distinct t1.cinteger) COUNT(DISTINCT '8.9')
NULL 0
select max(distinct t1.cinteger), SUM(DISTINCT '8.9') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
max(distinct t1.cinteger) SUM(DISTINCT '8.9')
NULL NULL
select max(distinct t1.cinteger), AVG(DISTINCT '8.9') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
max(distinct t1.cinteger) AVG(DISTINCT '8.9')
NULL NULL
select max(distinct t1.cinteger), STDDEV_POP('8.9') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
max(distinct t1.cinteger) STDDEV_POP('8.9')
NULL NULL
select max(distinct t1.cinteger), STDDEV_SAMP('8.9') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
max(distinct t1.cinteger) STDDEV_SAMP('8.9')
NULL NULL
select max(distinct t1.cinteger), VAR_POP('8.9') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
max(distinct t1.cinteger) VAR_POP('8.9')
NULL NULL
select max(distinct t1.cinteger), VAR_SAMP('8.9') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
max(distinct t1.cinteger) VAR_SAMP('8.9')
NULL NULL
select max(distinct t1.cinteger), COUNT('a') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
max(distinct t1.cinteger) COUNT('a')
7483647 11
select max(distinct t1.cinteger), SUM('a') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
max(distinct t1.cinteger) SUM('a')
7483647 0
select max(distinct t1.cinteger), AVG('a') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
max(distinct t1.cinteger) AVG('a')
7483647 0
select max(distinct t1.cinteger), MIN('a') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
max(distinct t1.cinteger) MIN('a')
7483647 a
select max(distinct t1.cinteger), MAX('a') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
max(distinct t1.cinteger) MAX('a')
7483647 a
select max(distinct t1.cinteger), COUNT(DISTINCT 'a') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
max(distinct t1.cinteger) COUNT(DISTINCT 'a')
7483647 1
select max(distinct t1.cinteger), SUM(DISTINCT 'a') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
max(distinct t1.cinteger) SUM(DISTINCT 'a')
7483647 0
select max(distinct t1.cinteger), AVG(DISTINCT 'a') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
max(distinct t1.cinteger) AVG(DISTINCT 'a')
7483647 0
select max(distinct t1.cinteger), STDDEV_POP('a') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
max(distinct t1.cinteger) STDDEV_POP('a')
7483647 0
select max(distinct t1.cinteger), STDDEV_SAMP('a') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
max(distinct t1.cinteger) STDDEV_SAMP('a')
7483647 0
select max(distinct t1.cinteger), VAR_POP('a') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
max(distinct t1.cinteger) VAR_POP('a')
7483647 0
select max(distinct t1.cinteger), VAR_SAMP('a') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
max(distinct t1.cinteger) VAR_SAMP('a')
7483647 0
select max(distinct t1.cinteger), COUNT('a') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
max(distinct t1.cinteger) COUNT('a')
NULL 0
select max(distinct t1.cinteger), SUM('a') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
max(distinct t1.cinteger) SUM('a')
NULL NULL
select max(distinct t1.cinteger), AVG('a') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
max(distinct t1.cinteger) AVG('a')
NULL NULL
select max(distinct t1.cinteger), MIN('a') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
max(distinct t1.cinteger) MIN('a')
NULL NULL
select max(distinct t1.cinteger), MAX('a') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
max(distinct t1.cinteger) MAX('a')
NULL NULL
select max(distinct t1.cinteger), COUNT(DISTINCT 'a') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
max(distinct t1.cinteger) COUNT(DISTINCT 'a')
NULL 0
select max(distinct t1.cinteger), SUM(DISTINCT 'a') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
max(distinct t1.cinteger) SUM(DISTINCT 'a')
NULL NULL
select max(distinct t1.cinteger), AVG(DISTINCT 'a') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
max(distinct t1.cinteger) AVG(DISTINCT 'a')
NULL NULL
select max(distinct t1.cinteger), STDDEV_POP('a') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
max(distinct t1.cinteger) STDDEV_POP('a')
NULL NULL
select max(distinct t1.cinteger), STDDEV_SAMP('a') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
max(distinct t1.cinteger) STDDEV_SAMP('a')
NULL NULL
select max(distinct t1.cinteger), VAR_POP('a') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
max(distinct t1.cinteger) VAR_POP('a')
NULL NULL
select max(distinct t1.cinteger), VAR_SAMP('a') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
max(distinct t1.cinteger) VAR_SAMP('a')
NULL NULL
select max(distinct t1.cinteger), COUNT('2011-04-08') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
max(distinct t1.cinteger) COUNT('2011-04-08')
7483647 11
select max(distinct t1.cinteger), SUM('2011-04-08') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
max(distinct t1.cinteger) SUM('2011-04-08')
7483647 22121
select max(distinct t1.cinteger), AVG('2011-04-08') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
max(distinct t1.cinteger) AVG('2011-04-08')
7483647 2011
select max(distinct t1.cinteger), MIN('2011-04-08') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
max(distinct t1.cinteger) MIN('2011-04-08')
7483647 2011-04-08
select max(distinct t1.cinteger), MAX('2011-04-08') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
max(distinct t1.cinteger) MAX('2011-04-08')
7483647 2011-04-08
select max(distinct t1.cinteger), COUNT(DISTINCT '2011-04-08') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
max(distinct t1.cinteger) COUNT(DISTINCT '2011-04-08')
7483647 1
select max(distinct t1.cinteger), SUM(DISTINCT '2011-04-08') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
max(distinct t1.cinteger) SUM(DISTINCT '2011-04-08')
7483647 2011
select max(distinct t1.cinteger), AVG(DISTINCT '2011-04-08') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
max(distinct t1.cinteger) AVG(DISTINCT '2011-04-08')
7483647 2011
select max(distinct t1.cinteger), STDDEV_POP('2011-04-08') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
max(distinct t1.cinteger) STDDEV_POP('2011-04-08')
7483647 0
select max(distinct t1.cinteger), STDDEV_SAMP('2011-04-08') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
max(distinct t1.cinteger) STDDEV_SAMP('2011-04-08')
7483647 0
select max(distinct t1.cinteger), VAR_POP('2011-04-08') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
max(distinct t1.cinteger) VAR_POP('2011-04-08')
7483647 0
select max(distinct t1.cinteger), VAR_SAMP('2011-04-08') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
max(distinct t1.cinteger) VAR_SAMP('2011-04-08')
7483647 0
select max(distinct t1.cinteger), COUNT('2011-04-08') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
max(distinct t1.cinteger) COUNT('2011-04-08')
NULL 0
select max(distinct t1.cinteger), SUM('2011-04-08') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
max(distinct t1.cinteger) SUM('2011-04-08')
NULL NULL
select max(distinct t1.cinteger), AVG('2011-04-08') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
max(distinct t1.cinteger) AVG('2011-04-08')
NULL NULL
select max(distinct t1.cinteger), MIN('2011-04-08') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
max(distinct t1.cinteger) MIN('2011-04-08')
NULL NULL
select max(distinct t1.cinteger), MAX('2011-04-08') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
max(distinct t1.cinteger) MAX('2011-04-08')
NULL NULL
select max(distinct t1.cinteger), COUNT(DISTINCT '2011-04-08') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
max(distinct t1.cinteger) COUNT(DISTINCT '2011-04-08')
NULL 0
select max(distinct t1.cinteger), SUM(DISTINCT '2011-04-08') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
max(distinct t1.cinteger) SUM(DISTINCT '2011-04-08')
NULL NULL
select max(distinct t1.cinteger), AVG(DISTINCT '2011-04-08') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
max(distinct t1.cinteger) AVG(DISTINCT '2011-04-08')
NULL NULL
select max(distinct t1.cinteger), STDDEV_POP('2011-04-08') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
max(distinct t1.cinteger) STDDEV_POP('2011-04-08')
NULL NULL
select max(distinct t1.cinteger), STDDEV_SAMP('2011-04-08') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
max(distinct t1.cinteger) STDDEV_SAMP('2011-04-08')
NULL NULL
select max(distinct t1.cinteger), VAR_POP('2011-04-08') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
max(distinct t1.cinteger) VAR_POP('2011-04-08')
NULL NULL
select max(distinct t1.cinteger), VAR_SAMP('2011-04-08') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
max(distinct t1.cinteger) VAR_SAMP('2011-04-08')
NULL NULL
select max(distinct t1.cinteger), COUNT('2011-04-08 12:34:56') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
max(distinct t1.cinteger) COUNT('2011-04-08 12:34:56')
7483647 11
select max(distinct t1.cinteger), SUM('2011-04-08 12:34:56') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
max(distinct t1.cinteger) SUM('2011-04-08 12:34:56')
7483647 22121
select max(distinct t1.cinteger), AVG('2011-04-08 12:34:56') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
max(distinct t1.cinteger) AVG('2011-04-08 12:34:56')
7483647 2011
select max(distinct t1.cinteger), MIN('2011-04-08 12:34:56') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
max(distinct t1.cinteger) MIN('2011-04-08 12:34:56')
7483647 2011-04-08 12:34:56
select max(distinct t1.cinteger), MAX('2011-04-08 12:34:56') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
max(distinct t1.cinteger) MAX('2011-04-08 12:34:56')
7483647 2011-04-08 12:34:56
select max(distinct t1.cinteger), COUNT(DISTINCT '2011-04-08 12:34:56') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
max(distinct t1.cinteger) COUNT(DISTINCT '2011-04-08 12:34:56')
7483647 1
select max(distinct t1.cinteger), SUM(DISTINCT '2011-04-08 12:34:56') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
max(distinct t1.cinteger) SUM(DISTINCT '2011-04-08 12:34:56')
7483647 2011
select max(distinct t1.cinteger), AVG(DISTINCT '2011-04-08 12:34:56') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
max(distinct t1.cinteger) AVG(DISTINCT '2011-04-08 12:34:56')
7483647 2011
select max(distinct t1.cinteger), STDDEV_POP('2011-04-08 12:34:56') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
max(distinct t1.cinteger) STDDEV_POP('2011-04-08 12:34:56')
7483647 0
select max(distinct t1.cinteger), STDDEV_SAMP('2011-04-08 12:34:56') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
max(distinct t1.cinteger) STDDEV_SAMP('2011-04-08 12:34:56')
7483647 0
select max(distinct t1.cinteger), VAR_POP('2011-04-08 12:34:56') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
max(distinct t1.cinteger) VAR_POP('2011-04-08 12:34:56')
7483647 0
select max(distinct t1.cinteger), VAR_SAMP('2011-04-08 12:34:56') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
max(distinct t1.cinteger) VAR_SAMP('2011-04-08 12:34:56')
7483647 0
select max(distinct t1.cinteger), COUNT('2011-04-08 12:34:56') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
max(distinct t1.cinteger) COUNT('2011-04-08 12:34:56')
NULL 0
select max(distinct t1.cinteger), SUM('2011-04-08 12:34:56') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
max(distinct t1.cinteger) SUM('2011-04-08 12:34:56')
NULL NULL
select max(distinct t1.cinteger), AVG('2011-04-08 12:34:56') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
max(distinct t1.cinteger) AVG('2011-04-08 12:34:56')
NULL NULL
select max(distinct t1.cinteger), MIN('2011-04-08 12:34:56') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
max(distinct t1.cinteger) MIN('2011-04-08 12:34:56')
NULL NULL
select max(distinct t1.cinteger), MAX('2011-04-08 12:34:56') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
max(distinct t1.cinteger) MAX('2011-04-08 12:34:56')
NULL NULL
select max(distinct t1.cinteger), COUNT(DISTINCT '2011-04-08 12:34:56') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
max(distinct t1.cinteger) COUNT(DISTINCT '2011-04-08 12:34:56')
NULL 0
select max(distinct t1.cinteger), SUM(DISTINCT '2011-04-08 12:34:56') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
max(distinct t1.cinteger) SUM(DISTINCT '2011-04-08 12:34:56')
NULL NULL
select max(distinct t1.cinteger), AVG(DISTINCT '2011-04-08 12:34:56') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
max(distinct t1.cinteger) AVG(DISTINCT '2011-04-08 12:34:56')
NULL NULL
select max(distinct t1.cinteger), STDDEV_POP('2011-04-08 12:34:56') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
max(distinct t1.cinteger) STDDEV_POP('2011-04-08 12:34:56')
NULL NULL
select max(distinct t1.cinteger), STDDEV_SAMP('2011-04-08 12:34:56') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
max(distinct t1.cinteger) STDDEV_SAMP('2011-04-08 12:34:56')
NULL NULL
select max(distinct t1.cinteger), VAR_POP('2011-04-08 12:34:56') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
max(distinct t1.cinteger) VAR_POP('2011-04-08 12:34:56')
NULL NULL
select max(distinct t1.cinteger), VAR_SAMP('2011-04-08 12:34:56') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
max(distinct t1.cinteger) VAR_SAMP('2011-04-08 12:34:56')
NULL NULL
select max(distinct t1.cinteger), COUNT(null) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
max(distinct t1.cinteger) COUNT(null)
7483647 0
select max(distinct t1.cinteger), SUM(null) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
max(distinct t1.cinteger) SUM(null)
7483647 NULL
select max(distinct t1.cinteger), AVG(null) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
max(distinct t1.cinteger) AVG(null)
7483647 NULL
select max(distinct t1.cinteger), MIN(null) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
max(distinct t1.cinteger) MIN(null)
7483647 NULL
select max(distinct t1.cinteger), MAX(null) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
max(distinct t1.cinteger) MAX(null)
7483647 NULL
select max(distinct t1.cinteger), COUNT(DISTINCT null) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
max(distinct t1.cinteger) COUNT(DISTINCT null)
7483647 0
select max(distinct t1.cinteger), SUM(DISTINCT null) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
max(distinct t1.cinteger) SUM(DISTINCT null)
7483647 NULL
select max(distinct t1.cinteger), AVG(DISTINCT null) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
max(distinct t1.cinteger) AVG(DISTINCT null)
7483647 NULL
select max(distinct t1.cinteger), STDDEV_POP(null) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
max(distinct t1.cinteger) STDDEV_POP(null)
7483647 NULL
select max(distinct t1.cinteger), STDDEV_SAMP(null) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
max(distinct t1.cinteger) STDDEV_SAMP(null)
7483647 NULL
select max(distinct t1.cinteger), VAR_POP(null) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
max(distinct t1.cinteger) VAR_POP(null)
7483647 NULL
select max(distinct t1.cinteger), VAR_SAMP(null) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
max(distinct t1.cinteger) VAR_SAMP(null)
7483647 NULL
select max(distinct t1.cinteger), COUNT(null) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
max(distinct t1.cinteger) COUNT(null)
NULL 0
select max(distinct t1.cinteger), SUM(null) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
max(distinct t1.cinteger) SUM(null)
NULL NULL
select max(distinct t1.cinteger), AVG(null) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
max(distinct t1.cinteger) AVG(null)
NULL NULL
select max(distinct t1.cinteger), MIN(null) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
max(distinct t1.cinteger) MIN(null)
NULL NULL
select max(distinct t1.cinteger), MAX(null) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
max(distinct t1.cinteger) MAX(null)
NULL NULL
select max(distinct t1.cinteger), COUNT(DISTINCT null) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
max(distinct t1.cinteger) COUNT(DISTINCT null)
NULL 0
select max(distinct t1.cinteger), SUM(DISTINCT null) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
max(distinct t1.cinteger) SUM(DISTINCT null)
NULL NULL
select max(distinct t1.cinteger), AVG(DISTINCT null) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
max(distinct t1.cinteger) AVG(DISTINCT null)
NULL NULL
select max(distinct t1.cinteger), STDDEV_POP(null) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
max(distinct t1.cinteger) STDDEV_POP(null)
NULL NULL
select max(distinct t1.cinteger), STDDEV_SAMP(null) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
max(distinct t1.cinteger) STDDEV_SAMP(null)
NULL NULL
select max(distinct t1.cinteger), VAR_POP(null) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
max(distinct t1.cinteger) VAR_POP(null)
NULL NULL
select max(distinct t1.cinteger), VAR_SAMP(null) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
max(distinct t1.cinteger) VAR_SAMP(null)
NULL NULL
select count(distinct t1.cinteger), COUNT(2) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
count(distinct t1.cinteger) COUNT(2)
11 11
select count(distinct t1.cinteger), SUM(2) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
count(distinct t1.cinteger) SUM(2)
11 22
select count(distinct t1.cinteger), AVG(2) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
count(distinct t1.cinteger) AVG(2)
11 2.0000
select count(distinct t1.cinteger), MIN(2) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
count(distinct t1.cinteger) MIN(2)
11 2
select count(distinct t1.cinteger), MAX(2) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
count(distinct t1.cinteger) MAX(2)
11 2
select count(distinct t1.cinteger), COUNT(DISTINCT 2) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
count(distinct t1.cinteger) COUNT(DISTINCT 2)
11 1
select count(distinct t1.cinteger), SUM(DISTINCT 2) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
count(distinct t1.cinteger) SUM(DISTINCT 2)
11 2
select count(distinct t1.cinteger), AVG(DISTINCT 2) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
count(distinct t1.cinteger) AVG(DISTINCT 2)
11 2.0000
select count(distinct t1.cinteger), STDDEV_POP(2) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
count(distinct t1.cinteger) STDDEV_POP(2)
11 0.0000
select count(distinct t1.cinteger), STDDEV_SAMP(2) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
count(distinct t1.cinteger) STDDEV_SAMP(2)
11 0.0000
select count(distinct t1.cinteger), VAR_POP(2) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
count(distinct t1.cinteger) VAR_POP(2)
11 0.0000
select count(distinct t1.cinteger), VAR_SAMP(2) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
count(distinct t1.cinteger) VAR_SAMP(2)
11 0.0000
select count(distinct t1.cinteger), COUNT(2) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
count(distinct t1.cinteger) COUNT(2)
0 0
select count(distinct t1.cinteger), SUM(2) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
count(distinct t1.cinteger) SUM(2)
0 NULL
select count(distinct t1.cinteger), AVG(2) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
count(distinct t1.cinteger) AVG(2)
0 NULL
select count(distinct t1.cinteger), MIN(2) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
count(distinct t1.cinteger) MIN(2)
0 NULL
select count(distinct t1.cinteger), MAX(2) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
count(distinct t1.cinteger) MAX(2)
0 NULL
select count(distinct t1.cinteger), COUNT(DISTINCT 2) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
count(distinct t1.cinteger) COUNT(DISTINCT 2)
0 0
select count(distinct t1.cinteger), SUM(DISTINCT 2) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
count(distinct t1.cinteger) SUM(DISTINCT 2)
0 NULL
select count(distinct t1.cinteger), AVG(DISTINCT 2) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
count(distinct t1.cinteger) AVG(DISTINCT 2)
0 NULL
select count(distinct t1.cinteger), STDDEV_POP(2) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
count(distinct t1.cinteger) STDDEV_POP(2)
0 NULL
select count(distinct t1.cinteger), STDDEV_SAMP(2) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
count(distinct t1.cinteger) STDDEV_SAMP(2)
0 NULL
select count(distinct t1.cinteger), VAR_POP(2) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
count(distinct t1.cinteger) VAR_POP(2)
0 NULL
select count(distinct t1.cinteger), VAR_SAMP(2) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
count(distinct t1.cinteger) VAR_SAMP(2)
0 NULL
select count(distinct t1.cinteger), COUNT(8.9) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
count(distinct t1.cinteger) COUNT(8.9)
11 11
select count(distinct t1.cinteger), SUM(8.9) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
count(distinct t1.cinteger) SUM(8.9)
11 97.9
select count(distinct t1.cinteger), AVG(8.9) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
count(distinct t1.cinteger) AVG(8.9)
11 8.90000
select count(distinct t1.cinteger), MIN(8.9) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
count(distinct t1.cinteger) MIN(8.9)
11 8.9
select count(distinct t1.cinteger), MAX(8.9) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
count(distinct t1.cinteger) MAX(8.9)
11 8.9
select count(distinct t1.cinteger), COUNT(DISTINCT 8.9) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
count(distinct t1.cinteger) COUNT(DISTINCT 8.9)
11 1
select count(distinct t1.cinteger), SUM(DISTINCT 8.9) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
count(distinct t1.cinteger) SUM(DISTINCT 8.9)
11 8.9
select count(distinct t1.cinteger), AVG(DISTINCT 8.9) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
count(distinct t1.cinteger) AVG(DISTINCT 8.9)
11 8.90000
select count(distinct t1.cinteger), STDDEV_POP(8.9) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
count(distinct t1.cinteger) STDDEV_POP(8.9)
11 0.00000
select count(distinct t1.cinteger), STDDEV_SAMP(8.9) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
count(distinct t1.cinteger) STDDEV_SAMP(8.9)
11 0.00000
select count(distinct t1.cinteger), VAR_POP(8.9) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
count(distinct t1.cinteger) VAR_POP(8.9)
11 0.00000
select count(distinct t1.cinteger), VAR_SAMP(8.9) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
count(distinct t1.cinteger) VAR_SAMP(8.9)
11 0.00000
select count(distinct t1.cinteger), COUNT(8.9) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
count(distinct t1.cinteger) COUNT(8.9)
0 0
select count(distinct t1.cinteger), SUM(8.9) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
count(distinct t1.cinteger) SUM(8.9)
0 NULL
select count(distinct t1.cinteger), AVG(8.9) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
count(distinct t1.cinteger) AVG(8.9)
0 NULL
select count(distinct t1.cinteger), MIN(8.9) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
count(distinct t1.cinteger) MIN(8.9)
0 NULL
select count(distinct t1.cinteger), MAX(8.9) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
count(distinct t1.cinteger) MAX(8.9)
0 NULL
select count(distinct t1.cinteger), COUNT(DISTINCT 8.9) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
count(distinct t1.cinteger) COUNT(DISTINCT 8.9)
0 0
select count(distinct t1.cinteger), SUM(DISTINCT 8.9) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
count(distinct t1.cinteger) SUM(DISTINCT 8.9)
0 NULL
select count(distinct t1.cinteger), AVG(DISTINCT 8.9) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
count(distinct t1.cinteger) AVG(DISTINCT 8.9)
0 NULL
select count(distinct t1.cinteger), STDDEV_POP(8.9) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
count(distinct t1.cinteger) STDDEV_POP(8.9)
0 NULL
select count(distinct t1.cinteger), STDDEV_SAMP(8.9) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
count(distinct t1.cinteger) STDDEV_SAMP(8.9)
0 NULL
select count(distinct t1.cinteger), VAR_POP(8.9) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
count(distinct t1.cinteger) VAR_POP(8.9)
0 NULL
select count(distinct t1.cinteger), VAR_SAMP(8.9) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
count(distinct t1.cinteger) VAR_SAMP(8.9)
0 NULL
select count(distinct t1.cinteger), COUNT('8.9') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
count(distinct t1.cinteger) COUNT('8.9')
11 11
select count(distinct t1.cinteger), SUM('8.9') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
count(distinct t1.cinteger) SUM('8.9')
11 97.9
select count(distinct t1.cinteger), AVG('8.9') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
count(distinct t1.cinteger) AVG('8.9')
11 8.9
select count(distinct t1.cinteger), MIN('8.9') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
count(distinct t1.cinteger) MIN('8.9')
11 8.9
select count(distinct t1.cinteger), MAX('8.9') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
count(distinct t1.cinteger) MAX('8.9')
11 8.9
select count(distinct t1.cinteger), COUNT(DISTINCT '8.9') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
count(distinct t1.cinteger) COUNT(DISTINCT '8.9')
11 1
select count(distinct t1.cinteger), SUM(DISTINCT '8.9') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
count(distinct t1.cinteger) SUM(DISTINCT '8.9')
11 8.9
select count(distinct t1.cinteger), AVG(DISTINCT '8.9') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
count(distinct t1.cinteger) AVG(DISTINCT '8.9')
11 8.9
select count(distinct t1.cinteger), STDDEV_POP('8.9') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
count(distinct t1.cinteger) STDDEV_POP('8.9')
11 0
select count(distinct t1.cinteger), STDDEV_SAMP('8.9') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
count(distinct t1.cinteger) STDDEV_SAMP('8.9')
11 0
select count(distinct t1.cinteger), VAR_POP('8.9') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
count(distinct t1.cinteger) VAR_POP('8.9')
11 0
select count(distinct t1.cinteger), VAR_SAMP('8.9') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
count(distinct t1.cinteger) VAR_SAMP('8.9')
11 0
select count(distinct t1.cinteger), COUNT('8.9') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
count(distinct t1.cinteger) COUNT('8.9')
0 0
select count(distinct t1.cinteger), SUM('8.9') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
count(distinct t1.cinteger) SUM('8.9')
0 NULL
select count(distinct t1.cinteger), AVG('8.9') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
count(distinct t1.cinteger) AVG('8.9')
0 NULL
select count(distinct t1.cinteger), MIN('8.9') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
count(distinct t1.cinteger) MIN('8.9')
0 NULL
select count(distinct t1.cinteger), MAX('8.9') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
count(distinct t1.cinteger) MAX('8.9')
0 NULL
select count(distinct t1.cinteger), COUNT(DISTINCT '8.9') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
count(distinct t1.cinteger) COUNT(DISTINCT '8.9')
0 0
select count(distinct t1.cinteger), SUM(DISTINCT '8.9') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
count(distinct t1.cinteger) SUM(DISTINCT '8.9')
0 NULL
select count(distinct t1.cinteger), AVG(DISTINCT '8.9') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
count(distinct t1.cinteger) AVG(DISTINCT '8.9')
0 NULL
select count(distinct t1.cinteger), STDDEV_POP('8.9') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
count(distinct t1.cinteger) STDDEV_POP('8.9')
0 NULL
select count(distinct t1.cinteger), STDDEV_SAMP('8.9') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
count(distinct t1.cinteger) STDDEV_SAMP('8.9')
0 NULL
select count(distinct t1.cinteger), VAR_POP('8.9') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
count(distinct t1.cinteger) VAR_POP('8.9')
0 NULL
select count(distinct t1.cinteger), VAR_SAMP('8.9') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
count(distinct t1.cinteger) VAR_SAMP('8.9')
0 NULL
select count(distinct t1.cinteger), COUNT('a') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
count(distinct t1.cinteger) COUNT('a')
11 11
select count(distinct t1.cinteger), SUM('a') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
count(distinct t1.cinteger) SUM('a')
11 0
select count(distinct t1.cinteger), AVG('a') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
count(distinct t1.cinteger) AVG('a')
11 0
select count(distinct t1.cinteger), MIN('a') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
count(distinct t1.cinteger) MIN('a')
11 a
select count(distinct t1.cinteger), MAX('a') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
count(distinct t1.cinteger) MAX('a')
11 a
select count(distinct t1.cinteger), COUNT(DISTINCT 'a') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
count(distinct t1.cinteger) COUNT(DISTINCT 'a')
11 1
select count(distinct t1.cinteger), SUM(DISTINCT 'a') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
count(distinct t1.cinteger) SUM(DISTINCT 'a')
11 0
select count(distinct t1.cinteger), AVG(DISTINCT 'a') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
count(distinct t1.cinteger) AVG(DISTINCT 'a')
11 0
select count(distinct t1.cinteger), STDDEV_POP('a') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
count(distinct t1.cinteger) STDDEV_POP('a')
11 0
select count(distinct t1.cinteger), STDDEV_SAMP('a') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
count(distinct t1.cinteger) STDDEV_SAMP('a')
11 0
select count(distinct t1.cinteger), VAR_POP('a') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
count(distinct t1.cinteger) VAR_POP('a')
11 0
select count(distinct t1.cinteger), VAR_SAMP('a') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
count(distinct t1.cinteger) VAR_SAMP('a')
11 0
select count(distinct t1.cinteger), COUNT('a') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
count(distinct t1.cinteger) COUNT('a')
0 0
select count(distinct t1.cinteger), SUM('a') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
count(distinct t1.cinteger) SUM('a')
0 NULL
select count(distinct t1.cinteger), AVG('a') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
count(distinct t1.cinteger) AVG('a')
0 NULL
select count(distinct t1.cinteger), MIN('a') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
count(distinct t1.cinteger) MIN('a')
0 NULL
select count(distinct t1.cinteger), MAX('a') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
count(distinct t1.cinteger) MAX('a')
0 NULL
select count(distinct t1.cinteger), COUNT(DISTINCT 'a') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
count(distinct t1.cinteger) COUNT(DISTINCT 'a')
0 0
select count(distinct t1.cinteger), SUM(DISTINCT 'a') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
count(distinct t1.cinteger) SUM(DISTINCT 'a')
0 NULL
select count(distinct t1.cinteger), AVG(DISTINCT 'a') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
count(distinct t1.cinteger) AVG(DISTINCT 'a')
0 NULL
select count(distinct t1.cinteger), STDDEV_POP('a') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
count(distinct t1.cinteger) STDDEV_POP('a')
0 NULL
select count(distinct t1.cinteger), STDDEV_SAMP('a') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
count(distinct t1.cinteger) STDDEV_SAMP('a')
0 NULL
select count(distinct t1.cinteger), VAR_POP('a') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
count(distinct t1.cinteger) VAR_POP('a')
0 NULL
select count(distinct t1.cinteger), VAR_SAMP('a') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
count(distinct t1.cinteger) VAR_SAMP('a')
0 NULL
select count(distinct t1.cinteger), COUNT('2011-04-08') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
count(distinct t1.cinteger) COUNT('2011-04-08')
11 11
select count(distinct t1.cinteger), SUM('2011-04-08') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
count(distinct t1.cinteger) SUM('2011-04-08')
11 22121
select count(distinct t1.cinteger), AVG('2011-04-08') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
count(distinct t1.cinteger) AVG('2011-04-08')
11 2011
select count(distinct t1.cinteger), MIN('2011-04-08') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
count(distinct t1.cinteger) MIN('2011-04-08')
11 2011-04-08
select count(distinct t1.cinteger), MAX('2011-04-08') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
count(distinct t1.cinteger) MAX('2011-04-08')
11 2011-04-08
select count(distinct t1.cinteger), COUNT(DISTINCT '2011-04-08') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
count(distinct t1.cinteger) COUNT(DISTINCT '2011-04-08')
11 1
select count(distinct t1.cinteger), SUM(DISTINCT '2011-04-08') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
count(distinct t1.cinteger) SUM(DISTINCT '2011-04-08')
11 2011
select count(distinct t1.cinteger), AVG(DISTINCT '2011-04-08') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
count(distinct t1.cinteger) AVG(DISTINCT '2011-04-08')
11 2011
select count(distinct t1.cinteger), STDDEV_POP('2011-04-08') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
count(distinct t1.cinteger) STDDEV_POP('2011-04-08')
11 0
select count(distinct t1.cinteger), STDDEV_SAMP('2011-04-08') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
count(distinct t1.cinteger) STDDEV_SAMP('2011-04-08')
11 0
select count(distinct t1.cinteger), VAR_POP('2011-04-08') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
count(distinct t1.cinteger) VAR_POP('2011-04-08')
11 0
select count(distinct t1.cinteger), VAR_SAMP('2011-04-08') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
count(distinct t1.cinteger) VAR_SAMP('2011-04-08')
11 0
select count(distinct t1.cinteger), COUNT('2011-04-08') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
count(distinct t1.cinteger) COUNT('2011-04-08')
0 0
select count(distinct t1.cinteger), SUM('2011-04-08') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
count(distinct t1.cinteger) SUM('2011-04-08')
0 NULL
select count(distinct t1.cinteger), AVG('2011-04-08') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
count(distinct t1.cinteger) AVG('2011-04-08')
0 NULL
select count(distinct t1.cinteger), MIN('2011-04-08') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
count(distinct t1.cinteger) MIN('2011-04-08')
0 NULL
select count(distinct t1.cinteger), MAX('2011-04-08') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
count(distinct t1.cinteger) MAX('2011-04-08')
0 NULL
select count(distinct t1.cinteger), COUNT(DISTINCT '2011-04-08') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
count(distinct t1.cinteger) COUNT(DISTINCT '2011-04-08')
0 0
select count(distinct t1.cinteger), SUM(DISTINCT '2011-04-08') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
count(distinct t1.cinteger) SUM(DISTINCT '2011-04-08')
0 NULL
select count(distinct t1.cinteger), AVG(DISTINCT '2011-04-08') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
count(distinct t1.cinteger) AVG(DISTINCT '2011-04-08')
0 NULL
select count(distinct t1.cinteger), STDDEV_POP('2011-04-08') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
count(distinct t1.cinteger) STDDEV_POP('2011-04-08')
0 NULL
select count(distinct t1.cinteger), STDDEV_SAMP('2011-04-08') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
count(distinct t1.cinteger) STDDEV_SAMP('2011-04-08')
0 NULL
select count(distinct t1.cinteger), VAR_POP('2011-04-08') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
count(distinct t1.cinteger) VAR_POP('2011-04-08')
0 NULL
select count(distinct t1.cinteger), VAR_SAMP('2011-04-08') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
count(distinct t1.cinteger) VAR_SAMP('2011-04-08')
0 NULL
select count(distinct t1.cinteger), COUNT('2011-04-08 12:34:56') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
count(distinct t1.cinteger) COUNT('2011-04-08 12:34:56')
11 11
select count(distinct t1.cinteger), SUM('2011-04-08 12:34:56') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
count(distinct t1.cinteger) SUM('2011-04-08 12:34:56')
11 22121
select count(distinct t1.cinteger), AVG('2011-04-08 12:34:56') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
count(distinct t1.cinteger) AVG('2011-04-08 12:34:56')
11 2011
select count(distinct t1.cinteger), MIN('2011-04-08 12:34:56') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
count(distinct t1.cinteger) MIN('2011-04-08 12:34:56')
11 2011-04-08 12:34:56
select count(distinct t1.cinteger), MAX('2011-04-08 12:34:56') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
count(distinct t1.cinteger) MAX('2011-04-08 12:34:56')
11 2011-04-08 12:34:56
select count(distinct t1.cinteger), COUNT(DISTINCT '2011-04-08 12:34:56') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
count(distinct t1.cinteger) COUNT(DISTINCT '2011-04-08 12:34:56')
11 1
select count(distinct t1.cinteger), SUM(DISTINCT '2011-04-08 12:34:56') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
count(distinct t1.cinteger) SUM(DISTINCT '2011-04-08 12:34:56')
11 2011
select count(distinct t1.cinteger), AVG(DISTINCT '2011-04-08 12:34:56') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
count(distinct t1.cinteger) AVG(DISTINCT '2011-04-08 12:34:56')
11 2011
select count(distinct t1.cinteger), STDDEV_POP('2011-04-08 12:34:56') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
count(distinct t1.cinteger) STDDEV_POP('2011-04-08 12:34:56')
11 0
select count(distinct t1.cinteger), STDDEV_SAMP('2011-04-08 12:34:56') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
count(distinct t1.cinteger) STDDEV_SAMP('2011-04-08 12:34:56')
11 0
select count(distinct t1.cinteger), VAR_POP('2011-04-08 12:34:56') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
count(distinct t1.cinteger) VAR_POP('2011-04-08 12:34:56')
11 0
select count(distinct t1.cinteger), VAR_SAMP('2011-04-08 12:34:56') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
count(distinct t1.cinteger) VAR_SAMP('2011-04-08 12:34:56')
11 0
select count(distinct t1.cinteger), COUNT('2011-04-08 12:34:56') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
count(distinct t1.cinteger) COUNT('2011-04-08 12:34:56')
0 0
select count(distinct t1.cinteger), SUM('2011-04-08 12:34:56') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
count(distinct t1.cinteger) SUM('2011-04-08 12:34:56')
0 NULL
select count(distinct t1.cinteger), AVG('2011-04-08 12:34:56') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
count(distinct t1.cinteger) AVG('2011-04-08 12:34:56')
0 NULL
select count(distinct t1.cinteger), MIN('2011-04-08 12:34:56') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
count(distinct t1.cinteger) MIN('2011-04-08 12:34:56')
0 NULL
select count(distinct t1.cinteger), MAX('2011-04-08 12:34:56') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
count(distinct t1.cinteger) MAX('2011-04-08 12:34:56')
0 NULL
select count(distinct t1.cinteger), COUNT(DISTINCT '2011-04-08 12:34:56') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
count(distinct t1.cinteger) COUNT(DISTINCT '2011-04-08 12:34:56')
0 0
select count(distinct t1.cinteger), SUM(DISTINCT '2011-04-08 12:34:56') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
count(distinct t1.cinteger) SUM(DISTINCT '2011-04-08 12:34:56')
0 NULL
select count(distinct t1.cinteger), AVG(DISTINCT '2011-04-08 12:34:56') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
count(distinct t1.cinteger) AVG(DISTINCT '2011-04-08 12:34:56')
0 NULL
select count(distinct t1.cinteger), STDDEV_POP('2011-04-08 12:34:56') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
count(distinct t1.cinteger) STDDEV_POP('2011-04-08 12:34:56')
0 NULL
select count(distinct t1.cinteger), STDDEV_SAMP('2011-04-08 12:34:56') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
count(distinct t1.cinteger) STDDEV_SAMP('2011-04-08 12:34:56')
0 NULL
select count(distinct t1.cinteger), VAR_POP('2011-04-08 12:34:56') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
count(distinct t1.cinteger) VAR_POP('2011-04-08 12:34:56')
0 NULL
select count(distinct t1.cinteger), VAR_SAMP('2011-04-08 12:34:56') from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
count(distinct t1.cinteger) VAR_SAMP('2011-04-08 12:34:56')
0 NULL
select count(distinct t1.cinteger), COUNT(null) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
count(distinct t1.cinteger) COUNT(null)
11 0
select count(distinct t1.cinteger), SUM(null) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
count(distinct t1.cinteger) SUM(null)
11 NULL
select count(distinct t1.cinteger), AVG(null) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
count(distinct t1.cinteger) AVG(null)
11 NULL
select count(distinct t1.cinteger), MIN(null) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
count(distinct t1.cinteger) MIN(null)
11 NULL
select count(distinct t1.cinteger), MAX(null) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
count(distinct t1.cinteger) MAX(null)
11 NULL
select count(distinct t1.cinteger), COUNT(DISTINCT null) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
count(distinct t1.cinteger) COUNT(DISTINCT null)
11 0
select count(distinct t1.cinteger), SUM(DISTINCT null) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
count(distinct t1.cinteger) SUM(DISTINCT null)
11 NULL
select count(distinct t1.cinteger), AVG(DISTINCT null) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
count(distinct t1.cinteger) AVG(DISTINCT null)
11 NULL
select count(distinct t1.cinteger), STDDEV_POP(null) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
count(distinct t1.cinteger) STDDEV_POP(null)
11 NULL
select count(distinct t1.cinteger), STDDEV_SAMP(null) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
count(distinct t1.cinteger) STDDEV_SAMP(null)
11 NULL
select count(distinct t1.cinteger), VAR_POP(null) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
count(distinct t1.cinteger) VAR_POP(null)
11 NULL
select count(distinct t1.cinteger), VAR_SAMP(null) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx > 0;
count(distinct t1.cinteger) VAR_SAMP(null)
11 NULL
select count(distinct t1.cinteger), COUNT(null) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
count(distinct t1.cinteger) COUNT(null)
0 0
select count(distinct t1.cinteger), SUM(null) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
count(distinct t1.cinteger) SUM(null)
0 NULL
select count(distinct t1.cinteger), AVG(null) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
count(distinct t1.cinteger) AVG(null)
0 NULL
select count(distinct t1.cinteger), MIN(null) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
count(distinct t1.cinteger) MIN(null)
0 NULL
select count(distinct t1.cinteger), MAX(null) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
count(distinct t1.cinteger) MAX(null)
0 NULL
select count(distinct t1.cinteger), COUNT(DISTINCT null) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
count(distinct t1.cinteger) COUNT(DISTINCT null)
0 0
select count(distinct t1.cinteger), SUM(DISTINCT null) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
count(distinct t1.cinteger) SUM(DISTINCT null)
0 NULL
select count(distinct t1.cinteger), AVG(DISTINCT null) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
count(distinct t1.cinteger) AVG(DISTINCT null)
0 NULL
select count(distinct t1.cinteger), STDDEV_POP(null) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
count(distinct t1.cinteger) STDDEV_POP(null)
0 NULL
select count(distinct t1.cinteger), STDDEV_SAMP(null) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
count(distinct t1.cinteger) STDDEV_SAMP(null)
0 NULL
select count(distinct t1.cinteger), VAR_POP(null) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
count(distinct t1.cinteger) VAR_POP(null)
0 NULL
select count(distinct t1.cinteger), VAR_SAMP(null) from datatypetestm t1, datatypetestm t2 where t1.cidx = t2.cidx and t1.cidx = 0;
count(distinct t1.cinteger) VAR_SAMP(null)
0 NULL
View Git Blame Copy Permalink