Details
Description
$ ./mtr main.delete --view
|
Logging: ./mtr main.delete --view
|
MariaDB Version 10.4.29-MariaDB-debug
|
==============================================================================
|
TEST RESULT TIME (ms) or COMMENT
|
--------------------------------------------------------------------------
|
main.delete [ fail ]
|
Test ended at 2023-02-17 09:40:49
|
|
CURRENT_TEST: main.delete
|
mysqltest: At line 607: query 'select * from t1
|
where $c' failed: 1356: View 'test.mysqltest_tmp_v' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them
|
|
The result from queries just before the failure was:
|
< snip >
|
#
|
# MDEV-30586: DELETE with WHERE containing nested subquery
|
# with set function aggregated in outer subquery
|
#
|
create table t1 (a int);
|
insert into t1 values (3), (7), (1);
|
create table t2 (b int);
|
insert into t2 values (2), (1), (4), (7);
|
create table t3 (a int, b int);
|
insert into t3 values (2,10), (7,30), (2,30), (1,10), (7,40);
|
select * from t1
|
where t1.a in (select t3.a from t3 group by t3.a
|
having t3.a > any (select t2.b from t2
|
where t2.b*10 < sum(t3.b)));
|
--------------------------------------------------------------------------
|
The servers were restarted 0 times
|
Spent 0.000 of 3 seconds executing testcases
|
|
Failure: Failed 1/1 tests, 0.00% were successful.
|
|
Failing test(s): main.delete
|
Attachments
Issue Links
- is caused by
-
MDEV-30586 DELETE with aggregation in subquery of WHERE returns bogus error
- Closed
- is duplicated by
-
MDEV-28570 Select from view fails if definition of view has 'HAVING' in query
- Closed
-
MDEV-28571 Select from view fails if definition of view has aggregate function ( like 'GROUP_CONCAT(COUNT(a))' ) in query
- Closed