41 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	b92d8dde92	append RETURNING * to REPLACE Commands	2024-02-26 23:31:22 -08:00
Matthew Bucci	6149c2f234	remove uncessary insert regex which modified (0 to ("0",	2024-02-26 23:15:24 -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	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	b76a569a15	add test for single quotes	2024-02-21 01:12:35 -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	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	7471e353e9	Merge	2024-01-08 01:15:25 +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
Matthew Bucci	d7bf645504	handle regular key expressions	2023-11-26 15:24:45 -08:00
Matthew Bucci	f3a71be3f0	handle unique keys	2023-11-26 15:17:26 -08:00
Matthew Bucci	fd2467c00b	switch to serial numeric types	2023-11-26 15:07:33 -08:00
Matthew Bucci	cbd3d83918	postgres does support primary keys in the mysql format, we don't need to rewrite	2023-11-26 01:42:21 -08:00
Matthew Bucci	91f1612d10	add tests for table creation	2023-11-26 01:34:10 -08:00
Matthew Bucci	ec9079d9c9	don't split on ',' if within a function	2023-10-30 14:24:27 -07:00