Re: [Django] #24637: get_constraints broke on newer version of sqlite.

[Django]

#24637: get_constraints broke on newer version of sqlite.
-+-
 Reporter:  dmrsearch|Owner:
 |  maestrofjp
 Type:  Bug  |   Status:  closed
Component:  Database layer   |  Version:  master
  (models, ORM)  |
 Severity:  Release blocker  |   Resolution:  fixed
 Keywords:   | Triage Stage:  Ready for
 |  checkin
Has patch:  1|  Needs documentation:  0
  Needs tests:  0|  Patch needs improvement:  0
Easy pickings:  0|UI/UX:  0
-+-

Comment (by Tim Graham ):

 In [changeset:"309142dba10e24557b67a2734aa67d56518c0b14" 309142d]:
 {{{
 #!CommitTicketReference repository=""
 revision="309142dba10e24557b67a2734aa67d56518c0b14"
 [1.8.x] Fixed #24637 -- Fixed database introspection with SQLite 3.8.9.

 Backport of f8e8853b51476af1cc75a229dadc990c9ccf45ec from master
 }}}

--
Ticket URL: 
Django 
The Web framework for perfectionists with deadlines.

-- 
You received this message because you are subscribed to the Google Groups 
"Django updates" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to django-updates+unsubscr...@googlegroups.com.
To post to this group, send email to django-updates@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/django-updates/067.7dd18f21f95c606636d95ce360590588%40djangoproject.com.
For more options, visit https://groups.google.com/d/optout.

Re: [Django] #24637: get_constraints broke on newer version of sqlite.

[Django]

#24637: get_constraints broke on newer version of sqlite.
-+-
 Reporter:  dmrsearch|Owner:
 |  maestrofjp
 Type:  Bug  |   Status:  closed
Component:  Database layer   |  Version:  master
  (models, ORM)  |
 Severity:  Release blocker  |   Resolution:  fixed
 Keywords:   | Triage Stage:  Ready for
 |  checkin
Has patch:  1|  Needs documentation:  0
  Needs tests:  0|  Patch needs improvement:  0
Easy pickings:  0|UI/UX:  0
-+-

Comment (by Tim Graham ):

 In [changeset:"d74903e4fb381576e5cb0cbfbd19555bcd255752" d74903e4]:
 {{{
 #!CommitTicketReference repository=""
 revision="d74903e4fb381576e5cb0cbfbd19555bcd255752"
 [1.7.x] Fixed #24637 -- Fixed database introspection with SQLite 3.8.9.

 Backport of f8e8853b51476af1cc75a229dadc990c9ccf45ec from master
 }}}

--
Ticket URL: 
Django 
The Web framework for perfectionists with deadlines.

-- 
You received this message because you are subscribed to the Google Groups 
"Django updates" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to django-updates+unsubscr...@googlegroups.com.
To post to this group, send email to django-updates@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/django-updates/067.c13bf346e906370e52a33d959fdd1a05%40djangoproject.com.
For more options, visit https://groups.google.com/d/optout.

Re: [Django] #24637: get_constraints broke on newer version of sqlite.

[Django]

#24637: get_constraints broke on newer version of sqlite.
-+-
 Reporter:  dmrsearch|Owner:
 |  maestrofjp
 Type:  Bug  |   Status:  closed
Component:  Database layer   |  Version:  master
  (models, ORM)  |
 Severity:  Release blocker  |   Resolution:  fixed
 Keywords:   | 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 Tim Graham ):

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


Comment:

 In [changeset:"f8e8853b51476af1cc75a229dadc990c9ccf45ec" f8e8853]:
 {{{
 #!CommitTicketReference repository=""
 revision="f8e8853b51476af1cc75a229dadc990c9ccf45ec"
 Fixed #24637 -- Fixed database introspection with SQLite 3.8.9.
 }}}

--
Ticket URL: 
Django 
The Web framework for perfectionists with deadlines.

-- 
You received this message because you are subscribed to the Google Groups 
"Django updates" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to django-updates+unsubscr...@googlegroups.com.
To post to this group, send email to django-updates@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/django-updates/067.3be8363a62f00f89a6b306cca105d3b6%40djangoproject.com.
For more options, visit https://groups.google.com/d/optout.

Re: [Django] #24637: get_constraints broke on newer version of sqlite.

[Django]

#24637: get_constraints broke on newer version of sqlite.
-+-
 Reporter:  dmrsearch|Owner:
 |  maestrofjp
 Type:  Bug  |   Status:  assigned
Component:  Database layer   |  Version:  master
  (models, ORM)  |
 Severity:  Release blocker  |   Resolution:
 Keywords:   | 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 charettes):

 * stage:  Accepted => Ready for checkin


--
Ticket URL: 
Django 
The Web framework for perfectionists with deadlines.

-- 
You received this message because you are subscribed to the Google Groups 
"Django updates" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to django-updates+unsubscr...@googlegroups.com.
To post to this group, send email to django-updates@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/django-updates/067.acf956025a6e6eacba839cc459e734e5%40djangoproject.com.
For more options, visit https://groups.google.com/d/optout.

Re: [Django] #24637: get_constraints broke on newer version of sqlite.

[Django]

#24637: get_constraints broke on newer version of sqlite.
-+-
 Reporter:  dmrsearch|Owner:
 |  maestrofjp
 Type:  Bug  |   Status:  assigned
Component:  Database layer   |  Version:  master
  (models, ORM)  |
 Severity:  Release blocker  |   Resolution:
 Keywords:   | Triage Stage:  Accepted
Has patch:  1|  Needs documentation:  0
  Needs tests:  0|  Patch needs improvement:  0
Easy pickings:  0|UI/UX:  0
-+-
Changes (by charettes):

 * version:  1.8 => master
 * stage:  Unreviewed => Accepted


--
Ticket URL: 
Django 
The Web framework for perfectionists with deadlines.

-- 
You received this message because you are subscribed to the Google Groups 
"Django updates" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to django-updates+unsubscr...@googlegroups.com.
To post to this group, send email to django-updates@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/django-updates/067.c7da499dd4463739193d85fb9206e317%40djangoproject.com.
For more options, visit https://groups.google.com/d/optout.

Re: [Django] #24637: get_constraints broke on newer version of sqlite.

[Django]

#24637: get_constraints broke on newer version of sqlite.
-+-
 Reporter:  dmrsearch|Owner:
 |  maestrofjp
 Type:  Bug  |   Status:  assigned
Component:  Database layer   |  Version:  1.8
  (models, ORM)  |
 Severity:  Release blocker  |   Resolution:
 Keywords:   | Triage Stage:
 |  Unreviewed
Has patch:  1|  Needs documentation:  0
  Needs tests:  0|  Patch needs improvement:  0
Easy pickings:  0|UI/UX:  0
-+-
Changes (by maestrofjp):

 * has_patch:  0 => 1


Comment:

 Patch is PR4494 on GH:

 https://github.com/django/django/pull/4494

--
Ticket URL: 
Django 
The Web framework for perfectionists with deadlines.

-- 
You received this message because you are subscribed to the Google Groups 
"Django updates" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to django-updates+unsubscr...@googlegroups.com.
To post to this group, send email to django-updates@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/django-updates/067.5097d2272e5f4488aa7d765c5237351c%40djangoproject.com.
For more options, visit https://groups.google.com/d/optout.

Re: [Django] #24637: get_constraints broke on newer version of sqlite.

[Django]

#24637: get_constraints broke on newer version of sqlite.
-+-
 Reporter:  dmrsearch|Owner:
 |  maestrofjp
 Type:  Bug  |   Status:  assigned
Component:  Database layer   |  Version:  1.8
  (models, ORM)  |
 Severity:  Release blocker  |   Resolution:
 Keywords:   | Triage Stage:
 |  Unreviewed
Has patch:  0|  Needs documentation:  0
  Needs tests:  0|  Patch needs improvement:  0
Easy pickings:  0|UI/UX:  0
-+-
Changes (by maestrofjp):

 * status:  new => assigned
 * owner:  nobody => maestrofjp


Comment:

 I have a PR in progress that works for both behaviors.

--
Ticket URL: 
Django 
The Web framework for perfectionists with deadlines.

-- 
You received this message because you are subscribed to the Google Groups 
"Django updates" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to django-updates+unsubscr...@googlegroups.com.
To post to this group, send email to django-updates@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/django-updates/067.60e57b68f7b83a385cdfff615b4de1d5%40djangoproject.com.
For more options, visit https://groups.google.com/d/optout.

Re: [Django] #24637: get_constraints broke on newer version of sqlite.

[Django]

#24637: get_constraints broke on newer version of sqlite.
-+-
 Reporter:  dmrsearch|Owner:  nobody
 Type:  Bug  |   Status:  new
Component:  Database layer   |  Version:  1.8
  (models, ORM)  |
 Severity:  Release blocker  |   Resolution:
 Keywords:   | Triage Stage:
 |  Unreviewed
Has patch:  0|  Needs documentation:  0
  Needs tests:  0|  Patch needs improvement:  0
Easy pickings:  0|UI/UX:  0
-+-

Comment (by maestrofjp):

 The original reporter was on OSX as I helped him with this is at PyCon
 Sprints.  I can confirm that upgrading from Sqlite3 3.8.2 to 3.8.9 on
 Ubuntu 14 causes the above issue.  This issue is reproducible.  Sqlite
 3.8.9 was released on April 8, 2015.  I had to install it from source on
 Ubuntu.

--
Ticket URL: 
Django 
The Web framework for perfectionists with deadlines.

-- 
You received this message because you are subscribed to the Google Groups 
"Django updates" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to django-updates+unsubscr...@googlegroups.com.
To post to this group, send email to django-updates@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/django-updates/067.374055a469994ebaa4247b94687d4f2f%40djangoproject.com.
For more options, visit https://groups.google.com/d/optout.

Re: [Django] #24637: get_constraints broke on newer version of sqlite.

[Django]

#24637: get_constraints broke on newer version of sqlite.
-+-
 Reporter:  dmrsearch|Owner:  nobody
 Type:  Bug  |   Status:  new
Component:  Database layer   |  Version:  1.8
  (models, ORM)  |
 Severity:  Release blocker  |   Resolution:
 Keywords:   | Triage Stage:
 |  Unreviewed
Has patch:  0|  Needs documentation:  0
  Needs tests:  0|  Patch needs improvement:  0
Easy pickings:  0|UI/UX:  0
-+-

Comment (by maestrofjp):

 The new version of 3.8.9 returns 5 columns while we are relying that is
 only has 3 columns.

--
Ticket URL: 
Django 
The Web framework for perfectionists with deadlines.

-- 
You received this message because you are subscribed to the Google Groups 
"Django updates" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to django-updates+unsubscr...@googlegroups.com.
To post to this group, send email to django-updates@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/django-updates/067.66daaea7b07a070911b950c7ad170adf%40djangoproject.com.
For more options, visit https://groups.google.com/d/optout.

Re: [Django] #24637: get_constraints broke on newer version of sqlite.

[Django]

#24637: get_constraints broke on newer version of sqlite.
-+-
 Reporter:  dmrsearch|Owner:  nobody
 Type:  Bug  |   Status:  new
Component:  Database layer   |  Version:  1.8
  (models, ORM)  |
 Severity:  Release blocker  |   Resolution:
 Keywords:   | Triage Stage:
 |  Unreviewed
Has patch:  0|  Needs documentation:  0
  Needs tests:  0|  Patch needs improvement:  0
Easy pickings:  0|UI/UX:  0
-+-

Comment (by maestrofjp):

 It appears that database.index_list() in sqlite3 has changed:

 Current documentation for the latest release 3.8.9:
 http://www.sqlite.org/pragma.html#pragma_index_list

 Older documentation (don't know which version exactly but shows what
 Django is relying on):
 https://www.safaribooksonline.com/library/view/using-
 sqlite/9781449394592/re183.html

--
Ticket URL: 
Django 
The Web framework for perfectionists with deadlines.

-- 
You received this message because you are subscribed to the Google Groups 
"Django updates" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to django-updates+unsubscr...@googlegroups.com.
To post to this group, send email to django-updates@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/django-updates/067.02740f5fb21474c493ac4c042f0a9eb8%40djangoproject.com.
For more options, visit https://groups.google.com/d/optout.

Re: [Django] #24637: get_constraints broke on newer version of sqlite.

[Django]

#24637: get_constraints broke on newer version of sqlite.
-+-
 Reporter:  dmrsearch|Owner:  nobody
 Type:  Bug  |   Status:  new
Component:  Database layer   |  Version:  1.8
  (models, ORM)  |
 Severity:  Release blocker  |   Resolution:
 Keywords:   | Triage Stage:
 |  Unreviewed
Has patch:  0|  Needs documentation:  0
  Needs tests:  0|  Patch needs improvement:  0
Easy pickings:  0|UI/UX:  0
-+-
Changes (by maestrofjp):

 * cc: maestrofjp (added)
 * needs_better_patch:   => 0
 * needs_tests:   => 0
 * needs_docs:   => 0


--
Ticket URL: 
Django 
The Web framework for perfectionists with deadlines.

-- 
You received this message because you are subscribed to the Google Groups 
"Django updates" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to django-updates+unsubscr...@googlegroups.com.
To post to this group, send email to django-updates@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/django-updates/067.b36a41ab346269c7bef849f23420c32e%40djangoproject.com.
For more options, visit https://groups.google.com/d/optout.

[Django] #24637: get_constraints broke on newer version of sqlite.

[Django]

#24637: get_constraints broke on newer version of sqlite.
--+
 Reporter:  dmrsearch |  Owner:  nobody
 Type:  Bug   | Status:  new
Component:  Database layer (models, ORM)  |Version:  1.8
 Severity:  Release blocker   |   Keywords:
 Triage Stage:  Unreviewed|  Has patch:  0
Easy pickings:  0 |  UI/UX:  0
--+
 Running the test suite with the latest version of sqlite "3.8.9" gives the
 following error.The way sqlite brings back constraints change between
 the two versions.

 {{{
 ERROR: test_unique_together_meta (inspectdb.tests.InspectDBTestCase)
 --
 Traceback (most recent call last):
   File "/Users/sthompso/PycharmProjects/django/tests/inspectdb/tests.py",
 line 225, in test_unique_together_meta
 stdout=out)
   File
 "/Users/sthompso/PycharmProjects/django/django/core/management/__init__.py",
 line 118, in call_command
 return command.execute(*args, **defaults)
   File
 "/Users/sthompso/PycharmProjects/django/django/core/management/base.py",
 line 398, in execute
 output = self.handle(*args, **options)
   File
 
"/Users/sthompso/PycharmProjects/django/django/core/management/commands/inspectdb.py",
 line 25, in handle
 for line in self.handle_inspection(options):
   File
 
"/Users/sthompso/PycharmProjects/django/django/core/management/commands/inspectdb.py",
 line 69, in handle_inspection
 constraints = connection.introspection.get_constraints(cursor,
 table_name)
   File
 
"/Users/sthompso/PycharmProjects/django/django/db/backends/sqlite3/introspection.py",
 line 242, in get_constraints
 for number, index, unique in cursor.fetchall():
 ValueError: too many values to unpack
 }}}

--
Ticket URL: 
Django 
The Web framework for perfectionists with deadlines.

-- 
You received this message because you are subscribed to the Google Groups 
"Django updates" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to django-updates+unsubscr...@googlegroups.com.
To post to this group, send email to django-updates@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/django-updates/052.f656fb16ef8b7c859da37e8db42aca47%40djangoproject.com.
For more options, visit https://groups.google.com/d/optout.