| 1 | | Replying to [ticket:24040 JorisBenschop]: |
| 2 | | > I cant imagine this is not a known issue, but I havent been able to find it. Please show me the duplicate if there is one. |
| 3 | | EDIT: https://docs.djangoproject.com/en/dev/ref/databases/#naming-issues |
| 4 | | > |
| 5 | | > If I create a model (django dev, oracle 11.2 backend), the sql statement is distorted if the db_table is over 31 characters. Almost like a buffer overflow: |
| 6 | | > |
| 7 | | > GOOD: |
| 8 | | > |
| 9 | | > _meta.db_table='variant_owr\".\"biomaterial_type' |
| 10 | | > {{{ |
| 11 | | > DEBUG (0.003) QUERY = u'SELECT COUNT(:arg0) AS "__COUNT" FROM "VARIANT_OWR"."BIOMATERIAL_TYPE"' - PARAMS = (u'*',); args=('*',) |
| 12 | | > }}} |
| 13 | | > BAD: |
| 14 | | > |
| 15 | | > _meta.db_table='variant_ownr\".\"biomaterial_type' |
| 16 | | > {{{ |
| 17 | | > DEBUG (0.002) QUERY = u'SELECT COUNT(:arg0) AS "__COUNT" FROM "VARIANT_OWNR"."BIOMATERIAL92C0"' - PARAMS = (u'*',); args=('*',) |
| 18 | | > }}} |
| 19 | | > _meta.db_table = 'ababababababxxxabababababababab' |
| 20 | | > {{{ |
| 21 | | > DEBUG (0.004) QUERY = u'SELECT COUNT(:arg0) AS "__COUNT" FROM "ABABABABABABXXXABABABABABACAD7"' - PARAMS = (u'*',); args=('*',) |
| 22 | | > }}} |
| 23 | | > |
| | 1 | no comment. user error |