Notice - Undefined index: ORDER BY

[williamdes]

Undefined index: ORDER BY
Execute:

CREATE TABLE sale_mast (bill_no INT NOT NULL, bill_date TIMESTAMP NOT NULL, 
cust_code VARCHAR(15) NOT NULL, amount DECIMAL(8,2) NOT NULL)  
PARTITION BY RANGE (UNIX_TIMESTAMP(bill_date))(
PARTITION p0 VALUES LESS THAN (UNIX_TIMESTAMP('2013-04-01')), 
PARTITION p1 VALUES LESS THAN (UNIX_TIMESTAMP('2013-07-01')), 
PARTITION p2 VALUES LESS THAN (UNIX_TIMESTAMP('2013-10-01')), 
PARTITION p3 VALUES LESS THAN (UNIX_TIMESTAMP('2014-01-01')));

• Go to table, expand 'partitions'
• Click on optimize

Param	Value
Error Type	Notice
Error Message	Undefined index: ORDER BY
Exception Type	php
phpMyAdmin version	4.8.6-dev
Incident count	212
Link	Report#56905

This comment is posted automatically by phpMyAdmin's error-reporting-server.

[williamdes]

use PhpMyAdmin\SqlParser\Utils\Query;


$analyzed_sql_results = Query::getAll('ALTER TABLE `sale_mast` OPTIMIZE PARTITION p3');
$unsorted_sql_query = Query::replaceClause(
    $analyzed_sql_results['statement'],
    $analyzed_sql_results['parser']->list,
    'ORDER BY',
    ''
);

[williamdes]

Notice in ./vendor/phpmyadmin/sql-parser/src/Utils/Query.php#587
 Undefined index: ORDER BY

Backtrace

./vendor/phpmyadmin/sql-parser/src/Utils/Query.php#683: PhpMyAdmin\SqlParser\Utils\Query::getClause(
,
,
string 'ORDER BY',
integer -1,
boolean false,
)
./index.php#35: PhpMyAdmin\SqlParser\Utils\Query::replaceClause(
,
,
string 'ORDER BY',
string '',
)

[williamdes]

@devenbansod Can you please have a look at this issue ?
Seems to need to be fixed on the sql-parser repository

[williamdes]

Create the procedure

DELIMITER $$
CREATE PROCEDURE `abc`()
    NO SQL
(SELECT 1)
UNION
(SELECT 2)$$
DELIMITER ;

Run the query

CALL `abc`()

And then, edit the query (edit inline) and run it another time