Comments (10)
Thanks for the report, I will take a look but it may be a few weeks before I get to this.
from firebird_fdw.
No problems, @ibarwick ! I'll try to prepare the smallest dataset for this issue. Surprisingly, this problem has nothing common with #13.
from firebird_fdw.
It may be interesting for comparation, https://github.com/pgspider/sqlite_fdw haven't issue for the same situation here discussed.
from firebird_fdw.
No problems, @ibarwick ! I'll try to prepare the smallest dataset for this issue. Surprisingly, this problem has nothing common with #13.
@mkgrgis Any chance of a dataset to reproduce this with? I hope to be able to take a look at this in the next few weeks.
from firebird_fdw.
Now there is only big dataset with 1345 rows from my first comment to this issue. I have some variants of mini datasets, but there is no errors. I'll make additional research to locate a problem.
from firebird_fdw.
Now there is only big dataset with 1345 rows from my first comment to this issue. I have some variants of mini datasets, but there is no errors. I'll make additional research to locate a problem.
Ah OK, I missed that attachment; that should be fine for now.
from firebird_fdw.
I have a version, error depends on a combination of cardinalities of objects in a plan of execution between DB's. All of my mini datasets (10..50 rows) haven't the error.
from firebird_fdw.
OK, I've finally had the time to work out what was causing this. The issue does not occur if the foreign table is analyzed; in this case a hash join is used. However, without any table statistics, the planner uses a merge join, which results in a rescan, which was not happening properly, leading to PostgreSQL only receiving a subset of the expected data. Fix is applied; I'll put out a new release in the next few days. Thanks once again for the report!
from firebird_fdw.
Thanks a lot, @ibarwick ! I have seen de5a02b My version of problem's source was wrong. Not only cardinality, but rescan in complex with merge join. I'll try to use Your new code next week and then can to write if it's correct for release.
from firebird_fdw.
Verified. Works fine, @ibarwick! My congratulations for You! No problems to make a new release if You want.
Now libfq doesn't support only generic BLOB and arrays. In my experience there was no BLOB's in Firebird. For C-language Firebird interface there is some common algorithms for BLOB and arrays. I saw that arrays in Firebird C-code likes to special implicit BLOBs, but i haven't use arrays. If You want, i will help with arrays.
from firebird_fdw.
Related Issues (20)
- Problems with quoted names of objects in Postgres and Firebird HOT 7
- Documentation not complete HOT 1
- IMPORT FOREIGN SCHEMA behaviour HOT 6
- Do not exist library/package to postgresql12-firebird_fdw HOT 3
- 1.2.0 build error HOT 1
- User survey - how and why do you you use firebird_fdw? And what features are missing? HOT 2
- Undocumented feature or access error in firebird_version function HOT 2
- PostgreSQL 14 support HOT 4
- Change libfq submodule link HOT 1
- Cannot load extension into PostgreSQL 15 - undefined symbol: pg_atoi HOT 6
- Failed to Import Table from Foreign Schema HOT 13
- Foreign server name quoting during IMPORT FOREIGN SCHEMA HOT 1
- 1.3.0 build error on Fedora 37 (and warning on RHEL 9) HOT 3
- Firebird array support
- Cannot load extension into PostgreSQL 15 and 14 - libfq-0.5.0.so HOT 1
- PostgreSQL 16 support HOT 4
- UUID support HOT 4
- Question: Option to Force Conversion of Strings to a Specific Charset HOT 3
- limit rows returned HOT 3
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 firebird_fdw.