Re: [Django] #34799: inspectdb fails on tables with cross-schema relations on MySQL.

17 views
Skip to first unread message

Django

unread,
Aug 26, 2023, 10:17:28 AM8/26/23
to django-...@googlegroups.com
#34799: inspectdb fails on tables with cross-schema relations on MySQL.
-------------------------------------+-------------------------------------
Reporter: John Whitman | Owner: nobody
Type: Bug | Status: new
Component: Database layer | Version: 4.1
(models, ORM) |
Severity: Normal | Resolution:
Keywords: inspectdb | Triage Stage: Accepted
Has patch: 0 | Needs documentation: 0
Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------
Changes (by Mariusz Felisiak):

* stage: Unreviewed => Accepted


--
Ticket URL: <https://code.djangoproject.com/ticket/34799#comment:2>
Django <https://code.djangoproject.com/>
The Web framework for perfectionists with deadlines.

Django

unread,
Aug 28, 2023, 3:31:42 PM8/28/23
to django-...@googlegroups.com
#34799: inspectdb fails on tables with cross-schema relations on MySQL.
-------------------------------------+-------------------------------------
Reporter: John Whitman | Owner: nobody
Type: Bug | Status: new
Component: Database layer | Version: 4.1
(models, ORM) |
Severity: Normal | Resolution:
Keywords: inspectdb | Triage Stage: Accepted
Has patch: 0 | Needs documentation: 0
Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------

Comment (by John Whitman):

Created a PR with a test that exercises the issue if the DB connection is
MySQL. One quick note: the test assumes the connection's user can CREATE
TABLE on both the "default" and "other" databases (unsure if that's a safe
assumption outside of the settings I linked in the PR).
https://github.com/django/django/pull/17205

--
Ticket URL: <https://code.djangoproject.com/ticket/34799#comment:3>

Django

unread,
Aug 28, 2023, 3:31:47 PM8/28/23
to django-...@googlegroups.com
#34799: inspectdb fails on tables with cross-schema relations on MySQL.
-------------------------------------+-------------------------------------
Reporter: John Whitman | Owner: nobody
Type: Bug | Status: new
Component: Database layer | Version: 4.1
(models, ORM) |
Severity: Normal | Resolution:
Keywords: inspectdb | Triage Stage: Accepted
Has patch: 1 | Needs documentation: 0

Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------
Changes (by John Whitman):

* has_patch: 0 => 1


--
Ticket URL: <https://code.djangoproject.com/ticket/34799#comment:4>

Django

unread,
Aug 29, 2023, 5:54:23 AM8/29/23
to django-...@googlegroups.com
#34799: inspectdb fails on tables with cross-schema relations on MySQL.
-------------------------------------+-------------------------------------
Reporter: John Whitman | Owner: John
| Whitman
Type: Bug | Status: assigned

Component: Database layer | Version: 4.1
(models, ORM) |
Severity: Normal | Resolution:
Keywords: inspectdb | Triage Stage: Accepted
Has patch: 1 | Needs documentation: 0
Needs tests: 1 | Patch needs improvement: 1

Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------
Changes (by Mariusz Felisiak):

* owner: nobody => John Whitman
* needs_better_patch: 0 => 1
* status: new => assigned
* needs_tests: 0 => 1


--
Ticket URL: <https://code.djangoproject.com/ticket/34799#comment:5>

Django

unread,
Aug 30, 2023, 6:48:06 AM8/30/23
to django-...@googlegroups.com
#34799: inspectdb fails on tables with cross-schema relations on MySQL.
-------------------------------------+-------------------------------------
Reporter: John Whitman | Owner: John
| Whitman
Type: Bug | Status: assigned
Component: Database layer | Version: 4.1
(models, ORM) |
Severity: Normal | Resolution:
Keywords: inspectdb | Triage Stage: Ready for
| checkin

Has patch: 1 | Needs documentation: 0
Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------
Changes (by Mariusz Felisiak):

* needs_better_patch: 1 => 0
* needs_tests: 1 => 0
* stage: Accepted => Ready for checkin


--
Ticket URL: <https://code.djangoproject.com/ticket/34799#comment:6>

Django

unread,
Aug 30, 2023, 8:17:43 AM8/30/23
to django-...@googlegroups.com
#34799: inspectdb fails on tables with cross-schema relations on MySQL.
-------------------------------------+-------------------------------------
Reporter: John Whitman | Owner: John
| Whitman
Type: Bug | Status: closed

Component: Database layer | Version: 4.1
(models, ORM) |
Severity: Normal | Resolution: fixed

Keywords: inspectdb | Triage Stage: Ready for
| checkin
Has patch: 1 | Needs documentation: 0
Needs tests: 0 | Patch needs improvement: 0
Easy pickings: 0 | UI/UX: 0
-------------------------------------+-------------------------------------
Changes (by Mariusz Felisiak <felisiak.mariusz@…>):

* status: assigned => closed
* resolution: => fixed


Comment:

In [changeset:"68a8996bdfce2d191decd7b1c1a2b9fdea8e4b2f" 68a8996b]:
{{{
#!CommitTicketReference repository=""
revision="68a8996bdfce2d191decd7b1c1a2b9fdea8e4b2f"
Fixed #34799 -- Made MySQL introspection skip cross-database relations.
}}}

--
Ticket URL: <https://code.djangoproject.com/ticket/34799#comment:7>

Reply all
Reply to author
Forward
0 new messages