215 Commits

Author	SHA1	Message	Date
HellaUseful1	de1824d84d	fix: use DB_PREFIX consistently in SQL DELETE query rewriting	2025-03-17 05:23:26 -07:00
Matthew Bucci	1327b9d82f	add end to list of reserved keywords	2024-10-18 23:31:21 -07:00
Matthew Bucci	a6765201ce	rewrite utc timestamp requests	2024-10-17 02:54:44 -07:00
Matthew Bucci	d0eab624eb	replace regexp with its postgres version	2024-10-17 02:45:32 -07:00
Matthew Bucci	90d1c47695	cast numbers explictly as ints rather than adding 0 to them	2024-10-17 02:36:24 -07:00
Matthew Bucci	07b49dbb65	remove key names which are not supported during key creation in postgres	2024-10-17 01:31:06 -07:00
Matthew Bucci	b463ead79f	convert mediumints to ints	2024-10-17 01:25:16 -07:00
Matthew Bucci	d46dba6148	numeric rewriting should be case insensitive	2024-10-17 01:18:11 -07:00
Matthew Bucci	916950315f	Merge remote-tracking branch 'origin/v3' into returning-replaces-seq	2024-02-29 00:07:13 -08:00
Matthew Bucci	28fb016969	update expected results for create table tests with protected names	2024-02-27 00:58:58 -08:00
Matthew Bucci	b7be1aa89a	add rewriting for protected column names	2024-02-27 00:53:05 -08:00
Matthew Bucci	1b6ecce7d9	Merge remote-tracking branch 'origin/v3' into rewrite-fixes	2024-02-26 23:55:09 -08:00
Matthew Bucci	a2e25163ff	remove custom last_insert_ID logic	2024-02-26 23:47:53 -08:00
Matthew Bucci	2d5f178426	improve primary key detection to use first column found if no primary key found	2024-02-26 23:44:17 -08:00
Matthew Bucci	b92d8dde92	append RETURNING * to REPLACE Commands	2024-02-26 23:31:22 -08:00
Matthew Bucci	226ed1fc89	Merge pull request #107 from PostgreSQL-For-Wordpress/fix-site-editor ... remove unnecessary insert regex which modified (0 to ("0",	2024-02-26 23:16:43 -08:00
Matthew Bucci	6149c2f234	remove uncessary insert regex which modified (0 to ("0",	2024-02-26 23:15:24 -08:00
Matthew Bucci	10d8047776	Merge branch 'returning-replaces-seq' into rc-3.4	2024-02-26 16:30:07 -08:00
Matthew Bucci	ed7cbf106c	correct the REGEX for returning statements to account for backticks around table name	2024-02-26 16:29:49 -08:00
Matthew Bucci	cf88b4d075	formatting	2024-02-26 16:15:07 -08:00
Matthew Bucci	f602b49a5b	Merge remote-tracking branch 'origin/returning-replaces-seq' into v3.4	2024-02-26 16:14:43 -08:00
Matthew Bucci	2adacb53aa	Merge remote-tracking branch 'origin/rewrite-fixes' into v3.4	2024-02-26 16:08:00 -08:00
Matthew Bucci	66cd2fb034	Merge branch 'v3' into site-health	2024-02-26 12:30:31 -08:00
Matthew Bucci	a5480c70cb	quote any variable usages in SQL	2024-02-26 12:27:23 -08:00
Matthew Bucci	cdd38f6dfe	Merge pull request #102 from PostgreSQL-For-Wordpress/wordpress-search ... Fix Wordpress Search	2024-02-26 12:25:19 -08:00
Matthew Bucci	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
Matthew Bucci	b44dd00ec2	make numeric rewriters generic	2024-02-22 19:33:03 -08:00
Matthew Bucci	b33aa78976	add support for REPLACE INTO rewriting	2024-02-22 19:11:41 -08:00
Matthew Bucci	315823a203	adjust Select rewriter to handle order by case statements	2024-02-22 00:52:19 -08:00
Matthew Bucci	8d420dca52	replace calls to seq by adding a RETURNING * to all insert statements	2024-02-21 20:22:43 -08:00
Matthew Bucci	61cfa6896d	extract public to schema variable so we can use a constant later	2024-02-21 01:22:57 -08:00
Matthew Bucci	ebbe2915c6	add rewrite logic for SHOW TABLE STATUS and a catch for calls to information_schema	2024-02-21 01:15:51 -08:00
Matthew Bucci	0dd4213cfc	handle Alter Table Add Index behavior	2024-01-16 22:45:28 -08:00
Matthew Bucci	0b09d08fb1	remove unncessary string replacement for != to <>	2024-01-16 22:17:07 -08:00
Matthew Bucci	23da9c0dd2	Merge pull request #76 from PostgreSQL-For-Wordpress/mb-fix-auto-increment ... Improve table creation	2024-01-16 22:01:32 -08:00
Matthew Bucci	98bcd4aad0	improve performance of sequence lookup	2024-01-16 21:49:06 -08:00
Matthew Bucci	d45c7d58d9	Merge pull request #91 from PostgreSQL-For-Wordpress/fix-show-variables ... correctly emulate Show Variables command in postgres	2024-01-16 21:41:30 -08:00
Matthew Bucci	487657a642	correctly emulate Show Variables command in postgres by using the pg_settings table	2024-01-16 21:38:24 -08:00
Matthew Bucci	66d8a3df0e	update sequence handling to support bigserial and serial types	2024-01-16 21:35:32 -08:00
Matthew Bucci	ade3d6ad87	handle case with keys across multiple columns with defined lengths	2024-01-11 01:28:43 -08:00
Matthew Bucci	8f1f65db47	handle tables with fixed key lengths	2024-01-11 01:10:57 -08:00
mattbucci	a90ab01a9b	handle table charsets	2024-01-08 05:08:57 +00:00
mattbucci	53125aec2d	Add support for keys with multiple values	2024-01-08 05:00:42 +00:00
mattbucci	5f27c893b3	Remove Default character set	2024-01-08 04:22:59 +00:00
mattbucci	aca566b8bf	pgrewrite should not remove IF NOT EXISTS	2024-01-08 04:13:06 +00:00
mattbucci	200dfaa0b2	Add space before replacements to avoid any issues with similar types	2024-01-08 04:08:35 +00:00
mattbucci	30f5bee84b	Merge remote-tracking branch 'origin/v3' into mb-fix-auto-increment	2024-01-08 01:14:46 +00:00
mattbucci	94259e408b	style fixes	2024-01-07 23:07:50 +00:00
laotoutou	1b08e302c0	bugfix: $dbname is not used in driver_pgsql.php	2023-12-31 13:32:41 +08:00
Matthew Bucci	f3a71be3f0	handle unique keys	2023-11-26 15:17:26 -08:00