pymysqlreplication-test-broken-datetime
/usr/local/lib64/python3.6/site-packages/pymysql/err.py(143)
raise errorclass(errno, errval)
/usr/local/lib64/python3.6/site-packages/pymysql/protocol.py(221)raise_for_error()
-> err.raise_mysql_exception(self._data)
/usr/local/lib64/python3.6/site-packages/pymysql/connections.py(725)_read_packet()
-> packet.raise_for_error()
/usr/local...
Partition Info in MySQL Binary Log
Overview
Partition information was added into MySQL binary log since MySQL 8.0.16
‘Rows_event’ class represents the information in source code.
Documentation
ROWS_EVENT in MySQL Documentation
Rows_event class in source code
Event Layout
bytes before ?
Log Event Header
Binlog::EventHeader in MySQL Documentation
Log Event Header(common header) i...
numeric datatype for pymysqlreplication
create table
integer datatype
CREATE TABLE `integer` (
`tinyint` tinyint DEFAULT NULL,
`smallint` smallint DEFAULT NULL,
`mediumint` mediumint DEFAULT NULL,
`int` int DEFAULT NULL,
`bigint` bigint DEFAULT NULL
);
unsigned datatype
CREATE TABLE `unsinged_integer` (
`tinyint` tinyint unsigned DEFAULT NULL,
`smallint` smallint unsi...
temporal datatype for pymysqlreplication
create table
CREATE TABLE `temporal_datatype` (
`classification` varchar(10) COLLATE utf8mb4_general_ci DEFAULT NULL,
`date` date DEFAULT NULL,
`datetime` datetime(6) DEFAULT NULL,
`timestamp` timestamp(6) NULL DEFAULT NULL,
`time` time(6) DEFAULT NULL,
`year` year DEFAULT NULL
)
insert values
zero, min, max values for temporal data...
TODO for pymysqlreplication
test same scenarios against pymysql
timezone support of pymysqlreplication
create documentation for numeric datatype test
write a post about call stack of pymysql
datatype
enum
test name change
test_zero_date -> test_date_zero_year
test_zero_month -> test_date_zero_month
test_zero_day -&g...
피보나치 수열 알고리즘
정의
\[a_n = a_{n-1} + a_{n-2}\ (n > 1)\]
\[a_1 = 1\]
\[a_0 = 1\]
구현
재귀 (recursion)
시간복잡도
\[O(2^n)\]
구조도
graph BT;
0,0((a4))
1,0((a3))
1,1((a2))
2,0((a2))
2,1((a1))
2,2((a1))
2,3((a0))
3,0((a1))
3,1((a0))
1,0-->0,0
1,1-->0,0
2,0-->1,0
2,1-->1,0
2,2-->1,1
2,3-->...
31 post articles, 4 pages.