| Showing 1-30 of 36 (Edit, Save, CSV, Feed) | Show Next 30 Entries » |
| ID# | Date | Updated | Type | Status | Sev | Version | OS | CPU | Summary |
|---|---|---|---|---|---|---|---|---|---|
| 37531 | 2008-06-19 19:38 | 2011-02-16 23:43 | MySQL Server: InnoDB storage engine | Closed (5080 days) | S3 | 5.1.25/6.0 | Any | Any | After truncate, auto_increment behaves incorrectly for InnoDB |
| 65615 | 2012-06-14 11:32 | 2012-06-15 3:57 | MySQL Server: Command-line Clients | Closed (4354 days) | S3 | 5.6.5 m8 | Linux (CentOS5.8 32bit) | Any | after truncating the table,data insert is slow |
| 34677 | 2008-02-19 21:33 | 2008-03-01 12:32 | Connector / J | Closed (5921 days) | S2 | 5.1.5 | Any | Any | Blob.truncate throws exception with len < 1, should be < 0 |
| 21106 | 2006-07-18 8:08 | 2006-07-19 10:12 | MySQL Server: Documentation | Closed (6512 days) | S2 | 5.0.22 | Any (any) | Any | Compressed MyISAM table is read only and thus truncate should not be possible |
| 97569 | 2019-11-10 7:00 | 2019-11-11 5:49 | Connector / C | Not a Bug (1649 days) | S3 | 8.0.18 | Ubuntu (16.04) | x86 | Connector is inserting Japanese as gibberish when using utf8 charset |
| 56536 | 2010-09-03 13:10 | 2010-10-05 16:12 | MySQL Server: InnoDB storage engine | Not a Bug (4973 days) | S3 | 5.1.43 | Linux | Any | CREATE TABLE … doesn't initialize data_length, index_length |
| 21497 | 2006-08-08 0:12 | 2014-03-20 0:16 | MySQL Server | Closed (5133 days) | S2 | 5.0,5.1 | Any | Any | DOUBLE truncated to unusable value |
| 29349 | 2007-06-26 1:01 | 2014-02-02 14:12 | MySQL Server: Memory storage engine | Verified (6169 days) | S3 | 5.0.27 | Any | Any | dropping MEMORY table very slow |
| 30889 | 2007-09-07 9:59 | 2008-02-01 17:57 | MySQL Server: General | Closed (5950 days) | S1 | 6.0.3, 5.0.50, 5.1.23 | Any | Any | filesort and order by with float/numeric crashes server |
| 54916 | 2010-06-30 14:24 | 2011-02-16 23:44 | MySQL Server: DML | Closed (4985 days) | S3 | 5.5.4-m3-log, 5.5.6-m3 | Any (FreeBSD 7.2, Mac OS X, Ubuntu) | Any | GROUP_CONCAT + IFNULL truncates output |
| 26438 | 2007-02-16 2:18 | 2007-03-16 10:22 | MySQL Server: Charsets | No Feedback (6272 days) | S3 | 5.0.32 | Linux (gentoo-linux-x86_64) | Any | invalidate character result in truncated data when inserting to gbk table |
| 71070 | 2013-12-04 4:05 | 2014-07-28 9:37 | MySQL Server: Replication | Closed (3656 days) | S2 | 5.6.14,5.5.18, 5.6.15 | Any | Any | kill of truncate table will lead to binary log written while rows remains |
| 27984 | 2007-04-20 14:06 | 2007-06-18 19:41 | MySQL Server: Data Types | Closed (6178 days) | S2 | 5.0.27/5.1 | Linux (Redhat) | Any | Long Decimal Maths produces truncated results |
| 77064 | 2015-05-18 8:43 | 2015-07-27 12:10 | MySQL Server: Documentation | Closed (3217 days) | S3 | 5.5, 5.6 | Any | Any | Manual does not say anything about a known performance problem with TRUNCATE |
| 111654 | 2023-07-04 10:33 | 2023-07-05 13:00 | MySQL Server | Not a Bug (317 days) | S5 | 8.0.31 | Any (Mac, Alpine docker image) | Any (Arm 64) | Memory usage increasing with truncate |
| 71173 | 2013-12-18 14:57 | 2014-02-25 18:29 | MySQL Server: InnoDB storage engine | Closed (3734 days) | S2 | 5.7.3 | Windows (Windows 7 Enterprise 64-bit) | Any | MySQL 5.7.3 InnoDB multiple errors: 'chsize' returned OS error 71 |
| 91387 | 2018-06-24 3:29 | 2018-07-02 8:53 | MySQL Server: InnoDB storage engine | Can't repeat (2146 days) | S1 | 5.6.30 | CentOS | x86 | mysql crash, Assertion failure in file srv0srv.cc line 1756 |
| 102264 | 2021-01-17 11:22 | 2021-01-19 14:19 | MySQL Server | Not a Bug (1214 days) | S3 | 5.7.22-22 | Ubuntu | Any | MySQL undo logs not truncating |
| 25264 | 2006-12-24 12:06 | 2006-12-25 9:34 | MySQL Server: Stored Routines | Duplicate (6353 days) | S2 | 5.0.30 | Any (Any) | Any | ON DELETE triggers fire on TRUNCATE of InnoDB tables |
| 107532 | 2022-06-09 20:21 | 2024-03-11 11:06 | MySQL Server: InnoDB storage engine | Verified (703 days) | S2 | 8.0 | Ubuntu (debian docker) | Any | running parallel TRUNCATE causing foreign key constraint fails on INSERT |
| 98869 | 2020-03-08 15:46 | 2021-12-17 10:54 | MySQL Server: InnoDB storage engine | Closed (1269 days) | S5 | 8.0.19 | Any | Any | Temp ibt tablespace truncation at disconnection stuck InnoDB under large BP |
| 76956 | 2015-05-06 14:34 | 2018-10-31 7:36 | MySQL Server: Performance Schema | Verified (3299 days) | S2 | 5.6, 8.0.13 | Any | Any | Threads table PROCESSLIST_INFO truncate query |
| 112178 | 2023-08-25 3:38 | 2023-08-25 14:12 | MySQL Server: InnoDB storage engine | Can't repeat (266 days) | S3 | 8.0.34 | Any | Any | Transaction inconsistency when the undo space truncate is incomplete |
| 56597 | 2010-09-06 14:15 | 2011-02-16 23:44 | MySQL Workbench: SQL Editor | Closed (4979 days) | S3 | 5.2.27 | Windows (Windows 7) | Any | TRUNCATE command triggers 'safe updates' warning |
| 71161 | 2013-12-17 11:58 | 2013-12-31 19:15 | MySQL Server: Errors | Not a Bug (3790 days) | S3 | 5.5.27-log | Linux | Any | Truncate function inconsistent |
| 34087 | 2008-01-27 4:27 | 2008-01-27 22:53 | MySQL Server: Falcon storage engine | Can't repeat (5955 days) | S5 | 6.0.3-alpha | Any | Any | Truncate is extremely slow for Falcon tables |
| 29507 | 2007-07-03 3:58 | 2011-02-16 23:43 | MySQL Server: InnoDB storage engine | Closed (5080 days) | S3 | 5.0.44 | Windows (Vista) | Any | TRUNCATE shows too many rows affected |
| 25296 | 2006-12-27 18:05 | 2007-04-27 12:24 | MySQL Cluster: Disk Data | Closed (6230 days) | S2 | 5.1.14 | Linux (Linux 2.6) | Any | Truncate table converts NDB disk based tables to in-memory tables. |
| 36763 | 2008-05-16 18:45 | 2011-02-16 23:43 | MySQL Server: Replication | Closed (5569 days) | S3 | 5.1.24, 6.0 BK | Any | Any | TRUNCATE TABLE fails to replicate when stmt-based binlogging is not supported. |
| 47855 | 2009-10-06 10:09 | 2009-10-06 11:03 | MySQL Server: General | Not a Bug (5337 days) | S2 | 5.1.39 Community | Windows | Any | TRUNCATE TABLE having effect on transactional blocks |
| Showing 1-30 of 36 (Edit, Save, CSV, Feed) | Show Next 30 Entries » |
