Home / Browse / SQLAlchemy / Mail / Archive

Donate

SQLAlchemy

Email Archive: sqlalchemy-tickets (read-only)

2006:	_Jan	_Feb	_Mar (174)	_Apr (50)	_May (71)	_Jun (129)	_Jul (113)	_Aug (141)	_Sep (82)	_Oct (142)	_Nov (97)	_Dec (72)
2007:	_Jan (159)	_Feb (213)	_Mar (156)	_Apr (151)	_May (58)	_Jun (166)	_Jul (296)	_Aug (198)	_Sep (89)	_Oct (133)	_Nov (150)	_Dec (122)
2008:	_Jan (144)	_Feb (65)	_Mar (71)	_Apr (69)	_May (143)	_Jun (111)	_Jul (113)	_Aug (159)	_Sep (81)	_Oct (135)	_Nov (107)	_Dec (200)
2009:	_Jan (168)	_Feb (109)	_Mar (141)	_Apr (128)	_May (119)	_Jun (132)	_Jul (136)	_Aug (154)	_Sep (151)	_Oct (181)	_Nov (223)	_Dec (169)
2010:	_Jan (103)	_Feb (209)	_Mar (201)	_Apr (183)	_May (134)	_Jun (113)	_Jul (110)	_Aug (159)	_Sep (138)	_Oct (96)	_Nov (116)	_Dec (94)
2011:	_Jan (97)	_Feb (188)	_Mar (157)	_Apr (158)	_May (118)	_Jun (102)	_Jul (137)	_Aug (113)	_Sep (104)	_Oct (108)	_Nov (91)	_Dec (162)
2012:	_Jan (189)	_Feb (136)	_Mar (153)	_Apr (142)	_May (90)	_Jun (141)	_Jul (67)	_Aug (77)	_Sep (113)	_Oct (68)	_Nov (101)	_Dec (122)
2013:	_Jan (60)	_Feb (77)	_Mar (77)	_Apr (129)	_May (151)	_Jun	_Jul	_Aug	_Sep	_Oct	_Nov	_Dec

Re: [Sqlalchemy-tickets] [sqlalchemy] #805: bindparam support for LIMIT/OFFSET

From: sqlalchemy <mike_mp@zz...> - 2008-09-15 11:30

#805: bindparam support for LIMIT/OFFSET
----------------------------+-----------------------------------------------
    Reporter:  zzzeek       |       Owner:  zzzeek              
        Type:  enhancement  |      Status:  new                 
    Priority:  medium       |   Milestone:  0.5.xx              
   Component:  sql          |    Severity:  minor - half an hour
  Resolution:               |    Keywords:                      
Status_field:  in queue     |  
----------------------------+-----------------------------------------------
Changes (by zzzeek):

  * milestone:  0.4.xx => 0.5.xx

-- 
Ticket URL: <http://www.sqlalchemy.org/trac/ticket/805#comment:1>
sqlalchemy <http://www.sqlalchemy.org/>
The Database Toolkit for Python

Re: [Sqlalchemy-tickets] [sqlalchemy] #805: bindparam support for LIMIT/OFFSET

From: sqlalchemy <mike_mp@zz...> - 2009-11-02 23:28

#805: bindparam support for LIMIT/OFFSET
-----------------------------------------+----------------------------------
    Reporter:  zzzeek                    |       Owner:  zzzeek              
        Type:  enhancement               |      Status:  new                 
    Priority:  medium                    |   Milestone:  0.6.xx              
   Component:  sql                       |    Severity:  minor - half an hour
  Resolution:                            |    Keywords:                      
Status_field:  needs questions answered  |  
-----------------------------------------+----------------------------------
Changes (by zzzeek):

  * status_field:  in queue => needs questions answered
  * milestone:  0.5.xx => 0.6.xx

Comment:

 what databases support LIMIT/OFFSET as bind params ?  all ?  some ?

-- 
Ticket URL: <http://www.sqlalchemy.org/trac/ticket/805#comment:2>
sqlalchemy <http://www.sqlalchemy.org/>
The Database Toolkit for Python

Re: [Sqlalchemy-tickets] [sqlalchemy] #805: bindparam support for LIMIT/OFFSET

From: sqlalchemy <mike_mp@zz...> - 2010-03-20 00:37

#805: bindparam support for LIMIT/OFFSET
-------------------------+--------------------------------------------------
 Reporter:  zzzeek       |          Owner:  zzzeek           
     Type:  enhancement  |         Status:  new              
 Priority:  high         |      Milestone:  0.6.xx           
Component:  sql          |       Severity:  major - 1-3 hours
 Keywords:               |   Status_field:  in queue         
-------------------------+--------------------------------------------------
Changes (by zzzeek):

  * priority:  medium => high
  * severity:  minor - half an hour => major - 1-3 hours
  * status_field:  needs questions answered => in queue


Comment:

 I think we should move more aggressively in this direction to use binds
 for LIMIT/OFFSET as supported by the underlying DB.  We have greater
 capabilities now for binds/no binds in compiler so we should use them.

-- 
Ticket URL: <http://www.sqlalchemy.org/trac/ticket/805#comment:3>
sqlalchemy <http://www.sqlalchemy.org/>
The Database Toolkit for Python

Re: [Sqlalchemy-tickets] [sqlalchemy] #805: bindparam support for LIMIT/OFFSET

From: sqlalchemy <mike_mp@zz...> - 2010-03-27 17:34

#805: bindparam support for LIMIT/OFFSET
-------------------------+--------------------------------------------------
 Reporter:  zzzeek       |          Owner:  zzzeek           
     Type:  enhancement  |         Status:  new              
 Priority:  high         |      Milestone:  0.7.0            
Component:  sql          |       Severity:  major - 1-3 hours
 Keywords:               |   Status_field:  in queue         
-------------------------+--------------------------------------------------
Changes (by zzzeek):

  * milestone:  0.6.xx => 0.7.0


-- 
Ticket URL: <http://www.sqlalchemy.org/trac/ticket/805#comment:4>
sqlalchemy <http://www.sqlalchemy.org/>
The Database Toolkit for Python

Re: [Sqlalchemy-tickets] [sqlalchemy] #805: bindparam support for LIMIT/OFFSET

From: sqlalchemy <mike_mp@zz...> - 2010-03-27 17:35

#805: bindparam support for LIMIT/OFFSET
-------------------------+--------------------------------------------------
 Reporter:  zzzeek       |          Owner:  zzzeek           
     Type:  enhancement  |         Status:  new              
 Priority:  high         |      Milestone:  0.7.0            
Component:  sql          |       Severity:  major - 1-3 hours
 Keywords:               |   Status_field:  in queue         
-------------------------+--------------------------------------------------
Description changed by zzzeek:

Old description:

> this is only at the level of a select() statement, not ORM.

New description:



--

-- 
Ticket URL: <http://www.sqlalchemy.org/trac/ticket/805#comment:5>
sqlalchemy <http://www.sqlalchemy.org/>
The Database Toolkit for Python

Re: [Sqlalchemy-tickets] [sqlalchemy] #805: bindparam support for LIMIT/OFFSET

From: sqlalchemy <mike_mp@zz...> - 2010-08-29 20:37

#805: bindparam support for LIMIT/OFFSET
-------------------------+--------------------------------------------------
 Reporter:  zzzeek       |          Owner:  zzzeek           
     Type:  enhancement  |         Status:  new              
 Priority:  high         |      Milestone:  0.7.0            
Component:  sql          |       Severity:  major - 1-3 hours
 Keywords:               |   Status_field:  in progress      
-------------------------+--------------------------------------------------
Changes (by zzzeek):

  * status_field:  in queue => in progress


Comment:

 Initial patch is attached.  This is straightforward for most backends and
 all tests continue to pass.   The branch at
 http://bitbucket.org/zzzeek/limit_offset_binds will track merges for this
 patch until the tip becomes 0.7.

-- 
Ticket URL: <http://www.sqlalchemy.org/trac/ticket/805#comment:6>
sqlalchemy <http://www.sqlalchemy.org/>
The Database Toolkit for Python

Re: [Sqlalchemy-tickets] [sqlalchemy] #805: bindparam support for LIMIT/OFFSET

From: sqlalchemy <mike_mp@zz...> - 2010-12-08 04:37

#805: bindparam support for LIMIT/OFFSET
-------------------------+--------------------------------------------------
 Reporter:  zzzeek       |          Owner:  zzzeek           
     Type:  enhancement  |         Status:  new              
 Priority:  high         |      Milestone:  0.7.0            
Component:  sql          |       Severity:  major - 1-3 hours
 Keywords:               |   Status_field:  completed/closed 
-------------------------+--------------------------------------------------
Changes (by zzzeek):

  * status_field:  in progress => completed/closed


Comment:

 r944ced7f0d6b

-- 
Ticket URL: <http://www.sqlalchemy.org/trac/ticket/805#comment:7>
sqlalchemy <http://www.sqlalchemy.org/>
The Database Toolkit for Python

Re: [Sqlalchemy-tickets] [sqlalchemy] #805: bindparam support for LIMIT/OFFSET

From: sqlalchemy <mike_mp@zz...> - 2010-12-08 04:40

#805: bindparam support for LIMIT/OFFSET
---------------------------------+------------------------------------------
    Reporter:  zzzeek            |       Owner:  zzzeek           
        Type:  enhancement       |      Status:  closed           
    Priority:  high              |   Milestone:  0.7.0            
   Component:  sql               |    Severity:  major - 1-3 hours
  Resolution:  fixed             |    Keywords:                   
Status_field:  completed/closed  |  
---------------------------------+------------------------------------------
Changes (by zzzeek):

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


-- 
Ticket URL: <http://www.sqlalchemy.org/trac/ticket/805#comment:8>
sqlalchemy <http://www.sqlalchemy.org/>
The Database Toolkit for Python

Re: [Sqlalchemy-tickets] [sqlalchemy] #805: bindparam support for LIMIT/OFFSET

From: sqlalchemy <mike_mp@zz...> - 2011-12-24 13:45

#805: bindparam support for LIMIT/OFFSET
---------------------------------+------------------------------------------
    Reporter:  zzzeek            |       Owner:  zzzeek           
        Type:  enhancement       |      Status:  closed           
    Priority:  high              |   Milestone:  0.7.0            
   Component:  sql               |    Severity:  major - 1-3 hours
  Resolution:  fixed             |    Keywords:                   
Status_field:  completed/closed  |  
---------------------------------+------------------------------------------

Comment(by guest):

 With Oracle, see also #2116

-- 
Ticket URL: <http://www.sqlalchemy.org/trac/ticket/805#comment:9>
sqlalchemy <http://www.sqlalchemy.org/>
The Database Toolkit for Python