https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=7806
--- Comment #23 from Martin Renvoize <[email protected]> --- 142 when I reduce the query to only those fields that are nullable: SELECT Concat(col.table_name, '.', col.column_name), col.data_type FROM information_schema.columns col JOIN information_schema.tables tab ON tab.table_schema = col.table_schema AND tab.table_name = col.table_name AND tab.table_type = 'BASE TABLE' WHERE col.data_type IN ( 'date', 'time', 'datetime', 'year', 'timestamp' ) AND col.is_nullable = 'YES' AND col.table_schema NOT IN ( 'information_schema', 'sys', 'performance_schema', 'mysql' ) AND col.table_schema = 'koha_demo1' ORDER BY col.table_schema, col.table_name, col.ordinal_position; -- You are receiving this mail because: You are watching all bug changes. _______________________________________________ Koha-bugs mailing list [email protected] https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
