Comments (2)
I have fixed the issue. I will push the fix after some testing.
Currently working on regression test cases so don't want to push anything
before the comprehensive test cases.
On Wed, Nov 12, 2014 at 8:04 PM, Andrew Mullins [email protected]
wrote:
Trying to execute a simple query that contains an IN clause.
SELECT * FROM mysql_driver WHERE id IN (1,2,3)
This is the error I'm receiving:
ERROR: failed to execute the MySQL query:
You have an error in your SQL syntax; check the manual that corresponds to
your MySQL server version for the right syntax to use near ''{1,2,3}')))'
at line 1If I retrieve the ids with a subquery, it works.
SELECT * FROM mysql_driver WHERE id IN (SELECT id FROM mysql_driver WHERE id < 4)
—
Reply to this email directly or view it on GitHub
#23.
Ibrar Ahmed
EnterpriseDB http://www.enterprisedb.com
from mysql_fdw.
I pushed a fix along with the test cases. "NOT IN" with sub-select will not work. I have created a new case for that and will push the fix for that ASAP.
Isseue: #24 "NOT IN with Sub-select is not working"
from mysql_fdw.
Related Issues (20)
- [Feature request] my.cnf as user credential store HOT 1
- doris-database error-based prompt Unsupported command (COM _ STMT _ PREPARE) , HOT 4
- MySQL's TIMESTAMP support HOT 3
- Support primary key not in first column HOT 1
- 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
- IMPORT FOREIGN SCHEMA not importing mixed case tables HOT 6
- 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
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.