Details
-
Bug
-
Status: Closed (View Workflow)
-
Minor
-
Resolution: Not a Bug
-
10.5, 10.6, 10.3(EOL), 10.4(EOL), 10.7(EOL), 10.8(EOL), 10.9(EOL)
Description
Test:
--replace_result $UDF_EXAMPLE_SO UDF_EXAMPLE_LIB
|
eval CREATE FUNCTION udf_sequence RETURNS INTEGER SONAME "$UDF_EXAMPLE_SO"; |
CREATE TABLE t1 (a INT); |
INSERT INTO t1 VALUES (4),(3),(2),(1); |
|
SELECT udf_sequence() AS seq FROM t1 ORDER BY seq ; |
CREATE VIEW v1 as SELECT udf_sequence() AS seq FROM t1 ORDER BY seq ; |
SELECT * FROM v1; |
DROP VIEW v1; |
|
DROP FUNCTION udf_sequence; |
DROP TABLE t1; |
Actual value:
seq
|
2
|
4
|
6
|
8
|
Expected value:
seq
|
1
|
2
|
3
|
4
|
Attachments
Issue Links
- is part of
-
MDEV-27691 make working view-protocol
- Open