Changes between Version 2 and Version 3 of Testing and Validation
- Timestamp:
- 05/12/26 02:16:40 (2 weeks ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
Testing and Validation
v2 v3 11 11 === SQL Code === 12 12 13 <syntaxhighlight lang="sql"> 13 {{{ 14 #!sql 14 15 INSERT INTO venue_booking( 15 16 "date", … … 30 31 1 31 32 ); 32 </syntaxhighlight> 33 }}} 33 34 34 35 === Expected Result === … … 40 41 === SQL Code === 41 42 42 <syntaxhighlight lang="sql"> 43 {{{ 44 #!sql 43 45 INSERT INTO attendance( 44 46 status, … … 55 57 1 56 58 ); 57 </syntaxhighlight> 59 }}} 58 60 59 61 === Expected Result === … … 65 67 === SQL Code === 66 68 67 <syntaxhighlight lang="sql"> 69 {{{ 70 #!sql 68 71 SELECT is_venue_available( 69 72 1, … … 72 75 '22:00' 73 76 ); 74 </syntaxhighlight> 77 }}} 75 78 76 79 === Expected Result === … … 82 85 === SQL Code === 83 86 84 <syntaxhighlight lang="sql"> 87 {{{ 88 #!sql 85 89 SELECT is_photographer_available( 86 90 1, … … 89 93 '22:00' 90 94 ); 91 </syntaxhighlight> 95 }}} 92 96 93 97 === Expected Result === … … 99 103 === SQL Code === 100 104 101 <syntaxhighlight lang="sql"> 105 {{{ 106 #!sql 102 107 SELECT * 103 108 FROM vw_wedding_financial_summary; 104 </syntaxhighlight> 109 }}} 105 110 106 111 === Expected Result === … … 112 117 === SQL Code === 113 118 114 <syntaxhighlight lang="sql"> 119 {{{ 120 #!sql 115 121 SELECT * 116 122 FROM vw_rsvp_overview; 117 </syntaxhighlight> 123 }}} 118 124 119 125 === Expected Result === … … 125 131 === SQL Code === 126 132 127 <syntaxhighlight lang="sql"> 133 {{{ 134 #!sql 128 135 INSERT INTO event_rsvp( 129 136 guest_id, … … 136 143 'invalid_status' 137 144 ); 138 </syntaxhighlight> 145 }}} 139 146 140 147 === Expected Result ===
