Error happening on test_column_validation_core_types function on test_db2.py
sqlalchemy.exc.ProgrammingError: (ibm_db_dbi.ProgrammingError) ibm_db_dbi::ProgrammingError: Statement Execute Failed: [IBM][CLI Driver][DB2/LINUXX8664] SQL0119N An expression starting with "COL_VARCHAR_30" specified in a SELECT clause, HAVING clause, or ORDER BY clause is not specified in the GROUP BY clause or it is in a SELECT clause, HAVING clause, or ORDER BY clause with a column function and no GROUP BY clause is specified. SQLSTATE=42803 SQLCODE=-119
[SQL: WITH t0 AS
(SELECT t2.id AS id, t2.col_int8 AS col_int8, t2.col_int16 AS col_int16, t2.col_int32 AS col_int32, t2.col_int64 AS col_int64, t2.col_dec_20 AS col_dec_20, t2.col_dec_38 AS col_dec_38, t2.col_dec_10_2 AS col_dec_10_2, t2.col_float32 AS col_float32, t2.col_float64 AS col_float64, t2.col_varchar_30 AS col_varchar_30, t2.col_char_2 AS col_char_2, t2.col_string AS col_string, t2.col_date AS col_date, t2.col_datetime AS col_datetime, t2.col_tstz AS col_tstz
FROM db2inst1.dvt_core_types AS t2
WHERE id>0 AND col_int8>0)
SELECT t1.col_varchar_30, count(*) AS "count", count(t1.col_int8) AS count__col_int8, count(t1.col_int16) AS count__col_int16, count(t1.col_int32) AS count__col_int32, count(t1.col_int64) AS count__col_int64, CAST(count(t1.col_dec_20) AS VARCHAR(3000)) AS count__col_dec_20, CAST(count(t1.col_dec_38) AS VARCHAR(3000)) AS count__col_dec_38, count(t1.col_dec_10_2) AS count__col_dec_10_2, count(t1.col_float32) AS count__col_float32, CAST(count(t1.col_float64) AS VARCHAR(3000)) AS count__col_float64, count(t1.length__col_varchar_30) AS count__length__col_varchar_30, count(t1.length__col_char_2) AS count__length__col_char_2, count(t1.length__col_string) AS count__length__col_string, count(t1.col_date) AS count__col_date, count(t1.col_datetime) AS count__col_datetime, count(t1.col_tstz) AS count__col_tstz, sum(t1.col_int8) AS sum__col_int8, sum(t1.col_int16) AS sum__col_int16, sum(t1.col_int32) AS sum__col_int32, sum(t1.col_int64) AS sum__col_int64, CAST(sum(t1.col_dec_20) AS VARCHAR(3000)) AS sum__col_dec_20, CAST(sum(t1.col_dec_38) AS VARCHAR(3000)) AS sum__col_dec_38, sum(t1.col_dec_10_2) AS sum__col_dec_10_2, sum(t1.col_float32) AS sum__col_float32, CAST(sum(t1.col_float64) AS VARCHAR(3000)) AS sum__col_float64, sum(t1.length__col_varchar_30) AS sum__length__col_varchar_30, sum(t1.length__col_char_2) AS sum__length__col_char_2, sum(t1.length__col_string) AS sum__length__col_string, sum(t1.epoch_seconds__col_date) AS sum__epoch_seconds__col_date, sum(t1.epoch_seconds__col_datetime) AS sum__epoch_seconds__col_datetime, sum(t1.epoch_seconds__col_tstz) AS sum__epoch_seconds__col_tstz, min(t1.col_int8) AS min__col_int8, min(t1.col_int16) AS min__col_int16, min(t1.col_int32) AS min__col_int32, min(t1.col_int64) AS min__col_int64, CAST(min(t1.col_dec_20) AS VARCHAR(3000)) AS min__col_dec_20, CAST(min(t1.col_dec_38) AS VARCHAR(3000)) AS min__col_dec_38, min(t1.col_dec_10_2) AS min__col_dec_10_2, min(t1.col_float32) AS min__col_float32, CAST(min(t1.col_float64) AS VARCHAR(3000)) AS min__col_float64, min(t1.length__col_varchar_30) AS min__length__col_varchar_30, min(t1.length__col_char_2) AS min__length__col_char_2, min(t1.length__col_string) AS min__length__col_string, min(t1.col_date) AS min__col_date, min(t1.col_datetime) AS min__col_datetime, min(t1.col_tstz) AS min__col_tstz, max(t1.col_int8) AS max__col_int8, max(t1.col_int16) AS max__col_int16, max(t1.col_int32) AS max__col_int32, max(t1.col_int64) AS max__col_int64, CAST(max(t1.col_dec_20) AS VARCHAR(3000)) AS max__col_dec_20, CAST(max(t1.col_dec_38) AS VARCHAR(3000)) AS max__col_dec_38, max(t1.col_dec_10_2) AS max__col_dec_10_2, max(t1.col_float32) AS max__col_float32, CAST(max(t1.col_float64) AS VARCHAR(3000)) AS max__col_float64, max(t1.length__col_varchar_30) AS max__length__col_varchar_30, max(t1.length__col_char_2) AS max__length__col_char_2, max(t1.length__col_string) AS max__length__col_string, max(t1.col_date) AS max__col_date, max(t1.col_datetime) AS max__col_datetime, max(t1.col_tstz) AS max__col_tstz
FROM (SELECT t0.id AS id, t0.col_int8 AS col_int8, t0.col_int16 AS col_int16, t0.col_int32 AS col_int32, t0.col_int64 AS col_int64, t0.col_dec_20 AS col_dec_20, t0.col_dec_38 AS col_dec_38, t0.col_dec_10_2 AS col_dec_10_2, t0.col_float32 AS col_float32, t0.col_float64 AS col_float64, t0.col_varchar_30 AS col_varchar_30, t0.col_char_2 AS col_char_2, t0.col_string AS col_string, t0.col_date AS col_date, t0.col_datetime AS col_datetime, t0.col_tstz AS col_tstz, length(t0.col_varchar_30) AS length__col_varchar_30, length(t0.col_char_2) AS length__col_char_2, length(t0.col_string) AS length__col_string, EXTRACT(epoch FROM t0.col_date) AS epoch_seconds__col_date, EXTRACT(epoch FROM t0.col_datetime) AS epoch_seconds__col_datetime, EXTRACT(epoch FROM t0.col_tstz) AS epoch_seconds__col_tstz
FROM t0) AS t1 GROUP BY 1]
(Background on this error at: https://sqlalche.me/e/14/f405)
env/lib/python3.12/site-packages/ibm_db_dbi.py:1322: ProgrammingError
Error happening on
test_column_validation_core_typesfunction ontest_db2.py