From 3f619478f796eddbba6e39502fe941b285dd97b1 Mon Sep 17 00:00:00 2001
From: Daniel Baumann <daniel.baumann@progress-linux.org>
Date: Sat, 4 May 2024 20:00:34 +0200
Subject: Adding upstream version 1:10.11.6.

Signed-off-by: Daniel Baumann <daniel.baumann@progress-linux.org>
---
 .../suite/engines/funcs/r/de_truncate.result       | 49 ++++++++++++++++++++++
 1 file changed, 49 insertions(+)
 create mode 100644 mysql-test/suite/engines/funcs/r/de_truncate.result

(limited to 'mysql-test/suite/engines/funcs/r/de_truncate.result')

diff --git a/mysql-test/suite/engines/funcs/r/de_truncate.result b/mysql-test/suite/engines/funcs/r/de_truncate.result
new file mode 100644
index 00000000..b4e2e077
--- /dev/null
+++ b/mysql-test/suite/engines/funcs/r/de_truncate.result
@@ -0,0 +1,49 @@
+DROP TABLE IF EXISTS t1;
+CREATE TABLE t1(c1 CHAR(10) NOT NULL);
+INSERT INTO t1 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
+TRUNCATE   t1 ;
+SELECT * FROM t1 ORDER BY c1;
+c1
+DROP TABLE t1;
+CREATE TABLE t1(c1 VARCHAR(10) NOT NULL);
+INSERT INTO t1 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
+TRUNCATE   t1 ;
+SELECT * FROM t1 ORDER BY c1;
+c1
+DROP TABLE t1;
+CREATE TABLE t1(c1 BINARY(10) NOT NULL);
+INSERT INTO t1 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
+TRUNCATE   t1 ;
+SELECT * FROM t1 ORDER BY c1;
+c1
+DROP TABLE t1;
+CREATE TABLE t1(c1 VARBINARY(10) NOT NULL);
+INSERT INTO t1 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
+TRUNCATE   t1 ;
+SELECT * FROM t1 ORDER BY c1;
+c1
+DROP TABLE t1;
+CREATE TABLE t1(c1 CHAR(10) NOT NULL);
+INSERT INTO t1 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
+TRUNCATE TABLE t1 ;
+SELECT * FROM t1 ORDER BY c1;
+c1
+DROP TABLE t1;
+CREATE TABLE t1(c1 VARCHAR(10) NOT NULL);
+INSERT INTO t1 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
+TRUNCATE TABLE t1 ;
+SELECT * FROM t1 ORDER BY c1;
+c1
+DROP TABLE t1;
+CREATE TABLE t1(c1 BINARY(10) NOT NULL);
+INSERT INTO t1 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
+TRUNCATE TABLE t1 ;
+SELECT * FROM t1 ORDER BY c1;
+c1
+DROP TABLE t1;
+CREATE TABLE t1(c1 VARBINARY(10) NOT NULL);
+INSERT INTO t1 (c1) VALUES('a'),('aaa'),('b'),('b'),('bb'),('bbb'),('c');
+TRUNCATE TABLE t1 ;
+SELECT * FROM t1 ORDER BY c1;
+c1
+DROP TABLE t1;
-- 
cgit v1.2.3