adminerevo
6283155f69
First bunch of fixes for PHP8.3
2023-11-17 06:24:10 +01:00
Lionel Laffineur
7c9722aa44
Added function DISTINCT to db supporting it
2023-07-18 16:50:14 +02:00
Roy-Orbison
a424d469b6
Enable regular expressions when searching data
...
Allows use of the database-specific regex operator and pattern syntax
when searching multiple tables.
2023-05-22 12:17:33 +09:30
Michal Paulovic
abe537dcd7
add unix_timestamp to functions for mysql
2022-11-15 10:16:09 +01:00
Benjamin Cremer
db01282e29
Use ST_SRID() in mysql driver for MySQL 8
...
`SRID()` is no longer available in MySQL 8 and has been replaced with `ST_SRID`
2021-05-23 09:45:55 +02:00
Jakub Vrana
af1a908f56
Unsubstite constants (PHP 5 is now required)
2021-02-23 12:42:11 +01:00
Jakub Vrana
e9e61fce26
MySQL: Allow moving views to other DB and renaming DB with views (bug #783 )
2021-02-12 11:49:35 +01:00
Jakub Vrana
5a1498d160
Use common code
2021-02-12 11:28:55 +01:00
Jakub Vrana
4038144c38
Add comments
2021-02-08 19:35:25 +01:00
Jakub Vrana
50ed4f7ce7
Prepare for moving drivers to plugins
2021-02-08 19:35:22 +01:00
Jakub Vrana
124092fd7c
MySQL 8: Fix EXPLAIN in SQL command
2021-02-08 12:26:51 +01:00
Jakub Vrana
19f23fe9ee
MySQL: Don't quote default value of text fields (bug #779 )
2021-02-07 09:31:31 +01:00
Jakub Vrana
b0a217abdd
Fix method call after #406
2020-12-06 13:45:55 +01:00
Jakub Vrana
5a507ec586
Don't overwrite variable
2019-11-11 13:40:47 +01:00
Jakub Vrana
a4e997fe60
PostgreSQL, Oracle: Set schema for EXPLAIN queries in SQL command (bug #706 )
2019-11-11 12:27:53 +01:00
Jakub Vrana
021e3f900d
Save bytes
2019-08-21 14:13:08 +02:00
Jakub Vrana
f692b6498f
MySQL: Support STORED GENERATED
2019-08-21 12:23:08 +02:00
Jakub Vrana
306e8733e7
Support MariaDB virtual columns
2019-08-19 18:38:57 +02:00
Jakub Vrana
67b84d1167
MySQL: Speed up displaying tables in large databases (bug #700 )
2019-08-19 18:29:05 +02:00
Malte Riesch
00d36efcf1
MySQL: Skip editing generated columns
2019-08-19 16:51:28 +02:00
Jakub Vrana
d5bf51b2a7
MySQL: Fix getting foreign keys
2019-07-18 08:50:52 +02:00
Jakub Vrana
36ade4e197
MySQL: Fix displaying multi-columns foreign keys (bug #675 )
2019-07-14 19:53:41 +02:00
grass@dionera.com
6a5b0abbb4
Check if PDO SSL Attributes are set within config, and only set them in PDO Options. otherwise Mysql PDO throws errors if attribute is set and empty
2019-07-14 19:20:13 +02:00
Dennis Stolmeijer
327041874e
Always pass the SRID part of a geometry property with the GeomFromText function
2019-05-18 17:24:35 +02:00
Jakub Vrana
deea21dd2d
Allow overwriting tables when copying them
2019-05-14 09:56:29 +02:00
Jakub Vrana
5bebb439a1
MySQL: Descending indexes in MySQL 8 (bug #643 )
2018-10-27 20:05:04 +02:00
Jakub Vrana
b327a76fc0
Avoid overwriting existing tables when copying tables (bug #642 )
2018-10-27 18:50:50 +02:00
Jared Brandt
e959e46fa5
Fixes foreign key pattern in MySQL
...
Foreign keys are not displaying in MySQL when ANSI_QUOTES is enabled because the preg_match_all() is looking specifically for backticks. This fix allows for double quotes as well, so foreign keys are recognized even when ANSI_QUOTES is enabled.
2018-07-15 20:51:09 +02:00
Jakub Vrana
c564a8ef50
MySQL: Disallow LOAD DATA LOCAL INFILE
2018-06-26 08:53:12 +02:00
Jakub Vrana
11f24a52e4
Order database names in MySQL 8(bug #613 )
2018-05-06 18:11:03 +02:00
Jakub Vrana
7b60b03e6a
Copy triggers when copying table
2018-05-06 17:36:52 +02:00
Jakub Vrana
665fafb297
Simplify running slow queries
2018-03-09 18:19:14 +01:00
Jakub Vrana
52d7c38ef1
MySQL: Use CONVERT() only when searching for non-ASCII (bug #603 )
2018-03-01 11:01:35 +01:00
Jakub Vrana
b1cdc7902b
Comment
2018-02-21 00:28:59 +01:00
Jakub Vrana
b4392b3f91
Use single \ in ' strings
2018-02-20 16:27:40 +01:00
Jakub Vrana
76d7560d27
MariaDB: Links to documentation
2018-02-08 13:56:22 +01:00
Jakub Vrana
cddd61c214
Add more system tables help links
2018-02-08 11:21:33 +01:00
Jakub Vrana
42eec7d728
Support connecting to MySQL via SSL
2018-02-07 12:13:58 +01:00
Jakub Vrana
d7f9b6b5de
PostgreSQL: Cast to string when searching using LIKE (bug #325 )
2018-02-06 13:51:53 +01:00
Jakub Vrana
197abdcb70
MySQL: Support non-utf8 charset in search in column
2018-02-06 13:51:23 +01:00
Jakub Vrana
c2de3b8ec1
Use ST_GeomFromText in MySQL 8 (bug #574 )
2018-02-06 13:50:40 +01:00
Jakub Vrana
6cfb3676a7
PostgreSQL: Don't treat interval type as number (bug #474 )
2018-02-06 12:17:01 +01:00
Jakub Vrana
7b0c58af32
Fix affected rows after getting warnings
2018-02-05 09:23:07 +01:00
Jakub Vrana
d3cdfc17de
Fix number of affected rows after getting warnings
2018-02-05 09:09:41 +01:00
Jakub Vrana
685bf29abc
Use separator in limit1
2018-02-01 18:53:53 +01:00
Jakub Vrana
52d98e16fa
PostgreSQL: Limit rows in data manipulation without unique key
2018-02-01 16:58:01 +01:00
Jakub Vrana
e55f0d7cb2
MySQL: Add FIND_IN_SET search operator
2018-02-01 15:25:38 +01:00
Jakub Vrana
6d55395d9e
MySQL: Add floor and ceil functions
2018-02-01 14:32:01 +01:00
Jakub Vrana
e9add6d985
Return string from warnings()
2018-02-01 11:43:44 +01:00
Jakub Vrana
2adc174541
MySQL: Display warnings in SQL command
2018-01-31 17:28:12 +01:00
