Cant detect table

[Jackpump]

1. Which driver are you using and version of it (Ex: PostgreSQL 10.0): MySQL 5.5.61-38.13-log

2. Which TablePlus build number are you using (the number on the welcome screen, Ex: build 81): Version 3.8.4 (138) - x64

3. The steps to reproduce this issue:

• Connect to a server with a Main database
• Open new SQL Editor
• Query something in a Secondary database
• try to right click -> delete a record

Noted: If the bug is related to data, please attach an example SQL data.

[zaknesler]

Confirmed with SQLite 3.31.0 and TablePlus version 3.12.9 build 152 x64.

Example

Using SQL structure:

CREATE TABLE example_users (
    id INTEGER PRIMARY KEY NOT NULL,
    name VARCHAR(255) NOT NULL,
    UNIQUE(id)
);

And data:

INSERT INTO
    example_users (id, name)
VALUES
    (1, 'Alex'),
    (2, 'John'),
    (3, 'Sally'),
    (4, 'Sarah'),
    (5, 'James'),
    (6, 'Zak'),
    (7, 'Alice');

When running following statement:

SELECT * FROM example_users;

Any data that is edited results in the error

This occurs regardless of whether or not it is a child table or (as in this example) the main and only table being searched. This issue is not present using the same example on the latest Mac release of TablePlus.

Example database: example-database.zip

[Meekohi]

I'm having this problem on Version 3.12.20 (160), on Windows when connected to a MSSQL server -- seems new, haven't run into this before.

[sonswift]

Hi @Meekohi, could you please give me an example of your issue? I could not reproduce this issue on MSSQL Server. Thanks in advance.

[huyphams]

Hi guys, please install this patch and see how it goes: https://www.dropbox.com/s/eqztxlh2bai0lyd/TablePlusUpdate.exe?dl=0
Thanks

[GraemeAllanBryce]

Hi, This appears to still be an issue in the current release for Windows (Version 4.0.2 (168)) and not an issue on Mac for the same query.

We have trued the patch given by @huyphams but that does not appear to resolve the issue on the latest release.

[chrissyast]

Having the same issue on 4.2.12.

select t.*, a_t.foo from table t
inner join another_table a_t on a_t.id = t.another_table_id

In the resulting table make an edit to any column and the "Can't detect table" error comes up.

The exact same query (as I was using, the example isn't the actual query!) allowed me to make edits a few days ago but not today and AFAIK I haven't updated TablePlus

[Enigmaticall]

Any fix for this?

[AdnanCukur]

Same issue on MsSQL, seems to be an issue with lowercase/uppercase.

f.ex if my query is select id, name from productoffer where companyid = 1234 it won't work
but if my query is select Id, Name from ProductOffer where companyid = 1234 it works