Jakub Vrana
1e4fb073b5
MongoDB: Display Authentication failed instead of exception
2021-02-09 11:04:10 +01:00
Jakub Vrana
7a89b5a037
PostgreSQL: Fix displaying NULL bytea fields
2021-02-09 10:08:27 +01:00
Takashi SHIRAI
c5b5b61be1
Avoid errors about 'view_trigger'
...
Signed-off-by: Takashi SHIRAI <shirai@nintendo.co.jp>
2021-02-09 09:57:29 +01:00
Takashi SHIRAI
2b0ac4c0e1
Support unprivileged users for schema list
...
Signed-off-by: Takashi SHIRAI <shirai@nintendo.co.jp>
2021-02-09 09:57:29 +01:00
Takashi SHIRAI
ef53494df0
Support altering indexes
...
Signed-off-by: Takashi SHIRAI <shirai@nintendo.co.jp>
2021-02-09 09:57:27 +01:00
Takashi SHIRAI
98458f737d
Avoid errors when alter table column
...
Signed-off-by: Takashi SHIRAI <shirai@nintendo.co.jp>
2021-02-09 09:57:00 +01:00
Takashi SHIRAI
68edea54ea
Avoid errors about auto increment
...
Signed-off-by: Takashi SHIRAI <shirai@nintendo.co.jp>
2021-02-09 09:57:00 +01:00
Takashi SHIRAI
6660789d04
Support granted table to list up indexes
...
Signed-off-by: Takashi SHIRAI <shirai@nintendo.co.jp>
2021-02-09 09:57:00 +01:00
Takashi SHIRAI
ee4ffe9b65
Correct column size with string type
...
Signed-off-by: Takashi SHIRAI <shirai@nintendo.co.jp>
2021-02-09 09:56:55 +01:00
Takashi SHIRAI
27de0417fe
Sort the DB list
...
Signed-off-by: Takashi SHIRAI <shirai@nintendo.co.jp>
2021-02-09 09:42:23 +01:00
Takashi SHIRAI
339981b9d6
Support importing table data
...
Signed-off-by: Takashi SHIRAI <shirai@nintendo.co.jp>
2021-02-09 09:42:18 +01:00
Takashi SHIRAI
53a8496412
The table with another scheme is deleted from the table list
...
Signed-off-by: Takashi SHIRAI <shirai@nintendo.co.jp>
2021-02-09 09:38:47 +01:00
Takashi SHIRAI
fb38ae2ffd
Support computing DB infos
...
Signed-off-by: Takashi SHIRAI <shirai@nintendo.co.jp>
2021-02-09 09:24:26 +01:00
salacr
91da14b15c
PostgreSQL: Do not show triggers from other schemas
2021-02-09 08:59:06 +01:00
Jakub Vrana
51abdcdab9
SimpleDB, Firebird, ClickHouse: Move to plugin
2021-02-08 19:56:15 +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
e915f73f18
PostgreSQL: Fix multi-parameter functions in default values (bug #736 )
2021-02-08 16:23:36 +01:00
Jakub Vrana
701c5cd73b
Fix whitespace
2021-02-08 15:50:02 +01:00
Jakub Vrana
2bb472d7a6
PostgreSQL: Avoid exporting empty sequence last value
2021-02-08 14:12:39 +01:00
Jakub Vrana
9e74c0632f
PostgreSQL: Create PRIMARY KEY for auto increment columns
2021-02-08 14:00:38 +01:00
Jakub Vrana
124092fd7c
MySQL 8: Fix EXPLAIN in SQL command
2021-02-08 12:26:51 +01:00
Peter Knut
922e1d96b0
Fix displaying type mapping for Elasticsearch >= 6.0
...
Earlier versions of Elasticsearch (<= 5) supported multiple types per index. That meant that you could have different data mappings for each type. With Elasticsearch 6, this was removed and you can only have single mapping type.
2021-02-07 13:24:03 +01:00
Jakub Vrana
52defd6f19
MongoDB: Prefer modern extension
2021-02-07 13:09:09 +01:00
ImDong
318cece1bd
Fix MongoDB connect 'Database does not support password.' tips
...
Add MongoDB Drivers func ping.
2021-02-07 13:08:29 +01:00
Josef Drabek
8c392363b1
Postgres - fix missing partitioned tables in navigation
2021-02-07 11:21:50 +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
cde988853d
SQLite: Set busy_timeout to 500
2021-02-06 18:01:39 +01:00
Jakub Vrana
f8288dd227
PostgreSQL 11: Create PRIMARY KEY for auto increment columns
2021-02-06 18:01:24 +01:00
Jakub Vrana
94194aac19
PostgreSQL: Support smallserial
2021-02-06 18:00:22 +01:00
Jakub Vrana
7edf80f636
PostgreSQL PDO: Support PgBouncer, unsupport PostgreSQL < 9.1 (bug #771 )
2021-02-06 16:45:20 +01:00
Jakub Vrana
23fdbedba1
PostgreSQL: Use bigserial for bigint auto increment (bug #765 , regression from 3.0.0)
2021-02-06 15:33:50 +01:00
Michal Adamec
8762895bb3
MSSQL: Don't trucate displayed comments to 30 chars (use varchar maximum of 8000 upon casting)
2021-02-06 14:52:26 +01:00
Oliver Tušla
1ce0a9aa94
show correct collation for PostgresSQL
2021-02-06 14:15:32 +01:00
Ivan Masár
96be913994
PostgreSQL: Fix current schema in view definition
2021-02-06 14:03:59 +01:00
Sartor
5cab8eabb7
Fix PgSQL generated always as identity fix
2021-02-06 12:18:27 +01:00
Ivan Masár
34345d8071
PostgreSQL: Export all FKs after all CREATE TABLE
2021-02-06 11:37:47 +01:00
Jakub Vrana
ccd2374b0b
Elasticsearch, ClickHouse: Do not print response if HTTP code is not 200
...
Thanks to Adam Crosser and Brian Sizemore
2021-02-06 10:45:56 +01:00
Jakub Vrana
b0a217abdd
Fix method call after #406
2020-12-06 13:45:55 +01:00
Jakub Vrana
d94adc09cc
Fix style
2020-12-06 12:53:27 +01:00
Jakub Vrana
ad16cb8581
PostgreSQL: Support exporting views
2020-01-30 17:13:50 +01:00
Mike Baranski
c7550bf68f
Stop using adsrc column
...
Was removed in V12, invalid since V8.
See https://www.postgresql.org/docs/8.3/catalog-pg-attrdef.html
2019-11-11 14:19:39 +01:00
Vladimir Goncharov
6ae81cd0ea
fixed: SQL command for insert, create table, etc. new: create/rename table, add/drop/change type for column
2019-11-11 14:11:49 +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
František Hána
34a0bfd939
setup Mongo authSource by ENV
2019-08-22 09:43:46 +02:00
Jakub Vrana
03961bbe1b
MS SQL: Support foreign keys to other DB
2019-08-21 14:33:17 +02: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
3b056fe308
SQLite: Skip renaming when recreating table if not necessary
2019-08-21 12:06:32 +02:00
Jakub Vrana
d6ec4ca0b3
SQLite: Preserve auto increment when recreating table
2019-08-21 11:54:07 +02:00
Jakub Vrana
903de0e889
SQLite: Allow setting auto increment for empty tables
2019-08-21 11:46:38 +02:00
Jakub Vrana
48f33f6255
Remove extra space in alter table command
2019-08-21 11:28:33 +02:00
Jakub Vrana
1b33729110
SQLite: Handle error in altering table (bug #697 )
2019-08-21 11:21:17 +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
b7b4157bcb
Fix table status in PostgreSQL 12 (bug #683 )
2019-07-15 13:37:10 +02:00
Jakub Vrana
45caae1660
PostgreSQL: Display definitions of materialized views (bug #682 )
2019-07-15 13:03:57 +02:00
Michal Adamec
36e9a4d6e1
Support for viewing and editing of column comments in mssql driver
2019-07-15 12:45:39 +02:00
Jakub Vrana
9b58ecf925
PostgreSQL: Fix setting column comments on new table
2019-07-15 12:21:17 +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
Bohuslav Simek
33234fef19
Elasticsearch: Show executed query as a json
2019-07-14 19:11:17 +02:00
Bohuslav Simek
4b6833ba65
MongoDB: number of records should be count on provide rows
2019-07-14 19:10:16 +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
Tim Düsterhus
a2fbcbe28e
Fix PHP 7.3 compatibility ( #318 )
2018-12-18 16:17:21 +01:00
helix84
da76e6b9b8
php <5.4 compat: array syntax ( #313 )
2018-12-18 14:21:23 +01:00
Jakub Vrana
e148db4b0f
Fix whitespace
2018-11-24 12:16:12 +01:00
Jakub Vrana
e546b483a1
Delete copy/pasted code
2018-10-29 11:43:45 +01:00
Jakub Vrana
5bebb439a1
MySQL: Descending indexes in MySQL 8 (bug #643 )
2018-10-27 20:05:04 +02:00
sartor
9f0ee9cf41
PostgreSQL: Support for GENERATED BY DEFAULT AS IDENTITY
2018-10-27 19:42:01 +02:00
Jakub Vrana
c002009bfe
Fix style
2018-10-27 19:38:43 +02:00
sartor
a592ad52f1
ClickHouse: support for decimal types, SQL operator
2018-10-27 19:32:52 +02:00
sartor
3127c0d95e
ClickHouse: Fix for drop multiple tables and views
2018-10-27 19:32:10 +02:00
sartor
9447d97a6a
ClickHouse ALTER DELETE and ALTER UPDATE support
2018-10-27 19:31:35 +02:00
sartor
c8e41ee649
ClickHouse fix select-like queries format postfix
2018-10-27 19:30:33 +02:00
Jakub Vrana
b327a76fc0
Avoid overwriting existing tables when copying tables (bug #642 )
2018-10-27 18:50:50 +02:00
Jakub Vrana
7f2dd73670
PostgreSQL: Export DESC indexes (bug #639 )
2018-10-27 18:14:00 +02:00
Jakub Vrana
a426fefd40
Remove unused code
2018-09-19 11:16:21 +02:00
Jakub Vrana
0234fe4a66
ClickHouse: Fix escaping
2018-09-18 13:13:34 +02:00
Sartor
1883e250ff
ClickHouse support alpha version
2018-09-18 13:09:46 +02:00
harryxu
94f6a45a2a
Set default db to sqlsrv connection
2018-09-18 11:44:02 +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
26a39ac243
Revert "PgSQL search operator "SQL" added"
...
This reverts commit af7ac6f06a
.
2018-06-27 22:23:56 +02:00
Jakub Vrana
c564a8ef50
MySQL: Disallow LOAD DATA LOCAL INFILE
2018-06-26 08:53:12 +02:00
Gintautas Miselis
b98d0bcc55
mssql: ignore serverproperty error
...
This change allows connection to Sybase ASE 15
2018-06-09 12:25:24 +02:00
Jakub Vrana
e856e28892
Add spaces
2018-06-09 12:24:18 +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
84c65fcca6
MS SQL: Support port with sqlsrc
2018-05-06 11:46:36 +02:00
Jakub Vrana
733fe9e430
PostgreSQL: Do not cast uuid searches to text (bug #608 )
2018-05-06 11:41:59 +02:00
Jakub Vrana
60d1b7b3b4
Disallow using password-less databases
2018-05-04 16:52:41 +02:00
Jakub Vrana
db11fa4c1a
MongoDB: Consolidate code
2018-05-04 16:39:21 +02:00
Jakub Vrana
c3cfc0e69b
MongoDB: Consolidate code
2018-05-04 16:38:24 +02:00
Jakub Vrana
5f4d407f2e
MongoDB: Consolidate code
2018-05-04 16:37:36 +02:00
Jakub Vrana
70afe70b72
MongoDB: Report version
2018-05-04 15:37:29 +02:00
Jakub Vrana
75f43a4454
Document that Elasticsearch requires allow_url_fopen
2018-05-04 15:26:57 +02:00