WordPress.org

Make WordPress Core

{31} Tickets in the Database component (107 matches)

Arguments
Create a new ticket
  • Active tickets in the Database component
  • Grouped by workflow and sorted by type, summary
  • Accepted tickets have an '*' appended to their owner's name

Results (1 - 100 of 107)

1 2

Candidates for Closure (12 matches)

Ticket Summary Owner Priority Severity Milestone Type Workflow Modified
#37678 Add an action hook for plugins to do database upgrades on normal normal Awaiting Review defect (bug) dev-feedback 04/18/2019
#40418 ID columns in multisite database tables should be unsigned flixos90 normal major Awaiting Review defect (bug) dev-feedback 09/11/2018
#40088 Stop creating the `wp_links` database table normal normal Awaiting Review defect (bug) dev-feedback 08/10/2019
#43893 The maybe_create_table() function has two definitions low normal Awaiting Review defect (bug) dev-feedback 09/01/2020
#47934 Undefined property: wpdb::$blogmeta normal normal Awaiting Review defect (bug) reporter-feedback 08/27/2019
#40779 function_exists() audit in wp-db.php low minor Awaiting Review defect (bug) dev-feedback 05/16/2017
#51097 post cannot be saved due to certain variant of Japanese Kanji normal normal Awaiting Review defect (bug) close 08/31/2020
#44163 wpdb->update() fails, showing no error message normal normal Awaiting Review defect (bug) reporter-feedback 05/21/2018
#49479 Does $wpdb->get_row() add LIMIT 1 to the query? normal normal Awaiting Review enhancement close 02/20/2020
#37692 Introduce WP_Database_Table base class normal normal Awaiting Review enhancement dev-feedback 03/15/2017
#39826 LIMIT clause not required in get_options function as there's already a UNIQUE KEY on option_name normal normal Awaiting Review enhancement dev-feedback 05/07/2020
#49028 Provide functionality to suppress $wpdb query filter normal normal Awaiting Review enhancement reporter-feedback 02/08/2020

Slated for Next Release (2 matches)

Ticket Summary Owner Priority Severity Milestone Type Workflow Modified
#32315 $wpdb->insert fails without error msg SergeyBiryukov normal normal 5.7 defect (bug) dev-feedback 11/16/2020
#47280 SQL_CALC_FOUND_ROWS is deprecated as of MySQL 8.0.17 normal normal 5.7 enhancement has-patch 11/25/2020

Tickets Awaiting Review (50 matches)

Ticket Summary Owner Priority Severity Milestone Type Workflow Modified
#43664 $wpdb->get_results fails in specific cases with non-latin charaters in where clause normal normal Awaiting Review defect (bug) 04/08/2018
#46923 $wpdb->get_var() — empty sting becomes a NULL normal normal Awaiting Review defect (bug) 04/15/2019
#39811 Bug maybe_unserialize() broke mysql data. normal normal Awaiting Review defect (bug) 02/20/2017
#40953 Empty values are handled inconsistently between wpdb->get_results() and wpdb->get_col() normal normal Awaiting Review defect (bug) dev-feedback 06/08/2017
#50789 Improve WPDB logic around information_schema normal normal Awaiting Review defect (bug) 07/28/2020
#44973 Issues with $wpdb->get_col_info normal normal Awaiting Review defect (bug) has-patch 09/23/2018
#49482 Non-english slug can sometimes cause an error in WordPress query normal normal Awaiting Review defect (bug) 02/20/2020
#41278 SQL_CALC_FOUND_ROWS slow query normal normal Awaiting Review defect (bug) 07/19/2017
#51486 The add_option function should not be able to update existing rows in the database. normal normal Awaiting Review defect (bug) needs-unit-tests 10/09/2020
#18210 Update_post_meta is case insensitive on meta_key, but get_post_meta is NOT normal normal Awaiting Review defect (bug) needs-unit-tests 05/15/2017
#39273 Updating to 4.7 can break serialized data because $wpdb->determine_charset now forces utf8 when DB_CHARSET is set to utf8mb4 normal normal Awaiting Review defect (bug) dev-feedback 03/15/2019
#30795 Upgrade bug affecting indexing normal normal Awaiting Review defect (bug) 03/22/2019
#43589 WPDB Update change NULL values to acceptable values normal normal Awaiting Review defect (bug) has-patch 01/17/2019
#41302 WordPress not stopping queries which have reached limit and preventing users to load WordPress until query times out normal normal Awaiting Review defect (bug) 07/14/2017
#42381 Wordpress update does not check if database structure/scheme on existing site is equal to how it would be on a new install normal normal Awaiting Review defect (bug) dev-feedback 11/11/2017
#49785 Wrong result / duplicates in query when using MariaDB normal normal Awaiting Review defect (bug) 04/03/2020
#46932 dbDelta does not account for MySQL keywords being used as key names normal minor Awaiting Review defect (bug) 04/16/2019
#46452 dbDelta given the same PRIMARY KEY and normal KEY produces no error, reports table created successfully, but the table is not created normal trivial Awaiting Review defect (bug) 03/09/2019
#46146 dbDelta not parsing enum correctly normal normal Awaiting Review defect (bug) 01/30/2019
#46145 dbDelta runs same updates on every execution normal normal Awaiting Review defect (bug) 01/30/2019
#36924 dbDelta(): Support more than one whitespace between field name and its type definition normal normal Awaiting Review defect (bug) 08/10/2018
#51350 mysql nosql feature request normal normal Awaiting Review defect (bug) 09/18/2020
#46739 post attributes order not working correctly normal normal Awaiting Review defect (bug) 03/30/2019
#41469 test_charset_switched_to_utf8() is not tested on Travis CI normal normal Awaiting Review defect (bug) 07/28/2017
#46625 username and password automatically change to dexter normal normal Awaiting Review defect (bug) 03/24/2019
#51207 wpdb query returns incorrect value for update ( using mysql ) normal normal Awaiting Review defect (bug) 09/01/2020
#49363 wpdb::query() does not detect LOAD DATA as an insert statement type normal normal Awaiting Review defect (bug) has-patch 02/05/2020
#47818 $wpdb should update ->insert_id also when `LAST_INSERT_ID(...)` is found normal normal Awaiting Review enhancement 08/02/2019
#41944 Add %u support to wpdb->prepare normal normal Awaiting Review enhancement 09/21/2017
#46210 Add helpers for default/empty datetime value normal normal Awaiting Review enhancement 11/09/2020
#45354 Adding index for meta_key and post_id in postmeta normal normal Awaiting Review enhancement dev-feedback 01/10/2020
#41956 Errno in $wpdb normal normal Awaiting Review enhancement has-patch 08/17/2018
#51769 Full-text search support normal normal Awaiting Review enhancement dev-feedback 11/27/2020
#39748 Function to insert or update DB value normal normal Awaiting Review enhancement 10/29/2017
#46179 Make fetch_array accessible in $wpdb normal normal Awaiting Review enhancement 02/04/2019
#44292 Make use of protected process_fields normal normal Awaiting Review enhancement 06/01/2018
#46565 Mixed engine in tables, could bring to major WP failure! Also there is a small fix that could avoid that. normal normal Awaiting Review enhancement 03/20/2019
#44386 Problem with utf8mb4_unicode_ci collation for arabic content normal major Awaiting Review enhancement has-patch 06/17/2018
#47994 The additions of a new wp_posts table columns called post_level and post_patriarch normal normal Awaiting Review enhancement 09/06/2019
#41054 Use sargable date filtering where possible normal normal Awaiting Review enhancement 06/15/2017
#40150 VARCHAR/TEXT inefficiencies normal normal Awaiting Review enhancement 03/14/2017
#42703 WP_Query: Swap parsing date into own method normal normal Awaiting Review enhancement 01/16/2019
#41281 attachment_url_to_postid results in very slow query joemcgill* normal normal Awaiting Review enhancement 10/13/2020
#8924 autoload should be boolean in add_option() lowest normal Awaiting Review enhancement 03/15/2019
#40357 dbDelta can't change primary keys, create AUTO_INCREMENT columns and doesn't make significant index changes normal normal Awaiting Review enhancement needs-unit-tests 04/04/2017
#49654 maybe_drop_table normal normal Awaiting Review enhancement 03/16/2020
#46576 short-circuit filter for dbDelta normal normal Awaiting Review enhancement 03/20/2019
#48285 wp-config-sample.php should default to `utf8mb4` instead of `utf8` character set normal minor Awaiting Review enhancement 10/12/2019
#46287 Add insert_ignore() method to wpdb to avoid unecessary boilerplate code normal normal Awaiting Review feature request has-patch 02/20/2019
#51762 Unix authentication support via unix_socket normal normal Awaiting Review feature request 11/12/2020

Tickets Needing Feedback (7 matches)

Ticket Summary Owner Priority Severity Milestone Type Workflow Modified
#12257 wpdb Scales Badly Due to Unnecessary Copies of All Query Results normal critical defect (bug) dev-feedback 06/04/2019
#18315 Add an index to the GUID column in the posts table normal normal enhancement dev-feedback 06/04/2019
#25559 Enhance prepare method to better support SQL IN operator normal normal enhancement dev-feedback 06/04/2019
#20634 dbDelta is unforgiving about field declarations normal normal enhancement dev-feedback 06/04/2019
#43578 Unexpected MYSQL data format normal normal Future Release defect (bug) dev-feedback 02/03/2020
#46947 ‘❤’ in Comment Generates DB Error normal normal Future Release defect (bug) reporter-feedback 04/17/2019
#15499 Add an index for get_lastpostmodified query SergeyBiryukov normal normal Future Release enhancement dev-feedback 12/16/2019

Tickets with Patches (13 matches)

Ticket Summary Owner Priority Severity Milestone Type Workflow Modified
#13103 "Unknown character set" during install into database reports successful install. barrykooij normal normal defect (bug) has-patch 06/04/2019
#34872 dbDelta Missing Index Name Creates Duplicate Indexes normal normal defect (bug) has-patch 06/04/2019
#37508 wpdb->result instance should be checked `mysqli_num_fields` in `load_col_info()` normal normal defect (bug) needs-unit-tests 06/04/2019
#26788 Improve dbDelta fields match normal normal enhancement has-patch 06/04/2019
#31018 Persistent database connections with mysqli normal normal enhancement needs-unit-tests 06/04/2019
#10404 dbDelta creates duplicate indexes when index definition contains spaces normal normal enhancement has-patch 03/30/2020
#38921 Defining filter pre_get_table_charset causes errors normal normal Future Release defect (bug) has-patch 05/27/2020
#42362 WordPress database error Unknown column 'wp_mywordpresssite' in 'field list' SergeyBiryukov normal normal Future Release defect (bug) has-patch 05/11/2020
#40695 `install_blog` suppresses database errors normal normal Future Release defect (bug) has-patch 06/01/2017
#40694 dbDelta uses suppressed errors to detect table absence normal normal Future Release defect (bug) has-patch 12/01/2019
#49364 dbDelta() should not change display width for integer data types on MySQL 8.0.17+ normal normal Future Release defect (bug) has-patch 08/19/2020
#28625 Enhancement: Add constants to support SSL connections for mysqli normal normal Future Release enhancement needs-unit-tests 01/07/2020
#15332 dbDelta($query) - do not create view normal normal Future Release feature request needs-unit-tests 07/30/2018

Unpatched Bugs (9 matches)

Ticket Summary Owner Priority Severity Milestone Type Workflow Modified
#35256 $wpdb->insert_id equals 0 normal normal defect (bug) 06/04/2019
#26858 Comment duplicate check has a slow query normal normal defect (bug) 06/04/2019
#29096 Confusing errors when mysqli fails but mysql works normal normal defect (bug) 06/04/2019
#32868 Consider running utf8mb4 conversion on each database update normal normal defect (bug) 06/04/2019
#14711 Indexes for comment_author_email and user_id normal normal defect (bug) 06/04/2019
#21762 Storing a multidimensional array using register_setting double-serializes subarrays identified with a string sekatsim normal normal defect (bug) 06/04/2019
#28139 WP MU legacy problems: missing database tables normal normal defect (bug) 06/04/2019
#28591 dbDelta Non-literal DEFAULT not working (CURRENT_TIMESTAMP) normal normal defect (bug) 06/04/2019
#51740 Test failures using MySQL 8 normal normal Future Release defect (bug) 11/10/2020

Unpatched Enhancements (7 matches)

Ticket Summary Owner Priority Severity Milestone Type Workflow Modified
#31624 $wpdb->prepare() named placeholders normal normal enhancement needs-unit-tests 06/04/2019
#35109 Add Online DDL support to dbDelta normal normal enhancement needs-unit-tests 06/04/2019
#31759 Allow to set $allow_bail when creating new wpdb object to handle connection error silently normal normal enhancement 06/04/2019
#31042 WPDB field_types Variable Too Broad? normal normal enhancement 06/04/2019
#10883 db-error.php not used for all DB failures normal normal enhancement 07/24/2019
#29938 mysqli_query and multiple resultsets normal normal enhancement needs-unit-tests 06/04/2019
#36242 wpdb set_sql_mode add param normal normal enhancement 06/04/2019
1 2
Note: See TracReports for help on using and creating reports.