Merge branch 'QA_5_2'

MauricioFauth · MauricioFauth · commit 53150552a33d · 2023-11-12T15:36:12.000-03:00
Signed-off-by: Maurício Meneghini Fauth &lt;mauricio@fauth.dev&gt;
diff --git a/ChangeLog b/ChangeLog
@@ -72,6 +72,8 @@ phpMyAdmin - ChangeLog
 - issue #17381 Fixed JS errors when editing indexes on create table
 - issue #14402 Fix the PRIMARY label still shown when using two columns for a PK on create table
 - issue #17347 Fixed JS errors when changing index settings on create table
+- issue        Fix BETWEEN search does not validate input because of spaces
+- issue        Fix JS number validation does not validate when the input is empty or emptied
 
 5.2.1 (2023-02-07)
 - issue #17522 Fix case where the routes cache file is invalid
diff --git a/phpstan-baseline.neon b/phpstan-baseline.neon
@@ -2626,12 +2626,12 @@ parameters:
 			path: src/Controllers/Database/Structure/EmptyTableController.php
 
 		-
-			message: "#^Parameter \\#1 \\$identifier of static method PhpMyAdmin\\\\Util\\:\\:backquote\\(\\) expects string\\|Stringable\\|null, mixed given\\.$#"
+			message: "#^Parameter \\#1 \\$value of function count expects array\\|Countable, mixed given\\.$#"
 			count: 1
 			path: src/Controllers/Database/Structure/EmptyTableController.php
 
 		-
-			message: "#^Parameter \\#1 \\$value of function count expects array\\|Countable, mixed given\\.$#"
+			message: "#^Parameter \\#2 \\$dbName of static method PhpMyAdmin\\\\Table\\:\\:get\\(\\) expects string, mixed given\\.$#"
 			count: 1
 			path: src/Controllers/Database/Structure/EmptyTableController.php
 
diff --git a/psalm-baseline.xml b/psalm-baseline.xml
@@ -1541,7 +1541,6 @@
     </InvalidArgument>
     <PossiblyInvalidArgument>
       <code>$selected</code>
-      <code>$selected[$i]</code>
     </PossiblyInvalidArgument>
     <PossiblyUnusedMethod>
       <code>__construct</code>
diff --git a/resources/js/src/table/change.ts b/resources/js/src/table/change.ts
@@ -190,7 +190,11 @@ function verifyAfterSearchFieldChange (index, searchFormId) {
             // BETWEEN and NOT BETWEEN
             // See all possible syntaxes in tests of https://regexr.com/7h1eq
             jQuery.validator.addMethod('validationFunctionForMultipleInt', function (value) {
-                return value.match(/^(((0x[0-9a-f]+)|([+-]?([0-9]*\.?[0-9]+|[0-9]+\.?[0-9]*)(e[+-]?[0-9]+)?))(,|$))+$/i) !== null;
+                if (value === '') {
+                    return true;
+                }
+
+                return value.replace(/ /g,'').match(/^(((0x[0-9a-f]+)|([+-]?([0-9]*\.?[0-9]+|[0-9]+\.?[0-9]*)(e[+-]?[0-9]+)?))(,|$))+$/i) !== null;
             },
             window.Messages.strEnterValidNumber
             );
@@ -200,6 +204,10 @@ function verifyAfterSearchFieldChange (index, searchFormId) {
             // validator method for INTs
             // See all possible syntaxes in tests of https://regexr.com/7h1ci
             jQuery.validator.addMethod('validationFunctionForInt', function (value) {
+                if (value === '') {
+                    return true;
+                }
+
                 return value.match(/^(0x[0-9a-f]+$)|([+-]?([0-9]*\.?[0-9]+|[0-9]+\.?[0-9]*)(e[+-]?[0-9]+)?)$/i) !== null;
             },
             window.Messages.strEnterValidNumber
diff --git a/src/Controllers/Database/Structure/EmptyTableController.php b/src/Controllers/Database/Structure/EmptyTableController.php
@@ -16,13 +16,15 @@
 use PhpMyAdmin\Operations;
 use PhpMyAdmin\ResponseRenderer;
 use PhpMyAdmin\Sql;
+use PhpMyAdmin\Table;
 use PhpMyAdmin\Template;
 use PhpMyAdmin\Transformations;
 use PhpMyAdmin\Util;
 use PhpMyAdmin\Utils\ForeignKey;
 
 use function __;
 use function count;
+use function is_string;
 
 final class EmptyTableController extends AbstractController
 {
@@ -57,6 +59,10 @@ public function __invoke(ServerRequest $request): void
         $selectedCount = count($selected);
 
         for ($i = 0; $i < $selectedCount; $i++) {
+            if (! is_string($selected[$i]) || Table::get($selected[$i], $GLOBALS['db'], $this->dbi)->isView()) {
+                continue;
+            }
+
             $aQuery = 'TRUNCATE ';
             $aQuery .= Util::backquote($selected[$i]);
 
diff --git a/src/Partitioning/Maintenance.php b/src/Partitioning/Maintenance.php
@@ -7,8 +7,10 @@
 use PhpMyAdmin\DatabaseInterface;
 use PhpMyAdmin\Identifiers\DatabaseName;
 use PhpMyAdmin\Identifiers\TableName;
+use PhpMyAdmin\Table;
 use PhpMyAdmin\Util;
 
+use function __;
 use function sprintf;
 
 final class Maintenance
@@ -136,6 +138,10 @@ public function repair(DatabaseName $db, TableName $table, string $partition): a
      */
     public function truncate(DatabaseName $db, TableName $table, string $partition): array
     {
+        if (Table::get($table->getName(), $db->getName(), $this->dbi)->isView()) {
+            return [false, __('This table is a view, it can not be truncated.')];
+        }
+
         $query = sprintf(
             'ALTER TABLE %s TRUNCATE PARTITION %s;',
             Util::backquote($table->getName()),

Original file line number	Diff line number	Diff line change
`@@ -2626,12 +2626,12 @@ parameters:`
`2626`	`2626`	`path: src/Controllers/Database/Structure/EmptyTableController.php`
`2627`	`2627`
`2628`	`2628`	`-`
`2629`		`- message: "#^Parameter \\#1 \\$identifier of static method PhpMyAdmin\\\\Util\\:\\:backquote\\(\\) expects string\\\|Stringable\\\|null, mixed given\\.$#"`
	`2629`	`+ message: "#^Parameter \\#1 \\$value of function count expects array\\\|Countable, mixed given\\.$#"`
`2630`	`2630`	`count: 1`
`2631`	`2631`	`path: src/Controllers/Database/Structure/EmptyTableController.php`
`2632`	`2632`
`2633`	`2633`	`-`
`2634`		`- message: "#^Parameter \\#1 \\$value of function count expects array\\\|Countable, mixed given\\.$#"`
	`2634`	`+ message: "#^Parameter \\#2 \\$dbName of static method PhpMyAdmin\\\\Table\\:\\:get\\(\\) expects string, mixed given\\.$#"`
`2635`	`2635`	`count: 1`
`2636`	`2636`	`path: src/Controllers/Database/Structure/EmptyTableController.php`
`2637`	`2637`