#43589
|
WPDB Update change NULL values to acceptable values
|
|
Database
|
normal
|
normal
|
Awaiting Review
|
defect (bug)
|
has-patch
|
01/17/2019
|
#42362
|
WordPress database error Unknown column 'wp_mywordpresssite' in 'field list'
|
SergeyBiryukov
|
Database
|
normal
|
normal
|
Future Release
|
defect (bug)
|
has-patch
|
05/11/2020
|
#41302
|
WordPress not stopping queries which have reached limit and preventing users to load WordPress until query times out
|
|
Database
|
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
|
|
Database
|
normal
|
normal
|
Awaiting Review
|
defect (bug)
|
dev-feedback
|
11/11/2017
|
#49785
|
Wrong result / duplicates in query when using MariaDB
|
|
Database
|
normal
|
normal
|
Awaiting Review
|
defect (bug)
|
|
04/03/2020
|
#40695
|
`install_blog` suppresses database errors
|
|
Database
|
normal
|
normal
|
Future Release
|
defect (bug)
|
has-patch
|
06/01/2017
|
#34872
|
dbDelta Missing Index Name Creates Duplicate Indexes
|
|
Database
|
normal
|
normal
|
|
defect (bug)
|
has-patch
|
06/04/2019
|
#28591
|
dbDelta Non-literal DEFAULT not working (CURRENT_TIMESTAMP)
|
|
Database
|
normal
|
normal
|
|
defect (bug)
|
|
06/04/2019
|
#46932
|
dbDelta does not account for MySQL keywords being used as key names
|
|
Database
|
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
|
|
Database
|
normal
|
trivial
|
Awaiting Review
|
defect (bug)
|
|
03/09/2019
|
#46146
|
dbDelta not parsing enum correctly
|
|
Database
|
normal
|
normal
|
Awaiting Review
|
defect (bug)
|
|
01/30/2019
|
#46145
|
dbDelta runs same updates on every execution
|
|
Database
|
normal
|
normal
|
Awaiting Review
|
defect (bug)
|
|
01/30/2019
|
#40694
|
dbDelta uses suppressed errors to detect table absence
|
|
Database
|
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+
|
|
Database
|
normal
|
normal
|
Future Release
|
defect (bug)
|
has-patch
|
08/19/2020
|
#36924
|
dbDelta(): Support more than one whitespace between field name and its type definition
|
|
Database
|
normal
|
normal
|
Awaiting Review
|
defect (bug)
|
|
08/10/2018
|
#40779
|
function_exists() audit in wp-db.php
|
|
Database
|
low
|
minor
|
Awaiting Review
|
defect (bug)
|
dev-feedback
|
05/16/2017
|
#51350
|
mysql nosql feature request
|
|
Database
|
normal
|
normal
|
Awaiting Review
|
defect (bug)
|
|
09/18/2020
|
#46739
|
post attributes order not working correctly
|
|
Database
|
normal
|
normal
|
Awaiting Review
|
defect (bug)
|
|
03/30/2019
|
#51097
|
post cannot be saved due to certain variant of Japanese Kanji
|
|
Database
|
normal
|
normal
|
Awaiting Review
|
defect (bug)
|
close
|
08/31/2020
|
#41469
|
test_charset_switched_to_utf8() is not tested on Travis CI
|
|
Database
|
normal
|
normal
|
Awaiting Review
|
defect (bug)
|
|
07/28/2017
|
#46625
|
username and password automatically change to dexter
|
|
Database
|
normal
|
normal
|
Awaiting Review
|
defect (bug)
|
|
03/24/2019
|
#12257
|
wpdb Scales Badly Due to Unnecessary Copies of All Query Results
|
|
Database
|
normal
|
critical
|
|
defect (bug)
|
dev-feedback
|
06/04/2019
|
#51207
|
wpdb query returns incorrect value for update ( using mysql )
|
|
Database
|
normal
|
normal
|
Awaiting Review
|
defect (bug)
|
|
09/01/2020
|
#37508
|
wpdb->result instance should be checked `mysqli_num_fields` in `load_col_info()`
|
|
Database
|
normal
|
normal
|
|
defect (bug)
|
needs-unit-tests
|
06/04/2019
|
#44163
|
wpdb->update() fails, showing no error message
|
|
Database
|
normal
|
normal
|
Awaiting Review
|
defect (bug)
|
reporter-feedback
|
05/21/2018
|
#49363
|
wpdb::query() does not detect LOAD DATA as an insert statement type
|
|
Database
|
normal
|
normal
|
Awaiting Review
|
defect (bug)
|
has-patch
|
02/05/2020
|
#46947
|
‘❤’ in Comment Generates DB Error
|
|
Database
|
normal
|
normal
|
Future Release
|
defect (bug)
|
reporter-feedback
|
04/17/2019
|
#47818
|
$wpdb should update ->insert_id also when `LAST_INSERT_ID(...)` is found
|
|
Database
|
normal
|
normal
|
Awaiting Review
|
enhancement
|
|
08/02/2019
|
#31624
|
$wpdb->prepare() named placeholders
|
|
Database
|
normal
|
normal
|
|
enhancement
|
needs-unit-tests
|
06/04/2019
|
#41944
|
Add %u support to wpdb->prepare
|
|
Database
|
normal
|
normal
|
Awaiting Review
|
enhancement
|
|
09/21/2017
|
#35109
|
Add Online DDL support to dbDelta
|
|
Database
|
normal
|
normal
|
|
enhancement
|
needs-unit-tests
|
06/04/2019
|
#15499
|
Add an index for get_lastpostmodified query
|
SergeyBiryukov
|
Database
|
normal
|
normal
|
Future Release
|
enhancement
|
dev-feedback
|
12/16/2019
|
#18315
|
Add an index to the GUID column in the posts table
|
|
Database
|
normal
|
normal
|
|
enhancement
|
dev-feedback
|
06/04/2019
|
#46210
|
Add helpers for default/empty datetime value
|
|
Database
|
normal
|
normal
|
Awaiting Review
|
enhancement
|
|
11/09/2020
|
#38036
|
Add support for the utf8mb4_0900_ai_ci collation
|
|
Database
|
normal
|
normal
|
Future Release
|
enhancement
|
|
03/08/2018
|
#45354
|
Adding index for meta_key and post_id in postmeta
|
|
Database
|
normal
|
normal
|
Awaiting Review
|
enhancement
|
dev-feedback
|
01/10/2020
|
#31759
|
Allow to set $allow_bail when creating new wpdb object to handle connection error silently
|
|
Database
|
normal
|
normal
|
|
enhancement
|
|
06/04/2019
|
#38760
|
Capture result size in bytes when SAVEQUERIES is true
|
|
Database
|
normal
|
normal
|
Future Release
|
enhancement
|
|
10/03/2017
|
#45697
|
Database: Upgrading field collations
|
|
Database
|
normal
|
normal
|
Future Release
|
enhancement
|
|
08/05/2020
|
#49479
|
Does $wpdb->get_row() add LIMIT 1 to the query?
|
|
Database
|
normal
|
normal
|
Awaiting Review
|
enhancement
|
close
|
02/20/2020
|
#25559
|
Enhance prepare method to better support SQL IN operator
|
|
Database
|
normal
|
normal
|
|
enhancement
|
dev-feedback
|
06/04/2019
|
#28625
|
Enhancement: Add constants to support SSL connections for mysqli
|
|
Database
|
normal
|
normal
|
Future Release
|
enhancement
|
needs-unit-tests
|
01/07/2020
|
#41956
|
Errno in $wpdb
|
|
Database
|
normal
|
normal
|
Awaiting Review
|
enhancement
|
has-patch
|
08/17/2018
|
#51769
|
Full-text search support
|
|
Database
|
normal
|
normal
|
Awaiting Review
|
enhancement
|
dev-feedback
|
12/02/2020
|
#39748
|
Function to insert or update DB value
|
|
Database
|
normal
|
normal
|
Awaiting Review
|
enhancement
|
|
10/29/2017
|
#6492
|
Guids No Longer Have Permalink Format
|
|
Database
|
normal
|
normal
|
Future Release
|
enhancement
|
|
08/30/2019
|
#43019
|
Hook to validate post form data before save
|
|
Database
|
normal
|
major
|
Awaiting Review
|
enhancement
|
has-patch
|
12/30/2020
|
#26788
|
Improve dbDelta fields match
|
|
Database
|
normal
|
normal
|
|
enhancement
|
has-patch
|
06/04/2019
|
#37692
|
Introduce WP_Database_Table base class
|
|
Database
|
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
|
|
Database
|
normal
|
normal
|
Awaiting Review
|
enhancement
|
dev-feedback
|
05/07/2020
|
#46179
|
Make fetch_array accessible in $wpdb
|
|
Database
|
normal
|
normal
|
Awaiting Review
|
enhancement
|
|
02/04/2019
|
#44292
|
Make use of protected process_fields
|
|
Database
|
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.
|
|
Database
|
normal
|
normal
|
Awaiting Review
|
enhancement
|
|
03/20/2019
|
#52253
|
New filter on wp-db.php
|
|
Database
|
normal
|
normal
|
Awaiting Review
|
enhancement
|
reporter-feedback
|
01/08/2021
|
#31018
|
Persistent database connections with mysqli
|
|
Database
|
normal
|
normal
|
|
enhancement
|
needs-unit-tests
|
06/04/2019
|
#44386
|
Problem with utf8mb4_unicode_ci collation for arabic content
|
|
Database
|
normal
|
major
|
Awaiting Review
|
enhancement
|
has-patch
|
06/17/2018
|
#49028
|
Provide functionality to suppress $wpdb query filter
|
|
Database
|
normal
|
normal
|
Awaiting Review
|
enhancement
|
reporter-feedback
|
02/08/2020
|
#47280
|
SQL_CALC_FOUND_ROWS is deprecated as of MySQL 8.0.17
|
|
Database
|
normal
|
normal
|
5.7
|
enhancement
|
has-patch
|
01/12/2021
|
#42352
|
Support use of native MySQLi prepared queries
|
|
Database
|
normal
|
normal
|
Future Release
|
enhancement
|
early
|
09/24/2019
|
#47994
|
The additions of a new wp_posts table columns called post_level and post_patriarch
|
|
Database
|
normal
|
normal
|
Awaiting Review
|
enhancement
|
|
09/06/2019
|
#41424
|
Use a better error message than "Error establishing a database connection" when site isn't found
|
|
Database
|
normal
|
normal
|
Future Release
|
enhancement
|
needs-unit-tests
|
11/22/2017
|
#41054
|
Use sargable date filtering where possible
|
|
Database
|
normal
|
normal
|
Awaiting Review
|
enhancement
|
|
06/15/2017
|
#40150
|
VARCHAR/TEXT inefficiencies
|
|
Database
|
normal
|
normal
|
Awaiting Review
|
enhancement
|
|
03/14/2017
|
#31042
|
WPDB field_types Variable Too Broad?
|
|
Database
|
normal
|
normal
|
|
enhancement
|
|
06/04/2019
|
#42703
|
WP_Query: Swap parsing date into own method
|
|
Database
|
normal
|
normal
|
Awaiting Review
|
enhancement
|
|
01/16/2019
|
#41281
|
attachment_url_to_postid results in very slow query
|
joemcgill*
|
Database
|
normal
|
normal
|
Awaiting Review
|
enhancement
|
|
10/13/2020
|
#8924
|
autoload should be boolean in add_option()
|
|
Database
|
lowest
|
normal
|
Awaiting Review
|
enhancement
|
|
03/15/2019
|
#10883
|
db-error.php not used for all DB failures
|
|
Database
|
normal
|
normal
|
|
enhancement
|
|
07/24/2019
|
#40357
|
dbDelta can't change primary keys, create AUTO_INCREMENT columns and doesn't make significant index changes
|
|
Database
|
normal
|
normal
|
Awaiting Review
|
enhancement
|
needs-unit-tests
|
04/04/2017
|
#10404
|
dbDelta creates duplicate indexes when index definition contains spaces
|
|
Database
|
normal
|
normal
|
|
enhancement
|
has-patch
|
03/30/2020
|
#20634
|
dbDelta is unforgiving about field declarations
|
|
Database
|
normal
|
normal
|
|
enhancement
|
dev-feedback
|
06/04/2019
|
#49654
|
maybe_drop_table
|
|
Database
|
normal
|
normal
|
Awaiting Review
|
enhancement
|
|
03/16/2020
|
#29938
|
mysqli_query and multiple resultsets
|
|
Database
|
normal
|
normal
|
|
enhancement
|
needs-unit-tests
|
06/04/2019
|
#46576
|
short-circuit filter for dbDelta
|
|
Database
|
normal
|
normal
|
Awaiting Review
|
enhancement
|
|
03/20/2019
|
#48285
|
wp-config-sample.php should default to `utf8mb4` instead of `utf8` character set
|
|
Database
|
normal
|
minor
|
Awaiting Review
|
enhancement
|
|
10/12/2019
|
#36242
|
wpdb set_sql_mode add param
|
|
Database
|
normal
|
normal
|
|
enhancement
|
|
06/04/2019
|
#46287
|
Add insert_ignore() method to wpdb to avoid unecessary boilerplate code
|
|
Database
|
normal
|
normal
|
Awaiting Review
|
feature request
|
has-patch
|
02/20/2019
|
#34330
|
Locks API for atomic data manipulation
|
|
Database
|
normal
|
normal
|
|
feature request
|
|
06/04/2019
|
#51762
|
Unix authentication support via unix_socket
|
|
Database
|
normal
|
normal
|
Awaiting Review
|
feature request
|
|
11/12/2020
|
#15332
|
dbDelta($query) - do not create view
|
|
Database
|
normal
|
normal
|
Future Release
|
feature request
|
needs-unit-tests
|
07/30/2018
|
#49879
|
Can't create or save post if post date is less than 13 Dec 1901
|
|
Date/Time
|
normal
|
normal
|
Awaiting Review
|
defect (bug)
|
|
04/13/2020
|
#34435
|
Creating a post might fail during fall's DST switch due to ambiguous time
|
|
Date/Time
|
normal
|
normal
|
Future Release
|
defect (bug)
|
needs-docs
|
05/30/2019
|
#49012
|
Date format output incorrect in Finnish
|
|
Date/Time
|
normal
|
normal
|
Awaiting Review
|
defect (bug)
|
|
12/17/2019
|
#51625
|
Date/Time test failures during DST transition
|
|
Date/Time
|
normal
|
normal
|
Awaiting Review
|
defect (bug)
|
|
10/25/2020
|
#51945
|
Dates in REST API responses are incompatible with date-time JSON schema format
|
|
Date/Time
|
normal
|
normal
|
Awaiting Review
|
defect (bug)
|
dev-feedback
|
12/07/2020
|
#51289
|
Documentation issue: get_post_time is getting the time when published not when created
|
SergeyBiryukov
|
Date/Time
|
normal
|
normal
|
5.7
|
defect (bug)
|
has-patch
|
11/04/2020
|
#32386
|
Draft's Last Modified date incorrect if it is Scheduled
|
obenland
|
Date/Time
|
normal
|
normal
|
Future Release
|
defect (bug)
|
|
10/07/2020
|
#48207
|
Implement new Comment Date Functions
|
|
Date/Time
|
normal
|
normal
|
Awaiting Review
|
defect (bug)
|
needs-unit-tests
|
11/08/2019
|
#46609
|
Incorrect posts date on saving scheduled posts draft
|
|
Date/Time
|
normal
|
normal
|
Awaiting Review
|
defect (bug)
|
|
05/27/2019
|
#43028
|
Remove numbers before month in dropdown, it makes user confused when drowdown is not opened
|
|
Date/Time
|
normal
|
normal
|
Awaiting Review
|
defect (bug)
|
has-patch
|
06/22/2020
|
#49581
|
Revisions are showing time in GMT and not Local Time
|
|
Date/Time
|
normal
|
normal
|
Awaiting Review
|
defect (bug)
|
|
03/04/2020
|
#44597
|
Scheduling posts adds wrong seconds as post_date
|
|
Date/Time
|
normal
|
normal
|
Awaiting Review
|
defect (bug)
|
|
08/25/2020
|
#52220
|
Weekly archives/week 53 incorrect crossing over a year change
|
Rarst*
|
Date/Time
|
normal
|
normal
|
Awaiting Review
|
defect (bug)
|
needs-unit-tests
|
01/05/2021
|
#26798
|
While inserting a post some values for 'post_date' throw a PHP exception
|
|
Date/Time
|
normal
|
normal
|
Future Release
|
defect (bug)
|
needs-unit-tests
|
09/25/2020
|
#41011
|
get_calendar generates query with invalid date formats
|
|
Date/Time
|
normal
|
normal
|
Future Release
|
defect (bug)
|
|
09/22/2020
|
#26980
|
the_modified_date is lower than the_date when post is scheduled
|
|
Date/Time
|
normal
|
normal
|
Awaiting Review
|
defect (bug)
|
|
03/27/2019
|
#45047
|
user_registered returned as UTC Time instead of Local Time
|
|
Date/Time
|
normal
|
normal
|
Future Release
|
defect (bug)
|
has-patch
|
04/22/2020
|
#49413
|
wp_exif_date2ts should use Datetime and accept an optional offset
|
Rarst
|
Date/Time
|
low
|
normal
|
Future Release
|
defect (bug)
|
needs-unit-tests
|
11/05/2020
|
#48204
|
wp_exif_date2ts throws notice on empty date
|
|
Date/Time
|
normal
|
minor
|
Future Release
|
defect (bug)
|
|
10/04/2019
|
#49414
|
wp_read_image_metadata should look for timezone offset
|
|
Date/Time
|
normal
|
normal
|
Awaiting Review
|
defect (bug)
|
|
02/15/2020
|