Re: MySQL error subquery returns more than 1 row

On Tue, Nov 17, 2009 at 9:03 AM, Ilya Polosuhin wrote: > I don't fully understood your question. Of course I have more than one row > at test_mymodel2 > SQL query was formed by django-ORM. I just call > print (MyModel.objects.filter(key_to_mymodel2 = >

Re: MySQL error subquery returns more than 1 row

I don't fully understood your question. Of course I have more than one row at test_mymodel2 SQL query was formed by django-ORM. I just call print (MyModel.objects.filter(key_to_mymodel2 = MyModel2.objects.all()))._as_sql()) and write here output. And I also googled for this MySQL error and found

Re: MySQL error subquery returns more than 1 row

On Tue, Nov 17, 2009 at 7:17 AM, Ilya wrote: > I just developed some code like: > MyModel.objects.filter(key_to_mymodel2 = MyModel2.objects.all())) > This query produce SQL: > SELECT * FROM `test_mymodel` WHERE key_to_mymodel2_id =(select `id` > from `test_mymodel2`) >

Re: MySQL error subquery returns more than 1 row

M, thanks. But should I create ticket on django trac about this issue? On 17 ноя, 17:29, Tom Evans wrote: > On Tue, Nov 17, 2009 at 3:17 PM, Ilya wrote: > > I just developed some code like: > >  MyModel.objects.filter(key_to_mymodel2 =

Re: MySQL error subquery returns more than 1 row

On Tue, Nov 17, 2009 at 3:17 PM, Ilya wrote: > I just developed some code like: > MyModel.objects.filter(key_to_mymodel2 = MyModel2.objects.all())) > This query produce SQL: > SELECT * FROM `test_mymodel` WHERE key_to_mymodel2_id =(select `id` > from `test_mymodel2`) >

MySQL error subquery returns more than 1 row

I just developed some code like: MyModel.objects.filter(key_to_mymodel2 = MyModel2.objects.all())) This query produce SQL: SELECT * FROM `test_mymodel` WHERE key_to_mymodel2_id =(select `id` from `test_mymodel2`) It works fine on SQLLite, but in MySQL it produce error: OperationalError: (1242,