<commit_before>## Test TIMESTAMPDIFF
---
- Statement: SELECT TIMESTAMPDIFF(DAY, '2009-12-12', '2009-12-11');
- output: [[-1]]
---
- Statement: SELECT TIMESTAMPDIFF(DAY, '2009-12-11', '2009-12-12');
- output: [[1]]
---
- Statement: SELECT TIMESTAMPDIFF(WEEK, '2009-12-12', '2009-12-11');
- output: [[0]]
---
- Statement: SELECT TIMESTAMPDIFF(MONTH, '2009-12-12', '2009-12-11');
- output: [[0]]
---
- Statement: select timestampdiff(MONTH, '1991-9-29', '1990-8-1');
- output: [[-13]]
---
- Statement: select timestampdiff(MONTH, '1990-8-1', '1991-9-29');
- output: [[13]]
---
- Statement: SELECT TIMESTAMPDIFF(MONTH, '2011-01-01 23:59:59', '2010-12-31 00:00:00');
- output: [[0]]
---
- Statement: SELECT TIMESTAMPDIFF(QUARTER, '1990-8-1', '1991-9-29');
- output: !select-engine { all: [[3]], sys-mysql: [[4]] }
---
- Statement: SELECT TIMESTAMPDIFF(HOUR, '1991-05-10 19:30:00', '1991-05-10 20:30:00');
- output: [[1]]<commit_msg>Add a test demonstrating the problem.<commit_after>## Test TIMESTAMPDIFF
---
- Statement: SELECT TIMESTAMPDIFF(DAY, '2009-12-12', '2009-12-11');
- output: [[-1]]
---
- Statement: SELECT TIMESTAMPDIFF(DAY, '2009-12-11', '2009-12-12');
- output: [[1]]
---
- Statement: SELECT TIMESTAMPDIFF(WEEK, '2009-12-12', '2009-12-11');
- output: [[0]]
---
- Statement: SELECT TIMESTAMPDIFF(MONTH, '2009-12-12', '2009-12-11');
- output: [[0]]
---
- Statement: select timestampdiff(MONTH, '1991-9-29', '1990-8-1');
- output: [[-13]]
---
- Statement: select timestampdiff(MONTH, '1990-8-1', '1991-9-29');
- output: [[13]]
---
- Statement: SELECT TIMESTAMPDIFF(MONTH, '2011-01-01 23:59:59', '2010-12-31 00:00:00');
- output: [[0]]
---
- Statement: SELECT TIMESTAMPDIFF(DAY, DATE('2011-02-03'), DATE('2011-02-13'))
- output: [[10]]
---
- Statement: SELECT TIMESTAMPDIFF(SECOND, DATETIME('2011-02-03 04:05:06'), DATETIME('2011-02-03 04:06:05'))
- output: [[59]]
---
- Statement: SELECT TIMESTAMPDIFF(QUARTER, '1990-8-1', '1991-9-29');
- output: !select-engine { all: [[3]], sys-mysql: [[4]] }
---
- Statement: SELECT TIMESTAMPDIFF(HOUR, '1991-05-10 19:30:00', '1991-05-10 20:30:00');
- output: [[1]]
{'fraction_non_alphanumeric': 0.2586616041765543, 'fraction_numerical': 0.18509729473184622, 'mean_word_length': 4.007125890736342, 'pattern_counts': {'":': 0, '<': 3, '<?xml version=': 0, '>': 3, 'https://': 0, 'lorem ipsum': 0, 'www.': 0, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 0, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'dir': 'git-commits-cleaned', 'id': '6024270', 'n_tokens_mistral': 1104, 'n_tokens_neox': 853, 'n_words': 168}