| Server IP : 185.86.78.101 / Your IP : 216.73.216.124 Web Server : Apache System : Linux 675867-vds-valikoshka1996.gmhost.pp.ua 5.4.0-150-generic #167-Ubuntu SMP Mon May 15 17:35:05 UTC 2023 x86_64 User : www ( 1000) PHP Version : 7.4.33 Disable Function : passthru,exec,system,putenv,chroot,chgrp,chown,shell_exec,popen,proc_open,pcntl_exec,ini_alter,ini_restore,dl,openlog,syslog,readlink,symlink,popepassthru,pcntl_alarm,pcntl_fork,pcntl_waitpid,pcntl_wait,pcntl_wifexited,pcntl_wifstopped,pcntl_wifsignaled,pcntl_wifcontinued,pcntl_wexitstatus,pcntl_wtermsig,pcntl_wstopsig,pcntl_signal,pcntl_signal_dispatch,pcntl_get_last_error,pcntl_strerror,pcntl_sigprocmask,pcntl_sigwaitinfo,pcntl_sigtimedwait,pcntl_exec,pcntl_getpriority,pcntl_setpriority,imap_open,apache_setenv MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : OFF | Sudo : ON | Pkexec : OFF Directory : /www/server/mysql/mysql-test/t/ |
Upload File : |
--echo # --echo # Bug#40277 SHOW CREATE VIEW returns invalid SQL --echo # Bug#41999 SHOW CREATE VIEW returns invalid SQL if subquery is used in SELECT list --echo # --echo # 65 characters exceed the maximum length of a column identifier. The system cannot derive the name from statement. --echo # Constant with length = 65 . Expect to get the identifier 'Name_exp_1'. let $after_select= '<--- 65 char including the arrows --->'; --source include/view_alias.inc --echo # Subquery with length = 65 . Expect to get the identifier 'Name_exp_1'. --echo # Attention: Identifier for the column within the subquery will be not generated. let $after_select= (SELECT '<--- 54 char including the arrows (+ 11 outside) -->'); --source include/view_alias.inc --echo # ----------------------------------------------------------------------------------------------------------------- # --echo # 64 characters are the maximum length of a column identifier. The system can derive the name from the statement. let $after_select= '<--- 64 char including the arrows --->'; --source include/view_alias.inc let $after_select= (SELECT '<--- 53 char including the arrows (+ 11 outside) --->'); --source include/view_alias.inc --echo # ----------------------------------------------------------------------------------------------------------------- # --echo # Identifiers must not have trailing spaces. The system cannot derive the name from a constant with trailing space. --echo # Generated identifiers have at their end the position within the select column list. --echo # 'c2 ' -> 'Name_exp_1' , ' c4 ' -> 'Name_exp_2' let $after_select= 'c1', 'c2 ', ' c3', ' c4 '; --source include/view_alias.inc --echo # --echo # Bug#40277 SHOW CREATE VIEW returns invalid SQL --echo # --disable_warnings DROP VIEW IF EXISTS v1; DROP TABLE IF EXISTS t1,t2; --enable_warnings --echo # Column name exceeds the maximum length. CREATE VIEW v1 AS SELECT '0000000000 1111111111 2222222222 3333333333 4444444444 5555555555'; let $query = `SELECT VIEW_DEFINITION FROM INFORMATION_SCHEMA.VIEWS WHERE TABLE_SCHEMA = 'test' AND TABLE_NAME = 'v1'`; DROP VIEW v1; eval CREATE VIEW v1 AS $query; DROP VIEW v1; --echo # Column names with leading trailing spaces. CREATE VIEW v1 AS SELECT 'c1', 'c2 ', ' c3', ' c4 '; let $query = `SELECT VIEW_DEFINITION FROM INFORMATION_SCHEMA.VIEWS WHERE TABLE_SCHEMA = 'test' AND TABLE_NAME = 'v1'`; DROP VIEW v1; eval CREATE VIEW v1 AS $query; DROP VIEW v1; --echo # Column name conflicts with a auto-generated one. CREATE VIEW v1 AS SELECT 'c1', 'c2 ', ' c3', ' c4 ', 'Name_exp_2'; let $query = `SELECT VIEW_DEFINITION FROM INFORMATION_SCHEMA.VIEWS WHERE TABLE_SCHEMA = 'test' AND TABLE_NAME = 'v1'`; DROP VIEW v1; eval CREATE VIEW v1 AS $query; DROP VIEW v1; --echo # Invalid conlumn name in subquery. CREATE VIEW v1 AS SELECT (SELECT ' c1 '); let $query = `SELECT VIEW_DEFINITION FROM INFORMATION_SCHEMA.VIEWS WHERE TABLE_SCHEMA = 'test' AND TABLE_NAME = 'v1'`; DROP VIEW v1; eval CREATE VIEW v1 AS $query; DROP VIEW v1; CREATE TABLE t1(a INT); CREATE TABLE t2 LIKE t1; --echo # Test alias in subquery CREATE VIEW v1 AS SELECT a FROM t1 WHERE EXISTS (SELECT 1 FROM t2 AS b WHERE b.a = 0); let $query = `SELECT VIEW_DEFINITION FROM INFORMATION_SCHEMA.VIEWS WHERE TABLE_SCHEMA = 'test' AND TABLE_NAME = 'v1'`; DROP VIEW v1; eval CREATE VIEW v1 AS $query; DROP VIEW v1; --echo # Test column alias in subquery CREATE VIEW v1 AS SELECT a FROM t1 WHERE EXISTS (SELECT a AS alias FROM t1 GROUP BY alias); SHOW CREATE VIEW v1; let $query = `SELECT VIEW_DEFINITION FROM INFORMATION_SCHEMA.VIEWS WHERE TABLE_SCHEMA = 'test' AND TABLE_NAME = 'v1'`; DROP VIEW v1; eval CREATE VIEW v1 AS $query; DROP VIEW v1; --echo # Alias as the expression column name. CREATE VIEW v1 AS SELECT a FROM t1 WHERE EXISTS (SELECT ' a ' AS alias FROM t1 GROUP BY alias); SHOW CREATE VIEW v1; let $query = `SELECT VIEW_DEFINITION FROM INFORMATION_SCHEMA.VIEWS WHERE TABLE_SCHEMA = 'test' AND TABLE_NAME = 'v1'`; DROP VIEW v1; eval CREATE VIEW v1 AS $query; DROP VIEW v1; DROP TABLE t1, t2;