diff options
| author | Igor Babaev <igor@askmonty.org> | 2016-09-06 10:05:36 -0700 |
|---|---|---|
| committer | Igor Babaev <igor@askmonty.org> | 2016-09-06 10:05:36 -0700 |
| commit | 2d36e5aa38b6943d194e1696761cf357e7d09cca (patch) | |
| tree | 2832787d1bb26a057be47bb89aed9589844cb66b /mysql-test/r/cte_recursive.result | |
| parent | 225440047d145bbe6a92bff05c5d4aa33e0aca91 (diff) | |
| download | mariadb-git-2d36e5aa38b6943d194e1696761cf357e7d09cca.tar.gz | |
Fixed bug mdev-10736 that caused crashes.
The bug manifested itself for recursive definitions that
used anchors over tables with blobs.
Diffstat (limited to 'mysql-test/r/cte_recursive.result')
| -rw-r--r-- | mysql-test/r/cte_recursive.result | 9 |
1 files changed, 9 insertions, 0 deletions
diff --git a/mysql-test/r/cte_recursive.result b/mysql-test/r/cte_recursive.result index da5f380c0e4..17a4274f1ca 100644 --- a/mysql-test/r/cte_recursive.result +++ b/mysql-test/r/cte_recursive.result @@ -1623,3 +1623,12 @@ n 3 4 5 +# +# MDEV-10736: recursive definition with anchor over a table with blob +# +CREATE TABLE t1 (f VARCHAR(1024)); +WITH RECURSIVE cte(f) AS +(SELECT t1.f FROM t1 UNION ALL SELECT cte.f FROM cte) +SELECT * FROM cte; +f +DROP TABLE t1; |