268 Commits

Author SHA1 Message Date
ea843d1560 Merge pull request #144 from hellausefulsoftware/bugfix/hellauseful1-issue-0-postgres-delete-query-rewrite
Automated: Fix #1: SQL Replacements need to use DB_PREFIX when building the regex replacements
2025-05-06 21:25:11 -07:00
de1824d84d fix: use DB_PREFIX consistently in SQL DELETE query rewriting 2025-03-17 05:23:26 -07:00
333f414a58 Merge pull request #138 from PostgreSQL-For-Wordpress/hotfix/add-end-to-reserved-keywords
add end to list of reserved keywords
2024-10-19 02:32:15 -04:00
1327b9d82f add end to list of reserved keywords 2024-10-18 23:31:21 -07:00
129aa7f171 Merge pull request #135 from PostgreSQL-For-Wordpress/hotfix/handle-utc
rewrite utc timestamp requests
2024-10-17 05:55:50 -04:00
a6765201ce rewrite utc timestamp requests 2024-10-17 02:54:44 -07:00
9f33ebc14d Merge pull request #134 from PostgreSQL-For-Wordpress/hotfix/handle-regexp
replace regexp with its postgres version
2024-10-17 05:46:44 -04:00
d0eab624eb replace regexp with its postgres version 2024-10-17 02:45:32 -07:00
f03cc84142 Merge pull request #133 from PostgreSQL-For-Wordpress/hotfix/handle-zero-int-addition-casting
cast numbers explictly as ints rather than adding 0 to them
2024-10-17 05:37:22 -04:00
90d1c47695 cast numbers explictly as ints rather than adding 0 to them 2024-10-17 02:36:24 -07:00
3de1eaae35 Merge pull request #132 from PostgreSQL-For-Wordpress/hotfix/primary_key_rewriting
remove key names which are not supported during key creation in postgres
2024-10-17 05:10:46 -04:00
0873fdaf7c Merge pull request #131 from PostgreSQL-For-Wordpress/hotfix/numeric-rewriting
Numeric Rewriting should be case insensitive.
v3.4.1
2024-10-17 04:33:36 -04:00
07b49dbb65 remove key names which are not supported during key creation in postgres 2024-10-17 01:31:06 -07:00
b463ead79f convert mediumints to ints 2024-10-17 01:25:16 -07:00
d46dba6148 numeric rewriting should be case insensitive 2024-10-17 01:18:11 -07:00
d8b83c88e2 Add newest WP version to tested list 2024-06-03 02:34:53 -07:00
c7e3fbd50b Merge pull request #101 from PostgreSQL-For-Wordpress/returning-replaces-seq
Replace calls to seq by adding a RETURNING * to all insert and replace statements
v3.4
2024-02-29 00:07:55 -08:00
916950315f Merge remote-tracking branch 'origin/v3' into returning-replaces-seq 2024-02-29 00:07:13 -08:00
6df70e35f2 Merge pull request #93 from PostgreSQL-For-Wordpress/rewrite-fixes
Improve string replacements
2024-02-29 00:04:36 -08:00
28fb016969 update expected results for create table tests with protected names 2024-02-27 00:58:58 -08:00
b7be1aa89a add rewriting for protected column names 2024-02-27 00:53:05 -08:00
1b6ecce7d9 Merge remote-tracking branch 'origin/v3' into rewrite-fixes 2024-02-26 23:55:09 -08:00
a2e25163ff remove custom last_insert_ID logic 2024-02-26 23:47:53 -08:00
2d5f178426 improve primary key detection to use first column found if no primary key found 2024-02-26 23:44:17 -08:00
b92d8dde92 append RETURNING * to REPLACE Commands 2024-02-26 23:31:22 -08:00
226ed1fc89 Merge pull request #107 from PostgreSQL-For-Wordpress/fix-site-editor
remove unnecessary insert regex which modified (0 to ("0",
v3.3.1
2024-02-26 23:16:43 -08:00
6149c2f234 remove uncessary insert regex which modified (0 to ("0", 2024-02-26 23:15:24 -08:00
10d8047776 Merge branch 'returning-replaces-seq' into rc-3.4 2024-02-26 16:30:07 -08:00
ed7cbf106c correct the REGEX for returning statements to account for backticks around table name 2024-02-26 16:29:49 -08:00
cf88b4d075 formatting 2024-02-26 16:15:07 -08:00
f602b49a5b Merge remote-tracking branch 'origin/returning-replaces-seq' into v3.4 2024-02-26 16:14:43 -08:00
2adacb53aa Merge remote-tracking branch 'origin/rewrite-fixes' into v3.4 2024-02-26 16:08:00 -08:00
d66df1d283 add pull request template 2024-02-26 13:24:33 -08:00
052f6cc978 Update issue templates 2024-02-26 13:22:15 -08:00
e9c35a4294 Update issue templates 2024-02-26 13:21:25 -08:00
8de18593da Updated tested versions 2024-02-26 12:47:54 -08:00
ab2809d28a Merge pull request #100 from PostgreSQL-For-Wordpress/site-health
add rewrite logic for SHOW TABLE STATUS and a catch for calls to information_schema
v3.3
2024-02-26 12:31:34 -08:00
66cd2fb034 Merge branch 'v3' into site-health 2024-02-26 12:30:31 -08:00
a5480c70cb quote any variable usages in SQL 2024-02-26 12:27:23 -08:00
cdd38f6dfe Merge pull request #102 from PostgreSQL-For-Wordpress/wordpress-search
Fix Wordpress Search
2024-02-26 12:25:19 -08:00
9373b914c2 Merge pull request #103 from PostgreSQL-For-Wordpress/replace-support
add support for REPLACE INTO rewriting
2024-02-26 12:24:54 -08:00
15bdebed5e Merge pull request #104 from PostgreSQL-For-Wordpress/robust-numeric
make numeric rewriters generic
2024-02-26 12:21:25 -08:00
b44dd00ec2 make numeric rewriters generic 2024-02-22 19:33:03 -08:00
b33aa78976 add support for REPLACE INTO rewriting 2024-02-22 19:11:41 -08:00
315823a203 adjust Select rewriter to handle order by case statements 2024-02-22 00:52:19 -08:00
8d420dca52 replace calls to seq by adding a RETURNING * to all insert statements 2024-02-21 20:22:43 -08:00
61cfa6896d extract public to schema variable so we can use a constant later 2024-02-21 01:22:57 -08:00
ebbe2915c6 add rewrite logic for SHOW TABLE STATUS and a catch for calls to information_schema 2024-02-21 01:15:51 -08:00
b76a569a15 add test for single quotes 2024-02-21 01:12:35 -08:00
0dd4213cfc handle Alter Table Add Index behavior 2024-01-16 22:45:28 -08:00