[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:  (none)
     Type:  enhancement  |     Status:  new
 Priority:  low          |  Milestone:  Awaiting Review
Component:  Database     |    Version:
 Severity:  minor        |   Keywords:
  Focuses:               |
-------------------------+-----------------------------
 MariaDB supports setting various parameters for queries, but
 wpdb::get_table_from_query() doesn't currently understand this.

 https://mariadb.com/docs/server/reference/sql-statements/administrative-
 sql-statements/set-commands/set-statement

 For example:
 {{{
 wp> var_dump( $wpdb->get_table_from_query( "SET STATEMENT
 max_statement_time=10 FOR SELECT something FROM table_name WHERE
 something-is-expensive" ) );
 bool(false)
 }}}

 I'm not sure how useful supporting this would be to most WordPress
 plugins, nor how it would apply to other database engines.

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