Test subquery2.sql (id f56b8f83e70a) (err)
subquery2.stable.out.FILTERED 2019-09-11 21:01:06.861656521 +0200subquery2.test.out.FILTERED 2019-09-11 21:01:06.863656503 +0200
1 Statistics about stdout of test 'subquery2` in directory 'sql/test/subquery`: 1 1 Statistics about stdout of test 'subquery2` in directory 'sql/test/subquery`: 1
2 26 lines, 130 words, 582 chars in lines not matching '^$|^(\| |)#|^=` 2 ! 2 29 lines, 139 words, 597 chars in lines not matching '^$|^(\| |)#|^=` 2
3 = 26 lines, 130 words, 582 chars in lines not matching '^$|^(\| |)#` 3 ! 3 = 29 lines, 139 words, 597 chars in lines not matching '^$|^(\| |)#` 3
4 # 67 lines, 433 words, 2904 chars in all lines 4 ! 4 # 77 lines, 495 words, 3532 chars in all lines 4
5 5 5 5
..................
#drop table students;
67 #drop table exams; 67 67 #drop table exams; 67
68 68 ! 68 #CREATE TABLE tbl_ProductSales (ColID int, Product_Category varchar(64), Product_Name varchar(64), TotalSales int); 68
69 # 18:55:46 > 69 ! 69 #INSERT INTO tbl_ProductSales VALUES (1,'Game','Mobo Game',200),(2,'Game','PKO Game',400),(3,'Fashion','Shirt',500),(4,'Fashion','Shorts',100); 69
70 # 18:55:46 > "Done." 70 ! 70 [ 4 ] 70
71 # 18:55:46 > 71 ! 71 #CREATE TABLE another_T (col1 INT, col2 INT, col3 INT, col4 INT, col5 INT, col6 INT, col7 INT, col8 INT); 71
+ 72 #INSERT INTO another_T VALUES (1,2,3,4,5,6,7,8), (11,22,33,44,55,66,77,88), (111,222,333,444,555,666,777,888), (1111,2222,3333,4444,5555,6666,7777,8888); 72
+ 73 [ 4 ] 73
+ 74 #INSERT INTO tbl_ProductSales VALUES (0, 'a', 'b', 0); 74
+ 75 [ 1 ] 75
+ 76 #DROP TABLE tbl_ProductSales; 76
+ 77 #DROP TABLE another_T; 77
+ 78 78
+ 79 # 21:01:06 > 79
+ 80 # 21:01:06 > "Done." 80
+ 81 # 21:01:06 > 81
72 72 82 82