This is a follow up issue on https://www.drupal.org/project/drupal/issues/2986452, where in #50 and #60 these are discussed.

#50 was about - not being allowed in table names, which they are as long as the tables are properly quoted.

#60 was about the { } prefix substitution anywhere in the sql string. This means that if you happen to have a custom query where {...} occurs in for example a value set, the prefix is inserted at that point.

CommentFileSizeAuthor
#2 drupal-allow-dash-prevent-prefix-substitution-in-data-3011987-2.patch4.9 KBkriboogh

Comments

kriboogh created an issue. See original summary.

kriboogh’s picture

kriboogh commented
Status: Active » Needs review
StatusFileSize
new drupal-allow-dash-prevent-prefix-substitution-in-data-3011987-2.patch4.9 KB

!! NOTE: you first need to apply the patch from #2986452-63: Database reserved keywords need to be quoted as per the ANSI standard

This patch:
- Added - in the allowed character sets for table, field and alias
- Added more complex substitution for the {..} prefixes so they are not replacing curly braces when they are encountered in data strings.

Status: Needs review » Needs work

The last submitted patch, 2: drupal-allow-dash-prevent-prefix-substitution-in-data-3011987-2.patch, failed testing. View results

Version: 8.7.x-dev » 8.8.x-dev

Drupal 8.7.0-alpha1 will be released the week of March 11, 2019, which means new developments and disruptive changes should now be targeted against the 8.8.x-dev branch. For more information see the Drupal 8 minor version schedule and the Allowed changes during the Drupal 8 release cycle.

Version: 8.8.x-dev » 8.9.x-dev

Drupal 8.8.0-alpha1 will be released the week of October 14th, 2019, which means new developments and disruptive changes should now be targeted against the 8.9.x-dev branch. (Any changes to 8.9.x will also be committed to 9.0.x in preparation for Drupal 9’s release, but some changes like significant feature additions will be deferred to 9.1.x.). For more information see the Drupal 8 and 9 minor version schedule and the Allowed changes during the Drupal 8 and 9 release cycles.

Version: 8.9.x-dev » 9.1.x-dev

Drupal 8.9.0-beta1 was released on March 20, 2020. 8.9.x is the final, long-term support (LTS) minor release of Drupal 8, which means new developments and disruptive changes should now be targeted against the 9.1.x-dev branch. For more information see the Drupal 8 and 9 minor version schedule and the Allowed changes during the Drupal 8 and 9 release cycles.

Version: 9.1.x-dev » 9.2.x-dev

Drupal 9.1.0-alpha1 will be released the week of October 19, 2020, which means new developments and disruptive changes should now be targeted for the 9.2.x-dev branch. For more information see the Drupal 9 minor version schedule and the Allowed changes during the Drupal 9 release cycle.

Version: 9.2.x-dev » 9.3.x-dev

Drupal 9.2.0-alpha1 will be released the week of May 3, 2021, which means new developments and disruptive changes should now be targeted for the 9.3.x-dev branch. For more information see the Drupal core minor version schedule and the Allowed changes during the Drupal core release cycle.

lendude’s picture

lendude
Primary language Dutch
Location Amsterdam
commented

This reads like it is trying to solve two different problems in one issue, which we should avoid. The first part (allow dash) sounds more a task/feature than a bug. The second part (prefix substitution where it shouldn't happen) sounds like a bug if that still happens.

Version: 9.3.x-dev » 9.4.x-dev

Drupal 9.3.0-rc1 was released on November 26, 2021, which means new developments and disruptive changes should now be targeted for the 9.4.x-dev branch. For more information see the Drupal core minor version schedule and the Allowed changes during the Drupal core release cycle.

Version: 9.4.x-dev » 9.5.x-dev

Drupal 9.4.0-alpha1 was released on May 6, 2022, which means new developments and disruptive changes should now be targeted for the 9.5.x-dev branch. For more information see the Drupal core minor version schedule and the Allowed changes during the Drupal core release cycle.

Version: 9.5.x-dev » 10.1.x-dev

Drupal 9.5.0-beta2 and Drupal 10.0.0-beta2 were released on September 29, 2022, which means new developments and disruptive changes should now be targeted for the 10.1.x-dev branch. For more information see the Drupal core minor version schedule and the Allowed changes during the Drupal core release cycle.

Version: 10.1.x-dev » 11.x-dev

Drupal core is moving towards using a “main” branch. As an interim step, a new 11.x branch has been opened, as Drupal.org infrastructure cannot currently fully support a branch named main. New developments and disruptive changes should now be targeted for the 11.x branch, which currently accepts only minor-version allowed changes. For more information, see the Drupal core minor version schedule and the Allowed changes during the Drupal core release cycle.

mile23’s picture

mile23
Primary language English
Location Seattle, WA
commented

Posted by mistake....

Version: 11.x-dev » main

Drupal core is now using the main branch as the primary development branch. New developments and disruptive changes should now be targeted to the main branch.

Read more in the announcement.