Comments (4)
Fabio286
commented on August 17, 2024
Hi Robin,
thanks for this report. I'm trying to reproduce this bug with no luck.
Is the tab selected schema right?
The issue occurs on MySQL or PostgreSQL?
Could you provide me an sql dump with which I can reproduce the same conditions?
from antares.
raliqala
commented on August 17, 2024
Can you maybe post screenshots of the same query in antares and dbeaver. and what is ja
from antares.
UglyBlueCat
commented on August 17, 2024
I'm sorry; I'm unable to provide you with a dump.
ja is the results of the inner query
When joining tables you give them short codes to identify the fields in the first part of the select.
In this case jb.* is referring to all fields from aajobdetails and ja.ToCustomerID is referring to the CustomerID in the results returned by the inner query
I only logged this to help you, as I have other DB clients this works in, so you can close the case any time you like.
from antares.
Fabio286
commented on August 17, 2024
No problem Robin.
I made different tests with nested queries, also using alias for tables but I can't reproduce.
I keep this issue open in case other people face this issue and can provide more clues.
from antares.
Related Issues (20)
- [Feature Request] Simplified Process for Creating New Databases HOT 4
- Database change select doesn't work
- Include saved notes and query history in the import/export data HOT 1
- Copy - Paste Rows
- 🐞 Error when connect to CockroachDB HOT 5
- A javascript error occurred in the browser proccess HOT 3
- backUp HOT 1
- Should we separate the backend from the frontend in antares-sql? HOT 1
- Configuration Properties - Add multiples Schemas
- Database problem search HOT 1
- Console Log HOT 2
- rows count is very wrong when more then one time click HOT 1
- Importing plain text/CSV files HOT 1
- Materialized views in Postgres not shown HOT 1
- I can't connect to the Firebird database
- Add MSSQL Support to Antares HOT 2
- Release downloads version mismatch HOT 1
- Column Visibility, Import & File Explorer
- [MariaDB / MySQL] Error: Can't add new command when connection is in closed state HOT 1
- [Sqlite] Set: NotNull, Primary Key, ->AutoIncrement<- 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 antares.