[MDEV-31425] Update range partitoning example in KB Created: 2023-06-07  Updated: 2024-01-16  Resolved: 2024-01-16

Status: Closed
Project: MariaDB Server
Component/s: Documentation
Affects Version/s: None
Fix Version/s: N/A

Type: Bug Priority: Minor
Reporter: Anel Husakovic Assignee: Ian Gilfillan
Resolution: Fixed Votes: 0
Labels: None


 Description   

On page https://mariadb.com/kb/en/range-partitioning-type/ there is example that leads to error message

ERROR 1364 (HY000): Field 'ip' doesn't have a default value

Suggestion to remove ip and action not null, non-default fields.
Besides that there is a column timestamp with datetime and TIMESTAMP field with insert statement related to later, but with the error message returned for former.

INSERT INTO log(id,timestamp) VALUES 
  (1, '2016-01-01 01:01:01'), 
  (2, '2015-01-01 01:01:01');

This should return error for timestamp type:

ERROR 1526 (HY000): Table has no partition for value 1451606461

instead of datetime type:

ERROR 1526 (HY000): Table has no partition for value 2016

that is returned for other type of insert

INSERT INTO log(id,timestamp) VALUES 
  (1, '2016-01-01'), 
  (2, '2015-01-01');

Maybe to add both tables?


Generated at Thu Feb 08 10:23:46 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.