Comments (6)
Hi @DavidBuch1,
You are talking about this issue - #202?
from mysql_fdw.
hi. Yes.. looks similar to my issue, but I cant see how to get past it.
note, we are running on ubuntu 22.04, so this is not a windows or mac issue.
I have tried to force mariadb to store lowercase, but it doesnt take the setting, and seems to alwasy remain at 0
from mysql_fdw.
Okay. Can you please just share a simple reproducible test case from your end? How do you create a mixed case table on MySQL, value of lower_case_table_names, and IMPORT FOREIGN SCHEMA command tried at your end?
from mysql_fdw.
Hi
Sure:
SHOW GLOBAL VARIABLES LIKE 'lower_case_table_names'; value 0
setting in conf files
[mysqld]
lower_case_table_names=2
Mysql/Mariadb tables
CREATE TABLE debugLog
(
id
int(11) NOT NULL AUTO_INCREMENT,
routine
varchar(255) DEFAULT NULL,
line
int(11) DEFAULT NULL,
debugMsg
varchar(1000) DEFAULT NULL,
isError
int(11) DEFAULT NULL,
createdDate
datetime DEFAULT current_timestamp(),
PRIMARY KEY (id
)
) ENGINE=InnoDB AUTO_INCREMENT=4265468 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
and from postgres
IMPORT FOREIGN SCHEMA xld
FROM SERVER xld_bridge
INTO imports;
all the lowercase tables import, but examples like the above dont.
its not practical to make them all lowercase, as there so many dependencies
from mysql_fdw.
Thanks for sharing the test case.
I tried the same at my end and it is working fine. I am using MySQL 8 at my end.
mysql> CREATE TABLE debugLog (
-> id int(11) NOT NULL AUTO_INCREMENT,
-> routine varchar(255) DEFAULT NULL,
-> line int(11) DEFAULT NULL,
-> debugMsg varchar(1000) DEFAULT NULL,
-> isError int(11) DEFAULT NULL,
-> createdDate datetime DEFAULT current_timestamp(),
-> PRIMARY KEY (id)
-> ) ENGINE=InnoDB AUTO_INCREMENT=4265468 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
Query OK, 0 rows affected, 3 warnings (0.01 sec)
mysql>
mysql>
mysql> SHOW GLOBAL VARIABLES LIKE 'lower_case_table_names';
+------------------------+-------+
| Variable_name | Value |
+------------------------+-------+
| lower_case_table_names | 0 |
+------------------------+-------+
1 row in set (0.00 sec)
Postgres:
edb@44896=#IMPORT FOREIGN SCHEMA s2 FROM SERVER mysql_server into s2;
IMPORT FOREIGN SCHEMA
edb@44896=#
edb@44896=#\d s2.*
Foreign table "s2.debugLog"
Column | Type | Collation | Nullable | Default | FDW options
-------------+-----------------------------+-----------+----------+---------+-------------
id | integer | | not null | |
routine | character varying(255) | | | |
line | integer | | | |
debugMsg | character varying(1000) | | | |
isError | integer | | | |
createdDate | timestamp without time zone | | | |
Server: mysql_server
FDW options: (dbname 's2', table_name 'debugLog')
Can you please verify the same at your end once? From your update, I can see that you are using mariadb, if possible test the same on MySQL just to rule out the possibility of mariadb specific issue.
from mysql_fdw.
from mysql_fdw.
Related Issues (20)
- cannot install on Ubuntu 22.04 HOT 1
- Failing to install mysql_fdw HOT 8
- Getting error while installing pgvector extension to PostgreSQL in windows using the pgvector source repository HOT 3
- During push-down insert, the precision of numeric type fields is lost. HOT 1
- MySQL type YEAR is not supported HOT 4
- trigger not firing on foreign table HOT 9
- How can I Disable PREPARED-STATEMENT for SELECT statement? HOT 1
- ERROR: failed to load the mysql query: (null) HINT: Export LD_LIBRARY_PATH to locate the library in PostgreSQL 16 on Rocky Linux 8 HOT 9
- Segmentation fault w/ dual left join is null HOT 4
- [Feature request] Support Subquery pushdown
- Truncating casts are not pushed down correctly HOT 2
- bytes after ` `(0x02 0x01 0x00) get truncated in column with type `text`
- cannot `UPDATE` or `DELETE` on fdw foreign table that inherits pgsql table HOT 1
- Unable to install the extension HOT 7
- Trouble downloading mysql_fdw
- Import Schema should convert/map MySQL tinyint(1) to PG boolean. HOT 2
- Unable to install the extensions HOT 5
- make: *** No targets specified and no makefile found. Stop. HOT 2
- create extensions failed HOT 1
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from mysql_fdw.