[wp-trac] [WordPress Trac] #63777: wpdb::get_table_from_query() doesn't support queries with `SET STATEMENT ... FOR`

[WordPress Trac]

#63777: wpdb::get_table_from_query() doesn't support queries with `SET STATEMENT
... FOR`
--------------------------------------+-----------------------------
 Reporter:  dd32                      |       Owner:  SergeyBiryukov
     Type:  enhancement               |      Status:  closed
 Priority:  low                       |   Milestone:  6.9
Component:  Database                  |     Version:
 Severity:  minor                     |  Resolution:  fixed
 Keywords:  has-patch has-unit-tests  |     Focuses:
--------------------------------------+-----------------------------
Changes (by SergeyBiryukov):

 * owner:  (none) => SergeyBiryukov
 * status:  new => closed
 * resolution:   => fixed


Comment:

 In [changeset:"60622" 60622]:
 {{{
 #!CommitTicketReference repository="" revision="60622"
 Database: Add support for `SET STATEMENT` in
 `wpdb::get_table_from_query()`.

 MariaDB supports setting various parameters for queries. This commit
 ensures that `wpdb` can properly retrieve the table name from such
 queries.

 Reference: [https://mariadb.com/docs/server/reference/sql-statements
 /administrative-sql-statements/set-commands/set-statement MariaDB
 Documentation: SET STATEMENT].

 Follow-up to [30345].

 Props dd32.
 Fixes #63777.
 }}}

-- 
Ticket URL: <https://core.trac.wordpress.org/ticket/63777#comment:3>
WordPress Trac <https://core.trac.wordpress.org/>
WordPress publishing platform